Instrumental in migrating the Demand Planning System ETL and reporting BASE SAS programs to Data Integration Studio jobs. Design and develop a batch process to run system in a production environment. Also used SAS EG.

Tech Lead for the development effort in leveraging multiple data sources to transition Credit Card, Mortgage, Home Equity and Risk Control Framework systems into SAS EBI environment for the Enterprise Consumer Analytics and Reporting Solution (ECARS) program. Full Life Cycle duties within the Consumer Risk Group using SAS Data Integration Studio 4.2 , SAS Enterprise Guide, Base SAS, UNIX, ETL, LSF Scheduler. Converting quantitative analyst’s Base SAS code to SAS DATA INTEGRATION ETL jobs.

Tech Lead for the development effort in leveraging multiple data sources to transition Top of House Card and GWIM systems into SAS EBI environment for the Enterprise Consumer Analytics and Reporting Solution (ECARS) program. Full Life Cycle duties within the Consumer Risk Group using SAS Data Integration Studio 4.2 , SAS Enterprise Guide, SAS Information Studio, Web Report Studio, Base SAS, UNIX, ETL, LSF Scheduler. Working closely with LOB subject matter experts and technical business analysts in integrating data into end-to-end SAS data mart solution for risk analytics and reporting. Creating Low Level Documents (tech spec). Using TortoiseSVN interface to Subversion for source control. Light SAS Admin duties (promoting code from DEV to SIT, creating folders, registering tables in SPDS).

Expertise in extracting and aggregating mutil million rows of data from DB2, Oracle and Teradata data bases and creating Metadata for DI jobs.

Member of Risk Data Management Platform group working on the development effort in automating the Federal Reserve Board 14M Regulatory project, which consists of multiple sources feeding into custom jumbo mortgages. Also working on the Data Sourcing and Home Loans projects doing source to target analysis in the conversion from SAS and DI Studio to Neteeza and Informatica. In charge of migrating metadata from current User Work Space to future target environment. These projects use the Agile Methodology.

Reviews, analyzes, and modifies programming systems including coding, testing, and debugging. Lead Developer for the Management Reporting system. Maintained and developed batch application programs using Mainframe SAS, SAS/ACCESS, COBOL, DB2 and IMS. Developed specifications, diagrams and flowcharts.

Full life cycle development; including requirements analysis, design, programming, data transfer from old system, testing, implementation, and application enhancements.
Major Account Reporting System: New development using COBOL, Mainframe SAS, SAS/ACCESS, DB2 and Easytrieve Plus working on financial reporting systems . Creating extracts and reports from financial data in large Data Warehouse for clients of BCBST in the areas of Medical Claims, Member databases, Prescription Drugs and Case Management. Eligibility, Provider, Pharmacy Claims, Dental Claims.

Additional duties include compiling extensive test scripts for QA.

Report Migration Project – Lead Developer: Converted user reports to IS standards reports using PC SAS, Mainframe SAS, COBOL, Easytrieve Plus across multiple platforms. Created front-end for system to capture user parameters using Visual Basic 6.0. Verifies program logic by preparing test data and conducting unit tests. - Participants in the systems testing and user acceptance testing. Converted many COBOL reports to Adobe Acrobat PDF’s using SAS ODS.

Environment: MVS, IBM Mainframe, COBOL, DB2, SQL, SAS, QMF, Easytrieve Plus, Visual Basic.

Financial Data Mart: Converting Legacy reports from retrieving data from Data Warehouse to retrieving data from new Financial data mart using Easytrieve Plus, COBOL, DB2.

Cash Financial Data Mart: Designed program specs for Extract and Transform programs. Analysis of old system reports for conversion to new system. Easytrieve Plus, COBOL, DB2.