PROFESSIONAL SUMMARY:

• Over eight years of experience as a Senior Business Analyst in various domain
• Experience in all phases of software development life cycle (Agile and RUP) including application demos, requirement analysis, business analysis, design and construction phases of application development, change management, ongoing support
• Analysis business issues and provided recommendations for possible solutions, work with Business users and IT project teams to drive decision making and define requirements for application development, ensuring that business needs are met. Worked closely with the Development team and Business teams to ensure successful implementation of business requirements.
• Support the development and maintenance of the business requirements process used to define requirements for systems projects, assist with the definition of project scope and create appropriate scope documentation
• Evaluate opportunities to improve application reliability, provide recommendations for possible solutions, and work with IT and Business partners to implement solutions.
• Experience in conducting JAD sessions, Scrum session, Brainstorming sessions and Focus Groups
• Experience in conducting GAP Analysis, Impact Analysis, SWOT analysis and Business Process Engineering by using Business Analysis tools. involved in validation activities for Laboratory Information Management System (LIMS) from LabVantage
• Expert in documenting requirements for LabVantage LIMS interfaces to external systems
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Extensive experience in creating User stories and decomposes each user stories for sprint planning.
• Hands on experience in creating large number of artifacts such as: BRD (Business Requirement Document), FRD (Functional Requirement Document), FSD (Functional Specification Documents), PSD (Page Specification Document), TFSD (Techno - Functional Specification Document) etc
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, sequence Diagrams, logical and physical diagrams, context diagrams, cause and effect diagrams, decomposition diagrams and many more
• Extensive experience in creating/executing Test Plans, Test Scenarios and Test Cases and assist in User Acceptance Testing (UAT).
• In depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
• Design and review of various documents including the SRS, FRD, SRS, Use Case Specifications, data requirements, RTM, GUI Requirements, SLA's, RFP and project initiation document.
• Sound in Suggesting system automation solutions to business problems or opportunities; providing automated solutions that are cost effective and that meet user requirements.
• Supporting developers with unit testing and troubleshoot where the issues emerging.
• Experienced in creating tableau dashboards, worked with different types of data visualization charts in tableau.
• Expertise in GUI testing, Functionality testing, System testing, Unit testing, Integration testing, Front end testing, Back end testing and Regression testing of Client/Server and Web based applications
• Demonstrated capability in managing people, leading teams on various complex projects.
• Extensive experience in developing Use Cases, business process modeling,
• Creating Screen Mockups, prototypes and wire frames for website as well as developed layout of GUI.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Experienced in ICD 9 to 10, EDI Transaction (270/271, 276/277, 834, 835, 837), HIPAA 4010/5010, Affordable Care Act, Health Care Claim Submission, Health Care Claim Adjudication, Rx Claim, E-Prescription, E-Lab, PBM (Pharmacy Benefit Management), Specialty Pharmacy, HIE (Health Information Exchange), HIX (Health Insurance Exchange), Medicare (Part A, B, C, D), Medicaid, EMR (Electronic Medical Record), Revenue Cycle Management and Different Health Insurance Plan and Benefits.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Platforms: Windows 2000/XP/NT, Linux, Windows Vista and 7

Content/Change Management Tools: MS Share Point, Rational Clear Case, Jira

Modeling & Analysis Tools: Rational Rose, MS Visio, Rational Requisite Pro, Caliber RM

Web Development/Design Tools: Flash, Adobe Creative Suite, Balsamiq, iRise Studio

Testing Tools: Rational Clear Quest, HPQC, ALM, Load Runner, Rational Test Manager

Project Management Tools: MS Project, Rational Team Concert

Office Tools: MS Word, PowerPoint, Excel, Outlook

Other Tools: Tableau

PROFESSIONAL SUMMARY:

Confidential - Norfolk, VA

Lead Business Analyst

Responsibilities:

• Gathered business requirements by interviewing the Subject matter experts (SMEs), conducting JAD sessions with stakeholders and documented them in a format that could be reviewed and understood by both business and technical teams.
• Performed as a business and technical analyst by translating user requirements into practical/integrated process-based solution
• Attended trainings such as EDC-Rave, Oracle Argus Suite and Electronic Document Management Systems (EDM), Change Management and Control, Validation with respect to a specific project
• Good experience using Microsoft SharePoint for document management and as a common repository for project documents and deliverables.
• Identified and documented the technical requirements for the LabVantage LIMS v.6.0.1 (Lab Information Management System)
• Utilized Share Point document management system to share documents and to interact with client.
• Worked on Document Management, Service Definition, Workflow Management, Contact Management, Neutrals Management, Activity Management and Communications Management modules.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion
• Utilized MS Office products and Adobe Acrobat for technical writing. Utilized Collab net as the enterprise document management system for document capture and for version control
• Developed business intelligence reports using Business Objects (BO) tool for the updated results to the stake holder
• Worked along with the Project Manager and other BA's to develop various project plans to track down the time and progress of various projects using MS Project.
• Carried out extensive analysis of the business requirements and subsequently developed high level Use Cases.
• Prepared Use Case diagrams using MS Visio.
• Prepared basic design diagrams including flow charts, data flow diagrams using MS Visio following the UML conventions.
• Converted functional specifications to technical specifications (design of mapping documents)
• Wrote Functional specifications for each of the ETL processes, working in close co-ordination with business users and development leads.
• Configured laboratory information management systems, such as LabVantage SQL LIMS,developing validation master plans and validating LIMS implementations
• Reported the overall progress periodically to the Project Management and business stakeholders.
• Maintained Requirements, Traceability Matrices and Attribute matrices using Rational Requisite Pro.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing
• Conducted User Acceptance Testing (UAT), gathered and documented User Manuals and Business Rules.
• Managed the planning and requirements phase for the implementation of a Laboratory Information Management System (LIMS)
• Developed and Tested SAS programs needed to import external data from raw data files.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Analyzed, designed and successfully completed the full product development life cycle of a high visibility, high throughput screening Laboratory Information Management System (LIMS).
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Validation of lab equipment interfaces to ensure data is correctly transferred to the LIMS. This includes completed test cases and documented evidence.
• XML is used extensively to communicate with web service component and to populate data at the client side
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Created RUP activity diagrams and sequence diagrams to analyze the requirements and recommend solutions.
• Assisted the technical team in translating application functionality into application architecture.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly
• Learned LabVantage tool to understand the functionality and scope of the product

Confidential - Baltimore, MD

Business Analyst

Responsibilities:

• Involved in preparing project scope document which focus on what are the areas we are going to develop and also mentioned the risks, assumption, dependences and limitation of the project.
• Identified various interfacing system of two EMR and created context diagram and spreadsheet with various information about interfacing system to make understand stakeholders about the two EMRs
• Assisted my project manager for daily and weekly status report, project tracking, reporting and presentations, involved in preparing project road map.
• Involved in the implementation of LabVantage LIMS ensuring compliance with FDA rules and regulations
• Worked with project manager for resources allocations, assigned and track tasks as well as tracking deliverable
• Involved in different JAD sessions with stakeholders, system owners, architect and developers to present project scope document and gathered high level business requirements as well as analyzed the Requirements and managed changes using Rational Suite
• Created work package and task lists for completion of different artifacts.
• Developed business process models in RUP to document existing and future business processes as well as created Use Cases, page specification and Technical Interface Specification document and conducted meeting for getting feedback from system owners and architect for different artifacts and make correction if needed.
• Developed Activity Diagrams, logical and physical diagrams, Sequence Diagrams, low level business process flow and decomposition diagram for different requirements as well as created different wire frames, mockups and prototypes for new web based business processes by which end users and customers can do their operations
• Created different Experienced in User experience (UX) definition and User Interface (UI) design for project.
• Communicated with developers and QAs to collect information about their release schedule and make them understand about various artifacts.
• Managed offshore vendor team who was responsible for development of website and another offshore team who was dealing with all pharmacy claims. I was responsible to communicate with them and monitor them about their assigned tasks.
• Developed training materials for training users about new features of the projects
• Executed PQ and OQ scripts and wrote validation documents for the validation of Labvantage LIMS
• Used Share Point for upload, edit and delete new and existing document to the team members.
• Created e-prescription process and enhanced processes for claim adjudication
• Executed Test Cases in System, Integration, Backend, Front-end, Regression, E2E, and UAT using SQL queries and UI testing on applications.
• Worked with UAT testing team to setup data, share test cases, and provided results walkthroughs.
• Created gap analysis about ICD 9 to 10 conversion process and also involved in data mapping for conversion.

Environment: RUP, Microsoft Office Suite, Case Completes, MS SQL 2008, HPQC, MS Share Point, MS Visio 2008, Balsamic, MS Project, Labvantage

Confidential - Ashburn, VA

Business System Analyst-

Responsibilities:

• Involved in the complete SDLC (software development life cycle) of the application from requirement analysis to testing.
• Followed Agile Methodology in analyze, define, and document the application, which will support functional and business requirements. Coordinate these efforts with Functional Architects
• Facilitated JAD sessions and created reports for budgeting finance and project Management
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Gathered information all types of business reporting requirements to generate these reports, using Crystal reports, CSV format etc.
• Gathered requirements and designed Report Specifications for Driver Reports which comprised of complex SQL queries on multiple database environments. Gathered requirements for internal reporting within the mortgage section from executive level clients to generate mortgage related reports
• Analyzed, design and develop new Excel VBA applications.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Worked extensively with MS office suite for preparing status reports during project life cycle.
• Data scrubbing of raw source data utilizing advanced Excel/Macro techniques, MS Access and VBA.
• Collecting data from various sources in the form of oracle, XML, flat files and bringing those into uniform format and normalization.
• Developed BDD tests using Cucumber by writing behaviors and step definitions.
• Assisted and directly involved with QA team in creation of Test Cases and tests implementations.
• Conducted Data validation and analysis using SQL Queries and statements Tool & Technologies
• Researched inquiries from law enforcement and regulatory agencies directed to the compliance department
• Created ETL package using SSIS for data conversion using various transformations tasks.
• Automated calculation and daily reporting system by building VBA macros to decrease the time spent
• Integrated custom visuals based on business requirements using Power BI desktop.
• Provided maintenance and development of bugs fixes for the existing and new Power BI reports.
• Verified to ensure that all artifacts are in compliance with corporate SDLC Policies and guidelines.
• Defined guidelines on system integration, migration of the application at infra level as well as application level.
• Deployed the code into production, UAT testing, and system integration
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Participated in budgetary estimates for integration, migration, resource estimates for different projects
• Drafted metrics management, analysis, and data collection for reporting
• Worked on Architect design ideas for application monitoring and alerting
• Implement Standardized Data Quality Processes including Data Profiling and Cleansing.
• Prepared Test Data and preformed Positive and Negative Testing used in Data Driven Testing.
• Demonstrated ability in utilizing Postman and SoapUI for testing web services (SOAP & REST API)
• Used JIRA Software Extensively in Agile and Coordinate with Offshore teams for Time Bound deliverables.
• Responsible for management and oversight of a regulatory compliance of a business unit that is regulated worked on Design and implement business managed DR solution for application servers
• Provided input to the project manager developing integration and implementation plan
• Reviewed and provide feedback on functional and technical documents/deliverables created by team members
• Participated in numerous development life cycle and general activities related project agile process
• Created/Gathered requirements, Design documents/Reports, process flow as per business needs
• Data analysis and forecasting of upcoming due vulnerabilities using Excel PowerPivot.
• Created reports for change management purposes with SQL report.

Environment: SSRS,, VBA, Power Pivot, Power BI, Teradata, MS SQL Server, XML, Oracle, HP Quality Center, SQL,Oracle,T-SQL,IBM Doors, Oracle PL/SQL,Doors, Windows, MS-Office, MS-Visio, Actuate Report Rational RequisitePro.

Confidential - Mclean, VA

Business Analyst

Responsibilities:

• Worked with Subject Matter Expert to create a system which could be used both internally and externally.
• Followed Agile Methodology to analyze and design business needs in an iterative manner.
• Responsible for coordinating JAD sessions with business users to analyze the present shared resource, analyze the needs of the new application, application lifecycle, gather and define the key performance indicators, document and present the requirements specifications
• Led Joint Application Development (JAD) session and user interviews to get a better understanding of client business process.
• Ability to work collaboratively with Customers, Business Teams, Quality Assurance, Developers and other team members in complex testing projects and in the overall enhancement of software product
• Performed GAP and Risk analysis of existing system and evaluating benefits of new system.
• Conducted functional requirement reviews and walkthrough with the Integration experts and stakeholders.
• Created UML diagrams like Use Case Diagrams, Activity Diagram using MS-Visio for various stakeholders.
• Facilitated and coordinated daily Change Management meeting to address change inefficiencies or identified risks.
• Analyzed the "As is" and "To be" system documents to show the current and proposed functionalities of the system using MS VISIO.
• Utilized Balsamiq cloud to create seamless low fidelity wireframes of the redesigned website
• Assisted Project Managers with the development of project schedules and management scope using MS Project and Excel.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Worked with Balsamiq to create Screen Mocks for new applications
• Incorporated Balsamiq mockup tool to design website under guidance of company
• Designed and implemented SQL queries for QA testing and report / data validation including joins, aggregate functions to bring together data from various tables, for reporting purposes
• Generated tableau dashboards with combination charts for clear understanding
• Extensively worked on MS Access, MS Excel, MS Word, PowerPoint, SQL, MS Project
• Utilized defect tracking tool JIRA for reporting bugs/defects in functionality. Conducted weekly status meeting with development teams for defect resolution. Utilized SQL for querying database tables during testing.
• Worked extensively on Access, such as creating Tables, Validating the Relationship between tables and Executing SQL queries for data validation and Reporting Purpose.
• With each suggested update, took business approval and then assigned the change request to developers, QA teams, to follow the SDLC steps to implement changes.
• Involved in writing Test Cases and developing test strategies with Quality Assurance group to implement them.
• Tested the final application for usability testing (UAT) to verify whether all the user requirements were catered to, by the application.

Environment: MS Office (Word, Excel, PowerPoint, Visio, Project), JAD, UML, SQL, Rational Rose, BalsamiqJIRA, Tableau

Confidential - Minneapolis, MN

Business Analyst

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes.
• Collected, documented and managed business requirements, functional requirements and non-functional requirements using MS Word.
• Conducted problem opportunity analysis, user interviews, gathered, analyzed and documented business requirements based on the analysis the processing workflow model.
• Followed Agile Methodology to analyze and design business needs in an iterative manner. Led Joint Application Development (JAD) session and user interviews to get a better understanding of client business process.
• Designed data flows that (ETL) extract, transform, and load data by optimizing SSIS performance.
• Performed GAP and Risk analysis of existing system and evaluating benefits of new system.
• Conducted functional requirement reviews and walkthrough with the Integration experts and stakeholders. Developed Investment Banking describing the structure of the deal, return expectation and projected financials
• Upgrades, performing source-to-target mappings, storage capacity planning and developing ETL.
• Worked on development of data warehouse and ETL systems using relational and non relational tools like SQL.
• Developed new criteria in investment process via value focus and mean-variance portfolio construction. Improved investment process performance by remaining above benchmark
• Created UML diagrams like Use Case Diagrams, Activity Diagram using MS-Visio for various stakeholders.
• Key area of responsibility core service functions (incident management, service desk, change management).
• Assisted in the preparation of financial projections to support investment banking engagements, including financial modeling comparable company transaction multiple or deal structure analyses to support deal positioning, negotiation and execution.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like SQL server. Worked with ETL to create source to target mappings.
• Evaluated and executed expansion-stage investments for venture capital fund and technology companies completed two deals totaled in invested capital.
• Prospected for new investment Banking opportunities, conducted market, competitive, regulatory, intellectual property and due diligence, prepared investment pitches and built term sheets for investment committee approval.
• Interacted with entrepreneurs, communicated findings to advisory board members, directed participation in investment banking decisions and monitored ongoing deal flow process.
• Designed and implemented SQL queries for QA testing and report / data validation including joins, aggregate functions to bring together data from various tables, for reporting purposes
• Utilized defect tracking tool JIRA for reporting bugs/defects in functionality. Conducted weekly status meeting with development teams for defect resolution. Utilized SQL for querying database tables during testing.
• Worked extensively with Microsoft Excel, Microsoft Word and PowerPoint.
• Worked extensively on Access, such as creating Tables, Validating the Relationship between tables and Executing SQL queries for data validation and Reporting Purpose.
• With each suggested update, took business approval and then assigned the change request to developers, QA teams, to follow the SDLC steps to implement changes.
• Involved in writing Test Cases and developing test strategies with Quality Assurance group to implement them.
• Tested the final application for usability testing (UAT) to verify whether all the user requirements were catered to, by the application.

Environment: MS Office, Agile (Scrum), MS Project, UML, MS Visio, JIRA, SQL