SUMMARY

• Nearly seven years of experience as Business Systems Analyst, with expertise in analysis, design, development and implementation of software applications.
• Expert knowledge and experience of SDLC processes like Waterfall, Agile (Scrum), and RUP for software enterprise initiatives.
• Experienced with Risk Management,Basel II/III Implementation, Capital Adequacy Calculations (CAR), Risk Ratings system, Credit Risk, Trading platforms and Fixed Income Products like Treasury (Bonds, Notes, and Bill),Mortgaged Backed Securities (MBS),Municipal Bonds, Corporate Bonds, Junk Bonds and Convertible Bonds.
• Wrote complex SQL queries to perform the Back End Testing of the Oracle database using SQL and UNIX shell commands.
• Hands on experience in Oracle and UNIX environment.
• Created and maintained SQL Scripts and UNIX Shell scripts to perform back - end testing on the oracle database.
• Supported UAT team with technical aspect of testing like running autosys batch jobs.
• Experience in gathering business requirements, evaluating data sources, translating requirements into specifications, application design, technical and business writing and testing various methodologies.
• Knowledge of Rational Requisite Pro and DOORS for requirement management and created traceability metrices among requirements.
• Reviewed and worked on JIRA Tickets
• Experience with facilitating workshops and meetings to define and document business training requirements for new product releases.
• Worked in cross-functional environments and acted as a point-of-contact between the management and technology team; made presentations to them regarding the requirements and project updates.
• Coordinated and conducted JAD sessions to review the progress of the project.
• Expertise in UML like class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams, as a business analysis methodology for application functionality designs using MS Visio and Rational Rose.
• Experience in performing and conducting UAT and coordinating the overall test effort.
• Experience with tools such SQL and Toad for writing and running queries and perform data analysis.
• Knowledge of GAP analysis and data mapping documents
• Experience in assisting with implementing change management and establishing traceability.
• Experience in Quality Assurance Life Cycle (QALC) aspects such as establishing project standards, writing test strategies, test plans, test cases, defect reports and developing test scripts, traceability matrices and test environments.
• Defining test cases, analyzing bugs, interaction with team members in fixing errors and User Acceptance Testing (UAT)
• Strong leadership skills
• Experience working with offshore teams.
• Understanding of concepts related to Consumer Lending, Consumer/Business Credit Cards and Consumer loans.
• Extensive experience in General Ledger, A/P, A/R, Primary Mortgage, Commercial Loan and Data Migration Applications.
• Extensive experience in development of loan processing system and mortgage using Empower system

TECHNICAL SKILLS

Methodologies: Rational Unified Process (RUP), Agile (Scrum), DOORS, Rational Requisite Pro, SDLC, Product Life Cycle Management, SWOT Analysis, GAP Analysis, RAD, Cost Effect Analysis, Use Cases, Workflow diagrams

Business Tools: Rational Rose, MS Visio, Rational Modeler

Tracking Tools: Rational Rose, ClearQuest2002, Bugzilla, Quality Center

Operating Systems: Windows 9x/NT/2000/XP, UNIX

Databases: Oracle 11g/9i/8, SQL Server 2010, MS Access 2013

Quality Assurance: Software Application Testing Life Cycle, Knowledge of automation tools, HP Quality Center

Business Applications: MS Office 2013 (Word, Excel, PowerPoint, Outlook), Macromedia Dream Weaver, Adobe Go Live, Image Ready, Photoshop Flash, Adobe Acrobat, MS Visio, MS Project, Front Page 2000, HRDW (Human Resource Data warehouse), Business Objects, MicroStrategy Business Intelligence, Axure Pro, LAWSON

Environment: s: Java, C, C++, SQL, HTML, J2EE

PROFESSIONAL EXPERIENCE

Confidential, Moorpark, CA

Sr. Business Analyst

Responsibilities:

• Actively involved in Design and Implement customization to packaged software applications (i.e. Encompass, Optimal Blue, Leads 360 etc.) supporting Retail line-of-business.
• Review & Understand packaged software capabilities and features and apply my knowledge to solutions. Closely Work with software vendors as needed.
• Executed SQL statements to check if the data integrity has been maintained.
• Worked on brokerage applications for trading, risk management and processing proprietary profitability system serving treasury security and services, commercial bank, and investment bank units.
• Followed Software Development Life Cycle using Agile (SCRUM) Methodology which is based on iterative and incremental development.
• Involved in Configuration Testing of the application across different platforms. Worked in Microsoft SharePoint to get detail requirements, plans and minute. Also used JIRA to report Bugs to the developing team
• Created and maintained SQL scripts and UNIX as a part for back-end testing on the oracle database.
• Changes in system for the eDisclosures forms as per State & Federal regulation& other regulatory authority.
• Attended JAD Sessions in order to capture Business rules around Data elements on the User Interface system
• Involved in Source Data Analysis, and designed mappings for data extraction
• Create use cases & process flow for CSR (Customer Representatives) training for web portal
• Performed data driven test for multiple scenarios with different sets of data using internal and external data sources.
• Migrated SSIS packages and SSRS reports
• Execution of Unix, Autosys Batches, retrieval of logs, identification for the source of errors
• Knowledgeable of manual execution of Autosys Batches
• Write business & functional requirements for various web portals such as Binder Portal, SLP Internal & External Portals, Member (client) Portal
• Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
• Performed GUI testing and Functionality testing manually.
• Worked and used Excel Macros as requirement template
• Good working knowledge of SQL using QMFP facility in Mainframe.
• Scheduled and Executed UNIX batch jobs using Autosys.
• Maintain system documentation. Assist in development of training materials on customization / enhancements.
• Participated in application & end-user support process. Performed other related duties as required and assigned.
• Always demonstrates behaviors which are aligned with the organization’s desired culture and values.
• Supported the re-design of the Mortgage Asset Management System.
• Conducted interviews with key business users to collect requirement & business process information for loan process including set-up Account, New Loan set-up, Escrow Analysis, Appraisal, Credit, income & Title functionalities.
• Involved in Configuration Testing of the application across different platforms. Worked in Microsoft SharePoint to get detail requirements, plans and minute. Also used JIRA to report Bugs to the developing team.
• Conducted Weekly meetings to check the progress of project.
• Comprehensively worked with requirement gathering for Enterprise reporting system using RequisitePro
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, process and revenue streams
• Experience in complete WATERFALL, AGILE/Scrum, RUP SDLC Client /server architecture providing a well-balanced understanding of business relationships, business requirements.
• Functioned as primary liaison between business line, operations, & technical areas throughout the project cycle.

Confidential, Atlanta

Business Analyst

Responsibilities:

• Involved in business analysis and project management, coordinating between the team members, addressing budget issues and creating test plans according to the business requirements.
• Maintained Functional Requirements Documents (FRD) for the Tellers functions & Operations Management applications ensuring that they are current.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Wrote SQL Queries to gather data from these MS Access Tables.
• Performed Data Analysis, created gap analysis document, and performed data quality Checking.
• Created numerous temporary, derived, permanent and volatile tables.
• Teradata SQL performance tuning.
• Work on Jira environment.
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers.
• Prepared test plans using business requirements, data mapping documents and technical specifications.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Expertise in problem solving and bug tracking using JIRA, HP ALM, Quality Center
• Worked projects on Agile and Waterfall methodologies.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
• Executed SQL statements to check if the data integrity has been maintained.
• Studied and analyzed risks associated with fixed income investment performance, including inflation risk, interest rate risk, currency risk, default risk, and liquidity risk.
• Tested UNIX shell scripts written for ETL Processes to schedule workflows on Autosys.
• Extensively used SQL queries to extract data from the database for Analytical purposes.
• Retail, lending, and operational regulatory compliance audit and monitoring reviews
• Performed GAP and Risk analysis of existing system and evaluating benefits of new system.
• Created Requirement Specification Documents after conducting Interviews with End Users, JAD Sessions and analyzed their current systems.
• Create internal reports using Dashboard and basic SQL queries in the tool to track activities of the teams.
• Performed Back-end Testing using PL/SQL for Database Validation
• Conducted functional requirement reviews and walkthrough with the Integration experts and stakeholders.
• Identified Use cases for Business Requirements and Created UML diagrams like Use Case Diagrams, Activity Diagram using MS-Visio for various stakeholders.
• Involved in Testing Autosys Jobs, that automates workflows
• Understood and worked on Fixed Income, Equities & Trade Cycle, Derivatives -- Options, Futures, Mutual Funds, Portfolio Management, Brokerage
• Assist end users and IT staff in the use of data to satisfy informational and reporting requirements and implementing and using SQL.
• Created Functional Requirement Specifications/Use Cases following the Agile Methodology using MS Word/Visio.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
• Create SQL queries to read data from databases.
• Used Teradata SQL assistance to write SQL queries for data extraction.
• Developed SQL queries, functions, stored procedures and triggers to perform the backend testing of the data
• Wrote SQL Statements to extract Data from Database to verify the output Data of the reports
• Recommended process or system changes intended to eliminate identified risks or gaps.
• Managed the change request and analyzed the impact of the change request on the application in regards to Project Plan, Project Scope and Project Schedule.
• Responsible for Back-End Testing Using SQL Commands
• Provided regular verbal and written status reports to IT management and business community; published meeting minutes and maintained project plans.
• Involved with the Quality Assurance team to develop and design test plans and test cases.
• Tested the final application for usability testing (UAT) to verify whether all the user requirements were catered to, by the application.
• Performed UAT testing along with call center managers to make sure that application meets their requirements
• Worked on ATM transaction processing/options ranging from personalized Fast Cash withdrawals to deposit automation.

Business Analyst

Responsibilities:

• Arranged walkthroughs and interviews with the Subject Matter Experts (SMEs) and other stakeholders to keep track of user requirements and thus modifying business goals when necessary. Also recorded the requirements in a format that could be easily understood by both the business and the technical groups.
• Implemented RUP within the different groups involved in the project, to configure and develop processes, standards, and procedures.
• Converted user requirements into business requirements, analyzed the same, and segregated them into high level and low level business requirements.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Assisted in integratingTableaudata into the active archives to make it readily accessible.
• Extensively used SQL to retrieve, and manipulate data in the database
• Use SQL to select the accounts with certain characteristics and to track the volumes with each processed file for a time period to create volume and functionality graphs.
• Revised the use case, collaboration, object, sequence, activity, and state diagrams using Rational Rose/MS Visio according to UML methodology.
• Responsible for Analysis and Defect Tracking using HP ALM, Bugzilla, JIRA, IBM Clear Quest.
• Developed internal risk rating methodology based on financial risk models and metrics for growth, profitability, capital, liquidity and leverage, streamlined public and private company review workflow
• Managed credit exposure associated with the banks broad range of foreign exchange, Derivatives, and Treasury Management products.
• Participated in Agile development practices and Agile software development.
• Reviewed and finalized the User Requirement Specification (URS), Functional Requirement Specification (FRS), technical specification, and detailed design documents.
• Created different traceability views to maintain the traceability of the requirements using Rational RequisitePro/DOORS.
• Involved in validation of data coming from sources outside the company using DTD.
• Finalized the requirements for building an OLAP tool for extracting data from a central legacy server and loading it into an Oracle server.
• Wrote SQL queries to query a database for the purpose of analysis.
• Used Rational Unified Process (RUP) for streamlining the team’s development activities.
• Conducted reviews with all the stakeholders to ensure that the data warehouse meets requirements and Service Level Agreements (SLA).
• Prepared documents such as project scope, project vision, project success, business requirements, functional specification, data warehouse process flow (SQL queries & crystal reports) using MS Office (Word, Excel, Visio) and Dashboards
• Expertise in Problem solving and tracking bug reports using Bug tracking tools such as ALM, JIRA
• Revised and finalized the impromptu web reports and reports in Quality Center.
• Coordinated the database validation by executing SQL queries on Oracle server.
• Used MS Project to manage schedules, deadlines, and resources.
• Acted as a liaison between the different stakeholders for facilitating communication between them.