SUMMARY

• Senior Business Analyst with 9+ years of experience in business process analysis/modelling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Extensive experiences in Investment Banking projects, specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Financial domain expertise with extensive Credit/Debit Card application experience.
• 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.
• Mortgage and Finance: Extensive experience in all aspects of consumer and real estate loan origination, underwriting and collections. Training and some experience in commercial lending, including financial statement and cash flow analysis.
• 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.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management, e - document strategies and process mapping.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Proficient in IT & Business roles of Business Rule management System (BRMS) and working experience with rules engines ( Camel, Drools, JRules).
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Extensive experience in developing Use Cases, creating Screen Mock-ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in developing web based GUIs using Applets, Servlets, JSP, HTML, JavaScript, CSS and Java Swings, Design & Recommendations for future state.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, XML, SQL.

Data Base: MS Access, Oracle (SQL Series), DB2

Project Management: Microsoft Project, Microsoft Office, OLAP Crystal Report

Operating Systems: MS-DOS, Windows, Apple McIntosh, Linux

Software: MS Office Suite(Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes

Performance Testing Tools: Virtual User Generator, Load Runner

Processes/Technologies: Rational Unified Process (RUP), Waterfall, UML & Microsoft Office SharePoint

Automation Tools: Requisite Pro, Win runner, QTP, Test Director, Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. Business Analyst

Responsibilities:

• Worked as a business systems analyst for developing a Microsoft.NET-based loan origination application that handles all the complex tasks of loan origination, including credit request, credit underwriting, loan approval, facility booking, and credit administration processes through the entire development process.
• Responsible for gathering requirements, creating artifacts for Rational Unified Process (RUP) - use cases, system architecture document, supplemental requirements document, architecture diagrams; verifying technical production infrastructure; designing and executing performance tests; and documentation.
• Formulated functional specification based on business requirements, inclusive of a logical data dictionary, future - state use case documentation, wire-frames, and data conversion/mapping specifications
• Extensively used the methodology to create various UML use case diagrams for the system.
• Authored Use cases, Business Requirement Documentation, and System Requirement Change Request.
• Analyzed, Evaluated and assessed gaps in the current processes.
• Extensively used Rational Rose to create use case diagrams, state diagrams and collaboration diagrams
• Documented the existing process, performed analysis, identified gaps and provided remediation plan for the processes.
• Facilitated JAD sessions to expedite the processes of data mapping
• Negotiated with vendors in the required areas in terms of tasks performed
• Gathered requirements from business users and tracked them using Rational Requisite Pro.
• Used MS Access and Excel to cleanse and assemble accounting data and develop reports.
• Created test scripts for all the test cases in PL/SQL
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked with technical teams to research and advice on alternative technical solutions to address critical/major business issues and opportunities.
• Created customized report using OLAP Tools such as Crystal Report for business use Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Facilitated the User Acceptance Testing (UAT) of the application by working with users and documenting gaps in the beta version of the application
• Effectively communicated user acceptance test results between users and development team and provided recommendations for change control requests (CCR).

Environment: Rational Requisite Pro, IBM Rational, Clear box, Clear Quest, Data warehouse, UML, Oracle, XML, MS Project, SQL Server, Rational Suite, MS Office

Confidential, Calabasas, CA

Business Analyst/ System Analyst

Responsibilities:

• Extensive experience in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
• Gathering market data including real time and historical price data, financial data, and trading news using financial data source named Bloomberg.
• Integral part of the development, implementation and maintenance of Eagle Pace, a performance and reporting platform.
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Deep understanding the Business Flow of Investment Banking, and extensively involved in Portfolio management and analyses, Mutual Funds, Securities trading.
• Developed test plans with QA team and helped test every scenario using Mercury TestDirector Tool for system testing
• Determined and Drawn the preferred flows for OMS (Charles River), TMS figuration, BOSS and MEO for financial instruments (Stocks, bonds, Options, Mutual Funds, Preferreds, etc) with the consideration of Web discounts, daily trading account value, margin requirements, IRA accounts, trading limits, Lead-Ins and Lead-Outs, GLAS (Gain Loss Analysis Systems), Confirms, Settles, Trade multiplier, etc. on MS Visio.
• Involved in creating reports for the end users using Crystal reports from the gathered requirements.
• Collaborated with External Auditors and documented SOX compliance requirements
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Worked extensively in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Gained in-depth knowledge and experience in pricing, inventory, procurement, time & attendance, barcode, EFT, credit cards, and handheld wireless technology in mainframe, client/server and web based environments.
• Used SoftTest software with pseudo code to ensure test cases covered all branches of project's code impacting the system. (The system is an IBM mainframe based system that contains the master set of customer information used to bill customers.)
• Established a RUP (Rational Unified Process) centric business analysis methodology.
• Solid Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
• Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Designed and developed Project document templates based on SDLC methodology
• Helped with data modeling and defining the conceptual and logical model of the data warehouse.
• Conducted UAT to confirm that all derivative products can successfully processed during the trade life cycle

Environment: Windows, Oracle, SQL, Eagle Pace, MS Access, MS Excel

Confidential, Salt Lake City, UT

Business System Analyst

Responsibilities:

• Gathered high level requirements and developed scope of the project for the implementation of Microsoft Office Share Point.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Gathered requirements for the integration of POS system with the supply chain system
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
• Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory.
• Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
• Responsible for creating Business Requirement Specifications, to capture functionalities at all E-Commerce touch points.
• Responsible for data mapping and for governing the data quality (Data Governance)
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Provided technical and procedural support for User Acceptance Testing (UAT) and Coordinated with the QA Team in the sign-off process before deployment.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Enforced rules of Scrum during development phase, which involved facilitating meetings, updating Burn-down charts, backlog refinement and removing impediments affecting project goals
• Assisted with the BRD for the POS implementation project
• Captured and documented system level (SSS) and software level (SRS) requirements in DOORS supporting the SOW and system design for the SCL3S Airborne Communcations program.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Worked on exporting data using Teradata.
• Analyzed trading partner specifications and created EDI mapping guidelines
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Developed Data Conversion Strategy for converting data from the existing site to the new site.

Environment: Windows, Oracle, PL/SQL, SharePoint, Unix, Doors, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, MS Access

Confidential, Atlanta, GA

Business System Analyst

Responsibilities:

• Participated in project management, design, requirements definition, specification, budgeting, control, and restructuring of organizations
• Prepare Use Case Models based on Business Requirement documentation gathered through interaction with users. Studied existing business application and processes, collected end user requirements and suggested the improvised Business Process Model.
• Utilized corporation developed Agile SDLC methodology. Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Gap Analysis of client requirements generated Workflow Process, flow charts and relevant artifacts
• Defined and documented the Vision and Scope of the project. Conducted one on one interviews with high level management team and participated in the JAD session with the SME’s.
• Responsible for establishing and maintaining positive business relationships with IT managers and clients, and ensuring that business objectives and priorities are aligned.
• Interpreted business objectives to support the implementation of technical software application
• Consolidated the analysis of multiple business lines after the COTS evaluation.
• Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
• Involved in Business Process Management (BPM) activities like Process Design, Process Monitoring and Process Execution. Worked as a liaison between the business and technical side to convey the business needs to the system architects.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
• Designed Use Cases using UML and managed the entire Functional requirements life cycle using RUP. Utilized corporation developed Agile SDLC methodology.
• Used Scrum Work Pro and Microsoft Office software to perform required job functions
• Conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models. Conducted the final user-acceptance testing (UAT) and usability testing
• Involved in review and Gap Analysis of Functional Requirement documents and the creation of technical documents and related test case documents
• Worked on the Microsoft SQL query to extract the data required for data validation.
• Involved in Cross-functional teams, developing new ways to boost efficiency and delivering results in a fast changing environment to achieve company goals
• Provided the management with Test metrics, Reports, and Schedules as necessary using MS Project and participated in the design walkthroughs and meetings
• Conducting requirement gathering sessions, gathering business requirements and translating into system requirements, building project plans, designing using Rational Rose/UML, relational database design and handle all release changes.
• Hands-on development using Java and J2EE technologies and overseeing efforts for Webservices integration, proper testing using Mercury Quality Center - TestDirector.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle)

Environment: Agile, Windows Vista, Microsoft Project, MS Access, Business Objects, MS Visio, SQL, MS Excel, Oracle, Java, Rational Suite, MS Visio, MS PowerPoint

Confidential, Framingham, MA

Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
• The Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• Conducted Data Analysis and Data Mapping activities using SQL and MS Access
• Manage projects throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project and NIKU Workbench.
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
• Reports were formatted according to the user requirements usingBusinessobjects functionalities like Breaks, Sections, Calculations,SliceDice, Drill down and Variables.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies. Worked with Front-end and Back-end systems.
• Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting). Performed the requirement analysis and documented the requirements using Rational Requisite Pro
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Responsible fordatamapping of feeds from several referencedatasystems, to a number of in-house applications.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution. Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Used MS Visio for Process modeling, Process designing, Process mapping and Business Process flow diagrams. Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.

Environment: Java, J2EE technology, .NET, SQL Server, UNIX/Oracle Platform, MS Visio, MS Word, MS Excel, MS Power Point, Businessobjects, MS Project, RUP, Rational Rose, Rational Clear Quest, Rational Clear Case, Rational requisite pro