SUMMARY:

• A competent professional with an overall experience of 11 years 7 months in Information Technology with major focus on Business Intelligence - ETL process Development Using INFORMATICA 8.6 - 9.x versions.
• Currently associated with Confidential Technology Solution as a BI- APPLN ARCH-OFF (Senior Associate) for Confidential - Onsite Coordinator/Data Analyst/Technical Lead/Scrum Master.
• An effective communicator with honed relationship management, analytical, logical and problem-solving abilities.
• Expertise in liaising with Customers, Stake holders, vendors and business SME and translate analysis into actionable business insight
• Leading technical aspects of all phases of the project including Requirement Gathering, elicit technical requirements, all stakeholders sign-offs, Conceptual Architecture, Logical Architecture, Physical Architecture, Infrastructure Architecture, High Level and detailed
• Design, Development Environment (E1), QA Environment (E2) and Production Environment (E3). Responsible for End to End Architecture of a very strategic project.
• Design Detail ETL spec for development team. Provided ETL solution for complex data movement
• Proficient in drawing sizing/estimates of resources to be committed for work performance and implementing internal controls to ensure project execution, testing and operations within defined time/cost parameters.
• Monitoring project risks and scope creep to identify potential problems and proactively identifying solutions to address them in advance.
• Escalating promptly any issues that may impact operations highlight reports, risk logs, requests for change.
• Communicate Project Status to onsite team and Customer regularly.
• Managing client expectations by ensuring the delivery of the highest quality service.
• Demonstrated ability to work with and support cross-functional project teams.
• Ability to manage multiple projects simultaneously and under pressure.
• Strong attention to detail and focus on task completion and monitoring team performance.
• Experience in Data Loading, Analysis, Design by using Various Technologies like Informatica Power Center 8.6, 9.x and Oracle, Teradata 12.0, DB2 in Data Warehousing, ensuring the deliverables within the time & cost parameters.
• Developing ETL processes like Data Extraction, Transformations, and Loading using Informatica Power Center 8.6 & 9.x versions Designer, Workflow Manager and Workflow Monitor tools.
• Extensively worked on Informatica Power Center Extensively worked on Informatica B2B Data Studio & Informatica Power Exchange.
• Extensively worked on third party tool like Erwin studio, TOAD, Confidential - Quality Center, Control- M.
• Represented as a Software Configuration Management Coordinator for CMMI level 5 Certification for Confidential project in Confidential Technology Solutions.
• Onsite Experience (USA): 3 yrs as an Onsite Coordinator.

TECHNICAL SKILLS:

Hardware / Platforms: Windows, Unix

ETL: Informatica - Power Center, Informatica- B2B DT Studio, Informatica - Power Exchange, Pentaho, Bigdata(Trained & Certified)- Hadoop, Pig, Hive, NoSQL

Language Used: SQL, PL/SQL, Teradata 12.0 (Bteq, Fastload, Mload), Shell Script

Databases: Oracle 10G, 11G, Teradata

Tools: Eclipse Toad- Oracle, Winscp, Confidential - Quality Center - Testing tool, JIRA Tracker, Visio 2010, Control M, Erwin Studio - Data modelling

Project Management Tool: Star Team, Tortoise (Subversion), Visual Studio - Source Control

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead - Onsite Coordinator / Data Analyst/ Scrum Master

Responsibilities:

• Performed various roles Architect, Sr. Technical Lead/Scrum Master - Preparing Design document, mapping document, providing design for complex Transformation.
• Provided end to end design for the UNIX frame work for the process flow.
• Code Reviewing/Performance tuning and interacting with customer for the UAT defects raised by UAT Team & taken care of Production jobs.
• Managing defects in Confidential ALM tool.
• Participated in design review meetings with customer.
• Configuration Management - Maintaining code standards, Documentation, End to End delivery point of contact to customer.
• Weekly summary Status report to stakeholders.

Confidential

Team Lead - Onsite Coordinator / Data Analyst

Responsibilities:

• Performed various roles Onsite Coordinator, Sr. ETL Developer/ Data Analyst - Preparing Mapping document, providing design for complex mapping.
• As a data analyst, I have actively involved in doing analyzing the existing system data updating mapping documents and interacting with customer in order understanding the existing system for building new data warehouse system.
• Code Reviewing/Performance tuning and interacting with customer for the UAT defects raised by UAT Team & taken care of Production jobs
• Managing defects in Confidential ALM tool.
• Communicate Project Status to client and offshore team regularly during daily Status Meetings.
• Participated in design review meetings with customer.

Confidential

Project Lead - Application Architect - Onsite Coordinator / Business Analyst

Responsibilities:

• Performed various roles Onsite Coordinator, Business Analyst, Project Lead - Providing design for complex mapping, Code Reviewing Interacting with customer for the UAT defects raised by UAT Team & taken care of Production jobs.
• As a business analyst, I have actively involved in doing analyzing the existing system and creating mapping documents and interacting with customer in order understanding the existing system for building new data warehouse system.
• Preparation of high-level, detailed-level design documents based on the business/functional Requirements (BR/FR).
• Project Sizing/Estimation based on the BR/FR.
• Code Review - Informatica, Support UAT team, Performance tuning & taken care of Test parallel and Production Load.
• Manage defects raised in Source Control tool.
• Communicate Project Status to client and offshore team regularly during daily Status Meetings.
• Participated in design review meetings with customer.

Confidential

Project Lead - Application Architect (BI- APPLN ARCH-OFF)

Responsibilities:

• Performed role of Project Lead, Innovation champion & SCM Coordinator
• Preparation of high-level, detailed-level design documents based on the business/functional Requirements (BR/FR)
• Project Sizing/Estimation based on the BR/FR.
• Involved in Data modeling activities using E.R Studio Tool.
• Review Informatica mapping
• Review Test cases for Component, Assembly, SIT test cases.
• Support UAT and Performance tuning.
• Manage defects raised in JIRA Tracker tool (QC tool).
• Communicate Project Status to onsite team and Customer regularly during daily Status Meetings.
• Participated in design review meetings with customer.
• Hands on experience in XML & Data Transformation Studio - B2B concepts.
• Managed more than 10 people as lead.

Confidential

Project Lead - Application Architect

Responsibilities:

• Working as a Project Leader & SCM Coordinator leading a team size of 12
• Preparation of high-level, detailed-level design documents based on the business/functional Requirements (BR/FR).
• Project Sizing/Estimation based on the BR/FR.
• Development and unit test of ETL mappings using Informatica Power Center Power Center, Informatica Power Exchange as per the Business Requirements.
• Used B2B Data Transformation Studio tool for converting NACHA file to XML file format.
• Review Test cases for Component, Assembly, SIT test cases.
• Provide Project Status to onsite team and Customer regularly during Weekly Status Meetings (WSM).
• Participated in design, code review meetings with customer.
• Conducted training session on XML & Data Transformation Studio - B2B concepts.
• Represented as SCM Coordinator in CMMI level 5 interview processes for Confidential .
• Received Certification award from Periasamy, Nallasenapathi for representing as SCM Coordinator for Confidential .

Confidential

Team Lead

Responsibilities:

• Preparation of high-level, detailed-level design documents based on the business/functional Requirements (BR/FR)
• Project Sizing/Estimation based on the BR/FR.
• Data modeling
• Development of ETL mappings using Informatica Power Center Power Center as per the Business Requirements.
• Unit testing of developed mappings and UNIX scripts.
• Worked on UNIX shell scripts in order to validate source files (includes record count, length, Structure) from one database to another database.
• Developed PL/SQL procedure and package to load data from stage schema to EDW.
• Developed BTEQ’S in Teradata.
• Involved in UAT and Performance tuning.
• Maintain test case document in the Confidential Quality Center tool (QC tool).
• Responsible to ensure all ETL mapping, shell scripts, PL/SQL script deliverables are in compliance with Confidential 's ( Confidential ) Global Method for Application Services ( Confidential GMAS) Software lifecycle process.
• Prepare development status tracker using the data points sourced directly from PPMC. Provide quick clarifications, resolutions on time in different phases of project (design, development, testing and support).

Confidential

Senior Developer

Responsibilities:

• Data profiling of data obtained from new member hospitals
• Creating Partitioning using the tool in DW and DM
• Development of new Informatica mappings for new member hospitals based on the specification
• Recurring data load for member hospitals
• Gap data loading for member hospitals.
• Coordination with Business Analysts and Dedicated Advisors
• Support Business Analysts JIRA requests
• Unit testing of developed mappings
• Creating a workflow setup to load the data into the data warehouse
• Validating the data available in the data warehouse to check if the data is ready to be loaded into the data mart
• Creating requests to load the data available in the data warehouse into the data mart using the customer centric tools.
• Validating the data available in the data mart and checking if the reports are getting populated with precise and relevant data.
• Creating requests to swap data from the internal site to the external site so that the reports can be viewed by the end user.
• Debug issues arising from existing hospitals member
• Making the client site ready for production movement.
• Transitioning Documents.
• Worked in Compass Control Confidential internal tool.
• Got client appreciation from the Senior Director of Confidential Project.

Confidential

Developer

Responsibilities:

• Migrated the websites based on the specification provided by BA.
• Making sure all the documents, images, presentations provided are maintained in the same server.
• Involved in communicating the Project Status for the code movement to onsite team on a daily basis.