SUMMARY:

• Confidential is a Sr. BI Business Analyst, Sr. Application Quality Analyst, Sr. BI Data Analyst, Sr. BI Reporting Analyst, Sr. Systems Analyst, and Sr. BOBJ Developer with over twenty (26) years of professional experience.
• Ed has worked within multiple applications and system environments consisting of large volumes of data across various data warehouses, platforms, and schemas.
• He is experienced with application lifecycle management, data profiling, data mapping, data modeling, data acquisition, data mining, data integrity, data analysis, report requirements, and report modeling, development and automation.
• Ed has broad experience working on large scale, complex applications with high performance needs.
• Confidential has strong SQL query creation and manipulation skills in Oracle, PL SQL, and Confidential AS400 environments.
• Ed has an exceptionally strong talent with identifying nuances within large data sets and their process flow.
• Ed has worked extensively to develop, gather, refine, and analyze requirements, design reporting requirements, build documentation, communicate, and work with business stakeholders to ensure that projects come to fruition within their scope and vision.
• He has worked as a ‘hands - on’ liaison between the business operations, business production, business technology, business development, and executive reporting areas in companies and government agencies on a variety of different projects involving integrations, migrations, conversions, acquisitions, and product development. Ed has strong communication, organization, facilitation, and training skills, which can all be easily leveraged and assimilated into any corporate culture.

TECHNICAL SKILLS:

Operating Systems: Windows

Databases: MS Access, Oracle, SAP, Confidential AS400 (JDA)

Tools: SAP BW/BI, Business Objects, MS Excel, PL/SQL, Toad

Related Skills: Business and Data Analysis, Data Profiling, Data Mapping, Data Mining, Data Integrity, Data ETL, Data Acquisition, Report Requirements, Report Modeling and Report Development, MDM processes, Documentation, Training, Facilitation, Presentation

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Business Analyst & Application Quality Analyst Consultant

Responsibilities:

• Assisted business operations organizations by developing reports, analyses, and corporate communications from discipline-specific systems and applications.
• Performed monthly, quarterly and annual procedural reconciliations specific to the Housing Goals and RDW Single Family acquisitions activities, book of business statements, recurring ad hoc needs, as well as non-recurring ad hoc database modifications.
• Identified, analyzed, documented, communicated, and escalated all production reconciliation discrepancy analyses items for matters ranging from data quality issues, missing data, improperly loaded data, and many other abnormal datum criteria.
• Identified, documented, and created changes to operational procedure reconciliations, working with management for their analysis, review, and approval, and publish updated procedures to corporate SharePoint document database along with all pertinent approval documentation and communications.
• Performed database modifications, working closely with business units, Risk Reporting teams, and IT Development groups to ensure proper system and application impact analyses and approvals were created and assessed while coordinating all necessary activities with all impacted individuals/teams to perform database modifications in Development, Test, and Production environments; then communicated results, and any potential next steps.
• Functioned as Housing Goals and RDW Single Family Acquisitions Production Team Lead; developed and performed monthly production load and reconciliations load activities, and identified, documented, communicated, and escalated any and all data quality issues.
• Contributed and maintained an exceptional level of awareness to accuracy and detail in all production reconciliations and other ad hoc reports and database modifications, as many of these tasks required submission of financial reporting details documenting various aggregate datum to be submitted and approved by corporate directors, executives, external auditing consumers, and the U.S. Congress.

Confidential

Sr. BOBJ Developer Consultant

Responsibilities:

• Assessed current BO (3.1 & 4.0) reporting tools for the procedures and business processes of the Financial Data Warehouse management (FDW), Accounting Data Warehouse (ADW), transactional Relational Data Warehouse (RDW) systems, and the business operations unit for methods of automating or improving existing applications’ reporting support tools.
• Worked closely with the various business units and subject matter experts to identify technical requirements for application tools under development or being revised.
• Documented all specifications, requirements, and procedures for each specific application reporting tool developed.

Sr. Data Analyst Consultant

Responsibilities:

• Gathered, identified, profiled, and mapped all data elements across eight disparate ERP global business systems’ tables and data elements using PL/SQL (for Queries) for the eventual migration into a future state consolidated ERP business system.
• Listed all data elements, with key profile characteristics, for each business system application, cross-matching fields into a consolidated MS Excel dataset for each business concept for aircraft contracts, proposals and their modifiers, aircraft inventory, operations, billing, flight operations, reservations, service and support providers, and FAA and FBO data.
• Discussed with business owners the developing logical data model to proactively identify data elements no longer needed, or which required further detailed special analysis and potential manual modification enhancement before the final migration.
• Partnered with Sr. Business Analysts to identify data elements containing inconsistencies across business concepts/systems, including format, content, context, and inherent formulas.
• Documented all identified and relevant data cleansing issues within the logical model for the business owners and users in preparation for creation of the final migration of data and the creation of the final target system staging database prior to conversion.

Confidential

Sr. DataReporting & Systems Analyst

Responsibilities:

• Worked extensively with conceptual data modeling, data acquisition, data mining, data integrity, data analysis, report modeling, Master Data Management processes, and process automation as a lead Data Analyst and SME for the corporate acquisition teams during the Sunglass Hut and Cole National acquisition, as well as for each instance of converting each business units' data for migration from JDA to SAP.
• Developed and owned all BI reporting activity for the consolidated Inventory Planning Team involving the design, creation, establishment, and maintenance of all primary key reporting tools for each corporate product division and brand label.
• Used extensive advanced querying skills with MarketMax PA, BO 3.1, SAP BW (AFS, Bex Analyzer), Confidential AS400 systems (JDA and JBA), MS Access, and SQL to extract data from various disparate data warehouses to create published reports and other internal data reporting tools for each unique corporate business product division and brand label.
• Leveraged analytical skills, data extraction methodologies, and advanced technical expertise to effectively design, build, and further improve and automate multiple corporate reporting tools while continually enhancing performance, efficiency, accuracy, and timeliness.
• Utilized MS Excel and MS Access for report building, manipulation, automation, database querying, advanced analytics, data refinement, and MDM integrity.
• As a report developer, used BO 3.1 to in corporate advanced formulae in many unique purposes across multiple key corporate reporting tools to aid report development for comparative analysis of MDM data refinement, data integrity, data manipulation and correction, reporting automation, and advanced analytics.
• Maximized MS Excel functionality by creating pivot tables, charts, and graphs, VBA macros, SQL scripting and de-bugging, complex customized and advanced nested formulae, advanced filters, conditional formatting, hyperlinks, diverse ODBC connectivity, and other advanced functionalities to facilitate corporate business analysis and unique reporting needs.
• Developed and maintained effective business relationships across independent corporate business divisions to collaborate and evolve data mining, processing, and reporting needs for independent teams, departments, and overall corporate buying and inventory planning business forecast reporting.

Confidential

Sr. Product Coordinator

Responsibilities:

• Created, maintained, and managed inventory product purchase orders, and communicated with product vendors; ensured the timely delivery of all sunglass frames and accessory product; confirmed and validated receipts of purchase orders at distribution centers.
• Created Confidential AS400 queries, datasets, and MS Excel and MS Access reporting tools to track and manage all product purchases, receipts, transfers, and other inventory management tools, continually working with planning team members to ensure the proper placement and replenishment of product to all assigned stores and laboratories.
• Developed and maintained business reporting tools to assist product buyers, inventory planners, and business directors for multiple standard and ad hoc needs across product purchasing, inventory planning, merchandising, inventory control, financial reporting, and vendor performance management reporting for all external product suppliers and the corporate subsidiaries and wholly owned manufacturers.

Confidential

Store Manager

Responsibilities:

• Performed operational duties of ordering merchandise, scheduling, cash and credit card management, receipts reconciliation, and bank deposits, and loss prevention measures.
• Hired, supervised, trained, and developed Assistant Managers and associate team members on all operating practices and procedures, inventory management, and sales presentations.
• Proactively engaged customers in sales conversations, resolved their concerns quickly, and demonstrated empathy and understanding for their unique situations when appropriate.
• Reduced store bad debt in first year from 27% to 9% through aggressive collection efforts coupled with proactive empathy and enthusiastic customer service contact, while dramatically increasing store revenue, customer loyalty, and retention.