Sql Server Data

MANIKANDAN THANDALAM MOHANASUNDRAM

*** ***** ****** **, *******, IL 60607 312-***-**** ****.*********@*****.***

https://www.linkedin.com/in/manikandanTM

SUMMARY:

Healthcare IT professional with three years of experience to drive today’s technology and conceptualize tomorrow’s processes.

Specialties: Healthcare Information Management, Clinical work flows, Data analysis, Statistical techniques and predictive models, Clinical Data Management System, ETL, AD hoc testing and Project Management

EDUCATIONAL QUALIFICATIONS:

Master of Science in Management Information Systems

Expected – May 2016

University of Illinois at Chicago – Liautaud Graduate School of Business, Chicago, IL

GPA: 3.4/4.0

Bachelor of Engineering

May 2012

Anna University, Chennai, India

GPA:8.2/10.0

CERTIFICATIONS:

SAS® Certified Professional: Regression and Predictive Modeler

SAS® Certified Professional: Statistical Business Analyst

Infosys Internal Certification: Database development using SQL server 2012

INFORMATION TECHNOLOGY SKILLS:

Data Analytics/Statistics/Database: R, SAS, SPSS, Apervita, Rapid Miner, MySQL, MS SQL Server 2012, Google Analytics

ETL Tools/Reporting: SSIS, Tableau, QlikView, SSRS

Programming: J2EE, Python, Hadoop MapReduce

Productivity: Microsoft Office Suite, Microsoft Project, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Data Base Administrator and Web Developer University of Illinois at Chicago Jan 2015 – Present

Assisted in design and implementation of databases for various functions like project, quality and operations through SQL Server

Designed department’s website on WordPress. Improved unique visitors by 40% and bounce rate by 20% through Google analytics.

Health Care Data Analyst -Intern Loretto Hospital May 2015 –Aug 2015

Developed complex queries, stored procedures, views and functions to support clinical investigations purposes on SQL Server 2012.

Extracted data from Meditech Data Repository and built a data warehouse for several analytical and reporting purposes using SSIS.

Automated customized daily census reports through SSRS. Achieved 85% reduction in man-hour on manual reporting tasks.

Responsible for creating KPI dashboards in Tableau Desktop by establishing a direct SQL server connection. Recommended Tableau Enterprise solution as global reporting tool for all departments within the organization.

Systems Engineer Infosys Technologies Limited Oct 2012- Mar 2014

Gathered requirements, liaise with business and technical delivery group to study project feasibility and to conceptualize projects.

Assisted data base design and maintenance, created programs and reports to automate workflows using SAP.

Performed reporting using pivot tables, macros, v-lookups and h-lookups in MS Excel that helped reduce 12 man-hours in the project.

Clinical Data Analyst National Siddha Institute, India May 2012 – Oct 2012

Assisted in planning, designing and documenting standardized project related procedures through Case Request Form, Data Management Plan and Statistical analysis plan.

Participated in End to End data management (CDMS) operations including quality assurance (Data entry and code review), edit check programs (Manual checks, Test case preparations and querying DB) and handling data discrepancies.

Worked with SAS 9.4 to preprocess (Outliers, Data transformation) and analyze patterns in data using various statistical techniques.

PROJECTS:

Dimensional Modelling: Prepared ETL-Technical specification document and developed a dimensional data warehouse using star schema with ETL tools. Identified KPI’s and generated BI reports for answering key business questions using Tableau.

Medical Claims Fraud Detection: Performed data cleaning, dimension reduction on claims dataset. Implemented different fraud detection algorithms to develop models. Evaluated models based on performance, scored new datasets using SPSS and Rapid Miner

Analysis on Customer Satisfaction Index: Applied various regression, correlation and statistical techniques to identify the key satisfiers and dis-satisfiers on customer survey dataset using SAS.

Target Marketing: Implemented Predictive algorithms to identify the top 25% responder for solicitation from a marketing data set. Models were created through Decision trees, K means, Naïve Bayes algorithm and Logistics regression.

Contact this candidate