Michael R. Hansen

Randolph, N.J.

mike.hansenm@gmail.com (862)-222-3865


Sybase SME with strong systems/applications skills and extensive experience with a wide range of operating systems (MVS/Unix/VM/Win), databases, languages, and software tools. Strong communication and analytical skills with a sharp focus on quality of detail. Exceptional task manager with a keen sense of determining effective task prioritization. Professionally certified product knowledge with a variety of tools.


Top of Form

SUMMARY:


Sybase SME

- Analysis, performance tuning and support of Sybase SQL and stored procedures

- Design, implementation, and support of numerous FACETS data environments using SQL extract, load, and/or replication

- Sybase DBA providing daily database support and administration including data loading, security, capacity planning and backup/recovery

- Systems administrator support of IBM’s Guardium (database security) product for Oracle and Sybase dataservers

- Implementation and support of Bradmark’s Surveillance monitor for database servers


Professional Services - Senior Consultant

- Design and delivery of enterprise-wide technology solutions for Sybase clients in mission-critical, fast-paced environments (applications support, heterogeneous data connectivity/administration, replication, client/server code development, product installation, configuration, tuning, and problem determination)

- Sybase DBA providing daily database support and administration including data loading, security, service requests, capacity planning, and backup/recovery

- Sybase instructor for 'Fast Track to Replication Server'.


Technical Program Manager

- Technical program manager for the migration of a European mainframe (MVS) data center to the US

- Technical Lead for designing and implementing a worldwide corporate rollup model of replicating data from nine countries to the US


Call Center Deployment Manager

- Coordinated the implementation of all hardware and software components for a new (ground-up) call center in Hong Kong.


CICS Systems Programmer/Manager

- Directly responsible for the installation and operation of all CICS/DB2 online systems deployed to (11) U.S. Army and Air Force bases throughout the nation.

- Online Systems Manager for a staff of (15) CICS and DB2 systems programmers.

- Team member responsible for the functionality of (110) CICS/Plex production, QA, and DEV regions utilizing DB2, VTAM, LU62, autoinstall, journalling, and RDO.

SKILL SET:


Professional Certifications:

Sybase IQ Administrator, Sybase Replication Server Administrator, Sybase Adaptive Server Enterprise Administrator, SAFE Project Manager I


Relational Databases:

Sybase ASE, Microsoft SQL Server, IBM UDB/DB2, MySQL, VSAM, Oracle


Product Knowledge:

In-depth knowledge and application of the following Sybase products:

Replication Server, Heterogeneous Replication Agents and DirectConnects, SQL Remote, ASA, Mirror Activator, IQ, RAP Trading Edition, Data Integration Suite, NetGateway, Integration Orchestrator, RSM, ASE, PowerDesigner.

Non-Sybase product skills: DBArtisan, Omegamon, Intertest, CAFC, TSO/ISPF, Abend-Aid, CICS Playback, Data virtualization/federation, ETL, IBM Guardium (Database security), Bradmark Surveillance


Platforms/OS:

Linux, Sun Solaris, IBM AIX, HP Unix, MVS, VMWare, Windows, VM/SP


Languages:

PHP, Ruby/Rails, Unix shell scripting, Windows batch scripting, C, C++, MF Cobol, Assembler, CICS Command and Macro, REXX


EXPERIENCE:


Barclays Capital Mar 2011 – October 2012

Sybase SME (Contractor)

- Monitored, analyzed, and optimized Sybase TSQL stored procedures and views

- Supported applications staff with TSQL problem analysis and resolution

- Created and maintained statistical reports on baseline performance and enhancements


Keystone Mercy Health Plan Feb 2010 – Jan 2011

Sybase SME (Contractor)

- Designed, built, and supported numerous synchronized, distributed data, replication environments (development, UAT, SIT, QA, production).

- Developed and implemented Unix shell scripts to monitor for error alerts, performed problem determination and performance monitoring

- Conducted knowledge transfer for onsite DBA staff.

- Implemented, and supported IBM’s Guardium (database security) product and Bradmark’s Surveillance monitor.


Sybase, Inc. Feb 2000 – Jan 2010

Professional Services - Senior Consultant

- Maintaining a year-over-year superior client satisfaction rating, assisted Sybase client companies with the design, implementation, and support of high performance, high availability, consolidated and/or distributed data systems using primarily, ASE, ASA, and Replication Server.

- Utilized Sybase products to exceed client expectations regarding heterogeneous data connectivity, database administration, ETL, data virtualization/federation/integration, and transactional replication of OLTP, DSS, and D/R data within distributed architectures.

- Designed and coded Unix scripts to generate alerts, monitor resources, and handle error recovery

- Compiled client engagement reports, technical documentation, and conducted knowledge transfer.

- Client verticals included financial, insurance, government, pharmaceuticals, entertainment, health, telecom, and industrial sectors. This position required frequent travel to domestic and international clients.

- Conducted middleware client training at customer sites and served as an instructor for 'Fast Track to Replication Server'.


CICS-Related Projects (Contractor) Jul 1998 – Feb 2000

- Technical Project Manager (AT&T) for the online segment of a large scale engineering project utilizing laser scanners, microfilm recorders, and optical disk. Direct responsibility for the installation and operation of all online (CICS) systems deployed to (11) U.S. Army and Air Force bases throughout the nation. Designed and developed a series of EXCP-level (Assembler code) subtasks to improve performance in the process of microfilm recording.

- As Y2K Project Coordinator (UBS), successfully managed the process of migrating all mainframe financial applications from CICS V2 to V4 (Y2K compliant). Worked closely with data center, applications managers, and technicians to develop migration project plans. Allocated resources as necessary, conducted regularly scheduled meetings to track/resolve open issues, and developed detailed timelines for actual migrations.


American International Group, Inc. Feb 1990 – Jul 1998

Manager, Online Systems - AIGDC

- Primary responsibility included managing a staff of (15) CICS and DB2 systems programmers. Prepared departmental budgets, established technical objectives, researched/acquired mainframe software, performed employee performance appraisals, managed additions/reductions in staff, and provided direction for all projects. Also served as Technical Project Manager for the migration of our MVS/CICS mainframe Paris data center to NJ. Duties included the research and development of a technical project plan, regularly scheduled meetings to provide direction for a team of (14) project leaders, interfacing with European management on all aspects, and the execution of several migration simulations to ensure the successful and timely completion of the overall project.

Deployment Manager, Hong Kong Call Center - AIU

- As Deployment Manager for a new Call Center in Hong Kong, worked with project leaders, HK AIG management, and vendors to ensure the timely implementation and operation of all required hardware and software. Coordinated physical site issues, application deployment, and local resource staffing.

Senior Sybase DBA - AIU

- As Technical Project Manager for the worldwide rollout of Sybase Replication Server, responsibilities included the research, installation, testing, maintenance, problem determination, capacity planning, training, and migration of nine countries from a homegrown mainframe upload system to Replication Server. Designed and implemented architectures supporting bi-replication of Sybase and DB2 databases on MVS, NT, and Unix platforms, decision support/portfolio management databases, and warm standby environments. Installed and administered Sybase ASE on Unix and NT. Conducted functional presentations for European and Asian management, developed operational documentation, and performed successful implementations and local training onsite in all countries.

- Technical Lead responsible for the online (CICS, TSO) simulation segment (TPNS) of moving our data center from East Orange to Livingston.