Senior Business Systems Analyst
Results-driven systems engineer with a proven track record of delivering multiple comprehensive IT projects to a high standard; seeking an opportunity to leverage my extensive experience with and knowledge of SQL, Relational Database Design, Production Support, Project Leadership, and Business Continuity Planning. Thrives in fast paced environments requiring strong problem-solving skills.
SQL PL/SQL COBOL/SCOBOL PATHWAY TACL PROGNOSIS OLTP RDF BATCHCOM ORACLE MQ
Business System Analyst
Relational Database Design
Training & Development
EXPERIENCE & ACHIEVEMENTS
WELLS FARGO 2001 – 2018
Senior Systems Engineer
Provide support for SQL infrastructure which includes programming, installation, monitoring, tuning and troubleshooting issues in a high availability environment. Optimize database performance, database upgrades, and/or migrations. SQL Performance tuning and capacity planning/management. Perform business analysis. gather requirements, perform analysis, and document disaster recovery procedures for Wholesale Data Systems. Manage and support planned failover activities; maintain and support backup and recovery documentation and procedures. Expertly oversee database architecture, development and maintenance are properly executed, ensuring systems run at peak performance with no issues. Provide 24x7 production support.
Business/Disaster Recovery Analyst
Assist in deployment and configuration of remote system. Implement database replication software and establish procedures for data recovery.
Perform Business Impact Analysis. Work with internal/external customers to define RTO/RTP. Gather requirements, needs and schedules from customers, vendors and internal development teams.
Work with internal auditors and management to insure regulatory and compliance requirements.
Spearheaded the development and implementation of Business Continuity Plan for Wholesale Systems and applications.
Manage semi-annual failover exercises. Work with customers to insure failover exercises are completed successfully. Conduct meetings before and after exercises to address concerns or issues.
Document disaster recovery plan within the LDRPS (Living Disaster Recovery Planning System).
Certified Business Continuity Administrator (BCA).
Certified SCRUM/Agile Fundamentals.
Proficient with MS Office tools.
Support software release cycles and Wave installations through product life cycles (SDLC).
Work with development teams to gather requirements for database changes.
Execute duties as SQL Database Administrator for Tandem Wholesale Systems; adeptly performed data loads and ETL as part of the Tandem to Oracle migration.
Hands on development skills using SQL, PL/SQL for stored procedures, triggers, and periodic (day/month end) processes.
Perform Relational Database Modeling and create logical database design and Entity Relationship Diagrams (ERD).
Create physical database tables, views indexes.
Review SQL statements with development team to insure optimal execution plans.
Review and modify SQL execution plans on complex queries.
Perform database tuning and capacity planning.
Develop ad-hoc queries to identify and resolve application/database issues.
Develop programs for database archiving and cleanup.
Migrated existing flat-file structure database to a relational SQL database that exceeded performance and response times; successfully migrated hardware and application to new platform and tuned the system and database for optimal performance.
INDEPENDENT CONTRACTOR 1990 – 2001
Freelance Systems Engineer
Independent Contractor working as Technical Leader/Manager, Architect and SQL Database Administrator for several different organizations located in the Bay Area.
Appointed Lead architect and project lead at Chevron to design and implement their new manufacturing system as well as manage a team of contractors throughout life of project.
Lead designer and database administrator at San Jose School District; designed and implemented system that maintained data regarding student attendance.
Designed and implemented San Jose Real Estate Board’s new Multiple Listing Service system.
TANDEM COMPUTERS 1980 – 1990
Designer/Developer for Tandem’s Order Entry System
Technical Project Leader for development and rollout of Tandem’s Remote Duplicate Database (RDF) facility. Developed and taught training course and performed marketing presentations to customers, resulting in millions of dollars of sales worldwide.
Technical Sales Analyst – Assisted sales team with technical evaluations, system planning, operational audits, software requirements and sales.
Bachelor of Science, Computer Information Systems, Arizona State University, Tempe, AZ
Scrum Fundamentals Certified (SFC)