RAJEEV KASHYAP GANDIKOTA

**** ********** *****, ** ● Kalamazoo, MI 49048 ● 352-***-**** ● admpmy@r.postjobfree.com

https://www.linkedin.com/in/rajeev-kashyap-gandikota-9a11a118/

EDUCATION

Master of Science in Information Systems and Operation Management (ISOM) AUG 2015 - MAY 2017

Warrington School of Business, University of Florida. (BI & IT) GPA 3.75 GAINESVILLE

Bachelor of technology in Computer Science and Engineering (CSE) SEP 2006 - MAY 2010

College of Engineering GITAM, Andhra University. GPA 3.41 VISAKHAPATNAM

SKILLS

Tools: MS office (access, excel, power point, visio), Excel (Formulations, functions, What-if analysis, Goal seek, vlookup, pivot-tables, charts, Spreadsheet modelling, linear programming), MSSQL Server, SSRS, SSIS, SQL Profiler, Oracle, Tableau, Power BI, XLMiner, SPSS, STATA, Visual Studio, JIRA, SVN, Azure Dev ops.

Languages: T SQL (stored procedures, triggers, functions, views), PL/SQL, XML, HTML, C, Java, C#, Python.

Platforms: Windows, Linux, and Unix.

Technologies: Relational Databases (Data modelling, Design, ER diagrams, Normalization), ETL techniques, Indexing and query optimization, Data warehouse (Snowflake, Star Schema), OLAP, OLTP, data profiling, cleansing, Data Mining techniques, Statistical Analysis (Descriptive, Inferential, Policy analysis, Hypothesis testing(t-test, z-test, f-test), ANOVA (one-way, two way), Non-parametric tests, Correlational/Causal), Predictive analytics (Regression, Classification, Association rules)

Others: RCA, Debugging, Healthcare/Pharmacy/Patient/Payer Data (EDI, HL7, XML, ASC X12), Customer support, Reporting, SDLC, Agile methodologies, Scrum, Testing methodologies, System Analysis and Design.

EXPERIENCE

Systems Analyst, Streamline HealthCare Solutions SEP 2018 - PRESENT

Reporting and Production Support KALAMAZOO

●Worked on production tickets for SmartCare EHR, by trying various ways (workflows) ways for the issue replication in non-prod settings and identified the root cause (in DB using sql profiler/in Dev console for web)

●Developed many parameterized reports with drill-down, grouping features in SSRS based on patient information/ attendance data, Service Plan review, Treatment plan progress, Bed Census in lieu with the customer requirements. Deployed the reports on Report Server that is integrated with application.

●Fixed the problems related to reports and dashboards. Ensured the configurations and metrics are correct.

●Developed and maintained queries, stored procedures, functions which involved utilizing various joins, grouping, aggregations, cursors, CTE’s, window functions, date functions, null checks, views, temp tables in production. Created solutions to address system defects (bugs in store procedures) and report issues. Utilized Report builder, Visual studio to correct the reports. Checked in those scripts to SVN/ Azure Dev ops.

●Created SSIS packages to export/ transform data files and to create backup copies of clinical documents

●Monitored and scheduled sql agent jobs (Scheduling conflict /data/ logic issues in case of failure).

●Developed sql data correction scripts for the issues in existing data that is not affected by the recent fixes.

●Fixed data integrity and workflow issues related to Clinical Documents, Appointments, Services/ Notes, Client orders, Medication scripts/ Admission Records, Rx, Authorization domains of the application

●Troubleshooted and resolved billing matters such as Charges/Claims, ICD 10, CPT codes, COB Order, Client coverage plans and time spans. Worked on Electronic Eligibility verification and HL7 interface configurations

●Resolved performance issues due to worker process in app server IIS (memory issues, application time outs).

●Identified long running queries that slow the system. Performed query analysis, Activity monitor, SP_who2, Analyzed exec query stats, execution plans, used optimization and indexing to improve query performance.

●Worked on Front end application problems, analyzed the source code (NET and Java script), identified the issues/defects in the logic or recent changes to logic (Dev ops) and forward these to module team for review.

●Demonstrated excellent customer support capabilities (first line/second line) and addressed their issues in efficient manner adhering to the SLA’s promised. Provided on-call support on rotation basis in after hours.

●Developed customizations / enhancements for system functionalities based on customer requirements

●Trained the recent joiners on the EHR system (data model), its functionalities and basics of debugging.

●Adhered to HIPAA rules, PHI guidelines and practiced it while handling patient information.

Analyst, MDSL JUL 2017–SEP 2018

