Summary:
• Possess more around five years of experience in handling Oracle PL/SQL, D2K, and Oracle Apps based applications with strong knowledge of SQL and PL/SQL. Good understanding of design patterns and has used them in Designing applications
• Experienced in all phases of Software development life cycle (SDLC), project life cycle processes, Development, QA, UAT, Production, project estimation
• Experience in maintenance project, accepting and assigning incidents, resolve incidents within pre defined SLAs, moving them to Track Record if require code change, creating RFC and follow up with respective group
• Extensive experience in developing client/server applications using Oracle 10g/9i, Dev2000
• Actively involved in developing complex PL/SQL structures.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e. Stored Procedures, Packages, Functions, Triggers, Collections, Bulk Binding and Table Partitioning using SQL*PLUS and Toad as development tools.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines, work around of mutating errors.
• Experience in handling errors using Exceptions.
• Experience in implementing row level security using DBMS_RLS package.
• Designing of Forms & Reports, module level testing and database designing
• Solid experience with Oracle development tools using Developer 2000, TOAD, Sql Loader
• Experienced in application fine-tuning & database fine-tuning using Explain Plan.
• Understanding and working knowledge with SQL Trace and TKPROF.
• Working experience of Unix and FTP
• Working experience in VI Editor
• Oracle Utilities: Backup, Import, Export
• Reports creation and customization in Discoverer
• Translation of Discoverer reports into different languages and resolve different issues in discoverer
• Experience of AOL
• Good working experience in ERP environment
• Has excellent communication skills, interpersonal skills and has consistently delivered quality work on time
• Excellent problem solving and troubleshooting skills
Certifications:
• Oracle Certified Professional on developer track from Oracle Corp. in 2008(OCP) with 94%
• Oracle Certified Associate on developer track from Oracle Corp. in 2007(OCA) with 92%
Education:
• Master in Computer Application from Sikkim Manipal University in 2011 with 68%.
• Bachelor of Science, Affiliated to Meerut University, Uttar Pradesh, India in 2006 with 68%
• Higher secondary school from New Public Collegiate, Lucknow in 2003 with 61%
• Secondary school from New Public Collegiate, Lucknow in 2001 with 65%
Technical Skills:
• Languages SQL, PL/SQL, Unix
• Key Skills Oracle PL/SQL, D2K 6i&10g, Developer 2000(forms & Reports),
Oracle Apps, Data Mart, Discoverer 10g, UNIX, XML Publisher, SQR,
• Tools Toad, PL/SQL Developer, SQL Loader, Winscp, Star Team, ITSM,
Application Manager (APPWORX).
• O. S. Windows 2000 pro, Advanced Server-2003, XP/2000/NT, UNIX
• Database Oracle 9i , Oracle 10g, 11g
Professional Experience:
Mar 10 – Till Date Keane India Limited Sr. Software Engineeer
Client Best Western International
Description Best Western International is the world's largest hotel brand with over 4,200
hotels in 80 countries. Their uniqueness is found in each hotel's charm and local
appeal while maintaining a commitment to quality, service and value. The Project
comprises of 50 team members excluding onsite team members handling various
technology based sub applications.
Contribution My responsibilities included:
• Actively involved in all phases of a project i.e understanding functional document, creating TDS, UTS, peer review, creating RFC, check in & check out code, QA, UAT, clarification meetings with client and on-site team.
• Playing role of primary on-call for maintenance project.
• Resolving incidents within defined SLAs and moving them to track record if any code change required, send analysis to BAM
• Writing complex sql queries for client’s report request, formatting the report.
• Writing pl/sql objects, coding in Forms, Reports, SQR, Ksh, Perl Script
• Tuning of queries in database and reports
• Helping team resources for resolving their critical incidents
Environment Oracle 10g, PL/SQL, Developer 2000/FORMS REPORTS 6i and 10g, SQR, PSP, PL/SQL Developer, Star Team, Winscp, Application Manager (APPWORX), FRS (Front Range IT Service Management), Perl Script, KSH
Team Size 50
Sep 09 – Mar 10 Jagran Prakashan Ltd (JPL) Sr. Software Executive (IT)
Jagran Prakashan Ltd (JPL) is India’s leading media and communications
group, with its main interests across Newspapers, Outdoor, Internet,
Magazines, Below the Line marketing solutions, and Mobile Value
Added Services. DAINIK JAGRAN, as on today, is the highest read
National Daily across all languages (including English) in India.
Project I MIS Development and Support Project
Modules Inventory, Wastage
Description Inventory module involves the purchasing of materials (especially reels) through enquiries to relate vendors on the basis of requisition by different cost centers, vendor analysis, and purchase order dispatch, material Receipts, Issues, Stock Maintenance and Stock valuation. Wastage module is about selling the wastage generated in various form in paper industry, payment of wastage on credit and accounting of the same. It merges in the finance module.
Contribution My responsibilities included:
• Understand the functional system of Newsprint and Wastage.
• Database designing, Security of database, Developer level security
• Writing the database triggers for auditing
• Designing of forms and reports coding and testing
• Creating the database procedure and functions
• Tuning of queries in database and reports
• Database designing and creating libraries in using the database procedures and packages
• Responsible for databse security at both developer and user level
Environment PL/SQL, D2K, Developer 2000/FORMS REPORTS 6i and 10g, Oracle 10g, Data Mart, Toad 9.5.
Role Team member
Team Size 30
Jul 08 – Sep 09 KPIT Cummins Infosystems Ltd Software Engineer
Project I Cummins IT Support and Implementation Project
Client Cummins Turbo Technologies
Contribution As a Software Engineer, my responsibilities included:
• Designing and customizing of forms and reports using various tools like developer 2000(D2K), discoverer, XML Publisher and updating the technical design document accordingly
• Writing and customizing inbound and outbound interfaces which include writing functions procedures and packages
• Customization of PL/SQL reports.
• Responsible for storing backup of database objects (views, packages, templates), recompiling these objects and upload again in database after refresh of instance.
• Responsible for translating the discoverer reports from one language to another
Environment Oracle, Developer 2000/FORMS REPORTS 6i, PL/SQL, Oracle 9i, Unix, Toad 7.5, Discoverer 10, XML Publisher, Citrix, VSS, Putty
Role Team member
Team Size 12
Duration Jul 08 – Aug 09
Jun 06 - Jul 08 Four C plus (Internet) Co Ltd, New Delhi Software Engineer
Project I Enterprise Resource Planning for Print Media
Client DNA (Daily News & Analysis Mumbai)
Description Material management involves the purchasing of materials through raising the enquiries to relate vendors on the basis of requisition by different cost centers, vendor analysis, purchase order dispatch, material Receipts, Issues, Stock Maintenance and Stock valuation. HR and Payroll module helps to keep the record of employee, their monthly salary and income tax related information. Finance module is about the Cash, Bank and Journal Vouchers entry and finance related reports. This module is linked with the Circulation, Classified, Display and Purchase and Store.
Contribution My responsibilities included:
• Understand the functional system of their HR and Payroll activities
• Make a new 10g database server
• Database designing
• Implement the HR and payroll
• Module testing and make it live
• Coding of triggers in forms and reports
• Creating the database procedure and functions
• Designing of forms & reports for finance module
• Database designing and creating libraries in using the database procedures and packages
Environment PL/SQL, D2K, Developer 2000/FORMS REPORTS 6i and 9i, Oracle 10g, Toad 9.5.
Duration Jan 08 – Jul 08
Project II Enterprise Resource Planning for Print Media
Client Prabhat Khabar Ranchi
Description Finance module is about the Cash, Bank and Journal Vouchers entry and finance related reports. This module is linked with the Circulation, Classified, Display and Purchase and Store. HR and Payroll module helps to keep the record of employee, their monthly salary and income tax related information. Material Management involves the purchasing of materials through raising the enquiries to relate vendors on the basis of requisition by different cost centers, vendor analysis, purchase order dispatch, material Receipts, Issues, Stock Maintenance and Stock valuation. From two branches data was sent to the main server as scripts and in the month end it was re-loaded into the same server using sql loader and LOGME-IN. An online Backup Server is also maintained which is used in case of server failure. All the branches were connected through DB Links and financial ledger, trial balance, salary reports was generated globally.
Contribution My responsibilities included:
• Client interaction for the requirement of gathering, analyzing and designing of the following modules: Inventory, Finance, Payroll, Advertisement
• Coding of triggers in forms and reports
• Creating the database procedure and functions and call them in forms
• Use the constraints and trigger to maintain database integrity
• Module level testing
• Designing of forms & reports
• Database designing and creating libraries in forms
• Creating database procedures and packages
Environment PL/SQL, D2K, Developer 2000/FORMS REPORTS 6i, Oracle 9i, Toad 7.5, Sql Loader
Duration June 06 – Dec 07
Personal Information
Father’s Name Late Shri Dhanprakash Tyagi
Date of birth 20-SEP-1987
Nationality Indian
Marital Status Single
Language English and Hindi
Hobbies Playing Cricket, Chess, Surfing
Address Deoband, Sharanpur (247554)
Passport Yes (Passport No-G6522105 valid up to 16-Dec-2017).
Vivek Tyagi
