Allan Da Silva, Cma Email & Phone Number

Orlando, FL, US

Cambridge, Massachusetts, US

Cambridge, Massachusetts, US

Cambridge, Massachusetts, US

Worldwide, OO

• Lead BI (Business Intelligence) reporting development efforts including analysis of metadata and ETL (Extract, Transform, Load) strategy for 45+ business user reports to support creation of new corporate tax data engine.
• Partnered with business users / SMEs and lead calls with corporate IT department leaders to derive reporting business needs and expectations while logging JIRA user stories.
• Presented to team leadership on project progress and communicated potential risks to data modeling / reporting progress.
• Identified data from variety of source systems (Data Warehouse, ECC, S4) and performed validation in UAT testing /quality environment and automated data flow into google cloud (GCP) based target system.
• Owned 10+ monthly production compliance reporting tasks due within company month end close deadlines.
• Troubleshooted and fixed production issues over variety of data mediums (ABAP, SQL, API, BEX Query, SAP BI, Python).

Basking Ridge, NJ, US

• Reconciled $200M in monthly IT and Technology and Network Maintenance expenses, explaining all month over month, quarter over quarter and year over year expense fluxes.
• Lead monthly meetings with 4 different purchasing and FP&A teams to review budget expectations to review vendor purchase orders and determine appropriate accounting treatment, amortization terms and P&L account expense.
• Lead team process improvement efforts by initiating data warehouse table creation with source data teams; negotiated data refresh times, table fields requirements, and scope of data.
• Created data transformation rules table using SQL to use in collaboration source data team table to automate manual process used by entire department during month end saving 8 hours per person across 3 teams.
• Utilized Qlik Dashboard to create custom reports in tracking expense progress throughout month.
• Facilitated migration from Peoplesoft based AP/Expense data for corporate and wireless segments to S4 Hana by creating new process to eliminate business partner manual entry for expense terms.

Basking Ridge, NJ, US

• Reconciled more than $3B in monthly activity in the largest wireline biller(Vision5) accounts receivable.
• Used SQL research analysis to design and implement a ASC606 promotion gift card solution to satisfy booking requirements.
• Created custom reporting solutions using BODS/EDW data analytics to help management make booking decisions.
• Lead the A/R team during the 1revclose project, gathered and submitted user stories in JIRA to close engine developers to resolve revenue accounting gaps.
• Converted and troubleshooted account reconciliations from vSAP to 1ERP based balances using AO; researched errors/fallout and provided to 1ERP development team for modification.
• Partnered with revenue assurance to map new and old rep

Basking Ridge, NJ, US

• Recorded monthly telecom advertising and consumer revenues of up to $100M in accordance with GAAP Standards for a F-500 Telecom organization.
• Gained tech-industry expertise: carrier content, targeted advertising, banner ads, impression statistics, and other tech drivers that fueled TV\Internet\OTT [Over-The-Top] Platforms revenue.
• Lead collaboration meetings with outside department officers to refine processes and drive process transparency.
• Helped drive digital finance and automation initiatives leveraging and mastering coding languages:Automated External Auditor Requests
• [SQL, Powershell]Automated Manual Standardized Journal Entries
• [Powershell]Automated Customer Level Detail Pulls

Basking Ridge, NJ, US

• Developed expertise for a wide variety of payment mediums: ACH, EDI, Wire, Credit/Debit Card, Gift Cards, Check and the nuances of rules within them.
• Investigating account, remit processing center and system issues within all areas of a telecoms business segment spectrum (VZW, VES, VZ Prepaid, VZT).
• Executed a daily automation that re-allocated analyst hours into non-standardized complex customer issues, reducing an average of 40% of tickets created on a daily basis.
• Compiled automation results and produced a dashboard style report for Sr. Management's review.
• Mastered warehouse shipping logistics and returns practices in a telecom retail/online order setting.
• Leveraged industry/internal systems data and performed payment processing analysis.

Daytona Beach, Florida, US

• Directly affected the operational governance, risk management and financial efficiency of the seventh largest independent insurance intermediary organization in the world through the Internal Operations Review Committee.
• Responsible for requesting support, enforcing, testing and recommending segregation of duties to ensure appropriateness and organizational alignment with SOX.
• Performed complete audits across the nation (50-60% travel) for branches with revenues of up to $30 million+
• Ensured a professional independent audit environment and exhibited a vast knowledge of GAAP standards while interviewing executive level financial controllers for procedural completeness.Key

London, GB

• Responsible for resolving complex participant issues including conducting research, analyzing plan provisions and translating provisions to the ongoing processing environment.
• Resolved system edit issues and performed manual calculations/processes that are not automated.
• Created ad hoc reports in support of client and participant service delivery functions.
• Performed file processing for third party administrators.

Noblesville, Indiana, US

• Responsible for reporting on the chapters mutual fund investment of over $50,000.
• Administering the allocation of an expected $30,000 in income to various expense accounts.
• Maintain constant relationship with our administration center and make sure payments are made as scheduled.
• Account for all expenses, revenues and assets owned by our organization.

Maitland, Florida, US

• Managed fundraising efforts for our client at New Hope for Kids using data excel spread sheets
• Submitted detailed PMP’s (Project Management Plans) for the Cornerstone course at the University of Central Florida

Orlando, Florida, US

• Participate in and is responsible for certain tasks directly related to the agency’s marketing and/or special events (i.e. writing press releases, PR phone calls, photo shoots, graphic design, etc.)
• Develop knowledge and skills in writing for public relations, graphic design, the printing process, etc.
• Interact with various departments and facilitate marketing projects and campaigns
• Exhibit a high degree of integrity and character with professionalism and commitment to excellence, both with internal and external publics.
• Required attendance at special events as requested (set-up & breakdown included).