act8fj@r.postjobfree.com

732-***-****

Summary

8+ years of experience as a Business Analyst/Business System Analyst in industry domains including Mortgage, Financial, Brokerage Accounts, Retail Banking, e-Commerce, and Supply Chain.

Strong understanding of Retail Banking, including Credit Card, Mortgage, Account Transactions, Wire Transfers, Bill Payment.

Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations.

Knowledge of Anti Money Laundering (AML), Bank Secrecy Act (BSA), Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act. Working knowledge and understanding of Suspicious Activity Reporting (SAR),and OFAC reports.

Knowledge of Teradata.

Experienced within Individual Retirement Accounts (IRA), 401K, 403(b), 457 plan, Employer Sponsored Retirement Plans (ESR), Fixed Income Investments, Capital Market, and Wealth Management domains.

Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.

Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications. Experienced in creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.

Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.

Strong Data Quality Management background performing analysis, monitoring and tuning to maintain data integrity.

Experience in creating database tables, writing stored triggers, select statements, joins, views.

Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.

Experienced in developing accurate business process requirements for Mortgage Companies, Banks, Insurance and State government projects.

Knowledge of Mortgage Loan Origination, Servicing, Closing, Loss Mitigation, Loan Modification, Appraisal, Credit, Income, and Title functionalities

Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.

Good Data Warehousing concepts including Meta data and Data Marts.

Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.

Extensive experience in project management best practices, processes, & methodologies including Waterfall, Agile, SCRUM, and Rational Unified Process (RUP).

Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.

Ability to understand current business processes and implement efficient business process.

Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.

Analysis and review of Software and Business Requirement Documents (BRD).

Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.

Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.

Team lead skills encompassing user interviews, coordination with Tech Lead, DBA's, Developers, QA/QC Analysts during the design phase.

Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.

Having application testing experience with working knowledge of automatic testing tools like Mercury Quick test Professional and Load Runner.

Experience with re-engineering, implementation and Data Governance projects.

Worked in various technologies such as XSLT, XPATH, CSS, XML, and HTML.

Experienced in IBM Security Identity and Access Management (IAM), and IBM Master Data Management (MDM) implementation.

Well versed in Process Narratives, Flow charting Techniques using UML, and Good Documentation Practices. Prepared documents to conduct user acceptance testing. Good working experience in all the sprints of the project in SCRUM.

Strong SQL knowledge for querying the database and proficient in developing External Tables, Joins, Indexes, Data Modeling, Analysis, Verification, Cleansing, Transformation, Integration, Mapping, Extraction, Load Process from multiple Data Sources.

Proficient in executing Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, Positive-Negative, and Regression testing.

Experience in writing User manual, conducting functional walkthroughs, and in performing extensive User Acceptance Testing (UAT).

Knowledge of Business Intelligence and Data warehousing tools

Articulate, confident, and able to communicate comfortably with all levels of the company.

Technical Skillset

Web Technologies HTML, DHTML, XML, CSS, XSLT, JavaScript

Software Applications MS Office, MS Project, MS Visio, MS FrontPage, Dreamweaver, Adobe PhotoShop

SDLC Methodologies Waterfall, RUP (Rational Unified Process), Agile, Scrum

Requirements Management Rational ClearCase, Requisite Pro, Use Cases, User Stories,

QA/Testing Rational Clear Quest, Team Foundation Server, HP Quality Center 11, Quick Test Professional, LoadRunner

Project Management MS Project (PERT, Gantt charts), Excel spread sheets

Operating System Windows 95 & 2007, NT/2000/XP, LINUX, UNIX, DOS

Design Tools Rational Rose, MS Visio (UML)

Database/Tools Microsoft SQL Server, Oracle 10g & 11g, PeopleSoft, TOAD, Lotus Notes, MS Access

Change Management Stakeholder Analysis, Change Classification, Prioritization, & Implementation

Education

Bachelors of Commerce, Business management and Computers

IGNOU University

Professional Experience

Farm Credit Bank of Texas – Austin, TX Jun 2014 – Present

Business System Analyst/Data Analyst

Farm Credit Bank of Texas, headquartered in Austin, Texas, is a cooperatively owned wholesale bank with assets of $18.8 billion. Together with affiliated lending cooperatives, that comprises of $25.6 billion Texas Farm Credit District, the single largest rural lending network serving Alabama, Louisiana, Mississippi, New Mexico and Texas.

