PROFESSIONAL SUMMARY:

• Over Seven years of experience as a Financial Systems Analyst with strong understanding of Systems Requirements Gathering, Process Flow, Business Process Modeling and Systems Analysis.
• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document(SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Sound understanding of Object Oriented Analysis and Design OOAD and proficient in documentation of As - is and To-be business processes.
• 1.5 years Meter Data Management System (MDMS) consultant experience -- providing functional, technical (SQL, UNIX, PL/SQL, PERL), application testing, project management (PM) and requirements definition support
• Followed standard AML procedures and processes. Collected and examined financial statements and documentation.
• Assisting the Bank in implementing Enhanced Prudential Standards (EPS) for the International Holding Company (IHC)
• Delivers the most comprehensive suite of mission critical operational systems for all segments of the utilities industry, combining meter data management, load profiling, pricing, marketing, sales, customer care, billing, analytics and management of the networks, work force, assets, and business to business transactions.
• Creating business process model (BPM) UMLs using MS Visio for the new system, wireframes, and visual designs, which provided the overall business process and graphical user interface.
• Extensive experiences in Investment Banking projects specialized in Securities Trading (stock trading, fixed income trading, and derivatives trading), wealth management and risk management.
• Have good understanding with entire phases of Software Development Life Cycle SDLC .
• Full understanding of Rational Unified Process (RUP) using Rational Rose, Requisite Pro, Unified Modeling Language (UML), Object Modeling Technique (OMT).
• Experience in Scrum Process and thorough understanding of Extreme Programming (XP), Agile Software Development Methodology and Object Oriented Analysis (OOA).
• Experience in ISO 9000 Documentation.
• MO/Trade processing -- Commodities, FX, FX options, FX swaptions, Non-deliverable Forwards, FX Cross Currency swaps, FX rates and Treasury Funding models, BARX (Barclays electronic FX portal), Money Markets, Fixed Income
• Proficient in R Programming Language, Data extraction, Data cleaning, Data Loading, Data Transformation, Predictive Modeling and Data visualization using R and Tableau
• Experience in designing and developing web-based applications using Java, J2EE, Web Services, both SOAP/WSDL and REST.
• Hedge fund seeks to take long positions in undervalued and under-followed international equities.
• Basic understanding of Business architecture Zachman and POLDAT frameworks and Service-oriented Architecture SOA .
• Automated the entire proprietary and agency desk of Fixed Income trading which involved pricing of variety of bonds, dealing, settlement, risk management, MTM, valuation and MIS generation.
• Exposure to SAP Finance (FI) module.
• Responsible for Operation's ongoing Business Process Development through Business Process Modeling (BPMN) using UML Tool.
• Expertise in the Fed Reserve reporting, documentation, policy and procedure writing and analysis of FR Y9C and FR Y14 schedules (CCAR) e.g. Supporting Documentation and the Risk Identification process.
• Actively involved in understanding business requirements, collecting data, performing data analysis and data migration as per the business need to maintain Data Warehouse/Data Mart.
• Broad experience in investment banking, capital markets and technology, specialized professional experience in global data, securities lending, prime brokerage and fund accounting.
• Experience in Competitive Analysis, Data Analysis, Gap Analysis and understanding of ROI Analysis, P&L Analysis, SWOT Analysis, Impact Analysis and Cost-Benefit Analysis.

TECHNICAL SKILLS:

Languages / GUI: C/C++, Java, SQL

Databases: Oracle10g, PostgreSQL, DB2

Modeling Tools & Languages: Rational Rose, MS Visio, UML

Project Management Tools: MS Project

Requirement & Traceability Matrix: Rational Requisite pro, MS Excel

Change Management Tools: Rational Clear Quest, MS Office, Snag-It

Testing Tools: LinkScan, QTP, Win runner, LoadRunner

Web Technologies: HTML, CSS, XML, LAMP, AJAX

Operating Systems: MS-DOS, LINUX RH 9.x

Banking Protocols: FIX, SWIFT

Financial Terminals: Bloomberg, Reuters, Capital IQ

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

Sr. Business Systems Analyst

Responsibilities:

• Reviewed existing functionality of online trading (Stocks & ETF’s), Options (Exchange Traded), MF’s and Bonds) to prepare for ported use of myFi & CPB. Overhauled necessary components and reworked existing processes to increase performance and reliability on par with expected additional volume.
• Disciplines include documentation, policy, procedure, process and controls for Federal Reserve capital stress testing, FR Y9C, the Risk Identification process and Country Exposure reporting; SOX Compliance; Project Management; Business analysis and strategy.
• Smart Metering module provides an interface to move data back and forth between the CIS billing system and Meter Data Management Systems.
• Collaborate with Engineering, Design, Editorial and QA teams and use Fatwire CMS to seamlessly deliver content. Troubleshoot and resolve issues that can affect internal and external customers
• Assimilated the Business requirements from myFi, CPB and Benefits Access to formulate their version of Online Trading Application with their own compliances.
• Garnered insights on present framework and laid out the client centric application (Presentations).
• Legacy trading system was re-written in Java and implemented using the standard RECOM Websphere J2EE architecture to run on fully licensed and vendor-supported infrastructure in order to comply with CITMP guidelines.
• Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, Brokerage, CMBS, MBS
• Managed process improvement, business rule development, and application systems replacements for integrated biometric time collection, HR/Payroll, and financial ERP systems.
• Enterprise-wide web content management, intranet and website integration, coding CMS customizations, workflow creation, user authentication.
• Process Improvement Process Reengineering Data Mapping / Data Conversion
• Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
• Working on FED reporting’s such as RC-R, HC-R, FRY-9C, FRY9c- 14Q, FFEIC- 01 Schedules.
• Effectively partner with multiple business lines and technology teams in driving STLC process improvements and risk management systems changes impacted by the Enhanced Prudential Standards (EPS) final rule for Bank Holding Companies and Foreign Banking Organizations regulation.
• TRS on commodities (modelised for Risk, not implemented for trade processing)
• Worked on following applications Business Objects, Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management.
• Built a “restricted security” tool for the IMS group to allow for RT blocking of specific securities in the case of last minute reorganizing issues.
• Experienced in implementing presentation layer using JSF, JSP, HTML, CSS, Ajax, JQuery, Java script and servlets.
• Created various types of data visualizations using R and Tableau
• Gather requirements from multiple sources, evaluate, and provide documented analysis for review

  FX, Rates, Prime Synthetics, Credit, Muni's, Commodities, Securitized Products, Equities.

• Utilized knowledge of AML laws, including BSA, Patriot Act, and US Treasury guidelines.
• Used Advanced Query Tools like TOAD, DbVisualiser for extracting data for analysis and reporting.
• Business Process Re-engineering (Reverse Engineering) was performed on trading messages to churn out the Key-Business Logic (KBL’s).
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Created the High Level Use Case Diagram and utilized Visio 2010 to document BPM and BPD using UML format.
• Collaborated with Basel II team on credit risk analysis and issue resolution.
• Generated requirements from Feedback (from FA’s) / Users’ requirements via CRM (SFDC or Salesforce.com)
• Worked with SME’s in Europe, to finalize the layout of the new Work-flow diagram. Also, the design (wire frames) was re-formulated.
• Assisting in the implementations, support and enhancements of Front, Middle, Back Office and Accounting processing for Capital Markets systems with particular emphasis on Dodd Frank Title VII reporting, clearing, Volcker scope / impact analysis starting with clarification of registration requirements.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• 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.
• Customized Charles River functionalities (trade flows, compliance flows, blotter, manager work bench rules, broker commission rules, settlement instructions ) to match the clients work flows
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Ensured BPM solution roadmap alignment with new business process, objectives and priorities
• Managed Cross Team Collaboration and Offshore Testing team.
• Other areas include enhancements in Portfolio, Account setup, Content management, E-delivery and prepared Quick guide for CPB clients.

Confidential

