Sravya Singam Email & Phone Number

Dallas, Tx, Us

San Antonio, Texas, Us

Dallas, Tx, Us

•Designed and managed data models using Microsoft Visio, employing best practices in SQL to maintain data integrity and optimize storage efficiency.•Led cross-functional teams in mapping out migration strategies and identifying key data migration requirements, collaborating closely with stakeholders to ensure successful transitions within projected timelines.•Spearheaded the implementation of Master Data Management (MDM) solutions, utilizing SQL methodologies to standardize data across diverse datasets and enhance overall data quality and consistency. •Automated table structure and data comparisons utilizing Pentaho Kettle (ETL), resulting in a 100% reduction in manual efforts.•Orchestrated seamless migration of data from MariaDB, and Mem SQL to Big Query for robust data warehousing using airflow thus reducing the data storage and processing costs.•Managed ETL workflows and monitored data loads for batch processing, ensuring data integrity and timely execution of data workflows, with a focus on optimizing SQL queries and ETL processes for performance and efficiency.•Proficiently established data connections and loaded data from various sources, including SQL Server, Oracle, Excel, and SharePoint, leveraging ETL processes and SQL expertise to ensure seamless data integration and accuracy.•Demonstrated skill in database tuning, application tuning, SQL tuning, and PL/SQL tuning, optimizing performance and efficiency in data processing and analysis across multiple platforms and databases, including SAS and SQL Server.•Implemented strategic optimizations and fine-tuned SQL queries to enhance performance and efficiency, reducing overall query runtime and improving data processing capabilities across SQL and Big Data platforms.

Paris, France, Fr

•Spearheaded the analysis of SAS and Teradata scripts, devising migration strategies to transition them to the in-house platform SparkOLA, leveraging SQL expertise for seamless data transformation to process customer information from 20+ source systems, increasing productivity by 40%.•Utilized SQL and Scala to design and implement Spark SQL pipelines, facilitating smooth data transformation and migration processes across multiple systems and platforms.• Conducted extensive analysis of different time frames to pinpoint potential customer segment opportunities worth $50M, utilizing SAS, SQL, and Teradata expertise for insightful business recommendations.•Analyzed results from over 5TB of data housed in Hive tables, utilizing Presto views to compare output and measure customer behavior over various time intervals, enhancing data analysis efficiency.•Reduced job time by 2 hours per day through SQL optimization, contributing to a reduction in database load during runtime, improving overall system performance and efficiency.•Designed interactive data visualization dashboards using QlikView, providing actionable insights to stakeholders, enhancing decision-making processes.•Leveraged Presto views to query and analyze data stored in Hive tables, ensuring efficient data exploration and analysis using SQL and HiveQL.•Automated data processing workflows utilizing SQL queries, Jenkins, and Apache Collibra, achieving a 90% reduction in manual effort, optimizing data processing efficiency and accuracy.•Developed and executed custom PySpark scripts to optimize job execution on the Hadoop cluster, achieving enhanced performance and resource utilization, improving overall job execution efficiency.

Paris, France, Fr

•Deployed and monitored Airflow jobs and Unix scripts through CI/CD deployment process, ensuring smooth execution and management of data processing workflows.•Conducted deep dive analyses of different time frames to identify prospective customer segment opportunities of $50M, utilizing SAS, SQL, and Teradata expertise for strategic business insights.•Validated quality assurance and accuracy of data output through deploying jobs across UAT, QA, and Production environments, leading to a 95% successful job loading rate, ensuring data integrity and reliability.•Executed custom shell scripts to automate data extraction from servers and migrate it onto S3 repository, reducing manual data movement by 90%, optimizing data processing workflows.•Built automated reports utilizing BI tools to forecast customer purchase patterns across the lifetime value cycle, enabling 10% improved accuracy in finding high-potential customers, leveraging SQL and BI expertise for data-driven insights.•Analyzed and validated results from over 5TB of data housed in Hive tables, creating Presto views to compare output and measure customer behavior over varied time intervals, enhancing data analysis efficiency.

Paris, France, Fr

•Led a migration project from AbInitio to Talend, demonstrating strong ETL expertise and analytical skills.•Prepared comprehensive mapping documentation outlining components required for migrating from AbInitio to Talend, ensuring clarity and accuracy throughout the migration process.•Analyzed source-target mappings, meticulously mapping all columns and back tracing the logic involved in each column to the source for both Traded and Non-Traded flows.•Documented detailed mapping documentation, providing critical insights that facilitated the development of ETL jobs in Talend, ensuring seamless data migration and transformation.•Utilized analytical skills to identify dependencies, potential challenges, and opportunities for optimization during the migration process, contributing to the successful execution of the project.•Collaborated closely with cross-functional teams to gather requirements, address concerns, and ensure alignment throughout the migration project, fostering effective communication and teamwork.•Played a key role in the development and implementation of ETL solutions in Talend, leveraging deep understanding of data structures, transformations, and integration processes.•Demonstrated proficiency in ETL tooling and methodologies, ensuring efficient data extraction, transformation, and loading processes.•Contributed to the continuous improvement of data migration strategies and processes, implementing best practices and innovative solutions to enhance overall efficiency and effectiveness.

Master'S Degree, Business Analytics

Bachelor Of Technology - Btech, Civil Engineering

Education record