SUMMARY:

• 7 years of Business Analysis experience, working in Federal Regulations, Finance and Accounting domain for web applications and data warehouses.
• Domain experience includes knowledge of CCAR, FRY9C, Basel III
• Strong knowledge of the Software Development Life Cycle (SDLC), Agile and Waterfall Methodology
• Expertise in Data Analysis, Data Validation and conducting Gap Analysis for data warehousing projects.
• Expertise in Change Control Management and managing requirement traceability and work in collaboration with business users, developers/admins/architects and QA team.
• Extensive knowledge of QA methodology, issue prioritization, bug tracking and reporting testing status process.
• Extensive experience in building and executing Test Plans, Test Scenarios, Test Cases according to Business, Functional and User Requirement Specifications and Writing Test Scripts and Reports.
• Extensive Knowledge of Data warehouse and Data marts testing for ETL process (Extraction, Transformation and Loading) business rules and data quality checks.

TECHNICAL SKILLS:

BA/QA Tools: - Quality Center, MS Word, MS Access, MS Excel, MS Project, MS PowerPoint.

Database: - Oracle 8i/ 9i/11g, MS SQL Server 2003, Basic SQL Server

Database Tools: - Toad, PL SQL, PL SQL DBX, Access with ODBC

BI Tools: - Cognos, SAP BI

ETL Tools: - Informatica

SDLC Methodology: - Waterfall, RUP, Agile

Documentations: - User Specifications, Functional Specification, File Specification, Process Flow, Data Flow Diagram, Feed specification, Requirement Traceability Matrix, Data Mapping Matrix, Test cases, Painpoints, Initial Load, Data Attributes, Data Dictionary, Control Report, Manual Upload etc.

PROFESSIONAL EXPERIENCE:

Confidential (NYC)

Technology: MS Access, Excel, Axiom

Responsibilities:

• Analyzed and created Business Requirements and Functional Requirements for 14Q/A Actuals for various schedules.
• Interacted with different businesses in Confidential to identify the source of the data in order to satisfy the requirements of PPNR schedules for FRY14Q and FRY14A.
• Identified and established processes for monitoring of the data qualities. Ensured the correctness and prevented invalid data values.
• Assisted in creating data repositories for compliance with data governance policies and standards.
• Created documents, mapping tables and issue list for all processes - manual and automated.
• Assisted in creating an access database, which maps the 14Q/A MDRMs to the FRY9C MDRMS using GL and SL account information.
• Compared logic and acceptance thresholds for edit check changes from FRB to Axiom implementation; communicated discrepancies to Axiom for upgrades.
• Documented the manual upload process for Axiom team for different schedules - 14Q/A.
• Involved in the meetings to identify the scope and timeline change of the data, after the recent merger and acquisition between Confidential and Citi National.
• Collaborated with developers on effort to develop Axiom reporting for schedules.
• Created different types of reports in Axiom - Control Report, Adjustment Report, Manual Upload template.
• Currently involved in testing of FRY9C reports in Axiom - Executing test cases and reporting defects.
• Established data quality process, governance, and issue tracking process tools.
• Worked with business and IT partners to remediate identified gaps using both manual and automated solutions.

Confidential

Technology: MS Access, Excel, Axiom

Responsibilities:

• Identified data to be sourced for FRY9C for multiple schedules.
• Created Business Rule requirements usingJRulesforIncome Statement and Balance Sheet using US GAAP/ IFRS and also created mockup reports in Cognos for the IT team.
• Analyzed and created requirement for the Sign Convention for different systems to understand how the signs for different Account Class change when flowing from one system to other; and how the data should be reported to the Regulators via Axiom.
• Working with the Data Sourcing team to identify the data gap attributes and the procedures/steps required mapping the data to an existing EUDA or creating a new EUDA around it.
• Created a PowerPoint presentation from an Infrastructure prospective to understand all the requirements needed to deliver an accurate Average Daily Balance Sheet for the FRY9C requirements.
• Documentation of the processes for all Manual Data feeds and in future to create a Strategic process around the manually sourced data.
• Investigated and resolved discrepancies between strategic and tactical manual reporting solutions.
• Documented Key Operating Procedures and updated Axiom rules and processes.

Confidential (CT)

Technology: Teradata, MS Access, ETL, SAP BI Reports, Bloomberg Data, Basel III

Responsibilities:.

• Interacted with the business users to gather requirements based on the CCAR Regulation for Financial Statements (using US GAAP/ IFRS), Interest Rate, Credit Ratings, FRY9C and Investment Securities.
• Maintaining Data Quality Rules for all work streams and phases of the project
• Creating Test Strategy and Test Plan document for the all the phases of the release
• Coordinating with the Treasury team in getting the Interest Rate Data from Bancware into the ERisk database and validating using the aggregation logics.
• Developed data quality metrics that identify gaps and ensure compliance with standards across the enterprise.
• Validating Data Quality rule for different Securities like Debt Securities (CDs, CMOs) and Equities
• Testing reports for different report streams like Risk Analyst, Credit Ratings, and Real Estate.
• Stress testing the whole of the process flow and ETL logics for the System Integration testing
• Managed Quality Center for adding projects, creating dashboards, creating and scheduling reports and maintaining users.
• Coordinating with the business for certifying the data and meeting the deadlines for Soft Close & Hard close reports.
• Establishes processes to continuously monitor data quality. Ensures processes are in place to proactively detect, correct, and prevent invalid data values.
• Leading the testing team for different phases of the project

