SUMMARY:

• Over 9 years of experience in SAP BW/BI, SAP Business Objects, Tableau, SAP Data Services, Information Steward, Data Quality Management, Data warehousing OLAP and OLTP applications which includes 3Full Life Cycle implementations and production support in various domains like Banking, Utilities, Networking and life Science
• 5+ years of Experience in Tableau Desktop/Server in creating highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Expertise in development of Data Warehouse Data Marts, Data Modeling, designing the STAR and SNOWFLAKE schemas
• Hands - on experience in Universe design tool (UDT) and Information Design Tool (IDT)(Universe) by leveraging Oracle, Teradata, SQL Server & BW
• Good Knowledge in SQL, PL/SQL, views, stored procedures and other components of database applications
• Extensive experience of SAP BW/BI components like Standard InfoCubes, DSO's, InfoObjects, DataSource, InfoSets, Hierarchies, Start/End/Transfer Routines, Open Hubs, Transformations, MultiProviders, Composite Providers, IDocs, User Exits
• Good Exposure to Customer Master, Vendor Master, Sales and Distribution (SD), Material Management (MM), Production Planning (PP), Finance & Controlling (FICO), Human Resources (HR), Supplier Relationship Management (SRM), Customer Relationship Management (CRM) and Supply Chain Management (SCM)
• Expertise in Design the target table structures and develop the data flow to extract data from various source systems like SAP BW as Source and Target, SAP ECC, SAP CRM, SFDC, IP (Integrated planning, Oracle Database, SQL and flat files as well
• Expertise in BODS, Creation of inbound/outbound interfaces and real time jobs
• Experience in Information Steward for Data Profiling and creation of Score cards and business rules
• Expertise in Data Quality Management for Data profiling, Data Quality, Address Cleansing, Data Cleansing, Data Conversion, Data Integration and Master Data Governance
• Experience in BODS Management Console for doing the administrative tasks like Scheduling, Monitoring jobs and for creation of users and data stores
• Expertise in In-Memory analytics Tools Tableau, Lumira & QlikView
• Connected Tableau server to publish dashboard to a central location for portal integration and setup auto refresh feature

TECHNICAL SKILLS:

ETL Tools: SAP BODS 4.2, Information Steward (IS), Data Quality Management (DQM) and Informatica

Reporting and Analytics Tools: SAP BO 4.2, Crystal Reports, Analysis for Office, Lumira, Tableau and QlikView

Data Modeling Tools: SAP BI/BW 7.4 and Oracle BI

Data Bases: Oracle, SQL and Teradata

Methodologies: Waterfall, Agile & DevOps

Defect & Incident Process: Remedy for Incident Management, JIRA Charm for Change Management and HPQC for Defect Management

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, California

SAP Business Objects / Tableau Consultant/ Tech Lead

Roles & Responsibilities:

• Interacted with the end users to understand the business requirements and derived technical specifications from functional specifications
• Worked with business very closely in identifying the dimensions, Measure and metrics they needed and done gap analysis in documenting BRD
• Involved in designing and developing the architecture of reporting layer
• Derived high level Technical Design Documents based upon the Functional Requirements Document
• Developed most interactive customer information dashboards for global users
• Worked with business users closely in gathering the requirements and developed dashboards accordingly
• Extensively used dashboard action filters to show the drill down dimensionally
• Designed an application with multiple dashboards by embedding URL’s and implemented row level user security from top level summary page to low level drill down
• Developed customized charts like Funnel charts, Donut charts, Radial charts for best user interaction
• Used LOD calculations in dashboards to show the data in different levels
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Expertise in creating Complex WEBI, Crystal reports like (Ad Hoc Reports, Canned Reports, Frequency Reports, Summary Reports, graphical, aging reports, Trend Reports, Master/Detail, Trends, Comparison, Drill down/Drill up, Cross Tab and Chart), Sub-reports and other Crystal functions
• Developed Interactive dashboards with blended views and provided multiple filtering option and action filters with best interaction
• Publishing the extracts, running the extracts refreshes, creating Projects, creating the users and their roles
• Lead team in educating and following the guidelines to maintain the consistency across all the dashboards and Appling optimizing techniques
• Shared my thoughts and ideas across the organization to improve the dashboard interactivity
• Optimized performance of the dashboards by implementing different optimization techniques
• Design strategy for the Business Objects Universe and Business Objects Reports & Working on CDW data modelling
• Design & Maintenance Business objects semantic layers (Universe) Using BO IDT
• Implemented aggregate awareness on summary tables in universes BO IDT
• Created different Detail and Summary Webi reports showing Utilization, Meter Read, Daily Payment etc.
• Converted around 100+ RSS Brio reports to BOBJ Webi and Crystal reports
• Created Year to Date and Rolling 12 months and Report reusable filters
• Created the Webi Reports from Multiple Data providers with Different grain of Data
• Created Universe Level Custom filters, Cascading prompts, Hierarchies, Custom Lov’s.
• Implemented Performance technique like Index Awareness Universe level
• Working change Request on Existing BODS Jobs
• Maintaining Production job and maintain tracking schedule
• Working on Production issues, backtracking the issue from webi report to Source Jobs
• Back track the reports issues with BODS jobs, Identifying the ETL mapping issues and resolving
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis

Environment: SAP Business Intelligence 4.2(Business Objects - Web Intelligence, IDT, UDT), SAP BW 7.5, Query Designer, Business Explorer Analyzer, Power BI, Tableau 10, Analysis for Microsoft Excel, Oracle 11g/12c, SQL.

Confidential, San Francisco, California

SAP Business Objects / Tableau Consultant/ Tech Lead

Responsibilities:

• Interacted with the end users to understand the business requirements and derived technical specifications from functional specifications
• Derived high level Technical Design Documents based upon the Functional Requirements Document
• Designed Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Extensively used data blending functionality in tableau to show the comparison of one metric and dimension with different filtering options.
• Expertise in using various dashboard components like Horizontal, Vertical Containers and Sheet filters to show multiple chart types and filters in a single view or Dashboard.
• Developed and maintained multiple internal dashboards which run for every hour with complex logic and functionality’s for executives.
• Worked very closely with Accounting and Marketing people in training them on tableau as a part of self-serve BI.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Implemented user security to limit the data in the view dynamically based on the login username related to studio
• Involved in embedding Tableau Server views into webpages
• Customized Tableau server by creating different projects, Users, Groups, Extract and subscription schedules and built the security model on different levels such as Project, Workbook and view
• Provide analysis and recommendations for ETL implementation to load data from SuccessFactors to SAP BW
• Developed 30+ inbound interfaces in SAP BODS to load the data from SuccessFactors to SAP BW by using SFAPI adapter
• Developed 9 Webi reports based on BW Bex queries showing different Detail and Summary Reports Like staffing status, schedule time to start and fill, candidate relocation and requisition audit, requisition dump etc.
• Created “Candidate All Activity Status” and “Relocation Eligible by New hire and Transfer” dashboards by using Tableau
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis for candidacy progression status and requisition audit

Environment: SAP BO 4.2, Analysis for Office, SAP BW 7.5, BEx Analyzer, Query Designer, Tableau 10 / 10.1, SQL, Oracle 11g

Confidential, San Francisco, California

SAP Business Objects / Tableau Consultant/ Tech Lead

Responsibilities:

• Interacted with the end users to understand the business requirements and derived technical specifications from functional specifications
• Derived high level Technical Design Documents based upon the Functional Requirements Document
• Provide analysis and recommendations for ETL implementation to load data to data warehouse
• Design strategy for the Business Objects Universe (FAS) and Business Objects Reports & Working on CDW data modelling
• Design & Maintenance Business objects semantic layers (Universe) Using BO IDT
• Implemented aggregate awareness on summary tables in universes BO IDT
• Developed 52 Webi reports and 2 dash boards based on universe (FAS Data Mart)
• Created different Detail and Summary Webi reports showing Utilization, Meter Read, Daily Payment, Monthly leak survey and leak open etc.
• Creating Year to Date and Rolling 12 months and Report reusable filters
• Created Universe Level Custom filters, Cascading prompts, Hierarchies, Custom Lov’s
• Created 130 Reports jobs for different business units using infoburst job scheduler
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis

Environment: SAP BO 4.2, Information Design Tool, BO Explorer, Analysis for Microsoft Excel, Oracle 11g/12c, SAP BW 7.5, Query Designer, Power BI, Tableau 10 / 10.1

Confidential, Indianapolis, Indiana

Sr. SAP BI/BO / Tableau Consultant

Responsibilities:

• Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature
• Maintained Test log and Wrote Test Evaluation, Summary Reports
• Extensively involved in doing user acceptance testing (UAT)
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
• Utilized Tableau server to publish and share the reports with the business users
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group
• Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections
• Add/Edit Sites and corresponding administration rights (System vs. Content)
• Create/Modify/Manage server task schedules
• Monitor server activity/usage statistics to identify possible performance issues/enhancements
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community

Environment: Tableau 9.3, 9.4, 10.0 Tableau server, SAP BO WEBI, SAP BO Analysis for Office, MS-Excel, SQL Server, SharePoint, Microsoft office, Windows 7

Confidential, Sunnyvale, CA

SAP HANA /BO&BODS/Tableau Consultant

Responsibilities:

• Gathering the requirement from Business spec and functional spec
• Analyzed the Functional Specs provided by the process teams and fill the technical gaps if any before assigning it to a developer
• Preparation of Functional specification document (FSD) for respective objects.
• Preparation of Technical design documents for accordingly
• Will get the sign from respective team; later deals with whole development of corresponding objects
• Define & Develop ETL jobs to facilitate Data Warehousing
• Development of stored procedures and HANA models (Information views), Data provisioning and Transformation based on hierarchies & aggregation factor for BO consumption
• Build the multiple reports and Dashboards on Calculation View / Analytic View using BO Webi and Tableau
• Build multiple Analysis work books using SAP Analysis for office for Finance Users
• Interact with clients directly provides my inputs in various situations like during technical designing, object development and make sure the technical team is getting right inputs from the functional team
• Done performance tuning in ETL jobs while creation of various interfaces in various systems (will retrieve and push the data) like inbound interfaces (SFDC, Integrated Planning and Agile) outbound interfaces (Demantra, Hyperion, OBIEE and Serus and Marketing System)
• Have created the interface as Real time job to handle the process of standardizing the customer details i.e. Data flows from 5 boundary systems via CRM interfaces to DS, where in DS will have to standardize Name and address using SAP address directories and check for duplicate records against existing CRM data and return the results, that if duplicate found then return BP IDS with matching % or if no duplicate found then return standardize name and address details by using the Parsing, Correction, Standardization and Duplicate Matching techniques in DQM(Data Quality Management).
• Have handled threshold for determining Duplicate records entered in source CRM GUI screen through real time job using the Match Editor transformation to calculate the threshold percentage i.e. sum of the given weightage of different fields that match and Used the match code patterns the percentage similarity of entered record with the existing record is calculated
• Reviewed code and Technical Specs delivered by me, does self QC and put forward best practices; and make sure they adhere to those standards before moving the objects to Quality for further testing
• Preparation of Functional unit testing document
• Expertise in creation of ATL files and has Good support experience in maintaining a robust BODS landscape
• Good working knowledge in Installing Data services 4.X and worked on different Transport methods Direct importing of ATL, Shared directory, ftp and custom transfer to import the data from SAP R3/BI System
• Prepared ETL flows, data cleansing, matching, and auditing by creation of real time jobs using Data Services
• Experience with cleansing and profiling data in Data Services and experience troubleshooting issues with data type mismatches and formatting
• Extensively worked with Repository manager, Job server, Workbench, Information Steward, Administrator Console, Metadata Integrator in generating ETL Project, Business Intelligence, Data quality with Heterogeneous data sources including XML, R3, BI with Full load and Incremental load capabilities in a Batch or Real time data flow
• Used BODS Management Console for doing the administrative tasks live Scheduling, Monitoring jobs and for creation of users and data stores
• Extensively used ABAP data flow processing using Data services to improve the performance of the jobs
• Preparation of test scripts, initiate with sing off process and will move to HPQC tool
• Dealt with the defects raised by the Functional Team during Integration and User Acceptance Testing and tracking their progress so that they are fixed on time
• Report Generation - Worked in BEX Analyzer in building Queries Created BO Webi reports based on BEx queries

Environment: SAP HANA Studio, SAP SLT, Webi Rich Client, SAP Analysis for office, SAP BODS 4.2, IS (Information Steward), DQM (Data Quality Management, Tableau 9.3 MS-Excel, SQL Server, SharePoint, Microsoft office, Windows 7

Confidential

Sap BO/BODS Consultant

Responsibilities:

• Understanding existing business model and customer requirements
• Mapping Data Items from Source system to the Target system
• Involved in the designing and implementation of the mappings for stage to data warehouse data loading
• Extensively involved in Data Extraction, Transform and Loading (ETL Process) from Source to target systems using BODS
• Created jobs to load data from source into Target using Flat File Format, Query Transform, Case Transformation, Lookup function, and Merge, Validation and Table Comparison Transformation.
• Used the Web Administrator to schedule the jobs and monitoring the Resulting

Environment: SAP BODI 11.7, SAP BO XI 2 (Webi), Oracle 10g, MS-Excel, SQL Server, SharePoint, Microsoft office, Windows 7.

Confidential

Sap BO/BODS Consultant

Responsibilities:

• Interacting with business in resolving production issues (both ETL and Reports)
• Coordinating with team in solving production issues (ETL)
• Supporting Business Objects Universe/ Reporting application
• Supporting Tableau Dashboards
• Worked on Enhancements in ETL and Reporting
• Involved in gathering requirements and business logics from the users
• Developed critical OLAP reports like drill down, Slice and Dice, master/detail for analysis.
• Scheduled and monitored the reports
• Involved in full life cycle of Business Objects Suite

Environment: SAP BODI 11.7, SAP BO XI2 (Webi), Oracle 10g, MS-Excel, SQL Server, SharePoint, Microsoft office, Windows 7.

Confidential

Sap BO/BODS Consultant

Responsibilities:

• Gather and understanding the requirements from the client and act as a sole functional resource.
• Configured SAP Data flows and created SAP R3 Data store, SAP BW Source data store, SAP BW Target data store
• Designed Business objects semantic layers (Universe, Business view manager & Voyager) with SAP Warehouse and Non-SAP warehouse
• Involved in DQ Process and Data Profiling along with Performance Tuning
• Created ETL design and ETL mapping documents
• Extracting the data from flat files which are dynamic in structure using BODS
• Wrote scripts for creating dynamic tables based on the structure of the flat file
• Created batch scripts for handling dynamic file formats, for creating dynamic data stores and for importing and exporting the BODS jobs in .xml format
• Developed complex batch jobs using BODS
• Used various DI transformations like Pivot, Reverse pivot, Table Comparison, Map Opration and DQ transformations like Address cleansing, ISO country code, Data cleansing, Match etc.
• Used Central Repository to check in and check out of the jobs to maintain version history and for multi user development
• Extensively worked on performance tuning of the programs and processes by using concepts like linked data stores, parallel execution, recovery mechanism, degree of parallelism (DOP), etc.
• Involved in the design of Requirement Specification Documents
• Developed mappings using number multiple transformations for moving data from client Environment to Staging Area and then to Ware house (EISW)
• Extracting, Transforming and Loading the Data through SQL Server Scripts
• Scheduled the ETL Jobs Daily in UAT environment and generate the error log files
• Posting the user regarding the error information during the load and supported by rerunning the ETL jobs
• Responsible for timely and efficient delivery of allocated modules

Environment: SAP BODI 11.7, SAP BO XI2 (Webi), Oracle 10g, MS-Excel, SQL Server, SharePoint, Microsoft office, Windows 7