Summary:

• Around 8 years of professional experience in requirements gathering, analyzing and writing system functional specifications including use cases.
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
• Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
• Well versed with SDLC software development life cycle . Experience in dealing with different data sources ranging from Flat files, Oracle, Sybase, SQL Server, Teradata, MS Access and Excel.
• Extremely proficient in using Agile and XP methodologies, performed roles of Scrum Master following sprint sessions and wrote User Stories, assigned tasks to individual team members
• Deep understanding of Enterprise Data Warehouses.
• Experience in facilitating Joint Requirement Planning JRP sessions with Business User Groups, conducting Joint Application Development JAD sessions with IT Groups and Conflict Management with Project team members.
• Ability to model business processes BPM in enterprise level projects using industry standard case tools.
• Expertise in UML class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, cross functional diagrams and collaboration diagrams as a business analysis methodology for application functionality designs using IBM's Rational Rose.
• Experienced as Business Analysis roles within market risk, collateral, trading, compliance, asset management, operations, compliance, legal, treasury and reporting, accounting.
• Extensive experiences in Investment Banking projects, specialized in Securities Trading stock trading, fixed income trading, and derivatives trading , wealth management and risk management.
• Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
• Excellent understanding of EFT system such as ACH, Fed Wire, BACS, CHIPS, FIX, SMAC, Automated Cash management and Prime Brokerage . Knowledge of Online Banking and the whole Fund Transfer process.
• Advised management on improvement strategies, competitive profitability Analysis.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
• Strong experience in RUP Business Modeling process.
• Conducted Code testing Unit testing, Module testing, Integration testing and UAT
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

Technical Skills:

• Software/Hardware: TOAD, MS Office, MS Visio , SaaS, Salesforce, Siebel, SAP, Google Aps, ServiceNow, UNIX, Linux, Solaris, Windows, Windows CE, Mac OS X, Mac iOS, HP-UX, Google Analytics, WebTrends,
• Documentum, SharePoint, Jira, Livelink, FrameMaker, MediaWiki, WebWorks, CS3, HTML, XML, TeamSite, Flash, Fireworks,Dreamweaver, JavaScript, HTML Help, JavaHelp, Safari, Access, NAS, UML, RUP, ERwin, Eclipse, PeopleSoft, SAP, WebLogic, Oracle, SQL, MySQL, JBuilder, Together, Photoshop, Illustrator, Paint Shop Pro, InDesign, Avaya, SurveyMonkey, Loadrunner, Captivate, NetMeeting, Caliber RM, Trackwise, Nagios, Bugzilla

Employment History:

Confidential

Sr. Business System Analyst

The project was built to reconcile the incoming and outgoing cash transactions for overall Money Flow. The system was build to track the modes of payments and then reconcile the accounts receivable with the total net flow of incoming money. Accounts payable were reconciled with disbursements and other payments so that the net flow of outgoing money equals all disbursements. The system was built to reconcile the total activities related to Commercial Lending, Loan Operations, Collections and Banking Operations for the money flow. Cash settlement system was used for reconciliation. Enhanced the Cash Conversion Cycle, and Asset Conversion Loan system.

Responsibilities

• Experience from Front to back office, worked with fund managers, financial advisors and technical team members.
• Developed a Financial Systems Datamart and a Customer Information System CIS Datamart as components of the data warehouse.
• Extensively performed data modeling.
• Responsible for Tuning and Optimization for the AML and Project management department.
• Analyzed and studied Credit Card process and regulations to be complied for card services in detail.
• Worked on integrating the credit card processing system with the new strategic exposure calculation engine to generate credit risk metrics.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Object-oriented Design OOD using Rational Rose according to the UML methodology.
• Played major role in writing lower level and upper level Use case.
• Review, maintain, update and disseminate AML / Compliance Policies Procedures.
• Create and maintain data model/architecture standards, including master data management MDM .s
• Responsible for the valuation and development of credit card products.
• Wrote SQL statements to extract data from the Tables.
• Actively participate in system test as the data governance SME for multiple implementations.
• Develop, coordinate and oversee BSA Risk Compliance and related initiatives to meet regulatory guidelines and related Board and operational policies procedures.
• Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
• Defined web service interfaces using WSDL and XML schemas.
• Worked deeply into laws and regulations related to BSA /AML, OFAC, and FCPA and the ability to apply this knowledge in gathering and reviewing the documentation requests.
• Administer training to external end-users on Data Governance procedures and master data functionality.
• Maintained awareness of regulatory changes in the BSA/AML arena which may affect assigned business lines and ensure appropriate communication and development of appropriate policy/procedure s changes to remain in compliance.
• Entity Master support for Data Governance, Regulatory Compliance for Client Data, Dodd-Frank.
• Oversee the management of the data governance KPIs and quarterly reporting.
• In-depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Made the changes the Policy Administration system to report to FRAUD AML system whenever any fraud is encountered.
• Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data transaction information related to Capital Markets - Online Brokerage, IVR trading, Conventional Brokerage, Orders, Trades Executed and SPS Orders for reinvestment agreement to write global specs.
• Aimed at significantly improving the efficiency and effectiveness of the firm's global credit risk, interpretation, definition and implementation of Basel II requirements, and amplifying exposure management activities.
• Addressed all aspects of credit card business.
• Assisted project team in preparing Functional Specification Document FSD , developed non-functional requirements, and documented Business Requirements Document BRD .
• Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.

Environment: Windows, Oracle, SQL, MS Visio, MS Access, MS Project, AML Anti Money Laundering , Basel II, Dodd Frank, MS SharePoint, UML, Requisite pro, Rational ClearQuest, Windows XP, Oracle/SQL Server 2000, SQL, MS office, Rational Rose, Agile/Scrum, Rational Requisite Pro, OOAD, .Net, Test Director, Clear Case, Rational Suite.

Confidential

Business Analyst /Systems Analyst

The Fox Broadcasting is an American commercial broadcast television network that is owned by the Fox Entertainment Group division of 21st Century Fox. The Fox Broadcasting Company and its affiliates operate many entertainment channels internationally, although these do not necessarily air the same programming as the U.S. network. Most viewers in Canada have access to at least one U.S. Fox affiliate, although most of Fox's primetime programming as well as NFL on Fox is subject to Canadian simultaneous substitution regulations.

Responsibilities:

• Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Followed solely RUP methodologies during the course of the project.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Worked into identifying the Data Sources, ETL methods, Data Conversion process, OLAP designing and Reports generation required for reporting purpose.
• Worked with BPM, IT and Data Managers to come up with Business and Technical Process flows
• Lead Analyst who delivered a store-facing CRM application with a front end UI built on Microsoft Dynamics CRM, .Net, cloud email and interfaces that call web services.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management BPM tool
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Worked in Extract, Transform and Load ETL environment involving Informatica and Business Intelligence tools like Cognos and Business Objects.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
• Experienced working with various SDLC methodologies including CMMI, CMMI-DEV, Scrum as Product Owner , Unified Process, Agile Spiral and classic waterfall.
• Familiar with workflow applications and BPM such as ishare and sharepoint, defined workflow of the new application using use cases, experience of working on several projects at the same time and making the best use of project management.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets.
• Working with development in transformations requirements for ETL of data from multiple sources to auto data warehouse ADW .
• Worked deeply into Customer Relationship Management by applying Microsoft Dynamics CRM Software.
• Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
• Participated and organized daily Scrum and kept track of Sprint backlog and burndown charts
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Involved in jobs and analyzing scope of application, defining relationship within between groups of data, Star Schema etc.
• Generate and analyze report using Cognos and analyze data using Informatica Data Explorer IDE .
• Reviewing and approving mapping documents for moving data from Source to target tables.
• Writing meeting minutes, organizing scrum daily meetings with the team, sending project/change progress report to business and documenting new functionalities/enhancements of the system.
• Improved programmability, enhanced Web Services, unified event model, plug-ins to replace callouts throught MS Dynamics CRM.
• Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
• Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Suggested measures and recommendations to improve the current application performance.

