Sql Server Data Migration

Sarada

********@*****.*** 606-***-****

Professional Summary:

* ***** ** ** ********** with a strong background in Data warehousing projects administration, development, power BI and three years of ETL experience using SQL Server.

Good knowledge in QNXT 5.4, 5.7, 5.8 and 5.9 and Claim Processing and File monitoring.

Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling using Erwin, MS Visio

Strong understanding of the principles of Data warehouse using Fact Tables, Dimension Tables and star schema modeling and data modeling for ODS.

Experience in healthcare in providers and claims, enrollment, memo message, retro termination users, delink, cob etc.

Worked on Azure SQL for connecting to Power BI Desktop.

Expertise skill in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard

Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL)

Experienced T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Data Import/Export, Triggers, and Cursors

Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance

Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2008/2012

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Drill Down, Drill Through and Cascaded reports

Experienced in developing Custom Report and different types of Chat Reports, Tabular Reports, Matrix Reports, and distributed reports in multiple formats using SQL Server 2008/2012 Reporting Services (SSRS)

Experience in creating Jobs, Alerts, SQL Server Agent, and scheduled SSIS Packages

Versatile in Query Analyzer, Profiler, SQL Server Management Studio (SSMS)

Technical skills:

EDI Tools

Gentran Integration Suite (GIS) 4.2/4.3, EDIFECS: EAM, Spec builder;

Programming Skills

T-SQL, PL-SQL, HTML, CSS, XML.

RDBMS

MS SQL Server 2014/2012/2008/2005, MS Access.

Operating Systems

Windows NT/98/ 2000/XP/Vista/2003, MS-DOS

ETL Tools

SQL Server Integration Services (SSIS), SQL Server DTS, ETL.

Other Tools

Microsoft Visual Source Safe, Microsoft Office, MS Visio, QNXT.

Programming languages

C, SQL, T-SQL

Data Warehousing & BI

SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2012.

Education Details: B.Tech (Civil), J.N.T.University, A.P India

Projects Summary:

SQL Developer/Production Support 03/2019– Present

Aetna, Blue Bell PA

Medicaid Production support projects handle small and medium sized change request from different states health plans/business owners across all domains of Medicaid like enrollment, Eligibility, Prior authorization, Provides, Members, State & Vendor Extracts, Public websites, Claims, Payments and Utilization management Many times these requests are compliance related and must be as per specs provided by State and completed within the timelines provided by State. Worked on various modules, which includes Claims, policy, Benefit, Contract, Provider, Member, Payment, and various other modules of QNXT and experience on Manual promotes. Adept in utilizing technologies QNXT 5.4, 5.7, 5.8 and 5.9.

Involved in Production support QNXT 5.4, 5.7, 5.8 and 5.9 and claims.

Experience in Claim file processing and claim intake process.

Identify, review and resolve all issues regarding the setup and configuration of providers, contracts, fee schedules, service groups, claim editing, Medical codes, Rules and codes.

Experience using agile methods like Scrum, service now, Kanban and Remedy tool.

Experience with QNXT 3.4, 4.6, 5.4, 5.7, 5.8 and 5.9 Facets 4.71, Inbound & Outbound interfaces.

Troubleshoot any problems found within QNXT when testing the SQL database while validating against the business rules.

Maintaining and resolving Data warehouse related issues. And troubleshooting SSIS ETL Packages.

Experience in claim intake process of HIPAA regulations and 270, 837P, 837I, 837D EDI and x12 EDI transactions for health care industries.

Generated ad-hoc reports in excel power pivot and shared them using power BI to the decision makers for strategic planning.

Experience in creating Microsoft SSIS packages, enhancing SSIS Packages and Modifying when needed and deploying to stage and production environments.

Worked with Claim Processing, Claim Rejection and File monitoring and Dash board issues.

Troubleshoot claims adjudication issues related to configuration

Crosswalk creation coded in EDIFECS Spec Builder for static EDI data elements mappings to allow the developers to concentrate on only the complex mappings.

Create feasibility studies to design possible technology solutions using Edifecs Engine Server, delivering interoperability in an integrated FL Blue healthcare “smart” pipe transaction.

Good exposure on Elastic Search, Edifecs Engine, In Rule Rules Engine.

Involved in end-to-end testing of FACETS Enrollment Claim Processing and Subscriber/Member module.

Generated ad-hoc reports in excel power pivot and shared them using power BI to the decision makers for strategic planning.

Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.

Working on various incidents & order tickets and on change requests.

Involved in Delink, clear edits, Termination Retro, unable to deny claims.

Worked with manual promotes, Auto promotes, Remit N95, Enrollment.

Knowledge of Service Request, create and update, view request in Remedy.

Experience in Reporting Services, Power BI (Dashboard Reports), Crystal reports, SSRS MS SQL server and in supporting services.

Involved in Manual Promote and knowledge of Auto Promote.

