SUMMARY

• Accomplished business analyst with more than twelve years of experience in IT.
• Possess well - developed skills and experience in evaluating and improving business systems and processes.
• Proficient in analyzing and creating use cases, activity diagrams and swim lanes.
• Have strong analytical, time-management, problem-solving and decision making abilities; Proven ability to produce work with limited supervision.

Area of Expertise

• Requirements gathering
• Gap analysis & solution recommendations
• Test case & User Acceptance Testing
• Agile Scrum methodology
• Software Development Lifecycle
• SQL queries

TECHNICAL SKILLS

Web Technologies: Visual Basic 6.0, COM / DCOM, .NET, FoxPro, ASP 3.0Source Control System CCC Harvest, Visual Source Safe, WinCVS, TFS

Development Platform/Environments: Microsoft Visual Studio.NET, SharePoint Portal 2013, SQL Server 2013, MS-Access, Oracle, ATG

Reporting Tools: SSRS, Analysis Services, Tableau

Other Tools: JIRA, Confluence, Outlook 2016

PROFESSIONAL EXPERIENCE

Senior Business Analyst Consultant

Confidential

Responsibilities:

• Responsible for gathering requirements and document requirements for the Data Broker Services used by Health and Human Services Commission(HHSC) for SNAP, TANF and Medicaid eligibility. Consult with internal business unit partners to validate requirements
• Consult with functional unit management and personnel to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access
• Act as a liaison between departmental end-users, technical analysts, information technology analysts, consultants and other organizations in the analysis, design, configuration, testing and maintenance of systems to ensure optimal operational performance
• Analyze the feasibility of, and develops requirement for, new systems and enhancements to existing systems; ensures the system design fits the needs of the users
• Conduct business requirements gathering sessions in the form of questionnaires and business scenarios with the business sponsors, subject matter experts (SME) and the developers.
• Prepare business process flow diagram, user stories, requirement specifications, business rules, user interface mock-ups, data mapping and other documentation as necessary for software development
• Perform data analysis using sql queries
• Follow Agile SCRUM and Kanban methodology for SDLC iterations of the project.
• Use Confluence to create and manage documents
• Use JIRA for Issue tracking and assign tasks.
• Provide status reports to IT Director

Business Analyst

Confidential

Responsibilities:

• Responsible for gathering requirements and document the requirements to comply with Medicare Part D CMS requirements. Consult with internal business unit partners to validate requirements
• Conduct business requirements gathering sessions in the form of questionnaires and business scenarios with the business sponsors, subject matter experts (SME) and the developers
• Work with business sponsors to gather, manage, and prioritize requirements
• Developed As-Is and To-Be business process for the CMS November and February software changes
• Prepare business process flow diagram, user stories, requirement specifications, business rules, user interface mock-ups, data mapping and other documentation as necessary for software development
• Acceptance test done on both front end and back end data. Back end data is verified using SQL queries and stored procedures
• Conduct requirement walkthrough with Business sponsors and IT teams
• Follow Agile SCRUM methodology for SDLC iterations of the project. Use SCRUM methodology to define Acceptance Criteria for functional requirements
• Work with the development team to design and implement prototypes and software systems.
• Identify and document issues, risks, gaps and their impact to the project life cycle. Provide recommendations and alternatives
• Assist with user testing of systems, developing and maintaining quality procedures
• Provide status reports to IT Development Manager and IT BA/QA manager

Senior Business Analyst

Confidential

Responsibilities:

• Conducted business requirements gathering sessions in the form of questionnaires and business scenarios with the business sponsors, subject matter experts (SME) and the developers
• Worked with business sponsors to gather, manage, and prioritize requirements. Created business requirement documents for rewriting the iPrint portal, Office Depot migration portal and Walmart portal
• Captured requirements for around 100 user stories in 9 sprints for the iPrint portal. Generated user story Acceptance Criteria and depending impact analysis documents
• Developed As-Is and To-Be business process for the iPrint portal rewrite and Office Depot migration portal
• Prepared business process models, user stories, use cases, swim lane diagrams, requirement specifications, business rules, user interface mock-ups, data mapping and other documentation as necessary for software development
• Conducted requirement walkthrough with Business sponsors, IT and QA teams
• Followed Agile SCRUM methodology for SDLC iterations for all projects. Used SCRUM methodology to define Acceptance Criteria for functional requirements
• Captured user story points, categorized into respective epics and maintained the requirement matrix
• Work with Marketing on item promotions/discounts and pricing setup and validation of the same.
• Worked with the development team to design and implement prototypes and software systems
• Identified and documented issues, risks, gaps and their impact to the project life cycle. Provide recommendations and alternatives. Analyzed the gaps for training purposes
• Assisted with user testing of systems, developing and maintaining quality procedures
• Provided status reports to product owners

Business Analyst

Confidential

Responsibilities:

• Worked with users and sponsors to gather, manage, and prioritize requirements for integration of TeamMate with other CCH GRC (Governance, Risk and Compliance) products
• Performed data mapping to map the GRC database to the TeamMate database for integration.
• Defined and documented detailed project requirements and deliverables with project stakeholders.
• Produced models of "as is" and "to be" business processes and associated narratives.
• Documented data requirements, data flow, and data models that support project requirements.
• Used Agile SCRUM methodology for SDLC iterations.
• Decomposed mid-level business requirements into functional and non-functional requirements.
• Worked with program and project manager, architect, technical leads, developers and database administrators to design and implement prototypes and software systems that meet requirements.
• Worked with stakeholders and management to discuss requirements, identify issues and discuss solutions.
• Prepared use cases, swim lane diagrams, requirement specifications, business rules, user interface mock-ups, prototypes, data mapping and other documentation as necessary for software development.
• Conducted pre-planning game to prioritize work for the next iteration
• Provided status reports to product owners. Conducted daily stand up call to discuss work status with the team
• Assisted Business Users with User Acceptance Testing

Business Systems Analyst

Confidential

Responsibilities:

• Gathered business and technical requirements through JAD/JAR sessions
• Responsible for authoring the Project Requirements Statement by analyzing the business use case and system logical data models
• Wrote SQL queries to retrieve data for building cube and reports
• Developed cube using Sql server analytical services(SSAS) and reports using Sql server reporting services(SSRS)
• Gathered data from different systems, processed and stored them in the data warehouse to enable report generation.
• Performed data mapping to map the data from different systems to the data warehouse.
• Analyzed the database design and build the draft data model. Worked with the DBA’s in designing the data model
• Designed prototypes, release products to production, and maintain product releases
• Participated in code review and specification walkthrough
• Created task plans, managed and tracked project execution
• Formulated and effectively allocate team talents to accomplish identified project tasks
• Mentored the project team throughout the deliverable process
• Audited deliverables from functional areas to ensure they support the end deliverables
• Mediated coordination issues encountered by team members and supported functional staff
• Conducted regular project status/quality meetings and shared status reports with clients
• Maintained overall project documentation for the post install "lessons learned" review

Project Lead

Confidential

Responsibilities:

• Created system requirement specification and conducted specification walkthrough
• Developed components using VB6.0, XML, VBScript
• Prepared XSLT for different equipment to generate and send XMLs to datalog
• Created project plans, managed and tracked project execution
• Released products to production, and maintained product releases
• Involved in the Business Continuity Planning
• Checked the SLA (Service Level Agreements) for each month and reported to manager
• Prepared metrics analysis presentation to the top management, to show the progress of the team
• Performed internal audits for CMM compliance and quality process audits

Software Engineer

Confidential

Responsibilities:

• Developed components to call the related XML, XSL files which has values coming from host (Mainframe)
• Created GUI for new requirements and confirming the format with the client
• Developed requirement matrix, which is used by the higher management to keep track of system tests
• Developed project change request that generates a variety of reports. These reports can be converted into word format
• Participated in code review and specification walkthrough
• Provided technical guidance to team members

Software Developer

Confidential

Responsibilities:

• Involved in the design of database of Report Suite Web, which is an integral part of Report Suite Enterprise Solution
• Developed COM components to manage back office operations, retrieval of PDF files, send automated responses for the issues received.
• Created ASP pages for back office operations which is used in giving certain permission to certain users.
• Created mailing components that used Collaborated Data Objects
• Created web pages for logging issues, sending responses, changing the status of issues using ASP
• Used Image Edit component to convert TIFF images to Jpeg