Project Manager Engineer
Resume:
Michael R. Hansen
Randolph, N.J. 07869
Senior level, professional services consultant with strong customer
interaction skills and a proven track record of ensuring high client
satisfaction. Very broad exposure and hands-on experience with a wide range
of operating systems and products. In-depth (Sybase professionally
certified) product knowledge to support pre-sales through technical
presentations, product demonstrations, and proof-of-concepts. Extensive
experience in designing, delivering, and supporting exceptional technical
solutions built around heterogeneous data consolidation/distribution.
SUMMARY:
Sybase Performance Engineer
. Analysis and optimization of Sybase TSQL stored procedures and ASE
servers
Professional Services - Senior Consultant
. Design and delivery of enterprise-wide technology solutions and
training for domestic and international Sybase clients
Solutions Architect
. Design, implementation, and support of numerous distributed data
environments to facilitate corporate rollup, consolidated reporting,
and disaster recovery (using Sybase ASE and Replication Server)
. Implementation and support of IBM's Guardium (database security)
product and Bradmark's Surveillance monitor
Technical Project Manager
. Technical project manager for the migration of a European mainframe
data center to the US (17 direct reports)
. Technical Lead for designing and implementing a worldwide corporate
rollup model of data (using Sybase ASE and Replication Server) from
nine countries to the US
SKILL SET:
Professional Certifications:
- Sybase IQ Administrator
- Sybase Replication Server Administrator
- Sybase Adaptive Server Enterprise Administrator
- SAFE Project Manager I
Relational Databases:
- Sybase Adaptive Server Enterprise (15.x, 12.x) 12 years
- iAnywhere mobile Adaptive Server Anywhere 2 years
- Microsoft SQL Server 1 year
- IBM UDB/DB2 1 year
- Oracle 1 year
- MySQL 1 year
Product Knowledge:
In-depth knowledge and application of the following Sybase products:
- Replication Server (15.x, 12.x, 11.x) 12 years
- Heterogeneous RepAgents and DirectConnects 10 years
- Mirror Activator 2 years
- IQ (15.x, 12.x) 4 years
- OpenSwitch 6 years
- RAP Trading Edition 1 year
- Data Integration Suite 1 year
- Integration Orchestrator 1 year
- PowerDesigner 1 year
- MainframeConnect/OpenServerConnect 6 years
- DB-Lib/CT-Lib/RPC coding 2 years
Non-Sybase product skills:
- Data virtualization/federation 1 year
- IBM Guardium (Database security) 1 year
- Bradmark Surveillance 1 year
Platforms/OS:
- Linux 6 years
- Sun Solaris 7 years
- IBM AIX 5 years
- HP Unix 7 years
- VMWare 1 year
- Windows 20+ years
Languages:
- Ruby, Rails, MySQL 1 year
- Unix shell scripting 5 years
- T-SQL/Stored Procedure development 2 years
- C, C++ 1 year
- Mainframe Cobol and CICS Command/Macro 6 years
EXPERIENCE:
International Investment Bank Mar 2011 - Present
Sybase Performance Engineer (Contractor)
. Monitored, analyzed, and optimized Sybase TSQL stored procedures and
views
. Identified and analyzed database object lock waits/contention and
improved performance via index modification and lock schemes
. Created and maintained statistical reports on baseline performance and
enhancements
Keystone Mercy Health Plan Feb 2010 - Jan 2011
Solutions Architect (Contractor)
. Designed, built, and supported numerous synchronized and distributed data
environments (development, UAT, SIT, QA, production).
. Utilized the latest product features of Sybase Replication Server to
consistently maintain synchronized FACETS data among OLTP, DSS, and
D/R databases.
. Implemented scripted monitoring for error alerts, performed problem
determination and performance monitoring of ASE and Replication
servers
. Conducted knowledge transfer for onsite DBA staff.
. Also planned, 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 (marts).
. Utilized Sybase products to exceed client expectations regarding
heterogeneous data connectivity, ETL, data
virtualization/federation/integration, and transactional replication
of OLTP, DSS, and D/R data within distributed architectures.
. Implemented remote/consolidated iAnywhere ASA replication and product
upgrades
. Designed and implemented bi-replication configurations between Oracle,
MSSQL, UDB, ASA, OS/390, and ASE
. Managed client expectations with respect to issues regarding product
scalability, reliability, and performance optimization
. 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.
Polarsoft Limited - Boulder, Co. 1999 - 2000
Principal Consultant
. Successfully delivered middleware-based solutions for all Polarsoft
client companies.
. Assisted Polarsoft clients with data/information architectural design,
product/systems integration, problem determination,
performance/tuning, and administration of enterprise-wide data
access/data movement products.
. Installed, configured, and administered the following Sybase products
on multiple platforms: Replication Server, RepAgent for MVS CICS/DB2,
DirectConnects, Mainframe Connect, Open Server Connect.
. Conducted middleware client training at customer sites and served as a
Sybase instructor for 'Fast Track to Replication Server'. This
position required frequent travel to clients based throughout the U.S.
Contact this candidate