Saurabh Gupta

About Saurabh Gupta

Scaling new heights of success and leaving a mark of excellence in assignments that involve analytical capabilitiesand professional growth; targeting assignments in Data Visualization/ Data Analytics / BI with an organization of repute.Goal-driven Technocart with over 13 years of experience in definingshort- & long-term strategies for corporate BI/analytics programto ensure effective delivery of information that met current & futurerequirements in Finance and Telecom industry.− Spearheaded design, build, implementation & optimization of BIsolutions/technologies including Reporting, Dashboards & story visualization− Excels in business intelligence and data warehouse environmentsincluding system administration, database design, dimensional modelling,security, reporting & analytics− Provided guidance to top management on KPIs, metrics, and businessdecisions including accurate analysis of user and business data− Created designs & plans for the integration of all data warehousetechnical components− Interfaced with clients to identify business problems and developstate-of-the-art solutions aligned with business objectives− Steered development & support of the Business Intelligence (BI)tools including MicroStrategy, Power BI & SSRS; Hands on experiencein data analyticsguiding a team of 8-10 members for delivery of full lifecycle development,architecture, systems, production operations/support, dataanalysis and ad-hoc reporting

Experience

1. Authorized Officer

   UBS

   May 2019 — Present · Pune, IN

   Managing schema development changes/enhancements effectively. Extensively working in creating Attributes, Facts, Metrics, Views and Relationships between various attributes and developed perfect logical models for reporting environment.• Working with the Business Analysts and involved in gathering business requirements and determining the appropriate facts, attributes and metrics from the same and documented them.• Working with R Integration to create advanced derived metrics deployed Custom R scripts to fulfill analysis requirement.• Working with QA team to oversee stress testing and performance tuning operations.• Providing end user training for the MicroStrategy Web users.• Deploying an object on different server using object Manager.• Gathering requirements from clients, designing suitable data model based on requirements.• Attending daily scrums calls and working in Agile environment.

Education

• IIMT ENGINEERING COLLEGE, MEERUT

  MCA, COMPUTER APPLICATION

  2006 — 2009

• Indira Gandhi National Open University

  BCA, Computer Application

  2002 — 2004

Skills

• Ssrs
• Teradata
• Databases
• Sql
• Microstrategy
• Sql Server Integration Services (Ssis)
• Microstrategy Reporting
• Business Objects
• Ssis
• Data Warehousing
• Business Intelligence
• Microsoft Sql Server