Guru.com Profile - cmadsen
Find this profile here: http://www.guru.com/freelancers/Web-Developer-Website-Designer-Email-Design-SEO/Florida/Melbourne-Titusville-Palm-Bay/705190
User Information

Screen name:cmadsen
Profile ID:705190
Tagline:The professional has not entered a tagline.
Screen icon:
Membership:Basic Member
Photograph:No images have been uploaded.
Country:United States
GMT:
Overview

Category rank: in Websites & Ecommerce
Quality score:0.00
Feedback:None
Money (year):$0.00
Money (all time):$0.00
Min. rate/hour:$28.00
Min. project budget:Not specified
Member since:07 Jul 2006
Last sign In:02 Dec 2007 10:47 AM ET
Quotes submitted:0 in last 30 days
Work onsite:Yes
Experience:Not available
Highest degree:Bachelor's Degree
Software skills:Not available
Additional skills:Program in PHP and Transact SQL using MYSQL, SYBASE and MSSQL
Subcategories:Web Development
Web Design
Email Design
Search Engine Optimization
Industries:Consumer Goods & Services
Education
Government
Technology & Internet
Professional Services
Highlights:SUMMARY:

A dynamic database administrator/developer with a strong record of achievement, combing skills in diverse areas of legacy database migration, database modeling and design, stored procedure and trigger development, database version migration, database performance and tuning, and EDI record transfers and database reporting. A total of thirty-seven years in the MIS industry, with 15 years senior consulting positions which have included full life cycle development of database-driven applications and troubleshooting existing databases and applications. Excellent trainer and mentor. Solid work experience with UNIX and Microsoft environments and systems analysis work involving database schema and system implementation.

TECHNICAL SKILLS:

Databases: Sybase ASE 4.9 through 12.5 on UNIX Solaris and HP platforms. MS SQL Server 6.5.
7.0 and 2003
Hardware: HP-UX, Sun Solaris, Windows (Dell, Compaq)
Software: Sybase Replication Server 11.5, MS Windows 3.1, 3.11, 95, 98, 2000, NT 3.51, 4.0,
2000, XP, Vista. UNIX, MQ Series, Reflections, Power Designer, Erwin, DBArtisan, Crystal Reports, MS Access, MS Excel, Erisco Facets, RapidSQL, SQL Advantage, PVCS Manager, PVCS Tracker.
Languages: Visual Basic, Perl, HTML, Unix Shell scripting, Transact SQL

CARRER HISTORY AND SELECT ACHIEVMENTS

CitiStreet, Jacksonville, FL. (Oct 2006 to present) Sybase and MSSQL Developer
. Responsible for maintenance on thousands of stored procedures. This maintenance was on event and calculator store procedures requiring changes initiated by the customer requirements.

Independent Consulting, Titusville, FL. (May 2005 Oct 2006) Web site design
Using HTML and PHP along with MySQL and Sybase developing company websites. Developing Sybase databases including installing, designing, writing stored procedures and triggers.

Tampa Electric, Tampa, FL. (September 2004 to April 2005) Sybase Developer.
Convert the company's stored procedures from Sybase to DB2 database. I converted over 1200 stored procedures and triggers for this migration.

Navigant International, Sterling, VA (March 2004 - August 2004) Sybase DBA/MSSQL/developer
 Responsible for overall operation and administration of the production, test and development Sybase and MSSQL servers on a 24X7 schedule. Create reports from both database servers using crystal reports. Select data from servers to be exported to Excel reports.
 Develop Perl scripts for running management and financial reports.
 Install Sybase IQ server in test environment for management evaluation.
 Develop SQL stored procedures and triggers as needed
Environment: Sybase ASE 12.0 Sybase IQ 12.0, MSSQL server, Windows XP, SQL Advantage, Sybase Central,
Perl, Transact SQL, Reflections, Solaris

UNISYS, Crystal City, VA (October 2003 - March 2004)
Lead Database Analysis
 Moderated meetings between customers, developers and DBA's to insure project was on track.
 Worked with customers to identify business rules in the application software and databases.
 Identified problems with application software where business rules where inconsistent.
 Worked in a group of seventeen analyses to develop solutions to application and database problems.
 Responsible for cleaning up bad data in databases.
 Responsible for peer reviewing all stored procedures written by developers.
 Resolved problems between development, test and production.
 Responsible for development and coding of an archive system for daily transactions on 14 Sybase servers to an IQ data warehouse.
 Designed and developed archiving IQ databases.
Environment: Sybase ASE 12.5, Sybase IQ, Windows 2000, PVCS, SQL Advantage, Solaris,
Perl, Transact SQL

