TECHNICAL SKILLS

• BI Tools: Tableau Desktop 9.3, Tableau Server 9.3, Tableau Online, Tableau Mobile, QlikView
• Database: SQL Server 2012/14, SQL Server 2008, Oracle 10g
• Data Warehousing: Visual Studio, SQL Server Integration Services, SQL Server Data Tools, Data Quality Services, Master Data Services, Change Data Capture
• Reporting Tools: Tableau, SQL Server Reporting Services, SQL Server Analysis Services, MicroStrategy, MS Excel
• Programming: Core Java, C, C++, SQL Server Management Studio
• Scripting: T - SQL, PL/SQL, Python (Numpy, Pandas & Matplotlib)
• Version Control: GIT, Subversion, Perforce
• Operating Systems: Windows 2007, Windows Server 2008, RHEL 5.5 and 6.5
• Other: IBM Tivoli, ServiceNow

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Data Warehousing/SQL Consultant

Responsibilities:

• Designed, implemented and maintained ETL processes using SSIS (SQL Server Integration Services)
• Created the ETL mapping documents based on business logic
• Used SSIS to extract data from the source databases, transformed the data as needed and loaded the finished data into the cube
• Translated client user requirements into data flows and data mapping
• Used the SQL Server Analysis Services wizards to build the measures, dimensions, and schema
• Provided cube browsers for users so they can select and view reports
• Modified current database by adding tables, altering referential integrity and relationships to support online system
• Coordinated with source system owners and performed tasks like day-to-day ETL progress monitoring, design and maintenance for Data Warehousing target schema (Star Schema)
• Developed new mappings using Look Up/Aggregation transformations to match the needs of the business case
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings
• Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems. Assisted DBA in using the repository manager to give permissions to users to create new users and repositories
• Created views to reduce apparent database complexity for end users and preventing sensitive columns from being selected
• Created indexes on columns having high selectivity and low density to speed up the execution of data retrieval queries and stored procedures
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Supported complete backup on the database and restored database from disaster recovery

Environment: SQL Server 2012, Tableau, SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Server Management Studio(SSMS), SQL Server Integration Services(SSIS), SQL Server Data Tools (SSDT), PL/SQL, Microsoft Excel, Windows 2007

Confidential, Woodland hills, CA

Tableau/ETL Consultant

Responsibilities:

• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions
• Involved in Data warehouse and Data mart design
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Coordinated with the business users to provide appropriate, effective and efficient ways to design the new reporting needs based on the user with the existing functionality
• Interacted with database developers and DBAs to understand the existing schema
• Performing daily system checks. Data entry, data auditing, creating data reports & monitoring all data for accuracy
• Gathered data from different data sources like SQL Server, Oracle and Excel
• Developed Tableau visualizations and interactive dashboards with guided navigation links within them using Tableau Desktop
• Implemented authentication, data security and access level settings for tableau reports and dashboards. Restricted data for particular users using row level security and user filters
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards were displaying the changed data accurately
• Developed complex calculated fields for the business logic, actions, sets and parameters with various filtering capabilities for the dashboards, and provided drill down features for the detailed reports
• Defined best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel
• Created rich dashboards and prepared user stories to deliver actionable insights
• Designed and published customized interactive reports, dashboards and scheduling data extract refreshes using Tableau server
• Hosted live dashboards on to the client web page using Tableau JavaScript API which are updated regularly
• Worked on Tableau Servers upgrades for new versions

Environment: Tableau Desktop, Tableau Server, Tableau Mobile, SQL Server 2012, Oracle 10g, My SQL, MS Excel, PL/SQL, SQL Server Analysis Services(SSAS), SQL Server Management Studio(SSMS), SQL Server Integration Services(SSIS), SQL Server Data Tools (SSDT), Windows 2007

Confidential, Phoenix, AZ

Data/Reporting Analyst

Responsibilities:

• Reviewed business requirements and analyzed data from multiple data sources for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop
• Developed various Tableau visualizations like dual axis, bar graphs, scatter plots, pie charts, heat maps, bubble charts and dashboards using Tableau Desktop
• Created analysis reports using Tableau Desktop to provide detailed product performance across various locations to the client
• Projected and forecasted future growth in terms of new customers by developing area maps to show details on which states the client has the most customers
• Designed dashboards on the concept of dynamic availability where in variety of worksheets were connected by actions providing an interactive reporting environment
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data with the usage of quick filters for details on demand
• Performed Tableau admin duties that comprised of adding users, groups, data connections and scheduling tasks. Monitored Tableau Servers for its high availability to users
• Developed Python scripts that periodically scraped log files and generated daily/weekly reports of run times, errors and other metrics that provide overview of system performance
• Converted charts into crosstabs for further underlying data analysis in MS Excel
• Used Tab-admin and Tab-cmd commands in creating and restoring backups of Tableau repository
• Monitoring the automated loading processes . Advising on the suitability of methodologies and suggesting improvements. Involved in defining the source to target data mappings, business rules, and business data definitions.
• Created naming and system standards for lookup, transformation and target tables. Loaded consolidated data using SQL*Loader in parallel and direct mode.
• Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality .

Environment: Tableau Desktop, Tableau Server, Tableau Mobile, SQL Server 2008, Oracle 9i, My SQL, MS Excel, SQL, Python 2.7, SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Server Management Studio(SSMS), SQL Server Integration Services(SSIS), SQL Server Data Tools (SSDT), PL/SQL

Confidential, Memphis, TN

Data Engineer

Responsibilities:

• Extracted statistical information from database logs using SQL Server Management Studio and used this data to create Tableau dashboards that track disk utilization
• Created Tableau dashboards to inform application and DBA team to understand trends in disk space utilization thereby reducing 95% of fatal alert scenarios
• Gathered historical data on alerts from IBM Tivoli monitoring tool, filtered out false and repetitive alerts by analyzing this data using pivot tables and charts on MS Excel which resulted in reduction of over 30,000 alerts in 2 months
• Involved in generation of daily/weekly reports using Tableau by identifying the dimensions, measures values and level of details for business analytics to give an overview of current trends
• Handled SQL Server administration and performance tasks through monitoring SQL Server Profiler, also used System Monitor to record database activities and further performed consistency checks using DBCC
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing)
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding
• Performing daily system checks. Data entry, data auditing, creating data reports & monitoring all data for accuracy.
• Responsible for defining the functional requirement documents for each source to target interface .
• Worked on incident, change management processes through coordination with various stakeholders in application and support teams

Environment: SSMS, SQL Server Activity Monitor, SQL Profiler, SQL Activity monitor, SQL Server 2008, MS Excel, SQL, PL/SQL, Tableau Desktop, Tableau Server, SQL Server Analysis Services(SSAS), SQL Server Integration Services(SSIS), SQL Server Data Tools (SSDT), IBM Tivoli