SUMMARY

• SQL BI Developer wif experience of 8 years on SQL Development in Banking, Insurance, Healthcare Telecommunications wif a strong understanding of data and analytics.
• Profound knowledge of Software Development Life Cycle (SDLC) wif thorough understanding of various phases like Requirements Gathering, Analysis, Design, Development and Testing.
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2005/2008/2012/2014/2016.
• Proficient in writing complex SQL queries, Stored Procedures, Normalization, Views, Database Design, creating Indexes, Functions, DDL/DML Triggers,CTE’s and Sub - Queries using T-SQL
• Experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Solid expertise in database development for both Online Processing & Batch Processing (OLTP) and OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2005/2008/2012/2014.
• Created SSIS Packages to perform filtering operations. Migrating data from teh OLTP system and multiple excel files to SQL server.
• Extensive understanding of managing and automating Control flow, Data flow, Events and Logging for SSIS packages.
• Expertise in Normalization/De-Normalization, data design methodology and building Referential
• Integrity Constraints for teh relational and dimensional database models
• Strong experience in error handling, product support, debugging, testing and error logging for SSIS
• Worked wif different Control flow tasks in creating SSISpackages especially For Loop and For Each Loop containers wif Execute SQL and Script Tasks.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Service SSAS.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad Hoc Reports and distributed reports in multiple formats using SSRS.
• Expertise in designing, developing, and deploying several kinds of reports and dashboards using SSRS using relational and multidimensional data.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub reports and formatting them.
• Created POWER BI reports effective dashboards after gathering and translating end user requirements.
• Experience in connecting MicrosoftPOWER BIDesktop to various data sources, Publishing POWER BI Desktop reports to POWER BI Services.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.

TECHNICAL SKILLS

Data Warehousing & BI: SQL SERVER Business Intelligence Studio (SSIS, SSAS, SSRS, DTS)

Reporting Tools: SSRS 2016/2014/2008 R2/2005, Crystal Reports13/11/08/XI, Excel, POWER BI Desktop

Database: MS SQL SERVER 2016/2012/2014/2008 R2, Oracle 12c/11g/10g/9i, MS-Access.

Programming: C, C++, Visual C++ 2010,ASP.Net, VB6.0, C#.Net, VB.Net, PL/SQL.

Database Design Tools: Erwin 9.6, MS Visio 2010/2013, ER Studio Rational Rose(UML),Kimball & Inmon Methodologies

Tools & Technologies: Performance Point Server 2007(ProClarity), Enterprise Manager, SSMS, EMC Networker, Database Tuning Advisor, DTS, Analysis Manager, BCP, Visual Studio, QTP, Microsoft Office.

Version control: Visual SourceSafe 2005, Team Foundation Server

Operating System: Windows Vista/NT/XP/ 2010/2008/2007, Windows 2016/2012/2008 Server, UNIX.

Application Servers: Microsoft IIS 10/8.5/8, Apache.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SQL/SSIS/SSRS/SSAS/POWER BI Developer

Responsibilities:

• Developed Complex Stored Procedures, Common Table Expressions(CTE’s) Views and Temporary Tables in T-SQL as per teh requirement.
• Involved in writing T-SQL Programming for implementing Complex triggers and User Defined Functions for different tasks using SQL SERVER 2016
• Facilitate procurement management in project data analysis and procurement data analysis, as well as weekly and monthly overall department data analysis by using advanced Excel skills.
• Responsible for Deploying teh SSIS packages and scheduling teh package through Jobs in all Tiers including Dev, UAT and Prod, Setting teh Configuration files which is done in teh specified tables and created technical specs documents for all teh enhancements.
• Performed ETL (Extraction, Transformation & Loading) operation using SSISPackage for loading Daily Transactions using SQL Server Data Tools 2015.
• Deploying and scheduling SSIS packages and jobs using SQL server agent and few were deployed as active directory jobs as well.
• Used Script task for Data Flow and Error Handling inSSIS using VisualStudio2015.
• Worked through all teh phases of Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, Production and Post-Production Support.
• BuiltSSIS using packages to Load data from source systems to DW.
• Built SSISpackages for Dimension and fact tables.
• Involved in Writing SQL Queries, Views,CTE’s and Stored Procedures on SQLServer 2014
• Created Calculated Columns and Measures in Power BI and Excel depending on teh requirement using DAX queries.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS visual studio data tools 2015
• Created multi valued parameters & cascaded parameters in teh reports using MDX and T-SQL.
• Created MDX queries to retrieve data from teh cube and to display SSRS reports.
• Automated teh SSIS Packages using teh SQL Server Agent Jobs and troubleshooted teh SSIS/SQL job Agent whenever necessary.
• Created Power BI Reports using teh Tabular SSAS models in Power BI desktop and published them to Power BI Service using star schema.
• Employed bar charts, bubble charts, and Power map to answer business questions wif Power BI.
• Mapped millions of records over Bing maps from Excel data model and discovered actionable insights for strategic planning utilizing Power BI (Power Map).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI's & MDX Queries using SQL Server 2016 Analysis Services.
• Deploy SSIS Package using SQL Server Data Tools 2015 into Production and used Package configuration to export various package properties to make package environment independent. Designed databases and relevant objects through preparation of tables, groups, and indexes.
• Created Dimensions and cubes wif star schema using SQL SERVER Analysis Services (SSAS) using SQL SERVER DATA TOOLS2015.
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
• Design, deployment, and maintenance of various SSRS Reports in SQL SERVER 2014
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL SERVER and non-production database code as well as T-SQL code from Developers and QA.
• Developed Star schema using SSAS cubes.

Environment: SQL SERVER 2016/2014 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, TFS-Team Foundation Server Version Manager, Ceridia HR Tool, SQL Agent, Office-2013, MS Excel, Power BI, Power-Pivot, .Net (C#, VB), Service Now, Erwin r7.3, ER Studio,SQL SERVER DATA TOOLS2015.

Confidential, San Diego, CA

SQL Developer/SSIS/SSRS/SSAS/Power BI

Responsibilities:

• Created & Implemented Database Components Databases, Tables, views, Constraints, Stored procedures, CTE’s Views and Functions using SQL Server 2012/2014.
• Proficient in writing advanced T SQL Server Queries, experience in DW concepts, report development, ETL development & tuning and data model development.
• Generated T-SQL scripts for Data retrieval, Manipulation & Validation for various applications.
• Involved in Performance Optimization of Queries & Stored Procedures by analyzing Query Plans, blocking queries, Identifying missing indexes etc.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS) SQL SERVER DATA TOOLS2015.
• Loaded flat files into SQL Server tables and vice versa using SSIS SQL SERVER DATA TOOLS 2015.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Created multi-dimensional cubes using SSAS and designing DW schemas.
• Created SSIS Packages using Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text file, and CSV files to data warehouse
• Created perspectives in SSAS and configured security levels for teh Cubes.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created logging, custom logging and error handling packages.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Created SSAS packages, OLAP cube, and multi-dimensional modeling on Terabytes Database, and worked in Designing and Building Dimensions and Facts wif star schema and snowflake schema using SQL Server Analysis Services (SSAS) 2015.
• Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS Visual studio 2015
• Used SSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS using visual studio data tools 2015.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports, and Charts.
• Created MDX queries to retrieve data from teh cube and to display SSRS reports.
• Created reports to generate them through Email for teh administrative using MDX Queries.
• Experience in creating measures and calculated columns using DAX in Power BI.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports
• Built Ad-Hoc reports in Power BI depending on business requirements was one of teh major responsibilities
• Publishing Power BI Reports from Power BI Desktop to Power BI Service.
• Creating multiple kinds of Power BI Reports, Dashboards and Visualizations.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.

