SUMMARY:

Highly motivated Information Systems Professional with 20+ years of IT experience in health insurance, retail, financial, utility, telecommunication, pharmaceutical industries including 10+ years working with Business Intelligence concepts like Data Analysis, Data Cleansing, Data Warehousing, Data Reporting and Data Integration. Detail oriented with strong communication, leadership, 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, MS Access.

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

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

Development tools: Informatica PowerCenter, Informatica PowerExchange, Informatica Data Quality (IDQ), Informatica MDM (Siperian), SAP/BW, Erwin, Toad, AQT, Microsoft Office, VISIO, Test Director/HPQC, PVCS, MQ Series, IBM Utilities, XDB, FTP, CVS, Subversion(SVN), TFS, XML/XSD.

Scheduling Tools: Informatica Scheduler, Tivoli Workflow Scheduler (TWS), Control - M, JAMS scheduler, Autosys.

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

Familiarity with: Informatica Cloud, Salesforce.com, Web Services, SOAP, WSDL, MPP, SMP, Teradata, Neteeza.

PROFESSIONAL EXPERIENCE:

Confidential

Integration Specialist

Responsibilities:

• As a member of consulting team responsible for technical development and support for Informatica Master Data Management (MDM) and Informatica Data Quality (IDQ) platforms, as well as ETL processes to load data from multiple source systems.
• Provide technical support for Informatica Master Data Management solution, including inbound/outbound data integration (ETL), maintenance/tuning of match rules and exceptions, data model changes, executing and monitoring initial load and incremental updates, and working with infrastructure and DBA teams to maintain multiple environments.
• Collaborate with business and technical teams to gather requirements around data quality rules, propose the optimization of these rules if applicable and design and develop these rules with IDQ.
• Document all mappings, mapplets, and rules in detail and hand over documentation to the customer.
• Run data quality specific ETL jobs (address standardization and validation, email and phone cleanups, name cleanup, parsing, etc.) utilizing IDQ and migrate and integrate IDQ mapplets into PowerCenter batch processes.
• Designed and developed end-to-end ETL batch automation.

Environment: Informatica PowerCenter 9.6, Informatica MDM v.10, IDQ v.10, Oracle 11g.

NTT Data - Consultant/ Data Integration Specialist

Confidential, Bala Cynwyd, PA

Responsibilities:

• ETL Lead providing guidance in design, development, and implementation of ETL solutions in support of the corporate wide initiative to reduce complexity of PHLY company technology landscape and replace existing billing center and policy administration systems with new robust system based on Guidewire Insurance package.
• Established and promoted ETL Development Standards and Best Practices. Worked with ETL administration team and Infrastructure team on implementing standards and improving release management procedures.
• Documented and communicated technical architecture and ETL solution approaches. Developed processes design and Standard Operational Procedures (SOP) artifacts.
• Work closely with the Business Analyst resources in creating the code for data migration into Guidewire DataHub.
• Provided technical support to development team in resolving test defects.
• As part of Leads group responsible for build coordination and operational support of various development environments.
• Implemented ETL scheduling through JAMS enterprise job scheduling tool. Implemented scheduling standards. Resolved tool technical issues and deficiencies.
• Conducted code reviews, promoted ETL best practices, mentored junior developers and conducted technical interviews.

Environment: Informatica PowerCenter 9.6 on Windows platform, SQL Server Management Studio 2012, Erwin, Windows PowerShell Scripting, Visual Studio 2013, MS TFS, Agile, XML/XSD, JAMS, SAP BODS, SharePoint, VISIO, HPQC.

Starpoint Solutions / Regent Systems - Consultant/ Data Integration Specialist

Confidential, Philadelphia, PA

Responsibilities:

• ETL Architect/ Informatica Lead Developer providing expert level design, development, and implementation of ETL solutions in support of the Defense Medical Logistics Support System (DMLSS) medical materiel management and to 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.
• Created the logical data model and work closely with the Database Administrator on the translation of the logical model into a workable physical model.
• Established and enforced ETL development standards.
• Designed and built ETL processes to support Master Medical Catalog load effort.
• Implemented Web Service calls and integrated disparate systems data into ETL processes.
• Implemented Workflows Automation, Error Handling, Session Failure Notification and Recovery into existing processes.
• Wrote PL/SQL Stored Procedures and Functions and implemented calls into ETL processes.
• Conducted code reviews, promoted ETL best practices, mentored junior developers and assisted administrator on overall development environments improvements.

