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(BDE), 8, 7, 6
• 1 year of Informatica IDQ
• 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.
• Certified Master Consultant with ETI*EXTRACT experience (since 4/97).
• Four months of Web Development experience in multi tier architecture.

TECHNICAL SKILLS:

• SAP(SD / CD/ FI)
• SalesForce
• INFORMATICA v 9.1
• 8.6.0
• 7.2
• 6.2
• “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
• Pentaho Data Integration Tool
• Talend Data Integration Tool.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr Consultant

Responsibilities:

• Involve as Sr. ETL Consultant to convert PIMS database to Passport system database. This is Onetime database conversion project.
• Used Informatica Power Center, Informatica BDE, 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 11/

Sr 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.
• Delivered above mentioned document successfully as per project budget and timeline.

Confidential, Warren, NJ

Sr Consultant / Team Lead

Responsibilities:

• Involved as Solution Architect to setup ETL batch job environment from scratch for Data Lake (Big Data) for Health Insurance, Wellcare, Tampa, FL. This project required to extract data from multiple source systems and load into Data Lake to data warehouse.
• My responsibilities include Team Lead + Sr ETL and MDM Consultantant. Designed the system to get the data from multiple source systems and load into data lake to GreenPlum database. We used Infomatica Big Data Edition (BDE) and Power Center for ETL, Informatica MDM Tool for MDM, Linux BASH script and Hortonworks for Big Data. Used HIVE, HDFS, FLUME, AMBARI, YARN, Tableau, GreenPlum database to build the report.Used SQOOP to load data from Oracle to BigData Datalake.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 IDQ to build mapplets for data validation.
• Used Informatica MDM to retrieve the data for staging area and populate into MDM.
• My responsibilities include Team Lead + Sr ETL and MDM Consultantant. Designed the system to get the data from multiple source systems and load into data lake to GreenPlum database. We used Infomatica Big Data Edition (BDE) 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.

Confidential, Chicago, IL

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.

Confidential, Detroit, MI

ETL Architect

Responsibilities:

• Involve 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, Datastage, Cognos batch jobs, schedule test and implement in production. Open Process schedule jobs between multi operating system. We are using Trizetto’s Facets system, Datastage and Informatica ETL, Unix Scripts and Cognos reporting jobs. Have good knowledge of Facets Healthcare data model.

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 methodlogy.
• My responsibilities included Analysis, design, develop and implement the system. Did the setup Informatica Cloud, ETL program and load from SAP to SaleForce 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.

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

Confidential, IL

Sr. Data Warehouse Consultant

Responsibilities:

• Involved in building New York Stock Exchange Order Tracking System (Rule 132 OTS ) as well as Supervision Archival Project for Confidential . This project required extraction of data from multiple sources viz. ORACLE, UDB DB2, QSAM files and transform and load into DB2 UDB on AIX environment. Involved in ETL (Extraction, Transformation and Load) design, resolved the mapping issues, Business Rule, Data Warehouse design issues, Granularity issues, Data Warehouse Data Model issues. Resolved lots of Data Warehouse Data Model Granularity issues because of extensive Data Warehouse experience. Used SAS for financial reporting. Involved in JAD session for requirement gathering. Implemented OTS project and Supervision Archival project.
• My responsibilities included designing/developing ETL programs using INFORMATICA V7.2, 6.2, unit testing using unix scripts and integration testing and implementation on AIX. Involve in following internal Project: a) Order Tracking System (OTS) . b) Supervision OLAP Data Archival c) Rate Tiering .

Confidential, IL

Sr. Data Warehouse Consultant

Responsibilities:

• Involved in building Integrated Sales Reporting II (ISR 2) Data Warehouse Project for Confidential, Inc., (Retail & Manufacturing). This project required extraction of data from multiple sources viz. DB2, QSAM files and transform and load into DB2 UDB on AIX environment. Involved in ETL (Extraction, Transformation and Load) design, resolves the mapping issues, Business Rule, Data Warehouse design issues, Granularity issues, Data Warehouse Data Model issues. Resolved lots of Data Warehouse Data Model Granularity issues because of extensive Data Warehouse experience. We were extracting data from SALES REPORTING System, and loading the data into DB2 UDB database. Used the SAS for Sales Reports & OLAP tool to build the front-end cube and reports to access the Database.
• My responsibilities included ETL Team Lead + designing/developing ETL programs, UNIX scripts, unit testing, and integration testing on Mainframe as well as AIX.