Environment: MS SQL Server-2014/2012 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, SQL Agent, Office-2013, Power BI, MS Excel, Erwin r7.3, ER Studio

Confidential - Philadelphia PA

SSIS BI Developer

Responsibilities:

• Created/debugged complex Stored Procedures which are used to calculate & validate financial data by tracing them using SQL Profiler.
• Worked on Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification and OLAP.
• Involved in designing and developing logical and physicaldata modelsto best suit teh requirements.
• Used SQL Profiler to trace/debug/optimize SQL queries/Stored Procedures fired using User Interface (UI).
• Optimized slow performing SQL queries, Stored Procedures, views, functions by analyzing their Query Execution Plan and by using techniques like creation of Index on a table, creating Indexed or materialized view, using lock hints etc.
• Created User Logins for various business departments, applications and granted controlled rights to them to access various database objects like tables, views and stored procedures.
• Created SQL Scripts to fix production data issues.
• Implemented teh slowly changing dimensions (SCD) type 1 and type 2 to maintain current information and history information in teh dimension tables.
• Extensively used Execute SQL Task, Data flow Task, look up, Script logic component, Union All tasks in SSIS packages in coding, testing, implementing.
• Involved in data profiling, identifying data quality issues by doing data analysis, impact analysis, and data model enhancements
• Designed and developed ETL solution using MS SQL Server and SQL Server Integration Services (SSIS).
• Used Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component while creating SSIS Packages.
• Created Jobs and scheduled Packages using SQL Server Management Studio for teh Daily/Weekly Load.
• Documented whole ETL Process using MS Visio.
• Used TFS for version control and configuration management.
• Created detailed source to destination (target) mapping documents explaining things like business rules, error handling strategy, restart/reload strategy etc.
• Used data analysis techniques to validate business rules and identify low quality missing data in teh existing data.
• Developed SSIS packages to automate data retrieval data from Oracle, SQL Server, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used T-SQL to manipulate and architect to produce results for users.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: MS SQL Server 2012/14, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, SQL Server Management Studio (SSMS). Visual Studio 2012, Windows Server 2012, Microsoft TFS, MS Access, T-SQL and SQL Profiler, SAS, Crystal Reports.

Confidential, Austin, TX

SQL System Analyst/ BI Developer

Responsibilities:

• Interacted wif teh Business Analysts for requirement analysis and created Functional Specification Documents based on teh business requirements.
• Worked through all teh phases of Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, Production and Post-Production Support.
• Developed many Stored Procedures and User Defined Functions for providing input feed for front end applications.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Employed process and data analysis to model a Customer Information Business System.
• Implemented different types of constraints on tables.
• Performance tuning on existing stored procedures and existing reports for teh faster processing of reports.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard to improve teh performance and implement teh best practices. Troubleshooting performance issues, fine-tuning queries & stored procedures.
• Used TFS-Team Foundation Server for Version Controlling.
• Experience in migrating some of teh DTS packages in to SSIS.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed reports using SSRS and Crystal reports. Used table control, matrix control for cross tab reports.
• Configured Reporting Services in SQL SERVER.
• Troubleshooting performance issues wif Fragmentation using Profiler, System Monitor, and DMV’s.
• Configured nodes and virtual server to set up Active/Active Clustering.
• Import Data from MS-Access Database and XML to SQL SERVER Database.
• Performed daily tasks including backup and restore by using SQL SERVER tools like SQL SERVER Management Studio, SQL SERVER Profiler, SQL SERVER Agent, and Database Engine Tuning Advisor

Environment: SQL SERVER 2012, Enterprise Edition, SQL, Enterprise manager, SSRS, SSIS, Spotlight, MS Access 2000 & Windows 2003/2000 platform, C#, VB.NET, ASP.NET.

Confidential, Rocky Hill, CT

SSIS/Data Warehouse Developer

Responsibilities:

• Designed and developed OLAP cubes for Multi-dimensional data reporting using SSAS 20012.
• Worked on Data models for teh Multi-dimensional databases and data warehouses.
• Developed SSIS Packages Scripts to extract data from teh numerous data sources.
• Created and restored SSAS database backups from development to production servers.
• Worked as a developer to tune teh queries, run scripts and move teh database from production to development servers
• Develop SQL Server Stored procedures and SSIS Packages Scripts to extract data from teh database.
• Worked on creating Excel Pivot tables and charts shows teh summarized data and gives teh control to teh user on how they want to view teh data.
• Designed, developed, debugged and tested reports in SQL Server 2012 Reporting Services (SSRS)
• Created User Interfaces for Multidimensional models using SSRS reports.

Environment: SQL Server 2008, SSAS, SSRS, SSIS, SSMS, SQL Server Jobs.

Confidential

BI ETL Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers
• Wrote efficient Stored Procedures for teh Optimal Performance of teh system
• Monitored performance and optimized SQL queries for maximum efficiency
• Created and Modified T-SQL Stored Procedures/ triggers for validating teh integrity of teh data
• Created Star Schema Cubes using SSAS and Managed OLAP Cubes using SSAS
• Created indexed views and appropriate indexes to reduce teh running time for complex queries
• To keep track of data manipulations using Audit functionalities
• Generated custom and parameterized reports using SSRS
• Created reports that call Sub reports in SSRS
• Configuration and Deployment of all teh Reports using Report Definition Language and Remote Data Service (RDL, RDS) across various SDLC environments
• Developed Complex SSRS Reports involving Sub reports, Matrix/Tabular Reports, Charts and Graphs
• Created several packages in SSIS
• Scheduled teh packages to keep extracting teh data from OLTP at Specific Time Intervals
• Used various transformation tasks to create ETL packages for data conversion Monitored performance and optimized SQL queries for maximum efficiency
• Created and Modified T-SQL Stored Procedures/ triggers for validating teh integrity of teh data
• Created Star Schema Cubes using SSAS and Managed OLAP Cubes using SSAS
• Created indexed views and appropriate indexes to reduce teh running time for complex queries
• To keep track of data manipulations using Audit functionalities
• Generated custom and parameterized reports using SSRS
• Created reports that call Sub reports in SSRS
• Performs data transfer from various types of databases wif conversion through SSIS
• Responsible for Rebuilding teh Indexes and Tables as part of Performance Tuning
• Used SQL Server Agent for scheduling jobs and alerts
• Performer Query optimization & Performance Tuning
• Optimized queries using SQL Profiler and Database engine tuning advisor

Environment: SQL SERVER 2008,SSRS, SQL Enterprise Manager, Windows XP, Oracle, MS Access, MS Excel, Windows 2003, HTML, Visual Source

Confidential

MS SQL Developer

Responsibilities:

• Involved in analysis and design of teh system specification and gathering requirements and prepared teh document for proposed system.
• Involved in teh Design of Interactive User Interface and Coding of teh application.
• Involved in Designing and creating of Database Tables and Views.
• Participated in creating stored procedures in Oracle database. functions to insert teh data depending on teh criteria into teh tables
• Interacted wif financial analysts to gather requirements, test plans and DBA's for database schemas.
• Encapsulated frequently used SQL Statements into stored procedures and reduced teh execution time
• Wrote Merge Statement to handle insert, update and delete wifin single statement between source and destination table
• Interacted wif financial analysts to gather requirements, test plans and DBA's for database schemas.
• Wrote Database triggers for audit and to implement complex business logic.
• Involved in integrating individual tools and executing them from Visual Basic.
• Involved in Manual Testing and implementation of software at client location.

Environment: .NET Framework, VB and C#, ASP.NET, ADO.NET, Web Services, T-SQL, SQL SERVER 2008, COM/COM+, UML, Visual Studio.NET, Windows 2000 Advance Server.