SUMMARY

• IT professional with more than 10+years of experience in building data models/reporting solutions using SAP HANA, SAP BW, Relational(RDBMS) sources, and SAP Business Objects suite
• 4 plus years of development experience with primary focus on SAP HANA and development, planning, architecture, and implementing large scale data warehousing on SAP HANA platform
• Recent experience includes implementing Data tiering (Hot (HANA Memory) and Cold (HADOOP)) using Data lifecycle manager, and loading Data from Fixed width file using Smart Data Integration (SDI and SDA) in SAP HANA
• Experienced in all phases of the Software Development Lifecycle (SDLC) including requirements gathering, analysis, design, system implementation, performance tuning, testing and support
• Expertise in Native HANA development: creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytic, and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics)
• Experienced in creating functions, Analytical Privileges, building SAP HANA security models, migration & optimization, sizing, and performance tuning
• Experienced in architecting SAP Business Object Platform 4.2/4.1 to integrate with SAP BW, SAP HANA, SAP ECC (HANA Live views), Oracle (MDM) and to support Data migration/profiling using SAP Data Services and Information Steward
• Expertise in developing complex WebIntelligence documents with multiple reports, tabs, queries, cross - tabs, charts, hyperlinks, with drill-down/though capabilities from using BICS and Universes
• Developed fully interactive Dashboards with multiple KPI’s, inputs, what-if analysis with drill-down/through capabilities using SAP Dashboard (Xcelsius), Design Studio and integrated these with SAP Business Objects Mobile App to consume in Ipads/Iphones
• Strong functional knowledge with SAP ECC (HR, FICO, MM, PP, and SD)
• Expertise in building reporting solutions on top of SAP BW (BEX Queries (BICS), using Crystal reports, Analysis for Offices, WebIntelligence, SAP Dashboards and, SAP Design Studio
• Commendable knowledge in SAP BW components like Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and Transfer Rules
• Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written
• Experienced in working with big consulting firms like SAP, Noah, Capgemini, HCL Axxon, Virtusa
• Excellent inter-personal skills with eager to learn new concepts, methods, and technologies

TECHNICAL SKILLS

Reporting Tools \Operating Systems: \: SAP Business Objects (Information Design \Microsoft Windows, Unix, Windows Enterprise \ Tool, Universe Designer, WebI, DeskI, \Server, AIX, Red Hat Enterprise Linux 4.0.\ Central Management Console, InfoView, BI \ Launch pad, Mobile, SAP Business Objects \ Dashboards (Xcelsius), Design Studio 1.6, \ Lumira, Analysis for Office\

ETL Tool \Languages: \: SAP Data Services 4.2 /Data Integrator, SAP \SQL, PL/SQL, UNIX Shell Scripts, HTML, \ BW, Information steward.\C, C++, VB 5.0/6.0\

Data Bases \: SAP HANA, Oracle, SQL Server, Teradata, \ Sybase\

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SAP BI/ BOBJ Consultant

Responsibilities:

• Gather business users’ requirements, document, and translate them into functional, trchnical design/development documents
• Architect and manage the technical, non-technical and visualization aspects of the project
• Lead the delivery of Visualizations with a focus on end-to-end integration
• Develop dashboard using SAP Design Studio which can be used as the base for new dashboards for different business use cases
• Developing and enhancing the other technical artifacts such as UNX, and dataware house tables/views
• Create Global script, CSS and optimize the code to control the component interaction and to manage data sources, data elements and data calculations during run time
• Create customized Web Intelligence documents which can be utilized as detailed reporting purpose

Environment: SAP Business Objects 4.1, IDT, Oracle, Design Studio 1.6 SP 2

Confidential, Inver Grove Heights, MN

Sr. SAP HANA/BOBJ Consultant

Responsibilities:

• Gathered reporting requirements, and prepared technical specifications documents for developing reporting solutions
• Closely worked with Business Analyst, and business users to understand CXL data, business uses cases, and bridge the gaps between from CXL data warehouse and the functional requirements
• Lead data analysis, modeling, and extraction of data from multiple sources
• Loaded Data from Fixed width file using Smart Data Integration (SDI and SDA) in SAP HANA
• Model, develop data models to address the business requirements and guide on best practices in inter-operability of different tools, security, and best practices in design and development of data models in SAP HANA (Native)
• Developed calculation views, analytical privileges, SAP HANA security roles, exposed SAP BW models as HANA views, and enhanced the SAP HANA Live views to address the business user requirements
• Developed reports using Web intelligence, Analysis for Office, and Lumira from SAP HANA, Universes
• Developed hybrid scenarios to meet client real-time/historical reporting requirements
• Provided guidance on inter-operability of different platforms, tools, security models, content promotion, and best practices in design and development of data models in SAP HANA (Native)
• Developed, implemented, and document standards and guidelines for SAP HANA modelling

Environment: SAP HANA, SAP Business Objects 4.2, IDT, ECC, SAP TMS, Webi, Lumira, Analysis for Office

Confidential, Mt Laurel, NJ

Sr. SAP BOBJ Consultant/Design Studio Developer

Responsibilities:

• Architecting and managing the technical, non-technical and visualization aspects of the project
• Leading the delivery of Visualizations with a focus on end-to-end integration and bringing standardization within the project
• Building Dashboards using Design Studio 1.6 to evaluate its capabilities in caparison with SAP Dashboard to leverage Webi functionalities
• Developing standardized dashboard templates using SAP Design Studio which can be used as the base for new dashboards for different business use cases
• Develop attribute views, analytic views, calculation views, exposing SAP BW models as HANA views, and enhance the SAP HANA Live views to address the business user requirements
• Developing and enhancing the other technical artifacts such as UNX and SAP HANA views
• Provided ideas around dashboard development to enhance the user experiences at run time
• Used indexes in the Design Studio to capture the data points at the run time to minimize the development efforts on universe and HANA views
• Created Global script and optimized the code to control the component interaction and to manage data sources, data elements and data calculations during run time
• Created customized Web Intelligence documents which are utilized as detailed reporting purpose

Environment: SAP Business Objects 4.1, IDT, SAP HANA, Design Studio 1.6 SP 2

Confidential, Oklahoma City, OK

Sr. SAP BOBJ/HANA Consultant

Responsibilities:

• Architect to implement/integrate SAP Business Objects Platform 4.1(Mobile) on Windows Servers
• Involved in requirements gathering, development, promotion, testing and performance tuning
• Installed SAP Business Objects 4.1, Data Services 4.2, Information Steward on Windows Platform and integrated with SAP BW on HANA, SAP HANA, Oracle (MDM) and supported data migration
• Assessed business requirements and defined technical specification documents for Personnel Actions, Benefits & Payroll for Human Resources.
• Activated BI content heavily for the first ever SAP BW on SAP HANA implementation for the company. Define configuration for the implementation and addressed the requirement gaps
• Created attribute, analytical, calculation views and enhanced SAP HANA pre-delivered content
• Worked with security team in building security models within BOBJ and configured single-sign-on between SAP BOBJ and BW(STS), HANA (SAML) and WinAD
• Coordinated with technical teams to configure SAP HANA/Live pre-delivered content and involved in promoting packages using HANA Lifecycle Manager (HLM)
• Worked extensively on Analysis for Office Reports to support their operational reporting needs
• Used Promotion manager to promote objects in CMC from Dev to Test to Production env’s
• Worked with Basis, IT teams for configuration, troubleshooting issues for performance tuning
• Involved in user training and prepared technical specification document on Business Objects artifacts

Environment: SAP Business Objects 4.1 (Mobile), SAP HANA/Live, SAP BW 7.3 on HANA, ECC, Data Services 4.2, Design Studio 1.5

Confidential, Johnston, RI

Sr. SAP BOBJ/BW Consultant

Responsibilities:

• Gathered user requirement and documented the same to build reporting solutions
• Assessed business requirements and defined technical specification documents for Accounts Receivables Accounts Payable Asset Accounting and Consolidation
• Extensively worked in data modeling of Info Cubes, ODS, Info Objects, Info Sources, Data Sources.
• Customized standard business content extractors and enhanced Data Sources in various applications using User Exits
• Worked extensively on SAP BW objects supporting FI- CO modules
• Developed/modified BEx Queries for more enhanced reports as per the client requirements
• Independently handled Unit testing, Integration testing, and User acceptance testing (UAT)
• Created Web Intelligence reports with Parameters, Sub-reports (Master/Detail) using open Doc functionality on top of BEX Queries (BICS)
• Used major functionalities of BO, like Breaks, Global and Local Filters, Sorts, Query Prompt, Drill filters and input controls
• Created customized Web Intelligence reports and utilized drill-through functionality (linking) to drilldown to detailed reports depending on user input.
• Created BI workspaces models and demonstrated its functionalities to business users
• Utilized open-doc functionality to give user drill down reports and hyperlink functionality to granular level information
• Used Promotion manager to migrate objects from different environments and assigned folder level security to the user groups
• Implemented multiple data security scenarios (row level and folder/object level security) depending on the type of reporting object

Environment: SAP Business Objects BI Platform 4.1, SAP BW 7.3, ECC, Data Services

Confidential, Hartford, CT

Sr. SAP BOBJ Consultant

Responsibilities:

• Involved in Business Requirement gathering, documentation and translating it into design developments
• Worked as the dashboard specialist for two dashboards to build an end to end reporting solution
• Developed complex Dashboards by utilizing dynamic visibility, open-doc functionality for detailed reporting and presented to the customers published to Business Objects environment
• Used QAAWS and BIWS connection methodologies to build SAP Dashboard
• Created Web Intelligence documents for ad-hoc requirements across the board and developed Webi reports with Parameters, Sub-reports (Master/Detail) using open Doc functionality
• Extensively used major functionalities of BO, like Breaks, Global and Local Filters, Sorts, Query Prompt, Drill filters and input controls
• Coordinate with technical teams regarding client promotions, testing strategies etc
• Identify data quality issues, provides recommendations for improvement / resolution
• Prepare input/output reports and assist business analyst in preparing reconciliation reports
• Developed Universe using Information Design Tool (IDT) on top of Oracle and responsible for migrating from Universe Development tool to IDT
• Responsible for maintenance and migration of Universes, Reports, Dashboards and ETL jobs.

Environment: SAP Business Objects BI Platform 4.0, Dashboards 4.0, MS SQL Server 2008

Confidential, Louisville, KY

SAP BOBJ/Mobile BI Consultant

Responsibilities:

• Involved in business requirement gathering to translate them into design developments
• Developed complex Dashboard, Geo analysis (using CMap plugin) and added detailed reporting using Opendoc functionality
• As part of Dashboard development, used BICS connection to connect to BEx queries
• Developed WebI reports and published web services (BIWS) to consume these in Dashboards
• Developed Analysis Applications using Design Studio that to be consumed in Desktop and Ipad
• Modified Bex queries to facilitate design requirements for Analysis applications using Design Studio
• Designed and developed SAP Mobile solutions (using WebI and Dashboards) to business users depending on requirements which include Geo-Analysis (GeoMaps) for Ipad
• Used BIWS and BICS connection types to render data into the Dashboards
• Developed complex Dashboards by utilizing dynamic visibility, open-doc functionality for detailed reporting and published to Business Objects environment.
• Developed Webi reports with Parameters, Sub-reports (Master/Detail) using open Doc functionality
• Used major functionalities of BO, like Breaks, Global and Local Filters, Sorts, Query Prompt, Drill filters and input controls

Environment: SAP BOBJ 4.1 (IDT, WebI, Dashboards, Design Studio 1.2), SAP BW 7.3

Confidential, Denver, CO

SAP BOBJ Developer/Administrator

Responsibilities:

• Involved in Business Requirement gathering, documentation and translating it into design developments
• Worked extensively on Dashboards to develop new and enhance old dashboards to satisfy their high-level reporting needs of the organization
• As part of Dashboard development, designed BEx queries, built Universes and generated reports
• Designed and presented mock Dashboards to business users depending on requirements and enhanced these to better serve the user community
• Created Universe and Web Intelligence reports using BEx queries. Defined best practices to use BEx queries in Business Objects.
• Created Web Intelligence documents for ad-hoc requirements across the board and developed Webi reports with Parameters, Sub-reports (Master/Detail) using open Doc functionality
• Extensively used major functionalities of BO, like Breaks, Global and Local Filters, Sorts, Query Prompt, Drill filters and input controls
• Involved in performance tuning and enhancements of Dashboard and Webi documents/reports
• Extensively used Import Wizard to migrate content from Development, QA to Production and maintained versions control using Life Cycle Manager
• Interacted with the users in the weekly status meetings, helped/trained users in building reports
• Involved in Business Objects upgrade from SAP Business Objects XI3.1 to SAP Business Objects Business Intelligence 4.0

Environment: SAP Business Objects 3.1/4.0 (Universe Designer, WebI), Xcelsius Dashboards 2008, SAP BW 7.1, Crystal Reports 2008

Confidential, Oklahoma City, OK

Sr. SAP BOBJ 4.0/ HANA Developer

Responsibilities:

• Involved in Business blue print and technical specification. Developed of Functional Specifications for standard cost reporting.
• Developed Technical Design Documents including GAP Analysis.
• Configured and activated Business content according to the requirement based on the Application areas.
• Created Multicube to all access reportable Objects on daily and monthly level.
• Configured, activated and enhanced Business content for base actual cost and project actual cost according to the requirement
• Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business Scenario Generated reports using BEx Analyzer and Crystal Reports
• Developed universes (.unx) on top of information models using Information Design Tool (IDT)
• Developed Sales/Inventory dashboards for high level reporting needs using QAAWs, BIWS and Live office connections
• As part of the SAP HANA POC, developed attribute views, analytic views, calculation views, exposing SAP BW models as HANA views, and enhanced the SAP HANA views
• Upgraded, and successfully improved the performance of Dashboard by implementing best practices
• Published Dashboards to BOE and Enterprise portal, designed these dashboards in such a way that they are compatible with touch screen devices
• Created Information Spaces on top of UNX universes which was on top of Sales cube and presented the same to user community to use (BO Explorer)

Environment: SAP HANA 1.0, Eclipse 3.6, SAP BW 7.3, SAP Business Objects BI Platform 4.0, Xcelsius Dashboards 2008

Confidential, Jackson, MI

SAP BOBJ/BW Developer (Dashboard)

Responsibilities:

• Design and review of various documents like Business requirements document (BRD), Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and testing documents
• Designed and Developed Bex Queries for Business Objects reports (Web Intelligence, Crystal)
• Communicated with external users and Business Analysts to gather requirements, transformed them into technical work plan and generated reports
• Enhanced Standard Business Content InfoCubes like Line Item, Payment History, Cost and Allocation and in sales BCT ODS objects to include source system ID, time characteristics and harmonized version.
• Developed custom InfoCubes for General Ledger and Plan data (Balance sheet and profit loss), actual and plan data for Profitability Analysis.
• Customized and maintained DataSources such as billing, Sales Order and Delivery Order for the SD module and Profitability Analysis Actual Data.
• Worked extensively on Business Objects Enterprise Architecture, migration of Crystal Reports and Business Objects
• Responsible to support the issues with reports on the Business Objects enterprise environments (Development, UAT, Test and Production)
• Responsible for Extracting Data from ECC and other applications into SAP BW and Oracle using Data Services (Data Integrator)
• Developed Universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities.
• Designed, developed and managed Universes in the Designer for report generation.

Environment: SAP BI 7.0, SAP Business Objects XI release 3.1 SP3/R2, Web-Intelligence, SAP Data Services, Oracle 9i/10g, PL/SQL, Xcelsius 2008, Crystal Reports XI

Confidential, Chicago, IL

SAP BOBJ/BW Developer

Responsibilities:

• As a part of the BI implementation team, involved in gathering user requirements and data modeling using ERM, star schema data models
• Worked extensively with the Business Objects Designer in developing Universes from the warehouse database.
• Created Universes based on the dimensions, detail and measures required for the reporting analysis
• Created Web Intelligence documents for ad-hoc requirements across the board and developed Webi reports with Parameters, Sub-reports (Master/Detail) using open Doc functionality
• Worked extensively with the major functionalities of BO like Breaks, Alerters, Global and Local Filters, Sorts, Query Prompt, and Drill filters
• Created complex Dashboards by utilizing Dynamic Visibility functionality and published the Xcelsius dashboards to Business Objects environments, MS word, MS PowerPoint.
• Generated reports using crystal reports to provide critical statistical data essential for preparation of annual budget as well as weekly reports required by the internal and external clients
• Interact with the users in the weekly status meetings; also support them in building the reports.

Environment: SAP BI 7.0, SAP Business Objects XI release 3.1 SP3/R2, Web-Intelligence, Crystal Reports XI, Oracle 9i/10g, PL/SQL, Xcelsius 2008, Windows 2003 server

Confidential, Memphis, TN

SAP BO Consultant

Responsibilities:

• Conducted meetings with business users and documented the user requirements into Functional Specs and Technical Specs
• Involved in Designing and Development of Universes, Classes and objects which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users
• Detected loops, and checked the Integrity of Universes and Created Classes, Objects, Hierarchies, Created Prompts, Filters and used Aggregated Awareness function
• Enhanced the existing master and transaction data to get better results in the dashboard
• Created Several Standard reports for various departments with different report Criteria
• Built complex formulae in WebI documents to accommodate business rules and requirements
• Created customized Web Intelligence reports as a source data for Live Office to integrate Xcelsius on corporate dashboards
• Involved in Installation of Crystal Xcelsius, Query as Web Service, Live Office Add in (Client)
• Prepared documentation for the users to understand how the reports will work and how to use the functionality with step by step also called as Data maps