•Redesigned comprehensive Tableau visualizations by ingesting data from Redshift and SQL Server improving 70% report quality•Utilized Python for statistical analysis of large datasets, identifying trends and patterns to improve operational efficiency by 15%•Optimized ETL pipelines with PySpark, resulting in a 30% reduction in processing time, improving data accessibility for reporting•Worked in an Agile environment by implementing Scrum practices using Jira that enhanced the final product delivered•Created client-facing presentations, increasing engagement by 20% through clear visual storytelling of complex data•Analyzed multiple performance data sources, delivering insights that identified cost-saving opportunities, reducing costs by 12%•Collaborated with cross-functional teams to gather, document, and analyze data boosting business decision-making accuracy by 18%

• Transformed supply chain data models through Erwin reverse engineering, accelerated data processing speed by 40%, accuracy, and inventory management, resulting in a 20% increase in order fulfillment using AWS Redshift and Postgres• Attained 15% faster data retrieval for ticket sales and traveler’s data through strategic indexing and optimizing data models• Extracted data dictionary from Erwin Report Designer, providing a centralized repository of data definitions and relationships• Formulated more than 10 advanced SQL views to extract vital revenue and journey-related information for statistical analysis

•Pioneered data extraction, and cleansing to migrate data 25% faster from Oracle to Teradata using SQL queries, stored procedures, data mover, and TPT scripts•Designed, constructed, tested, and maintained data architectures for data platforms, databases, analytical, reporting•Demonstrated proficiency in new and emerging technologies, such as AWS SDK, and applied knowledge of IT architectures, technical standards, design and development tools, layered systems architecture•Conducted query tuning to improve the performance of the DataMart and Data Warehouse, and recommended long-term processes and solutions to ease support issues and stabilize applications•Designed, developed, and supported a comprehensive data mart architecture to facilitate the flow and synchronization•Implemented data transformation and migration across different platforms, and collaborated with data scientists to analyzeperformance, troubleshoot issues and implement data requirements•Performed multivalued compression on production objects for space management saving 1 TB of system space weekly•Accelerated data migration from Oracle to Teradata by 25% using TPT scripts, SQL queries, Data Mover and stored procedures• Maintained SQL Server, Oracle, Postgres, and MySQL databases, achieving 99.99% uptime and high data integrity•Monitored and resolved performance issues, reducing database bottlenecks by 25% and improving system response time by 30%

• Created interactive dashboards and reports in PowerBI, Looker, and Tableau, enhancing data visualization and enabling clients to understand and interpret key performance metrics• Generated reports for clients by conducting quality assurance checks and recorded a 65% increase in customer satisfaction• Conducted a comprehensive review of the existing ETL processes and reporting dashboard queries used for supply chain data, and optimized them to reduce CPU/IO usage by 30%• Maximized efficiency by implementing scheduling, monitoring, and reporting process for healthcare project using MicroStrategy, SQL Server and AutoSys, resulted a daily time savings of 2 hours for stakeholders

Worked as a technical support associate on SAP Business One, Crystal reports, C#.