PROFESSIONAL SUMMARY:

• 8 years of experience in data modeling, database designing, product support, development and implementation of applications using Microsoft SQL Server suite of products.
• Extensive working experience with Business Intelligence Development Studio (BIDS) which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Proficient in developing SQL Server objects such as tables, views, user defined functions, indexes, stored procedures, functions, triggers, and CTEs.
• Expertise in extracting data from multiple tables using T - SQL joins, correlated and non- correlated sub queries.
• Experience in developing interactive data visualization reports, and dashboards using Power BI Desktop.
• Extensive working experience in developing SSRS reports such as tabular, matrix, cascading parameterized, drill down, drill through, custom reports using report builder and report designer.
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat files, excel, Oracle, DB2, and SQL server.
• Experience in Extracting, Transforming, and Loading (ETL) process involving large volumes of data from various data sources using SSIS.
• Worked on migrating and troubleshooting DTS packages to SSIS packages.
• Implemented event handlers, package configurations, logging, user defined variables, and expressions in SSIS packages.
• Worked on OLTP and OLAP systems. Created Tabular and Multi-dimensional cubes using SSAS.
• Also developed various ad-hoc reports from OLTP and OLAP databases.
• Experience in designing data warehouse using dimensional model schemas like star schema and snow flake schema.
• Expertise in populating dimension and fact tables of a data warehouse using SSIS packages.
• Experience working in agile environment and have good understanding of Software Development Life Cycle (SDLC) methodologies and principles.
• Worked on designing database models using MS Visio and Erwin.
• Experience in troubleshooting the database issues and resolve the incidents/tickets as per SLAs.
• Extensively worked on Performance Tuning Analysis, Query optimization, Avoiding deadlocks and Blocking, Backups, Disaster Recovery Planning.
• Created datasets based on MDX queries and implemented performance analysis of the SSRS reports.
• Experience in scheduling jobs using SQL Server Agent and involved in database administration activities such as backup, recovery, and replication of databases.
• Experience in performance tuning, query optimization, and database security by creating users and role based access to data.
• Responsible for coordination and execution of User Acceptance Testing (UAT) for standard and custom implementations.
• Facilitated technical trainings to clients/end users/support team.
• Worked on complex RDBMS table structures and ability to research application issues using SQL or related tools.
• Experience in source code management, reporting, requirements management, and project management using Team Foundation Server (TFS).

TECHNICAL SKILLS:

Database: MS SQL Server 2005/08/12/14/16, Oracle 11g, MySQL, MS Access

Data Warehousing & BI: SSMS, SSIS, SSRS, SSAS, DTS

Reporting Tools: SSRS, Excel, Power BI, Tableau

Data Modeling Tools: Erwin

Programming Languages: T-SQL, Java, VB Script, MDX, DAX

MS Office Suite: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, TFS

Ticketing Tool: ServiceNow, First wave

Web Services: SOAP UI, Rest API

PROFESSIONAL EXPERIENCE:

Confidential, Rancho Cucamonga, CA

SQL/Power BI Developer

Responsibilities:

• Worked on gathering business requirements from end users, developing and maintaining SSRS reports.
• Collaborate with cross-functional teams to help end users navigate the data and reporting to solve business problems.
• Developed SQL scripts to load data into enterprise data warehouse(EDW).
• Generated reports from OLTP and OLAP databases.
• Worked on developing Power BI reports and dashboards from multiple sources.
• Created dashboards and data visualization using Power BI desktop.
• Published reports and dashboards to Power BI Service through Office 365 integration.
• Created data marts and load data into dimension and fact tables by creating SSIS packages.
• Worked closely with application teams and be responsible for database query design.
• Developed and supported SSIS ETL packages to perform data loads from various types of source files to SQL server database.
• Handled incremental data load into staging and ODS databases.
• Performed SQL code review on new procedures and report queries created by consulting team.
• Used performance monitor and SQL profiler to optimize the SQL queries and enhance the performance of the database.

Environment: SQL Server 2016, T-SQL, SSRS, SSAS, SSIS, Visual Studio, Power BI

Confidential, Pittsburgh, PA

Power BI Developer

Responsibilities:

• Designed and developed tabular models and multidimensional models using SSAS based on the insights provided by the business users.
• Designed dimensions and hierarchies in SSAS cubes based on star schema from Data warehouse.
• Interacted with business users and analyzed the user requirements and built reporting solutions such as relational database reports, OLAP reporting, and dashboards.
• Created visualizations and dashboards using Power BI as per the requirements.
• Based on report requirements, I have created the calculated columns and measures using DAX in Power BI.
• Involved in user interface design of reports and layouts that were developed using Power BI.
• Used various Power BI visualizations such as clustered column chart, waterfall chart, gauge, pie chart, tree map, bar chart etc.
• Developed stored procedures and user defined functions to access data from data mart using T-SQL.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).
• Troubleshooted and resolved the issues with existing ETL process.
• Provided documentation for the new SSIS packages and procedures.

Environment: Power BI Desktop, SQL Server 2014, SSAS, SSIS, T-SQL

Confidential, Baltimore, MD

SQL Server/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

• Automated the execution of SSRS reports using subscriptions and data-driven subscriptions.
• Designed and maintained SSRS Reports using parameters and expressions.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Build different types of chart reports using SSRS like column chart and pie charts.
• Created sub reports and pass through parameters from main report to the sub reports.
• Generated various report models on views and deployed them on to the production reporting server and generated various report models and ad-hoc reports.
• Created dashboards, graphs, and power BI visualizations using Microsoft power BI desktop to improve business and decision taking.
• Wrote complex stored procedures, queries, triggers, functions, indexes, and cursors for application using T-SQL.
• Created reports from SSAS cube using MDX.
• Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension tables, Physical and logical data Modeling.
• Improved the performance of the slow running queries by using performance tuning.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.

Environment: SQL Server 2014, SSIS, SSRS, SSAS, Visual Studio

Confidential, Cleveland, Ohio

ETL Developer/Data Analyst

Responsibilities:

• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Responsible for deploying and scheduling the SSIS packages through jobs.
• Designed data models using Erwin.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Worked with T-SQL to create Tables, Views, and triggers and complex stored Procedures.
• Used Script task for Data Flow and Error Handling in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly, and yearly reports.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic backups with backup devices, database maintenance plans and recovery.

Environment: MS SQL Server 2012, SSIS, SSRS, T-SQL, Visual Studio 2012, Erwin, SQL Profiler.

Confidential, Overland Park, KS

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Created ETL packages to load transactional data to data warehouse and built analysis services database to provide summarized data for dashboards.
• Created custom measure groups in SSAS cube to implement business logic.
• Created roles and implemented security to restrict users to view the data.
• Migrated data from different heterogeneous sources such as flat files, excel, and SQL Server using SSIS and Bulk Insert.
• Designed and maintained SQL server views to support ongoing reporting and application requirements.
• Worked with team and created the data sets for reporting. Managed and supported the report environment.
• Used SQL server relational database and T-SQL query language to create new database objects as needed, including primarily tables, views, and stored procedures.
• Created reports with SSAS cube as the data source using SQL Server Reporting Services (SSRS).
• Maintained the Business Intelligence Incident Management queue.
• Responsible for trouble shooting, supporting, and enhancing existing production application reports.
• Provided business users the data required for metrics and analysis.
• Performed unit testing on the SSRS reports before deploying them to the production server.
• Provided the production support after designing and deploying the reports to production server.

Environment: SQL Server 2012, SQL Server Data Tools (SSDT), SSIS, SSRS, SSAS, T-SQL, TFS