PROFESSIONAL SUMMARY:

• Over 4+ years of extensive experience in database design and development using MS SQL Server 2017/2016/ 2014
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Strong development skills with Azure Data Factory, Azure SQL Data warehouse, Azure SQL Data base, Azure Storage Explorer.
• Implemented Copy activity, Dataflow, Trigger in Azure Data Factory Pipeline Activities for On - cloud ETL processing.
• Extensive experience in Design and Develop ETL Processes data from external sources like Azure blob Storage, Azure Data lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse (Azure Synapse).
• Extensive experience using Azure Key vault to Encrypt keys and Password.
• Extensive experience in working various platform with large TB Database.
• Extensive experience in Extraction, Transformation and Loading of data using SSIS from heterogeneous sources
• Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.
• Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance.
• Extensive experience in using Microsoft Business Intelligence studio products like SSIS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, Star Schema modeling foreign key concepts and referential integrity.
• Extensive experience in design and development of reports using Power BI.
• Extensive experience using Logic Apps, Power BI Report Server in Azure Environment
• Good Knowledge on Azure Databricks.
• Extensive experience in working closely with stakeholders, vendors and business users.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in writing common table expressions (CTEs) and user defined functions, indexed views and DML/DDL triggers for data consistency and data manipulation.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Experience in using Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints
• Expertise in performance tuning, fine tuning SQL queries for improved performance and Query Optimization
• Excellent knowledge in understanding various data models.
• Participate in Azure migration for existing Data Warehouse from on premise to Iaas VM in Azure Cloud.
• Experience in Setup/Configure Integration Runtime for Azure Data Factory.
• Experience working on Azure SQL Data warehouse.
• Experience Using Azure Data Factory to upload to transfer data from on premises to Cloud.
• Experience in implementing hybrid connectivity between Azure and on - premise using virtual networks, VPN and Express Route.
• Experience in implement ETL and data movement solutions using Azure Data Factory (ADF), SSIS.
• Experience in Azure SQL Data warehouse by following all the best Practices like Group Inserts, Poly Base to load, Hash Distribute tables, Minimizing transaction size etc.
• Experience using advanced database objects like temporal tables (also known as system-versioned temporal tables).
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer

TECHNICAL SKILLS:

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, AZURE Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, infrastructure-as-a-Service (IaaS), Database-as-a-Service (DBaaS), Data Migration Service (DMS), Azure SQL Data.

Languages: T-SQL, PL/SQL, MDX, DAX, C, HTML.

Databases: Azure SQL Database, Azure data warehouse, Azure Data azure data factory, Azure Data Synch, MS SQL Server 2008 R2, 2012, 2014 MySQL and Oracle12c.

BI Tools: Azure Database migration Service (DMS), ETL Informatica 9.x/8.x Informatica Power Exchange, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio, Tableau Desktop, POWER BI.

Database Design Tools and Data Modeling: Star Schema/Snowflake Schema modeling, Fact and Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies.

Tools: and Utilities SQL Server Management Studio, Import & Export Wizard, SQL Server Profiler, Visual Studio, DTS, Business Intelligence Development Studio (BIDS), Power BI, Microsoft Office (MS), Excel Data Explorer, Tableau, Amazon Web Services.

Operating Systems: Windows, Windows Server

PROFESSIONAL EXPERIENCE:

Confidential, Sanjose, CA

MSBI/Power BI Developer/Azure Developer

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets.
• Trained Power BI to all business units and users.
• Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers
• Created notifications and alerts, subscriptions to reports in the Power BI service.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Report.
• Involved in Creating User Security and Roles in Power BI.
• 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.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Experience in Integrating Power BI App with Azure Active Directory Groups and Office 365 group to implement Row level Security.
• Experience in Integrating Power BI App with Share Point.
• Assigning different access permissions and security levels for the reports in Power for various levels of users in the company. Designed, Developed and Deployed Dashboards in Power BI.
• Build and automated Power BI reports for the FP&A (Finical Planning and Analysis) department through which company was able to reduce Man hours of data cleansing and creating report in excel for every month.
• Extensive experience in Design and Develop ETL Processes data from external sources like Azure blob Storage, Azure Data lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse.
• Design and Develop ETL Processes in ADF Glue to migrate Campaign data from external sources like Azure blob Storage, Azure Data lake and Using ORC/Parquet/Text Files into Azure Datawarehouse.
• Design, Develop, test, and deploy ELT/ETL pipelines using Azure Data Factory.
• Implemented Copy activity, Data flow, triggers in Azure Data Factory Pipeline Activities.
• Developed multiple complex ETL pipelines and activities stores for full and incremental data loads into a Azure SQL DW.
• Designed and Developed ETL pipelines that will read data from various sources like CRM, ADP (HR and Pay role) and JDE(Operational) and loaded into Azure SQL Datawarehouse.
• Designed Developed various objects like External Tables (HDFS format on any Azure cloud storage), Relational Tables, Views,
• Stored Procedures, Triggers and Other Database Objects.
• Designed and Developed ETL Frame that extract, transform, Audit and load data in Azure SQL Datawarehouse and Used Various leveraged Architecture like Polybasic.
• Developed Azure SQL Datawarehouse by Analyzing Analytical, Functional and Non-Functional Requirements and selecting appropriate MPP Methodology (Round Robin, Hash Distributed tables).
• Experienced working on larger datasets.
• Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
• Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
• Generated several drill down and drill through reports using SSRS.

Environment: Azure Cloud, SSIS, Azure SQL Database, Azure Data lake, Power BI, SQL Server.

Confidential, Tracy, CA

MSBI/Power BI Developer

Responsibilities:

• Participate in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Developed and Published dynamic and complex Financial and Sales Reports in PowerBI.
• Used DAX to create complex measure and calculated columns.
• Setting up PowerBI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from different sources
• Created many calculated columns and measures using DAX in PowerBI based on report requirements.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created, Maintained & scheduled various reports in PowerBI like Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2017/2016, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), JDE, SharePoint, PowerBI Desktop, PowerBI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.

Confidential, Herndon, VA

MSBI Developer

Responsibilities:

• Worked on developing complex stored procedures for implementing incremental loading from Stage to Target tables.
• Develop working solutions to custom client requirements and Data services automation requirements, keeping in mind product capabilities, scope limitations and the impact on integrated products employing SQL Server built in features and analytical methods.
• Design specific databases for collection, tracking, and reporting of administrative clinical data and Operational Product Data for IT Operational performance analysis using SQL Server Management Studio 2016.
• Design, code, test and debug custom SQL queries and generate financial, utilization, cost reports and IT Operational Performance metrics, using Microsoft SQL queries, SQL Server Management Studio and SQL Server Reporting Services.
• Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Designed and implemented Row Level Security & Roles for SSAS Tabular Model. And deployed into SSAS 2016.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Created Dashboard and the App Workspace for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
• Used One Drive for storing different versions of Power BI report.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI and SSAS
• Created or modified Databases, tables, indexes, views as per the requirement and analysis of records that are integrated from call records, online filing records
• Collaborating with other team members and stakeholders.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created SSIS packages to populate data from various data sources.
• Performance tuning, and optimization of procedures and queries.
• Involved in Requirements gathering, Analysis and design of all the client requirements.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Responsible for making SQL datasets for Power BI and Ad-hoc Reports.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
• Created many Complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.

Environment: MS SQL 2016/2014/2012 , SSIS, SSRS XML, T-SQL, .NET Visual Studio, MS Access 2010, MS Word, MS Excel, VBA (Visual Basic for Applications), SharePoint, DTS, C#, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server.

Confidential

MS SQL Server / SSIS/SSAS/SSRS Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Experienced in database design process and data modeling process.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Extracted data from various sources like DB2, VSAM, SQL Server 2014/2012/2008 R2, .CSV, Microsoft Excel and Text file from Client servers.
• Analyzed business requirements and implemented data mart solutions for data mining and reporting.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
• Created a report model on SSAS cubes.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Worked closely with QA team and helped them come up with test scenarios.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), Share point, DTS, C#, ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server