Sumalalitha Atreyapurapu

Email: acuwhv@r.postjobfree.com

Current Employer: Deloitte Consulting LLP, USA Phone: +1-216-***-****

Professional Summary

9+ Years of experience in IT with full life cycle implementation of Oracle Business Intelligence Product suites (OBIEE) and Oracle Business Intelligence Applications(OBIA), ETL - Data ware house implementations (Informatica)

Involved in all the phases of gathering requirement, Proof of concept, gap analysis, design, development and implementation of software applications

Extensive expertise in providing end-to-end business intelligence solution by configuring metadata & building analytics metadata repository, star schemas, snow flake schemas, dimensional modeling design, building business models, generating reports, and creating interactive BI dashboards, iBots (Agents), Scheduler.

Extensive experience in building and customization of interactive dashboards with drill down capabilities using global & local filters, contextual navigation, guided analytics, Business Rules with User Identity & roles, profiles & personalization and creating and scheduling I-Bots

Experience in migrating RPD, Catalogs and applying patches

Proficient in development and production support and OBIEE application design, build, test, experience, including requirements gathering, ownership of metadata and dashboards and reports

Extensive experience in migration of OBIEE Presentation Services objects using OBIEE Catalog Manager and repository files between different environments

Experience in development of BI Publisher Reports using various templates using BI Publisher Desktop Tool

Experience in performance tuning, security, cache management, aggregation and usage tracking

Experience in working with Oracle Business Intelligence (BI) Applications, pre-built BI solutions, extracting data from Oracle EBS, Oracle RETEK (ORMS), flat files and loading into OLAP systems. Configure and scheduled iBots for daily sales trend reports alerts.

Experience of working in MUDE, resolve conflicts and maintain consistency

Experience in development of mappings using Informatica Mapping Designer using various transformations like Expression, Router, Lookup, SQ, Update Strategy, Implementation of Type 2 dimensions etc.

Experience in development of sessions and workflows and using Informatica Workflow Manger

Experience on execution, monitoring and troubleshooting of the ETL executions using Informatica Workflow Monitor

Expertise in debugging, optimizing the performance tuning of Oracle BIEE 10g/ 11g Repository & Dashboards / Reports by implementing Aggregate tables, Fragmentation of data sources, Indexes and Cache management.

Experience in performing end to end testing including Data Validation, Unit Testing and UAT.

Experience in managing project through various phases SIT, UAT and Production Implementation.

Created Run book for end users.

Trained end users on creating Adhoc reports using OBIEE 11g.

Excellent interpersonal skills, outstanding problem solving and decision making skills.

Education

B.Tech in Production Engineering from Nagarjuna University, Vijayawada, India.

Technical Skills

TechnicalSkills

Reporting Tools : OBIEE 10G/11G, OBIA 7.9.6.3, BI Publisher, BI Publisher Desktop

RDBMS : Oracle 8i/9i/10g/11g, SQL Server 2000

ETL Tools : Informatica 9.x,

Operating Systems : Windows, Unix

Scheduling Tools : Control M Jobs

Applications : MS Office Suites (Excel, Word, PowerPoint, Access)

Profiling Tools : OEDQ (Oracle Enterprise Data Quality)

Querying : PLSQL

Database Clients : TOAD, SQL Developer

Professional Experience

Clinet: Eaton Corp, Cleveland, Ohio

Employer: Deloitte Consulting LLP, USA April 2015-Till date

Project: CERP (Conceptual ERP)

Role: Sr. OBIEE Tech Lead

Environment: OBIEE 11g, Informatica 9x, Oracle 10g, PLSQL,

Responsibilities:

Worked closely with Business Users, involved in discussing and gathering the reporting requirements.

Over all development of 8 Sales and 5 Invoice Dashboards with other standard reports.

Worked on converting the CERP Analytics – (conceptual ERP) requirements into technical requirements.

Created mapping documents to map the report attributes back to the the CERP data modelfor end user reporting for Sales and Invoice data globally from AMERICAS, EMEA and APAC regions.

Involved to finalize the reporting requirements to the end users. Finalizing the approach for RPD development.

Co-ordination with end users on the business and functional requirements to facilitate adhoc reporting.

Worked on Agile methodology by sprint based releases for every two weeks with Daily stand up call.

Managed Onshore offshore resources, Project planning activities and co-ordination activities during System Integration Testing, User Acceptance Testing and Production Implementation planning.

Client: Anthem, Richmond, VA Feb 2012 –March 2015

Project: Oracle BI Implementation

Employer: Deloitte Consulting LLP, USA

Role:Sr.OBIEE/OBIA Developer

