Ab initio Developer Resume Chicago, IL - Hire IT People

SUMMARY:

8 Years’ experience in IT industry strong data - warehouse and ETL - Abinitio background.
Excellent grasp on all Components of Ab Initio - GDE, EME,PSETS, PDL Programming with knowledge of Continuous Graphs and Conduct>IT (Plans).
Over 8 years of experience in system analysis, design, development, Support and maintenance of business applications in client/server technology.
5+ years of relevant work experience in analytics, data engineering, business intelligence.
Over 3 years of experience in Leading team (5-8 members) spared in multiple geography.
Extensive experience in Client Facing Role.
Over 6 years of experience in Insurance domain.
Over 2.5 years of experience in Banking Domain.
Extensive experience in managing and working with teams in offshore - onshore model.
Experience in client facing roles in US, process documentation, people management.
Worked in project extensively using Agile and SCRUM methodology.
Experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Ab Initio, Oracle, Teradata, Snowflake and Linux.
Experience in Production Support, Job monitoring, Scheduling jobs.
6 months of experience in Axiom tool, running workflows, setting up the environment.

TECHNICAL SKILLS:

Programming Languages: PL/SQL

Development Tools: Ab Initio

Schedular: Tivoli

RDBMS: Oracle, Teradata

Operating System: Unix

Design Tools: MS Visio

Version Control: GIT

Other Tools: Axiom

Methodology: Agile, SCRUM

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Ab initio Developer

Responsibilities:

Developer for the FDIC Part 370 solution at Discover to accurately calculate the deposit insurance of each beneficial owner of funds within 24 hours of the appointment of an FDIC receiver.
Created Ab Initio graphs to transform the input data and send to the downstream with Unix and Teradata as the DB.
Creation of Maestro jobs and scheduling them in Tivoli meeting the dependency criteria.
Involved in the ab initio migration activities, new database table creation, migration of tables to test and production.
To ensure the report is generated with till date data and all the records are successfully passed.
To create updated monthly reports.
To create test results after monthly production run and update and maintain the Axiom tool if any updates or changes come.
Worked as a Data Engineer and actively involved in development, enhancement and support of existing work and any new enhancements coming up. Co-ordinate with off-shore and on-shore team.
Co-coordinating with Client managers and Director for new and ongoing engagements.
Attend daily meetings with client and discuss all changes and issues.
Analyze functional and non-functional requirements.
Estimate total effort for any new enhancement.
Provide production support for existing applications.
Coordinate with end users to understand their issues and provide the solution.
Involved in Unit Testing.

Environment: Ab Initio, Unix, Teradata, SQL, Snowflake, Axiom

Confidential, Chicago, IL

Ab Initio Developer

Responsibilities:

The project aims at calculating and sending the premium and claims to downstream systems thus validating the amounts involved from financial systems.
The project is very complex in terms of business knowledge as it includes data from different sources.
Gained extensive knowledge of the data and the process related to Life Insurance business.
Leading the 5-member project team from a client location, understanding the requirements, working with project BA and SA to finalize design, distribute and manage work, code, unit test and deploy it within the decided timelines.
Improved the quality of the data drastically, fixed code related issues, set up a process of following up with source for incorrect/missing files, stabilized the process.
Worked as a developer and production support member of one of the projects along with 2 other team members. Worked on various Ab-Initio components such as Join, Rollup, Scan, Reformat, Partition by Key, round robin, gather, merge, Dedup sorted, etc.
Worked with the migration team and involved in validations.
Experienced in creating emergency change and handling issues in case of production failure.

Environment: Ab Initio, Unix, Oracle, SQL