Shriram Rajalakshmi Sankaranarayanan
Senior Data Analytics Senior Data Engineer @Fidelity Investments
Signup · Get unlimited contacts
WORK HISTORY
Senior Data Analytics Senior Data Engineer @Fidelity Investments
Developed complex SQL queries and stored procedures to extract financial transactions, reconcile ledgers, and support month-end closing processes, reducing reporting lag by 30%.Built automated ETL pipelines using Azure Data Factory to ingest, clean, and standardize investment portfolio data from multiple sources including APIs, flat files, and databases.Created interactive Power BI dashboards to visualize key financial KPIs like revenue variance, cost allocations, and forecast vs. actuals, enabling leadership to make data-driven decisions.Used Python for data cleaning and transformation, building reusable scripts to handle missing values, detect outliers, and automate routine data validation tasks across financial datasets.Collaborated with finance and audit teams to design reporting templates for compliance and internal controls, ensuring SOX readiness and data auditability.Leveraged Azure SQL Database to store structured financial data with optimized indexing, improving query performance and ensuring faster access for analysts and stakeholders.Performed data profiling and data quality checks across large datasets (10M+ records) to ensure data integrity in revenue, billing, and general ledger tables.Scheduled and monitored data pipelines in Azure, ensuring timely data refresh for dashboards used in treasury, budgeting, and forecasting operations.Applied statistical techniques in Python (pandas, statsmodels) to analyze financial ratios, trends, and variances, helping identify anomalies in expense reporting and asset management.Collaborated cross-functionally with business analysts and IT teams to translate financial requirements into scalable analytical solutions, contributing to automation of reporting processes and reducing manual intervention by 40%.
EDUCATION
University at Buffalo
Master's degree, Master's in Industrial Engineering - Data Analytics Engineering
Panimalar Engineering College
Bachelor of Engineering - BE, Computer Science and Engineering
ABOUT SHRIRAM RAJALAKSHMI SANKARANARAYANAN
Result-driven Data Analyst with over 5 years of experience in extracting, analyzing, and visualizing data to support data-driven decision-making in enterprise environments. Proficient in SQL for querying, data transformation, and building complex joins, subqueries, and CTEs to analyze large relational datasets efficiently. Skilled in Power BI for developing interactive dashboards, creating KPIs, and applying DAX calculations to provide real-time business insights and drill-down capabilities.Hands-on experience with Azure Data Factory for designing scalable ETL pipelines, automating ingestion, transformation, and loading of structured and semi-structured data into Azure SQL and Synapse. Strong background in Python for data preprocessing, exploratory data analysis (EDA), and automation using libraries like pandas, numpy, matplotlib, and openpyxl.Experienced in building cloud-based data workflows using Azure services, including Blob Storage, Azure SQL Database, and Key Vault, ensuring secure and scalable data access. Familiar with data quality frameworks, using Python and SQL to validate, clean, and transform raw data into consistent and accurate datasets for reporting. Demonstrated ability to work cross-functionally with stakeholders to gather business requirements, define KPIs, and deliver self-service reporting solutions using Power BI and Azure.Adept at writing performance-optimized T-SQL queries and stored procedures for reporting, slicing datasets by dimensions such as time, location, and user behavior. Strong communication and documentation skills, with a track record of delivering actionable insights and automating repetitive reporting tasks to save team bandwidth.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.