SUMMARY

• SAP Techno functional Consultant with more than 10 years of executive level experience in Analysis, Design, Development, Testing and Upgrade areas in BW/BPC/HANA using BI tools in Financial, Retail, e - commerce and Telecom industries.
• 4+ years of extensive experience with design and development of Tableau visualization solutions.
• Extensive experience inTableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau reader in various versions of Tableau (7.x/8.x/9.x) and SQL, PL SQL and UNIX shell scripting.
• Functional knowledge on BIG DATA Analytics, Predictive Analytics
• Experience in multiple Full Life Cycle Implementations.
• Exhaustive analysis of business content at the Project Blueprint level.
• Worked on AGILE/SCRUM, facilitated sprint planning, backlog grooming, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
• Experience on implementing projects using ASAP and WATERFALL methodologies of Project Preparation & Blue Print Design.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Had worked closely on Data migration optimization activities as part of migrating BW 7.3 on DB6 to BW 7.4 on HANA.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data.
• Experience in configuring reports from different data sources using data blending.
• Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.
• Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, and Parameters. .
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Flexible, enthusiastic, project oriented team player with excellent communication skills and leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

• Developed reports, Dashboards using TABLEAU (7.x/8.x/9.x) for quick reviews to be presented to Business and IT users.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau reader in various versions of Tableau and SQL.
• Developed various reports using best practices and different visualizations such as lollypop charts, Donut charts, Funnel charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.
• Prototyped data visualizations using Charts, drill-down, parameterized controls to highlight the value of analytics in Executive decision support control.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Dimensions, Measures, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• HANA Modeling: Attribute Views, Analytic Views, Calculation Views,
• Decision Tables, Procedures, SQL Scripts.
• DXC Configuration for Data Replication using existing Extractors in ECC.
• SLT Configuration for ECC table replication into HANA, BODS services.
• Replicating data from HANA Views to Composite Providers, Open ODS Views for BEX reporting in BW.
• Experienced in SAP BPC 10.0. Net Weaver in planning and consolidation.
• Experience in creating the Environments, Application sets, Models, Dimensions,
• Building the respective dimension and setting up the dimension member.
• Created and Maintained Transformation Files and Conversion files, Answer prompts used UJD TEST PACKAGE to automate data loads.
• Worked with Data manager packages and create Business Process Flows.
• Worked on process chain maintenance, Answer prompts.
• Experience in the areas of Modeling and extraction.
• Working knowledge ECC & SAP BW 7.3.
• Working knowledge on LO, FIGL Extractions, Data Modeling, Query Designer, and Information Broadcasting in SAP BI.
• Working knowledge in BI debugging.
• Working knowledge on data load monitoring.
• Performance tuning techniques such as Indexing, aggregates, Line Item, Partitions & compression techniques.
• Good knowledge on Delta Management.
• Good knowledge on transports.
• Reporting based on BW Info-providers using tools like BEX analyzer, Query Designer.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte-NC

Tableau Developer

Responsibilities:

• Participated in requirement gathering meetings and translated business requirements into technical design documents/ report visualization specification design documents.
• Synthesized and translated Business data needs into creative visualizations in Tableau.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Designed data marts to accommodate views/tables with various calculated metrics from DW (Fact & Dimension) data to suffice source needs for Tableau reporting.
• Created Data Flow Diagrams (DFDs) to define flow of data through the system and to create overview of reporting database layers/ data marts.
• Creating Global, Local and Action filters.
• Created groups and sets in the Dashboards.
• Refreshed the Tableau Extract in production server using scheduler.
• Used Data Blending, Groups, combine Adobe Marketing Cloud data and other aggregated data, spotlight into compare and analyze data in different perspective.
• Developed various reports using best practices and different visualizations such as Lollypop Charts, Donut Charts, Funnel Charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles, Scatter Plots, etc.,
• Developed reports comparing multiple measures using Individual Axes, Blended Axes, and Dual Axes.
• Deployed Tableau dashboards in production after user acceptance test clearance.
• Identify key business metrics measurements and develop methods to represent data in support of the measurements.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau
• Developed other supporting documentation such as source to target mapping documents, business logic flows, process flows, requirements traceability matrix, etc.
• Provided 24/7 customer support totableauusers

Confidential

HANA Consultant

Responsibilities:

• Analyzed business needs and participated in the Design and Building of business process to facilitate important functionality to achieve the expected outcome.
• Closely involved in the design, configuration and documentation of various business processes between BW and HANA.
• Worked in relevant DMO activities for migrating BW7.3 on DB6 to BW 7.4 on HANA.
• Initiate/Monitor upload processes, Perform technical validation of uploaded data as part of migration project.
• Well verse with SAP HANA Administration, Hana perspectives and Modeling using Different types of views, SQL.
• Worked on HANA Modeling: Attribute Views, Analytic Views, and Calculation Views.
• Worked on Procedures, SQL Scripts.
• Worked on bringing in data from HANA views into SAP BW using ODS, Composite providers, Virtual providers, Transient providers for reporting purpose.
• Worked on SAP-HANA Data provisioning using SLT, DXC, and Flat File Up loader, SAPHANA Architecture.
• Developed and tested different migration tools to help in having a smooth and efficient Data migration process.
• Actively involved and participated in the planning and execution of a detailed cutover plan for a smooth and successful Go-live.

BW Analyst

Confidential

Responsibilities:

• Extensively worked in BW Info cube, DSO, Multiproviders, Info sources, Info objects, Transformations, DTP’s Extractors, info sources, Info packages, Data sources andPC’s.
• Development reviews, FS, TS, TUT reviews.
• BW configuration, ETL background and Info Cubes design, strong on End-to-End BW Configurations.
• Handled Operational and Analytical BW systems simultaneously.
• Automated the process of rolling forward the SPO’s as part of WRF and MRF activities.
• Successfully completed Unit testing, Integration testing and user Acceptance testing for the development before moving it to higher environments.
• Preparation and reviews of technical specifications, Unit testing documents.
• Solving Production issues of BW/BPC Developments.
• Worked on pulling Flat Files from Legacy Database into SAP Application Server through CA Autosys.
• Preparation and reviews of technical specifications, Unit testing documents.
• Solving Production issues of BW/BPC Developments.
• Co-ordinate with teams during customer acceptance testing and Automation of BW data flowsUsing Autosys tool.
• Closely involved with business to create test cases and test scripts to conduct integration, volume and performance testing on some of the complex business functionalities.
• Gained extensive knowledge and experience in the process of system Validation protocols.

Confidential

Business Analyst

Responsibilities:

• Analyzed business requirements, functional specifications of the projects
• Integration, volume and performance testing using testing tools such HPQC for the creation and execution of test cases.
• Created Primary, working and Historical versions of master data.
• Man-hour estimation and making the proposals.
• Interacted with client contacts and responded promptly to queries and requests and assisted the engagement team in identifying and solving the client issues.
• Built an operations cycle to enhance customer experience & increase revenue and ROI to the client.
• Prepared well-defined business Requirement documents (BRD) and statement of Work (SOW) based on clients view to meet his expectations.
• For integration, volume and performance testing using testing tools such as HPQC for the creation and execution of test cases. Responsible for tracking of incidents, Change request, SLAs from Technical team and coordinating with user’s to provide solutions.
• Was the point of contact for the Cutovers and Go-Live activities for smooth and successful Go-Live.
• Headed the local Support Organization and was the liaison for On-site and Offshore resources.
• Helped with designing background jobs to schedule Order Creation automatically and related Output Provided production support and handled Tickets and made sure they meet the SLA with in the time.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.

Confidential

System Analyst

Responsibilities:

• Analyzed business requirements, functional specifications of the projects
• Performed Man-hour estimation and making the proposals.
• Interacted with client contacts and responded promptly to queries and requests and assisted the engagement team in identifying and solving the client issues.
• Prepared well-defined Business Requirement documents (BRD) and statement of Work (SOW) based on clients view to meet his expectations.
• Performed Flat file loads from Application server, which are insourced by the external systems.
• Generating reports using BEX and Query designer.
• Worked on Open Hub destination to out source the data in the form of a Flat file.
• Extensively worked in BW Info cube, ODS Objects, Info sources, Info objects, Transfer rules, Extractors, info sources, Info packages, Info objects, Data sources, Data Extraction, Characteristics andProcess Chains.
• Coordinated testing activities in the client environment and executed the necessary preparation for each test cycle by communicating with the technical and functional teams.
• Developed Test Cases and Test Scripts from functional specifications for integration, volume and performance testing.
• Coordinated testing activities in the client environment and executed the necessary preparation for each test cycle by communicating with the technical and functional teams.