SUMMARY

Database Management and Administration / Enterprise Data Systems

A Career of 15+ years of Expertise in Network Systems and Data Management

A system professional with advanced technical and business management skills evolved during a 11+ years of IT career comprising over 8 years of extensive DBA experience with leadership qualification and hands - on expertise in information technology. The A team player with excellent interpersonal communication skills; one who thrives on achieving the desired bottom-line for the business while feeding on today’s diverse technologies and becoming an asset to the company.

& Platforms HP-UX 11.0 in Superdome environment, Windows 2000, Windows NT 4.0, Windows 2003, 2008, 2008R2, ESX 3.5, 4, 4i, 4.1i, Hyper-V

Languages SQL, PLSQL, Stored Procedures

Database Systems Oracle 8i, 9i and 10G, 11G MS SQL Server 6.5, 7.0, 2000,2005.2008, 2008R2

Application Systems PeopleSoft - HR/FIN 8.4, Retek, Manugistic’s Logistics, JDA IKB, Tequila’s Retail Lease, Glovia, Workbrain, Manugistic’s Lgistics, DC replenishment, Account4, Remedy, Driscoll’s Reconnect, ER Win, Plan View, Workbrain, Protvity Sarbanes Oxley, ANSO (Radioshack web poral for stores), Radioshack.com application, SumTotal (learning managemet application) and numerous home grown client/server and web application systems.

Database Design Erwin All Fusion Database Tools OEM, DBA Studio, Toad and SQL Navigator on Oracle. Enterprise Manager on SQL Server., RMAN, HP Data protector. Currently in the process of evaluating Ab initio ETL tool rollout in April 2004.

Work Experience:

Confidential, Chelmsford, MA

Technical Consultant

One of the 27 Technical Consultants in the entire Company, an industry leader in providing the Workforce Management software throughout the World. The job includes new deployments of workforce solutions and upgrade of existing installations.

A typical deployment comprises of h/w & s/w feasibility report, help customer procure hardware, interaction with pre-sales, customer project management team, work with Kronos project management team, development of architecture, providing a deployment plan, work with the customer installation of database, web and Application servers, installation and creation of SQL or Oracle backend, development of backup strategy, DR strategy, trouble shooting issues, development of testing strategy, development of Go-Live plans Here is a list of some of the MSSQL Customers deployments in last 3 years:

1- Univ. of Colorado

2- Disney Stores

3- AT&T

4- City of South Lake

5- City & County of Denver

6- City of Houston

7- Baker Hughes

8- Fossil

9- Nike

10- TJ Maxx

11- Clear Channel

12- Freeman

13- Landry’s

14- La Quinta Inc.

15- IESI

16- Lehigh Hansen

17- Mattel

18- SABRE

19- Texas City ISD

20- Irving ISD

21- Katy ISD

22- Lamar ISD

23- Crowley ISD

24- Birdville ISD

25- RoundRock ISD

26- Northeast ISD (San Antonio, TX)

26- Department of Corrections state of Wyoming

& numerous small MSSQL projects

Note: The list does not include Large Oracle Customers such as Lowes, WholeFoods, etc..

Confidential, Fort Worth, Texas

Database Administrator, Enterprise Data Management

I worked in a team of 5 Oracle, 2 SQL Server and 7 DB2 DBA which maintain well known products like people Soft, Retek - inventory management, Glovia - Accounting software, Account4 – time management, Remedy – problem case management as well as Manugistic – Logistics & Distribution Center Replenishment system on Oracle, JDA’s IKB and Tequila software’s Retail Lease and Avaya’s Explorer on the SQL Server.

Our Team manages more than 6000 weekly jobs scheduled to provide a prompt and up-to-date data across all systems. These jobs were maintained using Tivoli Work Scheduler (TWS), UNIX CRON as well as AUTOSYS. Created custom reports to fit business requirements and maintained seven terra (7) bytes of data alone in the Oracle DBMS by authoring and maintaining shell scripts with embedded PLSQL, SQL. Additionally, I provided expert support for MSSQL to maintain data for the DOT com side of the business.

Key Projects & Achievements:

• LEAD DBA FOR Workbrain implementation: I worked as a lead DBA for the rollout of Workbrain labor scheduling package for 5000 stores comprising up to 55000 employees. The project phase 1 has been rolled out to 600 stores. Remaining store go online in September 2006.
• Implementation of Workbrain time and labor management application project warranted my involvement in the design phase, alpha (50 stores), beta (200 stores) and phase 1 (1000) roll out of the application and finally the 2nd phase, which was the final rollout to rest of 4000 stores.
• As a lead DBA I worked with various business analysts, system analysts and developers to design interface with HR/payroll/Benefits, Sales channel, Store operations and financials systems for the workbrain application databases. The integration involved hooks into People soft HR, Payroll, Benefits and AP databases as well as hooks into RETEK and sales DB2 databases.
• Also worked with Data analyst to logical data model customization and physical data modeling changes.
• I created 6 database environments for the workbrain application. Implemented backup and recovery, replication and maintenance methodology for workbrain databases and most important the SOX compliance procedures and standards.
• Worked directly with workbrain corporation to iron out bugs because Radioshack was one of the first few companies in North America to implement Workbrain time and attendance package.
• Designed and implemented reporting databases and helped configure the application, webservers and reporting servers.
• On my advice after the phase 1 rollout, Management decided to move labor scheduling Oracle databases from Windows to HPUX due to performance and backup and recovery infra structure issues.
• The Workbrain databases are in production for over 1 year without any issues.
• People Soft AR upgrade: Upgraded the database environment from 8.1.6 to 9.2.0.6. Currently working on upgrading the PS Application tools upgrade to 8.9 from 7.6.
• Database upgrade: Earlier this year I have upgraded several Oracle databases from Oracle 9i to 10.0.2.1. At the same time upgraded several SQL server 7.0 and 2000 databases to 2005.
• Also working in lead DBA capacity for the corporation wide rollout of Leaning Management system application rollout for the corporation on SQL Server platform. This is an application package consolidates 3 existing databases on Oracle and SQL server. Alpha roll out to corporate expected on 14 August 2006. Complete rollout will occur in January 2007.
• Upgraded RMAN catalogs database on HPUX to 10G from 9i.
• Developed and implemented RMAN database recovery software using HITACHI SAN.
• Radioshack Canada: Installed, configured SQL server environment for Solomon suite of applications. (now called Microsoft Dynamics). Also, incorporated the merchandising portion of the rollout into RETEK on Oracle.
• Sam’s Club kiosk acquisition: This SQL server/Oracle project was to single handedly move a newest acquisition of Radio shack corporation called Sam’s Club Kiosks (a Cellular phone retailer company ) in less than 2 months. This project involved over 300 GB of databases, 80 sql server databases and 6 Oracle databases. 3 HPUX servers and 36 Windows database servers. Project cost $8 Million.(3/18/05).
• Authored database management, audit and security procedures for Sarbanes-Oxley compliance under corporate governance. (2004)
• Provided up to the minute data for the general ledger (GL) by implementing replication process across different DBMS data sources.(2000)
• Served as lead DBA for some high profile projects like RS On-line – a systems specifically designed to cater the need of our 5000 company stores, Franchised Showcase Convention backend DBMS system for the collection and replenishment of more then $80 million worth. (2001)
• Implemented HP data protector solution for Oracle database on both Windows and UNIX platforms for over 150 instances accounted for 5 TB of space. (2004)
• Implemented HP data protector solution for over 50 instances of SQL server databases across the enterprise accounted for over 400 GB of space.(2004)
• Consolidated three production and nine development Oracle DBMS instances from Windows to UNIX platform.(2003)
• During this down cycle of the economy to save millions in SG&A, by replacing the SQL Backtrack with Oracle’s native RMAN backup system. (2002)
• Currently implementing Affirmative Action Plan application on MSSQL server with collecting employee data from PeopleSoft HR system. (2001, 2002, 2003, 2004)
• Provided capacity planning recommendation as well as performance tuning for Data Warehouse system. (2003)
• Designed and implemented a shell script base process to collect DBMS security information for backup and recovery saving a bundle in third party product cost. (2001)
• Implemented reporting system for Retek (a $20 million project for merchandising and inventory management system) using Oracle Transparent Gateway to DB2. (2002)
• Recently finished implementing Tequila Software’s REAITLEASE management application on SQL 2000. (2003, 2004)
• Implemented in Nov 2003, JDA IKB (INTACTIX knowledge BASE) on SQL Server 2000.
• Upgraded 11 SQL Server 7.0 to SQL Server 2000 which contains 30 databases. (2004)

Confidential, Dallas, Texas

IT Controls Database Administrator

I managed Database Security position to provide support for Oracle DBMS and Oracle Applications support because of IT Controls identified the need to establish an Oracle Sys Admin role only limited to managing database security. The primary function of this position was to manage security for all DBMS that required writing SQL scripts and stored procedures, however on occasions I performed space management as well as SQL tuning for Oracle tests and development systems.

IT Control Administrator

Initially, I was recruited to implement network security and access control management policies as well as procedures for the corporate network. This security management included access control for Windows, UNIX and enterprise DBMS systems to all the way to Mainframe architecture. Additionally, I administered all aspect of the corporate email system using industry proven Microsoft Exchange server.

Key Projects & Achievements:

• Using my network knowledge, I implemented a trouble free connectivity between various front end applications, such as client/server and web-base application, tying back to Windows servers.
• Implemented Business Continuity (disaster/recovery) polices for the corporation.
• Defined and created IT policies and procedures to help manager systems.

Confidential, Plano, Texas

Contractor for EDS Inc I worked as a contractor to provide support for EDS clients like Southernland (7/11) for WAN connectivity across the nation. Frame Relay, ISDN as well as T1 links were used for connecting CISCO 7500 corporate backbone to nation wide 7/11 stores. I served a level 3 support and worked with a team of engineers and reconfigure the corporate backbone so allowing connectivity to all new rollout of Motorola router out to the stores.

Confidential,Dallas, Texas 9

Exchange and Windows Administrator

Compucom is one of the leading names in IT outsourcing companies. I joined for a short period time and managed Microsoft Windows and Exchange server for the corporate.

Confidential, Irving, Texas, 8

LAN Administrator

Recruited at this world-class insurance organization to provide network support for Windows desktop, servers, local area network and as well as hardware maintenance support.

Confidential, Dallas, Texas, 7

Helpdesk Support

I was recruited at the outsourcer to provided helpdesk support for Microsoft Network (MSN), Dell Corporation.