BI ARCHITECT DATA MODELING ARCHITECT DATA ANALYST OBIEE ARCHITECT BUSINESS ANALYST AND MSTR
Work in challenging and growing work environment to utilize my technical knowledge and expertise in an effective way Experience in handling all phases of SDLC for BI Projects Expertize in designing STAR schema and developing complete reporting solution based on the requirement Experience in implementing more than 10 full time OBIEE projects (to name few major projects: complete BI implementation in Telstra Australian Telecom, Production Support and Enhancement in Kraft Foods, Performance improvement project in Kraft foods, Customer Care Avaya in Cox, Corrective Action Tracking for Field Service in Cox FS, Technician Performance Management in Cox, Go All Digital in Cox, Oscar Effectiveness in Cox Marketing etc) Expertize in implementing Security administration - Data level and Object level security in OBIEE (to name few projects: Multi country security implementation in Kraft Foods and Complex Security requirement for Technician Performance Management system in TPM for Cox FS) Experience in effective utilization of Session Variables, Init blocks and building complex drill-down and interactive dashboards with Guided Navigations Experience in BI Performance tuning through Cache Management, Combining Dim and Fact Extension tables, introducing parallel hints, reducing internal joins etc Experience in DAC concepts and implementation for workflow scheduling and implementing Incremental refresh in EDW Experience in Data analyst role directly interacting with business and providing reports, writing SQL queries and modeling data to satisfy customer needs Experience in creating cube within OBIEE using OWM to improve performance Experience in Offshore/ Onshore model as well, served as Onshore technical lead for 4 years managing a team of 12 developers Career Achievements Best Innovator 2014" in EIM Practice within Cognizant Technology Solutions EIM Awesomist" award in Cognizant Technology Solutions Above and Beyond" award for performing a critical role in multiple Cox projects DW achievement" award from Cognizant Technology Solutions Best Team Performer" award within Telstra in Accenture Services Private Ltd Client appreciation on performance improvement [improving performance of 6 daily used segments from 6 hours to 50 mins[attaching an appreciation email from business]
BI Architect, Data Modeling Architect, Data Analyst, OBIEE Architect, Business Analyst and MSTR, QuickBase Developer,
Data Analyst role for Cox Marketing team, analyze data, write SQL's, develop reports in MSTR.
OBIEE Architect, OBIEE Onsite Technical Lead, OBIEE Offshore Team Lead, OBIEE and Siebel Analytics Developer
gathering requirements, suggesting reporting needs to clients and documenting BRD, TRD, Granularity Metrics etc) Data analyst role (working along with end business users), analyzing data, modeling tables, creating reports on ad-hoc basis.
Exhaustively handled all roles here right from analyzing data, modeling tables, loading tables, designing reports and finally creating reports for end users Production support Offshore lead (24/7 production support for Telstra, handling client calls, analyzing tickets and resolving them within SLA) Technical Acumen Oracle Business Intelligence Enterprise Edition 11.1.1/10.1.3.x, Siebel Analytics 7.8.4, Siebel Analytics 7.7 Microstrategy 9.4.1 Marketing Analytics Oracle Workspace Manager for OLAP Knowledge of Informatica Oracle 10g and 11g Experience 10 years and 5 months" experience in delivering Business Intelligence solution by gathering requirements, analyzing data, developing solutions, testing and deploying Business Intelligence application using OBIEE [hands-on in Siebel Analytics 7.7, 7.8, OBIEE 10G and OBIEE 11G] Working knowledge of data modeling, ETL (Informatica and DAC, used as scheduling tool) Extensive experience in OBIEE 11G, 10G, Oracle BI applications, Siebel Analytics 7.7, 7.8, Marketing Analytics, which includes creating, configuring, customizing and managing repository and Presentation services (Answers, Dashboards & Delivers), BI (RPD and Web-catalog) administration Marketing Analytics [creation of List Formats, Load Formats, Marketing Segmentation] Trained Microstrategy resource and have 6 months of current experience in working on MSTR version 9.4.
OBIEE Architect, Onshore Tech Lead, Business Analyst and Offshore Team Lead, Cox Communications
Work Duration: Nov 2009 till Date Organization: Cognizant Technology Solutions Tools/ Applications: OBIEE 11G, 10G, OLAP [OWM], JAVA/ OBIEE integration Discuss with Clients on requirement, documenting and recommending OBIEE solutions Design reporting structures based on requirements, provide support in OBIEE architecture organization through database design, modeling and implementation Understand analytical need of client and design valuable BI and ETL solutions accordingly Using best coding practices of business intelligence to design the analytical solutions Interact with Offshore team and provide insight about project requirement, educate them on the design and do code reviews on the Reports and RPD Understand future requirements and model concepts of the project Learn new business processes and OBIEE solutions to be applied Provide training for new team members on OBIEE Conduct Interviews for Organization to recruit OBIEE candidates Also part of Offshore team as Offshore Team Lead Understanding requirements communicated by Onshore team, build solutions and perform testing Provide Production support for the reporting solution built Projects Handled in Cox: All Digital Program Technician Performance Management: OBIEE architect and technical lead Corrective Action Tracking for Field Technician: OBIEE architect and technical lead Apollo: played OBIEE onshore technical lead role Credit and Collections: played role of OBIEE offshore technical lead Challenges handled in each project: ALL DIGITAL: The Digital Switch program is a comprehensive plan to enable Cox Communications to recover bandwidth.
As part of that effort, Cox will deploy HD-uDTAs or Cable Card (referred as Mini Box in this document) to receive encrypted digital channels, to all customers currently using analog service (ClearQAM TVs).
This will be done as part of a multi-phased, multi-year rollout, as well as Analog decommission across Cox markets.
By deploying the Mini Box, Cox will recover bandwidth which will be re-allocated for other Cox existing and new services.
TPM: Technician Performance Management is the first of kind where we integrated OBIEE with Java to achieve write-back functionality.
There was specific requirement to dynamically change values of metrics and still calculate performance based on the modified metrics value.
OBIEE write-back feature has huge limitations which we resolved by performing all write-backs in Java and integrating the same with OBIEE.
The project received positive responses from clients and was rated even at a 11 scale out of 10.
CAT: "Corrective Action Tracking" was first of the project in my career where we delivered development of 90+ reports [which involved complex calculations, budgeting, forecasting data from Essbase, year on year comparisons and trending data summary] with 4 weeks of design and 5 weeks of development and met all client expectations.
There was performance issue for 2 reports which were resolved later but overall delivery was a major success.
Apollo: This major challenge was with respect to volume of data with respect to call center.
Cox has a reporting performance standard of 35 seconds and Apollo had specific requirement to support all 4 time zones.
POC's was carried out using OWM [Oracle Workspace Manager] to create cubes in order to improved performance and the best solution was overlaid which resolved all performance issues.
Credit and Collection: This program had 3 simultaneous projects to be developed within the same subject area.
Being offshore technical lead, challenge was to keep development activities of all 3 projects carried out in parallel and appropriately synced.
to 10/2009 Telstra Accenture Services Pvt Ltd
Positions Handled: Offshore Team Lead and Production Support Tools/ Applications: Siebel Analytics 7.8.4, Marketing Analytics and ETL [Vanilla Applications, Integrated Environment] Part of the development and Production Support team Take care of CR's along with Production Support tickets Client interaction, understanding SR and providing resolution at the earliest Resolve Service Tickets within the SLA [SLA for high severity tickets are 4 hours which improved problem solving skill in Marketing Analytics, Siebel Analytics and ETL] Troubleshoot all issues and figure out the root cause/s of those issues Interact with Onshore team on explaining resolutions to direct Telstra Application users Major Challenge faced in Performance improvement of Segments/ Segment Trees Suggest improvements to Segment Trees Challenging role on Marketing Analytics [interacting with Siebel Marketing, ETL and Siebel Analytics to find root cause to problems].
Offshore - Developer and Production, 12/2007
to 11/2008 Kraft Foods Accenture Services Pvt Ltd
Siebel Analytics 7.7 and ETL Monitor ETL loads for different countries Resolve bugs in case ETL loads fail and raise SR for starting Control M job Resolve RPD related SR's within the SLA Perform ETL build activity, changes to SDE and SIL mappings based on the customizations in OLTP side.
Help the design team to formulate Technical and Functional Design Documents for the developments Do detailed case studies on the upgrade process to [upgrade Siebel Analytics from 7.7 to OBIEE 10G] Implementing Performance Improvement on Siebel Analytics reports [A complete phase to improve report performance, merging Facts with Extension tables etc] Completed an Internal Project [pro-actively] to monitor productivity of Employees within the team.
Offshore Developer, 04/2006
to 12/2007 Telstra Accenture Services Pvt Ltd
Siebel Analytics 7.8.4, Marketing Analytics and ETL [Vanilla Applications, Integrated Environment] Customize and Optimize data warehouse for Siebel Analytics Users Create and Customize RPD/ Reports to cater to business needs Create Export List Format, Load Format and Segmentation Subject Areas, also create Target Levels for the same.
Create List Formats and Load Formats in Siebel Analytics Web, create campaigns in "Siebel Marketing" application, loading the campaign and generate output list with respect to the Segmentation Criteria.
Follow Oracle Coding Standards while performing customizations in RPD Part of development team, provide testing support, co-ordinate with Onshore and Offshore team members First Siebel Analytics Project helping me acquire complete exposure in creating RPD, and exploring a new area called 'Marketing Analytics' Exposure in Siebel Answers [creating Dashboards, Reports, List Formats, Load Formats etc].
Master of Computer Application: RVS Arts and Science College -
Bachelor of Computer Application: Sri Krishna Arts and Science College -