SUMMARY

• Around 9 years of experience in Business Intelligence solutions (Informatica, Cognos, SAP HANA,SAP BODS, Oracle, Analytical, Problem solving skills and Project management related activities).
• Expertise in complete SDLC including requirement gathering & analysis, designing, testing, integration, quality assurance, maintenance and support.
• Well familiar with mapping the requirements, custom designing solutions & troubleshooting for complex software & application problems.
• Providing effective resolution to customer queries related to production support and improving relationships with the customer by anticipating customer future requirements, thereby ensuring a positive customer experience.
• Experienced in Business Intelligence & Data Warehousing domains including Requirement Analysis, Data Analysis & Validations, Data Modeling, DW Design, ETL Scripts etc.
• Effectively lead the offshore team and manage coordination between offshore and onsite teams.
• Technical skills and expertise in working on SAP HANA,SAP BODS, Informatica (9.6, 9.1,8.6,8.1,7x and 6x) Development and Administration, Cucumber scripts, SQL Programming, UNIX Scripting with good understanding of Cognos and Oracle applications.

TECHNICAL SKILLS

Data Warehousing: Dimensional Modelling and Data Warehousing concepts

ETL Tool: Informatica Power Center 9.6, 9.1/ 8.6 /8.1.1/ 7. x, SAP BODS

OLAP Tools: SAP HANA, Cognos 8

Data Modelling Tool: SAP HANA, ERwin 4.5

RDBMS: MS SQL and Oracle

RDBMS Tool: Toad, SQL Developer

Languages: SQL, PL/SQL, UNIX Shell Script, C

Environment: s Ms - Windows NT/2000/XP and UNIX

Testing: Cucumber, Piper framework

PROFESSIONAL EXPERIENCE

Confidential, Moline, IL

Sr. Informatica Developer

Environment: Informatica 9.6, 9.1,SAP BODS 4.2 and Piper. Data Quality

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Following Agile methodology to continuously keep track of project developments and handling of the scrum process.
• Taking part in Sprint planning and story sizing activities as part of Agile practise.
• HANA Modelling solutions to the dealer transactional data.
• Develop Data services data flows for the ETL requirements.
• Creation of ETL Jobs in SAP BODS for loading the data from different heterogeneous systems to SAP HANA Database.
• Participate in the Retro, Planning and Sizing meetings as part of the Agile methodologies.
• Took part in Data Analysis, exception handling, reporting an d monitoring capabilities.
• Contribute towards requirement gathering and understanding the business requirements to suit the technical solutions.

Confidential, Stamford CT

ETL Lead

Environment: Informatica 8.6, Oracle and UNIX

Responsibilities:

• Development of Informatica Mappings to load into EDW.
• Resolution of data loading issues in Informatica and Oracle.
• Interacting with Business Analyst and users to get new requirements and enhancements.
• Interacting with the offshore ETL team for work assignment and updates.
• Managing Application issue resolution and changes in BI.
• Attending Confidential calls and reporting project status updates to Confidential and TechM management.
• Managing and supporting the team for the project activities to be aligned with the project plan.
• Single Point of contact (SPOC) for the ETL team.

Confidential, Atlanta, GA

Project Lead

Environment: Informatica 9.1, UNIX

Responsibilities:

• Development of Informatica Mappings to extract data files from EDW.
• Writing Unix Scripts to validate data and SFTP it to Corporate Server.
• Resolution of data loading issues in Informatica
• Taking care of HPSM cases from users by using HPSM tool.
• Interacting with Corporate team new requirements and enhancements.
• Managing Application issue resolution and changes in BI.
• Attending Confidential calls and reporting project status updates to Confidential and TechM management.
• Managing and supporting the team for the project activities to be aligned with the project plan.

Confidential, Atlanta, GA

Project Lead

Environment: Informatica 8.6,9.01,UNIX, Oracle

Responsibilities:

• Development of Informatica Mappings and Oracle Stored Procedures to load data into the Data Warehouse.
• Writing Unix Scripts based on the requirement.
• Resolution of data loading issues in Informatica and Orcale.
• Interacting with Business users on Developments and challenges.
• Responsible for interacting with various teams in issue resolving.
• Managing Application issue resolution and changes in BI.
• Attending Confidential calls and reporting project status updates to Confidential and TechM management.
• Managing and supporting the team for the project activities to be aligned with the project plan.
• Single Point of contact (SPOC) for the team.

Confidential, Greenville,SC

Environment: UNIX, Informatica 8.6 and Oracle

Responsibilities:

• Managing the Informatica BI environment in Confidential .
• Assisting program teams during application development.
• Planning and preparing for the outages that are related to the environment.
• Development of Informatica Mappings to load data into the Data Warehouse.
• Writing Unix Scripts based on the requirement.
• Resolution of data loading issues in Informatica.
• Tracking the defects and preparing statistical reports and charts.
• Managing Application issue resolution and changes in BI.
• Attending Confidential calls and reporting weekly metrics.

Confidential

Team Member

Environment: UNIX, Informatica 8.1 and Oracle

Responsibilities:

• Managing the BI environment in Confidential .
• Assisting program teams during application development and release.
• Helping in planning and preparing for the project deployments.
• Writing Unix Scripts based on the requirement.
• Reviewing project documents and the code before the code movement.
• Attending Confidential calls and reporting weekly metrics.
• Single Point of contact (SPOC) for the team.
• Have been the Facilitator of the Project community on the Support Central.
• Designed, developed, deployed and maintained Support Central workflows for the project management.

Confidential

ETL Developer

Environment: Informatica 7.1, Oracle 9.i, TOAD, MS Access

Responsibilities:

• Prepared ETL specification documents for Informatica.
• Developed Informatica mappings to load data from Oracle and Flat Files.
• Resolving issues (Performance Tuning, Enhancing the mappings according to Confidential requirements).
• Performed comprehensive Unit testing by comparing the Cognos reports against the database using SQL in Toad and documented the same.
• Working with the users by creating Test cases and resolving reported issues for UAT.
• Updating the Specification document, Mapping Document and review checklists.
• Implemented Slowly Changing Dimension.
• Involved communication with Users, Managers and business analysts for understanding the Business logic and database.