SUMMARY:

• 5+Years of Business Intelligence /SQL Developer and Data Analyst with Bachelors of Science in Information Systems. Extensive T - SQL, SSIS, SSRS, Power BI and Tableau with initiatives that utilizes software and hardware components within a creative and technology-driven organization.
• T-SQL development skills in Objects creation such as Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, Cursors and Triggers using SQL Server 2008R 2/2012/2014.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.
• Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization .
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.
• Solid knowledge of Power BI and Tableau Desktop report performance optimization.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and Heat Map.
• Expert on Microsoft Power BI and Tableau reports, dashboards and publishing to the end users for executive level Business Decision.
• Expert on maintaining and managing Tableau and POWER BI driven reports and dashboards.
• Experienced in managing users, groups, sites, permissions and roles on Tableau server.

TECHNICAL SKILLS:

RDBMS/DBMS: Microsoft Access, SQL Server 2008 R2, and SQL Server 2012, 2014

Software/Databases:: MS SQL Server 2008RS,2012 MS SQL Server Reporting Services 2008/2012 (SSRS), MS SQL Server Analysis Services 2008/2012 (SSAS), MS SQL Server Integration Services 2008/2012(SSIS), ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler, PerformancePoint Server

Development Environments: Microsoft Visual Studio 2008/2, Microsoft Visual Studio Team System 2008/2010/2012, Microsoft SQL Server Management Studio 2008/2012/2014, Microsoft SQL Server 2008/2012/2014, ORACLE, POWER BI, Tableau, Excel, Smart Sheet

Programming Languages: Experienced in Transact-SQL (T-SQL), XML, and C#.

PROFESSIONAL EXPERIENCE:

Sr. BI/Power BI/ Tableau Developer

Confidential, Tampa, FL

Responsibilities:

• Designed, developed and tested various Power BI and Tableau v isualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company .
• Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices .
• Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across same and various data sources .
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard. .
• Excellent SQL skills for daily testing of data using various SQL queries.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.
• Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions .

Sr. Business Data Analyst/ Tableau Developer

Confidential, Seattle WA

Responsibilities:

• Responsible for creating SQL data sets for Tableau recurring and Ad-hoc Reports.
• Created ad-hoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports .
• Worked directly with stakeholders for requirements gathering and developing various decision making Dashboards.
• Created developing dashboards and reporting visualization.
• Created joins and sub-queries for complex queries involving multiple tables.
• Created various reports using Tableau based on the client’s needs.
• Expert on creating multiple kind of Report in Tableau and present it using Story Points.
• Created Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
• Expert on creating complex CTE, Sub Queries, Joins, cumulative queries for multiple kind of reports.
• Provided an advance Tableau training to top stakeholders and team Members.
• Created, maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created, maintained & scheduled various reports in Oracle Roast like Tabular Reports, Matrix Reports & Parameterized Reports using SSRS.
• Expert on connecting multiple data sources in Tableau to implement working reports.
• Performed super user trainings in Basic and Advanced Tableau Desktop .

BI/ Data Analyst/Power BI /Tableau Developer

Confidential, Seattle WA

Responsibilities:

• Managed enterprise services by diagnosing root causes of incidences, determined time of detection, diagnosed and resolved by analyzing data.
• Worked with various data sources such as Oracle, SQL Server, Hadoop, ODBC and flat file sources
• Created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Expert in connecting multiple data sources in Power BI to implement working reports.
• Hands on experience in developing reports and dashboards visualization.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point. Slicer, Pivot chart, Pie Chart, Macros.
• Expert in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.
• Expert in creating multiple kind of Power BI Reports and Dashboards.
• Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability.
• Implemented subscriptions and snapshots in the SSRS Report Manager.
• Researched problems thoroughly to diagnose the root cause by pulling data from multiple Sources, Developed Reports and dashboards using Power BI .
• Expert in creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office 365.
• Expert in creating multiple kinds of Report in Power BI and presented them using Story Points.
• Created SSIS package to pull all events and programs data from database server and SharePoint lists.
• Hands-on experience assisting users in creating and modifying worksheets and data visualization dashboards.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.

BI Developer /Data Analyst

Confidential, St Paul, MN

Responsibilities:

• Built SQL Server Queries for Power Pivot based reporting to deliver on managers reporting needs.
• Widely used Excel, Access and SQL Server to cleanse, de-duplicate and format client files.
• Provided complex reports using Excel, Access and PowerPoint.
• Expert in writing Parameterized Queries for generating Tabular, drill down, drill through and sub-reports using SSRS 2012 and generating on-demand and scheduled reports for business analysis or management decision.
• Wrote SQL queries, CTE and sub queries for Stored Procedures.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data into Production Data Base Tables.
• Designed and modified the existing packages accordingly by using the transformation tasks such as Script Component, Lookup, Derived Column, Condition Split, Union All, Copy Column, Aggregate and Audit Transformation.
• Created Data Profile packages for data quality using SSIS Data Profiling Task.
• Worked on extensive SQL Server Integration Services (SSIS) - Extracting data from 8 different sources and load into data warehouse after applying business logic and data profiling.
• Involved in creating different reports based on the business request and ad hoc requirements using SSRS 2008/2012.

SQL/ Data Analyst

Confidential

Responsibilities:

• Worked on Microsoft Visual Studio 2008/2012 project environment to create dynamic metadata driven SSIS packages for source data extracts and destination system updates.
• Created, maintained and analyzed wide variety of reports / Excel spreadsheets for senior management. Oversaw departmental software drive / files.
• Scheduled a job in SQL Server Agent that runs on daily basis and creates a log file and maintained the Errors in Error log file.
• Experienced in developing ETL processes from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks, and transformations provided by SSIS.
• Excellent skills in developing SSRS reports with functionality such as Drill Down, Drill through, and Parameters.
• Involved in automating SSIS Packages using SQL Server Agent Jobs.
• Exported and imported data from Flat file, CSV file, Excel to/from SQL Server Database using SSIS.
• Created tabular, list, matrix reports and writing queries to perform drill down operations in SSRS.
• Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager.