Sql Server Ms

SAILA

Ph: 973-***-****

Summary:

Over *+ years of experience in MS SQL Server Design, Development, and Testing working on large-scale enterprise and performance-critical applications.

Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts, and Complex Queries in MS SQL Server, Postgres, Oracle, Sybase, and DB2.Experienced with C#, VB.NET 1.1, 3.0 3.5, and ADO.NET, Python,

Extensively worked on Data Capture and orchestration.

Proficient in database performance optimization, tuning using the query analyzer, SQL profiler, and SQL server debugging, coding, testing, and installing to support client servers and software applications.

Involved in the Logical Design of the Database, transforming it into Physical Design.

Performed Data Modeling using Erwin.

Experienced in supporting a team of application developers for their .NET database application.

Transformed data from various data sources using OLE DB and ODBC connections.

By using COZYROC, we connected Salesforce through SSIS.

Experienced in SQL Development in the .NET environment, especially with CLR Stored Procedures.

I am experienced with DTS, BCP, and Jobs for MS SQL SERVER.

We used all SSIS configurations, including XML configuration files, environment variables, registry entries, parent package variables, and SQL Server tables

Experience with batch, database, real-time, flat-file, Oracle, XML files, CSV files data load, and dynamic data migration methodologies.

Exceptional programming skills in VB6 VB.NET, C#, Python, Azure Synapse Analytics

Excellent knowledge of development in reports in SSRS, Tableau, and Power BI.

Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures.

Worked extensively on system analysis, design, development, testing, and implementation of various projects.

Excellent verbal and written communication skills with a strong focus on customer-facing interaction, customer service, and presentation.

Self-motivated and possesses the ability to think critically and analyze, as well as good interpersonal and communication skills. Technically motivated and creative.

User-oriented with a desire to learn the client's business requirements.

Expertise in MS Office functionality, especially Excel (Macros, VBA, Pivot Tables, Lookups)

Worked with data visualization and reporting tools like Tableau.

Worked with data transfer methods (SFTP, FileZilla, HTTP, TCP)

Worked with the most common structured or delimited file formats (CSV, XML, Pipe, etc.) and parquet files.

Created Tableau dashboard and Power BI Dashboards.

Used join conditions, CTEs, subqueries, window functions, and aggregation techniques to prepare data for reporting.

Deployed on the server and accessed URL for concerned reporting by our stakeholders.

Formulate a reporting roadmap with internal key stakeholders to create a reporting “one-stop shop " that will drive improvements in funnel metrics over time.

Excellent knowledge of healthcare, finance, manufacturing, sales, and insurance industry applications. Ability to work excellently as an individual and as a proactive team member with minimal supervision.

Education:

Master of Science

MS(FDU)NJ

Technical Skills:

Databases Technologies: MS SQL Server (including SSIS, SSAS, SSRS), MS Access, PostgreSQL, DB2, Oracle, MySQL

Programming Languages & Development: C#, VB.NET, ADO.NET,Python

Business Intelligence & Reporting: Microsoft Power BI (Desktop & Service), Tableau, Cognos, SSRS (SQL Server Reporting Services)

Cloud & Big Data Technologies: Azure Synapse Studio, AWS S3, Azure Data Factory, Snowflake, Databricks, Fabric

Data Modeling & Query Languages: DAX, M Query Language

Professional Summary:

Carson Tahoe Health

DATA Base Developer

1600 Medical Parkway

Carson City, NV

Date: 2023 July- Till Date

Carson Tahoe Health is a not-for-profit healthcare system in Nevada that includes hospitals and physician clinics. Thao Do is a doctor at City of Hope who specializes in treating patients overnight. affiliated with the University of Utah Health. Worked on Epic Clarity and caboodle files.

We receive flat files from UTH, which are uploaded via SFTP.

Worked on Epic Caboodle/Clarity, Infor, and fiancé files.

The data is then ingested into various Epic, Clarity, and financial systems.

The flat files are loaded into the staging environment, cleaned, and then loaded into the EDW tables, followed by the generation of final reports.

These reports are then forwarded to the relevant department for auditing.

Using the flat file sources, we create fact, dimension, and bridge tables in Postgres.

By using an E-R diagram, we join and merge the sorting grouping of the data.

