Hire the Best Database Modeling Experts
in the United States

INTRODUCTORY I am a Advanced/Expert Microsoft Access Developer with over 20+ years (since 2001) Access experience. I can import/export your data, I can either modify an existing system or design a system from scratch based on your requirements, recommendations and direct input. I have many professional references that can attest to my easy-to-use, professional, robust and economical Microsoft Access databases. I am a great communicator and great documenter and can provide necessary training as needed. From a technical prospective, I fully utilize VBA coding (not macros) for my development style, I am well experience in SQL and can assist with older versions of Microsoft Access. I am very timely and available to discuss your system needs within a few minutes of our initial conversation. Find below some of my Microsoft Access Database Accomplishments: • Designed 7 Access DB’s for various teams to track productivity, appeals, complaints, etc. • Assisted in 20% decrease in TAT (turn-around-time) by creating 3-month analysis reporting • Designed Microsoft Access database used by 20+ users to store and track “do-not-call” members) • Designed Microsoft Access database that automated a previous manual process (saves 4.5 man hours) • Designed Microsoft Access database for handling over 600,000+ transactions per year and calculations. • Created email and fax interface ability within Microsoft Access System. • Designed Microsoft Access database responsible for State Parks reservations (55 state parks) • Designed Microsoft Access Payroll system, accruals, W-2 printing, weekly paychecks. • Designed Microsoft Access Elderly Abuse Tracking for Clark County (Las Vegas). • Designed Microsoft Access System for Storage Units. • Designed Microsoft Access System to track employees qualifications for working at Refineries. • Designed Microsoft Access System for tracking & entering cell phone payments. • Designed Microsoft Access Video check out system (equivalent to Block Buster). • Designed Microsoft Access Bail bond system (still current/active) • Designed Microsoft Access Payday Loan system (still current/active) • Designed Microsoft Access Title Loan system (still current/active) • Designed a time tracker/cost system keeps track of employee’s time (still current/active) • Designed Microsoft Access Asset Tracking System • Designed Microsoft Access Certified Training/Curriculum system • Designed Microsoft Access Salary Review/Compensation Tracker system for bonus structures • Upgraded many MS Access databases from previous version (i.e. 2000 to 2003 or 2003 to 2010, etc)

✅ Expert Vetted Top 1% Rated Plus Upwork Freelancer, based near Chicago with 10+ years of experience specializing in Data, Analytics, Engineering, Software Development, Product Management, Digital Marketing, and Social Advertisement. Data Engineering & Analytics Digital Marketing & Advertisement Software Development & Product Management I have a master's in Information Technology & Data Management from Illinois Tech and an executive program in Product Management from Northwestern University in Chicago. I was an adjunct professor at UCLA and VP of Product, Data & Analytics at ML/AdTech company. I have managed and led marketing teams running campaigns worth over $12M on Google, Facebook, LinkedIn & Twitter and marketing efforts like website building and overall marketing strategy. • Data Engineering & Analytics Data Warehouse ETL & Data Lake - AWS Redshift, Airflow, S3, Hive, Snowflake, Python, Lambda, EMR Analytics and Reporting - Excel, Google Sheets, SQL, MySQL, MS SQL Server, Postgres, Azure Data Factory Data Viz Dashboard - Tableau, Power BI, Google Looker Data Studio, Metabase Web Analytics - Google Analytics GA4, Tag Manager, Big Query, • Digital Marketing & Social Advertisement PPC SEM - Google Ads, Facebook Instagram Business Manager, LinkedIn Ads, TikTok & Twitter Marketing - Website Building (WordPress, eCommerce) & Onsite SEO Direct - Email and Text Marketing • Software Development and Product Management IT Management - Product Management, Product Ownership, Agile Scrum & Kanban, PI Software Development - PHP, JavaScript Node & React, HTML, CSS, API Integration, I believe in delivering the best data analytics, marketing and software application services employing the latest technology that gives the client a straightforward tool with a top-of-the-line user experience. Thank You for reviewing my profile.

• Azure SQL, Power BI, Azure Data Factory & Databricks working from last 4 years. • Highlight proficiency in Power BI Desktop, Service, DAX, M, and Data Modeling. • Converted SSRS Report to Power BI. • Extensive experience in T-SQL writing complex Queries, Stored Procedures, Functions, Triggers and Views. • Experience in Performance monitoring, SQL Profiler, Tuning, Query Optimization. • Experience in Replication Models (Snapshot/Transactional). • Employed SQL Server database to create and maintain Data Marts. • Experience in logical and physical database design, data structures, and data modelling. • Experience defining Data Warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services. • Experience in designing and implementing ETL packages using SSIS 2017/2016/2014 for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text file, Teradata) using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all. • Experience developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and deploying and Processing SSAS objects. • Expert in designing Enterprise reports using SQL Server Reporting Services. Generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS 2017/2016/2014.

I have worked with data for over 10 years and am an expert in analysis, database development, data mining, and data modeling. I have worked with web data and marketing campaign data and optimization. My skills also include ETL development and database design.

I am a Data Architect with a MCSA: SQL Server 2012/2014 certification. I have over 15 years of experience writing SQL/T-SQL queries and managing the Charleston County School District's internal relational data warehouse which is stored on a SQL Server. I develop C# applications in Visual Studio to accommodate user needs and as a way to provide accurate information to schools in regards to state accountability measures. I create and maintain SQL Server Integration Services (SSIS) packages that import the PowerSchool SIS Oracle data into a local SQL Server to be used for ad-hoc reports, and for the data integration into multiple vendor software systems, and automated 10+ scripts to streamline these data uploads into vendor software on a nightly basis. I also create and maintain student-level dashboards in SQL Server Reporting Services, which are used during teacher conferences. I am very efficient and dependable, and I am interested in helping other companies with their SQL and and web development needs.

From database design to Power BI dashboards — I deliver fast, reliable, and insight-driven data systems. I’ve helped 50+ companies optimize queries, automate ETL, and scale analytics with Microsoft SQL Server, SSIS, SSRS, SSAS, Power BI and Domo. Performance-focused | Cloud or on-prem . Contact me to get started WHAT I CAN DO FOR YOUR BUSINESS RELIABLE DATABASES (Microsoft SQL Server, PostgreSQL, MySQL, and more) Design and optimize SQL Server databases so your queries run faster, smoother, and at scale. Create business logic and build complex queries and stored procedures in T-SQL PERFORMANCE TUNING & OPTIMIZATION Identify bottlenecks and fine-tune SQL queries, indexes, and execution plans for maximum performance and reliability. FAST DATA PIPELINES (SQL Server Integration Services (SSIS)) Automate extraction, transformation, and loading of data (ETL)— clean and up-to-date data with zero manual effort. FLEXIBLE ANALYTICS MODELS (SQL Server Analysis Services) Build OLAP cubes and semantic models that allow decision-makers to analyze data from any angle. INSIGHTFUL DASHBOARDS & REPORTS (SQL Server Reporting Services (SSRS), Power BI, DOMO) Deliver clear, actionable visualizations that drive decisions based on facts, not guesswork. MY TOOLBOX Databases: MS SQL Server, PostgreSQL, Google Spanner, Google BigQuery, MySQL, Oracle Microsoft BI: SSIS, SSRS, SSAS, Power BI Other BI tools: DOMO (MajorDomo certified), Oracle Hyperion BI, SAP BI Languages: T-SQL, PL/pgSQL, other SQL dialects, MDX, Python, R Modeling: IDEF0/1/1X/3, UML, DFD (BpWin, ErWin, Rational Rose) LET’S TALK ABOUT YOUR PROJECT