SUMMARY

• Over 7+ years of Experience in Business Intelligence Technologies and Database with Extensive Knowledge in Data analysis, T - SQL queries, ELT Process (SSIS & Azure Data Factory), Reporting Services (using SSRS, Power BI & Tableau) using MS SQL Server 2019/2017/2016/2014 and Azure SQL Database.
• Have extensive experience in creating Design, Development, Implementation and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application working in Agile, Waterfall.
• Proficient in SQL Server and T-SQL (DDL and DML) in Constructing Tables, Normalization Techniques on Database Tables and established relationships between tables using Primary Keys & Foreign Keys.
• Expertise in writing SQL Queries, Dynamics, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Indexes, Views, and Cursors.
• Hands on experience in Performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes.
• Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent.
• Strong Experience in Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and U-SQL Azure Data Lake Analytics.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Good knowledge and experience in Data Warehouse design of Dimensional Modeling, ETL Design and Dimensional and Facts Maintenance.
• Proficient in Azure Data Factory to perform Incremental Loads from Azure SQL DB to Azure Synapse.
• Experience in moving the data from heterogeneous data sourceslike oracle, xml etc. to SQL using SSIS.
• Experienced in Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel data into database.
• Strong skills in visualization toolsPower BI,Confidential Excel - formulas, Pivot Tables, Charts and DAX Commands.
• Hands on experience on Tableau Desktop versions 7/8.2, Tableau Reader and Tableau Server.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Strong understanding of Application Lifecycle Management best practices for Development, Testing, CI/CD, Monitoring.
• Knowledge of full software development cycle (SDLC), including code reviews, source control management and working knowledge of Agile.
• Hands on experience using the version controls like GIT, project management tools like JIRA.
• Ability to model data both logically/physically through tools such as ER Studio/Erwin.
• Domain Knowledge ofFinance, Logistics and Health insurance.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment.
• Communicate effectively with colleagues and business users.

TECHNICAL SKILLS

Databases: Azure SQL Database, SQL Server 2019, 2017/2016/2014/2012 Database Tools SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services

Power BI Tools: Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS

Programming Skills: T-SQL, XML, DAX, MDX, HTMLWeb Technologies Microsoft Azure Data Factory, Azure DevOps, Azure SQL Data Warehouse

ETL/ELT: Azure Data Factory, SSIS, DTS, BCP

Data Visualization: Power BI, Tableau, SSRS, MS Excel

Reporting tools: SQL Server Reporting Service (SSRS), Power BI, Tableau 7.0/8.0/8.1/9.0/9.3

Data Modeling: ERWIN, ER/Studio, Microsoft Visio

Operating Systems: Win XP/7/8/10, UNIX, MAC OS X

Methodologies: Agile, Waterfall

Miscellaneous: Agile, Azure DevOps, CI/CD, JIRA, MS Office, GIT, GITHUB, Visio, PowerPoint, Share Point, TFS

PROFESSIONAL EXPERIENCE

Confidential

SQL/MS BI Developer

Responsibilities:

• Develop new queries to pull the data from database based on business requirements.
• Creating stored procedures usingCommon Table Expression (CTE)and various types of UDF functions Developed ComplexT-SQL queries, common table expressions (CTE), stored procedures.
• UseT-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Reducing the T-SQL overhead successfully by avoiding unnecessary joins, wildcard syntax & parsing using char index, pad index within the select statement to optimize the query performance.
• Creating indexes on the database tables and generated trace events to improve the query performance and optimize data access.
• Design, develop, and implement Business Intelligence (BI) solution using SSIS, SSRS, Tableau, MS SQL & Power BI.
• Scheduling and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures.
• Optimizing Azure Data Factory (ADF) Pipelines with Various Partitioning Techniques.
• Work closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Design and Develop Data Warehouses using Star Schema, Snowflake Schema depending upon business needs.
• Designing Data Warehouse SSIS/Data Factory ETL/ELT to check for general errors, support auditing of row counts, financial amounts, and other metrics.
• Implementing Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
• Importing data from various sources (flat file, excel, XML, raw file & various databases) and exporting to various destinations using SSIS (2016).
• MovingCSV files from Azure blob to Azure SQL Server.
• Use Power BI Gateways to keep the Dashboards and reports up to date and Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Created Dax Queries to generated computed columns in Power BI.
• Created reports in Power BI by importing data, shaped and transformed data for business intelligence (BI), Visualize data, author reports, scheduled automated refresh of reports and created and share dashboards based on reports in Power BI desktop.
• Develop BI Dashboards, Reports and maintain existing Reports to Visualize data in a business environment with large-scale, complex data sets.
• CreatingRich Graphicvisualization/dashboards to enable a fast read on claims and key business drivers and to direct attention to key area.
• Working extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups,hierarchies,sets to create detail level summaryreport and Dashboard using KPI's.
• Scheduling the reports to run on daily and weekly basis in Report Manager and emailing them to director and analyst to be reviewed in Excel Sheets.
• Create several reports for claims handling which had to be exported out to PDF formats.
• Implementing Azure DevOps solutions for various development teams, including source control, work item tracking, build and release management.
• Working on projects using Agile and Waterfall model methodologies.
• Working onGIT(Git Hub) repositories as Distributed Version Control System.

