Oracle PL/SQL Developer
Resume:
Obj***
KEERTHANA
Email: *********.**********@*****.***
Cell: 607-***-****
SUMMARY:
6+ years of experience in designing and building custom applications using Oracle databases in UNIX and
•
Windows environments.
Expertise as an Oracle Developer and experience with SQL, PL/SQL, Open Interfaces and APIs.
•
In-depth knowledge of PL/SQL with the experience in constructing the procedures, functions, triggers, cursors,
•
table collections, user defined data type etc.
Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Study, high
•
level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project
Planning.
Performed Key Role in Logical and Physical Database design and development, Normalization and Data modeling
•
for multidimensional cubes using Erwin and SQL Server Enterprise manager.
Expert in ETL, Data warehousing, Operations Data Store concepts, Data Marts and OLAP technologies.
•
Experienced in ETL processes, Data warehousing methodologies and concepts including star schemas, snowflake
•
schemas, dimensional modeling and reporting tools, Operations Data Store concepts, Data Marts and OLAP
technologies.
Expert in using Oracle Export/Import, SQL*Loader and data pump utilities.
•
Extensive experience in identifying performance issues, debugging and performance tuning using SQL Trace,
•
Explain plan, Indexing, Hints, Partitioning.
Proficient in Oracle 11g/10g/9i PL/SQL back end applications Development Toad, SQL Plus, PL/SQL Developer,
•
UNIX, Perl and working knowledge of UNIX editors, Debuggers.
Hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration,
•
Conversions, and Process Documentation and robust knowledge in STAR Schema, Snow Flake Schema, FACT
Tables and Dimension Tables.
Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types,
•
Dynamic SQL and Analytical Functions.
Thoroughly worked on ETL process consisting of data transformation, data sourcing, mapping, conversion,
•
migration and loading into OLAP systems.
Very good experience with shell scripting for creating UNIX processes, running background processes and
•
scheduling Autosys jobs.
Strong knowledge of different Database management and Database administration activities.
•
Extensive experience in developing applications using UNIX shell scripts and Perl scripts.
•
Very good academic and practical knowledge in JAVA programming language (object oriented programming).
•
EDUCATIONAL QUALIFICATIONS:
Bachelors in Computer Science, JNTU, Hyderabad, India.
Certification:
Oracle 11g Advanced PL/SQL Developer Certified Associate.
Technical Skills:
Database Tools SQL Developer 2.0, Toad 9.0, SQL*Plus, SQL*loader, Erwin
Data Modeling Dimensional Data Modeling -Star, Snowflake Modeling, Erwin.
Data Analysis Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table,
Business Rules, data modeling, Data Warehousing, system integration, and team building.
Databases Oracle 11g/10g/9i, IBM DB2 UDB 8.0/7.0, MS SQL Server 2000.
Environment Windows Xp, Red Hat Linux, Unix, Sun Solaris.
Programming PL/SQL, SQL, UNIX Shell Scripting, Perl Scripting, Java
Languages
ETL tool ETL,ODI
Professional Experience:
Novartis Pharmaceuticals, NJ Nov 2015 – Till Date
Sr. Oracle PL/SQL Developer
Novartis Pharmaceuticals Corporation wants to migrate “Electronic Claim Processing (ECP)” on new server with
configurations - Oracle 11.2.0.4 and Linux operating system. As part of this migration program, ECP application would
be migrated from UNIX server AIX 6.1 with Oracle 11.2.0.1.0 to Linux 6 with Oracle 11.2.0.4.0.
Responsibilities:
• Responsible in Validating all the Privileges and Roles, Users, Parameters of the new DEV database against
the existing production database.
• Responsible in validating all the objects, Users, Parameters of the new DEV database against the existing
production database.
• Validating the UNIX components including directory structure, file systems, shell scripts from existing
production UNIX server to new Linux 6.
• Modified Shell scripts to execute using the database parameters defined in .bash profile.
• Performed Job runs using ControlM to support testing in the new environments.
• Repointing Cognos Reports to new environment. Update Cognos environment and change DSN
pointer/password and ensure the reports are working without any issues.
• Developed processes to manage daily workflow of information by communicating, redesigning, and
establishing follow up techniques to prioritize tasks.
Environnent: SQL*Plus, PL/SQL Developer, Oracle 11g, SQL, L I N UX, UN IX, ControlM,
Perl.
I ES ( Integrated Eligibility System), MA Jun 2014-
Oct 2014
Sr. Oracle PL/SQL Developer
The Department of Transitional Assistance (DTA) is implementing business process changes for the Application,
Recertification and Maintenance of cash and SNAP cases. The primary change involves developing a statewide “First
Available Worker" (FAW) model that is client-centric and flexible enough to respond to increases in case volume. The
FAW model will be incorporated into the DTA eligibility system known as BEACON and will exist alongside the current
caseload assignment model. The secondary business process changes will be to integrate the BEACON system with
the Electronic Document Management (EDM) system and the Interactive Voice Response (IVR) system. The IVR
system will also be enhanced to support the FAW model.
Responsibilities:
• Responsible for gathering requirements from users for reports development and interface program
customizations and in analyzing business process.
• Created and maintained Oracle Database Objects like tables, views, materialized views, indexes, constraints,
sequence, synonyms and database link using SQL.
• Created numerous complex queries involving joins, correlated sub-queries, and nested sub-queries diverse
business requirements.
• Reorganized databases and sized database objects to meet standards and improved performance by 30%.
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records,
Types, Dynamic SQL and Analytical Functions.
• Created packages, stored p rocedures, t riggers and functions using SQL developer.
• Involved in writing the database t riggers to furnish the audit details.
• Managed the Metadata associated with the ETL processes used it to populate the Data Warehouse.
• Worked extensively on Object groups for maintaining consistency throughout the Proposals module.
• Modified and developed new features and functionality for the existing application.
• Used Oracle features like Global Temporary tables, Analytical functions and Table functions.
• Monitoring and tuning the applications using Indexes, Explain Plan, Hints, Tkprof.
• Performed SQL performance tuning for various PL/SQL packages.
• Closely worked with functional team and users in resolving the issues.
• Worked with the production support team in resolving tickets.
•
E nvironment: SQL*Plus, SQL Developer, Toad 11, Oracle 10g/11g, Sun Solaris UN IX.
Oct
D TCC (Depository T rust & Clearing Corporation), FL
2013 – May 2014
Sr. Oracle PL/SQL Developer
The project is aimed to create and maintain a central data repository of DTCC. The repository holds all the transactions
details between two financial organizations which registered for the service. The transactions are the stock exchanges
which are made between the clients. All the transactions and the life cycle events are accepted and validated according
to the norms and stored in the repository. Periodical reports are generated and sent to both the clients and also to the
concerned government officials. Ad-Hoc reports are also available to the clients.
Responsibilities:
• Gathering the functional requirements from users and converting them into Technical requirements to get sign-
off by architect before the execution.
• Created logical, physical data models, and built data marts in the data warehouse.
• Analyzed data quality, worked in conjunction with the data warehouse architect on the development of logical
data models.
• Managed the Metadata associated with the ETL processes used it to populate the Data Warehouse.
• Analyzing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning,
explain Plan.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF.
• Created and maintained Oracle Database Objects like tables, views, materialized views, indexes, constraints,
sequence, synonyms and database link using SQL.
• Designing and modifying of Database tables, keys, indexes, triggers, packages, functions and stored
procedures etc.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Developed Database Triggers for the integrity and security purpose.
• Participation in reviewing code and ensuring testing, facilitate code delivery to production environments.
• Knowledge on system configuration for the database PL/SQL applications.
• Actively involved with DBA for deployment of objects to production environment.
• Reorganized databases and sized database objects to meet standards and improved performance by 30%.
• Used SQL*Loader to load flat files and created log tables containing data with discrepancies.
• Performed data analysis and generated reports for the senior management for their use in taking strategic
decisions.
• Developed automated notification of Emails, using UNIX shell script, to the users in case of failure in the
process from time to time.
Environment: SQL*Plus, SQL Developer, Toad 11, Oracle 11g, Sun Solaris UNIX, SQL* Loader, SQL server.
TATA CONSULTANCY SERVICES, India Jan 2011 – Jan 2012
Oracle PL/SQL Developer
Tata Consultancy Services Limited (TCS) is an India-based information technology (IT) company. The Company offers a
range of IT services, outsourcing and business solutions. TCS’ segments include banking, financial services and
insurance; manufacturing; retail and distribution, and telecom. It operates mainly in the Americas, Europe and India. We
are a leader in the global marketplace and among the top 10 technology firms in the world. Our continued rapid growth
is a testament to the certainty our clients experience every day. Building on more than 40 years of experience, we add
real value to global organizations through domain expertise plus solutions with proven success in the field and world-
class service. It’s how we keep you moving forward.
Project Description: WAP Online Recharge:
WAP Application enables the customer to recharge their mobile number from the TATA DoCoMo WAP Page for Prepaid
customers. This is achieved by replicating the current implementation web module for online recharges. A WAP links to
the sales executive which enables them to view the details of all the plans for the given circle. This enables the sales
executive to be updated with latest plans. An option has to be provided in the admin portal through which the admin
would be able to update the list of plans
Responsibilities:
• Involved in developing detailed designs based on business and system requirements.
• Created low level database designs necessary to fulfill the request within existing system constraint.
• Created Database and Application level Triggers, Stored procedures, Sequences, Views and Synonyms.
• Designed and implemented batch processes with PL/SQL and optimized the existing PL/SQL packages for
faster retrieval, transactions and updates of online and bulk processes.
• Assisted in design of tables, databases, in Oracle and other applications.
• Analyze the database schemas involved and develop approach for accessing and updating data as required.
• Choose best fit technology and solutions to meet requirements.
• Performed detailed code review of all the requirements of the peers to ensure normal implementation.
• Maintained and enforced coding standards.
• Extensively used logical modeling and physical modeling to create database objects like table’s relations, and
PL/SQL & data process flows.
• Involved in coordination between development teams, business analysts, QA, internal stakeholders, vendors
and the Production support organization.
• Worked on SQL Tuning, Query Optimization Techniques for complex SQL Statements.
• Design of User Interface form for reports to provide user with a selection criteria, and built Triggers to handle
various parameters of the Interface form in Reports.
• Involved in developing logical and physical database using Erwin, Normalization, Dimension Modeling and
Enterprise Manager.
• Used Oracle features like Global Temporary tables, Analytical functions, and Table functions.
• Wrote UNIX shell scripts to invoke all the stored procedures, parse the data and load into flat files.
Environment: SQL*Plus, SQL Developer, Oracle 11g, Sun Solaris UNIX, Erwin, SQL* Loader, Toad, SQL Server
TATA CONSULTANCY SERVICES, India Jun 2009 - Dec 2010
Oracle PL/SQL Developer
Tata Consultancy Services Limited (TCS) is an India-based information technology (IT) company. The Company offers a
range of IT services, outsourcing and business solutions. TCS’ segments include banking, financial services and
insurance; manufacturing; retail and distribution, and telecom. It operates mainly in the Americas, Europe and India. We
are a leader in the global marketplace and among the top 10 technology firms in the world. Our continued rapid growth
is a testament to the certainty our clients experience every day. Building on more than 40 years of experience, we add
real value to global organizations through domain expertise plus solutions with proven success in the field and world-
class service. It’s how we keep you moving forward.
Project Description: VIBE (Voice for Better Experience) is based on PIM2R(Packet Interactive Multimedia response) a
TCS Patent-pending Technology, and provides mobile users with Complete Self Care Audio & Text menus on their
mobile, making it more intuitive and user friendly. The platform provides the flexibility of plug-n-play features and the
development turnaround time is very minimal to meet the market demand. Various Entertainment and Information
related VAS can be build using VIBE Framework and First Application in line is VCare.
VCare: The world’s first Voice, Text & SMS based self-help application launched for Virgin Mobiles India. It is a self-care
application developed on VIBE Platform to replace the IVR System. VCare gives customers access to services like
balance check, offers, VAS, games, CRBT activation, etc through a 24x7 interactive portal. This helps customers to get
a quick answer to their query. Also, this is a big cost saving to the company as VCare has been equipped to handle
most of the queries from customers directly and would lead to a reduction in the number of calls to the contact center.
Responsibilities:
• Develop SQL scripts, indexes, and complex queries.
• Perform quality assurance and testing of SQL server environment.
• Created tables, views, indexes, functions for databases.
• Writing UNIX Shell Scripts to automate load process, Scheduling batch jobs in Crontab.
• Data conversions and data loads from various databases and file structures.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Worked on SQL Tuning, Query Optimization Techniques for complex SQL Statements.
• Partition of tables to improve performance.
• Designed and created new tables which are being used in the new forms and batch programs.
• Converted data from various excel and access files using SQL*Loader and PL/SQL scripts and extensively
fine-tuned SQL queries written in procedures/functions at the back end.
• Writing UNIX Shell Scripts to automate load process, Scheduling batch jobs in Crontab.
Environment: SQL*Plus, SQL Developer, Oracle 10g, Sun Solaris UNIX, SQL* Loader
TATA CONSULTANCY SERVICES, India Aug 2008 – May 2009
Oracle PL/SQL Developer
V M I SmartPay
Project:
Tata Consultancy Services Limited (TCS) is an India-based information technology (IT) company. The Company offers a
range of IT services, outsourcing and business solutions. TCS’ segments include banking, financial services and
insurance; manufacturing; retail and distribution, and telecom. It operates mainly in the Americas, Europe and India
Responsibilities:
• Worked on analyzing the systems and gathering of requirements.
• Documented business requirements and translated them into system solutions and developed implementation
plan and schedule design changes.
• Implemented Data Warehousing-Star Schema Design.
• Developed stored procedures and packages using PL/SQL to check differences between Source and Target.
• Analyze the database schemas involved and develop approach for accessing and updating data as required.
• Designed and developed automated scripts to reduce manual support work and thus saving resources time
and effort.
• Involved in designing and development of data warehouse environment.
• Involved in implementing star schema for the data warehouse for Logical/Physical Data Modeling and
Dimensional Data Modeling.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database.
Environment: SQL*Loader, Oracle, UNIX, Windows XP, SQL Developer, SQL* Plus, Toad.
MICROGENESIS TECHSOFT PVT LTD, India Nov 2007 – July 2008
Oracle PL/SQL Developer
MicroGenesis TechSoft was set up in 2000 as part of MicroGenesis expansion strategy to address the burgeoning
needs of software development in the IT Industry. In its quest constantly look for niche technology solutions which can
possibly address different business needs of customers in IT with advent of time.
• Created and maintained Oracle Database Objects like tables, views, materialized views, indexes, constraints,
sequence, synonyms and database link using SQL.
• Plan, design, and implement application database code objects, such as stored procedures and views,
indexes.
• Direct interaction with users and helped in the development of functional specifications.
• Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table
partitioning.
Environment: SQL Developer, SQL* Plus, Toad, UNIX.
Contact this candidate