JYOTSANA RAWAT

Senior Data Warehouse Developer

Mobile: +91-963******* E-Mail: ac5cow@r.postjobfree.com PROFESSIONAL SUMMARY

Qualified B-Tech with 5 years 5 months of experience as Senior Software Developer with Primary Skills: Oracle Pl-SQL Programming, OBIEE Reporting, Oracle Data Integrator

(ODI)-ELT tool and UNIX Shell Scripting.

Currently associated with British Telecom. Bangalore as Analyst/Professional.

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support.

Coded SQL/PL-SQL, SQL* Loader and Unix Shell scripts for high volume data warehouse instances.

Well versed in OBIEE RPD modelling, reporting, dashboards, etc.

Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.

Team player with excellent communication and problem solving skills. EXPERIENCE

Currently associated with British Telecom India Pvt. LT as Analyst from 20th Jan 2016 till date

Previously associated with Accenture Services Pvt. Ltd. As Software Engineering Analyst from 6thFeb, 2013 to 18thJan, 2016.

TECHNICAL SKILLS

ETL: Oracle Data Integrator, SQL Loader.

BI: OBIEE 11g, 12c.

RDBMS: Oracle 10g, 11g, 12c, MS Access 2000, SQL Server 2000

Languages: SQL, PL/SQL, UNIX shell scripting

Web: HTML

OS: Windows, Unix

Database Tools: SQL Loader, TOAD

Other tools: Putty, WinSCP, Filezilla, etc

ACADEMIC QUALIFICATION

Bachelors’ of Engineering in Electronics and Communication (2008-2012) from Govind Ballabh Pant Engineering College Pauri Garhwal, Uttarakhand with aggregate 74%

12th (2006-2007) from Sri Guru Ram Rai Public School Kotdwara, Uttarakhand with 82%. 10th (2001-2004) from Sri Guru Ram Rai Public School Kotdwara, Uttarakhand with 78%. PROFESSIONAL EXPERIENCE

Project 1: British Telecom Projects (telecom domain) Role: Component Designer and Developer

DESCRIPTION:

Design and development and Component testing in agile model.

Focuses on :

Application Design and Development

Feasibility check and estimations of requirements.

Fixing defects/ fulfilling Support requests in production environment.

Technical Background: Oracle Pl- SQL/SQL, OBIEE, UNIX Shell Scripting, Oracle Data Integrator (ODI).

Project 2: Hong Kong based Insurance Project (Financial domain) Role: Support and Maintenance/Software Developer

DESCRIPTION:

The Insurance Project has application development, support and maintenance Of different production applications and it is aimed to fulfill client expectations, Queries and satisfaction. Applications Based on multiple technologies including Oracle, JAVA, Siebel, etc.

Focuses on:

Application development

Support and Management / Incident Resolution

Technical Background: Oracle Pl- SQL, Unix Shell Scripting, Obiee Reporting Additional knowledge on: MQ, LDAP, WebLogic Administration, ftp or sftp, Siebel.

EXTRACURRICULAR ACTIVITIES

Won Winner and runner up trophies in badminton tournament at school and university level.

Represented state university in national level tournament of badminton in North zone held in Jalandhar.

Won Winner and Runner up in British telecom Badminton Tournament. AWARDS AND APPRECIATIONS

Secured 80%ile in elitmus PH test.

Received Client Appreciations and reward/performance Points from Lead and Project managers.

Received Monetary awards for providing effective deliverables : Voice of Customer Award

Instant Karma award

Star of the month Award

PERSONAL DETAILS

Name :Jyotsana Rawat

Date of Birth :10-Mar-1991

Languages Known :English, Hindi

Contact NO :+91 –963-***-****

Email Address :ac5cow@r.postjobfree.com

Permanent address :New Colony Balasour, Kotdwara, Pauri Garhwal Uttarakhand

DECLARATION

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars. Place: Bangalore Jyotsana Rawat

Contact this candidate