KALYANI.G

Email: adco2x@r.postjobfree.com

Mobile: +91-630*******

SUMMARY

Over 14 years of experience in design, and development of information systems for various commercial applications. VFP Brain Bench Certified at 96% better. Extensive expertise in designing, coding implementation of variety of software applications using FoxPro 2.6, Visual FoxPro (VFP 3.0, VFP 6.0,7.0,8.0, 9.0), OOP, SQL Server 2000/2005/2014, Oracle database, Developer 2000, PL/SQL, VB, HTML

Experience in Networking Technology, .Net Technology, C#, ASP.Net, VB.Net, Visual Basic, HTML, DHTML, CSS, DOM, Web Design, Web Programming, JavaScript, VBScript. Experience with databases like Dbase, Oracle SQL*Plus, Oracle 8/9i, Oracle Stored Procedures, Visual FoxPro, SQL Server 2000/2005/2014

SIGNIFICANT PROJECTS

BlueCherry (Computer Generated Solutions Inc., Hyderabad, Telangana)

RFACTS (IndChem Sales Corporation, Chennai, TamilNadu)

BFS (Dendrite, Totowa, NJ)

GNMA (JP Morgan Chase, New York, NY)

NYCSCA (NY City School Construction Authority, Long Island City, NY)

BCBS (Blue Cross Blue Shield, Little Rock, AR)

SCMA (ORI Inc, Kansas City, KS)

ITMS (U.S. General Services Administration, Kansas City, MO)

APS (Vi. Microsystems Pvt. Ltd., Chennai, India)

SKILLS

OS

Windows 2000 Server, Windows 3.1, Windows 95/98/2000/NT/XP, Unix, Windows 10, MS-DOS

Databases

Dbase, Oracle 7.x/8.0/9.0, Oracle SQL*Plus, MS-Access 2000/2007/2010, MS-Excel, SQL, SQL Server 2000/2005/2014, Visual FoxPro, OleDB

DB Drivers

ODBC Driver

Languages

Java, JDK 1.2/2.0, PL/SQL, HTML, C, C++, C#.Net, VB.Net, ASP/ASP.Net, Visual Studio.Net, JavaScript, XML/XSL, XSLT, FoxPro 2.5, 2.6, Visual FoxPro 3.0/6.0/7.0/8.0/9.0, Visual Basic 6.0, COBOL, Object Oriented methodologies, Pascal, Basic, Fortran

.Net Technologies

C#, .NET framework, Assemblies, VB.NET, Web Services, ASP.NET, ADO.NET, COM interoperability, .NET Security, Web Custom Control

Internet Technologies

HTML 4.0, DHTML, CSS, DOM, XML, XSL

Servers

SQL Server 2000/2005/2014

Scripting Languages

JavaScript, VBScript

Design Skills/Tools

PL/SQL, Forms Designer 4.5, Reports Designer 2.5, Visual FoxPro 3.0/6.0/7.0/8.0/9.0

Other S/W

OOP, Crystal Reports, Visual Fox pro Reports, CIW - Foundation Series, .Net Framework, IIS, Visual Source Safe, TOAD, Adobe Acrobat, HTML Tables, CSS Styles

GUI Tools

Visual Age for Java 2.0, Visual Basic 6.0

PROFESSIONAL EXPERIENCE

BlueCherry – Computer Generated Solutions Inc, Hyderabad, Telangana Aug 19-Apr 20

Project: BlueCherry ERP Application

BlueCherry - BlueCherry Application maintained in Visual Foxpro 9.0 with SQL Server 2014 backend. It is one of the most widely deployed ERP for leading fashion, apparel and footwear brands across the globe. This application provides EDI processes for inbound and outbound data, Style Master, Sales Order Entry, Production Order Entry, Process Invoice, Reports etc.

Roles & Responsibilities.

BlueCherry Application maintained in Visual Foxpro 9.0 with SQL Server 2014 database.

Involved in adding, updating, deleting, modifying data in the entire BlueCherry System Application for example order info, Products available and ordered quantities, product information, projects under each client etc. Pulled delimited flat files and loaded that data to sql server tables and vice versa through EDI processes. Implemented, maintained, enhanced the BlueCherry application to satisfy the customers.

Created SQL Queries and Reports to track sales customer wise, product wise. Provided weekly and daily basis reports to superiors as to what is being updated in the system and provided reports monthly basis as to sales tracking. Created new screens to fulfill customer requirements as and when needed. Created Qpatches, Customer Service Packs, Global Service Packs for Customers as and when needed with the fixes for delivery. This whole application is based on Frame work within CGS.

Environment: Visual FoxPro 9.0, SQL Server 2014 Database, Visual Source Safe, SQL, OOP, MS-Word 2007, MS-Access 2007, MS-Excel 2007, Note Pad, SharePoint, MS-Outlook, Networking, Adobe Acrobat

RFACTS - Indchem Sales Corporation, Chennai, TamilNadu Jul 16-Sep 17

Project: RFACTS

RFACTS - RFACTS is Foxpro 2.6 DOS system maintained to buy and sell leather products from local and import companies associated with IndChem Sales Corporation. Printing Reports, Invoices, keeping track history of sales per month and reconciliation, journal entries, accounts etc organized within RFACTS.

Roles & Responsibilities.

RFACTS - Already existing system maintained in FoxPro 2.6 with FoxPro database.

Involved in adding, updating, deleting, modifying data in the entire RFACTS System for example order info, Products available and ordered quantities, product information, projects under each client etc. Pulled delimited flat files and loaded that data to FoxPro tables and vice versa. Implemented, maintained, enhanced the RFACTS application to satisfy the customers.

Created SQL Queries and Reports to track sales customer wise, product wise. Provided weekly and daily basis reports to superiors as to what is being updated in the system and provided reports monthly basis as to sales tracking. Created new screens to fulfill customer requirements as and when needed. Monthly outstanding reports have been created and printed for collection.

Environment: Visual FoxPro 7.0/FoxPro 2.6, FoxPro/Visual FoxPro Database, Visual Source Safe, SQL, OOP, Visual Basic, MS-Word 2000, MS-Access 2000, MS-Excel 2000, Note Pad, SharePoint, MS-Outlook, Networking, Adobe Acrobat

BFS - Dendrite, Totowa, NJ Jan 08-Jan 13

Project: Basic Fulfillment System (BFS)

BFS – Basic Fulfillment System is an Order Entry System connecting physicians and the pharmacies, warehousing to ship drug samples to the physicians, reps. BFS is the mediator between the both. This system takes the orders by validating physician’s state license validity and checks, processes before authorizing the orders to be shipped. After all the process validated, BFS sends all the orders to ILS inventory system and warehousing to ship the orders to the physicians.

Roles & Responsibilities.

BFS - Already existing system maintained in FoxPro 2.6 with FoxPro database.

Involved in adding, updating, deleting, modifying data in the entire BFS System for example order info, Products available and ordered quantities, drug and product information, projects under each client etc. Pulled delimited flat files and loaded that data to FoxPro tables and vice versa. Implemented, maintained, enhanced the BFS Fulfillment application to satisfy the customers.

Environment: Visual FoxPro 7.0/FoxPro 2.6, FoxPro/Visual FoxPro Database, Visual Source Safe, SQL, OOP, Visual Basic, MS-Word 2000, MS-Access 2000, MS-Excel 2000, Note Pad, SharePoint, MS-Outlook

JP Morgan Chase, New York, NY Jan 06 - Oct 07

Project: GNMA (Ginnie Mae)

Ginnie Mae, helps make affordable housing a reality for millions of low- and moderate-income households across America by channeling global capital into the nation's housing markets. Specifically, the Ginnie Mae guaranty allows mortgage lenders to obtain a better price for their mortgage loans in the secondary market. The lenders can then use the proceeds to make new mortgage loans available. Ginnie Mae does not buy or sell loans or issue mortgage-backed securities (MBS).

Roles & Responsibilities.

