Data Analyst

Sivagami Thinnappan

Data Analyst

+1-201-***-**** ********.*******@*****.*** NJ-08876 LinkedIn SUMMARY

Data Analyst with 5 years of experience in managing data projects, including analysis, design, data modeling, implementation, and application maintenance across OLTP and OLAP systems. Skilled in both Agile and Waterfall methodologies with strong expertise in regulatory compliance, including CCPA, and GDPR. Proficient in applying Data Warehousing principles such as Fact and Dimension tables, Star and Snowflake schema modeling, improving query performance and data retrieval efficiency. Experienced in leveraging cloud platforms like AWS for scalable data storage, processing, and analysis, while designing and delivering impactful dashboards and reports through Power BI and Tableau to drive business insights and decision-making. SKILLS

Data Analysis & Visualization: SQL, Excel, Power BI, Tableau, Google Data Studio, Looker, DAX, Power Query Statistical Analysis & Modeling: Descriptive & Inferential Statistics, Regression Analysis, Hypothesis Testing, Forecasting, A/B Testing, Time Series Analysis

Programming & Analytics Tools: Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn), R (ggplot2), Jupyter Notebook Databases & Warehousing: MySQL, PostgreSQL, SQL Server, Snowflake, BigQuery, Azure SQL Cloud & BI Tools: AWS (Redshift, QuickSight), GCP (BigQuery), Microsoft Azure (Synapse, SQL) Business & Reporting Tools: JIRA, Confluence, Microsoft PowerPoint, Notion Collaboration: Git, GitHub, Slack, MS Teams

EXPERIENCE

Data Analyst, State Street, USA Nov 2024 – Present

Coordinated with the Data Warehouse team in developing Dimensional Models and analyzing ER-Diagrams to support financial data systems.

Developed interactive dashboards using Power BI and Looker, enabling real-time financial data visualization and improving business decision-making efficiency by 30%.

Optimized data warehousing and analytics by implementing Snowflake, reducing query execution time by 22% and enhancing financial data accessibility across teams.

Engineered a data warehouse solution on AWS Redshift, integrating multiple financial data sources and reducing query processing time by 50%, empowering cross-functional teams with accurate insights for strategic planning. Data Analyst, FISERV, USA Jun 2021 – Oct 2024

Spearheaded a cross-functional initiative employing a hybrid project management approach, combining elements of Agile, to ensure comprehensive project oversight and timely delivery of critical milestones.

Defined ETL mapping specification and designed the ETL process to source the data from sources and load data into DWH.

Incorporated MS Excel, Pivot Tables, and VLOOKUP to streamline data analysis, reducing data processing time by 40% and enhancing report accuracy for business decision-making.

Designed mapping and identified and resolved performance bottlenecks in Source to Target, Mappings.

Wrote, tested, and optimized triggers, stored procedures, and functions at the database level using PL/SQL, improving the performance of query by 15% and reducing execution time.

Executed Python, R, and SQL for comprehensive data analysis, modeling, and manipulation, harnessing libraries such as NumPy, Pandas, Matplotlib, ggplot2, and Scikit-learn to extract actionable insights.

Leveraged BigID for comprehensive data mapping and lineage, ensuring 100% accurate data governance and adherence to regulatory requirements.

Data Analyst, Streebo Inc, INDIA Jun 2016 – Aug 2017

Developed and fine-tuned machine learning models for predictive analytics and classification tasks utilizing the Scikit-learn library, achieving robust and accurate results.

Crafted visually engaging dashboards and detailed reports using Tableau and Microsoft Excel, improving data accessibility and decision-making capabilities for stakeholders.

Harnessed the power of DataBricks for scalable data processing and collaborative analytics within a cloud-based environment, improving data processing by 50% and team collaboration across departments.

Employed version control and facilitated collaborative development using GitLab, maintaining smooth workflows and codebase management across projects.

EDUCATION

Master’s in Analytics, Harrisburg University of Science and Technology, PA, USA Oct 2019 – May 2021 Bachelor’s in Electrical, and Electronics Engineering, Thiagarajar College of Engineering, TN, India Aug 2012 – May 2016

Contact this candidate