Sql Developer Medical Billing
Resume:
Dhara Shah
admplj@r.postjobfree.com
MS SQL Server Developer for over 10 years of strong experience in various domains like Financial, Healthcare, Retail, Communication and Insurance, Law firm. Worked with various versions of MS SQL Server such as 2016/2012/2008r2/2008/2005 and BI tools such as SSIS, SSRS and SSAS. Also, worked extensively on T-SQL Queries and Dynamic SQL Queries.
Professional Summary:
Proficient in installing, configuring, managing, monitoring and troubleshooting MS SQL Server 2016/2012/2008/2008r2/2005.
Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
Experienced in Logical and physical Database design and development, Data conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
Strong MS SQL Server Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
In-depth knowledge of T-SQL.
Extensive experience in Migration of data from DB2, Oracle, and Sybase to SQL Server.
Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLTP, OLAP technologies, cube, Including Star and Snowflake schema.
Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and SSIS.
Experienced in migration of data from Excel, Flat file, Oracle to SQL Server.
Strong experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
Expert in Microsoft Business Intelligent Studio 2010/2008 (SSIS/SSRS/SSAS).
Mastery in extracting and transforming transactional information using DTS Import/Export wizard,
Expert in Dynamic SQL, SQL profiler, Execution plan and SQL Server Agent.
Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
Performed Data Scrubbing, Data Staging and Data Validation in preparation of pushing data to production environment.
Good understanding in Database Backup, Recovery and highly experienced in investigating and applying necessary SQL Server database Service packs, hot fixes and Security Patches.
Defined and administered database standards, controls, procedures and documented the same.
Extremely diligent strong team player with an ability to take new roles and ability to work under pressure in a highly visible role and 24x7 on call support.
Education and Certification:
Bachelors of Science from CUNY, New York.
Business Skills / Technical Skills:
MS SQL Server 2012/2008r2/2008/2005, BI Tools SSIS/SSRS/SSAS, Microsoft Access 2007/2003, Microsoft Office, Outlook, MS SQL Profiler, SQL server Query Analyzer, Index Tuning Wizard, Oracle 11g and 10g, DB2, My SQL, Cognos reporting tool, Erwin, SSMA, Windows server 2008/2005, Windows operating system, Java and C++, Crystal Report, WEBI, TOAD, TFS, VBScript, C#., Python, Power BI, Tableau
Project Summary:
Columbia University Medical Center, Fort Lee, NJ
Sept 2019- June 2020
Senior MS SQL Server Developer/SSIS Developer
Columbia University Irving Medical Center (CUIMC) is a clinical, research, and educational enterprise located on a campus in northern Manhattan. We are home to four professional colleges and schools that provide global leadership in scientific research, health and medical education, and patient care. The main goal of the project is to create ad hoc reports requested by the user and build and support ETL process to support business
Responsibilities:
Translate business requirements into ETL and report specifications.
Worked on HER/EMR Medical billing system
Experience working with Caboodle data warehouse
Develop and implement ETL processes, reports and queries in support of business analytics.
Develop and implement interactive analytic reports and dashboards.
Provide technical and business knowledge support to the team.
Compile ad-hoc data and report requests.
Created ETL packages with different data sources (SQL Server, Flat files, Excel files, CSV files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
Create add hoc Cognos report and Power BI reports for end users.
Provide Support to the end users to create adhoc and on demand reports.
Develop SQL Script for testing and validation.
Ability to interact and communicate with end users to collect and translate business requirements into deliverable solutions
Create SQL object to support business requirements
Tools &Technologies:
MS SQL Server 2017, T-SQL, IBM Cognos Analystics, SSIS, Service now, Power BI, C#, Python, EPIC and Clarity
Mizuho Bank, Jersey City, NJ
Sept 2017 – May 2019
MS SQL Server Developer/ Data Analyst
Mizuho Bank, Ltd. is the integrated retail and corporate banking unit of Mizuho Financial Group one of the largest financial services companies in Japan. The main goal of the project is to expand existing business in Mexico, add new loan feature.
Responsibilities:
Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
Responsible to create various Tables, Views and Functions based on the requirement specified by business users and wrote complex Join statements for combining data from various Databases and tables.
Interpreting data, analyzing results using statistical techniques
Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality
Acquiring data from primary or secondary data sources and maintaining databases
Work with management to prioritize business and information needs
To simplify complex queries properly used joins, sub queries, CTE, UDF, Constraints and temporary tables wherever required.
Develop SQL Scripts for testing and validating data.
Write dynamic SQL for constant changing table definition
Involved in the initially integration of three different system (Gbase, Flexcube and Minds).
Recommending and implementing changes in existing application for ease of data import into SQL server database using VBscript.
Integrating SQL quires and code in TFS
Create and maintain VBscript and Batch file to run the Tidal jobs.
Create and configured build functionality in Serena to release code.
Integrating SQL quires and code in Serena.
Tools &Technologies:
MS SQL Server 2012, T-SQL, Tidal, TFS, Serena, C#
Northwell Health, NewHyde Park,NY March 2017 – Sept 2017
MS SQL Server Developer/SSIS
Northwell Health is the largest integrated health system in New York State, based on patient revenue and the 14th largest healthcare system in the United States. Its service area encompasses more than eight million people throughout the New York metropolitan area. The main goal of the project was to use integration services to create package and writing T-SQL queries to achieve Business requirements on daily basis.
Responsibilities:
Responsible to create various Tables, Views and Functions based on the requirement specified by business user and wrote complex Join statements for combining data from various Databases and tables.
Wrote standard & complex T-SQL Queries based on business requirements.
Used Execution Plan, index for performance tuning.
Created ETL packages with different data sources (SQL Server, Flat files, Excel files, CSV files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
Use Packages by testing and cleaning the Standardized Data by using tools in Data Flow.
Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
Logged various packages as well as individual tasks using SQL server log providers like text file, sql server database, trace file, xml file.
Responsible for database tuning using normalization and application tuning.
Documentation for all kinds of reports and SSIS packages.
Ability to create complex JIRA workflows including project workflows, screen schemes, permission scheme and notification schemes in JIRA.
Tools &Technologies:
MS SQL Server 2012, T-SQL, SSIS 2012, Microsoft visual studio, Windows server, JIRA.
Fragomen,DelRey,Bernsen&LoewyLLP, Matawan,NJ
Sep 2016- March 2017
MS SQL Developer/SSRS
Fragomen, Del Rey, Bernsen & Loewy LLP is a New York City-based International Law firm established in 1951 and specialized in providing a range of immigration law services to corporate and individual clients, and is recognized as the world's largest law firm that focuses its practice solely on global immigration law.The main project goal is migrating existing reports and creating new report as per business requirements.
Responsibilities:
Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
Transformed complex business logic into Database design and maintaining it by using SQL Server 2016 objects like Stored Procedures, User Defined Functions, and Views.
Successfully implemented indexes on tables for optimum performance.
Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using Crystal Reports. Maintaining proper documentation of the reports for future reference.Use Crystal, WEBI in developing different type of reports according to business need.
Scheduled the report using Schedule Manager in Crystal Management Console to run every day on a periodic basis.
Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
Replicated logic of old crystal report to the new business logic.
Involved in performance tuning of slow running queries using execution plan and index tuning wizard.
Scheduling jobs and alerts using SQL Server Agent and configure database mail for any job failure.
Used Change gear to maintain and create new tickets to track issues related to the Project.
Tools &Technologies:
T-SQL, MS SQL Server 2016 Integration Services, Visual Studio, Windows XP, MS Office, MS Access, Crystal reports 10, Change gear.
Barclays, NewYork, NY Sep 2015 – Sep 2016
Sr. MS SQL Developer
Barclays is a British multinational banking and financial services company headquartered in London. The goal of the project was to load all financial products and Assist management related data in a centralized system.
Responsibilities:
Designed and Developed database objects like table, views, Store Procedure, Triggers, Functions and etc., for settlement data integration related processes.
To simplify complex queries properly used joins, sub queries, CTE, UDF, Constraints and temporary tables wherever required.
Consumed Accurate in SQL databases and import the good-to-settle data; data includes all good–to-settle data which are held from previous settlement period and validate those data using TSQL.
Developed a DB Process to group all matching Auto blocks and Offset transactions in to a batch and non-matching transactions to hold transactions.
Worked with Business executives to collect integration requirements for Inter Company cash settlement.
Used dynamic SQL for some of the procedure.
Developed Multi-Dimensional Data Model for Cash Settlements, which is used for analyzing lagging settlements with operating units.
Responsible for developing store procedures and SQL Script to import data into Accurate system.
Developed Stored Procedures which are used in configuring and executing auto block rules to hold or un-hold transaction.
Developed SSIS Packages to handle feedback system on wiring process, which is consumed by PeopleSoft system.
Taken care performance issues in stored procedures developed by other team members as part of review.
Used SQL execution plan to see the proper use of indexes and to improve logic.
Using SSDT project tool and builds functionality have done development to testing environments in TFS.
QC Reports, lead organization of trouble ticket reporting and data analysis, report on new product trials.
Tools &Technologies:
C#.Net, SQL Server 2012, T-SQL, Query Analyzer and Performance Tuning, TFS, HP QC
Tory Burch NY, NY
Jan 2015- Sep 2015
Sr. SQL Developer/SSRS
Tory Burch is an American fashion line for women cloths, bags, shoes and accessories. The main goal of project was to redesign Data Warehouse. Data was extract from old Data Warehouse to new data warehouse and integrate data by using Stored procedures and also involved in writing SQL queries against Data Warehouse for reporting.
Responsibilities:
Involved in redesigning and redefining data warehouse and provided necessary documentation.
Used Stored procedure to extract data from old Data Warehouse and push to into new Data Warehouse.
Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, tables, Views, Functions.
Successfully implemented indexes on tables for optimum performance.
Used SQL Script to Validate, Extract, Transform and Load data to Data Warehouse databases.
Performed performance tuning by analyzing indexes, queries, table sizes, etc and heavy utilization of SQL Profiler and query execution plan tools.
Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
Involved using Dynamic SQL for constantly changing table definition.
Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
Used execution plan to improve the logic and see the efficient use of index.
Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
Defined the browsing perspectives and browsing translations since most transactions were online.
Created many Cascaded parameters in the reports using SQL SSRS 2008r2. Developed many
Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting
Services.
Created Drill-down, Drill-through, Linked and Parameterized SSRS Reports.
Create and configured build functionality in Team foundation server (TFS) to release code.
Integrating SQL quires and code in TFS.
Used JIRA to create tickets and maintain JIRA to track issues related in the project.
Tools &Technologies:
T-SQL, Microsoft visual studio 2008r2, Windows server 2008r2, SSRS, TFS, JIRA
PNC financial Group, Pittsburg, PA Jan 2013 – Dec 2014
Senior MS SQL Server Developer/ Data Modeler/DBA
PNC operations include a regional banking franchise operating primarily in nineteen states. Financial businesses serving companies and government entities, and asset management and processing businesses.
This project was to design, create, and administer the data from Oracle and MS Access 2007 to SQL Server 2012 by creating various SSIS Packages, to be used for generating different reports depending on the business requirements.
Responsibilities:
Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2012/2008 to store data and to maintain database efficiently.
Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
Developed and deployed data transfers packages using SSIS 2012/2008r2, also maintained the jobs running on Servers.
Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.
Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages. Deployed, Tested and Scheduled SSIS packages using SQL Agent.
Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.
Created many Cascaded parameters in the reports using SQL SSRS 2012/2008r2. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2012/2008r2).
Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.
Worked with production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing 24/7 on-call production support for daily job and ETL loads.
Worked within the development team and DBA teams for database update and system restarts.
Recommending and implementing changes in existing application for ease of data import into SQL server database using VBscript.
Create and configured build functionality in Team foundation server (TFS) to release code.
Integrating SQL quires and code in TFS.
Backup and restore database
Maintenance of SQL Server version patching
Tools &Technologies:
MS SQL Server 2012/2008r2, T-SQL, SSIS, SSRS, Win 2003 Advanced Server, Erwin v7.2., TFS, QC
Weight Watchers International Inc., New York, NY
Nov 2011 - Dec 2012
BI Developer/DBA
Weight Watchers Inc is an international company based in the United States that offers various products and services to assist weight loss and maintenance. The main goal of project was to get data from different sources and integrate data by using Stored procedure and also involved in writing SQL query based on business requirements to find customer information.
Responsibilities:
Used Toad, Oracle and MySQL source to extract data and push to into Data Warehouse.
Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
Successfully implemented indexes on tables for optimum performance.
Use various SSIS transformations such as Merge Join, Merge, Lookup etc which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
Successfully implemented indexes on tables for optimum performance.
Used SQL Script to Validate, Extract, Transform and Load data to Data Warehouse databases.
Performed performance tuning by analyzing indexes, queries, table sizes, etc. and heavy utilization of SQL Profiler and query execution plan tools.
Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
Develop SQL Script for testing and validation.
Create Drill down, Drill thro, Parameterized reports and other using SSRS
Wrote MS SQL Server Store Procedures using existing Oracle logic.
Worked on creating and maintaining Oracle objects such as Tables, views, and PL/SQL queries.
Involved in Unit testing to compare and verify the result set in Oracle, MySQL and Toad database and SQL Server.
Use SQL Agent to execute some of the procedure in certain schedule.
Involve working on performance tuning on slowly running query.
Implemented work item query check-in policy that allows specifying a work team query whose result will be the work items check in to be associated with in Team Foundation Server (TFS).
Backup and restore database
Maintenance package and reports
Tools &Technologies:
MS SQL Server 2008r2, T-SQL, SSSIS 2008r2, Microsoft visual studio 2008, Windows server 2008, Toad, Oracle, MySQL, TFS, SSIS, SSRS
Deloitte, Camp Hill, PA
MS SQL Server/BI Developer Sep 2010 – Nov 2011
Deloitte is the largest professional services network in the world by revenue and by the number of professionals. The main goal of project was to get data from different sources and integrate data by using SSIS package and also involved in writing SQL query based on business requirements.
Responsibilities:
Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
Used Erwin Model to design database.
Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
Successfully implemented indexes on tables for optimum performance.
Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Fixed File) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008.
Wrote MS SQL Server Store Procedures using existing Oracle logic.
Worked on creating and maintaining Oracle objects such as Tables, views, and PL/SQL queries.
Used SSMA for migrating data from Oracle to SQL Server.
Transform all objects from Oracle database to SQL Server.
Involved in testing to compare and verify the result set in Oracle database and SQL Server.
Analyzed and exchanged administrator, designed developed and maintained the web-based and automated accounting systems and various other application using Visual Basic (VB) Script and SQL Server.
Tools &Technologies:
MS SQL Server 2008, T-SQL, SSSIS 2008, Microsoft visual studio 2008, Windows server 2008, Erwin, and SSMA, VBscript, JIRA,SSAS
MetLife INC, Wilmington, DE
June 2009 – Aug 2010
MS SQL Developer/SSIS Developer
MetLife, Inc. is the holding corporation for the Metropolitan Life Insurance Company (MLIC), better known as MetLife, and its affiliates. MetLife is among the largest global providers of insurance, annuities, and employee benefit programs, with 90 million customers in over 60 countries .The main project goal was to use integration services to extract data from sources and push that data through staging and create package.
Responsibilities:
Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
Successfully implemented indexes on tables for optimum performance.
Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
Applied ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
Created ETL packages with different data sources (SQL Server, Flat files, Excel source files) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008r2.
Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
Performed Documentation for all kind of SSIS packages.
Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS.
Schedule and maintain Full, Differential, Transactional Log backup and restore the data using restore with recovery and restore with no recovery option.
Worked on locking, blocking and dead lock issues.
Involved in performance tuning of slow running queries using execution plan and index tuning wizard.
Scheduling jobs and alerts using SQL Server Agent and configure database mail for any job failure.
Recommending and implementing changes in existing application for ease of data import into SQL server database using VBscript.
Tools &Technologies:
T-SQL, MS SQL Server Integration Services, Visual Studio, Windows XP, MS Office, MS Access
Contact this candidate