Programmer Analyst Resume

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

Programmer Analyst

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.