S. SUGANTHI No.* KNG Garden,

Kuniamuthur,

COIMBATORE – 641 008

Ph: 91-960*******

ac2r1g@r.postjobfree.com

Over 10 years of experience in design, development & maintenance of Client-Server and ERP applications

Expertise in Oracle 9i and Oracle 10g, SQL, PL/SQL, Crystal Reports 10

Expertise in Database designing and Performance tuning.

Experience in Database administration includes Backup, Recovery & Database maintenance

Strong experience in Application production support includes Incident resolution, Incident reduction, Platform stabilization & Enhancements

Good experience in supporting Network, Firewall & Infrastructure management

Good experience in VB 6.0, Asp. Net, vb.Net, Microsoft SQL Server 2000

Good domain knowledge of ERP applications covering Purchase, Manufacturing, Sales, Accounting & HR functions

Strong analysis, design, development and implementation skills.

A logical, analytical thinker with exceptional database skills possesses rich experience as Oracle PL/SQL developer

Experience in implementing projects at Client locations (Travelled to China)

EDUCATIONAL QUALIFICATION:

Jun 2001 – Jun 2003 M.Sc. Software Information System

Amirta Institute of Computer Technology, Coimbatore.

Jun 1998 - May 2001 Bachelor of Commerce (B.Com)

C.B.M. College of Arts & Science, Coimbatore.

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS:

Windows 2000, Windows NT 4.0, Unix

SOFTWARE:

Oracle 9i,Oracle 10g, MS- Access 7.0, Microsoft SQL Server 7.0, Visual Basic 6.0,Asp.net, VB.Net,WPF,Crystal Reports 10,SQL Server Reporting Services( SSRS )

LANGUAGES:

SQL, PL/SQL, C/C++, Java

Work Experience

As Asst.Manager IT at Emerald Jewellery Retail Ltd., Coimbatore from Sept 2016 to till date.

As Asst.Manager IT at Kirtilal Kalidas Pvt. Ltd., Coimbatore from Dec 2008 to Aug 2016.

As Software Engineer at Datalog Technologies Pvt. Ltd., Coimbatore from April 2005 to Dec 2008

PROJECT EXPERIENCE

Sept 2016– Till date Point of Sale (POS)

Role Project Manager

Environment Windows, ASP .NET, SQL Server, Crystal Reports 10

Client Emerald Jewellery Retail Ltd (In House)

Project Description: The objective of the system is to manage the end to end Sales process covering the Diamond/Gold jewelry details, list of Customers, their product Estimation, Billing & Certification. It also enables the user to manage Customer Orders and Online tracking & Branch transfers. Additionally, the system has been integrated with Calendar for organizing days for retail activity like Customer Follow-up target vs sales details, commercial and for administrative purposes. Also, robust reporting and Analysis platform has been developed to monitor the performance of various products, Profitability, Sales by Region & month and provides trends and various insights for making business decisions.

Roles/Responsibilities:

Responsible for overall Design, development & implementation of the system includes Front end development, Database & reporting components.

Created the packages, stored procedures, functions using PL/SQL for data storage and developed various business reports using Crystal reports

Involved in most of the backend activities like writing DML & DDL statements, Creating views and Indexes

Responsible for performance tuning of Queries, Functions & Procedures

Involved in Code review process and guiding other team members

Responsible for post implementation support, Application monitoring & incident analysis and resolution

Responsible for analyzing repeated incidents / issues and address the root cause to stabilize the application

Jun 2015– Aug 2016 Stockpile Application

Role Project Manager

Environment Windows NT, Oracle 10g, PL/SQL, VB.Net, Crystal Reports 10

Client Vispark Manufactures

Project Description: This system has specifically designed & developed for Vispark Manufactures. The system contains diamond /Gold jewellery production needs, raw material details to finish the product with all process information. It also captures Core Inventory management details, Product manufacturing history, Vendor Sales and return details, manufacture area to showroom transfer details, Customer order and transactions details. Various Management information reports are generated to manage raw materials, Stock details, Issue and receipts details for a specified period and to track quality controls defined in the process.

Roles/Responsibilities:

Responsible for overall Design, development, implementation & production support of Database & reporting components.

Created the packages, stored procedures, functions using Oracle PL/SQL for data storage and developed various business reports using Crystal reports

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Involved in most of the backend activities like writing DML & DDL statements, Creating views and Indexes

Responsible for performance tuning of Queries, Functions & Procedures

Involved in Code review process and guiding other team members

Responsible for post implementation support, Application monitoring & incident analysis and resolution

Responsible for analyzing repeated incidents / issues and address the root cause to stabilize the application

