We provide IT Staff Augmentation Services!

Systems/business Analyst Resume Profile

4.00/5 (Submit Your Rating)

CT

RELEVANT SKILLS EXPERIENCE Expert skills in Relational Database Management Systems, Proficient in Excel using advanced functions, pivot tables, V H Look ups, subtotals, etc. Proficient in Access, creating databases, importing and exporting tables between databases, and excel. Querying/action querying, select, make table, and delete queries, . DML DDL Statements. Write functions in VBA to support reports production. PowerPoint, ODBC, OLE, Intermediate Level Oracle SQL PL/SQL, Sequel Server 2008 R2, Sequel Server 2012. Team player and an autonomous producer with a sense of timeliness, accuracy, and the willingness to learn. EXPERIENCE RECORD

Systems/Business Analyst

CONFIDENTIAL

  • Importing large volumes of data using an importer
  • Prepare data in excel for import into sequel server
  • Use existing, and write new macros
  • Exclusion/addition of data in sequel server prior to mailing
  • Use/edit exiting sequel scripts to manipulate data
  • Query/insert data into sequel server
  • Modify and use existing sequel scripts
  • Analyzes information to determine, recommend, and plan for future systems and modifications.
  • Communicate with users and managers for effective system production.
  • Acts to correct situations in quickest method possible.
  • Provides important system points for training and development areas.
  • Develop relevant knowledge and skills.
  • Enter data to store, retrieve and manipulate data analysis of system capabilities and requirements.
  • Train users on new and old system operations.
  • Ensures programming results are meeting the client's requirements based on the client's business needs.
  • Consults with developers and other technology staff to develop understanding of varied and complex business needs supported by the system.
  • Additional duties as assigned.

Sales Reports Coordinator

CONFIDENTIAL

Designed and developed all new/existing reports. Gathered and compiled data, analyzed, and generated reports on the results of all avenues of lead generation, sales, and client communications. Distributed reports per established production schedule. Responded to reports requests as communicated by field office sales management. Developed new reporting methods as either adhoc or production based. Assisted database and reporting manager in administration of NetSuite database as requested. Served as a resource to field office sales management and their contact center management by creating desired reports for their respective markets. Evaluated historical data for use in forecasting and analysis. Generated, scrubbed, and analyzed data for accuracy. Maintained records and databases for lead generation and client communications. Performed other duties as assigned by senior management for data analysis. -

Item Maintenance CONFIDENTIAL

  • Updated vendor prices using ODBC, access, excel and prophet 21 at the backend. Called vendors to verify prices, specifications of items and updated the mainframe database with vendor prices through imports, and resolved invoice discrepancies. CONFIDENTIAL
  • Technical Assistant Created and administered Access databases, updated and maintained the process division database using Microsoft Access, Oracle Discoverer, Visual Basic for Applications, Excel linked to Lotus Notes / Oracle ODBC , to generate daily, weekly ad-hoc worldwide sales reports for personnel at all Stone Webster locations worldwide via email or fax. New input of Customer profile, prospects, etc. Wrote programs in Visual Basic modules to support the running of the reports/applications.
  • Provided creative/logical alternatives for proposal and client deliverable solutions requiring detailed research abilities. Created pivot tables, V H Look ups, querying/action querying Lotus Notes / Oracle with Oracle Discoverer, Access or Excel Performed various functions in the S W main frame Marketing Management Information System MMIS , Contract Initiation and Billing Administration CIBA , and Budget Control System BCS to support Marketing operations. Initiated work orders for expense and labor charges, prepared weekly and monthly work order budget summary reports, and compiled experience lists and project descriptions. CONFIDENTIAL
  • Support Services Assisted with the preparation of proposals. Typing, data entry, e-mailing of files, preparation of experience list, and library maintenance. Performed other functions as indicated by the Manager of Proposals or Database Manager CONFIDENTIAL
  • various temporary assignment utilizing general office skills. Assignments included spreadsheets, typing proposals, correspondence, filing and telemarketing.

We'd love your feedback!