PROFESSIONAL PROFILE:

Exceptional multifaceted Sr. Business/Data Analyst, Project Manager, and MS Access Developer experienced in project implementations and application enhancements. Wide variety of exposure in a host of industries including banking, manufacturing, telecommunications, insurance, transportation, etc. Experienced in application development, software enhancements, system conversions/installations, and financial/project/cost analysis.

SUMMARY:

• Formal education in IT Infrastructure, Systems Analysis and Development, Enterprise Models, Emerging Technologies, Database Fundamentals, Strategic Management, SQL Server 2012 and Project Management, Predictive Business Analytics, SAS Programming, ETL Processes, and MDM (Master Data Management) strategy.
• Participation in IT infrastructure including education in network topology and data processing gaining familiarity in data integrity, big data repositories, data security, ERP systems, CRM systems, SCM systems as well as data mining, modeling, and analysis techniques.
• Knowledge of the SDLC (System Development Life Cycle) both Waterfall and Agile processes emphasizing scope documentation, screen designs, functional and non - functional specifications, Story Cards, Software Operational Qualification’s, etc. which required understanding business process requirements, the impact to the system(s); consequently, performing analyses to determine the system approach and implementation.
• Knowledge of data analytics against SQL Server and Oracle databases via MS Access, MS Excel.
• Performed Data migration, data cleansing, mapping, extraction and loading of disparate legacy systems insuring data integrity and created and documented repeatable ETL process for ERP implementation.
• Primary point of contact in several projects in performing use case analysis with extensive interaction with users and developers requiring thorough knowledge of web-based systems, network intricacies, project management, change management, database management, and client server technology.
• Performed User Acceptance Testing (UAT), Integration Testing, Stress Testing, Regression Testing while developing test matrices, test plans, strategies and scenarios that included the instructions for data input, expected results, actual results. Standardized the test matrices with system job references that detailed the JCL, COBOL, and XML codes, Lotus Notes development, Oracle databases, and text files needed.
• Proficient in the development of detailed and complicated MS ACCESS databases for various entities, which involved writing of database interfaces that produced detailed and accurate reports through the generation of complex SQL queries and macros.
• Creation of graphically detailed PowerPoint presentations for senior management and hosted JAD sessions with project management, business units, unit test coordinators, project planners, and programmers during the project scope phase, conceptual design phase, planning of specific tasks for project members, and implementation of new applications.
• Strong understanding of business process design techniques including flowcharting in Visio, Use Case analysis and testing, UML (Unified Modeling Language) in gathering and documenting requirements.

SKILLS:

• Database Administration
• Project/Change Management
• ETL Process Creation
• SDLC Process - Waterfall and Agile
• JAD Sessions
• Supervision and Consulting
• Detailed Requirement Gathering
• Access/Excel Development
• Training and Customer Support
• ROI/Cost Analysis
• Data Modeling and Mapping
• Oral/Written Communications Skills
• Test and Use Case Development
• SQL Queries
• Technical Writing

TECHNICAL EXPERIENCE:

• MS-WINDOWS XP, VISTA7 yrs.
• GOOGLE CHROME 10 yrs.
• VISIO 3 yr.
• MS INTERNET EXPLORER 15 yrs.
• QUICKBOOKS 7 yrs.
• WEBADI 1 yr.
• APPLOAD 1 yr.
• DATALOADER 1 yr./
• WEBEX /INSTANT MESSAGING) 10 yrs.
• MICROSOFT PROJECT 2 yrs.
• MIG21 1 yr.
• QUICKEN 5 yrs.
• MICROSOFT OUTLOOK yrs.
• HP QUALITY CENTER 1 yr.
• REMOTE/SCREEN SHARING COMPUTER REPAIR 15 yrs.
• ORACLE ERP (EBS) 1 yr.
• MS OFFICE SUITE 15 yrs.
• ODBC CONNECTIVITY 10 yrs.
• LOTUS NOTES 3 yrs.
• DB VISUALIZER 1 yr.
• SAP 1 yr.
• RSA SECURID 2 yrs.
• SQL MANAGEMENT STUDIO 2 yrs.
• SHAREPOINT 1 yr.