Jan 2015– May 2015 Euro Star Production system and Product Catalog

Role Technical Lead

Environment Windows NT, Oracle 10g, PL/SQL, Asp.Net, Crystal Reports 10

Client Euro Star - CHINA

Project Description: The existing Production system and Product Catalog applications have been customized for Euro Star for their business requirements. The package contains the list of Customers, their diamond /Gold jewellery production needs, Inventory management & Product manufacturing history

This system will able to provide an online catalogue for various ornaments. Using this, Customer can check the various ornaments with is made of gold’s, diamonds etc. Apart from all these, the admin of particular Jewellery shop can also make some important updates online like selling on any particular Jewellery products, any new exchange scheme etc. Just like online shopping portal, here the customers will also able to look products using different images, reviews of customers who have purchased particular products earlier, Reports are also generated for diamond /Gold raw material and finished good stock details,

Roles/Responsibilities:

Implementation of Production system and Product Catalog at Customer location

Created the packages, stored procedures, functions using Oracle PL/SQL for data storage

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Mar 2014– Dec 2014 Kirtilal Kalidas– Jewellery catalog

Role Technical Lead

Environment Windows NT, Oracle 10g, PL/SQL, Asp.Net, Crystal Reports 10

Client Kirtilal Kalidas (In house)

Project Description: This package has specifically designed & developed for a kirtilal kalidas jewellers This system will able to provide an online catalogue for various ornaments. Using this, Customer can check the various ornaments made of gold’s, diamonds etc. Additionally, the admin of a particular Jewellery shop can also make updates online like selling on any particular Jewellery products, any new exchange scheme etc. Just like online shopping portal, here the customers will also able to look products using different images, reviews of customers who have purchased particular products earlier etc.

Roles/Responsibilities:

Worked as a Technical Lead

Analysis of business requirements from the business users.

Converting the business requirements into Technical requirements.

Involved in most of the backend activities like writing DML & DDL statements, Creating views and Indexes

Writing Oracle Stored Procedures and tuning SQL queries.

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Responsible for post implementation support, Application monitoring & incident analysis and resolution

Responsible for analyzing repeated incidents / issues and address the root cause to stabilize the application

Oct 2012– Jan 2014 Payroll System

Role Technical Lead

Environment Windows NT, Oracle 9i, PL/SQL, Asp.Net, Crystal Reports 10

Client Kirtilal Kalidas (In house)

Project Description: This application contains the employee detail includes professional details, personal information & Compensation details. It also handles Monthly Salary generation, Employee KRA & Provident Funds. As part of this project, have implemented several enhancements to these modules to manage business requirements and initiatives taken. It also handles associates Training needs & schedules.

Roles/Responsibilities:

Worked as a Technical Lead

Involved in Logical & Physical design of the Database

Creations of Functions, Procedures & tuning of SQL queries

Involved in most of the backend activities like writing DML & DDL statements, Creating views and Indexes

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Responsible for post implementation support, Application monitoring & incident analysis and resolution

Responsible for analyzing repeated incidents / issues and address the root cause to stabilize the application

Nov 2010– Sept 2012 Vispark Jewellery Manufacture – Production System

Role Technical Lead

Environment Windows NT, Oracle 9i, PL/SQL, Visual Basic 6.0, Crystal Reports 10

Client Vispark Manufacture,

Project Description: This package has specifically designed & developed for Vispark Jewellery Manufacture. The package contain the list of Customers, their diamond /Gold jewellery production needs, Product manufacturing history and BOM details, vendor Sale and return, manufacture area to showroom transfer details, Product design and diamond details This package helps in maintaining a overall diamond/Gold jewelry transactions. Reports are also generated for diamond /Gold raw material and finished good stock details, jewelry production, issue and receipts details during a specified period.

Roles/Responsibilities:

Worked as a Technical Lead

Involved in Database design and Screen prototype

Involved in most of the backend activities like writing DML & DDL statements, Creating views and Indexes

Writing Oracle Stored Procedures and tuning SQL queries.

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Involved in Code review and Unit test case review.

Involved in Development, Unit testing, System testing, User Acceptance testing, Implementation and Production support for the enhancements.

Jan 2009– Sep 2010 Kirtilal Kalidas Jewellers – Diamond /Gold Jewelry Sales System

Role Senior Developer

Environment Windows NT, Oracle 9i, PL/SQL, Visual Basic 6.0, Crystal Reports 10

Client Kirtilal Kalidas Jewellers (In house)

