Data Analyst

RESUME

Professional Summary:

Having * years of proven track record as Oracle developer contributed for the applications development.

Responsible for the full systems lifecycle from requirements gathering through implementation of data analysis solutions.

Primary responsibility as Data Analyst, acquire data from systems of record, cleanse and conform it before distributing it to downstream analytics data marts and operational data stores.

Worked closely with clients and demonstrated professional knowledge and ensured that the work products and deliverables were of the highest caliber in client satisfaction.

As an SME identified, developed, and implemented techniques that improved engagement productivity, increased efficiencies, mitigated risks, resolved issues, and optimized cost savings and efficiencies for clients.

Expert in understanding data sources and structures that relate to data warehousing techniques and analytical reporting.

Knowledge on Big Data Architecture, MapReduce and Hive.

Had experience in Data Modeling and Data Architecture.

Developed various DB objects like packages, procedures, functions, triggers, Views and Indexes.

Hands on with performances tuning which includes SQL Queries tuning, rebuild indexes, partitions.

Had worked on ETL tools – SSIS & Informatica for Data extraction, transformation and loading.

Creation of database tables, table spaces, users in Oracle 10g and 11g.

Experience in DB activities like Backups and Recovery, exports/imports.

Having experience in Dynamic SQL and Data Migration

Used Microsoft SSIS for data extraction, transformation and loading.

Developed reports using Crystal Reports.

Certifications: Certified “Mastering Data Analytics with R” from edureka! in 2016 with “A” grade.

Professional Experience:

From [Year]: To [Year]

Employer

Positions held

Dec 2013 – Till Date

UnitedHealth Group

Data Analyst

Jan 2011– Nov 2013

Magnaquest Technologies Ltd.

Oracle Developer

Technical Skills

Operating Systems

Linux, Unix, Windows XP, 2000, 2003, 2012 and Windows 7

Databases

Oracle 9i,10g, 11g, PostgreSQL

Reporting Tools

Crystal Reports XI

Programming Languages

PLSQL, Data Analytical Tool R

Other tools

Toad, SQL Developer, exp/imp, expdp/impdp, AWR, RMAN, Sql data modeler,SSIS & Informatica

Ticketing Tools

MICS, HPALM

Educational Summary :

Title of the Degree with Branch

College/University

Percentage

Master of Computer Application

Holy Jesus & Mary PG College for Computer Science

Achieved an aggregate of 69

B.A (Eng Lit)

St. Xavior's Degree College

Achieved an aggregate of 60

Intermediate

Sarada Junior College

Achieved an aggregate of 72

SSC

ZPH School

Achieved an aggregate of 73

Projects Handled:

Project # 1

Client : eSynch Health Portal (eHP)

Location : USA

Team : 13

Duration : Jan 2014 – till date

Technologies : Oracle10g, Microsoft SSIS, Windows 2012,

Domain : HealthCare

Description : eSync Health Portal (eHP) is a health portal designed to improve the quality and health care of employer groups. This application provides users health and wellness programs, health assessment, and health trackers with reward plans. After registering at the portal, employees are prompted to complete assessments and questionnaires that capture their current health factors ("I Am"). Then, programs identified offer the greatest potential for improving and maintaining that employee's health ("I Do"). When employees participate in these programs, they become eligible for various rewards ("I Get"). Ultimately, this drives better health outcomes and lower medical costs to the employee and employer.

Responsibilities:

At United Health Groups, I am working as an Oracle Data Analyst.

Part of current responsibility, use Data Analytical tool – R to provide predicative analysis strategies to business for decision making.

As an SME identified, developed, and implemented techniques that improved engagement productivity, increased efficiencies, mitigated risks, resolved issues, and optimized cost savings and efficiencies for clients.

Responsible for data modeling and key responsibility is to maintain the Data Integrity across various DB severs.

Automated the process to validate the accuracy of Config files with Database using PLSQL procedures.

