Badges
Certifications
Work Experience
Criminal Data Analyst
San Francisco Superior Court• October 2019 - Present
• Research San Francisco’s criminal data to present data-driven insights & build data reports for the Safety & Justice committee to help reduce the Jail population and shut down the County Jail 4 • Query & analyze several data warehouses using advanced SQL to discover metrics prolonging case duration to assist attorneys and judges and also decrease racial disparities • Build real-time Power BI dashboards of case data to expedite courtroom decision making and serve as a general dashboard for the court managers & chief officers • Collaborate with Stanford University’s computational lab and test their artificial Intelligence-powered tools to remove racial bias in the criminal justice system • Counsel multiple criminal justice agencies like Sheriff's Office, District Attorney, Public Defender, SFPD, and community justice by representing San Francisco court as a data consultant for all their data requests, identify and re-evaluate data measures to reduce incarceration and analyze recidivism rates • Facilitate Public policy graduate interns from Stanford & UC Berkeley on data management, validation, and analytics • Attend data requests from the Mayor’s office and various non-profit organizations for information on crime demographics whilst making changes to public policies • Ensure data quality across all criminal justice agencies and validate court data entries • Integrate with UC Berkeley's Policy lab researchers to advocate data measures to reduce incarceration • Build ad-hoc reports, respond to data requests from senior executives, other criminal justice agencies for data-driven decision making • Visualize data trends and data patterns using python’s machine learning packages to identify factors influencing recidivism rates & incarceration
Data Analyst/Big Data
AT&T• July 2019 - September 2019
• Create, automate and maintain weekly dashboards using Tableau to track call dispositions of DirecTV set-top boxes and AT&T routers for Executive level decision making • Perform yearly cost analysis based on projected calls, device costs, and technical labor costs for Executive level decision making • Create complex SQL queries to gather data from various tables across data lakes, and data warehouses like Teradata, Cognos, Hive, Hadoop, New Relic, and Snowflake • Process gigabytes of text files using python to create summary metrics for senior management • Develop logistic regression models predicting the probability of technical calls, service rollouts based on engineering metric • Script stored procedures and functions for data ETL and automation of reports for real-time data on Kibana • Ad-hoc projects utilizing linear/logistic regression, clustering, PCA and other statistical tools • Query data lakes and data warehouses for data analysis/mining to gather required information requested by SLA’s with 1-business day turnaround
Data Analyst
California State University Fullerton • October 2017 - May 2019
Collect, clean, and perform data analysis on 40,000+ vendor products to improve demand forecasting that reduced backorders to retail partners by 15% Created visually impactful dashboards and reports in Tableau and Excel for data reporting and analyze data to identify key metrics and optimize data delivery Develop data modeling, and ETL mapping solutions within structured data warehouse environment Interpret and analyze data to identify key metrics and transform raw data into meaningful, actionable information using SSIS, SSAS, SSRS, and T-SQL
Data Network Engineer
Al Futtaim Technologies• January 2016 - July 2017
Designed and implemented IT systems for Dubai Airports, banking firms, and hotel industries for reliable data connectivity and information security that drastically improved service-level agreements Collaborate with internal and external peers to design data communication equipment’s and administer various projects Review development of software and systems using advanced analysis and models to predict and measure outcomes, consequences and set project milestones for clients Prepared scope of work and performed cost analysis to ensure project feasibility and resolve conflicts and best serve client needs
IT Engineer
Techcomputer• July 2014 - June 2015
Generated easy-to-interpret regression reports using MS Excel and pivot tables for data modeling Interviewed, trained four new employees on database querying, customer service, ITSM, and clerical tasks Extract, transform, and load data using SQL, ad-hoc data query building and extraction on regular basis Diagnose ETL and database related issues, perform root cause analysis, and recommend corrective actions to management
Education
California State University, Fullerton
Computer Information Systems, MS• August 2017 - May 2019
Information Systems - Business Analytics