We provide IT Staff Augmentation Services!

Senior Business Analyst Resume

Somerset, NJ

SUMMARY

  • IT professional with 15 years of experience in Analysis, Design, Development, Unit/ System Testing, and Quality Assurance.
  • Experience in business requirements gathering, define and capture metadata for business rules, creating physical infrastructure, system analysis, design, development and user training associated with the ETL processes employing Unified Modeling Language (UML) and Rational Unified Process (RUP) methodology.
  • Experience in working with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
  • Experience in Software Analysis & Design, Gathering Functional and Business Requirements Specifications, User Interface Specifications, Technical Design, Test Cases and Test Plan.
  • Responsibilities over the years included those of a Sr. Business Analyst, Software Developer & Programmer /Analyst.
  • Experience in complex business analysis and system support across multiple platforms
  • Strong Knowledge of SDLC, UML, RUP, Waterfall, Agile/Scrum methodology and project life cycle.
  • Extensive experience in writing Use Case Specifications, Business Requirement Documents (BRDs), High Level Design Documents (HLDs), Low Level Design Documents (LLDs) and Requirements Traceability Matrices (RTMs).
  • Expertise in performing Gap Analysis, Feasibility Analysis, Impact Analysis, Risk Analysis, Risk Management Plans, Business Process System and Cost - Benefit Analysis.
  • Facilitated Joint Requirement Planning (JRP) sessions, Joint Application Design (JAD) sessions with Subject Matter Experts (SMEs), Business User Groups, Top Management Groups and Technical Groups.
  • Conducted change management across the entire consulting process from project conceptualization through project delivery, performing Software Development & Implementation Management in diverse business & technical environments, with demonstrated leadership ability and excellent visual, oral, and written communication skills.
  • Excellent knowledge of Project Life Cycle, with outstanding skills in project planning, workflow, execution, control and resource balancing as well as the ability to support multiple simultaneous short-term projects.
  • Good knowledge about Agile analysis includes estimation and prioritization of requirements, where software development becomes “real” for project stakeholders.
  • Excellent experience in developing and executing Test Approach Documents, test plans, test scenarios, test procedures, test cases, test data and test scripts according to Business and Design Specifications.
  • Primary areas of expertise are COBOL, VS-COBOLII, JCL, CICS, VSAM, DB2, UDB, Tera Data, Oracle, SQL Server, DATA STAGE, Informatica, MS Project, Excel, Word, Visio, PowerPoint, PVCS Tracker, Team Track, Test Director and Quality Center.
  • RDBMS experience in DB2, Teradata, Oracle, SQL Server and programming experience using PL/SQL, SQL
  • Extensive experience in Unit, System, and Integration Testing.
  • Test Director, PVCS Tracker and Quality Center tools are extensively used to track the defects.
  • Good Functional knowledge in Financial, Telecom and Insurance domains

TECHNICAL SKILLS

Hardware: IBM 360/370/308X, 3090, 4300, Personal Computers.

Operating Systems: OS/390, IBM 3090, MVS, Windows 95/NT 4.0/2000.

Databases/OLTP: DB2, Teradata, Oracle9i/8i SQL Server and CICS.

Software Development: TSO/SPF-ISPF, QMF, SPUFI, INFOMAN, VSAM, MQSERIES, VSS.

Languages: COBOL, JCL, JAVA, ASP, VB Script, SQL, C

Tools: IBM Rational Rose, Requisite Pro, MS Office suite/ Visio, INTERTEST, Expediter, Endevor, File-Aid, File mast, INSYNC, PRIDE, AHD, OPC, CHANGEMAN, BMC, TOAD, Teradata SQL Assistant,Team Track, Test Director, Quality Center and PVCS Tracker, Axture RP Pro 6.5 and soapUI 4.5.1

Methodologies: System Development Life Cycle (SDLC), Joint Application Design (JAD), Rational Unified Process (RUP), Unified Modeling Language (UML), Agile/ Scrum methodology, User Acceptance Test (UAT), Inmon and Kimball Concepts, Star Schema, Snow Flake Schema.

PROFESSIONAL EXPERIENCE

Confidential, Somerset NJ

Senior Business Analyst

