Senior Business Analyst Resume
New, YorK
PROFESSIONAL SUMMARY
- Over 7 years of experience in gathering business requirements, defining business process flow, system analysis, business process modeling and analysis.
- Experienced in conducting Joint Application Development (JAD) sessions, project meetings, reviews, walkthroughs, and customer interviews.
- Promoted implementation of ITIL based non-functional Service Design requirements within Agile development.
- Experience in Data Modeling, Data Warehouse on Inmon and Kimball principles, Enterprise Architecting and design flows with use of Sparx Systems Enterprise Architect, XML and UML, Erwin, ETL, Reporting, etc.
- Expertise in writing Business Requirements Document (BRD), Functional Specification Document (FSD), Non-Functional Specification Document, System Design Specification, Use Cases, and training manuals.
- Created complex Ad-hoc reports, Dashboard Reports, KPI’s, Business views containing charts showing U-Verse sales, products, posted installs, in-service customers, disconnects, revenue by regions, market areas & divisional managers using Toad, ERwin data modeler, Business Objects, Visual Studio, SSRS, VBA, SalesForce.com Dashboards, Reports and SQL.
- Involved in the process of Use Case creation for Payment Credit Card (PCI Compliance)
- Successful work experience working for large systems at Goldman Sachs, Citigroup, Airlines Reporting, Fannie Mae and HSBC.
- Worked in Credit Card Services on RISK team for Payment/Authorizations Business Application CL TCR177 release
- Good experience of working with the QA methodologies and processes.
- Played a key role in centralizing customer support using Service Desk model, establishing procedures for functional and hierarchical escalations and architecting ITIL incident management L1-L2-L3 model.
- Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
- Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
- Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
- Excellent skills in Requirement gathering, System analysis, Furnishing Business Requirements and Functional Requirements.
- Familiar with business requirements documents (BRD), defining project plans, writing system requirements specifications, and delivering project/status reports.
- Excellent Analysis, technical Writing, Documentation, oral communication skills with a results-oriented attitude. Flair in easy presentation of complex concepts.
- Possess reasonable understanding of different relational databases, writing simple SQL queries, creating tables, and generating reports.
- Proactive team player with demonstrated problem solving and analytical reasoning abilities.
- Familiar with MS Project to manage schedules, deadlines, resources, collaborate with different teams, and analyze project information.
- Lead and worked with teams, during the coursework, to examine and solve business problems by accurately analyzing the needs and improve quality.
- Excellent leadership qualities.
- Creative and Enthusiastic with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.
TECHNICAL SKILLS
Project Management Tools: Microsoft Office tools namely Project (WBS, PERT, Gantt charts), Visio, Access, Excel, Outlook, PowerPoint.
SDLC/Design Methodologies: Unified Modeling Language (UML), RUP, Agile, RAD and
Waterfall.
Requirements/Document Tools: Rational Requisite-Pro, Rational Clear Quest and MS
SharePoint.
Modeling and Design Tools: Rational Rose, Microsoft Visio.
Testing Tools: Mercury Win Runner, Load Runner, Quality Center and Quick
Test Pro (QTP).
Languages: Visual Basic, C++, Java/J2EE, VB.Net, ASP.Net, C#, PHP.
Scripting Languages: HTML, XHTML, DHTML, and JavaScript.
Databases: SQL Server, MYSQL, PL/SQL, Oracle9i/10g, Access.
Hardware skills: Basic Hardware Knowledge of Computer System.
Operating System: Microsoft Windows95/98/NT/2000/XP/Vista/Windows7 and Mac
OS X
EXPERIENCE
Confidential, New York, NY May’ 11 Present Role: Senior Business Analyst
UDAP Project
Worked for multiple initiatives for new systems and process improvements. I worked on upgrade of trade management system to ensure timely availability of trading information for the system users including brokers and institutional clients. It includes upgrade of legacy system and development of intranet based trading system.
Responsibilities:
- Examined Order Management System (OMS) to ensure compliances with upgrade requirements, and generated documents for the workflow of exiting system and desired system that involve Cash Analysis, Portfolio Analysis, and performed gap analysis.
- Worked on requirements gathering, Internal and External Client reporting, testing and quality assurance for Prime Brokerage applications for trading fixed income, equities, Options, REPO, ABS, CDS and MBS products etc.
- ITIL Problem Management - Managed and coordinated all activities necessary to detect, analyze and initiate resolution of problems using Root Cause Analysis (RCA) methodologies
- Assisted Project Manager in maintaining and monitoring project progress and status using MS Project, providing high level estimates of efforts for analysis, implementation and estimating delivery schedule and resource allocation.
- Collaborated with project manager to define project scope, risks and determined appropriate methodologies and developed project time lines for on time delivery based on SDLC methodology.
- Used ERWIN column property editor to create and named physical properties, ERWIN index editor to create, named, sort and cluster[for performance tuning] for physical design, ERWIN physical object editor and table property editor to create named physical objects for physical design.
- Identified and documented business needs and created detailed Use Cases using UML, and collaborated with production team to identify system gaps and developed functional requirements documentation (FRD).
- Involved in Prime Brokerage Technology quality assurance analysis and testing and supported UAT.
- Prime Brokerage application Excalibur is a trade entry and trade management application and it services hedge fund clients.
- Facilitated discussions involving key stakeholders from both business side and IT side to elicit high level requirements and estimate project feasibility, designed and conducted survey among different end users including institutional users, brokers to collect detailed requirements, and documented them.
- Maintained Traceability Matrix for the current business processes and proposed changes.
- Wrote SQL Queries extensively against different databases generated different reports and analyzed them as per the company requirement.
- Mediated users and stakeholders conflicts on requirements through JAD sessions
- Derived functional specifications using UML models including user case diagram, activity diagram, and sequence diagram, and collaborated with software architects and developers to ensure that the applications conform to the requirements and helped to understand the business flow.
- Participated in design, planning and implementation of ITIL based Event and Incident management process.
- Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages, and managed changes requests; controlled, tracked and monitored change requests using Rational ClearQuest to enable successful interactive development
- Developed test plans with QA team and helped to develop test scenarios for system testing and performance testing.
- Conducted UAT, documented and reported user feedbacks to management team, and developed training materials for different end users and assisted in User Training for the new system.
Environment: SDLC, Rational Tools Suite (Rose, RequisitePro, ClearQuest, ClearCase), Erwin, MS Access, UML, SQL, MS Project, MS Office and crystal report.
Confidential, FL Oct’ 10 Apr’ 11 Role: Senior Business Analyst
UDAP Project
Worked on UDAP - (Unfair or Deceptive Acts or Practices) Balance Transfer Strategy.
This project was about the change in Regulations (Reg Z) to improve the effectiveness of the disclosures consumers receive in connection with credit card accounts. Worked simultaneously on Payment Tag, Pay Pass (Contact less payment mode) & E-Statement application
Responsibilities:
- Participated in the Project Definition Kickoff.
- Analyzed the Technology Project Request and Interviewed the Project Sponsor.
- Served as the liaison between the lines of business and the Development team.
- Worked directly with the business to ensure requirements and goals are correctly understood during the Analysis phase.
- Used ERWIN synchronization dialog to sync physical object information with the target environment.
- Used ERWIN entity note/query/sample editor to input general notes about the entity, sample queries involving the entity, sample data instances For the entity
- Worked directly with the development team to ensure system enhancements are correctly transitioned to the Build phase.
- Created documentation (Functional Specifications) for the Development team to code functionality into customer support applications.
- Created Business Requirements Document.
- Created additional documentation to communicate planned system functionality and implementation processes to the business and development teams consists of the following: Use Cases & Process Flows.
- Created Use Cases for Payment Tag / Pay Pass.
- Conducted impact assessments to understand business and application implications to requests being considered.
- Created Features List from the Technology Project Request.
- Created Traceability Matrix by mapping the Features captured with Technology Project Request reference and BRD reference.
- Analyzed and Gathered Business Rules for the Online Balance Transfer project.
- Worked hip to hip with User Interface Leads, assisting them with building wireframes.
- Coordinated with the Legal, Copy Writers, Content Management and Spanish Translators.
- Worked with off -shore developers through conference calls.
Environment: Domino, Erwin, Excel, Windows XP, Microsoft Share point.
Confidential, New York, NY Jul’ 09 Sept’ 10
Role: Business Analyst
(Trade Management System)
Workedfor multiple initiatives for new systems and process improvements. I worked on upgrade of trade management systemto ensure timely availability of trading information for the system users including brokers and institutional clients. It includes upgrade of legacy system and development of intranet basedtrading system.
Responsibilities:
- Examined Order Management System (OMS) to ensure compliances with upgrade requirements, and generated documents for the workflow of exiting system and desired system that involveCash Analysis, Portfolio Analysis, andperformedgap analysis.
- Worked on requirements gathering, Internal and External Client reporting, testing and quality assurance for Prime Brokerage applications for trading fixedincome, equities, Options, REPO, ABS, CDS and MBS products etc.
- Assisted Project Managerin maintaining andmonitoring project progress and status usingMS Project,providing high level estimates of efforts for analysis, implementation and estimating delivery schedule and resource allocation.
- Collaborated with project manager to define projectscope,risksand determined appropriate methodologies and developed project time lines for on time delivery based onSDLCmethodology.
- Identified and documentedbusinessneeds andcreated detailedUse CasesusingUML, and collaborated with production team to identify system gaps and developedfunctional requirements documentation (FRD).
- Involved in Prime Brokerage Technology quality assurance analysisand testing and supported UAT.
- Prime Brokerage applicationExcaliburis a trade entry and trade management application and it services hedge fund clients.
- Facilitated discussions involving key stakeholders from bothbusinessside and IT side to elicithigh level requirementsand estimate projectfeasibility, designed and conductedsurveyamong different end users including institutional users, brokers to collect detailed requirements, and documentedthem.
- MaintainedTraceability Matrixfor the currentbusinessprocesses and proposed changes.
- Wrote SQL Queries extensively against different databases generated different reports and analyzed them as per the company requirement.
- Mediated users and stakeholders conflicts on requirementsthrough JAD sessions
- Derived functional specifications using UML models including user case diagram,activity diagram, andsequence diagram, and collaborated with software architects and developers to ensure that the applications conform to the requirements and helped to understand thebusinessflow.
- Establishedtraceability matrixusingRational Requisite Proto trace completeness of requirements in different SDLC stages, and managed changes requests; controlled, tracked and monitoredchange requests using Rational ClearQuestto enable successful interactive development
- Developed test plans with QA team and helped to developtest scenariosforsystem testing and performance testing.
- Conducted UAT, documented and reported user feedbacks to management team, and developed training materials for different end users and assisted inUser Trainingfor the new system.
Environment: SDLC, Rational Tools Suite (Rose, RequisitePro, ClearQuest, ClearCase), MS Access, UML, SQL, MS Project, MS Office and crystal report.
Confidential, Washington DC Mar’ 08 Jun’ 09
Role: Business Analyst
Project Summary
Fannie Mae’s online registration system was too intrusive, resource intensive and not flexible enough. Furthermore, some large wholesalers needed transition of tens of thousands of brokers, and register thousands more. The system would be time and cost-prohibitive for both the business partners and Fannie Mae. Hence, the business partners had requested the ability to submit broker registration data electronically and the existing system be reengineered to automate the setup process.
Responsibilities:
- Managed the requirements of the business users.
- Gathered business requirements through JRP and JAD sessions, one on one interviews of brokers and traders, surveys, controlled brainstorming sessions, prototyping.
- Facilitated meetings with clients, brokers and a group of business partners to identify the needs and requirements of the new system, prioritized and organized these requirements in a systematic fashion, evaluated and compared potential solutions.
- Performed Gap analysis and was involved in analysis of the technical specifications of the current system and the infrastructure needs.
- Assisted in finalizing and documenting the new business processes to be followed by various verticals.
- Gained proficiency in formulating effective service delivery processes for the line of business.
- Synthesized User Interface and Business Process Requirements and translated it into the Business Requirement Document (BRD), to be used as input to the functional design specifications.
- Worked with project teams in preparing Software requirement specifications (SRS), software design documents (SDD), user interface design.
- Defined and organized the system requirements to Narrative Use Cases and Use Case Scenarios using the UML methodologies. Created Use Case Diagrams, Activity Diagrams, Flow Diagrams in MS Visio and created Wire frame Diagrams.
- Developed supporting documentation including business and technical requirements.
- Collaborated with development teams to come up with working business solutions.
- Involved in drafting functional specifications, user and operations manuals.
- Participated in Functional Audit and User Acceptance testing.
- Carried out UAT by developing test plans, test scenarios, test cases, test data to be used in testing based on business and user requirements.
- Wrote SQL Queries, Functions and Triggers to validate all possible business rules.
- Imparted training to the end business users on the new enhancements/application.
- Supported the change management process by way of formal and informal presentations.
Environment: Windows 2000/XP, Unix, MS Office, MS Visio, MS Project, VC++, SQL, Oracle, HTML, JAVA, J2EE, Load Runner
Confidential,Arlington, VA Jun’06 Feb’08
Role: Sr Business Systems Analyst
(E-Commerce - Payment application)
ARC is a technology solutions company providing transaction settlement and data information services. Airlines, travel agencies, corporate travel departments, railroads, and other travel suppliers’ process more than $80 billion annually through ARC\'s world-class settlement system - making it the financial backbone of travel distribution.
The payment application was implemented into a secure network environment by the following standards:
- Ensures transmission of data meets PCI / ARC Data Security Standards.
- Ensures storing of data meets PCI / ARC Data Security Standards.
- Encrypt the Credit Card transmissions and application passwords.
- Encrypt all non-console administrative access.
- Masks credit card PAN.
- Card holder data must never be stored on a server connected to the Internet
- Log application activity
Responsibilities:
- Acted as a Liaison between the Business and Technical team.
- Conducted analysis while gathering requirements from the Legacy system to Web Application.
- Created Business Requirements Document.
- Created Functional Document based on Business Requirements Document.
- Determined business processes and system requirements by conducting meetings with key subject matter experts.
- Designed business processes using UML diagrams. Thoroughly analyzed the business processes and created Use cases.
- Gathered Information for Forms Catalog for the E-commerce project.
- Created UML diagrams using Visio. Converted functional specifications into process flows using MS Visio and converted them into use cases
Use Case creation for:
- Payment Credit Card (PCI Compliance)
- Company Information
- Customer Information
- Admin Tools
- Resolved ambiguous and incomplete requirements issues, kept an eye on the long term goals of project completion and searched outkey contributorsto clarify confusion and work for understanding consensus to complete requirements issues.
- Effectively translated high-level business requirements into detailed functional Specifications and made changes to the specifications accordingly.
- Ensured project deadlines were met by IT resources.
- Coordinated with the Technology team to provide a solution as per the Business Needs.
- Used SharePoint to share information, schedule meetings, and organize files, create/modify/delete use cases and to coordinate with stakeholders.
- Followed the RUP methodology for the entire SDLC
- Involved in creating and updating functional specifications to document existing functionality of the application.
- Worked with the project managers by contributing effective solutions.
- Performed business and system level analysis, and provided documentation for deliverables.
- Conducted JAD sessions with Stakeholders, SME’s, and User Interface Leads, QA analysts to discuss issues and to resolve them.
- Provided suggestions to User Interface Leads on converting the use cases into Wire frames.
Environment: RUP, MS Visio, SharePoint, Excel, Windows XP, Microsoft Share point, J2EE.
EDUCATION
- Bachelor of Engineering in Computer Science
