Systems Analyst Business

STEVE W. SIMMONS

***** *** **** *****, *********, Ca. 92504

Email: *****@******.*** / Cell: 323-***-****

https://www.linkedin.com/in/steve-simmons-b144872b4

PROFESSIONAL SUMMARY

Looking for an Information Technology role where I can utilize my Project Management and Analytical Skills as a Business Systems Analyst, Project Manager, or Database Administrator.

TECHNICAL SKILLS

Experienced with Microsoft SQL Server, T-SQL, SSRS Report Server, SSIS, Microsoft Dynamics AX, Microsoft Dynamics CRM, Excel, MS Word, Windows IIS Server and Active Directory. MySql, MySql Workbench, TFS, Perl, Linux, HTML, XML, CSS, .Net 4.5, Visual Studios, Visual Basic, Visual C++, C#, PL/SQL, Java, Python, JSON, Jupyter, GitHub open source, Oracle Developer, and Sharepoint Designer.

PROFESSIONAL EXPERIENCE

Business Systems Analyst/Data Analyst, Simmons & Simmons LLC, Inc. 06/2021 – Current

Developed SQL and python queries for data mining and statistical analysis of complex consumer data to support marketing, data mapping, and advertisement endeavors.

Supported Oracle Financials ERP modules, including GL, AP, AR, FA

Conducted data mining to analyze patterns in timeline data and created charts/graphs for data visualization.

Used IBM Watson AI to show the Impact delivery of target advertisement to millions of customers to increase revenue, updated GitHub Chabot modules and webhooks for IBM Watson API connection.

Created a data driven prediction model for consumer behavior based on timeline data.

Conduct data analysis of the Marketing Department business requirements.

Contract Business Systems Analyst, AT&T Entertainment Group 02/2018 – 02/2019

Conduct data analysis of the Marketing and Finance Department business requirements.

Analyzed projects to identify gaps in the Billing/Finance system using Sharepoint Developer.

Created workflow diagrams and tested User-Defined functions as per the business requirements.

Interfaced with Change Management to implement new scripts into production.

Created Oracle SQL scripts and PL/SQL using financial/accounting and reporting tools.

Modified SQL scripts for the Marketing Departments Visa Cards, Gift Cards, and Fox/NFL Sports Sales.

Developed SQL queries using Teradata to support Engineering, Finance, and Marketing Initiatives.

Processed ETL Jobs using SQL Developer, C# scripts, JSON, UNIX, OpenVMS, and Teradata.

Proactively research issues and worked with impacted teams to determine the source of error issues.

Analyzed and troubleshot complex problems using SQL Server, Teradata, JSON, and Oracle Developer.

Utilized Sharepoint Designer for the creation of libraries, groups and workflows to document the approval. of different user request types as well as managing website appearance, groups and user permissions.

Contract Systems Analyst / SQL Developer, Union Bank 06/2017 – 08/2017

Conducted data analysis of the Savings DDA/NOW system.

Gathered business requirements and system requirements as per user requests.

Set up regression test regions, system processes, and Posted project updates to Sharepoint.

I wrote test plans, created test scripts, data mapping, and updated system documentation.

Analyzed COBOL and Assembler programs for the Savings DDA system and documented.

Contract SQL Database Administrator / Lake Havasu City 10/2016 – 12/2016

Installed Windows Server 2012 Clustering Services.

Set up High Availability/Always-On Availability Server Groups.

Configured group policies, Data Services and updated the Active Directory.

Installed new instances of SQL Server, SSRS, SSIS, and test server applications.

Set up project plans, gathered requirements, created Business Requirement Documentations.

Interfaced with Change Management to install updates for Issues management.

I wrote test plans, created test scripts and Worked with Windows Server 2012.

Contract Business Systems Analyst, American Federation of Musicians 08/2016 – 10/2016

Created Monthly Billing reports on Microsoft Access system.

Generated Customer Statements and Musicians reports using Microsoft Access.

Processed email mailers, updated application documentation, addressed Issues log, and resolved Alerts.

Troubleshoot email problems and MS Access monthly statement problems.

Uploaded new information and changes to American Federation of Musicians website.

Contract Business Systems Analyst, American Apparel 02/2016 – 07/2016

Supported the Microsoft Dynamics AX 4.0 System, Wholesale Marketing, and Retail Sales Force system

Updated the Active Directory by adding new employees and giving user access rights to employees.

Ran Microsoft Dynamics AX system for customer sales, Warehouse distribution, and was on-call 24/7.

Resolved problems with Wholesale/Retail invoices, Supply Chain, and issued customer refunds.

Provided support to the High Jump WMS Shipping System and Oracle Pro9 Retail System.

Updated the Barcomm (Label Printing Server), fixed RFID Scanners, and warehouse cameras.

Ran the Store Force application for labor scheduling, task management, employee time, and attendance.

Conducted analysis of business requirements, resolved Return Item Issues, and EDI business documents.

Contract Business Systems Analyst, Wells Fargo Capital Finance 06/2014 – 04/2015

Installed new versions of Microsoft Dynamics CRM, Informatics, Citrix, and JIRA/Bamboo applications.

Tested changes to Core banking applications, configured group policies, and data mapping of interfaces.

Created Lab platform of Core banking applications, Flow Charts, SQL queries, and Documentation.

Configured SSL certificates, applied updates to the Lab test platform.

