Sql Server Ms

Suman Pandey

Irving, Texas *****

972-***-**** ***********@*****.***

SQL Server/SSIS/SSRS/ETL Data Warehouse Developer

SUMMARY OF QUALIFICATIONS

Over 14 years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2022/2019/2017/2016/2014/2012/2008/2005/2000. Experience in various industries includes HealthCare, Manufacturing, Insurance, Financial Services, Retail, Educational Services and IT Sectors.

Extensive experience in creating, configuring, deploying Source Mart, Subject Area Mart and their Views using one of the leading Health Catalyst Data Ware House tools,

Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.

Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.

Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.

Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data Warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.

Experience in managed Azure SQL instances and Azure Data Factory.

Extensive experience working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.

Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).

Good Experience in Exposure to Writing SQL/Transact-SQL (DDL, DML and DCL), Developing, Creating New Database and Database Objects Such as Tables, Views, Indexes, Complex Stored Procedures, Function (UDF), Cursors, E/R Diagrams, Normalization, Triggers, Locking Issues, Constraints, Security, SQL joins and Query Writing, DTS (i.e. Import and Export), BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent, SQL Server profiler using SQLSERVER 2000/2005/2008/2012/2014.

Have Good Experience in Migrating from SQL Server 2005 to SQL Server 2008/2012/2014. And Successfully Migrated Data Between Different Heterogeneous Source Such as Flat-File, Excel, Oracle, Sybase, DB2, MS Access Using SQL Server SSIS 2000/2005/2008/2012/2014/2016.

Expert in Migrating of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005/2008) to Higher Version (2005/2008/2012/2016) and Troubleshoot Migration Issues.

Expert in Deploying and Configuring Packages, Error Handling and Batch Logging Check Points and Troubleshoot Reporting Services Using SSRS.

Experience in Generating On-Demand and Scheduled Reports for Business Analysis or Management Decision Using SQL Server Reporting Services.

· MS SQL Server 2022/2019/2017/2016/2014/2012/2008R2/2008/2005/2000 · MS SQL Server Integration Service (SSIS) · MS SQL Reporting Services (SSRS) · SQL Server Data tools 2012/2014/2016/2017 · Microsoft Access 2000 · Microsoft Excel · Team foundation server

· Outlook · MS SQL Profiler · SQL Query Analyzer · Database engine tuning advisor ·

PL/SQL · T-SQL · MS Visio 2005 · Windows 10/7/XP/2003/2000 Advanced Server/Professional /Workstation

PROFESSIONAL EXPERIENCE

Steward Health Care · 1900 Pearl St., Dallas, TX · Hybrid

Data Warehouse Developer Full-time Jun 2021 – Present

• Expert in creating, configuring of Source Mart Design, Subject Area Mart Design and views using/following Health Catalyst tools in EDW environment.

• Involved in creating different SSIS/ETL packages to load data from heterogeneous sources and automated the processes of database. Optimized and monitored them in daily basis.

• Worked with heterogenous sources Oracle PL/SQL, DB2 to load the data to the Enterprise Data Warehouse.

• Used GIT/GitHub for source control.

• For ticketing used Jira.

• Strong knowledge on HL7 standards, HIPAA (Health Information Portability and Accountability Act), PHI (Protected Health Information).

• Created different dim tables and fact tables for data analysis of Hospitals and patients. Created different KPI’s for performance of hospitals.

• Created Dimension and Cubes with star schema using SQL Server Analysis Services (SSAS).

• Experience in evaluation of on-premise SQL database to Azure SQL to reduce the license cost.

• Migrated on-premise SQL databases to Azure Portal.

• Managed Azure SQL instances, and monitor.

• Involved in creating, T-SQL Queries, Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions, CDC to implement the business logic using SQL server 2008/2012/2014/2016/2019/2022.

• Expert in Fine-tuning of Source Mart and Subject Area Mart for resolving performance issues.

• Created different types of SSRS reports and scheduled and automated.

• Created different stored procedures, views and queries to implement in new reports as per requirement from business users.

• Involved in Optimizing stored procedures to implement update statements to production support.

• Involved in performance tuning of long running queries, stored procedures and troubleshooting them to reduce runtime by 30%.

• Expert in moving data from different data bases to Health Catalyst databases.

• Expert in loading and cleaning large data sets from different files to Health Catalyst databases.

• Expert in deployment and troubleshooting of Source Mart, Subject area Mart in Production.

