SUMMARY

• Having 6+ years of experience as Business Analyst and proven competence in solving technical and business challenges through team work, exceptional interpersonal skills and effective communication.
• Self - Starter, Analytical and Innovative Business Analyst with proven experience in Insurance, IT and Networking software domain.
• Extensive experience implementing all phases of Software Development Life Cycle (SDLC) Principles and methodologies such as Agile(Scrum), Rational Unified Process(RUP) and waterfall methodology in development.
• Detailed working experience in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS), Functional Requirement Document (FRD), Requirements Traceability Matrix, testing documents, design identifying interface, business process specifications and Use Case Specifications.
• Experienced in creating Use Case Diagrams - Activity Diagram, Data Flow Diagram (DFD), Sequence Diagram, State Diagram, diagrams based on UML Methodology and business Process Flow Diagram using MS Visio/ Enterprise Architect/ Rational Rose.
• Expertise in developing QA test plan, test scenarios and test cases.
• Proficient with Microsoft office tools (includes MS Project, MS Visio, MS access, MS Excel, MS Word, MS PowerPoint).
• Web Development experience: Successfully converted HTML5 to WordPress theme and hands on Experience developing backend of WordPress using PHP.
• OOAD: Strong Object-oriented Analysis and Design (OOAD) concepts and programming skills.
• Strong knowledge of Data Warehouse methodologies, including Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension Tables.
• Expert in writing detail system use cases, developing business test cases and working with QA teams during testing phase thereby facilitating acceptance testing (UAT) with stakeholders and business users.
• Experience on working with SQL Server 2008/2012, EXCEL VBA, Macros.
• Expertise in understanding and supporting the client with project planning, project definition, requirements definition, analysis, design, testing, system documentation and user training.
• Extensively involved in market research, feasibility studies, system analysis and GAP analysis.
• Experienced in handling requirement changes and user conflicts.
• Personal Skill includes Strong time & results oriented discipline, able to work in an organized fashion in teams & independently, Capable of communicating Confidential all levels - individuals & groups, Self-directed and maintain a proactive approach to problem Solving and Have excellent oral & written communication skills & solid interpersonal skills.

TECHNICAL SKILLS

Frameworks and Languages: PHP, SQL, EXCEL VBA

Scripting Languages: JavaScript

Web Technologies: HTML5, DHTML, CSS

RDBMS: MS SQL server 2008/2012, MS Access

Methodologies: Waterfall, Iterative, Incremental, SCRUM, Agile, RUP, UML, SDLC

Operating System: Windows NT/98/2000/XP/7

Business modeling Tools: MS-Visio, Rational Rose, Visual Paradigm, MS-Office, MS project

PROFESSIONAL EXPERIENCE

Confidential, Morristown, NJ

Business Analyst / VBA Developer

Responsibilities:

• Interacted with stakeholders to get a better understanding of client business processes and gathered requirements.
• Working in an Agile / Scrum environment which poses initiating several JAD sessions and active integration with business, technical and engineering terms.
• Responsible for gathering the business requirement, functional requirements, non-functional for the Confidential & Confidential conversion Software and tools required to upload the final output.
• Conducted requirement gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD) and the Functional Requirement Document (FRD).
• Captured process flows by preparing activity and sequence diagrams, pre- and post-conditions, performance requirements, impacted areas, high-level business rules, issues, areas in scope and out of scope, assumptions, etc.
• Involved in Requirement Scoping and analyzing high priority requirement. Conducted sign-off meetings with IT teams to lock down the requirements.
• Created VBA programs to analyze complex data structures from varied sources.
• Tracked stakeholder requested enhancements and changes using Requirement Traceability Matrix (RTM).
• Reviewed Technical Specification Documents (TSD) with development team, resolved issues and provided Sign Off.
• Executed SQL queries to test the database for records that detect and submit functional acknowledgement and remittance advice in the claims application.
• Accessed reports, analyzed raw data received from various sources - data extracts from Confidential tool, Excel and database. Transformed the data into creative and compelling insights.
• Involved in full life cycle report development using BI tools - Tableau. Performed data blending, Join, union operation on data by connecting to data from multiple sources.
• Involved with the Quality Assurance Team to develop and design Test Plan and Test Cases.
• Conducted User Acceptance Testing (UAT) of the application with the QA team.

Environment: Agile/SCRUM, MY SQL, UAT, .net, Tableau, Quality Centre, MS Visio, MS Office, UML, SSIS, SSRS, Crystal Reports, MS Project.

Confidential

Business Analyst / Web Developer

Responsibilities:

• Analyzed the need for interactive and informative website.
• Maintaining all the business requirements, functional requirements and nonfunctional requirements, developing and testing.
• Developed and tested the applications in an agile/scrum environment.
• Involved in all Software Development Life Cycle phases including requirement analysis, implementation and estimating time-lines for the project.
• Participated in gathering and co-coordinating requirements, design and implementation for the application.
• Responsible for designing the User Interface by coding in HTML5, CSS3, JavaScript, bootstrap to build WordPress website.
• Successfully converted HTML5 themes to WordPress theme.
• Currently working on Making Website Mobile Friendly.
• Successfully tested the website and successfully made quick responsive website.
• Used GoDaddy to make WordPress website live.
• Designed and developed stored procedures for SQL Server 2012 database.
• Responsible to gather Details from Customer and work on each Requirements.

Environment: WordPress, HTML5, CSS3, Bootstrap, JavaScript, PHP, UAT, Quality Centre, MS Visio, MS Office, UML.

Confidential, Chevy chase, MD

Business Analyst

Responsibilities:

• Extracted the Business Requirements during various sessions with business leads and tagged all requirements in Requisitepro, tracing them all the way to the stakeholder requirements.
• Responsible for acting as a liaison with operational and economic management, systems support and sales to identify business opportunities.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Implement and maintain Property and Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Responsible for testing the Quote and Purchase for Auto Insurance of the customers.
• Extensively used Visual Basic to create macros to make data migration testing more useful and compared results from the legacy databases to the new CRM database.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Prepared requirements document for Commercial Auto, Personal vehicles, driver’s insurance, Property insurance and business insurance.
• Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface).
• Understanding the High-level GIS requirements from Grasp application purview to ensure smooth integration of Grasp application with GIS interface.
• Work with Grasp and GIS Technical teams to clearly understand Business logic, processes and identify potential challenges and risks.
• Conducted JAD sessions with extensive involvement from Business, Development, Testing teams, architects, SME (Subject Matter Experts) and Managers of various Business Units.
• Responsible for the development and administration of environmental databases implementation of quality control procedures and metadata standards; data acquisition, preparation of tabular reports, charts and figures; and coordination of GIS support for multiple projects.

Environment: MS Visio, MS SQL Server, Rational Rose, Scrum Work Pro, MS Office, UML, Crystal Report, Asp.net, Visual studio 2008/2010/2015.

Confidential

Business Analyst

Responsibilities:

• Conducted daily stand-up meetings to get live updates from the team, helped Project Manager actively update the project status, detected risks Confidential early stage and took corrective/preventive actions.
• Conducted JAD sessions, user interviews, and detailed research and requirement meetings to gather requirements and fetch details for Business Requirements Document (BRD).
• Created precise High-Level Use Case (UC) to detailed UC documents to be used throughout the project.
• Prepared business process models and created AS-IS/TO-BE flows (Gap Analysis) to represent the current and future capabilities of the product.
• Assured delivery of number of documents in a timely and efficient manner. (BRD, FRD, UAT, Technical Flow Diagram, etc.)
• Managed workflows and sign off via SharePoint for all required documentation throughout the release.
• Worked with Compliance, Fraud, Risk and Security teams to ensure their concerns and requirements were covered.
• Authored Project Change Request (PCR) Documents and drove PCR from analysis to development.
• Worked directly with the Project Manager to manage project scope and handled scope changes, scope creep, process change, etc. and created/updated required documents for proper communication to all impacted teams.
• Managed change control logs and version control for the documents to provide the ease of understanding and finding the correct documents.
• Provided active testing support to the testing team. Actively participated in mobile application releases by running test cases, revivifying defects/bugs and properly communicating and highlighting them to the required representatives.

Environment: Agile Scrum, MS Office Suite, Quality Center, MS Visio, UML, Rational Suite, MS Project.

Confidential

Business Analyst

Responsibilities:

• Extracted the Business Requirements during various sessions with business leads and tagged all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements.
• Responsible for testing the Quote for estimation purpose to the client.
• Extensively used Visual Basic to create macros to make data migration testing more useful and compared results from the legacy databases to the new CRM database.
• Responsible for reviewing requirements, analyzing the requirements for implementing them using Guidewire Policy Center either by using the out-of- box solutions in Guidewire Platform or providing custom solutions on a case to case basis.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Prepared requirements document for Inventory system, account department, Customer and vendor management.
• Work with Grasp and GIS Technical teams to clearly understand Business logic, processes and identify potential challenges and risks.
• Conducted JAD sessions with extensive involvement from Business, Development, Testing teams, architects, SME (Subject Matter Experts) and Managers of various Business Units.
• Responsible for the development and administration of environmental databases; implementation of quality control procedures and metadata standards; data acquisition, preparation of tabular reports, charts and figures; and coordination of GIS support for multiple projects.

Environment: MS Visio, MS SQL Server, Rational Rose, MS Office, UML, Crystal Report, Asp.net, Visual studio 2008/2010.