SUMMARY

• Worked extensively on - Informatica, OBIA,ODI,OBIEE & Confidential .
• Experience in various technologies like- Informatica, OBIEE, ODI, Confidential .
• Experience in Data warehousing, BI, ETL Development and BI Reporting.
• Data warehousing, Data Profiling and Data Analyst.
• Informatica 9 and 10.
• Oracle Business Intelligence Enterprise Edition 10g and 11g.
• Data Warehouse Administration Console.

TECHNICAL SKILLS

• Windows XP, Unix
• Unix, SQL, PL/SQL, Python programming, Core Java.
• Informatica PowercenterInformatica Data Analyst DACOBIEE 11gCognos 8ToadSQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Symphony data conversion project is about the cleansing of the existing data present in legacy erp system using different tools and technique and loading the cleaned, quality and meaningful data into new erp system name as Symphony Oracle ERP .
• Requirement gathering, analyzing requirement, preparing functional specs, creating the design documents, effort estimation and resource planning.
• To prepare system requirement specification.
• To create data profiles, building the data cleansing business rules with the help of business steward and loading the quality data into target system.
• ETL Design as per the business rule and implement ETL code to clean the source data and load into intermediate database and further pushed the clean and changed data into Oracle EBS system as per requirement.
• Created reference model to transform the source data into required values and load into target. e.g. transforming the Unit of measures values, Country name, etc
• Worked Bill of material, Routing data, Price FX and Supplier data migration using Informatica Powercenter 10.
• Created reports on Oracle Application Express for data testing by users.
• Worked on OBIA ODI ETL customization and RPD design and development for custom reports.
• To create test scenario, execute the test cases and fixed the identified bugs.
• To migrate the code from dev to qa and from qa to production.
• To identify and mitigate the project risk.
• Post migration support.

Tools: and Skills: Informatica 10,OBIEE 11g,Cognos 8Oracle10g,Oracle Application Express,ODIOracle SQL Developer, Toad,PL/SQL

Confidential

Technical lead

Responsibilities:

• Cognos reports across the 3 business segment name as Industrial, Electrical and Commercial were in scope of the conversion project.
• Involved in analyzing the existing cognos reports and listed all the report into cross metrics report that considered for conversion project.
• Initially overall 10000 cognos reports across the different business segment were listed to convert into obiee 11g reports.
• Further sorted above 10000 reports and cut down the list to 2000 reports for the conversion(taking out all the adhoc reports which was not in scope).
• Involve in requirement gathering and design phase.
• Involve in creation of high level designs and low level designs of the obiee 11g reports.
• Followed agile method for conversion of cognos 8 reports to obiee 11g.
• Daily scrum calls with development team to track the progress and remove the gaps in terms of requirement and implementation.
• Maintain coordination between development team and business team and assign the task to development team.
• Present WSR segment wise, there were 3 calls per week with customer on status update.
• Involve development, unit testing and migration of code from dev to qa and from qa to production.
• Involve in bug fixes identified during the unit testing and qa testing
• Involve in impact analysis whenever there is requirement change and plan out the risk and mitigation accordingly.
• Informatica 10 is used to move the data from MFG pro system to Oracle ERP system.
• Involved in ETL design and Development using informatica.

Tools: and Skills: Informatica 10,OBIEE 11g,Cognos 8Oracle10gOracle SQL Developer, Toad,PL/SQL

Confidential

ETL and BI Developer

Responsibilities:

• To coordinate with the Client for the better understanding of the requirements. Integration and tracking of Business rules.
• The development of a global, integrated reporting solution to analyze deal pricing details from initial quotes to sales orders through final sales transactions, and margin leakage using transaction level data for analytical Residential Solution’s Equipment streams for all regions.
• The project will be deployed by region and targeted business sites.
• Each targeted site within a region has been identified and scheduled.
• The reporting solution will be based on the Oracle Business Intelligence
• (OBIEE) product and leverage standard analytical design and functional capabilities provided with the tool.
• To do Unit Testing, Unit Integration testing and system testing of the components created for the interface from source to Data warehouse.
• To fix the defect found out during the testing and the retesting of the components.
• To prepare the Test Scenario and test cases for the testing of the components created and execute the same in different test environments.
• To create an ETL schedule on Confidential for the new development and execute it in Confidential as a part of system testing.
• To create the change request for the new requirement and the changes.
• To interact with the client and users for the new changes and well document the requirements.
• To do the impact analysis if there is any change in the requirement.

Tools: and Skills: Informatica 9.0.1 PowerCenter

Confidential

Oracle10gSQL Developer, Toad,PL/SQL

Responsibilities:

• Analyse the provided Test Plan, design the test cases
• Leading the offshore team, delegating the task, executing the test cases, reporting found bugs on share point, monitoring the team performance closely and also fixing the simple and complex issue raise by customer during the testing
• Preparing the Weekly status report, Sending it to customer and Account manager.
• Updating the Work status to the customer over weekly call
• Performing the Alpha testing, Reporting the bug on the Sharepoint portal.
• Fixing the identified bug and suggesting the solution customer.
• Attending the daily call with ATOS team (Develpement Team).

Confidential

ETL and BI Developer

Responsibilities:

• Analyse the operational reporting requirements and design.
• Prepare the documents for mapping, reporting requirements and design.
• Monitoring the offshore team, distributing the work in between the team.
• Coordination with DBA's for Noetix Global views Regeneration in DEV/Staging/PROD instance.
• Development /Modification of RPD, Web catalog objects and Dashboard.
• Unit testing and performance testing of all Reports and preparing UTP documents.
• System Testing and User Acceptance Testing.
• Knowledge Transition to Support team.
• Infant Care for agreed period post production roll-out.
• MoM preparation, Weekly status reports.
• Preparing various documents like Impact Analysis, Traceability Matrix, KT Plan and etc
• Presenting Project/ Change Requests to Business Intelligence - Design Review Board and Change Control BoardPerforming IQA and EQA on the deliveries based on the estimated effort using IQMS. Also this tool is used to maintain quality in our deliverables.
• To do Unit Testing, Unit Integration testing and system testing of the components created for the interface from source to Data warehouse.
• To fix the defect found out during the testing and the retesting of the components.
• To prepare the Test Scenario and test cases for the testing of the components created and execute the same in different test environments.
• To create an ETL schedule on Confidential for the new development and execute it in Confidential as a part of system testing.
• To create the change request for the new requirement and the changes.
• To interact with the client and users for the new changes and well document the requirements.
• To do the impact analysis if there is any change in the requirement.

Tools: and Skills: ORACLE PL /SQL, OBIEE 11G,Putty, WinSCP, Clear Case

Confidential

BI Developer

Responsibilities:

• Coordination with DBA's for Noetix Global views Regeneration in DEV/Staging/PROD instance.
• Development /Modification of RPD, Web catalog objects and Dashboard.
• Unit testing and performance testing of all Reports and preparing UTP documents.
• System Testing and User Acceptance Testing.
• Knowledge Transition to Support team.
• Infant Care for agreed period post production roll-out.
• Preparation MoM, Weekly status reports.
• Preparing various documents like Impact Analysis, Traceability Matrix, KT Plan and etc
• Presenting Project/ Change Requests to Business Intelligence - Design Review Board and Change Control Board

Tools: and Skills: ORACLE PL /SQL, OBIEE 11G,Putty, WinSCP, Clear Case

Confidential

ETL and BI Developer

Responsibilities:

• Obiee 10 was used for the operation and Analytical reporting, Informatica was used for the Daily loads from Operational and ODI sources to EDW datawarehouse.Knowledge Transition to Support team.
• Infant Care for agreed period post production roll-out.
• MoM preparation, Weekly status reports.
• Preparing various documents like Impact Analysis, Traceability Matrix, KT Plan and etc
• Presenting Project/ Change Requests to Business Intelligence - Design Review Board and Change Control Board

Tools: and Skills: Informatica 8, Confidential, PL/SQL, Obiee 10g, Putty, Wnscp

Confidential

ETL and BI Developer

Responsibilities:

• Analysing the Customer requirement document.
• Modifying the existing Store procedure, implementing the informatica mappings.
• Modeling the RPD, Updating the 10g reports for DBU S&NOP
• Updating the mapping in the Confidential jobs.
• Development /Modification of RPD, Web catalog objects and Dashboard.
• Unit testing and performance testing of all Reports and preparing UTP documents.
• System Testing and User Acceptance Testing.
• Knowledge Transition to Support team.
• Infant Care for agreed period post production roll-out.
• Preparation MoM, Weekly status reports.
• Preparing various documents like Impact Analysis, Traceability Matrix, KT Plan and etc
• Presenting Project/ Change Requests to Business Intelligence - Design Review Board and Change Control Board

Tools: and Skills: Informatica 8, Confidential, PL/SQL, Obiee 10g, Putty, Wnscp

Confidential

ETL Developer

Responsibilities:

• Designing and Executing Unit Test cases.
• Mapped UTC and SIT Test cases Doc.
• Peer review of procedures

Tools: and Skills: Informatica 8.6.0, PL/SQL, SAP BO, Contorl M