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 leadership, communication, analytical and problem solving skills.

TECHNICAL SKILLS:

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

Databases: AWS Redhsift, Hbase, Hive, 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 BDM, Informatica PowerCenter, Informatica PowerExchange, Informatica Data Quality (IDQ), Informatica MDM, Hue, Erwin, Toad, AQT, Microsoft Office, VISIO, Test Director/HPQC/ALM, PVCS, MQ Series, IBM Utilities, Syncsort, XDB, FTP, CVS, Subversion(SVN), TFS, XML/XSD.

Scheduling Tools: Informatica Scheduler, Tivoli Workflow Scheduler (TWS), Control - M, JAMS, 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, Python.

EXPERIENCE:

Confidential, Warren, NJ

Integration Specialist / Informatica Developer

Responsibilities:

• Responsible for technical development and support of Data Governance and Data Analytics solutions utilizing Informatica suite of products: Informatica Data Quality (IDQ), Master Data Management (MDM), Big Data Management (BDM) as well as PowerCenter ETL.
• Participated in Enterprise Data Hub solution implementation on Informatica BDM and Amazon Redshift platform with staging in S3 raw buckets.
• Developed ETL processes utilizing Dynamic Mappings for mass ingestion of data comprised of up to several hundreds tables/files to load into raw and refine zones. Dynamically applied data standardization, datatype conversion and cleansing rules.
• Good knowledge of Hadoop and Hive. Successfully loaded files into Hive, HBASE and HDFS from various sources. Good understanding of Amazon web services (AWS).
• Provided technical support for Informatica Master Data Management solution, including inbound/outbound data integration (ETL), maintenance/tuning of match rules and exceptions. Executed initial data load and incremental updates, worked with infrastructure and DBA teams to maintain multiple environments.
• Collaborated with business and technical teams to gather requirements around data quality rules, proposed rules optimization, designed and developed these rules in IDQ. Implemented data profiling, created score cards, reference tables and documented DQ metrics like accuracy, completeness, duplication, validity and consistency.
• Developed data quality specific ETL jobs including Address standardization and validation, emails, names parsing and phone cleanups. Migrated and integrated IDQ mapplets into PowerCenter batch processes.
• Designed and developed end - to-end ETL batch automation.

Environment: Big Data Hadoop, HDFS, HBase, Hive, Amazon EC2, AWS Redhsift, HP ALM, Informatica BDM 10.1.1 U2, Informatica PowerCenter 9.6 and 10.1, Informatica PowerExchange, Informatica MDM v.10, IDQ v.10, Oracle 11g, SQL Server.

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.

Confidential, Philadelphia, PA

ETL Architect/ Informatica LeadDeveloper

Responsibilities:

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

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.

Confidential, Philadelphia, PA

Informatica ETL Architect and Technical Lead

Responsibilities:

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

Confidential

Responsibilities:

• 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) generating EDI transactions.
• Performed basic administrative functions. Proficient in Admin Console.
• Provided coaching, mentoring, and overall leadership to junior developers.
• Conducted technical interviews and trained new developers.
• 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).