Apps Script Automation LLC

Simplify & Automate Google Sheets, Docs, Forms, Calendar, Gmail, Google Drive & more!
Integrate Google Workspace with Third Party Applications via their native APIs.
Help Business Owners Streamline Their Workflows with Google Workspaces.

Google Sheets Automation Expert

Trinity Health Of New England

Senior Reimbursement Analyst 

Financial Planning Analyst

State Farm

Develop leads, schedule appointments, identify customer needs, and market appropriate products and services.

Account Representative

Sherwin Williams

Cultivated relationships with new contractors and grew business with the existent client base by reaching out to over the phone and in person to determine needs and exceed them. Consistently surpassed customer expectations with extensive product knowledge and quality of service. Handled many aspects of inventory management as well as new employee training.

Sales Associate

💥 Ready to Save Time For You And Your Team? 💥

Most businesses only use the surface-level functions of Google Workspace. 

I can help amp up the power of your workflow.

❌ No more manual entry 
❌ No more piecemeal solutions
❌ No more wasting time
❌ No more confusion tracking KPIs
❌ No more miscommunication

Streamline your operations with Automations in Google.

With my expertise in Automations and Google, I can take your problem and create a solution.

I’ve created solutions in the following industries:

✅ Finance
✅ Ecommerce
✅ Accounting
✅ Agencies
✅ Logistics
✅ Event Planning and Production
✅ Construction
✅ Manufacturing
✅ Communications
✅ Food Industry
✅ Travel
✅ Medical
✅ and more

How can I help you?  What types of projects can I do?

Here is a small sample of real projects:

✔ Created dozens of Calendar Events from the click of a button in Google Sheets

✔ Sent leads into Google Sheets and then send to DocuSign

✔ Created connection between QuickBooks and Google Sheets - saved 1500+ hours/mo

✔ Sent automated emails each time a Google Form is submitted

✔ Automated order fulfillment between website and partner’s Google Sheets - saving 24 hours/month 

✔ Streamlined reporting process - saved 3 hours/day

✔ Created Marketing Dashboard which compiled reporting from Facebook, DRM and Google Sheet - saved 12+hr/mo of manual data entry

Take a look at my portfolio: https://www.paage.io/rwneakg/linkedin

-------- 

Need a custom solution or want to talk about your needs?
DM me to chat.

-------- 

Hear What Our Clients Say…

"Dennis helped us build out several dashboards in Google Sheets and did a fantastic job. Really high-quality work and an absolute pleasure to work with! Very thorough and methodical and took complex issues and made them simple!"


"Dennis is a wonderful person to work with and he created a very valuable catering management tool for my business. He was responsive to my needs and treated me very fairly. I look forward to working with him in the near future."  
~Dennis O. President Maple Tree BBQ


—---------

#SYSTEMS | #GOOGLEWORKPLACE | #GOOGLEWORKSPACE | #GOOGLE #GOOGLESHEETS | #AUTOMATION | #PRODUCTIVITY | #DATAWRANGLING | #GOOGLEAUTOMATION | #TECHNOLOGY

Dennis Krinitsyn

Central Texas College

Data Analyst, Office of Institutional Accountability, Curriculum Support & Grants

United States Army Human Resources Command

● Mentored a technical employee who utilized Power BI to create a dashboard that allowed IT leaders to visualize and analyze data from security event logs on 76 IT systems and databases.
● Facilitated the development of MS Excel pivot charts that provided insights to team leaders enabling them to focus resources and remediate over 1,200 high-risk software vulnerabilities on 23,000 devices.
● Oversaw the development and implementation of a continuous monitoring program that verified application and network compliance with cybersecurity technical implementation guidelines monthly, ensuring the system compliance percentage remained above 80%.

Deputy Chief of Staff, Communications Systems & Cybersecurity

● Guided the development of performance metrics that measured productivity of the organization with 70% of employees working remotely during the COVID pandemic, resulting in Senior Executive approval for the continued use of telework after restrictions were lifted.
● Identified and presented a critical funding shortfall required to transition 1,600 network circuits to a new service provider; obtained Senior Executive approval for the additional funding to complete the project, resulting in savings of $18 million annually.
● Reviewed and prioritized the organization’s budget requirements ensuring that the annual IT budget of $200 million supported the operations and maintenance of all mission critical infrastructure and systems.
● Led the analysis of the section’s key functions and personnel structure to identify areas that could be consolidated, resulting in a 10% reduction of military personnel.

Director, Information Systems

Texas A&M University

● Cleaned, manipulated, visualized, and analyzed raw data using spreadsheet software (i.e. Google Sheets), SQL (i.e. MySQL), and BI data visualization tool (i.e. Tableau).  
● Conducted an exploratory data analysis (EDA) to provide key stakeholders with data-based evidence of user success characteristics to make the business case for additional funding.
● Created DDL and DML SQL queries from formal and ad hoc data requests to draw insights and make data-driven recommendations to support company growth. 
● Built a Tableau Story with interactive dashboards and dashboard objects to report insights from the comparative analysis completed in Tableau Desktop to technical and non-technical stakeholders.

Tableau Data Analytics Certificate Candidate

US Army

● Identified $250,000 in excess procurement funding and obtained Senior Executive approval to utilize it to procure a new IT system that would provide reliable support for detention operations.
● Evaluated requirements and led the implementation of new technologies and IT capabilities such as video teleconferencing, WiFi, and cellular hotspots that enabled collaboration and ensured continuous detention operations under COVID-19 restrictions.
● Analyzed the section’s key functions and personnel structure to identify areas where functions could be consolidated, resulting in a 25% reduction of personnel.
● Provided oversight for a $1.5 million server/data storage infrastructure modernization project that increased storage capacity from 200 to 1.500 TB and enabled off site back-ups of critical data and records

Director Of Communications Systems

Army CIO/G-6

● Analyzed and defended over $500 million in IT funding requirements annually, ensuring IT services at 11 Army commands and 6 Strategic Command Centers were optimally resourced.
● Analyzed funding requirements in three programs and identified items cost efficiencies that helped achieve the Army goal of 5% reductions in program funding
● Identified $500,000 in unused procurement funding and facilitated their transfer to a high priority CIO project that modernized the warfighting network used by U.S. Forces Korea 
● Partnered with Army CIO budget analysts to draft coordinated responses to Congressional inquiries into funding for Army Enterprise Software Licenses and Enterprise IT services.

Branch Chief, Enterprise Services Branch

US Army Command and Control Support Agency

Division Chief, System Support Division

NATO Allied Command Transformation (ACT)

Information Systems Planner

Branch Chief, Enterprise Service Bus and Business Intelligence Branch

Data Analyst | Excel | SQL | Tableau | Top Secret Security Clearance | Army Veteran

I'm a data analytics professional leveraging experience in Information Technology Systems Management and as a staff officer to enable data-informed decision making in the U.S. Army. Experience cleaning, analyzing, and visualizing data with tools such as Excel, SQL, and Tableau. Building on a solid foundational knowledge of data systems and networks, I’ve focused on projects that allowed me to incorporate data analytics methods to improve operational, financial, and cybersecurity constraints to ensure stakeholder needs are met.

Would you like to view samples of my work?
- View my project portfolio here:  https://timzajac6.wixsite.com/timothy-zajac-portfo
- View my Tableau projects here: https://public.tableau.com/app/profile/timothy.zajac

Have any projects that you would like to share, a learning opportunity – or maybe any words of advice? Let’s chat!

taplio

The Battle

Dennis Krinitsyn

Timothy Zajac

Followers

Posts

Engagements

Likes

Ready to grow your LinkedIn presence?