Jiani Song

Jiani Song

Technical Consultant
United States of America

About Me

Technical Consultant with experience in ETL pipeline orchestration, SQL development and optimization, business intelligence, and data analytics. Holds an M.S. in Statistics from the University of Chicago and a B.A. in St…

Experience

Technical Consultant

BeaconFire Solutions
Jan 2023 - Present · 3 years 6 months

1. ETL strategy: Orchestrate robust ETL pipelines using SSIS, facilitating seamless data extraction from various sources, transformation, and loading into target databases for in-depth analysis. Formulate error-handling strategies to enhance process efficiency.
2. SQL development and optimization: Administer database management operations, develop complex SQL scripts and stored procedures. Leverage advanced optimization techniques including indexing strategies, query structure. refinement, data partitioning, and materialized views to drastically reduce elapse time from hours to several minutes.
3. Business intelligence: Proficient in using BI tools like Tableau and Power BI, creating interactive and insightful visualizations to effectively present insights and support data-driven decision-making.
4. Data analytics and model implementation: Leverage strong analytical skills to construct machine learning models, translating intricate data patterns into actionable business insights.

Technical Consultant

BeaconFire Solution, East Windsor, NJ
Jan 2023 - Present · 3 years 6 months

Orchestrated robust ETL pipelines using SSIS for data extraction, transformation, and loading into target databases.
Formulated error-handling strategies to enhance process efficiency.
Administered database management operations.
Developed complex SQL scripts and stored procedures.
Applied indexing strategies, query structure refinement, data partitioning, and materialized views to reduce elapsed time from hours to several minutes.
Created interactive visualizations using Tableau and Power BI to support data-driven decision-making.
Constructed machine learning models to translate data patterns into actionable business insights.

Quantitative Risk Analyst Intern

Lions Financial Assurance, New York, NY
Jun 2021 - Jul 2021 · 1 month

Conducted detailed research of the Cruise market.
Gauged the COVID-19 impact and projected a 2-year performance trajectory.
Collected, processed, and evaluated financial data of target companies post-IPO.
Utilized time-series plots, moving averages, and data visualization for performance assessment.
Focused on return rates, volatility, and the Sharpe Ratio.
Implemented quantitative risk models using regression analysis and stochastic models.
Identified, quantified, and predicted potential financial risks.
Conducted a comprehensive business analysis for Didi Global Inc.
Scrutinized IPO pricing, ongoing challenges, competitive landscape, future outlook, and investment recommendations.

Skills

Data Evaluation ETL Data Integration and Transformation (ETL) SQL Database Data Representation SQL Python Tableau Power BI Microsoft Office Suite AWS S3 AWS RDS AWS DMS AWS Lambda AWS Glue AWS CloudWatch AWS SNS Statistical Modeling Machine Learning Time Series Analysis Project Management SSIS Stored Procedures Indexing Query Optimization Data Partitioning Materialized Views Regression Analysis Stochastic Models Logistic Regression Lasso Causal Lasso KNN Random Forest Neural Network Exploratory Data Analysis Data Cleaning Data Validation Data Transformation Normalization Aggregation Feature Engineering
Report this Profile?