PROFESSIONAL SUMMARY:

• Interacted with business stakeholders, business analysts and user groups across multiple industries including Oil and Gas, Healthcare, and Pharmaceutical firms and currently Retail industry.
• HANA (Modeling): Designed and implemented Attribute, Analytical and Calculation views. including SQL script based and graphical calculated views.
• HANA (Schema): Worked extensively on Schema (SQL DDL, DML) and Security
• HANA (Data Provisioning): Replicated data from legacy systems applying SLT techniques, From Hadoop (SDA) and from SAP BW 7.5 into Confidential modeling.
• HANA: Exposure to Predictive Analytics Library and Live Hana
• SAP HANA with Business Objects Tool Set Implementation
• BusinessIntelligence (DataWarehouse): Created DSO, Cubes, multicubes, Objects, MultiSets and Aggregates
• BusinessIntelligence (ETL): Replicated data from Sales & Distribution and created DataSource
• BusinessIntelligence (B. EX Reporting): Designed B. Ex reports with Variables, RKF and CKF
• BusinessObject ( Universe): Extracted data from SAP BI and Oracle and created Aliases/Contexts to fix loops
• BusinessObject (Web Intelligence): Designed complex and advanced multiple reports
• BusinessObject ( LCM) : Transported reports and IDT between Dev, QA/Prod and c reated Version Management.
• BusinessObject (Crystal Reports): Designed Complex Crystal Reports, Frequency Reports, Summary Reports, Drill - down, Dynamic Grouping, formulae, Parameters, Selection criteria while writing several SQL queries
• BusinessObject (CMC): Created users, groups and privileges to end users
• SAP BODS 4.X: Migrated data from Oracle 11g into SAP HANA
• SQL and Modeling: More than 8 years of experience in RDBMS, Oracle PL/SQL and SAP Hana.
• ABAP: Created Tables, Views, DataSource, Function Module and InfoSet
• Tableau: Experience in Designed visualized charts, Dashboards and interactive charts
• SAP Hana4: Exposure to work on CDS.

TECHNICAL SKILLS:

• SAP HANA 5
• SAP BI 7.X 5+
• SAP BusinessObjects 4.X 3+
• SAP BusinessObjects Data Services 4.X 1.5+
• Oracle PL/SQL, Reports, Forms 8
• SAP ECC 6.0 Deep exposure

WORK EXPERIENCE:

Senior SAP Architect

Confidential, Woonsocket, RI

Responsibilities:

• HANA (Modeling) - Designing Calculation View. Created and applied input parameters, filters.
• Created Dynamic Filter Stored Procedures to apply in Multiple calculation views.
• Created Table Functions and accessed in Calculation Views.
• HANA (Data Provisioning) - Virtual cold Data is extracted from Hadoop thru Spark(SDA) under provisioning.
• Data from Hadoop and Hana is stored and modeled in Confidential combined thru Union All in Calculated views.
• Complex filters created in Projections.
• HANA (Transport): Transported contents from Dev environment to Testing environment using HANA Application Lifecycle Management(HALM).
• Troubleshooting the Performance Issues
• Providing support to existing Webi Reports and Modeling views.
• Also giving performance on SAP Analysis for Microsoft Office.
• Promoted Reports and Universes in Promotion Management(CMC).
• Involved in Confidential
• Exposed Hana calculation view in ABAP SE16
• Get Development, update and mapping instruction from Business analyst to design business.

Confidential

Senior SAP Architect

Responsibilities:

• Interacted with Business stake holders to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains.
• HANA (Modeling) - Designing Views (Attribute View, Analytic View, Calculation View). Applied Restricted and Calculated measures, input parameters, filters, Hierarchy, Variables and Currency conversion. Designed Calculation views with graphic and SQL Script. Worked on Decision tables.
• HANA (Data Provisioning) - Replicated data from Legacy system ECC 6.0 into HANA system in Large Enterprise DB system applying SLT and creating RFC.
• HANA (Security) - Design - Roles, SQL Privileges, Package Privileges, Analytic Privileges Integration.
• Design and Implement SAP HANA Static and Dynamic Analytic Privileges for Row Level Security.
• HANA (Transport): Transported content from Dev environment to Production environment using delivery units.
• Troubleshooting the Performance Issues
• Client Testing Step by Step Business Review with the Client and IT Team.
• Evaluation and Decision Detailed Presentation to compare As-is and proposed HANA Scenario
• Exposure to Live Hana and Predictive Analytics Library.
• Working on SAP Lumira along with my Hana responsibility
• Replicated Cube and DSO data from SAP BW 7.5 into HANA Calculation Analytical Views
• Connect to SAP BusinessObject 4.2 and working on Webi reports.
• Exposure to SQL Scripting of Creating CDS/EDM views from RAW HANA SQL TABLE
• Working on Core Data Services (CDS) in ABAP thru Eclipse on S&D Tables. Will bring into production soon.
• Cold data is stored in SAP BW 7.5 and limited hot data stored in Hana. Data is extracted from SAP BW into Confidential modeling as CompositeProvider and DSO to map with Hana tables and combined in Calculated View.

Confidential

Responsibilities:

• SAP BI - SAP Integrated Planning Solutions. Extraction, Transformation, Loading and B. Ex reporting.
• Created InfoSet, Functional Module and Views to extract Data thru Generic Delta from ECC 6.0. Created DSO, Cubes and B. Ex reporting. Lead a pool of resources for the development of Enhancements.
• Responsible for providing high end BI Solutions for the client that includes SAP BW as well as Universes
• Designing in BO4.1 and taking to Webi reports.
• BI solutions for Energy KPI’s, leading to multiple complex reports for analyzing and evaluating various types of Metrics and indexes which affect the overall financial wellbeing of company.
• Responsible for providing SAP Integrated Planning - planning solution to the client where data can be used for Dashboard designing in BO 4.1.

