Kalyan Pallati

Oracle Developer at Cognizant Technology Solutions

ab9jny@r.postjobfree.com

Summary

• Over eight years experience as a computer programmer with increasing responsibilities in fast-paced

environments.

• Extensive background gathering requirements, developing, testing, troubleshooting, documenting and

implementing software with experience in relational database design, SQL scripting and tuning, batch scripting,

packages, stored procedures/functions, cursors, triggers, analytical functions, report design, business

intelligence, interface development and optimization/timing analysis.

• Strong knowledge and use of SDLC methodologies, standards, and procedures with experience in promoting

database changes from development through production environments.

• Experience in high availability (24x7) and high throughput transactional systems.

• Experience working in large teams and able to collaborate efficiently.

• Ability to debug, troubleshoot, and solve complex PL/SQL issues, and the ability to reverse engineer existing

PL/SQL code into functional requirements.

• Strong knowledge in advanced concepts like Collections, Object types, Dynamic SQL and Ref Cursors.

• Expert in normalization, database design, data loading, data retrieval and modification.

• Experience with batch processing using Oracle external tables, bulk techniques, bulk collections, bulk

exceptions and partitioning.

• Experience in PLSQL tuning and optimization.

• Experience with data modeling tools such as Erwin and ER/Studio.

• Experience in ETL development, and intermediate use of Informatica.

• Experience working in UNIX environment.

• A good team member with strong technical and analytical skills.

• Excellent written and verbal communication and interpersonal skills.

Specialties

Oracle PL/SQL, Oracle SQL*Plus, PL/SQL Tuning and Optimization, JAVA, XML.

Experience

Oracle Consultant at Cognizant Technology Solutions

January 2012 - Present (1 year 7 months)

• Interacted with the end users to get the clarity on initial requirements as well as the enhancements to the

initial scope.

Page1

• Created Initial creation and modification of schema for enhancements to the application needs.

• Actively involved in the requirements gathering, analysis, development of this system, along with unit

testing and implementation.

• Performed walkthroughs of technical specifications, design and development, documentation and acquiring

sign-off from relevant stakeholders.

• Capture comments/arguments during technical specification walkthrough and document everything

diligently.

• Extensively used PL/SQL to create Stored Procedures, Functions, and Packages.

• Creating the Oracle schema i.e. tables, indexes, constraints, triggers, synonyms, database links, roles etc.

• Involved in Data-Modeling and database design.

• Involved in enhancement of existing Data flow diagrams, ER Diagrams.

• Created simple, complex views and materialized views for better performance and security.

• Reviewing / Testing Procedures & Functions developed by the team members.

• Created Test Data for testing procedures and functions.

• Debugging, editing and testing existing procedures and functions for enhanced functionality.

• Developed UNIX shell scripts to execute batch process, develop and deploy fixes in data.

• Migrated the data from external files into Database tables using SQL *Loader.

• Developed packaged application modules using SQL, PLSQL on Oracle 11g.

• Created test strategies and scripts.

• Developed procedures using Dynamic SQL and built-in packages like UTL_FILE.

• Performance tuning & SQL tuning using Explain Plan, TKPROF.

• Maintained issue logs for the project during system integration and User Acceptance Testing phases.

• Designed and developed database models for the download system.

• Developed batch processing data load and purge scripts.

• Worked closely with JAVA team.

• Worked on documentation and provided on-site production support.

Programmer Analyst at McDonald's Corporation

April 2011 - January 2012 (10 months)

• Developed Procedures & Functions to check validity & integrity of data.

• Created views to extract data from base tables & publish the data to the end users.

• Used Built-in Packages provided by oracle for debugging.

• Reviewed / Tested Procedures & Functions developed by the team members.

• Creating SQL Scripts to monitor the discrepancy database and resolve the discrepancies.

• Developed/Modified Shell scripts to regulate batch jobs.

• Creating test data and load it into database to verify the functionality of procedure & functions.

• Migrated the data from external files into Database tables using SQL *Loader.

• Extensively involved in performance and tuning of all SQL and PL/SQL code.

• Developed Database objects like Views, Materialized Views, Indexes, Sequences, and Synonyms.

• Extensive querying using SQL* Plus / TOAD to monitor quality & integrity of data.

• Created Database Triggers to populate tables for Reference data and Exposure data.

Page2

• Generated SQL Scripts for publishing weekly, monthly and yearly data into Oracle tables.

• Developed strategies to improve the performance of data loading operations.

• Provided maintenance and application support to end user and business groups, resolving tickets.

• Used subversion as a source control tool.

• Performed 24/7 on-call support to resolve production issues in a high availability transactional system.

Programmer Analyst at Wells Fargo

April 2010 - March 2011 (1 year)

1 recommendation available upon request

Programmer Analyst at DePaul University

September 2007 - April 2010 (2 years 8 months)

Software Programmer at Bharat Heavy Electricals Limited

May 2004 - August 2007 (3 years 4 months)

Projects

Global Download Systems

January 2012 to Present

Members:Kalyan Pallati

Global Download System (GDS) is First Data’s all-inclusive Terminal Management System.

It acts as the link between FDCS with an estate of payment terminals and the merchants using them. This

powerful yet flexible solution allows users to manage payment terminals remotely, modify their software

content and interact with merchants, all via an easy-to-use interface.

Restaurant Order Proposal

April 2011 to January 2012

Members:Kalyan Pallati

Mc Donald’s USROP (United States Restaurant Order Proposal) is a multi-dimensional data warehouse

which processes the Mc Donald’s restaurant transactions on a daily basis. It encapsulates the operations of

14000 restaurants, 47 distribution centers spread across the 4 time zones of United States. This application is

used to calculate the amount of raw materials required to replenish each restaurant on a daily basis based on

the daily transaction sales, historical data and marketing intelligence data.

CUSTDW Inclusion/Exclusion Process

April 2010 to March 2011

Members:Kalyan Pallati

CUSTDW IE (Customer Data Warehouse Inclusion Exclusion Application) is a multi-dimensional data

warehouse which processes the Wells Fargo customer information on a daily basis. This application performs

the pre-migration processing for Wachovia Bank customers who are being migrated to the Wells Fargo data

warehouse. This process involves various stages of conversion which define the most appropriate day and

Page3

event a Wachovia customer can be converted to a Wells Fargo customer.

Skills & Expertise

Oracle

SQL

PLSQL

Core Java

C++

Unix

Unix Shell Scripting

Perl Script

Linux

Informatica

SQL Tuning

Data Modeling

XML Databases

XML

PL/SQL

SDLC

Education

DePaul University

MS, Information Systems, 2007 - 2009

Jawaharlal Nehru Technological University

BTech, Electronics and Instrumentation, 2001 - 2005

Interests

Hiking, Tennis, Swimming

Page4

Kalyan Pallati

Oracle Developer at Cognizant Technology Solutions

ab9jny@r.postjobfree.com

1 person has recommended Kalyan

"A very detailed oriented person with a passion to excel by keeping abreast with the latest in technology and

best practices. A true team person whom one would count on in cases of exigencies / system issues that

requires extended monitoring, co-ordination and involved trouble shooting. A real hard working, sincere and

dependable team mate and a real asset to the team."

Nandagopal Raju, Senior Consultant BI, Wells Fargo, managed Kalyan indirectly at Wells Fargo

Contact Kalyan on LinkedIn

Page5

Contact this candidate