SUMMARY

• Around 10 years of professional experience in IT Industry including expertise in Development, Implementation and Support of Data Warehouse application systems in various domains like Investment Banking, Health Care, Insurance and Telecommunication.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Extensive experience in development and designing of ETL solutions for supporting data transformations and processing in a corporate wide environment using Informatica PowerCenter 7.x/8.6.1/9.x.
• Involved in the Software full development lifecycle (SDLC) from requirements gathering, design, development, coding, testing, debugging, deployment to Production env, L3 and L2 level escalation Production Support.
• Extensive knowledge of Dimensional Data Modeling like Star and Snowflake schemas and knowledge in designing tools like Erwin.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL (Stored Procedures, Triggers and Packages), SQL Loader, Informatica Power Center v 7.x/8.6.1/9.x.
• Extensive knowledge of Big Data Concepts, Hadoop Architecture, HDFS, YARN and Map Reduce.
• Hands on experience of analyzing/transforming data with Hive and Pig.
• Hands on experience with Data Ingestion tools like Flume and Sqoop.
• Working experience in Nice Actimize AIS Modeller, Service monitor and RCM Designer.
• Experience in Installation and configuration, Creation of repositories with user groups and security implementation. Good Experience in Informatica upgrades and installations.
• Have been certified as Informatica Certified Designer by Informatica.
• Have experience in preparing Business Continuity Solutions (BCP) by installing standalone Server for Informatica.
• Disaster Recovery and Infra Migration related activities to ensure the application availability and stability under all circumstances.
• Good Knowledge on Data Warehousing Concepts, Normalization concepts, Business Objects (BO) Reporting tool, Informatica IDQ, Informatica MDM, Teradata utilities, Oracle PL/SQL, Netezza.
• Experience in integration of various data sources like SQL Server, Oracle 11g/10g/9i, DB2, Flat Files, Salesforce, XML,MQ Sources, COBOL files, MS Excel and Flat files.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Well versed in UNIX shell scripting.
• Experience in scheduling of ETL jobs using Crontab, Autosys, Control - M.
• Extensive experience in Incident management, Release Management, Problem Management processes.
• Knowledge of different Schemas (Star and Snow Flake Schemas) for query and business analysis requirements.
• Worked on Instrument Reference Data dat is required for the systems within Investment Banks in order to provide foundation data for trading.
• Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.
• Extensive experience working in an Agile development environment.
• As an ETL Tech lead, lead the ETL development for a team of 5 members, for enhancements in Banking Data warehouse.

TECHNICAL SKILLS

Tools: Informatica Power Centrer 7.x,8.6.1,9.x, Informatica Admin, NICE Actimize (CDD Solution), IDQ and Informatica MDM, Big DATA Hadoop, PIG, HIVE, Sqoop

Data Modeling: Star Schema Modelling, Snow Flake Modelling, FACT & Dimensions.

Databases: Oracle 11g/10g/9i,Netezza,Teradata

Languages: SQL, PL/SQL, UNIX Shell Script

Operating Systems: Solaris, Unix, Linux, Windows 95/98/2000/NT/XP

Domain: Instrument Reference Data, Client Data, Investment Banking, Health Insurance

Data Distribution: Webmethods, Tibco, Durables, Web Service, FTP, SFTP

Scheduling Tools: Autosys, Cron, Control M,Tivoli Workload Scheduler(TWS)

Tools: / Utilities: Toad, Subversion (SVN), Clearcase, Toad, Putty, Jira, Confluence, Service NOW, Sqlplus

PROFESSIONAL EXPERIENCE

Senior Software Engineer

Confidential - Richfield, Minnesota

Responsibilities:

• Creating the design documents basing on the requirements documents for the new development/ enhancements.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes using Informatica Power Center.
• Maintaining Actimize AIS Instances in different environments like Dev, IT and UAT.
• Working in Actimize Modeler, Service monitor and RCM Designer.
• Working on upgrading activities of Risk Case manager and alsi AIS Server in different environments.
• Attend the meetings with business integrators to discuss in - depth analysis of design level issues.
• Provide support for Releases or Go Live changes. Performance/Fine tuning of Informatica mappings, Database queries.
• Responsible for coordinating the work and also transfer knowledge to the offshore crew.
• Fixing defects, bugs and critical issues.

Environment: NICE Actimize, Informatica Power Center 9.5.1, UNIX shell scripting, Oracle, PL/SQL, TOAD, SOAP UI, Websphere

Senior Software Engineer

Confidential - Nashville, Tennessee

Responsibilities:

• As an ETL Tech lead, lead the ETL development for enhancements in Banking Data warehouse.
• Creating the design documents basing on the requirements documents for the new development/ enhancements.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes using Informatica Power Center.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Responsible for disaster recovery process for Informatica. Configured a backup Informatica server for the current application.
• Developing the new Unix Shell scripts, Autosys Jobs.
• Develop Database objects like Tables, Functions, Procedures, Views and Cursors etc.
• Provide support for Releases or Go Live changes. Performance/Fine tuning of Informatica mappings, Database queries.
• Disaster Recovery and Infra Migration related activities to ensure the application availability and stability under all circumstances.
• Handled production issues and act as RTB (Run The Bank) to resolve it and ensure the stability of the applications and to provide users with the support for any related queries.
• Release Management, Problem Management, Incident Management etc. and look ways to mitigate the risk involved due to the incidents, incorrect codes etc.
• Responsible for coordinating the work and also transfer knowledge to the offshore crew.
• Fixing defects, bugs and critical issues.

