Business Analyst/ Data Analyst Resume
Warren, NJ
SUMMARY:
- Over 7 years of working experience as a Senior Business Analyst, Technical writer, and Subject Matter Expert for various projects from conceptualization to implementation.
- Defined business requirements and successfully re - engineered business processes for various industries/sectors like Insurance, Healthcare, Finance and Banking.
- Excellent Business writing skills in writing Business requirements document, Use Case specifications, Functional Specifications, System Design Specification (SDS), System Requirement Specifications (SRS), Test cases, Test plans, GAP analysis, Traceability Matrix, Workflows and Unified Modeling Language (UML) such as Activity diagrams, Collaboration Diagrams, Class diagrams and Sequence diagrams.
- Successful experience in communication skills both written and orally. Implementation of strong decision-making skills. Extensively involved in all the phases of SDLC, requirement analysis and Graphical user interface (GUI) business specification, development, enhancement, quality assurance, testing methodologies and implementation.
- Experienced in client-interaction, project planning, scheduling, and coordination with development teams in various functional domains
- Defined various Business Rules at every stage of the project to help it be in line with the working of the organization.
- Authored business and system requirements analyses and functional specifications with supporting business process flows (data modeling), Traceability matrices, risk analyses and concept of operations for systems utilizing company standards, processes, and procedures.
- Conducted Joint application development (JAD) sessions with relevant Subject Matter Experts to assess and document current configuration.
- Strong experience of creating Use case documentation from business requirements and/or existing application.
- Interacted with large teams of testers and developers through excellent communication and interpersonal skills.
- Experienced in using different UML diagrams, sequence diagrams, activity diagrams and collaboration diagrams.
- Strong knowledge of all functional areas of business including, finance, accounting, marketing and IT.
- Developed excellent professional skills by working independently and as a team member to assist business in the process of translating the vision of the application to a business requirement document.
- Strong presentation skills and ability to tailor presentations towards different functional areas of business.
- Excellent knowledge in creating test cases for various stages of software testing.
- Functioned as a liaison between client and project team.
- Ability to prioritize and work under pressure in time sensitive settings.
- MBA degree with extensive experience in implementation of strategies in a team oriented environment utilizing analytical skills.
TECHNICAL SKILLS:
Rational Suite: RUP, UML, Rational Rose, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest
Packages: MS-word, MS-PowerPoint, MS-FrontPage, MS-Visio, MS-Project, MS-SharePoint
BPM: Metastorm BPM 7.6
RMT: Doors; Requisite Pro
Reporting Tools: Business Objects, Microstrategy, Cognos
ETL Tools: Informatica, DataStage
RDBMS: Oracle 10g/9i/8i, MS SQL Server 2000/2005, MS Access
Design: Erwin 4.0/3.5.2, Power designer, GUI.
Programming Languages: SQL, XML, HTML, Visual Basic 5.0/6.0
Operating Tools: Windows 2000/2003/XP, Sun Solaris (UNIX), HP UNIX, AIX, Linux, Mainframes
Other Tools: SQL Navigator, Enterprise Architect, TOAD, Test Director, Test Manager Mercury tools
PROFESSIONAL EXPERIENCE:
Confidential, Warren, NJ
Business Analyst/ Data Analyst
Responsibilities:
- Identified data fields for different data sources which would help execute the model.
- Responsible for creating sub data sets from internal and external data sources and identifying them into Fraud, Recovery and Others which would help in executing the scoring engine for each Model.
- Identified the Primary Keys / Primary elements needed to run the model.
- Documented data requirements based on fields available after mapping them to the source.
- Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
- Collected information about different entities and attributes identified primary keys and foreign keys for the entities. Mapped surrogate key tables to the required dimensions.
- Presented the models and their advantages to Stakeholders and the Project Manager and logical database design Liaised between business users and the development team in translations of requirements and business process explanations, resolving communication issues and differences.
- Used Requisite Pro to document, review and analyze the requirements.
- Created Business process flow charts using Visio.
Environment: Microsoft Visio, Microsoft Excel, Microsoft Word, Lotus Notes, Requisite Pro, Quality Center, SAS.
Confidential, Pennsylvania, PA
Business Analyst/Project Manager
Responsibilities:
- Documented business process flows; business requirements; data sources and attributes; dimensions, facts, metrics, filters, etc., Inventory Control Reporting
- Worked with data modeler to design table structure(s) for DW
- Worked with IT to populate table structure(s) and perform UAT of data
- Developed Micro Strategy report(s) and/or dashboard per documented business document
- Provided weekly status report of progress and hours worked
- Worked with SQL, Micro Strategy Platform - Web Professional v9.4.1, Query Building tool
- Knowledgeable in data discovery and data profiling
- Documented business reports and/or dashboards in Micro Strategy
- Prepared operational BI Reporting
- Presented dimensional models and BI concepts like attributes, facts, and metrics.
- Documented business process flows
- Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
- Collected information about different entities and attributes identified primary keys and foreign keys for the entities. Mapped surrogate key tables to the required dimensions.
Environment: Microsoft Project, Microsoft Visio, Microsoft Excel, Microsoft Word, Micro Strategy, Toad, SQL Developer, Quality Center.
Confidential
Business Analyst
Responsibilities:
- Studied the existing Corporate Information Factory (CIF) and the Operational Data Store (ODS) relating to the subject area of the Accounts Data Mart.
- Gathered Business Requirements from the users through use of questionnaires, Joint Application Development (JAD) sessions, one-on-one interviews/Group interviews, examination of current reports.
- Analyzed requirements in terms of the dimensional data elements and measurable facts.
- Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
- Collected information about different entities and attributes identified primary keys and foreign keys for the entities. Mapped surrogate key tables to the required dimensions.
- Involved with architects in designing dimensional model star schema involving Kimball methodology using Erwin.
- Prepared Gap analysis report outlining the deficiencies in source system extracts and requirements for the Operational Data Store (ODS).
- Presented the models and their advantages to Stakeholders and the Project Manager and logical database design.
- Knowledgeable in the ETL process used by the Data Stage System designers used for extracting data from heterogeneous source systems, transforming and loading the data into the data warehouse/ data marts.
- Liaised between business users and the development team in translations of requirements and business process explanations, resolving communication issues and differences.
- Provided user test cases and collated and track defects. Communicate defects to development team.
Environment: MS Project, MS Visio, MS Word, Informatica, Cognos, Oracle
Confidential, San Ramon, CA
Business Analyst/Fraud Detection and Prevention
Responsibilities:- Worked with Fraud Detection Team in reviewing and verifying potential fraudulent accounts for prevention and detection of Fraud.
- Responsible for taking necessary steps and verifying the potential fraudulent accounts.
- Authored Requirements document, Use Case Specifications, Systems Requirement Specification (SRS) along with the technical staff and developers.
- Lead all internal and external audits as well as implement and track action plans to mitigate identified risks
- Implemented and designed Key Risk Indicator Report, Dashboard Report, Scorecard Report and Service Level Agreements for Executive Management Team and vendors.
- Used Requisite Pro to document, review and analyze the requirements.
- Created Business process flow charts using Visio.
- Member of the Internet Team charged with mitigating risks surrounding the roll out of project.
- Identified areas of significant risk and process inefficiencies
- Worked as an Interface between the users and the different teams involved in the application development for the better understanding of the Business and IT processes.
- Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the implementation of Rational Unified Process effort in different iterations and phases of the SDLC.
Environment: MS Visio, Test Director, Clear Quest, UML, Rational Suite, MYSQL, MS Access.
Confidential, Bloomington, IL
Business Analyst
Responsibilities:
- Experience in Project management, heavily involved in Project and working with Project manager.
- Analyzed the Project Definition Document for multiple projects and identify the systems impacted, stakeholders and business features requested
- Requirement gathering and created user requirements, managing change control process, updating existing documentation.
- Provide AGILE project management controls, project plans, timeline schedules, facilitate RAD sessions, and review software defect.
- Responsible for providing business requirements within an AGILE software development SCRUM environment.
- Coached teams in their efforts to adopt advanced methods for the effective application of the Scrum framework
- Worked as a part of the Team to trouble shoot design queries gathered during Sprints providing clarity for development.
- Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules and information needs, and ensured the critical requirements were not missed.
- Co-ordinated work plan between project manager and client with Sprint Planning, Daily Standups and updating Product Backlog for the assigned Functional group.
Environment: MS Office, Java, Oracle, Visio, Rational Rose, Clear Quest
Confidential, Warren, NJ
Business Analyst
Responsibilities:
- Captured requirements for the Citidirect Banking Evolution (BE Rel 1.2) application which aims to introduce a new platform for existing Citidirect Classic customers and facilitate on-boarding of new customers for cash, trade, loans, treasury and investment products via an online platform, and provide a new Payment method.
- Participated in the inception of a firm-wide application for client on-boarding to ensure smooth coordination between different functional groups.
- Captured requirements for real-time workflows and task status information on client on-boarding process
- Captured entitlements for Treasury Management to centralize treasury activities for Clients to improve Working Capital Management through r eal time control over cash, investments and risk
- Captured requirements for Electronic Bank Account Management (eBAM) application that offers a web-based tool to Clients to submit electronic requests to modify their accounts and to manage their list of designated authorizers and operating signers
- Captured requirements for Confidential .net Intranet Portal that will help increase user flow to Confidential .net and enable the workforce to leverage the knowledge existing in the organization
- Liaised with business stakeholders during ideation phase, requirements analysis and high-level FRD review sessions to derive and execute action plans, meeting deadlines and standards
- Conducted workshops with business users to prepare and update Functional Requirements
- Coordinated with usability and technology team to identify System Requirements Specifications (SRS)
- Prioritized business and systems problems and conducted impact analysis
- Performed GAP analysis of business rules, business and system process flows, user administration, and requirements
- Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
- Worked with focus groups to prioritize business problems
- Conducted individual and group (JAD) sessions with business stakeholders, Client Delivery Team and Technical Units
- Captured integration requirements with Oracle Entitlements Server (OES)
- Documented Interface Contracts with TIBCO Provisioning Channel, Desgold Safeword and Digital Certificate Management Systems
- Ensured all artifacts complied with corporate SDLC Policies and guidelines
- Applied change requests and version control
- Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met
- Traced functional specifications to BRD and test cases to FRD using DOORS
- Updated System Change Request (SCR) forms for Product Registration/ Data Management (PDM)
- Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT)
Environment: / Tools - MS office, Rational Rose,J2EE, MS Visio, MS Excel, MS Word, MS PowerPoint, DOORS, Dot Net, Java, SOA, TIBCO, OES, SiteMinder, LDAP, Oracle
Confidential
Business Analyst/ Systems Analyst
Responsibilities:
- Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
- Built the Forms for application using various form modules and windows.
- Designed the data flow diagrams using VISIO.
- Involved in preparing Business test cases, test design, test Cases, and Strategies.
- Reviewed the test cases and bug reports.
- Executed System and data quality testing to ensure all development deliverables are production ready.
Environment: SQL, SQL Server 2008 R2, PL/SQL, XML, XSLT, Java and UNIX.