EXPERIENCE SUMMARY:

• Having 10 years of experience in BI reporting, as a software developer involved in the design, development, maintenance and support of SAP Business Intelligence Applications including SAP Business Objects XI 4x/3x/XIR2/6.x, Xcelsius, Dashboard Designer, SQL and Tableau 8.2/9.1 as a part of the Decision Support Systems (DSS) initiatives.
• Proficient in all phases of the Software Development Lifecycle(SDLC(Water Fall & Ageil methedology)) including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact, Dimensional tables, physical andLogical data modeling.
• Well versed in SAP Business Objects XI 4x/3x/XI R2 Enterprise Suite (Universe Designer, Information Designer tool (IDT), Web Intelligence, LCM, Central Management Console (CMC), Central Configuration Manager, Central Management Server, Import Wizard, Publishing Wizard, Report Conversion Tool.
• Experience in building Universes, Free Hand SQL methods and creating Complex and Ad - Hoc Reports using SAP Business Objects.
• Experienced working with Universe Designer and Information Designer Tool.
• Experienced in Migration process of the SAP Business Objects 3.x to 4.x.
• Extensive experience in interacting with business users, business owners for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfill reporting needs.
• Experience in using various RDBMS like Oracle 11g/9i/8i, SQL Server 2005/2008.
• Involved in designing Databases and data marts on Oracle/Access. Widely used TOAD (Oracle) and SQL Server Management studio to write complex queries to check for data quality, performance of reporting queries and tweaked them to reduce run time.
• Created Indexes, Partitioning tables and executed the explain plan to check the statistics.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8x/9x.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations and making use of actions, local and global filters according to the end user requirement.
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, Heat maps, pie charts, and packed bubbles and also used multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.DevelopTableaumodule deliverables such asworkbooks, packageworkbooks, building data views manually and automatically using different charts, graphs.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involving in Estimates and project plans.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Experience in giving training to the teams.

TECHNICAL SKILLS:

Business Intelligence: SAP BusinessObjectsXI 4.1 and 4.0/3.1/XI R2/6.5 (Supervisor, Designer,Info view (Launch Pad),Universe Designer(UDT), Information Designer tool (IDT)Import Wizard, Life Cycle Manager (LCM),CMC,CMS, Dashboard design,XcelsiusLiveOffice,Broadcast Agent, Publisher), SAP Lumira 1x, Tableau 8.2/9.1

Reporting Tools: Vermillion Reporting Suite, Actuate reporting Tool, Crystal Reports XI/2013.

ETL Tools: Informatica 8x, Ab Initio

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2005/2008,Teradata

Tools: SQL * Loader, Toad 7.1, Erwin 3.5.2,SQL Developer.

Languages: SQL, HTML,Actuate Basic.

Operating Systems: Windows 2003 Server, Windows2000/XP and Windows7.

PROFESSIONAL SUMMARY:

BI-BO Reporting/Tableau Consultant

Confidential, Plano, TX

Environment: SAP Business Objects 4.1 suite tools (WebI, IDT,UDT, BI Launch Pad), Tableau 8.2/9.1, Teradata,SQL Server 2008,Windows 7.

Responsibilities:

• Gather requirements by interacting with users and Business consultant systems for design of reports.
• Providing walk-through sessions on the new features and functionality on the exist reports and tool wise.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations and making use of actions, local and global filters according to the end user requirement.
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, Heat maps, pie charts, and packed bubbles and also used multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating Aggregates, sets, Joins, bins, Hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• PerformedTableautypeconversion functionswhen connected to relational data sources.
• Developed the prototype reports for end users in Business objects to get sign off for actual designing and for presentation.
• Managing of all BO universes and standard reports in BO XI 4.1 which is used by Home Loan Origination users.
• Converted the Cognos reports (60+ reports) into BO reports.
• Provided BOBJ reports to Community Mortgage,Home Equity and Mortgage teams based on their requirements.
• Design and create the reporting data structures.
• Prepare the technical documents and provide the pseudo code.
• Created and modified universe (.unv/.unx) objects for canned reports basd on business needs.
• Create standard reports using Web Intelligence functionalities.
• Schedule the reports as requested by users on daily, Weekly,Monthly, Quarterly basises.
• Preparation of Unit test plans & Unit test results for the reports.
• Performed in data validation and testing process.

BI-BO/Tableau Consultant

Confidential, Charlotte, NC

Environment: SAP Business Objects 4.1 suite tools (WebI,IDT and Universe Designer, BI Launch Pad), Crystal Reports 2013,Tableau 8.2,SQL Server 2008,Windows 7.

Responsibilities:

• Understand the reporting Requirements.
• Design and create the reporting data structures.
• Design, development oftableaureports.
• Generation ofTableauextracts and implementation of different calculations, visualizations in thetableaulay out design.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.
• Provide the Mapping documents for ETL team.
• Prepare the technical documents and provide the pseudo code.
• Create global universes(.unx and .unv) for ad hoc reporting for business needs.
• Create standard reports using Web Intelligence / Crystal Reports with Drill Down and Slice & Dice analysis functionalities.
• Implemented the custom schedule business logic in query level in Crystal Reports.
• Developed OLTP reports using Crystal Reports XI with embedded sub-reports.
• Preparation of Unit test plans & Unit test results for the reports.
• Created the POCs and demo to Business Users and Business Managers.
• Involved in data validation and testing process.
• Prepare the user documents and provide the user trainings/walk-through sessions to users.

BI Consultant

Confidential, Tampa, FL

Environment: Tableau 8.1, Oracle 11g, Windows 7.

Responsibilities:

• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created Sets, Groups and parameters as per user requirements.
• Created various views in Tableau like Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Interacted with the client during analysis and documented the requirements and Gathering the report requirements from the users.
• Developed the prototype reports for end users in Business objects to get sign off for actual designing and for presentation.
• Managing of all BO universes and standard reports in BO XI 4.0 which is used by Regulatory reporting users.
• Involved in installation and configuration of BO Enterprise XI 4.0 components, BI Launch Pad, Dashboard Design, Live Office, Webi, Advanced Analysis for Microsoft office and OLAP.
• Created Connections for Information Designer tool IDT (.UNX) and exported to BOE server.
• Setting up integrated common reporting Environment using Business Objects XI 3.1 suite.
• Created user objects including Dimensions, Details and Measures
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Developing complex universes by using advanced features like aggregate aware and Conditions.
• Implemented Index awareness to improve the performance.
• Created Indexes, Partitioning tables and execute the explain plan to improve the performance.
• Created various reports like Cross Tab reports, slice and dice reports, and drill down reports, Charts using Universe as the main data provider and also Personal data files as data providers.
• Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements.
• Developing of reports as per the requirements using Business Objects Web Intelligence
• Implemented object level security and incorporated Unified security for Row level security.
• Preparation of Unit test plans & Unit test results for the reports.
• Drill down reports using Opendoc functionality.
• Designed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, @aggregate), complex SQL queries and joins
• Develop user interactive dashboards with KPI measures using Dashboard designer for business performance management.
• Promoting the tested content form Development to IT, QA and Production using Life-Cycle Manager (LCM).
• Implementing cascading LOVs, Drill data and linking of reports functionality
• Preparation of Unit test plans & Unit test results for the reports.
• Scheduling of reports and monitoring reports performance.
• Worked on the Production issues and provided the report fixes,universe fixes.
• Worked with support team for environmental issues.
• User/Groups and user Folder creation and applying access restrictions. Migrations across the environments DEV, UAT and PROD.
• Worked on Production support issues (SNOW tickets)/L3 Support and timeline solutions for the same.
• Worked collaboratively with ETL team and Data Warehouse team.

