SUMMARY:

• Excellent IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server in Development, Test and Production Environments on various business domains like Loan, Financial, Insurance, Software, Law and Manufacturing.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to express complex technical concepts effectively, both verbally and written.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, SAS, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in working with Web services to handle SQL connections.
• Strong skills on Deploy and operate large scale cloud infrastructure and application services in our own data centers on Amazon cloud and other Cloud providers
• Strong knowledge with Host Scripting to automate routine tasks.
• Great ability to create and manage various database objects like tables, views.
• Worked Extensively on ETL process using SSIS package.
• Experience in both on-prem and cloud solutions. Extensive experience with Microsoft Azure ecosystem such as: Power Bi Service, ADF2, Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL DW, Azure Blob, AKV Management. Also, hands-on experience with AWS cloud solutions such as AWS RDS SQL server, MySQL, Amazon Redshift, AWS EC2, AWS S3 buckets.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Good Experience in working with APIs to access specific database features.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Hands-on experience with Azure Data Factory V2, Data Flows, Snowflake, Azure Data Lake, Azure analysis services;
• Experience in creating packages to transfer data between, DB2, ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Hands on experience in Creating Star Schema and Snowflake Schemas.
• Azure cloud experience of at least 3 years with ADF V2, ADF Data flows, Azure Databricks, SQLDB/Hyperscale, SQLDW, ADLS Gen 2, and other Azure services. ADF source code version control using Azure DevOps or Git.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI Dax with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and Power BI creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts.
• Experience in writing DAX in Power BI and Expert in fine tuning the reports.

PROFESSIONAL EXPERIENCE:

Senior Azure SQL/SSIS/ADF/SSRS/Power BI Developer

Confidential, Redmond, WA

Responsibilities:

• Using TSQL 2016 and 2019 version, working on performance tuning of stored procs by using new features of SQL 2019, partitioning, parameter sniffing, column store index etc.
• Actively working on Azure, Azure SQL Database, Azure SQL Data Warehouse, ADF v2, Blob Storage, PolyBase and using SSIS in ADF environment on purpose of scripting calling APIs and so on.
• In Azure, using CTAS to do merge operator job, or using CTAS to do the work of delete and update with ansi joins since these are not supported in Azure SQL DW
• Created logic and indexed tables/views/stored Procedures based on the business requirements.
• Optimized row by row operations by replacing while loop, cursors with TSQL window functions (such as row number, lead, lag, sum()over(partition by), string split/agg etc.) or with recursive CTEs
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• High Experienced in all Visual studio components for Integration services such as Control flow (Data Flow, Execute SQL, Expression, File System, Script, XML tasks and For Loop Container, Foreach Loop Container, Sequence Container.
• Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SQL Server Integration Services
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• Automated manual process using Advanced ETL such as auto extract data from Smartsheet and load it into SQL Server using Script task and merge statement.
• Created Joins and sub-queries for complex queries involving multiple tables from different databases Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments;
• Experience in data discovery to data provisioning to Azure ADW and leveraging SSIS to create facts and dims, leveraging ADF to automate and provision data inbound to ADW;
• Involved in configuring Azure platform for data pipelines, ADF, Azure Blob Storage and Data Lakes and building workflows to automate data flow using ADF;
• Developed SSIS packages to pull out, modify and load data from law database(son db) into Data Warehouse of 3e
• Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.
• Good knowledge on the dimension, fact tables and designing the Data-Mart using Star schema.
• Always Received excellent feedback from clients for my work and performance.
• Successfully Completed 3e training, excellent knowledge of conversion related to small/medium/large law Firms.
• Client focused experience, was able to handle and complete complex conversions, strong knowledge of legacy data of law firms and 3e data.
• Strong knowledge, excellent experience of Creating SSRS /Power BI reports, excellent dax language skills such as logic, arithmetic calculations etc.
• Strong problem-solving skills, can solve any complex TSQL issues with simple way

Senior SQL BI SSAS, SSRS, SSIS Developer / Team Lead

Confidential, Kansas City, MO

Responsibilities:

• As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with SSIS, SSAS and SSRS.
• Supported the Project Manager in leading multi-functional project teams in 2 of 5 implementing data conversion strategies and communicating essential information to team members.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for SSIS packages and SSRS reports.
• Gathering, analyzing and documenting the business requirements and business rules by directly working with end users/clients.
• Created complex Stored Procedures/execute task, wrote C# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance.
• Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications.
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2, Oracle 7.x/8i/9i/10g/11g, Sap, XML files, SharePoint Lists into the central OLTP database.
• Extract Transform and Load data from databases of systems like ART, WANDA, EDR and IES.
• Developed C# console applications to manipulate databases and perform calculations
• Extended SSIS Capabilities by Creating Custom SSIS Components for SharePoint.
• Configured SSIS packages with XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table.
• Created SSRS and Power BI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
• Trained/guided new or junior developers in certain development areas helped them to understand better the project process.
• Assisted in developing systems with a high level of reliability and performance.
• Solved a lot of critical/challenge issues raised by the team about ETLs.
• Performed SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, DB2, Oracle, and SAP into the data warehouse.
• Regularly worked/used TFS and did Incremental Load using Foreach Loop, Sequence containers, Script Task, Conditional split, Data Conversation, Derived Column, Lookup, Merge/Merge Join, Union all and so on in Visual Studio.
• Participated in software quality assurance activities, include code reviews and unit system, integration, regression and performance testing.
• Understood and completed necessary documentation for the application/infrastructure change control process.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions/expressions, CTEs, indexed views, stage tables to process the data and populate them in the appropriate destination tables.
• Developed in Visual Studio 2010 and/or Visual Studio 2012 including applications written in C# is required.
• Created complex Stored Procedures/execute task, wrote C# hard codes in script task for ETLs, updated/maintained the ETL packages with high performance.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1/ type 2 changes.
• Converted old ETL packages to the new version (did optimization by applying more stored proc instead of using visual studio tasks).
• Worked with the team/architect to create logical/physical modeling, creating Cubes (fact, dimensions and calculations).

Skills Used: MS SQL Server 2005/2008 R2/ SQL Server 2012/2014, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL server Analysis Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.

SQL BI SSAS, SSRS, SSIS Developer

Confidential, Kansas City, MO

Responsibilities:

• Worked independently and as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Created Cube in Tabular mode, created hierarchies in VS 2012 for Cube.
• Worked on Insurance, Policy and Commodity data
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Successfully created database diagrams and physical models for the project.
• Created packages using the various control flow task such as data flow task, execute SQL task.
• Execute package task, File System task.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2012
• Data migration from text files, SAS, DB2, SAP and excels files to SQL server.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal Process.
• Experienced solving issues raised by QA, UA for database.
• Supported the different UI with back end logics, wrote SQL codes to summarize the data.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Responsible for Data migration from SQL Server 2000, 2005 to SQL Server 2012 Databases.
• Applied conditional formatting in SSRS to highlight key areas in the report data Used Report Builder to do Ad-hoc Reporting.
• Created report links to refer other reports in a particular report. Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• Created multiple hierarchical aggregates for faster performance.
• Installed SQL server 2008, 2012 on Windows 2007, 2008 servers and involved in Physical and logical Database Design using Erwin tool.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.
• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Worked in Amazon Web Services (EC2, S3), installed MS SQL server in virtual machine, deployed cubs, reports, packages.
• Identified, troubleshoot and resolved network or system issues in OnDemand production environment to ensure we have the highest uptime and performance.
• Involved in Normalization of the database and bringing it to 3NF.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 7.0 to SQL Server 2000 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports.