Data Analyst - SQL, Python, BI, Fraud & Compliance

SHIVA RAJ HARINATH REDDY

Union City, NJ +* (***) 212-184 ********.**********@*****.*** LinkedIn GitHub SUMMARY

Results-driven Data Analyst with 4+ years of experience in SQL, Python, and BI tools like Power BI and Tableau. Skilled in building predictive models, automating reports, and creating dashboards that improve business insights and decision-making. Strong background in data cleaning, segmentation, A/B testing, and regulatory reporting. Experienced in cloud platforms and big data technologies, collaborating effectively with cross-functional teams to deliver data-driven solutions. WORK EXPERIENCE

Citi, New York, NY Data Analyst Feb 2025 – Current

• Analyzed 120M+ monthly banking transactions using SQL, Python (Pandas, NumPy) and workflows to uncover high-risk patterns such as velocity spikes, geo-location deviation, MCC anomalies, and device mismatches, improving fraud-case triage accuracy.

• Engineered 30+ fraud-risk features in Python and SQL—including burst-transaction velocity, device-fingerprint mismatch scores, and merchant-risk indices—enhancing model input quality and reducing false positives by 14.6%.

• Built automated KPI/KRI dashboards using Tableau to monitor alert-to-case conversion, false-positive rates, SAR trends, and high-risk corridors, cutting investigator triage time by 22%.

• Consolidated multi-source datasets using SQL, and Python ETL pipelines by integrating KYC profiles, OFAC/PEP lists, device logs, and historical fraud alerts, ensuring 100% regulatory data completeness for AML and fraud monitoring.

• Developed automated SQL-based reporting pipelines and analytics workflows in Python/Dataiku, reducing manual reconciliation by 40% and improving audit readiness for OCC/FRB compliance reviews. PTC, Boston, MA Data Analyst May 2024 – Nov 2024

• Analyzed a manufacturing client’s IoT telemetry and PLM data using SQL and Python (Pandas, NumPy) to identify downtime drivers and workflow bottlenecks, increasing equipment utilization by 19%.

• Built real-time Power BI dashboards by integrating sensor streams, maintenance logs, and Windchill usage metrics, giving plant managers visibility into asset performance and reducing resolution time by 27%.

• Measured the impact of new ThingWorx digital workflows through A/B testing with SciPy and Statsmodels, providing insights that improved technician productivity by 13%.

Sigma Infosolutions Ltd., Bengaluru, IN Data Analyst Nov 2020 – Jul 2023

• Leveraged SQL and Python (Pandas) to integrate and clean large-scale e-commerce datasets including product catalog, customer transactions, and website clickstream logs, improving data accuracy for merchandising and marketing teams by 30%.

• Conducted in-depth exploratory and statistical analysis using NumPy and Scikit-learn, identifying trends in customer purchasing behavior, cart abandonment, and product affinity that informed targeted promotional strategies.

• Designed interactive Power BI and Tableau dashboards that visualized sales performance, conversion funnels, inventory movement, and campaign ROI, enabling stakeholders to act quickly on real-time business insights.

• Automated ETL pipelines and scheduled data refresh workflows using Python scripts and SQL stored procedures, reducing manual reporting time by 40% and ensuring timely availability of updated sales and inventory data.

• Partnered with marketing, supply chain, and IT teams to translate business needs into scalable data solutions—enhancing order fulfillment accuracy, improving demand forecasting, and optimizing digital marketing spend.

• Documented analytics processes, data definitions, and reporting workflows in alignment with data governance standards, ensuring cross- team transparency and improving onboarding for new analysts. SKILLS

Programming Languages & Methodologies: Python, SQL, R, SCALA, SDLC, Agile/ Scrum, Waterfall Databases: MySQL, MS SQL Server

Python Packages: Pandas, NumPy, Matplotlib, SciPy, Scikit-Learn, Seaborn, PyTorch, TensorFlow, ggplot2, Plotly, Keras Data Analytics: Data Manipulation, Data Cleaning, Data Visualization, Exploratory Data Analysis, Data Analysis Statistical & Analytical Methods: Regression Analysis, Time Series Forecasting, Cluster Analysis, Classification Techniques, Dimensionality Reduction, Anomaly Detection, Variance Analysis, Cost-Benefit Analysis, Ratio Analysis, Valuation Techniques Other Technicals: AWS, AZURE(Databricks), NLP, A/B Testing, Hypothesis testing, ETL, Databricks, Hadoop, Spark, Snowflake, Big Query, Apache Airflow, Presentation Skills, Problem-Solving Tools: Tableau, Power BI, Advanced Excel, MS Office Suite (Excel, Visio, Access, Word, PowerPoint), Visual Studio, Jupyter EDUCATION

Stevens Institute of Technology Hoboken, NJ

Master of Science in Data Science Dec 2024

Cambridge Institute of Technology Bengaluru, IN

Bachelor of Technology in Information Science and Engineering May 2023 PROJECTS

Healthcare Claims Cost Analysis & Forecasting Jan 2024 – Mar 2024

• Cleaned and processed 1.5M+ health insurance claim records using Python and SQL, ensuring data accuracy across multiple hospital networks and building SQL queries for key KPI extraction integrated into Power BI dashboards for stakeholders.

• Performed exploratory data analysis, outlier detection, and developed time-series forecasting models using Prophet and scikit-learn to predict monthly claims, enhancing budget predictability by 28%.

• Created executive-level Tableau dashboards to visualize cost anomalies, fraud indicators, and claim cycle timelines, enabling improved operational decisions in finance and compliance teams. Human Resource Analytics Dashboard Jan 2023 – Apr 2023

• Employed Tableau to create visually impactful charts, graphs, and dashboards from complex HR datasets, contributing to a redu ction in employee turnover within the first year.

• Enhanced data visualization capabilities by developing dashboards, which led to a 20% improvement in resource allocation efficiency. CERTIFICATIONS

• Data Analysis with R Programming – Google

• Google Data Analytics Specialization – Google

Contact this candidate