SUMMARY

• 7.6 years of experience in software development, support and enhancement with BI Technology.
• Worked on all stages of SDLC such as Requirement Gathering, software Development, Testing, software Deployment, User Training, and Production Support.
• Expertise in handling multiple projects simultaneously and development of client - server and multi-tier applications.
• Developed Data Marts and Warehouses using Dimensional Modeling based on the Ralph Kimball’s design methodology
• Worked extensively in building Dimensions, Bridges, Facts, Star Schemas, Snow flake
• Built Extraction-Transformation-Load (ETL) solutions using Informatica Power Center
• Built data load regulation programs with inherent ability to restart on failure using UNIX shell scripting
• Experienced in Oracle RDBMS, Teradata and developed ETL code using Oracle PL/SQL and Teradata Scripting
• Troubleshooting and Performance tuning of ETL (informatica) applications.
• Having good working knowledge on informatica Administrative activities (By using Admin console) like creating backup, restore backup, creating user and Assign privileges.
• During the course of the project, participated in multiple meetings with the client to propose better strategies for performance improvement and gather new requirements.
• Provided support for the applications after production deployment to take care of any post-deployment issues
• Involved in Installation and Configuring informatica Power Center 9.1.0 with oracle on Windows 2003 Server

TECHNICAL SKILLS

Business Area: BFSI Domain (Banking, Financial Services and Insurance) and Oil & Gas

ETL Tools: Informatica Power Center 9.6.0/8.6.1/7.1.5

EAI TOOL: TIBCO BW 5.X, RV, Administrator 5.X,, ADB Adapter 5.2.0, EMS 4.x, SAP R/3 5.x

Databases: Oracle 10g, Teradata, MS SQL Server 2005, Spatial Database

Programming languages: UNIX /Linux shell scripting

Scheduling/Automation Tools: AppWorx 8.1.0, UC4 Applications Manager 8.0, Informatica scheduler

Operating Systems: UNIX(Solaris), RED HAT LINUX, Windows XP, Windows 2003

Reporting Tools: BOXI (Business Objects)

GIS: Arc GIS (SDE Administrations )

PROFESSIONAL EXPERIENCE

Project Lead, Senior ETL Developer / Data Analyst

Confidential - Norwalk, CT

Responsibilities:

• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.
• Constructed data models, established relationships between entities, defined table structures and joins, index and partition parameters.
• Extensively worked with Teradata utilities like BTEQ, Fast Load, Multi Load .
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant
• Expertise in writing large/complex queries in SQL and Teradata.
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Proficient in preparing high/low level documents like design and functional specifications.
• Involved in review meetings with Project Managers, Developers and Business Associates for Project deliverables.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence, Union and Update Strategy transformations while creating mapplets/mappings.
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows.
• Modeled multiple data marts within the warehouse and articulated respective Star/Snow-Flake Schemas.
• During the course of the project, participated in multiple meetings with the client to propose better strategies for performance improvement and gather new requirements.
• Created modules and chains to schedule the loads using UC4 Applications Manager.
• Sequenced the different ETL components (Informatica workflows/Oracle SQLs/UNIX scripts) and enlisted in a list file; further created a data load regulation program by writing a parent UNIX shell script that executes the components within the list file sequentially
• Provided support for the applications after production deployment to take care of any post-deployment issues

Senior ETL Developer / Data Analyst

Confidential - Norwalk, CT

Responsibilities:

• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.
• Constructed data models, established relationships between entities, defined table structures and joins, index and partition parameters.
• Extensively worked with Teradata utilities like BTEQ, Fast Load, Multi Load .
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant
• Expertise in writing large/complex queries in SQL and Teradata.
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Proficient in preparing high/low level documents like design and functional specifications.
• Involved in review meetings with Project Managers, Developers and Business Associates for Project deliverables.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence, Union and Update Strategy transformations while creating mapplets/mappings.
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows.
• Modeled multiple data marts within the warehouse and articulated respective Star/Snow-Flake Schemas.
• During the course of the project, participated in multiple meetings with the client to propose better strategies for performance improvement and gather new requirements.
• Created modules and chains to schedule the loads using UC4 Applications Manager.
• Sequenced the different ETL components (Informatica workflows/Oracle SQLs/UNIX scripts) and enlisted in a list file; further created a data load regulation program by writing a parent UNIX shell script that executes the components within the list file sequentially
• Provided support for the applications after production deployment to take care of any post-deployment issues

Senior ETL Solutions Developer, Module Lead

Confidential - Norwalk, CT

Responsibilities:

• Interaction with clients and other stake holders through to gather the reporting requirement and understand risks.
• Partook in several conferences with the client to understand and collect revised requirements and suggest improved approaches for performance enhancement.
• Estimation of the software development effort.
• Project monitoring and control during offsite development.
• Demonstrated use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Aggregator, Joiner, Router, Sequence, and Update Strategy transformations while creating mappings.
• Comprehensively used the Workflow Manager tasks like Session, Command while creating workflows.
• Channelized the different ETL components and programmed jobs to execute in the required sequence using UNIX shell scripting.
• Implemented restart mechanism to ensure smooth continuation in case of any failures during the load.
• Created modules and chains to schedule the loads using AppWorx and established predecessors, conditions and schedules.
• Successfully deployed various data mart applications to constitute the corporate finance data warehouse.
• Provided support for the applications after production deployment to take care of any post-deployment issues.
• Assisting the BI enhancement team for impact analysis and changes to the current production environment.

