VIGNESH.SELVARAJ

Mobile: +91-900-**-**-***

Email: acuoyp@r.postjobfree.com

Professional Summary:

Insightful, result-driven IT professional with 42 months of relevant experience in Database Development and Business Intelligence (C# Application development, Data Migration, MSBI & Report Development) with MS SQL Server. An efficient team player and understands critical business requirements and achieve quicker workable solutions.

Key skills are as follows –

Implementation of Product for the Hospital standards and designing the logics needed as per US Healthcare Industry standards.

Analytical designer for Core-measures implementation and OPPE logics

Analysis and reporting on core areas like charge and cost analysis for Hospitals/Clinics

In-depth knowledge in Clinical Integration claims Analysis/reporting

Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

Extensive knowledge of Normalization and Relational Database Management Systems.

Identify any issues related to database performance and provide corrective measures. Perform data backup and archival on regular basis.

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

Creating complex reports to meet client requirements using SSRS.

Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading. Experience in using SSIS tools like Import and Export Wizard but never had chance to directly work into SSIS but I would be happy to have one.

Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions

Experience in Performance Tuning and Query Optimization.

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

Experience in data migration.

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by SSIS services.

Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS according to task.

Experience with logical and physical data modeling and database design using Erwin.

Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

Designed the product after analyzing the requirements.

Designed GUI using C# and WPF.

Database design using SQL 2008 R2 and wrote Stored procedures, triggers etc.

Documented Technical artifacts

Active Code review participation.

Technical Proficiencies:

Visual Studio C#

SQL Server (2008 & 2005)

SQL Server Reporting Services – SSRS (2008 & 2005)

MS Excel 2007

Experience:

I.Point Perfect Transactions services Ltd. (Marketing Systems Group-Horsham)

Designation : Database Developer

Domain : Demographic and Census Data

Duration : 1 Dec, 2015 – Till Date

Roles & Responsibilities:

Develop Procedures database designs and SQL Agent Jobs for the client requirement and review the data change request requested by stake holders in MSG Team.

Prepare the ad Hoc reports script using SQL with minimal assistance, based on the requirements provided by internal stakeholders.

Deploy the Business Object reports in live / production environment with minimal assistance.

Investigate the study related issues raised by internal stakeholders and provide assistance to resolve the issue.

Critically evaluate the user request and provide suitable solutions.

Plan, prepare and Review the technical information document which contains

Proactively communicate and collaborate with stakeholders to analyze information needs and functional requirements for effective delivery of the task.

Adherence to the maintenance of documentation as prescribed under the departmental and corporate SOP’s.

Understanding the basic functionalities of Clinical trials and prepare necessary SQL triggers and Scripts to facilitate the function as per SOP.

II.Cenduit India Services Private limited

Designation : Software Analyst

Domain : US Health Care (Clinical Trails)

Duration : 12 May, 2014 – 8 June 2015

Roles & Responsibilities:

Analyze the client requirement and review the Data change request, based on priority through ticketing system with minimal assistance using Cenduit Internal tool.

Prepare the ad Hoc reports script using SQL with minimal assistance, based on the requirements provided by internal stakeholders.

Deploy the Business Object reports in live / production environment with minimal assistance.

Investigate the study related issues raised by internal stakeholders and provide assistance to resolve the issue.

Critically evaluate the user request and provide suitable solutions.

Plan, prepare and Review the technical information document which contains

Proactively communicate and collaborate with stakeholders to analyze information needs and functional requirements for effective delivery of the task.

Adherence to the maintenance of documentation as prescribed under the departmental and corporate SOP’s.

Understanding the basic functionalities of Clinical trials and prepare necessary SQL triggers and Scripts to facilitate the function as per SOP.

III.ABCO Advisory Services India Private Limited:

Designation : Data Analyst

Domain : US Health Care

Duration : 9 April, 2012 – 30 April, 2014.

Project Summary: Crimson Continuum of Care (CCC), part of the Crimson Clinical Advantage suite of offerings, places credible, severity-adjusted performance profiles directly in the hands of physicians, enabling the hospital–physician collaboration needed to advance quality goals and secure cost savings. It takes a multifaceted approach to performance improvement, combining business intelligence technology with dedicated implementation support and best practices in physician alignment. It collaborates with physicians to transform cost and quality performance across the care continuum by providing access to severity-adjusted, visually intuitive performance profiles. This includes the following features –

Visibility across all sites of care inpatient, hospital outpatient, and ambulatory settings

Guided, insight-oriented analytics with clinically actionable details.

Proven technology solution for clinical integration programs

Roles & Responsibilities:

Extracting data from the files with various formats sent by the member.

Analyzing the source data and transform it according to the business needs.

After the successful modification, moving the data to the test database.

Verifying the data is reflecting properly in the site.

Once received confirmation from member’s end, proceeding with production migration.

After production move, doing data verification. Troubleshoot the issues observed.

Serving various custom report requests from members.

Deploying and scheduling the reports as required.

Project Summary: Crimson Clinical Integration (CCI), part of the Crimson Clinical Advantage suite of offerings, places credible, severity-adjusted performance profiles directly in the hands of physicians, enabling the hospital–physician collaboration needed to advance quality goals and secure cost savings in acquiring claims from the US Government. Product combined with business intelligence technology along with dedicated implementation support and best practices in physician alignment. It collaborates with physicians to transform cost and quality performance across the care continuum by providing access to severity-adjusted, visually intuitive performance profiles.

a. Visibility across all sites of care inpatient, hospital outpatient, and ambulatory settings

b. Guided, insight-oriented analytics with clinically actionable details.

c. Proven technology solution for clinical integration programs

Roles & Responsibilities:

● Extracting claims data and formulating with Parser team and processing the same.

● Analyzing the source data and transform it according to the business requirement.

● Modification of raw data (CSV, XLS) and push the data into the test environment.

● verifying the data validity and in assure the same is reflecting properly in the site.

● Receive confirmation from all the stake holders and precede data migration into production environment.

● Performing production move, doing data intensive smoke test and spot check to make sure the successful data transition.

● serving various business custom report requests from members.

Tools Developed

I.Internal Tools Support: Defect Tracking System **

The Tool designed and developed to accommodate defects and error tracking system all through the CCC Services Floor where as and when a error or bug is created on a product, the bug will be added and frequent follow-up mails until the bug is resolved to the SME team.

This created awareness and incorporating quality among the existing bugs and avoid new bugs to know about the fixes provided by the development team. Simultaneously the data will be sent through mail to all the recipients when a bug is raised and fixed.

II. Internal Tools Support: Jenkins Report Extractor and Mailer **

This tool provides and insight on the Jenkins Automation testing ran through, which will be HTML pages where this application converts the HTML data into SQL Table data and cleanse the data as per the necessity and forward the same for the particular recipient.

The tool enables easy to use and quick look view on the issues, failures in a particular member website and which enables all the stakeholders to be aware of the issues. This has reduced the maximum time duration of 40 Mins on 60 Mins trail on analyzing by opening individual pages which is filled with data tables on issues.

Application used for development: Visual C# & SQL Developer R2

EDUCATIONAL QUALIFICATION

COURSE

INSTITUTION

BOARD / UNIVERSITY

AGGREGATE

MCA

GRD College of Science

CBE-4

Bharathiar University

80%

B.Sc

GRD College of Science- CBE -4

Bharathiar University

72%

HSC

N.M.M.H.Sec.School

Coimbatore

State Board

68%

Training and Certifications:

MS SQL Server 2005 Business Intelligence – Implementation and Maintenance (MCTS 70-445)

Got trained in Warehouse Management System (WMS), US HealthCare Functionality.

Got trained in SQL Server 2005 and SSRS 2005, Data Structure, and SQL.

Certified Training in Manual and Automation Testing from Qspiders

Additional Information’s:

Present Address: Flat No A3, Choudry Enclave.

Papaiah Layout, Coconut Groves

Behind Devmatha high School,

Horamav, Bangalore-43

Karnataka,

India.

Permanent Address No 6 PKD Nagar 1 Street

Varatharaja mills opposite

Peelamedu,

Coimbatore-641004

Date of Birth: 18 September 1985

I hereby declare that the information furnished above is true to the best of my knowledge.

Vignesh.Selvaraj

Contact this candidate