PROFESSIONAL SUMMARY:

• More than10 years experience in the Information Technology Industry and 8 years experience as BI/BW Developer for a number of SAP implementation and maintenance projects with extensive experience in SAP BI/BW and SAP SD with more than a year experience in SAP ABAP/4 and a 5 years experience in SAP Business Object.
• Involved in large 8 SAP BW projects, of which 6 were full life cycle end - to end implementations and others being post-implementation and maintenance/production support projects in SD, MM, HR, FICO, CRM, SRM, APO, EHS, OTC, PM, IM, BCS, PS and SCM functional areas.
• Well-versed with the business models in Finance, Banking, Manufacturing and Retail, Food and Beverages industries, Oil and Gas.
• Expertise in all phases of BW implementation like Data Modeling, Data Extraction, Data Analysis and Reporting (Tool/Web Reporting)
• Proficient in various data design models - Entity Relationship (ER), Multi Dimensional/Star Schema and Extended Star Schema models
• Excellent knowledge in SAP Netweaver concepts
• Experienced with Accelerated SAP(ASAP) methodologies in working with end users to collect business requirements, prepare functional specifications, development, installation configuration and performance
• Project Management experience with creating and maintaining WBS (Work Breakdown Structure), Project Plan and ensuring the completion of the activities within the projected timelines/Milestones.
• Worked extensively on Administrative Workbench (AWB)/Data Warehousing Workbench (DWB) for Data Modeling, Scheduling and Monitoring data loads
• Extensive experience in SAP BW/BI components like Standard and Custom InfoCubes, Multi-Cubes, InfoSource, InfoPackage, Datasource, InfoObjects, ODS (DSO), Data Mapping, Update rules, Update routines, Transfer rules, Process Chains and Event management for Automation process, Transformations, DTP and OHS (Open Hub Service) in BI 2004s
• Proficient in ETL and Data Modeling
• Demonstrated experience in data extraction from flat files for Master Data and Transactional Data, update/transfer rules creation, Business content activation and extracting data from legacy systems and Flat files
• Sound Knowledge in Business One
• Proficient in Data staging using ODS/DSO before transferring the ODS/DSO contents to the Infocube
• Built Multi Providers, Multi Cubes and Info Sets as per the requirement
• Improved data load and query performance by using performance tuning techniques like Compression, Aggregates, Partitioning, Rollup, Collapse Indexing of InfoCubes and Repartition
• Extensive hands-on experience in Data Extraction from SAP R/3 using Generic Extraction, LIS Extraction, LO Extraction, CO-PA Extraction and Data Loading (Full/Delta Upload).
• Sound knowledge in BI Concepts like BI Accelerator, BEx Broadcaster, ETL Interface and InfoCubes Remodeling, Information broadcasting
• Expertise in front-end Business Warehouse BEx components like Queries, Web reporting, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Workbooks.
• Extensive experience with Roles, User Authorization, Profiles and User groups
• Experience in ABAP/4 programming techniques including development of Reports, Data Dictionary objects (Tables, Views, Structures, Data Elements and Domains), Job scheduling and Job monitoring

TECHNICAL SKILLS:

SAP: BW 3.5, SAP BI 7.0, 7.3, BOBJ 3.1, 4.0, 4.1, ABAP, C, C++, Microsoft Visual Basic 6.0, Primavera P6, P3 and Qlikview.

Hadoop: Hadoop Map Reduce, HDFS, HBase, Oozie, Sqoop, Flume, Spark, Zookeeper, Yarn, Pig & Hive, Mongodb, Cassandra.

Database: Microsoft Access, DB2, Microsoft SQL Server, Microsoft 2003 Server

Reporting Tools: Business Explorer, Business Analyzer, Business Browser and Web Application Designer

Web Technologies: HTML, DHTML, VBScript, Java Script, ASP and Microsoft FrontPage

Packages: Microsoft Visio, Microsoft Office and Star Office

Operating Systems: Windows 95/98/2000/ME/XP/NT/Vista, UNIX, DOS

QLIKVIEW:

• Qlikview development
• Database Design or Report Development
• Qlikview infrastructure, relational databases and data modeling
• Qlikview load script, data security and expression
• Data Modeling
• Report Design systems and application design
• Managing and prioritizing multiple tasks, work under tight release schedules
• Tableau Workbook design
• Tableau Reports and Dashboards design
• Tableau Administration
• Tableau Server
• Hands-on experience with MicroStrategy platform in Unix environment including:
• Using MicroStrategy Architect and desktop to design a project including creating facts, attributes, relationships and hierarchies
• Creation of reports, cubes and dashboards using Report Services and OLAP Services
• Performance tuning using VLDB settings

PROFESSIONAL EXPERIENCE:

SAP BI/BW/BO/HANA/Data Scientist Consultant

Confidential, San Diego, CA

Responsibilities:

• Involved in the GA SAP Implementation Project
• Involved in the design of over 200 reports for over 2000 Users - Reports cover all SAP Modules e.g. FICO, AR, AP, AA, COPA, OTC (logistics), SCM, PM, MM, PS, QM etc
• Provided Bex and BO 4.1 Training to the Business Users
• Created different Dashboards using BO Dashboard 4.1 and Design Studio
• Created OLAP Analysis Report to meet business requirements.
• Created WEBI Reports
• Used SAP Lumira, BO Explorer and Design Studio
• Created different connections using the IDT (Information Design Tool) in BO 4.1 and publishing it to the BOBJ Repository.
• Created Infoobjects, Infocubes, DSOs, Composite Providers, Hybrid Providers, Transformations, DTPS and Custom Datasources to meet Business Requirement
• Created Bex Queries
• Enhanced Datasource to add additional fields for reporting (E.g Vendor MD, MRPs, FIGL etc)
• Created Process Chains and automated the loading process
• Involved in Project full life cycle including, Development and Production Support.
• Created various BW Transport requests and transported the objects across various landscapes eg. Development to Quality and Production Environment.
• Used the Information Design Tool to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius), Live Office Reports, Design Studio and Lumira
• Designed HANA Models for real live reporting and used BO Tool for reporting.
• Developed Hadoop Frame work and integrated it with HANA for reporting
• Good Knowledge of the Hadoop ecosystem including: Hadoop Map Reduce, HDFS, HBase, Oozie, Sqoop, Flume, Spark, Zookeeper, Yarn, Pig & Hive.
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script, Decision tables.
• Used BODS to Provision data from different data sources
• Loading data into table definitions, suspending data loads, resuming data loads.
• Experience with SAP HANA Studio with Modelling and Administration Perspectives.
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views, and exposure to Procedures decision tables and calculated columns.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Experience in ETLs - BODS, SLT, SAP BI/BW workspace
• Experience in HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers
• Experience in using data flows & workflows using BODS.
• Created Schemas, table definitions, Attributes, Measures and Hierarchies in HANA
• Worked with multiple teams in delivering technical support
• Understanding the Business requirements & converting them into Blueprint
• Defined the Design Documents for the HANA Models
• Translating Functional Specifications into Technical Specifications
• Creation of Package
• Defining the Metadata Import process
• Design & Creation of HANA Attributes, Analytic, Calculation views and Decision Tables

Tools: SAP BW 7.4, SAP BI 4.1.SAP HANA, HADOOP, SAP Design Studio, SAP Lumira, SAP Predictive Analysis, Qlikview and Tableau

SAP BI/BW/BO/HANA /BPC Developer

Confidential, Woodland, Tx

Responsibilities:

• Work closely with business users to design and extend functionality within BPC.
• Creating BPC dimensions and Consolidation Models
• Developed Financial reports using EPM and BW Bex Reports
• Working with business users to design, develop, test and implement input schedules, reports and custom interfaces.
• Write and/or review documentation/user guides/training material/run books as required.
• Experience in BPC modeling and loading data.
• Experience designing and developing logic packages, business process flows, reports and input schedules.
• Building Application Sets/Environments
• Build Dimensions (Members, Hierarchies, Properties, Dimension Formulas)
• Work Status, Developed Business Rules, Business Process Flows, Configured BPC Portal pages and Developed Script Logic
• Configuring and scheduling Data Manager packages through BPC for Office
• Good understanding of Legal Consolidations, Budgeting and Forecasting processes
• Proficient in SAP BI/BW Architecture and Modelling requirements
• Excellent understanding of accounting principles in terms of consolidation and financial statements(balance sheets, Profit and Loss statements etc)
• Hands on experience in configuring / defining the following in the BPC (Business Planning and Consolidation) module.
• Create Dimensions, complex SAP BPC reports and input schedules
• Experience with Data Manager
• Ability to create & maintain security model
• SAP BCS Report Consolidation
• BW extracts, transformations, cube, and build/test associated with FI team deliverables.
• Data extracts, transformations, process chains, ODS Objects, InfoCubes, etc.
• BEx queries, reports, and broadcast settings
• BW processes - Process Chain monitoring and incident resolution
• Involved in full life cycle implementation concept, requirements gathering, data modeling, mockups creation & development.
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script, Decision tables.
• Used BODS to Provision data from different data sources
• Loading data into table definitions, suspending data loads, resuming data loads.
• Experience with SAP HANA Studio with Modelling and Administration Perspectives.
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views, and exposure to Procedures decision tables and calculated columns.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Good exposure to SAP BI tools and SAP HANA integration with BI tools like Crystal reports, Dashboards, WEBI, information designer, Explorer, Analysis editions, and Lumira.
• Hands on experience and Knowledge in Business Objects and Business Planning and Consolidation.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Replicated data using SLT and BODS and created models as per requirement.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges
• Experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Experience in ETLs - BODS, SLT, SAP BI/BW workspace
• Experience in HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers
• Experience in using data flows & workflows using BODS.
• Created Schemas, table definitions, Attributes, Measures and Hierarchies in HANA
• Knowledge in SAP HANA security management including user roles and privileges.
• Communicate effectively with key stakeholders in a multinational environment
• Worked with multiple teams in delivering technical support
• Work with Offshore/Nearshore teams
• Understanding the Business requirements & converting them into Blueprint
• Defined the Design Documents for the HANA Models
• Translating Functional Specifications into Technical Specifications
• Translate the Business KPIs into HANA & Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts
• Defining the Metadata Import process
• Identify Attribute & measures, Hierarchies
• Creation of Package
• Defining the Metadata Import process
• Design & Creation of HANA Attributes, Analytic, Calculation views and Decision Tables
• Activating Impacted Objects
• Validating Information Model
• Experience using Smart Data access

Tools: SAP BPC 10.0, SAP BW 7.4, SAP BI 4.1.SAP HANA

Confidential

SAP BI/BW/BO/HANA Developer/Hadoop

Confidential, Houston, Tx

Responsibilities:

• Involved in the design of over 400 reports for over 5000 Users US Fuels GSAP Project - Reports cover all SAP Modules e.g. FICO, AR, AP, AA, COPA, OTC (logistics), SCM, PM, MM, PS, BPC etc
• Involved in the full implementation of the Project which includes: Development (Functional Spec, Technical Spec, Gap Analysis etc), all phases of the testing cycle (ITC1, ITC2, CAT, LES1, LES2, Cutover, Go Live, Hypercare)
• Provided Bex and BO 4.1 Training to the Business Users
• Created different Dashboards using BO Dashboard 4.1 to meet business requirements.
• Created OLAP Analysis Report to meet business requirements.
• Created Several Crystal Reports to meet Business requirements
• Created WEBI Reports
• Used SAP Lumira, BO Explorer and Design Studio
• Created different connections using the IDT (Information Design Tool) in BO 4.0 and publishing it to the BOBJ Repository.
• Created some Reports using Live Office and using different connections eg. Crystal, WEBI, etc.
• Created Infocubes, DSOs, Composite Providers, Hybrid Providers, Transformations, DTPS and Custom Datasources to meet Business Requirement
• Created Bex Queries
• Enhanced Datasource to add additional fields for reporting
• Created Process Chains and automated the loading process
• Involved in Project full life cycle including, Development and Production Support.
• Created various BW Transport requests and transported the objects across various landscapes eg. Development to Quality and Production Environment.
• Used Rev Track for SAP BW Transport
• Used the Information Design Tool to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live Office Reports.
• Designed HANA Models for real live reporting and used BO Tool for reporting.
• Developed Hadoop Frame work and integrated it with HANA for reporting
• Good Knowledge of the Hadoop ecosystem including: Hadoop Map Reduce, HDFS, HBase, Oozie, Sqoop, Flume, Spark, Zookeeper, Yarn, Pig & Hive.
• Qlikview development
• Database Design or Report Development
• Qlikview infrastructure, relational databases and data modeling
• Qlikview load script, data security and expression
• Qlikview Data Modeling
• Qlikview Report Design
• Qlikview systems and application design
• Managing and prioritizing multiple tasks, work under tight release schedules
• Fundamental understanding and background of Data Modeling design and development
• Involved in full life cycle implementation concept, requirements gathering, data modeling, mockups creation & development.
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script, Decision tables.
• Used BODS to Provision data from different data sources
• Loading data into table definitions, suspending data loads, resuming data loads.
• Experience with SAP HANA Studio with Modelling and Administration Perspectives.
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views, and exposure to Procedures decision tables and calculated columns.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Good exposure to SAP BI tools and SAP HANA integration with BI tools like Crystal reports, Dashboards, WEBI, information designer, Explorer, Analysis editions, and Lumira.
• Hands on experience and Knowledge in Business Objects and Business Planning and Consolidation.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Replicated data using SLT and BODS and created models as per requirement.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges
• Experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Experience in ETLs - BODS, SLT, SAP BI/BW workspace
• Experience in HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers
• Experience in using data flows & workflows using BODS.
• Created Schemas, table definitions, Attributes, Measures and Hierarchies in HANA
• Knowledge in SAP HANA security management including user roles and privileges.
• Communicate effectively with key stakeholders in a multinational environment
• Worked with multiple teams in delivering technical support
• Work with Offshore/Nearshore teams
• Understanding the Business requirements & converting them into Blueprint
• Defined the Design Documents for the HANA Models
• Translating Functional Specifications into Technical Specifications
• Translate the Business KPIs into HANA & Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts
• Defining the Metadata Import process
• Identify Attribute & measures, Hierarchies
• Creation of Package
• Defining the Metadata Import process
• Design & Creation of HANA Attributes, Analytic, Calculation views and Decision Tables
• Activating Impacted Objects
• Validating Information Model
• Experience using Smart Data access
• Act as a liaison between the data scientist and the data architect by identifying and building data models needed for analytics and validating them.
• Performed data modeling on a common data layer architecture that includes SAP BW, BODS, SAP HANA, Sybase IQ and Hadoop data stores (HDFS, MAPReduce, HIVE, HBASE, PIG etc)

SAP BI/BW/BO/HANA Developer

Confidential, New Jersey

Responsibilities:

• New Implementation for BI 7.3 and BO 4.1
• Design MYPD (SAP HR implementation)
• Provided Bex and BO 4.1 Training to the Business Users
• Created different Dashboards using BO Dashboard 4.1 to meet business requirements.
• Created OLAP Analysis Report to meet business requirements.
• Created Several Crystal Reports to meet Business requirements
• Created WEBI Reports
• Used SAP Lumira, BO Explorer and Design Tool
• Created different connections using the IDT (Information Design Tool) in BO 4.0 and publishing it to the BOBJ Repository.
• Created some Reports using Live Office and using different connections eg. Crystal, WEBI, etc.
• Created Portal Iviews and established Portal Connection to BI 7.3 and BOBJ 4.0
• Created Infocubes, DSOs, Transformations, DTPS and Custom Datasources to meet Business Requirement
• Created Bex Queries
• Enhanced Datasource to add additional fields for reporting
• Created WAD Reports
• Created Process Chains and automated the loading process
• Involved in Project full life cycle including, Development and Production Support.
• Created various BW Transport requests and transported the objects across various landscapes eg. Development to Quality and Production Environment.
• Used Rev Track for SAP BW Transport
• Involved in the installation of BOBJ 4.1 (Server and Client Tools)
• Used the Information Design Tool to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live Office Reports.
• Created Financial Reports from BPC
• Involved in full life cycle implementation concept, requirements gathering, data modeling, mockups creation & development.
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script, Decision tables.
• Used BODS to Provision data from different data sources
• Loading data into table definitions, suspending data loads, resuming data loads.
• Experience with SAP HANA Studio with Modelling and Administration Perspectives.
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views, and exposure to Procedures decision tables and calculated columns.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Good exposure to SAP BI tools and SAP HANA integration with BI tools like Crystal reports, Dashboards, WEBI, information designer, Explorer, Analysis editions, and Lumira.
• Hands on experience and Knowledge in Business Objects and Business Planning and Consolidation.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Replicated data using SLT and BODS and created models as per requirement.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges
• Experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Experience in ETLs - BODS, SLT, SAP BI/BW workspace
• Experience in HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers
• Experience in using data flows & workflows using BODS.
• Created Schemas, table definitions, Attributes, Measures and Hierarchies in HANA
• Knowledge in SAP HANA security management including user roles and privileges.
• Communicate effectively with key stakeholders in a multinational environment
• Worked with multiple teams in delivering technical support
• Work with Offshore/Nearshore teams
• Understanding the Business requirements & converting them into Blueprint
• Defined the Design Documents for the HANA Models
• Translating Functional Specifications into Technical Specifications
• Translate the Business KPIs into HANA & Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts
• Defining the Metadata Import process
• Identify Attribute & measures, Hierarchies
• Creation of Package
• Defining the Metadata Import process
• Design & Creation of HANA Attributes, Analytic, Calculation views and Decision Tables
• Activating Impacted Objects
• Validating Information Model
• Experience using Smart Data access

SAP BI/BW/BO/HANA Developer

Confidential, Houston, Tx

Responsibilities:

• Provided Bex and BO 4.0 Training to the Business Users
• Created different Dashboards using BO Dashboard 4.0 to meet business requirements.
• Created OLAP Analysis Report to meet business requirements.
• Created Several Crystal Reports to meet Business requirements
• Created WEBI Reports
• Created different connections using the IDT ( Information Design Tool) in BO 4.0 and publishing it to the BOBJ Repository.
• Created some Reports using Live Office and using different connections eg. Crystal, WEBI, etc.
• Designed EHS Report using BO Tools
• Involved in full life cycle implementation concept, requirements gathering, data modeling, mockups creation & development.
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script, Decision tables.
• Used BODS to Provision data from different data sources
• Loading data into table definitions, suspending data loads, resuming data loads.
• Experience with SAP HANA Studio with Modelling and Administration Perspectives.
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views, and exposure to Procedures decision tables and calculated columns.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Good exposure to SAP BI tools and SAP HANA integration with BI tools like Crystal reports, Dashboards, WEBI, information designer, Explorer, Analysis editions, and Lumira.
• Hands on experience and Knowledge in Business Objects and Business Planning and Consolidation.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Replicated data using SLT and BODS and created models as per requirement.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges
• Experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Experience in ETLs - BODS, SLT, SAP BI/BW workspace
• Experience in HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers
• Experience in using data flows & workflows using BODS.
• Created Schemas, table definitions, Attributes, Measures and Hierarchies in HANA
• Knowledge in SAP HANA security management including user roles and privileges.
• Communicate effectively with key stakeholders in a multinational environment
• Worked with multiple teams in delivering technical support
• Work with Offshore/Nearshore teams
• Understanding the Business requirements & converting them into Blueprint
• Defined the Design Documents for the HANA Models
• Translating Functional Specifications into Technical Specifications
• Translate the Business KPIs into HANA & Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts
• Defining the Metadata Import process
• Identify Attribute & measures, Hierarchies
• Creation of Package
• Defining the Metadata Import process
• Design & Creation of HANA Attributes, Analytic, Calculation views and Decision Tables
• Activating Impacted Objects
• Validating Information Model
• Experience using Smart Data access

SAP BI/BW/BO/HANA Developer

Confidential, Nashville, Tennessee

Responsibilities:

• New Implementation for BI 7.3 and BO 4.0
• Implemented New GL (EHP3), Purchasing, AR, and AP
• Worked on Simplified Reporting based on the new SAP ECC EHP5.
• Provided Bex and BO 4.0 Training to the Business Users
• Created different Dashboards using BO Dashboard 4.0 to meet business requirements.
• Created OLAP Analysis Report to meet business requirements.
• Created Several Crystal Reports to meet Business requirements
• Created WEBI Reports
• Created different connections using the IDT ( Information Design Tool) in BO 4.0 and publishing it to the BOBJ Repository.
• Created some Reports using Live Office and using different connections eg. Crystal, WEBI, etc.
• Created Portal Iviews and established Portal Connection to BI 7.3 and BOBJ 4.0
• Created Infocubes, DSOs, Transformations, DTPS and Custom Datasources to meet Business Requirement
• Created Bex Queries
• Enhanced Datasource to add additional fields for reporting
• Created WAD Reports
• Created Process Chains and automated the loading process
• Created Pivot tables and graphical representation of the Pivot Tables
• Involved in Project full life cycle including, Development and Production Support.
• Created various BW Transport requests and transported the objects across various landscapes eg. Development to Quality and Production Environment.
• Involved in the installation of BOBJ 4.0 (Server and Client Tools)
• Used the Information Design Tool to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live Office Reports.
• Created Financial Reports from BPC
• Involved in full life cycle implementation concept, requirements gathering, data modeling, mockups creation & development.
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script, Decision tables.
• Used BODS to Provision data from different data sources
• Loading data into table definitions, suspending data loads, resuming data loads.
• Experience with SAP HANA Studio with Modelling and Administration Perspectives.
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views, and exposure to Procedures decision tables and calculated columns.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Good exposure to SAP BI tools and SAP HANA integration with BI tools like Crystal reports, Dashboards, WEBI, information designer, Explorer, Analysis editions, and Lumira.
• Hands on experience and Knowledge in Business Objects and Business Planning and Consolidation.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Replicated data using SLT and BODS and created models as per requirement.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges
• Experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Experience in ETLs - BODS, SLT, SAP BI/BW workspace
• Experience in HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers
• Experience in using data flows & workflows using BODS.
• Created Schemas, table definitions, Attributes, Measures and Hierarchies in HANA
• Knowledge in SAP HANA security management including user roles and privileges.
• Communicate effectively with key stakeholders in a multinational environment
• Worked with multiple teams in delivering technical support
• Work with Offshore/Nearshore teams
• Understanding the Business requirements & converting them into Blueprint
• Defined the Design Documents for the HANA Models
• Translating Functional Specifications into Technical Specifications
• Translate the Business KPIs into HANA & Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts
• Defining the Metadata Import process
• Identify Attribute & measures, Hierarchies
• Creation of Package
• Defining the Metadata Import process
• Design & Creation of HANA Attributes, Analytic, Calculation views and Decision Tables
• Activating Impacted Objects
• Validating Information Model
• Experience using Smart Data access