Environment: Informatica 9.1.0/8.6.1 , UNIX shell scripting, Oracle 10g/9i PL/SQL, Business Objects XI, Teradata 12.0, UC4 Applications Manager 8.0.

Senior ETL Developer

Confidential - Norwalk, CT

Responsibilities:

• Collected requirements from business, studied the same extensively; mapped subject areas onto dimensions, identified facts from the Key Performance Indexes (KPIs) and formulated conformed dimensions using Dimensional Modeling.
• Estimation of the software development effort.
• Constructed data models, established relationships between entities, defined table structures and joins, index and partition parameters.
• Modeled multiple data marts within the warehouse and articulated respective Star/Snow-Flake Schemas.
• Created Informatica transformations/mapplets/mappings/tasks/worklets/workflows to load the data from source to stage, stage to dimensions, bridges, facts, summary and snapshot facts.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence, Union and Update Strategy transformations while creating mapplets/mappings.
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows.
• Created UNIX shell scripts to FTP and cleanse source data files and archive data and log files.
• Sequenced the different ETL components (Informatica workflows/Oracle SQLs/UNIX scripts) and enlisted in a list file; further created a data load regulation program by writing a parent UNIX shell script that executes the components within the list file sequentially.
• Invoked Informatica using “pmcmd” utility from the UNIX script and Oracle using “sqlplus”.
• Incorporated the mechanism to restart the load in the main program itself by logging status to ensure smooth resumption in case of any failures during the load.
• Created modules and chains to schedule the loads using UC4 Applications Manager.
• Successfully deployed/enhanced data marts (DM) like Prospecting/Sales DM, Finance DM, Risk DM, Originations DM, and Customer Analytics DM to constitute the entire warehouse.
• During the course of the project, participated in multiple meetings with the client to propose better strategies for performance improvement and gather new requirements.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: Informatica 9.1.0/8.6.1 , UNIX shell scripting, Oracle 10g/9i PL/SQL, Business Objects XI, Teradata 12.0, UC4 Applications Manager 8.0.

ETL Developer, Module Lead

Confidential

Responsibilities:

• Collected requirements from business, studied the same extensively; mapped subject areas onto dimensions, identified facts from the Key Performance Indexes (KPIs) and formulated conformed dimensions using Dimensional Modeling.
• Interact with client to understand and collect revised requirements and suggest improved approaches for performance enhancement.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence, Union and Update Strategy transformations while creating mapplets/mappings
• Implemented session level partitioning to enhance performance by introducing inherent parallelism.
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows.
• Constructed data model, established relationships between entities, defined table structures and joins, index and partition parameters.
• Modeled data mart within the warehouse and articulated Star/Snow-Flake Schemas.
• Created UNIX shell scripts to FTP and cleanse source data files and archive data and log files.
• Sequenced the different ETL components (Informatica workflows/Oracle SQLs/UNIX scripts) and enlisted in a list file; further created a data load regulation program by writing a parent UNIX shell script that executes the components within the list file sequentially.
• Invoked Informatica using “pmcmd” utility from the UNIX script and Oracle using “sqlplus”.
• Incorporated the mechanism to restart the load in the main program itself by logging status to ensure smooth resumption in case of any failures during the load.
• Done the end to end to testing with the source system and downstream applications.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: informatica 8.1.6, Oracle 9i, PL/SQL, Business Objects

ETL Developer

Confidential

Responsibilities:

• Collected requirements from business, studied the same extensively; mapped subject areas onto dimensions, identified facts from the Key Performance Indexes (KPIs) and formulated conformed dimensions using Dimensional Modeling.
• Interact with client to understand and collect revised requirements and suggest improved approaches for performance enhancement.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence, Union and Update Strategy transformations while creating mapplets/mappings
• Implemented session level partitioning to enhance performance by introducing inherent parallelism.
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows.
• Constructed data model, established relationships between entities, defined table structures and joins, index and partition parameters.
• Done the end to end to testing with the source system and downstream applications.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: informatica 7.1.5, Oracle 9i/ PL/SQL, Business Objects

ETL Developer

Confidential

Responsibilities:

• Collected requirements from business, studied the same extensively; mapped subject areas onto dimensions, identified facts from the Key Performance Indexes (KPIs) and formulated conformed dimensions using Dimensional Modeling.
• Involved in Installation of Informatica PowerCenter 7.1.5 on Windows 2003 Server
• Extensively worked with Source Analyzer, Target Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation
• Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Involved in Performance tuning and testing at mapping level.
• Involved in end user training and support
• Interact with client to understand and collect revised requirements and suggest improved approaches for performance enhancement.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Router, Sequence, Union and Update Strategy transformations while creating mapplets/mappings
• Extensively used the Workflow Manager tasks like Session, Event-Wait, Timer, Command, Decision, Control and E-mail while creating worklets/workflows.
• Constructed data model, established relationships between entities, defined table structures and joins, index and partition parameters