PROFESSIONAL SUMMARY:

• Results - driven, versatile Analytics/Reporting lead with over 9+ years of experience in Data Strategy and Visualizations.
• Expertise in all facets of Business Intelligence applications with a strong background in Data extraction, data visualization, report generation, infographics and information visualization.
• Develop data-driven business and analytic strategies and visualizations for Fortune 100 companies, start-ups and NGOs. Specializing in Tableau Dashboard development, and turning big data into actionable insights.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC and various methodologies like Agile and scrum.
• Extensive experience in designing dashboards, reports development on various databases like Oracle, MS SQL Server, Hadoop, Teradata, MS Access, Flat Files and MS Excel.
• Experienced in leading a Team, project management and agile development environment following Scrum methodology.
• Serves as a liaison between Client, Project Management and offshore development staff.
• Hands-on with creating solution driven dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Line Charts, Area Charts, Scatter plots, Bullet Graphs, Pareto and Histograms in Tableau Desktop 8.x, 9.x, 10.x.
• Involve in discussion with Business folks in understanding the problem requirement and recreation scenarios updating and creating project related Request for Proposals (RFPs), Standard Operating Procedures (SOPs), Business Requirement Documents (BRDs) etc.
• Involved in conducting trainings to users on interactions, filters, sort and customization of views on an existing visualization generated through Tableau desktop.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop 10.x, 9.x, 8.x; Advanced Excel (VLOOKUPs, Pivots)

Project Management: Agile-SCRUM, SDLC, Waterfall, MS Office, CA-Rally

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2012, Hadoop

Programming: SQL, Python (Beginner)

OS Environments: Windows

Other Tools: Think-Cell Charts, Photoshop, Illustrator, Confluence, Visio

CLIENT EXPERIENCE:

Confidential, Philadelphia, PA

Data Visualization Consultant

Responsibilities:

• Currently working at Confidential as Business Analyst/Technical Lead for Business Intelligence Project
• Successfully led the Analytics team, implemented various reporting and analytics projects using Excel Dashboards, Tableau, such as
• Release Schedule Dashboard (Complex Gantt Chart to track all Group IT Releases)
• Change Management Dashboard (To track change tickets and their status)
• Release Readiness Dashboard (To track implementation Strategy of Release)
• DevOps Scorecard (To track CI/CD pipeline adoption)
• Technology Currency Dashboard (To track the end of support details of technologies used across Group)
• Impact Assessment Dashboard
• HR Analytics Dashboard (To track Project Schedule and budgets)
• Creating UI Mockups for the Data Visualizations and presenting to the Stakeholders.
• Involved in new KPI generation for Scorecards.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize and share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Designed and developed various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Pareto Charts, Dual Axis, Blended Axes, Scatter Plots, Bar in Bar, Box Plot, Bullet Chart, Gantt Chart, Heat Map, Spark Line, KPI Charts.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau 10.2, 2018.2, MS SQL Server, MS Excel, Flat files, MS PowerPoint, Windows 7, Management Studio.

Confidential

Business Strategy Insights Analyst (Tableau)

Responsibilities:

• Work within a cross functional team of Leadership Team, Business Analysts, Data Analysts and Data Scientists to design reports, dashboards, story boards and Visual representation of Business Statistics.
• Designed and developed automatically update dashboards from various data sources to closely monitor client business KPI, uncover industry trends and insights in order to optimize spending and ROI.
• Developed projects to automate and scale analysis, leading to efficient workflows and incremental investment from clients
• Develop Business Performance Dashboards including monthly Network Usage reports, Market penetration reports to inform strategic and tactical decision-making.
• Prepare executive level presentations to clearly articulate the results of the analysis.
• Provide insight into customer behavior, trends, financials, and Confidential 's business operations through development of business intelligence visuals.
• Builds new/enhance dashboards and reports in Tableau on Agile Methodology (2 weeks sprint).
• 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.
• 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.
• Implemented Donut chart to study Network Health across all regions.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau 10, 9.1 Desktop, MS SQL Server, MS Excel, Flat files, MS PowerPoint, Windows 7, Management Studio.

Confidential

Data Visualization Consultant (Tableau)

Responsibilities:

• As a Data Visualization Consultant supporting Risk Consulting Team in Model Documentation and Data Visualizations for the Data Science Team which develops Credit and Market Risk Predictive Models for the US Banking clients.
• Worked as a Tableau Desktop Developer focusing on developing high-end visualizations driven by data coming in from various data sources including Flat files, SQL Server and MS Excel.
• Developed various stories and dashboards using multiple data sources and by blending them on a single worksheet in Tableau Desktop version.
• Involved extensively in dashboards development such as creating Tableau Extracts, Refreshing extracts, Tableau Connectors (Live and Extract), formatting and report operations (sorting, filtering, ranking, Top-N Analysis).
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies in Tableau.
• Used advanced data visualization and representation techniques in Tableau to provide an easy to understand interface for end users to quickly identify key areas within their data.
• Trained end users in various parts of the world to effectively use tableau and also customize the reports based on the department and needs of the users.
• Create and enhance the standard of client communications like company reports & screen presentations in PowerPoint, various Reports in MS Excel/Tableau through corporate style/template as per specification.
• Additionally, performing the role of the Quality Audit on presentation for the new trainees
• Trained end users in various parts of the world to effectively use tableau and also customize the reports based on the department and needs of the users
• Engaged in the design and production of visual communication materials like charts, Financial presentations based on PowerPoint/Think cell/Tableau for use of Confidential Leadership Team.

Environment: Tableau 9, MS SQL Server 2008, MS Excel, Flat files, MS PowerPoint

Confidential

Data Visualization Consultant

Responsibilities:

• Responsible for building a reporting portal to provide insights of operations which includes reporting on Audit Strategy, Discussion and Appeals, Provider Communications, Imaging and Aging of Claims submission, Demand and Invoice
• Worked with cross functional team of Business Analysts and Data Scientists to design and implement various business intelligence inputs such as reports, dashboards, story boards and Visual representation of Complex Business statistics through PowerPoint Presentations.
• Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements
• Involved in end to end implementation and enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop 8 .
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development
• Created dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with SQL Server Databases
• Developed and reviewed SQL queries with use of join clauses in Tableau Desktop for Data Validation.

Environment: Tableau 8.2, 8.3; MS SQL Server 2008, MS Excel, Flat files, MS PowerPoint

Confidential

Senior Presentation Specialist/Tableau Developer

Responsibilities:

• Work closely with Confidential case teams by supporting in preparation of reports and presentation for their study, review marketing material and business report, including data and presentation created for board, by utilizing PowerPoint, Excel, and other proprietary programs.
• As a Data Visualization Consultant (Tableau), responsible for creating interactive visualizations to help strategy/case teams to take their decisions faster at first look.
• Analytics the tabular data and represent in sort and diagrammatically, so that it will be sort and eye catching for on-boarding Directors and Partners.
• Understanding the Reporting requirements, work with stakeholders to gather their reporting requirements, translate those requirements into actual report definitions, validate results
• Reformat quantitative data from reports or output for use in PowerPoint documents.
• Data visualization using Charts in Think-cell/Excel/Tableau (column chart, pie chart, stacked chart, waterfall chart, bubble chart, scatter chart, line chart, pareto chart etc.)
• Creating high profile, visually impressive presentations. Reformat in PowerPoint slides and Ms-Word for a more professional look and alignment with corporate and brand identity standards
• Reformat quantitative data from reports or output for use in PowerPoint documents.
• Build the design and content of PowerPoint reports/presentation slide shows including overall Environment: Tableau Desktop 8.2&7, MS Excel, MS PowerPoint, Excel Dashboards, Adode Design tools like Photoshop, Illustrator, Data Visualization tools like Think-cell Charts.

Reporting Analyst

Confidential, NA

Responsibilities:

• Prepared various MIS reports such as Default lists, audit, compliance for weekly, monthly and quarterly reports using Advance Excel & DM Techniques (such as Pivot Tables, Scenario Manager, Data Validations, Conditional Formatting, Consolidations, Advance Functions like V-lookup, Index-Match, Countifs, Sumifs etc.)
• Reformat quantitative data from reports or output for use in PowerPoint documents.
• As Presentation Specialist responsible for enhancing and optimizing both internal and client facing presentations.
• Developing animated visual stories, interactive kiosks, and navigation capable decks that allow presenters and users to use the tool in ways never imagined.
• Strong conceptual skills and ability to turn statistical information into opportunities for visual storytelling & Infographics

Environment: MS Excel, MS PowerPoint, Think-cell charts for Dashboards, Photoshop, Illustrator Infographics