SUMMARY

• 10+ years of experience in Development Support Solutions for Business Objects XI 4.1, 4.0, XI 3.1 SP2 / XIR2/XI/6.5, Business Objects Enterprise, Web Intelligence, Crystal Reports, Xcelsius, Design Studio, Lumira, Query as a Web Service (QaaWS).
• Over 3 years of experience in Analysis, Designing, developing Data Warehouses and supporting Informatica Power Center ETL Tools.
• Experienced in development of HANA objects (Analytical/Calculation/Attribute views) along with Columnar tables, stored procedures, sequence generators tagged to columnar tables.
• Experienced in Developing and troubleshooting WEBI reports, Design Studio Dashboards based on BEx queries created in SAP BW.
• Analyzing data and mining the data to fulfill reporting requirements.
• Dashboards using Xcelsius 2008/4.5, Design Studio, Lumira on BICS/OLAP Connections.
• Published Reports in Crystal Enterprise via Crystal Publishing Wizard and Crystal Management Console.
• Acheived data insights, integrate multiple data sources and create meaning visualizations or interactive Geo Maps for the monthly presentation for BI managers with help of Microsoft Power BI tool.
• Project implementation and development experience creating Project, Reports and Dashboards using Microstrategy BI suite 9.3.1.
• Experienced in designing and developing and support Microstrategy BI suite for the version 9.3.
• Solid Experience in writing SQL queries to help analyzing data for reporting and for finding data anomalies.
• Knowledge in the use of ETL tools. Worked on several transformations such as CDC, Historical, Filter Transformations, Joiner Transformations, Rank Transformations, Stored Procedure Transformations, and Expression Transformations.
• Expertise in databases to include SAP BW, Oracle 10g/9i, MS SQL 2014/2012/2005/2000/7/6.5, DB2, and MS Access.
• Good in creating T - SQL or PL/SQL procedures in Oracle or MS SQL Server and .hdbprocedures in HANA database
• Expertise in Universes for Customized Metrics and Goals to Create Metric Analytics and Goal Analytics.
• Major responsibilities include getting requirements from the user and developing Desktop Intelligence Reports, Crystal Reports and Webi Reports.
• Extensive database architecture and design skills working on high performance solutions in large corporate environments.
• Proficient in design, development, coding, implementation and Support.
• Excellent communication and strong interpersonal skills with ability to interact with end-users, managers and technical personnel.

TECHNICAL SKILLS

• OLAP/DSS Tools
• Business Objects XI 4.1, 4.0, 3.1, R2, Crystal Reports, Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Report Conversion Tool, Translation Manager, Crystal Xcelsius 2008/4.5, Query As A Web Service (QaaWS), Crystal Report Explorer, Dashboard manager, Scorecards, Informatica Power Center 9.5/9.3, Microstrategy BI suite 9.3.1/9.4
• RDBMS
• Oracle 10G/9.x, DB2/400, SQL Server 2000/2005/2008, Teradata
• Languages
• C, ASP, PL/SQL, SQL
• Utility Tools
• Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential, Saint Paul, MN

Present Designation: Dashboard Designer/ Data Analyst

The Confidential Company, formerly known as the Minnesota Mining and Manufacturing Company, is an American multinational conglomerate corporation based in Maplewood, Minnesota, a suburb of St. Paul.

With $30 billion in annual sales, Confidential employs 88,000 people worldwide and produces more than 55,000 products, including: adhesives, abrasives, laminates, passive fire protection, dental and orthodontic products, electronic materials, medical products, car-care products (sun films, polish, wax, car shampoo, treatment for the exterior, interior and the under chassis rust protection), electronic circuits, and optical films. Confidential has operations in more than 65 countries including 29 international companies with manufacturing operations and 35 companies with laboratories. Confidential products are available for purchase through distributors and retailers, and online directly from the company.

Project 1: PRISM

Industrial & Safety Market Center BI team is making efforts to present/support from Division heads to sales representatives by providing statistics on sales by all types of business segmentation to product level.

