As a Principal Data Architect with experience in driving efficiency, scalability, and cost reduction, I offer consulting services that help businesses leverage technology for maximum impact. I specialize in integrating user-friendly, reliable technology to enhance visibility, streamline operations, and enable growth.I develop tailored solutions that simplify systems, reduce friction, and create long-term savings. With a proven track record in managing IT teams, designing API integrations, and building business intelligence dashboards, I provide a range of services to meet your unique challenges.What I Offer:-System Integrations & Automation: I develop API servers that integrate SaaS platforms, reducing repetitive tasks and saving labor hours, allowing your team to focus on high-value activities.Data Architecture & Reporting: From scalable cloud databases to custom Power BI reports, I turn data into actionable insights, helping your business make data-driven decisions.Operational Efficiency: I identify and resolve inefficiencies, streamlining workflows and boosting productivity to reduce costs.-Custom Software Solutions: As a full-stack developer, I build custom software to address specific business needs, including portfolio management systems and client dashboards.Why Choose My Services:-Proven Impact: I’ve developed systems that sync multiple platforms, automate operations, and track progress, reducing overhead and improving resource efficiency.Scalability Focused: My solutions grow with your business. They are designed for long-term scalability, flexibility, and cost-efficiency.-Team Development & Training: I ensure your team can fully leverage the solutions I implement by providing training and streamlining documentation.Let’s work together to maximize efficiency, drive smarter decisions, and achieve sustainable growth.

bettercountry.shopbettercountry.etsy.com

At SKIS It’s a personal passion to bring the most reliable, effective, and user friendly technology that produces visibility and efficiency. Cost reduction and scalability is requirement. On a day to day I manage a small team to guarantee our company team members’ IT needs are served and that all daily technological dependent tasks are not interrupted. I am striving in investing into my team to see them succeed and to foster an “always improving” mindset. As help desk operations have become efficient, we have had more time to dedicate towards development of API Servers that sync multiple SaaS platforms together with the aim to reduce repetitive double entry so that labor hours can be reinvested into more meaningful and impactful and fulfilling tasks. Automation is a primary target.Any opportunity that presents itself for process improvement, we pursue it and brainstorm with our team on the best possible solution.We continually strive to be on the forefront of technological advances as this benefits the flexibility of our operations and continues to net efficiency which equals scalability.Achievements:- Developed API Server which syncs data from 5 different SaaS platforms using REST API and storing data into the SQL Database in Azure and also pushing data into other SaaS Platforms. Using Node.JS, Express.- Developed Help Desk Ticket System using AAD, MS Forms, MS Lists, Power Automate, Power BI, MS Teams, Email Forwarding, Phish and Spam Tracking.- Developed Inventory Manager using MS Teams- Developed Applicant Tracking System & Power BI Report- Developed Work In Progress Report 2.0 for Sales and Ops team that review active jobs on a daily and weekly basis which shows KPI’s and live data from our multiple SaaS platforms.- Developed personalized streamlined digital documentation central storage and access procedures for team elements while minimizing double entry and unnecessary sharing while maintaining security.-Knowledgebase Documentation & Videos.

Developing a custom Full Stack Web App for a client.Features:-Client Portfolio-Contact Company-Client Sign Up DB-Quote Generator-Sample Purchase & Shipping-Client Management Dashboard-Reactive Web App (All Devices)Technologies:-MongoDB-Express-React-Node.js-Material UI-Git-Server & Client-Heroku