SYBASE, Dublin, CA (November 2002 - October 2003)
Sybase DBA
Client: Keystone Mercy Health Plan (January - August 2003)
 Responsibility included studying HIPAA requirements and converting the requirements to client's policies and procedures.
 Evaluated HIPAA EDI files and mapped to Facets database for HIPAA 270/271 and 278 file transfers.
 Resolved problems with EDI input files and validating data in the database.
 Converted data from the legacy system (HSII) into FACETS (Sybase database), development of Interfaces whose purpose is to send/receive data from different providers into and out of FACETS database and develop the reporting applications using Crystal Reports. Successfully completed the project in time.
 Responsibility included studying the client requirement, converting the requirements into High Level Design, Detail design using Erwin for data modeling and Coding.
 Interfaces were developed in vendor specific formats and involved daily updates of the Facets tables.
 Added, changed and terminated records as well as full extracts sent on a monthly or fortnightly basis.
 Implemented integration internal developed programs and Facets batch programs.
 Problem resolution with Facet batch including batch recovery.
 Worked on batch conversion process of providers, members and claims from legacy system.
 Designed, coded and implemented custom reporting solutions.
 Wrote stored procedures and Crystal Reports for Facets. All work completed on schedule and fully documented
Environment: Sybase ASE 12.5, Windows 2000, RapidSQL, Crystal Reports, Perl, Transact SQL,
HP-UX


Client: Arizona Republic Newspaper (November 2002 - January 2003)
 Responsible for performance tuning on Sybase database.
Environment: Sybase ASE 12.0, Unix, XML, Perl

ATT WIRELESS, Allen, TX (Dec 2000 - November 2002)
Sybase DBA
 Duties included administering both production and development Sybase servers..
 Required to write UNIX shell scripts for nightly batch jobs.
 Wrote stored procedures as needed to extract data for in-house reports.
 Wrote triggers to enhance the integrity of the database.
 Used Power Designer PDM diagrams to create the databases for development.
 Previewed all stored procedures from developers to optimize and tune the procedures.
 Tuned the databases for optimum performance.
 On call for the production servers 24 X 7.
 Created and tuned indexes on the tables to improve performance, created nightly maintenance on the databases and instituted daily and weekly backups.
 Worked closely with the Sybase IQ DBA's to insure they were receiving timely data.
Environment: Sybase ASE 12.0, Windows 2000, RapidSQL, Perl, Korn shell, Transact SQL, HP-
UX

FedEx, Orlando, FL (Oct 2000 - November 2000)
Senior Tester
 Created Scripts in Unix K shell to load test data into Sybase database.
 Created Perl scripts to test data and load data
 Work with software application testers to determine is results obtain were valid
Environment: Sybase ASE 12.0, Windows 98, UNIX, Perl, Korn shell, Transact SQL,

ATT WIRELESS, Allen, TX (Dec 2000 - November 2002)
Sybase DBA/developer
 Worked with developers to define business rules within the application software and databases.
 Duties included administering both production and development Sybase servers.
 Installed Sybase replication server, Tested, and put into production.
 Required to write UNIX shell scripts for nightly batch jobs.
 Lead a team to move the data center from Dallas to Allen, TX
 Wrote stored procedures as needed to extract data for in-house reports.
 Wrote triggers to enhance the integrity of the database.
 Worked closely with the development team and management to develop the front end and also the logical and physical design of the database.
 Used Power Designer PDM diagrams to create the databases for development.
 Previewed all stored procedures from developers to optimize and tune the procedures.
 Tuned the databases for optimum performance.
 On call for the production servers 24 X 7.
 Created and tuned indexes on the tables to improve performance, created nightly maintenance on the databases and instituted daily and weekly backups.
 Upgraded all of our Sybase servers from 11.5 to 12.0
 Part of the team, responsible for writing a disaster recover plan. All the databases were
on HP L and N class servers.
Environment: Sybase ASE 12.0, Windows 2000, RapidSQL, Perl, Korn shell, Transact SQL, HP-
UX

LOCKHEED MARTIN, Manasses, VA (August 1998 - April 2000)
Sybase DBA/developer
 Maintained a classified 654G database used by the Department of Defense.
 Worked closely with the customer and the developers on the logical and physical design of the database.
 Responsible for reverse engineering the database using Erwin and wrote a series of manuals for this system. These manuals included mapping of the EDI streams, entity relationships between the tables, a users manual, troubleshooting manual, and data dictionary for the database.
 Worked closely with the replication DBA's. Data supplied was replicated to four physical sites. Also mentored the developers with stored procedures and triggers.
 Viewed all the stored procedures and triggers before tested in the development database.
 Tuned database for performance using sp_sysmon and dbcc utilities. Government used Sun ES1000 servers.
Environment: Sybase ASE 11.5, , Windows 98, Perl Transact SQL, RapidSQL, HP-UX


EDUCATION:
Florida Institute of Technology, Melbourne, FL. Business Management
Work terms:The professional has not written profile Work Terms.