SUMMARY

• Business Analyst with 8+ year experience in all phases of Application Life Cycle: Gathering and Analyzing Business Requirements, Functional Requirements, Reporting Requirements, Prototyping, Use Case and Test Case development. A smart, motivated, and committed quick learner.
• An excellent team player with analytical, leadership, interpersonal and problem solving skills
• Expert understanding of the Trade Lifecycle right from trade origination to trade settlement for Fixed Income, Equities, FX and Derivatives.
• Strong understanding of the payments, overpayment and repayments in case of the Federal and State provided family assistance programs.
• Expert understanding of Portfolio Wealth Management and Performance Reporting.
• Experience compiling data validation and augmentation for back office processes.
• Experience defining data quality rules based on various Business Processes and Rules.
• Experienced in the Agile, Waterfall & RUP software Development Life Cycle SDLC methodologies.
• Extensive experience in conducting JAD session for gathering requirements from the project stakeholders and converting them into Business (BRD) and Functional Requirements (FRD/SRS), developing Use Cases and Use case diagrams using Unified Modeling Language (UML) tools.
• Expert in UML modelling, BPMN diagrams, Use Case Diagrams, Wireframes, UI Prototyping, Workflow designs, Conducting Gap Analysis etc.
• Knowledge of Content Management Software (CMS) like ECM Documentum, Sales force and Alfresco to manage data, records, web applications and capable to analyze business process & recommend changes
• Knowledge of OBIEE 11g reporting, both custom and out of box reports.
• Expert knowledge of requirement traceability matrix & Version control as well as requirement change management.
• Extensively used rational tools including Requisite Pro, Rose, Clear Case, and Clear Quest.
• Highly experienced working with various Databases like Oracle, MS SQL Server, MS Access and writing SQL queries
• Experience inDataMining,Datamapping and Data modeling and good understanding of the ETL.
• Hands on experience in writing Test Plans, and Test Scripts. Actively involved in User AcceptanceTesting(UAT) and End User training.
• Working knowledge of report generation from Business Objects, Cognos & Crystal reporting.
• Proficiency in project management tools such as MS - Project for status reporting and planning.

TECHNICAL SKILLS

• Unified Modeling Language (UML)
• Rational UnifiedProcess (RUP)
• Agile
• Waterfall
• Rational Rose
• Rational Requisite Pro
• Axure
• DOORS
• ClearQuest
• HP Quality Center
• Windows 95/98/NT/2000/XP/Vista/7
• SQL
• HTML
• XML
• SQL Server
• Oracle SQLDeveloper
• Oracle Data Modeler
• MS Access
• MS Office
• MS Outlook
• MS Visio
• MS Project
• SharePoint
• Test Director.

PROFESSIONAL EXPERIENCE

Confidential, SAN JOSE, CA

SR. BUSINESS SYSTEMS ANALYST

RESPONSIBILITIES:

• Establish a project development methodology around Agile SDLC
• Work with Portfolio Performance Measurement committee to identify Portfolio Performance Calculation Business / Functional Specification / Report requirements
• Involved in the GAP analysis of the retiring system GIM2 and the future state CPOS/PMR
• Work with Financial Advisors in determining report exhibits, format and to run the stats with account performance data
• Work with Portfolio Reporting Team in determining the Report design and format
• Work with Advisory team in determining the data and data derivation logic required for the creation of Manager Composites and Factsheets
• Create Business/ Functional requirements document based on the needs and details identified
• Create Technical specifications document for determining Portfolio Performance Start Dates, Security Linking, Advisory Fee attribution, Security Benchmark measurement etc.
• Work with Data Migration team in determining the data elements and period for data migration
• Strategizing migration of the complex structure account and account groupings data over to CPOS/PMR
• Responsible forcreating datamapping documents between legacy Performance Reporting Systems and determining the best data source for migration
• Create Data Quality analysis document to measure the quality of migrated data in terms of completeness, accuracy and validity
• Work with Advisory reporting team in determining the collapsible APR, OPR, QPR and PWM reports
• Work with development team and keeping track of all the JIRA user stories being developed throughout the project.
• Presenting the traceability to Project Management team by providing RTMs on a weekly basis.
• Work with the QA team in defining the test cases, test data, data quality checks and test scripts for the project.
• Work as scrum master for daily scrum for project status tracking and keeping upper management apprised of the project.

ENVIRONMENT: Windows 7, Oracle, Java, MS Office 2007,MS Visio 2007, MS Access 2007, UML, MS SharePoint, GIM2, Advent Axys, Caliper, JIRA

Confidential, FORT WORTH, TX

SR. BUSINESS SYSTEMS ANALYST

RESPONSIBILITIES:

• Work with stakeholders to identify and document the business/ functional / report requirements.
• Involved in the GAP analysis of the current system and the future state.
• Create front end design document to capture UI requirements using wireframes and working prototypes.
• Identify the documents required for the project to be SDLC compliant and create a project plan to ensure the timely delivery of all required artifacts in line with the project delivery timelines
• Create Business/ Functional requirements document based on the needs and details identified
• Create Technical specifications document for Raising Requisition Request, Requisition Tracking, Invoice Creation, Voucher Creation, Generating Payments, and Report Generation etc.
• Completely involved in understanding the reporting requirements and prepared Report Specifications Documents that would provide the development team a clear understanding of the structures and the formats for the 13 reports to be developed
• Responsible forcreating datamapping documents for different requisition types and identifying the reference data elements.
• Worked with the testing team in defining the test cases and test scripts for the project. Acted as a reviewer and approver for these test cases.
• Worked with the Payment Services and Administration Services UAT team in defining the user testing scenarios

ENVIRONMENT: Windows 7, Oracle, Java, MS Office 2007, MS Visio 2007, MS Project 2007, UML, MS SharePoint, Axure

Confidential

SR. BUSINESS SYSTEMS ANALYST

RESPONSIBILITIES:

• Establish a business analysis and software development methodology around Agile.
• Responsible for identifying, analyzing and documenting the scope of work by conducting several JAD sessions with the Technology and Operations teams.
• Efficiently conduct daily scrum meetings as a scrum master for project, deliverable tracking and issue resolving.
• Design Business and System Process Flow using swim lanes, used MS Visio for UML Modelling
• Successfully converted the captured requirements into Business Requirement Document and Functional Specification Document.
• Identify requirements gaps, specify and document business rules.
• Review existing implementation of a data process (source to staging to production database) and formally capture the business requirements. This is for S&P's North American Corporates data that is sourced from Workday and finally loaded into the OPDM data base for use by the analysts.
• Measured the quality of incoming data versus existing data against various Data Quality dimensions like Completeness, Conformity, Accuracy, Consistency etc.
• Created Data Mapping documents depicting various Data sources and target.
• Work with Data Services to make sure ETL process and rules are documented and identified Data Quality rules to be added so as to trap and capture exceptions before they go into production data.
• Validated and analyzed the root cause of errors encountered during the loading of source data files in SIT and UAT environments as part of the Data Investigation work stream
• Work with IT QA, Data Assurance and Data Services to make sure that IT QA has developed proper test scripts to evaluate and check the data flows on rollout and on-going
• Write several complex SQL queries to verify the mapping exercise.
• Work with Data Assurance team to measure the quality of the incoming data in terms of Completeness, Consistency, Accuracy and Conformity.

ENVIRONMENT: Windows 7, Oracle, QlikView, MS Office 2007, MS Visio 2007, MS Project 2007, UML, TOAD, MicroStrategy, MS SharePoint

Confidential

BUSINESS ANALYST/DATA ANALYST

RESPONSIBILITIES:

• Conducted JAD sessions efficiently to capture the requirements from business stakeholders and exception resolving group and converted into business and technical requirements documents.
• Established a business analysis and software development methodology around Agile.
• Wrote complex SQL queries to do the map-gap analysis between different source system
• Created several data mapping documents to map the attributes across the systems in scope.
• Created diagrams and documented exception workflows between the trading, settlement and positions systems using the standard UML tool like MS Visio.
• Responsible for creating an “exception-resolution” document to define the exception and their possible resolution and also the list of involved actors and their roles.
• Responsible for determining Citi specific and street specific exceptions and creating a universal exception dictionary.
• Expertly categorized attributes in new data model as Main, Support, Reference data and Reference data hooks and used the categorization as a base for creating tables.
• Created a universal data dictionary to maintain the attribute, their definitions and sample data.
• Designed logical, conceptual and physical data models using the Oracle Data Modeler and reviewed the data models with the technical teams from various groups.
• Efficiently worked as a liaison between the development teams and the business teams and kept them abreast on the progress and changes.
• Expertly tracked project deliverables and statuses on a weekly basis. Created weekly status reports to be shared with PMO.
• Responsible for writing testing manuals and training of the end users.
• Extensively involved in conducting UAT sessions.

ENVIRONMENT: MS Office 2007(Word, PowerPoint, Excel-VBA, Pivots, Vlookup, Macros), MS Visio 2007, MS Project 2007, SQL Server, Oracle Data Modeler, Oracle SQL Developer, SQuirreL, UltraEdit, MS SharePoint, HPQC, UML, XML, Clojure, Citrix Web Client

Confidential

BUSINESS ANALYST

RESPONSIBILITIES:

• Performed Gap analysis to prepare ‘As-Is’ document and ‘To-Be’ document.
• Wrote vision and scope documents.
• Worked with the valuation development team to document requirements and implement system enhancements for the Asset Mark-to-Market application.
• Conducted JAD sessions with SMEs such as front office representative, branch managers and users for gathering requirements.
• Diddata mining, datamapping and data modeling forinsurance.
• Worked on specifics of cross selling and understood the concept ofinsurance products.
• LeadBAin preparing use cases & activity diagram.
• Involved in the Waterfall methodology in all phases of the project.
• Participated inDataAnalysis and Design with theDataanalyst.
• Extensively involved in writing Test cases and Test plans.
• Performed User AcceptanceTesting(UAT).
• Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

ENVIRONMENT: Windows XP Professional, Oracle 9i, Siebel CRM, Java, MS Office, MS Visio, MS excel, MS-Project,UML, HTML, XML.