Specialist Master Resume
4.00/5 (Submit Your Rating)
SUMMARY
- BI Enthusiast with more than 10 years of experience implementing analytical solutions that provide clients with key insights into their performance and empower them to make strategic business decisions.
- Leveraged industry best practices in technology as well as consulting to design and implement meaningful BI solutions for clients.
- Implemented end to end packaged as well as custom BI solutions for clients using leading Business Intelligence and ETL tools.
- Wrote technical papers on various capabilities of OBIEE like Migration Procedures, Branding, using XML as a source, Performance Tuning Techniques and many more.
- Imparted local office trainings on OBIEE and ODI and contributed to various RFPs, Feasibility Studies, technology Boot Camps and recruitment drives within the organization.
- Mentored, groomed and motivated the team to help them deliver their best and to prepare them for higher roles by providing career counselling.
- Currently helping a market leader in biotechnology upgrade its analytical reporting platform and build new insights into its Manufacturing, Supply Chain, Procurement and Spend and Financial data.
- Helped a leading US based bank consolidate and analyze its profitability data in a manner that influences key business decisions, by implementing a complex custom BI solution. The profitability platform allows users to assess customer relationship value, drive pricing and gauge officer and business performance.
- Enabled a Canada based health care provider to build a management reporting solution giving insights into its Financial, Procurement, Pharmacy and Payroll data.
- Empowered a major health insurance provider to better plan and execute its CRM strategy by implementing a comprehensive Marketing Analytics solution.
- Enabled a US based investment banking major to investigate exceptions and infractions in its transactions by implementing an integrated analytical reporting solution for its Compliance division.
WORK EXPERIENCE
Specialist Master
Confidential
Responsibilities:
- Conduct requirement workshops, understand and identify gaps in the existing BI framework and determine what KPIs, reports and dashboards need to be built to fit those gaps
- Translate business requirements into functional design and eventually into technical design
- Conduct front - end design workshops and collaborate with business users to define the report wireframe
- Design reporting data model and build the semantic layer for reporting in the RPD using Admin Tool
- Build analytical reports using Answers and actionable intelligence using Delivers
- Understand and define security requirements and implement row level and object level security
- Analyze the SQL and MDX queries generated by reports and employ case based optimization techniques to reduce the report turnaround time as a part of the performance tuning cycle
- Configure Multi-user Development Environment (MUDE) for the RPD and act as a gatekeeper to ensure the conflicts arising due to modifying shared objects by different developers are resolved appropriately
- Migrate the RPD, presentation catalog, customized configuration files, users and application roles to higher environments
- Interact with business users on an ongoing basis to ensure the solution being designed is in sync with the requirements
- Support the SIT and UAT cycles by tracking defects to closure
- Coordinate with various teams within the project to ensure smooth integration of different pieces of the solution
- Lead and mentor the team both at onsite and offshore
Consultant
Confidential
Responsibilities:
- Install and configure OBIEE in both standalone as well as clustered environments and perform upgrades as and when new releases became available
- Implement Single Sign On to allow seamless integration between OBIEE dashboards and other applications
- Configure the reporting data model in the RPD using Admin Tool
- Design and build insightful analytics in the form of reports and dashboards, using Answers
- Identify and create aggregates, partitions, indexes, etc. in the warehouse to improve report performance
- Develop simple ETL mappings in Informatica and monitor data loads in DAC
- Configure iBots to schedule report delivery to key users as well as for cache seeding for routine reports
- Implement row level and object level security
- Support different phases of testing during the lifecycle of the project by analyzing and fixing defects