SUMMARY:

• Contributes more than 25+ years of Information Technology experience.
• Contributes data warehouse, data mart systems, design, analysis, and conversion experience, and project lifecycle experience.
• Design, extraction, transformation and load experience involving multiple data sources across multiple platforms.
• Successful loaded large warehouse and data mart systems.
• 12 years of Informatica - V9.61( Confidential ), 8, 7, 6
• 1 year of Informatica Confidential
• 1 year of Informatica MDM
• 1 year of Big Data (Hadoop, Hortonworks, HIVE, AMBARI, ZOOKEEPER)
• 2 months Pentaho Kettle
• 16 years of DB2.
• 1 year of GreenPlum
• 5 year of Teradata
• 8 years of IBM UDB 7.0 / 8.2
• 12 years of Unix scripts
• 8 years of SAS (Mainframe + Unix)
• 12 years of Oracle.
• One year of SQL Server
• 6 years of IMS.
• 15 years of COBOL, VS-COBOL II, JCL, VSAM
• 15 years Data conversion, Data cleanup and application development.
• Data Cleanup, Data Conversion (5 years)
• Extraction and transformation from multiple data sources, three (3+) years IMS/DSL, DB2/DSL, COBOL/FS DSL and ORACLE/DSL and SAP.

TECHNICAL SKILLS:

• SAP(SD / CD/ FI), Salesforce, INFORMATICA v 9.1, 8.6.0, 7.2, 6.2, Informatica Power center, ETL, Oracle, SQL, PL/SQL, LINUX, “Informatica Cloud, SAP & Sales Force Integration”, FACETS 4.3, 5.2, SAS (Mainframe & Unix (9.1, 9.2) ) Hyperion Essbase OLAP 9 Tool . Cognos 8 Tool, ETI*EXTRACT v3.0.2, v3.0.3, v4.0, FX, COBOL FS, IMS DB, DB2 v6, IBM UDB 7.0, 7.2, 8.2, COBOL, COBOL II, PRISM Warehouse Executive v1.5, SQL, DL/I, CICS, VSAM, ISPF, MVS-JCL, VSE-JCL, PACBASE, DESIGN/I, INSTALL/I, IEF, MVS/ESA, MVS/XA, DOS/VSE, SSP, AOS/VS, MS-DOS, Unix, scripts, ORACLE, SQL-PLUS, Pro-C, ASP, HTML, VB. Big Data Horton, GreenPlum Database, HP Fortify, web services, Business analysis, Data warehouse.
• Pentaho Data Integration Tool, Talend Data Integration Tool.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr Informatica ETL Consultant

Responsibilities:

• Involved as Sr. ETL Consultant to convert PIMS database to Passport system database.
• This is Onetime database conversion project.
• Used Informatica Power Center, Informatica Confidential, HIVE, AMBARI, YARN.
• Responsible for Analysis, design, develop and implement the Informatica mapping.
• Source and target database are using DB2.
• Used Informatica, Mainframe, UNIX Scripts.

Confidential, Minneapolis, MN

Sr Informatica ETL Consultant

Responsibilities:

• Involved as Mainframe Security Consultant.
• This was Multi-phase project to produce multiple documents related to Security Issues.
• Used HP Fortify Security software for same.
• Responsible for OWASP top 10 security issues.
• Analyzed and produced following documents for phase I:
• Security Requirements
• Threat Modeling/Application Threat Profiling
• Deprecated Unsafe Functionality
• Secure Coding Standard
• Static Analysis.

Confidential, Warren, NJ

Sr Informatica ETL Consultant / Team Lead

Responsibilities:

• Involved as Solution Architect to setup ETL batch job environment from scratch for Confidential (Big Data) for Health Insurance, Wellcare, and Tampa, FL. This project required to extract data from multiple source systems and load into Confidential to data warehouse.
• My responsibilities include Team Lead + Sr ETL and MDM Consultant. Designed the system to get the data from multiple source systems and load into Confidential to GreenPlum database. We used Infomatica Big Data Edition ( Confidential ) and Power Center for ETL, Informatica MDM Tool for MDM, Linux BASH script and Hortonworks for Big Data Hadoop.
• Used HIVE, HDFS, FLUME, AMBARI, YARN, Tableau, GreenPlum database to build the report. Used SQOOP to load data from Oracle to Big Data and Confidential . We also used Flume to load data into target tables.
• Involved as Sr Informatica ETL Consultant to retrieve data from Salesforce, Oracle database and load into Oracle EDW for Verizon Telematics. Used Informatica Confidential to build mapplets for data validation. Used Informatica MDM to retrieve the data for staging area and populate into MDM.
• Also included designing/developing Business Components, Business Data Access Components, meeting business analysts and analyzing requirements.
• Developed application with n-tier architecture and made use of Confidential (Object Oriented Design/COM/DCOM) technology and MS Transaction Server 2.0, to create business objects ( Confidential ) along with software development life cycle (SDLC) methodologies.
• My responsibilities include Team Lead + Sr ETL and MDM Consultant. Designed the system to get the data from multiple source systems and load into Confidential to GreenPlum database. We used Infomatica Big Data Edition ( Confidential ) and Power Center for ETL, Informatica MDM Tool for MDM, Linux BASH script and Horton for Big Data. Used Tableau, GreenPlum database to build the report.
• Involved in ETL design for Media Company (A24 Film) in NYC. This required getting the data from files and load into Oracle Data Warehouse. Did the Analysis, design and loaded the data into Data warehouse.
• Used Pentaho Data Integrator, JAVA, Linux and also MS-Office and PowerPoint, Visio and Project.

