SUMMARY

• Overall 8 years of IT experience in Business Analysis, System Analysis, Data analysis, software design, development, testing and maintenance of BI/Data Warehousing environment
• Worked on different Domains like Financial, Food Science, Insurance and Retail industries.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.2,9.x, 8.x, 7.x 6.x and other BI technologies like Business Objects.
• Expertise in designing and developing dashboards using Tableau 10.2,9.x/8.x/7.x/6.x (Desktop/Server) using data from multiple sources like Oracle, SQL Server, Amazon Redshift, DB2 and Flat Files.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.
• Interaction with the Power Users &Business users during the various stages of the project lifecycle to identify various KPI’s and designed solutions to enhance business decision making.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Experience in developing rich interactive Tableau reports and Dashboards using various visualizations like Chart - Box (Drill Down, Drill up & Cyclic Grouping), Heat Maps, Tree Maps, Bubble Charts, Reference Lines, Dual Axes, Line diagrams, Bar Graphs, Geographic Visualizations (Detailed and filled in maps), etc.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Actions, Parameters etc., in Tableau.
• Extensively worked with various database systems like Oracle, Teradata, MS Access, Flat files, XML and SQL Server.
• Proficient in creating the Design Documents for loading data into Data Warehouse and Data Mart tables.
• 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.
• Exposure in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins and query writing. Optimized query performance by creating indexes
• Expertise in developing Parameterized, Chart, Graph, Dashboard, Scorecards, Drill-down and Drill-through reports using SSRS.
• 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 and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

Analytical Tools: Tableau (Desktop/ Sever/ Reader), Business Objects, SSRS, SSAS, Google Analytics (Adobe Site Catalyst).

ETL Tools: Data Stage, Informatica, SSIS

Databases: Teradata, Oracle, DB2 UDB, MS-SQL Server, Hive

Requirements Management: Requisite Pro, Microsoft Office (Access, Excel)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management: TFS, Documentum, Visual Source Safe, Share point, Ultra Edit

Methodologies: Agile, Waterfall

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

Languages: SQL, PL/SQL, JavaScript, Python, HTML, XML.

Operating System: Windows, IOS, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Tableau Developer/SSRS Developer

Responsibilities:

• Analyzed business user requirements, data and designed software solutions in Tableau desktop based on the requirements.
• Fully understand and translate the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.
• Used the Tableau desktop for the dashboard development activities such as creating the visualizations, calculations, calculated fields, hierarchies, filters, Actions.
• Involved in the daily meetings of the project design and development using scrum project methodology.
• Experience with Scheduling Tableau Extracts, working with Multiple Data sources using Data Joining and Data Blending.
• Created SSRS reports using Visual Studio 2015 and deployed reports to Report Server.
• Worked on Troubleshooting performance issues and fine tuning queries and stored procedures using temp tables.
• Upgraded SSRS Reports from 2012 to 2015.
• Used Jira for defects tracking.

Environment : Tableau (Desktop/Server) 10.2, SSRS, SQL Server, TOAD, Windows, Git, MS Office (Access, Excel).

Confidential, Urbana, MD

Sr. Tableau Developer/Business Analyst

Responsibilities:

• Responsible for driving Joint Application Development (JAD) Sessions to gather Business Requirements from Key Stakeholders
• Translated business requirements to technical design specification documents
• Transformed MDX (Multidimensional Expressions) query from cubes to SQL.
• Developed interactive Dashboards and reports using Tableau server.
• Developed multiple test cases for calculated fields and developed SQL.
• Compared Dashboards and reports developed in Tableau.
• Translated business requirements to technical design specification documents
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, Hive and MS Excel.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.
• Provided tableau training on the Survey dashboards built to the end users.
• Extensively involved in doing user acceptance testing (UAT).

Environment : Tableau (Desktop/Server) 10,9.3, Oracle, SQL Server, Amazon Redshift, Hive, TOAD, Teradata SQL Assistant, Windows, MS VISIO, MS Office (Access, Excel).

Confidential, Hopkins, MN

Sr.Tableau Developer/ Data Analyst

R e s po n s i b i l i ti e s:

