Vijaya

Ratnam Mob: - Email- Objective Position as Senior Database Engineer that will challenge my career growth and improve my knowledge and add value to the organization. Professional Summary Senior Software Engineer having 5+ years of work experience in SQL Programming and Database Administration using MS SQL Server / T-SQL. 4+ Years of experience in Database Schema designing, developing Complex SQL Queries, Stored Procedures, CTE, Views, User Defined Functions and Triggers. Along with Performance tuning. Good experience in performance tuning by optimizing the queries and indexing using SQL Profile and other debugging methods. Good Experience in reports development using SSRS Good experience in MS SQL Server Administration including Database Backup, Monitoring the Server, Replications and Database Migrations. Good exposure and experience in Health Care domain Technical Skills RDBMS : MS SQL Server 2019,2016,2012,2008 R2, SSRS Operating Systems: Windows Server 2003/2008/2012 & XP Education Summary Microsoft SQL Server Certification (70-432) MCA, Master of Computer Applications from Andhra University in 2010. B.Sc from Andhra University in 2007. CAREER CHRONOLOGY Senior Database Developer- Teksystems(HP Client)-Nov 2016 – July2017 Senior Software Engineer- DNA HealthCare-Oct 2011 – Oct 2016 Partner Managing Printing Service (PMPS) Client: HP Platform: SQL SERVER 2008 R2, SQL SERVER 2012, SSIS 2012, SSRS 2008 Team Size : 26 Duration : Nov 2016 to till date Responsibilities: Requirement Analysis, Impact analysis, SQL development, Code review, Bug fixing, Deployment, performance tuning,SSRS reports development,SSIS packages developement Project Brief: The PMPS is enterprise application which include Orion, Chronos, Notus+ (mobile App), Orion Application is basically used for service delivery, For that it will have contracts of a client with collection of printers. Application allow user to enter service calls for printers from various application. Then the application will be used to allocate the call to technicians and track the service till it get closed. Orion will also maintain logistics parts needed to fulfill a service. Logistics part include maintaining parts in stock, and have accountability. Orion also support drop shipment And integrated with third party venders for ordering. Other part of logistics is shipment which is tracked from ordering a part to get it in stock. Orion as billing module. PMPS support full support as well as invoice printers. In full support client is charged for pages printed and all supplies like toner, drum, parts replacement is done without cost. For Orion will maintain pages printed for each printer trough data collector or manual. Data collectors used are FM audit, Staples and UDA. In case of invoice printers, invoice is created for each service made. All DCA are integrated through APIs. Apart from page counts DCA report supply (toner) levels also. Which is used for ATR. Auto toner replacement is a tool which will monitor the toner level and once threshold level is reached (less than 10 %), it will trigger for a service to send toner to client place. Overall Orion enterprise solution will take care of contract creation, service delivery and logistics management. Coding Project Client : BLHC Environment : SQL Server 2008R2,SQL SERVER 2012, Windows 2008/2012 Duration : July 2014 to till date Team Size : 4 Role : SQL Developer & DBA Project Brief : This project transform the revenue cycle management by completely offloading the burden of billing offices, increasing operating costs, changing regulations, attrition, staff training, decreased physician reimbursements and augmentation includes HIPAA compliance requirements, diagnostic and procedural coding tasks. Roles and Responsibilities: Involve in requirements gathering, database design, database objects creation, database programming, data analysis with detailed reporting. Accomplishment: Have designed database schema, developed CTE and procedures for Coding Project data storage. File processing automation using CTE, Procedures from various source locations including from the FTP Servers. Developed procedures for monitoring the SQL Servers processes, MDF space utilization and automated tasks summary. Database administrating including database Replication,Backup and Restore, log file shrinking and server connectivity issues,Security issues. Responsible for General database Administration like log file shrinking, servers connectivity. As per the client requirements, rendering the reports in the form of PDF, EXCEL and CSV formats and generated the reports weekly and monthly basis as per the client requirements. Custom data archiving process between the servers using procedures and linked servers. Database migration between the servers configuration Iguana interface engine maintenance by swapping the feeds and monitoring the application. BLHC Charge Capture Client : BLHC Environment : SQL Server 2008R2,SQL SERVER 2012, Windows 2008/2012 Duration : Oct 2011 to July 2014 Team Size : 6 Role : SQL Developer & DBA Project Brief : This is the part of the revenue cycle management by capturing the charges or orders that are done across BLHC for Coding and Billing process. This project ensures accuracy, completeness and proper coding by posting, reviewing and submitting all office charges, hospital visits, surgeries, diagnostic and laboratory tests,error-free and faster claims submission at a lower cost Roles and Responsibilities : Involve in requirements gathering, database design, database objects creation, db programming , data analysis with detailed reporting. Accomplishment: Creating Database Objects like Tables,Indexes, Stored Procedures, and Views. Writing and tuning queries, Optimizing stored procedures and functions by using SQL Profiler. Backup and restoration of Databases and setting up Replication. Preparing project related documents. Responsible for General database Administration, and automation. As per the client requirements, rendering the reports in the form of PDF, EXCEL and CSV formats and generated the reports weekly and monthly basis as per the client requirements. Personal Details Address:H.No. 173,Billekahalli. B.G.MainRoad. Banglore-560076 DOB: 01-June-1987 Maritial Status: Married Languages Known: English & Telugu Declaration The above furnished details are true to my knowledge. Ratnam References: Available upon request