Database Administrator Sr Programmer Analyst Resume
Tarrytown, NY
OBJECTIVEDesire a responsible and challenging position that will utilize my educational background, expand my skill set and offer opportunities for professional growth.
SKILLS
Operating Systems: Windows (2007, 2003, XP, Vista and previous versions), DOS,
Red Hat Linux
ProgrammingSQL, PL/SQL, Transact SQL, Pascal, HTML and other
Languages: proprietary scripting languages.
Software/Database:Oracle Databaseversions 8, 9i, 10g and 11g
(Oracle Certified Professional– 10g Database Administration)
SQL Serverversions 4.21, 6.5, 7.0
MS Access (Microsoft Certification)
versions 2.0, ’97, 2000, 2003, 2007
VB Script,Visual Basic versions 4.0, 5.0, 6.0
MS Office, Veritas NetBackup
EDUCATION
MS, Computer Science, Villanova University, Villanova, PA 19085.Dec 1994
Major: Database Management Systems
Independent Study: Compare and assess different techniques of data compression.
BS, Electronics Engineering, University of Bombay, Bombay, India.Jun 1991
Majors: Digital Design, Microprocessor System Design
EXPERIENCE
Database Administrator/Sr. Programmer Analyst, ConfidentialMar 2000 – Present
- As a DBA in theBusiness Intelligence Group, I currently manage theOracle (10g)Data Warehouse, extensively using the key Oracle database administration and performance tuning tools for data warehousing and management.
- Responsible for the daily data transfers from Taro’s ERP system,Business Planning Control System (BPCS), into the Oracle Data Warehouse, usingExtraction, Transformation and Loading (ETL)scripts.
- Upgraded Oracle database environment to version11g, implementedData Guard (Disaster Recoverysolution using physical standby database)andRMANbackups usingSymantec NetBackupto ensure high availability of theDiscount Pricing System(DPS or Incentives). Provide data analysis, integration and support for the interfaces between DPS and BPCS, using theElectronic Data Interchange (EDI)with business partners.
- Extensively work withTOAD(9.7) for Oracle, to provide solid Oracle backend for theCognos(8.4) reporting environment.
- Provide Oracle database administration for other financial applications and systems, using Oracle versions 8 and 9i.
- As a Programmer/Analyst, I developed client/server applications like Expense Budget, Capital Budget, Inventory Control Systems and various Sales Reporting Systems for the executives in multiple locations worldwide.
- Extensively helped different users and groups with their data and business analysis needs and provided solutions for business problems.
Programmer/Analyst, ConfidentialTarrytown, NY 10591Feb 1998 – Mar 2000
- As an effective member of theSolutions Group, successfully completed design, implementation and installation of Imaging, Batch Processing and Data Capture systems, using Datacap software products.
- Developed a custom Database Query Tool usingOLE Automation ObjectsinVisual Basic5.0, on aSQL Server6.5 back-end.
- UsingTransact SQLlanguage, developedSQL Serverinstallation scripts for the creation of back-end databases for Datacap “Task Master 2000” software.
- Accomplished complex data validations using extensive SQL scripting,VB Scriptand Open Database Connectivity (ODBC).
Consultant,ConfidentialMalvern, PA 19355Dec 1996 – Feb 1998
- Developed various reporting applications using GUI tools and provided system support on client site.
- Developed a multi-user, company-wide Weekly Status Reporting application usingAccess’97.
- AcquiredMicrosoft CertificationinAccess Application Development.
- As aTeam Leader, coordinated a team of up to four consultants. Demonstrated excellent technical and communication skills.
Programmer/Analyst,ConfidentialHavertown, PA 19083Mar 1995 - Nov 1996
- Analyzed, designed and implemented client/server applications. Full life-cycle project development for several business applications like Inventory Control system, Invoicing application.
- Developed aRelational Databasesystem for a Shipping and Air Freight business, in aClient/Serverenvironment, integrating Electronic Data Interchange (EDI). Front-end:Access(2.0), Back-end:SQL Server(4.21), later upgraded to version (6.5).
- Developed databases on SQL Server, handled administration and security and fine-tuned the server parameters and settings.
- Demonstrated the detail-oriented, self-driven nature and the ability to work independently.
Trainee Project Engineer ConfidentialSep 1990 Apr 1991
- Hardware design and Assembly Language programming for Intel 8051 Microprocessor based Telemetering System Simulator, a hand-held equipment used to test the transmitters and receivers.