SUMMARY:

• Around 8 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2008/2008R 2/ 2012/2014/2016 .
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008R 2/2012/2104/2016.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions
• Created Scorecard/Dashboard pages in Performance point server (PPS)
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Generated reports from Analysis Services cube by using ProClarity tool.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS:

TSQL: PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server 2016,2014,2012,2008R2

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),Microsoft Data Tools(MSDT), Informatica, Visual Studio, Cognos, Crystal Reports, Power BI

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies

Packages: Office 365, Microsoft Office Suit, Microsoft Office SharePoint Server, Microsoft Performance Point Server

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Microsoft Data Tools(MSDT), Crystal Reports, Power Pivot, ProClarity, Microsoft Office(MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows 8/10/ Windows 7/Vista and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Provo, UT

MS SQL/SSIS/Power BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Having hands on experience in DR Processes including LogShipping and DatabaseMirroring.
• Create dash boards and reports by using power BI.
• Good knowledge on Power BI and SQL Azure.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query, Power View & Power BI.
• SSIS(ETL), SSAS(OLAP), SSRS(Reporting), Sharepoint Power BI, HDInsight
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Implementing all high availability techniques like clustering, log shipping, replication.
• Working knowledgewith DMExpress ETL tool to filter data based on end requirements.
• Working experience with Column store indexes, table partitioning in SQL SERVER 2012/2014.
• Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014/2016.
• Developed complex web forms using ASP.Net server-side scripting with C#, .NET Framework 3.5
• Utilized VB Scripting, C#, WCF, Web Forms for developing the codes
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2012/2014.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2012/2104. Create Calculate member in MOLAP cube using MDX in SSAS.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temptables, cte’s, redesigning schemas and many more.
• Also, went through query executionplans, sqlprofilers and did queryoptimization.
• Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets and Power Pivot.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Created different Power Pivot reports as per the client requirement.
• Worked on pre-defined facets included by SQL SERVER
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Copied Facet State to XML file using T-SQL.
• Experienced in Cognos 10, 8, ReportNet with Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection.
• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2016 Business Intelligence platform.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Developed Qlikview Load Scripts for distribution across multiple data sources.
• Use to update the database properties directly by getting into facets.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Analyzed and designed software and database solutions.
• Deploy Clarity reports in both BOE Infoview and Epic-Crystal Integration
• Excellent experience in MicrostrategyReport development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts.
• Develop Clinical reports in Epic-Clarity during the Epic Implementation Project
• Managed SQL Server environments, by configuring a facet in one instance of SQL Server, copy the state of the facet to a file, and then import that file into another instance of SQL Server as a policy.
• Stays current with every new Epic product offering.
• Used Tableau to visually analyze data and create consise and actionable dashboards
• Created checks and constraints to maintain data integrity.
• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2016 Business Intelligence platform.
• Provided DBA assistance in Sharepoint 2007 to Sharepoint 2010 conversion.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Windows2012 Advanced Server, ASP.Net, MS SQL Server 2012/2014/2016, TSQL, Pl/SQL, Visual Studio 2015,Oracle 11g, SharePoint 2007/2010, Cognos, Qlikview, Lotus Notes, SSRS, SSIS, OBIEE, Informatica, Erwin.

Confidential, Northville, MI

MSBI Developer

Responsibilities:

• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Developed the flow charts and diagrams as well as translation of the detailed designs with LotusNotes application.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• C reated efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Handled Tableau admin activities granting access, managing extracts and Installations
• B uilt connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions .
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2008 Analysis Services(SSAS).
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
• Repaired/recreated PPS reports damaged in the conversion process.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• With the help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Windows2008 Advanced Server, ODBC, OBIEE, MS SQL Server 2008R2/2012/2014, TSQL, PL/SQL 11g, Informatica, Visual Studio 2008,Sharepoint 2010/2013, Qlikview, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

Confidential, Riverwoods, IL

MS SQL/BI Developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• C reated efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases..
• B uilt connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions .
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
• Repaired/recreated PPS reports damaged in the conversion process.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, OBIEE, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential

MS SQL / BI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Designed and developed custom .NET components and user controls using ASP.NET
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2005, 2008 Integration services.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word

Environment: SQL Server 2008, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS.