MOUNICA KURAPATI

ac2e3j@r.postjobfree.com

Houston, Texas 832-***-****

PROFESSIONAL SUMMARY

Having 2 years of experience in IT industry in designing, development and implementation of Informatica and OBIEE.

Worked as Programmer Analyst in Cognizant Technology Solutions India Pvt. Ltd.

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.

CERTIFICATIONS

Oracle certified in Oracle Business Intelligence Foundation Suite 11g.

Oracle certified in Oracle Business Intelligence Applications 7 for ERP.

Oracle certified in Oracle Database 11g: Program with PL/SQL.

EDUCATION

Master of Science in Management Information Systems GPA 3.3/4

University of Houston Clear Lake, Houston, Texas August 2017

Bachelor of Technology in Computer Science and Engineering GPA 3.3/4

Jawaharlal Nehru Institute of Technology, Hyderabad, India May 2013

PROFESSIONAL EXPERIENCE

Cognizant Technology Solutions Pvt. Ltd. (CTS) Hyderabad, India

Programmer Analyst November 2013-December2015

PROJECT DETAILS

Project: IHG Retro Fitment Peoplesoft92 Upgrade

Client: IHG, USA

Duration: Jan’15 – Jul’15

Project Description:

IHG strategic objective is retro fitment of OBIA 7.9.6.3 Financial & Project Analytics using upgraded PeopleSoft 9.2 Application. IHG is using Financial & Project Analytics including customization with respect to PeopleSoft 9.2.

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.

Accomplishments – Received a Shining Star Award as an appreciation for this project.

Project: Oracle EBS R12 Upgrade

Client: Emdeon, US

Duration: Mar’14 – Oct’14

Project Description:

Emdeon used Financials, Procurement and Spend analytics which was implemented using BI Apps 7.9.6.4 version with the source system Oracle 11.5.10 upgraded to Oracle R.12.1.3 version which includes upgrading BI Apps reporting and ETL.

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.

ACADEMIC PROJECTS

Youth Tobacco Consumption in USA – Data Warehousing and Data Mining

This project was part of Data Warehousing and Data Mining course where we chose raw data set published by data.gov, identified the facts, dimensions and hierarchies, cleansed the raw data, formed an OLAP cube and performed data analysis and data visualizations.

Lead a team of three members in building a data warehouse for analyzing Youth Tobacco Consumption in USA.

Extracted and Transformed raw data and loaded it into data warehouse in required format and implemented star schema and built OLAP cube and performed data visualizations.

Houston Heating and Air Conditioning company – Systems Analysis and Design

Houston Heating and Air Conditioning company is an application developed in the Systems Analysis and Design course. Our team designed, developed and integrated Sales and Marketing application on to the common application platform using C#, WPF for Phase I and ASP.NET, C#, CSS, Bootstrap and Crystal Reports for phase II (web application).

Took care of the database tables for sales and marketing in the application.

Implemented the application and performed data visualizations using Crystal Reports.

Contact this candidate