My role as a Business Analyst was to continue enhancing FCB Portal for the bank vendors (brokers) related to farm mortgages. Every vendor had to log-in to different web applications to manage their Contracts/ Policies. So the management decided to build a new Client Portal integrating all these services under one web portal. Vendors would be able to log-in to FCB portal and manage their accounts at one place and perform their transactions online through Single Sign on. A part of this is also to do with an IBM implementation of MDM (Master Data Management) by collapsing redundant user accounts. The project also involves automating the farm mortgage loan insurance renewal process, and creating a new loan boarding and property tax analysis efficiencies.

Responsibilities:

Responsible for identifying scope, business and data requirements and artifacts of the project.

Interacted with cross-functional teams to facilitate gathering of business requirements.

Responsible for organizing meetings between various functional departments and our team in order to understand what data they are using, what dimensions are they grouping by, how often the reports are generated etc.

Responsible for writing FRS, URS and Logical Data Modeling Document.

Creating data models such as Logical and Physical data models using Erwin.

Performed data profiling and data modeling, and approved all final designs.

Reverse engineered from TOAD database to Erwin and generated SQL script in Erwin.

Involved in data analysis and Data mapping of existing reports to identify and document iteration and business metrics.

Responsible for understanding the functionality of the present reporting server and then assisted in the modification and design of reports to answers End Users unusual questions.

Figure out to make queries yield comparable data and then took part in the designing of queries for different DB in the Enterprise Datawarehousing.

Served as a liaison between Clients and Technical Staff to resolve any conflicts.

Analyzed Business Requirements and segregated them into high and low level Use Cases, Activity Diagrams/State Chart Diagrams and Robustness Diagram using ERwin.

Conduct JAD sessions with management, SME's, vendors, users & other stakeholders for open & pending issues.

Look at the various system (Origination, servicing system, Data Mart) and understand the transformation

Build the lineage mapping document and look at all the source to be able to document and test the transformation

Analyze how data flows from Point A to B based on line of business (farm, home loans).

Prepare data lineage mapping documentation.

Test data lineage and Prepare data lineage testing documentation.

Trace and manage all the requirements with Metadata to ensure the delivery of deliverables on time.

Worked on data quality, data organization and delivery. Conducted the FRS, URS and LDM reviews and walkthroughs with designers, developers and stakeholders. Also conducted feasibility and adaptability study.

Administered Identity and Access Management (IAM), (including password management) controls for staff and vendors assigned to department-level projects.

Developed reports to present the data broken down by the countries regulatory office and to highlight any suspicious activity that needs to be acted upon to prevent money laundering (AML) and fraud.

Worked extensively on NORKOM, the enhanced Anti - Money Laundering (AML) analysis and risk detection/management system, which enables to fight crime and create reports on the flagged transactions.

As part of MDM implementation, involved with validating and testing user accounts; validating the suspect and collapsed data; created dummy accounts to validate against the back-end and the front-end data.

Actively participated in the design and creation of quick databases to store/manipulate subsets of data in conjunction with client reports.

Actively involved in User Acceptance testing and Training of the end users.

Was involved in CCB, quality and risk management activities. Generated management reports on weekly and monthly basis.

Developed Process flow diagrams to document the existing system.

Involved in writing the Test Plan, numerous Test Cases and Test Scripts using Test Director.

Created test cases for FDR to perform Integration tests and verify the integrity of the accounts built on FDR.

Performed backend testing to check the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.

Designed and implemented basic SQL queries for QA testing and report.

Supported the reporting team in data preparation, test loads and query designing.

Performed System Integration testing, User Acceptance Testing and created test cases and test scripts.

Performed Functionality, Integration, and System Testing.

Environment: RequisitePro, Teradata SQL Assistant 7.1,Toad, Waterfall, UML, Power designer 12.5, Microsoft Excel, Ab Initio, Acquisition (internal process), MDM, Business Objects, NORKOM

H-E-B – San Antonio, TX Aug 2013 – Jun 2014

Business System Analyst

HEB Grocery Company, LP (H-E-B), is a privately held supermarket chain based in San Antonio, Texas, with more than 350 stores throughout Texas, as well as in northern Mexico.The company also operates Central Market, an upscale organic and fine foods retailer.The company has a total revenue surpassing $20 billion USD.

The Remote Dial project was originally created in order to avoid the time lag in the accounts payment. Prior to the application, stores used Fed-ex to ship copy of invoices, deposits and other memos to corporate office. This system was time consuming and many vendors were not being paid on timely basis. Remote dial project was developed in such a way that accounting department could dial into each store’s computer and retrieve all necessary documents. As a part of the ecommerce development team, my team mates and I succeeded in commercial web portal for ecommerce. As a business analyst, I was a part of the requirements gathering session and was a part till the implementation phase. Also, worked on the HEB supply chain IT project in implementing the CRTV (Consolidated returns to Vendor) initiative.

