Business Analyst Human Resources

Smitha Rajaram

IT Systems Business Analyst

Email: ***********@*****.***

Phone: 240-***-****)

Professional Synopsis

●Analytical, enthusiastic, and innovative Business Analyst with over 22 years of Information Technology experience in Systems Business Analysis, Requirements Analysis, QA Tester, deployment, web developing business processes and system solutions for Federal Agency, Mainframe, Software, Banking, Medical, Human Resources and Web Application.

●Certified PMP from the PMI and been a Product Owner and Scrum Master for 5 years for various projects.

●Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Business Requirements in AGILE environment, Google Analytics Reporting, Analysis/Design, Development and Testing and Gap Analysis.

●Extensive experience in gathering, managing, and documenting business and functional requirements, communicating effectively with upper management, developers, and QA engineers.

●Expertise Knowledge in creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Context, Use Case, BORD (Business Object Requirement Document), Activity diagrams in Enterprise Architect, MS Visio.

●Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, and brainstorming sessions.

●Strong communication skills and Comprehensive knowledge of Agile Management.

●Exceptional problem solving and sound decision-making capabilities, recognized by alternative solutions, and confident, accurate, decision-making coupled with excellent communication and interpersonal skills. Excellent track record for meeting deadlines.

●Over 5 years of experience as Web Developer in ColdFusion PHP, JavaScript and Visual Basic.

●Over 2 years of experience as Web Designer in HTML 5, CSS 3 and Bootstrap framework.

Skills Summary

Management Tools

Programming Languages:

IBM Mainframe, DB Visualizer, MS Office, MS Visio, PowerPoint, Lotus Notes, Excel, Google Analytics, ServiceNow Applications, SharePoint, .NET, TFS (Team Foundation Server), HP-ALM, JIRA, Dreamweaver, Photoshop, Visual Tools.

ColdFusion JavaScript, HTML5, CSS3, ASP.Net,

jQuery, PHP, SQL, Visual Basic, Visual C++, XML, MS Cobol, Concurrent Cobol.

Technologies:

Fusebox Framework, advanced JavaScript libraries, Bootstrap Framework

Databases:

MS SQL Server, DB2, MS-Access

Professional Experience

Social Security Administration (SSA) (Apr 2023 – Till date)

IT Specialist (OEIS/DES/EPGSB)

Project: Annual Wage Reporting Processing (AWR)

As an IT Specialist (Business Analyst), I have been responsible for the analytical duties in the AWR Project within OEIS for the following sub projects and tasks:

EBVAPREP (Validation Pre-post Application) is a weekly operation that controls the creation of input for the Master Earnings File (MEF) and Suspense Update Systems.

oHave been responsible to analyze, validate and testing the application on Mainframe File Aids, and check that the programs are running according to the requirements or for any changes that are updated for that Tax Year.

oDocumenting the process or process changes and creating Standard Operating Procedures (SOPs) and maintaining the DFRs (Requirement Documentation).

oHave been responsible during the cyclical validation period to test the input and the output files in the mainframe and checking if the records are being passed on to the right fields in the file.

oHave been responsible for upkeeping the reconciliation runs weekly and communicating to the teams.

oHave also been responsible to train a team member who will be acting as a backup for this project.

MEF UPDATE (Master Earnings File):

oHave been responsible to analyze, testing using Mainframe File Aids and documenting changes to the MEF Update, have been assisting as the secondary analyst for any MEF Consolidation, Data Review during any scenario that needed immediate attention or correction.

oHave also used DB Visualizer to use SQL queries for data comparison and data search.

oHave created work- flow process charts for certain MEF related issues and have documented using excel spreadsheet and used spreadsheet comparison to get to the filtered data to analyze.

oHave been reviewing the SSN case by case from the MikeToys Reports that mirrors the actual Master Earning File (MEF) to analyze particular mission critical issues and recording the research into a spreadsheet to share the analysis with the team.

VATFAM (Validation Trust Fund Adjustment Merge) This application is one of the outputs to the MEF and one of the inputs to the EBVAPREP application. It is a job that runs on a weekly basis and is a component of the DES (Division of Earnings). The adjustments are made to the SSA trust funds.

oHave been responsible to analyze and validate the VATFAM input and output files using File Aids to see if the monies for that SSN required any addition or subtraction made towards the trust fund adjustments.

oHave been updating the DFR and documenting the analysis using Excel spreadsheet and to calculate that the monies are balanced.

oCreating flat files on the mainframe with records that requires any updates or corrections that are identified by the Recheck Code indicator. This file is sent to the developer that gets swept into the weekly run.

oHave also been responsible for the postproduction testing.

Other Duties & Responsibilities

oAttending regular meetings

