SUMMARY Highly motivated Information Systems Professional with 20+ years of IT experience in insurance, retail, financial, utility, telecommunication and wholesale drug distribution industries including 6+ years working with Business Intelligence concepts like Data Reporting, Data Analysis, Data Cleansing, Design, Development, Testing and Implementation of Data Warehousing, Client-Server, and Legacy applications. Expert level in Relational Database Management Systems. Detail oriented with strong communication and leadership skills. Excellent analytical and problem solving skills.

Operating Systems: UNIX/AIX, Windows NT/XP, IBM Mainframe (MVS/ESA, OS/390, zOS)
Databases: Oracle, DB2 UDB, MS SQL server, ADABAS/ADASQL.
Languages: SQL, PL/SQL, COBOL, CICS, Shell Scripting, JCL, VSAM, Eazytrieve Plus, Visual Basic 6.0, JAVA Script, ASP, HTML, XML.
Methodologies: Software Development Life Cycle (SDLC), Data Warehouse Design, Logical and Physical Database Design, Dimensional Modeling, Star/Snowflake schema, ETL, SQL Tuning.
Development tools: SAP/BW v.7, Informatica PowerCenter 8.6/7.1/ 6.2, Informatica PowerExchange 8.6.1, Erwin, AQT, QMF, SPUFI, MQ Series, BMC, FILE-AID, INSYNC, IBM Utilities, Syncsort, FTP, EDI, Microsoft Office, Test Director/HPQC, PVCS, MQ Series, JCL, JES2, TSO/ISPF, VSAM, IDCAMS, CEDF, ABEND-AID, FILE-AID, XPEDITER, INTERTEST, ENDEVOR, LIBRARIAN, PANVALET, IBM Utilities, Micro Focus, TELON, VIASOFT, XDB, Tivoli Workflow Scheduler (TWS), CVS.
PM Tools: MS Project, Rational Portfolio Manager(RPM), Clarity Portfolio Management.

EXPERIENCE

07/2005-09/2010 Confidential, Chesterbrook, PA
Datawarehouse/ETL Lead Developer/SAP BW Developer

07/2007-09/2010 Responsible for all aspects of Data Integration / Data Warehousing development as well as Project Management within Corporate IT providing data services to external and internal customers.

• Under general direction of the Business Intelligence Lead, designed and developed SAP Business Warehouse (BW) applications for enterprise wide reporting. Gathered business requirements and conducted Gap Analysis to install Business Content. Designed and developed custom DataSource, InfoSource, InfoCube and DSO to fulfill user requirements.
• In support of Business Transformation project within corporate IT moving towards ERP solution, designed and developed ETL processes to unload desperate corporate system data into testing environment for the purpose of Data Quality analysis. Utilized Informatica Power Center and PowerExchange to access SAP, DB2 (UDB on AIX and on Z/OS), IDMS, VSAM data. Created complex ETL solutions based on analyst's requirement. Applied filters and functions to ABAP code. Assisted with installation of Informatica DataExplorer, and PowerExchange tools, set up and supported Data Quality Assessment Environment.
• Project manager for Informatica upgrade from Version 7.2.4 to version 8.1.1 and to 8.6.1. Developed and maintained project plan, coordinated and verify software testing. Worked with Informatica support to resolve the issues.
• Under general direction of the Data Analytics Group Manager, provided leadership for developing and managing a Center of Excellence (COE) for Extract Translate and Load (ETL) services within the Corporate IT department. Organized and conducted periodic peer review and maintained group SharePoint site.
• Provided leadership, vision and project management for Bellco Data Integration analytical solution. Translated business requirements into technical design documentation. Developed project plan and estimates. Performed resources management. Coordinated design, development and implementation efforts. Reviewed the work. Conducted weekly status meetings.
• Provide coaching, mentoring, and overall leadership to junior developers.
• Participated in technical interviews and trained new developers.

07/2005-05/2007 Responsible for all aspects of Data Warehouse development including sources identification, data analysis, ETL design, coding, testing and deployment.

