Obj***

KEERTHANA

Email: aco057@r.postjobfree.com

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