• Work with the businesses and project team members (Architect, Solution Designer, and SME’s) to understand and create reporting solutions. This includes prototyping potential solutions, or modifying existing work to meet new or changing needs through the use of development standards, processes, and tools available to the team.
• Conducted JAD sessions, interacted with the End users on a regular basis for resolving issues pertaining to the reports, attending weekly status meetings.
• Understanding of using structured data, dimensional models or cubes and various forms of ETL for reporting.
• Created data mapping documents for the worksheets to be built.
• D e si gned and de v e l o p ed a b u s i n e ss i nt e l l i ge n ce d a s h board u s i ng T ab l eau s o f t w a r e a l l o wi n g e x ecut i v e m a n ag e m e n t t o v i e w c u rre n t and pa s t p er f o r m ance sa l es t ren d s, f or eca s t s a l e s, and t o t rack e x i s t i ng c u s t o m er s a l e s .
• A na l yz e bu si n e ss r eq u ir e m en t s f r om B l ack B ox T e s t i n g pe r sp e c ti v e, b u s i n e s s p r o cess a s y s t em a r ch i t e c t u r e / de s i g n
• M ai n t a i ned docu m en t s f o r chan g e r e q ue s t and i m p l e m en t ed p r o ced u r es f o r t e s t i ng chan g e s .
• A c ti v e l y t r ac k ed s c he d u l e, c l e ar a nd c r i sp c o mm un i ca t i ons w i t h k ey r e s o u r c e s, s t a k e ho l d e r s and SM E s t o k eep e v e r y one i n v o l v ed i n t he p r o j e c t on t he s a m e pa g e, m il e st o n e t r ac k i ng and a v o i d i ng s c o p e c r eep i s s ues.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services SSRS
• Developed T-SQL queries, stored procedures, and user defined functions.
• Developed various operational Drill-through and Drill-down reports using SSRS
• Used Tableau URL Actions to navigate from the main Dashboard to detail Reports
• Created Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company.
• Created and edited the update schedules, managed scheduled update tasks on Tableau server.

Environment: Tableau(Desk/Server) 8.2, Oracle, SQL Server, SSRS, T SQL, Toad, Informatica, Power Designer, Mercury Test Director, Microsoft Office (Access, Excel,).

Confidential, Pleasanton, CA

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Facilitated interview sessions to identify Business rules and Requirements and then documented in a format that can be reviewed and understood by the whole team.
• Provided mock up visuals to speed up requirements visualization.
• Translated business needs into technical requirements.
• Worked closely with business and data teams to gather key stakeholder requirements and convert them into technical specifications.
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Published the workbooks and data sources to the tableau server for further review as well as to enable users to do slicing and dicing on data to derive more insights.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Developed and implemented SSRS reports with multi-parameter, chart, sub-report and interactive sorting capability for administration and accounting department.
• Administered user, user groups, and scheduled instances for reports.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Performance tuning of reports and dashboard.
• Resolved the bugs reported by QA team in existing dashboards.
• Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Oracle, Sybase).
• Effectively used data blending, filters and hierarchies.
• Creation of packaged workbooks (twbx) for end-users.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Effectively used bar chart, bubble chart, maps, and heat maps to answer business questions.
• Work with product management to determine, validate and implement a long-term strategy for Tableau.
• Conducted training session for business users.
• Scale up/ Scale out Tableau Server to meet the requirements of the company.
• Administered Tableau server and created tab admin scripts for automating backup procedures through windows scheduler.
• Responsible for implementation of Tableau desktop and server.
• Implemented data security by creating user filters.
• Conducted Business Acceptance and user Acceptance testing and sign-off meetings.

Environment: Tableau (Desktop/Server) 7.0, SSRS, Oracle, Toad, SQL Server, MS Office Suite (Excel, PowerPoint).

Confidential, Charlotte, NC

Data Analyst/ Tableau Developer

Responsibilities:

• Gathered Business Requirements by Conducting User interface sessions and documented their query, business analysis & reporting needs. Understood data and business logic with reports.
• Understanding source systems and Extracted data from various sources (SQL Server, Oracle, text files and excel documents).
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica
• Optimized performance tuning by SQL.
• Finding Work arounds for the application front end that dynamically hides selected areas of the dashboard on Tableau depending upon user privileges.
• Helped client reporting teams migrate from traditional static Excel reporting to a more interactive and powerful Tableau dashboard solution.
• Analyzed relational database model according to business requirements to create Tableau associative data model.
• Created dashboards utilizing Tableau functionality like sets, parameters, groups etc.,
• Extensively created dashboards with multiple worksheets, linear graphs, pie charts and crosstab.
• Research and troubleshoot technical problems and provided ongoing Tableau based application consultation to the development team.
• Worked on data validations and worked with peer for code review
• Provided demo of Tableau functionality for prospective Line of Business and actively involved in training end users on Tableau functionality.
• Extensively used data blending, embed functionalities in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.

Environment: Tableau (Desktop/ Server) 6.0, Teradata, Oracle 11g, SQL Server 2012, Informatica Power Center, and Toad.

Confidential

SQL Developer

Responsibilities:

• Promote emphasis on tools and process to facilitate analytics
• Involved in the development of system test plan which included scope, objectives, resources, timelines etc. of the testing effort.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Analyzed the reporting service tool provided by Microsoft to generate reports using Oracle and SQL as backend and developed a similar application with SharePoint as backend.
• Handled unit and system integration testing
• Prepared a help guide to system usage for the convenience of end users.
• Participated in meetings and Database Analysis with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application Database Tables, along with checkpoints for testing / verification.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing. Developed user test cases and validated test results during user acceptance testing.
• Assured that all Artefacts are in compliance with Department’s SLC Policies and guidelines.
• Used Test Director for Defect Tracking and prioritizing defects and for enhancements after base lining the requirements.

Environment:: Oracle, SQL Server, SQL/PLSQL and Windows 2000.