Responsibilities:

Gathered requirements from the business and technical end to develop the mainframe and the web portal backend.

Worked in agile methodology of system developement.

Php pages were developed using dreamweaver and CSS for actual web development.

Designing team was involved to develop product catalog.

SSL certification for electronic funds transactions.

Actively participated during the Production releases of the products and provided go-live support during Production deployments.

Lead and participated in multiple ongoing project meetings using iterative and Agile project methodologies.

Conducted JAD sessions with management, SME, vendors and other stakeholders for open, pending and critical issues. Sessionsfocusing on IT strategies.

Gap analysis and structured walk through of work flow with Actuaries and Underwriters to identify and fill the gap after the merger.

Problem solving skills and building a liaison between business and technical ends of the project.

Resolved system issues as they relate to production processing, report applications and system output.

Researched in determining the reporting tool, and the allocation of direct access to backend tables for real-time Ad hoc Reporting and analysis.

Played a major role indocumenting functional and technical specifications.

Assigned problems to appropriate software development team for fixes.

Performed meetings and discussions to implement technology concepts.

Created and managed project templates, use case project templates, requirement types and traceability relationships.

Performed document management using Microsoft Sharepoint.

Developing Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.

Designed SQL queries for Backend Testing and Report Generation accordingly based on the specifications.

Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using Quality Center and its modules (Requirements, Test Plan, Test lab and Defects).

Defined what data should be in the data mapping and the metadata information associated to customer data (including the documentation of business data definitions and rules).

Assisted project leader for project management and delivering projects.

As a member of production support team, I have provided on-call support to all enhancements done on production servers.

Performed Functionality, Integration, GUI, Regression, Usability and System testing.

Performedscript import and synchronized JAVA based applications with client website.

Used Quality Center to log all the test cases/scripts and generate a daily status report.

Performed testing and developed usage manual for Quick Test Professional (QTP).

Performed automated testing usingQuality Center, Business Process Testing (BPT), Quick Test Professional (QTP) or Winrunner.

Tested the Applications compatibility on different browser versions of IE, Firefox and Safari.

Involved in creating a detailed SystemTest Plans, Test Cases and Test Scripts for different modules in the Application according to the Business Requirement Documentation.

Validated system design and architecture against business requirements.

Environment: Windows NT, MS Office Professional, Agile Methodology, MS Project, MS Visio, Linux, C++, Rational Requisite Pro, Rational Rose, Rational Robot, Quick Test Pro, Test Director, WinRunner.

Daiwa Capital Markets America– New York, NY Jan 2011 – Aug 2013

Business System Analyst

Daiwa Derivatives Trading System (DDTS): The project involved in design and implementation of a global derivatives trading platform using Java front end. The application allowed traders and portfolio managers to trade multiple derivative instruments (exchange traded and OTC) with a common front end execution platform. This project entailed the development of a full-fledged front-end system to manage the various kinds of risks associated in maintaining the portfolio of assets. The portfolio comprised of fixed income securities, equities and derivatives (Equity - Options, and Fixed Derivatives - CDO, TRS, CDS). The risk analysis engine accounts for Enterprise Risk Management and Market Risk and Credit Risk for the held portfolios. The traders could assess the risk of their positions in the market using the risk analysis engine and devise hedging strategies based on the risk of the portfolio. The risk analysis engine computes the Value At Risk of the portfolio for any given period and confidence level using Historical Simulation, Duration and the Greeks. Based on the underlying asset, the application computes the intrinsic value of the options, and the trader can view the various parameters of Black Scholes model. The application generated reports and graphs to depict the risk and the positions held in the portfolio.

Responsibilities:

Trade capture & trade bookings for all coupons, assignments, innovations, unwinds, control & monitoring of the transactions & positions in the front office systems including corporate bonds, high yield & distressed bonds, emerging markets credit default swaps, interest rate swaps, ABS, MBS, CDO’s.

Worked with improving the efficiency and ease of use for user on Daiwa portal with managing Thrift Savings Plans, retirement plans 401k, 403(b), 457

Delivered innovative products like market risk repository and Pre-Run application that completely redesigned market risk operations which addressed SOX/BASEL II and audit control requirements. Increased system availability from frequent outages to 99.99% availability and highly scalable system from rigid installations.