• Followed agile methodology. Participated and conducted Scum meeting.

• Supported Production environment as needed and on call support.

Environment: SQL Server 2022,2016,2014, 2012, 2008, 2008 R2, SSRS, SSIS, SQL Server Data tools 2012/2014/2016, Visual Studio 2013, 2015, 2017, 2019,2022 Team foundation Server, Windows 10, Windows 7, Oracle, PL/SQL, SQL Profiler

DecisionEd Group INC, TX

SQL Server Developer/SSRS Developer/SSIS Developer July’ 2016 – May 2021

Responsibilities:

Created different SSIS packages and automated scheduled jobs. Optimized and monitored them in daily basis.

Created different SSIS packages for different Assessment tests for College Board exams and States Testing data to store in DW for report generation. Worked as Lead for SSIS team to develop new data load processes from different sources.

Created Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions, CDC to implement the business logic using SQL Server 2008/2012/2014/2016.

Created different T-SQL Queries, stored procedures, views and queries to implement in new reports as per requirement from business users.

Created different types of SSRS reports and scheduled them.

Loaded the data from different sources like Oracle PL/SQL, DB2 and flat files to the Data Warehouse.

Data analysis (finding errors, corrective measures and correction in production)

Migrated on-premise SQL instances to Azure and monitor.

Creating and maintaining Azure SQL databases using the right tiers.

•Optimized stored procedures to implement update statements to production support

Involved in planning, defining and designing database on business requirements according to provided documents.

Analyzed functional requirements and translated into technical documents and data mappings.

Involved in performance tuning of long running queries and stored procedures.

Designed and developed Data Warehouse and ETLs in an Agile working environment.

Designed and developed the data loading process to ensure the final Data in the warehouse meets the reporting requirements of granularity, dimensions and facts.

Involved in dimensional modeling, identifying the facts and dimensions.

Designed and developed Data Mart by following star schema and snowflake schema methodology.

Created SSIS packages to extract data from OLTP and transformed into OLAP systems and scheduled jobs to call the packages and stored procedures. Modified stored procedures and views as business changes.

Created SSIS Packages using Derived Columns, Conditional Split, sort transformation, merge, merge join, Union all, Aggregate, Execute SQL Task, Data Flow Task and Fuzzy Lookup and CDC. Used C# while using script task in SSIS.

Upgraded logic for failing SSIS packages and made them functioning correctly.

Prepared and used test data & test cases to verify accuracy and completeness of ETL.

Environment: SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2008 R2, SSRS, SSIS, SQL Server Data tools 2012/2014/2016, Visual Studio 2013, 2015, 2017, Team foundation Server, Windows 10, Windows 7, Oracle, PL/SQL, SQL Profiler, MS Excel

ACRE CAPITAL, TX

SQL Server Developer/SSRS Developer/SSIS Developer Dec’ 2015-June 2016

Responsibilities:

Involved in modifying stored procedures, T-SQL Queries and views to make better and faster functioning Reports as per business logic change.

Supported production team by Creating Index, Views, Complex Stored Procedures, and Triggers.

Created different types of insurance reports and letters in different format using SSRS.

Created/modified and supported different stored procedures, views and queries as business changes.

Created different SSIS packages to automate update processes of database.

Created data analysis queries to find errors. Created different replications and agent.

Created different stored procedures to implement business logic to production support,

Modified stored procedures and views as business changes.

Created different SSIS packages and scheduled jobs.

Developed SSRS Reports with different styles using Table, Sub Reports and Matrix using SQL Server data tools (2012/2014)

Created reports with formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.

Changed logic and mapping for existing failing SSIS packages and made them functioning correctly and faster execution.

Prepared and used test data & test cases to verify accuracy and completeness of ETL.

Environment: SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2008 R2, SSRS, SSIS, SQL Server Data tools 2012/2014, Visual Studio 2013, Team foundation Server, Windows 10, Windows 7, Oracle, PL/SQL, SQL Profiler, MS Excel, Powershell

Conexis, TX

SQL Server Developer/SSRS/SSIS Developer Feb’ 2015-Sept 2015

Responsibilities:

Created Index, Views for better performance, Created T-SQL Queries, Complex Stored Procedures, Triggers, and Cursors.

Working as BI developer Supporting Data analysis for exchange services of different states health exchanges.

Proving production support for health services Kaiser Permanente health insurance.

Providing data analysis for payment services (finding errors, corrective measures and correction in production)

Created/modified different stored procedures to production support,

Modified triggers and stored procedures as business changes.

Created different SSIS packages and scheduled jobs to support production team.

Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.

Created/modified different SSIS Packages and automated.

Updated and supported failing SSIS packages.

Created SSIS packages to import data from MS Access, Oracle, flat file, csv file, Excel to SQL 2008 R2/ 2012/2014

Environment: SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2008 R2, SSRS, SSIS, SQL Server Data tools 2012/2014. Team foundation Server, Windows 7, Crystal reports, Oracle, PL/SQL, SQL Profiler, MS Excel, Powershell

Standard Register, TX

SQL Server Developer/SSRS/SSIS Developer Sept’ 2014-Dec 2014

Responsibilities:

Created/modified T-SQL Queries, Index, Views, Complex Stored Procedures, Triggers, Cursors.

Optimized stored procedures to implement faster execution. After optimization, performance was increased drastically, more than 75%.

Modified triggers and stored procedures as business changes.

Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.

Created different SSIS packages and scheduled jobs. Optimized and monitored them in daily basis.

Involved in system analysis & design of the Enterprise Data Warehouse implementation.

Involved in modifying stored procedures, SQL queries, triggers and views to make better and faster functioning.

Developed Reports with different styles using Table, Sub Reports and Matrix using SQL Server data tools (2012/2014).

Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.

Created SSIS Packages using Derived Columns, Conditional Split, sort transformation, merge, merge join, Union all, Aggregate, Execute SQL Task.

Modified different existing failing SSIS packages and made them functioning correctly and faster execution.

Created SSIS packages to import data from MS Access, Oracle, flat file, csv file, Excel to SQL 2008R2/2012/2014

Prepared and used test data & test cases to verify accuracy and completeness of ETL.

Environment: SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2008 R2, SSRS, SSIS, SQL Server Data tools 2012/2014, Team foundation Server, Windows 7, Crystal reports, Oracle, PL/SQL, MS Access, FTP, SQL Profiler, MS Excel

M & A Technology, TX

SQL Server Developer/SSRS/SSIS Developer Sept’ 2012-Feb’ 2014

Responsibilities:

Written T-SQL Queries, Dynamic-queries, sub-queries and Complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Created Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.

Involved in system analysis & design of the Enterprise Data Warehouse implementation

Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.

Involved in Creating Period reports: shift or daily report, weekly, monthly and annual reports, till and employee reports.

Developed Reports with different styles using Table, Sub Reports and Matrix.

Developed RDLC Reports and Passing the Metadata for the Reports using XML Files

Created reports include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.

Localization for the RDLC Reports and created the Descriptor files for sort by options.

Created SSIS Packages using Derived Columns, Condition Split, sort transformation, merge, merge join, Union all Aggregate, Execute SQL Task, Data Flow Task and Fuzzy Lookup.

Created SSIS packages to import data from MS Access, Oracle, flat file, csv file, Excel to SQL 2008 R2

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Environment: SQL Server 2008, T-SQL, SSRS, SQL Server 2008 R2, SSRS, Windows 7, Crystal reports, Oracle, PL/SQL, MS Access, FTP, SQL Profiler, MS Excel, ASP.Net.

Richardson ISD, TX

MS SQL Server/SSIS/SSRS Developer Oct’ 2010 - Aug’ 2012

Responsibilities:

Created SSIS packages to clean and load data to Data Warehouse.

Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.

Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Created SSIS packages to transfer data between Staging database and Data Warehouse databases.

Worked with the ETL architect and Lead to ensure ETL developers have the required data schema and metadata information and participate in knowledge transfer with the goal to remove any knowledge gaps that might exist.

Assist with source data analysis and profiling and in the development of the source to target mapping documents.

Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task.

Created SSIS packages to import data from MS Access, Oracle, Excel to SQL 2008 R2

Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008R2

Generated Sub-Reports, Cross-tab, Drill down reports, Drill through reports and Parameterized Reports.

Created reports which retrieve data using Stored Procedures that accept parameters.

Scheduled the monthly/weekly/daily reports to run automatically using SSRS Subscription

Environment: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Win 2003 Advanced Server

EDUCATION

MBA in IT University of Dallas, Irving, TX (Dec 5, 2008)

MSC in Physics Tribhuvan University, Kathmandu, Nepal

Contact this candidate