Environment: Informatica 9.6 on Windows platform, Oracle 11g, Toad for Oracle 11.5, Erwin, Windows PowerShell Scripting, Visual Studio 2012, MS Team Foundation Server, Agile, XML/XSD, WebServices.

GalaxE Solutions - Consultant/Technical Analyst

Confidential, Philaldelphia, PA

Responsibilities:

• 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.

Starpoint Solutions - Consultant

Confidential, Philadelphia, PA

Responsibilities:

• Informatica ETL Architect and Technical Lead 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 8 people 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 Analysts, Data Modelers and DBA groups on creating technical requirements, database design and ETL solutions.
• Performed data modeling functions and provided DDL for additional objects.
• Provided recommendations for performance tuning of large data volume processes through the use of Database and/or Informatica partitioning, and better indexing resulting in 80% performance improvements.
• Promoted and conducted code reviews.
• Provided guidance to junior developers. Conducted technical training and interviews.

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

Confidential, Chesterbrook, PA

Datawarehouse/ETL Lead Developer

Responsibilities:

• Responsible for all aspects of Data Integration as well as Project Management within Corporate IT providing data services to external and internal customers. Confidential is a market leader in pharmaceutical distribution handling about 20% of all of the pharmaceuticals sold and distributed in United States.
• Responsible for Data Quality Analysis 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 Data Quality Assessment environment. Utilized Informatica Power Center and PowerExchange to unload SAP, DB2 (UDB on AIX, AS/400 and on Z/OS), IDMS, VSAM data. Created ETL solutions based on analyst’s requirement. Applied filters and functions to ABAP code.
• Configured Informatica Data Quality(IDQ) Services to perform profiling for Completeness, Conformity, Consistency, Duplicate data identification, Inaccurate data identification. Develop reusable Data Quality objects, mappings and mapplets.
• Prepared data quality health check analysis reports (profiling reports).
• Derived cleansing strategy based on profiling results.
• Project manager and hands-on technical lead for multiple projects.
• Technical lead for Bellco Health/ Confidential Master Data Management (MDM) solution. Translated business requirements into technical design documentation. Developed project WBS and test plans, produced budget estimates. Performed resources management functions. Reviewed the work. Coordinated development and implementation efforts.
• Involved in design and development of MDM Hub configuration, creation of Schema, Base Objects, landing and staging tables, mappings, Match and Merge rules, trust settings, cleanse functions and promotions.
• Lead an effort for developing a Center of Excellence (COE) for ETL services within the Corporate IT department.
• Implemented B2B data integration solutions for supply chain management (SCM).
• Performed basic administrative functions. Proficient in Admin Console.
• Provided coaching, mentoring, and overall leadership to junior developers.
• Participated in technical interviews and trained new developers.
• Responsible for all aspects of Data Warehouse development including sources identification, data analysis, ETL design, coding, testing and deployment.
• Collaborated with BI team, modelers, Database Administrators and members of the user community, in analyzing and integrating data from disparate applications.
• Performed data analysis using Informatica Data Profiler and recommended data acquisition and transformation strategy.
• Built mappings, sessions and workflows to load data from multiple Source databases (SQL Server, DB2) and flat files into target Oracle Database.
• 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. Documented Test Plans and worked with QA team on testing issues resolution.
• Provided post-implementation support, problem resolution, enhancements and maintenance.

Environment: SAP BW, Informatica 7.1 & 8.6, Informatica Data Explorer (IDE) 8.6, Informatica Power Exchange 8.6, Informatica Data Quality (IDQ), Informatica MDM (Siperian), Oracle 10g, DB2 UDB v8, Microstratergy, UNIX AIX 5.x, Shell Scripting, Erwin, Test Director (HPQC).