SUMMARY

• 8 years of experience in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.
• Strong programming experience in TSQL, PL/SQL Development (SQL SERVER 2012) and Report Development (SSIS, SSRS), Performance Analysis, Deployment Script Development, Production Support.
• Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Excellent hands-on experience in groups, hierarchies, and measures, KPIs
• Expert in working on all phases of Data warehouse from gathering requirements to testing, implementation, and support.
• Experience on ASP.NET, ADO.NET, C#, Web Services, HTML, XML, VSS, TFS.
• Excellent noledge in Performance tuning methodologies at a database level, ETL, and Report Level.
• Proficient in the ER-Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model.
• Excellent noledge of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modeling and reporting tools.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Expertin creating, configuring andFine-tuningSSISpackages, SSRSreportsandT-SQLqueriesusingtools like SQL profiler Monitoring tool.
• Experiencein creating jobs,alerts,SQLmailagent,andschedulesforSSISPackagesinSQLServerAgent.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.
• Optimizedallmajorrelationaldatabaseanddatawarehouseandaccessedmultidimensionaldatabases and flat files using SSIS.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
• Expert in generating reports using SQL Server Reporting Services (SSRS).
• Proficient in SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
• Experience as .NET as developer
• Strong Knowledge in Data Analytics tools such as Power BI, Tableau, QlikView etc.
• Expertise in DAX & MDX Languages which halps in understanding and analyzing the data.
• Worked in all the products in Power BI such as Power BI Pro, Embeded, Premium, Power BI Mobile...

TECHNICAL SKILLS

Data Warehousing/BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, Power BI, Tableau.

RDBMS/DBMS: SQL Server, MS SQL SERVER 2005/08/12, ORACLE 9i/10g, MS-Access.

Database tools: Management Studio, SQL Profiler, Database Tuning Advisor, Query Analyzer, DTS, Performance Monitor, Client Configuration Utility, Server Configuration Utility.

Programming Languages: C#, .net, VBScript,

Protocols / Middleware: TCP/IP, HTTP, FTP, UDP/IP, DOM, ODBC

Visualization Tools: Power BI, Tableau, Power Pivot

PROFESSIONAL EXPERIENCE

Confidential, SACRAMENTO, CA

Responsibilities:

• Design and develop intuitive and visually appealing reports, and dashboards using Microsoft Power BI in collaboration with SMEs.
• Participate in requirements gathering and illustration of designs using wireframes.
• Documentation of business and IT solutions, business process functional and nonfunctional requirements and problems.
• Created MS Access database to collect data systems in order to provide lists, status reports and management overview reports.
• Maintained and supported MS access database.
• Defined periodic extraction and performed data formatting in MS access.
• Assist in managing the Power BI environment, Enhancements and support of Power BI applications.
• Perform hands on developer activities such as building data visualizations dat can be used in interactive reports and dashboards.
• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Designed SSIS packages for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, and OLEDB supported databases.
• Performed trouble shooting, designed wrote test plans for MS Access db.
• Followed the complete SDLC by writing requirements, schema, and performed QA and UAT for MS Access.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Written stored procedures and used them in packages.
• Created stored procedures and SQL queries to pull data into power pivot model.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Imported data from Azure and build the dashboards according to requirements.
• Used C# and VB Scripts in ETL Packages wherever necessary.
• Used various sources to pull data into Power BI such as SQL Server, SQL Azure etc
• Implemented Event Handlers and Error Handling in SSIS packages .
• Built a Tabular Model cube from scratch data and by DAX queries fetched data to SSRS and Power BI reports.
• Extensive use of DAX expressions in tabular models as per business requirements.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed application using C#.Netunder Visual Studio 2015 environment. Extensively used controls such as Data Grid and Data List to populate the records for presentation layer.
• Developed User Interface using .NET and extensively worked with .Net forms using ASP.Net and Implemented validation using validation control.
• Created an ASP.NET MVC application for clarity project record. Add Controllers to handle URLs to the Home page of the site and for browsing its main functionality. Add a View to customize the content displayed along with its style and also add Model classes to contain and manage data and domain logic. Use View Model pattern to pass information from controller actions to the view templates.
• Involved in development of Azure Data Factory Pipelines, linked services, data sets, deploy and monitor them.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensive use of perspectives and hierarchies in models to efficiently serve reporting needs.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Worked on various Conditional formatting in power bi visuals to define the data in appropriate way.
• Developed different types of reports such as Descriptive, Predictive, Prescriptive for end-users.
• Migrated data from on-premises data servers onto Microsoft Azure cloud platform utilizing Azure data factory.
• Worked on Teradata insert, Update, modify and Dynamic SQL to transform and load Summary tables built on Core Data Warehouse.
• Created Drilldowns, Drillthroughs and Bookmarks in Power BI Reports for easy navigation and storytelling.
• Created Dynamic Dropdown measures in slicer with the halp of DAX in Power BI Desktop.
• Developed and deployed reports for the internal users in Power BI Report Server.
• The VB.NET app uses Crystal Reports, Excel, MS-Access, and SQL 2005 to generate multiple reports and spreadsheet.
• Worked on Azure Data Factory to move data from SQL Server DB to Azure SQL DB.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Performing extract/transform/load (ETL) routines using SQL Server Integration Services(SSIS).
• ImplementedDAXTime-intelligencefunctionsSAMEPERIODLASTYEAR, PREVIOUSYEAR, PREVIOUSQUARTER to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: MS SQL Server 2017, SQL Server Integration Services 2017 (SSIS), SQL Server Analysis Services 2017 (SSAS Tabular), SQL Server Reporting Services (SSRS), Power BI Desktop & Service, MS-Access, Azure, DAX, T-SQL,C#, Microsoft Visual Studio 2017,DAX STUDIO, TFS, MS Excel.

