RESPEC

Business Analyst

• Analyze user and stakeholder needs to determine functional and non-functional requirements.
• Collect and manage functional, non-fucntional and technical requirements.
• Create process and data flow diagrams as well as prototypes/wireframes.
• Manage product backlogs.
• Collect and report on requirements metrics related to assigned applications and client identified priorities.
• Perform detailed analysis, collection, assessment, design, development, modeling, simulation, integration, installation, documentation, and implementation Create test scripts and conduct testing.
• Write and update project documentation including user manuals, addendums, presentation and training materials.
• Develops advanced technological ideas and guides their development into a final product.
• May act as advisor to customers on advanced technical research studies and applications.

Senior Business Analyst – FED IHS

Database Administrator

• Maintain, develop, refactor, and optimize a T-SQL codebase (queries, views, stored procedures, functions) across all OBMS modules.
• Perform query tuning, indexing, and performance diagnostics as needed and as appropriate for a large and complex database.
• Design, develop, maintain and deploy SSRS reports, ensuring high standards for data accuracy and presentation to non-technical clients.
• Partner with the client and other RESPEC consultants on the OBMS team to elicit business requirements and transform them into database design.
• Work tickets triaged by a help desk; manage priorities and communicate status/risks clearly.
• Contribute to database design patterns for new/enhanced modules, looking for opportunities to evolve or leverage the system's existing architecture where appropriate.
• Document changes, follow proper change management processes, and uphold best practices for multi-environment migrations.

SQL Server Database Administrator

• Maintain, enhance, and further develop a long-lifespan, stored-procedure–centric application.
• Lead query tuning, indexing, and performance diagnostics for large-scale, complex databases.
• Design, develop, and deploy mission-critical SSRS reports.
• Partner with internal client managers to capture business requirements and translate them into actionable technical tasks.
• Manage and prioritize technical tasks triaged through the help desk (Javan).
• Document all database changes and uphold best practices for multi-environment migrations.
• Contribute to database design patterns for new or enhanced modules.

Account Manager

• Serve as the primary contact for a dedicated book of clients, managing relationships via email, Zoom, and phone.
• Meet with clients quarterly to review financial statements and provide strategic insights that drive business growth.
• Oversee G/L activity, financial statement preparation, and heavy account reconciliations to ensure technical accuracy.
• Facilitate the tax compliance process by preparing returns and providing clean financials to the tax department.
• Review transactional work and ensure all monthly accounting activities stay on schedule.

Client Relationship Manager – CPA, EA

Systems Engineer

• Support Texas State Partner Agency in transitioning reporting and data-extract capabilities from legacy systems to cloud or data-lake environment.
• Lead sessions with stakeholders for requirements and documentation.
• Review and interpret mainframe IMS data structures and document current state reporting logic.
• Collaborate with data engineers and architects to map legacy data to cloud models.
• Produce and maintain documentation such as mappings, business rules, and data flow diagrams.
• Develop test cases and support User Acceptance Testing (UAT).

Senior Business Analyst – FED IHS

SQL Server Database Administrator

SQL Server Database Administrator

Client Relationship Manager – CPA, EA

Senior Systems Analyst – Contractor