Sr. Oracle PL SQL Developer

Mansi Jain

Sunnyvale, CA-*****

Mobile: +1-408-***-****; Mail-ID: *****.***@*****.***

Seeking challenges in Data Engineering/Development with Oracle PL/SQL, Unix Shell programming, Java and NoSQL Data Technologies

Oracle Database Developer (RDBMS/NoSql)

A Graduate Technocrat (B Tech) with TCS Ltd, as well as a dynamic IT Professional, having over 7.5 years of rich and insightful experience, including more than 1 year of On-site working in International (USA) environment, involved in hard-core technical work using Database Technologies for both Development & production environment.

Functional Proficiencies

More than 7.5 years of Experience in Oracle PL/SQL and Unix Shell Scripting.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Expertise in writing complex Oracle Packages/Procedures/Function.

Experience in Oracle & Cron Job Schedulers.

Well versed with Java Object Oriented Programming.

Hands on Experience with Performance Tuning for Oracle RDBMS.

Worked on ETL processes consisting of data extraction, data mapping, transformations and loading. Comprehensive knowledge and experience in process improvement, data extraction, data cleansing, data manipulation.

Experience on Data reconciliation during incremental data loading.

Practical understanding of the Data modeling concepts like Physical and Logical Data modelling.

Implementation of Automation at Enterprise level for Oracle Databases.

Good Experience of handling client expectations including direct interactions, delivering resolutions to business impacting technical/non technical issues.

Adaptable to new technologies, a fast learner having good communication skills and a team player.

Cohesive Team Player with Fast Learning Curve along with strong analytical, problem solving, innovation, planning, organizational, communication & interpersonal skills

Persuing Edureka training for “Mastering Data Warehousing and Business Intelligence” involving DW Architecture, Data Modeling, ERwin, ETL fundamentals, Business Reporting and Data Visualisation

Technical Skills

Operating Systems: Windows, MacOS, UNIX (AIX, Solaris, Linux)

Languages: Java, SQL, PL/SQL

Scripting: UNIX Shell, Python, JQuery

Databases: Oracle 10g/11g/12c, Mongo Db, Vertica

Development Tools: PL/SQL developer Adobe Designer, Netvault.

Frontend Technologies: Oracle Apex, JQuery

Training

Trained on Oracle Performance Tuning.

Trained on Mongo DB Admin from Mongo University

Persuing Edureka training for “Mastering Data Warehousing and Business Intelligence” involving DW Architecture, Data Modeling, ERwin, ETL fundamentals, Business Reporting and Data Visualisation

Initial Learning Program (ILP) from Trivandrum. Main Areas covered UNIX with C++ and Oracle.

PROJECT SUMMARY OF MANSI JAIN

1.0

Employer

TATA CONSULTANCY SERVICES

Project

Apple DBA Support

Client

Apple Inc.

Location

Gurgaon,India (Dec’2012- Nov’2014)/ Sunnyvale, California(Dec’2014-Till Date)

Duration

Dec 2012 – Till date

Details

Apple Inc. is a pioneer in state of art products such as iPods, iPhones, iPads, Macs and Macintosh operating systems. Apple has employed a mixed model consisting of Apple & TCS engineers to support its global business intelligence. Apple has a multitude of major, large-scale production systems running mission-critical applications on several databases. DBA support staff is responsible to provide DBA Support needs for these application and administration of systems. TCS consultants are already providing the requisite services with onsite/offshore model at present. The primary objective of this initiative is to provide Systems Engineering /Database Support

Role

Database Developer

Responsibilities

Responsible for development of Scripted Automation tools using UNIX shell scripting leading to overall Service Improvements.

Responsible for development of Scripted Automations using Oracle Stored Procedures & Korn Scripting that contributes to standardization of dba operations, increases safety and leads to reduction of database related tickets escalated to dba team.

Responsible for development of replication conflict handlers (Using PL/SQL) with customized business rules in Active-Active Oracle Databases having Bidirectional data flow setup using replication technologies (Streams & Golden gate).

Developing GUI based Infrastruture Topology Diagram Generation Tool using front end Jquery and PHP & Mongo database as back end. This diagram will allow the user to get a topological view of technology artifacts of any given application in Apple IS&T.

Development of database health check automations leading to auto discovery of health issues in databases in timely manner.

Development of an automatic scripted Database Forecasting utility to forecast the amount of space needed to be added to a database at the tablespace and Filesystem level including auto generation of scripts to enable space addition. This utility aims to eliminate/reduce the tablespace and Filesystem related incidents at the complete enterprise level.

Development of a utility for Encryption of Critical Database login information such as passwords stored in customized configuration databases.

Developing utilities, which auto, monitors and alerts in the form of reports which highlights actions required in future to prevent any issues in the databases.

Development of GUI representation of database related information in the form of reports and graphs.

Performance Tuning for sql queries in Oracle RDBMS using tools such Execution plans, tkprofs and Active session history reports, indexing, stats gather.

Comfortable writing complex SQL queries with joins, date functions, inline functions, sub-queries, Exception handling, Views and Ref Cursors

Development of Complex database objects like Stored Procedures, Functions, and Packages and Triggers using SQL and PL/SQL.

2.)

Employer

TATA CONSULTANCY SERVICES

Project

PASSPORT SEVA PROGRAM

Client

Ministry of External Affairs, New Delhi, India

Location

Deputation at Client location – Ministry of External Affairs, New Delhi, India

Duration

Apr’09 – Nov’11

Passport issuance is a function of MEA, which is responsible for making it accessible to the citizens of India. Looking at the socio-economic trends, the demand is expected to rise even further and the citizens are demanding greater transparency, predictability, and efficiency from the Regional Passport Offices (RPOs). It is with this background that the PSP has been initiated. To deliver all Passport-related services to the citizens in a timely, transparent, more accessible, reliable manner & in a comfortable environment through streamlined processes and committed, trained & motivated workforce.

As part of executing PSP, TCS has performed the data migration from the existing systems (referred to as Central Database of NIC involving millions of data) to the database implemented for Passport Seva Project (PSP).

Role

Oracle Developer

Responsibilities

Responsible for development of Oracle PL/SQL procedures for data migration strategy

Responsible for Automation of operation using Korn Shell Scripting

Developed Java programs for the loading of media into Oracle databases and CAS Storage devices.

Involved in the development of ETL processes such as data transformations, data sourcing, mapping, conversion and loading.

Responsible for creation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plan for loading the data successfully into the targets.

Excellent proficiency in Data Transformations and loading using Export, Import and SQL Loader and External tables.

Responsible for Migration of NIC (National Information Centers, India) legacy passport data to New environment (ORACLE-DB2)

Developed Complex PL/SQL Data transformation Tool for data mapping and transformation of the legacy data.

Automation of data migration process using UNIX shell scripting.

Involved in Data Extraction and Data backup.

Working on Database Security like Encryption of Critical Database login information

Worked on creation of scripted Automations for DBA operations to help in minimizing manual effort and for standardization of processes.

Development of a utility in java to load the passport related media into database.

Involved in Data Reconciliation of NIC data.

Development of Data Quality Reporting.

3.)

Project

MCA21

Client

Ministry of Company Affairs, New Delhi, India

Location

Noida

Duration

Oct’08 – Mar’09

Details

MCA-21, India's largest e-governance initiative by the Ministry of Company Affairs provides stakeholders easy and secure access to MCA services, any time and from any place and in a manner that best suited for the user. Downloading & filing forms, making payments, obtaining information about transactions, lodging investor complaints and a slew of other services are facilitate by this portal.The MCA21 Backoffice portal involves automated workflows,Document management, forms processing mechanisms and role based access control and other user maintenance functions. Project involves Adobe Designer, J2EE architecture and Struts framework.

Role

Developer

Responsibilities

Responsible for development of forms in Adobe Designer.

Worked on validation of the forms layout.

Involved in Forms Validation

Education

B. E. (Electronics & Communication), from Delhi College of Engineering (Delhi Technological University) (May-2008), India

Accreditations

Awarded with “On the Spot Award” on many occasions.

Awarded with “Star of The Month” for successful completion of STQC audit for data migration.

Received Client Appreciations for many Service Improvement Programs (SIPs) related to Automations in Database Engineering (RDBMS)

Domain certification in eGovernance.

Contact this candidate