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.
• CMS development and administration using OpenText, a system very similar to Sitecore
• Sound understanding of Object Oriented Analysis and Design OOAD and proficient in documentation of As - is and To-be business processes.
• 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)
• 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
• Extensive experience in developing data warehouse/data mart, and Business Intelligence solutions.
• 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.
• Included developing templates and/or converting or importing spreadsheet to MS Access via macros and Visual Basics programming.
• Analyze data and create reports using Excel, Pivot Tables, and Power BI
• Collaborated with the KYC Group's counterparts worldwide on global requests.
• 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 reference 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, Omaha, NE

Sr. Business Systems 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 - Cleveland OH

Sr. Business Analyst

Responsibilities:

• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Working within a growing knowledge of X12 4010 HIPAA Transaction Processing 837 I, P, D, 835, 834, 820, 270, 271, 276, 277, 278, EDI, Privacy, Security, and Medicaid.
• MMIS can handle the HIPAA transactions such as 835, 837 (P, D, I) 276, 277, 278. The Inbound and Outbound is run through JCL in batch mode.
• The core data is in MMIS Legacy system and can handle the processing of different Claims within POS in MVS Site D and AIX Box. contributed as aLifeSciencesPrincipal Consultant for around 27 complexbusinessprocess consulting
• Worked on project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Involved in business process modeling using UML through Rational Rose.
• Analyze business requirements for new system requests, system upgrades, and system replacements to ensure compatibility with IT security policies and HIPAA standards.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers. Gathered requirements and modeled the data warehouse and the underlying transactional database.
• Extensively involved in testing Trizetto Facets and mainly involved in Enrollment and Eligibility modules.
• Followed the guidelines of AGILE methodology.
• Involved in HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278.
• Produced Gap Analysis documents for HIPAA 5010 and ICD-10. Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data. Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Managed multiple NASCO and Local projects Claims processing and payments and Membership and Enrollment processing utilizing the HIPPA 4010 transaction set (270/271, 267/277, 278, 820, 834, 835, 837P, 837I, 837D.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing. Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose. Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc
• Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Developed & executed several Optimized queries in SQL on this data.

Confidential - Seattle,WA

System Analyst

Responsibilities:

• . Conducted a needs assessment and aGap Analysisto understand the shortcomings of the existing system and evaluated the benefits of the new system and generated workflows.
• Facilitate risk management workshops, recording risk and assigning risk for mitigation. Research and resolve system issues and perform application testing as necessary. Produce metrics reports from data derived from database as necessary for the project.
• Identified gaps and performed gap analysis with respect to CMS requirements
• Worked in cross-teams withBusinessand FunctionalAnalyststo identify process improvement opportunities.
• Worked on broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design
• Created and handled sales reports (Salesforce), activity reports, forecasting, referral summaries and other miscellaneous ad hoc reporting.
• Learned about E- and different types of payment methods for conducting the same.
• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Requirements gathering for enhancements to the Cargo and Passenger Revenue Accounting System based on interacting with and observing end users.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Built and oversaw the client-server based ERP system and the Amul Online ERP system to manage supply chain management
• Analyzed the system for the effectiveness of the E- commerce operations
• Responsible for all web development, E-commerce and optimization and web strategy and corporate website and self-service intranet site.
• Detailing the UML use cases for E-Commerce platform by covering the requirements of all major studio/game producers including Spore, Sims Online, Global Online Studios (GOS) and Need for Speed (NFS).
• Collaborated with ITBusinessPartners, SAP SD, SAP MM, SAP FICO consultants and other SMEs to analyze tradeoffs between requirements, usability and performance needs.
• Performed UAT, Regression testing, Sprint planning, stand up meetings and releases in SDLC.
• Participated in change management and release management activities related to the assigned functional area(s).
• Assisted with the BRD for the POS implementation project
• Successfully decommissioned and migrated staroe functionality, that includes user data migration, upstream feed set ups, Nightly data integrity checking, nightly downstream feed generation, user entitlement migration.
• Provide technical expertise as an early engagement to different modules and enhancements to access impacts and define scope.
• Generated Statements of Work for the Design and Implementation of CRM solutions based on Salesforce.com Methodology.
• Worked with other FunctionalAnalyststo develop standards and establish processes for the creation and on-going maintenance of documentation related to configuration changes.
• Served as an interface between the end users and the SAP functional consultants.
• Updateddata dictionaryuser-defined attribute definitionsin the metadata repository.
• PerformedBusinessProcess Analysisand documentedProcess Design Document (PDD)to capture the end-to-end flow of processes in Sales and Distribution.
• Updated tickets with status and sent email notifications timely and accurately

Confidential - Pleasanton, CA

System Analyst

Responsibilities:

• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Documented to-be (proposed) business process to reflect changes to self-service options
• Interviewed business (end) users to solicit and document Business Requirements (BRD), using Rational Requisite Pro
• Collaborated with Subject Matter Experts (SMEs), technical architects to outline and document high-level Functional Requirements (FRD), in compliance to the SDLC and to ensure enhancements comply with architectural and testing standards
• Conducted brainstorming and JAD sessions with select-end users and SMEs to define and document new web page mock-ups and control flows, reflecting the required changes to the employee self-service options
• Created process flow diagrams to reflect underlying business processes for existing self-service options and as well as the proposed business process flow, using MS Visio
• Collaborated with SMEs and database experts, to define and document database impact and updates to existing Entity Relationship Diagram (ERDs).
• Editor of the Monthly Shaw Update which is distributed to over 500 executive level employees of the company to keep users of the system informed of commercial loan system changes and recommended practices.
• Write SQL queries to create reports to validate transactions, identify invalid data or identify affected populations
• Write User Stories, Created Wire Frames, Layout Mocks. Very closely involved with user interface and user experience involving the Graphical Designers and also the tech team confirm feasibility.
• Analysed the data model of various legacy systems and perform gap analysis with new reports.
• Created a communication matrix, with roles, responsibilities and focus areas - for reporting weekly updates to concerned stake-holders, development and management teams
• Generated ad-hoc reports as directed, for the management team, on progress of each requirement completion, delivery time-line, test and UAT schedules etc. and provided presentations and demo’s to all levels of management and partnering groups
• Conducted weekly status meetings with the outsourced development (DEV) and QA teams to review on-going progress and assessed potential show-stoppers
• Defined a Change Request (CR) template to track and manage and prioritize all pre go-live and post go-live change requests
• Maintain and support the Commercial Loan application for the corporation.
• Managed release calendar to prioritize, track and manage project milestones

Confidential - NYC, 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.
• Developed VBA that generates custom Pivot Tables having special visual effects.
• 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
• Responsible for the administration of Corporate Enterprise Wide Business Intelligence applications and databases utilizing SQL 2005 engines, SSIS, Analysis Manager and Share Point Portal server.
• 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 education 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.