Resolved any kind of issues related to system feeds as well as system upgrades with the IT team, worked with the project management lifecycle models, assisted in defining the business & functional requirements, SDLC, UAT, business analysis, special projects as necessary.

Made detailed research analysis & prepared a diagrammatic investment and trading process for derivatives instruments including CDS, CDS Index, CDS Options, Equity Swaps, Interest Rate Swaps, Exotic Options.

Gap analysis, coordinate & support user acceptance testing, develop & manage the UAT run book, coordinate daily UAT calls, provide regular testing status & progress update & manage testing change requests.

Worked on trade capture & trade booking issues & amendments as well as the daily PNL breaks & settlement breaks in collaboration with the settlements team & front office & sales.

Designed and implemented a production change management process from ground up that was user friendly and addressed all SOX and audit controls.

Conduct Training for the Team on Product, Processes, usage of systems and Compliance requirements like Anti Money Laundering (AML) Procedures, Identity Theft prevention and complaint handling policy & process (Fact Act).

Acted as an escalation contact for complex or sensitive client issues for the securitized products group, engaged in new design discussion and document workflow, logging of bugs and enhancements, managed entitlement requests and maintaining master user list.

Gathered requirements, created specifications and UAT plans, coordinated releases for downstream systems such as Credit Risk Management System (CRMS), General Ledger, etc.

Actively participated in establishing models in risk analysis engine as: optimization of portfolio through Black-Litterman model, calculating historical volatility and implied volatility through Black-Scholes, correlation coefficient calculation (historical and simulation), beta of portfolio for systematic risk, Greeks, VAR historical and forward looking etc.

Resolved the daily PNL breaks & settlement breaks as well as any trade capture & trade booking issues or amendments in collaboration with the settlements team & the front office & sales, assisted in FIN 46 reporting.

Participated in the logical and physical design sessions, conducted disaster recovery planning (DRP), and developed design documents.

Coordinated with various data feeds (Reuters, Bloomberg, Markit) for market data, reference data, counterparty data, and credit data; mapped them to the oracle database for credit derivatives pricing, corporate bonds, municipal bonds and analytics

Performed detailed analysis and work – flow diagrams for derivatives trading which included - preparation of market & reference data, analysis & decision support, modeling a contract, preliminary instrument setup on the application.

Liaison between stakeholder’s system users, clients and managers, software development team and the QA team to gather requirements.

Created targeted Questionnaires for SMEs to gather requirements.

Facilitated (JAD) Joint application Development sessions to identify the business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.

Involved in Requirement Scoping and analyzing high priority requirement for implementation.

Studied and analyzed competitor’s applications and brainstormed to gather effective requirements for a quality product.

Extensively used MS Visio to create Mockups, screenshots and Wireframes based on the requirements elicited for the mobile application

Created Business Requirements Document and converted them into System Requirement specifications Document.

Followed the RUP methodology right from inception to the projects transition.

Participated in Design walk-throughs with SMEs to baseline the business architecture.

Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos.

Implemented business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application. Created reports using formulas such as Vlookup, goal seek and pivot tables.

Analyzed Requirements and created Use cases, Use Case diagrams, Activity Diagrams using Enterprise Architect

Created and managed project templates, use case project templates, requirement types and traceability relationship in RequisitePro.

Coordinated with the development team, database team, data warehousing team and QA team throughout all phases in the RUP methodology.

Assisted QA Team in writing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were catered to by the application.

Coordinated with test team with Data Mapping to articulate better transfer of data and performed backend testing using SQL queries for data validation.

Archived all project documents and implemented the UCM model for activity-based configuration management using Used Rational Clear Quest for defect tracking and change management request and reported them.

Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

Environment: Rational Rose, Requisite Pro, MS-Visio, MS-Excel, Microsoft Project, Cognos 8.4, Oracle10g

M&T Securities– New York, NY Apr 2009 – Jan 2011

Business Analyst

M&T Compliance Technology (MTCT) the primary goal of MTCT was to enable surveillance of firm and client activity, support the customer identification process, and help ensure that the firm is not transacting with sanctioned entities. MTCT would also support the disclosure of firm and client holdings and trading activities, as required by laws and regulations across the jurisdictions in which the firm is active, and support assessing, monitoring and testing firm regulatory obligations and controls. Further it would also enable control and approval of employees' outside activities and interests and oversight of employee trading activity, and support regulatory and compliance documentation needs in accordance with the Bank Secrecy Act (BSA) and Anti-Money laundering (AML) compliance program.