Confidential, WA

Sr. Data Warehouse Consultant

Responsibilities:

• Involved in building PRISM Data Warehouse Project for PREMERA, Inc., (Health Insurance). This project required extraction of data from multiple sources viz. SQL Server, DB2, QSAM files and transform and load into DB2 UDB on AIX environment. Involved in ETL (Extraction, Transformation and Load) design, resolved the mapping issues, Business Rule, Data Warehouse design issues, Granularity issues, Data Warehouse Data Model issues. Resolved lots of Data Warehouse Data Model Granularity issues because of extensive Data Warehouse experience. We were extracted data from FACET System, Healthcare Management System, and loaded the data into DB2 UDB database. Used the COGNOS OLAP to tool to build the front-end cube and reports to access the Database.
• My responsibilities included designing/developing ETL programs using Datastage Suite, unit testing, and integration testing on Mainframe and AIX.

Confidential, CA

Sr. Data Warehouse Consultant

Responsibilities:

• Involve in building Sales Data Warehouse Project on Window 2000 Server. This project was used to compare Microsoft SQL Server performance, ease to build and run the data warehouse and DB2 UDB Database. This project was 6 weeks short-term project. Involve in installing DB2 UDB Database V7.2, Data Warehouse Manager, OLAP Server, and OLAP Tool (Hyperion Essbase OLAP Tool). Utilized IBM’s ETL tool to move data from Microsoft Access Database to UDB V7.2. Build the cube as per the clients requirement. Load the data into Cube and also did the performance tuning of DB2.

Confidential, Los Angeles, CA.

Sr. Data Warehouse Consultant

Responsibilities:

• Involved in building Insurance Information Warehouse(IIW) project. This is an IBM's Insurance Information Warehouse System using RS6000, AIX, UDB 7.0, IBM 390. This system will help Insurance Companies to sell cross product to their customers.
• Involved in analysis, design, modeling, extraction, transformation and load (ETL design and development) IIW (Insurance Information Warehouse) Data warehouse using ETI 4.1.2 FX, JCL, UNIX script. Current tasks involves modifying templates, extracting data from DB2 and flat files and loading it into UDB 7.0 database on RS6000 in AIX environment. It required extensive interaction with client particularly involving mapping issues, data base issue, performance tuning, load Cognos cubes.

Environment: ETI 4.1.2 FX, COBOL/FS, COBOL/DB2 DSLs, COBOL, JCL, shell script, DB2, UDB, MVS, AIX, COGNOS.

Confidential, San Ramon, CA

Sr. Data Analyst

Responsibilities:

• Involved in Gathering Data, Architecture, Analysis, Design, Coding, Unit Testing and Integration testing of system.
• Responsibility also included, gathering relevant data in Excel format, apply business transformation rules and extract data into Access Data Base. Utilized Access Data Base to generate fast reports and get rapid approval from the clients. On approval, extracts were performed to load the data into SQL Server 7.0 Data Base. Intranet leveraged same data using ASP, HTML, JAVA Script, VB Script, Visual Basic 6.0, and SQL Server 7.0.

Confidential, Santa Clara

Sr. Web Developer

Responsibilities:

• Designing, Coding, Unit Testing and Integration testing Visual Basic 6.0, ASP, HTML, CSS, MTS, COM and Oracle 8i based application.
• This state of the art application has been designed with COM/DCOM Multi-tier architecture using ASP, Java script, VB Script, Visual Basic, MTS, Oracle Stored Procedures from Microsoft and Oracle. I have been working in the capacity of web developer/COM Component Developer and User Interface Controller for the several use cases. This job involved the extensive usage of Visual Basic and ASP for user interfaces with COM components.
• Apart from the responsibility of COM Component Developer, I coded ASP pages, HTML, CSS and wrote Stored Procedures using Oracle 8.
• This application was built using Visual Basic (6.0), Microsoft Access, Oracle 7.x/8.0, SQLPLUS, ASP, ADO, CSS, HTML, IIS 4.0, and NT 4.0 Operating System.
• My responsibilities 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 OOD (Object Oriented Design/COM/DCOM) technology and MS Transaction Server 2.0, to create business objects (DLLs).