Confidential

Responsibilities:

• considered the scope of the project, the time available according to the deliverable dates, the resources, the length of services downtime, the and the backups and Involved in information gather phase
• Implemented full cycle of project on SAP HANA
• Involved in business and Architecture discussions.
• Worked closely with SAP Technical team on implementing the Health and safety project on HANA.
• Used Oracle as source DB and HANA as target with SAP Business Objects Data Services as ETL.
• Managing Attribute Mapping and Creation of Constant columns.
• HANA Security: Created Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges.
• Schema: Designed Schema and Store Procedures.
• Created, Cleaned and inserted data in tables using functions, DDL and DML SQL script. Have extensive experience of Modeling, independent and team player.
• Created Schemas as part of HANA Security and Development.
• Create cardinality and modeling in relational database applying normalized rules.
• Packages: Designed and implemented SAP HANA data modeling using Attribute View, Analytic View and Calculation View applying star schema joining fact tables and dimensions.
• Applied Restricted and Calculated measures, input parameters and filters.
• Developed complex Graphics and SQL and CESQL Scripting in Calculation views applying Unions and Joins.
• Exposed to ETL using SAP Data Services 4.1 and connected Oracle to HANA in BO 4.1 CMC.
• Designed Information Design Tool creating relational connection, Data Foundation and Business Layer Universe for HANA reporting.
• Developed Web Intelligence Reports and supported Dashboard creation.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report.
• : Provided to End users
• Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’
• Participated in the complete development lifecycle: analysis, design, build and test reports.
• Transport Contents: Migrated Hana contents Schema and Packages between Dev, QA and production through Life Cycle Management, Delivery Unit. Worked on Authoring and Physical Schema mapping.
• Integrating HANA views with Reporting tools BOBJ

Confidential

Responsibilities:

• Migrated data from Oracle DWH into HANA schema.
• Strong experience in the integration of BODS with Oracle, Non-SAP data sources.
• Created complex Jobs, Work Flows, Data Flows, and scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Extensive experience in Key Performance Metrics (KPIs), facts, dimensions, hierarchies, designed Star schemas and Database in PL/SQL
• Long experience in Data modeling (Dimensional & Relational) concepts including Star-schema

Confidential

Responsibilities:

• Performing a Role of a BO Solution Architect with major focus of planning, gathering information, designing IDT and Webi reports applying Best practices.
• The complexity of the Architectural Design is quite high. The target is to simplify the IDT of 10 Fact and 180-dimension tables and move the new landscape over Webi reports.
• I worked for the initial design documents for the client to give them a complete picture and high-level proposals, universe modeling and Webi report designing.
• Provided to End users
• Responsible for providing support to servers. Providing support to End Users for CMC.
• Creating Roles and Users migrating reports and universes between DEV, QA & Prod. and daily support
• Monitoring live charts to ensure correct information displayed.

Confidential

Senior Integrated Consultant

Responsibilities:

• Continue relationships with client management to handle expectations of service, together with work products.
• Timing and deliverables. Worked on data warehouse project, which comprises of providing data for reporting purposes. It includes understanding of the business requirements, catering to those requirements by providing a solution. Involved in monitoring the performance of the system and reporting which includes performing Aggregates, Indexes, Archiving the non-cumulative info cubes and Partitioning. Worked with the implementation team in SAP BI/BW 7.0.
• Created InfoCubes, DSO objects and MultiProviders InfoObject and SAP Business content objects using Customer namespace in SAP BI/BW 7.0
• Worked with Business Analysts and User Groups to gather the analytics requirements from different user groups and involved in providing the approach for the solution
• Worked with BOBJ 3.1 business users, Project Managers, Architects and involved in requirement gathering, analysis and creation of best practice architecture
• Universe Design: Universe planning building and implementation
• Web Intelligence: Created Advance multiple Ad hoc query reports
• Xcelsius: Chart with visualizing data range using parameters, Series, Interactive model, Query as a Web Service
• Configured OBIEE Metadata Objects including repository, BMM and information areas. Creaed variables, interactive dashboards, Pivot tables and reports.

Confidential, Southfield, MI

Senior Programmer

Responsibilities:

• Involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency & customer service and standardize documentation process
• Delivery of OBI development and maintaining OBI Best Practices
• Reviewed the deliverables and ensure that the deliverables meet client requirements
• Accomplished Peer-a-Med project using Oracle roll ups and scripts.
• Oracle PL/SQL, SQL, SQL*PLUS and TOAD: Created Procedures, Functions, Triggers, tables, Views and fixed inconsistent data receiving monthly
• SQL*LOADER: Loaded and fixed date, created control files, loaded with Store Functions and applied business rules to remove duplicates. Converted MS Access data and reports into Oracle.
• Oracle Designer: Created data modeling and Schema, applied business rules and Cardinality
• Developer 2000: Created User Interfaces for direct input of data as per user requirements using Oracle Forms and Financial Reports using lot of parameters
• Visual Cactus: Mapped data and loaded back in Oracle 9i
• Discoverer: Created and customized Oracle Discoverer Administrator data for client facility
• Interacted with business users, stakeholders, and IT staff to help define business requirements
• Crystal Reports: Provided report generation solution to the clients using Crystal Reports.
• Provided support in Oracle 10g PL/SQL in modeling, designing schema and writing complex queries