SUMMARY

• Having 8+ years of IT experience in database design and development in Microsoft SQL Server suite of Products.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Expert in working with the BIDS and SSDT which includes SSIS, SSAS and SSRS.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Experience in scripting T - SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Experience in creating and managing Control flow, Data flow, Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience with data warehouse concepts and implementation to provide reporting solutions for the organization.
• Including experience with slowly changing dimensions, star schemas, conformed dimensions.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Experience in Relational, Multi-Dimensional (Star) and Snowflake logical modeling.
• FACT & Dimensions tables and Logical & Physical data modeling.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions
• Developed Linked, Drill Down, Drill Through and Sub Reports using SSRS.
• Design functional specs for BI front end applications including dashboards and reporting, considering appropriate data flow and capture.
• Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
• Developed Reports and Ad-Hoc Reports using Tableau, Power BI.
• Designed Subscriptions and Security for Reports.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

TECHNICAL SKILLS

Languages: T-SQL, C, C#

Databases: SQL Server 2016/ 2014/2, MS Access, Teradata, Oracle, DB2 and MySQL

Tools: SSIS, SSAS, SSRS, Tableau, Power BI, Visual Studio 2010/2012/2015 , Microsoft Test Manager, Team Foundation Server, Rapid Miner, MS Project, MS Excel, Application Packages: MS-Front Page.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. SQL - BI DEVELOPER

Responsibilities:

• Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
• Created ETL Projects using SSIS 2016 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
• Developed SSISpackages that fetches files from FTP, did transformation on those data base on business need before I loaded to destination.
• Expertise in creating Metadata tables to log the activity of the packages, errors and change of the variable.
• Various techniques such as CDC, SCD and Hash bytes were used to capture the change of the data and execute incremental loading of the dimension tables.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Involved in migrating the present SSIS packages in 2014 to SQL Server 2016 environment.
• Developed, tested, and deployed all the SSIS packages using project deployment model in the 2016 environment by configuring the DEV, TEST and PROD Environments.
• Created SQL Server Agent Jobs for all the migrated packages in SQL Server 2016 to run as they were running in the 2014 version.
• Created Target Databases, Tables, Cluster/Non-Cluster Index.
• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
• Designed SSAS cube to hold summary data for Target dashboards and developed Cubes with Star Schema.
• Experience in creating ad-hoc reports by using Report Builder in SSRS.
• Excellent report creation skills using Microsoft Reporting Services (SSRS)
• Worked extensively on Creating Reports, Dashboards, Stories, and worked with different charts in Tableau Desktop also have created Application, Schema objects like Attributes, Facts, Metrics, Filters, Prompts, Metrics, Compound Metrics, Filters, Custom Groups and Consolidations for Complex Reports.

Environment: SQL Server 2016/s2014/2012, T-SQL, MS Office, Visual Studio 2015, SQL Server Management Studio, SSIS, SSRS, SSAS, Tableau Server.

Confidential, Williamsville, NY

SQL- MSBI DEVELOPER

Responsibilities:

• Involved in the migration of the data across different databases and different servers using SSIS, Import/export tools.
• Tested to optimize the procedures and triggers to be used in production.
• Creation of new database, planning the location of data, index, and transaction log files on the disks.
• To view the performance of indexes I used SQL profiler and execution plan objectives.
• Created and optimized stored procedures to create Clustered and Non-Clustered Indexes for Query Performance.
• Created custom data flow items for different SSISpackages using the VB.Net script.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures, and performing other maintenance tasks.
• Worked on performance tuning of T-SQL queries and Stored Procedures.
• Deployment and End-to-End testing of Tabular Models.
• Created unique and complex solutions with the optimization of Stored Procedures, Triggers, Views, Joins, Indexes, and Tables for various applications
• Extensively used Proc SQL for highly advanced matching and merging between large datasets.
• Developed Shell scripts to extract data from the URLS for specific exchanges.
• Assisted in development by recommending alternative solutions to technical problems for the businesspeople.
• Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSISpackages.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Configured and Tuned SQL Server 2012 Analysis Services (SSAS) Tabular and Multi-Dimensional Cubes.
• Experience in creating named Queries and Named calculations in Data source views.
• Created SSAS cubes using various dimensions and measure groups.
• Worked on performance tuning of SSAS cubes by creating partitions and hierarchies.
• Deployment and End-to-End testing of Tabular Models.
• Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in Creating Parameterized, Cascaded, Drill-down, Crosstab and Drill-through Reports using SSRS.
• Used SSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Developed Tableau Workbooks from multiple data sources using Data Blending.
• Used Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending, Joinsand Maps etc. Combine data sources by joining multiple tables.
• Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.

Environment: MS SQL Server 2014/2012/2008 R2, Microsoft Access, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), T-SQL, Facets, Microsoft Access. Tableau Desktop, Tableau Server, Power BI.

Confidential, Franklin, WI

MSBI DEVELOPER

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Engaged in gathering data and documenting it for further reference.
• Involved in installation and configuration of SQL Server 2008.
• Upgraded the server from SQL Server 2005 to SQL Server 2008.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various MSBI data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Created SSIS packages for data Importing, Cleansing, and Parsing.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing MSBI(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 basis.
• Designed, developed, and deployed reports in SQL Server environment using MSBI (SSRS 2008).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for monitoring and tuning report performance.
• Involved in the design and development of web forms for the application using ASP.Net to take care the cosmetic works of the reports deployed on the server.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Provided documentation for all kinds of reports, Stored Procedures and SSIS packages.

Environment: SQL Server R2, MSBI(SSIS, SSRS, SSAS), Visual Studio 2005, VSS 2005, Erwin 7.3, Windows NT/2003, Microsoft .NET framework 3.5, C#, JavaScript, ASP.NET, XML.

Confidential, Chattanooga, TN

SOFTWARE / ETL DEVELOPER

Responsibilities:

• Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
• Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2008R2 Analysis Services (SSAS) and Reporting service (SSRS).
• Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task.
• Actively involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.
• Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.
• Provided and defend conclusions and recommendations to customer based on results of analysis.
• Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.
• Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, TFS.