Tableau developer/Data Analyst

Mounika Sattenapalli

Tableau Developer/Administrator /Data Analyst

Phone: 814-***-****

E-mail: *************@*****.***

PROFESSIONAL SUMMARY

Over 8+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms. 4 years of extensive Tableau Experience in Tableau v6.x/7.x/8.x/9.x/10.x (Desktop, Server, Reader, Mobile, Online, public) as a Developer and Analyst

Extensive experience in various DB/DW/BI technologies including Tableau, OBIEE, Micro Strategy, SSRS, Unica, Google Analytics, Alteryx, Informatica, SSIS, Teradata.

Competent in Software Development Life Cycle methodology (SDLC) and Software Testing Life Cycle (STLC), which includes RUP, Agile, and Waterfall Methodology.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Strong knowledge of Business/Process Data flow in organizations and experienced in data modeling concepts.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies,

Prepared Dashboards using calculations, parameters in Tableau

Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.

Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), SQL Server MS Access and client/server applications.

End to end experience in designing and deploying data visualizations using Tableau.

Expertise in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Micro Strategy, SSRS, Informatica and Alteryx.

Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

Experience with SAS BASE, SAS MACRO, SAS ETL, SAS OLAP, SAS EG.

Experience in using SAS for data entry, retrieval and management thereby performing statistical and mathematical analysis.

Expertise in generating reports using global variables, expressions and functions for the reports.

Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.

Extensively worked in OLTP & OLAP environments that include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.

Experienced in tuning long running SQL queries for better performance.

Experience in using SQL Server 2008 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle, Lotus notes and DTS (i.e. Import and Export) also worked to Automate the ETL operations. (Automate the SSIS Packages and Import, Export).

Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level Data Analysis and Data Management Services.

Experience with Alteryx to collect the required data from large complex databases.

In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.

Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

Experience in Technical Support, Troubleshooting, Report Design and Monitoring of system usage.

Technical Skills

Data Modeling

Power Designer, MS Visio, Erwin, ER Studio

Databases:

Teradata, MySQL, MS SQL Server, Hive, ORACLE, IBM DB2, MS Access, Amazon Redshift

BI / Reporting Tools

Tableau Desktop v10.x/9.x/8.x/7.x/6.x, Tableau Server, tableau admin v10.x/9.x/8.x/7.x/6.x, Tableau Online, Tableau Reader, Tableau Mobile, Tableau Public, Crystal reports XI/2008, Business Objects XI R1/R2/R3.x/4.x, BO Universe Designer, BO Web intelligence, SAP BO, Micro Strategy, SSRS, Unica, Google Analytics (Adobe Site Catalyst).

Front End Tools

Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, Openproj, JIRA

ETL Tools

Informatica, SSIS, Data Stage, Alteryx

Document Management

Documentum, SharePoint, Ultra Edit

Programming Languages:

SQL, PL/SQL, HTML, Java/J2EE, ASP.net, JavaScript, CSS, XML.

Defect Management tool

HP Quality center

Versioning Tools

CVS, Tortoise SVN, GIT

Methodologies

Data Modeling – Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Service Management Tool

HP Service Manager, CA Service Desk

Professional Experience

Ups, Baltimore, MD Aug 2017- Till date

Tableau Developer / Data Analyst

United Parcel Service (UPS) is an American multinational package delivery company and a provider of supply chain management solutions. The global logistics company is headquartered in the U.S. city of Sandy Springs, Georgia, which is a part of the Greater Atlanta metropolitan area.

Responsibilities

Perform Tableau Server admin duties add users/groups from Active Directory; instances in Tableau Server.

Gather and analyze the business requirements and then translate them to technical specifications.

Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.

Gathered SSRS reports requirements and created in Tableau.

Prepared and published customized reports/dashboards.

Effectively used data blending feature in Tableau.

Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using Micro Strategy Desktop.

Converted SSRS and Micro Strategy reports into Tableau.

Created different Action filters, Parameters and calculated fields to create most complicated environments.

Worked with Tableau administrator in managing Production, Test and Development .

