Objective

Seeking a position in a challenging environment that will allow me to contribute to the success of an Organization by utilizing my software analysis/design/implementation/support and administration skills.

• Over 14 years of experience in systems/software industry years with proven success in systems analysis, development, administration and maintenance for various business industries which include Retail, Financial, Telecommunications and Government.
• Experience includes exposure to all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, administration and Maintenance.
• Sound understanding of ORACLE, MS SQLSERVER and IBM DB2 UDB database architectures.
• Extensive experience in ORACLE, SQLSERVER, DB2 UDB databases administration, design, development and implementation.
• Expertise in data migration projects - Migrated data from the Legacy systems. Involved in data mapping, data loading, and coding business rules for migration. Experience in ETL and Data Conversion processes.
• Enriched experience of VLDB and high availability environment; solid understanding of UNIX, AIX and Windows Server 2003/2008 operating systems.
• Experience in providing continuous customer support for the production environment, work on enhancements to the current running production environment.
• Highly motivated self-starter with strong troubleshooting skills, quick learner, good technical, interpersonal skills and an excellent team player.

• Bachelor of Engineering in Electronics and Communications
• Diploma in Client Server Technology

• ORACLE Database, 11g/10/9i/8i/7.x, TOAD, OEM, RMAN, SQLOADER
• MS SQLSERVER 2005/2008, Management Studio, BCP, Redgate Backup
• IBM DB2 UDB V.8.5 - 9.x, Control Centre, Data Studio
• PL/SQL, Pro*C, C, T-SQL, COBOL II
• Unix/Solaris/AIX, Unix Scripting (Korn & Bash)
• Windows NT/2000/XP/2003/2008
• SUN SPARC 64, IBM P Series
• DB Artisan 8.5 , Cygwinx, Winsql, TOAD
• Ascential DataStage 5.2
• Eclipse CVS, Track it, Footprints
• MS Office Suite, Visio, ERWIN

Confidential

Confidential, is a leading gaming technology and services company, providing innovative technology, creative content, and superior service delivery. GTECH is a fully integrated lottery operator and gaming technology solutions provider.

Client: Confidential, Tallahassee, FL
Position: SR.OPERATIONS DBA / SR.SYSTEMS ANALYST

Projects/Applications Supporting:

• Lead the Operations Database team in supporting the day to day gaming operations for the Florida Lottery on 24/7 support.
• Responsible for designing, planning implementing and maintaining DB2/ORACLE/SQLSERVER databases, including security, access and documentation. Provided technical assistance in identifying, evaluating, and developing systems and procedures as they relate to databases.
• Providing critical data requests for top level management by creating required scripts and queries.
• Perform daily Database Maintenance tasks -- Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Developed and implemented a maintenance strategy and maintenance scripts relating to backup and recoveries of databases.
• Implemented robust Release Management process and performed assigned database release actions. Assisted engineers/developers in planning efforts associated with projects and releases.
• Implemented industry standard Audit Management processes and procedures and performed assigned actions to capture audit evidence criteria.
• Responsible for data integrity and user security. Perform physical database design, database space needs and growth analysis, and future disk need analysis.
• Implemented and tested off-site Disaster Recovery planning and testing.
• Ensured that customers' concerns or service level incidents are addressed promptly and efficiently by delegating to the appropriate DBAs, personally troubleshooting and implementing solutions or escalating to the appropriate member of management or third tier resources.
• Demonstrated a relentless commitment to meeting and exceeding customers' expectations while also achieving the goal of reducing the risks and costs of providing services.
• Trained, mentored and coached all assigned database administrator.
• Participated in individual professional development by completing assigned development plan and in mentoring activities, tracking and reporting of development, and communicating career path goals and objectives.

Linux, AIX, Windows 2003/2008, IBM DB2 UDB, SQLSERVER 2005/2008, ORACLE ,Sqlserver Management Studio, DB2 Control Centre, OEM, DB Artisan, TOAD, Winsql, IBM Data Studio.

Confidential, Tallahassee, FL

The Agency for Workforce Innovation is Florida's lead state workforce agency and directly administers the state's Labor Market Statistics program, Unemployment Compensation, Early Learning and various workforce development programs. The Office of Early Learning, a division within the agency, provides oversight of Florida's school readiness programs and is the lead entity for implementing the state's successful Voluntary Prekindergarten program.

Workforce development policy and guidance in Florida is provided by Workforce Florida, Inc. Workforce Florida, Inc. and the Agency for Workforce Innovation are partners in the Employ Florida network which includes 24 Regional Workforce Boards who deliver services through nearly 90 One-Stop Career Centers around the state.

Position: DBA - Data Services

Projects/Applications Support:

One Stop Service Tracking - ORACLE 11.2
One Stop Information Management - ORACLE 11.2
Early Learning - ORACLE 10.2, MS SQLSERVER 2005/2008
Unemployment Compensation - MS SQLSERVER 2005/2008
Appeals - IBM DB2 UDB 9.x
EIS - IBM DB2 UDB 9.x
Star - IBM DB2 UDB 9.x

• Perform day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Supporting production databases, data warehouse databases, development and testing databases for the above application groups that are built in SQLSERVER, ORACLE and DB2 UDB.
• Performed installation of Database software products and database creation and upgrade. Applied critical patches as per the release schedule.
• Responsible for data integrity and user security. Perform physical database design, database space needs and growth analysis, and future disk need analysis.
• Implemented backup and recovery strategies for production databases using the native, Red gate Backup tools for SQLSERVER, RMAN tools for ORACLE and native backup for DB2 UDB.
• Participate in planning and implementation of off-site Disaster Recovery planning and testing.
• Monitor databases for performance and tune accordingly.
• Implemented new database features which include Clustering, replication, duplication and Dataguard using physical Standby databases.
• Assisting and advising the developers in tuning SQL code for better performances.
• Lead a team of developers in development of interface programs/scripts. Involved in Data Analysis and Mapping of the data fields between the multiple systems.
• Designed and developed New Batch Architecture for the interfaces and batch jobs to enable scheduling, logging and error handling. Built shell scripts, scheduler jobs to execute the batch jobs and monitor.
• Production Support includes - User Interaction, identify the problem area, Bug fixing, Enhancements, Providing critical data requests for top level management and 24/7 support.

Solaris, AIX, Windows 2003/2008,SQLSERVER 2005/2008,Oracle 11g/10g/9i/8i, IBM DB2 UDB 9.x, Sqlserver Management Studio, DB2 Control Centre, OEM, DB Artisan, TOAD, SQL*Loader, Oracle DataStage 5.2, Control Centre, IBM Data Studio.

Confidential, is a leading provider of securities information services and asset, wealth, trading and risk management software solutions to the North American and International financial community.

Position: Systems Analyst - Team Lead

Project Description

OASIS is Financial System built on Oracle Database that constitutes various financial service modules, which include, Securities Information Services, Pricing Services, Bond Services, Security Alert Services and Security Master which is one of the most comprehensive Security Master Database in North America. The security master database contains up to 250 data elements per security. This System caters to financial needs of the clients all over North America.

• Leading a team of programmers in the Design, Development and Implementation of the Financial Application on Oracle application platform utilizing various Oracle Application Development Tools.
• Strong command of the whole Software Development Lifecycle process (SDLC). Participated in all phases of a project including prototyping, project management, requirements analysis and functional specification writing, testing, implementation and technical support.
• Worked with the needs of the end user in order to provide an efficient workable solution through structure systems and business analysis approaches.
• Produced feasibility studies, software specifications end user documentation and software documentation to address the company's business needs.
• Prepared detailed flow charts and diagrams outlining system capabilities and processes.
• Designed and implemented integrated hardware and software computer and information systems to meet the needs of the organization.
• Provided advanced troubleshooting and maintenance assistance to ensure the ongoing availability of the company's computing solutions.
• Performed installation of Oracle software products and database creation and upgrade. Applied critical patches as per the release schedule.
• Responsible for data integrity and user security. Perform physical database design, database space needs and growth analysis, and future disk need analysis.
• Monitor databases for performance and tune accordingly.
• Developed stored procedures, database triggers, functions and packages using PL/SQL. Extensive use of Collections, utility files and SQL loader utility.
• Tuned PL/SQL modules and SQL Scripts for cost based optimizer mode using EXPLAIN PLAN. Used appropriate hints in SQL queries to enhance the performance.
• Involved in planning, conversion, testing and migration of PL/SQL modules, SQL scripts and PRO*C programs for database migration from Oracle8i to Oracle10g.
• Very strong Financial Market knowledge involving security master, stock and bond markets, pricing methods and related valuation services.

Windows 2003, UNIX, Linux, Oracle 8.i-10g, OEM, RMAN, TTS, SQL, PL/SQL, Pro*C, TOAD, Oracle Forms 6i, Oracle Reports 6i/10g, SQL*Loader, Oracle 9iAS, Erwin 4.0, Visio.

Confidential, Montreal, Canada.August 1998 to March 2000

Confidential, a division of Confidential, markets and distributes print and electronic yellow pages products. It manages clientele advertisers across Canada and a customer database of listings available in print media

Position: Programmer Analyst.

Analysis, design and development of White Pages, Yellow Pages and National Sales Systems.

• Involved in planning, conversion and migration of Legacy Program modules on mainframe environment to ORACLE client server technology.
• Successfully converted the required data into the redesigned Sales database using PL/SQL procedures/functions/packages, database triggers.
• Involved in performance tuning at the scripts level using EXPLAIN PLAN.
• Monitored and tuned the Server, SQL Queries and the application
• Involved in Automation and scheduling of batch jobs.
• Involved in design and development of database schemas and objects.
• Wrote several PL/SQL, triggers, functions and stored procedures and performance tuned the existing PL/SQL code. Extensive use of PL/SQL Tables.
• Extensive use of Materialized views and External tables.
• Production Support includes - User Interaction, identify the problem area, Bug fixing, Enhancements, Providing critical data requests for top level management.

Project Technologies

Windows NT, UNIX, MVS, Oracle 8i, SQL, PL/SQL, DB2, COBOL, JCL, SQL*Loader.Data Software Research Company Ltd. June 1996 to August1997

Position: Software Engineer.

Developed Inventory Development Tracking System, using Oracle database. This application keeps track of Daily movement of route vehicles, rental costs, and equipment. Availability of vehicles, and details of customers.

• Involved in training new recruits joining the company in programming languages and software.
• Developed front-end GUI screens using Oracle*Forms 4.5 and Oracle Developer/2000
• Inventory and reorder reports were generated using Oracle*Reports 2.5.
• This system was developed in Windows NT using Oracle 7.2.3
• Created and modified front end GUI.
• Involved in the redesign of the existing database.

Oracle 7.0, Windows, UNIX, Oracle Developer, Oracle Reports, SQL, PL/SQL.