Mitch Rosenberg



Resume of:Mitch Rosenberg2044 Woodside Ln, Broomall, PA 19008(610) 909-6268<mitch@> Education:- Wharton School of the University of Pennsylvania, Philadelphia, PA Bachelor of Business Administration in Accounting (5/86)- Maxwell Institute, Norristown, PA - Certificate in Computer Programming (8/80)Experience Summary:Engaged in analysis, design and programming since 1980. Excellent communications and organizational skills. Highly skilled in data development, data architecture and code archaeology, systems analysis, systems design, UI design, database, data mart, data warehouse and Internet systems. Roles have included Database Architect, Application System Architect, Data Engineer, System Designer, Project Leader, SQL Developer, Data Engineer, Programmer/Analyst, Systems Analyst and Programmer. Experienced in designing and building batch, online and Internet-based systems with a proven track record of quickly becoming familiar with the problem at hand and able to accomplish tasks in a variety of environments. Data Mart/Data Warehouse design/development & ETL (>20 years), Corporate programming experience with PC (>24 years), Mainframe (16 years), Internet [e-Commerce and Search Engine Marketing] (10 years), Systems Conversions (18 years) and Corporate Mergers (10 years), SQL Server Development/Architecture/Optimization (>20 years).Applications experience includes Health Care Insurance, Professional Services Organization, Fund Management, Pharma, Online Software Distribution, e-Commerce, Marketing Systems, Sales/Order Entry Systems, Banking, Manufacturing, Project Accounting, Trust Accounting, Inventory, Publishing (Yellow Pages) and Online systems.Employment History:5/03 – Present:, Inc., Broomall, PAPosition:Independent ConsultantResponsibilities:Owner, Developer, Data Architect, Data Archaeologist, Product development1/95 – 5/03:, Inc., Bala Cynwyd, PAPosition:CEO, System Architect, Business DevelopmentResponsibilities:Founder, Manager, Systems Architect, System Designer, Programmer8/86 – 1/95:Modular Technology, Inc., Bala Cynwyd, PAPosition:Independent Computer Consultant Responsibilities:Owner, Programmer, Systems Analyst, Project Leader3/82 – 8/86:The Reohr Group, Swathmore, PAManager:John LouchheimPosition:Staff consultant (Programmer)1/80 – 2/82:Safeguard Business Systems, Plymouth Meeting, PAManager:Aaron AmarnekPosition:ProgrammerSelected contract clients: Guardian Life, Cotiviti, Comcast, PMI, Endo Pharmaceutical, Yellow Pages Group, Macquarie, Delaware Investments, SunGard Availability Services, Independence Blue Cross, SmithKline Beecham, McNeil Consumer [J&J], IMS America, DuPont, Conoco, Armco Steel, Fidelity Bank, SEI Corporation, FiServ-Users, Campbell Soup, Rorer Pharmaceutical.Skills Summary:Database:SkillEnvironment(s)YearsLast UsedAbilitySQLDB/2, SQL Server, Sybase, MySQL342023ExpertDB/2MVS, CICS, OS/2 (Light DBA skills)112023StrongSQL Server/ T-SQLDevelopment DBA skills, Data Mart, Data Warehouse, Performance Tuning, DTS, SSIS, SSRS, Procs232023ExpertSybaseT-SQL, Development DBA, Performance Tuning12011StrongVSAMMVS121997AverageIMS – DL/1MVS51992AverageTeradata22019StrongOracle PLSQL22019AverageProgramming Languages:SkillEnvironment(s)YearsLast UsedAbilityBasicVB, PowerBasic, VMS Basic202005ExpertCOBOLBoth COBOL and COBOL II142004AverageCICS (Command)MVS101994BasicVB 6Windows Windows12005BasicPL/1MVS, VMS42012StrongScripting Languages:SkillEnvironment(s)YearsLast UsedAbilityPowerShellWindows42023StrongVBScriptASP/HTA/DTS/Stand-alone142013ExpertVBAExcel, Access, Word202023StrongASPWindows (IIS)122011ExpertJavaScriptASP, PHP102007AverageREXXOS/2, VM, TSO, Windows192016ExpertISPF/CLISTTSO82007StrongJCLMVS122012StrongInternet:SkillEnvironment(s)YearsLast UsedAbilityASPWindows 142011ExpertHTML/DHTMLIIS, WebSphere, Goserve, Apache162011ExpertHTTPIIS, WebSphere, Goserve, Apache102005ExpertXMLWebSphere, Goserve, SQL Server52015AverageJavaScriptIIS, WebSphere, Goserve, Apache102007AverageTCP/IPOS/2 Rexx, VB 6, VbScript82004StrongOperating Systems:SkillEnvironment(s)YearsLast UsedAbilityWindows262023StrongOS/2Warp 3, Warp 4122006StrongMVS & z/OS152012StrongTSO152012StrongExperience:04/23 – Guardian Life New York City, NYConverted database objects (stored procs, functions, views and triggers) from DB2 UDB to SQL Server 2016 to support the migration of app from on-prem to AWS.Extensive SQL Code enhancement and optimization for views and stored procs.Developed PowerShell administrative tools for managing database code promotion.Added DDL update tracking to dev database via database trigger.Documented processes for production support purposes.Skills: SQL Server T-SQL, PowerShellRoles: Data Engineer, SQL Developer05/19 – 1/23CotivitiBlue Bell, PASupport and Enhancements for the back-end batch processes for 51 health insurance clients across 30 production SQL Server VM’s (3200+ Databases; 250,000+ StoredProcs). Support and minor Enhancements for front-end (Access VBA) apps and L2 support for data load issues.Extensive SQL Code optimization for views, stored procs and triggers.Research/Analysis support for back-end SQL processes to help operations understand what the process is doing and to help them determine what changes need to be made to support the business.Migrated 850+ Windows Task Scheduler jobs (PowerShell with built-in Process Logging) from Win2008 to Win2016 and PowerShell from version 4 to 5. Set up a Dashboard for current status of batch processes by client.Developed PowerShell parsing processes to extract process metadata to make it easier for the support team to keyword search stored procedures, PowerShell scripts, .vba, .wsf, Syncovery profiles and SSIS packages.Supported batch claim re-pricing based on Optum WebStrat across 36 health insurance clientsDocumented processes for production support purposes including frequent problem resolution steps.Supported sFTP and file movement processes (via PowerShell/Syncovery)Skills: SQL Server T-SQL, PowerShell, Windows Task Scheduler, Control-M, Syncovery, Access VBARoles: Data Engineer, SQL Developer, L2 Production Support, Data BA, Data Architect2/17 – 9/19Comcast - EBIPhiladelphia, PAData Warehouse data reconciliation for semantic (star schema) layerUAT of data ingests and relational layer blending ETL targetsDeveloped data lineages for all biller-related relational layer tables from 5 existing sourcesBuilt E-R diagrams to map out both source and target for new biller source systemsDeveloped data mapping for new biller source systems (2)Planned out a best-practice based UAT architecture for new source systemsDeveloped data flow documents to help data modelers understand new source systemReconciled reporting requirements for Subscriber reporting across 15 regions and corporateSkills: Teradata SQL, Oracle SQL, SQL Server T-SQL, HUE SQL, Ambari, Visio, Excel VBARoles: Data Architecture, SQL Developer, Data Quality analyst, Data BA9/16 – 2/17Altai SystemsTallahassee, FLDesign/build DataMart from CRM Online database and map to legacy database.Built SSIS ETL processes from CRM Online to replace legacy processes.Built various CRM views, charts and dashboards.Data mapping from Legacy systems to new CRM database.Skills: T-SQL(SQL Server), SSIS, Kingsway, T-SQL Stored Procedures, SQL Server 2014Roles: SQL Developer1/13 – 9/16Project Management InstituteNewtown Square, PAAnalysis and development of data migration from legacy systems and Great Plains into Microsoft Dynamics CRM for the migration of 2/3 TB of legacy data.Design and development of synchronization processes between remaining legacy databases and Microsoft Dynamics CRM.Migration of SSRS 2005 & 2008 legacy reports to SSRS 2008 R2 server along with implementing SDLC and source control.Analysis, mapping, flowcharting and documentation of existing DataWarehouse, legacy systems and Month End processing in preparation for systems conversionMapping of entire data architecture from SQL Servers thru databases to applications.Implemented SDLC and source control across all main production databases.Developed a self-maintaining Data Dictionary app which maintains column notes across schema changes.Skills: T-SQL(SQL Server), SSIS, CozyRoc, T-SQL Stored Procedures, SSRS, Performance Tuning, Index Tuning, SQL Server 2000/2005/2008/2012/2014, Visio, PowerShellRoles: SQL Developer, Data Architect, Development DBA, Team Lead, Data Archaeologist 5/12 – 12/12Endo PharmaceuticalChadds Ford, PADeveloped a dependent DataMart from the corporate Netezza DataWarehouse to support internal QC needs of the SalesOps department.Developed SSIS processes and stored procedures in support of QC of the customer ETL/Data Cleansing/Data Refinement process matching AMS and IMS customer data to internal source systems.Developed a rules-based, multi-level Customer Matching engine (T-SQL store procedure) to support the integration of multiple departmental customer masters and for AdHoc reporting.Developed a process (SSIS/Stored Procedures) for data enhancement of State License number from MedPro data.Developed an enhanced version of the Jaro-Winkler string distance matching function to support address matching that significantly lowered false-positives while significantly raising the number of real matches.SSRS Performance tuning.Skills: T-SQL(SQL Server/Netezza), SSIS, T-SQL Stored Procedures, SSRS, Performance Tuning, Index Tuning, SQL Server 2005/2008, VisioRoles: SQL Developer, Data Architect, Database modeler/Developer, Development DBA11/11 – 2/12YPG (Volt Information Sciences)Blue Bell, PADeveloped the final ETL, data cleansing, data selection and output processing for a Yellow Pages publishing system. Syndication was by Polygon, NPA/NXX and postal code.Developed DB2 stored procedure in PL/1 to support the address-handling / GeoCoding of listings data and enhance the addresses by enriching them using distribution data. Achieved an 86% GeoCoding/Polygon association rate with Canadian data (AB/BC/ON).Wrote a VBA macro to support the network group in reorganizing 2 TB of shared storage.Taught the staff how to use DB2 Temporary tables and Common Table expressions.Wrote SQL reports to show efficacy of GeoCoding, Address enhancement & Polygon association.Skills: SQL (DB2), PL/1, Stored Procedures, z/OS batch programming & JCL, Excel VBARoles: SQL Developer, PL/1 Programmer, Database modeler/Developer, App Developer12/10 – 10/11Delaware InvestmentsPhiladelphia, PADesigned/developed a data dictionary and data warehouse to support the funds management business covering 20K+ columns across 175 tables. The first phase was to develop 74 denormalized views to cover the data requirements of 80% of current reporting. Analysis, data archeology and heavy tuning was required to achieve sub-second response times across 45 separate application databases. Developed an analysis database and tools to map data usage from application source and integrate this information in a search engine along with parsed SQL source (views/procedures/functions) as well as source-code embedded SQL. These tools enabled us to target the development effort and research data relationships across 45 separate databases.Phase two included integrating the data dictionary with a flex-grid UI and the development of an additional 30 denormalized views which will eventually become the basis for a separate data mart to support the reporting needs of the organization.Skills: T-SQL (Sybase), SQL Server 2008, Sybase 15.0, ASP, VisioRoles: Data Warehouse Architect, SQL Developer, Database modeler, Data Archaeologist03/10 – 12/10 Macquarie Funds GroupPhiladelphia, PADesigned/developed a systems/application inventory in support of the separation of Delaware Investments from Lincoln Financial. The application was used to organize the separation and merger activities across 750 servers and 500 applications. Developed the data model, converted from a VBA Excel-based app to SQL Server database with an front end. Mapped relationships between Applications/Database/File Feeds/Servers/Storage Systems/Generic Account/Users (Logins and security) and Contracts.Developed a group of SSRS reports to replace an old CICS system to complete the separation of Delaware from Lincoln. Also developed a series of dashboards to report on and manage the B2B new batch ETL infrastructure.Skills: T-SQL, SQL Server 2008, Sybase 15.0, SSRS, ASP, Excel VBA, VisioRoles: SQL Developer, Database modeler, ETL Developer, Data Archaeologist10/09 – 6/15LighthouseIBHaverford, PADesigned/developed institutional funds database for a boutique investment bank to enable the creation of tiered call lists of funds qualified by deal and fund investment parameters. Developed web-bot to data-mine, load, cleanse and blend data (ETL) into the institutional funds database.Developed HTA-based search engine to enable fund research and selection by deal parameters and fund investment type/criteria. One of the interesting features of the app is that it interfaced with an Excel spreadsheet that the investment bankers use to load and update data from the funds database for their use.Developed complex data cleansing and blending SQL queries to hone the mined data into an operational tool for developing deal call lists.Pulled successful call lists for deals totaling $ 450 MM in transactional value.Built a system to extract new fund information (and AUM) from the EDGAR Form D filings.Skills: T-SQL, SQL Server 2005, HTA, VBScript, ASP, DHTML, XML, Excel VBA, VisioRoles: SQL Developer, Business Analyst, Database modeler/Developer, ETL Developer1/08 – 7/09SunGard Availability ServicesValley Forge, PADesigned/developed prospecting data mart, including ETL, standard reporting (ASP/HTA/ftp & eMail) and yearly load process for five (5) yearly data sources plus daily telemarketing response updates. Included eMail error notification using xp_SendMail to increase the reliability of the process.Data Warehouse re-design and subsequent ETL from Data Warehouse to Marketing Data Mart.Developed a self-service extract and reporting app for prospecting data mart. Maintenance/development of an independent marketing data mart including ETL, blending and cleansing from source systems (Oracle Sales Online + homegrown systems).Documented/rationalized myriad collected databases and applications that had been only intermittently managed across the previous five years cutting their number by 40% while increasing end-user customer satisfaction with the resulting output.Developed a Virtual Landing system that allows for the redirection/logging of campaign-based landing page traffic by source media and region (DMA). Included database infrastructure, specification of ASPX redirector (hooked off the IIS 404 message) and full interactive reporting. Integrated of IfByPhone toll-free call tracking and Google AdWords into campaign-based traffic logging/reporting. Also developed various HTA-based tools for the ETL, database process reporting and web developer utilities. Various ad-hoc reporting on marketing data to serve the information needs of the marketing department.SQL Query performance tuning for existing reporting queries; on average was able to lower the runtime by 90% or more.Campaign support for numerous marketing campaigns, including integration into the corporate intranet (Oracle), various ASP apps including apps for salesreps allowing access to campaign facilities such as direct mail for their prospects and existing customers.Skills: T-SQL, SQL Server 2000/2005, DTS, HTA, VBScript, ASP, CSS, DHTML, VisioRoles: SQL Developer, DataMart Designer/Developer, Database modeler, ETL Developer, Systems Analyst4/07 –12/07Independence Blue Cross Valley Forge, PADeveloped a Medicare Part D Rx Pricing Model with actuarial to project the pricing Medicare Rx benefits and create bid-sheets for CMS. Developed ETL/Blending/Data Manipulations process to handle the processing of multiple scenario’s across a 1TB database in close-to-realtime. Required heavy SQL development and performance tuning of stored procedures. Interfaced the output of the actuarial model to complex Excel spreadsheets for presentation.Developed dashboard application for scheduling and concurrent launch of model projections and review/reporting of the results.Skills: T-SQL, SQL Server 2000/2005, ASP, DHTML, Excel VBARoles: SQL Developer, ETL Developer, Systems Analyst, Database Modeler1/06 –4/07Independence Blue Cross Valley Forge, PAMaintained/developed data mart ETL for a 4 Tb data mart/warehouse in DTS and T-SQL. Designed/implemented departmental operating procedures (Change Control, Development standards, etc.). Worked as part of the Data Warehouse data modeling group to design new subject areasVarious systems analysis tasks including NPI, PBM in-sourcing, and Lab results (HIPAA X12N 837). Developed a Q/A system to monitor data quality in the data mart.Query, stored procedure and DTS batch process performance tuningHeavy development of stored procedures and DTS. As project lead managed 10 developers and QA/Production Control analysts. Developed a security audit system to audit access to sensitive data in database and the underlying raw data on disk with both Intra-net and e-Mail reporting. Developed various HTA-based tools for the ETL developers including a copybook converter, database comparison utility and file viewer w/ copybook support. Organized project planning for Outbound Data feeds department.Skills: T-SQL, SQL Server 2000, DTS, HTA, VBScript, ASP, DHTML, DataStage (light), VisioRoles: SQL Developer, ETL Developer, Systems Analyst, Project Lead, Database Modler4/07 – 7/07 DataVantage DB2products/mf/dv-db2.html Additional follow-on product development/maintenance work including enhancement of database copy functionality, development of test databases and user interface design for copy facility.Skill(s): z/OS, TSO, ISPF Panels, DB2, REXX, JCLRole(s): Programmer/Analyst3/05– 12/05Accellent Collegeville, PADesigned/implemented departmental operating procedures (Change Control, Move to Production, Application Development, etc.). Maintained/developed manufacturing, shop floor, dispatch, labor reporting, QA and Sales Quote applications. Developed SQL Server analysis tools to search SQL objects and DTS procedures. Heavy stored procedures and DTS including heavy performance tuning (both query and database design). Converted Access-based and VB6 based applications to the IIS/ASP platform. Various bug fixes and enhancements to VB6/embedded Crystal Reports (versions 5, 6 & 8.5) and ASP-based systems. Database modeling to support new initiatives. Development / Enhancement of stored procedures, DTS packages and SQL Server agent jobs.Skills: ASP, VBScript, VB6, Crystal Reports, Access, T-SQL, SQL Server 2000, HTML, CSS, XHTML, DHTML, DOM, VSSRoles: Systems Analyst, Programmer/Analyst, SQL Developer11/04– 02/05 FiServ/Users King of Prussia, PAConverted e-Support site to CSS Stylesheets and upgraded look and feel to match corporate site. Also added attachments to a web e-Mail form and upgraded code to process these in a Access module pulling by pulling the e-Mail from Outlook, storing the attachment and updatingSQL Server tables to associate the attachment with a work order.Skills: ASP, , VBScript, VBA, Access, Outlook, T-SQL, SQL Server 2000, HTML, JavaScript, CSS, XHTML, DHTML, VSSRoles: Systems Analyst, SQL Developer5/04 – 01/05 DataVantage DB2products/mf/dv-db2.html Product development/maintenance including updated panels/scripts to interactively execute SQL queries, a Selection Recap function for edit/browse/copy selections, DCLGEN processing and new programs to create/edit DB2 View and Index objects. Wrote the Find/Change functionality subroutine for the online table editor. Upgraded and enhanced the system to function under DB2 Releases 7 and 8. Performance tuning of queries and stored procedures.Skill(s): MVS, TSO, ISPF Panels, DB2, REXX, CLIST, Cobol, JCLRole(s): Programmer/AnalystEarlier project experience (1980 thru 2004) information available upon request. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download