SUMMARY:

• Business/System Analyst with over 15 years of IT experience. Complete understanding of Software Development Life Cycle (SDLC), including Waterfall and Agile (SCRUM) methodologies. Implemented business process improvements that decrease time to develop and improve quality of deliverables. Expertise in conducting fit gap analysis between the "As - is" and "To-be" systems. Authored many key deliverables including Business Requirements (BRs), Report Requirements (RRs), Functional Designs, Business Processes, Standard Operating Procedures (SOPs) and manuals. Owned and maintained the requirements traceability matrix to make sure planned functionality is developed, tested and deployed.
• Experience in Business Analysis, Requirement Analysis, and Business Process Analysis (BPA) and Modeling.
• Expertise in translating business needs into Functional, and Non-functional/Technical requirements.
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall and Agile/Scrum methodologies. Application Lifecycle Management (ALM) Using TFS, Ralley and HP ALM.
• Strong Experience in all the phases of Scrum framework and Agile Methodology and well versed in writing user stories.
• Experience as Scrum Master - Facilitate daily scrum meetings, sprint planning, review, retrospective, Product Backlog grooming meetings, and tracking the burn-down chart for estimation
• Experience in interfacing with users, establishing relationships, gathering and documenting requirements, rollout and maintenance.
• Expertise in visualizing the Business needs and converting them into Visio Diagrams and PowerPoint.
• Expertise in developing UI Prototype using Balsemicq, MockPlus, and MockFlow.
• Experienced in designing Entity relationship diagram (ERD).
• Created Application Environment diagrams for various applications.
• Created detailed and accurate test plans, scripts and cases for conducting smoke test, regression test and user acceptance test (UAT).
• Experience in writing SQL Queries for data analysis and validation to conform to business needs.
• Create detailed Test Plans, Test Cases, and Test Scripts.
• Experience in performing Functional, Regression, Performance, Integration, System, and User testing.
• Experienced in reporting tools like Microsoft SQL Server Report Services (SSRS) and Excel.
• Experience XML-based Report Definition Language (RDL) code using Microsoft SQL Server Studio.
• Experience using Microsoft Project, SharePoint, Microsoft SQL Server Management Studio, Excel, Word, Web Browser, Visio, Access, PowerPoint, and Outlook.
• Strong computer skills, including Word, Excel, Access, PowerPoint, Visio, ClearQuest and ClearCase
• Experience in Developing and Presenting PowerPoint presentations to Management, Clients and End Users.
• Excellent communication skills, interpersonal skills, and organizational skills with the ability to coordinate multiple work streams, multi-task and work well under tight deadlines.
• Possess Problem-Solving skills, ability to follow industry standards and procedures.
• Proven management skills such as time estimation, task identification, scope management and resource management/allocation. Quickly master new concepts, applications and technology.
• Able to effectively converse, relate and liaise with multi-functional teams, including Business Owner, Managers, Developers and Testers at all levels.
• Knowledge of HIPPA regulations and ICD-9 and ICD-10 codes

WORK EXPERIENCE:

Confidential

Sr. Business System Analyst

Responsibilities:

• Leading project activities, facilitating meetings, and requirements gathering sessions.
• Collaborate with key business and IT partners, both internal and external, across multiple divisions and departments to collect business requirements
• Documented new business requirements and non-functional requirements into Business Requirements Document (BRD)
• Re-evaluated current business processes for LSM and GLS to streamline the business process using BPMN 2.0 for re-write effort
• Documented As-is and To-Be processes for LSM and GLS
• Create Business Requirements Document (BRD) for LSM and GLS by reverse engineering the applications to discover the systems’ current capabilities
• Involved in data gap analysis to identify the best data source and lineage for future LMS application.
• Created Shared Vision document, Project Roadmap, Project plan documents
• Created Sprint Summary/Roadmap for LSM Release -1 (Release 1 is due in Q1,2020)
• Coordinating with UX team to develop the LSM project wireframes
• Creating project backlog, grooming it to setup the priorities for user stories
• Working as a Scrum Master for LSM development. Managing and grooming Product Backlog, Sprint planning. Facilitating daily stand-up meetings to keep project on track and increase team’s productivity.
• Ensured on-time delivery by monitoring Scrum team progress using tools such as sprint burn down charts.
• Coaching,, and Providing support to other teams in Agile methodology and Scrum framework.

Technologies: SQL Server 2014, SharePoint 365, VersionOne, ARIS Cloud, MS-Word, MS-Excel, MS-Visio, MS- Project.

Confidential

Project Manager /Sr. Business Analyst

Responsibilities:

• Designed NewsFeed for EffectiveTeams, 2-Factor Authentication, Time Tracking, and Payment Module for Clarity.
• Develop UI for DTA, EffectiveTeams and Clarity projects Prototypes using PhotoShop, Visio and MockPlus.
• Re-engineered Tax Evaders legacy system and implemented new CRM based System for that increased the DTA revenue by 20%.
• Monitored project budget requirements and reviewed billing and created project status reports.
• SharePoint Administrator; created/maintained websites for all the projects
• Led teams through the full software development life cycle, including requirements, design, development, and product testing and production deployment.
• Created Business Requirements Document (BRD) and Software Requirements Specification (SRS) documents, process documents for ET, Clarity, and DTA projects.
• Interacting with DTA team leads, Project Manager as well as Fairfax County IT department to analyse the functional design of TARGET project, establishing the AS-IS and TO-BE processes.
• Designing the Dashboard and the workflow for DTA project for Dynamics CRM.
• Collaborate with county managers to establish functional scope for Taxonomy project.
• Doing Interface Analysis of various Fairfax County MainFrame systems such as A2HM, A2MP (OMAV) GIS, IRMS etc for eliminating the manual steps of data entry and establishing the data integrity.
• As a Scrum Master, planning the Sprint Plan, track burn-down chart, help managing product backlog, and run daily Scrum meetings
• Maintain the Requirements Traceability Matrix using TFS to make sure requirement are developed, tested and deployed as defined in the requirements document.

Technologies: SQL Server 2014, Dynamics CRM, SharePoint 365, TFS, MS-Word, MS-Excel, MS-Visio, MS- Project.

Confidential

Sr. Business Analyst

Responsibilities:

• Oversaw about 28 projects simultaneously and managed full life cycle of these projects.
• Provided weekly detailed status reports to Senior Management
• Create Project Charter, Business Requirements Document (BRD) and Software Requirements Specification (SRS) documents.
• As a Scrum Master, planning the Sprint Plan, track burn-down chart, help managing product backlog, and run daily Scrum meetings to resolve the impediments to keep the project on track and manage the risks.
• Collaborate with federal managers to establish functional scope for various application re-write.
• Analyse business needs and define requirements for various USDA intranet-based applications by interviewing stakeholders, business users and other agencies.
• Involved in re-org effort for entire FSA into FPAC. Reviewed and analysed As-Is business processes using existing written procedures and other business artefacts to develop To-Be business process documents. and subsequently created Business Process Model for FPAC.
• Create Business Requirements, Business Rules, and System Requirement Specifications for various applications to ensure that critical requirements are not missed.
• Analyse, document and specified the Functional and non-functional Requirements for various applications and converted them in to user stories to create product backlogs in HP ALM.
• Guide development teams in various applications’ development and maintenance to ensure that all functional and non-functional requirements are addressed.
• Analysing several services and Datawarehouse for PII security and to remove data redundancy, and guiding development teams for creating and consuming webservices for getting such data.
• Work extensively on the SQL Server environment to run T-SQL queries using Microsoft SQL Server Management Studio to analyse complex data for analytics, and reporting.
• Create Visio application work flow, data flow, business processes, and application environment diagrams for various applications.
• Develop UI Prototype using MockFlow for various applications.
• Maintain the Requirements Traceability Matrix using HP ALM to make sure requirement are developed, tested and deployed as defined in the requirements document.
• Create UAT test documents and Power Point presentations (demo) for various applications.
• Demoed and trained business users across US on various applications
• Using HP ALM for Requirement, change request, Defect Assignment/Tracking, Testing, Project Status Tracking.
• Created data dictionary and data mapping documents for various applications.

Technologies: SQL Server 2014, SharePoint 2013, JIRA, HP ALM, MockFlow, Tortoise SVN, MS-Word, MS-Excel, MS-Visio, MS- Project.

Confidential

System Analyst

Responsibilities:

• Collaborate with federal and project managers, and technical leads to establish functional scope and boundary for new proposed functionalities.
• Followed a structured approach to organize the requirements into logical groupings of essential business process, business rules to ensure that critical requirements are not missed.
• Analysed, documented and specified the Functional Requirement for over ninety SSRS Reports and UI.
• Created the business requirement for Report privileges and documenting the functional requirement and guiding the design and development team in creating access controls.
• Created many Visio diagrams for the ECS system used across the entire organization.
• Developed UI Prototype for many reports using Balsemiq.
• Architect for ECS report’s level security that required new table creation. The Existing role codes were re-grouped to Group codes in such a way that user could only see that data that pertains to him/her.
• Worked extensively on the SQL Server environment to run T-SQL queries using Microsoft SQL Server Management Studio to analyse the ECS Reports, Claim marts, Case Mart and Payment Mart data to identify and resolve bugs and to create new Report Requirements.
• Maintained the Requirements Traceability Matrix to make sure requirement are developed, tested and deployed as defined in the requirements document.
• Participated in Test Case Review to ensure test cases appropriately translate and map to the requirements.
• Developed detailed Test plan and Test cases for testing Report functionality, UI and Report security.
• Created UTD/UAT test cases, Power Point for End Users to conduct Report Automation testing.
• Created and delivered many PowerPoint Presentations for the clients and user for Product evaluation such as SAP Business Object and MS SQL Server.
• Worked as a lead analyst to develop a Data Warehouse (2nd Phase of Report Automation) for ECS. Work with stakeholders to gather user requirements for the Data Warehouse and subsequent reporting.
• Identified the Facts and Dimensions for ECS Data Warehouse and ETL process.
• Created Data Warehouse Architecture diagrams
• Facilitated and Maintained weekly CCB (Change Control Board) to review all changes across the project.
• Created Stored Procedures, Functions, Generating Scripts, Creating or developing Tables and Joins in SQL Server using Microsoft SQL Server Management Studio.
• Created or develop XML-based Report Definition Language (RDL) report code using Microsoft SQL Server Management Studio and extrude the reports to SSRS Server.
• ALM using Rally, including Requirement Gathering, Defect Assignment/Tracking, Testing, Project Status Tracking, and Project Collaboration.
• Wrote Business requirements for several reports. Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements.
• Created system requirements for various Data-Marts such as ‘Payment-Mart’ and Case-Mart’.
• Created the As-Is diagram and the proposed To-Be diagram for the data-Marts including the diagrams for different phases of the project using Visio tool. Helped the deployment of the project in defined phases.
• Document and participated in migration and implementation of ICD-10 (from ICD - 9 medical codes) in the application for reporting purposes.
• Analysed Report requirements and developed detailed Test plan and Test cases for testing the Reports
• Facilitated weekly meetings with the teams to improve testing process for Report development.
• Wrote complex SQL queries to test and verify the report outputs.
• Ran SQL Queries using Recurring Report Services (RRG) tool to prepare weekly and monthly Reports.
• Authored Business and System requirements for many complex/critical reports.
• Gathered business requirements and translated them into System requirements for the development team for many critical reports such as ‘DEEOIC Annual Report’ to Congress for FY 2013, 2014 and 2015.
• Testing Web Stat that gets published every week on DOL web site.
• Testing ECS Daily, Weekly and Monthly reports before they are distributed to the Client.
• ALM using Rally, including Requirement Gathering, Defect Assignment/Tracking, Testing, Project Status Tracking, and Project Collaboration.
• Supported collecting and documenting requirements for Wage Loss Component, Impairment Component, and NIOSH Component modules, requiring extensive co-ordination with business community.
• Created the UI protoypes for various modules using Balsamiq.
• Created Business Process model for NIOSH and FAB Hearing components using BPMN.
• Wrote Business requirements for DDRs (Drill down Reports) for ECS Reporting UI.
• Involved in data modelling for the application and created ER diagrams.
• Supported QA/Testing of FAB Hearing & RWR Component, Medical Component, Survivorship Component, and Offset Component modules.
• Developed UAT test plans, UAT test cases and coordinated the tests with the QA team to verify implementation of new features and enhancements.
• Extensively used SQL scripts to verify database integrity in backend testing.
• Participated in Mapping of ECS Application to the database.
• Documented mappings done on Source Data Elements to Destination Data Elements.
• Reported and Tracked Defect and Enhancements Using ClearQuest.
• Used ClearCase for Report’s version control.
• Analysed HIPAA laws and regulations to make ECS HIPPA compliant
• Performed impact analysis for ICD-9 to ICD -10 migration
• Mapped CD-9 /ICD-10 codes
• Used Agile methodology for software development with Confidential team
• Lead the team as SCRUM Master
• Involved in project planning & estimation efforts using Rally Software.
• Designed, developed and authored ECS IV&V Business Process Model, ECS Database Replication and Sanitization Process, ECS High level System Architecture document.
• Designed many Visio diagrams such as ECS Database Replication and Sanitization Process, ECS Report Automation, ECS High level System Architecture diagrams etc.
• Developed and delivered several Power Point presentations to Clients and End Users such as ECS Report Automation, SQL Server and Business Object Product Study, ECS Report Automation Presentation.
• Trained and guided over ten new hires on Scrum frame-work and ECS application.

Technologies: SQL Server 2012, SQL SQuirreL SQL Client, MS-Excel, ClearCase, ClearQuest, Rally Agile Application Lifecycle Management Platform, DB2 UDB, CVS, MS-Word, Windows XP, BPMN, Balsemiq, Visio, MS Project.

Confidential

System Analyst

Responsibilities:

• Point of Contact with end customers to receive customer issues related to Radiant One VDS. Interfaced with System Engineers to identify, reproduce, and resolve customer issues. It involved conference calls as well as GoTo meeting sessions. Collaborate with clients for VDS Customization.
• Utilized SalesForce SOA App to track customer issues/ reporting bugs/ providing patches and custom codes. Documenting all customer related communication in Salesforce History.

Technologies: LDAP, SQL, Java EE, MS Word, Oracle, OpenDS, Amazon EC2 Cloud, Salesforce, and Windows XP.

Confidential

Analyst

Responsibilities:

• Key member of the strategy, planning and procurement of funding.Responsible for implementation and maintenance of the computerized system.
• Developed computer based /examination test material, increasing student participation and helping better experience for students.Trained Marine Engineering staff in handling toxic and hazardous materials.
• Developed computer based /examination test material, increasing student participation and helping better experience for students.
• Trained Marine Engineering staff in handling toxic and hazardous materials.