SUMMARY:

• 9 years of IT experience interacting with business users and technical community for requirements gathering, software data modeling/design, solution delivery planning and communication on various BI/Data Analytics platforms.
• 5+ years of experience in Tableau Desktop/ Tableau Server 10.x/9.x/8.x/7.x, creating highly interactive Data Visualization Dashboards using feature such as Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM).
• In depth understanding of the Gap Analysis i.e., As - Is and To-Be business processes and experience in converting these requirements into Technical Specifications and preparing Test Plans.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Pareto Charts, Funnel Charts, Bar Graphs, Scatter Plots, Pie-Charts, Donut Charts, Bubble Charts, Funnel Charts, Heap Maps, Tree Maps, Geographic Visualization and other making use of actions, other local and global filters per the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Worked on integrating several data sources like BIGDATA, Excel, SSAS, and HADOOP into Tableau reporting.
• Hands on experience in Data migrating (using ETL tools like SSIS, DataStage) between homogeneous/heterogeneous systems as a part of Data Migration and Data Maintenance.
• Extensive experience in developing reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating various reporting components from multiple sources.
• Created TDE's using Hadoop as the data source and using Hive and Impala connectors.
• Highly experienced in whole cycle of DTS/SQL server integration services … Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Extensively used Tableau, Crystal Reports , Business Objects , SSRS , Informatica Power Center , SSIS , SQL Server, Oracle, Teradata, Hadoop and Hive .
• Exposure to SAP BW Multiprovider and Info set providers to get the BEx reports.
• Expertise in designing Tableau dashboards connected live databases like SAP HANA, SAP BW, Oracle and flat files.
• Having good knowledge on Alteryx Designer tool.
• Expertise in cleaning, transforming, inspecting and modeling large data to discover patterns, trends and behaviors, arrive at conclusions and support decision making process using Alteryx Designer.
• Strong experience in Business and Data Analysis, Data Profiling, Data Cleansing, Data Migration, Data Integration, and Metadata Management Services.
• Tested the migrated the code from Mainframes to Java environment.
• Responsible for project initiation documents preparation, WSR preparation, and PSM documents preparation.
• Provided support to project life-cycle development including architecture, design, develop, implementation, testing and enhancements
• Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snow-Flake, Fact and Dimension Table, Physical and Logical Data Modeling using Erwin 3.x/4. x.
• Have been working with various data sources such as Oracle, SQL Server, Teradata, Hadoop, ODBC and flat file sources.
• Extensively used Alteryx Designer for Data Preparation by blending data from multiple data sources and performing required cleansing operations and scheduled a tableau data extract in to the Tableau Server.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Teradata, Oracle, SQL Server, Tableau, Informatica, SSIS, Micro Strategy, Business Objects, SSRS technologies.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Good knowledge of Data Warehousing concepts, RDBMS and multi-dimensionalschema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases.
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).
• Worked in the onshore/offshore model, performing key responsibilities.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

BI Tools: Tableau (Desktop/Server), MicroStrategy, Hadoop, Hive, Business Objects, SSRS

ETL Tools: Informatics, Data Stage, Alteryx, Microsoft SQL Server Integrated Services

Front End Tools: MS Project, MS Office Suite (Word, Excel, PowerPoint), Visible Analyst

Databases: Teradata, Oracle, SQL Server, DB2, Sybase, Access, SAP HANA, SAP BW.

Document Management: Visual Source Safe, share point, Ultra Edit, Documentum

Defect Management tool: HP Quality Center, Test Director

Methodologies: Kimball/InmanData Modeling, Star/Snow flake Schema, Waterfall, Agile

Scripting Languages: Java Script, HTML, SQL, PL/SQL, and XML

Data modeling: Erwin, ER Studio

Microsoft office Application: Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft project

PROFESSIONAL EXPERIENCE:

Confidential, West Point, PA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Working with business users to analyze business needs for data extracts and reporting
• Worked in coordination with clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement
• Working with product owner and business analyst to solicit visualization requirements, recommending changes, creating prototypes, giving demos to the users.
• Working closely with business areas (especially Global Human Health) participating in all phases of projects, including ideation, data preparation, design, analytics, and communication.
• Design, develop, test, and maintain Tableau reports based on user requirements.
• Design and Execute data visualizations by developing dashboards using Tableau, understanding and translating business requirements
• Design, develop, test, and maintain Tableau reports based on user requirements.
• Draw upon full range of tableau platform technologies to design and implement proof of concept solutions and create advanced BI Visualizations.
• Develop highly interactive Data visualization tableau reports using multiple data sources and custom SQL queries.
• Developed optimized data collection and qualifying procedures.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Improved the Performance of data extracts created from Plutora using contexts and Action filters instead of quick filters.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Develop complex tableau reports using parameters, sets, groups, actions, and customized calculated fields
• Write queries, views, or stored procedures to extract data
• Develop wide variety of tableau dashboards with bar charts, donut charts, line graphs, Heat maps, Tree maps. Pie Charts, Gauge charts.
• Conduct the Dashboard review sessions with the end-users before publishing the dashboard on to the tableau server.
• Testing the dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Extensively involved in doing user acceptance testing (UAT).
• Executed and tested required queries and reports before publishing dashboards.
• Provide the documentation to the reports build in Atlassian confluence
• Creating of Tableau functional design document.
• Provide to internal team and assist with expert knowledge on best practices for creating Tableau Reports.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard
• Monitor all KPI’s (Key Performance Indicators) for various dashboards, identify root cause for all technical issues, and recommend solutions.