AREAS OF KNOWLEDGE AND EXPERIENCE:

Business/Data Analyst/Access Developer

Confidential

Responsibilities:

• Involved in the creation of powerful databases for non-profit organizations, real estate owners, payroll departments, accounting firms, etc. that require setup of Menus, Tables, Forms, Queries (SQL) and ad hoc reports.
• Create and upgrade Excel workbooks using this application to the fullest; macros, VBA coding, pivot tables, nested if statements, dashboards, cell linking, and intense formulas.
• Consulting organizations on software enhancements and upgrades, tax situations, and financial analysis.
• Prepare individual income tax via Tax Works software.
• Upgrading Personal Computer hardware including installation of hard disks, CD-ROMs, ram chips, USB ports, graphic and sound cards, etc.
• Extensive documentation of training manuals with graphics accessible via linked objects in forms and reports within developed databases.

Environment: Windows 7, 8, &10, Microsoft Office 2010, 2013, 2016, Tax Works, Crosslink, Pro Series, QuickBooks 2014, SQL Server, ODBC Connectivity, Remote and Screen Sharing Computer Repair

Sr. Business/Data Analyst

Confidential, St. Louis, MO

Responsibilities:

• Performed as a Product Owner/BA representing the business community gathering detailed requirements as well as a Data Analyst analyzing database architecture, mapping issues, SQL query analysis, data modeling and data migration strategy.
• Requirement gathering and documentation of current procedures for the tracking and assignment of field operations and sales division employee and contractor identification applications for legacy companies.
• Involved in the designing of a consolidation application for three legacy companies’ disparate systems through investigation of boundary applications both inbound and outbound as well as the data requirements for new solution.
• Created business case, impact analysis, risk analysis, functional requirements documents, data attributes, feasibility studies, and company specific documentation delivered to Senior Management, VP’s, Directors, and subordinates.
• Performed one on one web hosted sessions and in person interviewing of SME’s in reference to current application processes for tracking, reporting, and analysis of sensitive employee labor data
• Provided feasibility study of process to determine a more appropriate application and provided feedback to upper management.
• Extensive data mapping and modeling of legacy data to provide support and creativity in the developmental process of new database application.
• Worked with analyst and PM’s strategizing on ETL process to implement new data warehouse for Business Intelligence reporting.
• Exposure to IAM/SSO through the tracking of sales and technicians that were entered into NetIQ Identity Management as the system of record for employee information and allowed for single sign on access to other networked applications.
• Became involved in process and application discovery processes for multiple departments including Business Intelligence, Customer Care, Billing Operations (ICOMS and CSG), Sales and Commissions and related findings graphically with Visio and PowerPoint diagrams displayed through WebEx Portals and state of the art conferencing equipment.
• Worked with SME’s in providing data extraction process information for outbound boundary systems and recorded findings as admin of SharePoint List and Access database developer.
• Became familiar with database structure of Teradata and RDM data warehouses analyzing associated entities and attributes consumed and impacted by diverse enterprise systems.

Environment: Windows 7, Microsoft Office, SQL Server Management Studio, SharePoint, ODBC Connectivity, Teradata, NetIQ, Waterfall/Agile Hybrid Methodology

Consultant

Confidential, St. Louis, MO

Responsibilities:

• Short term consulting position analyzing the current planning and forecasting process to determine products to be manufactured throughout geographic locations worldwide.
• Requirement gathering and documentation of current procedures and mimicking the process using MS Excel and gravitating to MS Access for automation.
• Detailed financial analysis and ETL processing extracting data entered into SAP ERP from Oracle 11i database transforming and loading that data using ODBC Connectivity to MS Excel and Access for reporting to senior executives.
• Automated the manual Excel process using MS Access queries and VBA coding.
• Performing other duties assigned at management’s discretion requiring versatility, innovation, and the ability to work on new applications and environments learning data processing requirements quickly.

