SUMMARY:

• 4 years of experience as a Tableau Developer/ Admin, 9 years of experience in the Business Intelligence and Databases arena as a Data Engineer, Data Analyst, and Business Intelligence Analyst in various Business Domains. Over 18 years of experience in the Information Technology Industry with different capacities, including Customer Services and Business Analysis.
• Core expertise in Developing Reports and Dashboards, Data Visualization, Visual Analytics, Data Mining, Business Analytics, Data Analysis, Data Quality management, GAP Analysis and Master Data Management (MDM) using Tableau, Excel, MS SQL and Microsoft BI stacks (SSIS, SSAS, SSRS).
• Experienced in all phases of SDLC of a Project Development Life Cycle through Requirements gathering and analysis, Planning, Design, Coding, Testing and Validation, Deployment, Maintenance and Production Support.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems and effectively develop technical solutions.
• Solid background of high education, multiple skills and strategic business sense to meet the challenges of fast - paced industry.
• Able to manage multiple tasks at once and prioritize work.
• Ability to work under tight deadlines and handle multiple/detail-oriented tasks
• Ability to influence at all levels of the organization such as executives, managers, SME and development teams.
• Effective liaison between business analyst and the technical team to facilitate technical and design specifications, set expectations and coordinate team members utilizing team work and collaborative skills.
• Worked in Agile, Scrum, Iterative, Waterfall development & project methodologies.

TECHNICAL SKILLS:

TECHNOLOGIES AND ENVIRONMENTS: SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 , Windows 2000/2003/2007/2008/2010/2012 , Microsoft BI Stack (SSIS, SSAS, SSRS), Microsoft Office Suite, Microsoft Project, Microsoft Visio, Tableau, Power BI, R, Sapience, T-SQL, Erwin, UML, Rational Rose, SharePoint, LiteSpeed, Commvault, Red-Gate, GoldenGate, SQLSentry, Attunity, JIRA, Clarity, ServiceNow, GCP, Azure, AWS, Waterfall and Agile/ Scale Agile Framework (SAFe), Agile Scrum Methodologies.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Tableau Developer/ Administrator

Responsibilities:

• Installed and configured Tableau Server 2018.1 on Distributed High Availability- Multi Node environment and upgraded to the current version Tableau Server 2018.2. Involved for Tableau Server Sizing, Clustering and Load Balancing, Troubleshooting, monitored memory and CPU utilization of reporting servers, Managing Server sites and projects, Scheduling, Server Health Check and Server Security management. Installed and Configured Tableau Services Manager (TSM). Deployed Tableau Bridge for live connection on-premise data source to the Tableau Online Server.
• Built Reports, Dashboards, Workbooks, Storyboards with implementing various functionalities such as Actions, Marks, Parameters, Highlighters, Bin, Sets, Groups, Hierarchy, Filters, Interactive Filters, Content Filters, Calculated Fields, Table Calculations, LOD Expression, Date Calculations, Logic Calculations, Aggregation functions, Maps, etc. and published to the Tableau Server for organizational use. Identified and organized Dimensions and Measures. Set up data security with user filters to restrict access on the reports, workbook. Managed published Dashboards and Data Sources in Tableau Server.
• Extracted data and built data sets from various Data Sources such as SAP HANA, SAP BW, Teradata, Oracle, MS SQL, PostgreSQL, Cloud, Salesforce, Web, through Data Extract API, Adobe Analytics, Excel, Splunk, Cubes, PDF, through Data Blending and SQL Queries customization and Published Data Sources to the Tableau Server on Live as well as on Extract connection mode.
• Implemented Tableau command line utilities: TABCMD for common tasks automation and TABADMIN for Server administration-configuration on Tableau Server.
• Configured Tableau Server for Data connections, Alerts & Subscriptions, SMTP, SSL, SAML, Security settings. Managed Content, Users, Site Roles, Groups, Schedules, Tasks, Status, Web Authoring on Web Interface Tableau Server.
• Installed Tableau Prep and utilized Tableau Prep functionalities to make data ready for Analysis and Visualization.
• Visualized data into Charts, Graphs, Dashboards and Reports form. Analyzed the pattern of data to get insights.
• Created and maintained Tableau Data Elements Mapping Documents and Metadata, Data Dictionary Documents.
• Dashboards and Data Sources promoted in between Development to Production environments.
• Managed Tableau License and Vendors.
• Enhanced the existing Dashboards, Data Sources and supported to the various department of the organization, Educated to the end users on Tableau’s product Ecosystem.
• Integrated Tableau with Web Applications, R, Mobile App.
• Analyzed data to identify the trends, insights, root causes and KPIs.
• Developed Functional and Business Requirement Documents (BRD and FRD), Test Case Scenarios & Test Plan Documents, Requirements Traceability Matrices (RTM), Use Cases, User Stories, Issue Logs and other Documents as needed. Performed Gap Analysis. Performed Integration Testing, System Testing, Functional Testing, Regression Testing, End-to-End Testing, User Acceptance Testing.
• Coordinated and worked with key stake holders, business owner, product owner, onsite and offshore development team to implement the solutions and projects.
• Worked in Agile Development environment as Scrum methodology

Confidential, Atlanta, Georgia

Sr. Data Analyst- Tableau Developer (Consultant)

Responsibilities:

• Analyzed financial transactional data and developed summary reports, interactive visualizations, reports, workbooks, dashboards, storyboards, and KPIs using Tableau. Managed published Dashboards and Data Sources in Tableau Server.
• Developed Functional and Business Requirement Documents (BRD and FRD), Test Case Scenarios & Test Plan Documents, Requirements Traceability Matrices (RTM), Use Cases, User Stories, Issue Logs and other Documents as needed. Performed Gap Analysis. Performed Integration Testing, System Testing, Functional Testing, Regression Testing, End-to-End Testing, User Acceptance Testing.
• Developed Metadata, Data Dictionary, and Master Data Inventory using Profisee and Microsoft MDS. Generated Golden Records using Profisee and implemented across the Organizational Data sources
• Worked with RSCL (Risk, Security, Compliance and Legal) team for Data Governance and Data policy.
• Developed ETL FDD & Data Mapping documents for Data migration from on-Premise to Google Cloud Platform (GCP).
• Developed dynamic ETL SSIS packages to migrate date from on-premise source database to the GCP platform.
• Developed Dashboards with Google Cloud Platform-GCP (Big Query) using Tableau.
• Identified relevant and available data sources, consolidated the databases and analyzed data across the databases. Analyzed data to identify the trends, insights, root causes and KPIs.
• Assisted to the program director, project manager, VP and coordinated meeting with vendor and internal clients, documented the meeting minutes and distributed to the key team members.
• Worked with Confidential and Change Advisory Board (CAB) to standardize database systems across the organization.
• Coordinated and worked with key stake holders, business owner, product owner, onsite and offshore development team to implement the solutions and projects.
• Developed Standard Operation Procedures (SOP) documents and provided training to the users on the products.

Confidential, Atlanta, Georgia

Sr. BI Analyst - Tableau Developer

Responsibilities:

• Built Reports, Dashboards, Workbooks, Storyboards with implementing various functionalities such as Actions, Marks, Parameters, Highlighters, Bin, Sets, Groups, Hierarchy, Content Filters, Filters, Interactive Filters, Calculated Fields, Table Calculations, LOD Expression, Date Calculations, Logic Calculations, Aggregation functions, Maps, etc. and published to the Tableau Server for organizational use. Identified and organized Dimensions and Measures. Set up data security with user filters to restrict access on the reports, workbook.
• Extracted data and built data sets from various Data Sources such as SAP HANA, SAP BW, Teradata, Oracle, MS SQL, PostgreSQL, Cloud, Salesforce, Web, Adobe Analytics, Excel, Splunk, Cubes, PDF, through Data Blending and SQL Queries customization and Published Data Sources to the Tableau Server on Live as well as on Extract connection mode.
• Developed KPIs, monitor key organizational and operational measures, and provide visibility of performance throughout the organization and customers.
• Analyzed business problems and recommended its solutions, performed statistical and quantitative analyses generated reports, summarized data by using histograms and descriptive statistics, and provided recommendations.
• Created source-to-target mapping documentation and define data tables, columns, and metadata.
• Proactively identified gaps and opportunities and provided recommendation for business actions.
• Analyzed Customer Order Management (COM), Delivery Management System (DMS) and other various data sources to find out the root cause of spiking the number of incident tickets generated from each store and turned the business problem into the measurable data problems.
• Coordinated and worked with key stake holders, business owner, product owner, onsite and offshore development team to implement the solutions and projects.

