SUMMARY

• 11+ years of experience as a Technical Business Analyst/ Data Analyst and hands on experience in requirements gathering, reporting, documentation, process mapping, scheduling, planning, and data analysis.
• Familiar with spinning AWS EC2 instances and performing Text Analysis in Natural Language Processing (NLP).
• Extensively worked on Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Expert in creating Risk Management Plan, User requirement Specification (URS), Functional Requirement Specification (FRS), Business Requirement Documents (BRDs).
• Proficiency in analyzing and Creating Use cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams and Navigational flow diagram and Sequence diagrams using MS Visio and Rational Rose.
• Experience in building data warehouse and business intelligence systems.
• Expertise in MS Office Suite, MS Project for Project Plan, MS Visio, Rational Rose, Rational Requisite Pro, Rally, and HP Quality Center.
• Strong T - SQL experience in creating database objects like Tables, Stored Procedures, DDL/DML Triggers, Views, Indexes, Cursors, Functions and User defined data types.
• Experienced with Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Organized many Joint Application developments (JAD) and Joint Requirement Planning sessions (JRP), Interviews, workshops and requirement Elicitation sessions, Rapid Application Development (RAD) sessions and JAM session with end-user/clients/stake holders and the development group.
• Extensively interacted with the QA Team in creation of the Test Plans, Providing Test Data, Creating Test Cases, and Issuing SRs upon detection of bugs and collecting the Test Metrics.
• Thorough knowledge in Requirement analysis, Planning, Scheduling & Tracking projects.
• Worked on large Web-based Application development and maintained account Automation functionality which includes New account opening, Client documentation, preparation, Account Maintenance and Upgrades.
• Proficient in writing SQL Queries using DDL, DML, DCL, Transition Control statements and develop stored procedures.
• Good knowledge of various RDBMS like DB2, Oracle, MS-Access and MS-SQL Server.

TECHNICAL SKILLS

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

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

Testing Tool: Rational Clear Quest, Team Foundation Server, HP Quality Center, Quick Test Professional and Load Runner

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

Business Documentation: Requirements Gathering, Business Definition Requirements, Business Processes research, analysis & documentation, Use Case Modeling & Analysis, Functional Requirements gathering, JAD/RAD/JAR Sessions, Gap analysis, SWOT analysis, ROI analysis

Operating System: Android OS, iOS, Windows 95 & 2007, NT/2000/XP, LINUX, UNIX, DOS

PROFESSIONAL EXPERIENCE

Confidential - Washington, D.C.

Business/Data Analyst

Responsibilities:

• Involved in writing functional/non-functional requirements for report rationalization and re-platforming as per inputs from the business. Involved in performing data mapping (source to target) for report attributes identified during.
• Followed agile methodology involving sprint planning/retro planning sessions with each sprint covering two weeks.
• Worked as a business/data analyst to analyze existing business objects reports to identify the usability of the same.
• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using star and snow flake Schemas.
• Designed use cases, data flow diagrams, process flows, data model and context diagrams to provide visual representation of data to the business users as well as achieve unified reporting data.
• Shared the meeting minutes created with business to get approval and sign off from the business users and key stakeholders.
• Developed python scripts to compare data across Teradata and Snowflake.
• Translation of the Clip BTEQ scripts and data from traditional Teradata/SQL to cloud using AWS services (EC2, S3, Lambda) and JSON utilizing the quantum framework.
• Learned new cloud-based services like snowflake and AWS components and involved in knowledge transition sessions.
• Resolved user queries on the data present in Data Warehouse and AWS Cloud and help the users in providing the definitions and data usage.
• Developed shell script that runs the python code, save the .csv file on EC2, S3 bucket and load the data into Amazon Redshift database.
• Worked in AWS Environment for loading data files from Legacy UNIX Systems to UNIX system.
• Performed SQL Testing on AWS Redshift databases.
• Created dashboard mockups in Excel using Pivot tables and graphs and pie charts for presenting in front of the business and also, to give an idea about potential dash boarding solution capabilities.
• Ability to use SQL Server Analysis Services SSAS in creating cubes, data sources, views, named queries, dimensions and deploying of analysis service project in SQL Servers.
• Developed Teradata SQL scripts using RANK functions to improve the query performance while pulling the data from large tables.
• Created tables, stored procedures in SQL for data manipulation and retrieval, Database Modification using SQL, PL/SQL, Stored procedures, triggers, Views in MS SQL.
• Reviewed the error & session logs in Teradata to make sure Data Quality & complete data transfer from the source to the target systems.
• Analyzed existing data to identify critical data elements, perform source to target data mapping, elicit data requirements and converted them into BRD and SRS. Performed UAT testing for designated reports involving business users.
• Created tracker to track changes to existing reports as well as to track new reports being put into production and reports to be decommissioned.

