Data Analyst Sql Server

JEEVAN RAJ OTTILINGAM LAKSHMAN RAJ

**** **** **** ******, ****, OH 44240 C: 330-***-**** ********@****.***

Summary

1.5+ years of experience as a Data Analyst with diverse industry experience in large scale enterprise,

healthcare and insurance Professional expertise includes systems applications, disaster recovery planning

and information protection analysis

Hands-on Experience with Operational support, development and production environments along with

managing priorities

Worked on BI Reports, Dashboards, Project Management, Change/Incident Management, Root cause

analysis

Experienced with detailed document and report preparation and complex internal and external data

analysis responsibilities with key competencies in the areas such as Data Management, Relational

Databases, SQL, Data Analysis, Tableau

Detail-oriented professional with extensive system administration scripting experience using shell

programming technologies

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development,

testing, implementation and maintenance with timely delivery against aggressive deadlines

Skills

Languages: c, core java, scala, spark, SQL

Operating System: windows 2000, windows XP,

windows 7, UNIX, Linux, Mac OS

Applications: MS Office, Visual Studio,

MATLAB, SharePoint

Databases: Microsoft SQL server, Oracle 11g,

MySQL, MS-Access

Cloud technologies: AWS S3, EMR, EC2,

microsoft azure, HDInsight

Data Analytical Tools: Rstudio, Tableau,

Pentaho, Talend, Informatica, SSRS, SSIS,

SSAS

Tools: Eclipse, SQL Developer, NetBeans, R

Studio, Pentaho, Sqoop, Flume, Hive, Pig, HP

Service Manager, HP Quality Center, VMware

VSphere

Experience

Data Analyst 06/2015 to 12/2015

Hewlett Packard Bangalore, Karnataka

Developed complex database objects like Stored Procedures, Functions, Packages, Triggers using SQL

Created indexes on the tables for faster retrieval of the data to enhance database performance

Created PL/SQL scripts to extract the data from the operational database into simple flat text files

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error

messages in the application

Experienced in data extraction, transforming and loading (ETL) using SQL Server Integration Services

(SSIS), SQL Server Reporting Services (SSRS) & SQL Server Analysis Services (SSAS)

Worked on Tableau server to publish dashboards to a central location for portal integration

Connected Tableau server with SharePoint portal and setup auto refresh feature

Created visualization for Sales calculation and department spend analysis for each medical product

Generated KPI for customer satisfaction survey results and disease management

Engaged in reporting to the Program Manager regarding the updates and progress of the project by

submitting weekly reports

Communicated quality status and reporting metrics of various projects, both resulting from manual testing

efforts and automated efforts

Data Analyst 06/2014 to 05/2015

TRREC Hyderabad, Telangana

Worked as Data Analyst to turn data into information, information into insight and insight into business

decision

Created star schemas and wrote SQL statements for joins, user defined functions, triggers and views

Trained under the supervision of team lead in creating effective tables

Troubleshot the minor glitches occured while creating the application

Interpreted data analyzed results using statistical techniques and provided ongoing reports

Interpreted patterns in complex data sets

Performed “clean” data and reviewed reports and performance indicator

Created SQL scripts to find data quality issues and identify keys, data anomalies, data validation issues

Assisted Developers in Data Modeling using Entity Relationship Diagrams

Developed Activity Diagrams, Sequence Diagrams and USE Case Diagrams with GUI components along

with the screen designs using MS Visio

Developed Test Plans, Test Cases and maintained Master Test Plan

Education and Training

Master of Science: Computer Science 2017

Kent State University Kent, OH, United States

Master of Science: electronics and communication engineering 2015

Jawaharlal Nehru Technological University Hyderabad Hyderabad, Telangana, India

Contact this candidate