• Collaborated with other BI team members, modelers, Database Administrators and members of the user community, in analyzing and integrating data from disparate applications.
• Assisted in the dimensional database design (Star/Snowflake schema). Reviewed multiple data source systems and recommended data acquisition and transformation strategy.
• Effectively translated business requirements into data transformation design documentation.
• Worked with Data Architects on enhancing logical and physical data model for CDW.
• Reviewed multiple data source systems, performed data analysis using Informatica Data Profiler and recommended data acquisition and transformation strategy.
• Developed an ETL strategy to integrate disparate legacy sources to eliminate redundancy and create a single view of the Customer data for accurate business analysis.
• Using Informatica Power Center 7.1.2 created mappings, sessions and workflows to load data from multiple Source databases (SQL Server, DB2) and flat files into target Oracle Database. Implemented advanced transformations to optimize mappings. Developed reusable transformations and mapplets. Ran complex SQL queries to verify data loads.
• Oversee, guide and mentor other team members in the best practices of designing, developing and testing complex data mappings and transformations.
• Utilized Informatica Scheduler to schedule workflow batches.
• Performed migration of objects from Development to QA and Production.
• Developed UNIX shell scripts as part of the ETL process, to perform data quality check, automate the process of loading, pulling and pushing data from/to servers.
• Conducted Data Analysis, Unit and System testing. Worked with QA team on testing issues resolution.
• Created and documented Test plans using Test Director.
• Provided system support, including Unit/Integration/QA testing, problem resolution, enhancements and maintenance.

Environment: SAP BW, INFA 7.1 & 8.6, Informatica Data Explorer (IDE) 8.6, INFA Power Exchange 8.6, Oracle 10g, DB2 UDB v8, Microstratergy, UNIX AIX 5.x, Shell Scripting, Erwin, CVS, MS Project, Rational Portfolio Manager (RPM), Clarity Project Management tool.

12/2000-07/2005 Confidential, Cigna Group Insurance, Philadelphia, PA
01/03-07/05 Datawarehouse/ETL Developer
Responsible for building a divisional Data Mart housed on DB2 UDB in UNIX environment with the Staging areas in MS SQL Server on Windows XP. Used Informatica tool to extract heterogeneous data, automate the transformation and support end-to-end process of loading data from an ODS to a dimensionally modeled target database.

• Assisted in the dimensional database design (Star schema). Reviewed multiple data source systems and recommended data acquisition and transformation strategy.
• Installed and configured Informatica environment. Using Informatica PowerCenter created detailed mappings to load data from multiple Source databases (SQL server, DB2) and flat files to target DB2/UDB Database. Implemented Aggregator, Joiner, Sorter, Router, Lookup, Update Strategy and Stored procedure transformations to optimize mappings.
• Worked directly with Business analysts and the end-users to translate their information requirements into effective data design and ETL solutions. Created system documentation.
• Created and monitored Sessions and Batch jobs to execute the mappings. Provided 24/7 production support, resolved production issues.
• Analyzed and recommended solutions within an Enterprise Data Warehousing environment.
• Analyzed, designed, developed, deployed, and maintained the Multidimensional OLAP Cubes, drill-through targets for the Cubes, Impromptu Web Reports, PowerPlay Portable Reports and ReportNet Reports.

Environment: Informatica 6.2, SQL Server 2000, DB2 UDB v.7 & 8, UNIX AIX 5.x, Shell
Scripting, Tivoli Workflow Scheduler (TWS), Cognos Impromptu 7.0, Cognos PowerPlay 7.0,
Cognos ReportNet 1.1, Erwin 3.5

Developer, Programmer/Analyst
03/02-05/05 Responsible for 24/7 Production Support of Disability Claims Management Systems. Claim System based on the FileNet Acenza package customized for the company needs.

• Performed analysis, modifications and unit/system testing of various parts of web based Claims application. Resolved production issues. Developed and maintained the code management process using PVCS. Supported Admin Tool functions and maintain the system priming scripts.
• Primary support person for maintaining multiple test environments. Supported executions of test cycles. Resolved technical issues.
• Primary support person for all TWS schedule changes.
• Provided on-call technical customers' support. Documented reported problems and solutions using Vantive problem management tool.

Environment: SQL Server 2000, DB2, DB2 UDB v.7 & 8, AIX 5.x, Shell Scripts, Oracle, PL/SQL, Filenet Workflow and Document Management, QMF for Windows, VB v.6, Windows NT/XP, Transact SQL, DTS packages, Stored Procedures, Java Script, XML, PVCS, Tivoli Workflow Scheduler (TWS), Vantive, mainframe, Visio, Erwin.

12/00-03/02 Responsible for support, modification and improvement of the Disability Management suit of products. System includes mainframe, client server and web applications utilizing COBOL, DB2, VB, ASP and Java Script. Data is housed in DB2 databases on the mainframe and accessed using DB2 Connect. Applications are communicating with other systems using MQ Series.

• Performed analysis, modifications and unit/system testing of VB applications. Provided production support, resolve production problems. Queried database to produce ad-hock reports. Wrote batch process to perform data conversion (DB2 UDB, QMF, QMF for Win).
• Analyzed existing processes and made recommendations for SQL and Database tune-up.
• Wrote new Stored Procedures to replace dynamic calls in the Web applications. Analyzed and made appropriate changes in VB code. Generated test data using new conversion process and perform unit and system testing.
• Responsible for migration of all application source into PVCS version management tool..
• Provided 12/7 support for mainframe based Employee Eligibility daily and nightly processing and implemented the new processes for the new companies. Developed and implemented number of enhancements. Redesigned processes to make them more efficient.
• Created system documentation, prepared 'Statement of Work' and 'Project Plans' for a new proposals and enhancements. Created system diagrams, conducted training and 'Info Sharing' sessions.

Environment: DB2 UDB v.7 & 8, CICS, COBOL390, QMF, XPEDITER, FILE-AID, Extra!, ENDEVOR, EZTRIEVE PLUS, HTML, ASP, VB Script, Visual Basic v.6, Windows NT/XP, FrontPage, MQ Series, Websphere Host-on-Demand, PVCS, Vantive, Test Director, Visio.

05/2000-11/2000 Confidential
Consultant for Verizon (former Bell Atlantic).

Environment: Oracle 8i, PL/SQL, DB2 v.5, COBOL2, ENDEVOR, FILE-AID.

04/1998-04/2000 Confidential,
Consultant for Confidential
Responsible for complete reengineering and support of the Financial Assistants Compensation System. Development efforts included redesign of the database (DB2), enhancement to programs functionality, automating of the manual processes. System was rewritten to more effectively interact with the Integral Payroll system, to be Y2K compliant, and streamlined. The CICS part of the system was replaced by the Web application (ASP, VBScript) on Merrill Lynch IntraNet which facilitates the access of branch offices to the system database (DB2).

• Performed analysis, coding and full system testing of the new system. Provided production support for current system (COBOL/CICS/DB2), resolve production problems. Queried database in order to provide users with multiple reports (QMF, SQL).
• Gathered business requirements for the next stage of the project. Wrote specifications and recommendations to improve processes.
• Modified the Stored Procedures to improve the performance of the Web applications. Analyzed and made appropriate changes in ASP code.
• Provided technical assistance to business analyst in the new International Payroll project. Create system prototype using Visual Basic.

Environment: DB2 v.5, CICS, COBOL2, QMF, PROEDIT, VIASOFT, INTERTEST, ENDEVOR, FILE-AID, Brixton/Extra, MS Access, MS Access ASP, VBScript, Visual Basic, Visual InterDev.

OTHER RELATED EXPERIENCE:
10/96-04/98 Confidential, Franklin Center, PA - Senior Programmer/Analyst
04/96-10/96 Confidential, Plymouth Meeting, PA - Senior Consultant
1993-1996 Confidential, Haddonfield, NJ
Consultant for Confidential, (12/94-04/96), Confidential, (09/93-12/94), Confidential, (08/93-09/93)
03/93-07/93 Confidential, Wayne, PA
Consultant for Confidential

Confidential, Moscow, USSR - Programmer/Analyst

1986-1988 Confidential, Moscow, USSR - Programmer/Analyst
Environment: IBM-3090, MVS/ESA, DB2, CICS, COBOL2, EZTRIEVE PLUS, TELON, XPEDITER, FILE AID.

EDUCATION
12/2009 BW330 - SAP BW - Modeling & Implementation
10/2009 BW310 - SAP BW - Enterprise Data Warehousing
05/2009 Informatica 9 "Deep Dive" Conference and On-Hands Training
05/2007 Informatica Inc. PowerCenter 8 - Level II Developer with New Features
03/2006 Informatica Inc. PowerCenter 7 - Level II Developer/Administrator course
03/2002 Themis Inc. Introduction into MQ Series.
12/99-03/2000 DPT Business School, Philadelphia, PA
04/99-06/1999 Course in Web Development using Java, Java Script and ASP. Introduction to PERL on Unix.
Course in Client Server programming using Visual Basic, ORACLE PL/SQL..
02/92-01/93 Data Processing Trainers, Philadelphia, PA
Advanced courses in DB2 programming. Diploma in Business Applications Programming.
1982-1986 Moscow Institute Of Automobiles And Roads State Technical University, Moscow, USSR . B.S. in Engineering with minor in Computer Science

REFERENCES Available upon request.