Project 2: Corporate KPI Dashboard

Supply Chain Management team brought in few Key Performance Indicators which will help give insights to the top-level executives on the performance of Material to Delivery cycle, Logistics and On time in Full payments by all possible business segments.

Responsibilities:

• Understand the current state of providing the BI solution and how the data is being presented to Sales and Business users.
• Worked with Business very closely to gather the requirements and document Business requirement Documents for carry out system design, gathering data sources and approach with optimal technical design.
• Conducted Design workshops and Solution walkthroughs for the business.
• Established standards for various artifacts in HANA such as - Naming convention for views and procedures, test documentation template, Business Requirement Document template etc.
• Data modeling experience creating various views such as Attribute views, Analytic views and Calculation views (Graphical, Star and Scripted).
• Extensively worked on SQL stored Procedures, SQL views, functions and Calculation view expressions.
• Designed the table level security & Analytical Privileges for HANA Views to secure the data.
• Propose solutions based on how and what business would like to see the data on high graphical data visualizations tools.
• Gather data sources and define new and dedicated table structure for the Dashboards to make availability for users in business hours.
• Integrate data sources at promisable data granularity levels to provide insights by comparing the markets against company performance with Power BI.
• Achieved product recommendations for end users based on previous product transactions and their competitor’s/similar business’s purchases.
• Apply linear regressions algorithm in Power BI for predictive sales data and store in presentation tables on daily basis for corporate Dashabord.
• Implement solutions on corportate Business Objects platforms with SAP Design studio tool.
• Used Parallel Data Source invocation at Application startup to enhance performance of Dashboard.
• Used Design Studio Profiling in DS local mode to gather stats for every components runtime and its usage, which helps to improve performance of Dashboard.
• Define SQL and PL/SQL procedures to feed the tables on timely basis.
• Create Dashboards using SAP Design Studio tool to accommodate all the business requirements which has more dynamic data drill and populating based on the data selection or the type of user.
• Handle the User interactions keep updating the functionality based on the business user’s requirements.

Environment: SAP Business Objects 4.1 Sp6, Web Intelligence, Information Design Tool, SAP HANA, SAP Design Studio 1.6, Lumira 2.0 (Designer and Discovery), Teradata 15.0, MS Power BI, SQL & PL/SQL.

Confidential, Columbus, OH

Designation: SAP BOBJ Developer/ Data Analyst

JPMorgan Chase & Co. is a multinational banking and financial services holding company. It is the largest bank in the United States, the world's sixth largest bank by total assets, with total assets of US$2.35 trillion, and the world's most valuable bank by market capitalization. It is a major provider of financial services

Responsibilities:

• Carry out meeting with the concerned managers and business users to understand their requirement and their perspective of viewing the data and the usage of the data projections.
• Run multiple iteration of analysis with requested managers along with sample data and visualization/report layout inputs with hygiene rules applied.
• Conclude on the requirements and define development strategy and plans for delivery of the required reports/data.
• Convert the functional requirement to technical documentation with data mapping and the data relations and conditions.
• Define the logic using SQL server Management studio to meet all the requirements.
• Create or modify SAP Business Objects Universe using Information Design tool (IDT) as a data abstraction layer, which include required business rules on data.
• Defined report templates that makes data presentation more understandable to the end users, and include all the user interactivity functions to make user easy to work on the report data for further analysis.
• Write reports on the Web Intelligence tool with required visualization and implement all the required corporate standards.
• Build Complex to easy level Web Intelligence reports, Lumira Dashboards based on the technical and functional specifications by extracting the data from the IDT universe/views.
• Conduct Unit tests sessions along with unit test scripts and test cases created which covers all requirements of report functionality & report data.
• Create and promote the required elements of the reports to test environment for functional testing.
• Make backups of the existing elements of the PROD before promoting the tested reporting objects.
• Promote the tested elements to PROD using Promotion management tool in CMC.
• Assist and conduct UAT sessions with users on the in PROD. Record any issues, fix the bugs if any, and collect the signoff.

Environment: SAP Business Objects 4.1 Sp6, Web Intelligence, Information Design Tool, SQL Server 2008, SQL server Managemnet studio, SQL and PL/SQL.

Confidential, San Jose, CA

Designation: Reporting Analyst/Delivery Lead

Responsibilities:

• Define strategy and deliver solutions for business analytics which includes HANA data models, view designs and standardizations.
• Analyze the Functional requirements and convert them into technical specifications for BOBJ Web Intelligence, Analysis for Office and Lumira/Design studio.
• Build Complex to easy level Web Intelligence reports, Lumira Dashboards based on the technical and functional specifications by extracting the data from the Calculation/Analytical views of the HANA.
• Analyze the Functional requirements and convert them into HANA hdbprocedures which carry out a reconciliation process to update the records whether it is been reconciled on time or any exceptions applied.
• Discuss the requirements with client and functional team to understand the business flow and the process to convert them into the technical specifications, which helps the developer carry out the development process.
• Define Administration tasks like creating Security roles to segregating users by the level of access to folders or restricting BO/BI Launchpad functionalities for assigned users, reports scheduling for operational or organizational reports
• Create Columnar tables for the reconciliation process and tables to dump the historical data.
• Create sequence generators for all the tables where all records or transactions identified uniquely.
• Carry out TUT process from creating the test cases, test scripts and test case execution to ensure desired functionality.

Environment: SAP Business Objects 4.1 Sp6, Web Intelligence, Analysis for Office, SAP Lumira 1.27, SAP HANA 1.2.

Confidential, Mason, MI

Responsibilities:

• Extracting the technical specifications for the final Dashboard based on the Functional specifications and the requirement discussions with business users and the functional peers.
• Understand the business flow and the thresholds of the manufacturing units and the dependent factors to include them in the Dashboard to give details with data visualization on the day-to-day process flow.
• Articulate or formulate the metrics, which projected on the dashboard and the type of visualization to project the data.
• Create BICS/OLAP connections to utilize BEx queries for the Dashboard.
• Analyze the Functional requirements and convert them into BW/BEx technical specifications.
• Helped in consolidating all requirement for BW developers to design DSO and BEx queries.
• Develop artifacts and look feel of the dashboard on SAP Lumira with BEx Data Connector and Design Studio with inputs form the business users and their needs.
• Developed the dashboard on SAP Lumira from end to end using a maximum number of functionalities provided.
• Implemented Java scripting as well to customize the components using SDK on Eclipse WEB IDE of SAP Design studio.
• Developed Navigation from the Dashboards to Web Intelligence reports to justify the metrics projected in the Dashboard.
• Conduct testing phases with Business Analysts and end users with data in ECC.

Environment: SAP Business Objects 4.1 Sp6, SAP Web Intelligence, SAP Design Studio 1.5, SAP Lumira 1.27, SAP BW 7.3

Confidential, Belmont, WV

Role: Business Objects Reports Analyzer/Developer

Responsibilities:

• Analyze the Functional requirements and convert them into BW/BEx technical specifications.
• Suggested reporting tool based on the functionalities and functional requirements.
• Build Complex to easy level Web Intelligence reports based on the technical and functional specifications with BEx queries as source.
• Created Analysis for OLAP reports on BEx specifically for manufacturing module to accommodate the time interval key figures.
• Created crystal reports for multiple with BEx queries.
• Created Universe based on DSOs.
• Crated reports with multiple sources like BEx and Excel to accommodate requirements to show COPA and FI values in single block.
• Created dashboards using SAP Design studio for AR Aging analysis, Work Center Downtime Analysis by customer

Environment: Business Objects XIR4.1 (WEBI), Crystal Reports 2013, Analysis for OLAP, SAP BO Information Design Tool, SAP BI 7.3, SAP BEx Query Builder, SAP ECC, Windows XP