Analyzed business requirements, translated it into SAS and SQL. Coded and tested complex SAS reports.

Used data blending feature in tableau and defined best practices for Tableau report development.

Responsible for Developing Dashboard and preparing ad-Hoc Reporting.

Created and manipulating large datasets using SAS and have worked on business forecasting and decision support.

Created report on Cloud based environment using Amazon Redshift and published on Tableau

Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau

Integrated dashboards with live Connection in Microsoft PowerPoint.

Desktop to validate static and dynamic data for data validation.

Worked with Master Data Management architects to develop data models.

Created SharePoint site to store all tableau workbooks and data source.

Embedded tableau views in to SharePoint and handled tableau admin activities granting access and hanging extracts and installations.

Created Custom Hierarchies to meet the Business requirement in Tableau.

Published Packaged workbooks.

Created reports in Tableau using SSRS SQL Queries and Stored procedures.

Converted Pearl Script Query in to SQL Query for ETL.

Executed and tested required queries and reports before publishing.

Created reports using Custom SQL for complex report views.

Used Erwin for relational database and dimensional data warehouse designs.

Writing complex queries using Teradata SQL.

Participated in weekly meetings, reviews, and user group meeting as well as communicating with

Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL mappings in Informatica.

Environment: Microsoft SQL Server 2013, Alteryx, Teradata, Tableau 9.x/10.x, Tableau Server 9.x/10.x, Amazon Redshift, SAS, SQL, ERWIN r8, MDM, Toad, SSRS 2013, Informatica, Oracle, Salesforce, SharePoint.

DC Government (Office of Chief Technology Officer) June 2016 –July 2017

Tableau Developer/ Data Analyst

Office of Chief Technology Officer (OCTO) is the central technology organization of the District of Columbia Government. OCTO develops, implements, and maintains the District’s technology infrastructure; develops and implements major enterprise applications; establishes and oversees technology policies and standards for the District; provides technology services.

Responsibilities

Developing and maintaining high level overview of the project and design flows using MS Visio.

Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.

Building, publishing customized interactive reports and dashboards using Tableau.

Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.

Effectively used data blending feature in tableau and defined best practices for Tableau report development.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Executed and tested required queries and reports before publishing.

Administered user, user groups, and scheduled instances for reports in Tableau.

Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.

Provided support for Tableau developed objects and understand tool administration.

Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.

Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.

Created Custom Hierarchies to meet the Business requirement in Tableau.

Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.

Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0

Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.

Created SharePoint site to share project related documents.

Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: UDT, WEBI-BI: SAP BW Query Designer, Analyzer, Teradata SQL Assistant, Tableau 9.x, Teradata, SAP Business Objects 4.1/4.0, IDT, Teradata Administrator, SQL BI Suite (SSRS / SSAS) 2012, SharePoint

North American Savings Bank, Overland Park, KS Feb 2015 –May 2016

Data Analyst/Tableau admin

North American Savings Bank is one of the leading providers of banking and financial services and it provides retail, investments, mortgage loans, consumer loans and commercial loans. In NASB we involved in a project called “Response Management System”.

Responsibilities

Created views in Tableau Desktop those were published to internal team for review and further data analysis and customization using filters and actions.

Involved in reviewing business requirements and analyzing data sources form Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.

Involved in creating interactive, parameterized dashboards by extracting data from various sources using data blending and applying actions - filter, highlight and URL.

Involved in Data profiling, data analysis and data visualization with SAS new features, tools and technologies including SAS Visual Analytics.

Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.

Creating visually compelling and actionable interactive reports and dashboards.

Developed different reports and dashboards using SAS Enterprise Guide.

Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time.

Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.

Follow SOPs and administration guidelines for server upgrades, backups, patching, performance tuning, and security and administration of the applications.

The individual will be using administrative guidelines and industry best practices to administer Tableau Server.

Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.

Responsible for supporting Tableau Server installation, configuration, administration and maintenance.

Validated the reports before publishing reports to Tableau server, troubleshoot Tableau reports, dashboards, etc.

