Dinesh Kumar Email and Phone Number

Client: PNC BankProject: Portfolio Command Module, AML Analytics Hub (AAH)Responsibilities• Managed the entire data analytics lifecycle from requirement gathering through to business question definition, data analysis and interpretation, data visualisation and creating reports and dashboards.• Sourced and validated data from multiple platforms (MS SQL, MDM, Fenergo) to synthesize and analyze information, generating insights that influenced key business decisions.• Apply data visualization techniques to analyse and interpret large datasets and analyse results using statistical techniques. Identifying trends, patterns, and correlations that provide actionable insights.• Developed visual Reports, dashboards and KPI scorecards on power BI and Tableau desktop using visualisation best practices and effective data visualisations.• Proficient with SQL, experience in writing SQL and DAX queries to create measures and calculations.• Managed Power BI workspace and Tableau server to publish and manage reports, dashboards, data sources, schedule extract refresh, manage user/group permissions and monitor jobs and alerts.• Working closely with the operational teams to monitor progress and ensure that the plans are well defined, clearly communicated and executed well.• Documented processes and policies to ensure consistency and facilitate knowledge transfer.

Data Analyst- Reporting (April 2016- March 2019) Global Trade Repository (GTR), DTCC, NA Responsibilities:• Solves complex business problems and provides technical expertise for clients in derivatives.• Managed Monthly, weekly position/status reports and ad-hoc reporting.• Diagnose and resolve issues pertaining to Business clients (participants/ regulators) on post trade clearance, settlement and reconciliation of real time trades.• Developing KT (Knowledge Transition), SOPs (Standard operating procedures) and process documents to improve the quality and efficiency of daily operations.• Providing relevant data from Database and server to troubleshoot major incidents and assisting in resolution.Achievements• Developed a splunk dashboard for the operation teams to query client’s recent trade history for different asset classes allowing a faster response time to meet client needs.Systems Used:Excel, Unix, Putty, Autosys, SecureFX, Toad, Greenplum, ServiceNow, Salesforce, Splunk

Application Support Analyst Citidirect, Citibank, NAResponsibilities:• Manage Infrastructure and daily operations for global banking applications. (Citidirect Online Banking, CitiDirect Classic)• Liaise with various internal groups and triage issues along with Dev Teams• Involved in major deployments (Unix, Windows and service layer deployments) and release activities and providing cut over support• Scheduling/ monitoring of server and application related alerts using Autosys and SiteScope• Responsible for performing DB configuration changes