Sanjotha B.

Business Analyst

690 dollar

Mon expérience

Voir plus

JP Morgan & Chase Co., BangaloreDecember 2015 - April 2019

CCB Risk Reporting - The CCB BCBS program was created to address the Basel Data Aggregation & Reporting
Principles issued by the Basel Committee on Banking Supervision (BCBS) in early 2013. The regulation aims to
align standards in a bank’s ability to identify and manage bank-wide risks.
• Engaged with stakeholders to understand business requirements, translate them into functional
specifications and integrate it.
• Executed and published MIS and BCBS reports to support various business decisions.
• Ensured quality of reported risk information, timeliness, completeness and consistency.
• Responsible for identifying the Critical Data Elements for various lines of Business.
• Developed Cognos packages to reduce dependency on the IT Team, which helped the team attain
more than 50% target for the year in just a span of 3 months.
• Developed Tableau dashboards to provide clear visualizations of risk data.
• Designed and developed interactive reports (in Cognos and Tableau), for ad-hoc analysis, saving
turnaround time of 1-2 days for each analysis and reduced the team workload by 30%.
• Performed UAT, Pre-Prod and Prod testing of all automated reports.
• Cross-trained team members to take up back-up roles.
Voir plus

CognizantSeptember 2010 - November 2015

Clients – Apple, Capital One, Loblaw, American Express
The projects aimed in enhancing the features and testing all the end to end processes to ensure quality
product delivered to the end users.
• Worked closely with client's business team to gather requirements and design scenarios.

• Created data mapping documents for data migration projects.
• Built, published and customized reports from multiple data sources, using Cognos and Tableau.
• Participated in Sprint Planning, Stand-up calls and Retrospective meetings.
• Involved in System Integration Testing, Regression testing, UAT and Production phases.
• Performed Functionality (ETL) testing for the exceptional scenarios and enhancements.
• Created and executed Test plans while working closely with developers to resolve issues.
• Prepared SQL Test Scripts to validate business transformations.
• Involved in Defect Management, tracking and logging defects in HP Quality Centre/ALM.
• Validated ETL workflows at each level of processing, to ensure data completeness.
• Performed Hadoop testing to validate Source and Target data using Hive queries

Mes compétences

Others

Data analysis, Quality Assurance

Languages

SQL

Business Intelligence

Cognos, Tableau Software, ETL, Business Intelligence, Data Warehouse, SAS

Analysis methods and tools

JIRA, Agile

Software testing

ALM Quality Center, Manual testing

Mes études et formations

Bachelor of Technology - Dr. Babasaheb Ambedkar Technological University, Maharashtra2010 - 2010