TECHNICAL SKILLS

Development Languages: .NET, C#, CSS, XML, Java (Android), SQL (Oracle and SQL Server), PL/SQL, MS SQL, C++, SAS Expression Language (DataFlux Data Management Studio)

Tools: ArcGIS, Balsamiq, Crystal Reports 2011, DataFlux Data Management Studio; Eclipse, PL/SQL Developer, HP Quality Center, iNavigator, IBM Rational Developer, Jira, MadCap Flare, Mantis Bug Tracker, MS Access, MS Excel, MS PowerPoint, MS Project, MS Team Foundation Server, MS Teams, MS Visio, MS Visual Studio 2010 and 2012, MS Word, MySQL, OnTime, SAS, Salesforce, SharePoint 2010, SharePoint Designer 2010, SnagIt, SPSS, SQL Server Management Studio 2008 R2 and 2014, VersionOne, X - Analysis

PROFESSIONAL EXPERIENCE

Business Systems Analyst/Scrum Master

Confidential - Maryville, Tennessee

Responsibilities:

• Construct detailed documentation on current, interim and future state functionality and processes.
• Formulate conceptual and logical data models for future implementations.
• Construct data sets for use in Oracle ERP configuration.
• Analyze RPG (AS400) code and provided analysis of functionality contained within.
• Participate in reconciliation of existing data in preparation for a large-scale AS400 to Oracle ERP development and implementation effort.
• Act as scrum master for a team of developers, analysts and QAs, including facilitation of all scrum ceremonies and creation/management of user stories within Jira and Confluence (includes participation in Scaled/Nexus ceremonies on the organizational level).
• Perform various analytical tasks using manufacturing data and code (RPG, using simple and complex SQL queries and scripting).

Senior Technical Analyst

Confidential

Responsibilities:

• Set up and configured repositories, data connections and database management server connections within SAS DataFlux Data Management Studio.
• Prepared and reported data quality metrics to management using data processed by SAS DataFlux Data Management Studio, SQL Server Management Studio and Excel VBA.
• Utilized HP Quality Center for application lifecycle management including planning, testing, defect management and maintenance.
• Monitored execution of scheduled jobs within Autosys and Cisco Enterprise Scheduler.
• Performed ad hoc testing of process flows, data jobs and business rules.
• Developed and tested scripts, stored procedures and views using simple and complex SQL.
• Created and tested Windows Server batch scripts used to execute SAS DataFlux process flows.
• Constructed logical and physical data models, data flow diagrams and process flowcharts for Data Quality Management Center processes.

Lead Business Analyst

Confidential

Responsibilities:

• Server Management Studio.
• Used agile/scrum methodology to plan, execute, test, and manage releases iterative product (i.e., business rules, process flows and user interface) releases.
• Constructed physical and logical data models, data flow diagrams and process flowcharts for the existing mainframe (AS400) and future SAS-based systems.
• Engineered test data for use in validating business rule accuracy and overall system stability.
• Performed line-by-line quality assurance checks on tens of thousands of output records.
• Performed quality assurance tests on executed code (e.g., log files, etc.) and reported issues to project team members.
• Ensured referential integrity across a data warehouse through the use of star schemas and user-defined functions/procedures.
• Managed the receipt and processing of data from approximately 40 disparate data sources.
• Verified and managed schema accuracy within Microsoft SSIS, DataFlux Data Management Studio, IBM Infosphere DataStage and Microsoft Access.
• Constructed and executed complex queries and stored procedures (using SQL and T-SQL as part of the overall data mining and database management effort.
• Managed business rules, tasks, data connections, unit tests, and process jobs within DataFlux Data Management Studio and SQL Server Management Studio.
• Ensured adequate and through defect management and resolution throughout development and testing.
• Developed processes for engineering and transformation of test data into various formats for use within a multi-dimensional data warehouse setting.
• Set up and managed application lifecycle management artifact repository within MS Team Foundation Server.
• Conducted knowledge transfer training for future testers and developers.

Business Analyst

Confidential

Responsibilities:

• Coordinated overall testing effort, including construction of all testing documentation (e.g., Master Test Plan, test scripts, testing results documentation, requirements traceability matrices, etc.).
• Consolidated test data and prepared mechanisms for consolidation of test results.
• Performed QA reviews of existing Unified Modeling Language (UML) documentation and data.
• Constructed logical and physical data models, data flow diagrams and process flow charts.
• Constructed user manuals for existing software and projects undergoing development
• Facilitated requirements and business rule gathering.
• Created and managed user manuals, system requirements and design documentation.
• Conducted statistical analysis on existing roadway and traffic accident data using GIS software.
• Performed application lifecycle management and defect management tasks for new and existing applications.

Lead Business Process Analyst

Confidential

Responsibilities:

• Used Agile/Scrum to successfully plan, develop and implement software releases.
• Coordinated testing (i.e., facilitated testing, managed issue resolution, and verified user acceptance).
• Examined code, queried development databases (using SQL), and coordinated internal testing.
• Constructed logical and physical data models, data flow diagrams and process flow charts for existing and proposed applications.
• Developed stored procedures and reports using PL/SQL Developer and Crystal Reports.
• Reviewed star schema diagrams, reference data integrity and lookup table-related functionality within web and console-based applications.
• Created project proposals, statements of work, site maps and prototypes for various clients.
• Consolidated market research data for use in vetting and pursuing clients.
• Facilitated requirements and business rule gathering via JAD.
• Ensured adequate and through defect management and resolution throughout development and testing.
• Documented meeting minutes, open items, and project risks.
• Performed application lifecycle management tasks for various new and existing applications.
• Created and managed user stories based on client user needs and legislative requirements.
• Constructed wireframes, use cases, flowcharts, and requirements traceability matrices using MS Visio, Balsamiq, VersionOne and Microsoft Excel.
• Developed site collections within SharePoint 2010 using C#, CSS, and XML.
• Created business requirements documentation and design specifications.
• Constructed testing and validation plans, tester packets, user manuals, and help files.
• Coordinated and conducted “train-the-trainer training”.