Sr. Business Analyst

Responsibilities:

• After the knowledge transfer of the current environment, projects were assigned.
• As every 10 weeks there was a release, the projects were divide into three categories viz., Integration, enhancement and performance.
• Overlapping waterfall model was used for requirements gathering.
• Usability Analysis was performed on the website “workbench.mellon.com”.
• Milestones were set and Action Items were created in the Weekly Status meetings, along with the CAIR (Constraints Assumptions Issues Risks) log.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Create SQL queries using Quest Toad software to verify the correctness of data in back-end
• Captured requirements based on Basel II internal ratings based approach ( IRB ). Allowing certain extent on estimation of credit risk.
• Depending on the ISR and meetings, Scope and high level estimates were sent for approval.
• Once Scope is approved, Draft SRS master document was prepared and detailed business requirements were captured.
• RWA Calculation, reporting and Capital Adequacy norms per Intermediate Holding Companies(IHC), CCAR, FBO-EPS, Basel II/III statutes
• Leading the integration and migration of various code bases (Linux, UNIX, Microsoft .net) into TFS Company wide.
• Business Process Understanding of BPM and extensive experience leveraging technology to automate Business Processes.
• Oracle Utilities Products include Oracle Rate Management, Oracle Quotation Management, Oracle Meter Data Management, Oracle Load Analysis, and Oracle Load Profiling.
• Collection of data migration requirements, selection and definition of reporting metrics.
• Augmented a team of Data Modelers in the Brokerage Data Management group.
• Extensive experience in developing applications using Java and related technologies using WATERFALL and AGILE (SCRUM) methodologies.
• To increase productivity and reduce time for invoice tracking, planned and implemented an interface between Aquarius, a commodities trading PO application, and the in-house General Ledger application system.
• Project involved understanding the entire Electronic Fund Transfer system and the various processes related to it.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions
• Involved depth understanding of Credit Risk management for the application
• After the SRS is complete, to Baseline it, a Peer review meeting was held. Once the issues and questions raised in the Peer review meeting are logged and solved, then the SRS was sent for approval to Stakeholders.
• After approval and construction, traceability matrix was prepared and BA testing of functionalities was done in a lower environment, typically known as TEST-NR.
• Charles River (CRD) gap analysis review sessions for order management selection.
• Created test cases, test plans for Charles River compliance rules for the algorithm tools.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Objective to re-design Trading and operational flows and systems processes for maximum customer / market availability Globally for listed futures & cash equities and their derivatives
• Investigated accounting documents of all departments and ensured compliance of each transaction with the set legal and ethical standards Kept track of any suspicious money transfer, dealings or documents
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Traceability Matrix was executed in TEST-NR environment, and the results were again tested in higher environments.
• Also, helped the testers with automated testing in higher environments, QA-NR, TEST and QA.
• Finally UAT was done on the release date, and any remaining issues were either solved or deferred to next build in PROD. This was noted in the Deferred Log document.
• Lessons learned document was updated.

Confidential, NY

System Analyst

Responsibilities:

• Obtaining a detailed knowledge of the business process being followed in the project environment.
• Prepared Business Object / Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
• Responsible for performing back-end analysis and testing using ETL tool and Quest Toad
• Extracted the business requirements from the stakeholders keeping in mind their need for the application and documenting them using Rational ReqPro.
• Implementation of the Enhanced prudential standards (EPS) for the FBO for Day 1 Readiness of the newly formed Intermediate Holding Company
• For PR firm, Cerrell, developed a custom front to back end CMS (Content Management System) allowing internal users to manage their website content and change user authentication, much like in an OpenText or Sitecore system
• 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.
• Updated the organization about the current AML related industry standards, procedures, and practices
• Developed BRD documents for Securitized Inventory (CMO, ABS, MBS, and ABCP). BRD targeted new Basel II Compliance requirements.
• Involved in put or call options that protects an investor from foreign-exchange risk for a future sale or purchase of a specified foreign-equity portfolio.
• Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet.
• Coded the UI using Struts Forms and Tags. Used JavaScript for front end development.
• Designed and developed the Oracle BPM process for message tracking and message publishing on to the Topic
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
• The platform enabled institutions to estimate and stress credit risk measures and rating estimates by using scorecards/models.
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Performed timely verification of suspicious transactions and took immediate action
• Analyzed Business Requirements performed gap analysis 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 Data Process Models.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Interacted with database developers for formulating the ER diagrams and data flow diagrams.
• Created cross-functional flow chart using MS Visio.

Confidential, New York, NY

System Analyst

Responsibilities:

• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Proactively prepared RASCI Charts and Cross-Functional Flowcharts using MS Excel 2003 and MS VISIO 2003 respectively.
• Used Agile Software Development process viz. Scrum, as this was a time bound project.
• Facilitated JAD sessions with end users, development and QA teams.
• Responsible for business system analysis of customizing the BPS Risk Management product with involvement through the whole SDLC
• Authored Business Requirements Document BRD with project teams. Extracted, discussed, and refined business requirements from business users and SME’s.
• Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Assisted in creating wireframes for web interface with the GUI design team.
• Moreover, I also authored functional requirements documents FRD by interacting with development team for improving client’s legacy system.
• Conducted status report meetings with the business and the IT team on a weekly basis, as the most important aspect of the project was Data Mapping.
• Designed and developed the Insurance Order Oracle BPM Process
• Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications. Performed analysis and design projects using a systems development methodology. Worked with all levels of client staff in solution definition.
• Developed the applications using Java, J2EE, Struts, JDBC
• Assisted the development team in preparation of the CRUD Matrix.
• Exposed to SQL queries while churning out relevant information from company’s database.
• Assisted in system and user acceptance testing (UAT), free-trial demos, performed client presentations.
• Submitted change requests and worked with change request records in ClearQuest.
• Participated in entering and tracking system defects in Rational ClearQuest.

Confidential, NY, NY

Business Systems Analyst

Responsibilities:

• Worked with the business community to define business requirements and analyze the possible technical solutions.
• Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis
• Worked with the Business community, Tech Lead and 3rd party vendors in gathering their requirements and data transaction information related to OLTP, OLAP and ASP.
• Co-authored business requirements document with project teams. Extract, discuss, and refine business requirements from business users and team members.
• Facilitated and managed meeting sessions with committee of SME from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures.
• Tested the Basel Advanced Measurement Approach ( AMA ) approach which allowed Fannie Mae to take account of their operational risks in assessing capital adequacy as part of the Basel get compliant project.
• Run the SQL queries using TOAD and SQL Navigator.
• Helped with Data Mapping between the data mart and the Source Systems.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using Rational Rose requisite pro - RUP
• Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
• Worked on core java, using file operations to read system file (downloads) and to present on JSP.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Assisted project managers with the development of project schedules. Develop requirements and preliminary design for client applications. Perform analysis and design projects using a systems development methodology. Work with all levels of client staff in solution definition.
• Coordinated activities between business unit and technical staff, developing new methods, policies, and procedures to meet the business needs, and will acted as primary trainer in of the business unit as it relates to business applications.
• To organize meeting and send agenda of the meeting, draft minutes to keep all invitees of the meeting on a same page.
• Organize weekly status meetings with the team to promote open discussion of business requirements and other system functionalities.

Confidential, Indianapolis, IN

Systems Analyst

Responsibilities:

• Performed GAP Analysis to analyze the current system and worked with internal users to help define system requirements.
• Defining requirements for product control and risk management end of day feeds.
• Facilitated various JAD sessions with development architects and business leads to develop both high-level and detailed application architecture to meet business needs
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Responsible for scheduling meetings with users, SMEs and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Worked collaboratively with the User Group, User Experience Analysts, and System Analysts to help document custom and system modifications.
• Developed Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
• Produced and managed documentation on release activities to support problem resolution and post-release analysis.
• Performed GAP Analysis to analyze the current system and worked with internal users to help define system requirements.