SUMMARY

• Extensive Tableau Experience in Enterprise and financial Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Worked on MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS).
• Moved reporting to Amazon Redshift and rewrote reports and dashboards in Tableau.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Leveraged data from web analytics tools to create custom key metrics reports and trends.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• Knowledge of working on Google Analytics Segmentation and creating Google Analytics Dashboards .
• Generation of Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management.
• Knowledge of System Development Life Cycle (SDLC).
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending. Extensive experience in Installation, Configuration, Upgrade and administration of Tableau Desktop/Server.
• Experience in Developing Performance Dashboards, Score cards, Metrics, what if analysis, Prompts, Drills, Search (using Add-ons), Reports/Dashboards for all the functional areasincluding Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales/Marketing, Variable Objects with formulas.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, MSBI tools (SSIS/SSRS), Alteryx, SAP BI

Databases: MS SQL Server, Oracle 11g/12c

Tools: MS Excel, MS Word, MS PowerPoint.

Programming: TSQL, SQL

WEB Technologies: XML, HTML.

MANAGEMEBT SKILLS: Six Sigma & ISO Leadership, Continuous Improvement, Process Development, Statistical process controls(SPC), Quality Auditing, Project management, Methodologies like DMAIC, DMADV, APQP, FMEA, QFD,8D,5S.

PROFESSIONAL EXPERIENCE

Confidential, TX

BI Developer

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Creating Check Points and Break Points to trace package errors using SSIS.
• Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned.
• Well versed in Performance Point Server. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Interacted with Subject Matter Experts, End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Expertise in Desktop creating and integrating Micro strategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Created Heat Map showing sales data by color that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
• Worked on Data Warehousing methodologies and concepts.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Performed in depth analysis of data & prepared periodic reports using MS Excel, SQL.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints.

Environment: Tableau 9.x/8.x (Desktop/ Server), QlikView, MS SQL Server, SSRS.

Confidential, Marlborough, MA

BI Developer/Tableau developer

Responsibilities:

• Used SQL queries and Scripts to perform efficient data load based on complex business rules and produced results for users.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business.
• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Created different schema objects like Attributes, facts by using Micro Strategy.
• Involved in creating Micro Strategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
• Developed predictive statistical models using statistical analysis and other predictive modeling techniques.
• Conducted data accuracy analysis and support stakeholders for decision-making.
• Analyzed data using advance Excel functions such as Pivot Table, Charts, Graphs and Macros.
• Maintained a log of number of data tested, number of passes, number of fails, number of defects identified, type of defects and the severity and frequency of every defects.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Defined best practices for Tableau report development.Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.

Confidential, Charlotte, NC

BI Developer//Data Analyst //Tableau Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server in various versions of Tableau.
• Involved in Creation, Manipulation and Supporting the SQL Server Database.
• Involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Worked closely with all team members in implementing Tableau BI tool in IT projects.
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Responsible for creating the user manual for the Business Unit.
• Worked on special assigned projects in Excel. Proficiently used excel functions like V-lookup, sum if, count if, pivot tables, macros in cash received analysis and cash forecast reports.
• Worked on motion chart, Bubble chart, drill down analysis using tableau desktop.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Configured User row level security for data in the Dashboard.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users.

Confidential

Business Analyst

Responsibilities:

• Documenting business and technical specifications.
• Worked with the US team members and delivered application in a timely fashion.
• Analyzed and prepared business requirement documents and functional requirement specifications.
• Created Use Case specifications,businessflow diagrams, Activity/State diagram and Sequence diagram.
• Monitored and reported on client problems and issues.
• Updated stakeholders on problem status and ensured speedy resolutions.
• Designed marketing material and sales presentations for assigned products.
• Participated actively on a regular basis in focus groups and steering committees.
• Analyzed and prepared business requirement documents and functional requirement specifications.
• Works with the cross-functional partners to support and assist in the development of long term implementation decision solutions, with technology as a key enabler.
• Documents and maintains all business process and workflow solutions. Documents business solutions with technology as an enablement.
• Owns, analyzes, and supports business process components of implementation through structured project delivery model.
• Tracked and managed defects along with analyzing data and provided reports.

Confidential

Business Analyst

Responsibilities:

• Designed marketing material and sales presentations for assigned products.
• Monitored internal and client use of available business tools for company policy compliance.
• Communicated with customer base on delivery schedule to plan.
• Completed troubleshooting tasks, including reconfiguring and communication validation, to ensure rapid resolution of data inaccuracies and prompt delivery of data to the customer.
• Performed a wide range of coaching responsibilities to promote knowledge acquisition within the department.
• Responsible for monitoring data quality of new sites from installation through to release into production.
• Determined validity and quality of initial data, through the scheduling and analysis of videos, using agreed upon data standards.
• Develops and maintains a comprehensive understanding of business processes and industry practices pertaining to retail pharmacy healthcare and delivery services.
• Coordinated meetings between IT team’s users and internal business analysts.
• Collaborated with key personnel in analyzing business requests for feasibility and costs.
• Provided support assistance to all functional business components.