Environment: Internet Explorer and Netscape, SQL, Informatica, Web Logic, UNIX, Agile, Rational Req. pro, clear case, Rational Rose, Clear Quest, UML, Ms Visio, Ms Project, MS Office.

Confidential

Business System Analyst

• The Project is to implement ATM/FR/DSL and IP/VPN customer provisioning application that automates GSR router settings and reduce the human intervention in establishing secured connections. The system automates the application of customer requirements in provisioning PE GSR's.
• The aim was to integrate the ACD system with the IVR system to provide a very sophisticated call distribution process. The project also involved to enhance the functionalities of various existing applications linked to E-commerce.
• The existing ACD systems channels incoming phone calls on a first come / first serve basis. The new intelligent ACD can route calls based upon caller identification, dialed number, time of day, and custom defined parameters established in the IVR Interactive Voice Response program script.

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Effectively implementation of the System Development Life Cycle SDLC.
• Conducted Joint Application Development JAD process with Stakeholders to analyze deliverables and system constraints.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application
• Actively analyzed current business processes Claims, Recipient eligibility and enrollment etc. and
• worked with management to improve and implement enterprise solutions to ensure compliance.
• Clarified client requirements, business needs and project objectives, via feedback sessions and client
• meetings, in collaboration with all stakeholders.
• Served as a liaison between various business units and information technology groups. Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Responsible for capturing the requirements for the Integration between Network and OSS/BSS applications
• Prepared detailed Business Requirement Document BRD and transformed them into the System Requirements Specification SRS documents.
• Developed executed several Optimized queries in SQL on this data.
• Tested Performance Accuracy related queries under SQL Server.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Captured requirements for TDS billing enhancements and performed source to target data mapping for TDS billing ODS
• Gathered requirements around the Amdocs Integration
• Continued call Center reporting enhancements with CTI integration from CCE to Microsoft Dynamics CRM for screen pop and to insert calling/called party information into customer record.
• Design end-to-end BSS and/or OSS enterprise architecture solutions, including integration with legacy/third party systems.
• Advanced call routing and case management for each required customer need.
• Co-ordinate the workflow among team members and managed project deliverables like Business Requirement Document BRD, Functional Specification Document FSD and progress through regular meeting with internal stakeholders.
• Responsible for collecting and documenting the business and technical requirements for the Network applications which interface with the OSS/BSS applications.
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Created Billing Quality Assurance Sarbanes-Oxley Narrative and Testing Documentation for the Enhanced Traffic Systems Mediation Platform, including fmCI and fWCOM switched traffic plus fmCI Operator Service Traffic.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing reviewed their consistency with the business requirements.
• Designed, developed, maintained and executed automated and manual test scripts for the IVR platform
• Trained End-users and customer service agents on the CRM Customer Relationship Management application.
• Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Implemented custom data collection systems. Systems allowed to move all online and IVR data collection in-house.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Experienced in evaluation, customization, and implementation of various Commercial Off the Shelf packages COTS
• Prepared documents for business requirements document BRD , systems requirements specification SRS , high level design documents HLDD .
• Analyzed business requirements and produced functional specifications for Visual Basic/Oracle and Genesys CTI applications.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design UI screen using Microsoft Visio.
• Created Source to Target data mapping document for Siebel EIM Tables
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Agile, Rational Suite, XML, Windows, HL7 v2.X,Crystal Reports, Oracle, UML, MS Project, MS Office, MS Visio

Confidential

Business Analyst

Responsibilities

• Effectively implementation of the System Development Life Cycle SDLC.
• Conducted Joint Application Development JAD process with Stakeholders to analyze deliverables and system constraints.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application
• Actively analyzed current business processes Claims, Recipient eligibility and enrollment etc. and worked with management to improve and implement enterprise solutions to ensure compliance.
• Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.
• Served as a liaison between various business units and information technology groups. Documented requirements for Excel based system toleverage bulk purchasing of media space. Successfully deployed to multiple regions.
• Communicate with users and technical staff to bring projects and issues to resolution.

Environment: XML,Crystal Reports, Oracle, UML, MS Office, MS Visio, Photoshop, In Design, Illustrator.