SHIKHA SEN

• Leading Enterprise Risk Organization, Compliance Analytics and Innovation Reporting team and supporting customers for their day to day analytical and data needs.
• Framing a culture of data-driven decision-making within the organization by promoting best practices in analytics methodologies and tools usage.
• Collaborating with cross business, product, tech, design and data scientist team to drive innovation, process improvements, resulting in increased productivity and streamlined workflows.

• Worked as Product Owner and data lead for Risk Analytics Data Analysis and Reporting team handling 40+ dashboards suite.
• Responsible for creating data visualization dashboards for Risk Management & Compliance team for Regulatory Reporting by challenging first line to mitigate risk by providing various reporting suite.
• Working as Analytical Lead for PRIME to Fuse Migration MVP efforts. Evaluating dashboards impacted with the migration effort and remediating scripts and dashboards to work as intended.
• Subject Matter Expert for Risk Datawarehouse having end to end knowledge of various PRIME objects.
• Responsible for communicating project status as well as demonstrating work in S2, S3 and quarterly meetings with Senior Leadership.
• Project: Risk Management -Compliance and Ethics (Analytics and Innovation)

• Worked as Product Owner for Risk Analytics Data Analysis and Reporting team handling 40+ dashboards suite.
• Responsible for creating data visualization dashboards for Risk Management & Compliance team for issues, events and regulatory changes impacting the business decisions.
• Leveraged Machine Learning Platform to schedule python automated jobs to utilize data from google drive, storing in dataframes and output the data in the snowflake tables to refresh the dashboards.
• Created automated solution and data quality rules for data validation between Redshift and Snowflake for Fuse Migration.
• Responsible for creating data visualization dashboards for Risk Management & Compliance team for issues, events and regulatory changes impacting the business decisions.
• Developed and automated spark-based solution in data bricks to pull the regulatory change data and implement the transformation logics before generating the output file.
• As part of Data Analytics Reporting & Transformation team, my responsibilities include producing data to support Integrated Compliance Transaction Testing for Commercial, Retail & Banking application. Sourcing data from line of business to fulfill the request to meet regulatory requirements for Capital One.
• Worked on deploying the php dynamic webpages on Amazon EC2 and performing rehydration.
• Experience on deploying code to production using CI/CD Jenkin pipeline.
• Build and enhance General Ledger reconciliation rules to minimize the variance in General Ledger data and OFSAA (Oracle Financial Service Analytical Application) data for all lines of business.
• Perform Data Quality check on daily, weekly and monthly basis and identify the root cause of failure.
• Responsible for maintaining and enhancing Liquidity Coverage Ratio (LCR) , Data Quality and General Ledger Reconciliation tableau dashboard.
• Perform reconciliation process to recon General Ledger balance to OFSAA balance and research variance if occurs.
• Responsible for identifying the difference in rules on source (General Ledger) and target (OFSAA) and implement the changes to match the balance.
• Project: Risk Management -Compliance Governance

Responsible for creating data visualization dashboards for Risk Management & Compliance team for issues, events and regulatory changes impacting the business decisions.

• Developed and automated spark-based solution in databricks to pull the regulatory change data and implement the transformation logics before generating the output file.
• As part of Data Analytics Reporting & Transformation team, my responsibilities include producing data to support Integrated Compliance Transaction Testing for Commercial, Retail & Banking application. Sourcing data from line of business to fulfil the request to meet regulatory requirements for Capital One.

• Responsible for requirement gathering from the business, writing the user stories in JIRA, analyzing the requirement, creating the mapping document and clarifying requirements with the LOB SME.
• Responsible for creating Tableau reports from various data sources using aggregates, hierarchies, charts, filters, table calculations, parameters and trend lines.
• Responsible for understanding, analyzing, cleaning, and filtering the data and drawing some meaningful information and figures from the data using python data visualization libraries like pandas, matplotlib, numpy, seaborn etc.
• Experience in writing shell scripting for automating the process.
• Responsible for all DEV activities including environment preparation, DDL preparation, DB workbook preparation, Control M job scheduling workbook preparation.
• Responsible for writing BTEQ scripts for pulling the data from source table, applying all the transformation rules and logic to load the data into target table.
• Responsible for preparing and executing unit test cases.
• Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modelling, Data mapping, ETL Development, metadata management, data migration and reporting solutions).
• Strong understanding of Data Modelling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
• Advanced Microsoft Office suite software skills (Excel, Access, Word, SharePoint, One Note, Project)

• Worked as Data Analyst to analyse data, pull the data from multiple heterogeneous sources, transform and load in data warehouse.
• Involved in all the phases of Data analysis and creating visualizations using Tableau, Python and Excel to explore the data helping business predicting and making future decisions.
• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Written SQL Teradata scripts to pull the data from tables, connect to databases and create Data Visualization in Tableau, EXCEL to perform Data Analysis.
• Worked with Python Pandas Libraries and Seaborn Libraries for Data Analysis and Visualizations.