Involved in the Web Design and Development of GNMA Web Application – Converting GNMA VFP Windows application to Web Application. The project was maintained in VFP. Created Web Pages for GNMA Modules using C#, VB.Net, ASP.Net, JavaScript, VBScript. Created Oracle Stored Procedures using Oracle 8/9i, Oracle SQL*Plus to relate to database. Created various Help Pages using HTML, CSS, JavaScript, DOM, HTML Tables for GNMA Web Help Pages. Created Various External Style sheets using CSS, inline class styles for GNMA Web Pages. Created various query screens and programs to perform functionality according to Client’s specification on an as needed basis using Oracle, SQL, PL/SQL. Provided detailed status reports of tasks and assignments performed on an as needed basis.

Environment: ASP.Net, C#, VB.Net, JavaScript, VB Script, Oracle 8/9i, Oracle database, Oracle SQL*Plus, Oracle Stored Procedures, SQL, PL/SQL, TOAD, HTML, DHTML, CSS, DOM, HTML Tables, Adobe Acrobat, Visual FoxPro 8.0/9.0, Visual FoxPro Database, Visual FoxPro Reports, Visual Source Safe, SQL/SQL Server 2000/2005, OOP, Visual Basic, MS-Word 2000, MS-Access 2000, MS-Excel 2000, Note Pad, Windows XP, Windows NT

NYCSCA (NY City School Construction Authority), Long Island City, NY Aug 05 - Nov 05

Project: Project Controls Reporting – Business Analyst

The NY City School Construction Authority (SCA) established by the New York State Legislature to build new public schools and manage the design, construction and renovation of capital projects in New York City's more than 1,200 public school building.

Roles & Responsibilities.

Involved in the Analyzing and Reporting for CIP and RESOA Projects using VFP 7.0. Created Various VFP programs to generate data and reports using VFP Reports Designer. Created queries using SQL and maintained data in VFP 7.0 database. Written & executed Test cases to test the programs and data generated.

Environment: Visual FoxPro 7.0/8.0, Visual FoxPro Database, SQL, OOP, MS-Word 2000, MS-Access 2000, MS-Excel 2000, Note Pad

BCBS - AR (Arkansas Blue Cross Blue Shield), Little Rock, AR Apr 05 - Jun 05

Project: BCBS Insurance

As a nonprofit, mutual insurance company, Arkansas Blue Cross is owned by its policyholders, not by stockholders. This means that premium dollars are used solely to pay claims and administrative costs, not to pay stock dividends. Any excess funds are held in reserve for payment of future claims. Arkansas Blue Cross must maintain a fiscal balance between premium income and benefits paid to ensure that they have the ability to continue to offer these products and to pay policyholder claims in the future.

Roles & Responsibilities.

Designed and developed the UI and middle tier business components for BCBS Insurance project modules using Visual FoxPro 8.0/9.0 using Visual FoxPro Database. The project was maintained in VFP 8.0. Also converted VFP 2.6 project modules to VFP 8.0. Created various query screens and programs to perform functionality according to Client’s specification on an as needed basis using Oracle, SQL. Provided various suggestions to improve the functionality and the behavior of the project to make it User-Friendly for the valuable Client and customers. Provided detailed status reports of tasks and assignments performed on a daily basis.

Environment: Visual FoxPro 8.0/9.0/2.6, Visual FoxPro Database, Visual Source Safe, SQL, OOP, Visual Basic, HTML, DHTML, CSS, DOM, JavaScript, HTML Tables, MS-Word 2000, MS-Access 2000, MS-Excel 2000, Note Pad

ORI, Inc ., Kansas City, KS Sep 03 - Feb 05

Project: SCMA (Service Chain Management Application)

ClarientASP markets and provides Service Chain Management Application in the Marketplace. The application provides specific and modular functionality tailored to Client’s requirements. It is an integrated solution towards human capital management, which links clients, employees, vendors, project managers, management, facilities, and suppliers.

Roles & Responsibilities.

