Sr SAS Developer & Analyst

RABINARAYANA PANDA

MOB-767-***-****

*********@*****.***

Passport No.J3704842

RABINARAYANA PANDA

SYNOPSIS

Over 1.5 Years of Experience in PL-SQL DEVELOPER.

Believe in developing innovative and ingenious computing solutions and have critical thinking and keen observation for technical and business perspectives.

Competent technical as well as management Skills.

Flexible & Adaptive nature to any environment.

Strong logical, Analytical skills help to take on new challenges & win over them.

1. Professional Profile

Employer NETCENTRIC INFORMATICS PVT LTD,BANGALORE

www.netcentricinformatics.com

Title PL-SQL Developer

Date Of Employment 4th Jan 2010 to till date

Project Information

Organization : Tyco Electronics Corporation, India PVT. Ltd.

Project Name : Tyco Electronics Data Warehouse(TED).

Duration : From 18TH MAY 2010 to till date.

Environment : UNIX (HP), Oracle 9i,10g.

Skill/Tools : SQL, PL/SQL, UNIX, Informatica,PLSQL Developer,Toad

This is a data warehouse which contains all the information related to Tyco products from manufacturing to shipment information.

• TED is a collection of enterprise wide data into a single database

• TED consists of various applications which collect, cleanse and store data from TE companies all around the world

• TED currently has subject areas available such as Sales, Finance, Purchasing, Inventory, Quality,… for daily, weekly & monthly reporting

• TED info is available thru « data marts », which offer

– efficient reporting performance

– data mart refresh within target time window

– reporting for specific business area, function or region

TED is used for the following purpose:

• Global BU Reporting

• Cross Functional Reporting

• Managed Standard Reporting

• Historical Reporting

• Analytical Reporting

• Master Data

Roles and responsibilities:

1 To Extract data from different source system and load it to the database after cleaning or validating by writing stored procedures and functions.

2 Preparing various reports for the need of enterprise data management team using SQL script.

2. Project Information

Project Zensar Retail management System - ZRMS

Employer NETCENTRIC INFORMATICS PVT LTD.

Type Application Support, Maintenance and user training, Developer

Role Production Support Engineer

Technology/Software Oracle9i, 10g, Developer 6i (D2K), Oracle Forms, Oracle Reports,

SQL, PL/SQL, TOAD, SQL Loader,

Solaris 9&10, IBM Aix, Windows 2000/NT

Duration 4th Jan 2010 to 14th May 2010.

Client Max Hypermarkets India Pvt. Ltd.

(Spar Hypermarkets, Bangalore, Hyderabad)

Landmark Group of Companies

http://www.cplmg.com/our-brands/affiliatesothers/india/spar- hypermarkets/24/33/1/index.hml

Zensar Retail Management Solution (ZRMS), a product of Zensar Technologies (http://www.zensar.com/retail/zrms), provides a complete solution for retail business .ZRMS offers a complete store automation solution for large and mid sized retailers in India. ZRMS is able to streamline point-of-sale (POS), customer service and store inventory management, and providing real time access to key business metrics. It is a comprehensive solution for single store and multiple stores retailers alike and empowers independent and emerging proprietors on one end and managers and heads of established retailers on the other.

Roles & Responsibilities:

• Master Data Upload (Both Product & SLL) .

• Handling Master Database of ZRMS .

• Development of SQL & PL/SQL code

• Developing adhoc reports for business users using Report Builder 6i.

• Analyzing and resolving issues (ZRMS)

• Creating MIS Reports using Oracle Reports

• Data Transfer in All Location in Day Time.

• Application maintenance and support (ZRMS) at HO and all locations through media.

EDUCATIONAL QUALIFICATION :

• Passed MCA(Master in Computer Application) with 8.2 CGPA from CV Raman Computer Academy, Bhubaneswar under BIJU PATNAIK UNIVERSITY OF TECHNOLOGY, ROURKELA, ORISSA IN 2010.

PERSONAL DOSSIER:

Address : Rabinarayana Panda

#294/3A,Oph Road,Kadugudi

P.o.: Kadugudi Bangalore-67

Date of Birth : 7th July 1987

Sex : Male

Language Known : English, Hindi, Oriya

I hereby declare that the above information and particulars are true & correct to the best of my personal knowledge and belief.

Place: BANGALORE (Rabinarayana panda)

Contact this candidate