Environment:OBIEE 11.1.1.7.x/11.1.1.6.x), Informatica Power Center 9.6.1, Oracle 11g, PL/SQL,DAC 10.1.3.4.1, Oracle EBS R12.1.1, Toad, Linux Putty,

Responsibilities:

Involved with business users to gather requirements for developing a custom reporting solution for Provider Care Management Solution.

Active participation in converting business requirements into technical specifications, from the mock up reports to technical user stories.

Involving with various teams RPD development, UI team and data team to discuss on proposed solution and approach.

Actively Interacted with project managers & team members to discuss timely deliverables, project status & documented technical specifications from functional specifications in reporting point of view

Administrated BI Environment by debugging identified issues and delivered solutions.

Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.

Developed custom client specific reports, dashboards.

ETL : Working extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner Transformation

Used catalog manager to migrate custom dashboards, requests, filter and prompts to Prod Fixed performance issues for improving report performance.

Client :GE Appliances & Lighting March 2011 – Feb 2012

Project: Consumer Experince Dashboards

Role: Sr.OBIEE Developer

Environment: OBIEE11.1.1.6.4/11.1.1.5

Responsibilities:

Worked closely with Business Users, involved in discussing and gathering the analytic requirements from different user groups.

Worked as Sr.Developerto successfully deliver a multiphase OBIEE deployment by coordinating between offshore and onsite team and also involved in various status and activity meet up with client’s IT and Business team.

Created Consumer experience Dashboards with Pie charts, Banners, Guage views etc as a Pilot project that got end user approval for funding the entire project.

Dealt with the performance issues such as tuning the queries using Views, Materialized Views and Indexes for the reports which are running at significantly higher time periods.

Performed Dimensional modeling, Identify Fact tables& Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions.

Responsible for migrating the web catalog and RPD from DEV, UAT and PROD environments.

Configured External Database Authentication Security and created OBI_USER, OBI_GROUP, OBI_PRIVILAGE & OBI_PASS_ENCRYT to store OBIEE Users Credentials which was used to setup Data Level & Object Level Security.

Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards.

Performed the Server Administration tasks of migrating the BI Repository, Webcat between the Development, Testing, UAT and PROD environments.

Have extensively used presentation variables.

Trained End users on using OBIEE presentation services for adhoc reporting.

Land Mark Gulf group, Dubai, UAE Aug 2008 – May 2010

Project: Retek User Reports – Custom ORDW

Role: BI Analyst

Environment: OBIEE 10g, Oracle 10g, Oracle plsq

Responsibilities:

Worked in analysis of reporting requirements and coming up the custom data model and creation of custom repository for meeting the reporting requirements.

Conducted design sessions with data owners toward capturing business requirement for an analytics environment

Worked on stored procedures that run over a nightly batch run to populate the aggregate tables required for the Oracle BI.

Worked on the OBIEE RPD Physical, Business and Presentation Layers.

OBIEE Administration, maintaining users, groups, roles, Data level security and Object level security.

Creation of OBIEE reports, Dashboards, Scheduling Ibots that generate reports for the Senior managers of each of the 11 sub divisions.

Involved in determining the logic and creation of Ageing reports for the physical warehouse management.

Worked on customized Oracle BI publisher reports.

Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Managed and maintained the OBIEE solution, RPD, Answers and addressing user issues.

Trouble shooting the issues related to repository models and report development.

Super Valu, Eden Praire, MN Feb 2005 – July 2008

Project: Retail Dashboards

Role: OBIEE Developer

Environment: OBIEE 10g, Oracle, plsql.

Responsibilities:

Conducted design sessions with data owners toward capturing business requirement for an analytics environment

Working closely with end user community to enhance and improve the user experience architecture look and feel

Design various reports i.e. Drill down, pivot, Breakdown reports, Narrative and Nested reports in answers and configured intelligent Dashboards for different groups of users to view across regions customer demography with the facility to drilldown and charts.

Configuring the repository modeled physical, business and the presentation layer.

Build Repository of all the 3 layers Physical Layer(connecting Data sources & import schema) business Model & data mapping (create Logical tables & data source mapping) & Presentation layer level (create presentation catalogs), create presentation folders & tested.

Involved in creating Dimensions and Fact tables.

Responsible for preparation of Test plans and the development of Test scripts as per the requirement from client.

Proposed and Configured a new Security model in order to maintain data-level security for the users

Proposed the enhancements required on the reporting requirements

Proposed the required changes that are required in the EDW data model for generating the required reports

Involved in the DB design and required changes

Developed the BI dashboards and reports

Configured the security settings for the dashboards as well as data security

Involved in the design activities and created the design specifications documents

Documented test cases to test the reporting requirements functionality and carried out thorough testing

Deploy the code to the OBIEE Production environments.

Contact this candidate