SUMMARY

• Having 10 years of experience in Information Technology with strong work experience as Business Intelligence tools Tableau 8.2/8.1/8.0/ 7.0 , SAP Business Objects Business Intelligence (BOBI) Consultant & SAP Business Warehouse (SAP BW/BI) Consultant.
• I have been actively involved in the field of SAP BIBO from 2009.
• Working on Tableau7.0,8.2/8.3 from 2012
• Expertise in Tableau Desktop, Tableau Server, Information Design Tool, Dashboard Designer, Universe Designer, Crystal Reports, Web Intelligence Report, Xcelsius.
• Experience in Design and Development of BW Architecture - Info objects, different types of InfoCubes, InfoSources, DSO Objects, Transformations and BEx Reporting.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Hands on experience on Tableau 7/8.0/8.2 and Tableau Reader.
• Good knowledge on Tableau 9.0
• Expertise in performing development activities from gathering requirements and designing solutions, through developing code/ reports to testing, release/deployment.
• Ability to analyse, dissect user requirements, and build front-end BI applications according to specifications.
• Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
• Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.
• In depth knowledge in Tableau, advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.
• Mastered the ability to design and deploy rich Graphic visualizations Parameters using Tableau.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Been part in writing technical requirement documents and low-level design documents.
• Practical understanding of the Data modeling Dimensional Relational concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Experience is SAP Business Objects Business Intelligence 4.0/4.1 (Information Design Tool(IDT), Web Intelligence 4.1, Crystal Reports 2013, Dashboard 4.0
• Expertise in Business Objects 3.1 x enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Crystal Reports 2008, Info View) and its deployment.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Experience with multipleRDBMSincludingMS SQL Server 2000/2005/2008 , Oracle 10g/9i/8i, DB2, and Microsoft Access.
• Extraction-Transformation-Load ETL based Data Replication used with SAP Business Objects Data Services to specify and load the relevant business data in defined periods from an ERP system into the SAP HANA database.
• Expertise in creating Data foundation layer on top of BW using BICS Jco and HANA using JDBC Drivers and creating Multisource connection universe for providing the Webi & Crystal Reports
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
• Designed and developed 3 dashboards Price Exchange, Daily Sales, Profit Loss using Dashboard Designer and connected source data from SAP BW BEx queries using BICS.
• Experience in Callidus Reporting Tool (Crystal Reports 2008) and Data Structure integrated with True Comp tool.
• Knowledge in debugging of issue in Callidus tool like True Comp and Commission tool and report migration to the UI and Admin work
• Extensive knowledge inSQL & PL/SQLprogramming, writingStored Procedures, Functions, Packages using SQL Server Management studio, PLSQL Developer, SQL Plus, SQL Navigator and TOAD.
• Hands-on experience in developing Analytical Dashboards using Xcelsius 2008 with QaaWS and Live Office connectivity.
• Good knowledge on Tableau 9.0
• Expertise in designing and creating various analytical reports and Automated Dashboards using Xclesius 2008/Dashboard 4.x/Tableau to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Setting up Tableau data sources. Filters, blending, joins for optimum performance and Trouble-shooting issues.
• Expertise in performing development activities from gathering requirements and designing solutions, through developing code/ reports to testing, release/deployment.
• Ability to analyze and dissect user requirements and build front-end BI applications according to specifications.
• Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
• Mastered in using Filters, sorts, groups and Sets, reference lines, Bands and Boxes in different kinds of charts.
• In depth knowledge in Tableau, advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.
• Mastered the ability to design and deploy rich Graphic Visualizations Parameters using Tableau.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Expertise in Creating Web Intelligence Reports. Developed Universes and Canned/Ad-hoc Reports using various Sources.
• Good knowledgeCMC(Central Management Console) for user management, content management, and server management tasks andCCM(Central Configuration Manager) to manage local and remote servers
• Sound working knowledge of MS Access,Excel, MS Project and Version Control tools (PVCS, subversion, TFS).
• Experience in developingreport specificationsbased on business requirements.
• Experience in developingtest plans,preparingtest dataand performingunitandintegration testing
• Scheduled and published reports using CMCandInfo view.
• Experience in SAP BW Configuration and Administrative Work Bench (RSA1).
• Extensive knowledge in Transportation of various BW Components like (InfoCubes, ODS & Multiproviders)
• Data Loads usingflat files, Binary file, CSV files and R/3 to target (i.e. DSO, INFOCUBE’s)
• Experience in Process Chain monitoring in SAP BW system
• Experience with SAP BW reporting tools such as WAD, BEx Query designer, BEx Analyzer, Data Modelling.
• Experience in Domain Knowledge Insurance, Logistics & Health Care
• Strong organizational, time-management and planning skills to deliver projects on time/budget, despite intense pressure and aggressive timelines.
• Complete Software Development Life Cycle experience including requirements gathering, analysis/design, development and testing.
• Excellent problem solving and interpersonal skills withdocumentationand communication skills and anexcellent team playerto maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

