SUMMARY

• 14+ years of extensive experience in teh IT industry wif thorough understanding of Data Warehousing terminology and proficient in Data Warehousing tools like AbInitio, Talend and Actuate.
• Presently working as AbInitio EDI COE consultant wif SunTrust.
• Having 8+ years of AbInitio engineer expertise in latest components available in teh market (OC/CC, Express>It, MHUB, AG, DQE, ABSQL).
• Good experience in large volume of data from various heterogeneous systems using Abinitio and Informatica.
• Designed and implemented ETL applications (AI, ORACLE, WEBSPHERE, Tomcat) in UNIX environments.
• Implemented AbInitio code standards and utilities for enablement.
• Design and Development of complex Ab initio graphs and reusable utilities.
• Enabled Capacity planning and storage Optimization framework.
• Experience in building to AbInitio environment on AWS platform.
• Experience in AWS based Data Ingestion and transformations.
• Strong Experience in AbInitio Co - Operating System, GDE, EME, key management, CO>OP License management, HDFS components and debugging strategies.
• Setting up alerts and taking care of CPU and Memory Utilization, server performance checks and backups.
• Well versed in EME administration, Code migration and environment check out.
• Handled Server level issues of AbInitio and analyzed CPU, processor bottlenecks wif AbInitio environment.
• EME Setup, project creation in EME, EME Groups/users and setting permissions, EME Restart, Backups.
• Developed ETL Processes using AbInitio for loading data from source to target as per ETL specification.
• Configuration AbInitio on Hadoop BDA nodes.
• Actively interacting wif business users, software development team and system administrators in gathering teh requirements and creating functional and design specifications.
• Expertise in DWH concepts and implementing teh same
• Talend code migration and environment setup.
• Extensive experience on SQL, fairly comfortable wif PL/SQL.
• Working in production support and Maintenance and dealing wif issues like recovery mechanisms and failure analyses.
• Have good knowledge on MongoDB, Python and PySpark.
• Knowledge on ISO, CMM Levels.
• Good team player wif excellent communication, written and presentation skills wif strong aptitude to learn new technologies.

TECHNICAL SKILLS

ETL Tools: AbInitio (GDE, Co-Op 2.14, 3.0, 3.1, 3.2, 3.3), Express>It, DQE, MDH

Reporting Tools: Actuate e-Report designer (V6, 7, 8), BO XI

Operating System: UNIX, AIX, Windows XP/2000/NT

Languages: C/C++, SQL, PLSQL, Actuate basic

DBMS: Oracle9i, SQL Server, DB2

Management Tools: VSS, Autosys, Harvest, USD 60, Tivoli, Autosys, OC, CC

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

ETL Abinitio Engineer consultant

Responsibilities:

• Design and Development reusable utilities
• Involved in code migration from Informatica to Ab Initio and vice versa.
• Involved in AbInitio server builds and configurations.
• Hadoop BDA node configuration, and updating HIVE table.
• Handling large volume of data from various heterogeneous systems using Abinitio and Informatica.
• Enabled Capacity planning and storage Optimization framework.
• Co>op upgrades and server level patching activity.
• AbInitio code migrations and framework updates.
• Experience in building to AbInitio environment on AWS platform.
• Experience in Abinitio project migration from Legacy to AWS cloud platform.
• Troubleshooting user Issues related wif GDE, EME. DQE and Express>It
• Project creation and Sandbox Setups.
• CC, Express>IT, DQE, AG products application setup and configuration
• Server health checks monitoring.

Confidential, NC

Sr ETL AbInitio Consultant

Responsibilities:

• Involved in server AbInitio server builds and training setup for DQE and MDH
• OC, Express>IT, DQE, AG products application setup and configuration
• Meta data configuration
• Used Ab Initio for performing ETL by connecting to various sources like S3, Oracle DB and Unix.
• EME migrations and Restart operations
• Troubleshooting Access Related issues wif GDE, EME
• Project and Sandbox Setup
• Setup of AbInitio key alerts on teh server.
• Server health check monitoring and running delete scripts/adding files to ignore list
• Providing access to teh users and support teh SDLC process
• Key related issues.

Confidential, FL,

AbInitio ETL Administrator and support Analyst

Responsibilities:

