We provide IT Staff Augmentation Services!

Lead Developer Resume

SUMMARY

  • 8 Years of experience in the Software Development Life Cycle (SDLC) that includes expertise in the Analysis, Design, Development, Implementation, Testing and Data Warehousing using ETL tools like Informatica, SSIS
  • Experience in developing ETL applications using SSIS and Informatica.
  • Extensive experience in creating SSIS Packages, Informatica Mappings and Workflows.
  • Experience working with various heterogeneous source systems such as Oracle, DB2, SQL Server, MySQL, XML files and flat files.
  • Performed ETL performance tuning of the sources, targets, transformations, mappings, workflows and sessions to resolve or remove the bottlenecks.
  • Sound knowledge of Oracle, MySQL Database, Data Warehousing Concepts and SQL.
  • Creating SSRS RDL Reports.
  • Experience in writing Unix Scripts.
  • Creating test cases and unit testing of developed component.
  • Conversant with all phase of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
  • Understanding the design document and analysing the business process requirements.
  • Providing support for user acceptance testing.
  • Code base lining and versioning using various tools like Tortoise SVN and GitHub.
  • Active involvement in the code deployment process across all testing, production and BCP environments.
  • Providing post - implementation, maintenance and enhancement support.
  • Working with the Amazon Web Services infrastructure setup.

TECHNICAL SKILLS

RDBMS: Oracle 10g, MySQL, SQL Server

Languages: SQL, C++, C, UNIX Scripting

ETL Tools: Informatica Power Center and SSIS

Additional Skills: Thorough understanding on Amazon Web Services, Micro-Strategy

PROFESSIONAL EXPERIENCE

Confidential

Lead Developer

Environment: SQL Server, SSIS, Flat files, SQL Developer, SSRS

Responsibilities:

  • Understanding the business requirements.
  • Analyze the requirements and bridge the gaps if any.
  • Prepare the database design and document the same.
  • Review the design document.
  • Design and Develop the code based on the requirements.
  • Migrate the existing data to the new system for a seamless transition.
  • Support unit and integration testing of all the modules.
  • Support deployment and post deployment activities.

Confidential

Lead Developer

Environment: SQL Server, MySQL, SSIS, Flat files, SQL Developer, AWS

Responsibilities:

  • Understanding the business requirements.
  • Analyze the requirements and bridge the gaps if any.
  • Review the design document.
  • Design and Develop the code per the requirements.
  • Setting up the infrastructure in the cloud for lower environments using Amazon Web Services.
  • Create test data adhering to business requirements using T-SQL.
  • Create various DB related activities like Cold Backups, Replication etc. for MySQL Database.

Confidential

Lead Developer

Environment: Oracle 10g, Informatica Power Center9.5, Unix, Flatfiles, SQL Developer, Serena Business Manager, HP-QC, Tortoise SVN, Autosys.

Responsibilities:

  • Requirement gathering from the Business Analysts and End user.
  • Analyze the requirements provided and bridge the gaps and review the design document.
  • Design and Develop the code per the requirements with in tight timelines.
  • Maintain and create Unit test case documents.
  • Interact with the downstream and upstream partners to fulfill the ad-hoc needs.
  • Support SIT Testing and UAT Testing.
  • Deployment of code to the higher environments.
  • Handling Infrastructure requests based on the environment usage and working with DBA’s to keep a track of overall application performance and request for scaling the resources based on the needs.

Confidential

Lead ETL Developer

Environment: Oracle 10g, Informatica Power Center9.5, Unix, Flatfiles, SQL Developer, Serena Business Manager, HP-QC, Tortoise SVN.

Responsibilities:

  • Creating a high level design by working in tandem with finance team to understand the requirements.
  • Gathering and analyzing business requirements from the business and recommending design changes.
  • Identifying the key constrains of the Legacy systems and providing a solution for those as part of new system being developed.
  • Develop and maintain SDS as per the business requirements and the PRD proposed by the business.
  • Prepare and maintain process flow diagrams to identify the dependencies (upstream/downstream) of the new system being developed.
  • Coordinating with the offshore team on daily basis and assigning them tasks to ensure that the business requirements are coded properly.
  • Formulating low level design to enable offshore team to convert business requirements into a workable solution.
  • Involved in Unix Scripting for basic operations like File FTP, Archival, merging of many files to one.
  • Peer review the code developed by offshore team and recommend the changes.
  • Analyzing the interdependency of various systems and the new system to help the business user in creating an appropriate job schedule.
  • Handling change requests for the existing mappings.
  • Deployment to of code to various environments like SIT, UAT and Prod.

Confidential

Lead ETL Developer

Environment: Oracle 10g, Informatica Power Center9.5, Unix, Flat files, XML Files, Excel Files(xls), SQL Developer, Serena Business Manager, HP-QC, Tortoise SVN.

Responsibilities:

  • Creating a high level design by working in tandem with system architects to create an application that is robust and scalable.
  • Gathering and analyzing business requirements from the business and recommending design changes.
  • Involved in peer review of the design document and recommend changes.
  • Develop Informatica mappings as per the design document and also analyze the scenarios on ad-hoc requests and recommending a solution.
  • Coordinating with the offshore team on daily basis and assigning them tasks to ensure that the business requirements are coded properly.
  • Formulating low level design to enable offshore team to convert business requirements into a workable solution.
  • Understanding the granularity of data required for different XML targets, recommending the XSD changes to the business and extensively working for key generation to produce XML outputs.
  • Involved in Unix Scripting for basic operations like File FTP, Archival, merging of many files to one.
  • Peer review the code developed by offshore team and recommend the changes.
  • Analyzing the interdependency of various systems and the new system to help the business user in creating an appropriate job schedule.
  • Handling change requests for the existing mappings.
  • Deployment to of code to various environments like SIT, UAT and Prod.

Hire Now