Environment: MS VISIO, Control-M, Erwin, Tableau (Desktop /Server), Oracle, SAS, SQL Server, DB2, SSIS, SQL, Toad, Teradata SQL Assistant, Teradata Administrator, Unix, SQL, Share Point, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Anthem Inc., Norfolk, VA Nov 2013 - Jan 2015

Data Modeler

Anthem Inc. is an American health insurance company founded in the 1940s, prior to 2014 known as WellPoint, Inc. It is the largest for-profit managed health care company in the Blue Cross and Blue Shield Association. It was formed when Anthem Insurance Company acquired WellPoint Health Networks, Inc.

Responsibilities

Updated existing models to integrate new functionality into an existing application.

Conducted one-on-one sessions with business users to Gather Data Warehouse Requirements.

Developed normalized Logical and Physical database models to design OLTP system.

Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions.

Created DDL scripts for implementing Data Modeling changes.

Created Dimensional Model for the reporting system by identifying required dimensions and facts using Erwin.

Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.

Created ERWIN reports in HTML, RTF format depending upon the requirement.

Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN.

Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.

Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.

Created and maintained Metadata, including table, column definitions.

Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.

Responsible for Defining the Naming Standards for data warehouse.

Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers.

Eliminated errors in Erwin models through the implementation of Model Mart (a companion tool to Erwin that controls the versioning of models).

Massaged the existing model to create new logical and physical models that formed the basis for the new application.

Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).

Identified the most appropriate data sources based on an understanding of corporate data thus providing a higher level of consistency in reports being used by various levels of management.

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.

Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data.

Environment: SQL Server 2008, Teradata, Oracle11g, DB2, Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, OBIEE, Windows XP/NT/2000.

GlaxoSmithKline-Consumers, Punjab, India Feb 2011- Oct 2013

Data Analyst / Business Systems Analyst

GlaxoSmithKline Consumers Healthcare Ltd. is in Gurgaon. In India, this company started its operation with the immortal brand Horlicks under the Hindustan Milk Foods Manufactures Pt. Ltd. In the year 2000, the two companies, Glaxo Welcome and Smith Kline Beecham came together to be renamed as GlaxoSmithKline.

Responsibilities

Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks

Analysed the business requirements of the project by studying the Business Requirement Specification document.

Maintained security and data integrity of the database

Created a logical design and physical design in Erwin.

Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.

Identified the business function activities and processes, data attributes, and table metadata, and documented detailed design specifications

Extensively used Erwin for developing data model using star schema methodologies.

Run batch jobs for loading database tables from Flat Files using SQL*Loader.

Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.

Good knowledge and experience on Global Custody operations, capital markets, securities services, vendor management operations, trade finance, trade settlements, income processing, tax, corporate actions, market claims and reconciliations, NAV generations

Created Entity relationship diagrams (ERD), Function relationship diagrams (FRD), data flow diagrams(DFD) and enforced all referential integrity constraints using Erwin data modeling tool

Environment: Erwin, SQL*Loader, Oracle 8i, SQL, PL/SQL, Perl, TOAD and UNIX

East India Distilleries Parry Limited, Chennai, India Mar 2010 - Jan 2011

MS SQL Server Developer/BI Developer

East India Distilleries Parry Limited is a public company headquartered in Chennai. Including the manufacturing of fertilizers for the first time in the Indian subcontinent. The company is currently engaged in the manufacture and marketing of sugar and bio-products.

Responsibilities

Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.

Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.

Implemented Data Mart, Facts, Dimensions, Snow Flake schema, Star Schema and OLAP cubes

Created Stored Procedures, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.

Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.

Created Calculated Measures and Dimension Members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.

Responsible for tuning and Optimizing Queries for the reports.

Worked in visually enhancing reports as per user requirements.

Created and maintained Roles and Database users.

Expert in SQL Server Management Studio interface for writing queries and stored procedures.

Responsible for trouble shooting the reports.

Maintained DTS 2000 Packages and migrated them to SSIS

Created database objects like views, indexes, user defined functions, triggers and stored procedures.

Environment: MS Visual Studio 2005, MS SQL Server 2005, Windows XP Professional, Team Foundation Server, ProClarity, SSIS, SSRS, SSAS.

Contact this candidate