Paula Andrea Garcia

Senior Dynamics GP Administrator | Systems Integration Lead
Oversee a complex 100-user Microsoft Dynamics GP environment across the USA and Mexico, directing the full lifecycle of financial systems, third-party integrations, and cross-border banking operations. Specialized in managing the full end-to-end remittance cycle, from initial capture and processing to final settlement and reconciliation.

Enhanced Job Duties
Systems Administration & Leadership: Lead a team of Package Software Administrators, overseeing the architecture and maintenance of Microsoft Dynamics GP, SQL Server, and Management Reporter, ensuring 99.9% system uptime for international operations.

Financial Operations & Remittances: Direct the end-to-end tax and commission engine for 5,000+ agencies in the U.S., leveraging GP to automate complex payout structures and regulatory reporting.

International Banking & Treasury: Manage strategic relationships and secure data protocols (ACH, SPEI, Wire) with U.S. and international banks to facilitate seamless fund disbursements and automated account reconciliations.

Project Management & Workflow Optimization: Orchestrate cross-departmental projects with Accounting, Marketing, and Operations to identify bottlenecks and implement custom-designed software solutions that streamline corporate workflows.

Third-Party Ecosystem Management: Research, procure, and integrate high-value third-party tools (GreenShades, Mekorma, Integration Manager) to enhance core ERP functionality and data accuracy.

Data Migration & Security: Spearheaded the successful migration of legacy data into modern SQL databases while establishing rigorous network specifications and security protocols to protect sensitive financial information.

Customization & Testing: Lead the design, UAT (User Acceptance Testing), and deployment of software customizations, ensuring compatibility across all integrated third-party platforms.

Cross-Functional Support: Provide high-level functional and technical support, translating complex technical requirements into actionable training for diverse teams, from Cash Management to Customer Service.

Senior Systems Administrator & Financial Project Lead
Directed the end-to-end administration of Microsoft Dynamics GP for a 70-user environment, serving as the primary technical and financial liaison for Senior Management, Banking Partners, and the Board of Directors.

Executive Reporting & Business Intelligence: Architected and deployed advanced reporting frameworks for high-level stakeholders, providing the Board of Directors and global banking partners with critical visibility into financial health and operational performance.

International Coordination & LatAm Strategy: Led the strategic alignment of financial and technological projects across Latin American correspondents, ensuring cross-border compliance and unified system workflows.

Strategic Risk Management: Established a formal risk-mitigation framework to identify and measure technical and financial vulnerabilities; successfully maintained project integrity and success rates throughout the entire development lifecycle.

System Evolution & Integration: Spearheaded complex GP upgrades and full-scale integrations of third-party software across legacy and modern versions, ensuring zero-loss data migrations and continuous system availability.

Software Engineering & SDLC: Managed the complete Software Development Life Cycle (SDLC) for custom modules, including functional specifications, unit testing, performance tuning, and debugging to optimize ERP functionality.

Process Automation & Customization: Designed and implemented bespoke Dynamics GP workflows, dialogs, and business process automations that streamlined month-end and year-end closing cycles.

Vendor Management & Procurement: Negotiated high-value contracts with IT vendors, optimizing the infrastructure budget while securing premium hardware and software assets.

Operational Excellence: Reduced system downtime by significantly through the implementation of proactive maintenance protocols and rapid-response troubleshooting for global internal and external users.

Senior ERP Solutions Architect & Project Manager
Led the end-to-end implementation and strategic optimization of Microsoft Dynamics GP and Platinum ERP ecosystems for high-growth organizations, specializing in complex data migrations and internal control frameworks.

Strategic Process Optimization & Business Architecture
Expert in Business Process Reengineering (BPR), Gap Analysis, and the design of internal control frameworks. Proficient in translating complex business requirements into automated, scalable workflows within ERP environments.

Strategic ERP Implementation: Orchestrated full-lifecycle installations and major version upgrades for 50+ user environments, managing the integration of diverse third-party software to create unified, scalable ERP architectures.

