For the given job description <<Reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall business strategies. Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective. Familiar with industry standard business process mapping, and reengineering. Prepares solution options, risk identification, and financial analyses such as costbenefit, ROI, buybuild, etc. Writes detailed description of user needs, program functions, and steps required to develop or modify computer programs.  This position will work on the Grants Management application. This position will perform the duties of a Business Analyst including requirement gathering, analysis of requirements, development of requirements and design for required system modifications, completing business requirement documents, user stories, and business area collaboration andor coordination. Will also work with technical teams to coordinate demos, UAT, code releases, and user communication as necessary. Must have experience working in an Agile environment. Some on-call support may be required depending on the project phase. II. CANDIDATE SKILLS AND QUALIFICATIONS Minimum Requirements:Candidates that do not meet or exceed the minimum stated requirements (skillsexperience) will be displayed to customers but may not be chosen for this opportunity.YearsRequiredPreferredExperience8RequiredBusiness Analyst Experience8RequiredSQL Experience8RequiredSystem Reporting (Oracle, SQL)8RequiredSystems Testing (Unit, Integration, UAT)8RequiredExcellent communication skills (verbal and in writing)4PreferredAgile Software Development Methodologies Experience2PreferredProject andor Product Management experience1PreferredExperience with Jira III. TERMS OF SERVICE Services are expected to start 10022023 and are expected to complete by 08312024. Total estimated hours per Candidate shall not exceed 1850 hours. This service may be amended, renewed, andor extended providing both parties agree to do so in writing. IV. WORK HOURS AND LOCATION Services shall be provided during normal business hours unless otherwise coordinated through the Texas Health and Human Services Commission. Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM, excluding State holidays when the agency is closed.
The primary work location(s) will be at 701 W 51st St Austin, TX 78751. Any and all travel, per diem, parking, andor living expenses shall be at the Candidate's andor Vendor's expense. Texas Health and Human Services Commission will provide pre-approved, written authorization for travel for any services to be performed away from the primary work location(s). Pre-approved travel expenses are limited to the rates and comply with the rules prescribed by the State of Texas for travel by its classified employees, including any requirement for original receipts.
The Candidate(s) may be required to work outside the normal business hours on weekends, evenings and holidays, as requested. Payment for work over 40 hours will be at the hourly rate quoted and must be coordinated and pre-approved through Texas Health and Human Services Commission. V. OTHER SPECIAL REQUIREMENTS Remote work Mon - FriLocation: within the state of TexasInterviews will be conducted through Microsoft Teams>> the resume: <<ProfileHas a Master’s of Science Degree in Management Information Systems with Business Intelligence Concentration.Has  5+  years of experience working as a SQL server Developer, SQL DBA, and Data Analyst with excellent analytical and problem-solving skills to work with minimal supervision.Strong knowledge and experience of RDBMS like MS SQL Server 2008 R2/2012, MS Access, MySQL and T-SQL (queries, stored procedures).Strong knowledge and experience in Business Intelligence –SSIS, SSRS, SSAS, Power BI ( Power Pivot, Power Query, Power View, Power Map and Pivot Table,).Experience in Windows server 2008/2012 Active Directory Administration(Users and Computers, DNS, DHCP)Experience with data analysis and visualization tools like Excel and Tableau
Core QualificationsBusiness Intelligence /Data AnalyticsDatabase Development /AdministrationWindows Server AdministrationWindows AzureData warehouse/Data MiningMicrosoft OfficeWeb DesignAmazon Web Services
Technical SkillsSQL Server, MS Access, MS Excel, MYSQLSSIS, SSAS,
SSRS, Power BIT-SQL, VBA (MS Access), Excel MacrosTableauRapidMiner, XLMiner (Data Mining)HTML, CSS, WordPress, Dreamweaver, Photoshop, JavaScript
Professional ExperienceSQL Devloper/DBA/Data Analyst,09/2012-03/2015Market Footwear, Fred Lurie Associate Inc.–City,STATE,Responsibilities:Created ETL packages involving various data sources (SQL Server, Flat Files, Excel source files,  etc)  using MS SSISDeveloped data quality solution using SQL Server data services (DQS) as part of ETLAnalyzed data using using SSAS, Excel, Tableau and Power BI tools for decision making processBuilt Self Service Business Intelligence  dashboards using Power BI tools in Excel.Wrote T-SQL queries  for data Analysis and ReportingDeveloped reports using MS SQL Server Reporting Services (SSRS) and ExcelHelped decision makers to understand data on reports and dashboards and gain insights.Installed, administered and maintained MS SQL Server 2008/2012, including upgrades, security, configuration and service packsDesigned, implemented, and maintained SQL Server databases.Designed and implemented tables, views, functions, stored procedures and triggers in SQL Server.Planned and implemented SQL Server Security and database permissionsPerformed  Database Performance Analysis and Tuning using Database Engine Tuning Advisor, SQL Server Profiler and SQL Server Extended EventsSetup High-Availability as part Disaster Recovery Strategy for the SQL server 2012 databases (Failover Clustering, Database Mirroring, Log Shipping and Replication).SQL Server developer/DBA,07/2009-08/2012Cifra Systems–City,STATE,Responsibilities:As a mid-level DBA, Installed, configured, administered and secured SQL servers 2008/2008 R2.Created and optimize database objects, e.g. Tables, Views, indexes, cursors, stored procedures, functions and Triggers.Scheduled and automated maintenance plans using SQL Server Job Agent.Scheduled and automated full/differential/transactional backups and implemented recovery strategies.Configured and monitored database Mirroring, Replication and Log Shipping as HADR strategy.Planned and implemented SQL Server Security and database permissionsExtensively used Joins and sub-queries for complex queries involving multiple tables.Created indexes (clustered and non-clustered)  to speed up query performance.Designed Excel dashboard  for tabular and chart reports with drill down  functionality.Web Designer/SQL DBA/Developer/Media Specialist,02/2005-04/2009Miami Christians Fellowship–City,STATE,Designed desktop database application in MS Access using VBADeveloped financial report using MS Access and ExcelCreated website for the organization utilizing HTML, WORDPRESS, CSS, PHP, MSSSQL and MYSQLPerformed regular website maintenance and update while also designing graphics for banners, flyers, and postersRecorded and edited videos to be distributed in DVD , CD format and upload them to organization’s websiteTrained staff members how to utilize computers, use software to maintain website and other media support servicesWeb Developer and Database Support,07/2003-2005Hotsilhouette, Inc.–City,STATE,Responsibilities:Developed and maintained  company's websites using Dreamweaver, HTML, CSS, ASP.NET, JavaScript.Designed and managed back-end SQL Server databases for web applications.Wrote complex T-SQL queries to manipulate  dataDesigned and edited graphics and photos for websites using Photoshop.Installed, Configured and managed SQL Server and Access databases.Analyzed sales data from different sources and created dashboards using MS Excel.Provided technical computer support to end users.
EducationMaster of Science:Management Information Systems,Expected in2015-Nova Southeastern University-Fort Lauderdale,FLGPA:Status-Concentration: Business IntelligenceAssociate of Science:Computer Programming and Analysis,Expected in2003-Miami Dade College-Miami,FLGPA:Status-Bachelor of Science:Agriculture (Plant Science),Expected in1988-Haremaya University Of Agriculture-Haremaya,HarerGPA:Status->>. The result is, Good Fit

Fit assessment: Good Fit