SUMMARY

• 6 + years with 3 full life cycle implementation experience in business intelligence consultation with a strong focus on reporting, database modeling, SAP integration, customer relation and business user support processes.
• Expertise in conducting meetings, interviews and surveys to gather requirements and partner with customers to asses’ gaps and define scope of projects.
• Excellent verbal and written communication skills.
• Skilled Team player with good logical reasoning ability, coordination and interpersonal skills.
• Excellent understanding of Data warehouse and Business Intelligence concepts
• Expert in writing Functional design document - FDD and Technical Design Document - TDD for HANA and Business Objects development.
• Created Business Intelligence training document and conducted in-person and virtual business users training sessions.
• Hands on modeling experience with SAP HANA Modeling using HANA Studio (created Attribute View, Analytic View, Calculation Views - Graphical / SQL Script).
• Created Custom Tables, Stored Procedures and XS Jobs.
• Expert in HANA models performance tuning using Visualize Plan.
• Comprehensive understanding of SAP HANA data provisioning using SLT Replication for SAP as source system, SAP Data Services for non-SAP data source and DXC.
• Created reports using Business Objects functionalities like Combined Queries, Slice and Dice, @Functions, Cross Tab, Drill Down, Master Detail and Variables, Formulae etc.
• Used HANA to run the SQL against the database for data analysis, data validation and query performance.
• Collaborated and actively involved in several full project life cycles (i.e. requirements gathering, design, development, test, cut-over and support) as SAP Business Objects developer; and 1 full project life cycle as SAP HANA Modeler.
• Extensive knowledge of SAP HANA Architecture.
• Hands on development experience with SAP Business Objects 3.x/4.0/4.1/4.2 (Universes, Webi reports, Lumira, Crystal, Analysis for office and SAP BW and Business Objects integration via BICS and OLAP universe)
• Developed complex universes by defining hierarchies - navigation paths to support drill down reports, cascading prompts, derived tables, aggregate aware, context. Resolved table join problems like Chasm trap and Fan trap using context and Alias.
• Experience in creating various types of Reports like Cross Tab Reports, Drill through Reports.
• Performed query performance optimization and working with the data modelers to define the requirements for different aggregate layer for optimal query performance for executive dashboards, canned reports and ad-hoc analysis.
• Provided production support for the existing Business Objects contents and followed defect management process for defect resolution and change management process for any enhancements.
• Worked on multiple source SAP and Non - SAP systems for Business Intelligence Reporting includes SAP (FI, CO, SCM, SD) and Non - SAP (Hyperion, i3 database, SQL server)
• Well versed with SDLC, Waterfall, Agile implementation methodology.
• Understanding of all phases of software development lifecycle including scoping, design, construction and testing of the reports.
• Experienced in successfully establishing, leading and maintaining onshore and offshore development teams.
• Used workflow analysis and case reviews to alter, modify, and upgrade processes to improve production and efficiency of work done via best practices recommended by SAP
• Customized KPIs for better manageability of overall performance while meeting SLAs (Service level agreements).
• Experienced in handling Incidents during support phase, debug and analyze incident, identify issues and hand over task to technical team for fix. Ensured fixes addresses issue by testing with technical team and business team before sign off.
• Expert in writing testing scenarios and test scripts.

TECHNICAL SKILLS

In Memory Databases: SAP HANA 1.0 / 1.9 / Business Objects 3.x / 4.0 / 4.1/ 4.2 BI Launch Pad/ Info View, Interactive Analysis/ Webi/Web Intelligence/Thin Client, Deski/Desktop Intelligence/Full Client, Webi Rich client, Information Design Tool - IDT / Universe Design Tool - UDT, Import Wizard, CMC, Publishing Wizard, Report Conversion Tool, Universe Builder, Lumira, BO Explorer, Xcelsius, OLAP Analysis, Analysis for Office

Programming Languages: SQL

Computer OS: Windows 8.1, 8, 7, XP

PROFESSIONAL EXPERIENCE

Confidential, NJ

Business Objects Developer/ HANA Modeler

Responsibilities:

• Worked at Confidential as SAP HANA Modeler and BO developer
• Worked with the business to understand and document the functional and technical requirements.
• Conducted AS-IS, future state and GAP analysis workshops.
• Wrote functional and technical specification based on the business requirements.
• Developed Attribute, Analytical and Calculation HANA views to address the functional specifications.
• Created Input parameters and Variable prompts to filter results from user selection
• Created Joins, Unions, used ranked function and performed Aggregations for HANA views.
• Created Custom tables, Stored procedures and XS Job to capture slow moving dimensions.
• Enhanced HANA models by performance tuning and analysis of data flow upward.
• Worked with the SAP Basis team to setup the SLT replication for SAP source and SAP Data Services team to load the non-SAP data in SAP HANA
• Design the solution to integrate the SAP and non-SAP data using HANA Studio
• Developed the calculation views using graphical and SQL Script mode. Developed analytical views to integrate different tables.
• Optimized the SAP HANA view for Adhoc reporting using Webi, analysis for office and lumira.
• Created, maintained, and updated several universes using Universe Design tool and Information Design Tool.
• Created Universe (using IDT) on HANA views to expose the data in Webi and analysis for office.
• Developed Fix formatted and self-service reports based on the business requirements using Webi Intelligence and Analysis for office.
• Implemented functionalities like Drill filters, Breaks, Sections, Hyperlink, @variable, @prompt.
• Created User Prompts, Conditions and Filters to improve the report generation
• Scheduled Business Object Reports to users using BI Launch pad.
• Created Webi reports Publications in CMC based on User Profile to enable report bursting.
• Involved in performance tuning and optimization on Business objects reports and Universes.
• Conducted End User training workshops.
• Developed End User training material and provided support for production support while meeting Business SLAs.
• Worked in onsite-offshore Business model.
• Worked as an IT Support to solve issues/tickets related toBusinessObjectsusing Track It.

Confidential, New York, NY

SAP BI / HANA Developer

Responsibilities:

• Performed data modeling and developed Analytical views for transactional data, Attribute views for the master data and calculation view on based on those views in HANA Studio.
• Migrated HANA content from development, testing environment to Production environment.
• Created Universes on top ofHANA calculation viewsand developed the Webi reports and dashboards usingIDT(Information design tool)
• Loaded master/transactional data from flat file as well as from R/3 system.
• Interacted with business users and business analysts for understanding requirements to build universes/ reports for users.
• Created SAP BEx queries in SAP BW and integrate them with Webi using BICS.
• Created WEBI reports, Advanced OLAP analysis for Web reports
• Involved in Project planning, maintaining different phases of the projects
• Extensively worked on end-user requirements, business data requirements, analysis and study and efficient in testing SQL queries and stored procedures.
• Implemented Open Doc to drill down to detail Webi report from dashboard.
• Developed Canned, Standard Interactive Analysis reports, Webi reports.
• Created and modified dashboards with dynamic data
• Created, maintained, and updated several universes using Universe Design tool.
• Analyzed existing stored procedures to create simple queries to create crystal reports.
• Involved in performance tuning and optimization on Business objects reports.
• Created universe to access non-SAP Data.
• Scheduled Business Object Reports to users using BI Launch pad
• Designed and Documented Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Provided end user straining about basic functionalities of using reports, such as ‘opening reports, using prompts, saving reports in different formats, scheduling reports, etc...’

Confidential, Atlanta, GA

SAP HANA / BO Developer

Responsibilities:

• Conducted AS-IS, future state and GAP analysis workshops.
• Wrote functional and technical specification based on the business requirements.
• Developed Attribute, Analytical and Calculation HANA views to address the functional specifications.
• Worked with the SAP Basis team to setup the SLT replication for SAP source and SAP Data Services team to load the non-SAP data in SAP HANA
• Design the solution to integrate the SAP and non-SAP data using HANA Studio
• Developed the calculation views using graphical and SQL Script mode. Developed analytical views to integrate different tables.
• Optimized the SAP HANA view for Adhoc reporting using Webi, analysis for office and lumira.
• Created, maintained, and updated several universes using Universe Design tool and Information Design Tool.
• Created universe (using IDT) on HANA views to expose the data in Webi and analysis for office.
• Developed Fix formatted and self-service reports based on the business requirements using Webi Intelligence and Analysis for office.
• Implemented functionalities like Drill filters, Breaks, Sections, Hyperlink, @variable, @prompt.
• Created User Prompts, Conditions and Filters to improve the report generation
• Scheduled Business Object Reports to users using BI Launch pad.
• Created Webi reports Publications in CMC based on User Profile to enable report bursting.
• Involved in performance tuning and optimization on Business objects reports and Universes.
• Conducted End User training workshops.
• Developed End User training material and provided support for production support while meeting Business SLAs.
• Worked in onsite-offshore Business model.
• Worked as an IT Support to solve issues/tickets related toBusinessObjectsusing Track It.

Confidential, Charlottesville, NC

SAP HANA Consultant

Responsibilities:

• Gathered and analyzed the requirement to replicate the ECC content inHANAusing data provisioning.
• Developed batch jobs inSAPBODS which do the ETL betweenSAPECC andHANA
• Designed and created column store tables andHANAViews to support several business reports based on closed opportunities from Planning and financials.
• BuiltHANAInformation models (Attribute Views, Analytical Views, Calculation Views and Column based tables) inHANAdesign studio for efficient data integration.
• Built Schemas, apply Analytic privileges and granted permissions for end users.
• Implemented currency conversion, input variables, calculates key figures, parameters and restrict key figures on Analytic View.
• Executed Data Extraction Transfer Loading (ETL) usingSAPData Services 4.0 to import csv files intoSAPHANAtables
• Developed Real - Time Information models to support SLT replicated tables fromSAPECC.
• MigratedHANAcontent from development, testing environment to Production environment using delivery units.
• Created Universes using Relational Data sources and Databases and publish this universe as a Repository.
• Using the universe created the Dashboards for identify profiles of distinctive donor groups

Confidential, GA

SAP BW HANA Consultant

Responsibilities:

• Involved more than 10BW/BI projects including requirement gathering, design, development, testing and production support.
• Involved with different application area includingSAPR3, SCM and HR
• Experienced withHANAmodeling including calculation, analytics, attribute views and store procedure, advance DSO, composite provider.
• Experienced with an upgrade fromSAPBW7.3 on Oracle toSAPBW7.4 onHANA.
• Experienced with BPC 7.5 NetWeaver, specifically the data integration withBW.
• Expertise and experienced in ABAP programming related toSAPBW.
• Built and enhanced BI objects such as info objects, DSO, info cubes, multi provider, data sources, master Data, transactions, transformations, extractors, APD, process chains, user exits.
• Built restricted key figures, calculated key figures, variable, structures, cell reference, condition reports.
• Built solution for business to execute or run process by demand.
• Designed comprehensiveBWsolutions, translating complex requirements into an optimal BI design
• Coordinated with basis transportingBWobjects to quality and production environment.
• Coordinated with security team to apply and testBWauthorization objects
• Conducted quality assurance activities such as loading testing data, providing test evidence, peer review.
• Provided fixes to eliminate root cause of failures for both support and development environment.
• Proficient knowledge of HR-BWspecifically in the areas of Personnel Management and Organizational Management.
• Strong analytical skills and ability to devise creative solutions to complex problems.
• Ability to work effectively as part of a team made up of consultants fromSAPand other consulting firms and clients from various business disciplines and backgrounds.