Environment: Windows 7, Microsoft Office, SQL, ODBC Connectivity, Oracle 11i, SAP, VBA

Confidential

Remote Business/Data Analyst

Responsibilities:

• As a data analyst, create database models, specifications, data flow diagrams and entity relationship diagrams to provide direction in the development of an MS Access database for the extraction and transformation of data from a legacy AS400 DB2 Frontier ERP system with automation of sequential processes using VBA.
• Responsible for performing the collection and analysis of complex information and making recommendations for team initiatives via conferencing with coworkers, IT, EDI support, etc. to determine impact of database changes on other systems
• Perform in the Business Analysis capacity in working with all levels of employees in collaboration to determine and document functional requirements necessary for system changes and the interaction with other systems.
• Act as a key link and liaison between 20/20, EDI and Systems teams while troubleshooting system applications, identify real or potential gaps then escalate to appropriate support personnel.
• Extensive data mapping and modeling of legacy data to provide support and creativity in the developmental process of new database applications.
• Detailed documentation and gap analysis in regard to the creation of ETL processes with finalization of template to be used for outside client selection, options, and conditions for product distribution.
• Provide tools and reporting capabilities for business experts and specialists to access and analyze data while identifying and defining new data process improvement opportunities
• Identify, analyze and interpret trends or patterns in complex data via Access and Excel.
• Performing other duties assigned at management’s discretion requiring versatility, innovation, and the ability to work on new applications and environments learning data processing requirements quickly.

Environment: Windows 7, Microsoft Office, SQL, ODBC Connectivity, Frontier ERP, DB2, VBA

Data Conversion Analyst

Confidential, Louisville, KY

Responsibilities:

• Involved an ERP implementation specifically the Supply Chain Management modules analyzing, reconciling and creation of the repeatable ETL process for extracting legacy data from multiple silos for implementation to the Oracle 12 EBS system.
• Extensive use of MS Access 2007 and MS Excel 2007 functionalities for data analysis and data quality issues surrounding the extraction, transforming and loading (ETL) of sourcing data, BOM (Bill of Material) items, inventory, and the creation of the Item Master for large quantities of data involved in the manufacturing of Confidential appliances.
• Served as the Product Owner in an Agile Methodology development process representing and understanding the needs of the manufacturing and product servicing departments determining data mapping issues and features of the iteration release.
• Participation in Data Governance processes and data modeling both conceptually and logically and involved in the sign off of processes and rules associated with data extraction and loading during SDLC iterations.
• Became familiar with different Agile Methodology and Scrum processes including participation in 7ways JAD sessions, JIRA ticketing for resolution of gaps in system implementation and processes, and decision making processes in daily Scrum meetings.
• Creation of detailed documentation and SIPOC diagrams using Visio and Microsoft Office products.
• Performed Business Analysis techniques including the gathering of requirements, leading of brainstorming sessions promoting SME participation and customer satisfaction.
• Worked with Oracle EBS system uploading data using Data loader, Appload, and WEBADI templates.
• Instrumental in the development of database creation and the processes needed for the data extraction and cleansing prior to loading in interactive testing environments including CRP (Conference Room Piloting) and progressive development instances.
• Constant interaction with a variety of individuals including plant management, planning department, database administration, Oracle ERP system administration, etc.
• Monitored and updated system processes and defects through HP Quality Center.

Environment: Windows 7, Microsoft Office 2010, SQL Developer, ODBC Connectivity, Oracle 12, Appload, WebADI

Business/Data Analyst/Excel Developer

Confidential

Responsibilities:

• Involved in the creation of powerful databases for non-profit organizations, real estate owners, payroll departments, accounting firms, etc. that require setup of Menus, Tables, Forms, Queries (SQL) and ad hoc reports.
• Create and upgrade Excel workbooks using this application to the fullest; macros, VBA coding, pivot tables, nested if statements, dashboards, cell linking, and intense formulas.
• Consulting organizations on software enhancements and upgrades, tax situations, and financial analysis.
• Prepare individual income tax via Tax Works software.
• Train users on Internet functionality and various software packages.
• Upgrading Personal Computer hardware including installation of hard disks, CD-ROMs, ram chips, USB ports, graphic and sound cards, etc.
• Extensive documentation of training manuals with graphics accessible via linked objects in forms and reports within developed databases.
• Constant interaction with a variety of individuals from executives to clerical personnel.

Environment: Windows 7, 8, &10, Microsoft Office 2010, 2013, 2016, Tax Works, Crosslink, Pro Series, QuickBooks 2014, SQL Server, ODBC Connectivity

Business Support Analyst

Confidential, Ft. Wayne, IN

Responsibilities:

• Contracted as a Business Support Analyst/Access, Excel Developer documenting functional requirements and process flow charting of the current database structures in Access 2003 and the enhancements involved in the migration to Access 2010.
• Developed and enhanced Word Document mail merges and in-depth Excel workbooks which were migrated to the Office 2010 version as well which involved updating reports, queries, macros, source document links, reports, etc.
• Involved in JAD sessions scoping and documenting the user needs for the creation of new databases and Excel workbooks for the input of new business clients for financial management area at Lincoln.

Environment: Windows XP/7, Microsoft Office Suite 2003/2010

Confidential

Business Analyst/Excel Developer, Miamisburg, OH

Responsibilities:

• Involved in the creation of an automated Project Management Tool utilizing MS Excel’s macro building aspects, linking of worksheets, intense formulas, importing of files and tables, designing and linking of graphs, etc.
• Tool creation involved additional Excel spreadsheet analysis including the creation of graphs, pivot tables, nested if statements, dashboards, etc.
• Involved in JAD sessions scoping and documenting the user needs for the creation of enhancements to the existing tool via Excel for the installation of Teradata data warehousing application.

Environment: Windows 7, Microsoft Outlook 2007, MS Excel 2007, VBA

Database Developer

Confidential, Hebron, KY

Responsibilities:

• Involved in the development of MS Access databases for the Supply Chain/Warehouse facility in Hebron, KY involving the creation of user friendly data entry screens, ad hoc reports, intense queries, modules, VBA coding, etc.
• Databases created involved additional Excel spreadsheet analysis including the creation of graphs, pivot tables, nested if statements, dashboards, etc.
• Interaction with Process Mapping team discussing the development of user requirements and development requests.
• Interaction with Honeywell warehouse management and subordinates in the gathering of requirements and documentation of the developed applications specifying the unit sorting and distribution of Honeywell inventory products throughout the warehouse then throughout the nation.
• Enhanced and maintained current databases and created links and imports from AS400 tables via ODBC connectivity and provided a repeatable ETL process with the creation of new Access database for tracking of transportation, shipping and receiving network.

Data Analyst

Confidential, Miamisburg, OH

Responsibilities:

• Involved in the modification and enhancements of the databases currently in use to coincide with new user requirements which involve the gathering of these requirements via JAD sessions, one on one user investigation, and interaction with multiple departments within the corporate structure.
• Created reports for executive management which detailed the daily metrics, company economic position, company revenue and income, company invoiced and billable product, etc. via MS Access database development, and MS Excel.
• Enhanced existing tool which required the creation of powerful and advanced formula calculations, pivot tables, macro development, and overall advanced knowledge of the MS Excel application.
• Gained knowledge of the corporate status of economic positions at a high and detailed level of the manufacturing industry.
• Gained knowledge of the PROS application which presented the marketing strategy necessary for business development and enhancement.