SUMMARY

• Around 7 + years of strong MS SQL Server BI Developer experience in Health Care, Finance, Education, and Insurance domains with expertise in MS SQL Server 2019/2016/2014/2012/2008 suite of products like SSMS, SSIS, SSRS, SSAS and Power BI in Production, Testing and Development
• Experience with software development life cycle (SDLC), Agile/Scrum Methodologies. Extensively involved through SDLC from initial planning through implementation of projects.
• Strong experience in Business Intelligence (BI) using Visual Studio 2019/2017/2015/2010.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Triggers, DDL, DML and joins.
• Created, Built, and deployed successfully dynamic SSIS packages into SQLServer 2019 /2017 /2015/ 2014 /2012 databases and scheduled them according to requirements.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources into Data Warehouses and Data Marts using SSIS, view and Stored Procedures.
• Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Expertise in developing and extending MS SQL Server Analysis Services (SSAS) cubes, data mining models, deploying, and processing SSAS objects.
• Expertise in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS)
• Proficiency and Expertise in SQL Server Backup/Recovery, Disaster recovery and planning.
• Performed database consistency checks at regular intervals.
• Have good business & technical knowledge in Healthcare Membership, Benefits and Provider in FACETS
• Good interpersonal, Analytical and Communication skills
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.

TECHINICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica power center 9x,8x, Visual Studio 2017,2014

Reporting Tools: SQL Server Reporting Services (2016/2014/2012/2008), MS Access, MS Excel, Power BI, Tableau

RDBMS: MS SQL Server 2019/2016/2014/2012/2008, MS Access

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1

Programming: T-SQL, PL/SQL, VB.Net, XML, HTML, C#, C, C++

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation)

Operating Systems: Windows 10, Windows 2008, 2003R2, Windows Server 2008, Windows XP, Windows Vista, Windows, Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, TriZetto Facet, Citrix, Diagnostic Manager, IBM WebSphere (One Run, CMU), TWS, Service Now, Ultra Edit, One Note, MS Outlook, MS Teams, Jira, SOAP UI.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

MS SQL Server Developer

Responsibilities:

• Developed SSIS to migrate databases such as Excel files, flat files, and SQL Server database to centralized IT destination.
• Created complex database code objects using T-SQL such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve query performance.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS) and Power BI
• Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.
• Work with Service Management teams to establish and monitor service level agreements, communication protocols withdatasuppliers anddata quality assurance policies.
• Providedata qualityadvisory services to clients and to internal stakeholders. Recommend maintenance enhancements to data acquisition processes to improve accuracy of data warehouse data.
• Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Have good business analytical and technical knowledge in Healthcare Membership, Benefits and Provider Modules inFACETS.
• Created XMLPackage Configurations,Error Handling usingEvent Handlersfor On Error, On Warning, and On-Task Failed Event Types.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Tools and Technologies: MS SQL Server 2019/2016, Visual Studio 2016, 2013, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Microsoft SharePoint, MS Project, VB Studio, MS Office, ERwin 9.2 Data Modeling, ALM for QA testing and Software Development Life Cycle (SDLC), MS Power BI

Confidential - Lexington, KY

SQL Server BI Developer

Responsibilities:

• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server, for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created SQL server Reports using SSRS 2014 as well as Power BI deployed them on SharePoint Server for the manager and the brokers involved and formatted the report layout for the requirement of the end users.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the Tabular, OLAP, Operational data. Designed MDX queries to retrieve data from SSAS cubes.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Experiencein Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery.
• Data migration (import & export - BCP) from Text to SQL server.
• Supported Application Development team with any database issues, updates, or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.

Tools and Technologies: MS SQL Server 2014, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL, Oracle Enterprise edition, Power BI Desktop, Visual SourceSafe, Win 2003 Advanced Server, PowerBuilder 5, Erwin v7.2, C#.

Confidential, Madison Ave, NYC

Sr. SQL Server/BI Developer

Responsibilities:

• Writing complex T-SQL Queries, Stored Procedures. Created User Defined Functions (UDF), Views and created indexes to the tables that have least updates to improve the query performance.
• Tune SQL queries and database performance by improving overall Table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level.
• Review database objects for data integrity, quality, security, recoverability, scalability, maintenance, and capacity recommend changes, as necessary.
• Create tasks, sessions etc. in the workflow manager and monitored them in the workflow monitor.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Designed/developed the SSIS packages to extract, transform, load the data into Target and generate outbound files for various vendor by using SSIS.
• Created lots of Drill down, Drill through, Matrix report using SSRS, Tree Map /Heat map reporting using Tableau.
• Documented the mappings used in ETL processes including the Unit testing and Technical document of the mappings for future reference.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the Tabular, OLAP and Operational data.

Tools and Technologies: MS SQL Server 2014,2012, Visual Studio 2013,2010, SQL Server Integration Services (SSIS), Data Warehouse, Redgate Tools, Toad for oracle, Oracle 11g,12c, PL/SQL, DB2, Unix, MS Visio, C#, ERwin 9.2, Data Modeling, Share Point, Team Foundation Server (TFS) 2012, ERP, CRM software, Windows Server 2012, Linux server, Tableau

Confidential, Vienna, VA

Business Intelligence, SSAS/ETL/SSRS Developer

Responsibilities

• DesignedSSIS packages to Extract data from different sources like SQL server 2008R2, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data Warehouse using SSIS.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Developing reports on SSRS on SQL Server (2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities.

Tools and Technologies: MSSQL Server 2008 R2, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2005, Erwin, and SQL Profiler, Actuate Report.