Business Intelligence Developer

Timothy W. Moore

***********@*****.*** • 540-***-****

LinkedIn • VA, 24141, US

IT Professional

Methodical and detail-oriented IT professional with experience in software development lifecycle across diverse industries. Skilled in bringing a logical approach to solving intricate data challenges and a proven track record in enhancing system efficiency. Expertise in creating Business Intelligence solutions to meet data retention and reporting needs. Demonstrated proficiency in developing technical specifications for Microsoft Power Apps. Adept in fostering stakeholder relationships and translating user needs into actionable technical requirements, further strengthened by a commitment to continuous learning.

Technical Proficiencies

Methods:

Waterfall, Spiral, & Agile Design Methodologies

Languages:

C, C++, SQL, PL/SQL, INFORMIX 4GL, NoSQL, UNIX Shell, COBOL, Java

Platforms:

UNIX, Linux, MS Windows

Software:

SQL Server Business Intelligence Development Suite (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Azure, Power BI, Qlik Analytics, Jaspersoft BI Suite, IBM InfoSphere DataStage, Business Objects, MS Office Suite

Databases:

SQL SERVER, ORACLE, Postgres, MySQL, INFORMIX

Career Experience

Data Analyst

RB CONSULTING, INC, Frederick, MD

Feb 2024 - Present

Coordinate the creation and execution of strategies to bolster data analysis. Contribute to the VALOR Data Management Division team by enhancing supply chain and inventory management systems. Engage in Jira SCRUM activities to refine agile methodologies and streamline project workflows. Analyze and provide constructive feedback on data mapping processes to bolster system performance in anticipation of system upgrades. Collaborate with stakeholders to identify and resolve data-related issues, ensuring accuracy and efficiency in reporting.

●Authored a whitepaper on potential supply chain system replacements, influencing strategic decision-making.

●Played a key role in improving the SCRUM process, resulting in more efficient project management and team collaboration.

Business Analyst (Temporary Assignment)

TANTUS TECHNOLOGIES, INC, Washington, DC

Feb 2023 — Aug 2023

Facilitated customer engagement for NIH-NIEHS Power Applications team, translating user needs into technical requirements for system automation. Conducted Quality Assurance testing and addressed feedback during User Acceptance Testing phases. Collected detailed requirements for the enhancement of existing Promotion Committee application and for the development of a new Privacy Tracking System. Ensured the protection of Personally Identifiable Information (PPI).

●Created technical specifications for Microsoft Power Apps, contributing to the streamlining of manual processes.

●Played a key role in the final analysis gathering for Security Incident and Ethics Request applications, enhancing system reliability and user experience.

Business Analyst

NORTHWINDS TECHNOLOGY SOLUTIONS, Roanoke, VA

Aug 2022 - Oct 2022

Facilitated effective communication between client stakeholders and IT personnel to ensure alignment of business requirements with technical capabilities. Interpreted and translated complex project needs into actionable IT solutions, contributing to the success of the Data Solutions team. Managed the tracking and resolution of issues during the execution of test plans, employing various testing methodologies to guarantee project deliverability and quality.

●Streamlined requirement gathering processes, enhancing project clarity and stakeholder satisfaction.

●Improved project outcomes through issue tracking and collaborative problem-solving with cross-functional teams.

Senior Software Engineer

NORTHWINDS TECHNOLOGY SOLUTIONS, Roanoke, VA

Apr 2021 – Aug 2022

Developed and maintained SQL scripts for customer correspondence, ensuring accurate and efficient communication for Delta Dental VA. Provided expert second-level technical support, resolving production issues to maintain system integrity. Fostered team growth by mentoring colleagues in SQL script creation and problem-solving techniques. Enhanced team productivity by streamlining database operations and implementing best practices in script development.

●Created complex SQL statements, optimizing the generation of dental correspondence and improving client communication.

Business Intelligence Developer

ROSETTA STONE, Harrisonburg, VA

May 2020 — Apr 2021

Developed and maintained ETL processes to integrate data from various systems into the Microsoft Azure data warehouse, ensuring accurate and timely availability of information for reporting purposes. Designed, built, and managed Power BI reports and datasets, enabling end users to gain insights and make data-driven decisions. Collaborated with the Business Intelligence team to support customer reporting requirements and improve data accessibility.

●Fostered a collaborative environment with team members to meet reporting needs and address customer queries.

Technical Analyst

AMPLIFY TECHNICAL SOLUTIONS, Roanoke, VA

Aug 2019 — May 2020

Collaborated with senior technical analysts to deliver customized technical solutions for diverse clientele, focusing on GE's Enterprise APM application. Configured and implemented system customizations to meet client specifications. Built data visualization components to enhance client reporting capabilities and supported data migration to facilitate system transitions. Assisted in code development for system enhancements, contributing to the overall success of project deliverables.

●Contributed to team efforts in building robust data visualization tools, improving clients' analytical and reporting processes.

BI/DATA ANALYTICS CONTRACTS

SQL Developer (APEX SYSTEMS, Roanoke, VA)

Programmer/Analyst (TEK SYSTEMS, Roanoke, VA)

Aug 2018 — Jul 2019

Engineered and implemented financial datamarts for Segra Communications, utilizing Microsoft Office and SQL Server Management Studio to enhance data analysis capabilities. Spearheaded the development of a Revenue datacube, leading the analysis and programming efforts. Contributed to Advance Auto Parts' Omni-Channel Product Catalog by developing ORACLE databases, refining schemas, and troubleshooting stored procedures. Optimized ETL processes through the creation and maintenance of IBM DataStage jobs, effectively integrating external data sources.

●Executed the migration of SQL Server 2000 databases to SQL Server 2016 for the Factory Order Direct group.

●Played a pivotal role in the ORACLE database development for a major retail catalog, enhancing product data management.

Programmer/Analyst

MOOG COMPONENT GROUP, Blacksburg, VA

Jan 2015 — Jun 2018

Managed SQL Server Data Warehouse operations to ensure optimal functionality of Sales and Purchase Order Data Cubes. Maintained and updated SQL Server Integration Services packages for efficient ETL processes across multiple ERP systems. Monitored and resolved nightly process issues to guarantee uninterrupted data flow. Collaborated with end-users to refine data warehouse and create new Data Cubes tailored to specific decision-making needs. Developed and sustained a suite of reports utilizing Microsoft SQL Server Reporting Services to support organizational data analysis and reporting requirements.

●Ensured data integrity and availability by swiftly resolving nightly process issues, minimizing operational disruptions.

Data Warehouse Architect

VIRGINIA TECH, Blacksburg, VA

Dec 2007 — Jan 2015

Collaborated on designing a robust data warehouse architecture, utilizing IBM InfoSphere DataStage for efficient ETL processes on an ORACLE DBMS. Developed and maintained ORACLE stored procedures and functions. Spearheaded the creation of tailored reports using Jaspersoft BI Suite, meeting customer needs. Administered the Jaspersoft platform, optimizing performance and user accessibility. Led a dedicated reporting team to produce specialized BI Suite Reports for the Fixed Asset group.

●Streamlined data extraction, transformation, and loading operations, improving data workflow efficiency.

Additional Experience

Senior Consultant, COMPUTER AID, Allentown, PA

Senior Systems Analyst / Senior Programmer Analyst, CURRENCY TECHNICS & METRICS, Wilmington, DE

Lead Programmer Analyst, IBM GLOBAL SERVICES, Allentown, PA

Programmer Analyst, PENTAMATION ENTERPRISES, Bethlehem, PA

Programmer Analyst, DBM ASSOCIATES, Whitehouse Station, NJ

Education

Master of Information Technology

Virginia Polytechnic Institute and State University, Blacksburg, VA

Master of Science in Information Systems

DeSales University, Center Vally, PA

Bachelor of Arts in Computer Systems and Business Administration

Grove City College, PA

Contact this candidate