PROFESSIONAL SUMMARY:

• Around 8 years of IT experience in developing and supporting Business Intelligence solutions for fortune clients across the globe.
• 4+ years of experience in data extraction, transformation and loading (ETL) between different systems and data formats. Expert in creating, configuring and fine - tuning ETL workflows, creating SSIS packages using various transformations like lookup, derived columns, conditional split, etc.
• 3+ years of experience developing visualizations and dashboards using Tableau Desktop 10.x/9.x/8.x, Tableau Server, Tableau Public, Tableau Reader and Tableau Cloud
• 1+ years of experience in Big Data Ecosystem using HADOOP framework and related technologies such as HDFS, HIVE, PIG, FLUME, OOZIE, SQOOP, and SPARK.
• Expertise in SQL Server 2012/2008 Reporting Services (SSRS), Integration Services (SSIS) and in Analysis Services (SSAS) and developing dashboards and reports using Tableau Studio.
• Experience extracting SAP and PeopleSoft data from Oracle database systems and load in to the SQL Data Warehouse using SSIS and develop reports and dashboards using SSRS.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc…
• Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2012/2008/2005.
• Experience in Managing Security of SQL Server databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in developing reports using SSRS and Tableau (drill-down, drill through, cascading parameters, sub - reports), Excel Spreadsheets (functions, subtotal, and pivot tables).
• Build and publish Tableau reports utilizing calculated fields, table calculations, filters, parameters and excel sheets, flat files, CSV files and SSRS & Tableau adhoc reports.
• Expertise in Labeling & annotations, data blending, data extract, publishing, applying filter actions, quick filtering, hierarchies, conditional formatting, groups the rows and Title & Caption
• Worked on Tableau JavaScript API to integrate Tableau visualization into internet and intranet web applications to enable custom interactions.
• Build and publish Tableau reports utilizing calculated fields, table calculations, filters, parameters and excel sheets, flat files, CSV files and Tableau adhoc report scheduling using Tableau server.
• Responsible for Developing Dashboard and preparing ad-hoc and monthly reports using Tableau.
• Expertise in SQL Server 2012/2008 Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS)
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Generated context filters and data source filters while handling huge volume of data.
• Create Views with Formatting or standard templates, Applying sorts, calculations Knowledge in RDBMS concepts, Star Schema / Snowflake Schemas.
• Worked on the development of dashboard reports for the key performance indicators for the top management on regular basis, as per the Business requirement using internal tools.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Map, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirements.

TECHNICAL SKILLS:

Tools: SQL Server Management Studio, Enterprise Manager, Profiler, SQL Server Business Intelligent Studio (BIDS), DTS, Report Builder 9.0

BI Tools: SSIS, SSAS, SSRS, Tableau Desktop 9.x/8.x, Tableau Server

Hadoop/BigData: Hadoop, HDFS, MapReduce, Pig, Hive, Sqoop, Zookeeper, Elastic search, HBase, Spark Streaming, Flume, Yarn.

ERP Packages: SAP Finance, SAP Supplycain, PeopleSoft FSCM

Databases: SQL Server 2012/2008, Oracle 11g/10g, DB2

Language: SQL, T-SQL, PL/SQL, MDX, C, VB.net, C# (.NET)

Data Modeling Tools: MS Visio, Erwin, Microsoft Excel

Operating Systems: Windows 2010/2007/XP, Windows Server 2012/2008, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Data Analyst / Tableau Developer

Responsibilities:

• Work with business teams and stakeholders to gather master data and retail store data requirements and document data integration, data mapping, data migration specifications.
• Worked on predictive, prescriptive and descriptive analytics and related reports and dashboards.
• Analyzed, validated and cleansed large volumes of data by creating Excel data models and developed pivot tables and charts using Excel to present to retail operations teams.
• Coordinate with technical teams to export the analyzed data to the relational databases using Sqoop for visualization and to generate reports using Tableau for the BI team.
• Worked on large sets of structured, semi structured and unstructured retail data and parsed the data using Excel Spreadsheets and created pivot tables and reports for ad-hoc reporting by the management team.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD, MTD type of analysis on store front data and online retail data.
• Developed worksheets using parameters, calculated fields, groups, sets and hierarchies and different styles like bar, pie, tree map, dual axis, filled maps.
• Designed and developed drill through and drill down reports in dashboards using Filters, parameters, and Action Filters

