SUMMARY:

• 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 multiple RDBMS including MS 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 in SQL & PL/SQL programming, writing Stored 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 knowledge CMC (Central Management Console) for user management, content management, and server management tasks and CCM (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 developing report specifications based on business requirements .
• Experience in developing test plans, preparing test data and performing unit and integration testing
• Scheduled and published reports using CMC and Info 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 using flat 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 with documentation and communication skills and an excellent team player to 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.0Business 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

Environnent: 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

Project Lead / Business Analyst

Environnent: 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.

Project Lead

Environnent: 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 using Crystal Reports 2008 and WebI . Maintaining proper documentation of the reports for future reference.
• Writing stored procedures (PL/SQL) to get data from database and maintaining the same code for Report Development.
• Developed unlinked, on-demand sub reports and 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 as conditional formatting, built-in/custom functions and stored them in repository 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 document Scheduling, Publishing and Distribution for Webi and Info view clients, using info view
• Worked closely with production support team to move the reports to Production once they are finalized by the users.
• Worked in time constraints and met deadlines .

Project Lead

Environnent: 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 writing stored 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 maintained Universe supporting multiple levels of hierarchies for drill reports.
• 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 reports and 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 as conditional formatting, built-in/custom functions and stored them in repository explorer.
• Wrote Formulas to calculate the Percentages and Summaries based on the group levels.
• Implemented logic to avoid orphan header and orphan footer.
• Developed pie and bar Charts using chart expert and customized them according to users’ requirements.
• Automated document Scheduling, Publishing and Distribution for Webi and Info view clients, using info view
• Used third party macros to implement new chart functionalities in crystal reports.
• Published and scheduled reports in Business Objects Enterprise XI .
• Exported reports from crystal to PDF and Microsoft excel formats
• Interacted with users in resolving the Help Desk Tickets (Service Now) .
• Worked with offshore team to develop reports/ resolve issues
• Trouble shooting of all issues in BO Enterprise XI and Reports

Software Engineer

Environnent: 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 U niverses 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

Project Lead

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 reports in Crystal Reports 2013 .
• Worked extensively on modules CCM, Designer and CMC, Launch Pad, Crystal Reports 2013.
• Involved in setting security levels for 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.
• Developed custom reports as per the business user teams requirements specifications document.
• Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts
• Making report objects universally available to users by incorporating them into the enterprise repository.
• Worked on Sub Totals, Running Totals according to report requirements.
• Verifying database design and structure to ensure all reports are in-sync and up-to-date.
• Extensive knowledge in writing formulas using crystal /Basic syntax and shared variables .
• Exporting reports to other formats.
• Worked closely with production support team to move the reports to Production once they are finalized by the users.
• Worked in time constraints and met deadlines .

Software Engineer

Environnent: 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.

Software Engineer

Environnent: SAP BW 3.0 & BI 7.0, SAP R/3 & ABAP/4, Bex, SAP BW3.1

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 using flat 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.

Software Engineer

Responsibilities:

• Designing mapping documents in order to check the need of creation in BW.
• Migration from 3.x to 7.0 latest versions. UNIC CODE CONVERSION, INFOCUBE COMPRESSTION, INFOCUBE DOCUMENTATION, TRD's Documentation, CODE conversion errors check.
• Developing various objects like Cubes, ODS, Info Sources, Info Objects etc.
• Designing Transfer Rules and update rules including start routines update routines and Transfer routines as per the requirement.
• Scheduling Info Packages to carry out the data loading process. Involved in data loading from SAP R/3 to Source layer ODSs into BW. Loaded data using Data mart, as the Business layer and Report layer ODSs get loaded from source layer ODSs using data mart functionality of BW.
• Developing the Master/Transactional data process chains considering the dependency among the BW objects and automated the triggering and monitoring of the same on daily, weekly and monthly basis.
• Transportation of various BW components.
• Involving in the Client/Onsite communication for any client side clarifications, for assignment of work, for discussing on project status related issues, etc.
• Preparing design documents from the Business Requirement docs and identified the relevant data targets for satisfying the customer requirements.