T ejasvi Shah

acgogn@r.postjobfree.com

+1-201-***-****

SUM MARY

• 7.5+ years of IT Experience as an Oracle Apps Technical Developer in System Analysis, Design, Testing

Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environment.

• Adept at all stages of project lifecycle, from business requirements and technical definitions to resource

p lanning, code development, testing, user acceptance testing (UAT), production support and completion.

• Expert level skills i n wri ting SQL queries, PL/SQL-packages, stored procedures, pipeline functions,

t r iggers, exception handlers, indexes, views, cursors, synonyms, sequences, PL/SQL records & tables.

• Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, Materialized

V iews, Query Re-Write.

• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and

Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.

• Extensive experience in Application Development using Oracle Forms 10g/6i and Reports 10g/6i in

W indows environment.

• Experienced in working with SQL * Loader, External Tables, Import, Export and data pump utilit ies like

E XPDP/IMPDP.

• Experience in SQL and PL/SQL performance tuning and query optimization tools like SQL Trace,

E xplain Plan, Indexes, H I NTS and DBMS_PROFILER.

• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, Test Plan, and Test

Script & Test Cases.

• Worked on Production Support, conducted and coordinated support calls, t roubleshooting the application

and resolving bugs.

• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact

w ith individuals at all levels.

• Ability to work in teams and independently with minimal supervision to meet deadlines.

TECHN ICAL SKILLS

• ERP Application : O racle Financials Release 11i (11.5.9) / R12, Projects (Costing &

B illing) module, Account Receivables (AR), Account Payables (AP), General ledger (GL)

• Database: O racle 11g/10g/9i.

• Languages/Framework : SQL, PL/SQL, XML, OAF, Unix shell scripts

Page 1 of 5

Resume: Tejasvi Shah

• GU I/Tool: Toad, PL SQL Developer, Oracle SQL Developer (3.0.04), JDeveloper9i(9.0.3) for OA

F ramework, Oracle Workflow Builder, Oracle Forms/Reports Developer 10g/6i, XML Publisher, Putty,

E dit Plus, Control M.

• Configuration Management and versioning Tools : K intana PPM tool for code migration, HP

Quality Center for Defect logging and t racking, Dimension Express tool for code versioning, M icrosoft

VSS 6.0

• Operating System: W indows, UN IX

EDUCAT ION

• Bachelor of Technology (Electronics and Communication) – Jun 2006.

Usha M i t tal Institute of Technology, Mumbai (India)

WORK H ISTORY

Mac Steel I nternational USA Corp., Denver, CO J ul’13 - Present

Oracle PL/SQL Developer

P roject Description: M acsteel service centers USA offers one of the largest inventories of metals in the service

center industry. Macsteel service centers w ith 32 locations throughout North America p rocesses and distributes

carbon, stainless, aluminum and specialty metals to customers throughout North America and Puerto Rico.

T his project is Oracle E-Business Suite Release 12.1.2 implementation focused on Project and financial modules

for various Macsteel division and branches.

T echnical Responsibilities:

• Prepared designed documents based on the Functional need of the clients.

• Designed and developed database packages, procedures, functions and t r iggers in Oracle 10g databases

for new implementations.

• Implementation of Inbound Interface in Oracle E-Business suite to automate the addition of project and

t ask to project manufacturing organization and auto-creation of project contracts. Used seeded APIs of

p roject manufacturing organization and service contracts.

• Created SQL scripts and wri t ten p rocedures to load data from f lat files into new tables (using both UTL

and SQL Loader – for different cases).

• Implemented Inventory Outbound Interface Program to extract the inventory i tem data from base tables

to f lat file using UTL_FILE package.

• Used B ulk Collections for better performance and easy retrieval of data, by reducing context switching

between SQL and PL/SQL engines.

• Handled errors using E xception Handling extensively for the ease of debugging and displaying the error

messages in the application.

• Extensively involved in tuning the queries and applying hints for faster and better performance of the

SQL queries.

• Good knowledge of orchestration tool - BMC Control M used to design jobs, schedule/job ordering of

global batch.

• Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and

delivery Issues.

• Performed the unit testing for the code and migrated the files through K intana tool.

I ngersoll Rand, Charlotte, NC J an’12 to Jun’13

Oracle Developer/Analyst

Project Description: T he S MARTransformation is defined as simple and standard processes through Oracle

R12 that meet the needs of customers to Achieve Results through business Transformation. End-to-end

business performance visibility and optimization will help anticipate customers’ needs. I t will help to provide

smarter solutions, products and services so it becomes easier for customers to do business with IR.

T echnical Responsibilities:

• Experience in developing conversions using Open In terfaces/ AP I (Master Supplier Conversions, Projects

(Project, Task, and Expenditure)) .

• Wrote conversion scripts of legacy data (including validations) using SQL, PL/SQL, stored procedures,

f unctions and packages and then migrate data into Oracle database.

• Wrote sequences for automatic generation of unique keys to support p rimary and foreign key constraints

i n data conversions.

• Developed materialized views for data replication in distributed environments.

• Parti tioned large tables using range parti tion technique.

• Used P ragma Autonomous Transaction to avoid mutating problem in database t r igger.

• Wrote packages to fetch complex data from different tables in remote databases using database links.

• Designed Oracle Master Detail form using O racle Forms 10g, showing all the errors of a change request

and their respective resolution which helped developers to correct the error beforehand and avoid logging

of t ickets from users.

• Worked on Version Control software to check-in codes and integrated with K intana for file migration.

Used F ND-LOAD to migrate concurrent programs, request sets, forms menus and Personalization, by

downloading the LDT files.

• Involved in preparing BRD, functional document, user document, process f low diagram and f low charts.

• Created the test scripts and complex queries to test the application and quality assurance of the data.

• Involved in preparing test plans, unit testing, system integration testing, implementation and

maintenance.

• Ensure quality in coding and testing, conforming to standard IR protocol.

Tata Consultancy Services Ltd, I ndia J ul’08 to Dec’11

Oracle Developer/Production Support

Page 3 of 5

Resume: Tejasvi Shah

P roject Description: T his Project U ltimatix – Service Delivery maintains the whole of TCS’s project

business f low with clients provides process improvements and implements business in new subsidiaries. I t

maintains ERP solution (Oracle apps) for different subsidiaries of Tata Consultancy Services L td around the

world, enhancing existing processes and implement new system change requests from business users.

Technical Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.

• Used Oracle J Developer to build a new application in OAF.

• Had experience with Control-M for creating, scheduling and ordering jobs.

• Experience in SQL performance tuning using Cost-Based Optimization (CBO).

• Creating i ndexes on tables to improve the performance by eliminating the full table scans and views for

h iding the actual tables and to eliminate the complexity of the large queries.

• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using O racle Hints, for

Rule based optimization.

• Performed modifications on existing Oracle form as per change request and maintained i t.

• Conducted code reviews, performed unit testing, fixes, and requirement validations.

• Responsible for t racking of high priority t ickets and resolution of escalated support incidents.

• Answer technical support queries and implement fixes for application problems.

• Worked on cross-functional teams to proactively address support issues.

• Create and maintain documentation for supported applications.

GE I ndustrial, Louisville, KY A pr’07 to

J un’08

Jr Oracle Developer/Production Support

Project Description: A web application which keeps t rack of the future arrivals and open shipments for the

supplier. I t basically keeps t rack of pick tickets which will be received in the warehouse and the pick Tickets

w hich needs to be forwarded fur ther. I t also facilitates the user to search the Pick Tickets based on the different

search criteria.

Technical Responsibilities:

• Writing technical documents using the functional specifications.

• Writing PL/SQL code using the technical and functional specifications.

• Fix defects encountered in any of the testing phases.

• Performing the tests on the newly coded procedures and documenting the same

• Production Support of the application after core delivery phase.

• Preparing H LD, L LD.

CERT I F ICAT ION

• Oracle Certified Associate (OCA) as PL/SQL Develop er.

• Six Sigma Green Belt, TCS

Page 5 of 5

Resume: Tejasvi Shah

Contact this candidate