SUMMARY

• Over 9+ years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
• Extensively worked on Tableau 6.x/7.x/8.x/9.2 (Desktop, Server, Mobile, and Public), Micro Strategy, Business Objects and SSRS.
• Created Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7, Tableau 8 and Tableau 9
• Extensive experience on building Dashboards using Tableau.
• Worked closely with Tableau support team during tableau server upgrades to 8.3
• Worked on data blending and increased the Dashboard performance by extracting data .
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Work flows, Customized Analytic s Reports.
• Major responsibilities include getting requirements from the user and preparing estimates, defining technical solutions.
• Maintaining proper documentation of the reports for future reference.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Created solution driven dashboards by developing different charts types including cross tab's, Heat/Geo/tree maps, pie/bar charts/circle views/Lines/Area charts, Scatter plots, bullet Graphs, and Histograms in Tableau Desktop.
• Good knowledge on Tableau Administrator installation, configuration, and load balancing.
• Designed and Developed reports and dashboards for Insurance domain.
• Developed several Tableau reports for Sales Data Mart Data.
• Successfully completed several crystal report projects at major customer sites.
• Very good knowledge in Business Intelligence concepts and process.
• Good understanding on OLTP and OLAP based data. Capable of creating visually rich and highly optimized Tableau reports pointing to OLAP and OLTP systems.
• Written scripts in languages such as JAVA Script, which affect the behavior of HTML web pages
• Ease in dealing with end users while working on KPIs, Requirements and detail designs.
• Excellent knowledge in Data Warehouse concepts and multidimensional data.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection.

Data Visualization: Tableau, Qlikview, Power Pivot, Excel, SSRS,SSAS, Visual AnalyticsBusiness Objects XI/4.0

Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11gMS Access, Teradata.

Tools: and Packages: SQL Server Management studio, Toad, Microsoft Visual StudioLanguages SQL, PL/SQL, C, C#, ASP.Net, HTML, XML

Operating Systems: Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX.

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

Sr. Tableau Developer

Responsibilities:

• Responsible for creating the complex Tableau Reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Drill-down, dynamic grouping, Cross-Tab, graphical etc).
• Created Dashboards for Monitoring and performance Analysis.
• Responsible for running Ad-hoc queries in Track wise Team Access System to test the data in the report.
• Major responsibilities include getting requirements from the user and developing in Tableau. Maintaining proper documentation of the reports for future reference.
• Created complex formulas at the summary level and group level to implement the business logic.
• Extracting data from different sources connecting them and used the same to create dashboard
• Multiple data sources by joining tables and using Data Blending.
• Transformed complex data into easy-to-understand visualizations using Tableau and created a Story. Created Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.
• Transformed complex data into easy-to-understand visualizations using Tableau and created a Story.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Defined and created procedures to install Tableau desktop in silent mode. Defined best practices for Tableau report development.

Environment: Tableau 9.2, IBM Netezza, SQL Server,Oracle, MS Access, Teradata, Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential - Charlotte, NC

Tableau Developer

Responsibilities:

• Converted theBusiness Objects/OBIEE reports into Tableau Dynamic Data Visualization andcreated Mapping Documents.
• Gathered business requirements andtransformed the business into high interactiveData VisualizationusingTableau.
• Understood the business challenges and translated them into requirements and developed inTableau Desktopaccording to Business Requirements.
• Created Metadata dictionary Dashboard and allowed the business users to audit the metadata of identified data sources.
• Created Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.
• Transformed complex data into easy-to-understand visualizations using Tableau and created a Story. Created Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.
• Converted theBusiness ObjectsTechnical Specification into Tableau MetadatausingWorkbook Tools for Tableau
• EnsuredAction Filters, created aRow Level Securityand shared the reports with functional/business users
• Created Dashboards with the security using filters for the clients to measure cost saving.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drill down and drill up reports.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes. Combined
• Multiple data sources by joining tables and using Data Blending.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Worked on groups, sets, different calculation functions including Table calculations.
• Hands on Tableau Administrator installation, configuration, and load balancing.
• Hands on Design and implement security model.
• Blended data from multiple databases such as MS Excel, MS SQL, Teradata and Oracle.

