SUMMARY:

• 8+ years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools in Confidential, Healthcare, Insurance, and Finance industries.
• 5 + years of extensive experience with design and development of Tableau visualization solutions.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau reader in various versions of Tableau (7.x/8.x/9.x/10/2018.x ) and Vizql, SQL, PL SQL and UNIX shell scripting.
• Experience in business process analysis/modeling, business requirements, and developing High level Designs and Prototypes for Business applications.
• Support and maintain Project Data Models at multiple levels of detail and functionality (conceptual, logical, physical and subject - level) in developing star schema and snowflake schema.
• Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Efficient in identifying and analyzing Business requirements from documents and end-user discussions and deliver the data requirements necessary to support DW subject areas.
• Extensive experience in various DB/DW/BI technologies including Teradata, Oracle, SQL Server, Tableau, Informatica, SSIS, SSRS, Unica, Google Analytics, UNIX, Toad.
• Proficient in creating the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Experience in aggregating data and configuring reports from different data sources using data blending.
• Proficient in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps, Donut, Waterfall, Pareto and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• Designed the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis, data exploration and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Excellent analytical, problem solving, communication and time management skills.

TECHNICAL SKILLS:

Analytical Tools: Tableau(Desktop/Server/Public/Online/Reader), SSRS, SAP Business Objects,, OBIEE

ETL Tools: Aletryx, DataStage, Informatica, SSIS

Databases: Teradata, Oracle 11i/10g/9i, SQL Server, Sybase, SAP HANA/BW

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

Document Management: Documentum, Visual Source Safe, Share Point, Ultra Edit

Defect Management tool: HP Quality Center

Methodologies: Kimball/Inmon, Star/Snow flake Schema, ETL, OLAP, Waterfall, Agile

Data Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio

Programming Languages: C, C++, C#,.NET, SQL, PL/SQL, T-SQL and Java

Operating System: Windows, UNIX (HP UX, Solaris, AIX)

Scripting Languages: JavaScript, Shell Scripts, Python, HTML and XML

Scheduling Tools: Control M, AutoSys, ESP Scheduler

FTP Tools: WinSCP, FileZilla

PROFESSIONAL EXPERIENCE:

Confidential, Warsaw, IN

Sr. Tableau Consultant / Business Intelligence Analyst

Responsibilities:

• Developed data visuals design to enable analysts to perform targeted customer analysis.
• Implemented interactive changes to the existing sales reports and updated with that visuals from month level to the day level trends.
• Coordinated with systems partners to finalize reports and confirm requirements.
• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
• Developed Custom SQL queries to pull the data from legacy systems and data servers like SAP HANA, PostgreSQL, MS SQL, Oracle for reporting purposes.
• Expertise skills in building complicated, creative and user interactive visuals using Tableau Desktop. Developed consistent data extracts (.tde, .hyper) holding various data joins using connections like MS Excel, SAP HANA, MS SQL and published into Tableau Server for balanced maintenance.
• Consistently met deadlines and requirements for all production work orders.
• Developed work-flow charts and diagrams to ensure production team compliance with client deadlines.

Environment: Tableau Desktop, Server (10x), SAP HANA/BW, SAP Business Objects, SharePoint, Microsoft Office Suite (Word, Excel, PowerPoint), Oracle 11g, MS SQL Server.

Confidential, Chicago, IL

Sr. Tableau Consultant / Business Intelligence Analyst

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Conducted Requirements walk-through meetings with key stakeholders.
• Participated in technical walk-through meetings to develop the functional designs for the implementation.
• Enabled Finance leaders to consistently capitalize higher dollar amounts from prior quarters of 2015 to mid of 2016 by producing Tree maps, Stacked bars, Line graphs with Forecasts, by blending multiple sources on Oracle and Excel.
• Used Alteryx analytics for convert data blending and analytics efforts into Tableau extracts, enabling an easy, repeatable.
• Implemented workbooks to display Year to Date, Month to Date, Quarter to Date analysis for Operational expenses for IT leaders based on Accounts, and generated bullet graphs with a comparative analysis between 2015 and 2016.
• Worked on automation of the accounting reports submitted to IT leaders in Tableau Server according to the schedule of data update and created subscriptions to receive updated reports.
• Created dashboards with interactive visuals using Geo Maps, Heat Maps, Donut Charts, Funnel Charts, Water fall Charts, and much more default visuals available in the Tableau Desktop.
• Developed a story for PayPal with interactive dashboards using action filters which summarizes its performance over a period of time and growth over competitors.
• Developed workflows using Aletryx to obtain the tables from legacy systems which are most compatible with Tableau
• Worked as technical expert in the setup and upgrade of the Tableau production server environment in multiple nodes and configured the server with high availability architecture.
• Create/Manage Content, Users, Schedules, Tasks, Permissions and Data Source connections and was a part of monitoring setup for background running extracts as per the schedules planned avoiding the conflicts.
• Conducted weekly Q & A Sessions and helped in finding solutions for the working Issues of the Tableau (Desktop & Server) users in organization.
• Developed interactive and high performance dashboards using the published data sources within the Tableau Server and embedded into SharePoint team sites using JavaScript.
• Created Data extracts for better performance of dashboards and accessing data offline.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Environment: Tableau Desktop, Server, Reader (9x, 10x), Alteryx, Splunk, SharePoint, MS SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Oracle 11g, Python.

