Post Job Free

Resume

Sign in

Business Analyst

Location:
California City, CA
Posted:
August 15, 2017

Contact this candidate

Resume:

Pawanpreet

Ph. No. 440-***-****

Email ID: ac1ucj@r.postjobfree.com

SUMMARY:

Business Analyst with over 7 years of extensive experience in the field of Data/Project Management, Business process design, and object oriented analysis in various industry domains such as Retail and Energy sector and Banking services.

Hands on experience with data mapping and data profiling across multiple systems in various formats to meet the requirements.

Proficient in Technical and Business Writing, Business Process Flow, Business Process Modelling, Business Analysis and Testing various methodologies.

Hands on experience with projects for retail clients for data migration and very large scale integration between multiple systems.

In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).

Extensive experience in documenting existing process, preparing Business Capability Decomposition (BCD), analyzing Business Requirements, working with Requirements Traceability Matrix, re-engineering business processes and designing.

Hands on experience in business consulting, SQL analytics and application development with excellent skills in client interfacing, requirement gathering, gap analysis, Regression testing, functional testing, user support, user interface designing, quality assurance, problem solving, and documentation.

Extensive experience in facilitating JRP and JAD Sessions with Business User Community to the needs of both business side and the IT side.

Good Knowledge in ETL (Extraction, Transform, and Load) process for Datawarehouse tools INFORMATICA loading data in Oracle Database.

Extensive experience in identifying and documenting Business Requirement Documents (BRD), Use Cases, Functional Specifications, and Entity Relationship Diagrams (ERD), Use Case Diagrams, Activity Diagrams and Process Flow Diagrams using UML modeling tools such as MS Visio and Rational Rose.

Expertise in conducting Code review sessions and hosting Application walkthrough sessions for upper management.

For integration projects, prepare Data Mappings, Data Analysis, and Data Transformation documents for the development team to facilitate the development of interfaces.

Prepare the Integration diagrams that would show all the systems/layers being integrated and system as a whole.

Successfully implemented the RUP methodology throughout the organization hosting the training and working sessions and acting as a RUP Mentor for multiple projects.

Expertise in Peer review and reviewing the deliverables developed by junior business/data analysts.

Extensively experienced in Agile Software Development Process and Pair Programming. Worked in the latest implementation environments, J2EE and .Net with knowledge in the designing of SQL Server and Oracle databases.

Extensive experience in various testing strategies like Unit, System, Integration, User Acceptance Testing (UAT) and Manual testing (GUI Testing, Field Validation Testing, and Functionality Testing) of User Interface (UI) and Web Applications to ensure that the software meets the exact system business requirements and specifications and Performed Functionality based Testing.

Utilized a fusion of business knowledge, and strategic business analysis to provide insights, solutions and resolve issues for critical business and technical problems on different projects.

TECHNICAL SKILLS:

Operating Systems

Windows XP/Vista/7 Macintosh

Modeling Tools

Rational Rose, MS Visio, Mockup Screens, Wireframes

SDLC Methodologies

Waterfall, Agile-Scrum, Waterfall-Scrum, Waterfall-RUP

Business Skills

Change Management, Impact Analysis, JAD Sessions, SWOT analysis, Project Planning, Project Scheduling, and Project Budgeting.

Requirement Management

MS Office, JIRA, Confluence, HP ALM 11.5, Rational ClearQuest, Rally

Project Management Tools

MS Project, MS SharePoint Server

Testing Tools

HP QC v10.0, HP ALM V11.5, Load Runner

Financial tools

MS Excel functions and pivot tables, Financial Statement Analysis

Reporting tools

Tableau Desktop, MS Office Suite

Languages

HTML, XML, SQL, Java

Databases

MS SQL Server, MS Access, Oracle

PROFESSIONAL SUMMARY:

Target Corporation, Brooklyn Park, MN Jun2016-Till Date

Sr. Business Analyst

The project involved working a Business Analyst / Product Owner for implementation and enhancements of Service Now application and its form configurations. Project also involved any post production support for bugs / error related activities. Agile Methodology was followed.

Responsibilities:

Gathered Business requirements from Target for Change Management service during 1st Phase and later implement into other services like Incident Management, Configuration Management, and Service request Management, Problem Management and reporting.

Worked with third party vendors and Target Technical teams to understand the feasibility of Service Now tool at both ends and prepared Technical Specifications from BRD.

Facilitate project meetings deriving User requirements, creating use cases and user stories, and working as liaison between Business and Technical teams.

Establishing templates within QA Process for Test Plan, Testing Strategy, Traceability Matrix, Test creation, Test execution report, Defect report, Testing Closure report.

Coordinate with various IT/Business Teams as to when and how data refresh needed to be done to QA Env in order to be in Sync with the PROD Env in order to support UAT Testing

Provide several reports indicating status of various change process items and projects

Create monthly journal entries using Great Plains Dynamics to maintain accurate accounts.

Upgraded the Microsoft/Great Plains Enterprise software from version 9.0 to version 2013, and provided daily support, and maintenance for the application and related 3rd party applications (Starship, Quality Count, GP Agent, Willoware, Company Data Archive, Accellos, Rockton Software, Experlogix, Business Portal, Manufacturing, Field Service, Collections Management, Extender, Smartlist Builder, Smart View, Safepay Management Reporter, and Integration Manager),resulting in a more robust toolset for business usersCoordinate the presentations, capture meeting notes and concerns. Send Minutes of Meeting

Monitor the central mailbox, Service Now Changes and process requests and statuses

Populate the Implementation Management SharePoint Site

Facilitate implementation-related meetings and coordinate releases

Deliver implementation-related communication

Perform collision management for RFCs and non-change events

Maintain Offshore shift schedules, providing proactive & effective tools & notifications to enable rapid response to avoid Global issues

Publish Monitoring Team Monthly status on Implementation, Accomplishments, Challenges and Risks

Analyze Intake Requests from Optimization/Application teams

Establish clear roles & responsibilities for offshore team

Track & communicate progress against action plan

Create Readiness Template for Business Events or Technical Releases

Environment: Microsoft Word, MS Excel, MS Visio, Power Point, Share Point, Agile, Infrastructure, Change Management, Ecommerce- Front and backend applications, Java Script, XML

TD Bank, Jersey City, NJ Sep2014-May2016

Business Analyst

TD Bank, N.A., is a United States national bank chartered and supervised by the federal Office of the Comptroller of the Currency. TD Bank offers banking, insurance, brokerage, and investment banking services in Connecticut, Delaware, Florida, Maine, Maryland, Massachusetts, New Hampshire, New Jersey, New York, North Carolina, Pennsylvania, Rhode Island, South Carolina, Vermont, Virginia, and Washington, D.C.

Responsibilities:

Gathered user and business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface).

Stored and modified requirements in MS - Word and using Test Director.

Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.

Ability to manipulate and organize the requirements and defects by Traceability Matrix.

Gathered systems requirements, trained users, provided support, program and process definition, and management for the Great Plains

, Goldmine, and Vertex tax software applications, resulting in consistent and dependable business processes.

Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC.

Was involved in initial designing of Software Testing Artefacts - Test Strategy, Test Plan, Test Case, and Requirements Traceability Matrix.

Recommend system/process solution approaches to minimize risk and workflow impacts while capitalize strategic goals.

Calculate expenses using Great Plains and Microsoft Excel. Calculate fees using proposal pricing.

Create debit memos and credit memos using Great Plains to maintain accurate books.

Researched the various steps in the lifecycle and then constructed the system in a way that the high risk customers would be easily identified and monitored.

Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.

Scheduled meetings with developers, System Analysts (SA) and testers to collaborate resource allocation and project completion using MS Project.

Created Graphical representation of reports such as Bar charts, Pie charts etc as per the End user requirements using Business Objects and Crystal reports.

Assisted front-end development teams in integrating Crystal Reports in the .NET application using SDK.

Used Crystal Reports to design a complex, on the fly, report that displayed complete charts based on the parameters.

Created Mock-up forms in MS Access for better visualization and understanding of the software solution.

Experience in Test Summary reports and Traceability Matrix.

Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.

Performed data mapping of ITG's client database to the data warehouse for reporting.

Played a major role in Interface testing both functionally and manually.

Assisted the SA to document all custom and system modification.

Assigned problems to appropriate software development team for fixes.

Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.

Authored progress and completion reports, which were then submitted to project management on a weekly basis.

Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).

Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's Win Runner.

Suggested measures and recommendations to improve the current application performance.

Environment: J2EE technology, Test Director, Windows 2000 Advanced Server, microstrategy, SQL, UNIX / Oracle Platform, MS Visio, RUP 2002, Rational Requisite Pro

Liberty Mutual, Boston, MA Oct2013-Aug2014

Business Analyst

Liberty Mutual is an American diversified global insurer, and the second-largest property and casualty insurer in the United States. CI Sales application is an enterprise application that facilitates and allows Liberty Mutual’s customers to shop auto insurance policy online. This Application enables a flexible and highly dynamic approach to customers with varying level of auto insurance quotes which further allows them to make payments, sign documents electronically, download forms and account registration process.

Responsibilities:

Co-ordinated with development team and Research team providing day to day support on the project

Conducted sessions with stakeholders for gathering requirements and performed requirements analysis and risk analysis on the high level requirements

Prepared Business requirements Document for the project and documented in scope and out of scope functionality for the application

Assisted in Configuration Change Management and Change Request handling by tracking and maintaining requirements in the Traceability Matrix as per the request from Business and IT counterparts.

Create / modify test plans / cases in accordance with the requirements traceability matrix and execute the same and verify the results.

Prepared PowerPoint presentations to walkthrough the prototypes and wireframes created for the application

Used Rational Unified Process as the initial methodology for the project which was the organization standard

Implemented Scrum for two releases of the RAPS application to determine whether SCRUM is a better fit for the project

Prepared as-is workflow process to document the manual tasks being performed from the moment a research report is drafted through its approval

Developed to-be processes to show the workflow tasks and end user responsibilities through each status change of a research report

Estimated new requirements by conducting JAD sessions and created timelines for Change Requests incorporation into a sprint through implementation

Actively participated in Scrum events such as Daily Stand-up, IPM, Retrospective and Show & Tell meetings

Created user stories, reviewed with product owner, scrum master, and estimated user stories with the team

Developed acceptance criteria for user stories when operating under Scrum and performed functional and UAT on the application

Collaborated with Product Owner in defining expected results and review the test results with product owner and stake holders

Environment: Scrum methodology, Jira, Visio, Microsoft Office Word, MS Excel, PL/SQL, Gherkin

Independent Bank, Ionia, MI Jan2011-Sep2013

Business System Analyst

Independent Bank has its branch network in Michigan and deals in personal banking and mortgage financing. The Project included designing and developing the Treasuries Portfolio monitoring software and Loan servicing module for its assets portfolio. The Project included automating the amortization process and interfacing with other banks through SWIFT for updating the financial transactions involving Fixed Income and Securities Investments. The project was developed in compliance with risk analysis and reporting modules in accordance with Basel II and Sarbanes-Oxley norms. It also included analyzing the prepayment patterns, impact of Credit Risk and Market Risk through impact analysis study on the portfolio and building models that simulate different scenarios.

Responsibilities:

Obtaining a detailed knowledge of the business process being followed in the project environment.

Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.

Extracted the business requirements from the stakeholders keeping in mind their need for the application and documenting them using Rational Req Pro.

Captured requirements with the use of Bloomberg, Charles River trading system, and Compustat to analyze market data, and fundamental data.

Involved in put or call options that protects an investor from foreign-exchange risk for a future sale or purchase of a specified foreign-equity portfolio. Involved in put or call options that protects an investor from foreign-exchange risk for a future sale or purchase of a specified foreign-equity portfolio.

The Credit Risk Evaluator Project is an integrated customer - controlled platform for credit risk management. It is a powerful tool for measuring and monitoring and managing credit risk, thereby offering a broad range of analytical Capabilities and user control.

Created Test cases from scratch by using Business & Functional Requirement Specs, HLD and Wire Frames. Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk

Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.

Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.

Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements

Interacted with database developers for formulating the ER diagrams and data flow diagrams.

Undertook back end testing using SQL and wrote queries.

Effective communication made possible between the developers and the end-clients to guarantee that development efforts were within the scope of the project and the development was as expected.

Held regular JAD meetings with the system architects, developers, database developers, and quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand.

Carried out defect control and change control in Clear Quest.

Environment: Microsoft Office Suite, MS Visio, MS Project, Windows, Dreamweaver, SQL, PLSQL, XML, VB, ASP.Net, Crystal Reports, Adobe Photoshop, Mercury Test Director, Win Runner, Load Runner

Nationwide Insurance, Columbus, OH Nov2009 – Dec2010

Business Analyst

Nationwide is the sixth largest property and casualty insurer in the United States. Nationwide is a leading provider of personal and commercial property and casualty insurance and long-term retirement savings products. The project was involved in developing Right, a web based system for quoting, and maintaining and issuing auto and homeowner insurance policies.

Responsibilities:

• Developed the scope and vision documents that defined the primary goals, objectives and scope of the project.

• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.

• Developed the integrated development life cycle by integrating Rational Requisite Pro, Rational Quality Manager and Rational Requirements Composer (RRC) with Rational Team Concert

• Created screen-mockups using iRise to review the requirements and provide feedback on the screen design. Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.

• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment

• Prepared business requirements Documents (BRD) and got sign off to be used by the developers.

• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using Unified Modelling Language (UML), and with Rational Rose.

• Used the BPMN to GAP Analysis to bridge the gap between business processes.

• Created prototypes of the GUI environment using iRise to be used by the developers during the design phase.

• Document, analyse and define the user and system requirements and use Rational Requisite Pro to manage the requirements.

• Developed detail class diagrams and sequence diagrams using Rational Rose.

• Developed as-is and to-be business processes using BPMN standards.

• Identified and establish scope and parameters of requirements analysis in order to define impact, outcome criteria, and measure-taking actions through interface analysis, prototyping and JRP/JAD sessions with Focus group.

• Documented business requirements for system issues and enhancements using Rational Requisite Pro.

• Worked with the development team during the Design, Build and Test phase of system projects to clarify business requirements as required.

• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.

• Acted as a liaison to the Training team to facilitate them to deploy the training.

• Worked with the Policy and Procedure team as required to define new/updated policies and procedures.

• Provided post production support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans.

Environment: Rational Rose, Rational Requisite Pro, Rational Clear Quest, SharePoint, HTML, MS Project, MS Office, Macromedia Flash, M.S. Visio, M.S. Project, Dreamweaver, JAVA, SQL.

EDUCATION:

Associate’s degree in science, Butte college, California



Contact this candidate