Erik Willis Email & Phone Number

Los Angeles, Ca, Us

Menlo Park, Ca, Us

• Data Modeling and DAX: Created complex data models and optimized them with advanced DAX functions for accurate and efficient Power BI reports.• Data Integration and ETL: Integrated data from various external sources using Power Query ensuring smooth ETL processes.• Visualization and Reporting: Designed interactive and user-friendly reports and dashboards with Power BI's visualization tools, enhancing decision-making. • Power BI Service Management: Managed Power BI Service features, including workspaces, semantic model refreshes, data gateways, and security settings, ensuring efficient report distribution and governance. • Collaboration and Training: Collaborated with users to understand requirements, provided training, and supported Power BI adoption, promoting a data-driven culture.

Frisco, Texas, Us

Strategic Systems Analysis: Collaborated with finance leaders to analyze and implement strategic technical roadmaps, improving corporate planning and reporting systems.Technical Specifications & SME Guidance: Authored detailed functional and technical specifications for system enhancements and functioned as the primary technical and functional authority for Infor EPM and SAP BPC systems.Solution Development & Data Integrity: Engineered and sustained advanced financial planning and reporting systems leveraging Excel, SQL, and Power BI knowledge to ensure data integrity and aid strategic decisions.Infor EPM Configuration, Data Integrity & Technical Expertise: Led the management of Infor EPM settings for 200+ users, leveraging advanced knowledge in system architecture, UI customization, and data integrity principles. This included implementing robust data validation techniques to ensure accuracy, thereby significantly boosting user experience and operational efficiency.Proficient in Data Modeling, DAX, and Power Query: Skilled in building robust data models and using advanced DAX and Power Query for efficient data integration and analysis.Experienced in Power BI Dashboard Development and Service Maintenance: Expertise in creating interactive dashboards, managing Power BI Service, and ensuring data security and optimal performance.Month-End Close & Planning Precision: Expertly managed data extraction from Infor M3's Financial Management module for crucial month-end closing and strategic planning, streamlining reporting processes and enhancing forecast accuracy.Financial Management & System Optimization: Utilized Infor EPM module to streamline financial operations, significantly improving process efficiency and financial data accuracy.Strategic Financial Analysis: Leveraged Infor EPM to perform deep financial analyses, aiding in the formulation of strategic financial plans and enhancing decision-making processes.

Duluth, Georgia, Us

Environment Leadership: Primary technical and functional lead administrator, managing SAP EPM environments and liaising with over 100 users.Data Integrity and System Maintenance: Ensured data accuracy across financial systems, maintained master data in SAP BPC, ECC, and BW systems, and developed key reports using advanced SAP functionality.System Configuration Expertise: Defined and configured Cubes, Applications, Dimensions, and their properties in the SAP EPM environment.Technical Support and Troubleshooting: Provided crucial technical support during the forecast and budget cycles and resolved functional/technical issues in the SAP BPC environment.

Noida, Uttar Pradesh, In

Expertise: Designed, built, and maintained complex multi-source planning solutions, showcasing mastery in SAP EPM 10.0 NW.Project Leadership and Strategy Execution: Acted as project lead in high-profile cross-industry projects, directing requirement gathering and executing financial planning strategies, including budgeting, forecasting, and consolidations.SDLC Lifecycle Management: Oversaw deliverables across all SDLC phases, from project planning to post-go-live, ensuring seamless project execution and compliance.Training and Knowledge Transfer: Developed comprehensive training materials and conducted knowledge transfer sessions to enhance stakeholder understanding of SAP EPM functionalities post-implementation.

Worldwide, Oo

Architected SAP BPC Solutions: Expertly architected and sustained complex, multi-source planning solutions across diverse SAP BPC versions.Spearheaded Project Initiatives: Spearheaded high-profile, cross-industry projects as the primary SAP BPC technical and functional expert, driving financial planning strategies.Managed SDLC Processes: Efficiently directed project deliverables throughout all SDLC phases, ensuring successful implementation and go-live.Developed and Facilitated Training: Innovatively developed training content for SAP BPC and facilitated knowledge transfer sessions, enhancing stakeholder understanding and overseeing diverse project teams.

Beverly Hills, California, Us

Leadership: Primary technical and functional lead administrator, ensuring effective execution of financial planning strategies, including budgeting, forecasting, and consolidations.User Liaison and System Configuration: Served as the primary liaison for over 450 users of financial planning applications and defined/configured Appsets, Applications, Dimensions, and their properties.Advanced Reporting and Data Management: Developed key reports and input schedules using advanced SAP BPC functionalities and maintained SSIS packages for data management.Project Lifecycle Management: Completed deliverables across all phases of the SDLC lifecycle, from project planning to post-go-live.

Chandler, Az, Us

Key Role in System Implementation: Played a crucial role in planning, benchmarking, scheduling, and executing new system implementations with SAP BPC modules, encompassing financial reporting, CAPEX, planning, operations, profitability, and sales reporting.Monitoring and Decision Facilitation: Responsible for monitoring, analyzing, and reporting on key metrics to facilitate critical decisions during system implementation.Design/Implementation Team Member: Instrumental in a three-phase implementation of Business Planning and Consolidation software for a Fortune 500 athletic shoe and apparel company.Extended Support Role: Acted as a primary onsite resource for end-user and technical support during the development, implementation, and go-live phases for an international entertainment event promotions company.

Us

Data Management Expertise: As the primary data manager, effectively utilized standardized MicroStrategy application modules to manage the business needs of over 400 end-users in an Oracle DB environment.Process Improvement Implementation: Implemented process improvements in automated report delivery systems, enhancing reporting efficiency for a large financial services company.Complex Report Development: Developed complex ad-hoc reports for senior management and various business units, contributing to enhanced operational efficiencies.

Us

Sophisticated Financial Analysis: Created various models and methodologies for complex financial analysis functions including ROI, cost-benefit, and product performance analyses.Budget Management and Compliance: Implemented procedures and achieved the completion of annual operating and capital budgets, aligning with business plan targets.Process Improvement Contributions: Enhanced the accuracy of analysis and forecasting by working with business units and improved corporate planning cycle processes.Significant Cost Savings: Identified inefficiencies in CAPEX management, saving over $2.4M annually.Budget Oversight and Efficiency Improvements: Managed a $78 million IT Division budget and reduced monthly closing cycles by implementing enhanced procedures.