Summary
Overview
Work History
Education
Skills
Timeline
Generic

Greeshma Chapparada

Princeton

Summary

Experienced in leading complex business analysis projects, leveraging robust analytical skills to deliver comprehensive solutions that enhance business operations. Proven track record of successfully managing stakeholder relationships and driving process improvements. Professional business analyst with deep expertise in driving strategic initiatives and optimizing processes. Skill set includes data analysis, requirements gathering, and stakeholder management, with a strong focus on collaboration and delivering impactful results. Adaptive to changing needs and reliable in ensuring project success.

Overview

16
16
years of professional experience

Work History

Lead Business Analyst

Bank Of America
09.2023 - Current
  • Lead Projects for the Market Risk Team for Analytics team, while working for the business users on the VAR Projects in helping them with the better usage of the APIs to run their simulations
  • Worked on Capital Market asset classes Equity Swaps, Derivatives and Credit
  • Worked on Market Risk Projects where new derived mapper configs were added to the Time Series Viewer, for the users to use the different COB versions (Bi-Temporality) of the derived mappers for generating SAT report across different scenarios (VAR, CCAR etc..)
  • Leads Market Risk Team projects focusing on Capital Markets risk analytics and VAR (Value at Risk) projects
  • Works on asset classes such as Equity Swaps, Derivatives, and Credit, ensuring data governance alignment in risk assessments
  • Designed Time Series Viewer enhancements by incorporating bi-temporal derived mapper configurations, improving risk factor analysis
  • Led efforts in Climate Scenario VAR implementation, focusing on stress testing for Credit and Equity asset classes
  • Worked on generating the historical VAR data for parallel tenors, PAR rates, weekly windows rolled over for different asset class risk factors by liaising with Global Risk team on requirements and with technical teams on implementation; worked on documenting the end to end process and performed UAT test before the PROD rollout
  • Worked as a Product Owner in implementing new Climate Scenario VAR for stress scenario across Credit and Equity asset class, from Shocks sourcing part to the Rules Repo generation
  • Worked with the business users, to collect the project requirement and engage with them on elucidating the test cases as per the project scope into FRD
  • Worked on creating Epics and stories and elucidating the Acceptance Criteria required for each of them, and tracking the progress of them through the project lifecycle
  • Participated in UAT phase testing by performing sanity testing of the features developed against the Test Cases mentioned in the jira stories
  • Worked on analyzing the data for a particular bookmark to know the list of asset class, Feeds covered for a particular time span
  • Worked on tracking the project progress by connecting with the Developers at each phase, to make sure all the deadlines are met before the code freeze and proper UAT testing is completed for the Sign-Off
  • Worked on legacy Risk Factors retiring by analyzing the impact they had on the BookMarks across different Legal entities in a methodical way

Lead Business Analyst

Citi Bank
01.2022 - 09.2023
  • Lead Projects for the Compliance Surveillance and Risk team in analyzing the trades data across multiple products covering APAC, NAM regions as per the project surveillance scope and scenarios
  • Covered multiple asset class including Equities, Futures and Options, Fixed Income, Commodities etc
  • Led projects for Compliance Surveillance & Risk Team to analyze trade data across multiple asset classes, including Equities, Futures, Options, Fixed Income, and Commodities
  • Ensured data governance best practices by validating and mapping Critical Data Elements (CDEs) to surveillance models, ensuring regulatory compliance
  • Work closely with the risk team in gathering the project surveillance scope and the surveillance scenarios and gathering the latest CDE (Critical Data Element) rules for the areas applicable
  • Work on writing the CDE rule sqls as per the CDE rules provided by the risk team for NPAC/TVIQ Projects (New product onboarding or BAU projects)
  • Perform data validation across Olympus (Raw Data), EAP(Enriched) data lakes (on Orders and Trades data) and SMARTS files, including the complete lifecycle check for trades data for Equities, Futures and Futures products
  • Worked on FIX tags to decrypt the key data elements required to identify the sample trades data before proceeding with the data validation
  • Performed validation on Non-PROD, Pilot and PVT trades data and worked with the business team in gathering the key project details (data volume expectation, Desk Number, Trader location, Broker details etc..)
  • Worked on preparing the presentation deck with all the validation report details, business information for the Project Sign-Off from the risk team for the full-fledged project implementation
  • Created SQL-based CDE rule scripts to enhance risk monitoring and ensure compliance with NPAC/TVIQ projects (New Product Onboarding & BAU initiatives)
  • Worked with the APAC team in delegating the tasks for the data validation by creating the sub-tasks in the jiras

Sr Business Analyst

BCBS
03.2021 - 12.2021
  • Lead Project for generating benchmarks for each viable different sector customers by analyzing the client base health claim records across multiple line of health facilities in the Datawarehouse system, for helping the commercial customers analyze their insurance plan performance and to decide on opting for a better coverage plan as per their specifications by Populating the Fact tables after multi-layer of aggregate tables
  • Participated in the meeting with business team at analyzing the project scope
  • Worked on creating mapping document if the project is brand new or Performed Gap Analysis to incorporate new fields to the existing setup
  • Analyzed the data for each field by performing various joins and filtered the records to pick the right one as per the Business requirement
  • Created and Published Tableau reports for the business users to know the data trend of company’s insurance model Usage and performance
  • Participated in the project walkthrough with Data Modelers, Developers and Testers by assigning the tasks and helping them in understanding the nitty gritty of the project
  • Worked proactively during the SIT and UAT phase to make sure all the required reports or the features are available as per the project definition
  • Basic checks were made to make sure all the code components are properly checked in the versioning system and to make sure the PROD phase uses all the latest scripts
  • Experience working across the different health insurance models

