SUMMARY:

• Highly motivated Information Systems Professional with 20+ years of IT experience in insurance, retail, financial, utility, telecommunication, wholesale and pharmaceutical industries including 8+ years working with Business Intelligence concepts like Data Reporting, Data Analysis, Data Cleansing, Design, Data Warehousing, and Data Integration.
• Expert level in Relational Database Management Systems. Detail oriented with strong communication and leadership skills. Excellent analytical and problem solving skills.

TECHNICAL SKILLS:

Operating Systems: UNIX/AIX, Windows NT/XP/Win7, IBM Mainframe (MVS/ESA, OS/390, zOS)

Databases: Oracle, DB2 UDB, MS SQL server, ADABAS/ADASQL.

Languages: SQL, PL/SQL, Shell and PowerShell Confidential, COBOL, CICS, JCL, VSAM, Eazytrieve Plus.

Methodologies: Software Development Life Cycle (SDLC), Data Warehouse Design, CDC, Logical and Physical Database Design, Dimensional Modeling, Star/Snowflake schema, ETL, SQL Tuning.

Development tools: Informatica PowerCenter 9.5/8.6/7.1, Informatica PowerExchange 8.6.1, SAP/BW v.7, Erwin, Toad, AQT, QMF, SPUFI, MQ Series, BMC, FILE - AID, INSYNC, IBM Utilities, Syncsort, FTP, EDI, Microsoft Office, VISIO, 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), Control-M, CVS, Subversion(SVN), TFS.

PM Tools: MS Project, Rational Portfolio Manager(RPM), Clarity Portfolio Management.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Consultant

• Senior ETL Developer providing expert level design, development, and implementation of ETL solutions in support of the DoD initiative to reduce Military Health System (MHS) costs and enable the highest quality of health care for US troops around the world.
• The initiative includes building the common catalog, materiel standardization, and optimal sourcing, all intended to reduce overall materiel costs, increase use of clinically-appropriate products, increase availability and accuracy of materiel data, and improve interoperability of MHS capabilities.
• Established and enforced ETL development standards.
• Designed and built Informatica processes to support Master Medical Catalog effort.
• Conducted code reviews, promoted ETL best practices, advised and assisted administrator on overall development environments improvements.

Environment: INFA 9.5 on Windows platform, Oracle 11g, Toad for Oracle 11.5, Windows PowerShell Confidential, Visual Studio 2012, MS Team Foundation Server.

Consultant/Technical Analyst

Confidential, Philaldelphia, PA

• Worked directly with the business users as well as the ETL, Data Architect and Cognos development teams to develop business requirements and technical solution. Performed gap analysis and translated the requirements into technical specifications.

Environment: Neteeza, AbInitio (ACE), Oracle 11g.

Consultant

Confidential, Philadelphia, PA

• Informatica ETL Lead Developer providing expert level design, development, and implementation and direction to project team in the Retirement Services and Enterprise Reporting space.
• Lead a group of up to 6 developers in the effort to build line of business Data Warehouse and Data Store as well as reporting interfaces for B2B process.
• Established and enforced Metadata and ETL development standards. Work closely with Business, Data Modeler and DBA groups on creating technical requirements, database design and ETL solutions.
• Perform data modeling functions and provide DDL for additional objects. Provide recommendations for performance tuning resulting in 80% performance improvements.
• Conduct code reviews.
• Mentor and provide guidance to junior developers.
• Conduct technical training and interviews.

Environment: INFA 9.0, Oracle 11g, SQL Server 2008, UNIX AIX 5.x, VISIO, HPQC, SVN.

Confidential, Chesterbrook, PA

Datawarehouse/ETL Lead Developer/SAP BW Developer

• 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.
• In support of Business Transformation project within corporate IT moving towards ERP solution, designed and developed ETL processes to unload disparate 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.
• Lead an effort for developing a Center of Excellence (COE) for ETL services within the Corporate IT department.
• Project and technical manager for Bellco Master Data Integration solution. Translated business requirements into technical design documentation. Developed project and test plans, produced estimates. Performed resources management functions. Coordinated design, development and implementation efforts. Reviewed the work. Conducted weekly status meetings.
• Designed and implemented B2B data integration solutions for supply chain management (SCM).
• Provided coaching, mentoring, and overall leadership to junior developers.
• Participated in technical interviews and provided training.
• Responsible for all aspects of Data Warehouse development including sources identification, data analysis, ETL design, coding, testing and deployment.
• Collaborated with other BI team, 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).
• Effectively translated business requirements into data transformation design documentation.
• Worked with Data Architects on enhancing logical and physical data model.
• 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. Ran complex SQL queries to verify data loads.
• Utilized Informatica Scheduler to schedule workflow batches.
• 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, code review, Unit and System testing. Worked with QA team on testing issues resolution.
• Created and documented Test plans using Test Director.
• Provided post-implementation support, 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 Confidential, Erwin, VISIO, CVS, MS Project, Rational Portfolio Manager (RPM), Clarity Project Management tool, Test Director/HP Quality Center.

Confidential, Philadelphia, PA

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.

Environment: Informatica 6.2, SQL Server 2000, DB2 UDB v.7&8, UNIX AIX 5.x, Shell

Confidential

Developer, Programmer/Analyst

• Responsible for 24/7 Production Support of Disability Claims Management Systems. Claim System based on the FileNet Acenza package customized for the company needs.

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.