Developing Business Intelligence Systems & Reporting Dashboards for Small Businesses using Microsoft Power BI & DAX, T-SQL, SSIS, Microsoft Visual Studios 2014, Microsoft SQL Server 2016, Microsoft Azure SQL Server & Any Relational Database (On-Premises or Cloud).SDSX Services:Data Model Evaluation included as part of consultation.One-Time & Recurring Weekly, Monthly, Quarterly, and Yearly Custom Reports. Customer provides the Data via Relational Database (On-Premises or Cloud) or via Excel, CSV, or Delimited Text File.Daily, Hourly, & Live-stream Reports Available (Relational Database Only; On-Premises or Cloud)Consulted CRM systems, implemented, and trained clients on effective use, documented, created custom procedures, follow-up training.Achievements:Created efficient systems & improved current systems: -Used Pivot Tables to aggregate and summarize large volumes of Data for management-Used Pivot Tables & Excel formulas to calculate Quarterly L&I Reports & CostsCreated custom Reports for managerial KPI analysis using MS Power BI:-Revenue Report, Job Profitability Summary, Job Profitability Detail, Company Profitability Summary, Current Cash, Future Cash, Jobs In Progress Detail, and Job Cost Detail Report.-Automated Recurring Profit & Loss Report Per Job-Planned, Implemented, & Delegated SOP’s and Plan for Managers and Staff to use to insure future clean & usable Data at entry points.-Created Quality Control System for Exporting and Reporting Dirty Data which is used to notify the data source user of incorrect entry.-Designed Database Model to Adapt to current software used by client at the time while proactively researching better software to provide quality data, integration with current systems, and to provide a consistent, efficient, and simpler user experience.-Create custom cost analysis reports to formally present proposed solutions with data and visuals to support conclusions.

Data Analyst / Manager Responsibilities:-Create Systems for Data Collection (Multiple Platforms & Sources)-Data Workflow-Create & Manage Database (SQL)-Create Custom Reports, Live Dashboard, Formulas, & Datasets (MSFT Power BI)-Analyze Reports & Create Strategic PlanI researched, trained, and successfully deployed an operational database used for production using Microsoft SQL server 2016 Standard into an on-premises server until we migrated our Database into the cloud with Microsoft Azure SQL database. I created a successful and stable ETL package using SSIS in order to extract, load, and transform data from three separate sources to fit our SQL database model. I re-linked all of the connections with our Business Intelligence software using the DAX query language in Microsoft Power BI Pro and created custom reports and dashboards based on the CEO, COO, and CRO's specifications and request. I continue to research and develop new reports and database techniques that can be used to further improve internal company visibility on performance & trajectory so that goals can be met and healthy growth stimulated. Data System Collection Analysis & DevelopmentBusiness Structure Analysis & DevelopmentSupply Chain OptimizationAdministrative Responsibilities:-Financial Reporting-Payroll-Tax Management-Human Resources-Accounts PayableI took care of the basic bookkeeping responsibilities such as receipt/bill entry into our systems as well as our monthly, quarterly, and annual tax filing and payments. I reconciled our books such as our vendor accounts, bank transactions for 10+ accounts, all of the respective records in our SQL database, Power BI reports, as well as our CRM software that contains our labor, client, and jobs data. I trained an administrative assistant to take over my data entry responsibilities so that I could focus on development at my Managers approval.

Administrative Responsibilities:-Labor Tracking-Data Collection-CRM Management-Site ManagementBusiness Structure Analysis & Development-Data Collection Systems-Job Costing Development-Operations Flow Analysis & Development-Profit & Loss Development

Administrative Responsibilities:-Financial Analysis & Reporting-Contract Management-Storage Management-Vendor Payments-Payroll-HRBusiness Structure Analysis & DevelopmentCommunications Structure Analysis & DevelopmentProcess Improvement

Commercial Contract Estimate, Bid, & Management:-Find Applicable Bid-Calculate Area (SQFT, LNFT, etc.) of Proposed Construction (Blueprints)-Collect Cost Data from Clients-Calculate Cost of Project for Client-Create Estimate/Bid-Deliver Estimate/Bid to Contractor-Manage Contract Status for Client-Hand Off Estimate/Bid to ClientOperations Flow Analysis & DevelopmentAchievements: Reduced 40 hours of work down to 1 hour of work per week by improving and creating new data collection and filtering system using online sources with Excel and Analysis Skills (SCRUM).