SUMMARY:

• Around 6 years of IT experience in SQL Server development, Data Warehousing, SSIS development, Database Modelling, Data Analysis, Design, Testing, and support of MS SQL Server in production.
• Experience with all stages of software development life cycle (SDLC), Agile/Scrum and Project management methodologies.
• Involved in Requirements gathering/analysis from business users, performing data mappings and documentation.
• Experience in working with different RDBMS and NoSQL DB such as Oracle, MS SQL Server, Hadoop, Teradata etc.
• Strong experience in developing and debugging SSIS packages.
• Experience in designing ETL data flows, creating mappings/workflows to extract and migrate data from various heterogenous sources like flat files, CSV, Excel, MS Access, Oracle, XML and various RDBMS using SQL Server Integration Services (SSIS).
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views, Indexes, Triggers and Cursors.
• Experience in generating complex Transact SQL (T-SQL) queries, Sub queries, Dynamic SQL queries, DML, DDL involving multiple tables and exception handlers.
• Experience in creating, updating clustered and non-clustered Indexes to keep up the SQL Server Performance
• Experience in creating and managing indexes to achieve better query performance, and expertise in performance tuning and query optimization.
• Power BI experience in designing Interactive Reports, pages, visualization, dashboards using DAX, Power Query, Power Pivot, Power View.
• Extensive experience using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server for generating drill down, drill through, parameterized reports, Cascaded reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Proficient in generating reports and Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Experience working with Microsoft cloud’s ADL (Azure Data Lake), and ADS (Azure Data Storage).
• Experience working with USQL (Unified SQL), to deal with bigdata that resides in Microsoft cloud Azure.
• Self-motivated to take responsibility and contribute to be a productive team member. Strong team building, mentoring skills and excellent leadership capability.
• Excellent communication and inter-personal skills.

TECHNICAL SKILLS:

Reporting tools: Power BI Desktop, Tableau Server, SSRS, Excel

Programming Languages: TSQL, PL/SQL, Java, HTML, CSS

RDBMS: Oracle 9i/10g/11g, MS SQL Server 2014/16, MS Access, Teradata

Methodologies: Agile Modeling, Scrum Model, SDLC model

Machine Learning: Linear Regression, SVM, KNN, Naïve Bayes, Random Forest, SVM, Logistic Regression, K-means Clustering

Statically Programming Languages: Python, R

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

BI/SQL Developer

Responsibilities:

• Developed and maintained ETL mappings for loading fact tables, aggregate fact tables, SCD and staging tables.
• Gathered, analyzed, and documented requirements for generation of reports and ETL development.
• Involved in creating Views and Stored procedures for the performance of the complex business reports.
• Developed SSIS templates which can be used to develop SSIS packages such a way they can be dynamically deployed into Dev, Test, and Production Environment.
• Executing data validation stored procedures in SSIS packages using Business Intelligence Development Studio.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Employed many Slowly Changing Dimension methodologies to maintain and update historical data.
• Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads
• Created newSSISpackages as per the requirement and assigned SQL Jobs through Job agent. Worked on providing Logging, Error handling forSSISPackages.
• CreatedSSISpackage to Export and Import data from SQL Server to Flat files and Excel files.
• Developed SSIS/ODI extract jobs from different databases/files and API’s and load the data into an On-Prem oracle database.
• Was involved in creation, managing, and optimizing performance for Views, Procedure, Triggers, Table and Functions.
• Identify and solve performance bottlenecks inSQLServer.
• Tune/optimizeSQLqueries and indexes.
• Used Data Analysis Expression Language (DAX) in creating different calculated measures, columns in the Query editor.
• Creating pipelines using Azure Data factory and Azure apps services to pull data from Webservices and APIs in Azure SQL.
• Involved in prepping data from Azure Data Lake and Azure SQL database. The data is pulled into the Power BI service for in depth analysis.
• PerformedPowerBIDesktop Data modeling, which cleans, transforms, mash up Data from multiple sources.
• UsedPowerBIPowerPivot to develop data analysis reports and usedpowerview to visualize the reports.
• Following the best practices and up to date technology user Experience (UX) viz and dashboards.

