Information Technology Software

SANTOSH GEORGE

Fremont, California- *****, USA

C: 510-***-**** ****************@*****.***

Skype: ****************@*****.***

VISA STATUS: US Green card holder

PROFESSIONAL SUMMARY

** **ars of software development and programming experience with strong analytical and problem solving skills. Wish to be part of an organisation that facilitates my skills and knowledge that I can use to the betterment of the company resulting in advancement of both.

SKILLS

Troubleshooting problems/issues

MS SQL, SQL Server 2008, Oracle 8i

ETL Process and SSIS packages

QTP,QC

Database and application maintenance and Support

Crystal reports Enterprise Edition 10

Knowledge of Automation testing tool

JavaScript, VBScript, HTML

Knowledge of Order Management, Purchase

C#, ASP.NET WebForms

Manufacturing, Inventory, Shipping, Finance

.NET 3.5, IIS, VS 2008

Quality Control

WORK HISTORY

PHILADELPHIA WORKFORCE DEVELOPMENT CORPORATION

Programmer Philadelphia, Pennsylvania, US June 2007 - August 2013

Financial Payment System Team size: 2

This application is used by the company to track payments made to different candidates undergoing training with the agencies that work with the company. Agencies send payment and attendance details to the company that are loaded on to the company’s database. This application also allows the users to make payments.

Duties:

Designed and maintained database for Financial Payment System using SQL Server 2008

Created SSIS packages using Visual Studio 2008

Worked on ETL process using SSIS to extract data from database tables

Wrote SQL queries to get data as per requirements and loading into new database tables

Updated tables with new data extracted from text files received from external source via excel

Developed web user interface using ASP.net and C# to update data in the database according to the business rules

Generated crystal reports and reports in excel

Performed daily backup of the database

Created and executed disaster recovery plans

TRANE

Programmer (Contract) Hamilton, New Jersey, USA March 2007 - June 2007

Electronic quality testing Team size: 2

Trane is a heating and ventilating equipment manufacturing company

Duties:

Generating of Crystal reports from Oracle database using Crystal reports Enterprise edition 10

Used Quest software like SQL Navigator for querying and fetching data

Application maintenance and customization based on customer requirements for different software developed in VB 6 and used by the company like:

ØMaintained Mass Spec and Leak test software written in VB6 used in coil units

ØMaintained ETQC application written in VB6, used by assembly section of furnace manufacturing

ACCUMED INC.

IT Specialist Lawrenceville, New Jersey, USA November 2005 - January 2007

Oracle Apps ERP Team size: 4

Duties:

Administration and maintenance of Oracle Apps ERP package implemented at the pharmaceutical company

Developed a strong knowledge and SQL skills and using Quest software (Toad)

Created, modified and maintained the Oracle Server data and related functions

Created, modified and maintained the Oracle Server data and related functions

Client support and training of Orion ERP package, currently being under implementation at the company; also training for core users in each module

Developed Oracle Discoverer reports and D2k reports as per requirements

Installation and troubleshooting of software for the users

Designed, developed, and tested new software/customization based on customer requirements

Supervised the day-to-day support and training of the Orion ERP to core users

Developed strong skills with Order Management (OTC), Purchasing, Manufacturing, Packaging, Quality control, Inventory, Shipping, Finance (AR & AP),

Scheduled and implemented the project module’s full life-cycle in the Pharmaceutical Company.

Technical support duties as required

PIERRES & METAUX PRECIEUX LLC

Database developer Dubai, United Arab Emirates January 2004 - March 2005

Team size: 2

Administration and maintenance of Oracle database server

Developed and implemented supporting software and interfaces that utilized user interface

Created user and administrative documentation

Worked with Crystal reports

Interviewed business customers to elicit data requirements and to understand the relationships between data items

Developed a competency in training and directing the user community in resolving complex problems

Developed and implemented web-enabled supporting software and interfaces that utilized user interface

Created data flow diagrams (DFD’s) to define workflow and data structure diagrams to refine database needs

Designed, developed, and maintained business and technology applications

Performed software installation and troubleshooting

MICROHARD TECHNOLOGIES INDIA PVT. LTD

Programmer Bangalore, India July 2002 - December 2003

Directory Search Engine Team size: 2

Supervised the day-to-day support of the software

Implemented various Web based projects

Developed directory search engine using ASP technology

Supported trouble shooting

Organized and conducted orientation programs for the new staff

EDUCATION

MASTER OF SCIENCE IN INFORMATION TECHNOLOGY AND E-COMMERCE

Manonmanian Sundaranar University

Tamil Nadu, India 2002

MASTER DEGREE IN SCIENCE

Bidhan Chandra University

West Bengal, India 2000

BACHELOR OF SCIENCE

Dr. Punjabrao Deshmukh University, India

Maharashtra, India 1996

Contact this candidate