SUMMARY

• 12+ years of total work experience including 4.6 years in People - Project Management Role including and mentoring of teams.
• 8+ years of experience in business analysis, business requirements modeling and development of web Based and client/server applications extensively in business domain of BFSI.Requirement gathering for Various Projects including loan lending loan approval process and other loan services workflows.
• Strong business development acumen of managing multiple business relationships.
• CRM,SCM and financial data manager workflow including SAP integration with EDM.
• Data sourcing for 47 Vendors into MDM and redistribution management.
• Warehouse flow diagram and interface integration with other systems for data sharing.
• Enterprise management and integration including new GUI features.
• Simulation and UAT tests for the same.
• Risk management, MO risk, CCAR Model, Treasury ops,
• People and Client Management: Managed key clients and stakeholders for 11 Projects.
• Reporting and SLA Planning and reconciliation of data for Key deliverables. Managing KRA,SLA and other metrics at project level
• Data Analysis, Project Management & Performance Improvement, Product management, Capital Market Operations, Data base management.
• SCRUM methodology and sprint runs with integration for SCM and Retail domain using Agile methodology.
• SQL based development and maintenance of strategic database common to 8 projects and reporting for them to higher management for planning and change management purposes.
• Liasoned with Institutional Sales/Client support, Forex Trading, Equity Trading, Options & Hedging Strategies,FO,MO and BO for functional requirements gathering for 11 projects.
• Fixed income, valuation, securities and loan management module and trust funds ops for some ETF.
• Experience in Financial Services and Banking domains. Swift and Cash management and payments, Treasury and Mortgage experience.
• Conducted highly interactive JAD sessions with project stakeholders, subject matter experts (SME’s), users, QA analysts and project management team for requirement gathering, and identifying and resolving issues.
• Expert in business process engineering and software development life cycle, including analysis, design, development and implementation of software applications.
• Utilized Rational Clear Quest for change requests, enhancement requests, system defects and issues. Handled repository management for release, review and technical documents using Rational Clear Case to provide accountability and version control. Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers. Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• ETL Informatica and ESB experience with Data modeling, TIBCO, client/server systems, Web services, SQL, Oracle DB, PL/SQL, Doors, GUI design and other programming tools.
• Well experienced in developing Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD), Use Case Models, Activity, State, Sequence, and Collaboration Diagrams utilizing Rational Rose, MS Visio and ERWIN
• Sound understanding of Gap Analysis, User stories, Functional and Non Functional requirement management and design, User case, risk analysis and project plans.
• Extensive experience in configuring data mapping of files using Edifices Spec builder.
• Experience in documenting Use Case Specification documents, Elicitation management documents, Test Plans, Test Cases& Scenarios,test documentation management, Traceability Matrix, Business Validation, Validation Result document. Coordinated team in bringing about Business Requirements, Architectural Specifications,QA and Testing initiatives through planned changes in testing tools, Reporting status at PMO level to be implemented across projects. Version change control included. Corporate Priorities and Functional Specification and maintain Requirement Traceability Matrix. Applied Unified Modeling Language (UML) to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram.
• Involved in Data Analysis, Data Mining, Designing and Implementing Data Warehousing applications focused mainly on Querying and Reporting techniques.
• Project Quality monitor and control initiatives taken for 6 projects.
• Excellent in handling change requests by the client, handled 30 major change unplanned requests.
• Technical experience with data analysis, report design, web design, development, client interface design,interface specification use cases. and experience with different databases like Oracle, SQL server, DB2 and MS Access.
• Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML).
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Experience in Risk Management process and technology reengineering, Sarbanes Oxley implementation,Valuation review process and technology, strategic sourcing, metrics and benchmarking
• Outstanding analytical, problem solving, interpersonal skills with quick learning ability. Demonstrated ability to work both in an independent and team-oriented environment with well-developed organizational & exceptional Communication skills.
• Application integration point to point, ETL, Middleware. Change management control.
• SCM, Order management, CRM linkage through informatica. Inventory management.
• AML, Compliance, regulatory reporting and mortgage, loan processing applications. Credit management and cash operations.

TECHNICAL SKILLS

Business Skills: Business Requirements, Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, JAD/JRP Sessions, Gap Analysis and Impact

Analysis Languages: SQL, UML, J2EE, .NET, HTML, XML, and Visual Basic 5.0/6.0Packages Siebel Sales and Call Center, SCM, CRM, ALS, Rational Rose, Requisite Pro, Clear Quest, ClearCase, Mercury Test Director, Win Runner, & Load Runner.

Databases: MS Access, Oracle, DB2, MS Access, MS SQL Server Operating Systems UNIX, Linux, Windows 2007/2010/NT/XP, MVS, and MS-DOS

Office tools: MS Office (Word, Excel, Power Point, Outlook), MS Visio, MS Project, MS Access, and MS FrontPage

PROFESSIONAL EXPERIENCE:

Confidential, Richmond,VA

Business System Analyst

Responsibilities:

• Used the Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse, database Query. Load testing.
• Experience in documenting Use Case Specification documents, Test Plans, Test Cases& Scenarios, Traceability Matrix, Business Validation, Validation Result document. Coordinated team in bringing about Business Requirements, Architectural Specifications,QA and Testing initiatives through planned changes in testing tools, Reporting status at PMO level to be implemented across projects. Version change control included. Corporate Priorities and Functional Specification and maintain Requirement Traceability Matrix. Applied Unified Modeling Language (UML) to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram.
• Involved in Data Analysis, Data Mining, Designing and Implementing Data Warehousing applications focused mainly on Querying and Reporting techniques.
• Project Scope, Business case, Project documents and analysis. Schedule and Risk.
• Involved depth understanding of Credit Risk management for the application.
• Risk management, Cash flows, CCAR modelling, BA, testing and GUI development through JAD.
• Technical and Regulatory risk assessment and built a reporting module for CCAR.
• Basel and FATCA monitoring and reporting.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• SCM, Order management, CRM linkage through informatica. Inventory management.
• Ware house distribution and systems integration.
• Database integration management and EDM flow manager.
• Business objects development and integration
• Data sourcing from Vendor systems.
• Experience in Business Intelligence Product design and have a solid understanding of development, data models, testing, and integration methodologies.
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market,Mark to Market.
• Worked with management and users to analyze specify and design business applications and document current processes for efficient operations (re-statement on general ledger, account payables and receivables and P/L) using Rational Tool (RUP).
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk.
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2014.Sharepoint Data
• Created Use Case Diagrams, Workflow and Activity Diagrams; and documented Use Case Narratives.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Loan operations and mortgage operations. Regulatory reporting and compliance.
• Experience with Defect and Change management tools preferably Rational Clear Quest and Mercury Quality Center.
• Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
• Worked as a business analyst to conduct JAD and elicitation sessions with the Private Banking, Capital Market business users and stakeholders to analyze end user objectives for Basel II Asset Classification and CRMT system and created business requirements specifications, use cases diagrams.

Environment: RUP, UML, Crystal Reports, Oracle,DB2,JIRA, SQL,Business objects, Agile, JAVA, XML,HTML, MS

Confidential

PM/Business Analyst

Responsibilities:

• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Actively participated in the resolution of Production Report issues and also the gathering and analysis of ever changing Reporting Requirements of users
• Involved in the meeting with business and marketing team for requirements gathering in definition stage.
• Gathered the reporting requirements of the Trade Position Reporting for various Secured and Unsecured Financial Products including Derivatives like Equity Swaps, FX Forwards, Currency Swaps, Interest Rate Options and Forward Rate Agreements (FRA) and formulated the Business Rules for the same in the Oracle Data Warehouse with Crystal Reports as the front end reporting tool. For a product testing Financial client
• Ensured IT security and SOX Compliance requirements are implemented in New Systems, Enhancements and Upgrades.
• Asset classes covered include Interest Rate Swaps, Credit Default Swaps, Foreign exchange swaps and Equity options.
• Ability to organize, document and track archive change request in Clear Case.Mark to market strategy.
• Worked as a Liaison between Trading and Debt Capital markets to execute Syndicated loans.Derivatives ops.
• Loan pricing management.
• Created narrative Risk Manuals and flow charts identifying internal risks to Investors Bank and Trust for Global Treasury/Global Treasury Operations.Debt and securitization and valuation.
• Monitored compliance of Global Treasury/Global Treasury Operations desks (Asset Liability Management, Broker/Dealer, Foreign Exchange, Investment Portfolio, Money Desk, Securities Lending and Wire Room Operations) with regulatory and internal requirements. Loan operations and mortgage operations. Regulatory reporting and compliance.
• Performed compliance projects as requested by Global Treasury/Global Treasury Operations Management.
• Monitored daily compliance reporting for all Global Treasury desks.
• Assisted with integration of former Investors Bank and Trust Institutional Custody Department into Wealth Management Services.
• SharePoint development and access management.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted with preparation for internal audits, and Federal Reserve Board audits.
• Provided Anti-Money Laundering review of State Street/Investors Bank and Trust clients.Completed other compliance projects.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL
• Performed Data Validation of the data flow from the front-end to the back-end using SQL to perform the Back-end testing on the database
• Facilitated negotiations with clients (other arrangers) for the finalization of syndicated facilities (conditions, term sheet, covenants)
• Ensured dat relevant UML diagrams and Tools (Rose, RequisitePro) were used in all requirement documents e.g. Business Requirements, Functional Specifications.
• SQL query tools and business objects. Designing, modeling, developing and supporting Data Management Systems.
• Integration methodologies, IBM and informatics tools. Database integration including data models, data marts.
• Data profiling, match and reconciliation based on query through centralized matching facility.
• Facilitated the Customer in defining the high-level Functional Requirements and needs.
• Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document
• Documented approved change controls to add them into business design.

Environment: MS Visio, PowerPoint, Quality Center, Rational Requisite Professional, Rational

Confidential

Manager/Business Analyst

Responsibilities:

• Responsibilities in Portfolio Management, Risk Management, Equity, Fixed Income Securities (Treasury Securities, Corporate Bond, Municipal Bond, MBS, etc) and Derivatives (Option, Interest Rate, CDS), Analysis and Data Testing of Financial Statement.
• Assist with new implementation of Equifax Appro front-end system, and the interface to Fidelity’s ALS application.
• Functioned as the primary liaison between the research operation personnel and developer team throughout the project cycle, and assisted project manager and worked with high level management team to identify project scope, develop phase plans and schedules using RUP to assure high quality and on time project delivery
• Facilitated user interviews with stakeholders and end users to determine business requirements and needs, and designed and conducted survey among different market end users.
• Solid knowledge of key systems comprise the trading system (Order Entry, Client Account Verification, Coding, Order execution, Figuration, Comparison, Confirmation, Custodian) in PM planning and design.
• Developed the Business Process Flows to support the products and services selected in phase 3 of the project.
• Involved with the requirements, design, development, testing and administration of transactional and analytical data constructs/structures. Principal and interest workflows. Approval process within systems. Loan life cycle.
• Analyzed data using complex queries and designed solutions to data problems, resulting in accurate and thorough resolution of issues and reduction of time required for completion of the project.
• Experienced on Market Data and Data, and performed data extraction, and data manipulation with SQL.
• Strong hands on ability to use SQL to extract data from database, data analysis and data reconciliation.
• Established a Business Analysis methodology around the Rational Unified Process.
• Developed current and future Business Process Flows, and created BRD and FSD with Visio and Word.
• Helped develop Use Cases, project plans and manage scope.
• Worked extensively in agile methodology throughout the project cycle.
• Coordinated in developing Test Plan, Test Case and participated in QA testing.
• Loan Accounting and Work flow Management including reporting of Data after query.
• Conducted interviews with various business users (Financial Advisers, Risk Management Group.) to collect high level requirements and business process information using MS Visio and Word.

Environment: Agile, Rational Requisite Pro, Rational Rose, Oracle, Fidelity ALS, MS Project, MS office

Confidential

Business Analyst/PM

Responsibilities:

• Assisted with testing and implementation of ALS system changes due to requirements of BASEL II initiative.
• Worked on story board sessions and Use Case Diagrams to refine the gathered requirements.
• Prepared Business Requirments Document converted it to Functional Requirements Specification using Rational Requisite Pro
• Followed the Unified Process Methodology for iterative design.Worked on creating a hybrid model of RUP and Waterfall methodologies for software development.
• Developed a Requirement Traceability Matrix and ensured its timely update.
• Worked with Senior Project manager and other users and created Work flow diagrams using MS Visio/UML t high definition level/Program management level. worked on creating the business requirments for Data Migration from Legacy system to new Oracle database.
• Involved with the requirements, design, development, testing and administration of transactional and analytical data constructs/structures.
• Expertise in creating Data Mapping Documents and Source to Target Transformation document.
• Experience with ETL Validation and writing requirments to enhance the ETL process. Middleware coordination
• Worked on the validation and integrity of the migrated data.
• Extensively used T-SQL to write complex queries against the database and the datamarts.
• Implemented SOX procedures and guidelines in the entire requirements and project framework.
• Created Mock Up screens using MS Visio for better visualization and understanding of the software application.
• Processed the data requirements to present them as Bar charts and Pie Diagrams for financial analysts to perform trending.
• Worked on development for Reverse Mortgage Product install(MISMO).
• Document and executed user acceptance and system integration test scripts using Quality Center
• Processed requirements for creating Analytical Trending reports for Marketing and Sales.
• Conducted Joint Application Development sessions with Developers, Testing teams and Subject Matter Experts.
• Prepared a schedule and work flow for the development team using MS Project.
• Made sure dat deliverables met Business Requirements
• Involved in conducting User Acceptance Testing with prospective users.
• Wrote complex SQL queries to conduct Data Validation tests and Data Integrity tests.
• Collected information to created a Back Out Plan as a part of Production Readiness Review.
• Played an active role in Production Support and maintenance of the applicaton.
• Conducted status meetings and presided over the Changed Control Board meetings to discuss Defect, Enhancement and Database Change tickets.

Environment: MS-Project, MS-Visio, UML, Rational Requisite Pro, SQL, Oracle.

Confidential

Manager/SME/Business Analyst

Responsibilities:

• Global Equity Settlements, Trade settlements back office trade reconciliations.APAC, European, US settlements/Stock Transfers.
• Interbank settlements. Upload postings and NDF entries and settlements. Liason with broker and senior management for
• Change management and daily ops.Confirmation management and trade processing.STP and exception load
• Processing. Uploads for portfolio management.
• Intellimatch ops, development and testing. Intellimatch reconciliation.
• Product management and Client management for APAC and Europe.
• MBS, CMO and MBS Futures and options.
• Database management through SQL carried out in Singapore for 6 Months
• Simulation tests, manual and automated testing.UAT, BAT design.
• Service now, Sales force implementation. Share point access and content management
• Consulting, requirements gathering, analysis, design, UAT in Payments and liquidity, exposure limits.
• Consulting,BA and clients management in value and cross border payments.Payments system and netting.Treasury
• Management.
• Process mappings and BPM, Process design.Database management and process modeling.
• MS Projects and MS Visio appovals.SOP approvals.
• Risk management,, anti-money laundering, Regulatory compliance.
• Global client management, resource management, Time/Task studies. Test cases.
• Reconciliation utility management-Intellimatch, Upload and exceptions processing.Clearing and settlements.
• BPR and BPM projects.
• Trade capture and client services and CRM, Client management, Client query and experience management.
• Collateral, lien and Swift messages. Daily dealer and custody ops.Trade confirmations and reconciliation.
• Corporate actions, Market data management - and price data, Exchanges Data. Business intelligence
• Onsite Transitions/migration of Upload process,Equity settlements,FX tomnext rates, Corporate actions trade reset.FX
• Processed.
• Experience in Business Intelligence Product design and have a solid understanding of development, data models, testing, and integration methodologies.
• Testing validation.Functional and process automation.Financial and Resource utilization reports. TAT, SLA.Employee retention.
• Data flow and process flow documentation.Process optimization through eradication of inefficient processes.Business process management and improvement.Project management.UAT/Functional and environment testing framework.process
• Reengineering.
• MS SQL and FRD, User cases. Traiceability matrix.Functional specification documents.BRD.Design document.Business elicitation
• Documentation. Flow diagram, server module diagram. Functionality flow diagram.
• Skills of SME for Investment banking: SQL, Visio diagram, documentation. Testing, MS project.
• Analysis: Gap, AS-IS,SWOT,Cost-benefit,fishbone diagram.Project feasibility study and Feasibility estimation for IT
• Projects. Agile (SCRUM), waterflow,RUP approach.
• Experience in UAT,unit,simulation and Regression testing.Automated and manual testing.Functionality testing.Data integration
• Testing through back end methodology.
• Multiple application and enterprise connect, flow and integration through environment diagram and ecosystem diagram.
• Multiple server multiple data approach.Test pro 9.1 used .UML modelling.QTP Tool used.Testing script archive through PAT
• Methodology.
• JRD, Elicitation meetings and document record management in DRR.Scenario management.
• Windows,ASP.NET,Web developer tools.SQL Server 2005,MS Acess 2010.Tera data,Oracle,DB2.MS Project 2010.Saxo share point 2009, Big data,Informatica BA.
• SDLC through content management and Content display on GUI interface and data modelling and integration from multiple
• Bug management and error resolution.Visual basic on MS Visual studio.NET and J2EE Technology,java scriptsUnix and Linux security orientation.JSP Servlet diagram.
• Resolved the data issues between the source systems and the target system using the Mapping Documents, ETL specification documents and issue logs.
• Worked closely with different development teams to document file sizes, file processing schedules and the volumetric of each file.
• Offsite transition of Data Management - and price,exchanges data and to the team.Exchanges setup and reporting-Client holdings and compliance reporting.Performance reporting.SAP BO.
• Fund accounting and booking rules.Uploads processing. Exchange and Regulatory disclosures and Reporting, Holding disclosures,FX tomnext processing.SEC,FSA,Exchanges and regulatory reporting.US GAAP and statistical reporting.FATCA, Mifid,Basel reporting.Money laundering reporting.
• Equity research reports generation and distribution to subscribers (WLC and private clients.)
• Process improvement.Instrument setup criteria.UAT testing for application enhancement.Access management. Institutional
• Banking. Back office accounts and ledgers. Productivity management.Project management.
• Client holdings.Bank Reconciliation.Foreign currency Hedge funds and fund accounting.Business recovery and sustainability.Ops control and reporting.Exeptional load reporting.Risk management.OTC derivatives.operations and risk.Margin services.Cash and Control.Clearing and settlements.
• Contribution to product management and client acquisition.UAT testing and business requirement matrix.BPM and
• BPA&R.Audit trial leads.CRM systems.Stakeholder management.
• Data Integration across various platforms for reconciliation and reporting.TLCM and transaction reporting.
• Development rules and Manual testing for functions in reconciliation utilities.Feed back mechanism.
• Portfolio tracker and management.WLC and client management-Citibank, Barclays.
• Participation in product focus programmes.
• Worked on process enhancements and application enhancements through suggestions on the feed commander application layout.
• Improvement of the Regulatory reporting.Functional and Knowledge specialist/Subject matter expert in major areas of back ffice.FX documentation, settlements and reconciliation. Confirmations processing and payments.
• FX option confirmations.CFD on FX trade support. Trades processing-Pre and post trade for Listed products.
• Custody operations management with UBS and Citibank.Trade giveups for FX Options DVP and RVP settlements.Liason with multiple brokers. DVP/RVP Settlements processing.Giveups to multiple counterparties/brokers and custody operations.trades failed reporting.Euroclear and DTC settlments.
• Good in gathering functional specification from line department and feeding information to development team.
• Client interaction for transition and functional requirement gathering.process development.
• Document management. Transition from Singapore, pretransition documentation and hiring.
• Business requirement elicitation for Development and testing.Business documentation(BRD).Change management for application environment.Product solution and optimization.UAT test cases.User story/case creation.
• Trade Lifecycle Management and SDLC Business analysis and Requirement gathering.Trade management and processing.Options trade confirmations.Tading platforms and investment management. mentoring, delegating of authority, coaching and managing teams. Performance management and feedback, Hiring of candidates.

