SUMMARY

• Over Eight plus years of extensive experience and hands - on working knowledge in various domains of IT industry as SQL/MSBI.
• Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Knowledge of USQL and how it can be used for data transformation as part of a cloud data integration strategy
• Experience with Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Experience in designing and creating RDBMS Tables, Views, User Created Data Types, Indexes, Stored Procedures, Cursors, Triggers and Transactions.
• Profound experience in performing Data Ingestion, Data Processing (Transformations, enrichment, and aggregations.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS, SSAS, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Adroit in Data munging, EDA, Feature engineering using Python, Jupyter Notebook, and packages like Pandas, sklearn, matplotlib, Regex.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated Transformations to be used in SSIS packages.
• Experience in designing Dynamic SSIS Packages using variables, expressions, containers.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using SSIS Packages.
• Experienced in writing expressions and fine-tuning reports. Created many Drills through, Sub, Parameterized and Drill Down reports using SSRS.
• Extensively worked in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in ETL, OLAP Cubes, BI Reports and Dashboards, Tableau, Power BI, Power Query, Power View, Power Pivot. (Microsoft BI Stack).
• Experience in working with Amazon Redshift (AWS), Google Cloud Big Query (GCP).
• Experience in performing a Bulk Loads into SQL Server and Incremental updates with SSIS.
• Expert in Looping through All Files in a Folder and Loading into SQL Server and other databases.
• Leveraged Azure SQL Data Factory to load Azure SQL Data Warehouses for analytics and reporting.
• Experience in writing stored procedures, Indexes, Views, Synonyms, and user defined functions.
• Experience with Fragmentation and Query analyzer for SQL Server 2005/2008 and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing, and Performance Tuning.
• Experience with SSAS, MDX, Reports, ETL Architecture.
• Expert in creating Data Source Views (DSV), Dimensions, Hierarchies, Cubes, Partitions.
• Expert in creating calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Experienced in fact dimensional modeling (Star schema, Snowflake schema), transactional modeling and SCD (Slowly changing dimension)

TECHNICAL SKILLS

Operating Systems: Windows 2019/2016/2012/2008 R2/2008, Unix

Languages: C, C++, .Net, ASP.Net, VB Script

RDBMS: SQL Server - 2008/2008R 2/2012/2014/2016/2017 , Oracle9i,10g,11g,12c

Scripting: T-SQL, PL/SQL, Power Shell Scripting, Batch Scripting

BI Tools: SSIS, SSRS, Power BI

ETL Tools: SSIS and DTS, SQL Server bulk insert and BCP utilities, SDT, Visual Studio

DB Utilities: SQL Server Management Utility, Query Analyzer, Database Engine Tuning Advisor

Ticketing Tool: ServiceNow, BMC Remedy, Jira

Cloud Technologies: Microsoft Azure, Azure Data Factory, Data Bricks, Amazon AWS, Google Cloud Platform, Big Query

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. ETL/SQL BI/Power BI Developer

Responsibilities:

• Responsible for maintaining quality reference data in source by performing operations such as cleaning, transformation and ensuring Integrity in a relational environment by working closely with the stakeholders & solution architect.
• Retrieving data from Amazon Redshift (AWS) and hive tables to provide meaningful analytics to end users.
• Used AWS EMR to transform and move large amounts of data into and out of other AWS data stores and databases, such as Amazon Simple Storage Service (Amazon S3)
• Extracting business data from different OLTP systems and loads into data warehouse using SQL server Integration Services (SSIS).
• Creates maintenance plans, stored procedures and functions using Transact-SQL to increase performance and ease of access for data manipulations.
• Hands-on experience with Amazon EC2, Amazon S3, Amazon RDS, VPC, IAM, Amazon Elastic Load Balancing, Auto Scaling, CloudWatch, SNS, SES, SQS, Lambda, EMR and other services of the AWS family,
• Utilizes SQL- DML, DDL, and DCL classes to setup, create, maintain, and manage SQL databases backend functions daily.
• Worked on AWS Data Pipeline to configure data loads from S3 to into Redshift.
• Defined and deployed monitoring, metrics, and logging systems on AWS.
• Provides application support and troubleshooting assistance to Clients.
• Responsible for creating documentation to assist my team to effectively transfer duties of different projects to one another.
• Technical problem-solving issues with internal tools such as image loading, OCR, document production, production history tracking and image tracking tools.
• Identify and implement new procedures to simplify and improve process.
• Cleaned and manipulated raw data.
• Collaborated with solution architects to define database and analytics engagement strategies for operational territories and key accounts.

Environment: MS SQL Server Management Studio 2017, SSIS, SSRS, T-SQL, Oracle 12c, Power BI Desktop, Power BI Dashboard, DAX Functions, Azure Data Factory (ADF), Amazon EC2, Amazon S3, Amazon RDS, Elastic Load Balancing, Auto Scaling, Python, TFS, Visual studio Data Tools 2015, PL/SQL, .Net, C#, Visual Basic, HTML.

Confidential, Fort Mill, SC

Sr. ETL/SQL BI/Power BI Developer

Responsibilities:

• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Work with business units to extract large or complex data sets from EIT (Enterprise Information Technology) sources (structured and unstructured).
• Explore, model, mine, and experiment with data to answer critical business issues.
• Designed DataMart can help in providing the business insights and business reportingacross the organization.
• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment experience in DWH/BI project implementation using Azure DF. leverages advanced analytics techniques and Artificial Intelligence (AI) in building the dashboard to evaluate, capture, and translate complex business questions.
• Mine customer viewership and internet consumption DataMart to provide business insights and business reporting across the organization.
• Created various pipelines to load the data from Azure data lake into Staging SQLDB and followed by to Azure SQL DB
• Develop customized calculated Columns and measure using DAX Formula language in Power BI to satisfy business needs.
• Deploying Azure Resource Manager JSON Templates from PowerShell worked on Azure suite: Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, Azure Analysis Service.
• Data mining, both independently and together with data science team.
• Builds interesting and appealing decks with visuals that bring the data to life to tell a story or create sleek interactive visuals for data exploration.
• Tweaking SQL Queries for best performance and recognizing areas for automation for all the reoccurring ad hoc requests.

Environment: MS SQL Server Management Studio 2017, T-SQL, Oracle 12c, Power BI Desktop, Power BI Dashboard, DAX Functions, Amazon Redshift (AWS), Data Analytics, Python, Google Cloud, Visual studio Data Tools 2016, PL/SQL, Unix.

Confidential, Charlotte, NC

Sr. ETL/SQL BI/Power BI Developer

Responsibilities:

• Analyzing the KPI's based on the end user requirements and needs to develop dashboards using Power BI.
• Extracting business data from different OLTP systems and loads into data warehouse using SQL server Integration Services (SSIS).
• Worked on providing row level securities using power bi to restrict data access for various users.
• Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Work closely with Client Services, Data Services and Document Control teams to understand project requirements and advise on best practices for project setup.
• Creates maintenance plans, stored procedures and functions using Transact-SQL to increase performance and ease of access for data manipulations.
• Creates and implements Microsoft Office Suite custom applications to interface attorneys with data and automates applications to assist with creations of document production sets and privilege logs.
• Provides application support and troubleshooting assistance to attorneys.
• Utilizes SQL- DML, DDL, and DCL classes to setup, create, maintain, and manage SQL databases backend functions daily.
• Data is integrated from multiple internal sources into an Azure SQL Server with Azure Data factory and Azure Automation
• Used SQL Azure Databases, Data Lakes, SSIS, and SSAS tabular models to capture features used to train risk attribute models used to score and identify high risk deals. involved in creating python scripts for cleanup and analysis of premium and policy data from various sources
• Used TFS (Team Foundation Server) and Visual studio Team services (VSTS) to share all the work, code, to sort out the exceptions raised during work.
• Responsible for creating documentation to assist my team to effectively transfer duties of different projects to one another.
• Technical problem-solving issues with internal tools such as image loading, OCR, document production, production history tracking and image tracking tools.
• Identify and implement new procedures to simplify and improve process.

Environment: MS SQL Server Management Studio 2017, SSIS, SSRS, T-SQL, Oracle 12c, Power BI Desktop, Power BI Dashboard, DAX Functions, Azure Data Factory (ADF), Python, TFS, Visual studio Data Tools 2015, PL/SQL, Crystal Reports, .Net, C#, Visual Basic, HTML.

Confidential, Albany, NY

ETL Developer

Responsibilities:

• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Creating, managing, and troubleshooting Windows Clustering and SQL Server high-availability solutions.
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS).
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Wrote Stored Procedures and Functions for better performance and flexibility.
• Deployed SSIS packages into various Environments (Dev, UAT and Prod) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse.
• Created and Designed Data Source and Data Source Views and configured OLAP Cubes (Star and Snowflake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube Partitioning in SSAS and enhanced the functionality in database and data warehousing concepts (OLAP, OLTP) Cube by creating KPI, Actions using SSAS.
• Ability to analyze business processes and document into an effective format for use in end user training
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, SQL, scripts, stored procedures, and views).
• Developed Aggregations, partitions, and calculated members for cube as per business requirements.

