CHITTRANSH PAGARIA
91-797******* ************@*****.***
Objective:
To work in a creative and challenging environment to accomplish great heights and strive hard to learn new developments where I could constantly learn and enhance my ability and knowledge to deliver successful solution to all problems.
Career Glimpse:
Almost 4 years of experience as a Software Engineer.
Experience of working with PLSQL, SQL and Unix development for more than 3.5 years.
Knowledge on SQL and PL/SQL concepts.
Able to assess business rules, understand problem statement and system requirements, collaborate with stakeholders and provide technical solution for the same.
Providing IVVT support for E2E testing team queries.
Providing Automated Deployment Scripts of Deliverables to ensure smooth deployment without much Manual efforts.
Knowledge of packages,procedures,cursors,functions,bulk collect etc.
Career Contour:
Achievements, Training & Accolades
Received “Pat on the Back Award” for deliveries with minimum CST and Zero IVVT defects.
Received “Bravo Award” within 3 months after joining project for quick learning quality.
45 days training from Oil and Natural Gas Corporation Limited (ONGC), Cambay Sub Asset, Ahmedabad.
Work Experience:
Software Engineer at Tech-Mahindra from August 2016 to Till Date
First :-
Project Name : ARTISAN
Role : Software Engineer
Responsibility : Oracle/ UNIX Developer
Client : British Telecom, UK
ARTISAN is inventory system for all the poles in British Telecom network,it takes care of all the register faults related to pole .Feeds related to faults send to different components which then send the data to planners for fault resolution.
Second :-
Project Name : ADLI-Goldmine
Role : Software Engineer
Responsibility : Oracle/ UNIX Developer
Client : British Telecom, UK
Goldmine comprises of multiple systems like LODE and ONCE. LODE system does speed calculation based on line loss and network route details it gets from performance monitoring systems. Based on complex algorithms it then calculates the target speeds the end user is eligible for. LODE also fetches and collates data from inventory systems to determine network capacity and details. All above data is then exposed to ONCE which is a flat record based system used for high volume of on demand hits from the enterprise service bus to fetch data in real time and in few seconds for exposing dialogue services to Openreach Communication Providers. ONCE provides data to down-stream components about FTTC,FTTP and Ethernet network.
TASK ACCOMPLISHED:
Experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
Created Tables, Views, Constraints, Index.
Developed Complex database objects like Stored Procedures, Functions, Packages.
Loaded Data into Oracle Tables using SQL Loader.
Partitioned large Tables using range partition technique.
Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions.
Training new team members about telecom domain and project KT’s.
Created release documents.
Technical Skills:
Language: SQL, PL-SQL, Unix.
Tools: SQL Developer,File-Zilla,Excel.
Database: Oracle-11g.
Version Control: SVN
Academic Records:
Year
Qualification
Institute
Percentage
2016
B.Tech (Electronics and communication Engineering)
Arya College of Engineering & I.T. (RTU)
70.10 (agg.)
2012
Class XII, CBSE
St. Paul’s Sr. Sec. School, Udaipur
78.3
2010
Class X, CBSE
Seedling Modern Public School, Udaipur
8.8 CGPA
Personal Profile:
Strengths: Quick Learner, Good Communication Skills, Leadership Qualities, Responsible
Languages: English, Hindi
Date of Birth: 15 November 1994
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.
CHITTRANSH PAGARIA