SUMMARY:

• With more than 12 years of significant contribution in Business System Analysis and data analysis across Banking and Finance industries with a focus to design, develop and implement business process and system solutions.
• I have an exceptional ability to build productive relationships across the board, in functional and technical disciplines with expertise in project deliverables.
• Advanced experience in capturing Business Requirements (BRD) and Functional Requirements (FS) working with Subject Matter Experts (SMEs), Business Users and Stakeholders
• Captured workflow and process flow along in documentation
• Experience in conducting Joint Application Design (JAD) session, Rapid Application Development (RAD) session.
• Developed software to be used for web - based, mobile and client/server applications
• Experience in Star Schema data organization dealing with Dimensions, high grain Fact Tables, Aggregate Tables, Surrogate Keys, Measures, and Slowly Changing Dimensions (SCDs)
• Good experience in writing SQL queries utilizing Aggregate Functions, Joins, and other techniques to perform a variety of CRUD functions manipulating and extracting data. To be used by stakeholders
• Created detailed Use Cases with components such as, Main path, Exception paths and Alternate paths - with a heavy emphasis on analysis
• Proficient in creating UML diagrams such as Use Case Diagrams, Sequence Diagrams, Activity Diagrams and Class Diagrams.
• Utilizing Toad Data point to perform data analysis and create data mapping documents for IT to implementation.
• Provide Improved Logics to be implemented by IT for Business Uses to generate accurate reports.
• Possess experience in creating Source to Target Mapping (STM) documents for mass data migrations
• Experienced in Collateral management, Collateral Financing and Custody and Clearing.
• Experience working with a wide array of SDLC methodologies such as Rational Unified Process (RUP), Agile Scrum and Waterfall - usually dealing with a mix of the above methodologies
• Managed Business Requirement Traceability by utilizing tools such as Traceability Trees and Traceability Matrixes with Req. Pro - a Rational Suites Tool
• Created AS IS and TO BE documents and performing Gap Analysis to provide enhancements /new solution.
• Excellent working knowledge in Rational Requisite Pro, Clear Quest and MS Suite.
• Strong knowledge of AML/BSA law (Anti money laundering /Bank Secrecy act) which also has KYC, CDD
• Extensive knowledge in CCAR, 5G liquidity reporting (2052a and b).
• Implemented business logic, Data Lineage mapping and traceability for Dodd Frank Regulatory reporting: (FRY14 Ms, Qs and As, also quarterly call reports (FFIEC031, FFIEC041).
• User acceptance testing - planning and execution
• Integration testing and regression testing
• Development of test plan and test cases
• Prototype development and testing
• Defect Tracking, performance management and asset management
• Business case and feasibility study
• Scope and project definition, Gap and cost-benefit analysis
• Business process analysis, technology architecture analysis
• Requirement gathering and documentation
• Requirements management and change control
• Use case creation, data modeling, data mapping
• Implementation and release planning

TECHNICAL SKILLS:

Req. Management Tools: Rational Requisite Pro & Enterprise Architect, MS Project, excel, Share Point, JIRA, HP ALM

Modeling Tools: MS Visio, Enterprise Architect

Processes/Technologies: Waterfall, Rational Unified Process (RUP), Agile, Business Objects, Crystal Reports, Use Cases Workflow & UML

Software: MS Word, MS Excel, MS PowerPoint, MS Access, Razor SQL, TOAD, SQL Server, Data Warehousing Solutions, Oracle Data Management Solutions etc.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Systems/ Data Analyst

Responsibilities:

• working closely with business teams and 3rd party stakeholders.
• Working on systems requirements and system interface requirements.
• Liaising with cross functional teams within the team and external teams (Offshore)
• Documenting ETL specifications and Data Mapping documentation.
• Performing Data analysis and data profiling using (SQL, Excel)
• Working with various on updates on different stages of a SDLC of a project and updating the JIRA board and also generating a daily update report to be provided the executive teams.
• Performing impact analysis on upstream and downstream systems which are dependent on certain Data Marts.
• Creating ad-hoc request reports for multiple teams for reporting purposes.

Confidential, Walnut Creek, CA

Senior Data Analyst

Responsibilities:

• Create and maintain Functional Specifications (FRD) and also DDD Detail design document.
• Work with business and the information gathered to create data mapping document which has (source tables / fields and target tables/ fields) for IT to implement for 5G reporting.
• Writing simple to complex SQL syntaxes to generate customized reports requested by Business Stakeholders. And other technology teams to use for their implementations.
• Experience in Data Lineage using Excel.
• Perform a thorough Data profiling using EXCEL and provide recommendations to Business for robust solutions that makes it convenience for business to access data to be extracted for reporting purposes.
• Created multiple Schemas and views for efficient data analysis.
• Create data mapping documents by performing an end to end data analysis using Toad for oracle
• Work with business stakeholders to perform a thorough gap analysis.
• Identified and facilitated meetings with multiple Lines of Business (LOB) to correctly identify if the data that is in the repositories is enough to report on.
• Organize and facilitate meetings with the management and the development team, conducting requirements gathering sessions with the purpose of defining the functional, business and system requirements.
• Write clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret and design and develop the application with minimum guidance.
• Conduct GAP analysis and created AS- IS and TO- BE workflow to better understand the mechanics of the existing system and future system also for Analysis to identify key areas of concern and addressed them with the Business team.
• Work with different business teams within Confidential to create control documentation for audit purposes pertaining the regulatory reporting.
• Conduct Impact Analysis to provide data and information to the business on how the new changes would impact the upstream and downstream systems.

Confidential, San Ramon, CA

Business/Data analyst

Responsibilities:

• Created and maintained Business requirements document (BRD), USE Case Specifications, and Functional Specifications (FRD).
• Work with business and the information gathered to create data mapping document which has (source tables / fields and target tables/ fields) for IT to implement for 14Q, 14M, and for 5G reporting.
• Writing simple to complex SQL syntaxes to generate customized reports requested by Business Stakeholders.
• Work with Business to identify Key Data Elements for new report generation.
• Work with business stakeholders to implement new requirements provided by FRB to be implemented for next report release. And coordinate with IT /QA to for them to be implemented and test before it gets submitted to FRB.
• Work with IT / DEVOPS to identify new source system and how it can be brought into EDW for data to be available for other reporting purposes.
• Experience in Data Lineage using Excel.
• Experience in creating Data Governance Policies, Business Glossary, Data Dictionary, Data, Metadata, Data Lineage, and Data Quality Rules. Working closely with the data quality team and data stewards.
• Perform a thorough Data profiling using EXCEL and provide recommendations to Business for robust solutions that makes it convenience for business to access data to be extracted for reporting purposes.
• Get input from high-level business concepts and discussions with project stakeholders and was responsible for the creation and maintenance of documentation required for a successful development effort.
• Applied technical skills in systems and data analysis to provide a high level of detail in requirements documentation.
• Created multiple Schemas and views for efficient data analysis.
• Create data mapping documents by performing an end to end data analysis using Toad Data Point.
• Worked with business stakeholders to perform a thorough gap analysis.
• Created data models to be implemented in UAT and Production Environment.
• Created and track defect tickets in the Cherwell system, and Jira for development purposes for implementation in Sprints.
• Work with key business uses to identify between Credit and Liquidity Facilities and provide impact analysis on how it Impacts US LCR, EU LCR, IFRS reporting.
• Work with Business and IT teams to identify if the logics that currently exist in production and make recommendation to correct the issues.
• Identified and facilitated meetings with multiple Lines of Business (LOB) to correctly identify if the data that is in the repositories is enough to report on.
• Work with the IT teams to find and fix production related issues.
• Organize and facilitate meetings with the management and the development team, conducting requirements gathering sessions with the purpose of defining the functional, business and system requirements.
• Write clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret and design and develop the application with minimum guidance.
• Utilize Toad Datapoint for writing and executing SQL queries to fetch data.
• Conduct GAP analysis and created AS- IS and TO- BE workflow to better understand the mechanics of the existing system and future system also for Analysis to identify key areas of concern and addressed them with the Business team.
• Creating user manual for new systems getting implemented within the organization.
• Work with different business teams within Confidential to create control documentation for audit purposes pertaining the regulatory reporting.
• Work with business team (ALMT) to update the 5G reporting decision tree.
• Conduct Impact Analysis to provide data and information to the business on how the new changes would impact the upstream and downstream systems.
• Work with (Risk, Finance and Reg Reporting) teams to get their inputs on analysis that is done to see if it has any impact on their reports.
• Implemented Tableau into UAT environment and created adhoc reports for presentation to senior leadership.
• Analyze multiple source systems (TSYS, IMPACS, IMOD, ST). to identify which accounts, need to follow FDIC guidelines.

Confidential, San Francisco, CA

Data Analyst/ Business Systems

Responsibilities:

• Created and maintained Business requirements document (BRD), USE Case Specifications, Functional Specifications (FRD), Test Cases for UAT.
• Used data blending feature in tableau and converting metric data into tableau reports for different Lines of Business. root cause analysis and remediation as part of the data lineage efforts.
• Got input from high-level business concepts and discussions with project stakeholders and was responsible for the creation and maintenance of documentation required for a successful development effort.
• Applied technical skills in systems and data analysis to provide a high level of detail in requirements documentation.
• Created multiple Schemas and views for efficient data analysis.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling
• Worked with the IT teams to find and fix production related issues.
• Organized and facilitated meetings with the management and the development team, conducting requirements gathering sessions with the purpose of defining the functional business and system requirements.
• Performing sanity checks on new enhancements in UAT environment before promoting the codes into production
• Conducted GAP analysis and created AS- IS and TO- BE workflow to better understand the mechanics of the existing system and future system also for Analysis to identify key areas of concern and addressed them with the Business team.
• Created knowledgebase for new items.
• Creating and handling work request daily.
• Creating user manual for new systems getting implemented within the organization.
• Worked with different business teams within Confidential to create control documentation for audit purposes pertaining the regulatory reporting.
• Working with the business to layout a better understanding of multiple process flows within the EPM (Enterprise Process Management) for different streams of data that is received from the sources and how the files and/or documents are converted to the standard laid out within the flow diagram and eventually getting consumed by different business entities within Confidential .
• Worked with the QA team to create Test plan and test cases for ongoing projects.

Confidential, San Francisco, Ca

Business System Consultant

Responsibilities:

• Extensive use of MS SQL and Razor SQL for writing queries to retrieve data and perform various kinds of analysis and validations.
• Applied technical skills in systems and data analysis to provide a high level of detail in requirements documentation.
• Ran SQL simple to complex queries to analyze and evaluate data.
• Created multiple Schemas and views for efficient data analysis.
• Worked with the IT teams to find and fix production related issues.
• Worked with the development team to provide and get updates on pending issues and fixes which need to be deployed into different environments.
• Performing sanity checks on new enhancements in UAT environment before promoting the codes into production.
• Created knowledgebase for new items.
• Creating and handling work request daily.
• Creating user manual for new systems getting implemented within the organization.

Confidential, San Leandro, CA

Business Data Analyst

Responsibilities:

• Extensive use of oracle SQL for writing queries to retrieve data and perform various kinds of analysis and validations.
• Applied technical skills around systems and data analysis to provide a high level of detail in requirements documentation.
• Ran SQL simple to complex queries to analyze and evaluate data.
• Created multiple Schemas and views for efficient data analysis.
• Initiated monthly maintenance for Reg W, Reg O and CAR CPE.
• Organized and facilitated meetings with the management and the development team, conducting requirements gathering sessions with the purpose of defining the functional business and system requirements.
• Worked with the product team to clearly derive Use Cases.
• Wrote clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret and design and develop the application with minimum guidance.
• Conducted weekly meetings to update the business team and tech on the ongoing issues and resolved issues. Also raising new issues with tech and logging them in QC ALM for tech team to get access to the issues and tracking them as to when they would go as enhancements and defects fixes in the following releases also helped the business in prioritizing the issues that needed more attention than others
• If an issue is an exception coming from DQS to LDIC, Touch base with DQS business analyst and discuss, analyze and decide in whose bucket the issue should go.

Confidential, San Francisco, CA

Senior Business Systems Analyst

Responsibilities:

• Created and maintain Business requirements document (BRD), USE Case Specifications, Functional Specifications (FRD), Test Cases for UAT, SQL Queries for data validation and verification
• Got input from high-level business concepts and discussions with project stakeholders and was responsible for the creation and maintenance of documentation required for a successful development effort.
• Used BPMN diagrams and process flows, and other forms of information articulation, to craft detailed system functional requirements.
• Worked closely with the Development team (offshore) going over the Mock-ups designed by the UX developer for a Self-contained Functional Demo to the Business team.
• Applied technical skills around systems and data analysis to provide a high level of detail in requirements documentation.
• Organized and facilitated meetings with the management and the development team, conducting requirements gathering sessions with the purpose of defining the functional business and system requirements.
• Worked closely with the Development team in deriving Non-Functional requirements.
• Wrote clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret and design and develop the application with minimum guidance.
• Helped in preparing a test plan and executed all levels of Unit, Integration, User Acceptance and Operational Acceptance testing using test cases to prove that the system conforms to specifications of business requirements and meet market driven quality requirements.
• Conducted GAP analysis and created AS- IS and TO- BE workflow to better understand the mechanics of the existing system and future system also for Analysis to identify key areas of concern and addressed them with the Business team