Confidential

Technical Business Data Analyst

Responsibilities:

• Developed and maintained an inventory of all Regulatory Reporting line items (RLIs) for various CCAR reports (FR Y-9C, FR Y-14A/Q/M) and worked with various work streams (Manual Process, Issue Management, Validation Rules team and Regulatory Reporting) to in corporate updates to individual RLI.
• Involved in Data Architecture, Data profiling, Data analysis, data mapping and Data architecture artifacts design.
• Managed ELDM Logical and Physical Data Models in ER Studio Repository based on the different subject area requests for integrated model.
• Migrated data from Teradata to Snowflake (AWS)
• Created data models for AWS Redshift and Hive from dimensional data models.
• Defined and documented detailed Business Requirements Document (BRD), Functional Specification Document (FSD) and Use Case Specification for front, middle and back office.
• Reviewed and analyzed various projections files from PPNR, Capital and Aggregation team to identify various models used for FR Y-14A, 9 quarterly projections
• Performed end-to-end Inter and Intra reconciliation between various CCAR Reports.
• Reviewed Federal Reserve Bank (FRB) Instructions to identify FRB requirements, and define non-technical data quality validation rules.
• Developed and documented technical Axiom pseudo logic for validation rules using Axiom conditions.
• Worked with CCAR Regulatory Subject Matter Experts (SMEs) and stakeholders to validate data quality validation / business rules and document functional requirements.
• FRB Filing Results Validation and Analysis - created manual work papers and documented validation rules results to identify data quality issues.
• Validated Rule Report Automation - Defined requirements, and test scripts to facilitate IT in creating various BI / Micro Strategy reports (Rule Execution Summary, Results Summary, and MDRM Balance Recon Report).
• Performed SIT / UAT testing for BI Reports to ensure completeness and accuracy of results and overall functionality.
• Worked closely with IT to resolve defects / inaccurate results.
• Developed Run the Bank (RTB) and Change Management Business Work Flows for Validation Rules.
• Developed and maintained various excel dashboards for tracking every validation rule for weekly reporting / metrics.

Confidential - Chicago, IL

Business Analyst/ Data Analyst

Responsibilities:

• Extensive experience in Data Analysis, database modeling and development of Entity Relationship Diagrams (ERD), SQL, Data migration, Data mapping, ETL, OLTP/OLAP.
• Created logical data model from the conceptual model using Erwin based on requirements analysis and validated the model with response to questionnaire from business analyst and its conversion into the physical data base design.
• Developed Snowflake Schemas by normalizing the dimension tables as appropriate.
• Used UNIX scripting to apply rules on the raw data within AWS.
• Used Redshift within AWS. Used Amazon s3 along with Informatica Cloud Services to load data into s3 bucket.
• Facilitated internal onsite consultant sessions to identify "As-Is" business processes and gaps (using BPMN).
• Managed general ledger close process and system financial reporting for all financial areas: Cash Management, Grants, and Accounts Payable.
• Provided support, including liaison and training, to the business to ensure overall credit risk framework and the use of tools are being applied consistently and appropriately in each business
• Compiled/Analyzed data for Government Reporting (Call Report, FR Y9C, FR Y10 & Y6)
• Analyzed and documented regulatory reporting processes to identify opportunities for process improvement, including FFIEC 101, FY-Y9C, and FR-Y14A etc.
• Re-engineering portfolio level risk management and reporting using Legal Entity and Master Agreement (in response to FSA & Dodd Frank Regulation)
• Involved with development of group's new Comprehensive Capital Analysis and Review (CCAR) planning and forecasting process
• Managed relationships with external vendors to develop real estate forecast for CCAR and annual capital planning processes
• Conducted CCAR stress tests and scenario and sensitivity analysis and assist in model validation
• Trained and mentored credit analysts in the performance of daily credit risk management responsibilities.
• Collected and record the results of the Federal Reserve CCAR "Stress Tests"
• Was responsible for senior leadership and defining control framework for Federal Reserve CCAR (Comprehensive Capital Analysis and Review), DFAST (Dodd-Frank Act Stress Test) and FDIC regulatory initiatives
• Involved in Business Process Re-engineering (BPR), Business process optimization and process mapping.
• Measured and monitored large exposure with respect to Basel III capital requirement on weekly and monthly basis
• Verified the accuracy of notional amounts as well as cash flow and maturity buckets that are uploaded into LRI.
• Extensively executed SQL Queries on Oracle and SQL server tables in order to view successful transactions of data and for validating data
• Performed loan level root cause analysis and control testing to identify appropriate risk level and determine solutions to gaps in business compliance.
• Contributed to the System Requirement Specification (SRS) Document and derived software models using UML for the System Design Specification (SDS) Document.

Confidential - Boston, MA

Business Systems Analyst

Responsibilities:

• Responsible for functions on projects of moderate to high complexity by working with business partners within multiple business functions to align technology solutions with business strategies.
• Worked on FX Trades for products like SPOT, FWD, NDF, Option, NDO & Swaps
• Performed data profiling and data mapping to map various source data systems to the new Basel database.
• Worked with Scrum Master in implementing Agile SDLC processes, including ticketing system, burn down charts, scrum sessions, and sprint and product backlogs.
• Documented and maintain requirements traceability matrix to ensure all requirements are traceable from top to bottom.
• Performed Data Analysis and Data Validation by writing complex SQL queries using Teradata SQL Assistant.
• Analyzed user stories and created narratives including screen mock-ups and wireframes.
• Documented analysis and represented them in Requirements Traceability Matrix (RTM) using Requisite Pro. Developed use cases for Story boarding and wireframes for Interfacing.
• Worked on development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation.
• Utilized Quality Center to record, track, update or close any defects related to business requirements or data quality.
• Assisted Test team in drafting test strategies and test plans to verify accurately any functionality issues and successful system integration.
• Analyzed business requirements according to System specifications and to devise a measurable Plan for the complete group.
• Using SharePoint 2016 created a new site and inserted an MS Excel Dashboard for SharePoint users.
• Conducted many informal sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Created Use Cases and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be carried out using MS Visio.
• Linked business processes to organizational objectives and perform critical path analysis.
• Utilized existing internal processes and improved those same processes for software problem identification, escalation, and resolution and facilitated project team meetings. Continually reviewed and revised project processes to ensure accurate and timely results.
• Create, update, prioritize and modify production and development issues in JIRA.
• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Created data trace map and data quality mapping documents.
• Perform Data Profiling and Data Quality.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Designed and implement report layouts according to reporting standards of the department.
• Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Identified defects and work with Quality Analysts and log the defects in HP ALM and provide the backup results. To fix the defects we will work with IT developers to resolve the defects.
• Participated in the analysis and definition of efficient, cost effective solutions, Gap Analysis, Business Impact Analysis Evaluate and reengineer existing systems, tools, methodologies, Standardization of processes (SQA, Test processes, and Configuration management).
• Was responsible for organizing the Quality Analyst (QA) walk through to explain proposed changes.
• Created Test Plans, Test Requirements, Test Hierarchy, Test Cases and Test Scripts with QA team and was involved with test execution, participated in System Testing and UAT process.
• Created user manuals and provided training to business users as part of the change management process.

Confidential

Business Analyst

Responsibilities:

• As a Business Analyst, worked on a Basel II initiative at the Corporate and Institutional banking division.
• Performed business analysis functions on credit risk business initiative to mitigate portfolio risk and improve credit operations.
• Executed Stress Scenarios to analyze impact on Risk and P&L by infusing shocks to factors of stock price, volatility, dividends and earnings move.
• Participated in the calculation of various risk metrics like Correlation, VAR. Forecast SVAR under various stressed market conditions to note expected losses.
• Involved in cross checking the performance of credit risk analysis, income documentation and property evaluation reviews on loan files. Support the creation of daily Inherent and Residual Risk reports and related risk analysis to provide transparency and insight to senior management, the Board and regulator.
• Was a single point of contact of all Risks and Issues at program level and prepared Weekly Risks and Issues report and present it in steering meeting.
• Maintained, created / Designed and monitored databases (SQL server, Oracle).
• Created test strategy/cases, execute QA testing and coordinate UAT.
• Worked on monthly review of all general ledger accounts and reconciled balance sheet accounts to ensure accuracy.
• Provided pivotal input on customers and accounts to Senior Regional Branch and Risk Management in weekly meetings to assess potential risk.
• Researched, analyzed, documented and prepared thorough statistical/regression analysis that helped forecast future behavior of key financial and operating metrics for the Comprehensive Capital Analysis and Review (CCAR) submission process.
• Assisted in the development of client's models/tools related to Comprehensive Capital Analysis and Review (CCAR) program
• Established, supported and executed processes. Delivered high quality CCAR stress testing results for credit risk, market risk.
• Lead and manage the Data Visualization and Reporting Team for the Enterprise Risk Management group.
• Monitored portfolio credit risk across various asset classes and provided market risk review on portfolio, and assisted in interest rate and foreign exchange hedging strategies
• Developed and supported applications for Risk, Forecasting and modeling support, and data warehouse.