Confidential, Milwaukee, WI

Tableau Developer / Data Analyst

Responsibilities:

• Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
• Analyze complex data from various data repositories and become familiar with user base locations.
• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.
• Designed and developed mock-up Tableau Dashboards to data exploration options for visualization of data, presentation, and analysis.
• Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.
• Mentored junior analysts in the process of requirements gathering, application development, and trouble-shooting and support.
• Created side by side bar chart comparison of Vendors who were into Confidential along with profit revenue generated.
• Effectively used data blending feature in Alteryx to combine the data from different sources like SAP Lynx, Vision etc. into a single report.
• Created line charts to display trends over a period of time and tied it with bar charts to show revenue growth based on users upgrading to additional features of the mobile app additionally adding filter to choose between business and personal users.
• Worked with DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Used parameters and input controls to give users control over certain values.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Created Data extracts for better performance of dashboards and accessing data offline.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Integrated dashboards with live Connection in Microsoft PowerPoint.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Created reports using Custom SQL for complex report views.
• Executed and tested required queries and reports before publishing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop/Server/Reader) 9.x/8.x, Oracle 11i, MS SQL Server, SQL BI Suite (SSIS, SSRS), Java API, SharePoint, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), FileZilla.

Confidential, Chicago, IL

Business Systems Analyst

Responsibilities:

• Played a key role in gathering and documenting Business requirements.
• Conducted Requirement walk-through meetings with key stakeholders.
• Participated in technical walk-through meetings to develop the functional design for the implementation.
• Performed detailed requirement analysis and created data mapping documents
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Designed the conceptual data and business process models.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modeling techniques in designing the data marts project.
• Extensively involved in Data mapping and Data modeling.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Developed mappings and workflows in SSIS to extract data files for third party vendors.
• Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.
• Involved in modifying Teradata stored procedures and performance tuning of various tables.
• Managing metadata by mapping dimensions and fact tables of various schemas/data models
• Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports using ERwin Tool.
• Conducted JAD sessions, design discussions and SOS meetings to come out with the appropriate data mart.
• Experience defining enterprise data location architectures for ODS, Data mart, and Data Warehouse data.
• Created test cases for carrying out unit testing and part of functional testing.

Environment: ERwin, SSIS, OBIEE, Oracle, Teradata, Toad, SQL Developer, TOAD, UNIX, MS Visio, MS Office Suite (Word, PowerPoint, Excel).

Confidential

SQL Developer

Responsibilities:

• As a team member involved in collecting all the requirements for building the database.
• Developed data solutions to support company's initiatives using Relational Database models, Business Objects and Informatica.
• Developed Reporting/BI Solutions, Score Cards and Dashboards using MS Excel, Business Objects WEBi, Universe, BO Explorer and Tableau.
• Developed complex Business Objects universes by using features like aggregate aware, Index aware, Conditions and hierarchies.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Worked on building Informatica mappings for data load from OLTP to OLAP system for reporting.
• Responsible for Extracting, Transforming and Loading data from Oracle, Flat files and placing them into targets.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected and unconnected lookups, Filter transformation, and sequence generator transformations.
• Involved in Data Modeling and design of Data Warehouse and Data Marts in Star Schema methodology with conformed and granular dimensions and fact tables.
• Used SQL, PL/SQL for database related functionality.
• Worked on SQL Tuning and Optimization of the reports.

Environment: Business Objects, Informatica Power Center, Oracle, SQL Server, PL/SQL, UNIX, Windows XP, MS Office Suite (Word, Excel, PowerPoint)