Sql Server Information Technology

Vishakha Rathod mobile: 714-***-****

Data Analyst / BI Developer ********.****@*****.*********:***********@*****.***

PROFESSIONAL SUMMARY:

About 4 years of experience in the Information Technology industry with a focus on Business intelligence of Microsoft SQL Server 2000/2005/2008/2012 in Development, Test and Production Environments on various business domains like media, healthcare and manufacturing.

Designing and implementing SSRS Reports using SSRS 2012.

Created reports in SQL Server Reporting Services.

Effectively managed data for various departments. Health system and Hospital Administration.

Hands on experience with healthcare specific software like PM-Practice Management and EHR- Electronic Health Records,

Experience in all the Latest BI Tools Power BI, Tableau, QilkSense, Qlikview Dashboard Design

Designed, Developed and Deployed SSIS Packages.

Created database objects such as tables, views, stored procedures, Triggers etc.

Maintained referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Identified columns for Primary Keys in all the tables at the design time.

Created Entity Relationship (ER) Diagrams to the proposed database using Workbench 2012, MS Visio2013.

Created functions to provide custom functionality as per the requirements.

Redesigned Database to fulfill new requirements.

Lead projects from start to finish using sound project management skills. Worked with the rest of the Business Intelligence Team and fully support them in their roles

System administrator; building a database and migrating information from multiple databases into one database using Workbench 2012

PROFESSIONAL EXPERIENCE:

Comprehensive Community Health Centers Inc. Glendale, CA Mar 2016 – Till date

CCHC operates five community health centers providing medical, dental, behavioral, and vision services to underserved people in metropolitan Los Angeles and the San Fernando Valley. At CCHC I am the only data analyst working in the finance department this motivates and encourages me to work hard and deliver the reports on time to the team and higher executives

Role: Data Analyst

Responsibilities:

Conducted independent statistical analysis, descriptive analysis, hypothesis testing and logistic regression.

Provided assistance for health care projects through SSRS, EHR and analysis software tools.

Assisted in development of data formatting and cleaning criteria from various data sources.

Generated database reports, presentation and documentation of analytical methods.

Performed ad hoc analysis of data sources for hospital administration, CEO, CFO, EVP, and internal team.

Participated in refinement and technical documentation of database reporting requirement,

Environment: SQL Server 2012, SSIS/SSRS/EHR/PM

WorkCompCentral Inc. Camarillo, CA Apr-2015 to Aug-2015

WorkCompCentral is a specialty media company providing professional news, education and data content to the workers’ compensation industry. I was immersed in lamp technology (Linux, Apache, MySQL and PHP) created SSIS Packages designed and delivered various reports.

Role: Database Administrator

Responsibilities:

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Triggers and Stored Procedures in SQL Server.

System administrator; building a database and migrating information from multiple databases into one using Workbench 2012.

Immersed in lamp technology (Linux, Apache, MySQL and PHP) Documentation of the migration process and implementing to the database, plus, updated current UI (user interface).

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: SQL Server 2008R2 Enterprise Edition, SSIS/SSRS/SSAS and SQL Management Studio 2008.

TAP Series Inc. – California Jan 2015 to Apr2015

TAP Series' unique teaching process allows for a real-time uninterrupted learning experience by using colorful graphics, animations, full motion video, audio and interactive learning exercises.

Data Warehouse project that I was part of enabled management to better leverage information collected within current operational systems to help in their decision-making process.

Role: SQL BI Developer/DBA

Responsibilities:

Work collaboratively with the IT team and Business users to identify and refine requirements.

Implemented Tableau mobile dashboards via Tableau mobile application.

Designing ETL packages for exporting heterogeneous data, different data sources (SQL Server, Flat Files, CSV and XML files etc.) and load the data into target data base servers by performing different data transformations (DTS) using SSISSQL Server 2012.

Implementing Event Handlers and Error Handlers during creation of SSIS packages and notified process results to various users.

Automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data into consistent and reliable data, and finally load it into a Multi-dimensional data warehouse.

Analysis Services & Reporting Services.

Creating Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Triggers and Stored Procedures.

Experience in troubleshooting production servers for user and application issues.

Environment: SQL Server 2012, SSIS/SSRS/SSAS and SQL Management Studio 2012.

Synechron Inc. India.Pune Sep2012 –July2014

Synechron Inc. is a New York based information Technology Company focused on the financial services industry including capital markets, insurance, banking and digital

Role: SQL Developer/SSIS/SSRS Developer

Responsibilities:

Migrated data from SQL Server 2000 to Server 2005 using Data Transformation Services (DTS).

Perform the tasks of updating test plan status to the test manager on a weekly basis.

Collaborate with Business Analyst to ensure comprehensive requirements based testing is achieved

Created Databases, Tables and triggers to validate the data to meet the specifications.

Created views and indexed views as required by front end developer for easier implementation.

Created stored procedures and functions to support data storage and manipulation.

Used linked / replicated servers and high-volume data storage.

Converted the DTS Packages into SSIS using Migration Wizards.

Involved in Testing and Debugging the Stored Procedures and T-SQL.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer Server.

Built test scenarios and test cases (negative/positive) to validate expected outcome.

Environment: Windows Server 2003, SQL Server 2005, Visual Studio 2005, T- SQL, DTS.

Persistent Systems Limited. India.Pune July2011 –August2012

Persistent Systems is a global company specializing in software product and technology services.

Software Tester/QA analyst

Responsibilities:

Performed: Smoke tests, BVT (Build Validation Test), System Testing, Retesting (after defect fixes), IAT (Integration Testing), Regression Testing, UAT (User Acceptance Testing), PROD (Test in Production).

Environment: ASP.NET, Microsoft Visual Studio 2008, C#, Quality center, Load Runner, MS Word, Excel.

PROJECTS, TRAINING & PUBLICATIONS

SAP Production Planning Module for SAP Consultant

Role: Data Analyst

Description: Designed Production Planning module for health care industry using different Microsoft Project Management tools.

Emotional Expression Detection

Description: Application for detecting user’s emotions by his/her face, eyes and lip movements

Language used: SQL 9.0, VB, .net

Application: Airline Reservation System

Description: This is intranet portal development project for Airline System. People can book ticket using this application

Language used: VB, Oracle

Website Design

Description: Web design for educational sites. Provides information about current syllabus, admission process using HTML and JAVA

Network Administrator

Description: Designed small school network infrastructure worked on IP ranges and subnetting, switches, routers etc.

Education

California Lutheran University

Thousand Oaks, CA

Masters in Information Systems, 2015

Key Courses: Project Management, Business Analytics, Database Management, Business Systems Development, Information Security, Data Communications.

Bachelors in Information Technology, India, 2012

Diploma in Computer Technology, India 2009

SOFTWARE SKILLS

Tools : SQL Server Management Studio (SSMS), BIDS, SQL Profiler, Query Analyzer, Performance Monitor, Database Engine Tuning Advisor, SQL Mail, SQL Trace, Redgate, Quick Test professional, Load Runner

DBMS/RDBMS : MS SQL SERVER 2014/2012/2008R2/2008/2005, ORACLE 9i, MS Access 2003, MySQL.

ETL Tools : SQL Server Integration Services.

Reporting Tools : SQL Server Reporting Services, MS Excel, Crystal Reports, and Report Builder 3.0.

Languages : SQL, T-SQL, PL/SQL, VB.NET, C, C++, C#

Data Modeling : MS Visio.

Other Technologies: ASP.NET 3.5, JavaScript, AJAX.

Operating Systems: Microsoft Windows XP/Vista, Microsoft Windows Server 2003/2008R2.

Note:- From Sep 2015 to December 2015 I was attending School to Complete Master’s Degree program.

Contact this candidate