PROFILE SUMMARY:

12+ years of IT experience, primarily in the field of Data Warehousing for System Analysis, Designing, Development, Administration and Support of various systems for Business Intelligence. As part of my career, I was involving in Requirement & Data Analysis, Designing, Quality Reviews, Migration, System Integration & Functional Testing along with Production Support. I also have good experience in the Agile Methodology and effective communication and mentoring skills. Having very good exposure roles as a Data Analyst, ETL Developer, QA Analyst, ETL Architect, Technical & Project Lead and Informatica Admin.

KEY STRENGTHS:

• Good knowledge of Data warehousing Concepts
• 10+ years of solid experience in Data warehousing/ Integration using different ETL Tools, mainly Informatica.
• Experience in performing Data profiling, Data governance identification and resolution of data quality issues.
• Strong experience in Data analysis, Data integration in cross functional environment.
• Experience in working with Oracle, Teradata, DB2, SQL Server, UNIX, DPA
• Involved in Requirement analysis, Data Analysis, Data modeling, Performance tuning.
• Good knowledge in Software Development Life Cycle Process and Agile Methodology
• In - depth experience in different BI lifecycle processes like Data Integration/ETL process, EDW, Data Marts, Master Data Management and Metadata Management.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling.
• Worked in multiple large end-to-end data warehousing implementations in different domains like Banking, Finance, Health Care, Retail etc.
• Worked on project proposals, project estimates and providing line of estimates.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.5/9.1/8.6/7.5 & Decision Point Analyzer(DPA)

Database: Oracle 11g/10g/9i, Teradata, SQL Server,DB2

Development Tools: SQL Developer, Toad, Teradata SQL Assistant

Languages: UNIX,SQL, PL/SQL, VB, C#

Reporting Tools: Business Objects, Hyperion

Other Tools & Technologies: Quality Center, JIRA, Version One, Tidal, AutoSys

WORK EXPERIENCES:

Confidential, San Ramon, CA

Technical Lead / Senior Developer

Responsibilities:

• Performed data profiling in the source systems that are required for FMS System
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Worked with project team representatives to ensure physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• High level ETL design, Review the low level design, Unit Testing Strategy etc.
• Design and Develop complex mappings involved
• Involved in Code migration in different environments.
• Coordinating and Supporting SIT and UAT activities with different teams.

Confidential, Pleasanton, CA

Technical Lead & Production support

Responsibilities:

• Review project status and project metrics on a weekly/monthly basis.
• Review and revise project plan to meet changing requirements in the project
• Submit or update monthly project plan or operational reports to customer on the progress of the project to meet the timeline or highlight any kind of risk
• Active Participation with Business team during Requirement gathering phase
• Responsible for ETL processes and tools as well as database loading and manipulation
• Interacting with client to understand the requirements and distributing the work to offshore team.
• Participate in weekly Tech leads meetings and the actively involved in all activities including deployment and initial code support.
• High level ETL design, Review the low level design, Unit Testing Strategy etc.
• Create Technical design document.
• Develop ETL complex mappings like institutional & professional claim header and detail mappings.
• Prepare and test Unix scripts for HCG & ICS grouping
• Supporting SIT and UAT activities, also worked in Production support job.
• Review and revise the operational aspects of the account with the reporting managers on a weekly basis
• Ensure compliance with project standards and quality assurance procedures.

Confidential, Walnut Creek, CA

Module Lead / Informatica Admin

Responsibilities:

• Plan daily/weekly activities for the team and track the progress on each deliverables.
• Prepare project plan and progress report and share with onsite coordinator.
• Review and revise project plan to meet changing requirements in the project
• Design business requirements to technical requirements and get the sign off from client managers.
• Ensure compliance with project standards and quality assurance procedures.
• Coordinating with Onsite PM and understanding the requirements and distributing the work to offshore team
• Designing the ETL Architecture and load strategy
• Review the ETL Design, Unit Testing Strategy etc.
• Develop ETL mappings and UNIX scripts.
• Prepare Unit test cases and capture the test results.
• Supporting the SIT and UAT activities
• Informatica Admin related activities

Confidential, San Francisco, CA

Senior Developer / ETL Architect

Responsibilities:

• Plan daily/weekly activities for the team and track the progress on each deliverables.
• Understanding the client requirements and prepare understanding and design documents
• Reviewing the understanding and design document with DA and finalize the design.
• Coding and Unit testing.
• Interact with onsite counterpart and plan activities
• Manage and allocate tasks for the team members
• Document and upload the various artifacts required for process related audits.
• Ensure effective and clear communication of Client team's requirements, expectations and feedback to the team at onshore and offshore.
• Periodic reviews of all the project/account level metrics with onshore and offshore project leads.
• Daily or weekly calls with the team and offshore management leads to keep the project timeline or upcoming project release activities to plan.
• Keep up-to-date both onshore & offshore leads on the client decisions and if any project plan changes.

Confidential, Alameda, CA

Offshore Technical Lead

Responsibilities:

• Ensure effective and clear communication of Client team's requirements, expectations and feedback to the team at onshore and offshore.
• Understanding the changes and design documents and developing the code based on it.
• Gathering requirements and functional knowledge from Onsite and updating the work status.
• Developing ETL objects, Database objects.
• Maintaining design documents, Business Requirement documents and uploading to Cisco's Live link for easy sharing and maintenance
• Adherence to Quality procedures as per client standards
• Prepare the Test cases for the Unit testing.
• Conducting impact analysis for the changes suggested by the clients
• Coding based on the Specifications provided by the Client and according to the checklist.
• Testing application (includes the Unit Testing and Pre Integration Testing).
• Reconciling the data and identifying any data-issues including Known Issues and fixing it.
• Write or assist in the writing of new project proposals and statement of works and formally present the same to client.

Confidential

Senior Developer

Responsibilities:

• Analyzing the existing RIC process and Reviewing the designs
• Preparation of Logical and Technical docs.
• ETL,PL/SQL Coding and Unit testing
• System Integration Testing
• Performance tuning
• Interaction with onsite Testing team on project activities iQA Support
• ETL code migration

Confidential

QA Analyst

Responsibilities:

• Preparing Detailed Test Plan.
• Assigning activities to the team members
• Understanding the clients’ requirements, project functionalities and writing test cases.
• Interaction with onsite Testing team on project activities
• Responsible for reviewing, executing test cases and logging defects.
• Responsible for Functional, Integration and System testing.
• Defect reporting & tracking and Status Reporting.
• Preparation of status reports.
• Maintaining test documents

Confidential

Data Analyst

Responsibilities:

• Requirement Analysis
• Data analysis
• Impact analysis
• Technical design
• Preparing Functional Design document
• Discussing the Design with Onsite and Offshore Developers
• Design and code design reviews
• Functional testing
• Functional defect reviews.

Confidential

ETL Developer

Responsibilities:

• Requirement Analysis
• ETL Designing
• Preparation of Logical and Technical docs.
• ETL,PL/SQL Coding and Unit testing
• Writing the test cases
• System Integration Testing
• Performed Unit testing and Functional Testing.
• QA Support
• ETL code migration
• Prod Warranty support for 3 months

Confidential

ETL Developer

Responsibilities:

• Requirement Analysis
• ETL Designing
• Preparation of Logical and Technical docs.
• ETL,PL/SQL Coding and Unit testing
• Designing and optimizing the Mapping to load the data in slowly changing dimension.
• Writing the test cases
• System Integration Testing
• Performed Unit testing and Functional Testing.
• QA Support
• Supporting the SIT and UAT activities
• ETL code migration.