Prathyusha,M

E-Mail: acvs0a@r.postjobfree.com

Cell: 480–843-4844

PROFESSIONAL SYNOPSIS

A BI Consultant and Database Developer with 4 years of experience in Sybase, SQL

Server 2005/2008/2012 and Business Intelligence solutions using Crystal Reports and SSRS.

Knowledge in requirements gathering, analysis, preparing technical and program specifications, coding, development, code review, coordination with stakeholders, production promotion and post-production support.

Skilful in handling the critical business requirements by providing quicker and better solutions.

Proficiency in analysing and translating business requirements to technical requirements and architecture.

Responsible for business analysis for improvement through the use of data analysis and performance trending.

Knowledge in writing SQL queries/ procedures in different RDBMS systems and Performance Tuning.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Responsible for establishing and maintaining business relationships with key stakeholders and providing reporting solutions to meet organizational objectives.

Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Create business and associate level reporting from concept to implementation to include scope, definition, design and development through various programming software like MS SQL, Crystal Reports, and the Microsoft Office suite of applications.

A good deal of Knowledge in SAP Crystal reporting, SQL Server Reporting, SSRS, Data Transformation Services.

Detailed knowledge of the full software development life cycle.

Ability to automate data retrieval and storage processes.

Knowledge in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.

Ability to function in a team environment as an individual technical contributor

Knowledge on different RDBMS systems like Sybase ASE, Sybase IQ, SQL Server and Oracle Developer.

Analysing the Diamond/ Facets (lower version) based reports and migrating it to Facets 4.7.1.

Team player and self-starter with professional attitude, excellent analytical and communication skills.

TECHNICAL SKILLS

RDBMS Systems: Sybase ASE, Sybase IQ, SQL Server and Oracle Developer.

Reporting Tools: SAP Crystal Reports XI R2, SAP Crystal Reports 2011, SSRS

Reporting Portals: CMC (Central Management Console),

Operation Systems: Windows 7, Windows XP

Tools/ Packages: Microsoft Office, Ultra Edit and Notepad++, Foot Prints Tool

FUNCTIONAL/ TECHNICAL CERTIFICATIONS

Name of Institution

Certification Name

Year Of Completion

America’s Health Insurance Plans (AHIP)

AHM -250 (Professional, Academy for Healthcare Management)

2013

Oracle(OCA)

OCA 1st Exam ( 1Z0-051 Oracle Database 11g: SQL Fundamentals I)

2014

EDUCATIONAL QUALIFICATIONS

Bachelor of Technology in Electronics and Communication Engineering – 2007-2011, Vidya Vikas Institute of Technology – Affiliated to Jawaharlal Nehru Technological University, Hyderabad.

Projects Knowledge:

#3

Project Name : Global Reporting Solutions

Role

Report Analyst/ BI Developer

Organization

North Gate Arinso

Team Size

5

Environment

Software

Database: SQL Server, Sybase ASE, Sybase IQ

BI Tools : SAP Crystal Reports 2011, SSIS

O/S : Windows 7

Hardware

Client/Server Architecture

Duration

March 24 2015 – November 1 2015

Project Description:

NGA is a leading provider of HR solutions and the trusted partner of HR decision makers around the world. We help HR executives optimize HR services through smarter processes and more efficient technology, supporting key HR areas like workforce administration, payroll, talent management, and HR analytics & reporting.

Roles and Responsibilities:

Analyzing the existing reports and preparing the Software Specifications Document (SRS).

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Designed logical and physical data models for star and snowflake schemas using Erwin.

Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Worked on XML along with PL/SQL to develop and modify web forms.

Designed Data Modeling, Design Specifications and to analyze Dependencies.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Used Discoverer 2000 to provide end users easy access to data and help in data analysis.

Created some Custom reports and Forms for the end users to check the details and errors.

#2

Project Name : Sybase ASE to IQ Migration (Community and State BI)

Role

Software Developer/ Report Analayst

Organization

UnitedHealth Group

Team Size

4

Environment

Software

Database: Sybase ASE, Sybase IQ, PL/SQL

BI Tools : SAP Crystal Reports 2011,SSRS

Data Model: FACETS 4.7.1

O/S : Windows 7

Hardware

Client/Server Architecture

Duration

February 2014 – March 24

Project Description:

As part of Sybase ASE to IQ Migration Project, Crystal Reports (with SQL Scripts/ Stored Procedures and all the re-usable components etc.) which are currently running/ available on Sybase ASE server will be migrated to Sybase IQ server. This Project was initiated due to server upgrade from old RDBMS system to latest system in order to improve the performance and reduce the TAT (Turn Around Time) of Query(s) execution. As part of this migration, more than 500+ reports are migrated to Sybase IQ server.

Roles and Responsibilities:

Being a senior developer in the Community and State BI reporting team, my responsibility was to identify all the reports which are running on Sybase ASE server.

Do the Impact Analysis and find the reports which are getting impacted by the server upgrade process and prepare a final report list.

Analyze the Impacted Report’s SQLs, convert them to Sybase IQ Compatible.

Responsible for producing identical results in Sybase ASE & IQ Platforms.

SQL Performance Tuning and Bug Fixing (if found any) by notifying to Onshore counterpart.

Allocation of reports within the team and check for progress on a timely manner.

Reviewing the code and design created by the team members and closure.

Interaction with Onshore counterpart on any issues and get clarifications for smooth flow of project.

Scheduling the developed reports in production server using CMC reporting portal.

#1

Project Name : GLHP to CSP Migration Project (Community and State BI)

Role

Software Developer

Organization

UnitedHealth Group

Team Size

3 – 5

Environment

Software

Database: Sybase ASE, Sybase IQ, SQL Server, PL/SQL

BI Tools : SAP Crystal Reports 2011,SSRS

Data Model: FACETS 4.7.1, FACETS 4.3.1

Proprietary Applications: GLEN (Greater Lakes Employee Network) – IRS (Internal Reporting Server)

O/S : Windows 7

Hardware

Client/Server Architecture

Duration

July 2013 – February 2014

Project Description:

GLHP Application (GLEN) is developed and maintained by UnitedHealth Group, which consists of different modules developed for UHG’s Health plan and it is an proprietary application for strategic platform. As part of standardization, this business is getting migrated under single data platform called CSP (community Strategic Platform). In this process of migration, the reports (parallelly all other parts of migrations like data etc.) from GLHP will be migrated to CSP Facets platform. GLHP is built on SQL Server technology, whereas CSP is on Sybase technology. This CSP database is used for developing reports as part of CSP Reporting Solutions Project.

Roles and Responsibilities:

Analyzing the existing GLHP reports and preparing the Software Specifications Document (SRS).

Preparing mapping documents for – GLHP to CSP (or) GLHP to SMART based on the business requirement.

Remove Custom tables and replace with Facets core tables.

Participating in requirements review and clarifications meetings with Onshore Analysts and clarifying the requirements gaps (if any) during U.S. business hours.

Reports Development in Crystal, SSRS and SQL in Sybase.

Real Time testing of projects with business users and Code Reviews and Coordination of Deliverables.

Scheduling the developed reports in production server using CMC reporting portal.

Have conducted many successful training sessions across teams on SQL, database objects and Crystal reports. Was also responsible for working as a mentor of database for all entry level associates in the project.

Creating templates and checklists to reduce development effort and minimize defect chances.

Worked on migration of more than 400 reports of seven different plans with a very minimum number of defect injection.

Submitted couple of ideas and patterns (DP) which results in huge cost savings in the project.

PERSONAL DETAILS

Full Name:

Prathyusha,M

Husband’s Name

Ravi Teja

Current Location

Phoenix, Arizona

Permanent Address

19800 N 7th Street, Apt 2077

Marital Status

Married

Personal Email Id’s

acvs0a@r.postjobfree.com

Contact Numbers

Mobile: 480-***-****

I hereby declare that the above written particulars are best of my knowledge and belief.

Date:

Place: Phoenix Prathyusha,M

Contact this candidate