SUMMARY

• Business Analyst with 3+ years of IT experience in financial markets, mortgage backed securities and banking.
• Develop business requirement documentation and work closely with technology partners to translate BRDs into technical specifications and ultimate development, testing and implementation of technology solutions which may be required for specific projects.
• Well versed with various methodologies like Waterfall and Agile.
• Good understanding of Data warehouse concepts and building of Meta data Repository.
• Strong SQL experience for creating ad hoc queries / reports usingjoins & aggregate functions.
• Knowledge with data warehousing tools like Informatica and Oracle.
• Excellent interpersonal, analytical, problem solving and communication skills with ability to interact with individuals at all levels. Understanding and executing resolution while maintaining strong business relationships.

TECHNICAL SKILLS

Software: Informatica, MS Visio, TOAD, SQL plus, SAS 9.4, Quality Centre, MS Excel, MS Access, MS Word, BO, and SharePoint.

Languages: SQL, T - SQL, PL/SQL, and HTML

Operating Systems: Windows XP/7 and UNIX.

Database: SQL Server and Oracle 10g/11g.

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential

Responsibilities:

• Gatheird requirements from multiple downstream systems working on multiple releases and critical & time sensitive projects.
• Developed Business Requirement Documents, Data Mapping Document, Test Plans, and other required document artifacts required by SDLC.
• Created & Managed Problem Reporting tickets in Clear quest for each release and tied it to RTMs.
• Created and maintained the Meta Data templates and worked with Data Modeler to ensure all key required attributes & information is captured and provided on a periodic basis.
• Participated in regular code reviews process to better understand of the dataflow and making sure the business logic and transformation are correctly applied.
• Extensively worked in Toad to create and execute SQL scripts for Data analysis and identifying & fixing gaps if any.
• Created reports using operational requirement in Business Object tool.
• Created test cases, test scripts for functional testing and UAT testing and resolved defects with developer as they were logged in QC.
• Developed Meta Data repository to document the Source to target mapping.
• Documented Process flow diagrams for critical projects which involved multiple exchange of information with external systems.
• Created and maintained Action and Issue List to monitor day to day activity and resolving critical issues on time.
• Point of contact for Providing Production Shakeout after implementation for each release.
• Worked on setting up Sox XL process to receive data from other systems in various formats (.xls, .csv. dat)

Environment: Oracle 10g & 11g, MS Excel, MS Word, MS Visio, Quality Center, Toad, MS Access, Clear Quest, SQL Plus, SharePoint, ETL,Business Objects.

Business Analyst

Confidential

Responsibilities:

• Acted as liaison between stakeholders, system users, external partners, and managers to gather requirements.
• Involved in gathering Business Requirements and interacted with the users, analysts, developers, PM to get a better view of the Business Processes.
• Gatheird reporting requirements (Operational and Management) and developed mock up screens that were used to create reports in Business Objects Business Intelligence tool.
• Involved in business process design and re-engineering by adopting efficient process.
• Documented the current state business process to open and maintain the accounts in PeopleSoft GL system and proposed recommendations to automate parts of the process and reduced human dependencies.
• Used MS-Visio to prepare Current State/ Future State business processes (Gap Analysis) to highlight the Gap and outline the future capabilities of the products.
• Assured timely delivery of various documents (BRD, FSD, Use Case Scenario, UAT test plan, etc.) to the development & testing teams.
• Created Traceability Matrix to ensure all requirements were being met.
• Created test cases and test scripts for user acceptance testing and maintained them in Quality Centre.
• Conducted UAT and made sure all identified defects and enhancements were logged into QC defect management module.
• Coordinated and prioritized outstanding defects and enhancement identified during UAT, and escalated the same if necessary to achieve the deadline.
• Overlooked the project binder and approvals log and ensured that all approvals and signoffs were attained as per schedule and met with the guidelines.

Environment: MS Office, MS Visio, SharePoint, Quality Center, .NET, PeopleSoft GL, (SAP)Business Objects, Oracle 11g, and SQL Plus,ETL,KYC/AML

Business Analyst

Confidential

Responsibilities:

• Worked with Front office, Service & Delivery, Credit Risk, and Compliance business stakeholders to document the requirements to be customized in the application.
• Created Current State and Future State business process flows to identify the gaps that need to be implemented in the new solution.
• Created BPI’s workflows for Credit Approval, Loan Origination, and Collateral Monitoring.
• Knowledge in regulatory reporting and credit risk management.
• Created Business Requirements, Requirement Traceability Matrix (RTM), Interface Mapping documents, and UAT test plan for the project.
• Worked with Compliance group to gather specific requirements for Customer On-boarding me.e. Prime OFAC check.
• Acted as liaison with credit risk control and reporting departments to ensure that the exposures are adequately reflected in the risk system.
• Worked with business in identifying the Business scenarios and assisted in writing system specific scripts for the User Acceptance testing.
• Supported questions from the SIT team to analyze defects and worked with the vendor for the resolution.
• Executed extensive SQL queries to validate the data migrated from the legacy system to the CME application.
• Reviewed and assessed client’s information for the establishment of new accounts. Provided guidance to Business Lines onAML/KYCrequirements.
• Liaison between traders and Compliance onAML/KYC, OFAC.
• Participated in weekly status meetings with Vendor, Business SME, Project manager to discuss issues, risk and CR’s for the project

Environment: Oracle 11g, MS Excel, MS Word, MS Visio, MS Access, SharePoint,ETL, and SQL Plus, Business Objects