PROFESSIONAL SUMMARY:

• Over 8 years of experience in Business Intelligence, Data Mining, Data Analysis, Project Management.
• Knowledge of project management, like estimation, planning, scheduling, and monitoring.
• Working knowledge in different industries like Finance, Health Care, Construction, Energy, Telecom
• Highly experienced in various analytic and reporting tool like Tableau Desktop, SSRS/SSAS, Microstrategy, Qlik View.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu and Parameterized option using Tableau.
• Experienced in developing reports based on statistical analysis
• Extensively used functions like Bins, Groups, Sets, Cluster in analysis and creating visualization
• Created various types of charts, worked with maps
• Experienced in creating highly interactive Dashboards in Tableau
• End to end experience in designing and deploying data visualizations using Tableau
• Experienced with Tableau Server, created different projects in server, customized permission to different level of users to different projects, created email alert for admins, connected Tableau Server to other databases for extraction of Data and to Publish views.
• Deployed the reports andScheduled Reportsfor the use of end users and customers
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Worked with different data sources like SQL Server, Oracle, Teradata using T - SQL, PL/SQL, Teradata SQL
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment
• Strong knowledge in software development methodologies like Agile, Waterfall across the span of various projects
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Ability to work on multiple tasks and deliver the results within estimated budget and time.
• Expertise in documentation of the processes and other application related manuals to support production activities.
• Strong analytical, problem solving and communication skills with strong focus towards goals and work ethics.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, MySQL, PL/SQLBI/Reporting tools: Tableau Desktop, SSAS/SSRS, Qlik View, Microstrategy

Databases: MS SQL Server, Oracle, Teradata

Operating Systems: Windows XP/7/8/10, Linux

Packages / Tools: MS Office Suite (Word, Excel, Power Point)

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Tableau Developer/Analyst

Responsibilities:

• Analyzing and Extracting data from different sources for design, development, testing, and production rollover of analysis and reporting projects within Tableau Desktop, and SQL Server Reporting service.
• Created Heat Map for analysis of data integrity and progress integrity across different site.
• Created highly interactive dashboard using parameters, sets, groups and calculations.
• Used maps extensively for reporting.
• Used page function for animation.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by various ways, like selecting primary key’s from each database, changing name of dimensions, matching columns.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created reports with point and trend lines for understanding status and forecasting purpose
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, SQL Server, SSRS, Microsoft Suite (Word, Excel, PowerPoint, Visio), Oracle Server, SQL Server 2012/2014, SSAS, SSRS

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop, and SSRS.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, SQL Server, SSRS, Microsoft Suite (Word, Excel, PowerPoint, Visio), Teradata

Confidential, Lowell, MA

Tableau Consultant

Responsibilities:

• Developed various data connections from data sources to Tableau Server and SSRS for report and dashboard development.
• Used both Tableau Desktop and SSRS for data mining.
• Participated in ETL process.
• Worked in SSAS platform for creating cubes with MDX.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop for Client Specific Hospitals.
• Used maps and animation for reporting
• Created statistical charts using Line, Trend Line, Drop Line, Forecasting
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• Written complex queries using Joins, Apply, Sub-queries, Table Expression, Windowing in T-SQL, PL/SQL for data mining, data arranging, data cleansing
• Scheduled data refresh on Tableau Server for weekly basis to ensure that the views and dashboards displayed the changed data accurately.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Upgraded Tableau Server to latest version 9.2 and created automated Backup using Task Scheduler.
• Used Data blending feature of Tableau to blend data with different level of granularities for proper analysis.
• Extensively used parameters in sets, bins, calculated fields, filters for highly flexible and controlled analysis and super interactive dashboard designs.
• Done QA of the Tableau work books and dashboards by comparing results from different tools.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Monitored and maintained incremental refreshes for data sources on Tableau server.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Focus on getting end-users up to speed on Tableau capability.
• Did the initial study of Health Care Management to collect customer’s information, data about existing systems at client site, specific customer requirements for the Electronic Health Reports (EHR).
• We work on programs such as Meaningful Use, Inpatient Quality Reporting (IQR), and Value Based Purchasing (VBP).
• Providing of clinical intelligence solutions for hospitals. Providing meaningful use reporting solutions and clinical reporting solutions help hospitals achieve compliance with federal P4P programs and provide them with daily, actionable information to improve care, quality, and outcomes.

Environment: Tableau Desktop, Tableau Server, SQL Server, SSRS, SSAS, Microsoft Suite (Word, Excel, PowerPoint, Visio), Oracle Database

Confidential, Schaumburg, IL

Tableau Developer

Responsibilities:

• Involved in creating dashboards in Tableau and SSRS platform, by extracting data from different sources .
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Desktop, Tableau Server, SQL Server, SSRS, Microsoft Suite (Word, Excel, PowerPoint, Visio), Teradata, Oracle Database

Confidential

BI/Tableau Developer

Responsibilities:

• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Stored Procedures, triggers.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Desktop, Tableau Server, SQL Server, Microsoft Suite (Word, Excel, PowerPoint, Visio)

Confidential

Business Systems/Data Analyst

Responsibilities:

• Liaison between the client and development team to support the client’s data analysis and reporting needs.
• Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective
• Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management end of day feeds.
• Performed monthly analysis comparing the monthly interest rate calculation to interest income booked to the general ledger.
• Reconcile internal & external financial reports to ensure proper account balance are maintained and accurate data, which are reflected on client accounts.
• Managed the production of cash flow, P&L and balance sheet reports
• Involved in analyzing requirements, identifying various individual logical components, expressing the system design through UML diagrams
• Worked on Rational Rose to develop the use cases, class diagrams and sequence diagrams.
• Worked on Requirement Change Management System in Rational Requisite Pro.
• Setting up document hierarchy and standards to define different level of requirement using Rational Requisite Pro.
• Requirements Elicitation, Analysis, Communication, and Validation according to Six Sigma Standards.
• Involved in User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Involved in data mapping sessions, and write the required business requirements documentation including use cases.
• Interacted and interviewed customers and business sponsors to gather data requirement.
• Developed detailed auditing and reporting of the current status and history of all components related to a product.
• Translated customer/clients’ needs into new features and new services.

Environment: Business Objects, Enterprise Architect, Toad, Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)