srujana sarella
Irving,Texas
Summary
Self-motivated Data analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with several years of vast experience collecting, cleaning and interpreting data sets. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Data Analyst
Significant Tek Inc.
Austin, TX
05.2023 - 06.2024
- Created infographics through Tableau and slide decks by transforming data and insights into stories; helped create pivot table-based reports and dashboards.
- Crafted complex SQL statements for comprehensive reporting, systematically uncovering and correcting data anomalies; improved data integrity by 30% and streamlined report accuracy by 20%.
- Constructed an engagement measure and used research techniques and data analytics (including correlation matrix and linear regression analysis) to assess validity and reliability
- Led the optimization of internal processes, resulting in a 20% increase in operational efficiency.
- Executed the program using Python API, written in Python, to support Apache Spark or PySpark.
- Leveraged Google Campaign Manager to analyze media campaign performance, integrating findings into Tableau dashboards to visualize key metrics and ROI.
- Developed compelling PowerPoint presentations to communicate findings and recommendations to stakeholders.
- Included charts, graphs, and visualizations from Excel to present data insights and support decision-making effectively.
- Participated in the full Software Development Life Cycle, contributing to requirements gathering, system design, development, testing, and deployment phases.
- Identified and validated data sources, assessed the feasibility of data joins, and ensured data reasonableness based on business context.
- Employed Pandas for feature extraction and transformation, resulting in a 15% improvement in model accuracy by enhancing data quality and relevance.
- Developed ETL processes using Informatica PowerCenter for data integration.
- Managed data quality and governance with Informatica Data Management Cloud, ensuring seamless data flow and accuracy.
- Generated comprehensive reports using Matplotlib and Seaborn to present findings to stakeholders, supporting strategic planning and business development.
- Demonstrated understanding of data management systems and database structures, facilitating effective data analysis and reporting.
- Developed and deployed machine learning models using TensorFlow and Keras, leading to a 20% increase in predictive accuracy for customer churn analysis.
- Designed and implemented complex data models and DAX formulas to analyze sales performance and forecast trends.
- Developed wireframes and mockups for data visualization solutions, effectively addressing business questions and KPIs.
- Created and customized Pivot Tables to summarize and analyze large datasets, focusing on key metrics such as sales performance.
- Championed key business ventures, driving strategic efforts that resulted in a 30% revenue growth.
- Leveraged Snowflake for data warehousing and cloud-based analytics, optimizing data storage, retrieval, and performance.
- Utilized VLOOKUP functions to merge data from multiple sources and automated data retrieval processes to ensure accurate and up-to-date information for analysis, reducing manual data entry time by 40%.
- Competent with pivot tables, functions, formulas, data validation, and sophisticated data analysis tools, like Power Query and Power Pivot.
- Utilized PyTorch to design and train deep learning models for natural language processing tasks, enhancing the company's sentiment analysis capabilities.
- Managed project tasks and tracked progress using JIRA, ensuring timely completion of analytical projects and efficient workflow.
- Designed and implemented ETL processes using Fivetran and Snowflake to consolidate data from multiple sources, improving data accessibility and reliability.
- Conducted in-depth statistical analysis and built predictive models to enhance marketing strategies, using packages in R, such as ggplot2 and caret.
- Directed development and implementation of new software applications, improving workflow and reducing processing time by 25%.
- Monitored sales metrics and tracked performance indicators through Salesforce dashboards and reports.
- Generated customized reports to assess sales trends, pipeline performance, and customer engagement levels.
- Designed complex flowcharts using Microsoft Word, PowerPoint, Excel, and Visio, and maintained and managed Azure storage using Microsoft Azure Storage Explorer.
- Environment: Big Data, Azure Data Factory, Azure Databricks (PySpark, Spark SQL), Azure Data Lake, Azure SQL, JSON, GitHub, Python, AWS, Agile
Graduate Engineer Trainee
Ramky Infra Ltd.
Hyderabad, India
08.2018 - 11.2021
- Constructed interactive dashboards to show key performance indicators (KPIs), identified patterns and trends in construction data, and communicated findings to project participants
- Managed and optimized distributed infrastructure, ensuring high availability and scalability of services
- Developed and deployed comprehensive hardware solutions that enhanced system reliability and user experience
- Facilitated knowledge transfer sessions to promote information exchange and foster a collaborative work environment
- Analyzed data and its trends from SAP and built reports based on the data
- Proficient in several SAP Modules (Project Systems, Core HR, Production Planning, and CRM) for transactions such as sub-contractor billing, compensation, payroll, material procurement, and quantity reconciliation
- Implemented strategic process improvements that streamlined workflow and increased productivity by 30%
- Ensured milestones were met and delivering within budget constraints
- Led service improvement initiatives that resulted in a 40% increase in client satisfaction and service quality
- Developed and enforced change management processes to streamline operations and improve organizational agility and provided exemplary customer care, achieving a client satisfaction rate of 98% and enhancing customer loyalty
- Used Python for use cases in predictive analytics
- Monitored and optimized systems performance, leading to a 50% increase in overall system efficiency
- Developed compelling proposals that secured funding and new business opportunities and crafted comprehensive white papers that provided in-depth analysis and guided strategic decision-making
- Performed regression analysis, forecasted project outcomes, analyzed risk factors, and conducted hypothesis testing using R and Python with pandas, NumPy, and SciPy
Education
Master of Information Technology -
University of Cumberlands
05.2024
Skills
- Programming Languages: Python, R, Scala, SQL, C, Java
- Data Analysis & Visualization: Tableau, Power BI, Excel
- Databases: Oracle, MySQL, Snowflake, HBase, Cassandra, NoSQL Databases
- Big Data Technologies: HDFS, Hue, MapReduce, Hive, HCatalog, Sqoop, Impala, Spark, PySpark, Spark Streaming, Zookeeper, Flume, Kafka, Yarn
- Cloud Platforms: AWS, Azure
- Data Engineering Tools: Airflow, DataBricks
- Infrastructure & Deployment: Docker, Kubernetes, Jenkins, Bamboo
- Version Control: GitLab
- Configuration Management & Infrastructure as Code: Terraform
- Cluster Management: Cloudera Manager
- Security: Kerberos
Certification
- Trained in implementing Oracle Recruiting Cloud (ORC), Core HR (Global Human Resources), Oracle Compensation (Base pay, Individual compensation, Workforce Compensation), Absence, Benefits, Payroll, and Security modules.
- AI for Everyone, https://coursera.org/share/c7c552a388fdcc76191e9f60b053a00f
- Intensive Cloud Computing Hands-on Training, https://app.thecloudbootcamp.com/certificates/8rofctmzaj
- AWS Certified Cloud Practitioner, https://www.credly.com/badges/5ea9abb9-d124-4f40-adee-2b6447f1784e/linked_in_profile
- Getting Started with Cloud for the Enterprise – IBM, https://www.credly.com/badges/ca5807a0-5837-491a-8a83-9dae0a4a3168/linked_in_profile
- Create a Website Using WordPress: Free Hosting & Sub-domain, https://www.coursera.org/account/accomplishments/certificate/63526EJTRVTY
Timeline
Data Analyst
Significant Tek Inc.
05.2023 - 06.2024
Graduate Engineer Trainee
Ramky Infra Ltd.
08.2018 - 11.2021
Master of Information Technology -
University of Cumberlands