JYOTSANA RAWAT
Senior Data Warehouse Developer
Mobile: +91-963******* E-Mail: ********.*******@*****.*** 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 :*******.*******@*****.***
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