Telecom Expense Management (TEM) ORLANDO

●Performed excel based data validation and analysis on the telecom billing data from vendors. Segregated it based on various plans associated with the circuit and cross verified the final invoice amount generated by vendor for a given circuit. Recognized and corrected billing and payment discrepancies.

●Verified the vendor Accounts Payable file processing to address various data issues present in the AP files.

●Tested the Handlers which provides input data feed to TEM and checked for data quality, mapping issues

●Written scripts for efficient management of inventory data that verifies the updates to inventory on regular basis in the event of circuit termination or upgrade and records of the spare inventory for the future usage

●Developed sql scripts to retrieve information from HR, billing, and inventory data to create adhoc reports to represent metrics related to total spend and dashboards using SSRS for various parameters.

●Verified workflows such as ordering new device, replace and upgrade of mobiles are registered successfully and are seamlessly updated in the database upon frontend GUI operations and Ebonding requests in API.

●Helped account managers in understanding technicalities of the field issues. Worked with end users for more details and reproduced issues in lab environments to identify root cause and collect the logs and snapshots.

●Developed patch files containing stored procedures to fix the workflow and data issues in TEM system.

Senior Data Analyst, Ericsson Global Services India (EGI R&D) JUL 2013 – JUL 2015

Backend data integration and validation BANGALORE

●Experience in extracting data from various sources such as Flat files, CSVs, Excel files to SQL server staging DB. Developed control flow tasks and utilized containers, different types of transforms and worked on data flow to load transformed data, created check points. Deployed SSIS packages and scheduled them in sql agent

●Performed data mapping checks, data validation and maintained data quality by checking missing values, verifying referential integrity checks, corrected duplicate values and incorrect data using SQL scripts.

●Developed complex SQL scripts and stored procedures, to efficiently retrieve the required information from multiple tables and performed aggregations and calculations to report router performance data.

Data Analyst, Ericsson Global Services India (EGI R&D) JUL 2010 – JUL 2013

Requirement Analysis, Data Analysis BANGALORE

●Analysed requirements, documented specifications, design across router management interface releases.

●Prepared reports that indicate Errors, Alerts and Audit logs of system to check routers health/performance.

●Analyzed the network traffic data loss and worked on the issues related to protocol settings and restore traffic.

●Developed project reports that highlight critical issues that impact the project delivery date and drew insights to facilitate managerial actions in reducing the delay.

UF - ACADEMIC PROJECTS GAINESVILLE

ORDER MANAGEMENT SYSTEM – MS ACCESS DB AUG 2015 – DEC 2015

Database design for order management system using Access which involved requirement analysis, modelling ER diagrams, Normalization of the database design, identification of primary and referential keys. Wrote complex SQL queries (Unions, Inner & Outer Joins, Views, Sub queries, Aggregate functions, DDL statements) on the imported excel data, generated forms and reports using respective wizards in specified format.

GLOBAL SUPERSTORE –SALES DATA ANALYSIS - MS EXCEL, TABLEAU JAN 2016 – APR 2016

Imported the sales data of Super Store onto Tableau 10 and prepared visualizations such as line, bar charts, scatter plots, pivot tables, dashboards to understand and analyse the sales trends over different quarters over years. Observed effects of various factors such as salesperson, region, customer demographics, popular products on the Total sales/ revenue. Created many calculated fields and various groupings to analyse data. Formulated excel sheets and implemented sensitivity analysis on turnover using goal seek, linear programming, data-tables.

PROBLEMS ON STATISTICAL ANALYSIS - MS EXCEL, SPSS, Stata AUG 2016 – DEC 2016

Conducted analysis using one-way & two-way ANOVA, Non-parametric, Hypothesis tests (f-test, t-test, z-test), Chi-square test, Correlation, Regression (SLR, MLR), Descriptive & Inferential statistics, Policy analysis on panel, time series datasets using SPSS, Stata, excel analysis tools and interpreted statistical/economic significance.

INSURANCE FRAUD DETECTION - MS EXCEL (XLMINER), SPSS JAN 2017 – APR 2017

Implemented data profiling and data cleansing to improve data quality of Insurance fraud data set. Worked on missing data, outliers and used binning techniques for replacement values. Performed data mining techniques like Dimension Reduction (PCA), Cluster Analysis (k-means), Classification techniques (CART trees), generated Association rules for patterns and dependencies. Assessed the classifier performance based on ROC, Lift chart and Confusion Matrix. Performed correlation and regression analysis to identify patterns and predict trends.

Contact this candidate