PEN188 | US Citizen | DoD - Active Secret Clearance

 

PROFESSIONAL SUMMARY

 

Seasoned IT professional with over 17 years of experience in leading SAP development and sustainment initiatives across Middleware and ECC systems. Known for a strategic approach to technology integration and a steadfast commitment to enhancing client satisfaction through robust IT solutions. Proven track record of implementing IT tools and systems in Federal, Oil & Gas, Construction, Manufacturing, and Retail sectors, driving business process improvements and operational efficiencies from the back office to the shop floor. Strong leadership skills combined with a deep technical background enable the delivery of high-impact IT strategies that maximize client investment value.

Key Skills:

 

• Leadership in SAP Implementation: Successfully directed four comprehensive SAP BW implementation cycles, including strategic planning, global reporting strategies, timeline management, and end-to-end project execution. Managed multidisciplinary teams to ensure alignment with business goals and objectives.
• Strategic Planning and Execution: Led all phases of SAP BW projects, from realization and go-live to post-implementation support, optimizing SD, HCM, APO, and FICO modules to enhance business performance.

• Advanced Analytics and Data Strategy: Developed and executed advanced analytics strategies using SAP Analytics Cloud (SAC), Datasphere, Business Objects, Power BI, and Qlik Sense, fostering data- driven decision-making and enhancing data visualization capabilities.

• Project Management: Expert in managing large-scale SAP projects with a focus on timelines, resource allocation, risk management, and stakeholder communication to ensure project objectives are met on time and within budget.

• Team Leadership and Development: Led diverse teams of developers and consultants, fostering a culture of collaboration, innovation, and continuous improvement. Mentored team members to enhance their technical and professional skills.

• Cross-functional Collaboration: Collaborated effectively with business stakeholders, cross- functional teams, and external vendors to integrate data from multiple sources and develop cohesive reporting solutions that drive organizational value.

• System Upgrades and Optimization: Directed SAP system upgrades and migrations, including ECC, BW, and HANA, ensuring minimal disruption to operations while enhancing system capabilities and performance.

• Business Process Improvement: Identified and implemented process improvements that enhanced efficiency and productivity, leveraging advanced technologies such as HANA, S4HANA, and FIORI applications.
•  Stakeholder Engagement: Maintained strong relationships with business stakeholders, providing strategic insights and recommendations to support key decision-making processes.

• Accumulated over six years of extensive experience in Tableau Desktop and Server across various versions (9.0, 9.3, 10), excelling in data visualization and dashboard creation.
• Proficient in leveraging Tableau to analyze large datasets and develop interactive, actionable reports and dashboards.
• Expertise in Microsoft Office Suite (Word, Excel, PowerPoint, Access, Project), enhancing productivity and project management capabilities.
• Exceptional communication skills for effective interaction with business stakeholders to capture essential development requirements.
• Profound knowledge in SAP Analytics Cloud (SAC), Datasphere, Business Objects WebI, Xcelsius, Design Studio, Crystal Reports, Lumira Designer, and Discovery for crafting web-based reports and dashboards. Intermediate skills in Design Studio SDK.

IT Certifications

 

• SAP Certified Analytics Cloud Story Design (SAC) Associate
• SAP Certified BW4HANA Application Associate
• SAP Certified Native HANA Developer
• Microsoft Certified Power BI Data Analyst Associate
• CompTIA Certified Security+ professional

PROFESSIONAL EXPERIENCE

 

Duration : 07/2018 – Present 

Client         : Department of Defense Role           : Lead Consultant

 

• Leadership and Strategy: Spearheaded the development and transition of complex reporting systems from Web Application Designer (WAD) to Web Intelligence (WebI), enhancing data accessibility and user experience.
•  End-to-End Solution Design: Directed the design and implementation of comprehensive solutions using SAP Analytics Cloud, including data modeling, visualization, and predictive analytics, aligning technology solutions with business needs.

• Cross-functional Team Management: Led cross-functional teams in integrating and preparing data from diverse sources, ensuring accuracy and consistency in reporting.

• Optimization and Performance Management: Implemented rigorous testing, debugging, and optimization processes for SAC applications, improving system performance and user satisfaction.

• Transformation: Innovated within the SAP BW system on HANA by creating Advanced DSOs and Composite providers for Datamart redesign, including code modification and new transformation and workflow development, culminating in the migration of BEx queries to new Composite providers and enhancing end-user experience through WebI.
• Utilized SAC as a planning tool, creating planning data models and working with categories actual, budget, planning, forecast, rolling forecast. Enabled user to perform what-if analyses, scenario planning, and budgeting processes.
• Adaptation of Next-Gen Technologies - Executed a Power BI Proof of Concept (POC) to enhance analytics and dashboard capabilities. This involved data extraction from SAP HANA via import method, data transformation within Power BI to align with project specifications, and integration of two distinct Excel files with HANA data using Power Query to form a unified dataset. Developed comprehensive reports utilizing Power BI's native features such as graphs, slicers, cascading filters, pie charts, and donut charts.

Duration : 06/2017 – 05/2018 

Role           : BI Manager

 

• Leadership in Business Intelligence Strategy: Directed the design and implementation of SAP Business Warehouse (BW) information models to enhance cross-functional reporting and drive business performance. Played a key role in aligning data strategies with the overall corporate objectives, enabling data-driven decision-making across the organization.
• Ownership of Data Architecture: Managed the full lifecycle of BI and data architecture, ensuring the scalability, security, and performance of both SAP and non-SAP data sources. Took a strategic approach to ensure that the architecture supported high-volume data processing and could scale with the company’s growth.

• Governance and Standardization: Defined and enforced enterprise-wide BI standards and processes to ensure consistent and efficient execution. Conducted architecture reviews to ensure adherence to best practices and to optimize system design for long-term sustainability and operational efficiency.

 

• Performance and Process Optimization: Established performance baselines and led ongoing performance monitoring to drive improvements. Spearheaded optimization initiatives that significantly enhanced system efficiency, managing a cross-functional team including onsite developers and AMS support staff.

• Advanced Analytics and Data Visualization Leadership: Led the design and deployment of advanced data models using Native HANA and SAP Analytics Cloud (SAC). Pioneered the use of Microsoft Power BI for advanced visualizations, providing executives and decision-makers with actionable insights through interactive dashboards and reports. Directed the development of key financial and operational reports, empowering departments such as Finance, Inventory, and Materials Management.

• Adoption of Next-Gen Technologies: Directed the adoption of cutting-edge technologies such as S4HANA, BOBJ 4.2, and FIORI applications, ensuring the organization stayed ahead of industry trends. Led the integration of HANA live views to reduce data modeling time, significantly boosting productivity and enabling faster time-to-market for data-driven initiatives.

• Cross-functional Leadership and Collaboration: Led collaborative efforts between internal teams, business stakeholders, and external vendors, ensuring successful project delivery. Provided leadership in aligning technical capabilities with business needs, ensuring the successful translation of complex data models into strategic business outcomes.

Duration : 01/2016 – 04/2017 

Role           : BI/BW Lead Consultant

 

• Strategic Leadership in Database Migration: Led the successful transition of Business Warehouse (BW) and Business Objects (BOBJ) systems from Oracle to HANA cloud infrastructure. This project was pivotal in modernizing the department's data infrastructure, enabling enhanced performance, scalability, and long-term operational sustainability.
• Oversight of System Migration and Optimization: Directed comprehensive preparatory activities for the SAP BW system migration, including system log cleanup, OSS note application, and consistency checks to ensure a smooth transition. Provided strategic oversight on the remediation of over 1,400 ABAP programs, ensuring full compatibility with the HANA environment.
• Post-Migration System Integrity: Managed post-migration activities to ensure system integrity and performance. This included executing system sanity checks, implementing OSS notes, and converting Infocubes to HANA-optimized cubes. By ensuring operational efficiency, the migration yielded significant performance gains for the department.
•  Quality Assurance and System Testing: Directed thorough testing and evaluation of BOBJ and Portal systems both pre- and post-migration, ensuring operational accuracy and maintaining business continuity during the transition.

• Data Strategy and Visualization Leadership: Led the development of Power BI dashboards utilizing Power Query and DAX, integrating SAP BW as the backend. These dashboards provided key stakeholders with real-time insights into critical metrics, driving more informed decision-making across the organization.
• Innovation in Data Visualization Solutions: Spearheaded a Proof of Concept (POC) for integrating Qlik Sense as a potential dashboarding tool. Evaluated the feasibility of this new technology within the organization, providing recommendations on expanding the department’s data visualization and analytics capabilities.

Duration     : 05/2014 – 12/2015 

Role             : BI/HANA Lead Consultant

 

• Specialized in front-end development, designing dashboards for the marketing team using SAP Design Studio versions 1.3 and 1.5, with a primary focus on enhancing user interaction and providing "What- if" analysis through dynamic reporting.
• Utilized HANA as the foundational database, integrating it with Design Studio to craft interactive dashboards.
• Developed advanced information models in HANA 1.0, employing Stored Procedures, CE functions, and SQL Scripting techniques.
• Addressed specific dashboard requirements using Power BI, demonstrating flexibility and expertise across different platforms.
• Contributed to the Data Driven Marketing (DDM) project by aggregating data from diverse sources including SAP, Excel, and CSV extracts from Visa (via BO Data Services), employing Star Schema modeling in Power Query for data consolidation in Power BI.
• Authored numerous DAX functions to refine datasets, culminating in the publication of comprehensive reports and dashboards in Power BI services, aimed at enhancing decision-making processes for users.
• Worked within an Agile methodology framework, ensuring rapid and adaptive response to project requirements.
• Conducted thorough analysis of existing HANA models to ensure data integrity and optimize model performance.

 Duration    : 12/2012 – 4/2014 

Role             : BI/BW Lead Developer

 

• Led a team of Senior SAP Developers, overseeing daily production support and development tasks while collaborating with clients to shape future strategies and visions.
• Engaged in HANA sizing activities for both BW on HANA and HANA in a sidecar configuration, contributing technical expertise to the team.
• Achieved successful conversion of two BW and one ECC report related to Funds Management into HANA-based reports using SLTs, Summary Tables, and triggers, utilizing HANA Studio tools, with final visualization on the BOBJ WebI platform.
• Addressed and resolved numerous BW data load performance issues, significantly reducing daily batch load durations.
• Played a pivotal role in the upgrade of the BW environment from version 7.1 to 7.3, enhancing system functionality and performance.
• Conducted thorough analyses to pinpoint 14 extractors requiring optimization, proposing modifications to ECC or BW code to improve efficiency.
• Identified and addressed design issues within BW, offering recommendations for optimization to ensure system integrity and performance.
• Demonstrated a comprehensive understanding of BW on HANA migration strategies, including the configuration and procedures necessary for converting BW InfoCubes and DSOs to HANA-optimized formats, showcasing a blend of leadership and technical acumen.

Duration : 10/2012 – 11/2012 

Role           : Sr. Developer

 

• Enhanced CRM and BPC extractors for Project and Opportunity applications, developing new process chains and optimizing existing ones through parallelization of variants as required. Additionally, refined transformation code to improve data loading efficiency.

 Duration : 07/2012 – 09/2012 Industry : Marketing

Client         : Dairy Farmers of America Location : Kansas City, KS

Role           : Sr. Developer

 

• Transformed legacy reports into BI reports by collecting business-specific process flow information, utilizing standard extractors, and designing generic extractors with function modules to facilitate data transfer from ECC to BI.
• Enhanced the Process Order Component extractor to operate in delta mode, transitioning from a full load to a more efficient daily delta load.
• Developed a comprehensive Dataflow diagram for the BI landscape, utilizing Visio to visualize and document the data architecture.

Duration : 03/2012 – 06/2012 

Role           : Lead Developer

 

• Served as a technical consultant for Deloitte's internal project, focusing on the HCM Benefits and Personnel modules. Enhanced the 0employee info type by adding additional fields to meet business requirements and explored strategies to optimize HCM data loads for reduced load times.
• Concurrently engaged in a Proof of Concept (POC) for a service-centric sales data solution using HANA, leveraging predictive analysis based on customers' previous purchasing behaviors.
• Developed the solution by creating tables, attribute views, analytic views, and calculation views for data modeling, and applied SQLSCRIPT for predictive analysis.
• Managed data loading from SAP BW into the solution using Data Services 4.0 for extraction, utilized HANA technology for data modeling and storage, and employed BO 4.0 Xcelsius and WebI for front-end reporting.

Duration : 04/2011 – 01/2012 

Role           : Sr. Developer

 

