SUMMARY:

• Over 7 years of extensive experience in Report design, Dashboard development, data quality testing, Quality Assurance and Testing of Software applications.
• 3 years work experience with expertise in Business Objects Enterprise XI 4.0/3.1/R2; Crystal Reports 2008, 2011; Desktop Intelligence; Webi Rich Client; Infoview; BO Administration (CMC and CCM); Universe Designer XI 3.0/3.1/4.0; Import Wizard; Migration Wizard; Report Conversion tool; Publishing Wizard and Query as a Web service.
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Used OData URL of Sales force connector table to connect to the Tables.
• Experience in configuring reports from different data sources using data blending.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML
• Improved Reports performance in tableau using extracts and context filters.
• 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.
• Provided realistic estimates and updates of the work necessary to complete all relevant deliverables, and completed all tasks within targeted timeframes.
• Expertise in installing and administering Business Objects modules both full-client modules (Business Objects XI3.x Designer, Desktop intelligence and Central Management Console) for user Community and server-side modules (Web Intelligence).
• Extensive experience in designing and developing Universes, creating canned/ad-hoc reports, scheduling the reports and administering the BO activities.
• Expertise in implementing, migrating and maintaining Business Objects modules both full-client modules (Business Objects XIR2 Designer, Desktop intelligent and Central Management Console) for user Community and server-side modules (Web Intelligence).
• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using Business Objects.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 8.1/7, Tableau Server 7, OBIEE11g/10.1.3.4

ETL Tools: Informatica 7.x/8.x (Power Center),, Talend 4.2.x/5.1.2,Data Cleaner 2.2.

Databases: Oracle 9i/10g/11g, My SQL, MS SQL Server 2008, Teradata

Languages: SQL, PL/SQL,HTML, XML, JavaScript

Operating Systems: Windows 95/98/NT/2000/XP/7

FTP Tool: WinSCP 5.X, Filezilla 3.5.x, Putty

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Tableau Consultant

Responsibilities:

• Develop various data connections from data source to Tableau Server for report and dashboard development.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Utilize Tabadmin and Tabcmd commands to create backups and restore backups of Tableau repository.
• Tableau server maintenance, Tableau server backup activity.
• Consolidate multiple data silos that exist on campus to one location.
• Scheduled data extracts on a daily basis.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.
• Environment Support to User community, Service Request & Resolution.
• Expertise in failed over activities in production Environments.

Environment: Tableau 8.1/7.0, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and JavaScript.

Confidential, Woonsocket, RI

Tableau Consultant

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tabcmd and Tabadmin utility tool.
• Migrated Workbooks and Dashboards from Tableau 7 to Tableau 8
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 7/8.0, Tableau 7 Desktop, Tableau server, Oracle 11g, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

Confidential . Cupertino, CA

Business objects Architect

Responsibilities:

• Designed Reports using BO tools (Xcelsius, Crystal reports, WebI).
• Involved in doing the gap analysis by checking the Existing reports and Requirements based on Business Requirement Document.
• Documented the functional Specifications and report design documents.
• Created and Scheduled several BO Reports and delivered to the clients.
• Involved in Designing Salesdash Board using Xcelsius and QaaWS.
• Integrated Xcelsius dashboards with Business Objects Universe using QaaWS.
• Created Master/Detail, Cross Tab and Chart templates using the Business Objects and Web Intelligence tools.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Involved in Designing AD Hoc reports and Canned Reports.
• Responsible for facilitating the definition of the business requirements and business processes throughout the implementation.
• Maintained and tested universes for supporting ad hoc queries and reports according to the business requirements.
• Evaluated the possible use of aggregate tables and worked with DBA team to create these tables.
• Defined @Aggregate awareness, @Prompt, @Select, @Where functions in universe level.
• Designed complex WebI and DeskI reports using opendoc parameters and cascading prompts.
• Analyze all the data sources and develop requirements for data conversion.
• Created thin client reports using web intelligence (Webi) in order to view the reports from intranet.
• Architected and developed Xcelsius dashboards: Executive level dashboard that tracks handraisers and leads, Direct mail promotion Dashboard that compares how different promotional campaigns are doing, and Performance dashboards.
• Created Crystal Reports with different graphs like Pie chart, Bar Graphs, Area Graphs, etc.
• Created Crystal Reports using SQL Commands.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Migrated reports from XI R2 to 3.1 and 3.1 to 4.0.
• Involved in performance tuning of reports, unit testing and documenting the processes.
• Involved in scheduling the reports and process them for Business users.
• Responsible for delivering the Business Objects Reports on time.
• Identifying the risks and issues from team meetings and coordinating with Project manager.
• Mentored the team members, to be able to run the BO reports.

Environment: Business Objects XI 3.1 & 4.0, WebI, DeskI, Xcelsius 2008, QaaWS, Live Office, Microsoft Visio, SQL Server 2008 R2, Access, Windows 2007.

Confidential, San Francisco, CA

Crystal Report Developer/ Business Objects Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created Universe level objects and measures using the business rules provided.
• Interacted with the Business Analysts to gather the requirements and developed prototypes in the form of PDF’s or Power Point Slides of the Dashboards for the initial presentation to the users.
• Worked in a production support role where in typical issues have been intelligently resolved.
• Created Crystal Reports using Stored Procedures and SAP data source.
• ConvertedSAS Reports to Business Objects Reports (Crystal Reports, WEBI).
• Fine tuning the performance of Universe and reports.
• Involved in production support based on the Remedy tickets modified/resolved the Reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the universes.
• Created hierarchy and conditions in the universes.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Business Objects.
• Created reports for various product lines using the universe as the main data provider.
• Used Business Objects functionalities like Slice and Dice, DrillDown, Cross Tab, Functions and Master Detail etc.
• Generated reports using personal data files like MS Excel.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• With the specifications given, analyzed the data for the Report generation.
• Using graphs, formulas, sub reports, cross tabs, conditional formatting and dynamic cascading prompts for parameterized reports.
• Used prompts for taking inputs from users and by the use of formulae, grouping and sorting functions are done dynamically.
• Created Complex Crystal Reports with user appealing design and format.
• Using import wizard Migrated reports, users, roles and Calculated Objects.
• Involved in all phases of migration from Crystal Reports 10 to 2008.
• Configured and trained users to use Crystal Reports 2008.
• Created views and stored procedures for Reports using complex SQL.
• Created standardized data collection and analysis reports.
• Used ADO (Excel/Access) connectivity for extracting the data from Excel spreadsheets to Crystal.
• Created drill down reports for material details.
• Used Cross Tab Reports for the easy retrieval of Project and cost information.
• Developed technical documentation for all the reports.
• Tested the Reports before the production process.

Environment: Business Objects XI 3.1, SAP, SAS 9.1, Oracle 10g, SQL server 2008, Xcelsius 2008, Crystal Reports 2008, MS Excel, windows 2007.

Confidential

MS SQL Server Developer

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, Stored Procedures and Views.
• Involved in developing the SQL code for the application.
• Solved various T-SQL issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created ad hoc T-SQL Queries
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Analyzed the Reports, Tables and ETL process.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties.

Environment: T-SQL, MS SQL Server 2008, SSAS, SSRS, SSIS, XML, Windows 2000/2003/NT/XP, Microsoft .NET framework 3.5, MS-Excel