Home

Fariha - Senior Data Analyst

[email protected]

Location: Dallas, Texas, USA

Relocation: Teaxas

Visa: Green Card

FARIHA PROFESSIONAL SUMMARY: Results-driven professional with over 10 years of experience in data analytics, software development, and business intelligence. Proven track record of successfully gathering and translating business requirements into actionable insights, driving strategic initiatives, and optimizing performance. Expertise in utilizing SQL and Python to extract, clean, and analyze data from various sources, including AWS Redshift, MongoDB, MySQL, and more. Skilled in leveraging advanced analytics tools and machine learning algorithms for classification, regression, clustering, and predictive modeling, enhancing decision-making processes. Proficient in developing and managing ETL pipelines, CRM systems, and data lake solutions to streamline data processing and storage for enhanced analytics capabilities. Experienced in architecting scalable and resilient data infrastructure, optimizing performance, and resource utilization to enhance overall data management efficiency. Strong proficiency in data visualization tools like Tableau, Power BI, Google Analytics, and Data Studio to transform complex data into clear visualizations for data-driven discussions and strategic planning. Demonstrated ability to mentor and lead comprehensive data analytics programs, fostering a culture of innovation and continuous improvement within teams. Effective communicator and collaborator, adept at building and maintaining strong client relationships, contributing to increased customer retention and satisfaction. In-depth knowledge of spatial analysis techniques, predictive modeling, and risk assessment processes, with a keen eye for identifying and leveraging business opportunities for revenue growth. Skilled in automation and troubleshooting, enhancing operational processes and optimizing data analysis and reporting efficiency. Committed to staying abreast of emerging technologies and best practices in the field, ensuring efficient data infrastructure and predictive modeling capabilities to meet evolving business needs. TECHNICAL SKILLS: Programming Languages: Python, Java, R, SQL, JavaScript Data Analysis & Visualization: NumPy, Pandas, Seaborn, ggplot2, Tableau, Power BI, QlikView, MATLAB, Excel/Numbers/Sheets, GIS Big Data Technologies: Apache Hive, Snowflake, Hadoop, Apache Spark, AWS, Redshift, Microsoft Azure, Azure Synapse Analytics, HDFS Database Management: MySQL, Oracle, NoSQL, MongoDB, Snowflake, Teradata, SQL Server Version Control: Git, SVN, GitHub Web Technologies: HTML/CSS, Netlify, SEO, GIS Applicant Tracking Software (ATS): Agile, Scrum, JIRA, Zendesk Mergers & Acquisitions (M&A): Business Analytics, Operations Research Office Suite: MS Office, Word, Excel, PowerPoint/Keynote/Slides Other Tools: Talend, Netlify, NumPy, Pandas, Scikit-learn, Reshape2, ArcGIS, QGIS Operating Systems: Linux/Unix, Windows IDE: Eclipse, IntelliJ, NetBeans, Visual Code Studio PROFESSIONAL EXPERIENCE: AT&T, Bothell, WA Oct 2022 Till Now Data Analyst Responsibilities: Employed various approaches to gather business requirements and collaborated with stakeholders to fulfill analytics needs. Utilized SQL and Python to extract data from AWS Redshift, ensuring accurate and efficient data retrieval. Proactively explored innovative solutions, adapting to dynamic market conditions for optimized performance. Leveraged SQL queries and Python libraries for data cleaning, manipulation, and modeling, aligning with business objectives. Transformed complex data into clear visualizations using tools like Google Analytics and Data Studio, facilitating data-driven discussions and strategic initiatives. Applied machine learning algorithms for classification, regression, and clustering, enhancing analytical capabilities and decision-making processes. Conducted data profiling and implemented data processing techniques for improved data quality using NumPy, Pandas, and Scikit-learn. Defined and tracked key performance indicators, optimizing processes to streamline development lifecycle and improve efficiency. Generated reports and dashboards using SQL Server, Tableau, and Power BI, enabling stakeholders to gain actionable insights. Collaborated across departments to identify KPIs aligned with business objectives, fostering communication and strategic alignment. Demonstrated proficiency in utilizing advanced analytics tools and technologies, ensuring efficient data infrastructure and predictive modeling capabilities. Built and maintained strong client relationships, contributing to increased customer retention and satisfaction. Enhanced operational processes through automation and troubleshooting, optimizing data analysis and reporting efficiency. Trinity Industries, Dallas, TX Feb 2020 Sep 2022 Data Analyst Responsibilities: Engaged in full Software Development Life Cycle (SDLC) by analyzing business requirements and orchestrating the flow of information across systems, ensuring optimal functionality. Demonstrated entrepreneurial acumen by identifying and leveraging business opportunities for revenue growth. Contributed to the development of ETL pipelines, facilitating seamless data extraction and storage in Amazon Redshift for enhanced analytics capabilities. Mentored a comprehensive Data Analytics program encompassing data fetching, preparation, machine learning modeling, and visualization using SQL and Python. Proficient in implementing and managing CRM systems to elevate customer interactions and satisfaction levels. Collaborated with stakeholders to glean insights into supply chain operations, fostering informed decision-making. Leveraged Python and R to develop and refine machine learning algorithms, driving efficiency and accuracy in data forecasting. Spearheaded sales strategies leading to increased revenue and market share. Expertise in architecting and implementing robust data lake solutions, ensuring centralized data repository for diverse data types. Skilled in designing visually compelling charts and graphs using Plotly, enhancing data storytelling and stakeholder comprehension. Presented actionable insights to senior management through Power BI and Tableau dashboards, facilitating informed decision-making and strategic planning. Wells Fargo, San Francisco, CA Nov 2018 Dec 2019 Data Analyst Responsibilities: Proficiently managed end-to-end research phases, from data collection and cleaning to modeling and visualization, fostering a deep understanding of customer behavior patterns. Collaborated seamlessly with data engineers and operational teams to source and integrate internal system data into Snowflake data warehouse, ensuring analytical requirements were met efficiently. Demonstrated expertise in architecting scalable and resilient data infrastructure, optimizing performance, and resource utilization to enhance overall data management efficiency. Leveraged ETL tools like Talend, Informatica, and MuleSoft for seamless data mapping and integration, streamlining the data processing pipeline. Utilized ggplot2 library in R for insightful data visualizations, enriching the comprehension of customer behaviors and trends. Applied advanced spatial analysis techniques for accurate interpretation of geographic data, employing geocoding, buffering, overlay analysis, and spatial interpolation methods. Proficiently refined data attributes and relationships and performed data cleansing using SQL queries across diverse database systems including MongoDB and SQL for RDBMS. Employed SAS to effectively extract customer information from large and complex datasets, contributing to informed decision-making processes. Developed data models utilizing Cassandra Query Language (CQL) for comprehensive customer data management, ensuring robust and efficient data handling. Innovatively designed and implemented predictive algorithms, notably a Random Forest model, to forecast credit card user default rates, enhancing risk assessment processes. Spearheaded the automation of reconciliation processes for fraud audit reports using visualization tools like QlikView, Tableau, or Power BI, streamlining operations and improving accuracy. Additionally, employed JavaScript to automate repetitive data tasks, boosting efficiency and precision in data analysis workflows. AJR Info System Private Limited, Hyderabad Aug 2015 Sep 2017 Data Analyst Responsibilities: Developed computational and automation objects, generating daily aggregated reports for client investment decisions and risk analysis, leveraging Python/SQL to fetch and process data from diverse sources like MySQL, SQL Server, Oracle, and cloud platforms (e.g., Snowflake, Teradata, DB2). Employed Python libraries (NumPy, Pandas, Matplotlib) for data manipulation and cleaning, implementing techniques such as backward-forward filling to handle missing values effectively. Utilized Spark SQL and PySpark within the Apache Spark Framework for extracting, transforming, and loading third-party spending data, ensuring compliance with specific formatting requirements. Automated recurring reports using SQL or Python, visualizing insights on BI platforms (Tableau, Power BI) for comparison of enterprise data metrics on weekly and monthly intervals, with the ability to present findings effectively through PowerPoint presentations. Conducted data collection and merging from market providers on a daily basis, applying various cleaning techniques to meet business objectives effectively. Leveraged MongoDB for large-scale data mapping tasks, contributing to streamlined processes and enhanced data management capabilities. Implemented simulation models to predict system behavior over time, conduct hypothesis testing, and proactively identify potential issues within systems. Applied extensive expertise in mortgage data analysis, including risk assessment, market trend analysis, and forecasting, contributing to strategic initiatives aimed at optimizing mortgage portfolios. Played a pivotal role in the networking team, providing data-driven insights and analysis to support infrastructure optimization and network performance enhancement efforts. Conducted comprehensive data quality checks for Mainframe data migration, ensuring adherence to legal compliance requirements by designing validation test cases and executing them rigorously. BrighTech, Hyderabad Jun 2013 Jul 2015 Data Analyst Responsibilities: Collaborated with management to prioritize business needs, analyzing and designing documents accordingly. Proficiently utilized SQL queries for data manipulation across diverse database formats (Relational-SQL, JSON, CSV, Excel), executing complex queries and subqueries. Excelled in data preparation and analysis, employing Advanced Excel features such as VLOOKUP, XLOOKUP, Macros, Formulas, Functions, and Pivot tables for comprehensive insights. Conducted data analysis and maintenance on various databases including MySQL, MS SQL Server, and MongoDB. Leveraged QlikView for designing and developing reports, facilitating data visualization for informed decision-making. Expertly managed multiple datasets, documenting mapping and transformation processes using Excel or Talend. Implemented ETL processes (Informatica, Talend) for efficient data integration and management. Developed strategies to optimize data acquisition and quality from primary and secondary sources, ensuring accuracy during collection and extraction. Established AWS-based data pipelines using services like S3 and Redshift, enabling seamless integration between disparate sources and real-time access for stakeholders. Produced ad-hoc reports and dashboards for key stakeholders, delivering standardized weekly and monthly reports, and exporting them in various formats including MS Word, Excel, CSV, and PDF. Keywords: business intelligence sthree active directory rlang microsoft California Texas Washington