Confidential, Chicago, IL

Informatica ETL Architect

Responsibilities:

• Involved in collection of Medical Students survey data, transform and load into Data Warehouse(DB2 database) and build report using Tableau.
• My responsibilities included design, develop and implement Informatica mapping, session, and workflow. We used Informatica Power Center, Unix Kshell script for ETL and SQL, PL/SQL.

Confidential, Detroit, MI

Informatica ETL Architect

Responsibilities:

• Involved in Integration, Design batch process to run Batch jobs using Open Process Batch Scheduler.
• Support offshore and onshore test team to achieve aggressive target date.
• My responsibilities include Design core Facets, Informatica, Data stage, Cognos batch jobs, schedule test and implement in production.
• Open Process schedule jobs between multi operating system. We are using Trizetto’s Facets system, Data stage and Informatica ETL, Unix Scripts and Cognos reporting jobs. Have good knowledge of Facets Healthcare data model.
• My responsibilities included design, develop and implement Informatica mapping, session, and workflow.
• We used Informatica Power Center, Unix Kshell script for ETL and also along with MS-Office and PowerPoint, Visio and Project.

Confidential, Chicago, IL

ETL/Data Warehouse Architect

Responsibilities:

• This was proof of concept project to integrate SAP and Salesforce system. Involved in Analysis, Design, Integrate SAP and Salesforce.
• Lead team of 4 ETL member and used agile project methodology.
• My responsibilities included Analysis, design, develop and implement the system. Did the setup Informatica Cloud, ETL program and load from SAP to Salesforce and vice versa. Also design, analysis of ETL programs from SAP (MM, SD) to Data Warehouse. System uses Oracle, SAP R/3 (MM, SD), ABAP using INFORMATICA V9.1, Informatica Cloud programs, UNIX Script, unit testing, and integration testing, performance tuning and SQL, PL/SQL.
• My responsibilities included design, develop and implement Informatica mapping, session, and workflow. We used Informatica Power Center, Unix Kshell script for ETL.

Confidential, Hartford, CT

Solution/ETL Architect

Responsibilities:

• This was 4 weeks POC project to integrate SALESFORCE and SAP Cloud using Informatica Cloud. Integrated data between Salesforce and SAP CRM. Demonstrated and implemented jobs in cloud environment.
• This project was integration between SAP SD and Sales Force.
• My responsibility was to develop and implement Informatica cloud jobs.

Confidential, Denver, CO

Solution Architect / Team Lead

Responsibilities:

• Involved as Solution Architect to setup ETL batch job environment from scratch. Also involved in Analysis and Development of interface between Facets (Health Care System) SAP FI (CD - Collection & Disbursement). This project requires extraction of data from multiple sources viz. ORACLE, Flat files, SAP R3/BW tables and transform, build SAP Doc and load into SAP R3 / BW databases and vice versa. Involved in ETL (Extraction, Transformation and Load) design, resolves data model issue (10%), the mapping issues (10%), Business Rules issues (10%), SAP BW (10%). Involved in Data Modeling, ETL and BI Architecture committee to create standard procedures. Used Water fall and agile project methodology. Also involved in scrum and project status.
• We used Infomatica Big Data Edition ( Confidential ) and Power Center for ETL, Informatica MDM Tool for MDM, Linux BASH script and Horton for Big Data. Used Tableau, GreenPlum database to build the report.
• My responsibilities included design, develop and implement Informatica mapping, session, and workflow. We used Informatica Power Center, Unix Kshell script for ETL and SQL, PL/SQL.
• Also included designing/developing Business Components, Business Data Access Components, meeting business analysts and analyzing requirements. Developed application with n-tier architecture and made use of Confidential (Object Oriented Design/COM/DCOM) technology and MS Transaction Server 2.0, to create business objects ( Confidential ) along with software development life cycle (SDLC) methodologies and also done MS-Office and PowerPoint, Visio and Project.
• My responsibilities include ETL Team Lead + Informatica Admin + designing/developing ETL programs to create SAP BB, BG, GG DOC using INFORMATICA V9.1, 8.6, 7.3, UNIX scripts, PEARL, unit testing, and integration testing, implementation, production support, performance tuning. Also Used SAS for financial reporting on UNIX. Completed and implemented following projects successfully in production: