Data Analytics & BI Specialist with SQL/Python Expertise

Shobhitha Rajanand

Princeton, NJ 857-***-**** ********.*@************.*** LinkedIn

EDUCATION

Northeastern University, Boston, MA Sep 2022 - Dec 2024 Master of Science - Information Systems

Ramaiah Institute of Technology, India Aug 2017 - Aug 2021 Bachelor of Engineering – Electronics and Instrumentation TECHNICAL SKILLS

Databases: MySQL, SQL Server, Oracle, PostgreSQL, NoSQL (MongoDB, DynamoDB, Cassandra),Hive, Teradata Programming Languages: SQL, Python(Pandas, NumPy, PyTorch, TensorFlow, Seaborn), R ETL Tools: Talend Studio, Alteryx, SSIS, Informatica, Apache Spark, Apache Airflow Cloud Technologies: AWS (S3, Redshift, EC2, RDS, Glue, Athena, Lambda, Quicksight, Kinesis), Azure Data Factory, GCP Azure Databricks, BigQuery, Snowflake

Data Visualization: Tableau, MS Power BI, Looker, QlikView Other Tools: GitHub, Jira, ER Studio, Excel, PowerPoint, Bitbucket, Sharepoint, Jupyter Notebook, SAS, Visual Basic Soft Skills: analytical skills, written and verbal communication skills, fast-paced, growth mindset, attention to detail, problem-solving skills, interpersonal skills, self-starter, organizational skills, critical thinking PROFESSIONAL EXPERIENCE

IpserLab LLC, USA Feb 2025 - Present

Financial Data Analyst

Led enterprise-level data quality analysis on large procurement and financial datasets using SQL, ensuring high data integrity for internal analytics and product reporting used by cross-functional teams

Streamlined data validation and transformation workflows through Python (Pandas), reducing manual effort by 30% and improving reliability of product-ready datasets

Collaborated with cross functional teams to identify, investigate, and resolve critical data discrepancies, using Microsoft Excel for validation, reconciliation, and ad hoc analysis, delivering corrected outputs within 6 hours and consistently exceeding stakeholder reporting SLAs

Owned the development and enhancement of Power BI dashboards and reports, translating business and product requirements into clear visual metrics and KPIs, improving insight visibility and enabling leadership and product teams to make informed decisions

State Street Corporation, USA Jul 2023 - Dec 2023

Data Analyst

Utilized financial data for Investment Management analysis and spearheaded the design of a dynamic documentation system, ensuring compliance and leveraging SQL, reducing manual efforts by 90%

Leveraged complex SQL queries to extract, transform, and load data into AWS Redshift from multiple sources. Enhanced data efficiency and reduced retrieval times by 40%, improving accessibility for cross-functional teams

Developed interactive and visually compelling dashboards and reports using Tableau, facilitating stakeholders to gain insights into key performance indicators (KPIs) and trends, resulting 20% increase in decision-making optimization Bhadra River Project (BRP), India Sep 2021 – Mar 2022 Data Analyst Intern

Designed and implemented Data Ingestion architecture using Python to process water transmission and distribution data, performed transformations into relational databases that reduced job execution time by 63%

Built predictive machine learning models using Regression algorithm in Python to advise on optimal water flow controls, enhancing electricity generation performance by 77%

Performed exploratory analysis in R to identify key parameters influencing hydro power generation, reducing dataset dimensionality using PCA and fine-tuning statistically significant predictor variables ACADEMIC PROJECTS

IMDB Movies and Data Analysis (Alteryx, SQL Server, Power BI )

Staged 100 million rows of worldwide movie details from IMDB, Movie Lens TSV files using Alteryx

Architected a dimensional model using ER Studio and SQL to build a data warehouse of IMDB, Movie Lens data

Optimized ETL pipelines in Alteryx ensuring one-click data loading into DW from staging tables, implemented robust error handling, and created dynamic dashboards in Power BI for actionable insights Blood Donation Management System (SQL Server, ER Studio, Tableau)

Designed an Entity-Relationship Model in Third Normal Form using ER Studio, implemented SQL computed columns, views, functions, and triggers, and developed compelling Tableau dashboards to extract actionable insights and trends

Contact this candidate