• Involved in server migration of 20 AbInitio applications as AbInitio environment admin.
• Worked wif Citi architects to review and prepare build documents for new AbInitio servers (DEV, UAT, and PROD & COB).
• OC, ACE End to end setup of application setup and configuration
• EME Setup, project creation in EME, EME Groups/users and setting permissions
• EME Restart, Backup and Restore
• Data migration work from oracle to Postgres SQL.
• Troubleshooting Access Related issues wif GDE, EME
• Worked in creating EME repositories and configuring EME web interface.
• Project and Sandbox Setup
• Worked in automated server level monitoring scripts for AbInitio environment.
• Involved in conducting full COB test for all supported Applications.
• Patch release/Project release and migrations and common project checkouts.
• Adding user to tag group/Project EME
• Monitoring alerts and running delete scripts/adding files to ignore list
• Talend code migration and environment setup
• Providing access to teh users and support teh SDLC process
• Key related issues.
• Weekend on call activities and Checkouts after server reboots and patch upgrades.

Confidential, Chicago IL

AbInitio Development and support analyst

Responsibilities:

• Identify all XCOM processes/graphs dat are owned and maintained by AFT Integration. Gather all teh configuration profile and place them a single repository.
• Introduce Oracle tables dat hold teh configuration and access profiles.
• Preparation of Design, Code inspection, UTP documents.
• Convert teh existing AFT XCOM graphs to call teh AFT Common/Generic Bulk Transfer graph.
• Remediate AbInitio code to meet GPP, ISG changes to teh data directory and teh landing zone changes. Also internal standards like referencing all dbc files for teh AbInitio processes to AFT COMMON DB and removing teh Unicenter command lines in teh Allstate scripts.
• Testing and documentation of test results.
• Implementation in QA and production.

Environment: AbInitio (GDE V1.13. 1.14, Co>Op V2.13.1, V2-14-1), Oracle 9i, UNIX)

Confidential, Chicago IL

AbInitio Production Support

Responsibilities:

• Application Maintenance includes job monitoring and handling wif Aborts.
• Analyze issues and prepare technical specifications.
• Design and Development of AbInitio Graphs.
• Making teh necessary logic changes.
• Preparing Approach document, code inspection documents and test plan document.
• Doing Unit and Regression testing.
• Delivering teh quality deliverables wifin teh deadlines according client standards.
• Resolving teh issues based on teh priority.
• Preparation of Unit Test plans.
• Preparation of Audit log, Weekly and Monthly reports
• Peer Code reviews.
• Played Lead Role and effectively handled team from Onsite.

Environment: AbInitio (GDE V1.13. 1.14, Co>Op V2.13.1, V2-14-1), Oracle 9i, UNIX)

Confidential

AbInitio ETL Application testing

Responsibilities:

• Responsible for gathering requirements from Business Owners, SME and by analyzing application design document.
• Developed detailed Test Plan by analyzing requirements and created test cases per teh business processes.
• Responsible for creating Test Cases by analyzing Business requirements from Business/End users and stored in HP Quality Center
• Responsible for backend testing making sure teh data entered in teh front end is inserting into correct tables and columns using Oracle SQL Developer.
• Writing SQL queries in teh SQL developer client to retrieve particular data regarding teh RIMS Orders.
• Executing jobs from schedule and GDE process and verifying teh target data as per teh test case documents.
• Analyze and optimize teh ETL queries
• Coordinating wif teh developers and explaining for teh cause of teh defect.
• Re executing teh test once teh defect is fixed. Hence, Responsible for Regression Test.

Confidential

AbInitio ETL Application testing

Responsibilities:

• Responsible for creating Test Cases by analyzing Business requirements from Business/End users and stored in HP Quality Center
• Responsible for backend testing making sure teh data entered in teh front end is inserting into correct tables and columns using Oracle SQL Developer.
• Writing SQL queries in teh SQL developer client to retrieve particular data regarding teh RIMS Orders.
• Executing jobs from schedule and GDE process and verifying teh target data as per teh test case documents.
• Analyze and optimize teh ETL queries
• Coordinating wif teh developers and explaining for teh cause of teh defect.
• Re executing teh test once teh defect is fixed. Hence, Responsible for Regression Test.
• Functionality Testing Of Developed Reports.

Confidential,

Actuate developer

Responsibilities:

• Requirement analyses as per teh client specification.
• Created Grouped, Cross tab, Sequential and Parallel reports.
• Used multiple Input filters, Memory sorters to integrate teh data from different data sources Involved in Preparation of TDD (Technical Design).
• Involved in report Enhancements.
• Functionality Testing Of Developed Reports

Environment: Windows NT, Oracle 8, Actuate 7, Visual basic.