Responsibilities:

  • Analyze current system and process gaps in context of functional requirements.
  • Participate in Joint Application Requirements (JAR) sessions with Business Users and Work Sessions with stakeholders, Call center/Customer Service, Marketing Communications, Design, HR, Community Outreach, Web/Social Team, Executive Team, and IT Team.
  • Document Analysis (Call Center Data, Brand Guidelines, etc.) and also requirements and current state processes
  • Interacted with third party applications like Western Union, ESRI/GIS, MDM, CCS, and Striata.
  • Understand the Confidential audience needs like My account, My bill, Alerts/Outages
  • Interacted with Western Union for the payment process, provided optimized solution for easy bill pay process for the Confidential customers.
  • Interacted with Water Metering Systems (MDM) / AMI advanced meter consumption data teams on how the current meter data is managed.
  • Working on how to provide the better and accurate water consumption data to the end customers.
  • Interacted with ESRI/GIS for the outage/water break management team to capture current state.
  • Created Functional requirements documents (FRD)
  • Analyzed Confidential ’s internal applications like CC&B Oracle System and Content Management System (CMS), and documented the current gaps.
  • Created Swim Lane diagrams using Micro Soft Visio for all the current state work flows
  • Created Use Case documents.
  • Participate in design reviews and identify potential mitigation strategies for technical risks.
  • Develop expert knowledge on business processes, rules, and regulations.
  • Own the project during its complete life-cycle from inception to production support.
  • Proficiency in SQL skills, excellent Analytical skills
  • Update project records using MS word, Excel, PowerPoint and Visio documents in SharePoint site.
  • Additional activities may include training of other staff, ensuring compliance with and assisting in the development of standards, policies and procedures, and possible oversight and coordination of other team members.
  • Tasks may include working with end users, applications development staff, system administrators, management, vendors, and staff from other organizations to ensure successful implementation and operation of application systems.

Environment: Agile, Microsoft Word, Excel, Visio, Power Point, SQL and Oracle 11g

Confidential, Colorado Springs CO

Senior Business Analyst

Responsibilities:

  • Analyze current system and process gaps in context of new business and functional requirements.
  • Analyze business and functional requirements provided from the business and partner with technology resources to translate into technical requirements (RDD).
  • Participate in design reviews and identify potential mitigation strategies for technical risks.
  • Develop expert knowledge on business processes, rules, and regulations.
  • Coordinate with end users to identify and support their testing needs include working with the DBA regarding test tables, access categories.
  • Worked with technical staff and involved in cost and time estimates
  • Coordinate with Topology Services and other provisioning systems (VI, BGW BAAIS and iVAPP etc.)
  • Coordinate with external systems like VI, ETMS, IMPACT, INMS, and OASIS...Etc.
  • Worked in different networks like Transmission, IP Public, IP Private, Power.
  • Own the project during its complete life-cycle from inception to production support.
  • Work on projects ranging from new network equipment to network topology, to automating user activities (trouble ticketing).
  • HP Quality Center 11.5 is used for requirements and defects tracking. soapUI 4.5.1 is used to communicate and test with other provisioning systems.
  • Develop web based screen mockups using Axure RP Pro 6.5.
  • SQuirreL SQL Client is being extensively used to communicate with Oracle 11g database.
  • Proficiency in SQL skills, excellent Analytical skills
  • Conducted User Acceptance Testing(UAT) meetings
  • Executing automated test cases using Selenium.
  • Generating metrics for the management and created architecture diagrams using Power Point.
  • Update project records using MS word, Excel, PowerPoint and Visio documents in SharePoint site.
  • Additional activities may include training of other staff, ensuring compliance with and assisting in the development of standards, policies and procedures, and possible oversight and coordination of other team members.
  • Tasks may include working with end users, applications development staff, system administrators, management, vendors, and staff from other organizations to ensure successful implementation and operation of application systems.

Environment: Agile, Microsoft Word, Excel, Visio, Power Point, Selenium, SQuirreL SQL Client, SQL, XML, soapUI 4.5.1, HP Quality Center 11.5, Oracle 11g and Axure RP Pro 6.5.

Confidential, Windsor CT

Senior Business Analyst (SBA)