The project encompassed various M&T applications including mutual funds, Bonds, Bond trading, Retail banking, Credit Cards, SOX, Basel lI, PCI compliance and Mortgage Applications. This project is a result of a global directive from CIOs and above. Aim was to fill the corporate compliance gaps within some of the current embedded security functions. These Security functions include provisioning user IDs (creating, deleting, and modifying entitlements), adding profiles, managing groups, & entitlement reviews.

Responsibilities:

Gathered, analyzed, refined, and interpreted business requirements Business and converted them into functional requirement specifications.

Documented business rules, understood the business need, added new Customer experience features (Update Content for Enrollment, Add Payees) and provided Screen Layout Specifications for the SRS document.

Selected the appropriate elicitation technique to efficiently identify critical requirements and prioritized requirements by conducting brainstorming sessions with the back office portfolio management and sign offs on requirement artifacts from project managers.

Determined the level of formality required and considered options for documenting and packaging requirements based on project type, priorities, and risks.

Executed two week iteration and worked with the cross-functional mobile application team to ensure that all the requirements were compliant with overall project goal and scope for mobile and web based products.

Led numerous JAD, mitigation, and negotiation sessions with key stakeholders to discuss alternate solutions for Process improvement.

Worked with streamlining Brokerage and Custody Services on company portal

Worked with the Remediation team to identify and analyze the ISA (Information Security Administration) functions to check for compliance and open CAP (Corrective Action Plan), RA (Risk Acceptance) or RE(Risk Exception) for AML (Anti Money Laundering), Bond trading and Fraud prevention applications.

Participate in knowledge transfer meetings and discussions with consumer management and BSA/AML Officer.

Worked on various credit card applications to ensure PCI compliance and perform other ISA functions (Information Security Administration).

Analyze the new regulatory requirements of Dodd Frank and Basel Accord III for Pillar 1,2 and 3 phases on Market Risk calculation, monitoring and reporting, and new implementation of Comprehensive Stress Testing.

Facilitated group meetings, one-on-one interviews, and correspondence through emails to manage change control process and to discuss the impact of change request on the project.

Conducted Gap Analysis by creating Swim lane diagrams and highlighted the differences between the Current (AS IS) environments versus the Target (TO BE) environment

Used Enterprise Architect and exercised UML methodology in creation of UML diagrams such as, Activity and Use Case, Context diagrams.

Initiated and exercised various strategies involved in website Usability, Functionality, and Compatibility testing.

Closely interacted with developers and System Architect to understand customer site navigational flow, to identify bottlenecks, enhance site navigation, and increase customer satisfaction.

Assisted the project team to enhance the Personal Loans, Credit Card, Internet Services, Mortgage Services divisions and Mortgage payments functions.

Created Test Plan document, test cases, test scripts and expected results for UAT.

Environment: RUP SDLC, Risk Management, Enterprise System, Core Banking, MS Project, MS Access, Dreamweaver, Mobile Application, MySQL database, IBM Requisite Pro.

HDFC Bank India – Hyderabad, India Jul 2007 to Mar 2009

Business System Analyst

The scope of project was to develop the core banking application for HDFC Bank India operations. Due to the myriad of advantages that comes along with core banking, the integration of various IT capabilities was critical to the success of this project. Core banking functions such as deposit accounts, loans, mortgages and payments were implemented as part of this project. The service oriented architecture of this project would enable the bank to be more strategic in offering services to its customers. The customer of HDFC bank would be able to perform transactions seamlessly from any branch within the nation and still get the same quality of service.

Responsibilities:

Involved in interviewing business area experts, asking detailed questions and carefully recording the requirements in the format so that it can be reviewed and understood by both business and technical people.

Gathered user and business requirements through interviews, surveys, prototyping and observing from account managers and User Interface of the existing system.

Worked as a liaison between technology and the business clients to improve business processes and support critical business strategies.

Determined user/business/functional requirements. Created UML diagrams including Use Case diagrams, Activity Diagrams using MS Visio and Rational Rose.

Used brainstorming and ideation techniques to derive ideas from the stakeholders.

Gathered requirements by using interviews, observation, JAD, brainstorming sessions, and documents analysis.

Collected Business Requirements and converted them into Systems Requirement specifications.

Developed non-functional requirements and documented them as Business Rules, Quality attributes, constraints documents.

Involved in Data Warehousing, Data Mapping integrations.

Utilized RUP to configure and develop process, standards, and procedures.

Validated technical designs created by IT developers against functional specifications.

Environments: Windows NT/2000, MS SQL Server, Rational Unified Process (RUP), Facets 4.21, UML, Rational Rose, Mercury Test Director and MS Office Tools.

Contact this candidate