We provide IT Staff Augmentation Services!

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

We'd love your feedback!