Crystal Reports Sales
Resume:
S. SUGANTHI No.* KNG Garden,
Kuniamuthur,
COIMBATORE – 641 008
Ph: 91-960*******
****.*****@*****.***
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