Business Analyst

Bank of America, DE
07.2019 - 04.2020
  • Lead multiple project deliverables in sending out surveys to the customers across multiple line of products
  • Coordinate with business and data team to gather necessary business requirements, to plan for the Data Pipeline
  • Liaise with business team to acquire/compare metadata document with final table template
  • Created DataMart and performed Data Profiling
  • Develop necessary tables in Hadoop platform as per business requirement document
  • Create HLD document against business requirement document and forward HLD to architect for approval
  • Carry out data massaging in interim stage as well as set of suppressions on table data against rule mapping table (created for each survey channel)
  • Utilize bit bucket to push data from Dev to UAT environment
  • Interact with testing team on the test case details before conducting SIT in UAT
  • Worked on creating complex queries for filtering out the required data at each stage
  • Involved in creating dashboards for multiple projects, and generated reports using Tableau
  • Created shell scripts for the scheduled batch execution of SQLs for multiple projects in the autosys scheduler
  • Participated in Python scripting for the DQC checks across the final set of data ready to be delivered to the customers
  • Worked on Traceability Matrix creation to link the BRD requirement to the assumption and in turn to the pseudocode
  • Engaged with the offshore team in assigning tasks to each team member and tracking the progress
  • Participated in the weekly meeting with the business stake holders to provide update on the project progress
  • Co-ordinated with the SOR, testing and business team at every stage of the project
  • Maintained data versioning using Bitbucket across all the stages of the project
  • Processed the Near real time data coming from the kafka topic needed for collecting the updated status of the active customers using the Bank’s products across multiple streams

Database Engineer

Medidata Solutions Inc
06.2016 - 05.2019
  • Worked in handling the clinical trial data of multiple pharmaceutical clients
  • Leveraged ETL tools Tableau, SSIS to transform and analyze the data and generated reports using SSRS
  • Oversaw the detailed report generation by executing UNIX shell scripts
  • Maintained consistent liaison with key stakeholders to gather and analyze necessary information
  • Collaborated with data analysts to devise innovative solutions for analysis as well as managed and reviewed the final data
  • Supported distributed data processing
  • Oversaw schema design and data modeling in close collaboration with application team
  • Worked on designing EDC Rave Databases
  • Streamlined client information gathering process by splitting up multiple stages of clinical trial data
  • Worked on scheduling automated script execution using SQL Server Agent
  • Participated in clinical Data Profiling and Cleaning to filter out the valid data points needed for further analysis
  • Participated in the meetings with the business stakeholders on designing the data platform as per their requirements
  • Generated efficient SQL scripts for database backups/restores with keen focus on ensuring uninterruptible execution of critical database functions
  • Devised PowerShell scripts for execution of queries across multiple servers (with output stored in csv format)
  • Worked on creating Google scripts for internal usage to report the jira tickets created by each department
  • Involved in the regular client meeting to come up with new strategies in analyzing their data efficiently and cost effectively by avoiding the delay in providing the final report

Database Developer

Nomura America Services, LLC
03.2014 - 07.2016
  • Provided support for designing, developing, and maintaining SQL server that involved script writing (such as writing stored procedures, user defined functions, views, query writing, and ER Design)
  • Oversaw database migration project from inception to completion
  • Monitored overall performance, capacity, and health of SQL database by utilizing DMVs and DMFs
  • Gained in-depth experience regarding packages, triggers, and stored procedures on oracle platform
  • Participated in global meeting with regional database team to discuss future goals/objectives
  • Utilized Service Now tool for generating overall production releases after receiving approval from change management team
  • Contributed to the MSSQL obsolescence project, ensuring successful transitioning of MSSQL servers from windows 2003 to 2008R2
  • Performed capacity planning and database sizing for newly deployed servers, as well as reinforced database security by implementing SQL logins, roles, and authentication modes
  • Participated in setting up SSIS packages to transfer data from one source to another
  • Utilized PowerShell scripts for retrieving multiple server details, as well as scheduled tap backups for MS SQL server to ensure smooth flow and maximum availability of business-critical data
  • Ensured maintenance, sustainability, and optimal performance of in-house database by implementing robust tools across MS SQL servers
  • Contributed to the implementation of database mirroring to support disaster recovery strategy
  • Provided production support to the applications by participating in the On-Call support on rotational basis
  • Handled the quarterly DR test to check the stability of the infrastructure on the DR site
  • Monitored the DB alerts using rivermuse over space usage, server usage to ensure the normal health status of the Databases across the US region for all the applications

SQL Database Developer

Tech Mahindra
01.2009 - 01.2011

Education

Master of Science - Computer Science

New Jersey Institute of Technology
Newark, NJ
06-2010

Skills

  • Use case development
  • Functional specifications
  • User acceptance testing
  • Software development life cycle
  • SQL proficiency
  • Data analysis
  • Business process modeling
  • Data mapping
  • Requirements gathering
  • Problem-solving
  • Business strategy
  • Pivot tables
  • Product management
  • Gap analysis

Timeline

Lead Business Analyst

Bank Of America
09.2023 - Current

Lead Business Analyst

Citi Bank
01.2022 - 09.2023

Sr Business Analyst

BCBS
03.2021 - 12.2021

Business Analyst

Bank of America, DE
07.2019 - 04.2020

Database Engineer

Medidata Solutions Inc
06.2016 - 05.2019

Database Developer

Nomura America Services, LLC
03.2014 - 07.2016

SQL Database Developer

Tech Mahindra
01.2009 - 01.2011

Master of Science - Computer Science

New Jersey Institute of Technology

Similar Profiles

CREATE PROFILE
Greeshma Chapparada