Sr. Business Analyst & Technology Consultant Resume
Washington D, C
SUMMARY
- An enthusiastic, hard - working professional wif a proven track record and good leadership skills. A creative and intuitive problem solver wif a love for data research and analysis. Strong work ethics and an amiable team player capable of gelling wif and motivating team members to perform above their expectations and an individual wif a desire to continuously learn and excel.
- 8 years of diverse work experience in the domains of Financial institutions (Investments and Wealth Management), Property and Casualty Insurance (P & C Insurance) and Banking.
- Highly skilled and experienced in utilizing Agile methodologies in SDLC, including Scrum and RUP as well as Waterfall methodology.
- Strong experience and noledge in SDLC and project lifecycle including Analysis, Review and Design.
- Excellent verbal and communication skills that is necessary to elicit requirements through shadowing, surveys, interviews and JAD sessions wif Business Owners, Business Users, SMEs and other stakeholders relevant to the project.
- Extensive experience in creating As-Is and To-Be process models, conducting Gap Analysis to understand areas of improvement and analyzing the risks involved through SWOT, FMEA, Value Stream Mapping, Feasibility Analysis and Impact Analysis.
- Skilled in identifying data requirements, creating data flow diagrams, data mapping, data analysis, Process mapping and BPM.
- Skilled in data modeling (conceptual, Physical and Logical) and creating Entity-relationship diagrams.
- Highly experienced in creating the requirements artifacts, Business Requirement Document (BRD), System Requirements Document (SRS), Use-cases, Functional Requirements Document (FRD), Technical Requirements Document (TRD) and Change Requests Planning (CRP).
- Proficient in using UML and MS Visio to create Use-Case diagrams, Sequence diagrams, Collaboration diagrams, Activity diagrams and Class diagrams.
- Proficient in creating mock-up screens and prototyping static and dynamic UI wif HTML4, Mockup Screens, MS Visio, Lucid Chart. Experience wif storyboarding and creating quick wireframes.
- Significant work wif UI/UX development wif in depth noledge of Adobe Creative Suite.
- Comprehensive noledge of Data Warehousing wif significant implementation experience.
- Extensively used SQL database to extract application data using SQL queries and performed data migration and data integration.
- Significant noledge and experience in using ETL tools such as Informatica 7, Informatica 9.0.1.
- Comprehensive experience and noledge in using Business Intelligence tools SAS 9.2, TABLEAU DESKTOP 8.2, etc.
- Comprehensive understanding of Web-services and the corresponding Service Oriented Architecture (SOA).
- Extensive experience in Change Management and Software Configuration Management (SCM).
- Highly expertized in tracing requirements throughout the development process and verifying adherence to Requirement Traceability Matrix (RTM). Extensively used tools such IBM Doors, Atlassian JIRA.
- Significant experience in reviewing Test Procedures and creating Test Cases, Test Scripts and Test plans.
- Extensive noledge and experience in defect management using HP Quality Centre and facilitating Triage decision making (Prioritization and Severity of defects) in defect management.
- Familiarity wif White box and Black box testing including functional testing, unit testing, integration testing, smoke testing, system testing and regression testing.
- Impeccable interpersonal skills, leadership qualities and excellent written and verbal communication. Adept at conflict management, work delegation and negotiation. Adapts easily to different environments.
TECHNICAL SKILLS
SDLC: Agile Scrum, RUP, Waterfall, Six Sigma (DMAIC)
Supporting Languages: HTML, SQL, XML
PM Tools: Lean Management, SWOT, CBA, FMEA, Impact, GAP, MS Project 2010, MS Office, MS PowerPoint
Modeling Tools: MS Visio, UML, Lucid chart, Adobe Illustrator
Business Tools/Reporting Tools: MS Project, TABLEAU DESKTOP 8.2, Micro-Strategy, MS Visio, MS Excel, MS Word, MS PowerPoint, MS Access.
Statistical Tools: SAS 9.2
Supporting Tools: JIRA, Rational Requisite Pro, Rational ClearQuest, Rational ClearCase
Testing Tools: HP Quality Center
ETL Tools: Informatica 7, Informatica 9.0.1, IBM Cognos
PROFESSIONAL EXPERIENCE
Confidential, Washington D.C
Sr. Business Analyst & Technology Consultant
Responsibilities:
- Acquired and read the artifacts to understand the various subsystems that effected inspections and scoring of Public Housing developments across the United States.
- Understood the various metrics that governed the data and also developed a keen understanding of the Date Warehouse.
- Created ad-hoc reports for the various business subsystems, completed pending tasks.
- Gatheird business requirements for the new quarter (October - December 2014) by interviewing the business owners and users.
- Developed Business Requirements Document for the business owners and a Functional Requirements Document for the technical team.
- Developed a report detailing the overall performance of the Public Housing Agencies on various metrics as requested by the Business team.
- Created basic Micro-Strategy dashboards to give an idea to the development team on the various metrics, calculations and the tables necessary to complete a particular task.
- Developed a lean Quality Control process to ensure integrity of Micro-Strategy dashboards through rigorous testing and validation.
- Ran Oracle SQL queries and performed data validation for the developed Micro-Strategy dashboards.
- Ensured smooth transition to the new team of contractors working for HUD.
Environment: Oracle SQL, Micro-Strategy, MS Visio, MS Access, MS Project, MS Excel, MS PowerPoint, MS Word, MS Outlook, SharePoint.
Confidential, New Jersey
Sr. Business Analyst
Responsibilities:
- Acquired and read through the artifacts prepared while developing the existing system to gain an understanding.
- Conducted interviews of the portfolio analysts and traders to understand the As-Is (Present State) process.
- Conducted interviews wif the Business Owners (BO) to understand the To-Be (Future state) process.
- Conducted Gap Analysis to identify potential opportunities of improvement and recommended them to the Project Manager.
- Conducted Operational Risk Analysis, Feasibility Study and created the Work Breakdown Structure (WBS) using MS Project 2013.
- Expressed the requirements through user stories, use cases, HTML models, ER diagrams and Process Flow Diagrams.
- Created an intuitive and minimal UI for the application, wif an aim for the application to enable “maximum user efficiency wif minimal interaction.”
- Created the Product backlog wif help of user stories collected through requirements gathering and gap analysis.
- Helped the PM team in resource and budget planning.
- Acted as a Scrum Master (leading a team of 15), creating sprint backlogs, organizing and conducting sprint planning meetings, daily scrum meetings. Created sprint burn down charts and release backlogs for effective Project Management.
- Planned and conducted UAT (beta testing), UI conformance testing wif the BO and adjusters utilizing the help of the product manager.
- Utilized Informatica to Extract, Transform and Load (ETL) claims data for stage 2 of the project (Business Intelligence and reporting).
- Conducted interviews, JAD sessions wif the Business & Corporate team, Predictive analytics team to understand the reporting and integration functionalities of SAS (Predictive Modeling) and Tableau (Data Modeling, Visualization and BI) and created the FRD.
- Developed an understanding of ORM Framework during the second stage of the project.
- Created analytical models using Tableau and presented analytical data obtained from SAS to business owners helping them identify new opportunities.
- Logged and tracked the defects using HP Quality Center. Created an error repository and managed the testing process wif the QA team.
Environment: SQL, Informatica, SAS, HP Quality Center, ORM Framework, MS Visio, MS Access, MS Project, MS Excel, MS PowerPoint, MS Word, MS Outlook, SharePoint.
Confidential, Palo Alto, California
Sr. Business Analyst
Responsibilities:
- Elicited the requirements through shadowing the claims adjusters to understand the As-Is (Current State) process of Personal Lines PI claims handling.
- Conducted interviews wif the Business Owners (BO) to understand the To-Be (Future state) process.
- Conducted Gap Analysis to identify potential opportunities of improvement and recommended them to the BO.
- Analyzed the operational risks involved in standardizing the claims processing system through SWOT and Cost-Benefit Analysis.
- Created the data mapping document for the integration of claims database wif Guidewire.
- Created WBS using MS Project
- Conducted JAD sessions, interpersonal interviews wif SME (Guidewire), BO, Sr. Developers, Architects to further breakdown the requirements. Conducted Feasibility Analysis and Product backlog planning wif the Product Manager and PM team.
- Expressed the requirements through user stories, use cases, business rules, story boarding, future state mapping and process flow diagrams.
- Defined the UI wif inputs from the data architect and developers for the standardized claims system using HTML models and mockup screens.
- Created the Product backlog wif help of user stories collected through requirements gathering and gap analysis.
- Acted as a Scrum Master (leading a team of 15), creating sprint backlogs, organizing and conducting sprint planning meetings, daily scrum meetings.
- Utilized SharePoint 2013 as an administrator for document management, version control and creating team dashboards on the team site.
- Planned and conducted UAT (beta testing) wif the BO and adjusters utilizing the help of the product manager.
- Logged and tracked the defects using IBM Doors. Created an error repository and managed the testing process wif the QA team. Retraced documentation to check for requirement conformance.
- Created a Standard Work document based on Lean Management principals for the adjusters to use in the new claims processing system.
- Conducted interviews, JAD sessions wif the Business & Corporate team, Predictive analytics team to understand the reporting and integration functionalities of SAS (Predictive Modeling) and Tableau (Data Modeling, Visualization and BI) and created the FRD.
- Created Analytical tables using SAS and presented it to the business owners to identify new opportunities.
- Interacted wif the accounting department and external auditing agencies to understand and implement the integration of the payment modules wif financial reporting and also to implement the Procure2Pay system to integrate the procurement department (replacement items) wif the accounting department using SAS FICO (FI, CO & MM).
Environment: Guidewire Claim Center®, GScript, JavaScript, Eclipse, SQL, Informatica, SAS, Tableau Desktop 8.2, IBM Doors, Lean Standard Work, MS Visio, MS Access, MS Project, MS Excel, MS PowerPoint, MS Word, MS Outlook, SharePoint.
Confidential, Greensboro, North Carolina
Business Analyst
Responsibilities:
- Elicitation of requirements from business owners and employees situated in North Carolina via interviews and shadowing to gain an understanding of the as-is system and the to-be system.
- Shadowing the correspondents across the country to gain an understanding of the product from their perspective.
- Worked on Benchmarking and conducted GAP Analysis to identify potential opportunities of improved functionality and flexibility.
- Worked wif the Project Manager in defining the scope and requirements of the Project.
- Analyzed the scope and vision documents of the project to come up wif the Functional Specifications Document (FSD).
- Created use-cases and context diagrams by incorporating all the functional requirements from the BRD document.
- Created UML diagrams (Use-case & activity diagrams) and created information and process flow diagrams.
- Conducted JAD sessions wif SME, Sr. Architect and BO to understand the Functional, Non-Functional Data and GUI requirements of the project.
- Incorporated UI and UX requirements from FRD by creating GUI mock-ups using MS Visio.
- Implemented AGILE RUP methodology for the SDLC and identified workflows in the four phases of the RUP. Organized and reviewed Backlogs brought in by the stakeholders to be used in the project.
- Utilized MS Project to create Work Breakdown Structures (WBS), prioritize the tasks and to track the progress of the project.
- Coordinated wif the adjusters, the development team and Quality Analysts in the creation of test plans, User Acceptance Test (UAT) scripts and Requirements Traceability Matrix (RTM).
Environment: Agile RUP, MS Project, MS Word, MS Visio, MS PowerPoint, MS Excel, SharePoint, HTML4
Confidential
Business Systems Analyst
Responsibilities:
- Elicited requirements by identifying system users and conducting interviews.
- Conducted JAD sessions and interviews wif developers and SMEs for eliciting requirements
- Created the FRD, BRD and SRS artifacts after gathering input from business owners and other stakeholders.
- Performed GAP analysis, cost-benefit analysis and feasibility analysis wifin the triple constraints.
- Created visual flow and UML diagrams for use cases, user interface, process flow and information flow.
- Created mockups (static and dynamic prototypes) of webpages and GUI, visualized process flows, information flow using MS VISIO.
- Worked on the UI/UX design wif the Project Manager and development team for the money transfer functionality.
- Created the WBS using MS Project.
- Utilized RUP methodology to develop the web application to satisfy the warranted periodic functionality releases.
- Managed project documents and other deliverables on SharePoint.
- Managed scope and requirements throughout the project life cycle.
- Wrote test cases, test scripts and planned the user acceptance tests (UATs).
- Performed Functional, Integration, System and Regression testing.
Environment: RUP, JAD, MS Visio, MS PowerPoint, MS Excel, MS Word, MS Project, SharePoint.
Confidential
Jr. Business Analyst
Responsibilities:
- Elicited requirements by identifying SMEs and conducting interviews.
- Created the FRD, BRD and SRS artifacts after gathering input from business owners and other stakeholders.
- Performed GAP analysis, cost-benefit analysis and feasibility analysis wifin the triple constraints.
- Created visual flow and UML diagrams for use cases, user interface, process flow and information flow.
- Utilized Modified Waterfall methodology wif Agile Scrum for change request to undertake the development of the product.
- Updated the BRD wif updated information as Change Requests are approved by business owners.
- Managed project documents and other deliverables on SharePoint.
- Created mockups (static and dynamic prototypes) of webpages and GUI, visualized process flows, information flow using MS VISIO.
- Aided the development team in unit testing wifin the Dev environment.
- Employed Triage decision making in classifying the defects based on their priority and severity using HP Quality Center.
- Created SQL queries for extracting data as required by the PM and other business stakeholders.
Environment: Modified Waterfall, Agile Scrum, SQL, HP Quality Center, MS Visio, MS Access, MS Project, MS Excel, MS PowerPoint, MS Word, MS Outlook, SharePoint 2007.
Confidential
SQL Developer
Responsibilities:
- Trained in SQL queries and ETL tools such as Informatica and IBM Cognos.
- Developed databases for the banking operations and extracted information for data scientists while developing the credit card features for the bank.
- Constant contact wif Business Owners, Project Managers and development team, building database prototypes for several projects to validate system requirements.
- Conducted some unit testing for the development team wifin the sandbox environment.
- Provided data scientists and project managers wif progress reports and peer reviews.
- Utilized SharePoint for collaborating and communication to project managers and data scientists.
Environment: SQL, Informatica, IBM Cognos, SharePoint, MS PowerPoint, MS Outlook, MS Word, MS Excel.
