Hire the best VBA Developers in Florida
Check out VBA Developers in Florida with the skills you need for your next job.
- $75 hourly
- 5.0/5
- (11 jobs)
I am a mechanical engineer with experience in project management, operations management and manufacturing. Experienced in: - VBA: Excel, Word and PowerPoint - Python, Google Sheets Apps Script, AutoHotkey -Sage 100 Reports and Business Insights - Task Automation - Power Automate, PowerApps - Will clean and parse large datasets I use VBA -Excel, Word and PowerPoint , Google Sheets App Scripts and Python scripting to save clients time, money and energy. I have generated solutions to analyze large data sets helping clients to understand their data and make actionable decisions. I have assisted clients by automating routine business processes allowing them to prioritize focus on the important aspects of their business.VBA
AutomationGoogle Sheets AutomationSpreadsheet SoftwareSpreadsheet AutomationGoogle DocsExcel FormulaGoogle FormsGoogle SheetsAutoHotKeyExcel MacrosVisual Basic for ApplicationsPythonGoogle Apps ScriptMicrosoft OfficeMicrosoft Excel - $50 hourly
- 5.0/5
- (110 jobs)
For the past 20+ years, I have been developing MS Access applications with all versions of Access (starting with the '95 version). I specialize in Access, and do not split my time on other disciplines (such as websites). During my 10+ years on Upwork (and elance and oDesk), I've successfully completed 80+ projects, totaling more than 1900 hours (1300+ hours on 'hourly' jobs & 600+ hrs on fixed-price jobs). 33% of these projects have been with repeat clients. Because of this experience, I have accumulated a toolbox of forms, queries, functions & subroutines that I can re-use on new applications. This enables me to keep the client costs down when developing new, or enhancing existing, applications. I have a job success rate of upwards of 90%, which is clearly reflected in my verbal & numeric feedback. I offer the following types of services: 1. Create turnkey database applications using MS Access (conceptualization, design, development & deployment). 2. Design normalized database structures. 3. Convert Excel-based applications to Access. 4a. Convert dBase & Lotus Approach applications to Access. 4b. Convert ADP projects to accdb databases 4c. Convert legacy mdb databases to accdb 5. Use Access VBA to import data from, and export to, Excel, CSV, text files & other Access DBs 6. Use Access VBA to automate creation of documents with MS Word mail merge & templates. 7. Deploy applications to the Cloud (via Citrix & Sharepoint). 8. Create documentation: System Manuals and User Manuals. 9. Deploy applications to tablet computers. 10. Create macros in Excel, Word & Outlook to automate various actions 11. Use VBA to control the contents and printing of labels to DYMO printers. 12. Use VBA Automation to control Excel, Word & Outlook. 13. Use Zebra label Designer software to connect to Access database & automate printout of labels. 14. Specialize in cracking legacy applications whose life has expired, and which are passworded. This includes applications based on Access and Word.VBA
Visual Basic for ApplicationsDatabase DevelopmentMicrosoft Access ProgrammingMail MergeDatabase ProgrammingDesktop ApplicationIBM Lotus ApproachMicrosoft WordDatabase DesignBusiness with 1-9 EmployeesMicrosoft Access - $100 hourly
- 4.3/5
- (32 jobs)
18+ years of professional development experience. Industry experience includes: Finance, Broadcast TV, Distribution & Transportation, Oil Services, Non Profit, Retail. ▬ Microsoft Full Stack Development ▬ Data Analysis, Data Modeling, Data Warehouse, Data Mart ▬ Data Integration, ETL, Data Quality ▬ Database Administration/Development ▬ SQL Server. SSIS, SSAS, SSRS, T-SQL ▬ PostgreSQL, MySQL ▬ Business Intelligence Solutions ▬ Software Development (.NET, .NET Core, MVC, C#, VB.NET) ▬ SAP Crystal Reports, Power BI ▬ Power Apps, SharePoint, Power Automate (Flow), Logic AppsVBA
Microsoft Power BIMicrosoft SQL Server Reporting ServicesVisual Basic for ApplicationsMicrosoft Power BI DevelopmentMicrosoft Access ProgrammingSAP Crystal ReportsMicrosoft SQL SSASData ModelingDatabase ProgrammingMicrosoft Access.NET FrameworkASP.NETXMLSQL Server Integration ServicesASP.NET MVCC#Transact-SQL - $100 hourly
- 4.9/5
- (98 jobs)
IT professional with 23 years of experience implementing software solutions for clients prior to becoming a freelancer. In my career I have worked in all phases of the software development life cycle (SDLC). I'm a problem solver with good communication skills. I have worked with clients at all levels. I bring this wealth of experience to my Upwork clients to effectively and efficiently deliver spreadsheet-based solutions to improve their business processes and save them time. Areas of proficiency and experience: - Complex Formulas (including Array Functions) - Advanced Lookup (including lookup on multiple values/fields) - Dashboards and Data Visualization - Power Query / Data Transformation and Loading - Complex Conditional Formatting - Performance Tuning - Data Validation - Tables and Pivot Tables - Charts - VBA/Macros - User Forms / Input Parameters - Helper Columns Notable Projects: - Automated payroll processing - Dashboards of varying complexity - Data analysis and survey charting - Stock Market Portfolio/Trade tracking (including equities, options, and futures) - Fulfillment/Sales/Inventory (e.g. amazon) - Modeling - Investment Performance and Trade Tracking/Reporting - Monte Carlo Simulation - Estimation/Invoices I am now freelancing exclusively and look forward to the opportunity to work with you.VBA
Visual Basic for ApplicationsRequirement AnalysisBusiness Process ReengineeringETLData AnalysisData ScienceSpreadsheet SoftwareData VisualizationMicrosoft Excel - $100 hourly
- 5.0/5
- (24 jobs)
As a TOP RATED and HIGHLY RESPONSIVE Real Estate Freelancer, I specialize in providing Commercial Real Estate Consulting and Underwriting Services for Multifamily, Office, Medical Office, and Retail properties. With over three years of experience as a Private Equity Real Estate Analyst and two years as a Private Consultant, I offer valuable insights and analysis that help clients make informed investment decisions. Using specialized tools such as advanced Microsoft Excel, CoStar, Real Capital Analytics, and Esri Business Analyst, I paint a clear picture of markets and properties, giving my clients the information they need to succeed. My 100% client satisfaction rating speaks to my commitment to providing the most significant benefit for the lowest reasonable cost. I am highly responsive to my clients' needs and work tirelessly to ensure their questions and concerns are addressed promptly. My communication skills have been praised by clients, and I am confident that I can deliver exceptional results on any project. If you're looking for a skilled and experienced real estate freelancer who can help you achieve your investment goals, look no further. Let's work together to make your next project a success!VBA
Real EstateVisual Basic for ApplicationsReal Estate Financial ModelingMicrosoft ExcelFinancial AnalysisUnderwritingFinancial ModelingArgus - $100 hourly
- 5.0/5
- (7 jobs)
I am a real estate professional with experience in loan and equity origination, asset management, and portfolio management. Take a look below to see how I can help with your investment process. How I Can Help: * Property underwriting for all major property types * IRR and equity multiple cash flow waterfalls * Debt spreadsheets to handle construction, perm, mezz, and floating debt * Fund models for private equity * Underwriting models for all major property types * Sensitivity scenarios to stress test investmentsVBA
Real Estate Investment AssistanceVisual Basic for ApplicationsPortfolio ManagementReal Estate Financial ModelAsset ManagementPro Forma StatementFinancial AnalysisMicrosoft ExcelFinancial ModelingFinancial Projection - $80 hourly
- 5.0/5
- (2 jobs)
Here to serve you and your business. Customer service is my #1 priority and making sure you understand your financial situation and are ready to go come tax time. My Background: - 9 years of corporate finance/accounting experience - Masters degree in Accounting - Bachelors degree in Finance - Certified QuickBooks Pro Advisor - Provide Tutoring for Undergraduate/Graduate Accounting CoursesVBA
ERP SoftwareMicrosoft OfficeFinancial ModelMacrosFinanceForecastingFinancial ModelingBudgetBookkeepingVisual Basic for ApplicationsMacro ProgrammingEssbaseOracleVLOOKUPMicrosoft Excel - $68 hourly
- 4.9/5
- (12 jobs)
⭐TOP RATED - Top 10% on Upwork! ⭐ Senior Data Scientist ✅Unlimited revisions ✅Clear explanations ✅Well-documented code ✅ Actionable insights ✅Fixed Fee Guarantee ++ Don't spend time, money, and effort posting a job -- reach out to me directly instead! I'm a Senior Data Scientist with a Master's in Statistics and a Master's in Mathematics Education, and I have a background in academia, government, and the private sector. I specialize in statistical analyses, data organization, and modeling. I'd love to hear from you! * Statistical Consultant - 6 years * Excel and VBA- over 15 years of experience * R and R Shiny - over 10 years of experience * SAS - over 8 years of experience * AI - over 7 years experience * Python - over 5 years experience ++ Need to know exactly what it is going to cost? I have a Fixed Fee Guarantee -- send me your data/proposal/documentation, and I can offer a flat fixed fee for a guaranteed price instead of an hourly fee!VBA
Statistical InfographicAnalytics DashboardStatisticsData ModelingVisual Basic for ApplicationsData AnalysisSurveyPsychometricsTableauArtificial IntelligenceMicrosoft ExcelPythonRSASData Analytics - $55 hourly
- 5.0/5
- (148 jobs)
I have been designing Excel spreadsheets for over 15 years professionally. I also have several years experience designing spreadsheets on Google Sheets. I have helped several companies incorporate data from forms, surveys, and other data collection services into Google Sheet and Excel. I can write macros and scripts to perform repeated tasks (such as reformatting data sets) quickly with the click of a button or menu dropdown. I helped design the spreadsheets used by Family Dollar's corporate office which compiles and sorts all the debit card transaction data for their over 6,000 retail stores to help with month end reconciliations. I performed accounting and audit tasks for a large cell phone company and am an experienced data entry professional.VBA
Visual Basic for ApplicationsGoogle SheetsBank ReconciliationData AnalysisSpreadsheet SoftwareGoogle Spreadsheets APIData EntryMicrosoft ExcelWord ProcessingMicrosoft Word - $250 hourly
- 5.0/5
- (71 jobs)
Expert Vetted by Upwork. I'm currently the co-founder and CSO of a startup. I was previously co-founder/CEO of a mobile app startup. "C.E.O." really stands for Chief Everything Officer. I started my mobile app startup with no prior tech/startup background and have been through it all, so I know what works and doesn't work. I know how to build businesses and sell businesses to investors. I consult on the following: - Growth, capital-efficiency-oriented, and process-driven fractional CFO - Building Initial Enterprise Sales Funnels - Finding initial product market fit, early customers - Product/Sales/Marketing Strategy - Process design and implementation for customer acquisition funnel (huge champion of automation and AI integrations) - Startup/Management/Strategy - Product Development/Go-To-Market/Growth Hacking - Angel/Venture Funding Strategist Here are a few secrets: - Capital raising: You don't need a written business plan to get funded. No one reads them. To get funded, you need a strong team, good storytelling, a pitch deck, financials (historicals are 10x more valuable than forward projections), revenue/customer retention analysis, and an appendix. - Since Q2 2022, enterprises to SMBs have shifted their focus towards margin preservation, emphasizing cash flow, and being as lean as possible. The future of management is labor force elasticity based on gross margins, running your company with an extremely lean and elastic approach that is grounded on gross margin preservation/expansion -- having a system in place that allows you to quickly ramp up and ramp down your operations to match market demand, regardless of the economic conditions. Highlights: - CFO at an AI-driven software development SaaS company. (2023 - Present) - Currently VP of Strategy & Growth for an early-stage B2B DevOps SaaS startup. (2021-present) Results during my tenure: Reduced our S&M spend by 60%, Reduce our average CAC from 11.4K to 2.6K. Accelerate our LTM ARR growth from 49% to 94%. Our forward NTM ARR growth rate is +160%. - Fractional CFO at 3 startups, including a smart light bulb e-commerce startup with $30M+ LTM revenue; responsibilities include capital raising/planning and M&A advisory. (2021-present) - Startup consultant primarily focused on capital raising, strategic planning, market sequencing, critical path, GTM strategy, sales funnel, process improvement/automation -- Industry/vertical agnostic - B2B, B2C, B2B2C, Marketplace, On-Demand models. (2016-present) - Consultant for G2VP, San-Fran-based ESG VC (2020-2022) - Ex-CEO/Cofounder of a B2B (pivoted from B2C) AdTech mobile keyboard app startup (raised outside capital and exited). (2013-2016) - Ex-CPA for Ernst & Young in NYC, working in the Financial Services Transaction Services group. I provided valuations for private businesses in M&A deals ($1 billion+ market cap) and illiquid financial instruments. (2008-2013) I love the startup community and want to give back. My time is limited and valuable so I only want to work with companies I know I can add a lot of value. Sorry, need to exclude pre-revenue companies and companies below 250K ARR. I will pass on work for another startup if I do not think I can help it become successful or are belowVBA
Copy EditingVisual Basic for ApplicationsMarketing StrategyFinancial ModelingLean ConsultingVenture CapitalVenture Capital ConsultingMicrosoft Excel PowerPivotCorporate FinanceProofreadingStartup ConsultingPersonal BudgetingManagement ConsultingMicrosoft ExcelProduct Design - $150 hourly
- 5.0/5
- (43 jobs)
I have worked for over 10 years as an actuary and utilize the power of Excel daily in my job. I am also an ASA in the society of actuaries and a member of the American Academy of Actuaries. As an actuary, I have extensive experience in reserving, data manipulation and mining to develop trends, financial forecasting, risk score analytics and price model development. In my career I have taken on numerous complex projects from the planning phase through the completion and presentation phase. My work also requires me to work with large data sets in Excel to develop complex projection models. I have 2 core competencies that define my process of working in Excel : 1. Most projects assigned to me in my work life are very abstract with just an end goal in mind. I have honed my ability to take those abstract ideas and focus them into an Excel solution that not only meets the end goal, but incorporates other critical elements that were not identified in the initial assignment 2. Workbook structure has to be well defined and documented so that the file is easy to navigate and update since most projects are not one-offs. Color coding, instructions, name definitions are just a few of the techniques I use to make sure every project is clear, concise and easy to update. My experience has prepared me to take on jobs ranging from simple excel workbook solutions to complex actuarial analysis. No job is too small or too big for me to take on.VBA
Microsoft ExcelStatistical AnalysisSQLStartup ConsultingInsurance & Risk ManagementFinancial ModelingData VisualizationVisual Basic for Applications - $125 hourly
- 5.0/5
- (9 jobs)
I am an experienced analyst with a background in manufacturing, finance, FP&A, consulting, supply chain management, sales and marketing, strategic planning, as well as cross functional leadership, running and implementing sales and operations planning process. My well rounded experience has given me a stand-alone advantage to truly understand business strategy side with the technical side. I have excelled as an analyst as well as identifying solutions and implementing new processes. I have also lead implementations teams for ERP, MRP and CRM. I have developed a unique set of skills that has kept me successful in my roles, which is defining and designing appropriate data architecture and structure to meet the companies needs from a functional systems perspective as well as data design for reporting. The most important implementation concept I practice is ensuring to align the data structures with the companies long term strategy to insure the data integrity stays intact through company changes over time and that everything stays organized in a meaningful way to the business. Outside of the manufacturing industry, I have worked in New York in the finance industry and was a key stakeholder in building out a finTech platform for taking B2B loans from just over a week to fund to just a few hours. utilizing numerous data sources for establishing credit risk, while building out extended workflows tying in CRM and building out an intelligent marketing system to identify low risk opportunities that best fit the ideal funding candidatesVBA
Financial AnalysisMicrosoft OfficeMicrosoft ExcelTableauProcess ImprovementMarketing AutomationVisual Basic for ApplicationsWinAutomationAlteryx, Inc.Management Consulting - $75 hourly
- 5.0/5
- (1 job)
Detail-oriented engineer/developer with 20 years experience and outstanding analytical and communication skills. Specialties: Web Development & Programming (PHP, Perl, and more), Database Administration (SQL Server, MySQL), Data Analytics and Automation (Excel, VBA, Tableau) Need help with Excel or a macro? I can help! Need help with a web script? I can do that! Need help with Tableau or building a dashboard? Just ask! I absolutely love solving problems, so let me do what I love! Looking forward to working with you, JenniferVBA
App DevelopmentMicrosoft SQL Server ProgrammingPerlPHPMySQL ProgrammingHTMLVisual Basic for ApplicationsTableauData AnalysisMicrosoft Excel - $100 hourly
- 5.0/5
- (13 jobs)
Projects and Experiences as Controller and Finance Manager * Controller / Finance Manager for 2 Fortune 100 Companies; GE and International Paper * Major contributor in achieving increased EBIT for box plant with $75MM annual sales and Metal Ship with $6.5MM annual sales * Actively providing feedback to QuickBooks Advanced Programmers for customer improvements * My client was selected by Intuit QuickBooks to do a 6-8 minute video about the company, to be viewed by 400 top leaders and executives. First time company has done this. * 9 ERP and System Implementations: 4 SAP, 1 QuickBooks, 1 Sage, 1 Witron, 1 ADP, 1 Visual * Created strong Internal Controls throughout the Accounting Department, resulting in a reduced invoicing from 18 days to 3.5 days, increasing cash flow in a timelier manner, and decreasing DSO from 62 days to 38 days. * Month end close from start to finish; reconciling accounts, managing payroll, and preparing accounting and financial reports (Income Statement, Balance Sheet, Cash Statement), and high-level explanations and anomalies * Implemented and drove an effective initiative for rollout of Visual Business Solutions (VBS). Saving the company $30,000 on an $85,000 budget. Created over 60 Work Instruction procedures for sales, operations, purchasing, customer service and accounting. * Lowered freight rates by $200,000 in 2012 by collaborating with shipping manager and creating a freight cost spreadsheet that compared contracted rates to actual rates and identified the higher priced carriers per lane. Achieved the above even with an 8% freight rate increase and the freight surcharge doubling. * Created chart of accounts for project-based machine shop 150 accounts to over 600 accounts. * Designed 13-week cash flow projection model measuring: the DCF, WACC and CAPEX of past, current and future projects. Business looking to implement 2 new additional lines and building the model provided the information to make an informed decision to delay 1 line. Human Resource and Recruiter Experience: * 2.5 years as a Recruiter hiring manufacturing floor workers all the way to C-level executives. * 5 years directly hiring candidates: scanning 1000s of resumes and vetting hundreds of candidates including: speaking to the candidate directly for further resume clarity, setting up official interviews (via face-to-face, video, or phone), conducting interviews, and contacting references. *Reviewed all benefits on a yearly basis, insured proper compliancy with the Affordable Care Act (ACA or Obamacare), and once a company reaches over 50 employees ensuring Federal and State compliance with FMLA laws are being followed and proper reporting. * Reviewed and rewritten portions ofVBA
Financial ModelingQuickBooks OnlineVisual Basic for ApplicationsCorporate FinanceBookkeepingCost AccountingIntuit QuickBooksGAAPCash Flow AnalysisMicrosoft Excel - $30 hourly
- 5.0/5
- (33 jobs)
I have some 25 years' experience in proofreading, editing, and writing in a wide variety of academic and nonacademic disciplines. My projects range from research publications to general interest books as well as fiction. I write research reports and software documentation. I develop and document Microsoft Office macro tools, styles, and templates and LaTeX styles and packages. I also perform statistical analyses using PSPP (for SPSS), Excel, and R.VBA
ProofreadingAcademic WritingTechnical WritingWritingLaTeXSoftware DocumentationPerlStatisticsCopy EditingVisual Basic for Applications - $50 hourly
- 5.0/5
- (3 jobs)
I will work diligently to understand and deliver your needs. With my expansive resources, I will get the job done correctly and on time. I am a Microsoft Certified Solutions Expert, a Microsoft Certified Power BI Analyst, and have over 15 years of experience in IT, primarily with SQL database programming, data warehousing, and business intelligence / reporting. My most recent experience is with SQL Server 2016, mySQL, SSIS, SSRS, Power BI, and Excel/VBA. My sweet spot is in SSRS, T-SQL programming, and Performance Tuning, and I have worked in these areas with the following companies: • Toppan (DuPont) Photomasks, Inc (Global Fortune 500) • Oracle Corporation (Fortune 500) • McKesson Corporation (Fortune 500) • DEFEND (Non-Profit Startup) • CertifiedAceSolutions.com (Database Consultant Service) • Designing and maintaining SQL scripts, and complex stored procedures • Building SSIS packages to move data from text files and Excel into SQL Server • Building highly customized Excel applications with VBA. • Building custom reports and dashboards using SSRS and deployment to online reporting servers • Creating Power BI dashboards and migrating SSRS reports to Power BI • Installing, configuring, tuning, and troubleshooting SQL Server and mySQL • Creating conceptual and logical database designs • Implementing a new physical database system from concept 🌟 I also have expert level skills in Excel and VBA. 🌟 I am owner of Certified Ace Solutions, LLC, a database consulting company specializing in Microsoft database related technologies. We strive to create strong and lasting partnerships with our clients. 🌟 I am affiliated with another consulting company, Agile Infoways, so I have vast resources to get projects completed efficiently.VBA
Microsoft ExcelVisual Basic for ApplicationsSAP Crystal ReportsMySQL ProgrammingData Warehousing & ETL SoftwareSQL ProgrammingSQL Server Integration ServicesData MigrationDatabase DesignDatabase OptimizationMicrosoft SQL Server ProgrammingETLMicrosoft Power BITransact-SQLMicrosoft SQL Server - $250 hourly
- 5.0/5
- (5 jobs)
I have 15+ years of experience in financial services, including 6 years in investment research and portfolio management at the largest Emerging Markets macro hedge fund. Currently, I partner with consultancies, hedge funds and family offices to develop systematic macro strategies and portfolios. At Pharo Management, a $12bn Emerging Markets hedge fund, my investment strategies were the second biggest contributor to the overall fund performance. I also managed a $100mn high conviction investment portfolio of credit, FX and interest rate assets, generating double digit annual returns and a Sharpe ratio of 2.25. At Noble Group, I traded gasoline, diesel and other oil liquids, while also working on large multi-million dollar deals in the oil and gas sector. I can help you with signal generation, backtesting, development and portfolio management. I can also build and test for you econometric and financial models. Areas of expertise: -- Performing financial and economic analysis -- Developing investment strategies and ideas -- Financial and economic modeling and forecasting -- Building econometric and statistical tools -- Designing risk management processes In addition to my quantitative and analytical skills, I have an extensive network of relationships with industry analysts, investors, traders and policymakers. Importantly, I bring to bear a global perspective, having lived and worked in 3 different continents and 2 global financial centers - London and New York. Please send me a message and I am happy to discuss your needs and how I can help.VBA
Trading StrategyEconomicsTrading AutomationFinancial TradingForex TradingRVisual Basic for ApplicationsQuantitative FinancePortfolio ManagementEconometricsInvestment StrategyMathematicsCompany ValuationFinancial AnalysisStatistics - $75 hourly
- 0.0/5
- (1 job)
Certified Public Accountant with 5+ years of diverse accounting experience and extensive knowledge of financial systems. Expertise in increasing the granularity of reports through advanced Excel and modeling techniques. Skilled in Oracle Database, Operational Analysis, QuickBooks, Visual Basic for Applications (VBA), and Microsoft Excel. Proven background reducing process time and input error by automating reports and accounting practices.VBA
Visual Basic for ApplicationsBookkeepingMicrosoft Excel PowerPivotFinancial AnalysisQuickBooks OnlineIntuit QuickBooksBank ReconciliationAccount ReconciliationMicrosoft Excel - $35 hourly
- 5.0/5
- (2 jobs)
Doubled Major in International Business and Finance. Experience in the commercial banking sector. Experience in Accounting and Credit. Task and people-oriented committed to my community and improved my professional self. Strong interpersonal skills with experience in handling individuals from different cultures. Praised for being optimistic, organized, and proactive. I'm constantly looking to innovate and streamline processes. Creator of SMMAFinance, a personal finance blog (bilingual) with the aim of providing financial education to everyone. Currently coursing a Master in Finance at EAE Business School located in Madrid, Spain. Open for opportunities in Madrid's banking/finance sector.VBA
Visual Basic for ApplicationsInternational BusinessSpreadsheet SoftwareFinancial ManagementCorporate FinanceFinancial ModelingFinancial AnalysisBusiness Analysis - $30 hourly
- 5.0/5
- (1 job)
As a seasoned MS Access developer with over two decades of experience, I have honed my skills to deliver custom solutions that streamline workflows and boost productivity. I am committed to creating user-friendly databases that cater to your unique business process. My track record of delivering successful solutions to small businesses and the State of Michigan is a testament to my expertise. Whether you require an update to your existing database or a brand-new one built from scratch, I am fully prepared to assist you. My aim is to help you transform your project into an automated system that optimizes efficiency and productivity. I am eager to work closely with you, leveraging my expertise to propel your company to new heights. Your input and needs are paramount to me, and I am dedicated to ensuring your satisfaction with my work. Please don't hesitate to contact me if you require any assistance. Let's collaborate to make your work more accessible and elevate your business to new heights. Technical Skills: Database Design: • Normalization: Understand how to normalize data to reduce redundancy and improve efficiency. • Entity-Relationship Diagrams (ERD): Be able to create and interpret ERDs to design databases. Tables and Relationships: • Create and manage tables. • Define primary keys and foreign keys. • Establish one-to-one, one-to-many, and many-to-many relationships. • Enforce referential integrity. Queries: • Write and optimize SQL queries. • Create Select, Update, Delete, and Insert queries. • Use query wizards and design view. • Work with aggregate functions and grouping. Forms: • Design and customize forms for data entry and user interaction. • Use controls like text boxes, combo boxes, and buttons. • Implement form events and VBA code behind forms. Reports: • Create and format reports for data presentation. • Use grouping, sorting, and filtering in reports. • Implement calculations and expressions in reports. Macros and VBA: • Automate tasks using macros. • Write VBA code for advanced automation and customization. • Debug and troubleshoot VBA code. User Interface Design: • Design intuitive and user-friendly interfaces. • Implement navigation forms and switchboards. Data Import/Export: • Import and export data from/to various formats (Excel, CSV). • Link Access with other databases (SQL Server).VBA
Data ModelingDatabase ReportDatabase QueryMicrosoft Access ProgrammingDatabase ProgrammingMicrosoft ExcelForm DevelopmentReport WritingQuery LanguageVisual Basic for ApplicationsDatabase DesignSQLMicrosoft Access - $15 hourly
- 4.7/5
- (5 jobs)
Passionate engineer driven to improve workflows and processes through automated tool development, safety, and efficient process design. Highly skilled in Visual Basic and data analysis , including statistics.VBA
Chemical EngineeringSix SigmaProcess ImprovementProcess SafetyProcess EngineeringProcess Flow DiagramProcess DesignData EntryData AnalysisPower QueryMicrosoft Excel PowerPivotExcel MacrosExcel FormulaVisual Basic for ApplicationsVisual Basic - $45 hourly
- 0.0/5
- (0 jobs)
Key Qualifications * Provides over a decade of high level credit analysis and origination experience. * Well versed in a diverse array of credit and fiduciary products * Strong understanding of general market and securities characteristics. * Experienced structuring, modeling, and marketing throughout the capital stack. JV structures, preferred equity, mezzanine, senior debt, and ground lease facilities. * Data Proficiency in Excel(VBA/Macros) SQL, Tableau, BLOOMBERG, Argus CRE, Moody's Analytics, SalesForce * Moody's Analytics - Certification in Commercial CreditVBA
MacrosMicrosoft OfficeJiraSalesforceAnalytical PresentationSQLEconomicsCapital MarketsUnderwritingDue DiligenceAnalyticsVisual Basic for ApplicationsMicrosoft ExcelFinancial StatementFinancial Report - $60 hourly
- 0.0/5
- (0 jobs)
Microsoft Word Guru Procedure Professionals Assocation Certified Nuclear Procedure Writer with extensive experience using Chicago Manual of Style (CMOS). I have experience in creating clear and user-friendly documentation. I have developed a strong skill set that combines technical writing expertise with Microsoft Word template automation. With 20+ years of experience, I have gained expert level status for technical writing, proofreading and editing. My expertise enables me to translate complex technical concepts into easily understandable content for a wide range of audiences. I am skilled at coordinating resources, prioritizing tasks, and meeting project deadlines while maintaining a high level of quality in deliverables. Using VBA, I have developed tools to mitigate human error for writing and proofreading. These tools make it possible to do more work with less people. I use a systematic approach to training (graded approach) to develop training programs and content for new joiners and existing employees.VBA
Document ConversionDocument ControlDocumentumAdobe AcrobatMicrosoft VisioTraining & DevelopmentMicrosoft Office SharePoint ServerMicrosoft OfficeBook EditingEditing & ProofreadingTechnical WritingVisual Basic for ApplicationsAcademic EditingTemplatesMicrosoft Word - $50 hourly
- 0.0/5
- (0 jobs)
Solana Blockchain Experienced in tracking SPL token transactions on Solana using WebSockets( QuickNode, ALchemy, etc). Proficient in real-time transaction logging, WebSocket connection management with automatic reconnection, and implementing asynchronous event loops in Python for efficient blockchain data processing. Python Development: Experienced in Python programming, including web scraping, API integrations, and error handling. Familiar with libraries like transformers for NLP tasks such as summarization and chatbots. Ability to modularize code for better organization and maintainability. Linux (Kali and Ubuntu): Proficient in working with Kali Linux, particularly for security and penetration testing tasks. Skilled in setting up and managing virtual machines with Linux systems. Experience using WSL on Windows 11 to run Linux distributions effectively. MongoDB: Comfortable installing, configuring, and managing MongoDB databases. Experienced in integrating MongoDB with backend systems for scalable database solutions. Node.js: Basic to intermediate knowledge of Node.js, particularly for backend development and connecting frontend applications with MongoDB. Database Expertise: Proficient in Microsoft SQL Server and MongoDB. Understanding of database design, querying, and data management. Web Development: Knowledge of modern frontend development practices, including creating interactive UI components. Strong focus on ensuring the frontend matches original designs with improved functionality. Cybersecurity: Familiarity with cybersecurity concepts and tools, including ARP cache management and using virtual machines for secure environments. Actively studying for certifications like COMPTIA Security+, Linux+, and Network+. Blockchain and Cryptocurrency: Beginner-level understanding of blockchain development, experimenting with Solana devnet for learning and testing purposes. General Programming and IT Skills: Proficiency in modularizing projects for ease of use and maintainability. Logical problem-solving abilities and experience with debugging complex systems. Upwork Profile Description: Skilled Python Developer | Linux Expert | MongoDB & Node.js Specialist I'm an experienced Python developer with a passion for building efficient, secure, and scalable applications. With expertise in Linux environments (Kali and Ubuntu) and a strong foundation in MongoDB and Node.js, I specialize in creating solutions that seamlessly integrate backend systems with modern web technologies. Here's what I bring to the table: Python Development: Crafting clean, modular, and efficient code for automation, APIs, and chatbot applications. Linux Proficiency: Advanced skills in Kali and Ubuntu Linux for development, security, and virtualization tasks. Database Management: Expertise in MongoDB and MS SQL, ensuring optimized database design and implementation. Backend & Web Development: Experience in Node.js and frontend integration for a smooth user experience. Cybersecurity Awareness: A strong focus on secure coding practices, fortified by ongoing studies in COMPTIA Security+ and Linux+. In addition to my technical skills, I thrive on logical problem-solving and have a proven track record of simplifying complex projects into manageable and modular components. If you're looking for a dedicated professional to bring your ideas to life, let's collaborate!VBA
Node.jsTesseract OCRWiresharkKali LinuxPythonMongoDBMarketing StrategyMarket AnalysisMicrosoft ExcelVisual Basic for ApplicationsMicrosoft AccessMicrosoft Access Programming - $35 hourly
- 0.0/5
- (0 jobs)
I am a software developer with experience in Object Oriented Programming and Excel VBA. I have a passion for helping automate processes to save you time and I can help you do that with my extensive experience in programming and Excel. There is no job too small in Excel that I am willing to do.VBA
Microsoft ExcelExcel FormulaVisual Basic for ApplicationsExcel Macros - $80 hourly
- 0.0/5
- (0 jobs)
Qualified and passionate software engineer. Adept in programming, systems maintenance, systems architecture, applications/data migration, database, tests, and deployment. Highly skilled IT Specialist in Core Banking, Card and Digital Payments (issuing and acquiring), and Point of Sale applications. Since March 2022, Lorenzo has been a Business Analyst at Tata Consultancy Services (TCS), assigned to Bank of America (Technology - Merchant Applications) as a Payment Support Engineer (L3). Between January 2021 and February 2022, he was a Business Analyst at Fiserv, where he played the Project Analyst role in implementing Fiserv's Credit Card projects (Optis) integrated into DNA Core Banking. Previously, Lorenzo worked at the Walt Disney Parks and Resort company in the Finance Business Operations (Payment Services) from February 2018 through August 2020, in charge of the requirements definition, test script design, and test validation for cardVBA
Grok-1Llama 3.1Claude 3.5 SonnetOpenAI APICSVMicrosoft ExcelVisual Basic for ApplicationsAlgorithm DevelopmentAI App DevelopmentAI Agent DevelopmentDatabaseSQLWeb ApplicationMobile AppArtificial Intelligence - $33 hourly
- 0.0/5
- (1 job)
I am a professional Project Manager with over 13 years of experience in Process Improvement and Automation. I have managed projects in both IT and Marketing fields. Over the past three years, my primary focus has been with SEO and CTA’s through the form of web content, blog posts, and article writing. The first eight years of my career held a heavy focus on business models and project structure. This involved a heavy influence of process improvement techniques along with automation to limit human error. During this time, I also obtained certificates in IT Accounting and Project Management. I also obtained my Bachelor’s degree in Information Technology. Three years ago, I turned back to my original focus, what I got my Associates degree in, Marketing (with a focus in writing). I am extremely passionate about writing. I can provide a unique perspective to writing by offering different styles, tones and voices. I have extensive experience in providing e-commerce companies with SEO optimization via blog posts, articles, product reviews, and social media posts. While working for a small startup company, I specialized in Marketing Content with a heavy focus on SEO. I oversaw the successful completion of several large-scale marketing concepts that lead towards growing their user base and unique rich content. Put simply, I seek positions that offer goal-oriented work. I strive for results and refuse to accept mediocre. My wish is that you allow me the opportunity to show you that my goal-oriented approach towards success is exactly what your organization would benefit from.VBA
Visual Basic for ApplicationsAdobe FlashAdobe Creative Suite Want to browse more freelancers?
Sign up
How hiring on Upwork works
1. Post a job
Tell us what you need. Provide as many details as possible, but don’t worry about getting it perfect.
2. Talent comes to you
Get qualified proposals within 24 hours, and meet the candidates you’re excited about. Hire as soon as you’re ready.
3. Collaborate easily
Use Upwork to chat or video call, share files, and track project progress right from the app.
4. Payment simplified
Receive invoices and make payments through Upwork. Only pay for work you authorize.