We provide IT Staff Augmentation Services!

Programmer Analyst Resume

PROFESSIONAL SUMMARY:

  • 11+ years of progressive IT experience in development and design of ETL methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica PowerCenter, Confidential and Confidential Studio.
  • Worked on all phases of data warehouse - ETL lifecycle, from gathering requirements to implementation, testing and support.
  • As a member of Corporate Data Management Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
  • Continually research the information technology marketplace for new and innovative technologies and application development practices. Proactively propose these new technologies as solutions to business problems.
  • Extensive experience in designing and development of mappings, transformation standards and processes using Informatica Power Center and Informatica Developer.
  • Extracted data from various sources like Oracle, Sybase, API’ Confidential, Flat files and XML files with knowledge of Data Warehouse concepts.
  • Experience in working on Unix Shell Scripts.
  • Good understanding between OLTP and OLAP systems.
  • Knowledge in Oracle - SQL, PL/SQL and Sybase and with knowledge in capital markets and insurance domain.
  • Documentation as per the client requirement.
  • Ability to quickly grasp new concepts, both technical and business related and utilize as needed.
  • Extensive experience in software development lifecycle and adept in software coding standards.
  • Excellent interpersonal, analytical and communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 6.x/7.x/8.x/9.x,Informatica Data Quality ( Confidential ) Tool, Informatica Confidential Studio Tool.

Programming Languages: UNIX Scripting

RDBMS: Oracle, Sybase, MS -Access

Scheduling Tools: Crontab, Autosys

Languages: SQL, PL/SQL, XML

Tools: Toad, Rapid SQL, HP ALM Quality Central

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

  • Analyzed the business requirement gathered from the client.
  • Understanding the architecture of the project and the data model.
  • Involved in creating the mappings for applying the business rules and loading them into the respective tables.
  • Involved in creating mapplets for YoY calculations and derived calculations.
  • Working on calling the web service API’ Confidential using web service transformation and HTTPS transformation and loading the data into stage tables.
  • Involved in Unit Testing the Code.
  • Bug Fixing of the associated mapping (if any).
  • Extensively used mapping parameters, workflow parameters and parameter files.
  • Working on calling the web service API’ Confidential using web service consumer, HTTPS transformation and loading the data into stage tables.
  • Day to day coordinating between onsite and offshore from offshore.
  • Ensure quality of deliverables by following predefined standards.

Environment: Informatica 9.6/10.1, Oracle 11, UNIX Shell Programming

Confidential

Lead Developer

Responsibilities:

  • Analyzed the business requirement gathered from the client.
  • Understood the requirements and designed the ETL process.
  • Created mapping specifications and Designed the mappings
  • Sending weekly status report and MSR.
  • Discussion with client to clarify issues

Confidential

Lead Developer

Responsibilities:

  • Tested sample parsers in Windows and compare both versions output for Windows
  • Tested sample parsers in Windows and compare both versions output for UNIX
  • Tested by using cm console and compare both versions output in UNIX
  • Used Informatica UDO transformation to test and compare both versions output in UNIX.
  • Changed CRISIL application to use the new UNIX server and setup the Production Environment.
  • Migrated old parsers history to the new environment.

Environment: Informatica 9.0.1/9.1.0 , UNIX, Oracle 10g, Informatica B2B Data Exchange, Informatica Data Quality ( Confidential ) Tool

Confidential

Senior Developer

Responsibilities:

  • Understanding the architecture of the project and the data model.
  • Involved in creating the mappings for loading the Static and performance data from the Staging tables, applying the business rules and loading them into the respective tables.
  • Involved in creating the mappings for performing the validations on the data based on the severity and rising exceptions.
  • Involved in creating common mapplets for loading the Static data for different source systems.
  • Involved in Unit Testing the Code.
  • Bug Fixing of the associated mapping (if any).
  • Extensively used mapping parameters, workflow parameters and parameter files.
  • Day to day coordinating between onsite and offshore from offshore.
  • Ensure quality of deliverables by following predefined standards.