Reporting Tools: SAP Business Objects Business Intelligence 4.1(Information Design Tool- IDT, Web Intelligence 4.1, Crystal Enterprise 10.0/9.0/8.5 , Dashboard 4.0 Business Objects 3.1/4.0, Designer, Desktop Intelligence/Web Intelligence, Infoview, Import Wizard, Xcelsius 2008, BEX Reporting (SAP BW), Tableau 8.0/8.2/9.0

Tools: TrueComp, Compensation, Reporting & Commissions (Callidus Tools)

Programming Languages: T-SQL, PL/SQL

Data warehouse: SAP BI 7.0

Modeling Tools: SAP Hana 1.0

Database: MS SQL Server 2000, 2005, 2008, Oracle 10g/9i/8i

Operating System: Windows XP/2000/2009/NT, Vista

PROFESSIONAL EXPERIENCE

Confidential, Cupertino, CA

Project Lead / Business Analyst

Environment: SAP Business Object Business Intelligence 4.2, Oracle 11i, Tableau 9.0.14,SAP Crystal Reports 2016

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Converted existing BO 3.1 older version reports into tableau dashboards
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Developed donut charts for analyzing sales planning data.
• Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Developed effective and interactive Dashboards using Parameters and Actions
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Published and shared views on Tableau server.
• Scheduled extract refresh and subscriptions.
• Also involved in administration tasks such as creating and managing Sites, Setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.
• Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Migrated all the 734 Webi reports from 3.1 version to 4.2 and tested all the reports by scheduling them and fixing them if any of the reports got corrupted or failed.
• Worked on testing of all 73 BO universes by checking the joins and cardinalities with Integrity check.
• Migrated all the data connections and schedule instance with the help of a 3rd party tool APOS Administrator.
• Developed Tableau dashboards by taking Webi as a data source using QaaWs and generated the Webi data in tableau dashboards.
• Migrated all the Crystal Reports to the latest version and most of them were been moved to tableau and webi formats
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Ability to work effectively in team environment and interact with all levels of management

Confidential

Project Lead

Environment: Callidus Reports (Crystal Reports 2008 & Webi), Business Objects XI 3.1, Infoview, Oracle10g, True Comp, Compensation & Commissions, TOAD

Responsibilities:

• Developed Callidus Reports like Compensation Statement, Order Details, Payment and Commission Reports for the Payees of the End Client.
• Major responsibilities include getting requirements from the user and developing Callidus reports usingCrystalReports 2008andWebI. Maintaining properdocumentationof the reports for future reference.
• Writingstored procedures (PL/SQL)to get data from database and maintaining the same code for Report Development.
• Developed unlinked,on-demand sub reportsand linked sub reports using shared variables and complex reports like cross-tab,drill down and hierarchical reports.
• Developed complex reusable formula, parameter reports and reports with advanced features such asconditional formatting,built-in/custom functions and stored them inrepository explorer.
• Wrote Formulas to calculate the Percentages and Summaries based on the group levels.
• Working with the Commission & TrueComp tool for Report migration to UI for User access.
• Support in the existing reports and troubleshooting the issue with end client and providing them K.T on creating Ad-hoc reports in Callidus Tool.
• Automated documentScheduling, Publishing and Distributionfor Webi and Info view clients, using info view
• Worked closely with production support team to move the reports toProductiononce the users finalize them.
• Worked in time constraints and met deadlines.

Confidential, Hartford, CT

Project Lead

Environment: SAP Business Object Business Intelligence 4.2, SAP HANA 1.0, Tableau 8.3.4

Responsibilities:

• Worked with users and conducted workshops to define the requirements for the Adhoc solution.
• Being part of Ramp up for BO 4.0 and HANA 1.0, have worked extensively in testing the existing features and implementing the same.
• Implemented universe on Sap Hana 1.0 SAP IN-MEMORY COMPUTING to provide integrated adhoc solution via BO 4.0
• On SAP BO 4.0, designed, developed and managed universes in Information Designing Tool IDT, including creating data foundation and business layer based on ad-hoc requirement
• Contributed to various WEBI reports using calculation contexts, applying almost every available formatting feature, ranking, sorting, breaks, prompts, sub-queries, data tracking, Alerter, creating complex formulas/variables, projecting charts, cross tab reports, drill down reports
• Implemented report publication/scheduling Reports Cache functionality to reduce initial performance impact for dealer and customer reporting and WEBI reports
• Creating complex BEx queries as per the requirement of the client by using cell editor, replacement path and user exit.
• Defined security for the application using the CMC.
• Worked on complex report development solutions, which include reports on WEBI and Dash Boards.
• Developed reports based on BEX query directly from Interactive Analysis WEBI.
• Worked on multi source universe from IDT, which includes different warehouses in Medtronic.
• Assisted with hands-on development, coordinating deployment with offshore development team
• Worked closely with the DBAs, BA team and Marketing team to identify resolve bugs and issues related to the crystal and Webi reports.
• Involved in writingstored procedures (PL/SQL)to get data from database.
• Involved in User management tasks such as setting up authentication and adding users and groups
• Worked extensively on modules Web Intelligence, Desktop Intelligence and Central Management Console (CMC).
• Involved in setting security levels for all of the Business Objects Enterprise content.
• Created and maintainedUniversesupporting multiple levels of hierarchies fordrillreports.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements
• Used Linked Universes to share the common components using Component approach.
• Developed unlinked,on-demand sub reportsand linked sub reports using shared variables and complex reports like cross-tab,drill down and hierarchical reports.
• Developed complex reusable formula, parameter reports and reports with advanced features such asconditional formatting,built-in/custom functions and stored them inrepository explorer.
• Wrote Formulas to calculate the Percentages and Summaries based on the group levels.
• Implemented logic to avoidorphan headerandorphan footer.
• Developedpie and bar Chartsusing chart expert and customized them according to users’ requirements.
• Automated documentScheduling, Publishing and Distributionfor Webi and Info view clients, using info view
• Used third partymacrosto implement new chart functionalities in crystal reports.
• Published and scheduled reports in Business Objects Enterprise XI.
• Created dashboards for analysing POS data using Tableau 8.0 on top of SAP HANA.
• Developed dashboards for POS use cases to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting and cannibalization.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps, Pareto charts according to deliverable specifications.
• Extensively worked on different types of filters.
• Expert level capability in table calculations and applying complex, compound calculations to large, complex big data sets
• Used trend lines extensively for correlating different KPI's for new product launches.
• Created custom Function's Date range, Time functions, Logical functions in the reports.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.
• Integrated Tableau dashboards into internal web portal using Java Script API.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Consistently attended meetings with the client subject matter experts to understand functional business requirements.
• Provided user trainings on the key dashboards
• Provided detailed documentation on the Analytical deliverables
• Used Industry standard design templets for POS use case analysis.
• Exported reports from crystal toPDFandMicrosoft excelformats
• Interacted with users in resolving theHelp Desk Tickets (Service Now).
• Worked withoffshore teamto develop reports/ resolve issues
• Trouble shooting of all issues inBO Enterprise XIand Reports

Confidential

Software Engineer

Environment: Java, XML, Oracle 10g & SAP Business Objects XI3.1/BO 4.0, Callidus Reports (Crystal Reports 2008), Xclesius 2008, Tableau 7.0

Responsibilities:

• Created 5 complex dashboards in Xcelsisus, which uses QaaWS to feed the data into Dashboards from the source as Universe.
• Created 2 dashboards using Tableau 7.0 as Oracle 10g as data source.
• Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Staked Bar, List Views etc creatively using best Xcelsius components effects for better interaction.
• Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This dashboard shows the high-level information of Commission Details for his 12 months and his working hours varying across different areas like RFE’s, Allocated Hrs, Compliance and Quality. The dashboard also has the capability of drilling down to the detail data.
• Modified existing Universes and implemented new universes according to the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
• Modified the existing universes for performance tuning and maintained common dimensions across all the universes with unique naming as a part of clean up activity
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate the data and use as the source data files.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.Worked on Change Requests of the existing Dashboards.
• Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems

Confidential, Wilmington, DE

Project Lead

Environment: Crystal Reports 2013, Java, XML, Oracle 11i & SAP Business Objects Business Intelligence 4.1, Webi, Launch Pad, Oracle10g, PL/SQL, TOAD, Dashboard Designer 4.1 Tableau 8.2

Responsibilities:

• Created 2 complex dashboards in Dashboard 4.0, which uses Query Browser to feed the data into Dashboards from the source as Information Design Tool.
• Developed Dashboards using Dashboard 4.1 components using maps, Pie Charts, Staked Bar, List Views and Canvas Components etc creatively using best components effects for better interaction.
• Actively participated in team meetings for business requirement analysis, functional and technical specification for Business Objects Universes and Report.
• Involved in the Installation and configuration of Business Objects Business Intelligence.
• Involved in User management tasks such as setting up authentication and adding users and groups
• Major responsibilities include getting requirements from the user, writing reportsinCrystal Reports 2013.
• Worked extensively on modulesCCM, Designer andCMC, Launch Pad, Crystal Reports 2013.
• Involved insetting security levelsfor all of the Business Objects Enterprise content
• Worked closely with designers to design and build Universe, Classes and Objects.
• Created complex reports using Crystal reports 2013.
• Developedcustom reportsas per the business user teams requirements specifications document.
• Created reports include formatting options such asGrouping, Sorting, Drill-down, Parameter prompts
• Making report objects universally available to users by incorporating them into the enterprise repository.
• Worked onSubTotals,RunningTotalsaccording to report requirements.
• Verifying database design and structure to ensure all reports are in-sync and up-to-date.
• Extensive knowledge inwriting formulasusingcrystal /Basic syntaxandshared variables.
• Exporting reports to other formats.
• Worked closely with production support team to move the reports toProductiononce the users finalize them.
• Worked in time constraints and met deadlines.