Environment: MS SQL Server 2005/2008, SSIS, SSRS 2005/2008/2010/2012, Microsoft Windows OS with Oracle SQL Developer, QNXT, Remedy

SQL/SSRS Developer 08/2018– 03/2019

Exelon, Market St PA

Advanced Meeting Infrastructure (AMI) is implemented for the PECO delivery companies in 2009. AMI application is used to maintain the user information as profiles, accounts and billing information. It gathers the information from different sources and reads the readings from meter to process it to downstream applications. It provides different platforms for the users to manage their accounts according to their needs. ETL

Leading & working with the offshore Team in application support Data warehouse as part of MDR PECO project.

Utilized power BI (Power View) to create various analytical dashboards.

Utilized power BI (Power View) to create various analytical dashboards.

ETL job monitoring and interval count and ETL dashboard reports.

AWS / RDS experience supporting databases in the cloud.

Monitoring monthly activities like server maintenance.

Developed Power BI reports and dash boards from multiple data sources using data blending.

Developed Power BI reports and dash boards from multiple data sources using data blending.

Validation data and Data repair for meter status.

Involved in writing test cases for the EDI maps and tested using Quality Center.

Familiarity with Scrum and Kanban concepts grooming user stories, managing the backlog, WIP.

Implemented power BI gateway different source to matching analysis criteria and further modelling for Power Pivot and Power View.

Worked on Meter connection issues on multiple meters.

Application Support and Maintenance and clear the blocking sessions.

Created ETL process using TSQL and SSIS and SSRS reports based on the requirements and met the users and every phase of the development to know their ideas or concerns.

Environment: MS SQL Server 2005/2008, SSIS, SSRS 2005/2008/2010/2012, VB Script, Scheduler, Visual Studio 208, Visual Studio 2010. Microsoft Windows OS with Oracle SQL Developer.

SQL/SSIS Developer 02/2018– 08/2018

AON, Fort Washington PA

AON – Migration CSC server into the new X2V servers and the CSC servers in the new CoLo servers Details needed to replicate the application (JRW) present in the CSC server into the new X2V servers and the CSC servers in the new CoLo servers along with certain change using web application was built on the Microsoft .Net framework version 4.0 using Dev Express framework version 15.2.The PAQS application is a web-based online application that allows JRW employees to create and update quotes and policies.

New Maps to handle EDI file translation for 837 to XML translation.

Verification of logic, functionalities of reports, batch jobs and documents.

Application on windows OS 2003 will be upgraded/migrated to Windows OS 2012/Window OS 2008R2.

Experience on deploying, configuring databases like (MySQL, SQL Server) on AWS Environment

Leading & working with the offshore Team in designing & building Data warehouse as part of CoLo affinity project.

Filter and Sorting Data using Power BI in Excel 2013.

Worked on Data modeling as part of building databases using Database Diagrams in SQL Server management studio.

Created alerts for successful or unsuccessful completion of scheduled jobs. Developed ad-hoc queries for end users.

Environment: MS SQL Server 2005/2008,SSIS,SSRS 2005/2008/2010/2012, VB Script, SVN, JIRA, Tidal job Scheduler, Visual Studio 208, Visual Studio 2010. Microsoft Windows OS with Oracle SQL Developer, Data Point, Facets, MS SQL, SSIS

SQL /SSIS Developer/EDI 11/2017 – 02/2018

Beacon Health Options, Latham, NY

New Maps to handle EDI file translation for 846, 850, 855 and 856 to XML translation.

Inbound and Outbound Envelopes for EDI transactions.

Modified Oracle database tables in custom schema to incorporate new routing information.

Created visibility of DSV transactions by implementing custom tracking mechanism.

Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator’s Map editor

Worked with different file formats including ANSI X12, EDIFACT and XML.

Inbound and Outbound Envelopes for EDI transactions.

Modified Oracle database tables in custom schema to incorporate new routing information.

Created visibility of DSV transactions by implementing custom tracking mechanism.

Handled the integration of Sterling OMS with Other applications by implementing various translation maps for positional xml to xml, flat file to xml, EDI X12 to xml files and vice versa.

Worked with different file formats including ANSI X12, EDIFACT and XML.

maps for positional xml to xml, flat file to xml, EDI X12 to xml files and vice versa Tools and Technologies: Gentran Server for Windows.

Environment: MS SQL Server 2005/2008, SSIS, SSRS 2005/2008/2010/2012, VB Script.

SQL/SSIS Developer 05/2017 – 11/2017

WellPoint/Anthem, Norfolk, VA

Project Summary:

Reconciliation of Provider data for the state of Virginia, Indiana, Wisconsin, and Kentucky. Migration of all eligible VA, IN, KY and WI Anthem providers from Central Region Facets to GBD Facets and perform a comparison of source and destination data which will result in the definition of all relevant provider entities to be migrated.

Roles and Responsibilities

Responsible for working with the state to review and modify process flows to increase productivity and effectively utilize FACETS features not provided by the legacy system.