Example: Billing Procedure Dim, Billing Service Area Mapping Dim, Billing Transaction Fact, Cost Center Dim, Coverage Dim, DRG Dim, Department Dim, Diagnosis Dim, Diagnosis Event Fact, Diagnosis Terminology Dim, and Drg Event Fact. These files are processed and integrated accordingly.

We created views, stored procedures, and function triggers and indexes and keys according to requirements.

We build a structured, scalable BI environment and data pipelines (ETL/ELT) from the ground up, ensuring a single source of truth.

We establish and enforce policies to maintain data integrity, consistency, and compliance across various sources.

Design and develop custom database schemas within the Data Warehouse, as needed

Test reports and data extracts, and perform volume testing in live environments

Ensure that customers are satisfied with the data provided to them

Monitor ETL executions and data-load processes as part of routine Data Warehousing operations

Troubleshoot failed packages.

We translate complex analyses into executive-level presentations and dashboards that drive actionable business decisions.

Developed interactive dashboards and reports in Power BI, utilizing bar charts, maps, and other visualizations to present key insights.

Designed and implemented data-driven visualizations, including stacked bars, geographical maps, and trend analysis, to enhance decision-making.

Utilized Power BI’s advanced analytics, incorporating measures, calculated columns, and relationships to facilitate in-depth reporting.

Created dynamic KPI-driven reports, leveraging DAX and M Query for data transformation and insightful analysis.

Presented customized reports and dashboards to senior executives, ensuring clarity and data-driven decision support.

United Way of Greater Roches

BI Developer (Remote)(end to end)

College Ave, Rochester, NY

Date: 2021July-2023June

The United Way of Greater Rochester and the Finger Lakes is a nonprofit organization dedicated to mobilizing community resources and goodwill to ensure everyone in the region can thrive. Serving six counties—Genesee, Livingston, Monroe, Ontario, Wayne, and Wyoming- the organization collaborates with over 50,000 donors, 1,300 workplaces, 1,000 nonprofit partners, and thousands of volunteers to address the area's most pressing human service challenges

We collect source data from Andar, FIMS, Salesforce (SF), and other platforms, such as Volunteer United and Galaxy.

Using the BDM and STTM documents, we develop stored procedures and functions to ingest data into the staging area.

The data is cleansed and loaded into the Enterprise Data Warehouse (EDW).

Historical loads are processed every Sunday.

Incremental loads run daily then send an e-mail to the concerned development team.

Views and triggers are created on top of the EDW database by using EDW data and views as the foundation for Tableau reports, refreshed daily.

We fixed the bugs depending on priority and created maintenance and support documents.

Worked on Tableau reports on a daily, monthly, and yearly basis.

Developed interactive Tableau dashboards and scorecards using stack bars, bar graphs, scatter plots, geographical maps, and Gantt charts.

Extensively worked with advanced Tableau analytics, including actions, calculations, parameters, background images, and maps.

Utilized trend lines, statistics, and log axes, incorporating groups, hierarchies, and sets to create detailed summary reports and KPI-driven dashboards.

Designed and delivered customized, data-driven insights through visualized projects and dashboards for senior executives.

Strong SQL reporting expertise, with the ability to create SQL views and write optimized queries for data analysis and reporting.

CVS (Well partner)

Data Analyst

NJ - Florham Park

200 Campus Drive

Date: 2018 May- 2021 June

CVS and Well Partner is a leading provider of 340B Drug Pricing Program services. See why covered entities trust Well partner to optimize their 340B programs and service. well partner, Inc. develops, delivers, markets, and supports pharmacy distribution solutions in the United States. It offers Access Convergence, a service.

Collaborated with Well Partner’s customers and vendors to analyze and provide solutions for their data-related issues.

I worked with various data feeds and was involved in the EDI life cycle and split Billing system.

Handled healthcare data, including ICD10, CPT, DRG, HL7, DFT, and UB-04.

Extensively worked on FogBugz tickets and resolved issues related to failed SSIS packages.

Designed, developed, and tested database objects, including SQL code, stored procedures, triggers, tables, and views.

Collaborated with the QA team to promote changes to production and created documentation on business rules.

Communicated with Account Managers regarding incorrect files and ensured new files were generated according to business rules.

Transformed complex data into easily understandable reports using graphs, charts, and dashboards.

