Manager Management

DEEPIKA GUPTA

Business Intelligence Analyst +1-424-***-**** ********.*@*****.***

PROFILE

10+ years of IT experience in Business Intelligence and data warehouse with knowledge of complete SDLC process including requirement analysis, design, development, testing, implementation and maintenance of application software.

Experience in writing unit test cases, unit testing, system integration Testing (SIT), providing support to user acceptance testing (UAT).

Extensive experience in gathering, understanding and writing BRDs (Business Requirements Document), Functional Specification, Use Cases and technical document.

Leading the 24*7 Production Support team and handling Incident/ Problem/ Change requests, proving root cause analysis for all problems and having them completed within time limit. Attending meeting with higher management on SLA’s, Enhancements and Tickets (Incidents/Problems/Changes).

8+ years of experience in SAP Business Objects (BI4.x/BI4.1/XIR2/6.x, Rich Client, Servers installation & Configuration, CMC, Auditor, Repository Migration, Report Conversion Tool, Universe Designer, Desktop Intelligence, Info View, Business Objects 6.x, Info view, Crystal Reports 2008, Import Wizard, Web Intelligence, Broadcast Agent, Schedule Manager, Broadcast Agent Publisher, BO Application Foundation, enterprise monitoring and Performance Manager).

Involved in Implementation of XIR2 to BI4.x. Provided estimates, prepared issue tracker to higher management.

Experience in Tableau BI Products (Tableau Desktop, Tableau Server and Tableau Reader). Technically hands-on experience with creating the dashboards and reports using Tableau Desktop tool and building various dashboard development activities such as Dashboard layout design and development, Tableau Extracts, Tableau Actions, Tableau Dashboards color coding and formatting

Experience in SSRS (Reporting services) and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Form, OLAP and Sub reports, and formatting them

Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms and analytical functions. Developed advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.

Well versed with Data Warehousing, Data Marts, Star & Snow-flake Schemas.

Trained end users on Business Objects Products.

SKILLS SUMMARY

Business Area

Media and Entertainment

Technical Skill

Business Objects 6.5, XIR2, XI R3.1, BI 4.x, Crystal Report, Tableau, SSRS

Data Bases

Teradata, Oracle, SQL Server

Other Tools

PL/SQL Developer 8.0, TOAD, SQL Server Management Studio, WINSCP 4.3.5, Putty, Toad, ServiceNow, HP Quality Center

Operating Systems

Unix (IBM AIX 2 5), Windows 7, windows 2003, Windows 2008/2012

PROFESSIONAL SUMMARY

Client- Sony Pictures Entertainment Inc., Culver City, CA, USA

Jan 2007 – Dec 2016

PROFESSIONAL EXPERIENCE

Role: Business Intelligence Analyst (Tableau/Business Objects)

Period: Mar 2015 – Dec 2016

Responsibilities:

•Gathered user requirements by interacting with business stakeholders.

•Analyzing and understanding business requirements and provided Estimation for the requirements provided.

•Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.

•Understand the business requirements and identified gaps in different processes and implemented process improvement initiatives across the business improvement model.

•Conducted peer design and code reviews and extensive documentation of standards, best practices. Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.

•Actively participated / arranged with number of iterations between team and customer on domain related tasks.

•Involved in reviewing of technical and non-technical document related to any new Enhancement or any Production

•Developed existing reports which are required to run day to day business like daily/weekly machine consumption reports or daily shift revenue report.

•Managed Incident, problems and SDLC process using Service Now Tool. Participated in the Incident Management and Problem Management processes for root cause analysis, resolution and reporting to higher management.

•Created SQLs to test report data accuracy related to orders, customers, studios, by weekly or daily using Teradata.

•Support and maintain data warehouse for users and senior management this include ETL, troubleshooting and BO reports on Teradata database.

•Created Ad-hoc report as per user requirement.

•Data analysis on the files received from different vendors like Rentrack, Cinemascore, Rotten Tomatoes, CAN, POS, Sales e.t.c

•Developed complex reports and dashboard to show KPI’s in graph and chart by Customer by Month in Tableau, which helped to monitor key dimensions.

•Developed complex reports in Business Objects using Web Intelligence, Infoview and Web Intelligence Rich Client for display complex calculation for User community.

•Involved in upgradation from XIR2 to BI 4.x. Tested new environment on sandbox during POC, given estimates and release dates to higher management. Co-ordinate with Application owners for any outstanding issues. Planned outages and communicated to all Application owners.

Role: BI and Data Analyst (SAP Business Objects/ Administration/ Tableau/ SSRS/Crystal Report)

Period: July 2011 – Feb 2015

Responsibilities:

•Manage Production Support & Enhancements Delivery for 14 BI applications (1 Data warehouse and 13 operational reporting applications) across multiple departments within Home Entertainment, Motion Pictures & Corporate lines of business. Handling all kind of issues like Data issues, small enhancement (request for Adhoc report creations), and big enhancements (creating canned reports used by higher management).

•Handled projects through all phases of SDLC and also support projects after Production deployments.

•Analysis data from multiple source system and create design according to user requirements.

•Developed on demand Adhoc reports for users for their critical data analysis.

