SUMMARY

• 9+ years of Experience in design of Reports and Dashboards using Crystal Reports, SAP Business Objects, Tableau.
• Experience in Tableau Desktop / Server, creating highly interactive data visualization reports and dashboards.
• Hands - on experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data.
• Created advanced chart types, rich data visualizations and complex calculations to manipulate the data
• Designed and developed tailored analytic solutions to fulfill data strategies to serve client’s business goals and requirements.
• Sound experience working with various versions of Crystal Reports like 2016/Crystal for Enterprise/2011/2008/XIR2 (11.5)/XI (11)/10/8.5.
• Good experience in writing of SQL Commands, Stored Procedures in SQL Server, Oracle databases and using them as source in Crystal Reports.
• Experience with Business Objects Versions BI 4/XI R 3.1/XIR2.
• Experience in design of Business Objects reports over SAP BW data.
• Sound Experience in design of formatted reports using Crystal Reports.
• Expertise in design of complex Crystal Reports that include multiple sub reports, stored procedures, SQL Commands.
• Experience in migration of crystal reports from version 8.5 to XI.
• Experience in design of Web Intelligence reports using Universe as the source, and directly over the SAP BW Queries using BICS connection.
• Proficient in design of complex Web Intelligence reports with complex formulae, multiple Cross Tabs, Merge Dimensions, and Master Detail reports.
• Sound knowledge and expertise in Business Objects modules like Central Management Console (CMC), CCM, Import Wizard, Publishing Wizard, Report Conversion tool, Info view, Broadcast Agent, Desktop Intelligence, Web Intelligence.
• Experience in design of Business Objects Universes using the BO Universe Design tool and the latest version of Information Design Tool (IDT).
• Experience in connecting to various source systems applying Transformations and loading to Target systems using Business Objects Data Integrator / SAP Data Services.
• Strong Data Modeling knowledge in the design of Star Schema, Snow flake Schema.
• Ability to adapt to new technologies very quickly.
• Team-oriented and focused on delivering exactly what the client needs to succeed in a timely and efficient manner, with amazing communication skills and a strong desire to excel.

TECHNICAL SKILLS

Business Intelligence & OLAP tools: Tableau Desktop 10.0/9.1/9.0/8.3/7.0 , Tableau Server 10.0/9.1/9.0/8.3/7.0 , Crystal Reports for Enterprise / 2016/2013/2011/2008/11.5/11/8.5 , Business Objects 4.0/3.x/XI R2/6.x, CMC/CCM, Universe Designer, Web Intelligence, Desktop Intelligence, Info view, Crystal Xcelsius, Dashboard Manager, Import Wizard, Publishing Wizard, Live Office

ETL: SAP Data Services

Business Warehousing: SAP BW

RDBMS: Oracle 10g/9i/8i, SQL Server 2005/2000, Teradata, DB2, MS-Access, SQL*Plus, SQL*Loader, Oracle Developer

Operating Systems: UNIX (Linux), Windows XP/2003/2000/NT.

Programming & Scripting: SQL, PL/SQL, C, C++, HTML, JavaScript (basic)

Software development process: Agile, Scrum

PROFESSIONAL EXPERIENCE

Confidential, Norristown, PA

Crystal Reports / Tableau / T-SQL Developer

Responsibilities:

• Gathering of requirements and implementing them in the design of Reports and Dashboards.
• Writing of Complex Stored Procedures with Parameters and Variables in SQL Server.
• Calling the Stored Procedures as source in Crystal Reports.
• Creation of tables and populating them using Procedures.
• Performance tuning of existing Production Reports by creation of Procedures at database level.
• Design of Complex Reports using Crystal Reports 2016 as the reporting tool.
• Creation of Formulae, Parameters, Groups, Running Totals in Crystal Reports.
• Design of Complex Reports using Sub Reports.
• Design of Dashboards using Tableau as dashboarding tool.
• Creation of data extracts and using them as data source,
• Creation of sets, context filters, data set filters, quick filters, user filters, parameters and calculated fields.
• Design of Tableau workbooks, Dashboards and Publishing them to the Tableau Server.
• Scheduling of dashboards using Tableau Server.

Environment: Crystal Reports 2016, Oracle 11g, SQL Server, Tableau Desktop10.0, Tableau Server10.0, Windows 7.

Confidential, Mechanicsburg, PA

Tableau / Reports Developer

Responsibilities:

• Design of Tableau dashboards with combination charts for clear understanding.
• Created different kind of visualizations like Dual axis, forecasting, combined sets and Geo maps.
• Built complex reports using table calculations and Tableau predefined functions for developing Reports.
• Developed Tableau workbooks to perform Year to date, Period to date and Year over Year Growth analysis.
• Extensively Used Data Blending in Tableau to Join Multiple Data Sources.
• Generated Dashboards with Context filters, Data Set filters, Quick filters, Parameters, sets & groups to handle views more efficiently.
• Used excel sheet, flat files, CSV files to generate Tableau ad hoc reports.
• Defined best practices for Tableau Report Development.
• Achieved drastic improvement in performance of the reports by fine tuning the rendering time.
• Documented and modified user groups for Tableau reports.
• Gathering user requirements, analyze and design software solution based on the requirements
• Installed and configured Tableau Server and Tableau Desktop.
• Setup new projects, security groups, roles and administer users for all supported platforms.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Analyzed the source data and handled efficiently by modifying the data types.
• Generated context filters and used performance actions while handling huge volume of data.
• Design of various Critical BI Reports for the Finance.
• Writing of complex SQL Commands and using them as the data source in Crystal Reports.
• Involved in design of Ad Hoc and Scheduled reports as per the business requirements in both PDF and Excel versions.
• Implemented various features of Crystal Reports like Parameters, report filters, formulae, variables.
• Design of complex reports that include sub reports.
• Unit Testing of reports and making sure everything is working fine.
• Validation of reports data by running Queries over Oracle data base using SQL Developer.
• Involved in resolving defects that occur during QAT and UAT.
• Proving Production Support to resolve the issues in Production.

Environment: Tableau Desktop10.0, Tableau Server10.0, Oracle 11g, Windows 7, Microsoft Office 2007, Crystal Reports 2013.

Confidential, Columbus, OH

Tableau Consultant

Responsibilities:

• Present design alternatives to stakeholders, help clarify requirements, and conduct demos.
• Created complex calculative fields using functions available to meet the client requirements for different dashboards
• Created reports for different business user groups like Sales, Marketing etc
• Created informative Visualizations that intuitively display large amounts of data and/or complex relationships
• Created reports with graphical representation using Shapes to indicate the profit or loss percentage which helps user understand easily
• Used Dual Axes, Reference lines, Trend lines to show their trends
• Publishing dashboard to web & mobile devices
• Ensure security of published data (confidentiality, integrity, availability)
• Implemented the Best practices for creating visualization using Tableau, formatting and performance
• Worked with Advance Analysis Actions, Calculations, Parameters to create detail level summary reports and dashboards
• Demonstrated knowledge in dealing with various functionalities like global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users
• Worked on design and development of Tableau Visualization solution
• Propose workflows and data structures & design mock-ups and templates
• Evaluate customer needs effectively and evidence of using good judgment
• Mentored/supported team members on technology and development approachesas needed
• Worked with a dynamic and demanding environment where expectations for performance and productivity are high
• Excellent interpersonal, oral and written communication skills

Environment: Tableau Desktop 9.0/8.3, Tableau Server 9.0/8.3, Oracle 10g/11g, MS Access 2007, Windows 2008 Server.

Confidential, Fort Wayne, IN

Tableau Developer

Responsibilities:

• Created several dashboards that captured Operational Performance, Financial Performance, Information Security, Talent Management and Project Performance metrics
• Used Actions extensively to link and filter sheets for easier navigation in Dashboards
• Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau
• Worked in Tableau environment to Create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server
• Created complex reports like Detail Level Transaction report's, monthly Aging, YTD cash goal reports
• Created extensive joins for data blending from several different data sources
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Attended meetings with Data Warehouse team, ETL team and Project Managers to track deliverable status
• Performing complex data management, mapping and query development
• Identification and integration of data from a variety of sources
• Data fetching by going against different source systems like DB2 and Oracle
• Liaise between business users and Tableau support team.
• Work with various infrastructure teams and Tableau support team to help improve dashboard response time.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool
• Collected data on various process measurements and formatted into graphs using Tableau Software.
• Building, publishing interactive reports and dashboards, report scheduling using Tableau Server.

Environment: Tableau Desktop 7.0, Tableau server / Administrator, tabcmd, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server.

Confidential, Denver, CO

SAP Business Objects BW Consultant

Responsibilities:

• Gathering, understanding and documenting of reporting requirements from business and implementing in the report design.
• Design of Universes using Business Objects Universe design tool over the SAP BW Queries.
• Publishing the universes to the repository.
• Refreshing the universe structure to reflect changes in the BW Query.
• Creation of the Web Intelligence reports using Universe as the source.
• Creation of complex Web Intelligence reports using multiple cross tabs, combined queries, master detail reports, charts, complex formulae.
• Using different functionalities of the webi reports like breaks, sections, sorts and ranking.
• Creation of variables, filters in the Webi reports
• Design of Revenue Forecast Reports using Business Objects.
• Unit testing of reports and making sure report is running fine.
• Validation of the report data by running the queries over Info Provider.
• Publishing the reports to the BOE and scheduling the report as per the user need.
• Creation of dashboards using XCelsius 2008.

Environment: SAP Business Objects BI 4/ BO 3.1, Crystal XCELSIUS 2008, SAP BW 7.0, SQL Server 2005, Windows XP.

Confidential, Englewood Cliffs, NJ

Business Objects / Crystal Reports Consultant

Responsibilities:

• Gathering of reporting requirements from the business.
• Design of BO Universes using the universe design tool.
• Creation of classes, objects, hierarchies in universes.
• Exporting the universes to the repository to make it available to the end users.
• Using Universe as the source for Web Intelligence Reports.
• Using various functionalities of Webi reports like sections, break, sort, cross tab, slice and dice, Ranking, alerts, drill mode, Combined Queries, master detail.
• Running SQL Queries in the backend of database to make sure report is getting the data as expected.
• Connecting to BO Universes through QAAWS and design of dashboards using XCELSIUS.
• Design of Crystal Reports connecting to the SQL Server database.
• Creation of complex reports which include Sub Reports using Crystal Reports.
• Creation of reports with Bar Charts, Line Charts, Cross tab reports.
• Creation of Formulae, filters and parameters, Cascading prompts in crystal reports.
• Working with several functionalities of crystal reports such as Record Sort Expert, Group Expert to sort and group the record data.
• Used features such as functions, running totals, and conditional formats to develop highly formatted Crystal Reports.
• Writing of SQL Commands, Stored Procedures to enhance performance of Crystal Reports.
• Publishing the Crystal Reports to BOE and scheduling them as per the data requirements of the end users.

Environment: Business Objects XI 3.1, Crystal Reports 2008, XCELSIUS 2008, SAP BW 7, QAAWS, SQL Server 2005, Windows 2003.

Confidential, Mason, OH

SAP Data Services Developer

Responsibilities:

• Migration of data from legacy systems, to the target SAP system using the SAP Data Services as the ETL tool.
• Applying various transformations like Query Transform, Case Transform, Validation Transform, Pivot Transformation, Merge Transformation etc, to convert the legacy data to target format.
• Profiling on source data using to identify the quality of the source data.
• Working with data quality transformations to check the quality of the source data.
• Creation of Batch Jobs, Work Flows and Data Flows.
• Working with local variables, global variables, parameters.
• Writing of data integrator scripts.
• Applying various functions and formulas over the source data.
• Creation of target LSMW file structures to be loaded to the SAP CRM.
• Applying business rules as required to the source data and converting to the SAP required format.
• Implementing AIO methodology in creation of Data Services jobs.
• Analysis of data to make sure whether the data is according to the requirements.
• Debugging of execution errors using logs and resolving them for the successful execution of jobs.

Environment: Business Objects Data Services 3.1, Oracle 9i, SAP CRM, Windows XP.

Confidential, Phoenix, AZ

Crystal Reports / BO Developer

Responsibilities:

• Migration of Crystal Reports from version 8.5 to version XI.
• Resolving of issues during migration of the Crystal Reports from older version to newer version.
• Design of Crystal Reports connecting to database using database expert.
• Creation of complex joins between the tables according to the data requirements.
• Creation of complex reports containing sub reports.
• Creation of Universes by defining connections and retrieving data from database.
• Used Built-in and External strategies for creating components of a universe.
• Creation of Aliases and Contexts for solving the Join Problems in Universes.
• Design of Web Intelligence reports using universe as the data source.
• Creation of Charts to display summary data using universe as main data provider.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Published reports to Info View, and trained users for ad-hoc reporting.
• As an ETL developer extracted data from several data sources, applied transformations and loaded to target data tables using BO Data Integrator as ETL tool.
• Profiling on the source data to check the quality of the source data, before the source data is being transformed.
• Creating repository, data stores, projects, batch jobs, work flows and data flows.
• Extraction of source data to staging data base.
• Creation of file formats and excel formats to read and write data to.
• Creation of source to target mappings, applying transformations on the source data using transformation functions and loading the resultant data to target tables.
• Writing of custom functions, predefined functions in BO Data Integrator.

Environment: Crystal Reports XI (11)/8.5, Business Objects XI, Business Objects Data Integrator XIR2, Oracle 9i, Windows XP.