Confidential

Analyst Business operations

Responsibilities:

• To manage data flow on SQL Platform.
• Details to manage Index and ETF data through structured query language (SQL) Business analysis of project requirement.
• Liaison with the development and testing team.Process Documentation, Vendor management across markets through case creation. STP processes for trade processing and exceptional uploads.Confirmation management.
• Client management across markets. Complex Corporate action event and derivatives management. Liaison with Reuters,bloombeg,Factiva,Sedol master file .Liason with broker and senior management for Change management and daily ops.
• Business case testing.Operational case testing. Transaction processing and TPLC.
• Merger and Acquisition, split, reverse split management. Part of Managed Data Service (MDS) team.Product and price data servicing.Functional and operational role in product management.
• Vendor management for IDC, Bloomberg, Reuters and stock exchanges..Research and maintenance of data feed mapping specifications linked to Bloomberg BackOffice, Reuters DataScope Feeds and Corporate actions feeds.
• Asset/Hedge funds and alternative priccing.Index/ETF/Fund related and performance data.Daily operations and product/IT testing support. Functional testing. Product performance.
• UAT testing and requirement gathering.listed products Risk management
• SQL data warehouse testing and database maintenance.C++ and Java tool format testing.
• SharePoint, Teradata, DB2, Oracle 10g, HP Quality Center, Cognos, MS Project, MS Office, ERWIN, TOAD for Data
• Analyst, MS Visio, Informatica for DB2 integrated environment.

Confidential

Business analyst(Sr Associate)

Responsibilities:

• OTC derivatives documentation and settlements including Swaps, IRS, CDS and Index Structured Swaps.
• ISDA reporting.
• OTC and structured derivatives/Transitions and migration from UK.Documentation management.SPV derivatives.process improvement and process reengineering.Pretransition documentation.
• Daily management reports format approval.client interaction for transition and functional requirement gathering.process development.lean/six sigma yellow belt.
• Testing validation.Functional and process automation.Financial and Resource utilization reports. TAT, SLA.Employee retention.
• Data flow and process flow documentation.Process optimization through eradication of inefficient processes.Business process management and improvement.Project management.UAT/Functional and environment testing framework.process reengineering.
• MS SQL and FRD, User cases. Traiceability matrix.Functional specification documents.BRD.Design document.Business elicitation documentation.Flow diagram,server module diagram.Functionality flow diagram.
• Skills of SME for Investment banking: SQL, Visio diagram, documentation. Testing, MS project.
• Analysis: Gap, AS-IS,SWOT,Cost-benefit,fishbone diagram.Project feasibility study and Feasibility estimation for IT projects.Agile,waterflow,RUP approach.
• Experience in UAT,unit,simulation and Regression testing.Automated and manual testing.Functionality testing.Data integration testing through back end methodology.
• Multiple application and enterprise connect, flow and integration through environment diagram and ecosystem diagram.
• Multiple server multiple data approach.Test pro 7.2 used .UML modelling.QTP Tool used.Testing script archive through PAT methodology.
• JRD, Elicitation meetings and document record management in DRR.Scenario management.
• Windows, ASP.NET, Web developer tools.SQL Server 2005,MS Acess 2005.MS Project 2007.HCL share point 2007.
• SDLC through content management and Content display on GUI interface and data modelling and integration from multiple
• Bug management and error resolution.Visual basic on MS Visual studio.NET and J2EE Technology,java scriptsUnix and Linux
• Security orientation. JSP Servlet diagram.
• Institutional Loan operations and OTC derivatives ops analysis.Requirement gathering through client interaction using SOM and
• ARMOR methodology, reporting template. Knowledge transfer and migration risk for 400 products across6 processes.
• Knowledge gap analysis, Managed the reports regarding the progress trackers, issue logs, Transition Risk issues, process reengineering
• Issues.Trade Reviewing matching and negotiation.
• Derivatives Documentation and settlements.Couterparts and client negotiation on trade terms.
• Liason with front office/middle office.Trade flow and TLC management.Reporting and failure analysis of failed trades.OTC derivatives,swaps and structured products.
• Trade data, Client data, and legal language data reconciliation as per ISDA regulations.Trade validation.Trade bookings.Trade workflow server.Breaks identification,validation and reporting.Intra application data verification
• Error rate and log reporting.Daily volume tracker.400 products acorss6 sub processes spread across the globe.Summit
• Application (Middle office).Trade negotiation. OTC products Risk managementSUMMARY:
• 12+ years of total work experience including 4.6 years in People - Project Management Role including and mentoring of teams.
• 8+ years of experience in business analysis, business requirements modeling and development of web Based and client/server applications extensively in business domain of BFSI.Requirement gathering for Various Projects including loan lending loan approval process and other loan services workflows.
• Strong business development acumen of managing multiple business relationships.
• CRM,SCM and financial data manager workflow including SAP integration with EDM.
• Data sourcing for 47 Vendors into MDM and redistribution management.
• Warehouse flow diagram and interface integration with other systems for data sharing.
• Enterprise management and integration including new GUI features.
• Simulation and UAT tests for the same.
• Risk management, MO risk, CCAR Model, Treasury ops,
• People and Client Management: Managed key clients and stakeholders for 11 Projects.
• Reporting and SLA Planning and reconciliation of data for Key deliverables. Managing KRA,SLA and other metrics at project level
• Data Analysis, Project Management & Performance Improvement, Product management, Capital Market Operations, Data base management.
• SCRUM methodology and sprint runs with integration for SCM and Retail domain using Agile methodology.
• SQL based development and maintenance of strategic database common to 8 projects and reporting for them to higher management for planning and change management purposes.
• Liasoned with Institutional Sales/Client support, Forex Trading, Equity Trading, Options & Hedging Strategies,FO,MO and BO for functional requirements gathering for 11 projects.
• Fixed income, valuation, securities and loan management module and trust funds ops for some ETF.
• Experience in Financial Services and Banking domains. Swift and Cash management and payments, Treasury and Mortgage experience.
• Conducted highly interactive JAD sessions with project stakeholders, subject matter experts (SME’s), users, QA analysts and project management team for requirement gathering, and identifying and resolving issues.
• Expert in business process engineering and software development life cycle, including analysis, design, development and implementation of software applications.
• Utilized Rational Clear Quest for change requests, enhancement requests, system defects and issues. Handled repository management for release, review and technical documents using Rational Clear Case to provide accountability and version control. Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers. Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• ETL Informatica and ESB experience with Data modeling, TIBCO, client/server systems, Web services, SQL, Oracle DB, PL/SQL, Doors, GUI design and other programming tools.
• Well experienced in developing Entity Relationship Diagrams (ERD), Data Flow Diagrams (DFD), Use Case Models, Activity, State, Sequence, and Collaboration Diagrams utilizing Rational Rose, MS Visio and ERWIN
• Sound understanding of Gap Analysis, User stories, Functional and Non Functional requirement management and design, User case, risk analysis and project plans.
• Extensive experience in configuring data mapping of files using Edifices Spec builder.
• Experience in documenting Use Case Specification documents, Elicitation management documents, Test Plans, Test Cases& Scenarios,test documentation management, Traceability Matrix, Business Validation, Validation Result document. Coordinated team in bringing about Business Requirements, Architectural Specifications,QA and Testing initiatives through planned changes in testing tools, Reporting status at PMO level to be implemented across projects. Version change control included. Corporate Priorities and Functional Specification and maintain Requirement Traceability Matrix. Applied Unified Modeling Language (UML) to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram.
• Involved in Data Analysis, Data Mining, Designing and Implementing Data Warehousing applications focused mainly on Querying and Reporting techniques.
• Project Quality monitor and control initiatives taken for 6 projects.
• Excellent in handling change requests by the client, handled 30 major change unplanned requests.
• Technical experience with data analysis, report design, web design, development, client interface design,interface specification use cases. and experience with different databases like Oracle, SQL server, DB2 and MS Access.
• Solid understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML).
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Experience in Risk Management process and technology reengineering, Sarbanes Oxley implementation,Valuation review process and technology, strategic sourcing, metrics and benchmarking
• Outstanding analytical, problem solving, interpersonal skills with quick learning ability. Demonstrated ability to work both in an independent and team-oriented environment with well-developed organizational & exceptional Communication skills.
• Application integration point to point, ETL, Middleware. Change management control.
• SCM, Order management, CRM linkage through informatica. Inventory management.
• AML, Compliance, regulatory reporting and mortgage, loan processing applications. Credit management and cash operations.