Environment: Tableau 10.5, Jira, Confluence, Visio, Oracle 12 C,MS Excel, MS Power Point, SAP HANA, Informatica.

Confidential, Weston, MA

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• 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.
• Worked in coordination with clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Deployment of Tableau Server in clustered environment by mapping server nodes to primary machine.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• 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 large data sets within Hadoop ecosystem performing analysis using Hive.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Extensively used Hadoop Map Reduce Job tracker to monitor the jobs.
• Built the DW environment using the Tableau and Hadoop Hive tables with Terabytes of data.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Designed Tableau dashboards connected to Oracle Server, SAP BW(Live), SAP BW(extract) and SAP HAN
• Extensively used Alteryx Designer to Parse the data and made different Predictive analysis to gain deeper insights.
• Created database joins and data blends in Alteryx for Tableau Desktop.
• Extensively used tableau data blending connecting to multiple data sources like Teradata, Hortonworks Hadoop Hive and Cloudera Impala.
• 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.
• Data cleansing is done using SQL queries and joins in the Alteryx and performed exploratory and statistical analysis.
• Scheduled incremental data refresh in to the tableau server daily using the Alteryx designer.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Improved the Performance of data extracts created from Hadoop using contexts and Action filters instead of quick filters.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• Validated the data in SAP HANA tables with source
• System data to ensure accurate data for reporting.
• Designing and implementing SAP HANA models (attribute views, analytical views, and calculation views) on the extracted survey data for reports
• Worked in Business Intelligence integration wizard to integrate query templates, BEx Query Designer, BEx Analyzer. Created numerous time calculation customer exit variables in project management for reporting in CMOD using ABAP (Advanced business application programmed) language.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Migrated data from legacy system (text-based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users
• Pushed all the created stored procedures and functions to the development, and production servers.
• Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts
• Created Process chains in SAP BW for the data flows and scheduled to run as periodically.
• Extracting and loading data from source systems like ECC, flat files and other source systems into SAP BW. Monitoring process chains (data loads from various sources)
• Involved in scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau 10.x/9.x (Desktop/ Server), Hadoop, MS SQL Server 2012, Alteryx, SSIS, SSRS,SAP Hana, Java Script, Oracle 10g, Erwin, Microsoft office Suite (Office, Excel, PowerPoint)

Confidential, Austin, TX

Tableau Consultant/ Sr. Data Analyst

Responsibilities:

• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developed predictive statistical models using statistical analysis and other predictive modeling techniques.
• Build and analyze queries from databases using SQL.
• Participated in weekly staff meetings and collaborate with various teams to develop and support ongoing analysis.
• Conducted data accuracy analysis and support stakeholders for decision-making.
• Analyzed data using advance Excel functions such as Pivot Table, Charts, Graphs and Macros.
• Handled the company’s day-to-day reporting and data access needs
• Developed and implemented a business intelligence strategy that ensures the system data is secure, integrated and accessible to staff
• Analyzed and designed Logical and Physical data models using E-R diagrams
• Worked across departments to identify and understand key business questions, and standardize key metrics and measures
• Worked with structured and unstructured data sources using Big Data technologies (Hadoop, Spark, etc.) across the solution cycle
• Extracted data from SQL Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration
• Moved data from one database to other database, Used SQL*Loader for data migration.
• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes
• Developed advanced analytical data modeling and reporting procedures through the use of SQL data joins, Excel VBA automation, and File Maker Pro reports.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Written several scripts using Java script for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Analyzed and designed Logical and Physical data models using E-R diagrams.
• Redesigned the data source having data from different sources into one SQL Server and to tableau.
• Analyzed and gained understanding of the underlying data and generated tableau dashboards with forecast and lines.
• Worked on Information Design Tool and Web Intelligence which has been used for reporting from Hana.
• Used Data Blending and combined Adobe Marketing Cloud data with other aggregated data, to compare and analyze data in different perspective using Alteryx.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• ETL implementation using SQL Server Integration Services (SSIS). Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems (OLTP), highly-usable de normalized reporting systems (OLAP) as well as staging areas and data marts.
• Effectively used data blending feature in Alteryx to combine the data from different sources like SAP Lynx, Vision etc. into a single report.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Configured AD security using tableau server
• Utilized Alteryx for blending data from multiple databases to create a single source of truth.
• Responsible for authorizing the users based on their privileges.
• Connected to Cloudera Hadoop using Hive/Impala native connectors and extracted datasets to create Performance Management Dashboards.
• Involved in migration activities related to Tableau across the environments
• Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.x.
• Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application.
• Worked with Teradata database and extracted data using Alteryx and developed POCs by building reports and dashboards using Tableau 9.2 to demonstrate quick wins.
• 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.
• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatic power center.
• Used Sqoop to import data from a relational database management system (RDBMS) such as MySQL or Oracle into the Hadoop Distributed File System (HDFS), transform the data in Hadoop MapReduce, and then export the data back into an RDBMS.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Executed and tested required queries and reports before publishing.
• Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.
• Designed and created Report templates, bar graphs and pie charts based on the customer data

Environment: Tableau 9.x/8.x (Desktop/Server), SQL Server 2005/2008 R2, SAPHana, Hadoop, Hive, SAP BW, Alteryx,MS Access, MS Excel, MS PowerPoint, Informatica, VBScript, HTML, XML, Visio.

Confidential, Lakeland, FL

Data Analyst/Tableau Developer

Responsibilities:

• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro and managed the concurrence of the parties involved with respect to the evaluation criterion.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Database Servers.
• Responsible for creating reporting data model as per the requirements. Experienced in constructing UX (User Experience) frameworks for desktop and mobile platforms. Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case.
• Used SQL queries for organizing and extracting data from Teradata databases to suffice adhoc data requests for Business Users.
• Captured Data flow diagrams and formatting of the data flowing through interfaces.
• Accumulated system requirements for analytical reports across different subject areas like Finance, Marketing, Merchandising users to convert Micro Strategy reports to Tableau reports.
• Designed standardized DataMart with aggregated tables and views to suffice data sourcing requirements for Tableau reporting solutions.
• ETL implementation using SQL Server Integration Services (SSIS). Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems (OLTP), highly-usable de normalized reporting systems (OLAP) as well as staging areas and data marts.
• Creating Scripts to load data from one server to another server using Alteryx.
• Configured the Data mapping between Oracle and SQL Server to Teradata.
• Designed and Developed single reports instead of multiple reports as in Tableau by implementing row level security and user filters to cater multiple users with different access levels to the data.
• Conducted meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Implemented Data Representation using Visualization Techniques in Tableau using Alteryx (Graphs, Charts etc.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Facilitated user acceptance testing and test strategies with Tableau power users.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests).
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).

