Summary:

• Over 9 years of professional experience as a Sr. Business Systems Analyst with excellent understanding, analyzing, and documenting Business Requirements, Functional Specifications, Business Process Flow, Business Process Mapping, and Modeling.
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.
• Fund accounting has been applied to investment accounting, portfolio accounting or securities accounting.
• Strong knowledge of Financial Industry including Investment Banking, Finance industry including Credit Cards with emphasis on Business Requirements and Functional Requirements.
• Validated / updated documents per Basel III standards and performed regression testing of the Basel EAD model for the entire OTC derivatives for the new regulatory capital models.
• Good comfort level with Capital Markets, Money markets, Trading Systems, Derivatives Strong in Options , Equities, Fixed Income, US government Treasury Securities T-Bills, T-Bonds and T-Notes , Municipal Bonds, Stocks Trading Cycle, Margin Requirement, Mark to Market, Hedge Funds.
• Experience gathering business requirements for integration points including downstream/upstream interface requirements.
• Used MS Sharepoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents
• Worked on project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficiency in business requirement gathering techniques, conducting JAD and RAD sessions and meetings.
• Excellent oral and written communication skills, interpersonal skills, and analytical skills.

Business Tool Skills:

• Data Governance and Regulatory Reporting
• SAS risk data modeling for Risk parameters
• Data Analysis with excellent SQL and PL SQL skills
• SQL PLUS, SQL LOADER, Hadoop, ETL
• Teradata
• Solid knowledge of BASEL II, Basel III, Risk Calculation, Risk Management and regulatory compliance
• Data architect and data modeling for various reports
• OFSAA, Regulatory capital,
• OBIEE 10g and 11g, Informatica, Dashboards.
• Wholesale Power one and SAS Retail Risk management
• SQL/ PLSQL/MSSQL based Developer for data warehousing.
• Expert in SQLs, TOAD and Oracle Database applications.
• OFSAA tool for BASEL II and III calculations.
• OBIEE Tool - Oracle Business intelligence for Reporting, Dashboard
• Clarity systems, Share point management.
• MQC Mercury quality center HPQC
• Solid Knowledge of Microsoft Windows, Microsoft office programs like Word, Excel /XML, PowerPoint, Basics, C , Visio, MS Project, Visual Basics.
• Data Repository and Data Quality
• Technology expertise in systems and applications
• Bridge the gap between business and functional side to IT technology and platform

Professional Experience

Confidential

Sr. Business Analyst/Data Analyst/Application Developer

Responsibilities:

• Gathered requirements using Use Case analysis and Developed system requirements SFD, HLD, SRD from business requirements BRD and architect approach documents.
• Created requirements and design phase artifacts using RequisitePro.
• Analyzed and maintained business and systems requirements over SOA based applications.
• Performed the data mapping for the new Web services elements between Front end, Middleware Back end systems.
• Perform analysis and determination of Swift statements that are not current during the drain cycle then requesting of the Business Partner to contact the applicable Bank.
• Participated Agile-Scrum story writing secessions and wrote executable stories for the projects assigned.
• Participated in Iteration planning secessions and added the stories Technical tasks in Jira.
• Acted as liaison between Requirements Engineers, Developers Testing Team to determine RTM in traceability.
• Used UNIX to check the Data marts, Tables and Updates made to the tables.
• Writing advanced SQL Queries to query the data from Data marts and Landings to verify the changes has been made.
• Extensively used MS SharePoint a content management platform, for managing content across the organization within a shared repository.
• Had exposure to Lean Sigma within the project scope.
• Worked on bond options, interest rate options, stock market index options and simply index options.
• Perform Data analysis, Backend Database testing, Data Modeling and Developing SQL Queries to solve problems and meet user's need for Database management in Data Warehouse.
• Wholesale ECRIS, IRR, Enterprise Risk, Enterprise Capital Management data sets
• Enterprise provisioning standards, metadata and lineage
• Process controls and data quality
• Data Migration from source to Hadoop and to ETL staging
• CCAR - Post Stress test capital ratio
• Regulatory capital Calculations
• Data migration from Source to ETL stage
• Creating procedures for forecasting modeling based regulatory requirement.
• Creating required functions and integrating into procedure.
• Creating tables, loading data into tables
• Worked on data modelling and produced data mapping and data definition documentation
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Actively participated Functional, System and User Acceptance testing on all builds and supervised releases to ensure system / functionality integrity.
• Data quality check for performed migration or data load.
• Running procedure and VAPS to calculate derived values in DRV tables.
• Debugging codes and provide fixes to the procedure or function.

Confidential

Sr. Business Analyst SME

Responsibilities:

• Develop and review Business Requirement Documents BRDs , Functional Requirements document FRDs and other documents as part of the project life cycle.
• Develop business and functional requirements from stake holders and legacy code bases.
• Participate in meetings with the appropriate subject matter experts to receive specifics on requirements
• Ensure that high-level business requirements have been decomposed properly into useable functional requirements
• Used SharePoint for storing and versioning the requirement and project management artifacts.
• Involved in providing online training and assistant to members in Foreign Payment, SWIFT, Nostro Reconciliations, Fund Reconciliations, SWIFT Messaging and Project Management.
• Experience working with secure messaging service like SWIFT.
• Process Modeling Sessions JAD Workshops Lead efforts in identifying Analyzing, defining, documenting and translating High-level business requirements into clearly articulated, detailed functional specifications, Lead efforts in Creation of Business Process Flow Diagrams.
• Designed the project development plan based on Agile methodology of SDLC.
• Perform analysis to determine and verify business requirements and functional design
• Maintain issues lists, including minutes from design meetings
• Document functional specifications and SDLC required artifacts
• Develop and execute test plans that will ensure business requirements have been met
• Develop SQL scripts to identify gaps between legacy and current applications
• Balance the needs and foster a relationship between the business and the technology areas
• Create flow diagrams, structure charts, and other types of system or process representations
• As appropriate, utilize design tools to create mock screens and prototypes
• Assist in the organization and delivery of presentations
• Utilize standard processes, design and testing tools throughout project development life cycle
• Ensure deliverables are being met on a timely basis

Confidential

Sr. Business Analyst

Responsibilities:

• Defining Business Information requirement using Agile Methodology.
• Interact with the Business team for Requirement Elicitation Validation
• Business Data Requirement Documentation
• Define Business Definitions Derivation Logic for Data elements
• Work with the Technology teams and guide them on core domain concepts Regulatory guidelines
• Worked on data Migration from EDW database to TERADATA.
• Used agile methodology for logic implementation for Mortgage Banking attributes.
• Involved in JAD sessions for defining logic and process.
• Prepared data lineage and data mapping documents
• Tested data and validated data from EDW to Teradata Migration.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Work with Microsoft SharePoint and Enterprise bank tools to record and track data warehouse project cost estimates and respond to technical questions from project team.
• Tested clearing and settlement flows using SWIFT codes between the clearing house and the bank .
• Works directly with the project manager, technical resources, and partners to best support business needs.
• Gathers, manages, and maintains business requirements.
• Identifies, analyzes, and translates business needs into functional specifications
• Contributes to and/or reviews the technical design to verify that it meets requirements and business needs
• Provide direction for and support to testing by collaborating with the quality assurance team and with user acceptance testing participants.
• Applies and executes standard business systems analysis and system development theories, concepts and techniques and assists in the development and maintenance of standards and procedures.
• Escalates issues or decisions that have cost or schedule impacts.
• Assesses business scope risk, potential severity, probability and strategy.

Confidential

Sr. Business Analyst/Data Analyst

• Development of wholesale and retail models credit cards, mortgages and personal loans for Basel II regulatory compliance through A-IRB approach.
• Directly reported to higher level stakeholders Sr. VP and CIO
• Writing SQL Procedures for entire program and its functions.
• Wrote SQL queries for data validation on the backend systems and used various tools like TOAD DBVisualizer for DBMS Oracle .
• Working with Databases DB2, Oracle DM, SQL Server for Database testing and maintenance.
• Owned 90 of PNC Source systems as Data Analyst.
• Calculated wholesale and retail capital using OFSAA.
• Provided support to Business for Query writing and in Data analysis.
• As a Data analyst, worked on automating all source systems for Data Quality Check QRM .
• As data Analyst, I was Responsible for testing for my source system in each release.
• Creating tables and columns for each source systems.
• Creating filters and joining criteria for tables.
• Coding logics for balance fields calculations and related attributes.
• Coding transformations and creating procedures for business fields according to requirements.
• Data preparation and manipulation involving exclusion and default criteria, merging monthly datasets as well as application / behavior scores
• Estimation of risk parameters PD logistic modeling , EAD and LGD for calculating risk-weighted assets and minimum capital requirements
• Utilized Agile Unified Process AUP to configure and develop process, standards, and procedures.
• Data quality and data validation using OFSAA
• Delivering the results to model validation team and responding to all technical and business related queries, till the model was approved for Basel II implementation.
• Implementation of Basel II wholesale and retail models after validation and approval to compute monthly minimum capital requirement

Responsibilities:

• As a business analyst interpretation and Implementation of Basel II regulatory rules and production support. The impact of required capital changes on loan pricing interest rate risk will be considered and updated in the system. Updating the Loan Origination System will allow users to complete their loan applications, which in turn would be gathered and verified by the system to allow the application to undergo the loan application, processing, underwriting and closing processes.
• Fully responsible and lead developer for Data Compare Tool, This will be used for internal purpose as well as by Federal Financial Regulators for Basel Program. Business and Regulators have approved this tool as standard tool for data quality check.
• Implementing the BASEL II process to set project development standards and develop the system iteratively
• Capital calculations for wholesale and Retail exposures using OFSAA.
• Support BASEL III architecture with Liquidity Ratio, Leverage ratios, VaR value at risk and CVA Credit Valuation adjustment
• Interacting with the users and internal stakeholders to gather requirements, analyzed and documented the requirements
• Participating in gathering user requirements, developing Functional and Non-Functional Requirements Specifications
• Participated in meetings to establish and enforce SharePoint best practices and standards manage proper security group naming conventions security assignment processes
• Responsible for installation and configuration of the SharePoint Server 2007 along with Office 2007 and worked on Site designing using SharePoint Designer 2007.
• Monitor daily activities of confirmations via SWIFT for Banks, Corporation and Fund Managers.
• Experienced in Cash Flow Forecasting, capital budgeting and SWIFT messaging products
• Worked on counterparty stream on CDS credit default swaps , IR derivatives, foreign exchange, OTC, Repo, Reverse Repo, Inside Trading and Trading and investment part of counterparty for Basel III changes.
• Met with subject matter experts, asked detailed questions and documented the requirements in a format that can be reviewed and understood by both business and technical people
• Created Business Requirement Document BRD , Functional Requirement Specification FRS document, and Traceability Matrix document for system application development
• Developed Test Plans and Test Cases
• Prepared Data lineage document and Data validation
• I was responsible for filling Defect in Mercury Quality center HP QC as Data analyst.
• Used Rational Rose to generate various UML Diagrams like Activity Diagrams, Sequence diagrams and Class diagrams for a clear understanding of the requirements by the development team
• Worked extensively with SMEs in understanding and documenting their requirements pertaining to Loan Origination
• Ensured that the modifications suggested by the users were incorporated into the application
• Performed Stress testing to test the basic functionality of the application
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in Requisite Pro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Created Project Initiation Document PID and defined the scope for an over-arching Basel II Readiness project, to encompass all other Basel II projects within the enterprise
• Took lead role in creating functional specification document for FFIEC 101 reports
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
• Created Technical specifications for the Business Objects Reporting Applications.
• Generated reports through Business Objects and further analyzed data through Excel Used Pivot tables, V-lookups and Offset functions in order to quickly and effectively generate actionable and insightful analysis
• Conducted Functional Walkthroughs, User Acceptance Testing UAT , and supervised the development of User Manuals for customers.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational Clear Quest.

Confidential

Business Analyst/Asst. Project Manager

Responsibilities:

• Reviewed functional and non-functional system requirements and constructed a conceptual design and detailed designs that align processes and technologies to achieve business objectives.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents BRD
• Worked with data quality governance teams to ensure each work-stream and project within the Basel II framework adhered to strict data quality and maintenance standards.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Created Project Initiation Document PID and defined the scope for an over-arching Basel II Readiness project, to encompass all other Basel II projects within the enterprise
• Took lead role in creating functional specification document for FFIEC 101 reports
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
• Writing advanced SQL Queries to query the data from Data marts and Landings to verify the changes has been made.
• Exposure to the concept of message feeds SWIFT in regards to cash and position.
• Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Involved in writing SQL queries and stored procedures using Query Analyzer and matched the results retrieved from the batch log files
• Created Technical specifications for the Business Objects Reporting Applications.
• Generated reports through Business Objects and further analyzed data through Excel Used Pivot tables, Vlookups and Offset functions in order to quickly and effectively generate actionable and insightful analysis
• Conducted Functional Walkthroughs, User Acceptance Testing UAT , and supervised the development of User Manuals for customers.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Involved in setting up different configuration environment for compatibility testing and manual testing.

Confidential

Business Analyst

Responsibilities:

• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system Requirements, design and configuration set-up.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Performed data analysis and ran various SQL queries to critically evaluated test results
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Designed and developed Project document templates based on SDLC methodology.
• Established a Business Analysis methodology around the Agile methodology.
• Apply UML notations and methodology in developing models that accurately represent the business process reengineering and workflows and clearly communicate them to the stakeholders.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Organized and facilitated JAD sessions as required with fellow Analysts, decision makers, users, key member s from the development team, system architect thereby developed the vision/scope of the system.
• Tested applications in different environments production, UAT .
• Involved in full life cycle of Business Objects reporting Application.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Worked with developers to make sure that they understood the Use Cases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Modeled requirements, managed communicated requirements throughout the project life cycle, performed GAP and Impact Analysis against requirements specifications to determine fit.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.