We provide IT Staff Augmentation Services!

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.

Hire Now