Tools: BOBJ 4.0, BW 7.3, HANA, BW HANA, BPC 10.0, Crytal Report 2011, Crystal Enterprise and Qlikview

SAP BI/BW/BO/HANA Developer

Confidential, Houston, TX

Responsibilities:

• Requirement gathering for the EHS Business Requirement
• Created Infocubes, DSOs, Transformations, DTPS and Custom Datasources to meet Business Requirement
• Created different Bex Queries
• Created WAD Reports
• Created Process Chains and automated the loading process
• Created Pivot tables and graphical representation of the Pivot Tables
• Involved in Project full life cycle including, Development and Production Support.
• Created various BW Transport requests and transported the objects across various landscapes eg. Development to Quality and Production Environment.
• Involved in the installation of BOBJ 4.0 (Server and Client Tools)
• Used the Information Design Tool to establish connection and created different resources for BO Reporting. Created WEBI Report, OLAP Analysis report, Crystal report, Dashboard (Xcelsius) and Live Office Reports.
• Involved in full life cycle implementation concept, requirements gathering, data modeling, mockups creation & development.
• Created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, Loading data into table, developed Attribute Views, Analytical Views and Calculation views Graphical and SQL Script, Decision tables.
• Used BODS to Provision data from different data sources
• Loading data into table definitions, suspending data loads, resuming data loads.
• Experience with SAP HANA Studio with Modelling and Administration Perspectives.
• Expertise in creating various Information Models like Attribute, Analytic and Calculated Views, and exposure to Procedures decision tables and calculated columns.
• Good exposure and hands on experience with Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Good exposure to SAP BI tools and SAP HANA integration with BI tools like Crystal reports, Dashboards, WEBI, information designer, Explorer, Analysis editions, and Lumira.
• Hands on experience and Knowledge in Business Objects and Business Planning and Consolidation.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Replicated data using SLT and BODS and created models as per requirement.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Experience working on HANA Enterprise - Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges
• Experience in Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA.
• Experience in ETLs - BODS, SLT, SAP BI/BW workspace
• Experience in HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers
• Experience in using data flows & workflows using BODS.
• Created Schemas, table definitions, Attributes, Measures and Hierarchies in HANA
• Knowledge in SAP HANA security management including user roles and privileges.
• Communicate effectively with key stakeholders in a multinational environment
• Worked with multiple teams in delivering technical support
• Work with Offshore/Nearshore teams
• Understanding the Business requirements & converting them into Blueprint
• Defined the Design Documents for the HANA Models
• Translating Functional Specifications into Technical Specifications
• Translate the Business KPIs into HANA & Define the Reporting Layouts
• Translate the Business KPIs for Dashboards & Define the dashboard Layouts
• Defining the Metadata Import process
• Identify Attribute & measures, Hierarchies
• Creation of Package
• Defining the Metadata Import process
• Design & Creation of HANA Attributes, Analytic, Calculation views and Decision Tables
• Activating Impacted Objects
• Validating Information Model
• Experience using Smart Data access

Tools: BOBJ 4.0, BW 7.3, HANA, BW HANA

SAP BI/BW/BO Developer/ Data Archiving

Confidential, Irving, TX

Responsibilities:

• SAP BI/BW Development and Production Support
• Requirement gathering
• Extensive use of BW Open Hub functionality and Data Services to load data to a third party system ( Netezza)
• Created Archiving Documents and was involved in archiving Data using BW archiving process/technology
• Created Infocubes, DSOs, Transformations, DTPs, Datasources to meet Business Requirements
• Improved the performance of reports and process chains