Confidential, Atlanta, Georgia

Data Engineer

Responsibilities:

• Designed, developed and implemented enterprise relational OLTP databases in conceptual, logical and physical layers using Erwin and MS Visio tool across the organization. Modified and standardized the existing transactional databases with enforcing data quality rules and master data management standards.
• Developed and implemented database objects, schema objects, triggers, stored procedures, functions, data dictionary views and meta-data; performed database performance tuning, query optimization and enhanced the existing database in MS SQL.
• Designed, Developed and implemented Data Mart/ DW using Star-Schema with Facts, Dimensions and Hierarchies.
• Designed, developed and implemented dynamic ETL SSIS packages using various dimensions with enforcing data quality and master data management rules. Loaded data from various sources to the staging and data warehouse environment.
• Analyzed Finance, Gift Cards and payments processing data and created traceability matrix with best practices and presented to the stakeholders and clients using Tableau Analytics BI tool.
• Implemented SSAS on Multidimensional and Tabular model for Analytics.
• Developed data governance policy and strategy for Master Data Management, Data visualization, Data Change, Data Sourcing, Data validation and Data Auditing.
• Worked in Agile, Scrum, and Iterative project methodologies.

Confidential, Atlanta, Georgia

Sr. Business Data Analyst- Lead

Responsibilities:

• Designed, developed and implemented enterprise relational OLTP databases in conceptual, logical and physical layers using ErWin and MS Visio tool across the organization. Modified and standardized the existing transactional databases with enforcing data quality rules and master data management standards.
• Designed, developed and implemented dynamic ETL SSIS packages using various dimensions with enforcing data quality and master data management rules. Loaded data from various sources to the staging and data warehouse environment.
• Developed and published interactive dynamic reports, sub reports, dashboards, and data visualization to support business decisions using SSRS.
• Responsible for managing data quality, metadata management, master data management, data change management, data sourcing, developing data governance policy and standards, data auditing and risk management.
• Developed and implemented database objects, schema objects, triggers, stored procedures, functions, data dictionary views and meta-data; performed database performance tuning, query optimization and enhanced the existing database.
• Conducted impact analysis of technology changes on business processes and existing technology.
• Facilitated collaborative system and data design sessions with the user community, technical architecture resources and development resources.
• Assisted in systems and business process support across multiple internal projects (Strategic and Tactical Projects).
• Worked in Waterfall development and projects methodology.

Confidential, Atlanta, Georgia

Business Data Analyst

Responsibilities:

• Performed backend support for applications, data validation, release management, requirements gathering, quality control and data audit, monitoring SQL server jobs.
• Developed and implemented database objects, schema objects, triggers, stored procedures, functions, data dictionary views and meta-data; performed database performance tuning, query optimization and enhanced the existing database.
• Performed On-site and Off-site Web Analytics to collect and analyze data using Google Analytic and developed KPI and measures for digital marketing campaigns.
• Conducted data analysis to provide insight into marketing and product opportunities within targeted consumer segments.
• Synthesized analysis findings and communicate to internal partners to drive further understanding of the consumer lifecycle and ultimately influence revenue projections
• Developed ETL process using SSIS and loaded data from various sources to the Staging and Data Warehouse.
• Analyzed and summarized data using SSAS Cube and developed interactive and dynamic reports using SSRS.