Arlene K. M. Hughes

**** ******* ********* ******** **** 43026 Mobile: 937-***-**** or Cell: 626-***-**** Email: Arlenekay1961@yahoo Email: adhcre@r.postjobfree.com

EDUCATION:

Master of Science Degree in Management Information Systems at Embry-Riddle Aeronautical University

Bachelor of Science Degree in Computer Scienc0e at University of Phoenix

EXPERIENCE:

Business Analyst, Professional Business Applications Inc. from 2011 to 2019

Worked for these businesses On a Contract for Parker Hannifin Aerospace (2011), Contract Bank of America BPG (2012-2014), Contract Union Bank of California (2015-2016), Contract San Gabriel Valley Conservation Group (2017), Contract Advantage Solutions Marketing (2018), and Contract Bank of the West (2019).

•Experienced with IBM Cognos components to manage the data design to meet companies’ database requirement. The Performance Management process was maintained by IBM Cognos to Create, Maintain, Analyze, and Extract data from multiple database tables or database files using MS SQL.

•Test results were easily verified by using IBM Cognos Analytics for data accuracy. Used IBM Cognos Analytics for reporting and monitoring the metric of events.

•Cognos toolkit was used to analyze the data before processing the data with Managed file transfer (MFT). Experience utilizing IBM's Cognos Business Intelligence (BI) component to manage electronic transfer of files using secure electronic file transfer.

•Used Cognos Analytics for analyzing and reporting defects data during integration. The Cognos Analytics toolset helped to monitor the data for metric of events.

•Knowledge of standards, best practices, methodologies, and frameworks associated with the insurance/financial/automotive business industry.

•Business Process Management procedures were Agile Scrum and Waterfall methodology across multiple organizations on conversion projects.

•Knowledge and experience with data warehousing and ability to layout a compelling vision of the future Map policy distribution for agency locations, open agency analysis, ad-hoc reporting solution analysis.

•Performed MS SQL programming language with experience in insurance, banking, and aerospace with strong understanding of industry concept advantage. Knowledge of the property and casualty insurance and financial systems.

•Worked with cross-functional teams, to participate and gather document reporting requirements to meet business needs for presentation to Senior Executive Team using the operating system.

•Responsible for gathering, compiling and synthesizing information regarding technology system process by designing, developing and implementing new programs and/or modifications of existing applications.

•Created reports and facilitates data requirements needed to extract and compile data from the data dictionary. Experience utilizing IBM's Cognos Business Intelligence (BI) component to manage electronic transfer of files using secure electronic file transfer.

•Proficient in Microsoft Office Excel, Access, Word, Visio, and Power Point. Knowledge of Microsoft desktop operating systems and All Office products.

System Analyst Supply Chain IT Asset Management Boeing Integrated Defense System

December 2005-December 2010

•Performed Logistic Spare Parts tracking and deliveries, repairs and modifications and supports the MS SQL and DB2 SQL. Performed data analyst functions and familiar with order status while updating Spares Order Entry System. Programmer using Toad for Oracle Database with nearly 20 years of development Offers unmatched functionality to reduce the time to learn, implement and manage new and existing database platforms. Works across the most widely used databases (including RDBMS) to provide a future-ready solution. Elevates the expertise of data professionals through extensive automation and collaboration capabilities.

•Communicates status effectively and creates required project reporting for all appropriate participants. Assists with projects, including documentation, training, and deployment. Supports the development, implementation, and management of Procurement systems and processes to assist in the strategic sourcing of high-quality non-merchandise offerings. Experience with data analysis and data quality.

•Recommends process improvements for potential duplicate assets, misconfigured assets, and retirement of related assets. Understands analytical programs and requirements to prepare data accordingly. Communicates and models the vision and values of the organization to create a proper work environment and sense of teamwork among employees.

•Participates in project or committee meetings as required. Perform Technical documentation skills and ability to present ideas in user-friendly language.

•Analyzes and validates complex system requirements and existing business processes and information systems and Designs, develops and implements new programs and/or modifications of existing applications.

•Designs, codes, tests, debugs, and documents and implements complex software applications according to standards. Defines and develops specifications and programs complex technical modules, applications, prototypes and computer programs.