Environment: MS SQL Server 2019, Micro Soft Visual Studio, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Power BI Services, Erwin, Tableau Server, JIRA, Agile methodology, Data Warehouse, ADF, Azure Data Lake, Azure DevOps, XML, data pipelines in Azure, Microsoft Azure SQL, GitHub, Git.

Confidential - Wariminster, PA

Data Analyst/BI/SQL Developer

Responsibilities:

• Created Procedures, functions, triggers, cursors while developing database using SQL Server.
• Wrote T-SQL queries, stored procedures and used them to build SSIS packages, SSRS reports and in Tableau.
• Created databases and schema objects including tables, indexes, and applied constraints.
• Connected various applications to the database and writing functions, stored procedures and triggers.
• Performance tuningof SQL queries and stored procedures usingSQL Profiler and Index Tuning Wizard.
• Collaborate with business users and members of the BI team, including business analysts, data warehouse developers, and managers, to design and develop as per requirement.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2016 & BIDS.
• Creating Multiple Data SetsinAzureworked in migration ofSQL Server 2017/2012/2014 to SQL Server 2019.
• Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files, Oracle DB for the daily load to create and maintain a centralized data warehouse.
• Designed SQL SSIS Packages to extract data from various data sources such as FTP site, Excel spreadsheet, and flat files into SQL Server 2017 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data Warehouse, write-back tool and backwards.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Created and assisted users in Tableau dashboard development.
• Created Dax Queries to generated computed columns in Power BI and Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Built Dashboards using techniques for guided analytics, interactive Dashboard design, and visual best practices.
• Produce attractive visuals/dashboards to convey the story inside the data.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Developed interactive Data Visualizations and developed automated processes for updating content used in standardized dashboards.
• Utilized Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• ScheduledReports to run thereports hourly, daily, monthly accordingto client requirements for the periodic analysis.
• Developed medium to complex reports like drill through reports, drill down reports, sub-reports, ad-hoc reports to meet various business needs using SSRS.
• Created different KPI using calculated key figures and parameters.
• Configured and maintained Azure DevOps pipelines, including automated builds and deployments.
• Configured JIRA workflows according to the needs to the CM team and integrated the project.

Environment: MS SQL Server 2019/2017, SSIS, T-SQL, Azure Data Factory, SSRS, BIDS, SQL Profiler, Power BI, Tableau, JIRRA Azure DevOps, Azure Data Warehouse, FTP, T-SQL, SSMS, Windows 2003 Server.

Confidential, Charlotte,NC

ETL/BI Developer

Responsibilities:

• Used Joins, Sub-queries for complex business queries involving multiple tables from different databases.
• Worked on Custom SQL to pull the required data from the data source.
• Creating numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Developed ETL packages in SSIS and pulling data from different Data Warehouse databases like Oracle.
• Deployed SSIS packages in the cloud by utilizing the Integration Runtimes feature for Azure Data Factory (Lift & Shift).
• Designed and configured SSIS packages to Migrate the data from Oracle, legacy System using various transformations.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Used the ETL tools (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• CreatedSSIS packagesto extract data from OLTP to OLAP systems andScheduled Jobsto call the packages and Stored Procedures.
• Worked with high-performance data integration solutions that connect multiple data sources for extracting and rapidly transforming the data for loading into the pre-designed data warehouses.
• Scheduled, load balancing, processing high volumes, disaster recovery, data archiving, backup and restore policies and solutions.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Implemented drill down functionality by building hierarchies in Power BI visualizations.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.

Environment: MS SQL Server 2017/2016, SSIS, DTS, T-SQL, OLAP/OLTP, Azure Data Factory, SSRS, BIDS, SQL Profiler, Tableau, JIRRA Azure DevOps, Azure Data Warehouse, T-SQL, SSMS.

Confidential Mequon, WI

SQL/BI (SSIS, SSRS) Developer

Responsibilities:

• Involved in fine Tuning and Query optimization of the Database as required by the application.
• Involved in planning and designing database based on business requirements and provided documentation.
• Building complex SQL queries, including stored procedures, triggers, user defined functions and views for data analyzing and data processing.
• Performed T-SQL tuning and optimization of performances that takes longer execution time.
• Managed and executed SSIS packages to transform the data from the client server and used SSIS transformations such as lookup, merge, merge join, conditional split, derived column, data conversion and aggregate etc.
• Create SSIS packages to integrate the data coming from flat files and migrated SSIS Packages from during data migration.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advancedBI visualizations.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Administered Reporting Services by securing Report Server Content by defining roles, role assignments & assigning item level, system level security.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Created several report subscriptions to deliver reports to the end users via email.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Deployed and scheduled Reports using SSRS to generate daily, weekly, monthly and quarterly Reports including status.
• Created standard report Subscriptions and Data Driven Report Subscriptions.

Environment: MS SQL Server 2014/2016, SSIS, T-SQL, ETL, DTS, SSRS, BIDS, SQL Profiler, Tableau, JIRRA Azure DevOps, Azure Data Warehouse, T-SQL, SSMS.