Developer Project
Resume:
T ejasvi Shah
*******.*.****@*****.***
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