Sankar Paramasivan

Cloud Migration & Architecture

• Led end-to-end migration of SQL Server databases and stored procedures to AWS RDS PostgreSQL across Dev, UAT, and Production environments.
• Spearheaded the transition from a legacy Hadoop to an AWS Data Lakehouse, reducing infrastructure costs by 30% and improving job reliability from 70% to 98%.
• Directed a team of six engineers to migrate 5 TB of transactional data, optimizing over 300 ETL jobs in the first quarter post-deployment.

Data Engineering & Pipeline Optimization

• Designed and implemented scalable ETL/ELT pipelines using Pyspark, Snowflake, and AWS Glue for batch and streaming data.
• Developed Pyspark scripts for large-scale transformations, reducing processing time by 30%.
• Built robust data quality control frameworks using AWS Glue, S3, Event Bridge, and Step Functions.
• Engineered egress pipelines for AWS S3 and Snowflake via EMR Pyspark, achieving a 30% reduction in processing time.
• Improved Snowflake query execution and ingestion latency by 20–30% through advanced optimization techniques.

BI & Analytics

• Developed over 100 dynamic Tableau dashboards with advanced parameters and manual SQL tuning.
• Converted SAS dashboards into Snowflake pipelines and Tableau visualizations for modernized reporting.
• Automated Tableau data extracts and scheduling using Airflow and Python, streamlining analytics workflows.
• Customized dashboards to visualize complex datasets, enabling actionable insights across business units.

Data Governance & Collaboration

• Defined and enforced data governance standards in collaboration with cross-functional teams.
• Provided technical leadership through code reviews, best practices, and mentoring in Snowflake, ETL, and Tableau development.

• Led end-to-end development and optimization of Tableau dashboards and Cognos reports for healthcare analytics, improving data visibility and decision-making.
• Validated report outputs against source systems using SQL queries to ensure data accuracy, reliability, and stakeholder confidence.
• Migrated Cognos packages and dashboards across DEV, TEST, and PROD environments, ensuring seamless deployment and version control.
• Resolved ETL failures in Cognos Data Manager and Informatica, enhancing data pipeline stability and report delivery timelines.
• Mentored junior developers in SQL tuning, dashboard design best practices, and performance optimization techniques.
• Designed rich Tableau dashboards with dynamic prompts, custom calculations, filters, and conditional formatting to meet complex business requirements.
• Supported production reporting, ensuring timely delivery of critical insights and continuous improvement of data quality.
• Applied relational data modeling principles to support scalable and maintainable BI architecture.
• Optimized Cognos performance via Framework Manager tuning, reducing report latency and improving user experience.
• Contributed to project estimation, planning, and requirement analysis, collaborating with cross-functional teams to deliver high-impact BI solutions.
• Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.

• Built and optimized dashboards for healthcare analytics
• Validated data accuracy with SQL checks
• Migrated Cognos packages across environments
• Fixed ETL issues in Cognos Data Manager & Informatica
• Mentored juniors in SQL and dashboard design
• Designed rich Tableau dashboards with filters and calculations
• Supported production reports and improved data quality
• Tuned Cognos performance using Framework Manager
  

• Designed and developed Cognos and SAS reports for high-profile clients including GSK and Astrazeneca, supporting strategic decision-making across business units.
• Optimized Oracle Workloads: Created robust PL/SQL procedures, views, and packages to handle high-volume data processing, improving system reliability and throughput.
• Enhanced Reporting Functionality: Integrated JavaScript into Cognos reports for dynamic interactivity and automated job scheduling, streamlining report delivery and user experience.
• Led BI Package Migrations: Managed end-to-end migration of BI packages across environments, resolving production issues and ensuring seamless deployment.
• Cross-Functional Collaboration: Partnered with software engineers, analysts, and stakeholders to deliver scalable solutions, demonstrating strong communication and negotiation skills.
• Client Engagement & Delivery: Maintained close client relationships to ensure timely delivery of project milestones and alignment with business goals.
• Project Planning & Estimation: Contributed to requirement analysis, effort estimation, and planning phases, leading to successful design and rollout of Cognos Framework Models and BI reports.
• Performance Tuning: Optimized Cognos reports and Cubes, reducing run times by 30% and enhancing operational efficiency.
• Data Integration: Developed PL/SQL scripts to load and transform data into Oracle databases, supporting analytics and reporting pipelines.