Sql Server Data

Damacherla Swathi

404-***-****(Cell)

Email: ****************@*****.***

SUMMARY:

An enthusiastic professional, with experience in Analyzing system functionality, Conceptualization, and Implementation of Software in healthcare and financial environments.

Over 3 years of experience in reviewing and analyzing business requirements and implementation of SSRS Reports and ETL Transactions

Well versed with Object Oriented Modeling using UML methodology (use cases, state charts,

Sequence diagrams) using visual paradigm.

As an Analyst/Developer, involved in all phases of software development including client interaction for requirements-use cases, use case analysis, design, development and testing.

Good knowledge of data warehousing concepts and BI applications.

Experience in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).

Experience in developing and modifying multi-dimensional cubes using SQL Server Analysis Services (SSAS).

Acquainted with Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).

Strong understanding of Dimensional Modeling technique, Multidimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, Section Access, and datawarehousing concepts.

Created complex SSIS packages and used various tasks, containers, sources, transformations and destination in SSIS tool while transferring the data from various sources systems into the destination.

Experience in data modeling and reporting per client requirements.

Has knowledge of HL7 messaging and vocabulary standards

Expertise in trouble-shooting, testing and solving problems in HL7 interface development and implementation.

Strong understanding of Hyperion Architecture.

Client and server installations of EPM Suite as well as the previous versions of Hyperionproducts such as Essbase Server, EAS, Essbase Integration Services, Essbase Analyzer and Hyperion Reports in Windows environments.

Metadata Loading and Actual data loading using HAL & Outline Load Utility.

Experience in design and development of Web Forms, Hyperion Financial Reports, WorkFlows, Task Lists, Menus and Smart Lists.

Efficient in data analysis and ability to multi-task in tight schedules meeting deadlines.

Excellent Communication and Interpersonal skills.

A positive approach towards any circumstance allows me to deliver outstanding results on a regular basis.

Possess effective report writing and knowledge sharing among Team (Community of practice).

Adapt to new environment easily and learn new things quickly.

Analyze the functional requirements & issues and achieve results

TECHNICAL SKILLS

Programming Languages

C,SQL, TSQL, PL/SQL,HTML

RDBMS

MS-SQL Server 2000/2005/2008,2012, Oracle 9i/10g, Microsoft Access, DB2

ETL Tools

SQL Server Integration Services (SSIS) 2005/2008/2012, DTS

Reporting Tools

SQL Server Reporting Services (SSRS) 2000/2005/2008,QlikView 11,Tableau

Database Tools

SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), Enterprise Manager, SQL Profiler, Teradata, Query Analyzer

Modeling Languages (OOAD)

Unified Modeling Language, SDLC, Microsoft Visio, Visual Paradigm.

Healthcare IT

Practice Fusion(EMR), EPIC Registration & Scheduling (Cadence),EPIC Ambulatory, EPIC Inpatient, EPIC Inpatient (Advanced), EPIC Billing (Resoute),EPIC Pharmacy (Willow),HL7

Operating Systems

Windows XP Professional/Standard, Windows Vista Business/Ultimate, Windows 7 Ultimate, UNIX.

EDUCATION

MS in Management Information Systems, UTD GPA: 3.6

Bachelor’s in Electronics & Communications, JNTU, Hyderabad GPA: 3.6

PROFESSIONAL EXPERIENCE

Business Analyst Intern at OMNICURE HOME HEALTH Jan 2014 – Dec 2014

Omnicure Home health provides skilled nursing, physical therapy, occupational therapy, speech therapy, MSW, registered dietician. Worked with the new Online Referral System to increase the number of patients for the company.

Responsibilities:

Created a new business plan-Online Referral System for CareCentrix patients.

Developed Use cases and class diagrams in Microsoft Visio for the new claims procedure.

Introduced a new procedure for allotting RNs to the patients which avoided delay of patient care and improved the profit.

