We provide IT Staff Augmentation Services!

Senior Systems Analyst Resume

Dayton, OH

OBJECTIVE

  • Currently a consultant and owner of Confidential Inc., me is seeking opportunities where me can work with a variety of clients in different business domains to help leverage technology to suit their business needs.
  • me has extensive experience in teh areas of customer relationship management (CRM), business applications, business intelligence, data management and reporting. With my education and experience, me is able to manage, architect, design, develop, and implement solutions using a variety of product suites and platforms for a broad range of business domains.
  • me enjoy working in teams with clients and other resources (including internal resources, vendors, etc.) in a highly collaborative, interactive manner. me has a very diverse skillset and thrive on taking ownership of projects to apply technology in order to enhance business efficiency and foster growth.
  • me also has worked for or consulted with a variety of companies ranging from startups to multi - billion-dollar organizations and government.
AREAS OF EXPERTISE
  • Architected and implemented data consolidation/business intelligence solutions in SugarCRM for a variety of businesses hosted online and/or in house.
  • Advised clients and staff on teh implementation and evolution of their CRM solutions to suit client business needs.
  • 18 years of CRM development, data integration, reporting, implementation, training, and support expertise (8 years SugarCRM and 15 years SalesLogix).
  • Over 26 years of data integration and reporting using Talend, Microsoft SQL Server (including SSIS and SLX Profiler), Crystal Reports, and SugarCRM’s Report Maker/Advanced Reports.
  • Sold, architected and implemented a nation-wide, highly customized, bilingual CRM/Grants-Contribution Management solution for Confidential of Canada (NRC) including a data warehouse.
  • Implemented a web application in PHP, Drupal, and MYSQL to manage quality control data in “teh Cloud”.
  • Implemented a software product to enable dynamic forms and reports to be created on any environment (Mac, PC, web, mobile) using one code base using PHP, MYSQL, HTML5, jQuery, javascript and jqPlot
  • Managed teh DealerKid Enterprise CRM (based on SalesLogix) for teh Automotive Industry) and associated staff.
  • Developed and implemented a revolutionary online automotive sales application allowing consumers to purchase vehicles online.
  • Managed, designed, developed, implemented, trained and maintained customer tracking software for automotive dealerships.
  • Managed, designed, developed, implemented, and maintained trading systems for teh front, mid, and back office to assist with financial trade management and market analysis involving Crude and Light Products.
  • Designed, developed, implemented, and trained users and administrators on a security documentation system for a foreign nation.
  • Received teh “Most Service-Oriented” award as voted on by peers at IRAP.
  • Certified SalesLogix CRM Application Developer and CRM Administrator
  • Certified Client/Server Systems Professional by Learning Tree International

PROFESSIONAL EXPERIENCE

Principle Owner/President

Confidential

Responsibilities:

  • Migration/transformation of data between SugarCRM and other systems including Ramquest, Resware, SAP, Salesforce.com, SalesLogix, and Act using Talend, SSIS and via Scheduled jobs managed in SugarCRM.
  • Business/system analysis for several systems in business domains including telecommunications, finance, automotive, medical, etc.
  • Data management expert for SugarCRM.
  • Designed, developed and implemented SugarCRM solutions in a variety of business domains PHP, MYSQL, MS SQL Server, Oracle, HTML, jQuery, javascript, REST, SOAP as well as several W-System applications for web users and mobile users.
  • Designed, developed and implemented a software product to enable dynamic forms and reports to be created on any environment (Mac, PC, web, mobile) using one code base using PHP, MYSQL, HTML5, jQuery, javascript and jqPlot.
  • Implemented a web application in PHP, Drupal, and MYSQL to manage quality control data in “teh Cloud”.
  • Designed, developed, and implemented a repair tracking solution using MS-Access, SQL Server 2000, and MySQL. This was also reengineered in PHP, JQuery and MYSQL.
  • Implemented, administered and supported SalesLogix solutions (4.0-8.0) for clients in a variety of business domains including pharmaceuticals, government, automotive, distribution, and information technology.
  • Developed a bi-directional interface between SalesLogix and QuoteWerks.
  • Analyzed teh request for proposal (RFP), worked with teh NewSys sales team, architected/implemented a sales prototype, create project plans, and demonstrated teh solution to IRAP (contract award was $1 million).
  • Actively participated in pre-sales activities (including proposal writing, demonstrations, prototyping, etc.).
  • Sold, architected, developed, implemented, supported, and trained users on Sonar, which is a highly customized, nation-wide, bilingual CRM solution (using SalesLogix for Sales) for Confidential of Canada.
  • Implemented a web-based solution for a non-government agency using SQL Server 2000, VB.Net and ASP.Net.
  • Implemented a resource management and scheduling application for a non-for-profit translation agency using MS Access.
  • Participated in several meetings with clients to best apply teh solution to streamline their business processes.

Senior Systems Analyst

Confidential

Responsibilities:

  • Architected, designed, developed, and implemented Sonar, which is a highly customized, nation-wide, bilingual CRM/Grants-Contribution Management solution (using SalesLogix for Sales 4 - 7.5, Microsoft SQL Server, SSIS 2008, and Crystal Reports) for Confidential of Canada.
  • Architected and implemented teh database design, teh data warehouse and reporting solution to reconcile data between Sonar and other external systems (including SAP) on a monthly basis.
  • Integrated NRC systems with IRAP's Sonar solution.
  • Designed, developed, and implemented a bilingual web application using teh Common Look and Feel (CLF) standards which interfaces to Sonar using ASP 3.0, ASP.Net 2.0, SQL Server 2000-5, VB, and SalesLogix).
  • Created user and management reports for users of Sonar using Crystal Reports and MS Access.
  • Analyzed client requirements in order to implement solutions to suit teh business need.
  • Captured, managed, and analyzed user requirements related to IRAP's business needs mostly related to CRM and Grants-Contribution Management.
  • Completed a SANS Web Security Application Workshop.
  • Developed solutions in Peregrine Service Center to apply teh product and ITIL’s framework.

Director of Development

Confidential, Dayton, OH

Responsibilities:

  • Designed, developed, and implemented an online vehicle sales application using ASP.Net 2.0-3.5, C#, AJAX, javascript, SQL Server 2005, Visual Source Safe, Service Objects, Neo Speech and Haptek.
  • Created virtual characters to be used by teh application to offer assistance to teh consumers.
  • Created virtual character demonstrations which used real-time data feeds to deliver live CNN news during a trade show using Haptek and Neo Speech as well as a custom Text-To-Speech (TTS) interface.
  • Assisted with teh development of teh Confidential corporate website.

Field Implementation Manager

Confidential, Cincinnati, Ohio

Responsibilities:

  • Managed teh DealerKid Enterprise CRM Product and associated staff.
  • Modified and managed teh development of software components for ADIS’ customer management product (called DealerKid) using Visual Basic 6.0 and Windows NT 4.0, MS Exchange 5.5, MS Outlook 97 and 98, Crystal Reports 7.0, MS SQL Server 6.5 and 7.0, MS Access 8.0, and MS Word 8.0.
  • Implemented DealerKid in automotive dealerships and demonstrated DealerKid to prospective clients.
  • Trained users and administrators on DealerKid and on teh associated management reports.
  • Created management reports for DealerKid using MS Access 8.0 and Crystal Reports 7.0.
  • Performed business analysis and acquired new requirements from clients to enhance DealerKid.
  • Managed teh design, development, and integration of DealerKid components and stored procedures.

Information Systems Analyst

Confidential, Wichita, Kansas

Responsibilities:

  • Designed, developed, and maintained Market Analysis Applications to assist with teh analysis of teh production of Crude and other refined products using MS Access 2.0, 7.0, 8.0, Visual Interdev 1 and MS SQL Server 6.5.
  • Migrated an application used for market analysis from MS Access 2.0 to MS Access 8.0 and SQL Server 6.5.
  • Supervised and participated in teh development and maintenance of Mid Office and Back Office Applications.
  • Designed, developed, maintained, and managed software to assist with P/L and position analysis and management, and daily earnings at risk reporting (using MS Access 2.0 and Sybase System 10).
  • Designed developed, and implemented a Contract Tracking Application to help manage Crude Contacts.
  • Designed, developed, implemented and managed interfaces between accounting and trade management systems.
  • Designed, developed, and implemented an application used to assess all teh MS Access Applications used in Supply and Trading in terms of Year 2000 compliance (using MS Access 2.0, 7.0, and 8.0).

Programmer/Analyst

Confidential

Responsibilities:

  • Worked on a development team to design, develop, implement on a multi-lingual security document system for a foreign country (using Oracle 7.3, Visual Basic 3.0, and Crystal Reports 4.5).
  • Trained users and administrators on teh security document system at teh client location in Confidential, Confidential .
  • Demonstrated teh security document system for officials of foreign countries.

Consultant

Confidential, Cincinnati, Ohio

Responsibilities:

  • Modified software components of Confidential Capital’s Purchasing Accounting Reporting Information System (PARIS) using Visual Basic 3.0 on a Windows 95 platform.
  • Created and modified reports integrated in teh PARIS application using Crystal Reports 4.5.
  • Modified software components of PARIS to enhance future portability to different backend RDBMS software.
  • Modified software components for Confidential Capital to process consumer credit card applications.

Consultant

Confidential

Responsibilities:

  • Tuning and optimizing software for teh QAIS (Quality Assurance Information System) using Visual Basic 3.0, MS SQL Server 4.21, and Crystal Reports 3.0.
  • Created and modified stored procedures as to enhance system performance over a LAN and WAN.

Database Analyst

Confidential

Responsibilities:

  • Performing data analysis to review data engineering related contractor outputs (eg. Data and object models, etc.)
  • Reviewing teh design and development of teh Data Dictionary (to be used in CAATS).
  • Developing software to assist in project management and data analysis using MS Access 2.0 and Oracle 7.0.
  • Providing LAN and software support to CAATS Project Office Staff.

Hire Now