SUMMARY

• Around 8 years of experience in Analysis, Design, Development, Administration and implementation of various applications in Business Intelligence and Database systems.
• 4+ years of Tableau Desktop/Server experience using various versions 9.x/8.x/7.x.
• Involved in various stages of SDLC such as requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analytics projects.
• Hands on experience in SAS programming for extracting data fromFlat files,Excel spreadsheetsand externalRDBMS (ORACLE, MySQL, DB2, Sybase) tablesusingLIBNAME and SQL PASSTHRU facility.
• Expertise in Data Manipulations usingSASdata step, such asSASFormats/In formats, Merge, Procedures like PROC APPEND, PROC DATASETS, PROC SORT, and PROC TRANSPOSE.
• Experience in creating different Visualizations/Dashboards using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables etc.,
• Experience in using different features of Tableau Desktop like Filters, Parameter, Actions, Calculations (logical, String, Table, Aggregate functions) and formatting the reports/dashboards (Layout Containers, Annotations, Mark Labels etc.,)
• Experience Tableau Administration including Installation, Configuration, Security, Upgrade, technical support, troubleshooting, report design and monitoring of server.
• Experience in creating users, groups, sites, projects etc., and managing data connections, scheduling tasks, Permissions etc.,
• Involved inPerformance tuning and Troubleshooting of reportsand resolving issues withinTableau Serveranddashboards.
• Create Tableau - based BI solutions and associated data architecture within Tableau or connecting with Hadoop/Hive environment
• Highly proficient in the use of SQL and PL/SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact, Measures and Dimensions tables, and Physical and Logical data modeling.
• Have been working with various data sources such as Oracle, SQL Server, ODBC and flat files.
• SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
• Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
• Working knowledge of performance improvement measures including aggregate tables, Indexes and explain plan.
• Experience in writing complex SQL queries to perform End-to-End Data validations and support Ad-hoc business requests.
• Strong Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.

TECHNICAL SKILLS

BI Tools: Tableau Desktop 9.x/8.x, Tableau Reader, Tableau Public, Tableau Server.

ETL Tools: Alteryx, Informatica, SSIS, SSRS

Management Tools: Requisite Pro, Microsoft Office, Microsoft Project, SharePoint

Databases: Teradata, Oracle, SQL Server 2008/2008R2/2012, MS Access, PostgreSQL, Toad

Defect Management Tools: Test Director, HP Quality center

Scripting Languages: PL/SQL, HTML, CSS, JavaScript

Operating Systems: Windows 8.x/7/XP, Windows Server 2012/2008, UNIX/Linux.

Networking: TCP/IP, LAN, WAN, Servers

Programming: C,C++, C#, Java

Analytics: R, SAS, SAS Enterprise Miner, SAS/MACROS, SAS/SQL, Python, Apache Hadoop, Apache Sqoop, Apache Hive

PROFESSIONAL EXPERIENCE

Confidential, Duluth, GA

Sr. Data Analyst

Responsibilities:

• Synthesized and leveraged data from varied sources and provided actionable recommendations to optimize the marketing analytics and customer experience.
• Addressed learning problems for a number of cross-functional business partners in an applied retail analytics environment.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Working on analyzing the existing BI infrastructure and coordinating with various teams to install and configure single node Tableau server environment and creating sites, users, groups and granting the required permissions
• Created and implemented Tableau best-practices on migrating and governing the dashboards in multiple environments
• Upgraded the Tableau server from 9.0 to 9.1/9.2/9.3 versions and involved in maintaining the server by regularly taking care of backup and cleanup activities.
• Create and manage Sites, Users, Groups and Projects in Dev/QA/PROD environments.
• Involved in extraction, transformation and loading of data directly from different source systems (flat files/Excel/Oracle/MSSQL/Teradata) using SAS/SQL, SAS/macros.
• Extensively read different forms of Input files like CSV and other formatted files using In-file, PROC Import and documented using SAS scripting to develop data cleaning operations.
• Generated PL/SQLscripts for data manipulation, validation and materialized views for remote instances.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages,Functions and Triggers using SQL and PL/SQL.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques usingSAS/Base.
• Developed Python scripts to clean the raw data.
• Query Data from Hadoop/Hive & MySQL data sources to build visualization inTableau.
• Created Macros and used macros created by other users.
• Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
• Validated regulatory finance data and created automated adjustments using advancedSASMacros, PROC SQL, UNIX (Korn Shell) and various reporting procedures.
• Created views/reports inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Worked closely with business power users to create reports/dashboards using Tableau Desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• 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.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Tools: & Technologies: SAS, SAS Enterprise Miner, SAS/MACROS, SAS/SQL, TableauDesktop & Server 9.x,SQL Server 2014, Apache Hadoop, Apache Hive, Apache Sqoop, MS Office.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Managed monthly accrual processes and variance analysis and Collaborated with cross functional teams to improve processes
• Provided monthly reporting and analysis on Confidential spend and interpreted and reported data findings to management.
• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience in creating dashboards using calculations, parameters in Tableau.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Mastered in different formatting techniques, using Annotations and Mark Label.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Setting the user permissions in Tableau Sever.
• Expertise in providing business solutions by analyzing various trends, risks and patterns in the data using interactive reports.
• Used advanced filters, groups, actions, complex calculations in Tableau Desktop extensively.
• Defined best practices for Tableau report development.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Provided post implementation production support.

Tools: & Technologies: Tableau (Desktop/ Server) 8.x, Teradata, ER Studio, SQL Server 2012, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access.

Confidential

Tableau Developer/Analyst

Responsibilities:

• Provided in-depth situation assessments of relevant disease areas in support of annual brand planning process and provided market research support as necessary in support of brand team objectives.
• Reported Key Performance Indicators (KPIs), including management dashboards and monthly reports.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Defined best practices for Tableau report development.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• 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.
• Provided support for Tableau developed objects and understand tool administration.
• Performed report validation writing SQL queries using SQL assistant on a Teradata database.
• 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.
• 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.

Tools: & Technologies: Tableau Desktop & Server 8.x, Microsoft office, SQL Server 2012, Teradata, SharePoint.

Confidential

SQL Developer

Responsibilities:

• Managed and maintained banking information which included details of customers and transactions.
• Developed, managed and maintained data dictionary and metadata.
• Ensured compliance of standards and conventions in developing programs.
• Designed, developed and implement complete life cycle of data warehouses.
• Performed and executed data extraction, transformation and loading using ETL tools.
• Maintained and managed all versions of data models for production, testing and developing databases.
• Utilized SQL Queries, stored procedures, packages, used defined functions, views, cursors using Toad or SQL Developer to present data on the reports.
• Developed Drill down Reports, Linked Reports, sub reports and Parameterized Reports.
• Created formulas and/or used statistical or financial functions for reports as needed.
• Used SQL stored procedures, created alias data tables as required to improve report performance.
• Worked with DBMS PROFILER to tune PL/SQL Procedures.
• Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
• Created Tables, Views, Constraints, Indexes and developed Complex database objects including Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with exception handling.
• Used SQL extensively by using Joins, Sub Queries, Set Operations, and Advanced OLAP Functions.
• Designed and developed T-SQL procedures, query performance tunings and SSIS packages.

Tools: & Technologies: SQL Server 2008 R2, SSIS, SQL Server Reporting Services, Agile Methodologies, MS Visio, Enterprise Manager.

Confidential

Data Analyst

Responsibilities:

• Related customer data from multiple internal and external source systems into a central, consolidated company-wide customer database in a timely manner.
• Offered input to improve customer data processing, and informed team lead about company hierarchy issues during staff meetings.
• Worked autonomously within a team of Data Analysts, to analyze, review, update, edit, clean, translate, and ensure accuracy of customer data.
• Validated data to ensure the quality, Validity and accuracy of content.
• Met daily and weekly metrics goals.
• Liaised with and resolved issues from other departments.
• Reviewed and performed quality control audits monthly on the work of colleagues within our department.
• PerformedQA testing of database, provided test results.

Tools: & Technologies: SQL Server 2008, SSIS, SSRS, SSAS, Microsoft Office tools, SharePoint