Francesco Gordon Email & Phone Number

Baltimore, Maryland, Us

Baltimore, Maryland, Us

Technology application owner, project lead, production support, full lifecycle developer and analyst. VB.NET, C#, SQL, SSRS, APIs, AWS, command line, Excel, VBA, Access.

Hunt Valley, Maryland, Us

Senior developer and analyst for large scale agile project to migrate accounting data to third party. Proactively identify ways to maximize competencies and lead team in achieving objectives. Responsibilities include meeting with business stakeholders, documenting requirements, data mapping, building complex stored procedures and MicroStrategy report queries, developing Excel UDT's, and updating .Net applications to upgrade systems from SQL Server database to new Oracle database.Focus Award winner with Vision Technology Services, a competitive distinction awarded monthly to one contractor across the firm for service and dedication provided to a client. Recommended for the award by client manager and service delivery manager for critical role played during project, extended hours worked, and commitment to attaining client goals within strict deadlines.Dependable leader for other developers, communicating simplified business requirements through the combination of financial knowledge and coding concepts.Leverage business knowledge to enhance discussions with end users and work cooperatively to establish coding logic needed to attain requirements.Manage coding from development, through user testing, to production, while providing daily status updates to stakeholders through project tracking systems.

Stevensville, Md, Us

Utilize SQL Server daily to query data, create views, functions and tables, and improve queries.Apply business acumen with technical expertise to create original forecasting and budgeting models to enhance financial planning and analysis reporting. Created and provide monthly updates and analysis on a cash flow model, inventory supply and demand model, payroll model and commissions model.Diagram and map data sets from various sources including SalesForce, UPS, and ERP system to create a unified data system for querying, reporting and analysis.Meet with Internal stakeholders to discuss business needs and design requirements to fulfill needs. Document and diagram process flows and time flows required to achieve business needs and present solution to management for approval. Upon approval, create solution independently or work co‐operatively with IT department. Examples include the implementation of a financial reporting package tool and a daily automated query sending real‐time data to External stakeholders.Produce automated dashboards for all departments and executive management via SQL, ERP system, SSRS, Excel, Access, VBA, SalesForce, and Crystal Reports. Over 90 automated dashboards created including Accounts Receivables/Payables, Shipping, Warehouse Labor Planning, Aging Inventory, Vendor statistics, and Department P&L reporting.Provide ad hoc reports, analysis, and training to various departments and senior management.Lead process improvement projects, customer AR meetings, ERP system reporting upgrades, and new sales tracking.Responsible for $25k in time savings from process improvements in 2016.

Baltimore, Maryland, Us

Established procedures for internal audits, documented workflows, and incorporated documentation into company workflow documents.Met with end users to design, document and construct business solutions via SQL, MATLAB, Excel and Access to enhance data reporting and analysis capabilities.Independently worked with large data sets employing VBA and SQL to generate new data models, queries, tools, and reports to effectively analyze data and present conclusions to management.Created a repeatable mapping and uploading process to sync client data with company tables. Using new mapping process and reporting capabilities, company was able to charge extra fee to clients who chose to have company create monthly peformance reports for them.Developed process improvements to increase data accuracy and time savings. Implemented a Quality Review Program aiding in the increase of data input accuracy from 96% to 99% over eight months. Generated immense time savings by applying VBA knowledge, ingenuity, and business rationale including condensing a one‐month‐four‐person process into a two‐day‐one-person process and reducing a five day process to a four hour process.

Baltimore, Maryland, Us

Researched, confirmed, and processed voluntary and mandatory actions, adhering to hard deadlines.Calculated interest payments, corporate action impacts on funds, and fund share entitlements.Incorporated Bloomberg, Interactive Data Corporation, and custodian platforms into data inquiries.Actively pursued and accepted leading roles in projects including constructing a new Access database.

Baltimore, Maryland, Us

Prepared and reconciled mutual fund performance reports in Excel for financial reporting.Computed daily net asset values, dividend yields, FX rates, futures margins, and market value impacts.Collaborated with team members, other departments, and custodians to research and resolve issues with dividend payments, failed trades, and wire transactions.Composed dividend computation packages for tax reporting. Created innovative macros for daily process improvements and time savings.

Omaha, Ne, Us

Prospected and contacted prospective clients via marketing tools such as mailings, cold calls, and networking events. Met with potential clients to discuss their financial outlook and presented the benefits insurance and annuity products can provide in a balanced portfolio to achieve financial goals. Provided consultations on asset and retirement protection to families and individuals.

Washington, District Of Columbia, Us

Led a team of 3 for an internal audit of the management bonus program. Contributed design ideas for payroll informational brochures. Organized drug testing information in Excel spreadsheets and databases. Researched telework programs at five other agencies and presented results in reports to assist in improving IRS' program. Acted as a communication liaison between executive level management and mid-level management.

Annapolis, Maryland, Us

Created a client satisfaction questionnaire to help determine clients' perceptions during recession. Prepared quarterly reports and constructed a monthly markets update email. Improved upon a retirement planning spreadsheet to predict the success or failure of individual retirement portfolios.