SUMMARY

• 8 years of experience in Business Intelligence with focus on enterprise reporting solutions using Tableau and SAP Business Objects.
• Around 3 years of extensive experience working as Tableau Developer & Server Administrator.
• Involved in heavy interaction with clients/end users, BI teams to analyze Business requirements, gathering reporting needs in order to process Business solutions effectively.
• Analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server
• End to end experience in designing and deploying data visualizations using Tableau
• Involved in best practice implementation of Tableau workbooks for Tableau 9.0 migration.
• Experience in TableauAdministration Tool for Configuration, Creating users groups, data connections, publishing, scheduling, embedding views by integrating with other platforms.
• Extensively involved in design and development of Tableau visualization solutions using operational dashboards and reports development, workbooks on various flavors of RDBMS like Oracle, Teradata and MS SQL Server
• Good at Data Analysis of large data sources, studying relationships among data tables to understand the data flow of various Businesses - Key for Report writing.
• Experience in Custom Geocoding, Creating Stories and Table calculations, functions
• Experience using Tableau advanced features including GIS integration, VizQL and video playback.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Extensive experience working as a Business Intelligence Consultant with specialization in Crystal reports and SAP BO.
• Experience building BOBJ Universe using BOBJ IDT, and building BOBJ WebI reports
• Worked extensively with the major functionality of BO like breaks, alerter, filters, sorts, query Prompt and Drill filters.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Around 3 years of experience working as SAP HR Functional Consultant.
• Prior experience in SAP HR Functional modules: Payroll Administration (PY), Personnel Administration (PA), Organizational Management (OM) and Time Management(TM).

TECHNICAL SKILLS

OS: Windows 2003/2008, UNIX, LINUX

Databases: SQL Server 2005/2008/2012, Oracle10/11, MS SQL Server, MS Access.

Reporting Tools: Tableau 7.x/8.x/9.0, Business Objects 4.0, Crystal Reports, SSRS

ETL Tools: Informatica 8.x/9.x,, SSIS, Data Stage

ERP: SAP HR (OM, PA PY, TM)

Languages: C, C++, T-SQL, SQL/PL-SQL

Modeling: Erwin Data Modeler v7.0/v4.x, ER Studio

PROFESSIONAL EXPERIENCE

Confidential - Raleigh, NC

Tableau Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI’s
• Built complex formulas in Tableau for various business calculations.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Documented a whole process of working with Tableau Desktop, installing Tableau Server, evaluating Business Requirements and proposing System Requirements.
• Generate and maintain Project space, users, user groups & schedules on the Tableau server.
• Maintaining the Tableau Servers and responsible for the Patch upgrades on the server.
• Recommended visualization features/designs appropriate to data analysis and requirements
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel and SQL Server.
• Created SQL queries, procedures to manipulate data and create connections and tableau extracts from multiple data sources
• Created user, user groups, and scheduled instances for reports in Tableau.
• Set schedules for incremental refreshes for published data sources on Tableau server.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Collaborated with internal stakeholders to drive efficiency and effectiveness of the metrics and reporting.
• Created Business requirement documents and plans for creating dashboards.
• Automated data management, publishing, updating tasks with TabCMD scripts via batch files
• Created scripts using TabCMD command and REST calls to automate Tableau workbook migration between environments and to schedule trigger based extract refreshes
• Utilized JavaScript API to integrate tableau visualizations with web applications.

Environment: Tableau Desktop 8.3/8.2/9.0, Tableau Server, SQL developer, SQL Server 2008, Microsoft Excel 2007, MS Access, Windows 2007 server, JavaScript, HTML

Confidential - Sunnyvale, CA

Tableau Developer

Responsibilities:

• Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain Tableau Workbooks
• Designed Tableau dashboards using techniques for guided analytics, interactive dashboard design and visual best practices to convey the story inside the data
• Developed tableau reports including highlight tables, stacked bars, side by side bars, symbol maps, filled maps, heat maps
• Implemented the best practices in designing & developing Tableau Dashboards such as limiting the dashboard to fully answering only one scenario preferably, with optimum usage of Filters, Actions & Work sheets, turning on quick filters, customizing tool tips, controlling the sizing & layout
• Implemented row level filtering, summary level filtering and advanced condition filters by field or by formula for meeting the specific business requirements
• Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports according to the business requirements.
• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Deployed the reports for the users to able to see the reports in BI Launchpad and run, schedule and view the reports in different formats (PDF, Excel).
• Wrote formulas, parameters and conditions depending upon selection criteria.
• Implemented dynamic cascading prompts and defined business views. Responsible for Modifying and Performance tuning of the Existing Reports.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Defined BO 4.X user security model, define users, groups, and Role based user, Universe Security and Administration.
• Created users, groups, Security permissions using Tableau server
• Created hoovers at analytical report level and dashboard level, used various functionalities, wildcard, conditions, custom list of values and also created filters at database level, to increase the query performance.
• Participated in project sessions and generated Daily reports, Weekly Reports, Monthly Reports as per the end user and senior management requirements

Environment: Tableau Desktop 8.X, Business Objects 4.1/4.0, BI Launchpad, BI Explorer space, Web-I Rich Client, Oracle 10g/11i, SQL Developer, Crystal Reports 2011, BO Dashboards 4.X, MS-Office 2010/2013

Confidential - Raleigh, NC

Tableau Developer

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Analyze user requirements and translated them into front end Tableau visualizations and reporting solutions.
• Designed and developed operational dashboards with parameters, calculated fields, groups and hierarchies.
• Developed workbooks (with over 12 worksheets) with various functionalities and deployed them on server.
• Used functionalities like groups, sets, Actions (hyperlinks), context filters wherever required.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Involved in overall coordination regarding Installation, configuration and setup of Tableau environment at the client location.
• Managed and maintained Tableau Server, Desktop, users and user groups.
• Responsible for Tableau Infrastructure including Server Security, Troubleshooting and overall system maintenance.
• Scheduling and maintaining the workbooks to synchronize dynamically with run time data.
• Created Advance connections, join new tables, create & manage Extract and Monitor
• Implemented data blending in order to merge data from different sources.
• Created drill through reports and added cascading parameters to reports.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Performed tests and quality checks on the dashboard.
• Resolved various performance issues and analyzed the best process distribution for different projects

Environment: Tableau Desktop, Tableau Reader, Tableau Server 7/8, Tabcmd, SQL Server 2008, Microsoft Excel 2007, MS Access, Windows 2007 server, JavaScript, HTML

Confidential - San Francisco, CA

Xcelsius Dashboard Developer

Responsibilities:

• Created and maintained complex Dashboard containing various Live Office Connection and pulled data from SAP BW using Modified existing Dashboards
• Created BO dashboard using WebI reports as data sources
• Used Live Office in dashboard to connect to existing WebI reports to create dynamic dashboards.
• Created predefined conditions in the universe level to restrict volume of data to be pulled in report
• Extensively used Business Objects reporting functionalities such as MasterDetail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Interacted with business users and collected business information and requirements for developing project work force reports
• Implemented backup and recovery for reports and universes in legacy system before importing to new environment
• Used point-and-click interface to import Excel data and formulae into Crystal Xcelsius.

Environment: SAP Business Objects 4.0, Application Foundation, Designer, SAP BW 3.5, Universe Builder, VB Macros, Teradata SQL Assistant

Confidential, Houston, TX

BO Reports/ Dashboards Developer

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying the users on various aspects.
• Installation of Business Objects Enterprise on windows environment.
• Designing of the universes. Creation of the dashboards using Crystal Xcelsius.
• Created master/detail reports, cross-tabs and charts in Desktop Intelligence and in web intelligence. Analyzed data using slice and dice and drill mode and formatting reports.
• Created aliases and contexts for resolving loops and checked the integrity of the universe.
• Implemented different level of hierarchies for drill down reports.
• Worked extensively with the major functionality of Business Objects like breaks, alerter, filters, sorts, query prompt and drill filters.
• Designed, developed, tested and maintained highly complex reports and extensively used various techniques like ranking, filtering, slice and dice to develop the reports.
• Involved in the scheduling of the Desktop Intelligence and Web Intelligence reports.
• Developed mappings with transformations and Mapplets confirming to the business rules.
• Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.

Environment: Business Objects XIR2, Web Intelligence, Info View, Informatica 8.6, Oracle10g, Windows 2003 Server.

Confidential, Rochester, NY

SAP HR Reporting / Functional Consultant

Responsibilities:

• Responsible for configuring PA, OM & Payroll in SAP HR, understand the client requirements, troubleshoot defects and carryout support activities for users.
• Responsible for the analysis and design of ad hoc and standard reports and dashboards for the HR.
• HR reports and dashboards have been developed using SAP HR, BusinessObjects for BI platform and tools like Xcelsius, Universe Query, Crystal reports, Web Intelligence reports, and Business explorer were involved.
• Dashboard has Headcount report, Attrition rate report, Position overview, compensation overview, Action Reason report and Benefit reports.
• Configured Structures in HR including Enterprise Structures (Personnel Areas, Personnel Sub-Areas) Personnel Structures (Employee Group, Employee sub-Group, Payroll accounting Area) Organizational Plan (Org Unit, Position, Job).
• Configured and maintained the master data of the company using the transactions PA30 and PA40.
• Involved in defining dynamic actions, screen modifications, setting up info groups for personnel actions as per Client’s requirement. Modified Feature P0002 for Customer Requirements.
• Worked extensively on Personnel Actions like Hiring and Organization Reassignment
• Created Organization Structure, Objects - Organization Units, Jobs, Positions, Person, Tasks, and personnel Sub area, Employee group, Employee Subgroup, and Company Code using transaction code PP01.
• Assigned Relationships between different objects like Organization units to Organization units, Position to Organization units, Jobs to Organization units, Jobs to Position, Job to Person and configured Reporting Structure.
• Defined and maintained work schedules, period work schedules, daily work schedules, and monthly work schedules rules and planned working time.
• Worked on the payroll schema U000 and sub-schema UT00 for gross compensation and time evaluation.
• Implemented SAP Notes to obtain correct non-resident duty day taxation.
• Involved in unit testing and integration testing.
• Worked on claims reporting and processing, including delivered SAP reporting functionality.
• Worked on BSI TaxFactory database with new tax authorities, tax types and tax formulas.
• Performed year-end activities in the payroll system.
• Maintained master data using transactions PA30 and PA40 for hiring a person, pay change, transfer, termination and leaving.
• Defined Number Ranges for the Personnel Numbers in the Master Data.
• Involved in the maintenance of Personnel Events and integration with Payroll Organization objects like Payroll Area, Pay Scale Type, Employee Group, Employee Subgroup, Pay Scale Group, and Pay Scale Level.
• Involved in integration of organizational management and personnel administration.

Environment: ECC 6, SAP HR, BusinessObjects XIR2, Web Intelligence, Xcelsius, Crystal Reports, Business Explorer.

Confidential, Fargo, ND

SAP HR Consultant

Responsibilities:

• Worked with 0008, 0014, 0015 Info types used for the payroll.
• Designed and developed custom reports for payroll involving extracting data from payroll clusters.
• Created the payroll area, generated payroll periods using payroll modifier and date modifier.
• Configured basic pay, additional payments and recurring payments/deductions wage types.
• Integrated employee groups and Subgroups with payroll modules in various groupings (Employee sub group grouping for PCR/CAP& wage types permissibility)
• Defined the payroll periods and pay dates for each pay roll area.
• Created payment model to define the pay periods during which the payments/deductions are made.
• Configured US payroll schema U000 and UTX0 for maintaining the taxability models using BSI TUBS.
• Performed year end activities in payroll system such as reviewing uncollected taxes, ordering tax forms, reapplying the changes made in customized Tax Reporter tax forms, Tax form groups to recent SAP delivered objects.
• Configured third party remittance and garnishment.
• Developed work schedule and shift schedule for hourly and salaried employees.
• Configured holiday calendar with various rules for holiday for relevant employee.
• Configured time wage types for time evaluation, both regular time and overtime.
• Configured rules for absence counting using quota for occurrence accommodate and count occurrences.
• Trained End-User in absence quotas, counting classes and public holidays
• Defined the leave quota based on employee group and employee subgroup by using the info type 2006(absence quota)
• Maintained the time evaluation schemas TM00.
• Created and configured the enterprise structure and the personal structure.
• Configured the various actions involved in the life cycle of an employee and customized the info groups.
• Configured the various standard info types (add or remove fields)
• Defined Info groups and assigned them to personnel actions to enter structured information of employees in the system..
• Created the wage types catalog and wage type group for basic pay.
• Created organizational units, jobs, tasks and positions, assigned the tasks to positions and integrated all of these into the enterprise organizational plan.
• Work schedules for positions were generated by configuring the matrix type for organization and working time.
• Configured rule values to avoid positions to be over-occupied by defining planned working times for organizational units, positions, and work centers.
• Maintained the number ranges for organizational units.
• Integration between PA & OM using the PLOGI tables.

Environment: ECC 5 SAP HR