Abinitio Developer
Resume:
Galdin Densy Lam. D
adbf7y@r.postjobfree.com
Career Summary
Working as Abinitio Tech Lead with 11.5 years of experience in ETL tools Abinitio, Informatica, Unix & Sql.
Technically adept and confident software programmer with exceptional skills in coding and documentation.
Good knowledge of Data warehousing concepts and expertise in tools like Abinitio BRE, Profiler & Informatica and domain knowledge of MANTAS.
Had worked on code optimization in Abinitio and metaprogramming with PDL’s.
Had taken initiative in identifying the project requirements, analyzing business risk & project risk and evaluating the same with the team in team meetings.
Had taken responsibilities in analyzing, development, unit testing, integration testing and Production Support after release.
Had been involved in cordinating the release related activities like migrating the code across different environments and deployment tasks.
Have taken up training in Talend.
Work Profile
Cognizant Technology Services Sep’16 till date
oAs Senior Associate – Projects Sep’16 till date
oAs Associate – Projects Dec’11 to Aug 2014
Virtusa Polaris Aug ’14 till Aug '16
oAs Senior Consultant Aug ’14 till Mar ‘16
oAs Manager Mar ’16 till Aug '16
Oracle Financial Services Solutions Limited Aug’08 to Dec ‘11
oAs Associate Consultant Aug’08 to Sep ‘09
oAs Staff Consultant Oct ’09 to Dec ‘11
Academic Profile
POST GRADUATE DIPLOMA IN BUSINESS ADMINISTRATION [Finance]
Symbiosis Centre For Distance Learning-Pune
BACHELOR OF ENGINEERING [Computer Science] 70%
Anna University-Chennai
H.S.C 78%
Tamil Nadu State Board
Software Skills
Languages : Unix Shell Scripting, SQL
Operating System: Windows, Unix
Database: Oracle 9i, 10g, DB2, Teradata
Scheduler: Autosys, Mainframe, Control M
Tools: AbInitio GDE3.1.5, AbInitio BRE1.15.2.5, Putty
Data Profiler 1.15.2, Informatica 8.1,TOAD, Pl/Sql Developer
Certification
Level 1: Ab Initio certification (CCP)
Feb 2013
Level 1 : Banking & Financial Services(CCP)
Aug 2013
Oracle Finance Professional
Aug 2008
Project Summary
1
Project
:
Walgreens – Retail – Integrated System
Client
:
Walgreens US
Duration
:
Oct 2016 till date
Technology
:
Ab Initio 3.1.5, Oracle, Unix
Role
:
Abinitio Tech Lead
Description:
As part of this project, we were integrating certain vendors merged with Walgreens into the One Walgreens System and then publish the data to other systems.
· CPM – Consent Preference Manager is the program rolled out to get the consent from the customers and update their preferences as per the law of U.S.
· Intercom Plus (IC+) is the Pharmacy Management System used to manage and store patient profiles, medication histories, drug databases, insurance profiles, prescriber and contact information. The Intercom Plus system is used by Pharmacist and Technician.
Responsibilities:
Gathering inputs from the Business team, coordinating with the off shore team, clarifying their queries during the development phase.
After the completion of development, reviewing the code and validating the data as per the mapping document given by the business.
Migrating the code and coordinating the testing process with the testing team, tracking the defects and making changes accordingly.
Attending client meetings regularly for understanding the business requirements and sharing the same with the team when required.
2
Project
:
Optima Trading Book
Client
:
Citibank
Duration
:
Aug 2014 till July 2016
Technology
:
Ab Initio 3.1.5, Oracle, Unix, Autosys
Role
:
Abinitio Tech Lead
Description:
The purpose of this Project is to implement the Basel III standards as per the recent trendings in the Industry.
Responsibilities:
Gathering inputs from the Onsite team, and implementing the logic into Abinitio code.
After the completion of development, reviewing the code and validating the data as per the mapping requirements.
Migrating the code and coordinating the testing process with the testing team, tracking the defects and making changes accordingly.
Developed graphs to get the consent and preferences of the customers and update the database. Created separate programs for Loyalty customers to give them the special benefits.
Involved in the production deployment activities and provided KT to the production support team.
3
Project
:
CRR – SFD Management
Client
:
Keybank
Duration
:
Oct 2013 to Aug 2014
Technology
:
Ab Initio 3.04, Mainframe, DB2
Role
:
Onsite Tech Lead
Description:
The goal of this project is to load the Key Bank data into SFD (Shared Data Foundation) which is based on the industry standard model BDW (Banking Data Warehouse Model).The architecture of SFD Business View project has elected to use a target based approach. All source files are moved to a common format based on subject area then move the data to the target SFD.
Data from the sources are landed into a common structure that is somewhat denormalized but still looks similar to the end target of SFD. From this common structure, only one ETL Code logic is used to move the data to the final SFD. When a new source is introduced, only the source to common structure is created. The previous ETL code for posting to the SFD is reused.
The canonical model will be placed between the sources and the target SFD. ie, between the harmonized and staging layer. The goal is to standardize the load, data validation and error reporting process, independent of source system. The canonical tables will have all the target columns needed.
Responsibilities:
Discussing and understanding the business requirements from the Client and sharing the same with the off shore team .
Coordinating the development work and guiding the off shore team regarding the business requirements, mapping & code clarifications
Reviewing the ETL code and checking if the business logic has been properly implemented.
Scheduling the jobs through Mainframe scheduler and also verifying the output data both technically and functionally.
4
Project
:
TSYS Pop Credit
Client
:
Keybank
Duration
:
Jan 2013 till Oct 2013
Technology
:
Ab Initio 3.04, Mainframe, DB2
Role
:
Senior Developer
Description:
This Project is based on the conversion process of the Pop Credit Card System from the existing source CCA to TSYS. This included a process to load the TSYS data into the Keybank Enterprise Data warehouse (EDW) environment. We also created a sub process for the Customer Information Exchange (CIX) process to populate customer related data
Responsibilities:
Analyzed the scenarios and gave valuable technical inputs for the conversion process as per the business requirements.
Developed graphs and objects as per the requirements for the conversion.
Done the mapping changes for the conversion from CCA to TSYS source.
Was involved in Testing the Graphs through Mainframe scheduler and also verified the output data both technically and functionally.
Was involved in the history population process, tracking the output files and get the output data in the tables validated through LOB’s.
5
Project
:
AMEX Performance Engineering
Client
:
American Express
Duration
:
Dec 2011 to Jan 2013
Technology
:
Ab Initio 1.15.9, DB2
Role
:
Performance Analyst
Description:
The goal of this Project is to analyze and suggest the areas which can be improved to better the performance of the graphs which are already running in Production and also to reduce the execution time of the process to be completed.
Responsibilities:
Analyzed the scenarios and gave valuable technical inputs for improving the performance of graphs.
Modified the design of graphs to drop unwanted components which were taking longer time for execution.
Was involved in Testing the Graphs and plans by running automatic scripts using UNIX commands and also through front end in GDE.
Was involved in technical support to the client during & after the release into production and solved the production issues on time.
6
Project
:
SPIDER
Client
:
US CITI
Duration
:
Nov 2009 – Dec 2011
Technology
:
Ab Initio 1.15.9, Ab Initio BRE 1.15.2.5, Data Profiler 1.15.2, Pl/Sql Developer, Control M
Role
:
Senior Developer
Description:
The SPIDER (Securities Position, Interest Disclosure and Enterprise Reporting) application is being built to support the business need of having a single, systematically controlled source of complete and accurate equities and equity like position data for use by all regions/countries globally in order to accurately report on the firm’s Disclosure of Interest regulatory reporting requirements.
The SPIDER application will replace the currently legacy reporting application (Global Concentration Reporting – GCR) and will source position data from multiple sources in order to provide the business with a complete populations of position data globally and allow the business to produce reports to meet their country/regional regulatory reporting needs.
Responsibilities:
Analyzed the scenarios and gave valuable technical inputs for design of graphs as per the business requirements
Developed graphs as per the requirements and delivered objects (dml’s&xfr’s) into production to refine undulated data in the expected SPIDER and CDL forms.
Was involved in Testing the Graphs and plans by running automatic scripts using UNIX commands and also through front end in GDE.
Profiled data using Ab Initio Data Profiler to generate datasets.
Applied business rules using Ab Initio Business Rule Environment by developing rulesets and generated xfr’s.
Was involved in technical support to the client during & after the release into production and solved the production issues on time.
7
Project
:
GFTS DM AML Data Quality Controls
Client
:
US CITI
Duration
:
Jul 2009 – Nov 2009
Technology
:
Informatica7.1, SQL,Unix
Role
:
Junior Developer
Description:
GFTS Data Management intends to implement controls with the AML surveillance system at key data acquisition and transition points. Total Nine controls are designed for the AML surveillance .These control points will give rise to indicators on data integrity and quality contributing the effectiveness of the surveillance system. The controls are to be placed externally to support the existing setup and it will result in generation of reports for AML data quality improvement and for monitoring the passage of mandatory data elements properly through the surveillance system.
Responsibilities:
Developed scripts for generating reports from the controls
Designed the informatica mappings and workflows for report generation
Involved in unit testing which included all the interfaces and had done the validations.
Provided technical support for the client after the release.
8
Project
:
Mantas Offshore Support
Client
:
US CITI
Duration
:
Oct 2008 – Jun 2009
Technology
:
Informatica 7.1, SQL, Unix
Role
:
Junior Support
Description:
The purpose of this project is to upgrade the Mantas Anti Money Laundering monitoring tool to the most recent version to monitor the transactions.
As part of the implementation approach, business, in conjunction with the AML development team has made the following key decisions and assumptions:
oTransaction, party, reference and watch list data will be extracted directly from the AML Data Warehouse to populate the Mantas database.
Responsibilities:
Learnt the mantas process for running jobs using informatica.
Done the analyzing work for generating matches and alerts using informatica using the scenarios and to alter the datasets to make the data to generate matches.
Done documentation for the “Scenario Execution Process”
Accomplishments
Attended basic training on Ab Initio & Metadata HUB from Ab Initio Corp.
Won the “I-Appreciate” award during the year 2009-10.
Mentored the freshers and had given them Project Training.
Completed “Oracle Financial Professional” certification with merit.
Completed “BUSINESS ENGLISH CERTIFICATE” ( prelims ) with merit
Personal Details
Date of birth : April 18, 1987
Nationality : Indian
Passport No : S5859292
Visa type : H1 B
Contact this candidate