Environment: Tableau 9.x/8.x, Microsoft Excel, Microsoft Office 2016, SQL Server 2016, Oracle 12c.

Confidential, Wilmington, NC

Data Analyst / Tableau Developer

Responsibilities:

• Worked with business teams to gather data requirements for manufacturing intelligence program including but not limited to ETL, data mapping, data transformation, and data integrity requirements and documented the specifications.
• Parsed large sets of data from GE MES system and sensors in the manufacturing plant floor and analyzed for consistency and developed excel reports to analyze the manufacturing performance.
• Involved in designing the Data model for the Data warehouse and for different Data marts.
• Involved in upgrading Tableau 8.0 to Tableau 9.0 and migrated the reports to the 9.x environment
• Managed importing tables using Data Warehouse catalogs and building logical tables.
• Designed and developed Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server.
• Used Java script API to integrate Tableau workbooks and dashboards with web applications.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill Down analysis using tableau desktop.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.
• Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.
• Generated Key Performance Indicators (KPIs) using calculated fields for the management to take strategic decisions based on visual analytics.
• Utilized symbol maps, filled maps and other map options to plot geographical data.
• Plotted data on image by creating background images.
• Performed End to end testing using SQL Queries in Oracle.
• Work with business owners to identify information needs and develop reporting, primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations.
• Used pre-aggregates and data source filters while extracting data to decrease the run time and increase the performance of the reports.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet with common fields in Tableau Desktop.

Environment: Tableau 9.x/8.x, SAP FI, SAP SCM, HANA, SAP BO, DB2, Oracle 11g

Confidential, Hackensack, NJ

Data Analyst

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Developed stored procedures and functions for designing various reports.
• Monitored the effectiveness of Incident Management and made recommendations for improvement.
• Supported the problem control process including support of error control processes and track evaluations for improvement.
• Produced SLA metrics and information for management for review.
• Supported the IT SAP Services organization with efficient, effective and proactive problem management activities.
• Provided first level support to the Data Intelligence team and related issues and production tickets.
• Tracking and monitoring internal change requests from business teams by following change management procedures including monitoring status, attending meetings and supporting the release schedules of customers.
• Assisted Release managers in ensuring that data being modified was traceable, secure and that only correct, authorized and tested versions were installed.
• Liaison with Change Management teams to support new BI and ETL rollouts for the releases and coordinate with the production support teams to move the changes.
• Participated in CAPA action meetings to maintain or improve service levels.
• Experienced in error handling and troubleshooting the scripts in failure to load the data into Test and Production database systems.
• Develop ETL processes using SSIS which involves collection of data from sources like SQL Server 2012 and Oracle 12c.
• Created package by using break points, For Loop, For Each Loop, Sequence Container, FTP Task, File System Task, Execute SQL Task, row count, Send Mail Task and Precedence Constraint to achieve business requirement.
• Used excel sheet, flat files, CSV files to generated adhoc reports.
• Generated dashboards by joining multiple complex tables.
• Generated dashboard for Finance team, provided security by using user filters.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
• Administrated the reports by assigning permission to the valid user for executing the reports.

Environment: SQL Server 2012 Enterprise Edition, SSIS, SSRS, Oracle 12c/11g, SQL, T-SQL, Visual Studio 2010, Team Foundation Server 2008.

Confidential

Data Analyst / SQL BI Developer

Responsibilities:

• Supported ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On warning, On Pre and Post Execution, On Task Failed etc.)
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency / requirement.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SSIS packages for application that would transfer data among servers and perform other data transformations.
• Generated country and region wise reports using variables, expressions and functions in SSRS.
• Scheduled the same SSIS packages by creating the corresponding job tasks
• Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
• Defined report parameters and wrote queries and procedures for drill down and parameterized reports using SSRS.
• Created and design the multiple dimensions and fact table for business report purpose.
• Created Report Snapshots to improve the performance of SSRS
• Generated parameterized/Drilldown reports to enable/disable the parameters based on user selection in SSRS
• Scheduled the reports to refresh & run on daily, weekly and monthly basis in the report manager.

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS 2008), Business Intelligence Development Studio (BIDS).