TECHNICAL SKILLS:

Business Skills: Business Requirements, Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, JAD/JRP Sessions, Gap Analysis and Impact

Analysis Languages: SQL, UML, J2EE, .NET, HTML, XML, and Visual Basic 5.0/6.0Packages Siebel Sales and Call Center, SCM, CRM, ALS, Rational Rose, Requisite Pro, Clear Quest, ClearCase, Mercury Test Director, Win Runner, & Load Runner.

Databases: MS Access, Oracle, DB2, MS Access, MS SQL Server Operating Systems: UNIX, Linux, Windows: 2007/2010/NT/XP, MVS, and MS-DOS

Office tools: MS Office (Word, Excel, Power Point, Outlook), MS Visio, MS Project, MS Access, and MS FrontPage

PROFESSIONAL EXPERIENCE:

Confidential, Richmond,VA

PM/Business System Analyst

Responsibilities:

• Used the Data Stage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse, database Query. Load testing.
• Experience in documenting Use Case Specification documents, Test Plans, Test Cases& Scenarios, Traceability Matrix, Business Validation, Validation Result document. Coordinated team in bringing about Business Requirements, Architectural Specifications,QA and Testing initiatives through planned changes in testing tools, Reporting status at PMO level to be implemented across projects. Version change control included. Corporate Priorities and Functional Specification and maintain Requirement Traceability Matrix. Applied Unified Modeling Language (UML) to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram.
• Involved in Data Analysis, Data Mining, Designing and Implementing Data Warehousing applications focused mainly on Querying and Reporting techniques.
• Project Scope, Business case, Project documents and analysis. Schedule and Risk.
• Involved depth understanding of Credit Risk management for the application.
• Risk management, Cash flows, CCAR modelling, BA, testing and GUI development through JAD.
• Technical and Regulatory risk assessment and built a reporting module for CCAR.
• Basel and FATCA monitoring and reporting.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• SCM, Order management, CRM linkage through informatica. Inventory management.
• Ware house distribution and systems integration.
• Database integration management and EDM flow manager.
• Business objects development and integration
• Data sourcing from Vendor systems.
• Experience in Business Intelligence Product design and have a solid understanding of development, data models, testing, and integration methodologies.
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market,Mark to Market.
• Worked with management and users to analyze specify and design business applications and document current processes for efficient operations (re-statement on general ledger, account payables and receivables and P/L) using Rational Tool (RUP).
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk.
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2014.Sharepoint Data
• Created Use Case Diagrams, Workflow and Activity Diagrams; and documented Use Case Narratives.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Loan operations and mortgage operations. Regulatory reporting and compliance.
• Experience with Defect and Change management tools preferably Rational Clear Quest and Mercury Quality Center.
• Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
• Worked as a business analyst to conduct JAD and elicitation sessions with the Private Banking, Capital Market business users and stakeholders to analyze end user objectives for Basel II Asset Classification and CRMT system and created business requirements specifications, use cases diagrams.

Environment: RUP, UML, Crystal Reports, Oracle,DB2,JIRA, SQL,Business objects, Agile, JAVA, XML,HTML, MS

Confidential

PM/Business Analyst

Responsibilities:

• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Actively participated in the resolution of Production Report issues and also the gathering and analysis of ever changing Reporting Requirements of users
• Involved in the meeting with business and marketing team for requirements gathering in definition stage.
• Gathered the reporting requirements of the Trade Position Reporting for various Secured and Unsecured Financial Products including Derivatives like Equity Swaps, FX Forwards, Currency Swaps, Interest Rate Options and Forward Rate Agreements (FRA) and formulated the Business Rules for the same in the Oracle Data Warehouse with Crystal Reports as the front end reporting tool. For a product testing Financial client
• Ensured IT security and SOX Compliance requirements are implemented in New Systems, Enhancements and Upgrades.
• Asset classes covered include Interest Rate Swaps, Credit Default Swaps, Foreign exchange swaps and Equity options.
• Ability to organize, document and track archive change request in Clear Case.Mark to market strategy.
• Worked as a Liaison between Trading and Debt Capital markets to execute Syndicated loans.Derivatives ops.
• Loan pricing management.
• Created narrative Risk Manuals and flow charts identifying internal risks to Investors Bank and Trust for Global Treasury/Global Treasury Operations.Debt and securitization and valuation.
• Monitored compliance of Global Treasury/Global Treasury Operations desks (Asset Liability Management, Broker/Dealer, Foreign Exchange, Investment Portfolio, Money Desk, Securities Lending and Wire Room Operations) with regulatory and internal requirements. Loan operations and mortgage operations. Regulatory reporting and compliance.
• Performed compliance projects as requested by Global Treasury/Global Treasury Operations Management.
• Monitored daily compliance reporting for all Global Treasury desks.
• Assisted with integration of former Investors Bank and Trust Institutional Custody Department into Wealth Management Services.
• SharePoint development and access management.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisted with preparation for internal audits, and Federal Reserve Board audits.
• Provided Anti-Money Laundering review of State Street/Investors Bank and Trust clients.Completed other compliance projects.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL
• Performed Data Validation of the data flow from the front-end to the back-end using SQL to perform the Back-end testing on the database
• Facilitated negotiations with clients (other arrangers) for the finalization of syndicated facilities (conditions, term sheet, covenants)
• Ensured dat relevant UML diagrams and Tools (Rose, RequisitePro) were used in all requirement documents e.g. Business Requirements, Functional Specifications.
• SQL query tools and business objects. Designing, modeling, developing and supporting Data Management Systems.
• Integration methodologies, IBM and informatics tools. Database integration including data models, data marts.
• Data profiling, match and reconciliation based on query through centralized matching facility.
• Facilitated the Customer in defining the high-level Functional Requirements and needs.
• Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document
• Documented approved change controls to add them into business design.

Environment: MS Visio, PowerPoint, Quality Center, Rational Requisite Professional, Rational

Confidential

Manager/Business Analyst

Responsibilities:

• Responsibilities in Portfolio Management, Risk Management, Equity, Fixed Income Securities (Treasury Securities, Corporate Bond, Municipal Bond, MBS, etc) and Derivatives (Option, Interest Rate, CDS), Analysis and Data Testing of Financial Statement.
• Assist with new implementation of Equifax Appro front-end system, and the interface to Fidelity’s ALS application.
• Functioned as the primary liaison between the research operation personnel and developer team throughout the project cycle, and assisted project manager and worked with high level management team to identify project scope, develop phase plans and schedules using RUP to assure high quality and on time project delivery
• Facilitated user interviews with stakeholders and end users to determine business requirements and needs, and designed and conducted survey among different market end users.
• Solid knowledge of key systems comprise the trading system (Order Entry, Client Account Verification, Coding, Order execution, Figuration, Comparison, Confirmation, Custodian) in PM planning and design.
• Developed the Business Process Flows to support the products and services selected in phase 3 of the project.
• Involved with the requirements, design, development, testing and administration of transactional and analytical data constructs/structures. Principal and interest workflows. Approval process within systems. Loan life cycle.
• Analyzed data using complex queries and designed solutions to data problems, resulting in accurate and thorough resolution of issues and reduction of time required for completion of the project.
• Experienced on Market Data and Data, and performed data extraction, and data manipulation with SQL.
• Strong hands on ability to use SQL to extract data from database, data analysis and data reconciliation.
• Established a Business Analysis methodology around the Rational Unified Process.
• Developed current and future Business Process Flows, and created BRD and FSD with Visio and Word.
• Helped develop Use Cases, project plans and manage scope.
• Worked extensively in agile methodology throughout the project cycle.
• Coordinated in developing Test Plan, Test Case and participated in QA testing.
• Loan Accounting and Work flow Management including reporting of Data after query.
• Conducted interviews with various business users (Financial Advisers, Risk Management Group.) to collect high level requirements and business process information using MS Visio and Word.

Environment: Agile, Rational Requisite Pro, Rational Rose, Oracle, Fidelity ALS, MS Project, MS office

Confidential

Business Analyst/PM

Responsibilities:

• Assisted with testing and implementation of ALS system changes due to requirements of BASEL II initiative.
• Worked on story board sessions and Use Case Diagrams to refine the gathered requirements.
• Prepared Business Requirments Document converted it to Functional Requirements Specification using Rational Requisite Pro
• Followed the Unified Process Methodology for iterative design.Worked on creating a hybrid model of RUP and Waterfall methodologies for software development.
• Developed a Requirement Traceability Matrix and ensured its timely update.
• Worked with Senior Project manager and other users and created Work flow diagrams using MS Visio/UML t high definition level/Program management level. worked on creating the business requirments for Data Migration from Legacy system to new Oracle database.
• Involved with the requirements, design, development, testing and administration of transactional and analytical data constructs/structures.
• Expertise in creating Data Mapping Documents and Source to Target Transformation document.
• Experience with ETL Validation and writing requirments to enhance the ETL process. Middleware coordination
• Worked on the validation and integrity of the migrated data.
• Extensively used T-SQL to write complex queries against the database and the datamarts.
• Implemented SOX procedures and guidelines in the entire requirements and project framework.
• Created Mock Up screens using MS Visio for better visualization and understanding of the software application.
• Processed the data requirements to present them as Bar charts and Pie Diagrams for financial analysts to perform trending.
• Worked on development for Reverse Mortgage Product install(MISMO).
• Document and executed user acceptance and system integration test scripts using Quality Center
• Processed requirements for creating Analytical Trending reports for Marketing and Sales.
• Conducted Joint Application Development sessions with Developers, Testing teams and Subject Matter Experts.
• Prepared a schedule and work flow for the development team using MS Project.
• Made sure dat deliverables met Business Requirements
• Involved in conducting User Acceptance Testing with prospective users.
• Wrote complex SQL queries to conduct Data Validation tests and Data Integrity tests.
• Collected information to created a Back Out Plan as a part of Production Readiness Review.
• Played an active role in Production Support and maintenance of the applicaton.
• Conducted status meetings and presided over the Changed Control Board meetings to discuss Defect, Enhancement and Database Change tickets.

Environment: MS-Project, MS-Visio, UML, Rational Requisite Pro, SQL, Oracle.

Confidential

Manager/SME/Business Analyst

Responsibilities:

• Global Equity Settlements, Trade settlements back office trade reconciliations.APAC, European, US settlements/Stock Transfers.
• Interbank settlements. Upload postings and NDF entries and settlements. Liason with broker and senior management for
• Change management and daily ops.Confirmation management and trade processing.STP and exception load
• Processing. Uploads for portfolio management.
• Intellimatch ops, development and testing. Intellimatch reconciliation.
• Product management and Client management for APAC and Europe.
• MBS, CMO and MBS Futures and options.
• Database management through SQL carried out in Singapore for 6 Months
• Simulation tests, manual and automated testing.UAT, BAT design.
• Service now, Sales force implementation. Share point access and content management
• Consulting, requirements gathering, analysis, design, UAT in Payments and liquidity, exposure limits.
• Consulting,BA and clients management in value and cross border payments.Payments system and netting.Treasury
• Management.
• Process mappings and BPM, Process design.Database management and process modeling.
• MS Projects and MS Visio appovals.SOP approvals.
• Risk management,, anti-money laundering, Regulatory compliance.
• Global client management, resource management, Time/Task studies. Test cases.
• Reconciliation utility management-Intellimatch, Upload and exceptions processing.Clearing and settlements.
• BPR and BPM projects.
• Trade capture and client services and CRM, Client management, Client query and experience management.
• Collateral, lien and Swift messages. Daily dealer and custody ops.Trade confirmations and reconciliation.
• Corporate actions, Market data management - and price data, Exchanges Data. Business intelligence
• Onsite Transitions/migration of Upload process,Equity settlements,FX tomnext rates, Corporate actions trade reset.FX
• Processed.
• Experience in Business Intelligence Product design and have a solid understanding of development, data models, testing, and integration methodologies.
• Testing validation.Functional and process automation.Financial and Resource utilization reports. TAT, SLA.Employee retention.
• Data flow and process flow documentation.Process optimization through eradication of inefficient processes.Business process management and improvement.Project management.UAT/Functional and environment testing framework.process
• Reengineering.
• MS SQL and FRD, User cases. Traiceability matrix.Functional specification documents.BRD.Design document.Business elicitation
• Documentation. Flow diagram, server module diagram. Functionality flow diagram.
• Skills of SME for Investment banking: SQL, Visio diagram, documentation. Testing, MS project.
• Analysis: Gap, AS-IS,SWOT,Cost-benefit,fishbone diagram.Project feasibility study and Feasibility estimation for IT
• Projects. Agile (SCRUM), waterflow,RUP approach.
• Experience in UAT,unit,simulation and Regression testing.Automated and manual testing.Functionality testing.Data integration
• Testing through back end methodology.
• Multiple application and enterprise connect, flow and integration through environment diagram and ecosystem diagram.
• Multiple server multiple data approach.Test pro 9.1 used .UML modelling.QTP Tool used.Testing script archive through PAT
• Methodology.
• JRD, Elicitation meetings and document record management in DRR.Scenario management.
• Windows,ASP.NET,Web developer tools.SQL Server 2005,MS Acess 2010.Tera data,Oracle,DB2.MS Project 2010.Saxo share point 2009, Big data,Informatica BA.
• SDLC through content management and Content display on GUI interface and data modelling and integration from multiple
• Bug management and error resolution.Visual basic on MS Visual studio.NET and J2EE Technology,java scriptsUnix and Linux security orientation.JSP Servlet diagram.
• Resolved the data issues between the source systems and the target system using the Mapping Documents, ETL specification documents and issue logs.
• Worked closely with different development teams to document file sizes, file processing schedules and the volumetric of each file.
• Offsite transition of Data Management - and price,exchanges data and to the team.Exchanges setup and reporting-Client holdings and compliance reporting.Performance reporting.SAP BO.
• Fund accounting and booking rules.Uploads processing. Exchange and Regulatory disclosures and Reporting, Holding disclosures,FX tomnext processing.SEC,FSA,Exchanges and regulatory reporting.US GAAP and statistical reporting.FATCA, Mifid,Basel reporting.Money laundering reporting.
• Equity research reports generation and distribution to subscribers (WLC and private clients.)
• Process improvement.Instrument setup criteria.UAT testing for application enhancement.Access management. Institutional
• Banking. Back office accounts and ledgers. Productivity management.Project management.
• Client holdings.Bank Reconciliation.Foreign currency Hedge funds and fund accounting.Business recovery and sustainability.Ops control and reporting.Exeptional load reporting.Risk management.OTC derivatives.operations and risk.Margin services.Cash and Control.Clearing and settlements.
• Contribution to product management and client acquisition.UAT testing and business requirement matrix.BPM and
• BPA&R.Audit trial leads.CRM systems.Stakeholder management.
• Data Integration across various platforms for reconciliation and reporting.TLCM and transaction reporting.
• Development rules and Manual testing for functions in reconciliation utilities.Feed back mechanism.
• Portfolio tracker and management.WLC and client management-Citibank, Barclays.
• Participation in product focus programmes.
• Worked on process enhancements and application enhancements through suggestions on the feed commander application layout.
• Improvement of the Regulatory reporting.Functional and Knowledge specialist/Subject matter expert in major areas of back ffice.FX documentation, settlements and reconciliation. Confirmations processing and payments.
• FX option confirmations.CFD on FX trade support. Trades processing-Pre and post trade for Listed products.
• Custody operations management with UBS and Citibank.Trade giveups for FX Options DVP and RVP settlements.Liason with multiple brokers. DVP/RVP Settlements processing.Giveups to multiple counterparties/brokers and custody operations.trades failed reporting.Euroclear and DTC settlments.
• Good in gathering functional specification from line department and feeding information to development team.
• Client interaction for transition and functional requirement gathering.process development.
• Document management. Transition from Singapore, pretransition documentation and hiring.
• Business requirement elicitation for Development and testing.Business documentation(BRD).Change management for application environment.Product solution and optimization.UAT test cases.User story/case creation.
• Trade Lifecycle Management and SDLC Business analysis and Requirement gathering.Trade management and processing.Options trade confirmations.Tading platforms and investment management. mentoring, delegating of authority, coaching and managing teams. Performance management and feedback, Hiring of candidates.

Confidential

Analyst Business operations

Responsibilities:

• To manage data flow on SQL Platform.
• Details to manage Index and ETF data through structured query language (SQL) Business analysis of project requirement.
• Liaison with the development and testing team.Process Documentation, Vendor management across markets through case creation. STP processes for trade processing and exceptional uploads.Confirmation management.
• Client management across markets. Complex Corporate action event and derivatives management. Liaison with Reuters,bloombeg,Factiva,Sedol master file .Liason with broker and senior management for Change management and daily ops.
• Business case testing.Operational case testing. Transaction processing and TPLC.
• Merger and Acquisition, split, reverse split management. Part of Managed Data Service (MDS) team.Product and price data servicing.Functional and operational role in product management.
• Vendor management for IDC, Bloomberg, Reuters and stock exchanges..Research and maintenance of data feed mapping specifications linked to Bloomberg BackOffice, Reuters DataScope Feeds and Corporate actions feeds.