Design/development of Stored Procedures, -Functions, Tables, and Triggers and tuning SQL queries for optimal performance.

Files were loaded into ADLS, from where they were fed into the staging area and subsequently into the final EDW.

Monitored revenue reports daily, identifying failed jobs and troubleshooting the root causes.

Created repeatable jobs and procedures using MS SQL Server to gather and analyze data, assess the effectiveness of controls, ensure report accuracy, and improve operational efficiency.

Worked with VSS and other version control systems.

PS Partner Solutions, Ltd.

BI Developer

New York, NY 10018

Date: March2015- 2018Apr

PS Partner is a global supply chain management company. I worked with the Business Intelligence (BI) analytics team, supporting various data-driven initiatives. My key responsibilities included loading data into the data warehouse, writing complex queries, and contributing to the development of dashboards, KPIs, quarterly business reviews (QBRs), and gold standard metrics. I also generated a range of analytical reports, with a particular focus on spend analysis to support client decision-making.

Extensively involved in the full lifecycle of ETL software development-analysis, design, building, documentation, and testing for the project using SQL Server Integration services.

Worked extensively building and supporting business intelligence/datawarehousing reporting solutions using Microsoft SQL, SSIS, SSRS, and SSAS.

Worked on cubes MDX queries and experience with Analysis Services (SSAS) and Reporting Services (SSRS), including database development, deployment, configuration, security, and troubleshooting.

Designed and developed SSIS packages, stored procedures, configuration files, tables, views, and functions and implemented best practices to maintain optimal performance.

Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).

Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.

Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.

Developed, executed, and maintained SQL queries scripts and to validate completeness, integrity, and accuracy of data.

Extensively wrote and edited existing Stored Procedures, User user-defined functions and Triggers using T-SQL. Created the Best Coding Practices Document for stored procedures functions for the developers.

Created new database files and database file groups in SQL Server using SSMS and T-SQL.

Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.

Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.

Responsible for deploying reports to the Report Manager and Troubleshooting for errors occurring in execution. Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing of the reports.

Transferred data from various OLTP data sources, such as Oracle, Teradata, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.

Optimized queries by getting insight from Execution Plan for better performance of the database.

Generated power Bi and Tableau reports for QBR, KPI, and dashboard presentation.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, DTS, SQL Profiler, VB.NET, MS Office, Windows Server 2003

Med Assets

SQL Developer

Saddle River, NJ 07458,

Date: March2012- FEB2015

Thrive, formerly Med Assets, is a revenue cycle management company focused on aiding health care providers with patient-to-Payment health. MedAssets, Inc. was an American healthcare performance improvement company. It provided products and services to 4,400 hospitals and 122,000 non-acute healthcare providers.

Responsibilities:

Migrating from DTS packages to SISS packages for all Hospitals. (Entity/facilities)

Once all packages are stabilized, check the amount and variance.

Worked with business users to understand their business processes, gathered and documented project requirements, and translated them into functional and non-functional specifications for BI reports and applications.

Provided leadership and technical guidance to identify system deficiencies, analyzed problems and solutions to conclude and implement corrective action.

Designed and optimized dimensional data models for data marts to support reporting infrastructure.

I identified data quality issues and supported the data governance initiative by participating in necessary activities, including data profiling.

Identified project risks and impediments, notified management, and proactively worked with other members of the team to complete assigned tasks as defined by project scope and timelines.

Worked with developers to provide support for development related issues that came up during implementation.

Developed complex joins to implement data manipulation tasks and data selection from the database.

Participated in evaluating and analyzing the relational database management systems, utilities, and tools offered by BI applications and tools vendors.

Involved in the development of custom SQL, T-SQL, custom stored procedures, functions and triggers.

Worked on the analysis and implementation of new functionalities that can be brought into the Target from other source systems.

Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between different Data Sources to SQL Server 2008 using ETL Concepts.

Collecting heterogeneous data sources and checking final KPI 160 columns to bring on dashboards.

Created and maintained accurate and complete documentation for all tasks performed.

Identified the database tables for defining the queries and datasets for report generation.

Worked on Target Mappings (STTM) for creating the successful ETL logic rule for transforming data from various sources.

Used ERWIN for designing database models and system analysis.

Analyzed various source systems for transferring data and maintaining the data.

Contact this candidate