SUMMARY

• 11 years of experience in Development, Management and support solutions in Business data analysis and reporting for financial, Banking, Project management, manufacturing and marketing industries.
• Implement strategic solutions for deriving and drive business’s Business Intelligence and data reporting interest to materialize in technology solutions.
• Understand, learn, define and develop metrics or Key performance indicators and their major factors to support business planning and decisions.
• Follow corporate data and audit policies in deriving and using data for reporting solutions.
• Propose methodologies or processes of data in reporting solutions, which may include gathering data from heterogeneous environments, cleansing and grouping of data and projecting as business metrics from an aggregated level to the lowest possible breakdown by business factors.
• Implemented solutions and managed data analytics projects for daily, weekly, monthly reporting needs critical metrics for executives.
• All reporting solutions implemented on SAP BW/BI & SAP Business Objects, Tableau and Microsoft technologies.
• Over 6 years of experience in Analysis, Designing, developing Data Warehouses and supporting Informatica Power Center ETL Tools.
• Experienced in development and analytics solutions in high end databases like SAP HANA, and relational databases like SQL server, Teradata and Big Data Hive 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.
• Achieved data insights, integrate multiple data sources and create meaning visualizations or interactive Geo Maps for the monthly presentation for BI managers with help of Tableau reporting suite.
• 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.
• Implement SDK for BOBJ WEBIntelligence for customized layout for specific folder/user groups when creating new report.
• 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

SAP HANA Analytics Tech Lead

Responsibilities:

• Meet Process and functional teams to gather information on reporting needs and business managers to prioritize and plan the delivery of the solutions
• Propose and implement BI and BW solutions to extract, transform and store data in warehouse with best possible methodologies.
• Manage and implement technical solutions with hands on in development of data objects with compliance to corporate policies.
• Plan deliverables by phase based in the resources, work hours and needed deliverables by project phase and go live deadlines
• Document and maintain technical development in global documents service for transparency of solutions implementation.
• Route the development through the approvals by system integration, User acceptance teams and prepare for business go live transports.
• Develop training solutions for end users on how to use the solutions and ways to move their current reporting process to global solutions.

Environment: SAP Business Objects 4.1 Sp6, SAP HANA, SAP Design Studio 1.6, Lumira 2.0 (Designer and Discovery).

Confidential, Saint Paul, MN

Dashboard Designer/ Data Analyst

Responsibilities:

• Understand the current state of providing the BI solution and how the data is been presented to Sales and Business users.
• Work 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.
• Conduct Design workshops and Solution walkthroughs for the business.
• Establish 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.
• Design 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 permissible 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 Dashboard.
• Implement solutions on corporate Business Objects platforms with SAP Design studio tool.
• Implement 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

SAP BOBJ Developer/ Data Analyst

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

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.
• Create customized WEBI layout with images/fonts/colors to standardize the reports created by business/Data Analysts with customized CSS files on WEBI report engine.
• Developer web application using report engine SDK with Eclipse IDE Java for EE.
• Help application developers to embed WEBI reports in Java based applications.
• 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 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 technical specification, which help developer carryout 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 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. Eclipse IDE for Java EE

Confidential, Mason, MI

Dashboard Architect

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 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, Eclipse IDE for Java EE

Confidential

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

Confidential, Raleigh, NC

Microstrategy BI Developer

Responsibilities:

• Analyze User reporting and Dashboard requirements.
• Model and design the Microstrategy project to accommodate all the user requirements.
• Optimize the project and dashboard’s look and feel on the Microstrategy Web to meet the customer requirements, and to look vivid and to differentiate among all the metrics shown in the dashboards.
• Create new and modify the existing cubes or the grid reports, which act as source for the dashboards.
• Maintained all the standards across all the dashboards showing data.
• Hyperlinked dashboards to show the lower level data.
• Help in documenting the quirks and issues faced while implementing dashboards.

Environment: Microstrategy BI suite 9.3.1. Microsoft SQL server 2012 R2

Confidential, Hoffman Estates, IL

Business Objects Developer

Responsibilities:

• Analyze functional and technical requirements to prepare initial technical documentation for the proposed reports.
• Proposed report templates in the Business Objects Web Intelligence reporting tool.
• Brought mock layouts for the reports to fulfill requirements.
• Create Web Intelligence Reports using BEx as the data source and as per the technical and functional specifications.
• Create Dashboards with Xcelcius for Profit and Loss Analysis, Customer Aging, Account payables and Receivables.
• Execute the technical unit test cases for all the reports.
• Present the reports to the clients and discuss on functionality and technical aspects of the report.

Environment: Business Objects XIR4.1 (WEBI), SAP BI 7.3, SAP BEx Query Builder, SAP ECC, Windows XP

Confidential

Team Lead

Responsibilities:

• Gather existing reports analyze Data for making decision for Initial design layouts for the universe and reports.
• Prepare Design Layout of the Universe and create ad-hoc reports for peer approval.
• Implemented BOBJ Events based on the data availability in the data warehouse.
• Responsible for Tuning the queries to improve the performance of the report refresh time.
• Conduct Analysis to reduce reports runtime against huge SQL Server database.
• Created Multiple Derived tables based on the Business requirements.
• Implemented MS Live Office for easy data presentation or manipulation for Analysts using MS Office tools for presentation especially MS Power point
• Worked with Control team and DBA to create Presentation Layer tables to support Universes.
• Introduced the most efficient way of using WEBI layout used for Direct presentation using all functionalities for playing around on the WEBI report
• Shown Technical expertise in Analyzing Data, Designing Universe, Implementation and administration of security models with securities defined at row level, role based security etc., in Business Objects.

Environment: Business Objects XIR 3.1 (Designer, WEBI, Crystal), SQL Server 2008 R2, Windows XP.