Responsibilities:

  • Analyze current system and process gaps in context of new business and functional requirements.
  • Actively involved in high level estimates and scoping.
  • Ensure the project gains or acquires expert knowledge of business and technical processes for all projects impacting The W database.
  • Interact with the End users (Downstream Users) of the “The W” data.
  • Analyze business and functional requirements provided from the business and partner with technology resources to translate into technical requirements.
  • Worked closely with Business partners to define strategies for technical solutions, determine requirements, and develop functional designs based on the analysis of line of Business needs, objectives and existing systems infrastructure.
  • Facilitated Joint Requirement Planning (JRP) sessions with the stakeholders for functional requirement gathering.
  • Performed all roles of Joint Application Design sessions including JAD Lead.
  • Develop expert knowledge on business processes, rules, and regulations.
  • Provide expert knowledge on assigned application(s), functionality and associate/customer processes.
  • Created several Business Requirement Documentation (BRD), High Level Documentation (HLD) for Systems Conversion projects as well as for the Business As Usual (BAU) projects.
  • During the Countrywide and Merrill Lynch projects conversion interacted with many SOR applications like Loans, E-Comm., SPX, OLB, LOC, AML, WMI, Data Coalition and LCR..Etc and created separate BRDs for each application.
  • Develop Service Level Agreements (SLAs) and Control Plan documents.
  • Coordinated with Architects, Modelers to create Logical and Physical Models for the project.
  • Acquire and institutionalize business knowledge to team.
  • Define testing protocol for communications and status reporting.
  • Implement tracking solution and status reporting for all inbound SOR files during System Integration Testing (SIT), User Acceptance Testing (UAT) and Dress Rehearsal (DR) testing.
  • Coordinate integrated testing efforts for all Countrywide/Merrill Lynch transition projects impacting The W (Data Warehouse).
  • Prepared and distributed bulletin information through Information Resource Center (IRC).
  • Used SharePoint site for collecting requirements from stakeholders and also to monitor testing progress
  • Coordinate the loading of the integrated test environment for all Service Provider projects during the testing process.
  • Provided Training on Quality Center to the team and other teams.
  • Coordinate and define with the Testing Center of Excellence (TCoE), for use of Quality Center for loading test scripts, use of Quality Center for reporting of defects, and integration with the Testing PMO.
  • Coordinate the creation, delivery and approval of the Service Provider projects SIT, UAT and DR test scripts to the System Conversion Project.
  • Worked closely with developers and testers to ensure requirements and functional designs are translated accurately into working technical designs and that test plans and scripts serve customer needs.
  • Worked on data mapping using Data Lineage documents to map the source to Target tables
  • Document the interaction of data, functions and business processes for selected functionality.
  • Analyze the current business functions and plan for needs, problems, and improvements with the help of line of business knowledge. This study helps to define and evaluate different solutions and arrive at the optimal one.
  • Coordinate with downstream users (stakeholders) to identify and support their testing needs include working with the DBA regarding test tables, access categories, and release calendar testing dates.
  • Coordinated with downstream and upstream teams and conducted defect triage meetings.
  • Experience with PL/SQL in constructing user procedure/functions, triggers, tables and views
  • Strong experience in using SQL using SQL Assistant tool.
  • Resolution and tracking of all open issues, TAR’s and defects throughout the testing cycles.
  • Report project status on an as needed basis to EIM management.
  • Escalate risks and issues to management as appropriate.
  • Responsible for all test script execution and uploading test results to Quality Center.
  • Serving as an escalation point for all issues pertaining to stakeholders.

Environment: Teradata, Teradata SQL Assistant 12.0, SQL, Informatica, HP Quality Center 9.2, TSO/SPF-ISPF, COBOL, JCL, VSAM, CA7 and File-Aid, Microsoft Project, Word, Excel, PowerPoint, Visio, SharePoint.

Confidential, Helena MT

Business Analyst

Responsibilities:

  • Creating work plans for team initiatives both in sustaining IT project delivery and day to day support.
  • All activities are documenting in a consistent and complete manner utilizing appropriate estimating, planning, risk, issue, problem/change management, project priorities and resource availability.
  • Working with IT planners, functional managers, project managers, business consultants and their customers and team members to meet information systems needs.
  • Working closely with business groups, gathering technical requirements or understand enhancement requests and the affect on shared enterprise storage and mainframe-based platform infrastructure
  • Communicated and worked closely with business and developers to translate business requirements into technical requirements.
  • Conducted JRP sessions with stakeholders and also with the project team at various project phases.
  • Design, develop, install, implement, fine tune, maintain databases, database dictionaries monitor standards and procedures and integrate systems through database design and administration.
  • Participating in development and preparation of documentation for procedural, program and user documentation.
  • Interface with business customers on project specifications.
  • Create Business Requirement Document(BRD) and High Level Document(HLD)
  • Involved in development of Enrollment Broker Project.
  • Worked on several Change Requests to make the system stable.
  • Documenting and maintaining the project documents in the repository and also getting the signoff for the deliverables from the project team and stakeholders.
  • Working with stakeholders to ensure successful system implementation.
  • Providing guidance and assisting in training of less experienced staff.
  • Preparation of detailed specifications from which programs will be written using COBOL, JCL, DB2 and VSAM.
  • Continuously monitor progress in terms of the status of the plan and report to the senior management, and managing status meetings.
  • Maintaining state-of-the-art knowledge and compiles information into recommendations and analyses.

