EXPERIENCE SUMMARY:

• Over 8 years of experience in the field of IT Industry.
• Experience in full life cycle of Software Engineering including design, implementation, testing and maintenance.
• Strong technical and development expertise in Informatica Power Center, Infomatica Data Quality, Oracle SQL, Oracle PL/SQL, UNIX Shell scripting applied predominantly in Health care, Auto finance, Telecom domain as well as Pharmaceutical Sector.
• Worked in Agile SCRUM development methodology.
• Worked on tools like Informatica Power center, IDQ, Tivoli Workload Scheduler, Toad, Aqua data studio, SQL developer.
• Strong analytical and development skills.
• Thrives in challenging environments with an aptitude for learning and applying new technologies.

TECHNICAL SKILLS:

Data warehousing: Data warehousing concepts

Methodologies: Software Development Life cycle (SDLC) and Agile SRUM Methodology

ETL Tool: Informatica power center 8.6.1/9.1.1 , 9.5.1,9.6. IDQ 9.1

RDBMS: Oracle 9i, Oracle 10g, Oracle 11g/12c, SQL SERVER 2005

Other tools: Toad, SQL Developer, Tivoli workload scheduler, Aqua data studio, Winscp, HPSM, Remedy, Putty.

Configuration Management tools: VSS

Generic tools: MS Word, MS Excel, PowerPoint, MS Excel

Operating System: Windows XP/7/Unix

BUSINESS SKILLS:

• Business Process Analysis & Research
• Technical Requirements Development
• Requirements Gathering
• Change management (CCR)
• Gap Analysis and Impact analysis

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Informatica Developer/Technology Lead

Responsibilities:

• Tuning the long running Informatica Workflows.
• Worked on Database of size 45TB and tables with more than 500 million records.
• Extensively used SQL, PL/SQL in writing Stored Procedures for complex scenarios like master record creation.
• Created/modified database objects like tables, views, materialized views, procedures.
• Strong in Unix shell scripting, created complex generalized scripts for processing files based on the command line input. Added logging and lock mechanism as well in the scripts.
• Job monitoring and defect fixing.
• Enhancement of existing Informatica mappings and Development of new Informatica Mappings.
• Worked on Standardizer, labeler, Address validator and Consolidation transformations in IDQ.
• Extensively used Unix Command like AWK, SED, GREP.
• Worked closely with Customer and multiple vendors for carrying out day to day business activities and worked on the solutions to some of the complex business requirements/issues.
• Expertise in Root cause analysis and necessary Test plans to ensure successful execution of the data load Process
• Understanding Reporting queries written in SAS and doing root cause analysis.
• Modified existing Unix Scripts to reduce log size.
• Fixing the data issues business is facing in the data warehouse.
• Impact analysis for changes that are happening on the existing/new tables.
• Gatekeeper role for new changes that are moved into production.
• Worked on Incident, problem tickets and Change management.
• War - room support for Post Go-Live support activities.
• Mentored new developers on the business and technical aspects of the project to enable them complete their modules successfully.

Environment: Informatica power center 9.1.1/9.6.1 , IDQ 9.1, Oracle 11g/12c, HPSM, Tivoli workload scheduler, Aqua data studio, Toad, ITG, UNIX

Confidential, Irvine, CA

Informatica Architect /EDW Developer

Responsibilities:

• Designing business requirement documents by analysing the existing EDW mappings and procedures.
• Creation of High level and Low level design documents.
• Creation of data warehouse depending on the new tables in new ERP system.
• Worked on Agile SCRUM methodology to design ETL mappings to load data from staging layer to data mart layer using Informatica Power Center.
• Created complete control framework for incremental data load including parameter file creation and exception handling .
• Created stored procedures to delete the target records in case of more updates and do insert append to improve the performance.
• Used parallel and full hints, indexing and other ways to tune the SQL queries.
• Loading data into derived facts and transaction based facts.
• Created Unix Scripts to alter files as per our requirement.
• Experience in calling Informatica jobs from Unix Scripts by using PMCMD commands .
• Loading data into SCD type 1 &2 dimensions.
• Working with SAP R3 connectors to get the data from SAP and creating ABAP program for the mapping.
• Unit testing my ETL’s.
• Creation of deployment group for moving the workflows from lower environments to higher.
• Created indexe s on the tables for faster retrieval of the data to enhance database performance.
• Review project/task statuses/issues with the team and ensuring completion of project on time.
• Created/modified database objects like tables, views, materialized views, procedures.
• Mentored new developers on the business and technical aspects of the project to enable them complete their modules successfully.

Environment: Informatica power center 9.5.1, SAP R3 connectors, Oracle 10g, SQL Developer, Toad, UNIX, Putty, Control M, Erwin.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Creating mappings Using complex logics in Informatica Tool to populate promote or demote notification for a partner by using their competencies.
• Extensively worked on Unix shell scripting.
• Worked with email, command tasks, Mapplets, Reusable Transformations and worklets.
• Performed Unit testing, system testing and regression testing.
• Work closely with Customer and multiple vendors for carrying out day to day business activities and working on the solutions to some of the complex business requirements.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Developed materialized views for data replication in distributed environments
• Used SQL LOADER to load data from files into testing environments.
• Involved in Performance tuning at source, target, mappings, sessions level.
• Scheduling workflows through Workflow scheduler.

Environment: Informatica power center 8.6.1, Oracle 10g, Toad, UNIX, Putty.

Confidential, Indianapolis, IN

SQL Developer

Responsibilities:

• Creation of Live reports and web reports .
• Migration of new data into the tool.
• Troubleshooting the issues faced by users.
• Tool administration.
• Folder creation and group creation.

Environment: Livelink, SQL SERVER 2005, Visual source safe

Confidential

Software Developer

Responsibilities:

• Gathering different requirements that need to be considered while evaluating the Customer.
• Developing the code using java.
• Creation of SQL scripts to load data into tables.
• Creation of PPT’s to explain the process.
• Unit testing.

Environment: Java, Tomcat, SQL