SUMMARY

• Skilled data analyst with more than 7 years of industry experience in collecting, organizing, interpreting, and disseminating various types of statistical facts to support business decision making. Strong technical background knowledge in Database applications
• Data modeling, ETL Development, Data Warehousing and Data Analysis. Organized and timely in providing executive management, staff, and departmental members with reports and BI dashboard visualizations of specific data findings and their impact on organizational growth and success.
• Have a great ability to understand business processes and learn latest technologies, software, and products to support business lines on - premises and cloud environment.
• Cleaned and transformed large dataset into useful and insightful to specific teams.
• Great understanding in data mining for fulfilling client segmentation business requests and regular report creation.
• In-depth understanding of Data Warehouse, ETL concept and modeling structure principles
• Experienced in Data Warehousing and Business Intelligence area in various domains.
• Experience in Data Analysis and ETL procedures for loading large amounts of data from various data sources to target database.
• Hand on experience in using Business Intelligence (BI) tools to implement dashboards, data visualizations, and analytics using Tableau Desktop, MS Excel, and Power BI
• Good understanding of SDLC methodologies such as Agile and Waterfall particularly using JIRA project management software to track product backlog and sprint progress in Agile mode.
• Knowledge with Snowflake cloud data warehouse in AWS and Azure cloud platform for integrating data from multiple source system which include loading semi-structured JSON files and formatted data into snowflake table.
• Professional knowledge of AWS Redshift
• Operationalize data ingestion, data transformation and data visualization for enterprise use
• Performed end to end Data Modelling and Data Migration from Conceptual, Logical to Physical using ERwin 3.x/4. x. tool.
• Experienced in analyzing business needs and interpreting business user requirements and translating them into reports.
• Used business intelligence tools to include OLAP (Online Analytical processing), data warehousing, MS excel, reporting, and querying tools.
• Good interaction with client, understanding business applications, business data flows and data relations.

TECHNICAL SKILLS

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL Developer

ETL/Other Tools: SSIS, Erwin Data Modeler, ER Assistant, SAS Base, SAS Enterprise Guide

Databases: MS SQL Server 2005/2008/2012 , DB2, MySQL 5.2, 5.7, Oracle 10g, 11g, Teradata 12/13

Business Intelligence Tools: Tableau, Power BI, Excel, Power Query and PowerPivot, SSRS, MicroStrategy

Programming Languages: SQL

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

Tableau Developer

Responsibilities:

• Carrying out data extraction and data manipulation using SQL as per business requirements
• Involved in reviewing business requirements and analyzing data sources from Flat file, Excel, SQL Server for design, development, and analysis projects within Tableau Desktop
• Designed interactive dashboards using Tableau worksheet and Dashboard, and prepared user stories to create compelling dashboards to deliver actionable insights.
• Developed Tableau Data Visualizations using Scatter Plots, Geographic Maps, Cross Map, worked on different chart types based on the requirements including Donut Chart, Pie Charts, Bar Charts, and Combination Charts.
• Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau Desktop.
• Published the developed dashboards into Tableau Server and refreshed the scheduled extract and tuned the performance of the dashboard.
• Generate Key Performance Indicator’s (KPI’s) for customer satisfaction and Confidential t feedback details.
• Utilized tableau to convert complex data into user-friendly visuals that are easy to understand for stakeholders for business decision making.
• Create Tableau workbooks from various data sources using Tableau connection and Data Blending.

Confidential, Oak Ridge, TN

Data Analyst / Tableau Developer

Responsibilities:

• Created reports, dashboards using Tableau to tell a story through visualizations to meet business requirements, and to solve business problems.
• Collected data from several data sources like Flat files, MySQL, Oracle and SQL Server into a central repository or Data Warehouse for Analysis and to solve complex business problems.
• Created Logical and Physical data models that capture current state and future state data elements and data flows using Erwin data modeler.
• Utilized SQL queries and create Views, Stored Procedures, Triggers.
• Perform Data migration from various data sources to staging area for cleansing, mapping, and transformation before loading data into the target destination.
• Created SQL commands to retrieve data from different tables using CTE’s, JOIN’s, UNION, Sub-queries, and Derived tables to user requirements.
• Created SQL queries and scripts to extract and aggregate data to validated date integrity and accuracy.
• Assisted developers to re-engineer database objects to create database diagram and database dictionary to ensure data consistency and referential integrity.
• Utilized Snowflake to convert JSON semi-structured data from web applications into structured data to meet business rules for data analysis which reduces time in extensive ETL processes.
• Creating, maintaining, and managing SQL Server Integration (SSIS) packages from source to target destination.
• Examines the quality of the company’s data and processes, reports on results, and recommend corrective action plans and alternative methods for executive management.
• Engaging in performance tunes ETL workflows, scripts and SQL written by other team members and business users.