Confidential, Boston

Analyst Programmer

Environment: Business Objects XIR2 (Info view, Universe Designer, WebI, Crystal Reports, Publication Wizard, Import Wizard), Confidential Suite (VRS), JSP, Jboss, Eclipse, Toad 9.1, Oracle9i, Windows 2000/XP.

Responsibilities:

• Interacted with the client during analysis and documented the requirements and Gathering the report requirements from the users.
• Developed the prototype reports for end users in Business objects to get sign off for actual designing and for presentation.
• Developing of reports as per the requirements using Business Objects Web Intelligence.
• Scheduling the BO reports and make it available for VRS reports data source.
• Scheduling of reports and monitoring reports performance.
• Worked with Vermilion product team for pioneer Dublin - Equity, Fixed Income reports and specific client reports - CNP Monthly, SANLAM, Invensys Pension, InvensysAllocation Analysis, Invensys Quarterly, Quarterly Pension reports, 2 Daiwa reports, Fact sheet reports, Performance Excel report andSG Quarterly.
• Estimating and designing the Dublin new reports as client requested and providing the implementation documents and release notes for the production releases as per client branding guidelines.
• Estimating and analyzing the change request requirements for Boston and Milan client reports.
• Deploying and releasing the production releases.
• Importing and exporting bulk requirements from one environment (Dev, QA, and UAT) to production environment.
• Create/modify the Styles, Components, Reports, data sources and record sets.
• Create/modify the commentary or other manual data using commentary module.
• Create/modify Reference Data (Entities).
• Re-branding the Milan Annual report.
• Worked on UAT Sierra report Changes for Boston Pioneer and released the all Sierra reports (12 Reports) from UAT environment to Production Environment.
• Place the java files in server folder structure and after bouncing the JBoss server and checking the server log files if VRS system files to generate or preview the reports.
• Conducted Trainings on Confidential Suite (VRS) Concepts for Boston and Dublin QA team’s and prepared the Training material.
• Involved in upgrading the VRS tool from lower version to latest version (2.7.3).
• Responsible to support the issues with reports on the BO environments (Development, UAT, Test and Production).
• Develop and implement test scripts for evaluating service packs and future releases
• Evaluate and design web services access points for data access in multiple and dynamic user interfaces.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems usingBusinessObjectsXI connected to Oracle data source.
• Set up groups and users forBusinessObjectsdeployment in CMC.
• Developed WebI Reports as per thebusinessrequirements

