Database Technical Resume Profile

PROFILE

An IT Professional with broad multi-platform experience specializing in Application Development, Data Architecture and Database Administration. Designed and implemented a variety of mainframe, client/server and J2EE application and database systems for major corporations and government agencies. An analytic and strategic thinker experienced with the full System development Lifecycle who has also served in project lead, technical lead, technical support and training roles. Also a Certified Sybase Professional, DB2 Administrator and Certified IBM Senior IT Architect. Areas of Expertise include:

Application/Data Architecture and Design	Data Warehousing, Data Migration
Relational Data Modeling	Database Change Control and Testing
Physical Database Design/Implementation	Technology Assessment, Roadmaps
Database and SQL Performance Tuning	Technical Team Leadership

TECHNICAL EXPERTISE

Data Modeling with Erwin, application development using Rational software toolset, WebSphere	Windows, AIX, Linux, z/OS operating systems
DB2, Oracle, Sybase DBMS	Shell scripting
Database Monitoring and Performance Tools	DataStage ETL tool
IBM zSeries, pSeries, Intel Server Hardware	Microsoft Office, Outlook, SharePoint, Lotus Notes

PROFESSIONAL EXPERIENCE

Confidential

DB2 Database Administrator, Data Architect

Installed, configured and administered DB2 LUW database servers on Redhat v6 for NY Health Exchange development, test and production database environments. Implemented database administration guidelines, security and privacy requirements HIPPA, PHI , High Availability Disaster Recovery HADR , and provided production support for ongoing maintenance, problem resolution and data management issues.
Designed and implemented Data Architecture for NY State Oversight Cognos reporting framework.
Conducted analysis and performance tuning of problem SQL queries, batch processes and DB2 database configurations.

Confidential

Certified Senior IT Architect

Conducted WebSphere web application and database architectural assessments to develop enterprise system implementation strategies for various commercial IBM Internal, Health Plan Services and NY State government Tax and Finance, Division of Budget clients.
Designed and implemented Data Architectures for database modernization, data migration and data warehousing projects.
Designed and implemented data access modules for mainframe and J2EE/SOA business applications.
Conducted analysis of mainframe legacy application assets for MetLife and UPS using Rational Asset Analyzer RAA . Analyzed these assets to report on key metrics as input to a legacy modernization project to re-build these systems on a J2EE/SOA enterprise application platform.

Confidential

Developed logical and physical relational data models using ERwin for DB2, Oracle and Sybase DBMS's.
Developed DB2, Transact-SQL and PL/SQL stored procedures/functions for mainframe and J2EE application data access layer modules.
Specified database server hardware and software stack components.
Conducted tuning of database servers and poorly performing SQL queries.
Developed data modeling standards and database object change control procedures.

Confidential

Database Technical Consultant

Provided onsite technical support for PeopleSoft application DB2 database related problems for State Farm Insurance. Debugged database performance problems with DB2/UDB Sybase platforms.
Setup DB2 database and PeopleTools 7.52 server environments for a benchmark test of a DB2/AIX platform at an IBM testing facility for Montgomery Ward's. Improved database performance and transaction rates for critical batch program processes numbering millions of transactions per day.
Tuned and debugged PeopleSoft Financials application on a DB2/MVS platform for Wendy's Restaurants.

Confidential

Senior Consultant

Project Lead for database design, development administration of strategic PowerBuilder/Sybase health care applications for sales force automation and policy rate quote generation systems at Kaiser Permanente.
Lead developer of a PowerBuilder/Sybase interactive network and circuit monitoring software product for EMI Communications. Developed stored procedures and batch processes for data capture from frame relay switches. This application was so widely accepted that EMI decided to market it to their network customers.
Developed a decision support system for the Sybase Worldwide Professional Services Education staff.
Lead DBA for a PowerBuilder/Sybase radio equipment inventory and work order tracking system for Niagara Mohawk. The system supported 100 users across seven regions in Upstate New York. Responsible for business area analysis, logical data model and physical database design using ERwin, Sybase SQL Server configuration, coding of stored procedures and triggers, server resource allocation and performance.
Lead database designer and Sybase DBA for the Insurance Compliance System at NY State Worker's Compensation Board.

Confidential

Senior Consultant, Technical Team Lead

Developed a technology migration strategy and application delivery standards to support the General Electric financial systems modernization project.
Technical Lead for team of 10 developers in conversion of batch and online GE corporate accounting systems.
Performed programming tasks to convert Honeywell system applications to IBM MVS mainframe platform. Utilized a conversion methodology developed in-house for design and development of each system. Converted programs to CICS, COBOL, CSP, DB2 and FOCUS languages.
Project lead in developing a corporate-wide General Ledger and Accounts Payable system using CICS, CSP and DB2.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship