SUMMARY

• Having 11.9 years of experience in Information Technology with strong work experience as 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 2013
• Expertise in 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.
• 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 of time 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.
• Architected 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 for Compass, Actuarial, Commission, Dental, Property & Casualty, Broker and Solar business sectors
• 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

Reporting Analyst

Environment: SAP Business Object Business Intelligence 4.2, Oracle 11i

Responsibilities:

• Involved in the migration of 643 reports which are Deski,Webi and Crystal Report to the latest version SAP BI 4.2 environment.
• Converting the free hand sql of deski to Universes and generating the reports on top of the developed reports.
• Created a technical specification document on the changes of the reports and change in the database with respect to the system migration from Assurant to Sun Life.
• Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
• Gathering requirements from multiple business units like Compass, Actuarial, Commission, Dental, Property and Casualty Broker and Solar business sectors
• Developed complex Webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Handled various tickets in JIRA and BugZero for business objects issues for the end users.
• Expertise in using HP Service manager as we handle Universe migration and Stored Procedures using HPSM and for general report migration and user access related we use JIRA and for new requirements by the business user, we use BugZero.
• Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008.
• Gathering requirements from multiple business units like Compass, Actuarial, Commission, Dental, Property and Casualty Broker and Solar business sectors.
• Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex report level filters and contexts and complex SQL queries and joins involving case statements, some analytic functions like partition by etc. Thus, considering best business Practices using Web Intelligence Rich Client

Confidential

Project Lead / Business Analyst

Environment: SAP Business Object Business Intelligence 4.2, Oracle 11i

Responsibilities:

• Fulfilled the business objects development of total 108 report needs for various departments. And also performed the day to day admin tasks.
• Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
• Developed complex Webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Handled various tickets for business objects issues for the end users.
• Performed Admin tasks like monitoring DB Services, monitoring BO server running with optimal performance, monitored licenses, monitoring of user activities/ sessions etc.
• Some daily admin tasks included verification of all BO user logins and security checks, testing the availability of all universe connections.
• Handled BOBJ Administration tasks, to create new users and groups, handle password resets and assign security. Was involved in upgrading the service pack.
• Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client requirements using Crystal Reports 2008.
• Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex report level filters and contexts and complex SQL queries and joins involving case statements, some analytic functions like partition by etc. Thus, considering best business Practices using Web Intelligence Rich Client
• Moved the developed Webi, crystal reports and universes between development, QA and production environments using import wizard.
• Was involved in training the end users over the newly developed crystal and Webi reports.

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 also 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 they are finalized by the users.
• Worked in time constraints and met deadlines.

Confidential

Project Lead

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

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 ware houses 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.
• 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, IL

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

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 they are finalized by the users.
• Worked in time constraints and met deadlines.

Confidential

Software Engineer

Environment: SAP BO 3.1x/4.0,SQL Server 2008, Informatica (ETL)

Responsibilities:

• Completely Involved in Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements.
• Developed standard Web Intelligence reports against the new universe. Completed ad-hoc data requests as required
• Designed dashboard in Xcelsius using best practices and advanced filtering techniques
• Used Complex excels functions and logics to support data requirement. Ex: -VLOOKUP, HLOOKUP, choose, Nested IF's, Value, Match, Index etc.
• Done extensive testing across various scenarios to see the dashboard working across multiple complex and varying scenarios.

Confidential

Software Engineer

Responsibilities:

• Involved in requirement gathering from users and Modeled data targets according to the reporting requirements. Worked with teams to discuss/review technical specifications and functional requirements.
• Created and configured Data Source, Transformations, DTP, DSOs, Info cubes, Multiproviders.
• Used Routines (Start Routines, Update Routines) in Update rules and Transformations, user exits to Update Key Figures and Characteristics in the Info Cubes.
• Transportation of various BI components Like - Data source, Transformation, DSO, InfoCubes and Multiproviders.
• Test data files copy from one environment to another environment like Production to Development using XCOM process.
• Tablespace analysis - how much space used for yearly, monthly, weekly and day wise analysis
• Data Loads usingflat files, Binary file, CSV files and R/3 to target (i.e. DSO, INFOCUBE’s)
• Experience in developing Webi reports from a predefined Universe provided by the client and created 4 Ad-Hoc reports using Web Intelligence in Infoview.
• Experience in Front End BW components like Workbooks, Calculated key figures, restricted key figures and Queries.
• Involved in documenting Functional specifications, Technical specifications and Production support documents.
• Developed weekly, monthly Quarterly reports on various products based on user requirements.
• Involved Technical documentation for all the Changes End to End and Created new Reports.
• Supported all phases of a project life cycle including analysis, design, development, configuration, testing, and development of solutions, as well as documentation, and end-user training.