Developed Procedures, Functions and implemented the business validations through Triggers.

Views and Materialized views are used to provide the required business data for various reports.

Performance tuning is highly used to enhance the performance. • Collections, Arrays, Varrays and Nested Tables are used to implement the business logic to provide the solutions.

Used SQL Loader, External tables and UTL_FILE to load the data to Database tables.

Project # 2

Client : SANSAR

Location : Mongolia

Team : 3

Duration : May 2013 – Nov 2013

Environment : Windows 2012, Oracle11g

Domain : Pay TV

SANSAR is the biggest analog and digital cable television operator in Mongolia. Sansar has association with Nagravision and Ddish in broadcasting the TV channels to the retailers and end subscribers.

Project # 3

Client : Rackspace

Location : USA

Team : 3

Duration : Sep 2012 – April 2013

Environment : Windows 2008, Oracle10g.

Domain : BRM

Rackspace is the open cloud company, which offers Hosting services and their maintenance across the globe. They offer customized server configurations, fully managed enterprise technologies, advanced server monitoring through Managed, Cloud and Hybrid hosting.

Project # 4

Client : Velocity Networks Pvt Ltd

Location : Madhapur, Hyderabad

Team : 2

Duration : Dec-2011 – Aug-2012.

Environment : Windows 2008, Oracle10g.

Domain : ISP, VOIP, VOICE

Velocity Networks is a fast growing ISP and VOIP service provider in Hyderabad. It offers TV channel, Internet service and VOIP services through a dedicated optical fiber line for individuals and business organizations of all sizes.

Project # 5

Client : Bharti Teleport (Airtel)

Location : New Delhi

Team : 3

Duration : Jan -2011 – Nov-2011

Environment : Windows 2008, Oracle10g.

Domain : Pay TV

Bharti Teleport is the wing of Bharti Airtel India's biggest telecom operator. Bharti teleport offers service by up-linking of TV channels content to Satellite from its centre in Noida. It's the permanent satellite uplink infrastructure through which broadcasters beam their channels to satellites for transmission.

Responsibilities:

Responsible for gathering the requirements for customizations requested by the clients.

Tested and delivered the custom works to clients.

Had done the Data mapping and porting.

Developed Specific customizations using Oracle/SQL/PLSQL.

Developed PL/SQL Stored Procedures, Functions, Triggers and created packages to access the database from front end screens.

Responsible for taking DB backup

Responsible to install the patch releases and the product upgrades.

Developed the reports using Crystal Reports.

Done the Payment Gateway and SMS integration

Had worked on modules like Inventory management, Provisioning, Billing and Order

Developed simple and complex reports using Business Objects Crystal Reports for financial analysis, reconciliation, etc. as per client's requirement.

Training Co-ordination, Preparation of training materials, End user training.

Achievements:

Received Make IT Happen award for the development of automation process to validate the Config files and Databases.

Received Team Excellence award for the improvement of Quality in deliverables.

Received STAR award for the outstanding performance and consistency.

PERSONAL SKILLS:

Highly Motivated, Ambitious, Good Communication and Organizational skills and Enthusiastic to work on a large scale enterprise applications.

Passionate about the technology and dynamic in nature to learn new things on the fly. Enthusiastic to stretch beyond in achieving the goals. Needless to say about the dynamic leadership qualities and commitment. Team spirit & enthusiasm are the two driven spirits that keeps me move on.

PERSONAL DETAILS:

Father’s Name : Sundara Raju. L

Date of Birth : 14-04-1984

Sex : Male

Address : Saipurna Residency, Flat No. G2

D. No: 1-8-506/21

Prakash Nagar, Begumpet, Hyderabad-500016.

Marital Status : Married

Languages Known : Telugu, English and Hindi.

DECLARATION:

I hereby declare that above details furnished are true to the best of my knowledge belief.

Place: Hyderabad

Date: ( Josaf Kiran B .L)

Contact this candidate