Designed and developed the UI and middle tier business components for “Time and Leave” and “Project management” modules using Visual FoxPro 6.0,7.0,8.0 using Visual FoxPro Database. The project was maintained in VFP 6.0 and the Database module was upgraded to VFP 7.0 and SCMA application was upgraded to VFP 8.0. Converted VFP 2.6 project modules to VFP 8.0. Created various forms and reports to keep track of employees and to view payroll data, timesheets etc using VFP Forms and Reports Designers.

Created various query screens and programs to perform functionality according to Client’s specification on an as needed basis using Oracle, SQL. Created various help pages, tables, styles using HTML, CSS (Cascading Style Sheets), JavaScript, DOM, HTML Tables. Provided detailed status reports of tasks and assignments performed on a daily basis.

Environment: Visual FoxPro 6.0/7.0/8.0, Visual FoxPro Database, Visual Source Safe, SQL/SQL Server 2000/2005, FoxPro 2.6, OOP, Visual Basic, HTML, DHTML, CSS, DOM, JavaScript, HTML Tables, Adobe Acrobat, MS-Word 2000, MS-Access 2000, MS-Excel 2000, Note Pad

U.S. General Services Administration, Kansas City, MO Oct 00 - Jul 03

Project: ITMS (Interagency Transportation Management System)

ITMS (Interagency Transportation Management System) was a CD-ROM based automated transportation management system that provided rate and routing information and report query functions to federal civilian agencies involved in the movement of freight and household goods. For Transportation Service Providers (TSPs), ITMS also provided rate filing capabilities.

Roles & Responsibilities.

Team Member of ITMS Project.

Design, Develop, Coding and implementation of ITMS CD-ROM release and DBA Module for federal civilian agencies and transportation service providers Using Visual FoxPro 3.0, Visual FoxPro 6.0

ITMS system was deployed using VFP 3.0 and the CD-ROM provided for the customers was in VFP 3.0

For to make the debugging process easier and since VFP 6.0 had more features and tools than VFP 3.0, ITMS was maintained in VFP 6.0 as well and the Database Administration Module (DBA) for ITMS system was maintained in VFP 6.0. CD-ROM was released every May and November of each calendar year to it end users. Created ITMS Flowchart and Program Manual. Created HTML Pages for viewing code using HTML, Created inline and external styles using CSS (Cascading Style Sheets), JavaScript, DOM, HTML Tables.

Provided detailed weekly documentation and status reports of tasks and assignments performed on a daily basis.

Environment: Visual FoxPro 3.0/6.0, Visual FoxPro Database, FoxPro 2.6, Dbase, Oracle, SQL, OOP, HTML, DHTML, CSS, HTML Tables, DOM, Adobe Acrobat, JavaScript, Adhoc Queries, Visual Basic, MS-Word 2000, MS-Access 2000, MS-Excel 2000, Note Pad, Windows 2000, Windows NT, Novell Netware

Vi. Microsystems Pvt. Ltd., Chennai, India Dec 96 - Jun 98

Project: APS (Accounts Payable System)

Accounts Payable System provides the company with an efficient method of keeping track of the bills the firm has to pay. APS allows the firm to enter invoice transactions as recurring transactions without re-entering the same payment information each month. APS helps the firm manage its cash needs by allowing to print a Detail or Summary Cash Requirements Report.

Roles & Responsibilities.

Implement, Design and Develop APS system using RDBMS Oracle and Developer 2000 tools namely Forms and Reports, SQL, PL/SQL.

Created various screens such as invoice, transaction and report screens using Forms and Reports Designer

Provided weekly and monthly reports for tasks performed on a daily basis

Environment: Oracle Database 8i, Forms 4.5, Reports 2.5, SQL, PL/SQL, Stored Procedures, Triggers, Cursors, Functions, MS-Word, MS-Access, MS-Excel, Note Pad

EDUCATION: B.SC (Bachelor of Computer Science) - University of Madras – 1998

PERSONAL DETAILS:

Name : Kalyani G

Father’s Name : Ganesan V

Gender : Female

Date of Birth : 13th Nov 1976

Marital Status : Married

Languages Known : Tamil & English

Nationality : Indian

Contact this candidate