Richard Merritt
IT Professional
Katy,TX
Summary
Passionate "Go-Getter" IT professional with over 10 years of experience including project management, requirement gathering, and Business Intelligence. Has worked as project manager, business analyst & consultant, and Business Intelligence specialist and on various AGILE teams. Innovative individual who has an exceptional ability to lead, foster teamwork, collaborate and turn vague requirements into tangible business solutions.
Overview
18
18
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
SQL Programmer & Client Engagement Specialist
Donor Direct
Dallas, TX
07.2021 - Current
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance.
- Created business intelligence tools to capture client metrics.
- Maintained knowledge of diverse programming domains to integrate multi-disciplinary assets into products.
- Reported on updates to project specifications and progress.
- Designed custom dashboards and reporting interfaces.
- Tested server code to validate code changes.
- Worked with cross-functional design teams to create software solutions that improved overall functionality and performance.
- Contributed to codebase used in software deployment on multiple virtual machines.
Executive Director
Levelduplife, Inc.
Katy, TX
02.2018 - Current
- Attracted major donor, generating $5000 in annual revenue under new expansion community project.
- Negotiated new annual contracts and service agreements with vendors to achieve prime pricing.
- Updated and maintained membership database on consistent basis.
- Provided exceptional counseling, case management, education and job training to diverse client base.
- Aligned department vision, goals and objectives with company strategy to achieve consistently high results.
- Exercised appropriate cost control to meet budget restrictions and maximize profitability.
- Recruited new members by networking at community events and distributing promotional materials to attendees.
- Worked closely with organizational leadership and board of directors to guide operational strategy.
- Drove strategic improvements to enhance operational and organizational efficiencies.
- Prioritized and allocated valuable resources to meet business targets.
- Created promotional materials and provided insightful information to social media, websites and print media to educate public.
- Spearheaded successful business development initiatives aligned with company's strategy and core competencies.
- Led recruitment and development of strategic alliances to maximize utilization of existing talent and capabilities.
Business Intelligence Developer
Vermeer Texas-Louisiana
Dallas, TX
06.2020 - 07.2021
- Responded to specific BI requests from Management personnel, creating data packets with requested information in easily understandable formats
- Spear Headed database reporting project by migrating Vermeer from their legacy db2 database linked to CDK ERP/Excel to modern Business Intelligence solution with AZURE SQL data warehouse, SSIS, SSAS, SSRS, and PowerBI from scratch
- Designed customized data collection models for specific visualization tasks
- Lead Project Manager/Developer on AGILE team for eCommerce web data project for used/new equipment part data synchronization, extraction, transformation, and loading onto external Vendor website
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles
- Reverse Engineered and improved parts operational reports with SQL, SSIS, and SSRS for easy distribution to day-to-day users of parts department
- Maintained proficiency with latest database technologies.
- Reverse Engineered and fixed executive Absorption report quickly by gathering requirements from stakeholders, writing user story, and deeply analyzing SQL logic from BI source system
- Monitored and optimized SQL server performance
- Lead project manager/developer responsible for designing data model/ERP diagram for use in Azure SQL Data Warehouse
- Built, scheduled, tested and debugged SSIS packages for ETL process that load DW staging tables, stored procedures, and views for whole company
SQL Programmer & Client Engagement Specialist
Donor Direct
Dallas, TX
09.2019 - 04.2020
- Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard, supported more than 20 client companies' general business reports and decision making processes
- Created business intelligence tools to capture client metrics
- Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability and performance
- Designed custom dashboards and reporting interfaces
- Suggested new technologies and tools for enhancing product value and increasing productivity
- Reported on updates to project specifications and progress.
- Coordinated with stakeholders to define project technical requirements
Senior Business Systems Specialist
Sunoco LP & Energy Transfer Partners
Dallas, TX
09.2018 - 08.2019
- Gathered vague business requirements from functional business partners to redesign wholesale distribution order freight SSRS report to include CPG and Per Load freight data
- Collaborated with stakeholders to enhance PDI system utilization and efficiency by customizing business processes
- Spearheaded a data report integration initiative of 4 separate PDI Enterprise ERP systems to improve IT & Accounting productivity by 200%
- Communicated deficits in system performance to senior leadership, recommending appropriate corrective measures
- Reverse engineered powershell/windows scripts attached to windows server scheduled task to redesign PDI batches to include new site acquisitions
- Utilize T-SQL to review, update and maintain various data streams associated with customer setups, pricing, terminal & product, and commercial sale deals in the associated systems
- Coordinated support responses to customer issues, verifying closure of concerns and correction of deficiencies.
Business Systems Support Analyst II
Valero Energy Corp.
San Antonio, TX
01.2013 - 08.2018
- Lead Project Manager Mobile Handheld Windows Mobile to Android conversion using SDLC methodology
- Reverse engineered vendor proprietary report to ultimately develop custom SSRS report for IntelaTrac that can be accessed from any site to reduce vendor support costs on Valero
- Reduced number of application support calls by assembling software packages and programming windows mobile scripts to handhelds
- Identified needed business improvements and determined appropriate systems required to implement solutions.
- Spearheaded for leading multiple enterprise wide mobile device enhancement projects and support initiatives simultaneously
- Organized system operating procedures to strengthen controls
- Responsible for identifying, researching and resolving system issues proactively and providing recommendations to management, customers and peers. Project Manager in implementation of new IntelaTrac system upgrades and enhancements with appropriate testing and change management
- Presented business leaders with ROI estimations to drive project planning
- Lead mobile device project team in implementation of new IntelaTrac system upgrades and enhancements with appropriate testing and change management
- Created and maintained standard operating procedures governing system functions and features
- Gathered requirements from mobile system champions to create enterprise wide KPI reports using SQL server reporting services (SSRS)
- Support data quality assessment and data flow analysis of IntelaTrac systems
- Gathered requirements and manage business relationship with refinery on-site customers to encourage IntelaTrac system best practices and usage
- Responsible for identifying, researching and resolving system issues proactively and providing recommendations to management, customers and peers
- Project Manager in implementation of new IntelaTrac system upgrades and enhancements with appropriate testing and change management
- Communicates with third party vendor to help reach business goals for Valero
- Troubleshoot, Support, and Program over 150 different windows mobile handheld devices remotely by utilizing SOTI MobiControl Software
- Utilize XML Provisioning to configure IntelaTrac software to Valero's custom requirements
- Developed reports using SSRS to communicate and inform management of IntelaTrac data to improve operator work performance and user acceptance
- Performs research and troubleshooting on end-to-end business processes within third party vendor and proprietary systems
- Examine vendor SQL Server IntelaTrac database to troubleshoot refinery customer system issues
- Utilize SQL Server 2008 to perform database queries to ensure database integrity for new system implementation
Web Developer
Texas Tech University
Lubbock, TX
09.2012 - 01.2013
- Planned website development, converting mockups into usable web presence with HTML, JavaScript, AJAX and JSON coding.
- Provided front-end website development using WordPress, Joomla and other editing software.
- Validated third-party code to comply with internal standards and technical requirements.
- Determined coding requirements for specialized scripts.
IT Analyst
Texas Tech University, TTU
Lubbock, TX
11.2011 - 09.2012
- Managed over 50 customer calls per day
- Assisted in troubleshooting network, cyber-security and non-standard software and hardware related issues.
- Investigated system issues and implemented resolutions to reduce downtime.
- Provide thorough documentation and escalate issues to proper departments
IT Analyst Intern
Valero Energy Corp.
San Antonio, TX
05.2012 - 08.2012
- Utilized SAP to create ETL processes in company data warehouse for Financial Reporting
- Shadowed personnel to learn appropriate methods for solving customer issues and troubleshooting technical problems.
- Analyzed current information and helped develop plans to address needs.
- Worked with high-performing teams in Agile environment.
- Investigated data issues and offered suggestions for resolution to supervisor.
Computer Sales Associate
Best Buy
Lubbock, TX
05.2009 - 11.2011
- Partnered with computer sales team and other store personnel to deliver unparalleled customer support and maximize revenue.
Education
BBA - Management Information Systems
Texas Tech University
Lubbock, TX 08.2007 - 12.2012
Skills
Ad-hoc report integration
Data visualization
Dashboard design
User requirements
Relational databases
Business intelligence analysis
Testing and debugging
Requirements gathering
Data visualizations
SQL proficiency
CDK ERP expertise
Usability understanding
Agile Methodology
Social media
Program leadership
Report compilation
Vendor relations
Strategic planning
Team Bonding
Member databases
Relationship building
Search Engine Optimization
Negotiation
Business Management
Marketing
Business planning
Accomplishments
- Founding member of Levelduplife, Inc.
Affiliations
- Association of Information Technology Professionals (A.I.T.P.)
- Big Brothers/Big Sister of South Texas
Certification
ITIL v3 Certified
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
I can’t understand why people are frightened of new ideas. I’m frightened of the old ones.
John Cage
Timeline
SQL Programmer & Client Engagement Specialist
Donor Direct
07.2021 - Current
Business Intelligence Developer
Vermeer Texas-Louisiana
06.2020 - 07.2021
SQL Programmer & Client Engagement Specialist
Donor Direct
09.2019 - 04.2020
Senior Business Systems Specialist
Sunoco LP & Energy Transfer Partners
09.2018 - 08.2019
Executive Director
Levelduplife, Inc.
02.2018 - Current
ITIL v3 Certified
08-2013
Business Systems Support Analyst II
Valero Energy Corp.
01.2013 - 08.2018
Web Developer
Texas Tech University
09.2012 - 01.2013
IT Analyst Intern
Valero Energy Corp.
05.2012 - 08.2012
IT Analyst
Texas Tech University, TTU
11.2011 - 09.2012
Computer Sales Associate
Best Buy
05.2009 - 11.2011
BBA - Management Information Systems
Texas Tech University
08.2007 - 12.2012