PROFESSIONAL SUMMARY:

• 13 years of excellent IT industry experience in Operational, Data ware Housing & BI projects.
• Extensive experience in Analysis, Design, Development, and Testing & Implementation of various Data Ware housing Projects.
• Strong project development and Management skills focusing in providing end - to-end Data Warehousing & Business Intelligence solutions for various industry segments like Banking & Finance (Credit Cards, Commercial Leasing Business), Health care & Life sciences.
• Extensive experience working in DW ETL tool Ab-Initio GDE (3.2.3, 3.1.3/3.0.2/1.15/1.14.38/1.13.4 ), Co>Op (3.2.5, 3.1.1.2/3.0.5/2.15/ 2.14.107/2.13 ).
• Experienced in writing wrapper scripts using Korn shell scripting in UNIX and Linux.
• Designed and developed efficient error handling, Re-conciliation routines and implemented in various projects.
• Experienced in EME Admin activities for version controlling, Dependency Analysis and code migration.
• Experienced in scheduling the Abinitio jobs using MAESTRO & Autosys Schedulers.
• Extensive experience in DWH Dimensional Modeling (Star & Snow flake schemas).
• Experienced in RDBMS like Oracle and Teradata.
• Good knowledge in SQL and writing PL/SQL procedures.
• Worked extensively in Legacy to Ab Initio migration, Oracle to Teradata Migration and AIX UNIX to Linux Migration projects.
• Experienced in Performance testing, Load testing, benchmarking and Performance based redesign
• Experienced in Agile Methodology.
• Experienced in hands-on trouble shooting of live critical applications and SLA bound delivery.
• Experienced in leading/collaborating with large teams, client and vendor relationships simultaneously.
• Experienced in Competency building, and Technology training.
• Excellent communication, documentation and presentation skills.

TECHNICAL SKILLS:

DWH Tools: Ab Initio GDE (3.2.3.1, 3.1.3/3.0.2/1.15/1.14.38/1.13.4 ), Co>Op (3.2.5, 3.1.1.2/3.0.5/2.15/2.14.107/2.13 ), Informatica 9

Database: Oracle, Teradata

Database Tools: Toad, Teradata SQL Assistant, Oracle SQL Developer, SQL Navigator

Schedulers: Autosys, Maestro.

Version Control tools: GitHub, SVN (Sub Version)

Operating Systems: UNIX, Windows 95/98/2000/2003/ XP/Vista/Windows 7/10, Red Hat Linux.

Languages: Unix/Linux Shell Scripting, SQL, PL/SQL, Java, Java Scripts, JSP and HTML

Domain: Banking/Core Banking, Credit Cards, Health care & Life sciences

Solution: Product Implementation, System Integration & Management.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, California

Sr. Ab Initio Developer

Environment: (with skill versions)

Software: Ab Initio GDE 3.2.3.1,Co>Operating System 3.2.3.5, Red Hat Linux Release 6.9, Oracle (12.1.0), PL/SQL, Shell scripting, Perl, Version controlling tools GitHub & SVN

Responsibilities:

• Actively involved in all the phases during the entire life cycle of the Ab Initio Migration project (right from Ab Initio GDE & Co>Op License procurement, Environment setup to production implementation).
• Involved in Reverse engineering of existing PL/SQL, Java spring batch jobs to understand the current system landscape.
• Involved in segregating the existing jobs into 4 different types based on their functionality (Alerts which are Non-subscription based, Subscription based, Non subscription based with Web service calls, Non-subscription & Subscription based with Web service calls).
• Involved in Design & Development of Ab Initio Reusable and
• Extensively used components like Meta pivot, XML Combine etc., to generate the name-value pair Normalized XMLs.
• Built graphs to perform web service calls using Internet Web service component “Call SOAP HTTP Service UTF8” by enabling concurrent HTTP requests for faster performance.
• Developed several Linked sub-graphs, which can be reused in multiple parent graphs.
• Worked closely with Ab Initio support in optimizing\tuning the graphs for better performance.
• Worked on POC for Encryption & Decryption of Ab Initio created MFS files using “AES Encrypt” & “AES Decrypt” components.
• Involved in writing the file watcher scripts using Perl scripting.
• Involved in Requirement analysis and breaking down the requirement and providing the estimates for various projects.
• Extensively worked on project documentation (FSDs, TDDs, Staging & Production Implementation Game plans, Release Game plans etc.,).
• Worked closely with testing teams (SIT, QA, Performance testing) in reviewing the test plans and test cases and also during the defect resolution.
• Widely appreciated by client management for successful completion of Ab Initio migration with zero post production implementation issues and also with 90% improvement in the performance when compared to legacy.
• Developed SQL scripts for data validations.
• Participated in regular project status meetings & Defect triage meetings.