Confidential, Milwaukee, WI

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on daily basis.
• Create reports utilizing the SSAS Tabular via Analysis connector as Data Source.
• Expert in developing multiple kind of Reports and Dashboards.
• Experience in publishing Power BI Desktop reports created in Report view to the Report Server.
• Explore & Analyze data in a Variety of ways and across multiple visualizations using Power BI.
• Responsible for writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Created packages using SSIS 2012 for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Work with business users to get the requirements and write the code.
• Worked on interface process which downloads the file from Client FTP and process the applications in production database based on the requirement.
• Created cross tables and ETL routines to standardize the data coming from multiple sources.
• Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic.
• Translated business logic to transformation logic to generate pseudo code for the ETL process
• Involved in Data migration, data cleansing and writing the retro to fix the existing effected data.
• Worked on Visual Studio 2012 and Synced/loaded projects with TFS 2010.
• Used transformations like Lookup, Aggregator, Sort, Derived Column, Union All and OLE DB Command to implement the transformation Logic and load the target tables.
• Developed the logic to Capture the Error Rows in the data flow and populate them into an Excel file.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild
• Performance tuning the Stored Procedures used in SSIS Packages.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS 2012.
• Design & develop solutions using C#, ASP.NET, MVC, HTML5, MS SQL Server and related technologies.
• Implemented code in ASP.net Web Forms in such a way dat it is ADAconsistentwhich is disable people friendly.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Scheduled and maintained jobs to perform ETL tasks on daily, weekly and monthly basis.
• Design store procedure, view, trigger, function for data ware housing.
• Developed 2012 SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Involved in all phases of Data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Set up SQL Profiler to trace various Database activities, Application Responses and their Performance to tune them.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created mapping for error handling sessions.
• Designed different type of reports: tabular, matrix (cross tab), conditional, list items, charts and sub reports with different sources.
• Documented requirements.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), DAX, T-SQL, Microsoft Visual Studio#, JIRA, Import/ Export Tools, MDS, DQS, TFS, Tableau, MS Access.

Confidential, Edison, NJ

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) .
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS .
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data-to-data warehouse databases and deployed with minimal changes using XML configuration file.
• Extensively worked on the packages, including a variety of transformations.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting application.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Generated matrix reports, drill down, and drill through, sub reports.
• Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
• Implementing SSRS solutions, used dashboards and gauges to enhance for the business users.
• Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
• Worked on Development and implementation of SSRS reports and ran them as per the requirement.
• Sound Knowledge and understanding of SSAS, OLAP and OLTP cube.
• Generated daily, weekly and monthly reports for the managers.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources, established the connections using SSIS, and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Created cubes in SSAS and build MDX queries to query cubes and to access cube's data.
• Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.

Environment: Power BI, MS SQL Server 2005, DTS, SSIS, SSRS, SSAS, DAX, T-SQL, Excel, Windows NT.