Lead Business Analyst Resume
Los Angles, CA
SUMMARY
- Around 7 years of experience as a Business/System Analyst and Quality analyst in various organizations.
- Experience across wide range of domains - Telecom, Mortgage, Financial, Biotech, Retail and e-commerce industries.
- Experience in full Software Development Life Cycle including requirement, analysis, design, development, and implementation.
- Experience in Agile, Scrum based business analysis and developing Vision, Software Requirements Specification, Risk Mitigation Plans, Software Development Plans, ERP Integrations and Web / Portal like the ECM (open text or WCM) Application Development.
- Experience in the area of CRM, Marketing, Sales, Audit processing and commission.
- Experience in implementing the Rational Unified Process (RUP) in all four phases of a project: Inception, Elaboration, Construction and Transition.
- Obtained knowledge and experience in software like FINACLE, Oracle FlEXCUBE and Power Banker.
- Proficient in creating UML diagrams such as Use Case Diagrams, Class Diagrams, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, State Diagrams, Deployment Diagrams and developed Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).
- Experienced in Data Mapping, GAP Analysis, Traceability Matrices, SWOT Analysis, and Cost Benefit Analysis.
- Experience in Functional, Usability, User Acceptance and User Interference, Integration Testing, including Developing and executing Test Plans and Test Cases in Manual test
- Experience with Basic SQL queries to retrieve and manage data in Database.
- Used iRise Studio to drag-and-drop interface, as easy to model the workflow and behavior of proposed business applications.
- Hands on experience and knowledge on Health care applications like Clinical Trails, SAS, Pharmacy Benefits Management (PBS) and others.
- Professional level skills in implementing and designing applications leveraging ADO.NET, LINQ to SQL, and the Microsoft Enterprise Library Data Access Application Block.
- Comfortable with managing and using both Microsoft Windows and Linux Systems (Windows Server 2003/2008, Ubuntu, Fedora, Red hat).
- Exceptionally organized with great ability to work on multiple projects simultaneously and ability to create synergies within the organization and with clients.
- Mentored teams on areas of subject expertise in various geographical locations.
- Excellent communication skills, leadership skills with management abilities and customer relationship.
TECHNICAL SKILLS
Business Modeling Tools: UML, MS Visioand Rational Rose
Software Methodologies: RUP, Waterfall, Agile, Scrum, Spiral
Operating System: Windows 95/98/2003/XP
Windows Applications: MS Office 2003 (Word, Excel MS PowerPoint), Adobe Illustrator
Project Management Tools: MS Project 2000
ERP: SAP R/3
PROFESSIONAL EXPERIENCE
Confidential, Los Angles, CA
Lead Business Analyst
Responsibilities:
- As a Business System Analyst for the iPacs (Image Process Automation and Content Services) team and Operational Data Store(ODS), responsible for defining the requirements and designing the process for any changes in the document management services and Data maintenance.
- Designed and initiated the notification process for Mortgage Loan Documents as expected by the line of business as part of the ipacs team.
- Analyzed data as part of different projects implemented in the ODS Application and maintained the Application changes.
- Participated in the identification, understanding, and documentation of System requirements, keeping in mind the need for the application based on the project scope and BRD designed.
- Elicited with business teams, technology teams and quality assurance members to gather, document and communicate system requirements effectively on the Document Integration Project.
- Conducted analysis of the different data and mapped the Applicable Data running complex SQl queries in various environments with management of multiple teams on the integration of the new process to rectify and evaluate, open and pending issues.
- Lead and participated in peer reviews and walk-through of the HLD (High Level Design), LLD (Low Level Design) and FSD (Functional Specification Document).
- Worked on the Data Dictionary (DD) for each individual project and used the HP Quality Centre to identify and maintain a clear and measurable development process that was deployable throughout the enterprise application.
- Worked on the systems of the backend to the application level of the metadata correlations to each level of support to be provided by the team.
- Created test scripts for all the test cases in PL/SQL and Configured the Data mapping between Oracle and SQL Server.
- Managed WBS, project sizing and resource allocation. Performed data analysis using SQL queries in TOAD and Wrote advanced SQL queries to test the database backend.
- Validated the business, user and functional requirements and segregated them into Use Cases, context diagrams and activity diagrams using Visio, thus defining the Data Process Models.
- Communicated the project status to the Project Sponsor and Senior Management on a regular basis using PowerPoint presentations and managed/disseminated the project updates for management review using MS Project.
Environment: MS Visio, MS Projects, Business Objects, UML Tools, HP Quality Center 9.2, SQL, Oracle 9i, AS400, HTML, XML
Confidential, Las Vegas, NV
Lead Business Analyst
Responsibilities:
- Lead the business requirements team, analyzed and planned the final Service Delivery space.
- Working in CRM (Customer Relation Management) Team / Information technology Group, Taking care of End-to-end technical responsibility for IT projects in support of the business aspects of merging company operations for SOB (Sales Ordering and Billing) and Involved in large System Integration projects with mergers.
- Working closely with the project manager in leading a team of engineers to deliver complex solutions including data center infrastructure, wireless networks, security compliance, Cisco Content Switch solutions and redundancy.
- Worked with teams tasked with implementing a new Commission and CRM application to replace the legacy system and involved in Migration and Cut over Strategy to be followed in converting data from the existing Legacy system to the new system inOracleApplications.
- Defined technical requirements that were used by the development, testing and client organizations including financial analysis.
- Understanding on the architecture overview to learn about the components for Cisco products.
- Compiled, tabulated and coded statistical reports using pivot tables to produce spreadsheets, graphs and databases. Participated in data modeling.
- Recommended Salesforce CRM for their Enterprise management services and conducted resource background.
- Reviewed time and cost estimates from development organizations, using Oracle ebusiness suit.
- Wrote Use Cases, Functional Specifications and Scenarios, Business processes, Work flow diagrams and process flows.
- Recommended Salesforce CRM for their Enterprise management services and conducted resource background.
- Worked in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis
- Analyzed on what type of reporting they need from COGNOS.
- Assist everyone in understanding how to maximize COGNOS and develop CUSTOMIZED applications on how to integrate their handheld systems.
- Used Requisite Pro to mitigate project risk by keeping track of requirements that may be affected by upstream or downstream changes of requirements.
- Worked closely with the Project Manager and used MS Project to schedule and track the project activities in Agile Methodologies.
Environment: Window XP Professional, Web based tools, Visio, Oracle, Outlook, PRISM, Cognos and MS Office Suite.
Confidential, Denver, CO
Business Analyst
Responsibilities:
- Worked in gathering data requirements from Sales and Financial organizations to understand the forecasting techniques and practices. Utilized SQL queries for Data Analysis and Data Modeling.
- Functioned as the primary liaison between the marketing team, operations, graphic design team and the technical areas throughout the project.
- Extracted data from different department to flat files and load the data to the target Oracle and SQL server database.
- Created test scripts for all the test cases in PL/SQL and Configured the Data mapping between Oracle and SQL Server.
- Managed WBS, project sizing and resource allocation. Performed data analysis using SQL queries in TOAD and Wrote advanced SQL queries to test the database backend.
- Captured the business requirements around sales and forecasting techniques and created Business Requirements and Functional Design Specification documents using Rational Requisite Pro.
- Conducted GAP analysis to document “AS IS” scenario to understand current forecasting techniques and practices to get an agreement from all users to come up with a proposal for the “TO BE” system
- Extensively involved in teams loading Oracle customer related information such as addresses, contacts, bill to, salesperson, tax code, commissions and accounting etc. in development as well as in production.
- Implemented Oracle Asset Tracking to enable item tracking, actual cost of acquisition, & depreciation upon deployment.
- Developed web contents and enhance the web sites by utilizing the languages like CSS, .NET, XHTML.
- Guided in developing business objects using ASP.Net for various modules.
- Facilitated multi-user usability tests are possible with a centralized server that captures multiple stakeholder feedback at the same time using iRISE.
- Developed test plans and test cases for UAT testing and also helped in data scrubbing in the test environments.
- Worked closely with the Project Manager and used MS Project to schedule and track the project activities in Agile Methodologies.
Environment: Requisite Pro, SQL, Rational Rose, Toad, Microsoft Project, Microsoft Visio, Oracle 9i, QTP, Load Runner. Cognos, .NET
Confidential, Birmingham, AL
Business Analyst
Responsibilities:
- Created documents that describe the functional requirements for each USD deposit product e.g. how the product is being used today within the context of the legacy core banking system e.g. opening an account, types of transactions, holds, special/exception processing, account amendments, fee reversals, notices,Financial advices, etc.
- Worked in identification, understanding and documentation of functional requirements, together with the product definitions, which would help draft project requirements and form the basis of QA and UAT testing which would define the scope..
- Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues.
- Configured complete product for use within Flexcube for each category of cash management product (excluding cash sweeping).
- Understanding requirement from Finnacle point of view and analyze the process with finnacle as Core Banking Software.
- Validated the business user functional requirements and segregated them into Use Cases, context diagrams and activity diagrams using Rational Rose
- Used their existing data investment to identify report and analyze cost of trade, staff performance, risk management, profitability and more in the financial organization.
- Prepared a detailed flowchart explaining the business flow for the legacy system and Oracle Accounts Receivables.
- Imported Data from existing sources and making the review process accurate and complete using iRISE Studio.
- Executed regression, functional, UAT testing on main application prototypes created by Flex, Ajax.
- Prepared a detailed flowchart explaining the business flow for the legacy system and Oracle Accounts Receivables related to the financial matters.
- Followed UML based methodology using Rational Rose for creating Business Cases and Use Case Models after assessing the status and scope of the project and implementing technology based solutions that will meet their strategic business processes needs.
- Conducted Brain-storming sessions and Joint Application Development sessions and documented the Concept Description Document (CDD).
- Communicated the project status to the Project Sponsor and Senior Management on a regular basis using PowerPoint presentations and managed the project updates for management review using MS Project.
Environment: MS Visio, MS Projects, Business Objects, UML Tools, Oracle 9i, Crystal Report, HTML, XML, Rational Rose
Confidential, CA
Business/Quality Analyst
Responsibilities:
- Worked in gathering data requirements from Sales and Financial teams to understand the forecasting techniques and practices. Utilized SQL queries for Data Analysis and Data Modeling.
- Functioned as the primary liaison between the marketing team, operations, graphic design team and the technical areas throughout the project.
- Worked in all phases of the testing done in Mercury like smoke testing of the builds, Functional, Database, User Acceptance, User Interference, Integration testing and Regression testing once the deployment is done in the production.
- Extracted data from different department to flat files and load the data to the target Oracle and SQL server database.
- Created test scripts for all the test cases in PL/SQL and Configured the Data mapping between Oracle and SQL Server.
- Managed WBS, project sizing and resource allocation. Performed data analysis using SQL queries in TOAD and Wrote advanced SQL queries to test the database backend.
- Captured the business requirements around sales and forecasting techniques and created Business Requirements and Functional Design Specification documents using Rational Requisite Pro.
- Worked in all phases of the testing done in Mercury like smoke testing of the builds, Functional, Database, User Acceptance, User Interference, Integration testing and Regression testing once the deployment is done in the production.
- Extensively involved in teams loading Oracle customer related information such as addresses, contacts, bill to, salesperson, tax code, commissions and accounting etc. in development as well as in production.
- Implemented Oracle Asset tracking to enable item tracking, actual cost of acquisition, & depreciation upon deployment.
- Conducted applicant interviews and Purchase to Order process and Tracked, Detected and Reported bugs using Test Director.
- Designed, scheduled and executed test plans within the predefined timeframe.
- Generated test scripts for Load and Performance testing to see how the system behaves under load using Load Runner.
- Facilitated multi-user usability tests are possible with a centralized server that captures multiple stakeholder feedback at the same time using iRISE.
- Developed test plans and test cases for UAT testing and also helped in data scrubbing in the test environments.
- Worked closely with the Project Manager and used MS Project to schedule and track the project activities in Agile Methodologies.
Environment: Requisite Pro, SQL, Rational Rose, Toad, Microsoft Project, Microsoft Visio, Oracle 9i, QTP, Load Runner, Cognos, Windows NT/98/2000, Win runner, Load Runner, Test Director.