Same desciption as VMware Project Section

Using SFDC as a source system. Creating reports and analyzing data in SFDC. Other description is same as VMware project.

Client is one among the leader in Virtualization software. VMware streamlines the journey for organizations to become digital businesses that deliver better experiences to their customers & empower employees to do their best work. Their software spans compute, cloud, networking & security, & digital workspace.

Accenture has been hired to assist VMWare with building Analytical environments (Business Intelligence) that will allow VMware to capture majority of the remaining market opportunity in the virtualization software market, it includes laying the foundation for enterprise reporting & analytics.

Responsibilities:

Ø Manage complete life cycle of DEV project from requirement gathering till support (analyze, design, build, test, implement, support).

Ø Work with Business End users in formulating BRDs (Business Requirement Document) & prepare FRD (Functional Review Document), then connect with dev team to create TDD (Technical Design Document), Finalize the requirement & drive it to completion.

Ø Lead multivendor roadmap team (25+) including FTEs.

Ø Guide Dev team with Functional & Technical details of the change.

Ø Manage delivery of all (26 modules currently) BI modules running for VMware from Accenture including 45+ resources onshore & offshore.

Ø Work towards project growth & new RFPs.

Ø Manage Project financials & resources.

Ø Implement & Drive process improvements, automation, Ideas & Innovations.

Ø Regular status reporting with minute details of all the modules to client & management.

Ø Taking interviews & onboarding resources.

Ø Code migration, deployment, unit testing, regression testing, post production support.

Ø Innovative in Approach, Proactive in learning new methods & ideas & putting them into daily practice, ability to work on multiple projects & multiple technologies.

Ø Role includes a mixture of responsibilities requiring strong technical background with excellent problem solving, analytical & communication skills, Leading/Managing team & co-ordination with onsite team/client.

Accomplishments:

Ø Picked up SAP HANA, BOBJ & Tableau while working on OBIEE. Initiated 1st Tableau project for client.

Ø Gained client trust & confidence over the period.

