Sathya Venkatraman
Plano,TX
Summary
Results-driven Data Management and Business Analysis Professional with over 20 years of experience in the banking and financial services industry. Expertise in data analysis, project management, and business analysis across global environments including the USA, Singapore, and India. Proven track record of delivering high-impact solutions using SQL, Oracle, and RDBMS technologies. Adept at leading cross-functional teams, streamlining processes, and implementing strategies that enhance operational efficiency and drive business growth.
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Core Competencies
• Data Management & Analysis: Data integration, data quality, data migration
• Business Analysis: Requirements gathering, stakeholder engagement, process improvement
• Project Management: Agile methodologies (Scrum), project planning, team leadership
• Technical Skills: SQL, Oracle, RDBMS, TOAD, MS Access, Excel
• Regulatory Compliance: SCCL (Single Counterparty Credit Limit), HMDA (Home Mortgage Disclosure Act)
• Tools & Platforms: JIRA, Confluence, Informatica, UAT testing, ETL
• Soft Skills: Analytical thinking, problem-solving, communication, collaboration
- Excellent knowledge in RDBMS concepts and Database Objects creation such as Tables, User Defined Data Types, Indexes and Views.
- Excellent working knowledge of database structure, data models, data mapping, data manipulation, reporting and ETL tools
- Hands-on Experience with Data transformation, data cleansing, validation, manipulating and analyzing of complex, high-volume, high-dimensionality data from varied sources
- Performed the required KYC screenings on customers documenting the information obtained on the client's as required by global KYC procedures.
- Experience in creating Data Dictionary, Reference Data, Metadata, Data Lineage, and Data Quality Rules.
- Extensive experience in creating data mapping specifications and interface documents.
Overview
12
12
years of professional experience
Work History
Senior Business Data Analyst
LPL Financial
12.2021 - 11.2022
- Involved in LRDS Consumer requirements gatherings and scrum meetings
- Facilitated Daily scrum meeting
- Involved in data analysis of PartyODS database tables as per the requirement
- Gained functional knowledge about PartyODS and LRDS projects thorough confluence links and project discussions
- Standardized data collection procedures across departments, ensuring consistent data quality and enabling seamless integration of new datasets.
- Increased data accuracy by implementing thorough data validation and cleansing processes.
- Provided evaluative judgment based on analysis of information in complicated and unique situations and contributed to formulation of standards and strategies for functional areas.
Sr Business Data Analyst- FRR-SCCL Project -FR2590
BNY MELLON
03.2019 - 02.2020
- Involved in Data preparation and analysis for Single Counterparty Credit Limit (SCCL)
- Interfaced with different stakeholders (Client Tech, Business & Downstream) for SCCL project as required
- Reviewed Daily, monthly, quarterly SCCL results with key business partners, compared and analyzed the results with excel calculator and generated SQL report
- Involved in multiple control assessments and ensure controls are documented appropriately
- Developed presentations and reports for senior management and regulators
- Supported the automation of report preparations, including UAT testing, and other improvements to reporting workflows
- Interacted with subject matter expert on the SCCL rules and Fed reporting instructions
- Involved in Identifying, analyzing specific business requirements of the reporting need of the FRR
- Data acquisition and Data Mapping
- Created and documented testing strategies and Acceptance Criteria
- Did UAT testing, analyzed and data between source and destination and reporting tool
- Compared, analyzed and validated daily and quarterly reporting aggregated values, and other functionalities, reviewed risk with stake holders
- Developed SQL test scripts and generated reports in SQL and compared with AXIOM report test results
- Ensured data quality checks for all critical elements are performed and logging and following defects in JIRA
- ENVIRONMENT: ORACLE, TOAD, SQL, MS EXCEL, VISIO, JIRA
- Reduced report generation time significantly by optimizing SQL queries and restructuring existing databases.
- Collaborated with stakeholders to identify business needs and data sources.
- Generated ad-hoc reports to evaluate specific business requirements.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
Lead Business Data Analyst- ECIF
BNY MELLON
03.2017 - 03.2018
- ECIF - Client Master data Management System, ECIF is the enterprise client master database
- This Project is to analysis and acquire all client data both internal and external data and its account relationship and cross referencing globally across the corporation to provide 360-degree view of each client
- Ensured holistic approach to Enterprise Data Governance is employed in ECIF project that addresses the people and process components of Data Quality, Data Stewardship, Data Privacy & Protection, Data Policy & Standards, and Metadata Management
- Interfacing with different stakeholders (Client Tech, Business & Downstream)
- Serve as a liaison between business, functional areas and technology, to ensure that data related business requirements for protecting sensitive data are clearly defined, communicated and understood, and considered as part of operational prioritization and planning
- Report on non-compliance with BNY 's data governance standards, policies, processes, etc.
- Document data lineage for current data in detailed and high-level views, Identify Authoritative Data Sources and document all data quality controls
- Provided source analytic and consultation support to customers
- Analyze the requirements and define process flows/data flows
- Responsible for acquiring data into ECIF to support SR-14 regulatory data requirements
- Responsible for accessing data sources [ Test, QA, Production) that has been sourced into EDS and to acquire this data to ECIF
- Responsible for writing functional requirement documents
- Data analysis, Data acquisition and Data Mapping
- Responsible for Developing complex SQL queries and scripts to extract, transform, load, test and aggregate data
- Developed extensive Business Process Modelling using MS Visio to understand the application, process and data movement
- Documented requirements in the form of Use Cases and obtain business user approval
- Developed and Review test cases and validate against the functional requirements defined
- Conducted training sessions for new inductees
- Trained team members on the overall performance process
- Assisted in identifying testing issues and suggesting resolution steps
- Conducted impact analysis to identify deviations in testing process for Change Requests
- Defined UAT plan and coordinate with users for testing
- Performed UAT, RCA (Root Cause Analysis) for UAT issues and determine the resolution mechanism
- Worked with the administration team to define the business validations to be performed
- ENVIRONMENT: ORACLE, IBM DB2, MS ACCESS, MS EXCEL, VISIO, CONFLUENCE, JIRA
- Identified data discrepancies and inconsistencies through rigorous data audits, ensuring the highest level of data integrity for business-critical decisions.
- Collaborated with cross-functional teams to identify key metrics and develop relevant dashboards for tracking business performance.
- Articulated risks and issues to communicate concerns to various levels of management.
- Facilitated seamless integration of acquired company's data systems by mapping critical fields between databases and performing extensive reconciliation efforts.
- Interacted with internal customers to understand business needs and translate into requirements and project scope.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Collaborated with stakeholders to identify business needs and data sources.
- Identified patterns and trends in large data sets and provided actionable insights.
- Increased data accuracy by implementing thorough data validation and cleansing processes.
Senior Business Analyst
TATA CONSULTANCY SERVICES
06.2012 - 06.2016
- Contributed to the strategic direction and successful implementation of the project - Investing & Retirement Portal Mobility Solution [Responsive Web Design] to PNC Financial Services Group,
- Collaborated with the stakeholders for the development of responsive user interface to support MaaS 360 browser and Good Browser
- Worked closely with technology team to define datasets, formats and tools needed to increase insights and efficiency
- Facilitated daily scrum meetings to identify roadblocks
- Conducted weekly sprint planning meeting with the developers and quality assurance analysts to review user story, assign story points and assign cards to a respective sprint
- Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, functional and non-functional requirements
- Worked with senior leadership to review existing values and principles and make recommendations to change
- Extensively used SQL
- Helped team in removing impediments from deliverables and goals
- Designed User Interface-level wireframes detailing interaction models and user experience using Azure.
- Conducted requirement workshops to verify and validate business requirements
- Maintained a Traceability Matrix to ensure that all functional requirements are addressed at the use case level as well as the test case level
- Develop and implement data collection systems, and other strategies and process improvement opportunities that optimize efficiency, quality and ability to pull insights from data
- Filter and 'clean' data, and review the system reports and performance indicators to locate and correct code problems as required
- Coordinated project scheduling and status reporting with the project manager
- Coordinated End User Acceptance testing with SME's
- Provided analytic and consultation support to customers
- Analyze the requirements and define process flows/data flows
- Applied SQL skills to access and reorganize almost any raw data in the organization
- Involved in pulling together information from various data sources scattered throughout the company to figure out where the data need to go in the organization
- Documented requirements in the form of Use Cases and obtain business user approval
- Reviewed test cases and validate against the functional requirements defined
- Assisted in identifying testing issues and suggesting resolution steps
- Conducted impact analysis to identify deviations in testing process for Change Requests
- Performed RCA (Root Cause Analysis) for UAT issues and determine the resolution mechanism
- Perform Testing in real mobile devices as well as using PERFECTO tool
- Worked with the administration team to define the business validations to be performed before data is displayed on the website
- Involved in drawing wireframes diagrams to provide easy understanding of the application to SME's, Developers, Testers and Quality Analysis professionals
- Experienced in using these wireframes diagrams to maintain design consistency
- ENVIRONMENT: Agile, Oracle, MS Visio, JIRA, web application, Portal mobile application, IBM WebSphere, Harvest, ALM, MaaS360 Browser, Good Browser, Perfecto Tool, SQL, Oracle, TOAD
- Facilitated requirement gathering workshops, resulting in clear project objectives and deliverables.
- Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
- Conducted gap analyses to identify discrepancies between current and desired states, leading to actionable recommendations.
- Led process mapping initiatives, resulting in optimized workflows and reduced redundancies across departments.
- Performed risk assessments on potential projects to determine feasibility and viability before moving forward with implementation plans.
- Enhanced stakeholder engagement through effective communication of complex data and insights.
- Collaborated with stakeholders to identify business needs and data sources.
- Analyzed data to identify root causes of problems and recommend corrective actions.
Sr. Business Analyst
Bank of America
02.2013 - 11.2014
- Database Design & Data Integration Project
- Worked with business users to elicit, analyze, document, and communicate requirements for business systems
- Supported business with time-critical tactical data analyses
- Worked extensively in moving data from one system to another, in analyzing the data between source and destination and in transforming the data when moving
- Involved Analyzing and pulling the source data from various applications and centralized in a repository
- Collaborated with business stakeholders to improve the teams reporting toolset and insights
- Created the performance sections of weekly, monthly and quarterly business review documents
- Documented, categorized and prioritized the business, user and system requirements
- Coordinated cross-functional participation in the business systems analysis process to ensure consistency and adherence with standards and best practices
- Co-coordinated the User Acceptance Testing with the SME's to make sure that all the business requirements are addressed in the application
- Ensured the appropriate training programs are in place to maximize the use of the technology, as required
- Created and automated professional diagrams using MS-VISIO software to simplify complex information with updated shapes, collaboration tools and data-linked diagram
- Involved in extracting data from underline Oracle and SQL server databases and transform it and stored in center data repository
- Assisted to identify vulnerabilities in Web applications and mitigate the associated security risk
- Worked in design, configuration and support of FactFinder, BlueStripe's monitoring software
- Involved in database analysis, quality control, reporting, maintaining, troubleshooting, monitoring, supporting, and optimizing key functional areas
- Supported data analysis and reporting needs, performance analysis for special business intelligence projects
- ENVIRONMENT: Oracle, SQL, EXPORT/IMPORT, SQL Loader, TOAD, SQL SERVER, IBM ITM, IBM ASE, MS-VISIO, BlueStripe, FactFinder, JIRA Agile, MS Azure, Kanban, JIRA - defect tracking, MS office suite
- Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
- Streamlined workflow for better productivity with the implementation of new software solutions.
- Utilized data visualization techniques to present and explain complex data sets.
Business Data Analyst
American Express
06.2012 - 01.2013
- Oracle Apps - Design & Development
- Responsible for Analyzing requirements, designing, maintaining and updating data models
- Created use case diagrams and activity diagrams using MS Visio
- Developed Templates for new forms and generate scripts for database objects using oracle designer 10g
- Developed and implemented complex data models and logical database designs
- Extensively used SQL
- Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures
- Support Oracle databases in ICM, OET, NGI PULSE
- Involved in data Modelling, data cleansing, validation and quality control
- Application support for Oracle 11g/10g/9i databases in testing, data migration, development and production environment
- Involved in migrated all the objects i.e
- Tables, store procedures, triggers from old server to new server using Export Import scripts, DBMS packages
- Involved in reorganizing the database to improve performance
- PULSE - Developed strategies for data extraction from Oracle server to Db2 database for Pulse Db2 conversion project
- Involved in database design, extensively involved in the process of gathering business needs and functionalities
- Provide expertise in designing, negotiating and defending database schemas and data models
- Consult with database administration and client areas and provides solutions in resolving complex issues during the translation to a physical database design
- Work closely with Application partners to achieve maximum application performance
- Regular maintenance of Database for space related issues
- Utilized IBM Change management [CMR] process and IMR [Problem management]
- Worked on small to mid-size UDB databases in AMEX Interactive Portfolio to implement CMRs for table structure changes
- ENVIRONMENT: Oracle 11g RAC /10g, 9i Import/Export, OEM, RMAN, PL/SQL, SQL
- Loader, shell scripts, cron-scripts, AWR reports, Db2 v9.7 on AIX
- Increased data accuracy by implementing thorough data validation and cleansing processes.
- Standardized data collection procedures across departments, ensuring consistent data quality and enabling seamless integration of new datasets.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
Lead Business Data Analyst - Data Management Services
FDIC
01.2011 - 05.2012
- Worked on a $500MM DMS program that involved financial data aggregation and providing business insights into the bankruptcy process of failed financial institutions
- The business goal was to create a one point solution for the clients to access the huge volume of failed banks data
- Worked in the following banks and involved in analyzing and capturing 10 years of data from various core applications from the bank site for FDIC
- (First Citizens Bank, Decatur Bank, GA, Colorado Capital Bank & San Joaquin Bank, CA)
- Obtained a standardized, cost-effective way to store, access, and maintain large volumes of data from electronic records, systems and applications from failed financial institutions in order to financially protect FDIC as Receiver
- Ensured the adequate protection of data necessary to support research and litigation
- Analyze 10 years of huge volume of electronic data at the bank, finalizing the details with FDIC
- Involved in the extraction, transformation and loading of the source data to the Oracle database for FDIC in a searchable format
- Onsite and Remote Assessment
- Involved in interacting with client and gathering requirements
- Involved in analyzing the bank's electronic data, providing the details to FDIC, obtaining the approval from FDIC and finalizing the scope document
- Developed Data capture scope, extraction strategy and approach
- Involved in analyzing the source data coming from different Data sources such as Oracle, DB2, SQL Server, flat files and identifying data anomalies in operational data
- Performed Applications and system analysis
- Planned and capturing the electronic data using DB/Reporting tools
- Executed reports, cleansing the data, validating the data
- Performed QA and creating documents
- Data capture includes extraction and loading of a standard data set from all banks
- Standard Data Sets include Loans -Basic and additional information [mortgage and non-mortgage], Deposits, CD, savings and DDA accounts, financials [GL, AP, wire and ACH], email and file shares
- Transfer and Hosting the Data
- Migrate data to the storage
- Support UAT phase
- Design and create table structures
- Load data to Oracle database
- Document Data access procedures
- Planning and creating Oracle database
- Planning and Creating Table spaces and tables for data loading
- Creating ad-hoc reports according to the requirements from FDIC for investigation purpose
- ENVIRONMENT: Cognos Reporting tool, Banc Pac- BPR reporting tool, Jack and Henry, LaserPro applications, SQL SERVER 2005/2008, Oracle 11g, Import/Export, SQL
- Loader, building scripts, Pl/SQL, Excel, MPP
- Identified data discrepancies and inconsistencies through rigorous data audits, ensuring the highest level of data integrity for business-critical decisions.
- Evaluated third-party software solutions to determine optimal tools for ongoing analytics projects, leading to increased productivity within the team.
- Identified patterns and trends in large data sets and provided actionable insights.
Education
Master of Computer Applications (MCA) -
Alagappa University
Karaikudi, IndiaSkills
- Oracle 9i,10g,11g
- SQL Server management studio
- INGRES
- SQL
- SQL Loader
- TOAD
- Embedded C
- Solaris
- HP-UNIX
- VAX-VMS
- UNIXWARE
- LINUX 9
- AS4
- Digital UNIX
- PC Compatibles
- ER-STUDIO
- COGNOS
- IBM Tivoli
- IBM ACE
- MS Office
- Microsoft Project Plan
- Tableau
- JIRA
- CONFLUENCE
- Agile methodology
- Advanced Excel
- Process mapping
- SQL programming
Technology
Oracle 9i, 10g & 11g Database, SQL Server management studio [SSMS], INGRES, Database Admin & Development, SQL/ SQL Loader/ TOAD, Embedded C, Windows 7/XP/2000, Solaris, HP-UNIX, VAX-VMS, UNIXWARE, LINUX 9, DELL VAX 400, VAX 4000/300, TATA UNISYS U6000, Digital UNIX, PC Compatibles, ER-STUDIO, COGNOS, IBM Tivoli, IBM ACE, MS Office, Microsoft Project Plan, Tableau, JIRA, CONFLUENCE
Timeline
Senior Business Data Analyst
LPL Financial
12.2021 - 11.2022
Sr Business Data Analyst- FRR-SCCL Project -FR2590
BNY MELLON
03.2019 - 02.2020
Lead Business Data Analyst- ECIF
BNY MELLON
03.2017 - 03.2018
Sr. Business Analyst
Bank of America
02.2013 - 11.2014
Senior Business Analyst
TATA CONSULTANCY SERVICES
06.2012 - 06.2016
Business Data Analyst
American Express
06.2012 - 01.2013
Lead Business Data Analyst - Data Management Services
FDIC
01.2011 - 05.2012
Master of Computer Applications (MCA) -
Alagappa University
Similar Profiles
Christian WallaceChristian Wallace
Financial Paraplanner at M Financial Planning Services (LPL Financial)Financial Paraplanner at M Financial Planning Services (LPL Financial)
Nico Delucia GarganoNico Delucia Gargano
Office Manager at Empire Financial Advisors, LPL FinancialOffice Manager at Empire Financial Advisors, LPL Financial
Teresa DiLorenzoTeresa DiLorenzo
President/Branch Manager at Distinctive Financial Services/LPL FinancialPresident/Branch Manager at Distinctive Financial Services/LPL Financial