Project Description: This package has specifically designed & developed for a Kirtilal Kalidas Jewellers for all Showroom which enables them to store the Diamond/Gold jewelry details, The package contain the list of Customers, their diamond /Gold jewellery Estimation, Diamond/Gold jewelry billing, Branch transfer (One branch to another branch transfer goods), Customer Old diamond/gold purchase details, overall sales, Customer Sale return, manufacture area to showroom transfer details, Product design and diamond details, Customer order transaction and jewelry receipt etc.

Roles/Responsibilities:

Worked as a Senior developer

Involved in Database design and Screen prototype

Writing Oracle Stored Procedures and tuning SQL queries.

Involved in the development of reports using Crystal Reports.

Involved in Code review and Unit test case review.

May 2008– Dec 2008 Australia Weaving

Role Senior Developer

Environment Windows NT, Oracle 9i, PL/SQL, Visual Basic 6.0, Crystal Reports 10

Client Australia Weaving, Australia

Project Description: Online knitting monitoring System is a product has been implemented in Australia Weaving with lot of customization. This software communicates with all the Machine Terminals at regular intervals and stores the information regarding the Run, Stop, Production and Efficiency details of the Machine in a Database. The details stored in the database will be reflected to the user automatically at regular intervals. Also it generates various reports based on the information stored in the database.

Major customization being done on the modules Speed Calculation, Stoppage details, Yarn details, Efficiency Calculation, Efficiency trend analysis, Machine details, Knitter efficiency. Also various management information reports have been provided to measure the organization compliance

Roles/Responsibilities:

Worked as a Senior developer

Involved in Database design and Screen prototype

Involved in most of the backend activities like writing DML & DDL statements, Creating views and Indexes

Writing Oracle Stored Procedures and tuning SQL queries.

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Involved in Code review and Unit test case review.

Involved in Development, Unit testing, System testing, User Acceptance testing, Implementation and Production support for the enhancements.

Jun 2007– Apr 2008 New Minatex - Online Loom Monitoring System

Role Developer

Environment Windows NT, Oracle 9i, PL/SQL, Visual Basic 6.0, Crystal Reports 10

Client New Minatex, Indonesia

Project Description: Online Loom Monitoring System is a product has been implemented in New minatex with lot of customization. Major customization has been done on the modules Efficiency Calculation, Efficiency trend analysis, Stoppage Maintenance, Snap Steady,Profile maintenance and EOD jobs. Various management information reports have been provided to measure the organization compliance. Enhancements for the modules Efficiency Calculation, Efficiency trend analysis & Stoppage Maintenance are in progress.

Roles/Responsibilities:

Worked as a designer and Developer

Involved in Development, Unit testing, System testing, User Acceptance testing, Implementation and Production support for the enhancements.

Involved in most of the backend activities like writing Oracle Stored Procedures, Error Handling, Creating Log file and managing the schema details.

Developed critical modules like EOD jobs, Efficiency Calculation, Efficiency trend analysis.

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Jun 2006– May 2007 CFL - Online Loom Monitoring System

Role Developer

Environment Windows NT, Oracle 9i, PL/SQL, Visual Basic 6.0, Crystal Reports 10

Client CFL, Moricis

Project Description: Online Loom Monitoring System is a product has been implemented in New minatex with lot of customization. Customization has been done on the modules Efficiency Calculation, Efficiency trend analysis, Meter Calculation, Machine details, Weaver efficiency. Also various management information reports have been provided to measure the organization compliance

Roles/Responsibilities:

Worked as a designer and Developer

Involved in Development, Unit testing, System testing, User Acceptance testing, Implementation and Production support for the enhancements.

Involved in most of the backend activities like writing DML & DDL statements, writing Oracle Stored Procedures.

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Sep 2005– May 2006 Badjatex - Online Loom Monitoring System

Role Developer

Environment Windows NT, Oracle 9i, PL/SQL, Visual Basic 6.0, Crystal Reports 10

Client Badjatex, Indonesia

Project Description: Online Loom Monitoring System is a product in Embedded System consists of Hardware Interfacing Unit (Machine Terminal). This software communicates with all the Machine Terminals at regular intervals and stores the information regarding the Run, Stop, Production and Efficiency details of the Machine in a Database. The details stored in the database will be reflected to the user automatically at regular intervals. Also it generates various reports based on the information stored in the database.

Roles/Responsibilities:

Worked as a designer and Developer

Involved in database design and Graphical User Interface (GUI).

Involved in most of the backend activities like writing Oracle Stored Procedures, Error Handling, Creating Log file and Batch process

Involved in Development, Unit testing, System testing, User Acceptance testing, Implementation and Production support

Involved in the development of reports using Crystal Reports and corresponding Oracle stored procedures.

Contact this candidate