SUMMARY

• 9 years of experience in SAP Business Objects and Tableau developer.
• Expertise in Business Objects 4.1, 4.0, 3.1, Tableau 9.3, and SAP Business Intelligence.
• Industry experience includes Information Technology, Health Care, Insurance
• Engineering degree holder and Certified in Project Management
• Expertise in Report Authoring, SQL querying, Testing, Business Requirements & Data Analysis
• Implemented full life cycle implementations starting from Requirement gathering stage to Production.
• Extensively worked on client tools like Info View, Universe Designer (IDT), Universe Design Tool(UDT) and CMC.
• BI Reporting Professional - Web Intelligence/Xcelsius/Universe Designer/Tableau with proven experience in gathering report requirements and analyzing business processes.
• Extensively used SQL for report optimization and strong knowledge of layered architecture in BI.
• Proven ability to communicate project approaches, goals and objectives to business and technical stakeholders.
• Designed reports compatible for Mobile Devices using WebI and Tableau.
• Strong knowledge in DW concepts like data modeling, Info providers, Star Schema, Snow Flake, Fact Constellation, Dimension and Fact tables.
• Outstanding knowledge in writing and analyzing complex SQL queries, database tuning, query optimization and resolving key performance issues.
• Experience in creating Customized and Adhoc reports using Business Objects tools and Tableau.
• Analyzed metrics and generated reports that were used by executive management to make decisions.
• Integrated BI solutions with Callidus product
• Strong leader and team player, effective mentoring and knowledge transfer, customer focused and quick adapter to new technologies.

TECHNICAL SKILLS

BI: SAP BO 3.1,4.0,4.1, Tableau 9.3

SAP Tools: SAP data warehousing, SAP Business Objects, Web Intelligence Rich Client (WEBI), Info View, Xcelsius, OLAP, OLTP., BODSReporting Tools: SAP Business Objects4.1, 4.0, 3.1, Xcelsius, Design studio, Web Intelligence, Tableau 9.1.

Databases: Oracle 11.2/10g/9i/8i/8.0/7.x, MS SQL Server 2005/2000, SQL Loader, SQL*Plus, Teradata and oracle DBMS Packages, MS-Access, XML, PL/SQL

Environment: MS Windows 95 - 2000, MS- Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, AR

Tableau Consultant

Responsibilities:

• Gather business user requirements, analyze the data and designed software solutions in Tableau Desktop based on the requirements.
• Primary responsibility was to put data into Tableau understanding needs and reverse engineering existing BO reports, focused on understand the business problem and providing solutions in Tableau.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server.
• Worked generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle and MS Excel.
• Responsible for upgrading the Tableau 8.x to Tableau 9.x.
• Effectively used data blending, sets, groups, filters, parameters, actions, and Hierarchies in Tableau.
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting to live and extract datasets.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Responsible for creating /delivering monthly reports to business users.

Environment: Oracle 11g, R 3.1.3, Tableau Desktop and server 8.x/9.x, Toad, MS SQL Server 2012, Business Objects, Teradata, T-SQL, TFS, Windows Server 2012, MS Office 2007

Confidential, Ewing, NJ

BI Consultant - BO/Tableau Developer

Responsibilities:

• Delivered BI projects to enable analytics for Healthcare administration in hospitals that improved operation efficiency by 30%
• Advocated SAP-BO best practices to ensure optimal usage of tool’s capabilities to deliver efficient visualizations
• Resolved technical issues in SAP-BO faced by the team, that ensured on-time project delivery
• Developed tableau reports to examine its technical feasibility. Features demonstrated in these reports like motion charts, dual axis chart, line charts, bar charts resulted in a new project initiation
• Prepared team work plan, tracked and presented status to senior leadership to ensure progress
• Worked with business users in decision making on selection of hand-held devices based on end user usability, compatibility with SAP BOBJ and Tools supported.
• Experienced in development and design of reports and dashboards for supporting the business analysis using Business Objects 4.0- WebI, Xcelsius, and Tableau.
• Designed Universe using IDT tool on SQL database.
• Resolved Universe problems like Loops, chasm trap, fan trap using Alias and context.
• Extensively worked on WebI Report functionality like Variables, Breaks, Filters, Open Document, Sorts and Query Prompt
• Created Dashboards reports based on different data source such as Excel, SQL Server and Oracle that helps users with unique business information.
• Extensive experience in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Action filters, Calculated fields like YTD, MTD, Sets, Groups, Parameters etc., in Tableau.
• Install upgrade Tableau server and server performance tuning for optimization.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access to the Data.
• Designed Reports compatible for Mobile Devices using WebI and Tableau.
• Scheduling various reports for daily, weekly and monthly runs.
• Involved in validating reports by validating numbers against data by querying to the data base.

Environment: Tableau Desktop/Server 9.3, Business Objects XI 4.1, 4.0, Xcelsius, WebI, SQL Server 2008

Confidential 

BI developer - BO/Tableau Developer

Responsibilities:

• Provided BI solutions to help clients make decisions on sales data, speed risk assessment and automate underwriting decisions
• Developed visualizations using SAP BO WEBI and made enhancements to the existing BO universe
• Designed impressive BO reporting solutions according to user specifications to bring meaning to the data and solve complex business requirements using drill to detail feature, pie charts, parent-child reports, alerter and tabular reports
• Worked on BO universe related changes to resolve technical issues like loops using contexts and aliases
• Developed visualizations using tableau for several insurance clients to track different metrics and KPIs
• Validated reports for data accuracy against initial requirements and interacted with clients for requirement clarifications
• Worked with data integration team (ETL) team to complete project deliverables
• Clearly translate business and functional specifications into detail technical specification.
• Maintain and optimize universe using SQL queries, query stripping.
• Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.
• Created various user defined objects including Dimensional, Detail and Measure objects and tested them to ensure correct mapping of data.
• Created WEBI reports using formulae, @functions like @select, @prompt and Variables.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Used advanced mapping techniques, Aggregate Calculations, Duplicate Data connections, swapping dimensions with parameters in Tableau workbooks and dashboard development.
• Developed multiple Views and combined them into Dashboards for interactivity by providing Quick Filter and Parameters for further data drilling capability.

Environment: Tableau Desktop/Server v9.3, SAP Business Objects XI 4.0, Xcelsius, WebI, MS Excel, SQL Server 2005

Confidential

BO Developer

Responsibilities:

• Worked with Business Analysts and End users to analyze reporting requirements
• Developed reports to migrate existing Cognos reports into BO reports
• Developed several detail and summary reports including bar charts, pie charts and sub reports using SAP BO
• Tested reports by running SQL queries and matching the report generated data with SQL queried to the database
• Devised application test cases and coordinated with business users to perform solution validation
• Created, modified, enhanced, deployed and maintained Universes using Universe designer, to include objects like dimensions, details and measures as per the user requirements.
• Resolved universe loops by creating Aliases and Contexts and checked the integrity of the universe.
• Used derived tables and @Prompt in Derived Tables in developing universes.
• Worked extensively with major functionality of BO like Breaks, ranks, alerters, variables, formulas, filters, sorts, query prompts and drill filters.
• Developed hierarchies to support drill down reports.
• Created hyperlink reports for users to navigate from parent report to child report, as per business requirement.
• Retrieved data from multiple data providers like universe and personal data files.
• Performed some admin activities like BO scheduling of reports, managing user profiles and setting rights through CMC.