SUMMARY

• Over 7 years of industry experience as a MS SQL Developer, Business Intelligence focus on financial area, Insurance, Health care offering various business solution strategies through SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS) using SQL server ( 2017/2016/2014 /2012 )
• Proficient in Data Warehousing methodologies and concepts, including Star schemas, Snowflake schemas, ETL processes, Dimensional modeling and reporting tools
• Experience in interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables
• Vast experience in extracting, transforming and loading (ETL) data from OLTP (transactional) databases and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, in SSIS using various tasks and transformations
• Expert in programming Tables, Views, Stored Procedures, User Defined Functions (UDF), Constraints, Indexes, Temporary tables, CTEs and Triggers to optimize retrieval
• Experience in creating ETL mappings in SSIS to load data from different sources to different target databases and data analysis, data profiling, data transformation, data mapping and data cleansing
• Expert in different components of SSIS (Control Flow, Data Flow and Connection Manager) while extensively using different kinds of Containers, Control Flow Tasks and various Transformations under data flow tasks
• Expert in developing T - SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues including complicated joins and cursor loops, creating indexes for fast retrieval of data, creating views, triggers, cursors, stored procedures and functions
• Worked in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and Dimensional Tables
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of some other region
• Good knowledge in optimizing queries using DAX and MDX
• Extensive experience with all phases of Software Development Life Cycle (SDLC)
• Expertise in Business Intelligence Process for Data Integration services
• Experience in using Microsoft .NET framework for SQL Server Integration Services (SSIS) packages for logging programmatically and managing, automating Control flow, Data flow and Events
• Skilled in error and event handling: Implemented check points, break points, event handlers, troubleshooting, and error handling in SSIS packages to improve usability and liability
• Working knowledge in Agile/Scrum Environment and used TFS (Team Foundation Server)
• Good knowledge of Data Marts, OLAP, Dimensional Data Modeling for FACT and Dimension Tables using Analysis Services
• Expert in creating and modifying different types of ad-hoc reports including parameterized, linked, drilldown, drill-through, sub-report, matrix, tabular, and dashboard reports as well as Reports with complex join queries in SSRS
• Published reports to Azure based Power BI services (Pro) and schedule subscription
• Experienced in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling SQL Server Agent Jobs
• Implemented Report server configuration, Deployed reports, created data driven subscriptions in Development, Test and Production environments
• Expertise in Debugging, Optimizing and Performance Tuning of MS SQL SERVER 2017/2016/2014 /2012 Dashboards / Reports
• Experience in developing ad-hoc reports using Report Builder
• Experienced in using Power BI and Tableau to do better data visualization and reports
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Programming Languages: C, C++, Python, JAVA, PL/SQL, SQL

Web Technologies: HTML5, CSS3, XML

IDEs: SQL Server Management Studio, Visual Studio 2017/2015/2013 , Eclipse, PyCharm

Databases: MySQL, Microsoft SQL Server 2017/2016/2014 /2012 , Oracle 11g

ETL Tools: SQL Server Integration Services (SSIS) 2016/2014

OLAP Tools: SQL Server Analysis Services (SSAS) 2016/2014

Software: MS Office, Adobe Photoshop

Reporting Services: SQL Server Reporting Service (SSRS) 2017/2016/2014 , Power BI, Tableau, Excel

PROFESSIONAL EXPERIENCE

Sr. BI Developer

Confidential, Phoenix, AZ

Responsibilities:

• Gathered requirements, analyzed and designed the system
• Loaded data from various sources like OLEDB, Flat files to SQL Server database using SSIS packages and created data mapping to load the data from source to destination
• Proficient in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions
• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers and Queries with best execution plan
• Successfully migrated data between different heterogeneous sources such as flat files, Excel using SSIS
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Used Configuration Files in SSIS to ease the process of moving the packages across servers
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow
• Task, Sequence Container, For Each Loop Container, Lookup and Aggregate
• Involved in creating multiple parameterized stored procedures which were used to generate reports, with Cascading Parameters and Interactive charts in SSRS
• Upgraded Excel reports to SSRS reports. Configured and deployed SSRS reports onto Report Server
• Used Report Builder to edit reports on the SSRS server
• Published Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and created Tabular and Sub reports
• Monitored performance and optimized SQL queries for maximum efficiency
• Created SSIS Packages to perform cube processing from staging area to Analysis Services cubes
• Proficient in working on Cube structure optimization for MDX query performance in Analysis Services (SSAS)
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules
• Built KPI reports for the cubes and optimizing the reports
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Environment: SQL Server 2017, Server Integration Services 2016, SQL Server Analysis Services 2016, SQL Server Reporting Services 2017, Tableau, MS Excel, Visual Studio 2017

BI Developer

Confidential

Responsibilities:

• Wrote complex SQL queries to retrieve information from the databases to match to the requirements.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views.
• Created and scheduled reports / dashboards.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into another database.
• Created Package Configuration files to support the SSIS packages in different environments.
• Generated Dynamic Reports from Cubes using SSRS 2017.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Generated Multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drill downs, drill through, sub reports, navigation reports (Hyperlink), List Reports, Conditional, Pie Chart Reports.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.
• Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2017.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Utilized SQL Server Integration Services to developed, monitored and deployed SSIS packages as well as to produce Data Mart.
• Implemented Performance Tuning and Query Optimization.
• Worked on identifying and resolving blocking and deadlocks.

Environment: SQL Server 2017, XML, T-SQL, Server Integration Services 2016, SQL Server Analysis Services 2016, SQL Server Reporting Services 2017, MS Excel, MS Access, Visual Studio 2017

MSBI Developer

Confidential

Responsibilities:

• Worked as a Lead in the development of the back-end systems.
• Created and maintained Users, Security Permissions and migration of the database objects from one server to another server.
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.
• Designed complex queries and stored procedures for high performance reporting and rendered them to HTML, PDF and EXCEL formats using reporting services.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files and XML etc.) and loaded the data into target data sources by performing different data transformations using SSIS.
• Involved in various Transformations in SSIS Dataflow, Control Flow using For Loop Containers etc.
• Implemented Event Handlers & Error Handling in SSIS packages & notified process results to various user communities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries by using Inner, Left, and Right Joins, database links to fetch complex data from different tables in remote database and formatted the corresponding results into reports and kept logs.
• Proficiently processed cubes, partitions in SSAS as and when required.
• Generated Multiple reports using SSRS from SQL Server Database and included various reporting features such as drill-drown, drill-through, navigation (hyperlink) reports.
• Developed reports that monitor different trends and patterns at city and state level which helps in identifying underperform assets.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Created business critical KPI’s using SQL Server Analysis Services (SSAS) representing aggregations in several different ways- hierarchically and using custom groupings that the company will use to analyze performance.
• Experienced in creating Jobs Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Developed Custom Functions that the company will use to analyze performance.

Environment: SQL Server 2016, T-SQL, SQL Server Integration Services 2016, SQL Server Analysis Services 2016, SQL Server Reporting Services 2016, MS-Excel, Visual Studio 2017.

SQL Developer

Confidential

Responsibilities:

• Gathered functional requirements and Business requirements and noted the technical specifications for building the Global Enterprise Data Warehouse
• Worked closely with end users in designing and creating the Global Enterprise Data Warehouse
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Implemented member properties, dimension custom rollups, write back, action and drill through
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions
• High Level Design of ETL SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data)
• Created Drill through, Drill down, Cross Tab Reports and Sub reports using RDL
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2014 that stored and maintained the data
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions
• Deployed database objects from Development/Testing environment to Production environment
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
• Designed reports, graphs and deployed reports to web applications using SSRS

Environment: SQL Server 2014, SQL Server Analysis Services 2014/2016, MS-Excel, Visual Studio 2015.

SQL Developer

Confidential

Responsibilities:

• Generated Script files for changes made to stored procedures or views or any other database objects.
• Designed Database Models, Entity Relationship diagrams.
• Used SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data, loading operations for application.
• Managed the use of disk space, memory and connections.
• Created complex queries by using Joins and Sub Queries.
• Worked with Flat Files, OLE DB Source, and Excel Source loading.
• Worked on Clustered and Non-Clustered index to improve the access of data within the database.
• Ran DBCC consistency checks, and fixed data corruption in application databases.
• Installed SQL Server service packs based on the errors and flaws that are found in the application.
• Generated Multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drill downs, drill through, sub reports, navigation reports (Hyperlink).
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Monitored MS SQL server for performance and network issues.
• Involved in designing visual report solutions, including dashboards using SSRS.
• Created and Rebuilt the Clustered & Non-Clustered indexes at regular intervals for better performance.
• Provided problem resolution, troubleshooting, tracked and resolved issues in the database environment.

Environment: SQL Server 2012, SQL Server Integration Services, SQL Server Reporting Services, MS Office, Visual Studio 2013.