Environment: Tableau 9.2, Data Stage, SQL Server,Oracle, MS Access, Teradata, Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential - Detroit, MI

Tableau Developer

Responsibilities:

• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Create views and dashboards on HR data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar and line charts that are viewed daily by CEO and CFO.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data Visualization dashboards.
• Extracting data from different sources connecting them and used the same to create dashboard.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Created complicated formulas and running totals on summarized totals for business measure calculations based upon various end user requirements.
• Transformed complex data into easy-to-understand visualizations using Tableau and created a Story.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.

Environment: Tableau Server, Tableau Desktop, Windows Server Standard R2, Clear quest, Clear case, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4.

Confidential - Orlando, FL

Tableau Developer

Responsibilities:

• Interacted professionally with a diverse group including executives, managers.
• Experience with the design and development ofTableauvisualization solutions.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Involved in creating dashboards and reports inTableau. Created report schedules onTableau server.
• Worked on Netezza JDBC, ODBC and OLE DB to configure data connectivity clients to connect Netezza system and run queries through the supported drivers.
• Installed Tableau Server in Dev, QA, UAT and Prod environments.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Monitored Vizql and WGSQL Server activity to track performance and system stability.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extracting data from different sources connecting them and used the same to create dashboard
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Created data blending in case of merging two different datasets.
• Designed the Conceptual and Physical Data Models, as well as the major components of the user interface for the “MDW” project. The Data Models were built with Sybase Designer.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Confidential Enterprise wide Tableau application consisting of multiple key functional business domains.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users

Environment: Tableau Desktop, Tableauserver / Administrator, Oracle 10g, Microsoft Excel 2007,MS Access, Microsoft office 2007.

Confidential - Overland Park, KS

Crystal Report Developer

Responsibilities:

• Responsible for the Design, Development & Implementation of Reports in Crystal Reports XI/10.
• Migrated existing Crystal Reports 10 to XI.
• Developed customized interfaces / Dashboards using Crystal Server Pages
• Created nested and conditional subgroups and formatting features in reports.
• Created sub reports called from the main report to implement the business logic.
• Tuned reports for faster execution using stored procedures, views and column indexes.
• Created complex formulas at the summary level and group level to implement the business logic.
• Responsible for creating the complex crystal reports (On demand, Adhoc Reports, Frequency Reports, Summary Reports, sub reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports).
• Created Parameter driven reports to restrict volume of data.
• Used Evaluation Time functions like In Repeated Group Header, While Printing Records, While Reading, Records, Evaluate After etc.
• Created complicated formulas and running totals on summarized totals for business measure calculations based upon various end user requirements.
• Scheduled reports using Schedule Manager in Crystal Management Console to run every day on a periodic basis.
• Responsible for inserting new records in database using the front end tool in Track wise Team Access.
• Responsible for running Ad-hoc queries in Track wise Team Access System to test the data in the report.
• Responsible for documenting reports using standard templates like Design Specification, Operational Qualification and Performance Qualification.

Environment: Track wise Team Access, Crystal Enterprise XI/10/9, Oracle 9i, TOAD

Confidential

Business Objects Developer

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Created New Universes and Managed existing Universes Migrate, upgrade and test the Business Object XIR3 content/environment
• Setup, execute, and test the assigned programs utilizing BO XIR3 WEBI and DESKI tools
• Creation of multiple Universes and Linked Universes.
• Design complex Web Intelligence and Desktop Intelligence Reports
• Plan the implementation of migration to different Environments in Business Objects.
• Involved in the Data Warehouse design process
• Develop Dashboards for the higher management of the company
• Worked on extensive features of Business Objects XI including Index awareness, Derived tables and Input Controls
• Creation of reports, working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Analyzed the reports using the Drill Through, Slice and Dice.
• Trained the users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
• Designed, developed, tested and maintained highly complex reports.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Deployed the reports by using Import Wizard (between DEV and UAT) and archived the reports giving access permission for Business Objects Reports.

Environment: Business Objects XI 3.1/6.5(Web Intelligence/Desktop Intelligence), Designer, Import Wizard) Performance Management, Oracle 9i, DB2, AS/400, SQL Server, Windows XP.