Confidential, Houston, TX

Data Solutions Integrator

Responsibilities:

• Involved in Design, Extraction, Transformation and Load Data Warehouse.
• Extracted data from IMS/DB, DB2 and flat files and populate them after transformation into Teradata Database.
• Involve in Analysis, Coding, Testing and Implementing of the system using ETI*EXTRACT SUITE Tool.

Confidential, IL

• Worked on a large Enterprise Data Warehouse Project, which extracts data from the operational systems in IMS, DB2, and COBOL flat files and loads it into Operational Data Stores (ODS) on DB2. The data from operational data stores on DB2 is then used to populate data marts on Oracle Database. Involved in Analysis, coding, testing and implementing of Extraction, Transformation and load modules, JCLs on Mainframe; loading of DATA MART into Oracle in Unix environment. ETI is the primary tool used to Extract, Transform, and Load (ETL Tool) for this project. Also used SAS for data validation and Brio to generate reports. Worked with IMS/DSL, DB2/DSL, COBOL/FS DSL and ORACLE/DSL. Wrote SAS programs on mainframe to audit/balancing the ETL data.
• Involved in following mentioned projects, which are successfully coded, tested and implemented in production:
• Extracted data from IMS/DB and loaded the data into DB2 ODS after transformation.
• Extracted data from DB2 and loaded the data into DB2 ODS after transformation.
• Extracted data from COBOL flat file and loaded it into Oracle database.
• Involved in consolidation of multiple workset into one workset to reduce the redundancies of same modification of templates in different individual project workset.
• Comparative Rating System - Involved in analysis, generate and testing of Extracted data from IMS/DB and loaded it into DB2 database. It involved modification of ETI conversions, JCLs as per the requirements.
• Also modified the limited number of ETI Templates for Confidential customization.

Confidential, GA

• Worked on a conversion project to transfer data from COBOL flat files using the ETI*EXTRACT tool. This project required conversion of Total System data to a Confidential .
• This included three input files and four output files.
• Work involved analysis, retrieving schema and mapping the parts to generate programs.
• Also modified the templates and wrote code blocks. Used Extract v3.0.3 in COBOL MVS, ISPF, and JCL under mainframe environment.

Confidential, TX

• Worked on a SAP conversion project to transfer data from COBOL flat files to Oracle Database using ETI*EXTRACT. Involved in writing (map and generate) the program, which extracts, transforms data from legacy systems and load into Oracle Database. Program successfully implemented in production. Worked in an ETI*EXTRACT v3.02, COBOL II, RS6000 SP2 (AIX), MVS (XM), TSO/ISPF, and SAP environment.
• Retained for the L/B practices for Data Solutions Integration for Data Transformation, Data Conversion, Data Warehousing, Data Migrations and Data Mining. Experienced in and cross-trained in other Data Movement tools and methods. Completed PRISM Warehouse Executive v.1.5, Warehouse Directory, Schedule Manager, Navigator Web Access, Quality Manager, and Transitioning to Prism Warehouse Executive. Cross-trained and certified in ETI*EXTRACT. Completed ETI*Extract for Master Users Week 1, Extract for Master Users Week 2, and Certification by ETI Certified Instructors on Extract 3.0.2.

Confidential, Beaverton, OR

Senior Consultant

Responsibilities:

• Involved in the analysis, coding and system testing of a warehouse distribution system for Confidential . Worked on Pilot project, which involved partition of current batch jobs and DB2 databases. Ultimately reduced the batch window from 8 hrs to less that 2 hrs. Analyzed, coded, tested and implemented the system successfully in production. This system was developed using VS COBOL II, DB2, and CSP in an IBM 3090 environment.
• Also involved performance issues of other COBOL, DB2 batch jobs using Platinum DB2 tools, STROBE e.g. Brought down the run time to under 2 minutes from 20+ minutes.

Consultant

Confidential, PORTLAND, OR

Responsibilities:

