SUMMARY

• Well versed in ETL tools/utilities like Informatica Power Center 9.0.1/8.6.1/8.1, SQL Server 2000 DTS and reporting tools Business Objects XIR2.
• Extensively experienced with RDBMS skills in Oracle (6+ years), SQL Server (3+ years). Good experience with UNIX Shell scripting (6+ years).
• Excellent Batch scheduling (3+ Years) experience using tools like CA Autosys.
• Expertise in Data warehousing, Data migration and Data Integration projects as ETL Solution Architect, DW Lead and ETL Developer.
• Data modeling knowledge using Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables.
• Worked on onshore - offshore team model as well as co-coordinating team from different geographical region.
• Functional requirement analysis and specification reviews with Business Groups and stake holders.
• Design Technical specifications as well as reporting specifications and data mapping.
• Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Worked with heterogeneous source systems like Flat files, xml files, Oracle, SQL Server, MS Access.
• Proficient in designing and developing the various transformation logics by utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy, java.
• Experience in Oracle PL/SQL programming (Writing Complex queries, Package, Store Procedure, Function, Trigger, View, Materialized views, Index), T-SQL and SQL Server scripting.
• Proficient in writing UNIX shell scripting using Korn shell, AWK, SED.
• Expert in tuning the performance of SQL queries and ETL process.
• Technical hands-on expertise using OLAP tool Business Objects XIR2 (Reports, Designer, InfoView) Qlikview.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0.1/8.6.1/8.1/7.0, SQL Server 2000 DTS, sql server 2008 Integration services

RDBMS: Oracle 11g, 10g (PL SQL), SQL-Server 2000, Big data

Reporting tools: Business Objects XIR2 (Web Intelligence, Crystal Report), Crystal Report 7, Hands on Qlikview

SQL Tools: SQL Navigator, Toad, SQL Developer, SQL Enterprise Manager

Scripting: Unix Shell scripting (Korn Shell), AWK, Perl, VBA, Putty, xml

Batch Scheduling Tool: CA Autosys, scheduling ETL using UNIX shell scripting.

Version Control: Sub version

Hardware/OS: Windows XP/2000/7/NT 4.0, Linux

Data modeli: HP Quality center

PROFESSIONAL EXPERIENCE

Confidential

Module Lead

Responsibilities:

• Gathering requirements, suggest the various design approaches to clients
• Working with offshore team for delivering various code releases,
• Unit testing of each module & UTCs, review the offshore team work
• Automation work for ETLintegration. Dothe planning and estimation for various code releases,
• Handle code migration in dev, uat, prod environments
• Implemented various new batch processes. Analysis, design and development of the oracle procedures as well as Unix shell scripts.
• Developed stored procedures to be used as a source to the reporting interface. Designed and developed report layouts using Seagate crystal report. Debuggingissues related application developed using VBA macro
• Developed Oracle PL/SQL Packages, Stored procedures, Functions, Triggers, Views
• Loaded files into database using SQL Loader utilities.
• Developed UNIX shell scripts using korn shell to execute Oracle packages and SQL Loader.
• Knowledge Acquisition Report developed in application using Qlikview visualization tool.
• Debugging & develop SSIS packages using sql server integration services
• Sql server jobs setup & debugging of issues in jobs.
• Adding new enhacemens,fixing issues in business objects reports
• Maintain code versions using SVN subversion, creating data flow diagrams using Microsoft visio
• Post production support after application migrations

Senior ETL Developer / Project Lead

Confidential

Responsibilities:

• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Co-ordination with offshore for design discussions, code review and mentoring.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank and Update Strategy.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during SIT, UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Design and develop Oracle package, procedure, function, trigger and views to process data from UI and produce the files in desired layouts. Perform Code review and unit testing at various levels of the ETL, Support IST cycles
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment through deployment groups
• Integration of Unix Korn shell with Informatica PMCMD command utilities.

Senior ETL Developer / Project Lead

Confidential

Responsibilities:

• Managed requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Co-ordination with offshore for design discussions, code review and mentoring.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during SIT, UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Design and develop Oracle package, procedure, function, trigger and views to process data from UI and produce the files in desired layouts. Developed UT packages for the respective database objects.
• Perform Code review and unit testing at various levels of the ETL, Support IST cycles
• Integration of Unix Korn shell with Informatica PMCMD command utilities.
• Design and develop batches in Unix shell scripts that would use the Oracle package and generate files in the application file systems.

Confidential

ETL Offshore developer

Responsibilities:

• Functional analysis, requirement management and co-ordination with technical teams and business partners.
• Data analysis and modeling, discussions with Data Architect.
• Team co-ordination for design discussions, code review and mentoring.
• Developed Real time ETL mapping for xml import
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Design and develop Oracle package, procedure, function, trigger and views to process data from UI and produce the files in desired layouts. Developed UT packages for the respective database objects.
• Perform Code review and unit testing at various levels of the ETL.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix Korn shell with Informatica PMCMD command utilities.
• Design and develop batches in Unix shell scripts that would use the Oracle package and generate files in the application file systems.
• Design and develop CA utility scripts to schedule overnight batch streams that would use the Unix KSH.

Confidential

ETL Offshore developer

Responsibilities:

• Led requirements and design phase towards identifying mutually agreed solutions with technical teams and business partners.
• Functional analysis with business group and preparing technical design specifications for ETL components.
• Source data file structures/layout analysis and creating mapping documents.
• Engage Data Architecture team for Data Modeling and DBA for database object creations.
• Co-ordination with team members for design discussions, code review.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Functional analysis and track down data elements to be sent to downstream systems. Mapping of functional data elements to database fields and come up with database procedure, view design.
• Perform Code review and unit testing at various levels of the ETL, developed Real time ETL for loading load data through java message queue interface