Environment: Informatica Power Center 9.5.1, UNIX shell scripting, Oracle, PL/SQL, TOAD, Tibco EMS, Orca NG, Autosys, Snow, Agile Scrum

Senior Software Engineer

Confidential

Responsibilities:

• Creating the design documents basing on the requirements documents for the new development/ enhancements.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes using Informatica Power Center.
• Responsible for disaster recovery process for Informatica. Configured a backup Informatica server for the current application.
• Release Management, Problem Management, Incident Management etc and look ways to mitigate the risk involved due to the incidents, incorrect codes etc.
• Provide support for Releases or Go Live changes. Performance/Fine tuning of Informatica mappings, Database queries.
• Disaster Recovery and Infra Migration related activities to ensure the application availability and stability under all circumstances.
• Performed Unit testing, Integration testing and generated various Test Cases.
• Handled production issues and act as RTB (Run The Bank) to resolve it and ensure the stability of the applications and to provide users with the support for any related queries.
• Fixing defects, bugs and critical issues.
• Maintaining stability of Applications.
• Supporting user queries.

Environment: Informatica Power Center 9.5.1, UNIX shell scripting, Oracle, PL/SQL, TOAD, Tibco EMS, Orca NG, Autosys, Snow, Agile Scrum

Senior Software Engineer

Confidential

Responsibilities:

• Creating the design documents basing on the requirements documents for the new development/ enhancements.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes using Informatica Power Center.
• Responsible for disaster recovery process for Informatica. Configured a backup Informatica server for the current application.
• Developing the new Unix Shell scripts, Autosys Jobs.
• Develop Database objects like Tables, Functions, Procedures, Views, Cursors etc.
• Provide support for Releases or Go Live changes. Performance/Fine tuning of Informatica mappings, Database queries.
• Disaster Recovery and Infra Migration related activities to ensure the application availability and stability under all circumstances.
• Handled production issues and act as RTB (Run The Bank) to resolve it and ensure the stability of the applications and to provide users with the support for any related queries.
• Release Management, Problem Management, Incident Management etc and look ways to mitigate the risk involved due to the incidents, incorrect codes etc.
• Fixing defects, bugs and critical issues.
• Maintaining stability of Applications.
• Supporting user queries.

Environment: Informatica Power Center 8.6.1, UNIX shell scripting, Oracle, PL/SQL, TOAD, Autosys, Snow, Agile Scrum

Senior Software Engineer

Confidential

Responsibilities:

• Interacting with the Functional Owners and end users to understand the demands and mapping the same into the functional specification.
• Extracted data from heterogeneous sources like Oracle, XML files, Flat files & MQ Series.
• Used Advanced Transformations like MQ Series, XML Parser, XML Generator, and SQL in Informatica to load data in to ODS.
• Development of the Informatica mappings/workflows, Oracle DB Objects as per the approved design documents.
• Developed several Reusable Transformations, Mapplets, Worklets.
• Performing unit testing at various levels of the ETL and preparing the Unit test results documents.
• Performance tuning for Mappings, Sessions whereever required.
• Performing the System Integration testing and providing support for UAT & Fixed the Issues raised by users.
• Developed UNIX shell scripts to automate daily loads and used Informatica scheduler to Schedule workflows.

Environment: Informatica Power Center 8.6.1, UNIX, Oracle, PL/SQL, TOAD, Flat files, MQ Series, XML Sources.

Senior Software Engineer

Confidential

• Analyze the Business Requirements Documents.
• Development of Informatica mappings/workflows.
• Performing unit testing at various levels of the ETL and preparing the Unit test results documents.
• Preparing the $U jobs for all the workflows.

Environment: Informatica Power Center 8.6.1, UNIX, Oracle, PL/SQL, TOAD, Flat files

Technology Consultant

Confidential

Responsibilities:

• Analyze the Requirements Documents and creating the Design documents.
• Created detailed process flow designs and drafts high-level Standard Operation Procedures.
• Involved in the meetings with customer to discuss design level issues.
• Development of Informatica mappings/workflows, mapplets and Unix Shell Scripts, Oracle DB objects, doing the Unit testing at each stage of ETL and preparing the unit test results document.
• Giving the codereview sessions to customer SMEs (Subject Matter Experts) to get the sign off.
• Performing the System Integration testing and providing support for UAT testing.
• Responsible for coaching, and mentoring new/junior members in the team.

Environment: Informatica Power Center 7.1, UNIX shell scripting, Oracle, PL/SQL, SQL Developer, Netezza, Control-M

Technology Consultant

Confidential

Responsibilities:

• Analyze the Business Requirements Documents.
• Design the Informatica mappings/workflows using different sources like Flat files, Oracle etc.
• Development of Informatica mappings, mapplets and Oracle DB Objects.
• Performing Unit testing and provide support to QA resources.
• Involved in Migration approach and Space estimation of the System.

Environment: Informatica Power Center 7.1, UNIX shell scripting, Oracle, PL/SQL, SQL Developer, Erwin Data modeling.

Technology Consultant

Confidential

Responsibilities:

• Understand the Business Requirement, High Level and Low level Design documents.
• Develop Informatica mappings/workflows.
• Doing the Unit testing for each component and preparing the unit test results documents.

Environment: Informatica Power Center 7.1, UNIX shell scripting, Oracle, PL/SQL, SQL Developer