mjsushanth.github.io/operational-reporting.html at main · mjsushanth/mjsushanth.github.io · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Operational Reporting - Joel Markapudi</title>
    <style>
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }

        body {
            font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, sans-serif;
            line-height: 1.6;
            color: #333;
            background: #f5f5f0;
        }

        .container {
            max-width: 920px;
            margin: 0 auto;
            padding: 50px 30px 40px 30px;
            background: #fafaf5;
            min-height: 100vh;
        }

        .back-link {
            display: inline-flex;
            align-items: center;
            color: #4a90e2;
            text-decoration: none;
            margin-bottom: 30px;
            font-size: 0.95rem;
            transition: color 0.3s;
        }

        .back-link:hover {
            color: #357abd;
        }

        h1 {
            font-size: 2.2rem;
            font-weight: 400;
            margin-bottom: 10px;
            color: #2c2c2c;
            line-height: 1.3;
        }

        .role-info {
            font-size: 1.05rem;
            color: #666;
            margin-bottom: 8px;
        }

        .date-range {
            font-size: 0.95rem;
            color: #777;
            margin-bottom: 20px;
        }

        .project-overview {
            color: #555;
            font-size: 1.05rem;
            margin-bottom: 25px;
            padding-bottom: 20px;
            border-bottom: 2px solid #e0e0d8;
            line-height: 1.7;
        }

        .highlights {
            margin-top: 25px;
        }

        .highlights ul {
            list-style: none;
            margin: 0;
            padding: 0;
        }

        .highlights li {
            margin-bottom: 16px;
            padding-left: 20px;
            position: relative;
            color: #555;
            line-height: 1.7;
        }

        .highlights li:before {
            content: "•";
            position: absolute;
            left: 0;
            color: #4a90e2;
            font-weight: bold;
            font-size: 1.2rem;
        }

        strong {
            color: #2c2c2c;
            font-weight: 500;
        }

        @media (max-width: 768px) {
            .container {
                padding: 35px 20px;
            }

            h1 {
                font-size: 1.8rem;
            }
        }
    </style>
</head>
<body>
    <div class="container">
        <a href="index.html" class="back-link">← Back to Portfolio</a>

        <h1>Operational Reporting & Data Warehouse</h1>
        <div class="role-info">Data Engineer & BI Developer • Innova Solutions</div>
        <div class="date-range">May 2022 – November 2023</div>

        <div class="project-overview">
            Architected enterprise data warehouse integrating multiple staffing systems (Bullhorn/HGC/JobDiva/Oracle EBS) with 25+ PL/SQL procedures across 40+ star-schema tables. Engineered entity resolution achieving 88% accuracy and delivered operational reporting dashboards serving 300+ KPIs with forecasting, actuals-vs-baseline tracking, and rollups across individual, team, and division hierarchies.
        </div>

        <div class="highlights">
            <ul>
                <li><strong>Enterprise Data Warehouse Architecture:</strong> Architected enterprise data warehouse integrating Bullhorn/HGC/JobDiva/Oracle EBS with 25+ PL/SQL procedures across 40+ star-schema tables. Implemented SCD Type 2 historization for tracking dimensional changes over time</li>

                <li><strong>Multi-System Entity Resolution:</strong> Engineered entity resolution using 6+ fuzzy matching patterns and dual-path PnL attribution logic, achieving 88% accuracy in reconciling records across disparate staffing and financial systems</li>

                <li><strong>Data Governance & Quality Layer:</strong> Built a data governance and reliability layer with automated validation, duplicate detection, cross-system ID reconciliation, and role classification with tenure/designation mapping logic, reducing manual verification workflows and improving data trustworthiness</li>

                <li><strong>Executive Analytics Dashboards:</strong> Delivered operational reporting dashboards serving 300+ KPIs with forecasting, actuals-vs-baseline tracking, and rollups across individual, team, and division hierarchies for executive and producer analytics</li>

                <li><strong>Advanced Drill-Down Capabilities:</strong> Enabled matrix-style drill-down for faster exploratory analytics, root cause analysis (RCA), and improved reporting accuracy, allowing stakeholders to investigate performance metrics from multiple dimensional perspectives</li>
            </ul>
        </div>
    </div>
</body>
</html>