SUMMARY:

• Dedicated IT Professional with around 11 years of multifaceted experience, including data warehouse, database, and business intelligence, as well as working directly with customers in a consulting capacity throughout the full software life cycle.
• Worked with Insurance, Banking, Sales, Manufacturing, and Automotive and Healthcare clients.
• Working as an Onsite coordinator for the last 1.8 years.
• Handles the complete end to end development project as a team lead and worked Business intelligence tools like Informatica, data stage.
• Developed expertise in data analysis, profiling, performance tuning, dimensional modeling, and star and snowflake schemas.
• Built the communication channel as a team lead between onsite and off - shore to process the maximum number deliverables for business.
• Convert Functional Requirements into Technical specifications and adhere to SLAs.
• Excellent exposure in Oracle BI components like RPD, Answers and DAC configuration & loading process.
• Train and manage developers, advising other groups in organization on data warehouse development, and Informatica development best practices.
• Sound knowledge of UNIX.
• Performed effectively both as an autonomous, self-motivated individual and as an active member of a decision making team.

FUNCTIONAL SKILLS:

• Participate in estimation, staffing analysis and solutioning in order to provide inputs for preparing solution delivery of the proposal and to provide inputs to overall project schedule in order to ensure on time delivery of the project.
• Participates in discussions with customers to gather scope information and performs analysis of scope information in order to provide inputs for project scope documentation.
• Trains team members on project processes and provides inputs on process tailoring and quality goals in order to finalize project quality plan.
• Provide inputs for technical risk planning with module perspective in order to ensure on time delivery of the project.
• Performs high and low level design, provides pseudo codes, implements the prototype and does design reviews in order to deliver design documents as per customer requirements.
• Guide the team in developing optimized high quality code deliverable, perform code deliverables and unit test plan reviews in order to build application conforming to projects standards and requirements.
• Lead the team for integration/system/performance testing based on integration and system test plans and support UAT in order to ensure defect free program/module/system release.
• Interface with customer for issue resolution, provides status updates, build customer confidence in team’s ability to deliver in order to support high customer satisfaction.
• Mentor the team on technical competencies and provides performance feedback of the individual team members to project manager in order to manage performance.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000/XP/Windows7

DBMS: Oracle 9i/10g, MS Access

Tools: INFORMATICA Power Center 6.x/7.x/8.x, DataStage 8.1

Languages: SQL, PL/SQL, SQL* Loader

Reporting tools: Oracle Business Intelligence (OBIEE), Jasper Soft

Data modeling tool: Erwin 3.5, Visio

Other Tools & Products: TOAD6.5, TOAD10.6.1.3, Clear Case, SVN, VSS (Version Control Tools), WINSCP, UNIX, Mercury, Dollar universe, Data Injector (Internal tool)

Scheduler: DAC, Control-M

EMPLOYMENT CHRONICLE:

Confidential

Project Lead

Responsibilities:

• Participating daily in Scrum meeting to provide the status of the offshore team.
• Handling a 7 member’s team and helping them as and when required technically as well as functionally.
• Preparing technical design document based on the client requirement and providing the same to the offshore team.
• Reviewing all the documents and code before sending it to client.
• Coordination, attending meetings, and the review of requirements, infrastructure setup, task assignments and code reviews.

Technology: Informatica, Qlikview, Oracle 10g, Windows7, Toad, Data Injector, UNIXDollar Universe Scheduler

Project Lead/Onsite Coordinator

Confidential

Responsibilities:

• Participating daily in Scrum meeting to provide the status of the offshore team.
• Handling a 11 member’s team and helping them as and when required technically as well as functionally.
• Coordinating with the business people to get the requirement.
• Passing the work to the offshore team.
• Reviewing all the documents and making changes, if required before sending it to client.
• Point of contact for ERM batch team (Mainframe technology), coordinating with the team as per the business needs.
• Sending the weekly status report to the client.

Technology: Informatica, Cognos, Oracle 10g, Windows7, Toad, Mercury

Project Lead

Confidential

Responsibilities:

• Interacting with the client on a daily basis in order to give the status of the project.
• Interacting with the BA’s for requirement gathering.
• Leading a team of 7 members and helping them as and when required technically as well as functionally.
• Reviewing the documents before sending it to the client.
• Being a Project Lead, taking the overall responsibility of the project.
• Participate in estimation, staffing analysis and solutioning in order to provide inputs for preparing solution delivery of the proposal and to provide inputs to overall project schedule in order to ensure on time delivery of the project.

Technology: Informatica, OBIEE, Oracle 10g, Windows XP, SQL Developer

Technology Lead

Confidential

Responsibilities:

• Participate in estimation, staffing analysis and solutioning in order to provide inputs for preparing solution delivery of the proposal and to provide inputs to overall project schedule in order to ensure on time delivery of the project.
• Participates in discussions with customers to gather scope information and performs analysis of scope information in order to provide inputs for project scope documentation.
• Trains team members on project processes and provides inputs on process tailoring and quality goals in order to finalize project quality plan.

Technology: PL/Sql, Oracle 10g, Windows XP, SQL Developer, Control-M

Technology Lead

Confidential

Responsibilities:

• Participate in estimation, staffing analysis and solutioning in order to provide inputs for preparing solution delivery of the proposal and to provide inputs to overall project schedule in order to ensure on time delivery of the project.
• Participates in discussions with customers to gather scope information and performs analysis of scope information in order to provide inputs for project scope documentation.
• Trains team members on project processes and provides inputs on process tailoring and quality goals in order to finalize project quality plan.
• Provide inputs for technical risk planning with module perspective in order to ensure on time delivery of the project.
• Performs high and low level design, provides pseudo codes, implements the prototype and does design reviews in order to deliver design documents as per customer requirements.
• Guide the team in developing optimized high quality code deliverable, perform code deliverables and unit test plan reviews in order to build application conforming to projects standards and requirements.
• Lead the team for integration/system/performance testing based on integration and system test plans and support UAT in order to ensure defect free program/module/system release.
• Interface with customer for issue resolution, provides status updates, build customer confidence in team’s ability to deliver in order to support high customer satisfaction.
• Mentor the team on technical competencies and provides performance feedback of the individual team members to project manager in order to manage performance.

Technology: DataStage8.1, Oracle 10g, Windows XP, SQL Developer, Control-M

Technology Lead

Confidential

Responsibilities:

• Participates in discussions with customers to gather scope information and performs analysis of scope information in order to provide inputs for project scope documentation.
• Trains team members on project processes and provides inputs on process tailoring and quality goals in order to finalize project quality plan.
• Provide inputs for technical risk planning with module perspective in order to ensure on time delivery of the project.
• Performs high and low level design, provides pseudo codes, implements the prototype and does design reviews in order to deliver design documents as per customer requirements.
• Guide the team in developing optimized high quality code deliverable, perform code deliverables and unit test plan reviews in order to build application conforming to projects standards and requirements.
• Lead the team for integration/system/performance testing based on integration and system test plans and support UAT in order to ensure defect free program/module/system release.
• Interface with customer for issue resolution, provides status updates, build customer confidence in team’s ability to deliver in order to support high customer satisfaction.
• Mentor the team on technical competencies and provides performance feedback of the individual team members to project manager in order to manage performance.

Technology: DataStage 8.1, Oracle 10g, Windows XP, SQL Developer, TeradataOBIEE, Clear case (Version control tool)

Technology Lead

Confidential

Responsibilities:

• Participate in estimation, staffing analysis and solutioning in order to provide inputs for preparing solution delivery of the proposal and to provide inputs to overall project schedule in order to ensure on time delivery of the project.
• Participates in discussions with customers to gather scope information and performs analysis of scope information in order to provide inputs for project scope documentation.
• Trains team members on project processes and provides inputs on process tailoring and quality goals in order to finalize project quality plan.
• Provide inputs for technical risk planning with module perspective in order to ensure on time delivery of the project.
• Performs high and low level design, provides pseudo codes, implements the prototype and does design reviews in order to deliver design documents as per customer requirements.
• Guide the team in developing optimized high quality code deliverable, perform code deliverables and unit test plan reviews in order to build application conforming to projects standards and requirements.
• Lead the team for integration/system/performance testing based on integration and system test plans and support UAT in order to ensure defect free program/module/system release.
• Interface with customer for issue resolution, provides status updates, build customer confidence in team’s ability to deliver in order to support high customer satisfaction.
• Mentor the team on technical competencies and provides performance feedback of the individual team members to project manager in order to manage performance.

Technology: Jasper Soft, Oracle 10g, Windows XP, Toad, OBIEE, SVN (Version Control tool)

Technology Lead/Developer

Confidential

Responsibilities:

• Analyzing the functional documents and prepare the understanding document on the basis of FRD.
• Participates in discussions with customers/onsite coordinator to gather the required information to create a Jasper/OBIEE Report.
• Prepare Technical design document as per the requirement given by the customer.
• Help the team members to prepare the Jasper Report on the basis of Technical design document.
• Participate in report review and give your inputs on the same so that developer can make the changes accordingly.
• Prepare the migration document for SIT and UAT.
• Lead the team for integration/system/performance testing based on integration and system test plans and support UAT in order to ensure defect free module release.

Technology: Informatica 8.1.1, Oracle 9i, Windows XP, Toad, Winsql

ETL Developer

Confidential

Responsibilities:

• Analyzing the functional documents and prepare Informatica Mappings using various transformations.
• Prepared Unit Test cases for Informatica mappings.
• Involved in the Unit testing for Informatica mappings using Project specific templates, processes and guidelines
• Involved in the preparation of design documents, Unit Test Case documents, Unit testing documents, Walkthrough Documents in detail.
• Involved in the implementation of Change Request given by Onsite team.
• Created corresponding sessions and workflows to load the data.

Technology: Informatica 8.1.1, Oracle 9i, Windows XP, Toad, Winsql

ETL Developer

Confidential

Responsibilities:

• Monitoring and sustenance ETL jobs on a daily basis.
• Follow up action on job failures to ensure completion of a load.
• In case a session/workflow takes long time to complete, identify the reasons for
• The same and come up with a few suggestions to improve its performance.
• Involved in the migration of Informatica from Informatica 7.1 to Informatica 8.1.1.
• Involved in the Performance tuning of Informatica mappings.

Technology: Informatica 6.2/7.1, Oracle 9i, Windows 2000.