Sr. Business System Analyst/project Manager Resume
East Palo Alto, CaliforniA
SUMMARY:
- An accomplished and result - oriented Project Manager, Business System Systems Analyst, Certified Scrum Master with 9+ years of experience in various domains such as Health Care, Finance, Insurance, Banking and Information Technology. Extensive experience in delivering and deploying large scale projects. Managed and coached several teams on agile framework to effectively release the projects. Analytical thinker, problem solver, quick learner with ability to adapt to new environments. Experienced in project management, consulting, strategic planning, business analysis, and new product development
- Project Management and Business Analyst experience in Health Care, Finance, Supply Chain(Lawson), and Banking sectors with a strong understanding of the business processes.
- Strong subject matter expertise in Portfolio Management, Data warehousing, Trading, Insurance, IT and Project Management.
- Extensive experience in communicating with Subject Matter Experts (SME’s), gathering requirements, analyzing Business Processes, documenting various artifacts and testing operations. Interacted and coordinated with technical and non-technical clients.
- An in-depth knowledge of various phases of Software Development Life Cycle (SDLC) and different development methodologies of such as Waterfall, Agile/Scrum, RUP and Hybrid Model. Excellent experience in writing User Stories and user manuals.
- Extensive experience in Requirements Gathering process using different elicitation techniques such as Client Interviewing, Workshops, job shadowing, survey/Questionnaire etc.
- Worked extensively on GAP analysis, Impact Analysis, Root-Cause Analysis, Cause & Effect Analysis, Cost-Benefit Analysis, Feasibility Analysis, ROI Analysis, Risk Analysis, Project Analysis and documentation.
- Generated portfolio analysis and P&L reports by performing risk analysis(Credit Risk, Market Risk and Inflation Risk) based on the client’s investment policies
- Involved in the formation and implementation of structured credit policy and related processes to manage and monitor credit card risks. Extensive knowledge in Credit card regulatory and compliance system.
- Experience in deriving at Functional and Non-Functional requirements of System by conducting Joint Application Development (JAD) sessions.
- Extensive experience in converting Business Requirements into System Requirement Specifications (SRS).
- Extensive experience in creating artifacts such as Business Requirement Documents (BRD), Functional Requirement Specification (FRS), Software Requirement Specification (SRS), Change Request Analysis, Requirements Traceability Matrix(RTM) and also in creating static and dynamic prototyping.
- Comprehensive knowledge of web services related concepts such as XML, WSDL, HTML, Ajax, SOA, API and web architecture. Comprehensive knowledge of business engines and XML schemas.
- Extensive knowledge in using Web Services for the projects. Acted as a source to find external Web Services to be consumed by the project.
- Actively contributed for SOA Orchestration and set up of Business Engine. Extensive knowledge in 3-tier and n-tier architecture.
- Experience in creating Use Case Diagrams, Sequence Diagrams, Activity Diagrams, Data-Flow Diagrams, Process Work-Flow Diagrams, Class Diagrams and other UML based diagrams using MS Visio, Rational Rose etc.
- Excellent knowledge of SQL Queries for Data Validation and Data Integration for timely reporting purposes.
- Excellent working knowledge of ETL tools such as Informatica and Tableau for retrieving, analyzing, transforming and reporting data to formulate useful information for business analysis purpose.
- Documented and created Test Plans, Test Scenarios, Test Objectives, Test Cases, Test Logs and Run Books. Knowledge in conducting User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.
- Experience in financial management: Financial Statements, Cash Flow Analysis, and Cost Analysis.
- Experience in Project Management in delivering success in all phases of diverse technology projects and know for high-quality deliverables that meet or exceed timeline and budgetary targets.
- Excellent communicator; leverage technical, business and financial acumen to communicate effectively with client executives and their respective teams.
- Business strategist; plan and manage multimillion-dollar projects aligning business goals with technology solutions to drive process improvements, competitive advantage and bottom-line gains.
TECHNICAL SKILLS:
Documentation Tools: MS Office, SharePoint
Databases: Microsoft SQL Server 2012/2008, MS Access, Oracle 9i/10g
Languages: C, C++, .NET Java, J2EE, SQL
ETL Tools: Informatica
BI Reporting tools: Crystal Reports, Tableau, XSL FO, IBM Cognos 10, SAP Business Objects.
Testing Tools: HP Quality Center (QC), HP ALM, JIRA, MS Test Manager 2013, Load Runner, Win Runner
Methodologies: Waterfall, Agile/Scrum/RUP.Modeling Tools: MS Visio, Rational Rose, Requisite Pro, Clear Case, Clear Quest &Mockup Screens.
Web Technologies: HTML, CSS, JavaScript, ASP.Net, C#, AJAX
Project Management Tools: MS Project Professional, JIRA, ServiceNow.
PROFESSIONAL EXPERIENCE:
Confidential, East Palo Alto, California
Sr. Business System Analyst/Project Manager
Responsibilities:
- Working with a client SME, gather requirements from the business for the following projects:
- Provider Data Management - MSOW and APOGEE by Morrisey
- In-House Volunteer Management application that is based in ASP.Net w/ C# and SQL 2012 for Guest Services
- Business Continuity in-house application
- Collect the business requirements and document them in a Business Requirements Document in Microsoft Word and Excel.
- Create SQL queries from scratch - this resource will need to know how to create and run the queries.
- Perform Gap Analysis and report definitions from the business users
- Pull data from the Provider Data Management System based on the definitions the business group defines for location, demographics, etc.
- Write Crystal Reports in v10 from scratch and maintain existing reports to report the findings
- Used SAP Business Intelligence to load data for Press Ganey application.
- Used SAP Web Intelligence to run weekly reports for ZOHO application.
- Promoted to project manager role to plan, schedule and execute all stages of enterprise software and hardware upgradation of KeyStroke POS machines and EMV complient devices at Stanford main hospitals gift shops. Assessed business implications for each project phase and monitored progress to meet deadlines, standards and cost targets.
- Successfully led a project in migrating all financial applications from Stanford acquired hospital to Stanford Standard environment. Drove impressive improvements across the business as a result of IT implementations
- Excelled in guiding the work of technical teams. Articulated project goals and scope, translated business needs into technical terms, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones.
- Created cost-benefit analyses and ROI assessments that were used as the basis for decision-making on proposed IT implementation projects.
- Resolved numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs
Environment: Windows 7, MS Office, SQL Server 2008/2012, PL/SQL, MS-Office, SAP Business Intelligence, SAP Web Intelligence, SAP Crystal Reports V10, MS-Project Management, MS-Visio.
Confidential, Oaks, Pennsylvania
Agile Project Manager/Product Owner
Responsibilities:
- Introduced Agile methodology and related tools in pilot phases (bottom-up adoption approach), and then scale them to meet the needs of the broader enterprise.
- Meet with the firm’s executive management to review the various agile practices and get them on board with the plan.
- Developed a road-map for process adoption and technology enablement featuring scrum, agile requirements, and Rally.
- Worked with business analyst to build enterprise wide system to support securities and their valuations, derivatives, money market instruments.
- Strong knowledge of Financial Statements, Cash Flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, Trade Capture Application, Risk Management, and Investment Accounting.
- Developed project plans, status reports, scorecards, performance metrics and monitoring, benchmarking, process mapping, change management, controls, issue logs, communication plans and to ensure flawless execution.
- Worked with the client to improve project management practices such as the development of an integrated, cross-team project plan, and the introduction of agile approaches within the client's standard software delivery model.
- Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
- Included an Agile player coach and a tools mentor.
- Tracking project dependencies outside of the project team’s control and escalating issues as necessary.
- Facilitating cross-group and cross-functional communications for issues resolution and updates.
- Providing Resource Management for projects including team and staff allocation to advance Scrum Implementation.
- Coached the development team in Self-organization and Cross-functionality.
- Collecting/Recording feedback from customers on achieving different milestones on the project.
- Helped managed customer expectations and keep them apprised of the progress.
- Used Tableau software to create functional diagrams and identify key areas for data analysis.
- Responsible for writing User Stories and acceptance criteria
- Prioritizing User Stories using MoSCoW and Kano methodology.
- Gained knowledge of Wealth Management, Asset Management, Service Level Agreements (SLAs) and Portfolio Diversification.
Environment: Agile Methodology, Rally, User Stories, Backlog Prioritization Techniques, Tableau, Web Service, .NET Framework.
Confidential, Richmond, Virginia
Sr. Business System Analyst/ Project Manager
Responsibilities:
- Involved in identifying the problem definition as part of continuous process improvement using define, measure, analyze and improve to support the business continuity of the organization
- Developed and prioritized key deliverables like the Project Management Plan, Schedule Baseline, Scope Baseline, RTM, WBS, and WBS dictionary
- Acted as a liaison between Business management and Data Warehouse management team.
- Extensively interacted with data analysts during the ETL operations in identifying the source files/databases and implementing the transformation logic for achieving data uniformity in operational data store (ODS).
- Facilitated JAD sessions with focus groups, requirements workshops, Interface analysis and prototyping to effectively understand the analytical reports needed by the internal clients.
- Coordinated with the DW architects and developers to identify appropriate dimensional modelling (identifying dimensions/facts/referential integrity), measures (additive/semi-additive/non additive) and sizing (in terms of number of columns, records per dimension and fact table).
- Gathered business requirements and understood the goal of data warehouse.
- Used Mockup screens to convey the look and feel of GUI screens for the end users to developers.
- Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements
- Successfully analyzed the functional/non-functional requirements of the data warehouse for generating BI reports and communicated the same to architects and developers.
- Involved in identifying and suggesting the different dimensions (slowly changing dimensions/rapidly changing dimensions) required for generating the reports and OLAP cubes to facilitate the multi-dimensional view of the data to generate slicing/dicing, roll-up/drill-down reports.
- Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
- Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
- Excellent experience in design and development of Data warehousing solutions and generation of OLAP reports.
- Coordinated with Project Manager to create WBS, manage schedules, deadlines, resources and the project tasks using MS Project.
- Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA Team in executing Test Plans, Test Scenarios and Test Cases.
- Produced risk registers, mitigation strategies and contingency plans, issue logs and presentations.
- Made Requirements Traceability Matrix (RTM) for tracing the test cases back to the requirements, ensuring requirements are met using HPQC.
- Updated Project documentation and was responsible for reporting project status/ progress to the management by performing Earned Value Analysis.
Environment: Agile Methodology, Clarity, MS Project, Requirements Traceability Matrix (RTM), HPQC, IBM Cognos, SQL, .NET Framework
Confidential, Columbus, Ohio
Sr. Business System Analyst
Responsibilities:
- Gathered business requirements and developed BRD & FSD
- Prepared project deliverables such as business workflow analysis, process analysis, user requirement documents (use cases and use case diagrams) and managed the requirements using Rational Requisite Pro.
- Followed Waterfall methodology and was extensively involved in each phase of SDLC
- Used UML methodology to prepare Use Cases from the gathered requirements and created diagrams using MS Visio.
- Involved in gathering the Data requirements, data analysis and defining the Data Mapping.
- Effectively implemented the change control processes and also update the impacted business process documentations.
- Conducted JAD sessions with various stakeholders and project team
- Used MS Project to manage schedules, deadlines, resources and the project tasks.
- Planned and implemented Test Plans, Test Scenarios and Test Cases.
- Independently prepared UAT test plans, test conditions, test cases and developed user manuals. Conducted UAT and maintained all log of defects in test director. Developed the schedules, documents and trained the users.
Environment: SQL, SQL Server, Oracle, Windows, MS Office, MS Visio, MS Project, GAP Analysis, Waterfall Methodology .
Confidential
Business Analyst
Responsibilities:
- Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans related to commercial lending
- Assisted with product evaluation, product customization and system integration. Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions
- Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML
- Supported testing, Test Cases in HP Quality Center that would test various Test scenarios
- Authored business requirements documents with the business users. Extracted, discussed, and refined business requirements from business users and team members.
- Involved in documentation during various phases of development life cycle.
- Coordinated activities between business unit and technical staff, developed new methods, policies, and procedures to meet the business needs, as well as acted as primary trainer in educating the business units, related to business applications. Performed UAT on business requirements, technical specifications and product knowledge.
Environment: Oracle, JAVA, MS Excel, MS Access, HP Quality Center, MS Visio, MS Project.
Confidential
Java Developer
Responsibilities:
- Involved in identifying the problem definition as part of continuous process improvement using define, measure, analyze and improve to support the business continuity of the organization
- Involved in analysis of business requirements and major enhancements, Unit Test Plan.
- Developed Web Application as per the business requirements using HTML and JAVA
- Developed oracle stored procedures, functions, triggers etc. Involved in client s and UAT at client side.
- Used Jdeveloper, Eclipse as developments IDE.
- Used tools like VSS and ClearCase for version maintenance.
- Defects fixing in Integration testing phase and System Testing phase.
- Fixed various issues and Change Request as part of production release.
- Involved in configuration of Oracle 10gR2 and Oracle 10gR3 application server for application deployment.
Environment: Java/J2EE, Struts 1.2, EJB 2.0, JSP, JMS, Oracle 10g AS, Oracle 9i DB
Confidential
Java Developer
Responsibilities:
- Involved in analysis, design and development of IBA application and developed specifications which include Use Cases, Class Diagrams, Sequence Diagrams and Activity Diagrams.
- Developed server side applications using Servlets and JDBC. Used Ant for building the application.
- Used JMS for communicating various clients and its components.
- Used JUnit for Testing. Involved into coding using core java technologies like inheritance, abstraction, etc.
- Deployed applications on JBoss server. Extensively configured the build files to different Environments
- Developed Session Beans which encapsulates the workflow logic
- Used Entity Beans to persist the data into database and also used Message Driven Beans MDB to notify the bean state.
- Developed EJB components for middle tier component implementation and business logic implementation.
- Used Struts the MVC framework for building web applications.
- Developed Web Application by using HTML, CSS and JavaScript.
- Developed SQL database scripts and written Stored Procedures and Triggers.
- Created User guide and application support document.
- Involved in regression testing, evaluating the response times, and resolving the connection pooling issues.
Environment: Core Java, JDK, Struts, JDBC, HTML, CSS, JavaScript, Servlets, SQL, JBoss, JUnit.
Confidential
.NET Developer
Responsibilities:
- Developed Web Application design based on n-tier Architecture and extensively involved in the Database design and Data Migration.
- Extensively involved in developing Data access components by using Microsoft application blocks.
- Worked on SQL Queries, Triggers, Backup and Restore Database, Defining roles, creating database users.
- Assigning Roles to users using SQL Server 2005.
- Created a Setup Package (.msi), compiled application in debug and release mode by Using Visual Studio. NET 2005.
- Participated in full software development lifecycle.Prepared project plan using Microsoft Project.
- Responsible for configuration management (Configuring the Project in VSS, Taking VSS backup etc.).
- Done unit testing, integration testing and regression testing.Testing of database, queries optimization and performance