Environment: OS/390, IBM 3090, TSO/SPF-ISPF, COBOL, JCL, DB2, VSAM, Endevor, Expediter and File-Aid

Confidential, Charlotte NC

Business Analyst

Responsibilities:

  • Analyze the functional requirements.
  • Actively participating in all requirement meetings.
  • Strong knowledge of portfolio accounting, investment performance measurement, and operations of a money management.
  • Strong facilitation skills with ability to elicit requirements from various stakeholders across the organization.
  • Acted as a liaison when interacting with various business units and being cross functional.
  • Commenced general and detailed requirements, system design, employing a JAD/JAR sessions.
  • Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams.
  • Expertise in analyzing varies investment securities.
  • Extensive knowledge on fixed income securities, ETFs, Stocks, bonds, CDS..Etc.
  • Created Business Requirement Documents(BRDs) and High Level Documents(HLDs)
  • Direct experience utilizing investment management systems to design, develop, and deliver client reports.
  • Experience in a high volume client delivery environment.
  • Demonstrated problem solver with the ability to work individually or cross functionally to ensure internal and external client satisfaction.
  • Implemented SDLC which included Requirements, Specifications, Design, Analysis and Testing utilizing RUP methodology.
  • System skills including SQL, Excel, Access, and an understanding and aptitude for relational datasets, data warehouses.

Environment: IBM Rational Rose, Requisite Pro, MS Office suite/ Visio, OS/390, IBM 3090, TSO/SPF-ISPF, COBOL, JCL, VSAM, DB2, Teradata, MQSERIES, Endevor, Expediter, INSYNC, PVCS tracker and Ascential Data Stage.

Confidential, New York NY

Sr. Developer

Responsibilities:

  • Interacted with clients and getting the requirements from the clients
  • Involved in developing the programs in COBOL, VSAM and JCLs in the Fixed Income module.
  • Tested the developed code thoroughly and documented everything and maintained in LAN
  • Coordinated and given business knowledge to the offshore team
  • Involved extensively code reviews for the programs developed by the offshore team.
  • Significantly contributed in peer reviews test plans and test results which are developed by the offshore team.
  • Communicated with the Business Analysts about the business and the enhancements of the new projects.
  • Coordinated other teams to assist them in completing the projects in time.
  • Extracted the data from the backups and proving the same to the clients to build the statistics and take the decisions.
  • Used the File-Aid for data extraction from the back-up files.
  • Prepared weekly reports to be sent to the project lead.

Environment: OS/390, IBM 3090, TSO/SPF-ISPF, COBOL, JCL, VSAM DB2, Intertest and File-Aid

Confidential

Sr. Developer/QC Coordinator

Responsibilities:

  • Performed extensive analysis of Ingenix system for enhancements.
  • Extensively worked on modified claims processing system
  • Designed the enhancements of iCES clearing house application for modified claims processing.
  • Developed Technical Specification Documents for developing the new programs to create a new path for iCES clearing house module.
  • Developed Online/Batch programs using COBOL, JCL, VSAM and CICS.
  • Unit test has done for the developed programs.
  • Significantly contributed in peer reviews and external reviews of test plans and test results and reported the review comments in Global Delivery Dashboard (GDD).
  • Interacted with infrastructure team for creating the new test files and test regions.
  • Communicate with the client (Subject Matter Experts) about the business and iCES enhancements.
  • Prepared weekly reports to be sent to the project lead.
  • Conducted Knowledge Transfer(KT) sessions and shared the project knowledge with other teams
  • Acted as a Quality Co-coordinator (QC) for iCES Clearinghouse project.
  • Prepared checklists for design and development of the code.
  • Prepared an Induction plan document for the new team members.
  • Maintaining all the documents in VSS (Visual Source Safe).
  • Conducting internal Audits every fortnight.
  • Conducting Defect Prevention meetings every fortnight to reduce the defects.
  • Attending the QC meeting every fortnight.
  • Attending the SQA (Sr. Quality Assurance) Audits.
  • Taken responsibility to deliver Quality products.

Environment: OS/390, IBM 3090, TSO/SPF-ISPF, COBOL, JCL, DB2, VSAM, CICS, MQSERIES, VSS, GDD, Expeditor, Endevor, File-Aid and TEST DIRECTOR

Hire Now