We provide IT Staff Augmentation Services!

Sr. Tech Business Analyst Resume

Dallas, TX

SUMMARY

  • Certified Scrum Master with more than 7 years of experience in Information Technology including extensive experience implementing large projects in both the public and private sectors.
  • Provided Functional analysis and Technical solution on Enterprise projects.
  • Most recently, I have become an expert in the Accela Suite of Products, including Business analysis, Process Management, Configuration, Reports, Data conversion and System Testing (including ADA).
  • My experience in functional and technical aspects of the project, along with my dedication to customer satisfaction, escalated my position to the Customer Success Liaison for the Alcoholic Beverage Control Commission serving as the point of escalation for the agency as well as the communication lead between the business and technical teams.

TECHNICAL SKILLS

Operating Systems: Windows Vista XP/2000/98/95, MS - DOS, UNIX

Databases: Oracle 10g/9i/8i, MS SQL Server 7.0/2000/2005

Languages: SQL, PL/SQL, UNIX Shell script, Java Script

Database Modeling Tools: Microsoft Visio

Database Tools: TOAD, SQL Developer, SQL* Plus, SQL Server Management Studio 2014

Reporting Tools: Crystal Reports, Accela Ad-Hoc Reporting Tool

ETL Tools: SQL*Loader, Ultra Edit, Accela Conversion Tool

Others: Share Point, JIRA, JAMA, Rational Team Concert (RTC), Rational Functional Tester(RFT), Jaws 13, 15, 16

Accela Products: Accela Automation, Accela Citizen Acces, Accela Conversion Manager, Admin Tools (AA/ACA/Classic), Workflow Designer, Data Manager

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. ACCELA Consultant/Sr. Tech Business Analyst

Responsibilities:

  • Serve as Agency liaison/lead for the Alcoholic Beverage Control Commission for the eLicensing project
  • Collaborate closely with Commonwealth project managers and other stakeholders from project initiation through delivery of final product to ensure projects met defined success measurements.
  • Plan, organize and conduct business process reengineering/improvement projects
  • Analyze and manage work effort of change requests
  • Manage and support Tier 2 tickets
  • Manage communications with the Commonwealth DBA for Data Cleansing and Data Validation
  • Create Data Dictionaries and conduct Data Mapping review meetings
  • Lead Data Conversion and Migration Deliverable Review meetings with the business users.
  • Document and explain business requirements to Commonwealth developers
  • Create project plans and timelines
  • Manage QAT and UAT schedule and activities
  • Prepare build and test status reports for Executive Management
  • Manage Change Request to implement new requirements in existing requirements
  • Develop Specification Documents and manage the deliverable approval process by being the liaison between Commonwealth and the Systems Integrator (SI)
  • Develop complex reports using Crystal Reports
  • Create performance tuning queries
  • Complete Unit Testing and System Testing of Reports
  • Elicit requirements and operational objectives using interviews, document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, task, workflow analysis and JAD sessions
  • Develop process flows to define specific system functionality in order to provide training to team Streamline operations to create efficient work flows between communicating systems
  • Mentor Business Analysts in creating, reviewing, and signing off on Configuration Design Documents and To-Be Analysis Documents
  • Complete development tasks using ACA Page flows, AA Classic and V360 Admin
  • Complete post production Security Design Changes including creating and updating new Users and User-Groups
  • Complete configuration tasks including Record types, Workflows, ASI/ASIT, Standard Choices, and Security in Accela Automation and in Accela Citizen Access
Confidential, Dallas, TX

Sr. Business Analyst/Data Analyst

Responsibilities:

  • Complete Data Conversion and Migration activities for multiple state agencies using SQL Loader and PL/SQL Functions and Procedures
  • Led Data Mapping activities and created Data Mapping Documents
  • Conducted Data Validation and Verification Testing
  • Tuned queries using Explain Plan, Indexes and Hints
  • Executed Requirement Analysis sessions
  • Created Specifications and Requirements Questionnaires
  • Developed reports using Crystal Reports and Accela Ad-Hoc Reporting Tool.
  • Performed Query Tuning by creating Indexes and materialized views
  • Executed in Unit Testing and System Testing of Reports
Confidential, Dallas, TX

Oracle PLSQL Developer

Responsibilities:

  • Heavily involved in System Analysis, Design, Coding, Data Conversion, Development and Implementation, Report Development, Unit Testing and Production Validation
  • Responsible for writing SQL queries and PL/SQL programming for project implementation as well as performance improvement
  • Performed Address Cleansing using Trillium as well as did data analysis using TOAD
  • Involved in Database upgrade for Oracle Forms and Reports from 6i to 10g

Confidential, Dallas, TX

Business System Analyst

Responsibilities:

  • Created Business Process Maps, Business Requirements, Functional Requirements and Test cases
  • Participated in analysis meetings for Data Mapping and mapped data to the data model
  • Analyzed the existing Business Process Flows and created the To-Be Process Flows
  • Led the design of the logical data model (relational and dimensional)
  • Executed user security and identity activities

Hire Now