Environment: Tableau8.x/7.x ( Desktop/ Server), Teradata, Share Point, TFS, Agile-Scrum, Alteryx,Informatica, Micro Strategy, Autosys, UNIX, SQL Server, Erwin, MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Analyzing the business requirements and building logical and physical data models
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Worked on SAP BI on HANA for reconciliation reporting using ODP
• Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Create and Monitor workflows using workflow designer and workflow monitor.
• Performing data management projects and fulfilling ad-hoc requests per user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Identify & record defects with required information for issue to be reproduced by development team.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Flexible to work late hours to coordinate with offshore team.

Environment: Teradata Oracle, PL/SQL, SQL Server 2008, MS SQL, Informatic a, Micro Strategy, Erwin, DB2, HP Open View, Lotus Notes, Windows XP, SAP HANA, MS Office Suite (Word, Excel, PowerPoint).

Confidential

SQL BI Analyst / Developer

Responsibilities:

• Created and/or strengthen systems for data collection, management, reporting and analysis. Advised the agency on technology needs to maximize efficiency and support a culture of managing to data
• Assisted in the creation and documentation of the business processes for data collection, entry, reporting, review and use of data to strengthen performance management
• Implemented logical and physical data modeling
• Developed PL/SQL stored procedures for the end-user report requirements
• Created crystal reports on the stored procedures and exported the Business Objects reports to WEBI, to be viewed by all users on the intranet and extranet
• Created queries for multidimensional analysis using slice, dice and drill modes
• Analyzed complex business needs presented by the user community and/or clients and recommended technical solutions to improve the reporting environment
• Accomplished Performance tuning of SQL queries and stored procedures using Database tuning advisor in SQL Server
• Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches
• Created SSIS packages and used Analysis Services processing task to update the cube with current data
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Created report snapshots to improve the performance of SSRS
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures

Environment: Windows XP/2000 Server, SQL Server 2000/2005, SSRS, Crystal Reports, BO Web Intelligence, MSOffice, XML, T-SQL, SSIS, SSRS.