Environment: MS SQL Server 2016/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2012/2015/2017, C#, SQL Server Profiler, Power BI, Power Query, SSMS, Business Objects, SharePoint 2012.

Confidential, Conshohocken, PA

BI/SQL Developer

Responsibilities:

• Participated in migrating existing tradition SQL application into Microsoft cloud ADL.
• Participated in research and analysis of the new programming language USQL for handling data within the cloud environment.
• Created Azure Data Storage accounts within the Azure Data Factory for storing bigdata inside the cloud.
• Created views using stored procedures, functions to create specific Tableau reports minimized the time, increased the accuracy and efficiency of work by 20%. Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters, and calculated fields on Tableau reports.
• Analyzing the client data and providing the legitimate insights over the businesses by creating ad-hoc and ongoing reports was one of the key responsibilities of my job.
• Adept in design and development of SQL Server Integration Services (SSIS) packages using various control flow task and data flow transformation.
• Translated Business requirements into BI application designs and solutions.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL server toTableau/ SSRS.
• Worked extensively with Advance analysis, Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploadedtableaudashboards on to server and provided production support fortableauusers.
• Knowledge of working on Spotfire and Informatica while getting the data from different resources.
• Assisted in ETL processes like Bulk insert, BCP, data conversion, conditional split, merge, and union all.
• Defined and created procedures to installTableaudesktop in silent mode and best practices forTableaureport development.
• Technically proficient in SQL, QVD creation, JavaScript, CSS, JSON, HTML5 and interaction with the Qlik Sense API
• Interacted with business users to collect and understand Business Requirements.

Environment: SQLServer 2016/2014/2012, SSIS, SSRS, Tableau, Visual Studio,SQLServerManagement Studio, USQL, ADL

Confidential

SQL Developer

Responsibilities:

• Gathered requirements and refined business requirements from the Team lead and Manager.
• Written SQL queries, complex join condition, and subqueries.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Effectively interacted with Team in Analysis, Design and Develop database using ERDiagram, involved in Design, Development, and testing of the system.
• Involved in the continuous enhancements and fixing of production problems generated in server-side scripts for data manipulation and validation and materialized views for remote instances.
• Created indexes on the table for faster retrieval of the data to enhance database performance.
• Creating and automating the regular Jobs.
• Used SQL profiler to trace out problems in slower execution plans.
• Rebuilt Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.
• Created complex SSIS packages using data transformations like conditional splitting, fuzzy lookup, multi cast, column conversion, fuzzy grouping, and script components.
• Scheduled and monitored SQL Server Agent jobs to run the SSIS packages and stored procedures.
• Designed complex packages with error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task filed types.
• Used SSRS to generate sub-reports, drill-down, drill through and parameterized reports.
• Created Dashboards, Tabular, Matrix reports, charts and graphs as per customer requirements using SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries, and Functions. Created reports to retrieve data using Stored procedures that accept parameters.

Environment: SQL Server 2012, SQL Server Management Studio (SSMS), Business Intelligence Studio (SSIS, SSRS), T-SQL, MS Excel.

Confidential

SQL Developer

Responsibilities:

• Developed SQL triggers, Stored Procedures, User Defined Functions and Views
• Resolved issues in existing code for various modules and adding new functionality upon the requirement.
• Worked on workflow optimization to reduce the query execution time for better performance.
• Developed scripts for Rules Based Notifications (RDN) for reducing the execution time of existing SQL queries that are used in Java coding.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Developed, Monitored and Deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Performed job scheduling and alerts.
• Resolved any deadlock issues with the databases/servers on a real-time basis

Environment: MSSQLServer 2008, SQL, SSIS (2008), T-SQL, Excel, Visual Studio