We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume Profile

2.00/5 (Submit Your Rating)

IllinoiS

PROFESSIONAL SUMMARY

  • I am seeking full-time or contractual employment as a senior-level business technical analyst. I am
  • an energetic self-motivated individual with more than 15 years experience in data analytics, data modeling, data warehousing, database applications, report design and business intelligence.
  • I communicate effectively on a 'common ground', with the customer, ensuring concepts and goals are understood and ownership taken. I actively engage Business Partners, Technical Architects, and Specialists to solve business problems providing technical solutions in the implementation of large scale and complex applications.

CAREER HIGHLIGHTS

  • Served as liaison between the business community and IT in defining requirements for the development and maintenance of complex and critical systems.
  • Experienced in Retail and Manufacturing systems utilizing SDLC and Agile methodologies.
  • Facilitated business requirements definition utilizing SQL to perform data analysis, user acceptance testing and quality assurance.
  • Analyzed business operations to determine opportunities to automate processes and functions where applicable.
  • Identified and documented business operational and technical tasks incorporating scope, time constraints, and task dependencies.
  • Delivered organized and understandable presentations to project teams.
  • Lead and motivated the efforts of subordinates and peers, instilling pride in getting the job done right the first time, while providing estimates and plans that were timely and cost effective.
  • Designed and implemented Logistics solutions assisting in the redesign of business processes.
  • Directed the training of both end users and peers in the application of technical solutions to achieve system goals.
  • Developed BI Business Intelligence solutions and ETL support providing web based reporting and dashboard solutions using Micro Strategy on a Teradata platform.
  • Designed functional test specifications, planning the selection of test data as well as criteria.
  • Performed data mining in the definition of meaningful metrics KPI's .
  • Designed and supported innovative and common processes for all aspects of logistics management including MRP.

SKILLS and TECHNOLOGIES

  • BI Business Intelligence Webfocus, Micro Strategy
  • Languages SQL, SQL ASSISTANT, MySQL, COBOL, CICS, IMS, DB2, JCL, SQL, MQ-Series, EZTRIEVE, TELON, HTML, JAVA SCRIPT, PHP
  • ETL IBI I-Way Data
  • Databases Teradata, MySql, DB2, IMS, VSAM, IDMS, Access
  • Mainframe - FILEAID, XPEDITOR, TSO, ISPF, Advanced Query Tool AQT , Z/OS
  • ERP software - Arthur Anderson - MACPAC, Xantel - AMAPS, IBM - COPICS
  • Application packages - INFO - Walker Trilogy - Selling chain
  • PC Software - Visio, Word, Excel, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential

Contact Sr. Business Systems Analyst

Design solutions for business requirements in a commercial environment

  • Gather business requirements and perform data analytics to define technical level requirements in the development, support and quality assurance QA of reporting used to monitor the impact realization of cancellations in relation to sales to achieve the prioritization of ROI.
  • Developed BRD's, wireframes, and model requirements to support report development in a Micro Strategy environment using Teradata DB. Provide solutions to both business users and developers to improve the profitability of Sears and its relations to their customers.
  • Created the test plans to support the business requirements. In an agile environment, worked closely with developers to define testing criteria and create test data that would exercise requirements. Validated test results to create UAT signoff

Confidential

Seller of repairable vehicles, parts, cars and trucks, recovered-theft and rental vehicles.

Contract Sr. Business Technical Analyst

  • Defined and documented supporting infrastructure for BI, business intelligence transitions.
  • Documented Business Rules and Requirements utilized in a Business Objects environment to insure the quality of transition to a Microsoft SQL Server platform.
  • Using SQL as a basis point, analyzed the data and its interpretation used in Business Objects to define the data dictionary to be utilized on a SQL Server platform

Confidential

Contract Sr. Business Technical Analyst

  • On a global data warehouse platform analyzed and facilitated the requirements to define supporting systems for BI, business intelligence.
  • Conducted requirements sessions using in depth interviewing skills to produce concise, clear and complete business requirements in the implementation of price tier strategies.
  • Documented Business Requirements, Use Cases and Test Cases to insure objectives were clearly defined and ownership taken from both a technical and business perspective.
  • Effectively modeled architectural solutions in the application of comparable restaurant sales analysis and reporting. Working in a team environment defined supporting SQL using Teradata for the most expeditious access of data in a BI environment powered by Micro Strategy.

Confidential

15,000 M global corporation specializing in industrial-use products and services in the field of construction, mining equipment, industrial machinery and vehicles.

Contract Business Analyst

  • Coordinated business requirements with IT direction to provide contracted services in business analysis and system design, integrating Komatsu's legacy service parts order entry application for the accommodation of an additional business unit.
  • In an ERP environment, facilitated the analysis of requirements to interface order entry through invoices ultimately generated via SAP.

Confidential

500M global corporation specializing in the sale, distribution and service of specialty maintenance products and chemicals through inside sales and independent field representatives.

Project Lead/Business Analyst

  • Defined the business requirements to manage the centralization of customer master applications in an IBM/DB2 environment. Modeled and designed the DB2 tables in support of customer administration requirements. Gathered the business requirements and objectives to re-engineer sales history analysis. Utilized SQL to provide the most expeditious access to the DB2 sales data warehouse.
  • Integrally responsible for the consolidation of Lawson subsidiaries into a single operating unit. Recognized for the task definitions, and cross-platform solutions in the redefinition of Lawson's financial, customer administration, order entry and sales history applications.
  • Facilitated and documented business requirements in support of purchasing administration and interfaces required for supply / demand analysis.
  • Identified with business users the requirements to correctly identify bills of material BOM for the accurate reporting of usage.
  • Participated in the design of sales, agent and marketing related data warehouses.
  • Resolved discrepancies pertaining to data sources of information and areas of responsibility, significantly reducing multiple versions of the same data and redundant maintenance efforts.
  • Strengthened the Marketing knowledge base with the implementation of BI reporting solutions.

Confidential

Senior Analyst

  • As business analyst/project lead, directed the efforts of the physical inventory team from both a technical and management perspective. Championed and implemented multiple enhancements, which significantly reduced the efforts required to coordinate and execute a multiple plant physical inventory. Directed efforts to support MACPAC ERP control system authored by Arthur Anderson . Responsible for the business requirements definition and the technical tasks required to supported Inventory Management and Accounting systems in an IMS/DB environment. Facilitated training classes in the areas of production and standard costs.
  • Designed web-based interfaces to Trilogy's E-Commerce Selling Chain, utilizing JAVA ASP, and HTML-Dreamweaver. Using IBM's MQ-Series software, programmed and implemented the interfaces required for mainframe support. Directed the design and programming of the Agent Performance Analysis system weighing margins and profitability based on sales analysis.

We'd love your feedback!