Information Technology Sql Server

Sai Ogirala

Email: ********@****.***,*********@*****.***, Ph.no: 678-***-****

http://www.linkedin.com/pub/sai-ogirala/4b/481/57a

OBJECTIVE: Seeking an IT position with a company utilizing technical and research skills gained

from academic projects and internship experience.

EDUCATION:

Master of Information Technology December 2014

Southern Polytechnic State University G.P.A- 4.0

Graduate Certificate in Health Information Technology December 2014

Southern Polytechnic State University G.P.A- 4.0

Master of Business Administration June 2008-Apr 2010

Institute of Public Enterprise G.P.A- 3.75

Bachelor of Information Technology Aug 2004-May 2008

Jawaharlal Nehru Technological University G.P.A- 3.25

TECHNICAL SKILLS:

Familiar with: HTML, CSS, JavaScript, MS SQL Server 2008 R2/2012, SSRS, SSIS, SSAS (2008

R2/2012), Qlikview Dashboard Professional 11.1, MS Office suite, SPSS.

ACADEMIC EXPERIENCE:

Brave Point Pvt Ltd Aug 2013-Dec 2013

Business Intelligence Project –Money Penny Dashboard

Gathered Business requirements and translated objectives into actionable Dashboard and

analytics

Created Data modeling using MS Visio 2007/2010 for database

Designed creative and visually effective user interfaces that address four Key Performance

Indicators such as Utilization Rate, Revenue, Average Bill Rate and Active Contracts using

Qlikview software 11.1 version

Involved in the development of writing T-SQL, Views and Indexes

Performed database validation using SQL server Management Studio 2012 to ensure that data is

accurate and matches with the user requirements

Designed and developed SQL SSIS Packages to extract data from various data sources such as

Excel spreadsheet, and flat files into SQL server 2008R2/2012 and further analyzed data by

using multiple transformations Derived Column, Data Conversion, Conditional Split, Bulk

Insert, merge and union all

Created Dashboard reports using Qlikview Dashboard and also designed matrix, tabular and

parametric Reports in the SQL SRSS 2008R2/2012.

Created OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of

large sets of data from SQL Server Management Studio 2008 R2/2012 and SSAS 2008

R2/2012.

Working knowledge of Analytical Tools like SPSS software.

Foundations of Health Information Technology-Term Project Aug 2013-Dec 2013

Chosen Metro Medical Associates clinic to know how does clinic is operating according to the

Obama healthcare plans

Discussed with Practice Manager Sangeetha Patil, Dr. Alexander Bindu whether clinic is

adopted Electronic Health Record system, and its daily Clinical Workflow operations

Discussed about how does clinic is following HIPAA Regulatory compliance and Meaningful

use standards

Conducted EHR Adoption Survey to know whether they have any difficulties with present EHR

software and how EHR impacts their career and overall organization

Prepared final report and presented my learning outcomes from this real time project in the

classroom

IT Design Studio- Capstone Project Jan 2014 – April 2014

Designed and Developed Question/Answer Website Form using HTML5, CSS, JavaScript, PHP

and MySQL.

Performed Client and Server Validation using JavaScript and PHP whether the form values are

valid or not before user submits the Question form.

Inserted the values coming from Question/Answer form into MySQL database.

Check that user is notified to email address after registration with the website.

Advanced Web Concepts and Design- Capstone Project Aug 2014- Present

Working with a client to document system requirements and client needs.

Design and create a database using MySQL to store volunteer and their activity data.

Build a database driven website with the functionalities Volunteer registration and sign-up for

specific events using HTML, CSS, JavaScript, PHP, MySQL.

Provide admin functionalities including creating events, managing volunteers (add, update,

delete), signing up events.

Provide volunteer functionalities including self-registration, status check, and contact updates .

Set up auto-reminder via emails or text messages

Provide a calendars, reports including by volunteer list by events and Export data to spreadsheet

WORK EXPERIENCE:

KONY Labs Pvt Ltd June 2010-Dec 2010

Research Analyst/Quantitative Analyst:

Performed as Business Research Analyst between Program manager and HR Department in

various projects and performed other related HR activities.

Gathered necessary information about new employee data and reports to the HR team in

timely manner

Prepared documentation and analyze reports related to Area Recruiting activity, including:

identifying trends, advising recruiting staff on findings, understanding Business needs and

applying reporting capabilities to the needs of the business.

Provided functional support for HRIS systems to answer questions, troubleshoot and provide

guidance on effective use.

Maintained and update HR related data tables in the HRIS systems, audit periodically to ensure

the information is accurate.

INTERNSHIPS:

BSNL Telecommunication, Andhra Pradesh, India Nov 2009-Apr 2010

Research Analyst Intern:

Gathered business requirements and prepared Research Methodology documentation to

conduct Market Research about Customer Perception of BSNL Company.

Collected data using Questionnaire and Personal Interviews to analyze the importance of price,

Quality of Service, Competitive Edge of different mobile service providers used by

customers

Data Analysis is implemented using Linear Regression Technique to find out the relationship

between each independent variable with dependent variable using Statistical Package for Social

Sciences (SPSS) software.

Provided Documentation of Business reports to company executives including research findings

and conclusions.

Recommended Suggestions and Implications on various ways to increase their percentage of

market share among Indian telecommunication providers

South Central Railways, A.P, India April 2009-Oct 2009

HR Intern

Prepared Research Methodology documentation to conduct market research on Effectiveness

of Performance Appraisal at South Central Railways.

Gathered Business Requirements from employees, their views, opinions and their knowledge

of evaluation factors using Questionnaire and One on one interview process

ANOVA regression is used to test the relationship between independent variables and dependent

variable in SPSS (Statistical Package for Social Sciences).

Conducted Reliablity stastics to check there is a relationship exists between each independent

variable and dependent variable using cronbach’s alpha which is greater than 0.6 that means

data is reliable.

Provided Implications and Recommendations to improve their existing performance appraisal

system using 360 degree performance appraisal which helps to maximize their employees and

overall organization productive output.

Contact this candidate