SUMMARY

• Around 8 years of experience in BI (Business Intelligence), Analytics, and Data warehouse solutions using Tableau and Power BI.
• Designed and developed Analytics solutions using Tableau and Power BI for various business domains.
• Expertise in designing dashboards/reports with complex, multiple data sources (SQL, Excel, Flat files), relational design and optimizing applications.
• Stored Procedures, User defined Functions and System functions using SQL Server, T - SQL.
• Experience in designing and deploying reports with Drill Down, Drill Through and Drop-down menu option and parameterized and linked reports using Spotfire.
• Strong understanding of project life cycle and SDLC methodologies including RUP, Waterfall, Agile and Scrum.
• Experience in OLTP/OLAP system study, Analysis, and modelling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modelling.
• Expertise in SQL Server Analysis Services (SSAS) to deliver online analytics processing (OLAP) and data mining functionality for business intelligence applications.
• Ability to work independently and as a part of team and possesses excellent communication, interpersonal and client facing skills.
• Excellent knowledge of all the phases of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS

BI / Visualization Tools: SSRS, Tableau, Power BI Desktop, Power Apps, Power BI Report Builder, Azure Data Bricks

Databases: MS SQL Server, Oracle, IBM Netezza, Tera Data, Hadoop, Hive, Microsoft Azure

Middleware Products: TIBCO BW 5.11/5.13, EMS

ETL/Data Integration: SSIS, Informatica

Languages: T-SQL, PL/SQL, Java, Python

Process/Methodologies: Agile, Waterfall, Kanban

PROFESSIONAL EXPERIENCE

Confidential, Eagen, MN

Power BI Developer

Responsibilities:

• Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.
• Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Build GSHS Reports in Power BI from scratch.
• Developed various solution driven views and dashboards by developing different chart types includingPie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Developed various dashboards to know theschool climate, school safety, risk factors, and risk behaviors.
• Created dashboard forschool system financial informationwhich includesrevenue and expenditure by district.
• Developed customGeorgia district map visual,the SVGis written inline within a Bootstrap 2 container.
• Written some Java script plugin that makes the polygons work like hyperlinks.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business usingPower BI.
• Used various sources to pull data intoPower BIsuch as SQL Server, oracle.
• Involved in installation ofPower BI Report Server.
• Developed reports to visually explore data and create an interactive reportExcel and Power BI.
• Using a query editor inPower BIperformed certain operations like fetching data from different file.
• Created groups, content packs.
• Created the KPI to show the difference between actual and forecast data.
• Working with import and direct query, creating custom table in thePower BI.
• Merge queries and append queries, remove columns, and split columns, choosing required columns in the data.
• By usingPower BI desktopconnected to various data sources, working with different visualizations.
• Developed and published reports and dashboards usingPower BIand written effectiveDAXformulas and expressions.
• UtilizedPower QueryinPower BItoPivot and Un-pivotthe data model for data cleansing and data massaging
• Created severaluser rolesandgroupsto the end - user and providedrow level securityto them.
• CreatedPower BI Reportsusing the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Worked on importing custom visualizations.
• Worked withtable and matrix visuals, worked with different level of filters likereport level, visual level filters, page level filters.
• Used various data visualizations withPower BI.
• Created reports utilizingSSRS, Excel services, Power BIand deployed them onSharePoint Serveras per business requirements.
• Designed different types of KPI's for percentage growth in different fields and compared over the period and designed aggregations and pre-calculations in SSAS.
• Involved in designing partitions in cubes to improve performance using SSAS.
• CreatedTabular modelreports to slice and dice huge volumes of data.
• UsingTabular modelprovided more security to data atRow level.
• MDXprogramming,DAXexpressions, analysis, and business forecasts.
• Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.
• Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud usingPower BI desktop.
• Creating reports from importing, direct query and live data from several data sources.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.
• Experience in combining data from different sources by using ofpower query.
• Experience with power pivot and dashboard designer.
• Troubleshoot and support reports inPower BI workspaceswhenever there are issues in production.

Environment: MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Oracle 11G, SQL Profiler, T-SQL, Power Bi Desktop, Power Bi pro, Visual Studio 2010, HTML5, Java Script.

Confidential, Pleasanton, CA

MSBI/Azure Developer

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and Sql Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import & Export Wizard and VB scripts, Sql Server Migration Assistant (SSMA) and SSIS packages.
• Architected Cubes with Power Pivot, MDX, SSAS.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on maintaining, generating reports and data migration usingSQL Server 2008, SSRS, SSIS.
• Worked onAzure Data Factoryto orchestrate the ingestion of data from various sources likeAzure tables, Azure SQL Database, Azure SQL DWH, Azure Storage Blobs, and on-premises databasestoAzure Data Lake Store.
• Worked onAzure WebJobswhich run every hour and pulls the Files from aData Drop File Shareand unzip them to move to variousBlobsand Registers those File names in Catalog.
• Monitor thedata factorieswhich pulls the files toblobs, Unzip the files, limits the data to 5 years and load into SQLDW throughexternal tableswhich sits on top of storage account.
• Created TSQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans.
• Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS data profiling task, data profile viewer and T-SQL queries.
• Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• T-SQL development included queries using joins, sub queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, constraints & database triggers.
• Improved the performance of SSRS reports by tuning the stored procedures and T-SQL queries using various join conditions.
• Involved in using Sqoop for importing and exporting data into HDFS.
• Unit tested and tuned SQLs and ETL code for better performance.
• Created and maintained technical documentation for launching HADOOP Clusters and for executing Hive queries and Pig Scripts.
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse (ETL).
• Deployment of SSIS packagesandschedule SQL Server Agentjobs to automate the run of SSIS packages on a weekly basis.
• Designed rich dashboards withpower BIand prepared user stories to create compelling dashboards to deliver actionable insights.
• Created reports inPower BIutilizing the SSAS Tabular via Analysis connector.
• Experience in creating master and child packages, usingpackage configurations(SQL Server) and SSIS logging.
• Conduct Code Walkthroughs and perform SSIS/SSRS peer reviews.
• Used Team Foundation Server 2010 to check in code artifacts and techno solutions.

Environment: SSIS 2008/2012, SQL Server 2008R2, T-SQL, HDFS, Hive, Sqoop, Microsoft Access, SSRS, Azure, Microsoft Excel, VBScript, SQL Server Migration Assistant (SSMA)

Confidential, Radnor, PA

Sr. Power BI Consultant

Responsibilities:

• Gathering the requirements analysis with business users to identify and finalize requirements for Power BI solution
• Supported business users in realizing their needs for in-depth data analysis
• Created design documents which Outlines the approach of the Power BI Implementation
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning
• Wrote multiple custom SQL queries and functions to extract data for Ad-hoc reporting using Power Query
• Creating Row level security with Power BI and integration with Power BIservice portal.
• Extensively worked with the business in creating their Excel workbooks, charts, and Pivot tables
• Installation, configuration, deployment, and management of BI software.
• Gateway Maintenance and connections within, handling user access
• Deployed web embedded power BI dashboards refreshed using gateways by using workspace and data source.
• Developed Power BI Paginated reports using Power BI Report Builder
• Troubleshooting BIissues and tuning for performance.
• Implemented user-based security in SSRS reports to limit the access of reports
• Worked on all types of transformations that are available in Power BI query editor
• Created stored procedures and SQL queries to pull data into Powerpivot model
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Installed and configured Enterprise gateway and Personal gateway in Powerservice
• Responsible in deploying developed paginated reports into Power BI Services
• Created Workspace and content packs for business users to view the developed reports
• Power user of Excel VLOOKUP, pivot tables, Power pivot, IFERROR and other formulas for cleaning, formatting data from multiple disparate data sources
• Worked with users to get the Business Users Signoff on the Paginated reports to move to Production

Environment: SSRS, SSIS, Microsoft Excel, Microsoft Power BI service, Power BI report Builder, Power BI Desktop, Oracle SQL Developer.

Confidential, Denver, CO

SQL/Business Intelligence Consultant

Responsibilities:

• Installed & Configured SQL Server 2000 for development purpose.
• Migrated certain packages from SQL server 7.0 to SQL server 2000.
• Created DTS packages to transfer the data from oracle to SQL Server 2000.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since stored procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Involved in performance tuning of the database and T-SQL queries using explain plan.
• Created indexes, constraints and rules on database objects.
• Created and modified Clustered and Non-Clustered Indexes to optimize the queries using Index Tuning Wizard.
• Designed and developed MS SQL Server stored procedures using T-SQL statements from scratch.
• Developed triggers on views to populate base tables.
• Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update or delete.
• Create stored procedures and user defines functions to supports efficient data storage and manipulation.
• Handling database objects with Enterprise Manager
• Provided technical documentation for future enhancements.

Environment: MS SQL Server 7.0/2000, T-SQL, Query Analyzer, SQL Profiler, Enterprise Manager, Windows Server 2000.

Confidential

Tableau Developer

Responsibilities:

• Experience using Tableau tool to handle the various data feeds from the different data sources using Tableau Desktop tool
• Creating customized and interactive dashboards using multiple data sources, data extraction and custom objects
• Migrating some of the existing excel - based dashboards of Tableau
• Experience in creating and implementing interactive charts, graphs, and other user interface elements
• Understanding of relational database structures and ability to create SQL views.
• Designing, developing, maintaining, and supporting multiple Tableau dashboards and apps using Tableau 7x and understanding of new features of Tableau 8x
• Good experience in Tableau development, analysis and Tableau Desktop, Server &Public support implementations
• Develop Tableau module deliverables such as workbooks, package workbooks, building data views manually and automatically using different charts, graphs
• Deploy and administer complex Tableau server environments involving multiple server setups in controlled and secure environments
• Added multiple additional processes (VizQL, Application server, data server and background processes) for performance improvement
• Helped Tableau power users in optimizing their tableau reports with proper use of filter, optimized SQL queries etc.
• Created Data extracts for better performance and accessing data offline
• Implementation of incremental data extracts updated on timely basis as database updates, Refreshing extracts, optimization and tuning applications for maximum memory management, scheduling
• Have developed patches by upgrading versions from 7.0 to 8.0
• Dealt with medium and enterprise deployment type with more than 32GB ram
• Configured general settings and caching, and adding administrative accounts

Environment: Tableau 7.x/8.x BI toolkit, Windows, SQL Server, Microsoft Excel