Contract Systems Analyst
2014 - 2015
Wells Fargo Capital Finance
Contract Systems Analyst Installed Microsoft Software, Documented all applications, and Tested several applications using SQL Server 2005, and 2012. Configured system environment for Test, Development, Lab, and Quality Assurance. Writing new documentation(BRD) based on lab testing, formulated project approaches, Technical Analysis, Application Diagrams, System Charts, User interface testing, Issues Management, test plans, and test scripts. SQL query and documentation skills. Installed Team Foundation Server(TFS) environment on IIS 7 Server, Upgraded the(JIRA) platform to release and with current Agile software development methodologies. Worked with Share point, Microsoft Dynamics 2013, Informatica 9.51, LAMP, Microsoft Office 2010, Windows Power Shell, Windows Server 2008R2, SSRS Report Server, Active Directory, Windows SSL, and Windows IIS Server 7.5.
Contract Programmer/mysql Dba
Feb 2008 - May 2014
Sandswebs Independent Consulting
Contract Programmer/MySql DBA Installed new versions of Drupal 7.9, Joomla 1.6, MySQL 5.1. 5, Zend Cart, SQL Server 2005, Linux, and Apache 2.2. 4 server. Designed Drupal PHP5 templates using Fusion and Skinr modules. Used Visual Studio 2005 for ASP.NET testing. Coordinated PHP release updates and setup Microsoft WebMatrix. Converted Zen Cart PHP5 applications to accept Amazon API. Setup LAMP Domain and web hosting for clients, Setup IIS Server, created database backup and replication, installed PHP5 web site tools. Created and loaded MySQL databases using data from Excel CSV files and phpMyAdmin. Did search, marketing using Google Adwords, Adsense, and analytics. Created Facebook APPS, SEO Metatags, and SEO web site submissions. Some clients were Oceanmist1.com Vacation Rentals, the City of Santa Clarita Valley, sanddhairimports.com, and fulltimediva.com.
Business Analyst/SQL DBA
Sep 2006 - Jan 2007
Volt Information Sciences
Responsibilities were to automate the monthly billing process with SQL Server 2000/2005 and MS Excel to be SOX compliant. Created SQL Stored Procedures, Database Tables, DTS jobs, recorded macros, and scheduled processing, Created SQL Queries, Setup Scheduler, created T-SQL Scripts, and Visio Flowcharts. Configured Excel spread Sheets to connect to SQL Server 2000/2005. Created ETL programs in Perl to load the SQL server. Provided data base programming, scripting, data structure analysis, SQL query and documentation. Also did database backup and replication. Setup IIS Server Net Framework 2.0 internet sharing using ASP.NET, Sharepoint, Crystal reports, PHP5, MySql, Visual Basic, C++, FrontPage 2003, and Excel 2003. Perfect Peace Church Part-time Systems Analyst Setup Windows 2000 Server, MySql, xampp-control, installed DSL, Installed Hardware, TCP/IP, Printers, Network, and Cat-5 cables. Held training Classes on Internet and Web design. Software included Microsoft Visual Studio 8, Microsoft Word, Excel, Front Page 2002, MS Access, and Macromedia Flash MX. Also helped them with math and English homework as well as answering computer related questions.
Contract Systems Analyst/DB2 Dba
Sep 2005 - Jan 2006
Farmers Insurance/Computer Science Corporation
Contract Systems Analyst/DB2 DBA Created source code for the Flex pay AR System using COBOL, CICS, JCL, Agile, Expediter, MS Project, Visio, IBM DB2, SQL, MySQL, Java J2EE, ASP.NET, Sharepoint Endeavor, Telon, VSAM, and TSO/ISPF. This project was to create a new product called the Flex pay System. Updated DB2 tables modified the Accounts Receivables ETL interfaces for upstream and downstream processes. Created SQL queries using DB2 tables, did High Level Analysis of the application interfaces, worked with the Business System Analysts to get the Business Requirement Documentations(BRD's) and then translate them to Technical Specifications. Also gathered requirements, created Visio flow charts, and did technical analysis using database tools. Managed Issues logs, UAT interfacing, and created FDD Documentation for the Flex pay System.
Systems Analyst/project Manager
Mar 2005 - May 2005
Liberty Mutual/National Engineering
Systems Analyst/Project Manager Responsibilities were to create the Project Charter for the Personal Lines Underwriting System using MySql, C++, HTML, ASP.Net, VB-script, MS Access, COBOL, Expediter, AION, SQL, Endevor, Extreme, Telon, Rational Clearcase, Documerge, Winrunner, Loadrunner, Test Director, Visio, Java J2EE, MS Project, AS400, and TSO/ISPF. This project was to convert the current system from Fair Isaac(FICO) to AION. Primary duties were to provide High Level Analysis of ETL interfaces, Estimates, Project Charter, Gather Requirements, formulated project approaches, provide Technical analysis, Application Flow Charts, User interfacing, Issues Management, test plans, write test scripts, and manage small project implementations. Documented reports the Personal Lines Underwriting System applications. Created SQL Queries, MySQL database backup and replication from Excel CSV files.
Team Leader/software Engineer-Contract
Sep 2004 - Dec 2004
Fidelity Information Services/Citizens Bank
Team Leader/Software Engineer-Contract programmer Responsibilities were to support the Charter One Bank Acquisition project involving the Multiple Branding Conversion to Citizens Bank. Duties were to Gathered Requirements, create Flow Charts, do User Acceptance Testing, and create SDLC technical Documentation for Shaw Commercial Loans and Alltel Collections applications. Also I Provided Production Support to Fidelity ALS, Combined Statements, GN Architecture, API/RPI's, and PARMS. Worked with Business System Analysts to get the Business Requirement Documentations(BRD) then translated them into Technical Specifications. Setup Data Dictionary, Data Warehouse, System Controls, and added new on-line transactions. Remote access to network system was VPN through Novell. Software involved was OS/390, TCP/IP, Endevor, Excel, Visio, CA-7, COBOL, MVS, File-Aid, VSAM, TSO, JCL, CICS/TS 3.1, Attachmate/Extra, Novell Client, and Windows 2003 Server.
Sep 2003 - Nov 2003
Wellpoint/Bluecross Systems/Deloitte Consulting
Consultant/Software Engineer Supported QA Change Management by working with Changeman on the HIPAA project. Created Cobol Batch Application to Examine Changeman packages and determine if a problem exists prior to move into production. Created file transfer programs to upload and download data/reports from the mainframe to server. Created test cases and Excel spread sheets of QA projects, release Issues Management, Defect Management, and Install dates. Software involved was Changeman, J2EE, HTML, DHTML, Excel, MySql, COBOL, File-Aid, VSAM, TSO, JCL, Extra, and Windows 2003.
Team Leader/software Engineer-Contract
Oct 2002 - Mar 2003
Toyota Financial Services/TCS
Team Leader/Software Engineer-Contract programmer Responsibilities were in maintenance, Setup IIS Server, User Acceptance Testing, implementation of Data Quality rules and Data Profiling. Supported Systems Development Life Cycle(SDLC), including testing and production migration. Created test environment, test scripts, and production support for the SHAW Retail Lending system. Created automation test plans, writing test scripts, documenting and metrics reporting, Functional and Technical documentation, Investigate production platform software application issues, and Provid ed 24/7 Production Support. Applications responsible for were Dealer Reserve, Chargeback, Branch Transfer, Application Tracking, Billing Statements, PeopleSoft G/L interface and documentation, Lockbox transmissions, Material Distribution, and payment processing. Software involved Expediter, Changeman, IMS DB/DC, QMF, DB2, SQL/SPUFI, OS/390, TSO, SAR, RUMBA, JCL, COBOL, JES2, CA1, SAS, VSAM, JCL, MVS/ESA, TSO/ISPF, File-aid, DYL280, SAR, XML, Visual Basic, Project experience Networking, TCP/IP, NIKU, MS Access, SQL, J2EE, HTML, PL/SQL and Windows 2003.
Jun 2001 - Oct 2001
Software Engineer/Analyst Responsibilities were to update the Derived Scoring Process system with new PL/1 subroutines for