SUMMARY

• Software consultant with 8 + years of extensive IT working experience as BI Developer in designing, developing, testing, deploying and documenting BI solutions with experience in installing, configuring and maintaining BI applications, user interfaces, server modules and their administration.
• Experience in gathering data requirements, business rules to build large enterprise warehouses.
• Experience in Installation, Configuration and Updates of SQL Server 2015/2017/2019.
• Expertise in BI Development and Deployment of DTS, SSIS packages from MS - Access, Excel, SQL Server.
• Comprehensive experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).
• Involved in maintaining the performance tuning of databases.
• Implemented data warehousing concepts like schema modeling and Schema designs in various Projects.
• Expertise with T-SQL (DDL & DML) in Implementing (Tables, Views, Indexes, sub queries, joins, Constraints, UNION Operators, Aggregate Functions, SQL Performance Tuning, Report Generation), and developing (Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes, Sub queries, Joins, SQL Functions).
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes to enhance SQL Server Performance.
• Experience in partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
• Exposure to ETL methodology for supporting Data Extraction, Transformations and Loading processing in a corporate - wide-ETL solution using SSIS.
• Experience in developing Dashboard, ad-hoc and Parameterized Queries for generating Tabular reports, drill down, drill through, click through, matrix, chart, snap shot reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SQL Server Reporting Services (SSRS).
• Worked on all activities related to high level design of ETL DTS package for integrating data from multiple heterogeneous data sources (Excel, Flat File, Text format Data) using SSIS
• Good knowledge of Normalization/DE-normalization, data design methodology and building Referential Integrity.
• Good Understanding of RDBMS concepts, Data Warehousing concepts, OLTP and OLAP.
• Worked cross-functionally to identify measures and key performance indicators to support business objectives and improve decision making processes.
• Creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis
• Developed Cubes and done Dimensional Modeling
• Knowledge of major cloud service providers, like AWS, Azure Databricks, Azure Data Factory, Azure SQL DW, Azure SQL DB.
• Used Azure Container Services to run the Azure Databricks.
• Developed ETL pipelines using Azure Databricks and Azure Data Factory.
• Strong experience in developing dynamic dashboards.
• Good Analytical and Communication Skills and has the ability to think outside the box.
• Excellent Communication, Interpersonal, Analytical skills and Strong ability to perform as Part of the team.

TECHNICAL SKILLS

Core Skills: Business Intelligence/SQL

BI Tools: SQL Server Integration Services (SSIS) 2016, SQL Server Reporting Services (SSRS) 2016, SQL Server Analysis Services (SSAS) 2016, Self BI with Excel

Databases: MS SQL Server 2005/2008/2012/2014/2017/2019 , Oracle 12c, MS Access, MongoDB

Operating Systems: Windows, Unix/Linux

Languages: T-SQL, PL / SQL

Other: Rally Software, Agile process

PROFESSIONAL EXPERIENCE

Confidential, NC

MSBI Developer

Responsibilities:

• Created Azure Data Factory pipelines to copy data from FTP server to Azure Blob storage and call SQL server Stored Procedures and also to call Azure Databricks Notebook.
• Created Databricks notebooks to import file, transformed the data and output to SQL server Database/Azure BLOB Storage.
• Involved in SSIS Migrations to Azure Data factory
• Designed and implemented Data Warehouse center by using Snowflakes Design method
• Involved in development of every phase of the project right from Requirements Analysis, Scoping, Designing, developing (SSIS, SSRS, and SSAS) Debugging, Testing and Documentation, deployment and UAT.
• Developed SSIS packages that can extract, load and perform a variety of transformations by using SSIS tools like Slowly Changing Dimensions (SCD), Change data capture (CDC), Checksum, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Migrated databases from various database sources like Sql Server, Oracle, Flat-files, upstream systems into Staging by using SSIS.
• Composed complex T-SQL Stored Procedures, Functions, Tables, Triggers, Views and Indexes
• Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
• Worked on Performance Tuning SQL, Query Optimization, identifying and resolving performance bottlenecks in various levels like sources, targets and mappings.
• Worked on creating 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.
• Extracted data from excels using the Control Flow and for Each Loop container transformations, cleansed and validated data then loaded into staging tables.
• Increased query performance, by performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard

Environment: MS SQL Server 2019/2018/2017/2019 , MS SQL Server Integration Services 2018, T-SQL, SSIS, SSRS, SSAS, ETL, SSMS, SSDT, Windows Server 2012, Visual Studio 2017, MS Visio, MS Access, MS Excel, MS word and MS PowerPoint

Confidential, VA

MSBI Developer

Responsibilities:

• Created conceptual, logical database and physical models
• Work with development, application and other data architects to provide an overall solution
• Create database objects like views, Stored Procedure, Trigger as per business requirements.
• Created stored procedures, Cursors, Joins in T-SQL.
• Designed T-SQL scripts to identify long running queries and blocking session.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Performed Performance tuning of SQL queries and Stored Procedures using Index Tuning Wizard
• Validate data before performing ETL transformations and load into SQL server database
• Migration of DTS packages to SSIS packages
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Extensively worked at Data Transformations like Derived Column, Row Count and Conditional Split, Aggregate, Merge join, Lookup, Sort & union all, Pivot, Unpivot and Audit to load data into Data Warehouse.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.

Environment: MS SQL Server 2017/2016, T-SQL, PL/SQL, SSIS, SSRS, SSAS, ETL, SSMS, SSDT, Windows Server 2012, HTML, CSS, JavaScript, Visual Studio 2008, MS Visio, MS Access, MS Excel, MS word and MS PowerPoint

Confidential, TX

Microstrategy Developer

Responsibilities:

• Worked with a highly distributed team of Business Analysts and developers to understand requirements for changes and enhancements to a custom web reporting and implement bug fixes.
• Worked on user requirements and functional design, and prepared technical specifications, unit test plans, and created a platform to run and validate the test cases.
• Created Reports for Health care Insurance enrollments.
• Created reports for Call center data, having consumers through the eligibility and enrollment process with Medicaid programs
• Developed tables and used stored procedures as per the report requirements.
• Experience in creating database objects and including databases, tables, indexes, views, Stored Procedures, Stored Procedures, Triggers, Functions and cursors.
• Developed SQL Server Integration Services (SSIS) ETL Packages and other back-end processes to support system integration and ETL process to facilitate the creation and population of Enterprise Data Warehouse
• Prepared source data for dimension ETL.
• Created a DTS package for incremental extraction.
• Deployed SSIS packages.
• Worked on Deployment of the packages into Production servers and managed scheduled SQL jobs.
• Captivated proper error handling techniques like logging, checkpoints, and event handler to handle errors in the package.
• Worked on Reporting subscription services such as data driven subscriptions for email and file sharing.
• Using MicroStrategy Desktop created Interactive reporting dashboards.
• Created documents for Health care Insurance Enrollments in MicroStrategy.
• Worked on creating Dynamic Dashboards with drill down options, panel stacks, selectors, widgets in flash mode to predict trend in market and produced interactive presentation using MicroStrategy desktop and web.

Environment: Oracle 12g, Pentaho Kettle, MicroStrategy Desktop 9.3.1, MicroStrategy Web, MicroStrategy OLAP, MS Visual Studio 2015, JIRA, MS Office 2010.

Confidential

Data Analyst

Responsibilities:

• Worked on requirement gathering on Agile Environment.
• Operated on the subject matter and business groups for requirement gathering.
• Worked on creating documents on conceptual and database design.
• Worked on creating various sources to load data into a unified model.
• Worked on complex SQL queries to parse Data.
• Worked on writing specifications for ETL process
• Developed each drop data model and build a primary data model.

Environment: Data Analysis, SSIS, SSAS, SSRS, Tableau, T-SQL.