Created the project plan, implementation plan, and post conversion support plan.

Performed User Acceptance testing, created Issues Management log, created test data and SQL scripts.

Implemented changes to current production software with current methodologies of Lab platform.

Supported disaster recovery testing and development on the banks production system.

Systems Analyst / MySql DBA, Sandswebs Consulting 02/2008 – May 2014

Installed new versions of Drupal, Joomla, MySql, Zend Cart, SQL Server, Linux, and Apache server.

Designed Drupal PHP5 templates using GitHub modules.

Setup LAMP Domain and web hosting for clients,

Installed IIS Server, created database backup, Server Replication, and installed PHP web site tools.

Created and loaded MySql databases using API interfaces from Excel CSV files and phpMyAdmin.

Did search engine marketing using Google AdWords, Google AdSense, and Google Analytics.

Created Facebook APPS, SEO Metatags, and processed SEO web site submissions

Business Systems Analyst/SQL DBA, Volt Delta Information Sciences 04/2007 – 02/2008

Automated the monthly billing process with SQL Server and Excel spread sheets to be SOX compliant.

Optimized and enhanced the stored procedures, tables, and queries.

Created SQL Stored Procedures, T-SQL Scripts, SQL Queries, Triggers, Views, Data mapping, Database Tables, DTS jobs, recorded macros, and setup server processing scheduler.

Integrated Excel spread Sheets with SQL Server and visual basic to provide real time data.

Created ETL programs written in Perl to load the SQL Server tables.

Provided Visio Flowcharts, data structure analysis and updated Documentation.

Performed database replication and executed backup/restore jobs.

Contract Systems Analyst/Project Manager, Liberty Mutual 03/2005 – 05/2005

Applied updates to the Project Charter for the Personal Lines Underwriting System.

Converted the current system from Fair Isaac (FICO) to AION.

Provided High Level Analysis of ETL interfaces, Estimates, Project Charter, and Gathered Requirements.

Formulated project approaches, provide technical analysis, Application Flow Charts, User interfacing,

Provided Issues Management log, test plans, wrote test scripts, and managed project implementations.

Documented reports of the Personal Lines Underwriting System applications.

Created SQL Queries, MySql database backups, server replication, and excel spread sheets.

Contract Team Leader, Citizens Bank / Fidelity Information Services 09/2004 – 12/2004

Supported Core banking applications of the Charter One Bank Acquisition project involving the Multiple Branding Conversion to Citizens Bank.

Gathered change Requirements, create Flow Charts, set up GN Parameters.

Did User Acceptance Testing and create SDLC technical Documentation for the Shaw Commercial Loans, Leasing, Lending, and Alltel Collections applications.

Provided support for ALS Real Estate, FIS DDA, Combined Statements, and FIS GN Architecture.

Translated Business Requirement Documents into Technical Specifications and Setup the Data Dictionary, Data Warehouse, System Controls, and added new on-line transactions.

Consultant/Software Engineer / Wellpoint-Bluecross 09/2003 – 11/2003

Contract: September 2003 - November 2003

Supported Change Management with Changeman on the HIPAA project.

Created Cobol Batch Application to Examine Changeman packages and determine if a problem exists prior to moving 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, Toyota Financial Services / TATA 09/2002 – 03/2003

Coordinated change KEAN Services to TATA Consulting Services, trained new employees, and provided support to financial services.

Responsibilities were to Process daily Applications, Perform System maintenance and set up IIS Server,

Performed User Acceptance Testing, implemented Data Quality rules and Data Profiling.

Supported Systems Development Life Cycle (SDLC) including testing, updates and production migration.

Created a testing environment to test scripts for production support to the SHAW Retail Lending system.

Created automation test plans for metrics reporting, Visio Flowcharts, updated the system documentation.

Functional and Technical documentation, investigate production platform software application issues, and Provided 24/7 Production Support.

Applications responsible for were Dealer Reserve, Chargeback, Branch Transfer, Application Tracking, Billing Statements, PeopleSoft G/L interface, Lockbox transmissions, Material Distribution WMS payment processing.

Software involved Expediter, Changeman, IMS DB/DC, DB2, SQL/SPUFI, OS/390, TSO, SAR, RUMBA,, JCL, COBOL, JES2, CA1, SAS, VSAM, JCL, MVS/ESA, TSO/ISPF, Visio, File-aid, DYL280, SAR, XML, Visual Basic, Microsoft Project, TCP/IP, NIKU, MS Access, MS SQL, J2EE, HTML, and Oracle PL/SQL.

EDUCATION

Coursera IBM Watson AI, Online classes

Courses on Generative Artificial Intelligence, Prompt Engineering, Python for Data Science, AI & Development,

Building AI Powered Chatbots, Developing AI Applications with Python and Flask, Building AI Applications

With IBM Watson APIs, ChatGPT Prompts and Stable Diffusion.

ITT Technical Institute, Torrance, CA.

Classes on Visual C++, Visual Basic, HTML, Windows Server, Networking, Math, MS Access, Algebra, Trigonometry, English Composition, TCP/IP, PC Hardware, User Interface Design, Business Data Communications, Relational data base structures, data structure design, and Computer Network Technology.

Computer Learning Center, Los Angeles, CA.

Classes included COBOL, Assembler, RPG 11, Computer Operations, DOS/JCL, OS/JCL, VSAM, ASCII, Management, and Systems Programming.

Contact this candidate