•Assists in leading all aspects of applications programming and development including file design, update, storage and retrieval. Evaluates and provides technical solutions to complex application development problems.

•Relational SQL Server database management system (RDBMS) structure, design criteria, capabilities, and limitations with SQL Server. Performed SQL Server database Requirements, for database Modeling, SQL Server database Analysis, SQL Server SQL queries, Strong problem-solving, organizational and decision-making skills.

•Resolve Part and Inventory Project to data to the permit Government Parts inspection processes for shipping The Foreign Military Sale requests required to be inspected with US Department of State to ship out of USA to Saudi Arabia Military Air Force.

•SME and Focal point for SharePoint Warp Drive and Dashboard for exception reports/error messages.

•Analyst for Technical Support for SQL Server database for Supply Support department by performing database modeling seven new SQL Server tables and ETL Governance Compliance data files loaded data base at Boeing in Philadelphia for part deliveries, repairs and modifications. Experienced with ETL files governance compliance, risk and assessment.

•Experience with ETL Governance Compliance, Business Analytics, Risk Assessment and the Governance Compliance processes of Data Integration Framework. Perform software development principles and methods for design, development, testing and implementation.

•Added an indexing process and KSDS key to parts pricing SQL Server database file, to run faster reports for management to forecast supplier management parts prices for the budget.

•Created the data dictionary using TOAD for Oracle database GUI tool, to enhance performance adding the index and key to the Database Table.

•Data and index files are managed Oracle Database Server 10g/11gi/12c (ODBC, OAD, and OLAP "Server-managed files"). Oracle Expertise in Relational database and SQL skills.

•Performed Oracle data modeling for Oracle table space and merged multiple table data files to create views load tables. Oracle Expertise in Relational database and SQL skills.

Senior Programmer Analyst - AAA Auto Club of Southern California October 1996 — December 2005

•Experienced Programmer with technical support and on call responsibilities by performing research, analyze problem description, and interpreting technical support for governance compliance with department of insurance, and risk assessment.

•Good teamwork and interpersonal skills. Ability to work well within a team environment as well as individually. Experience in Payment processing especially credit card and Financial systems is preferred. Relational Database Management Systems (DB2) CICS Mainframe Programming Languages (COBOL II), and other new technologies as they are deployed within the IT organization.

•Good verbal and written communications skills. Good ability to express complex technical concepts in terms less technical people can understand. Good analytical and problem-solving skills.

•Experience working with a production problem ticketing system to support our end users, providing troubleshooting, training, and hardware replacements as needed.

•Knowledge of Relational Databases and relational database management system (RDBMS) for SQL Server database experience with data virtualization tools. Programming duties and System Analysis on mainframe Back-end and/or client/server business application Front-end.

•Maintain batch files and logon scripts for end users. Perform, implement, and maintain regular maintenance and testing on all equipment, ensuring everything in working order for end users.

•Prepare detailed specifications for innovative programs and Perform modification using SQL Server SQL programming s to existing database table programs.

•Design, code, test and debug programs using SQL Server SQL programming then Participate in development of proposals including cost/benefit analysis.

•Provide maintenance, customer assistance, and documentation. Experience with business application systems and projects Monitor implementation of changes from estimates to design, development, testing and install.

•Analyze production problems with 24/7 on call duties to assess the situations and determine the source and resolution by reviewing data error findings then correct the data and suggests recommendations with direct report to resolve production problem permanently.

•Utilize documentation, scheduling, debugging standard software tools and technical support experience. Proficient with Windows accounts on Desktop PC’s, laptops, printers, copiers, and support technical new techniques for testing and debugging.

•Analyze user service requests and develop an approach to satisfying the business requirement.

•Notify direct report of production problems and recommend actions to resolve problems.

•Participate in the documentation of current system process and propose enhancement of Business System Application either for new development or maintenance.

•Experienced in Relational SQL Server Database Management Systems (DB2 and SQL Server MS SQL), Mainframe Programming Languages, Information Engineering Facility (IEF), Client/Server application technologies (Visual Basic, Composer, SAS, JAVA script, etc.), and Vendor Application Packages.

Contact this candidate