Environment: MS SQL Server 2014/12, Oracle 11g, T-SQL, Erwin, ASP.Net, C#, SSAS, SSIS (ETL), SSRS, Visual Studio 2012, Crystal Reports, UNIX, Toad.

Confidential, St louis, MO

SQL Server Developer/ Admin

Responsibilities:

• Based on the requirements created technical design specification documents for ETL Process.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging area.
• Involved in database and data warehouse design/administration, implementation, modification, and support.
• Involved in writing SQL queries, Stored Procedures and working with data in relational databases like Oracle, SQL Server, and MySQL etc.
• Involved in developing ETL Process to load the data from different sources into Enterprise Data Warehouse using ETL tools.
• Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data in the Enterprise Data Warehouse.
• Generated SQL and PL/SQL scripts to create and drop database objects including Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences, and Synonyms.
• Involved in analyzing schemas, tables, and Indexes as part of OPTIMIZATION.
• Used data pump to refresh the development and test database environment.
• Initializing (Data Validation) the production data to synchronize old data with new.
• Performed extensive unit and component testing for PL/SQL packages, ETL jobs involved in Data loading into Data Warehouse.
• Resolve system related problems; work independently and make necessary decisions throughout the systems process within department guidelines.

Environment: SQL Server 2008/2008R2,T-SQL, Oracle9i, DB2, PL/SQL, TOAD, SQL* Plus, SQL*Loader, AutoSys, Windows.

Confidential

Software Developer

Responsibilities:

• Applied Normalization rules in designing the database.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Tuned SQL statements using views and Stored Procedures.
• Designed Database objects including tables, procedures, views, and database triggers on SQL Server Database.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Created many complex Stored Procedures and used them in Crystal Reports.
• Created multi-format reports using Crystal Reports.

Environment: SQL Server 2012, T-SQL, SharePoint, Crystal Reports, Microsoft Visual Basic 6.0 and Windows