SQL Server Roles:  Analyzing use of existing tables and columns and deciding the changes required along with the product expert Creating and fine tuning of Stored procedures, which included creating indexes and Code Tuning Identifying slow running procedures and resolving the issues which may be due to absence of required Indexes or Parameter sniffing. Adding exception handling to the stored procedures for tracking the errors occurred during the process flow Configured the SQL Agent job for running SSIS Packages Using Apex SQL to give the incremental builds for the deployments Created training videos on how to troubleshoot SSIS package issues and understanding SQL LogsSSIS Roles: Designing the Packages efficiently to optimize the performance of the application Event Handling Creating SSIS package with Parent-Child packages for better maintainability

Professional Experience(1) Feb, 2012 – Present: Systems EngineerInfosys Ltd.Role: QBlue Business System AnalystResponsibilities:• Performed analysis on existing systems, recommended enhancements, and implemented strategies to streamline current processes• Used Business and existing system modelling approach to analyze the existing processes like claim processing, member enrollments, claim adjudication etc. • Prepared TRDs (Technical Requirement Documents) containing the essential business elements, technical elements, detailed definitions, and relationships between the Business Requirements and the current Claim Processing engine• Responsible for creating RTM (Requirement Traceability Matrix)• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs• Created Current and Proposed System Flow Diagram in MS Visio• Responsible for monitoring Proposed System Changes on Client’s Environment. • Responsible for writing TRD’s and Field Mapping Documents for ClaimXten and QBlue system as part of the ICD9 to ICD10 Upgrade. This Upgrade caused the Change in the Inbound/Outbound files sent/Received from QBlue to ClaimXten.• Created PCR (Process Change Requests) for Reports like : Reports for CMS SNP (Special Needs Plan) Report SRAE (Special Report of Adverse Effects) report PF (Procedural Frequency) reports(2) Feb, 2011 – Feb, 2012: Systems EngineerInfosys Ltd.Role: QBlue Systems Development and Maintenance TeamResponsibilities:• Developed SQL Scripts, SSIS Packages as part of Development and Maintenance work in QBlue system• Prepared Detailed Level and High Level Design Documents• Prepared Unit Test Cases and performed Unit Testing• Developed various Reports in SQL like: Reports for CMS SNP (Special Needs Plan) Report SRAE (Summary Report of Adverse Effects) report PF (Procedural Frequency) reports