SUMMARY

• Around 8 years of IT experience with expertise in analysis, design, development, and implementation of data marts using Power BI,Tableau, ETL and RDBMS like Oracle 11g, MS SQL server.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Strong ability to analyze user requirements, Business Requirement Specifications.
• Experience in Microsoft SQL Server ( 2008/2012/2014/206/2019 ), Business Intelligence through SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS), OLTP and OLAP and also testing of web application into all phases including Design, Testing, Analysis Development and implementing using MS SQL server.
• Experience in using Microsoft .NET framework for SQL Server Integration Services (SSIS) packages for logging programmatically and managing, automating Control flow, Data flow and Events.
• Strong experience in Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005/2008/2012/2014.
• Expert in Data Preparation, Data Modeling and Data Blending.
• Extensive experience with SQL Server with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
• Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.
• Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities.
• 3+ years of experience in Tableau, designed and developed multiple advanced visualization report and dashboard.
• Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query. experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau
• Hands on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.
• Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree mapsand Power BI Custom Charts, etc. using Power BI and Tableau.
• Generated context filters and data source filters while handling large volume of data using Power BI.
• Involved in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
• Hands on experience with MSBI (SSIS) to extract, transform and load data into database. experience in Data Analysis, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools SSIS.
• Experienced working with Excel Pivot, vlookup and other advance options.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed analytical, problem - solving skills and document function/process flows.
• Good communication skills inter personal skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop (2.68), Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.0/9.3 Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

ETL Tools: SQL Server Integration Services (SSIS).

Databases: Oracle 10g/11g, MS SQL server 2014/16, Teradata 15 and Snowflake cloud database, Azure SQL DB

Hadoop Ecosystem: HDFS, Hive

Operating System: Windows, UNIX

Languages: C, C++, SQL, PL/SQL, T-SQL

Others: TOAD, Oracle SQL developer, MS Office, FTP, Control-M, Teradata View Point, Teradata SQL Assistant, Rally, JIRA, GitHub, JSON

PROFESSIONAL EXPERIENCE

Confidential, Greensboro - NC

Power BI Developer

Responsibilities:

• Developed calculated columns and measures using DAX in Power BI
• Used the tabular model cubes as the source in Power BI to visualize the data.
• Created Power BI dashboard and generated reports.
• Performed Power BI Desktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
• Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
• Published Power BI Desktop reportsto the cloud.
• Created interactive reports customized for the business using Power BI Desktop.
• Installed and configured and maintained Power BI Report Server.
• Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.
• Developed complex SQL queries to obtain complex data from tables.
• Read source data from HDFS,Azure SQL DB, CSV, ORACLE 11g,SQL Server 2016. through Power BI.
• Read different formats of Source data from hive like JSON, ORC, TXT.
• Generated context filters and data source filters while handling large volume of data.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Have used Z-order to overlap the reports on each other using Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Created multiple data model and used as a common data source for the reporting purpose.
• Worked on Power BI Gateways Installation and adding the different data sources to Gateways to keep the dashboards and reports up to date.
• Scheduling the data refresh like daily, weekly monthly for Power BI reports.
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), and other time intelligence functions.
• Created Row level security so based on role, the end user can view the data.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Created no of views, calculated tables, calculated columns and measures.
• Created SQL Queries for testing the tableau Dashboards.
• Hand on Experience in Unix to write basic commands, Moving files from HDFS to local and vice versa.

Environment: MS SQL Server 2012, MS SQL Server Analysis Services (SSAS), EDW, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8, DAX Studio, M Query.

Confidential, Atlanta-GA

SQLSSRS/SSIS Developer

Responsibilities:

• Worked on creating Tables and writing Stored Procedures and User Defined Functions.
• Developed reports using SQL Server Reporting Services (SSRS).
• Involved in testing the application.
• Involve in Retesting, GUI Testing and Functional testing.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Responsible for design and development of complex reports using Crystal Reports XI.
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Performed report analysis, requirements gathering, design, development, and deployment of business requirement documents.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Wrote complex T-SQL statements, Stored Procedures, functions, view and triggers.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Exceptional communication skills in requirement gathering and design strategies for database management system.
• Offered production support at regular periods for migration and data issues.
• Developed re-usable stored procedures for database application support.
• Worked with transferring the data using SSIS (SQL Server Integration Services) packages. Used MS Excel, CSV files as data source and copied data to the target.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database.
• Generated Reports in SSRS using Expressions and Functions for the reports.
• Designed and rolled out canned and ad-hoc reports.
• Designed drill down, drill through, sub-reports and ad-hoc reports on large scale.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Created SSIS packages to import the data into SQL server. Troubleshooting already existing SSIS packages.
• Managed server related issues.
• Developed unit test plans for SSIS packages.
• Provided documentation for reports and SSIS packages.
• Worked with a team to suggest automated processes to reduce human errors and also to save time and resources
• Designed, developed, and deployed new reports and enhancements to existing Reports, for various applications as assigned.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Build database queries and test cases for the testing team to test the reports.
• Responsible for back up and Restoration of SQL Reporting Service.
• Provided Documentation support on SSRS 2012 as assigned.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Integration Services 2012, SQL Server 2012 Reporting Service, Crystal Report XI, ASP, Visual Studio, XML, IIS 6.0, Windows Server 2008, Sunrise Clinical Manager 4.5, Team Foundation Server.

Confidential

Tableau/ SQLSSRS/SSIS Developer

Responsibilities:

• Actively participate in review meetings with Project Manager to ensure that the development of projects meets business and system requirements for design development testing and production rollover of reporting and analysis projects within Tableau Desktop.
• Migrated Cognos reports to Tableau dashboards.
• Developed complex Stored Procedures and views by using T-SQL to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Developed, deployed, and monitored SSIS Packages.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and also defined roles and privileges to implement business rules and control access to database.
• Blended data from multiple databases into one report by selecting primary key s from each database for data validation
• Identified the factors involving the performance of the reports and coordinated in creation of indexes statistics to improve the query turnaround time efficiently
• POC on Power BI and Spotfire dashboards.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users groups projects workbooks and the appropriate permission sets for Tableau server logons and security checks .
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Power Pivot Transformation, and Slowly Changing Dimension.
• Developed entity-relationship diagram and data dictionary for project coordination; created SQL create, alter, and insert scripts.
• Worked as Tableau architect in tandardizing Tableau for enterprise wide deployment.
• Developed story telling dashboards.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately
• Perform quality assurance checks.

Environment: SQL, SSRS, AWS, Oracle, Java Script, SSMS, API, Hive, Excel, Teradata, Tableau Desktop 9.0, Tableau Server 9.0, Cognos Studio.