Environment: Informatica 9.1, Oracle 9i, UNIX Shell Programming

Confidential

Senior Developer

Responsibilities:

  • Understanding the architecture of the project and the data model.
  • Involved in creating the mappings for loading the translation tables (Asset Sub Asset Translation, BEGIN END PERIOD Translation etc.)
  • Involved in bringing the ratings data from the Fact and the different Dimensional tables in RRDW (Ratings Reporting Data Ware House) into the Staging Table.
  • Involved in creating the mappings for generating the Statistics Reports.
  • Used transformations like Source Qualifier, Router, Normalizer, Connected and Unconnected lookups, Filter, Sorter and Sequence to handle situations depending upon the requirement.
  • Involved in Unit Testing the Code.
  • Bug Fixing of the associated mapping (if any).
  • Involved in tuning the mappings and testing the same.
  • Worked on creating the UNIX scripts for running the process, generating the parameter file and for different email notifications.
  • Involved in creating High Level Design Document.

Environment: Informatica 9.1, Oracle 9i, Erwin, UNIX Shell Programming

Confidential

Senior Developer

Responsibilities:

  • Analyzed the business requirement gathered from the client.
  • Understood the requirements and designed the ETL process.
  • Created mapping specifications and designed the mappings
  • Creating Source Definitions, Target Definitions, Transformations and Mappings by using Informatica 8.6 Power Center Designer
  • Worked on XSD, XML Target, XML Parser, XML Generator and SQL Transformations
  • Generate the XML target files based on number of issuers
  • Tuned mappings for better performance
  • Creating the UNIX shell scripts to run the workflows
  • Creating unit test cases, executing the same
  • Sending weekly status report
  • Held discussions with client to clarify issues

Environment: Informatica 8.6.1, Windows XP, Oracle 10g, XBRL.

Confidential

Senior Developer

Responsibilities:

  • As a Senior Developer, responsible for analyzing the data and discussing with Onsite Business Analyst concerns if any.
  • Day to day coordinating between onsite and offshore from offshore.
  • Involved in Developing mappings and workflows for different Dimensions and Fact Table loading.
  • Used transformations like Source Qualifier, Router and Connected and Unconnected lookups, Filter, Sorter & Sequence to handle situations depending upon the requirement.
  • Ensure quality of deliverables by following predefined standards and templates.
  • Code review of Power Centre mapping/Workflow.
  • Involved in Unit Testing the Code.
  • Bug Fixing of the associated mapping (if any).
  • Extensively used mapping parameters, workflow parameters and parameter files.
  • Worked on UNIX scripts and able to write basic scripts.

Environment: Informatica 9.1, Oracle 10g, Erwin, UNIX Shell Programming.

Confidential

Senior Developer

Responsibilities:

  • Involved in implementation of the elevation logic as per the Business requirement.
  • Created, updated and maintained ETL technical documentation.
  • Review on-going and proposed projects to identify opportunities for reuse, process improvement.
  • Involved in Open Enrollment or Annual Enrollment (It’ Confidential that phase of business where in lot of change requests and updates roll on in Insurance benefits for the Employees).
  • Creating of mappings, workflows.
  • Used transformations like Source Qualifier, joiner and Connected and Unconnected lookups, Filter, Sorter & Sequence to develop mappings based upon the requirement.
  • Written SQL overrides in source Qualifier according to business requirements.
  • Ensure quality of deliverables by following predefined standards and templates.
  • Day to day coordinating between onsite and offshore from offshore.
  • Code review of Power Centre mapping/Workflow.
  • Bug Fixing of the associated mapping (if any).
  • Extensively used mapping parameters, workflow parameters for common mapping.
  • Involved in migration of the approved code to UAT and Production environments.
  • Involved on preparing mainframe jobs and schedule chart.
  • Scheduling the process to run weekly.
  • Prepare process documents to stream line the process.

Environment: Informatica 7.1/8.1, Sybase, Mainframe, UNIX Shell Programming.

Hire Now