Ø Created few assets, which are used by other projects also. (”Development lifecycle", "Basic concepts of RPD", "Peer Review Checklist", Knowledge documents on iBOTS, disconnected analytics, DAC & RPD merge/comparison, OBIEE induction Kit, Unit test plans.)

Ø Created & managed Repository Groups, Variables, Initialization Blocks, hierarchy, aggregates, performance, security & Administration, iBOTs.

Ø Good knowledge of configuring & developing the Analytics Repository (Physical layer, Business model & mapping layer & Presentation layer) which involves schema import, implementing the business logic by customization of dimensional hierarchies, Aggregate Navigation level based Measures, Variables, Initialization blocks & Cache management.

Ø Creating & Modifying Analytics Reports including Charts & Pivot views, Compound layout using global & local Filters in Answers & Configured Intelligent Dashboards for different groups of users. Creating OBIEE objects which involved complex processes & logic implemented like Union Reports, Presentation variables, Set-operators etc.

Ø Taken more than 100 interviews. Managed team of 45 people with multiple skills. Mentored 20+ resources in OBIEE.

Ø Always tried to complete the work before deadline even though it may take in some extra efforts.

Ø Created a logical fact table at the OBIEE rpd which involved complex joins & snow-flaking of the dimensions. The development was very complex which was greatly appreciated by the client.

Ø Worked on config.xml for changing the various reporting configuration.

Ø Used Informatica Workflow Manager to create, schedule, monitor sessions & send pre & post session emails to communicate success or failure of session execution.

Ø Made complex SQL queries as per the requirement.

Ø Involved in bug fixing & enhancements cycle.

Ø Helped team members in resolving their technical issues related to OBIEE, Informatica & UNIX along with PL/SQL, PPTs, Mails & excel spreadsheet formatting. Cross trained the resources of different projects on OBIEE.

Ø Got many awards like 'Shining Star' Award for the delivery, client award in the category "Drives for Value Added Results", client award in category for "Delivery Excellence & Leading as Team Player" presented by CFO of the company.

TouchStone Reporting & IC (Information Center) Siebel Analytics teams deals with the Load Process using ETL tools (like DAC & Informatica) for loading the data from OLTP to OLAP, Siebel Analytics Reports management & enhancements in Rpd & Webcat, Enhancements & maintenance of Informatica workflows & mappings. It is one of the world’s largest applications in terms of the number of user support for Siebel Analytics.

Responsibilities:

Ø Handling Touchstone Reporting & IC Analytics applications end to end.

Ø Identifying & analyzing the issues & setting up a proper foundation to resolve the same in the specified time & complying with stringent SLA’s for various categories of Service Request (Meeting 100 % SLA’s).

Ø Analysis, design, development & testing of Analytics metadata Repository (.rpd) at 3 layers i.e., Physical Layer (connecting to Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping with dimensions, facts, aggregators & time-series objects) & Presentation Layer level (create presentation catalogs).

Ø Creating & managing Repository Groups, Variables, Initialization Blocks, hierarchies, calculation measures, iBOTs & User Administration using Siebel Analytics Administration Tool & Security Manager.

Ø Creating & Modifying Analytics Reports including Charts & Pivot views, Compound layout using global & local Filters in Answers & Configured Intelligent Dashboards for different groups of users. Creating the Dashboard & Report level prompts.

Ø Performance Analysis of Analytics Dashboards. (Worked in a Data Reduction Module with SME’s (Subject Matter Experts) of Siebel Analytics & Informatica.)

Ø Design & Configuration of the DAC (Data ware house application console) tool.

Ø Working on config.xml for changing the various reporting configuration.

Ø Working in Analytics Disconnected which in involves synchronization of data from connected environment.

Ø Starting & monitoring the load processes which have been scheduled in DAC.

Ø Implementing the mappings by using Source Qualifier, Filter, Expression, Aggregator, Sorter, Lookup, Joiner, Sequence Generator, Router & Update strategy transformations.

Ø Importing Source & Target tables from the respective databases & created Reusable Transformations, Aggregations & Target Mappings that contain business rules, using Informatica.

Ø Involved in migrating the mappings & OBIEE code into different environments.

Ø Performed Unit Testing & tuned the mappings for better performance.

Ø Using Informatica Workflow Manager to create, schedule, monitor sessions & send pre & post session emails to communicate success or failure of session execution.

Ø Developing SCD's to maintain the historical data.

Ø Play major role in onshore offshore co-ordination. Responsible for doing the peer reviews.

Ø Analyzing, Writing, Testing & Implementation of the stored procedures, functions using PL/SQL. Making complex SQL queries as per the requirement.

Ø Involved in documentation of Reports Specifications, Dashboard Specifications, Repository Documentation & End user training documents. Creation of SOPs & Checklists.

Ø Involved in bug fixing & enhancements cycle.

Ø Handling different schemas & synonyms across the databases.

Ø Creation of spreadsheet with the monitoring activities & Regular status for all the applications across the project to be sent to client team lead on the daily basis.

Ø Organizing various fun events on behalf of the DU (Delivery Unit) & involved in CSR (Corporate Social Responsibility) activities, wherein helping different NGOs.

Ø Loading data from one environment to other using Jobscape (Autosys).

Ø Cross training resources of different projects on Siebel Analytics Disconnected.

Ø Leading Interns joined project for their internship.

Accomplishments:

Ø Expertise in Siebel Analytics (OBIEE) Disconnected, configuring DAC & configuring ibots to deliver analytics contents. Worked on the upgrade of SA to OBIEE.

Ø Good understanding of Siebel Application Administration (CRM) & Siebel 7.x based CRM implementation. Trained in Siebel Tools, SAS BI & Data Stage.

Ø Good Knowledge on Data warehousing concepts like Star Schema, Snow flake schema, Dimensions & Fact tables.

Ø Strong writing & documentation skills for management, development & control of documents, SOPs & Checklists.