SUMMARY

• 7 years of experience in Information Technology & Client/Server applications, covering all phases of Software Development Life Cycle Including Source gathering, Analysis, Design, Development & Implementation in large application development Projects.
• Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, DCL commands for various business applications.
• Involved in the Business Analysis of the OLTP and OLAP data and in decision support.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing.
• Proficient in Creating, Configuring and Fine-tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Experience in providing Logging, Error handling by using Event Handlers, and Custom Logging for SSIS Packages.
• Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.
• Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Involved in writing complex Stored Procedures, Functions, Views, Triggers, and Cursors for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle and flat files using connectors, tasks and transformations provided by SSIS.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Good knowledge at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions & features.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Strong Applications Development experience with back-end databases such as SQL Server, Oracle and MS Access using ADO/ADO.NET, OLEDB, ODBC and SQL client.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Knowledge and exposure Database management and monitoring, Performance Tuning and Solution design, on both Oracle and SQL servers.
• Good knowledge in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Trouble shooting and Database Objects authorization.
• Ability to communicate effectively and good interpersonal skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2016/2014/2012/2008/2005 , Oracle 9i/10g/11g, MS Access

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SSDT, Report Builder

ETL & Reporting Tools: Data Transformation Services, Visual Studio (SSIS, SSAS, SSRS, POWER BI), Excel, Power View, PowerPivot, Power BI

Scripting: HTML, DHTML, Visual Basic .Net, ASP.Net MVC, Shell Scripting, XML, Python.

Monitoring & compliance Tools: Lite Speed, Spotlight, SCOM, SQL secure

Languages: C#, SQL, PL/SQL, Python

Operating Systems: Windows, Linux.

Tools: TFS, SVN, GitHub

Cloud Tools: Azure SQL, Azure data Lake, Azure Data Warehouse

PROFESSIONAL EXPERIENCE

Confidential, Norfolk, VA

SQL BI Developer

Responsibilities:

• Gathering business requirement, developed Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• 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
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, and Fuzzy grouping etc. for creating many SSIS packages.
• Used SSIS and T-SQL stored procedures to transfer data from OLAP and OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Migrated all the packages to Test Environment and finally deployed from Test Environment.
• Scripting PowerShell to automate database/Server level activities like monitoring disk space, Status of services etc.,
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2016.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Generating reports though power BI application.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Coordinate with external teams to reduce data flow issues and unblock team members
• Actively participated in Sprint planning meetings, Daily Scrum, Sprint review meetings, and Sprint retrospective meetings.

Environment: T SQL, SQL Server 2016, MSBI Tools, Azure SQL, Azure Storage Explorer, Azure Blob, Power BI, SQL Server Management Studio, SQL Profiler

Confidential, Brentwood, TN

ETL/MSBI Developer (SQL/SSIS/SSAS/SSRS/Azure)

Responsibilities:

• Designed and develop SSIS packages to Extract transform and load data from various data sources into SQL server.
• Automating SSIS Execution using Windows Scheduler using DTExec Command.
• Created logging, custom logging and error handling packages.
• Grouping, aggregating, and splitting data using SSIS.
• Scripting using SSIS for data cleansing, encrypting, decrypting sensitive information.
• Created multiple pipelines, different datasets to copy data and performing bulk inserts from OnPrem to Azure Database/Across Azure using Data Factory and Blob Storage securely using Access Keys, SAS Tokens.
• Migrated databases to Azure and managing them, setting up security, creating Data Sync, maintenance jobs using Azure automation via runbooks and troubleshooting failed jobs.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Developed SSIS packages to automate different FTP’s files and emailing to different clients.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.

Environment: MS SQL Server Enterprise Edition, MDS, SSIS, SSRS, Azure SQL, Azure Storage Explorer, Azure Blob, C#, Windows Server, Visio.

Confidential, Plainsboro, NJ

MSBI Developer (SQL/SSIS/SSAS/SSRS)

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing Ad Hoc Reports.
• Developed functions, procedures and packages to implement the system's business logic using TSQL.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Installed and configured master data services (MDS), IIS, SQL Server Data Quality Services (DQS) in MS-SQL server.
• Worked on the RDBMS system using TSQL to create packages, procedures, functions, triggers as per the business requirements.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
• Developed unit test plans for SSIS packages.
• Modified the existing SSIS packages to meet the changes specified by the users. Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Responsible for validation and deployment of SSIS packages from development to QA and production environment.
• Developed SSAS Cubes, partitions, aggregation from scratch with Star Schema.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Developed custom Ad Hoc Reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic Ad Hoc Reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Worked as developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL and PL/SQL code and SQL joins for applications.
• Created new tables, written stored procedures for applications developer and some user defined functions and created TSQL/PL-SQL scripts.

Environment: MS SQL Server Enterprise Edition, MDS, SSIS, SSRS, C#, T-SQL, PL/SQL.

Confidential, Addison, TX

SQL Developer

Responsibilities:

• Developed ETL jobs like data transformation using Microsoft SQL Server Integration services.
• Created SSIS packages, staged data from different data sources into a SQL Server Database using SQL Server Integration Services.
• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications.
• Developed SQL Server reports on daily performance of databases using SQL Server Reporting Services.
• Administered minor databases of the facility using SQL Management Studio.
• Performance Tuning and Maintenance plan for consistency checks, backup/restore and Rebuild Indexes.
• Wrote stored procedures using T-SQL and implemented them.
• Conducted code review.
• Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.

Environment: SQL Server, SSIS, SSRS, T-SQL, SSMS.

Confidential

ETL Developer (SQL/SSIS/SSAS/SSRS)

Responsibilities:

• Understood existing business model and customer requirements. Prepared business and technical understanding documents for the existing applications.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2010. Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Worked on migration to SSIS packages across instance; also, tuning of SSIS packages and T-SQL queries. Fields are updated on time basis like day, month, quarter, year using SSIS packages. Monitored performance and optimization of SSIS packages for maximum efficiency.
• Created cubes in SSAS using multi-dimensional model based on business requirements and created additional measures. Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
• Generated SSRS Dashboard with quick/context/global filters, parameters and calculated fields on SSRS reports. Created SSRS Dashboards with interactive views, trends and drill downs along with user level security.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using SSAS and produced ad-hoc, standard and super user Ad Hoc Reports using SSRS.
• Understood and modified the data as per the requirement using the Query Editor and Data view in SSRS. Handled transformations on the data using Power Query in SSRS.
• Experience with SQL Server Reporting Services (SSRS) to author, manage and deliver paper-based, Web-based reports and Interactive Dashboards.
• Migrated different kinds of records using Reporting Services Migration Tool by performing necessary steps to prevent loss of reports. Automated few of the daily routine tasks thereby reduced few man hours of effort.
• Involved in the preparation of the unit test case documents and unit testing of the enhanced macro codes, T-SQL queries. Prepared detailed document of the know issues for future reference.
• Involved in Web Application using MVC3.

Environment: Windows server 2008, SQL Server 2008, Microsoft BI Suite 2008, C#, Microsoft Visio.