SUMMARY

• Having 2 years of experience in IT industry in designing, development and implementation of Informatica and OBIEE.
• Well versed in working with ETL tool Informatica Power Center in creating Source/Target definitions, building Mapping/Mapplets and creating and monitoring Sessions/Workflows.
• Experienced in creating Sessions, Workflows, Mappings and Mapplets using various available transformations in Informatica.
• Used DAC as scheduling tool for Informatica Workflows.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping and Presentation Layer.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters and variables.
• Experienced in creating technical and functional design documentation.
• Quick learner with strong communication skills who can work in a team or independently.

TECHNICAL SKILLS

Tools: and Frameworks: OBI Apps 7.9.6.4 (Certified), OBIEE 11.1.1.7.1 (Certified), Informatica 9.0.1, DAC 11g

Databases: Oracle 11g, SQL Server 2015.

Query Languages: SQL, PL/SQL.

Programming Languages: C#, C, C++.

Web: HTML, CSS, JavaScript

IDE: Visual Studio 2015, NetBeans.

Operating Systems: Windows.

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst

Responsibilities:

• Went through the existing system configurations and checked for changes and performed Financial analytics configurations using the new source system application regarding production system.
• Performed Informatica and DAC changes based on configurations and documented the changes.
• Migrated customizations by analyzing the changes made, ran ETL for Financials and Project Analytics and performed BI reports validation.
• Performed Code Merge and Migrations and Monitored the overall OBIEE usage on server and capture the usage spikes etc. to improve the performance.
• Prepared test cases, test plans for reporting and ETL development.

Confidential

Responsibilities:

• Went through the existing system configurations and checked for changes and performed Financial analytics configurations using the new source system application with reference to production system.
• Performed Informatica and DAC changes based on configurations and documented the changes.
• Migrated customizations by analyzing the changes made, ran ETL for Financials and Project Analytics and performed BI reports validation.
• Prepared test cases, test plans for reporting and ETL development.