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: <<SummaryExperienced Tableau Engineer with critical analytical& statistical knowledge in developing Tableau Dash Boards, Performance Tune and prepare insightful Tableau reports. Built and published customized interactive reports, dashboards, and report scheduling. In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server. Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage. Performed data audits, data profiling activities, providing strategic data to BI teams. Familiar with Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment. Working knowledge in Windows Servers, API, Network technologies with Active Directory, SAML for authentication. Strong knowledge in SQL, PL/SQL, XML, Python programming and understanding of Data modeling (Dimensional & Relational) concepts Experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint. Involved in Trouble Shooting, Performance tuning of reports, tuning long running SQL and PL/SQL queries for better performance and resolving issues. Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports. Involved in upgrading Tableau platforms in clustered environment and performing content upgrades. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions. Expertise with data architecture, data interoperability and data analytics using Tableau and SQLs Experience in different project methodologies - Waterfall, and Agile/SCRUM Self-starter with ability to motivate teamwork and lead competently in diverse groups. Decision making ability to make sound Engineering, Management judgment. Innate problem solver, able to intellectually articulate business problems, identify critical problems, and achieve targeted results Worked closely with ETL developers and stakeholders to assist them with their agile development life cycle. Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling. Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas). Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas). Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
HighlightsBI Tools				: TableauETL Tools          : Informatica, Data Stage, Microsoft SQL Server Integrated ServicesRequirements Management      	: Requisite Pro, Microsoft Office (Word, PowerPoint   Excel)Change Management          : HP Open View, CA Service Manager, Lotus Notesamp; Service ManagementFront End Tools          : Microsoft Project, Microsoft Office, Visible AnalystDatabases          : Oracle 9i, SQL Server, DB2, Sybase, Teradata, MS AccessetcDocument management          : Visual Source Safe 6.0, Share point, Ultra Edit, DocumentumDefect management tool          : HP Quality center 10.0Programming Languages          : C, C++, HTML, SQL, PL/SQL, XML, Python, C#Data modeling          : ERwin, ER Studio, MS Visio Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.Prepared several analytical reports comprised of different data modeling techniques such as time series analysis, financial modeling, and trend mapping and supported in MATLAB programmingCollecting data, text standardization and performing text mining using different python libraries to create clusters and classify to compare the results and improve search of the platformEnvironments: SQL/PL-SQL, ETL, Oracle, Windows Server, VMware, Active Directory, Virtualization, Linux, Systems Engineering, Servers, Cisco Systems Products, Microsoft Exchange, MS Office Suite, MS Visio, HTML, MS Access, MS SQL, JavaScript, HTML/HTML5, CSS3, DOM, XHTML, AJAX and jQuery, Bootstrap, AngularJS, SQL Server, SSIS 2008, SSRS 2008, DB2, T-SQL, Oracle and SSMS, Asp.Net, C#, J-Query, MATLAB, Cognos 8.4,10.1 connection MS Office Suite, MS Visio, HTML, UML, C++, Java, MS Visual Basic, VB Script, Test Director, Client Server, Windows XP, MS Access, MS SQL, .NET, Agile, SOA
Experience01/1toPresentTableau Developer /Data AnalystAlteryx Inc.|,OR,Develop various Tableau dashboards and analytical reports and solutions for marketing efforts on medical products and business groups, using Calculations, Filters, Parameters and complex statistical analytics features of Tableau.Work on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO Adjust views/dashboards after initial POC presentation to CEO and CFO.Create views and dashboards on end client's sales data.Produce powerful dashboards using pie, bar, geo, and line charts that are viewed daily by CEO and CFO.Developed and modified database procedures, functions, packages to enhance and improve functionality using PL/SQL.Design and development of Tableau software applications to support reporting and Business Intelligence initiatives, using data analytics, visualization, reporting using OLAP (Online Analytical Processing), data mining, SQL, UNIX, Linux, and Java portal technologies; Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.Design and develop workbooks, global filter page, and complex parameters based calculations.Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau Access and transform massive campaign datasets through filtering, grouping, aggregation, and statistical calculation.Develop Tableau workbooks from multiple data sources using Data Blending.Work with team of developers to design and develop BI solutions on various marketing and campaign KPIs.Responsible for the design and development of data warehouse, analytics and visualization to meet the big data needs of various products and businesses.Design and deploy rich Graphic visualizations with drill down, and drop down and parameters from ERP databases and complex Dashboard and Storyboard Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups.Created, organized and formatted reports, folders and other contents on Cognos Connection portal.Involved in migration of Cognos adhoc reports to Tableau workbooks.Converted business requirements into technical specification and design for Reporting Database/data mart, and Adhoc/standard reporting using Cognos 8BI.Perform query search via SQL knowledge and understanding of Data modeling (Dimensional & Relational) concepts Design different front-end forms & dynamic pages using CSS, HTML & given functionality with JavaScript, HTML5, CSS, JavaScript, JQuery, Angular.js Environments: Tableau Server, Tableau Desktop, Agile/Linux, HTML5, CSS, JavaScript, JQuery, Angular.js, Java Portal, PL/SQL, Windows Server, Oracle 10g/9i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA SCRIPT, J2EE,PL/SQL, Tomcat, MS Visio, MS SQL, Teradata, IBM Cognos 8.4,10.1 connection.01/1to01/1Sr. BI Consultant/ Tableau DeveloperGalaxy Solutions|,CT,Created and assisted users in Tableau dashboard development.Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters, Trend Lines, Statistics, and Log Axes.Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.Developed and designed User Interface using JavaScript, HTML/HTML5, CSS3, HTML5, jQuery, SASS, and AngularJS Performed relational database design and normalization, client-server development, OLAP analysis using pivot charts Migrated Cognos dashboards to Tableau showing Year over Year comparison of different key metrics, Premiums Vs Losses, IBNR etc.Developed Cognos Reports in compliance with user reporting standards Created Tableau extract files for improving the performance.Implemented various Validation Controls for form validation and implemented custom validation controls with JavaScript validation controls.Wrote DDL or DML SQL commands, visualizations in Tableau, to improve data quality, analyzed complex data systems and document data elements, data flow, relationships and dependencies describing what/how/where/why data is stored and how to access the data.Created SSIS packages using C# scripting, script components and script tasks for various Control Flow Tasks and Data flow.Worked with DBAs in order to schedule SSIS packages as jobs either daily, weekly, monthly.Wrote complex PL/SQL queries and designed SSIS packages to load the data into warehouse.Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.Created the test environment for Staging area, loading the Staging area with data from multiple sources.01/1to01/1Business Intelligence Analyst|City,STATE,Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Prepared Tableau dashboards using advanced features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.Created detailed technical design documents.Created Data Model for interface.Performed Logical and Physical data modeling within Tableau Server Experienced in Tableau Server Infrastructure: Installation & configuration of Tableau Server in clustered environment and REST API implementation.Involved in the production support and enhancement of the Sharepoint databases.Redesigned standards and procedures and bills of material tables.Created data maps using Informatica Power Exchange 5.1.2.Extensively used lookup, Expression, Aggregator, Normalizer transformation Performed Informatica code reviews.Created ETL design for real time data processing.Designed and implemented Informatica maps, workflows, schedules and scripts.Implemented mapping level data auditing and error handling, source to target mapping.Performed performance tuning of Informatica mappings and databases Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Wrote stored procedures/Triggers/Views in SQL server and Oracle Developed implementation plans for the SAP modules PP and PP-PI.Implemented Material Variant, Object dependencies, Variant Table, Functions, Variant Pricing, Order BOM and also managed implementation of PP and PP-PI design on SAP 4.7C release Experience in designing Business View Manager, Business Objects universes, complex Crystal and BO reports both Full and Thin Client Reports.Developed reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.Created reports using Business Objects functionalities like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.Used SQL Server Integrations Services (SSIS) to extract data (ETL), and quickly load data into SQL Server table, and handle data quality issues.Used SQL Server Reporting Services (SSRS) - Reporting Services Components and Business Intelligence Development Studio (BIDS) in order to design and develop reports.Worked in Windows Servers, API, Network technologies with Active Directory, SAML for authentication Environments: SAP BW/BO, SAP Business Objects XI R2 SP2,XIR 3.1 SP3, Designer, Infoview, Web Intelligence, Data Stage 8.1,Sql, PL/SQL, SQL server 2008, Xcelsius 2008,Live Office, Oracle 10g, Windows Server 2003,Clear Case,Clear Quest.MS Excel, MS SQL Server 2008/12 R2, Win Server 2008 R2, Active Directory, Oracle, Windows Server, VMware, Virtualization, Linux, Systems Engineering, Servers, Cisco Systems Products, VMware ESX, Microsoft Exchange, MS Office Suite, MS Visio, HTML, MS Access, JavaScript, HTML/HTML5, CSS3, DOM, XHTML, AJAX and jQuery, Bootstrap, SASS, AngularJS.08/2016to11/2016Business AnalystNA|City,STATE,Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Best Practices, Schedule, Business Change Management, and Develop Feasibility Study Report for Preliminary Study of the Project and Budget of the Project.Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs, and Best Practice initiatives.Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion.Designed and developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams by using MS Visio.Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users.Resource monitoring and repository Audit reporting.Worked on Backup and restoration.
EducationExpected intotoBachelor of Science|Chemical EngineeringOklahoma State University,Stillwater,OklahomaGPA:Chemical Engineering
Skills.NET, Asp.Net, Active Directory, Ad, Agile, AJAX, Analyst, API, Audit reporting, auditing, Backup, basic, big data, Budget, BI, Business Intelligence, Business Objects, C, C++, Change Management, charts, Cisco, Client Server, client-server, CMS, Cognos 8.4, Cognos, CA, hardware, content, Crystal, CSS, CSS3, Client, Data Analyst, Data Analysis, Data Conversion, data processing, Data Migration, data mining, Data Modeling, Data Validation, data warehouse, Databases, Database, Data Stage 8.1, Data Warehousing, Decision Support, designing, DIMENSIONS, DML, Document management, Documentum, DOM, DOORs, Edit, ERP, ERwin, ETL, XML, Feasibility Study, features, financial modeling, forms, Graphic, HP, Open View, HTML, HTML5, IBM, DB2, Informatica, J2EE, Java, JavaScript, JAVA SCRIPT, JQuery, J-Query, Linux, Lotus Notes, marketing, MATLAB, Access, MS Access, C#, MS Excel, Excel, Exchange 5.1.2, Microsoft Exchange, Microsoft Office, MS Office Suite, Office, PowerPoint, PP, Microsoft Project, Sharepoint, Share point, Win, Windows, 3.1, Windows XP, Word, migration, Modeling, Network, OLAP, Oracle 9, Oracle, PL-SQL, PL/SQL, page, Pricing, Programming, Python, Quality, Quest, real time, relational database design, reporting, Requirement, sales, SAP BW, SAP, SAP 4.7, Servers, scripting, scripts, script, Visual Source Safe 6.0, Specification, Sql, MS SQL Server, MS SQL, Microsoft SQL Server, SQL Server, Statistics, strategy, Sybase, System Analyst, Systems Engineering, Tableau, tables, Teradata, Test Director, Tomcat, T-SQL, Trend, UML, UNIX, upgrades, upgrading, User Interface, Validation, VB Script, View, Visio, MS Visual Basic, Web Intelligence, Windows Server, XHTML>>. The result is, Good Fit

Fit assessment: Good Fit