SUMMARY

• 6 Years as an experienced BI Analyst and MS SQL Server Development experience with expertise in MS SQL Server 2008/2012/2014/2016 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.
• Handles multiple assignments simultaneously and successfully identify and coordinate key deliverables with stakeholders in cross - functional groups. Passions include ensuring data quality, scalability, performance, integrity, and security, as well as standards development and process improvement
• Technically and logically very sound in T- SQL Programming, SSIS, SSRS, SSAS, .NET, Data warehousing, Business Intelligence etc.
• Strong S QL Server Developer skills including writing triggers, Stored procedures, Views, Query writing.
• Created Backend validations using Insert/ Update and Delete triggers.
• Excellent Knowledge in designing of ETL Packages for integrating data from multiple sources. (Oracle database, Flat files, Excel, CSV, XML)
• Extensively used T -SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Used XML and XSD's generated by the application as a data source for the reports.
• Wrote complex SQL statements using CTE's, joins, sub queries and correlated sub queries.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Power BI Service using star schema.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Migrated Mainframe data into SQL tables using complex logics.
• Troubleshooting issues with TFS environments at various clients.
• Involved in creating different types of reports (Tabular Reports, Matrix, Cross Tabs, Drill Down, Charts, Functions and Maps) by extracting data from tables, store procedures into report builder and SQL server reporting services.
• And customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions .
• Worked on T -SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL- Server databases.
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2014/2016 .
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent Power BI skills, Experience in creating solutions for mid-large sized companies with Advanced SQL server relational database and development experience, as well as in Microsoft technologies SSIS, SSRS, SQL server, Power Pivot, Power View, and related technologies
• Sound knowledge of Performance Tuning, Disaster Recovery, Backup and Restore procedures .
• Experience in Change Data Capture (CDC), Change Tracking (CT) in SQL server 2008.
• Reviewed and optimized SQL queries, CDC, stored procedures, functions, Indexes, views and triggers.
• Experience on Microsoft Technologies Visual Studio 2003/2005, ASP.NET, C#, VB.NET, ASP, VB, IIS5.0/6.0, HTML, Oracle, SQL Server, Sybase IQ 12.5.0.1 and other Web related tools like Microsoft Azure
• Hands-on experien12qce and exposure to different phases of Software Development Life Cycle (SDLC), Agile and Scrum Methodologies.
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems
• IT experience, that includes Client / Server Application Programming, BizTalk Server 2009/2006 R2/2006/2004, HIPAA /EDI, MQ SERIES / XML, ASP.Net, VB.Net, C#
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel

TECHNICAL SKILLS

Databases: MS SQL Server 2017/ 2016/ 2014/2012/2008 /2005 , ORACLE, MS Access, DB2.

SQL Server Tools: SSMS, Configuration Manager, Query Analyzer Profiler, DTS, SSIS,SSAS, SSRS, Database Tuning Advisor, 10 BI tools (Report Studio, Analysis Studio, Query Studio,)

Tools: DTS, SQL Server Integration Services (SSIS), HIPAA, HEDIS, ETL, Visual studios, office 365, SharePoint.

Reporting Tools: SQL Server Reporting services (SSRS), Power BI, Tableau Desktop

RDBMS: SQL Server 2005/2008R2/2012

Programming: T-SQL, PL/SQL, Dynamic SQL, XML, Java.

Operating Systems: Windows 7/Vista/XP/ 2008/2003/2010 , Windows 9x, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL BI (SSAS SSIS SSRS) Developer

Responsibilities:

• Upgraded SQL Server 2014 to SQL Server 2016 and migrated data from old systems to new systems.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Performed the role of Senior Database Architect for all SQL Server database environments.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views using SQL Server 2016.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports, Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Company Wide users pulling data from Multi-terabyte data warehousing systems.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2014 to 2016).
• Involved in migration and Conversion of Reports from SSRS 2014 to 2016.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients.
• Involved in Denormalization of existing tables for faster query retrieval.
• Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.

Environment: SQL Server 2016/ 2014/2012/2008 /2005 , SSRS, SSIS, SSAS, BCP, DTS, SQL Mail, SQL Server Management Studio, T-SQL, XML, MS Excel and MS Access, Visual Team Foundation Server, DTS, visual studio 2005/2008/ 2012 , TFS 2008/2010

Confidential - Albany, NY

BI Developer (MSBI)/Power BI

Responsibilities:

• Worked in close quarters with business, application developers, and production teams across functional units and identified business needs as well as optimal solutions.
• Installed SQL SERVER 2008/2008r2/2012/2014 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64-bit system and VM WARE, Hyper -V in PROD/TEST/DEV from scratch.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed Sub Reports, Matrix Reports, Charts, Drill through Reports and Drill down reports, using SQL Server Reporting Services (SSRS).
• Worked on Developing and deploying SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse.
• Performed Slowly Changing Dimensions (SCD) Concepts in EDW.
• Developed SSIS Packages (Lookup, Conditional Split) and T-SQL (Merge) for enhancing the performance of SCD concepts.
• Designed SSIS packages to import data from multiple sources to control upstream and downstream of data into SQL Azure database.
• Created different tabular reports using Power BI features and enhanced them based on user requirements.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked on creating relationships in Power BI Designer, Uploaded reports from the Power BI Designer.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task.
• Created Reports on CRM and customized based on the requirements from the clients.
• Developed SSRS Drill down and Drill through reports with giving users ability to select multiple parameters.
• Actively involved in developing Quadrant Reports and Bucket Reports as per the Business Requirements.
• Developed SSRS reports using complex TSQL queries, User Defined Functions, store procedures and Views.
• Developed OLAP cubes using SSAS and calculated the metrics revealed in the functional analysis.
• Monitored Full/Incremental/Daily Loads and supported all scheduled ETL jobs for batch processing.
• Responsible for Dimensional modeling, defining relationships between Dimensions and Measure groups.
• Written a script for different connection like Shared drive and SFTP for sources within SSIS packages.
• Studied existing OLTP systems and created facts, dimensions and Star Schema representation for the Data Mart and warehouse systems.
• Built complex multi-sectional reports with charts and drill-down capabilities, created report models for AD-HOC reports when the end user wants to see the reports on fly and also created Ad-hoc reports for manager using SSRS to find all the work items open for Developers.
• Involved in developing ad-hoc business requests, Power Pivot and Power View reports for team.
• Created and maintained Roles and Database users.
• Involved in code reviews, code migration and deployments across all environments.

Environment: MS SQL Server 2014/2012/2008 R2, SQL Azure, T-SQL, PL/SQL, Visual Studio 2013/2012, SQL Server Reporting Services (SSRS 2014/2012), SQL Server Integration Services (SSIS 2014/2012/2008 ), SQL Server Analysis Services ( 2014/2012/2008 ), SSAS.

Confidential, Austin, TX

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Expertise in analysis, design, and development of end to end business intelligence solutions using the MSBI suites such as SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS)& SQL Server Reporting Services(SSRS)
• Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS.
• Perform database development that includes Schema development, Stored Procedures that could be used by different Windows Services.
• Used SSIS variables, parameters, & expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.
• Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data
• Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Lookup, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging, and Development.
• Creation of ETL packages to load data from files into database by performing different kinds of transformations using SSIS
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• T-SQL development included queries using joins, sub queries, ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, constraints, and Database triggers.
• Involved in development & amp; Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Creating SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Extensive reporting skills using SQL Server Reporting (SSRS).
• Created Data Models for each module of the current OLTP system and participating in the brain storming session to nail possible design challenges.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Worked on TFS for performing tasks.

Environment: Windows Server 2012 Operating System, MS SQL Server 2012, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, MS Visio, MS Excel 2010

Confidential

SQL Server Developer

Responsibilities:

• Developed database objects such as SSIS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving. Multiple tables & calculations from different databases.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Monitored the SQL profiler and tuned queries and procedures to boost database performance.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, Data Mart databases.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Used various SSIS tasks such as Conditional Split, Script Component Task, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data Warehouse.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Used Bulking techniques, Table partitioning to increase database performance.
• Consistently worked and communicated with CMS (Center for Medicare & Medicaid) to ensure data received met the company expectations.
• Wrote complex expressions and calculations for SSRS reports with Conditional Formatting.
• Responsible for the design and deployment of the report using SSRS and MS Excel.
• Created Ad Hoc reports by building models in Report Builder using SQL 2008 Model Designer and Report Builder.

Environment: SQLServer 2008, Oracle 10g, T-SQL, BIDS, SSRS, SSIS, SSAS, Crystal Reports, MS Excel, Erwin, SharePoint.