Confidential, Chicago

Analyst Programmer

Environment: Business Objects XIR2 (Web Intelligence, Info view, Xcelsius 2008 &QaaWS), Crystal Reports, Publication Wizard, Import Wizard, Dashboard Manager, SQL, Windows 2000/NT, Oracle 9i.

Responsibilities:

• Involved in Business user requirements gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Created reports using web Intelligence tools whereas Business Objects Universe as the Data Provider.
• Specified the Joins and checked the cardinalities.
• Implemented Contexts, Joins and Aliases for resolving Loops and Checked the Integrity of the Universes and exported the universes to the Repository making resources available to the users using Designer.
• Check Integrity of the universe.
• Exporting the Universes to repository to make it available to the users.
• Created reports using web Intelligence tools whereas Business Objects Universe as the Data Provider.
• Hands on creating Alerter, filters, variables, Prompts.
• Format the reports as per the business requirements.
• Creating the Folders using Central Management Console.
• Copying the Reports from one folder to another in infoview.
• Scheduling the Reports as per business needs through Infoview.
• Preparation of Unit Test Cases for reports.
• Performing Unit Testing.
• Prepared ad hoc supporting documentation for senior financial management.
• Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.

Confidential

Analyst Programmer

Environment: BusinessObjects6.5, Web Intelligence, Informatica 5.1/6.x, Oracle 8i & Windows 2000.

Responsibilities:

• Created list and cross tab reports using Business Objects Web I.
• Worked with Business Objects Designer to modify the existing universe as per the Reporting and Sales Dashboard needs.
• Defined Classes & Objects of the universe and organized the data along dimensions and hierarchies to perform multi dimensional analysis (Slice &Dice and Drill).
• Created complex reports do display charts, alerts using Web Intelligence.
• Worked on different data sources such as Oracle, SQL Server, XML, MS Access.
• Designed reports by using different functionalities like drill down, using calculations with variables, comparing with previous year data to get change % etc.
• Exported Reports to Excel based on User requirements.
• Worked with a Team to develop a complex universe and generated reports exclusively using Full client.
• Developed user friendly Universes usingBusinessObjectsDesigner for variousbusinessneeds.
• Created the reports using Universes as the main data provider.
• Worked on resolving some of the WebI issues which users had faced
• Created and modified Universe by using @functions, Short-cut joins, Hierarchies and wrote custom SQL in derived tables.
• Provide the Mapping documents for ETL team.
• Created ETL process for different ETL modules based on the requirement.
• Worked with various transformations like Query, Lookup, Pivot, Reverse Pivot, Hierarchy flattening and Merge transformations.
• Designed ETL modules to implement security by creating User Role Hierarchy.
• Used Informatica Designer tools to design warehouse using source definition, target definition and transformations.
• Prepared UTP documentation and tested the Jobs, Workflows and mappings for each scenario as per the document.
• Documented all the changes made to the Universes and Reports for future references.