We provide IT Staff Augmentation Services!

Sr. Ab Initio Developer Resume

San Francisco, CaliforniA

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.

Hire Now