Business Intelligence & Advanced Reporting: Architected sophisticated reporting suites using Crystal Reports, FRX, and SQL-based scripts, delivering actionable data insights and high-level financial visibility to key stakeholders.

Governance & Internal Controls: Partnered with executive leadership to design and implement robust workflows that aligned with strict internal control standards and international reporting requirements.

Bridging Technical & Business Gap: Acted as the lead strategist in translating Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) into high-performance technical solutions, ensuring 100% alignment between client needs and product capabilities.

Quality Assurance & Risk Mitigation: Developed comprehensive testing frameworks—including test plans, scripts, and sample data sets—to oversee the seamless rollout of hotfixes, patches, and feature updates in mission-critical environments.

Data Integrity & Migration: Spearheaded large-scale cross-company data migrations, utilizing advanced SQL scripting to repair legacy data and ensure structural integrity within new databases.

Stakeholder Management: Facilitated high-level workshops with key stakeholders to define technical roadmaps, identifying business needs and implementing best-in-class processes to drive operational efficiency.

Senior Systems Architect & Forensic Financial Lead
Spearheaded the complex historical reconstruction and digital transformation of accounting systems for large-scale construction projects, integrating forensic financial analysis with custom database engineering.

Forensic Accounting Reconstruction: Directed the comprehensive historical reconstruction of construction accounting records, performing deep-dive audits of Job Costing and Fixed Assets to ensure 100% data integrity for investment accounts.

Full-Stack Database Engineering: Architected and deployed a custom technological platform using Visual Basic and SQL Server, managing the entire SDLC—from initial pre-analysis and structural design to final database implementation.

Strategic Project Management: Supervised a portfolio of high-priority technical projects, maintaining rigorous delivery schedules through advanced workflow optimization and resource delegation.

Capital Investment Analysis: Developed sophisticated parameters for the evaluation and analysis of investment data, successfully incorporating granular job-cost structures into centralized corporate financial systems.

Cross-Functional Leadership: Acted as the primary liaison between technical, financial, and construction departments, ensuring executive stakeholders were aligned on project milestones and risk-mitigation strategies.

Infrastructure & Security Oversight: Directed comprehensive systems administration, establishing robust database backup protocols and disaster recovery plans to safeguard mission-critical financial intelligence.

Data Synthesis & Modeling: Transformed fragmented legacy information into a structured, systematic database, enabling real-time financial tracking and accurate multi-year project reporting.

Regional Operations & Systems Administrator
Orchestrated the strategic expansion and technical infrastructure of regional subsidiary centers, aligning academic objectives with enterprise-level data processing and operational efficiency.

Strategic Business Planning: Authored and expedited comprehensive business plans for subsidiary operations, providing the roadmap for regional growth and long-term financial sustainability.

Corporate Governance: Developed and implemented a standardized suite of Internal Policies and Procedures (SOPs), ensuring regulatory compliance and operational consistency across all regional locations.

Operational Optimization & ROI: Directed a high-impact efficiency initiative that significantly reduced operating costs while simultaneously increasing throughput in regional administrative workflows.

Enterprise Database Administration (AS/400): Served as the Lead Database Administrator for the AS/400 (IBM iSeries) environment, ensuring the integrity, security, and 24/7 availability of critical academic and administrative data.

Systems Infrastructure & Security: Architected network specifications and security protocols, performing deep-dive analysis of workflows, access controls, and information security to protect sensitive institutional data.

Digital Transformation & Programming: Spearheaded data processing initiatives and supported complex programming activities to automate manual administrative tasks and improve reporting accuracy.

Resource Orchestration: Managed mission-critical IT assets and network access, coordinating high-demand hardware schedules to ensure uninterrupted service for internal and external users.

Executive Advisory: Acted as the primary Technical and Operational Advisor for the regional directorate, providing data-driven insights to support the planning and execution of large-scale academic projects.