oHousekeeping tasks and updating documentations

Environment: Mainframe TSO /ISPF/File Aids, DB Visualizer, MS Office, Excel, PowerPoint, Microsoft Teams, Skype, MS Visio.

Syneren Technologies Corporation (June 2022 – Mar 2023)

Business Analyst

Project: NOAA (National Oceanic and Atmospheric Administration)

●Have been responsible as a Business Analyst for the NOAALink Acquisition Tool Project in the ServiceNow Application.

●The NOAALink Acquisition Tool project enhances automation for the manual process of the NOAALink acquisition for hardware/software/Services request using ServiceNow capabilities and Service Portal with incorporated widgets and dynamic interface and enabling automated signature tasks.

●The DCAT Ticketing Project enhances automation for ticketing processes for various stakeholders and makes customization of their use according to their workflow process, SLA, dynamic portal and user-friendly tool and widgets.

●Assist the team with gathering requirements, meeting notes and different kinds of testing, documenting test scripts and training manuals for the DCAT Ticketing project and the NOAALink project within the ServiceNow Application.

Responsibilities:

●Gathering periodic requirements from the NOAALink Team and creating meeting notes and documenting stories and acceptance criteria.

●Creating Process flow using Microsoft Visio and creating the mockup framework using the Balsamiq and breaking each story components into tasks for the developers to implement

●Maintaining the VTB (Visual Task Board) in the ServiceNow Application to monitor and create tasks for the internal team to adhere to timeline and complete tasks within the scheduled milestones.

●Creating Test Scripts document for internal and UAT testing and doing smoke and regression testing in the development and testing environments

●Capturing defects and bugs during testing and documenting in the Defect Log and creating the defect task in the VTB for the developers to resolve the defects.

●Assist the team with responding emails and regression testing from customers for the DCAT Ticketing projects.

●Creating Training guides and manuals for the Customer for training purposes.

●Coming out with out of the box ideas for process improvements alongside my supervisor and project manager for improving from lessons learned out of deliverables and defects.

Environment: MS Office, Excel, PowerPoint, ServiceNow Application, Microsoft Teams, MS Visio, Balsamiq Mainframes, Google Tools.

3TEN Technologies, Inc. (October 2021- June 2022)

Business Analyst / Project Manager

Project: DOC (Department of Commerce) - ESHRSC Support Management

Have been responsible as a Business Analyst and Project manager hybrid, for the HRSM (Human Resource Support Management) to provide process improvement support for effectively managing workload within the ESHRSC in ServiceNow Application, a ticketing system that.

1) Retains a unique HR Case (ticket) from inception (intake through call, email, Portal, HRC) to absolute completion of all actions associated with the case with statuses that clearly and exclusively represent work performed, actions taken, or delays incurred due to external systems or conditions

2) HR Services can be segmented between PAR, Payroll & Benefits, and Time & Attendance requests and the tickets are processed by time bound pay periods.

Responsibilities:

●Extracting periodic reports out of HR Connect, NFC (National Finance Center) and ServiceNow HRSD for the various delivery team that includes Mismatch Reports, Canceled Payments, SINQ Reports, Compensation and Lump Sum Payment, Error Analysis and Missing Time & Attendance Report. Sorting and filtering the out-of-scope agency and Department ID. Tracing the mismatches by using the VLOOKUP and Xlookup functions. Created Macros in excel to expedite and automate the manual sorting and filtering.

●Prepared professional quality PowerPoint presentations for Service Level Agreement meetings and provided the graphical representation from the HRSD Application

●Analyzed data and developed visualizations and reports to meet customer needs and timeline.

●Extracted periodic reports from the NFC mainframes.

●Actively participated with HR higher management in providing solutions for process improvements. Have introduced the Visual task Board to the team and created and customized for each delivery team in accordance with their filter preferences and priority. Created the Validation Plan draft and User Acceptance Testing documentation.

●Have documented and revised Job Aids and SOPs for reporting and have provided ideas for process flows and recommended demands for changing the dashboard structure in the HRSD (ServiceNow).

●Developed and provided related templates/tools to facilitate team and leadership communication related to the future tracking and reporting.

●Attended regular stand-up meetings and periodic team meetings and documented meeting minutes.

●Scheduled meetings with customers for gathering requirements for process improvement projects.

Environment: MS Office, Excel, PowerPoint, ServiceNow Application (HRSD), Microsoft Teams, MS Visio

3TEN Technologies, Inc. (January 2020 – September 2021)

Business Analyst

Project: NOAA (OCIO)

As a Business Analyst was responsible and involved in the Requirements Analysis for 2 main projects:

●ServiceNow NOAALink

●ServiceNow DCAT Ticketing

●Working with NOAALINK ServiceNow team to gather requirements and team demonstration of the completed tasks to the stakeholders on regular scheduled meetings. Updating calendar with meeting agenda, discussions, and action items. Introduced Agile Methodology for projects.

●Working for NOAA DCAT Ticketing application, attending, and scheduling meetings, creating test scripts and participating in the UAT testing in ServiceNow.

●Preparing process flow diagrams, updating worksheets, documenting and updating the shared folders in the google Doc’s repository.

●Assisting the developers to understand the technical aspect of the application and coming up with pre-planned requirement questions alongside the PM for the next requirements gathering session.

●Timely updating tasks and discussing future course of action and Project Plans with Supervisor and the team.

●Attending the Service Now peer review architecture meeting, weekly meetings with the NOAALINK team.

●Involved in QA testing, regression testing, automation testing in ServiceNow and creating Test Scripts for UAT and creating the User Guide for clients using PowerPoint Presentations.

Environment: MS Office, Excel, PowerPoint, ServiceNow Application, Google Docs, MS Visio

Futrend Technology, Inc. (December 2016 – December 2019)

Business Analyst 3

Project: NIH (ORS and ORF)

As a Business Analyst 3 for the NIH/ ITB/DME was responsible for gathering requirements, documentation, creating reports, conducting scrum meetings in an Agile environment to support various projects and applications in the .Net and SharePoint environment during project enhancement or creating new applications or websites. The projects are mainly for the Operation of Research Services (ORS) and Operation of Research Facility (ORF) within NIH.

Responsibilities:

●Gathering project high-level requirements

●Creating PBI, User Stories and Acceptance Criteria in TFS

●Attending and Scheduling Scrum Meetings, Project Planning meetings

●Role as a Scrum Master for projects like ORS Spanish Site, ORS Wellness Site, ORS DPSAC

●Documenting required SOP or Reports as requested by the Project Manager

●Software procurement tasks – creating Purchase Order, updating Distribution list, and calling Clients for Quotes and Renewal of Licenses

●Content Management and FAQ updates on SharePoint and using HTML code.

●Google Analytics metrics and reporting for Internet and Intranet sites.

●Learn Designing Application and HTML CSS and Bootstrap Framework to assist the designer.

●Assisting Project Manager for tasks on Ad Hoc Basis

Environment: MS Office, Excel, PowerPoint, Google Analytics, SharePoint, TFS (Team Foundation Server)

Information Innovators, Inc. (August 2016 – December 2016)

Agile System Business Analyst

Project: FDA (Product Code Builder)

As an Agile System Business Analyst for the FDA was responsible for the Requirements gathering during the Sprint Planning sessions and to support and manage the SDLC team with execution and maintenance of the Product Code Builder Application within the FDA Internet and intranet applications with security and enhancement features.

Responsibilities:

●Providing process flow and UI design using Balsamiq wireframes during the planning phase.

●Participating in Sprint Planning and Sprint Review sessions to gather requirements and explaining the process flow.

●Translating requirements into User Stories and Acceptance Criteria and updating the JIRA board with tasks and sub- task created for the team.

●·Attending SME sessions with stakeholders from the FDA and participating in UAT Test Scripts

●Documenting requirements within requirement management tools such as JIRA and ALM

●Conducting online presentations and peer reviews among teams

●Generating Reports using Google Analytics and Angelfish to extract metrics and graphs representing changes over a specified time period.

Environment: MS Office, MS Visio, Balsamiq, Excel, PowerPoint, Angelfish, Google Analytics, SharePoint, HP-ALM, JIRA

RSDC Group: Arlington, VA (July 2015 – August 2016)

Business Requirements Analyst for the Department of Veteran’s Affairs

Project: VBMS (Veterans Business Management System)

As a VBMS Requirements Analyst I am currently responsible for supporting the implementation, management, execution, and maintenance of an Agile based requirements management process to support the enhancement and development of VBMS capabilities.

Responsibilities:

●Providing input to the Requirements Management Plan

●Supporting the traceability and documentation of existing requirements

●Translating requirements into User Stories and maintaining necessary User Story meta-data to support overall solution backlog management and prioritization processes.

●Attending SME sessions with stakeholders from the VA and other agencies and participating in gathering Requirements and identifying touch points to the VBMS Application systems.

●Documenting requirements within requirement management tools such as Rational Composer

●Supporting the established Agile development and testing processes to ensure that developed capabilities meet the documented requirements.

●Supporting Requirements WIPT and requirements management processes

●Support Sprint Planning and Review Activities

●Conducting online presentations and peer reviews among teams

●Provided documentation for Training purposes for New Hires.

