Sales Data

Summary

Around *+ years of IT experience as Business Systems Analyst/Data Analyst including project planning and management, software analysis and design. Strong in Data Warehousing experience using Sql’s, OBIEE(10g,11g,12c),OBIA (7.9.6,7.9.6.1), Informatica 8.6.0/8.6.1, DAC(10.1.3.4.1),ODI(10g/11g).

Experience in Business Systems Analyst/Data Analyst including project planning and management, software analysis and design.

Experience in the Analysis, Design, and Development, Testing of Data warehouses and Data marts.

Strong analytical skills combined with the ability to communicate with seasoned management across multiple time zones.

Performed large-scale data analysis and develop effective statistical models for segmentation, classification, regressions, optimization, forecasts, validation & testing.

Strong understanding of Extraction Transformation and Loading (ETL) and ELT Process using Informatica (8.6.0, 8.6.1), ODI (10.1.3.4.1) and DAC (10.1.3.4.1) .

Experience in performance tuning of sources, mappings, targets and sessions.

Proficient in translating business requirements into ETL logic using Informatica. Product development, generating test cases for unit testing based on requirements.

Experience in loading data, troubleshooting, Debugging mappings, tuning mappings, etc. Implemented performance tuning techniques at application, database and system levels.

Hands on experience in creating and customizing DAC Tasks, Subject Areas and Execution plans to load data from OLTP to OLAP stars.

Extensively worked on performance tuning in reporting and in informatica.

Very strong experience in developing OBIEE Repository (. rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Security Setup (groups, object and data level).

Expertise in converting and using Oracle OOTB rpd/pre-built rpd (HR, Supply Chain, Order Management, Procurement and Spend Analytics ), and PeopleSoft HR Analytics subject areas according to business requirements.

Experience in configuring Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots/Agents.

Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to star Schema, Dim Hierarchies, and Physical & Logical Data Modeling.

Generated many types of reports like RTF, EXCEL, and ETEXT using BI Publisher.

Well Versed with XPATH and XSLT.

Implemented Bursting logic for many BI Publisher reports to e-mail the output to particular list of users each time a report is run.

Hands on Experience in writing Oracle Sql’s.

Very good working knowledge in other reporting tools like Tableau, Microsoft PowerBI.

Worked in creating a Power BI pilot project for the demo to the business users.

Worked with Informatica Cloud (On Demand) to extract data from sales force.

Extensively worked on created long and complex templates for BI Publisher.

Experience in testing/debugging of invalid mappings, stored procedures, functions, Informatica sessions, batches and target data. Developed and scheduled various Pre-and Post-Sessions, Batches for all Mappings for data loading from Source files, Tables to Target tables.

Involved in Unit/Integration Testing & user training of the generated reports in OBIEE

Knowledge in merging applications from Dev - Test – Prod for deployment.

Establish scalable, efficient, automated processes by leveraging a wide range of environments and technologies. Excellent problem-solving skills with strong technical background and good interpersonal skills.

Technical Skills

Methodologies : Dimensional Data Modeling Logical / Physical.

Business Intelligence : OBIEE 10g/11g/12c, OBIA 7.9.6/7.9.6.1 & DAC, Power BI

ETL/ELT Tool : Informatica 8.6.0/8.6.1, Informatica On Demand, ODI10g/11g

Data Warehouse : OLAP, Star Schema, Snowflake Schema

OBI Apps Modules : Financials, Supply Chain, HR, OM & OFM, Sales

Databases : Oracle9i/10g/11g/12c, MS SQL Server2000/2005/2008/2012, Vertica.

Query Tools : SQL Developer, TOAD, TSQL

Languages : SQL, PL/SQL, Java, XML, HTML, JavaScript.

Operating Systems : Windows 98/00/NT/XP, Redhat Linux, Windows 2000/2003

Other : Visio, MS Office, Adobe Acrobat.

Microsoft : PowerBI Desktop, SPS2003, MOSS 2007, WSS (2.0/3.0), ASP.NET (2.0/3.0)

Professional Experience:

Ally Corporate Finance, Charlotte-NC February 2013 – Till

Ally Corporate Finance LLC provides financing solutions for equity sponsors and middle-market companies. The company’s portfolio comprises senior loans, including cash flow loans; and asset-based revolving credit and term loans. It offers loans to support various financing needs, such as leveraged buyouts, mergers and acquisitions, recapitalizations, growth capital, working capital, debtor in possession, and turnarounds/corporate restructurings.

Role: Sr BI Developer

Responsibilities:

Complete responsible for Installation, Configuration and Administration of OBI11g in all environments both in windows and Linux environments.

Installed and configured OBIEE 12c and involved in migrating the OBIEE11g to OBIEE12c .

Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.

Gathered capacity planning and end-user requirements for KPI development.

Implemented SSL for all the 6 environments for OBIEE11g, starting from creating certificates.

Participated in complete life cycle of the project, from project initiation, to development, to production support and maintenance.

Used Different BI Publisher Templates like RTF, Excel to replicate the layouts based on sample reports provided by the users for Counterparty Credit Risk Management team.

Worked in different modules of data analysis and reporting at Ally Financials like Ally Mortgage, Capital Markets (Bank, Investments, Insurance, Derivatives), GAP (Global accounting Platform),CAPS(Collateral Accounting Platform System),LCR (Liquidity Coverage Ratio), FR 2052A, Auto Payments Systems, HR Analytics, FSS (Financial Shared Services), CCR (Counterparty Credit Risk Management).

Configured image tables in DAC for SIEBEL Change Capture process to extract data into Staging Area through ETL Informatica (SDE Mappings).

Loaded data from Staging to Warehouse using custom Informatica Mappings (SIL Mappings) according to the business.

Created the custom mappings (SDE and SIL) in Informatica according to the business need and created the workflows.

Configured DAC for the new tables and Workflows created using Informatica.

Assembling subject area in DAC.

Worked in different subject areas of HR analytics like Compensation, Learning Management, Leave & Absence.

Customized actions in OBIEE Action Frame work for navigation between different pages of dashboard as per user requirements.

Implemented Security Model at each level (Application Level, Object Level and Colum Level) for Dashboard users.

Implemented performance tuning strategies like Aggregate Navigation, Caching strategies using OBIEE advance features along with the database objects design to improve the turnaround time of reports.

Tuned Performance, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.

Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.

Utilized Session variables, Repository variables and Initialization blocks in the Repository building and Modification procedures in OBIEE.

Evaluate and set strategies to implement infrastructure and application changes in OBIEE system and processes.

Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Worked closely with ETL developers for building aggregates for obiee.

Prepare documentation and communicate the status of the project to the management.

Complete responsible for administrative duties related to OBIEE maintaince .

Worked on Power BI to create some pilot projects like (Capital Markets and Ally Mortgage) for the business users to demonstrate the functionality.

Research and remain abreast with latest technologies and techniques to recommend new changes or upgrades.

Environment:

OBIEE (11g,12c), BI Publisher 11g, Oracle11g, PeopleSoft 8.0, BI Apps 7.9.6.5, Informatica 9.1.0,

DAC 11.1.1.6.4, Oracle12c Sql Server 2012, Oracle Exadate (X4), Windows Server 2012, Linux,

Power BI Desktop, SSRS, SSIS, Hyperion 11.1.2.4, Concur, Bigdata, SAP DW, Sql Developer,MS Office 2010 .

WebMD, NYC October 2010 - February 2013

The Company is a provider of health information services to consumers, physicians and other healthcare professionals, employers and health plans through its public and private online portals and health-focused publications.

Role: Sr Implementation Analyst/Administrator/Developer

Responsibilities:

Analyze activity data, provide assessments of trends, and position activity metrics to meet supporters’ objectives using Medscape’s data.

Provide additional insights and customized metrics reports on activity performance and impact to support sales in generating renewals for the Medscape Education business.

Work closely with the sales organization to assist in determining reporting needs based on supporter requirements

Completely responsible for all SDLC from Development to Production.

Installing and Configuration of Single Server and Multiple Instances.

Aggressively worked on implementing Single server and Multiple Presentation Servers on one box and maintaining them constantly without oracle Support (This type of architecture was not supported by Oracle).

Understanding the existing business requirements and implemented strong and complicated security architecture.

Aggressively used the session variables to implement the Data level security and object level security.

Implemented both LDAP and External table authentication for around 1100 users. This implementation runs parallel depending on who logs in.

Designed an well organized document for implementing the Security.

Implemented best practice methods for security in the front end such way that unnecessary login threads are closed forcefully, Bulk downloads are limited so that it won’t block the Server resources and network resources.

Experience in Performance tuning at the Database level by creating aggregate tables, RPD level by creating Database hints in the physical layer.

Extensively worked on tuning the reports by following the best practice methods like implementing Segmentation methods, Partitioning, Creating Materialized Views, Creating appropriate Indexes.

Implemented event polling methods to selectively update the tables.

Implemented usage tracking at Executive and VP level.

Completely responsible for END to END development in OBIEE.

Implemented most advanced techniques for dashboards look and feel.

Used narrative text, column selector, global and column filters to provide the functionality of viewing selective data for the end users.

Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.

Use Catalog Manager to move, merge and alter content from web catalog

Developed intuitive and user-friendly Dashboards by appropriately including guided navigational links, prompts, drilldowns and Go Urls.

Aggressively worked on Customization of look and feel of all different presentation server logins.

Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.

Extensively worked on scheduler using web services and burst mode that schedules 100’s of reports every month in CSV, RTF and PDF formats.

Developed complex RTF templates with more than 10 pages reports using BI Publisher.

Integrated OBIEE with Vertica Database and Developed an POC for BI Directors.

Performed unit and integration testing of reports and dashboards before releasing them to QA department.

Designed and conceptualized the extraction strategies and methodologies for data integrity.

Developed POC with OBIEE11g and Vertica as backend database.

Conducted UAT sessions with end users.

Perfectly maintaining the Project plan to release the different projects on time.

Environment:

OBIEE 10g, OBI11g, Oracle10g/11g, Vertica DB,Unix,BI Publisher 10.1.3.4.1,Sql Server 2008/2012

BIMINDS San Jose CA May 10 - July 10

Role: Informatica /OBIEE Developer

Responsibilities:

Installation, Configuration and Administration of Informatica Power Center Client, Server (8.6.1), Oracle 11g and OBIEE 10.1.3.4.1

Understanding the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.

Worked with the Business analysts and the DBA for requirements gathering, business analysis, and testing and project coordination.

Extracted data from various source systems like relational data bases, Flat files and

Data into the data warehouse using Informatica On Demand (2010 release).

Extensively used the Informatica on Demand for Replicating the Data from Sales force to local Database.

Developed new Adopters using Informatica 8.6.1, complete end to end Development against Salesforce.com source.

Extensively worked in developing Salesforce Adapters for Sales and Opportunities.

Created Facts like OpportunityLineitem, Opportunity History,Sales,Budget,Goals and dimensions like Opportunity, PriceBookEntry, User,Region,Account,

Created reusable transformations and Mapplets and used them in mappings.

Testing and Validating repository and Dimensions.

Analyzed reporting requirements for dashboard reports.

Custom built the OBIEE (10.1.3.4.1) repository (RPD) from the scratch with 4 Facts and 9 Dimensions and 4 confirmed Dimensions.

Performed high level and detailed design of the star schema.

Created some Reports for analyzing the Trend in Opportunities, sales and Sales Reps Efficiency etc.

Provided the Object level and Data level security.

Complete responsible for migrating the whole Dev Environment to Production Environment.

Complete responsible for preparing the END to END Document.

Environment:

OBIEE 10.1.3.4.1, Informatica 8.6.1, Informatica On Demand, Sales Force, Flat Files, Oracle10g.

BIMINDS San Jose CA Nov 09 - April 10

Role: Informatica Developer/OBIEE Developer

Responsibilities:

Studying the existing application architecture, designing and identifying the reporting requirements and prepare the requirements specifications document. This involved interacting with the business users and understanding the requirements.

Extracted data from various source systems like relational data bases, Flat files and

Data into the data warehouse.

Performed the Incremental ETL process using DAC to populate the Data Warehouse.

Implemented Out of the Box Supply chain analytics (Order Management and Order Fulfillment analytics).

Configured DAC for the new tables and Workflows created using Informatica.

Assembling subject area and build new execution plan in DAC.

Executed full load and then incremental loads in DAC.

Worked extensively on performance issues and fine-tuned transformations, mappings and sessions. Involved in optimizing the performance by eliminating Target, Source, Mappings and sessions bottlenecks.

• Used Filters and provided customized prompts (filtering options) appropriately to avoid excessive data showing up reports.

Involved in Usage Tracking Implementation.

Used Analytics Web Catalog to set up groups, access privileges and query privileges.

Used and customized Prompts for the reports in dashboards. Created filters that you drill on using column prompt according to the client’s requirement.

Use Catalog Manager to move, merge and alter content from webcat.

Support for the Informatica and DAC (10.1.3.4) related Issues.

Environment

OBIEE 10.1.3.3, Informatica 8.1.1, OBIA 7.9.5, DAC 10.1.3.4, Oracle EBS 11.5.10, Solaris, Oracle 10g Database.

Education

Masters In Computer Engineering

GPA: 3.5

LinkedIn Profile:

https://www.linkedin.com/in/nagendra-vakalapudi-930a0419

Contact this candidate