Developed user documentation and scripts for the physical therapists, RNs, occupational therapists.

To document the business process by identifying the requirements.

Prepared documentation on business requirements.

Created stored procedures, indexes, and queries.

Care Choices, Bangalore, INDIA Jun 2012 to Jun 2013

Client: Trinity Information Services

Integration and Solutions Department

(System Analyst)

Trinity Data Repository (TDR) stores the patient's health care data from different Trinity Health Member Organizations at different sites. The Data is fed into TDR system in the form of HL7 Messages via the Cloverleaf Interface Engine.

Responsibilities:

Study and Understanding of TDR, CardioTrac and Jupiter databases also Sqlizer, Populator and Replication Programs (PL/SQL).

Responsible for trouble shooting and solving the problems related to the HL7 messages of ADT (Admission, Discharge, and Transfer) and Order Entry.

Conducted the regression testing for the replication code changes that were made in the Replication.

Was involved in conducting the unit testing of the procedures pertaining to the different HL7 ADT and Order Entry transactions ex (A01- A18, ORM, ORU)

Suggested some changes at the Interface Engine feed to TDR so as to minimize the errors that occur at the TDR.

Environment: Unix (IBM AIX 4.3.3), PL/SQL,QDX A2A Integrator (Cloverleaf Interface Engine), MS Office tools, Windows XP, Vista

ICICI Bank, Hyderabad, INDIA June 11 to May 12

Data Analyst

Online Banking System was developed to facilitate the users and customers with Web based reports. It has four major modules like Consolidation module, Maturity module, Pricing communication module, and Account access module.

Responsibilities:

Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys

Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.

Configured SQL Server 2008 Environment.

Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.

Design and Creation of logical storage (Table spaces, Segments etc.).

Designed E-R Diagrams, logical and physical data modelling

Interacting with business users in getting the reporting requirements.

Performed installations of Oracle 8i and SQL server databases.

Backup and Recovery of Oracle database using Recovery Manager (RMAN).

Developed Database Triggers and Stored Procedures for populating and updating data into different tables on ORACLE 8i Database Management Systems.

Used FTP and SCP for keeping important files safe and secure.

Optimization of the SQL queries to meet the performance requirements.

Worked with database export & import scripts to backup database

Created tables, indexes, stored procedures and functions.

Developed and integrated code for enhancement of the application.

Responsible for optimizing the queries and application tuning.

Developed custom reports using Microsoft reporting Services.

Writing Oracle scripts for the SQL and PL/SQL requirements for various applications.

Optimization of the SQL queries to meet the performance requirements.

Environment: Windows, UNIX, SQL server, Oracle 9.2.0.1.0, T-SQL, Query Analyzer, Data Transformation Services.

RELEVANT PROJECTS in MASTER’S

Healthcare Database Management Project (MS Access) - Database Management.

Designed and developed relational database application for managing a company’s insurance policies.

Created forms and reports in Access and Data Modeling using MS Visio and established the relationship between the entities.

Written SQL queries to retrieve user information. Improved database by creating index, constraints and triggers.

Project lead - Mobile app Development (Online Delivery System) – System Analysis & Project Management.

Assigned as the project lead by the group and allotted duties to each group member and made them meet the deadlines assigned.

Created Use case Diagram, Use cases, Context Diagram, Sequence Diagram and class diagrams in UML

Developed interface design, system design.

Documented all the components of the work and made a project report.

Don’t get kicked (for buying cars in an Auction) - Data Mining & Analysis using SAS Enterprise Miner

Took the initiative to be the project lead and allotted work to every member and scheduled meetings whenever required.

Using advance data analytics (SAS Enterprise Miner) for Data Pre-Processing on unstructured training dataset to get proper formatted data

Applied advance and predictive modeling techniques such as decision trees, regression and neural networks and came up with the best model to analyze which car turns out to be a bad buy.

Documented all the findings and analysis of the observations obtained.

Contact this candidate