Confidential, South SFO, California

ETL Lead

Environment: ; (with skill versions)

Software; Languages: PL/SQL, UNIX shell scripting, Linux, AbInitio GDE 3.1.3, 3.0.2/1.15.9, Co>Operating System 3.1.1.2, 3.0.5/2.15.7.11 (release 2.15 update 7 patch level 11), Informatica 9, AIX UNIX 5.2, Oracle, Teradata

Responsibilities:

• Involved in end-to-end development of Confidential project - Certification Reports, Potential Duplicate reports, Known Duplicate reports, Un-stewarded reports & CMS (Center for Medicare & Medicaid services) reports.
• Involved in Designing the ETL process flow/framework of the project which includes key features like Re-start ability, Change detection capture, Meta data logging, Error logging & handling, Re-conciliation and handling of multiple source formats (XML, flat files and Data bases).
• Involved in development of Re-usable and customizable components.
• Involved in writing the file watcher scripts in UNIX.
• Involved in Requirement analysis and breaking down the requirement and providing the estimates for the project.
• Creating Technical Design Document for the project.
• Developed graphs for batch processing.
• Developed Unit test cases extensively to avoid QA testing defects.
• Lead the offshore team in delivery at an almost inexistent defect count. Widely appreciated by both client and organization management.
• Responsible for Coordination with DA and QA (Quality Analyst) teams in UAT (User Acceptance testing) and Production support\ETL Admin teams in code migration to Production environment.
• Developed SQL scripts for data validations.
• Execute batch processing and verify the jobs status and data in database tables as part of Unit testing.
• Tracking the defects in HP Quality Centre 9.5/10.0, HP ALM.
• Participated in regular project status meetings & Defect triage meetings.
• Served as vSPOC (Vendor Single point of contact) for Confidential project in Confidential .

Confidential, Irving, TX

Project Lead

Environment: (with skill versions)

Software; Languages: PL/SQL, UNIX shell scripting, Linux AbInitio GDE 3.1.3, 3.0.2/1.15.9, Co>Operating System 3.1.1.2, 3.0.5/2.15.7.11 (release 2.15 update 7 patch level 11), AIX UNIX 5.2, Oracle, Teradata

Responsibilities:

• Worked extensively in DWH ETL - Oracle to Teradata Migration, and AIX to Linux Migration projects.
• Breaking down the requirement and providing the estimates for the project.
• Designing the solution for the requirements.
• Creating Technical Design Document for the project
• Designing the architecture flow of the project with 3 interfaces of Java, TIBCO and ETL
• Developed the code with latest Ab Initio features of Continuous flows, Data profiling, compressed lookups, XML utilities & components.
• Implemented advanced component folding techniques for reducing memory utilization which was appreciated by client.
• Developed graphs for batch processing.
• Designed and developed Ab Initio custom components.
• Developed Unit test cases extensively to avoid QA testing defects.
• Developed/wrote regular expressions to cleanse/standardize the data.
• Used USPS Address Matching System API for correcting the Customer Addresses.
• Lead the offshore team in delivery at an almost inexistent defect count. Widely appreciated by both client and organization management.
• Responsible for Coordination with DA and QA (Quality Analyst) team in UAT (User Acceptance testing). And Production support team in code migration to Production environment.

Confidential

Team Lead

Environment: (with skill versions)

Software: AbInitio(GDE1.14,Co>operatingSystem2.14),Unix,Oracle NDM(Network Data Mover),SQL Navigator 5.1.0

Responsibilities:

• Creating Technical Design Document for the project.
• Designing the architecture flow of the project.
• Designing high performance ETL and Data Warehousing solutions.
• Developed 3 Interfaces Promise, Payment and Reviews & Contacts.
• Improved the performance of Ab Initio graphs by using Lookups, Max-core, In-Memory Joins and parallelism techniques for maximum usage of cache memory. And also used Check pointing and phasing to improve reliability of the application.
• Developed Unit test cases extensively to avoid QA testing defects.
• Co-ordinate with Production Support team in code migration and provided technical support in post-production implementation.