Actively involved in requirements phase including planning, estimation and ROI.

Worked on facets data tables and created audit reports using quires. Manually load data in FACETS and have good knowledge on FACETS business rules.

Tested the changes for the Front-End Screen in FACETS related to following modules, test the FACETS batches (membership).

Involved in FACETS Implementation, FACETS billing, enrollment, and claim Processing and Subscriber/Membership module.

Worked with DBA team on TDM process which is Data Acquisition TDM tool will help rapid development of ETL process which we can copy one or more tables from SQL server or flat files to any TD core system.

Tested the changes for the front-end screens in FACETS related to following modules, test the FACETS batches (membership).

Schedule jobs in Tidal environment.

Deployment through SDLC ZIRA administration tool.

Worked on member Management, Eligibility, Claims and Billing modules within FACETS.

Environment: MS SQL Server 2005/2008, SSIS, SSRS 2005/2008/2010/2012, VB Script, SVN, JIRA, Tidal job Scheduler, Visual Studio 208, Visual Studio 2010. Microsoft Windows OS with Oracle SQL Developer, Data Point, Facets, MS SQL, SSIS

SQL / MS- Systems Engineer IV 06/2016 – 03/2017

Atos, Mason OH

Atos Origin SA, is a France-based company that provides information technology (IT) services The Managed Services division manages and transforms all the IT operations of the Company's clients, including the management of their entire information and data processing systems, and the High-Tech Transactional Services (HTTS) & Specialized businesses division includes creation of electronic payment services, such as issuing, acquiring, card and non-card payment solutions and processing, as well as managing IT infrastructures for clients, including datacenters, desktop support, server farms and network communication systems.

Migrated data using ETL tool in SSIS.

Developed various operational drilldown and drill-through reports using SSRS.

Developed SSIS ETL process to maintain a real-time/near real-time Data Warehouse.

Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.

Created SQL server Reports using SSRS.

Reports writing based on tickets submitted from front end people using SQL Server Reporting Services (SSRS) and Crystal Reports 8.0.

Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.

Involved in gathering reports requirements and generated SSRS reports.

Environment: MS SQL Server 2005/2008,SSIS,SSRS 2005/2008/2010/2012, VB Script, SVN, JIRA, Tidal job Scheduler, Visual Studio 208, Visual Studio 2010.

SQL/SSRS Developer 01/2015– 04/2015

WellPoint/Anthem, Virginia Beach, VA

WellPoint is the nation's leading health benefits company serving the needs of approximately 35 million medical members nationwide. As a Development, Involved in the implementation of Providers/claims modules in the system. The Premium Billing department within Amerigroup performs a premium reconciliation and Premium Billing compares the premium amounts being paid per member per month with the amounts that should have been paid based on the billing functionality within FACETS

Responsibilities:

•Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

•Scheduled Jobs to run SSIS package in night feed to ODW for fresh day data.

•Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008.

•Successfully did the GO-Live for loading of the CVS data of 10 million records into the Facets.

•Filter and Sorting Data using Power BI in Excel 2013.

•Developed Power BI using Excel 2012 for Reporting.

•Working on T-SQL to migrate data into (Facets) application.

•Great ability to create and manage various database objects like tables, views.

•Involved in testing different interfaces and web application for FACETS.

•Worked on FACETS Data tables and created audit reports using queries.

•Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.

•Experience working with scheduling tools in Tidal.

Environment: MS SQL Server 2005/2008, SSIS, SSRS 2005/2008/2010/2012, VB Script, SVN, JIRA, Tidal job Scheduler, Visual Studio 208, Visual Studio 2010.

SQL/SSRS/SSIS Developer 12/2013 – 06/2014

WellPoint/Amerigroup, Virginia Beach, VA

The Purpose of the e Premium Analysis system (e PAS) is to automate and enhance the e Max Premium Integrity Department’s (the business) premium analysis Process. The purpose of capitation data Maintenance system (CDMS) is to automate and enhance the inflow of capitation data into AMERIGROUP. The business has identified several units which currently import the various Capitation data files and perform varying analysis. The CDMS system shall import the capitation data, allow for quality control checks and edits, perform some common categorizations, and publish the data to the AMERIGROUP data warehouse for consumption by other analysts and systems.

Responsibilities:

•As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.

•Developed Power BI using Excel 2012 for Reporting.

•Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables.

•Monitor security batch processing jobs in multi-platform shop via Control-M &Tidal Schedulers.

•Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

•Filter and Sorting Data using Power BI in Excel 2013.

•Experience in creating complex SSIS packages using proper control and data flow elements.

•Involved in the overall SDLC including inception, elaboration, construction and deployment.

•Filter and Sorting Data using Power BI in Excel 2013.

•Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages

•Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.

Environment: MS SQL Server,2008, SSRS 2008,2012 SSIS 2008,2012 ProClarity, T-SQL, XML, ETL, Power BI, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Win SQL, SQL Server2000, SQL, Tidal.

Contact this candidate