Sr. Developer/Lead Resume

SUMMARY:

Over 6 years of experience in Data Warehousing and Confidential in financial services domain.
Experience in full system development lifecycle including designing, developing, implementing, testing and maintenance
Expertise in concepts of Data Warehousing, Data Marts, Dimensional modeling, Fact and Dimensional tables and developing transformations between source and target using Ab Initio
Well versed with Ab Initio components of Partition, De - partition, Database, Datasets, Transform, FTP, Sort and Miscellaneous
Proficient with various Ab Initio parallelism techniques with experience of implementing Ab Initio graphs using Data parallelism and Multi File System (MFS) techniques
Excellent programming skills with ability to automate routine tasks using UNIX shell scripting , sound experience in SQL
Experience in creating the data lineage using Ab Initio EME
Worked on the automation of ETL jobs using Autosys and Tivoli Workload Scheduler

SKILLS:

ETL Tools : Ab Initio GDE ver. 3.0, 3.2, Co>Op sys 2.15, 3.2

Database: Teradata, Oracle, MS Access

Operating Systems: Windows XP, Unix, Linux

Scheduler: Tivoli Workload Scheduler, Autosys

Languages: PL/SQL, SQL, Shell Script

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Developer/Lead

Environment: Ab Initio, UNIX, Oracle SQL Developer, Autosys

Responsibilities:

Coordinated with the geographically diverse development teams to gather the requirements of the project
Prioritized the tasks and distributed them among the team members
Led a team of three people to optimize the existing code over 20% while migrating the data
Collaborated with the development/testing teams to carry out unit testing and integration testing
Performed data validation testing writing SQL queries

Confidential

Sr. Developer

Environment: Ab Initio, UNIX, Oracle SQL Developer, Autosys

Responsibilities:

Upgraded nearly 40 Ab Initio graphs to 3.2 Co>Op version
Involved in Functionality testing, Regression testing and User Acceptance Testing
Documented the issues related to data discrepancy and other bugs exposed because of the upgradation
Validated the data after testing the migrated code

Confidential

Programmer Analyst

Environment: Ab Initio, UNIX, Teradata, Tivoli Workload Scheduler

Responsibilities:

Lead a team of three people to carry out design and impact analysis. The work involved
Creation of the source to target mapping document by working with the business.
Data profiling to check the data quality issues such as duplication, lack of accuracy and incompleteness
Development of Ab Initio graphs with data manipulation logic including the join, rollup, reformat and scan components
As a lead developer, I was responsible for the design and analyzed the impact
Worked with other developers to help them understand the design and performed code review for their applications
Created the data quality setup for the applications
Worked on reviewing the test cases, test plans, test data ensuring accurate coverage of requirements and business processes
Scheduled the jobs using Tivoli Workload Scheduler and checked for the correct execution of the interdependent jobs
Checked in the Ab Initio graphs n the EME and created data lineage
Drove sprint sessions facilitating the user acceptance testing and the code changes implementation

Confidential

Developer

Environment: Ab Initio, Teradata, UNIX

Responsibilities:

Generated a list of merchants that do not accept Discover Card to be targeted on a monthly basis
Created an automated process to load the disposition data received from the marketing campaigns in the data marts
Generated weekly files containing the list of merchants that have started accepting the Discover Card and the list of merchants that should not be targeted in the further campaigns
Created monthly reports that provided the count of targeted, active and tested merchants along with merchant activation rate in respective direct marketing area
Also worked on generating monthly reports for the business that included details regarding the merchant performance
Provided expert resolution to technical/functional problem being a Subject Matter Expert for the application

Confidential

Developer

Environment: Ab Initio, UNIX, Teradata, Tivoli Workload Scheduler

Responsibilities:

Analyzed business needs to document functional and technical specifications per business requirements
Constructed the ETL code using the Ab Initio GDE which involved reading the EBCIDIC, Flat files and applying complex transformations on them to load to the target tables
Analyzed merchant data to generate reports useful in deciding the marketing strategy to increase the merchant acceptance
Created SAS scripts to automate the process of fuzzy matching used for checking the acceptance of the Discover card at merchant locations
Executed complex SQL queries within UNIX shell scripts
Ran adhocs to pull data from the Discover Data Warehouse and the data marts.