SATENDER PRASAD DHINDHORIA
Thane
Summary
A result-oriented professional with over 16 years of experience in operations management, data analysis, and compliance. Expertise in analyzing and interpreting complex data, developing operational procedures, and delivering insights using tools such as Power BI, MicroStrategy, and SQL. Proven track record of improving business efficiency and compliance through data-driven strategies.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr. Analyst & Compliance
Client - ABB
Mumbai
12.2022 - Current
- Being a part of Sox audit team for the IT department, ensuring seamless compliance with regulatory requirements.
- Implemented and monitored access controls resulting in a 20% reduction in access-related incidents.
- Documentation and Logging - Conducted thorough access reviews, documenting results and maintaining a 100% compliance rate with SOX regulations.
- User Provisioning and De-provisioning - Establish a systematic approach to provisioning new users with the necessary access rights promptly & Ensure that user access is promptly revoked or modified upon changes in job roles, terminations, or other status changes.
- Monitoring and Logging – Implement robust monitoring of user activities and log reviews to detect and respond to suspicious or unauthorized activities. Regularly review system logs and security reports for anomalies.
- Segregation of Duties (SoD) - Ensure that there is a robust segregation of duties framework to prevent conflicts of interest and unauthorized access. Key duties should be separated to avoid potential fraud or errors.
- Incident Response Plan - Develop and maintain an incident response plan to address any security incidents related to user access promptly. Establish procedures for reporting and investigating potential security breaches.
- Documentation of Compliance - Maintain comprehensive documentation that demonstrates compliance with SOX requirements related to user access management. Ensure that all audit trails and reports are available for review by internal and external auditors.
- Drafted documents that outlined processes, procedures, and best practices.
- Maintained updated knowledge base on industry trends and best practices.
- Developed training materials for end users.
- Led meetings with stakeholders to discuss objectives and budgets.
- Collaborated with IT teams on new tools and technologies.
- Conducted extensive research into industry trends and competitive analysis.
- Identified needs of customers promptly and efficiently.
- Analyzed and tracked data to prepare forecasts and identify trends.
- Provided technical support for existing reports, dashboards or other tools.
- Collected, tracked and evaluated current business and market trend data.
- Maintained or updated business intelligence tools, databases or dashboards.
- Created or reviewed technical design documentation to drive the accuracy of reporting solutions.
- Created and designed business intelligence databases, spreadsheets or outputs.
- Created or reviewed technical design documentation to drive accuracy of reporting solutions.
- Maintained library of model documents, templates or other reusable knowledge assets.
- Assessed programs to identify risks or problems to determine appropriate responses.
- Managed diverse projects for data capture, storage and forecast analysis.
- Gathered and organized data to analyze current industry trends.
Sr. Business Analyst/Data Analyst
Citi
11.2016 - 12.2022
- Handling EMEA Trade Operation Analytics project.
- Design and develop SharePoint sites for various EMEA Trade Operation projects.
- Strong experience in implementing Out of box workflows and designed Site workflows, List workflows, Custom Page layouts, External Lists, Content Types using SharePoint Designer 2013.
- Working on various tools for SharePoint designing i.e. InfoPath, Micro-Strategy, SharePoint designer & etc.
- Designing and working on Citi collaborates for various EMEA Trade Operation projects.
- MIS reports for trade finance to keep monitored daily, weekly, and monthly & annually transactions.
- Making of PowerPoint presentation and Newsletters for senior management (Director and vice President of EMEA trade operation) for Seminars, Trainings etc.
- Prepare reports product wise, region wise, country wise and client wise.
- Dashboards for stakeholder’s product wise, region wise, country wise and client wise for their business with Citibank.
- Co-ordinate with the Client regularly and making Ad-hoc reports as per their requirement.
- Extracting data and using various tools i.e. Trims, Business object etc.
Senior QA Analyst/UAT Lead
Citi
02.2016 - 11.2016
- Led UAT for Citi Bank Home Loan accounts, managing end-to-end testing processes, writing test scripts, and ensuring alignment with business requirements.
- Coordinated with multiple teams to resolve issues and discrepancies, ensuring seamless process transitions and improving UAT timelines by 20%.
- Generated detailed MIS reports, highlighting key performance metrics and supporting informed decision-making for operational improvements.
- Writing Test Scripts as per Test Scenario’s (BRD and FRD).
- Executing the Test Scripts and record the actual result Vs Expected Data.
US Mortgage Analyst
Citi
02.2012 - 01.2016
- Handling US CitiBank Home Loan accounts.
- Analyzed and managed large volumes of mortgage data, developing packages for foreclosure and pre-foreclosure processes, improving efficiency for downstream teams.
- Collaborated with legal and financial departments, ensuring accurate data handling and compliance with mortgage regulations.
- Streamlined reporting processes and created dashboards to monitor daily and monthly performance, leading to 15% faster issue resolution.
CCG - OCC Analyst
Citi
10.2010 - 01.2012
- Handling US CITI Bank Credit Card accounts.
- Prioritizing and managing work load according to the process requirement.
- MIS report for the team (Daily Reports, Monthly Report).
- Mentoring and coaching team members about new updates.
Auto Loans - Skip Trace Analyst
Citi
01.2008 - 09.2010
- Handling Auto Loan collection for complete back end process.
- Preparing MIS report for the team.
- Monitoring Account for complete Team on weekly basis.
- Giving Training for new hires.
- Prepared Process Presentation.
- Calling Customer for verifying Personal Information.
- Resolving Customer’s Queries.
- Transferring calls to customer services dept.
- Sending Demand letters/Invoices.
Education
BSc - Physics
KC College
Mumbai01.2007
HSC - (C.B.S.E.)
K.V. Karanja
Uran, Raigad01.2003
SSC - (C.B.S.E.)
K.V. Coimbatore
Coimbatore, Tamil Nadu01.2001
Skills
- Python and Java
- SQL and MySQL
- C, C, and C#
- Business Objects, SharePoint, and SharePoint Designer
- Software testing tools: HP Quality Center, ALM, and bug tracking with Bugzilla
- SOX compliance : auditing, documentation management, access control implementation, process improvement, incident response planning, regulatory compliance, root-cause analysis, Audit support
- SAP expertise
- User access management
- MIS reporting, PowerPoint presentation for clients
- Data integration, data mining, data visualization, data analysis, data modeling with Excel, Power BI, and MicroStrategy, and trend analysis
- Financial forecasting, Predictive analytics
Passport Id Number
Z3667124
Personal Information
Date of Birth: 04/26/85
Accomplishments
- Business Analyst/Data Analyst
- Team Lead, 01/01/16
- Sr. Consultant, 01/01/11
Languages
- English
- Hindi
Job Profiles
- Sr. Analyst & Compliance, Sox Audit & Compliance, 12/01/22, Ensuring seamless compliance with regulatory requirements., Implemented and monitored access controls resulting in a 20% reduction in access-related incidents., Conducted thorough access reviews, documenting results and maintaining a 100% compliance rate with SOX regulations., Established a systematic approach to provisioning new users with the necessary access rights promptly., Developed and maintained an incident response plan to address any security incidents related to user access.
- Sr. Business Analyst/Data Analyst, Analytics & Insights, 11/01/16 to 12/01/22, Handling EMEA Trade Operation Analytics project., Design and develop SharePoint sites for various EMEA Trade Operation projects., Creating dashboards for stakeholders product wise, region wise, country wise and client wise.
- Senior QA Analyst/UAT Lead, CITI MORTGAGE, 02/01/16 to 11/01/16, Led UAT for Citi Bank Home Loan accounts, managing end-to-end testing processes., Generated detailed MIS reports, highlighting key performance metrics.
- US MORTGAGE - (GLO), CitiBank, 02/01/12 to 01/01/16, Analyzed and managed large volumes of mortgage data., Streamlined reporting processes and created dashboards to monitor daily and monthly performance.
- CCG - OCC, Citi Bank, 10/01/10 to 01/01/12, Handling US CITI Bank Credit Card accounts., Mentoring and coaching team members about new updates.
- AUTO LOANS - SKIP TRACE, Citi Bank, 01/01/08 to 09/01/10, Handling Auto Loan collection for complete back end process., Preparing MIS report for the team.
Professional Snapshot
A result-oriented professional with over 16 years of experience in operations management, data analysis, and compliance. Expertise in analyzing and interpreting complex data, developing operational procedures, and delivering insights using tools such as Power BI, MicroStrategy, and SQL. Proven track record of improving business efficiency and compliance through data-driven strategies., Python, SQL, C, C++, C#, Java (Core & Advanced), Power BI, Micro Strategy, SharePoint Designer, Business Objects, SQL Server 2000, MySQL, HP Quality Center, HP ALM, Bugzilla, SOX Audit, SAP (SOX Auditor), User Access Management, MIS Reporting, PowerPoint, SharePoint, Trims, Excel (Pivot Tables, VLOOKUP), PowerPoint, Word, Diploma in Business Analysis (US Banking), Diploma in Project and Program Management (US Banking), Python for Machine Learning & Data Science (Edureka), Software Testing Testing (Diploma from SEEDS & TCS Domain Academy), Data Integration, Data Mining, Data Visualization tools MicroStrategy & Power BI
Certification
Diploma in business analysis (U.S. banking)
Diploma in project and program management (U.S. banking)
Python for machine learning and data science (Edureka)
Software Testing Testing (Diploma from SEEDS and TCS Domain Academy)
Languages
Hindi
First Language
English
Advanced (C1)
C1
References
References available upon request.
Timeline
Sr. Analyst & Compliance
Client - ABB
12.2022 - Current
Sr. Business Analyst/Data Analyst
Citi
11.2016 - 12.2022
Senior QA Analyst/UAT Lead
Citi
02.2016 - 11.2016
US Mortgage Analyst
Citi
02.2012 - 01.2016
CCG - OCC Analyst
Citi
10.2010 - 01.2012
Auto Loans - Skip Trace Analyst
Citi
01.2008 - 09.2010
BSc - Physics
KC College
HSC - (C.B.S.E.)
K.V. Karanja
SSC - (C.B.S.E.)
K.V. Coimbatore
Similar Profiles
KUMMARA NARESHKUMMARA NARESH
Testing Engineer at ALP Consulting (Client: ABB Global Industries and Services)Testing Engineer at ALP Consulting (Client: ABB Global Industries and Services)
Priyanka PurohitPriyanka Purohit
Module Lead at SYSCOVERY (CLIENT: ABB)Module Lead at SYSCOVERY (CLIENT: ABB)
Ganesh Kumar ShanmugamGanesh Kumar Shanmugam
Release Test Lead/Coordinator at Client-AIG|Org-AccentureRelease Test Lead/Coordinator at Client-AIG|Org-Accenture
Vilien DengléVilien Denglé
Business Director at RAYMOND CONSUMER CARE PVT. LTD.Business Director at RAYMOND CONSUMER CARE PVT. LTD.
Janvi Jagannath ParabJanvi Jagannath Parab
Deputy Manager – Finance and Accounts at MAHINDRA SUMMIT AGRISCIENCE LTD.Deputy Manager – Finance and Accounts at MAHINDRA SUMMIT AGRISCIENCE LTD.