prashanth j
Specialist at Deloitte India (Offices of the US)
Hyderabad
16+ years of work experience
Jun 20188 yrs 1 moPresent
Complex Dataset Analysis: Analyze large and complex datasets across diverse business units to successfully identify performance trends, anomalies, and critical business insights.
Advanced SQL Scripting: Write highly optimized SQL queries utilizing complex joins, subqueries, Common Table Expressions (CTEs), window functions, and stored procedures for robust data extraction, validation, and transformation.
Relational Database Competency: Work directly with enterprise relational databases including MySQL and Oracle to execute queries and validate multi-layered datasets.
KPI Dashboards Development: Develop and maintain automated reporting solutions, interactive dashboards, and visual metrics using business intelligence tools such as Power BI, Tableau, and Advanced Excel.
Data Quality & Governance Alignment: Execute rigorous data quality checks, structural data validation, and root cause analysis while ensuring data accuracy, consistency, and alignment with corporate governance standards.
Cross-Functional Collaboration: Partner directly with cross-functional technical teams—including Product and Operations groups—to interpret requirements and deliver end-to-end data processing tracks.
Business Documentation: Author comprehensive documentation covering core business logic, strict data definitions, and reporting workflows to maintain team alignment and continuity.
Ad-hoc Analysis & Insights Support: Support leadership and various business units with rapid-turnaround ad-hoc data analysis, technical data interpretation, and quantitative decision support.
Jul 201511 yrsPresent
Greater Hyderabad Area
Coordination and Tools designing
Oct 201410 mosJul 2015
Process Automation: Created complex macro solutions inside MS Excel, MS Access, Word, and PowerPoint to streamline repetitive tracking datasets and dramatically decrease manual reporting workloads.
Advanced Excel Modeling: Handled large operational metrics using advanced data properties such as Pivot Tables, VLOOKUP/XLOOKUP, and complex functional formulas to maintain strict data consistency.
Operational Task Allocation: Served as a workflow coordinator, assigning operational tasks to resources based on skillset profiles, tracking daily team performance, and maintaining secure SharePoint data repositories.
Jan 20123 yrs 6 mosJun 2015
Performance Metric Monitoring: Tracked large datasets reflecting call center efficiency indicators (Service Level, ASA, occupancy, schedule adherence, handle times) across multi-channel environments.
Automated Reporting Solutions: Designed automated performance reporting workflows by pulling data from core systems (Avaya and Business Objects) directly into Outlook using VBA scripting to deliver interval-wise analytics.
Ad-hoc Problem Solving: Interpreted high-volume transactional exceptions and real-time operational trends to support management with quick adjustments, optimizing operations workflow and data accuracy.
Jul 20101 yr 7 mosJan 2012
Education
Bachelor of Technology, Computer Engineering
Swami Vivekananda Institute of Technology
20064 yrs2010
Join prashanth and 10k+ other professionals on
Tal is the app where bosses meet engineers & builders directly, without middlemen
Download Tal Boss