Environment: MS Office, MS Visio, Balsamiq, Excel, PowerPoint, Google Analytics, SharePoint, JIRA

Mandak Systems Group: Springfield, Illinois (March 2010 – June 2015)

Business Analyst

Project Schedule and Task Monitoring System

As a Business Analyst my role was to write Technical Specification Documents by analyzing the legacy old Project Schedule & Task Monitoring System by replacing existing outdated interfaces with newer edits, added in-built features with new comprehensive user-friendly web-based application developed for maintaining project schedule and WBS (Work Breakdown Structure) tasks management that is monitored frequently by both employees and supervisors and Managers.

Responsibilities:

● Prepare Technical Specification Document and PowerPoint presentation slides.

● Gathered business requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter (SME's).

● Validate Screen Technical Specification with technical designs created by IT developers.

● Participated in UAT test plans, test cases, reporting bugs before deployment phase

● Implement business modeling using MS Visio to develop screens for the application and played a key role in leading the team to complete task within deadlines using Scrum methodology of Agile Management.

Environment: Windows XP, Microsoft Word/Excel/PowerPoint/Project/Access/Visio, MS SQL Server, JIRA

Training Dashboard

Training Dashboard is designed to facilitate employees in learning various web development languages/support tools. In addition to the ability to add users and grant different privileges to each user, it allows for creating classes, various assignments/tests associated with each class, averages, tutorials and feedback.

Responsibilities:

● Created a database for the entire application with a logical and streamlined design.

● Created Application setting, which controls the look and feel of application.

● Created Login Logic, integrated in house LDAP, for both validation/ adding existing LDAP users to local applications.

● Created Grid to house and manipulate various users and their respective privileges.

● Created student’s assignments grid that displays various modules associated to its respective class, and dynamic functionality such as deadline/past due, open/closed and class average for a given assignment.

● Created Forms that include files attachments to upload and links to download files.

● Made use of SVN to coordinate files with other team members.

● Used CSS to style various aspects of the grid.

● Implemented Search functionality.

● Contributed to functional requirements document and made use of agile to manage application progress.

● Used Excel to prepare spreadsheets for QA testing purposes and prepared documentation of the project and prepared presentation slides using MS-PowerPoint.

Environment: HTML, ColdFusion 8, JavaScript, CSS, jQuery, Excel, MS-PowerPoint.

State of Illinois: Springfield, Illinois (April 2006-March 2009)

System Analyst/Business Analyst

Spend-Down Systems.

The project was to identify and outline the scope of the Spend-Down Systems Application for Medical Cards for a wide range of people requesting for the aid depending on their income and other government grants. As a Business Analyst, my role was to gather business requirements, perform GAP analysis, write business and functional specification documents, and facilitate UAT.

Responsibilities:

● Wrote the Requirements and Functional Specification documents.

● Conducted Joint Application Development (JAD) sessions to develop and agree upon a system that focuses on the business requirements.

● Participated regularly in Walkthroughs and Review meetings with Project Manager, QA Engineers, and Development team.

● Handled regular deployment issues across Dev, Prod and Test environments.

● Responsible for Spend- down Pay-In project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance for State welfare Medical Cards including analyzing problems and troubleshooting reported by Clients.

● Developing GUI interfaces for design and maintenance of screens and programs for determining eligibility requirements of clients for food stamps and medical purposes.

Environment: MS Office, Excel, PowerPoint, Concurrent Cobol, DB2, MySQL, Eztrieve, Lotus Notes.

Tek Systems: Bloomington, Illinois (December 2005 - March 2006)

Web Developer

Progressive Impressions International

As a Web-Developer created Web based Applications in the form of Grid that were user friendly and with desired functionality could add, delete, insert, modify data according to the client requirements for generating and printing reports.

Responsibilities:

● Maintenance and development of screens using HTML forms and tables and programs fixing errors and updates to modify Clients requests for Bank of America using SQL queries to pull data for reporting purposes and using Stored Procedures to store complex SQL queries.

● Used Macros and formulas to speed processes and maximize accuracy.

● Process, maintenance and implementation of Clients Account Data in SQL Server 2000 Database, maintenance and testing programs in Visual Basic version 6.0 and creating reports using Crystal Reports.

● Created Flow Charts and documentation for internal use and participated in PowerPoint Presentations.

Environment: HTML, SQL, CSS, JavaScript, VB 6.0, Crystal Report, Excel, PowerPoint.

Professional / Academic Credentials

Education:

·Bachelor’s Degree from University of Calcutta, India.

·Certified Project Management Professional (PMP) – Project Management Institute (PMI)

·Certified Scrum Master

·Certified Automated Testing Framework (ServiceNow)

Contact this candidate