•Created derived tables in the designer to enhance the capabilities and performance of the universe, implement cascading prompts in universe, defined aggregate SQL functions on measures to improve performance, checked the cardinalities, contexts, joins and aliases for resolving loops & integrity of the Universes, addressed Chasm Trap and Fan Trap using Multi-Parse SQL. Applied Filters and prompts, Report linking, Slice & Dice, Graphs/Charts.

•Created restrictions for users, objects and classes based on universes privileges.

•Updated and submitted reports to Broadcast Agent to be displayed on Intranet on daily and monthly basis for easy access to data.

•Enhanced/modified existing Crystal reports by creating new Parameters, Formulas etc.

•Experienced in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports Modified old and created new reports and sub reports using Crystal Reports.

•Developed Tableau workbooks from multiple data sources using Data Blending.

•Built dashboards for measures with forecast, trend line and reference lines.

•Designed Dashboards using Filters, Parameters and Action Filters

•Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

•Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of Dashboard Action, Data Source and Context Filters according to the end user requirement.

•Extracted data from internal data warehouse system to SSRS

•Created, designed and deployed Tabular, Matrix, Chart, Drill-down, Drill through and Ad-Hoc reports on report Server.

•Used CMC (Central Management Console) for checking server status, updating server configuration to increase performance. Instance manager for checking schedules. Managing Events, Authentication (LDAP). Adding, removing Users, groups, reports, universes and connection and assigning access.

•Migrated reports, users, groups and connection from 6.5 to XIR2/4.x. Used Import Wizard tool for creating backups in XIR2. In 4.x we used Promotion management for migration.

•Experience with Business Objects Security Implementation (User level, Row level and Object level).

Role: Business Objects Administrator (Business object 6.5, XIR2 Administrator. Windows & Unix server)

Period: April 2009 – Jun 2011

Responsibilities:

•24*7 Support for all 27 Business Objects Applications in Sony Pictures Entertainment over all department.

•Experience with Installing, Configure and Administration of entire hardware, and software products like Tomcat and Apache as Application, service packs, fix packs and Web Servers (Clustered and Standalone environments).

•Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.

•Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).

•Adding Web Intelligence servers for special users to run their huge report.

•Created Groups, Users, Connection and setup security.

•Added Fonts and Images on Servers to help developers.

•Experience on CMC (Central Management Console) for all Admin related activities.

•Monitored servers and setup automated email notification if any servers go down of full memory.

•Worked with Business Objects vendor for product defect related issues

•Updated Server configurations for better performance.

•Configured SMTP on server to allow users to schedule report and send them to other resources.

•Providing explicit security access to Power Users.

•Used FTP for placing exported file through report Schedule.

•Expertise in working with all the modules of Business Objects Designer, BO User, Web Intelligence, Desktop Intelligence, CMC, CMS and Crystal Reports.

•Experience in performance tuning, identify and resolve performance bottlenecks.

•Managed all installation, upgrades and configuration from start to end. Updated all documents like Installation documents, Upgrade documents, Configuration documents, release notes and communicating to Application owners for any king of outages.

Role: Developer (Crystal reporting, Microsoft Excel, Oracle 9.1)

Period: January 2009 – March 2009

Responsibilities:

•Created Crystal report for Ongaurd Reporting.

•Report Contain information employee’s Swap In & Out time.

•Created Sub reports to mail reports to get more details.

•Database Analysis to make sure all the necessary data is available and correct for reporting

•Preparation of test plans to cover all the changes with respect to the business requirement.

•Testing the Report Design to make sure it handles the large reporting requirement

•Universe Design to support the data analysis & breakdown

•Reports Enhancement as per the change in the business and market trend

•Defect remediation & facilitation through Quality center

•Documentation of the Reports Design & Functionality

Role: Developer (Business Object XIR2, Oracle 9i)

Period: October 2008 – Dec 2008

Responsibilities:

•Worked on XIR2 version of Business Objects and created Web Intelligent reports.

•These reports where highly formatted reports.

•Applied Row Shading in this report.

•Linked Report with Application by using Opendoc functions.

•Quality Implementation of the report design and the Business Objects functionality to get the best output.

•Attending meetings with application owners and developers to find out the reports to migrate

•Logging Defects SPE Quality Centre to maintain the pattern of defects and keep record of the remediation done.

•Development according to the Business requirement by following all SPE standards and guidelines.

Role: Developer (Business Object 6.5 and XIR2)

Period: March 2007 – September 2008

Responsibilities:

•Worked on migrating different versions of Business objects reports like 5.0.3, 5.1.x and 6.5.1 to XIR2

•Attending meetings with application owners and developers to find out the reports to migrate

•Logging Defects SPE Quality Centre to maintain the pattern of defects and keep record of the remediation done

•Fixing the defect in the migrated report so that the result will remain same

•Writing test scripts to test reports after various phases of migration to make sure users are getting correct data

•Provided solution on issues coming during Migration of reports

•Understanding client business and thus gain adequate domain knowledge

•Testing and migrating all report from Business objects 6.5 version to Business Objects XIR2

EDUCATION SUMMARY

B.E., Jawaharlal Institute of Technology(RGPV), Borawan, Khargon, Indore, M.P., India 2006

Contact this candidate