• Involved in the analysis, design, data modeling and coding of the CSS System, also performed data conversion and data cleanup activities on CSS. The application focuses on the specialized needs of the company's current and prospective customers through accurate and timely consumption reporting, billing and payment, up-to-date support and financial summary information. Used DB2, VS COBOL II and IEF in an IBM ES9000 MVS/ESA environment.
• Also performed CYCLE (System Integration) Testing of the CSS project requiring extensive knowledge of business model, data model and raw data so as to find specific testing condition and run the batch jobs for predefined conditions. It used to consume around 14 - 16 hrs/day for 3 months.
• Presented with a reference letter from Rich Walje.

Confidential

• Involved in the analysis and coding of the Integrated Retail Item System (IRIS). The system helps Safeway to manage the range of items sold in stores, the retail price of these items, and the vendors or merchandisers from which these items were purchased.
• Performed analysis and coding of the data conversion programs.
• Used DESIGN/I, INSTALL/I, DB2, IMS/DB, VS COBOL II, and VSAM in an IBM 3090 MVS/ESA and OS/2 environment.

Confidential

System Engineer

Responsibilities:

• Worked on an Oil and Natural Gas Administrative and Revenue database called ONGARD. ONGARD deals with the activities connected to exploration of oil and natural gas.
• Involved in quality assurance and detailed program specifications. Developed program logic and final unit testing of programs using DB2, CICS, VS COBOL II and VSAM in an IBM 3090 MVS/ESA environment.

Confidential, NEW JERSEY

• Worked on a conversion project called Under Writer Processing. This was an existing system used by the Confidential, New Jersey, to underwrite insurance policies.
• Was involved in analysis, system testing, and converting the system database from IMS DB and TELON to DB2. The system was developed using DB2, CICS, VSAM, TELON, and IMS DB in an MVS/XA environment.

Consultant

Confidential, IL

Responsibilities:

• Involved in the enhancement of a Distribution Operating System (DOS). All Sears warehouses and stores to move merchandise from warehouses to the stores used this system.
• In the IBM 3090 MVS/ESA environment used IMS/DB, DB2, CICS and VS COBOL II.
• Involved in the analysis, coding and implementation of programs according to the System Investigation Report (SIR). SIRs were generated for any production problem in any of the application modules.

Confidential

Programmer/Analyst

Responsibilities:

• Worked on an existing payroll system on a DG MV15000. The customer wanted to use the DG MV15000 based payroll system on the IBM SYS/36.
• Was involved in the analysis and coding of the existing programs and was also involved in the conversion effort.
• The payroll system was originally developed on DG MV15000 using COBOL under an AOS/VS environment and was converted to the IBM SYS/36 using COBOL under SSP.

Confidential, KS

• Involved in the enhancement of a finance and forecast billing system and an order processing system for Confidential, Kansas.
• The system validates and analyzes the Call Detail Record (CDR) to generate various MIS reports.
• The system was developed in an IBM 3090 MVS/XA environment using DB2, CICS, VS COBOL II, and VSAM. Performed analysis, coding and testing of the system.

Confidential

• Involved in the development and implementation of a Pre/Post Examination Processing System. The system incorporates CICS on-line data entry and batch processing programs to generate various reports. Designed the CICS Post Examination data entry programs as well as batch programs for printing reports. Used COBOL, CICS, VSAM, and JCL in an IBM 370 DOS/VSE environment.

Confidential

Analyst/Trainee Programmer

Responsibilities:

• Involved in the design and development of an Order Processing System. The system incorporates Order Processing and prints various reports.
• Involved in CICS online data entry programs for orders and batch processing programs for invoice and sales summary reports on an IBM 370 using CICS, VSAM, and COBOL under DOS/VSE.

Confidential

• Involved in the enhancement of a payroll system. The system incorporates a print function to include printing salary slips, summary reports, income tax and so on.
• Used VSAM, CICS, and COBOL in an IBM 370 DOS/VSE environment.

Confidential

• Involved in the development of an Order Processing System. The system incorporates order processing and prints various reports.
• Coded and tested online programs, as per a Systems Analyst's specifications. Used VSAM, CICS, and COBOL on an IBM 4331 under DOS/VSE.

Confidential

• Involved in the development of an inventory control system. The system incorporates online stock status, ABC analysis, Generation of Material, reject notes, goods received and purchase orders. Coded online programs using VSAM, CICS, and COBOL in an IBM 370 DOS/VSE environment.