Gowthami Mallaram
Finance Expert
AR, United States
Skills
Data Analysis
About
GOWTHAMI MALLARAM's skills align with System Developers and Analysts (Information and Communication Technology). GOWTHAMI also has skills associated with Database Specialists (Information and Communication Technology). GOWTHAMI MALLARAM appears to be a low-to-mid level candidate, with 4 years of experience.
View more
Work Experience
Data Analyst
Adani
February 2020 - December 2021
- * Employed advanced features of Pandas and NumPy to execute intricate data manipulation tasks, encompassing hierarchical indexing, merging datasets and handling missing data. Achieved a 20% enhancement in data processing efficiency. * Utilized advanced SQL analytical functions for trend analysis, ranking and window calculations. Implemented these functions to extract actionable insights from large datasets, thereby contributing to informed decision-making. * Crafted customized and publication-quality visualizations using Matplotlib and Seaborn. Implemented advanced charting techniques, including subplots, heatmaps, and violin plots, elevating data representation and interpretability. * Developed visually impactful and user-friendly dashboards in Tableau, resulting in a 30% improvement in data accessibility and comprehension among stakeholders. Applied advanced design principles to optimize dashboard performance for an enhanced user experience. * Ensured data consistency across diverse sources by seamlessly integrating data from multiple databases in Oracle, resulting in a 20% reduction in data integration time and contributing to more accurate and unified analysis. * Executed automated data quality checks and validation processes in Oracle Data Integrator, leading to a 30% reduction in data errors. Established proactive measures to ensure data accuracy and consistency throughout the ETL pipeline. * Applied advanced data mining algorithms to unveil hidden patterns and trends, contributing to a 30% improvement in actionable insights. Utilized machine learning algorithms for predictive modeling, enhancing decision-making processes.
ETL Developer
Trigent
October 2018 - January 2020
- * Employed best practices to design and implement complete schemas, including tables, relationships, stored procedures, views, clustered, and non-clustered indexes for the Logility Metrics project, ensuring a robust foundation for data storage and retrieval. * Developed impactful T-SQL stored procedures, triggers, cursors, and tables, significantly enhancing data processing and manipulation in both projects, thereby optimizing database functionality and efficiency. * Identified and addressed field and column-level data quality issues in source systems for both Logility Metrics and CISCMMetrics projects, driving data quality improvements, cleansing, and error checking in ETL packages. * Established and meticulously documented effective error-handling strategies within the ETL packages, resulting in a 20% reduction in data processing errors and ensuring robust error detection, logging, and resolution mechanisms. * Utilized SQL Server Reporting Services (SSRS) to generate reports and charts based on customer data loaded into SQL Server, enhancing data visualization and reporting functionality for Logility Metrics. * Proactively collaborated with data architects to align DataStage development with overarching data architecture and modeling standards, ensuring a 15% improvement in consistency and adherence to best practices. * Innovated ETL workflows on AWS Glue, employing dynamic frame transformations, custom Python transformations, and leveraging machine learning for automated schema evolution. Achieved a 30% reduction in data processing time, enhancing system performance. * Designed and developed ETL packages using SQL Server Integration Services (SSIS) for loading data from diverse source systems, including SQL Server, Oracle, flat files, and CSV files, ensuring efficient and accurate data transfer.
Data Analyst
BCBS
March 2023 - Present
- * Developed interactive and dynamic visualizations using Plotly to provide stakeholders with a more engaging and exploratory data analysis experience. Integrated Plotly visualizations into presentations and dashboards for enhanced storytelling. * Executed sturdy SQL scripts for data validation and integrity checks, resulting in a 30% reduction in data discrepancies. Instituted automated checks to guarantee the accuracy and consistency of critical datasets. * Implemented advanced data wrangling techniques, reducing data preparation time by 30%. Utilized tools like Pandas and DataStage for effective data transformation, cleaning, and structuring. * Crafted compelling data narratives in Power BI, leading to a 25% increase in stakeholder engagement and comprehension. Utilized advanced storytelling features to convey complex insights in a clear and concise manner. * Spearheaded complex SQL query optimization initiatives in DB2 databases, resulting in a 30% reduction in query execution time. Applied indexing strategies and query plan analysis to enhance overall database performance.
Education
Pittsburg State University
Masters in Information Technology
January 2022 - May 2023
