DEEPESH MANGAL

Email: adj9a0@r.postjobfree.com

Phone: 646-***-****

SUMMARY

Over all 7 years of strong IT professional experience on SAP HANA, SAP Data Services, OLAP Data Warehousing and Business Intelligence using BusinessObjects XI R3/R2/6.5.1, BO Developer Suite (Designer, CMC, Supervisor, Desk I, Info view, Broadcast Agent, Web Intelligence, Performance Management, Dashboard Manager, Voyager and Crystal Reports, Xcelsius).

Experience in Designing/Developing the User-Interface (Universe/Data-Model), Developing Canned/Ad-hoc Reports, Scheduling and processing of reports using Broad Cast Agent and Supervisor.

Working experience on transforming data from various data sources to a Data warehouse using various ETL tool like Informatica, Data Integrator.

Strong Experience in Designing/Developing Dashboards by using SAP Lumira Discovery and Lumira Designer.

Extensive worked on different data provisioning technique like Flat Files, SAP Landscape Transformation (SLT), SAP Business Object Data services (BODS), Smart Data Access (SDA), Smart Data Integration (SDI)

Experience in Designing/Developing the User-Interface (Universe/Data-Model), Developing Canned/Ad-hoc Reports, Scheduling and processing of reports using Broad Cast Agent and Supervisor.

Expert skills in Data integrator XIin design, creation, and implementation of Data Integrator scripts and performing simple and complex transforms in Dataflow.

Written DI Scripts for implementation of Recovery Mechanism for unsuccessful batch jobs execution.

Expertise in analysing, designing, developing and administration of Universes, Reports and Dashboards as well as defining meta-data for end user reporting.

Worked on Data Modelling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 2.0

Strong Experience in Designing/Developing Dashboards by using SAP Lumira Discovery and Lumira Designer.

Experience in using various Data Providers like Universes, Stored Procedures, Free Hand SQL, and Personal Data Files for retrieving Data and creating Complex and Ad hoc Reports.

Created WSDL’s using query as a web service and implemented WSDL’s into dashboards.

Designed and built Universe, reports using Web Intelligence, Crystal Reports 2016 on the top of the SAP BEx queries.

Experience in migrating Business Objects Older versions to newer versions.

Experience in Installation and Configuration of Business Objects Enterprise XI R2/6.5.

Worked on installation on BO on Unix.

Strong database experience in using Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2000/7.0/6.5, MS Access7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000. Hands on Working knowledge in Writing the Stored Procedures, Packages, Functions and Triggers.

Extensive knowledge in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).

Expertise in Handling Business High Priority Issues and working with the Vendor for any related Product Issues.

Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

Technical Skills

Reporting Tools

Business Objects 4.2 (BI Launch Pad, Information Design Tool, Dashboards, Business Objects XI 4.2/4.1/4.0/3.1/3.0/R2 (CMC, Designer, Reporter), Web Intelligence XI/6.x/2.x, Info View, Dashboard Manager, Voyager, Xcelsius, QAAWs and Crystal Reports 2016, XI/9.0, SDK.SSRS, Lumira Discovery, Power BI, Lumira Designer, Tableau, Power BI

ETL Tools

Informatica 5.1/6.1/7.1/8.0 (Power Mart/Power Center), BO Data Integrator BODI 12.2,11.7.3/11.7.2/,6.5.

Operating Systems

Sun Solaris 8/9, Unix, and Windows NT/2000/2003/XP.

Languages

Java, C, C++, SQL, PL/SQL, Visual Basic 6.0, UNIX Shell scripting, XML, VB, ASP, .Net.

RDBMS

HANA database, Oracle 11g/10g/9i/ 8i/, SQL Server 2000/05/08, DB2, MS Access, Teradata, MySQL 5.0/4.1, Sybase 12.0

Tools

HANA, ER Studio, Erwin 4.1, TOAD, SQL* PLUS.

EDUCATION: - Bachelor’s in Computer Science from Shri Vaishnav Institute of Technology and Science (India)

Master’s in Computer Science from University of Massachusetts, Boston (Aug 2015- June 2017)

Professional Experience

Signet Jewelers, Irving, TX

Business Intelligence Developer Sept 20 - Till Date

Roles & Responsibilities:

Responsible for all phases of report development from specification gathering, research, code development, data validation, user acceptance review, publication and distribution of final reports and Universes.

Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file data sources.

Did extensive work to clean up the BOBJ Environment by Using Audit Universe and Query Builder

Created Dashboard from Scratch for different departments like Accounting, Sales, Marketing by using SAP Lumira.

Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.

Develop SQL scripts and functions for complex reusable scenarios in HANA.

HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View and Schemas.

Worked with Power user from different business units design traditional and HANA universe.

Design and integrated exiting BODS and SAP SLT with HANA.

Worked on customer service reports, Operational Scorecards, Budget Scorecards, Sales Views, Budget Views for Business Units.

Created Complex Webi Report for the Claims Department which contains more than 20 tabs. Using Graph, Charts. Did complex calculation on report level to satisfy the different filter conditions.

Extensive work on creating dashboards through Lumira Discovery, Power BI for all different groups like Accounting, Products, and Producer etc.

Worked on different BOBJ admin tasks like Promotion management, creating groups, and adding connections Monitoring Sessions on a day-to-day basis.

Environment: Business Objects 4.2 (BI Launch Pad, Information Design Tool (IDT), Dashboards), Business Objects XI, SAP Lumira Discovery, SAP HANA 2.0, Share point, SQL Server 2017, Power BI, Visual Studio 2017.

RLI Insurance, Peoria, Illinois

Business Intelligence Developer Oct 18 – Aug 20

Roles & Responsibilities:

Created the generic home page for all the WEBI users which shows the Daily Job status on their home page.

Created Webi reports with the help of Audit Universe for the analysis of System Performance.

Responsible for SAP HANA modeling using various Calculation Views/dimensions and SQL Scripting, utilizing the advanced features of HANA Studio.

Created Technical specifications and standard modeling documents for HANA.

Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file data sources.

Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.

Worked on various ava sdk scripts to configure authentications, SSO, and web servers for HANA, SAP BW7.3, BODS 4.0 and BOBJ4.0

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Created user profiles and folders in CMC module with varying security profiles for each user.

Created stored procedures for SSRS Reports.

Major responsibilities include getting requirements from the user and developing Callidus reports using Lumira Discovery and WebI . Maintaining proper documentation of the reports for future reference.

Developed Custom reports and developed then on server using power BI

Worked on SSRS reports. Added the new functionality on Existing SSRS report.

Did Extensive Code review for SSRS Reports.

Developed several other financial reports such as Ranking based on Sales by state and agent, expense allocation reports, production by different hierarchical levels.

Worked on Creating views, Table, Stored Procedures, CTE Etc.

Analyze different user activities by created script from Query Builder.

Compared and analyze the differences between the two different Environment SQL Scripts.

Created Reports to analysis User Account, Webi Scheduling Traffic, refreshed not refreshed reports.

Increased System Performance by at least 20% by finding and archiving the Reports and Disabling the Scheduled Reports which are not in use from long time.

Extensive work on to create Complex SQL queries with the help of SQL Server Management Studio

Developed Web Intelligence reports making use of combined queries (Union, Intersection, Minus).

Created Complex Scorecard for the claims department using webi Charts, Graph, Tables.

Environment: HANA Studio, Business Objects 4.2 (BI Launch Pad, Information Design Tool (IDT), Dashboards), HANA 2.0 Business Objects XI, SAP Lumira Discovery, Share point, SQL Server 2017, SAP ECC, BODS 4.0, Visual Studio 2017.

Geisinger Healthcare, Bloomsburg, Pennsylvania

Business Objects Developer July 17 – Sept 18

Roles & Responsibilities:

Worked on creating Universe using IDT on Hyperion DB as a source for one of the dashboards designed on Design Studio.

Extensive work on to create Complex SQL queries with the help of SQL Server Management Studio

Worked closely with Data services team to validate and check if all required fields and elements were loaded into EDW from the old source systems and monitor daily loads to ensure proper report delivery.

Worked along with the development team to integrate the Crystal Reports 2016 with the Prompt Screens.

Created and documented a list of tables, fields, joins, derived tables, hierarchies, and filter prompts needed for the complete reporting.

Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.

Involved in the regression testing on the reporting side after hundreds of new fields were mapped by the ETL team.

Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.

Converted Free Hand SQL reports to Business Objects reports using the business logic.

Worked on developing the templates in Webi and experience in working and managing in Different Environments simultaneously.

Designed enterprise SAP Dashboard 4.2 using combination of Information Design Tool (IDT) and Live Office connectivity.

Developed data flows and workflow using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.

Review, Refine and Validate Data Generated Reports in Excel and SAP Lumira

Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.

Created Report Level Variables, Objects and Formula to create new columns based on the result set.

Developing advanced analysis reports using SAP LUMIRA, Power BI, SAP PREDICTIVE ANALYSIS

Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional reporting.

Scheduled reports to be pushed onto a team’s SharePoint site as well as to user’s inbox. Served a support person a weekly rotational basis.

Environment: Business Objects 4.2 (BI Launch Pad, Information Design Tool (IDT), Dashboards), Business Objects XI Crystal Reports 2016, SAP BW 7.4, SAP HANA 2.0 Share point, Service Now, Oracle 11g, TFS Server, Power BI, SQL Server 2014,

Ranbaxy Pharmaceuticals, Hyderabad, India Sep 12 – Jun 15

Roles & Responsibilities:

Gathering the requirements from the Business Users for building the Reports and Metrics.

Designing and Developing Universes for the Operations Group.

Setting up the Aggregate awareness functionality in the Universe between the objects of Summary tables.

Resolved the join path problems such as loops, chasm, and fan trap using appropriate aliases and contexts.

Involved in Performance tuning of Universes by creating alternate views and indexes.

Designing complex reports for the Operations group.

Created complex reports using multiple queries and involved in tuning the reports to increase the accessing speed.

Part of report development created reports by using multiple data provider’s @functions and inner query concepts to generate full client reports.

Designing reports using Web Intelligence.

Generated linked reports with complex crosstab reports with multiple queries, conditions, global filters, and multiple data providers.

Environment: Business Objects 6.5 (Supervisor, Designer, Reporter) Web Intelligence 2.5, Info View, Broadcast Agent 6.1, PL/SQL, Oracle 8, MS Access 2000.

Contact this candidate