• Developed a Global Executive Dashboard using BOBJ Xcelsius, showcasing multiple KPIs to provide a comprehensive overview of revenue generation across various hemispheres, regions, and geo-markets worldwide. The dashboard offers a summary view with drill-down capabilities for detailed insights into revenue, field margins, operating expenses, and more.
•  Led a significant backend project to craft a customized Shipment Cost detail report, incorporating numerous custom fields from ECC to accommodate the company's specialized shipment procedures. This was achieved by enhancing existing standard extractors, creating two generic extractors, and utilizing function modules and BAdIs for data population.
• Utilized BOBJ WebI to deliver web reports on Business Process Instrumentation data, integrating data from ECC and Hyperion using Web-Methods.
• Addressed challenges with daily data loads, which averaged 14 hours, by conducting an in-depth system analysis and devising a strategy to significantly reduce load times by approximately 6 hours in the initial change cycle.
• Gained experience with Spotfire, a tool similar to Xcelsius, by creating dashboards focused on drilling-related data.
• Designed a dashboard to present BI Reports Usage metrics, leveraging BOBJ Data Services for extracting statistics from InfoView and Portal.
• Currently developing a dashboard to offer users real-time updates on the status of daily BI data loads and forecasts for upcoming loads, enhancing operational transparency and planning.

Duration : 05/2007 – 4/2011

Industry : Consumer Products Manufacturing 

 

Production Support Lead

• Led a team of four offshore consultants in India, overseeing daily batch loads from R/3, APO, and SRM systems with a success rate exceeding 95% across all areas.
• Managed Service Desk (SD) tickets within Solution Manager, delegating tasks to both offshore and onshore teams for efficient resolution.
• Spearheaded the deployment and configuration of BIA, including sizing and blade count, collaborating closely with the Basis team through installation, testing, and production delivery.
• Partnered with the Basis team to deploy, configure, and test the Pre-Calc server, automating BI report delivery to end users.

Production Support Role

• Accountable for performance tuning, addressing data loading, and query performance issues.
• Regularly resolved Service Desk tickets as part of the Production Support Team to ensure rapid problem resolution.
• Developed, tested, and implemented BW objects for Newell Rubbermaid Inc across SD, FICO, and BI Statistics cubes.
• Conducted business requirement gathering and gap analysis for Business Content installation.
•  Designed and developed custom DataSource, InfoSource, Extractor, InfoCube, and ODS to meet specific user needs.
• Crafted transfer rules, update rules, and start routines using ABAP for business logic integration and data manipulation.
• Enhanced master data sources (0Customer, 0Material, 0Mat_Plant, 0Ven_Compc) for tailored reporting needs.
• Formulated data loading strategies for master data, transactional data, and delta uploads, including process chains for efficient data management.
• Implemented aggregates, compressions, indexes, multi-cubes, and parallel setups for optimized performance and data utilization.
• Utilized Query Designer and Web Application Designer extensively to create queries for sales forecasts, budget, and delivery analysis, employing various BI tools and techniques.
• Engaged in comprehensive documentation and end-user training to ensure smooth operation and user competency.

 

Duration : 05/2006 – 4/2007 

Role         : Project Coordinator

 

• Led the deployment of the Meditech Electronic Medical Record System (EMR) across six regional hospitals in Texas and Louisiana, enhancing patient care and data management.
• Directed a team of eighteen professionals, overseeing project progress and team dynamics.
• Managed and updated a server-based Microsoft Project Plan to track project milestones and timelines.
• Orchestrated various software testing phases, including Unit, Integration, Parallel, and Stress Testing, to ensure system reliability and performance.
• Facilitated the coordination of implementation, training, and Go-Live activities, ensuring smooth transitions and operational readiness.
• Oversaw the creation and maintenance of comprehensive documentation for internal audits and steering committee reviews.
• Compiled weekly status reports from twelve project managers, synthesizing information for executive-level presentations and decision-making.
• Acted as the key intermediary between clinical and technical teams, bridging gaps in communication and understanding.
• Provided both technical and administrative support to the Regional Project Manager, contributing to the project's strategic planning and execution.

 Duration : 01/2005 – 04/2006 Industry : Medical 

Role         : Project Coordinator

 

• Oversaw three development teams comprising fifteen members, ensuring effective team organization and project execution.
• Crafted detailed project plans, defined project scope, sequenced activities, and outlined implementation strategies to guide project execution.
• Employed scientific methods to estimate project requirements, delegated tasks, conducted weekly progress reviews, and communicated updates to both the program manager and clients.
• Held accountability for meeting project deliverables and adhering to established target dates, ensuring timely project completion.
• Maintained stringent quality control over all deliverables throughout the development cycle, guaranteeing that outputs aligned with customer expectations and requirements.
• Conducted regular testing, audits, and code reviews to evaluate deliverable quality, providing constructive feedback to the development team and reporting findings to the Program Manager.