Confidential

Technology: Onedata, SQL Developer, ERP, Bloomberg Terminal, Asset Management, MDM, ATOM, ETL

Responsibilities:

• Analyzed the business process, collected necessary data from users tocoordinate with implementation consultants.
• Gathering business requirements for mapping into the SAP system
• Configuring SAP Business One applications according to project plans
• Created Data Governance framework that meets data objectives for the organization.
• Executed the Data Governance process, which includes end-to-end process and data quality framework.
• Developed and executed data quality strategies in line with the business strategy and goals.
• Works with business owners to define and establish data quality rules and definitions
• Determining the migration timing and the identifying the data to be migrated
• Creating RTM and Project Plan for the team
• Understanding the requirement from the Data point of view
• Creating Data Flow Diagrams to show business users the to-be process.
• Comparing tables to analyze the data elements and identifying the common data types that can be centralized in the master table.
• Conducted End to End functional testing and UAT testing

Confidential (NYC)

Technology: Cognos Advanced, PL/SQL DBX, MS Access, Bloomberg Terminal, ETL

Responsibilities:

• Gathered Requirements and created Functional Specification documents for Client Reporting.
• Analyzing different Database sources for reporting requirement.
• Analyzing Fund and Benchmark contribution and validating results using Excel and Access
• Created mock up reports using Cognos Reporting Studio & Business Insight Advanced for different groups.
• Created report presentation for Managers and VPs for locking requirements.
• Analyzed and created repots for REIT classification.
• The report was created to analyze the performance of the REIT Index Fund by comparing it with NA REIT as the benchmark Index.
• Investigated Securities using Bloomberg Terminal.
• Created monthly reports on pricing models for the Risk Management team.
• Worked extensively on Fixed Income security types - ABS, CMOs, CMBS, Bonds, Muni’s.
• Acquired data from source systems likes Invest1 and Bloomberg into the data feed.
• Worked on sending End of the Month data based on Position Market Value for different types of Fixed Income and Equity Funds.
• Validated Analytics Constituent Roll up to its Fund and Benchmark like Standard deviation, Duration - Modified, effective, and Spread duration.
• Introduced Level 0 for Asset breakdown and restructuring of Muni Fund attributes for the Client Reporting team.

Confidential (NYC)

UAT/ QA Lead

Technology: Web based Java Application, Oracle 11g, PL/SQL Developer, ETL

Responsibilities:

• Managing and updating requirement documents.
• Analyzed Bloomberg Market Data feeds for Equity and Fixed Income related feeds
• Understood trends in financial markets and impact on credit pricing.
• Data validation and proof of concept building to address issues prior and during development.
• Performed data analyses for identifying data gaps and resolution for the complete ETL process.
• Using Cognos to create daily and monthly reports.
• Maintain excel reports that utilize VBA for excel to automate processes, such as extracting data from SQL databases, format charts and tables and distribute updated reports towebsites and email.
• Documenting High level test scenarios and test cases for the UAT phase.
• Involved in complete Testing life cycle.
• Conducting UAT meeting for user and getting Business Signoffs.
• Coordinating between various teams and groups for processing the change management requirement.

Confidential (MA)

Technology: Oracle 11g, PL/SQL Developer, ETL

Responsibilities:

• Participated in requirement gathering phase, to identify process flow, test scenarios, functional and non functional requirements.
• Analyzed data and process requirement for impact, feasibility and testability for data warehouse.
• Performed data analyses for identifying data gaps and resolution for the complete ETL process.
• Used excel to analyze and manipulate data with v/h lookups, and macros to validate data for the ETL process.
• Created use case diagrams, Activity diagrams, Sequence diagrams using MS Visio for modeling the requirements
• Developed complex reporting utilizing excel reports and business objects.
• Involved in different types of testing in the testing phase.
• Performed data validation using SQL query, access and excel and UI functional and Non Functional requirement during QA and UAT phases.

Confidential (NY)

Technology: Oracle 8i, MS Office, SQL*Plus, TOAD, SQL Server 2003

Responsibilities:

• Played an active role in gathering, analyzing and documenting the Business Requirements, the business rules and Technical Requirements from the Business Group and the Technological Group.
• Developed complex reporting utilizing Crystal Reports and SQL stored procedures.
• Documented the Business Requirement Document to get a better understanding of client’s business processes of both the projects using the agile methodology.
• Resolved open issues related to data integrity, setup issues, and transaction errors.
• Handling the Accounting module of the application which included creating documents and testing modules like General Ledger, Credit Bills, Sales Tax, Accounts Receivable/Payable
• Designed test plans and defined cases for functional, integration system, and user acceptance testing.
• Interacted with developers, system engineers, and testing teams to identify applications defects