Manjula Karnati Email & Phone Number

Woburn, Massachusetts, United States

Boston, Massachusetts

Bengaluru, Karnataka, India

• Involved in Data Warehouse Development - ETL processes using Informatica Power Center 9.1• Extensive Experience in Support/Development.• Extensive expertise in implementing complex business rules by creating transformations and mappings/mapplets.• Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.• Good technical Skills in Oracle, Data Warehousing concepts, UNIX, SQL.• As a team member I supported the production and preproduction environment.• Checking logs by using UNIX command and executing shell scripting programmers in putty environment Involved in all release and deployment activities.

Chennai Area, India

Project: Enterprise SolutionsClient: SBI General Insurance Ltd.Role: ODI and OBIEE DeveloperResponsibilities :Defined and implemented complete ODI settup with governance procedures and ELT development standards.• Installed ODI and configured the Master and Work Repositories.• Set up the Topology including physical architecture, logical architecture and contexts• Created Source and Target systems, Physical and Logical Data Server connections into ODI Topology Manager.• Created ODI Variables and used those into ODI interfaces, Procedures and Packages.• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.• Created Interfaces to load data from source systems to staging area, staging area to Dimension and Fact tables.• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to Dimension and Fact tables.•Through Control-M integrated and scheduled for daily batch processing of ETL.Strong technical knowledge of OBIEE Administration tool, Security, Answers and Dashboard development.• Extensively worked with OBIEE Administration Tool for customizing and modifying the Physical, Business and Presentation layers of the metadata repository..•Created new dashboards/reports and made recommendations to report layout with reference to table, narrative, pivot, chart views in OBIEE Answers and embedded them into new/existing dashboards pages as required by the project.• Expertise in creating Measures, Dimension Hierarchies, Aggregates, Variables, Time series Measures.• Experienced in configuring the Security Settings in OBIEE to set up Groups, Users, Access Privileges and Query Privileges.• Extensively worked in configuring Analytics metadata objects and Web Catalog Objects, developed and Customized Dashboards / Reports with different Analytics Views as per the requirement.• Expertise in Building Interactive Dashboards by using Roll-Up, Drill Down, Slice and Dice and Pivot Capabilities

Visakhapatnam, Andhra Pradesh, India

Pg Diploma In Data Science

Subects: • Machine Learning : Regression (Linear,Logistic,Ridge,Lasso) , Clustering(KMeans),Decision Tree, Random Forest, SVM, Time Series.

Level Core Hybrid Program,Data Analytics

Master'S Degree, Computer Science