| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Business Analyst, IT Consultant, Data Entry Clerk, Analyst Elgin, IL Data analyst Chicago, IL Data Analyst Intern Chicago, IL Data Analyst Consultant Chicago, IL Machine Learning / Data Analyst / Software Engineer Chicago, IL Data Analyst Digital Marketing Aurora, IL Data Analyst Supply Chain Park Forest, IL |
|
Click here or scroll down to respond to this candidateChicago, IL PHONE NUMBER AVAILABLE EMAIL AVAILABLEPROFESSIONAL SUMMARY:Detail-oriented Data Analyst with over 3+ years of experience handling large datasets, both structured and unstructured.Developed and implemented automated reporting solutions using Microsoft Power BI, utilizing SQL and DAX for data modeling and advanced data transformation to drive insights for business decision-making.Integrated Azure Data Factory to schedule and automate ETL workflows that ingested data from various sources into Azure SQL Database, ensuring real-time data availability for Power BI dashboards.Created custom Power Apps to enable business users to interact with and update data directly, eliminating manual processes and enhancing data accuracy within Dynamics 365.Leveraged Power Automate to automate approval workflows and synchronize data between Dynamics 365 and Azure SQL Database, ensuring seamless data consistency across the organization.Optimized DAX calculations and data models within Power BI, reducing report load times and improving overall performance, allowing for more complex data analysis and visualizations.Collaborated with cross-functional teams to design a unified data model for different business units, ensuring consistency in reporting and analysis across various departments using Power BI and Dynamics 365.Developed Python scripts to automate data cleansing and transformation tasks, integrating them into Azure Data Factory pipelines for end-to-end data processing workflows.Provided ongoing support and performance monitoring of Power BI dashboards, ensuring data accuracy and troubleshooting issues related to data integration, refresh schedules, and visualizations.Leveraged Python extensively for importing metadata into Hive and migrating tables and applications to Azure cloud.Developed interactive dashboards and reports using Tableau, enhancing data visualization and user engagementLeveraged Informatica for advanced ETL processes, improving data integration and management capabilitiesUtilized Microsoft Power BI to create visually appealing and insightful business reports, driving better decision-makingCreated detailed and comprehensive reports using SSRS (SQL Server Reporting Services), ensuring accurate and timely data delivery to stakeholdersManaged structured and semi-structured datasets within PySpark using RDDs, ensuring efficient data handling and processing.Logged incoming data and public records requests from non-media parties, ensuring proper documentation and tracking for timely processing.Proficient in AGILE and SDLC methodologies, applying these frameworks to manage and execute projects effectively. This proficiency includes leading AGILE sprints, participating in daily stand-ups, and ensuring the delivery of high-quality software within established timelines.Skilled in designing and implementing SQL frameworks for complex data warehouses and marts. This includes defining data transformation rules, developing ETL/ELT processes, and ensuring data integrity and accuracy throughout the data lifecycle.Prepared responses to Microsoft 365 applications and public records requests within established timelines and legal requirements, drafting clear and complete correspondence and documentation.Communicated with requesters to clarify their requests, provide updates on processing status, and coordinate the delivery of requested information, maintaining records of all communications and actions related to each request.Served as the primary compliance contact for the implementation and oversight of the agencys Microsoft Purview application, a data governance tool for managing data across various sources, including Microsoft 365 applications (Outlook, SharePoint, OneDrive, Teams, Exchange) and other on-premises, multi-cloud, and SaaS data.Good knowledge of hosting Python applications using WSGI modules and Good knowledge of web services with protocols SOAP, REST.Designed and executed interactive dashboards in Tableau to visualize key performance indicators and business metrics. Utilized Hyperion and SQL for data extraction and transformation, creating a robust framework for business intelligence reporting. Provided training and support to team members on data visualization best practices, enhancing overall reporting capabilities and decision-making processes.Developed SQL triggers, procedures, and managed data manipulation within databases.Oversaw data deployment processes using WINSCP and PuTTY and coordinated data migration using SQL-Loader and Data Pump files.Educational Profile:Western Illinois University, M.S. in Computer Science May 2024GPA: 3.8Relevant Coursework: Data Structure and Algorithms, Artificial Intelligence, Database, Application Development, Software Design and Development, Operating Systems, Data ScienceCertifications:(1Z0-1085) Oracle Cloud Infrastructure Foundation Associate, (1Z0-1067-F) Oracle Cloud Infrastructure 2019 Cloud Operations Associate, (1Z0-931) Oracle Autonomous Database Specialist, (1Z0-1084-20-F) Oracle Cloud Infrastructure Developer 2020 Associate. (1Z0-144) Oracle Database 11g: Program with PL/SQL.Projects Involved (Roles and Responsibilities):Client 1: State Street (Data Analyst) May 2019 - Mar 2020Role: Project Engineer, Wipro, IndiaImplemented a robust enterprise data warehouse using Synapse Analytics, ensuring seamless integration with the Data Lake and enabling real-time, high-volume analytics and reporting.Designed and built Power BI dashboards connected to multiple data sources, leveraging SQL queries and DAX expressions to enable dynamic and real-time data visualizations for key performance indicators (KPIs).Implemented Azure Data Factory pipelines to automate the ingestion and transformation of data into Azure SQL Database, enabling continuous data updates for Power BI reports and reducing manual intervention.Developed Power Apps solutions to streamline business processes, integrating with Dynamics 365 for improved data entry and management, reducing data entry errors and increasing efficiency.Utilized Power Automate to trigger notifications and workflows based on changes in data from Dynamics 365, ensuring timely actions and follow-ups on business-critical tasks.Enhanced Power BI data models by optimizing relationships, hierarchies, and DAX formulas, improving both report performance and the ability to conduct more granular data analysis.Built Python scripts for data extraction, transformation, and loading (ETL) to preprocess complex datasets before feeding them into Azure SQL Database and Power BI for analysis.Partnered with stakeholders to define data requirements and ensure Power BI reports provided actionable insights, adjusting SQL queries and DAX as needed to meet evolving business needs.Monitored the performance of Azure Data Factory pipelines and Power BI data refreshes, troubleshooting failures and optimizing data flows to ensure timely updates for business users.Processed and presented data on the front-end by integrating Python with data visualization libraries (Matplotlib, Plotly) and rendering interactive charts in JavaScript (e.g., Chart.js, D3.js).Led troubleshooting and performance optimization efforts, addressing data ingestion bottlenecks, query performance issues, and ETL failures to ensure timely and accurate delivery of insights.Managed and curated metadata, ensuring data accessibility, understandability, and usability for analysis.Created data models in SQL, incorporating multiple data sources for comprehensive analytical solutions. Implemented custom visualizations and DAX measures to meet specific business requirements.Assisted in the SQL design and development of data products that provide actionable insights, supporting strategic decision-making across the business.Implemented SQL-based analytics solutions to enhance data-driven decision-making and reporting accuracy. Designed and executed data processing workflows to integrate SAS analytics outputs with existing business intelligence tools, including Hyperion and Tableau. Facilitated effective communication of analytical findings through detailed reports and presentations, ensuring alignment with strategic business goals.Created comprehensive documentation and guides for data sets and data products, making them accessible and understandable to a diverse range of users.Conducted training sessions and workshops to enhance data literacy and utilization across the organization.Proficient in data analysis tools such as SQL, Metadata Management, Python, R, and BI tools like Tableau or Power BI.Strong understanding of statistical analysis, predictive modeling, and data mining techniques.Environment: Tableau, SQL, R, Python, Google Cloud Platform (GCP), Azure Data Factory (ADF v2), Azure SQL Database, Scala, Microsoft 365 applications (Outlook, SharePoint, OneDrive, Teams, Exchange), SQL server, Windows remote desktop, UNIX Shell Scripting, Adobe, Azure PowerShell, Azure Synapse, Data bricks, Python, ADLS Gen 2, Azure Cosmos DB, Azure Event Hub, Apache Spark, MySQL, Azure Machine Learning.Project 2: Citi Bank (Data Analyst) Mar 2020 - Feb 2021Role: Project Engineer, Wipro, IndiaSkilled in connecting Tableau to various data sources, including data warehouses, databases, and flat files, to create unified and dynamic visualizations.Used Git for version control in Python and front-end projects, collaborating with designers and front-end developers for seamless code integration and release cycles.Implemented best practices for API security using Python, including rate-limiting, input validation, and data sanitization to ensure secure communication between front-end and back-end services.Created comprehensive Power BI reports utilizing advanced DAX measures and SQL queries, providing in-depth analysis and insights into operational data for executive leadership teams.Developed scalable ETL processes using Azure Data Factory to pull data from Dynamics 365 and other cloud sources into Azure SQL Database, ensuring reliable and up-to-date data feeds for Power BI dashboards.Designed and deployed Power Apps to automate manual workflows, enhancing data collection processes by allowing users to input data directly into Dynamics 365 and Azure SQL Database from any device.Integrated Power Automate workflows to automate the synchronization of records between Dynamics 365 and Azure SQL Database, improving data consistency and reducing processing times.Leveraged Python scripts for complex data transformations, preprocessing data before feeding it into Azure Data Factory for seamless integration into Power BI and Azure SQL Database environments.Conducted data modeling workshops with business analysts and stakeholders, ensuring that Power BI data models aligned with organizational goals and facilitated better decision-making through actionable insights.Led efforts to maintain and continuously improve data pipelines, monitoring data ingestion processes and ensuring that data processing remained aligned with business requirements and SLAs. Conducted user acceptance testing (UAT) for Power Apps and Power BI solutions.Created custom connectors and APIs for integrating external data sources with Power Apps. Developed reusable templates and components in Power BI and Power Apps to streamline development.Served as the primary compliance contact for the implementation and oversight of the agencys Microsoft Purview application, a data governance tool that helps organizations map, manage, and govern their data across various sources, including data/files within enterprise Microsoft 365 applications (Outlook, SharePoint, OneDrive, Teams, Exchange) and other on-premises, multi-cloud, and SaaS data.Adept at staying updated with the latest features and updates in Informatica PowerCenter and Tableau, ensuring the implementation of cutting-edge solutions and best practicesEnvironment: Tableau, SQL, R, Python, Google Cloud Platform (GCP), Azure Data Factory (ADF v2), Azure SQL Database, Scala, Microsoft 365 applications (Outlook, SharePoint, OneDrive, Teams, Exchange), SQL server, Windows remote desktop, UNIX Shell Scripting, Adobe, Azure PowerShell, Azure Synapse, Data bricks, Python, ADLS Gen 2, Azure Cosmos DB, Azure Event Hub, Apache Spark, MySQL, Azure Machine Learning.Project 3: EA (Electronic Arts) (Data Analyst) Feb 2021 - July 2022Role: Project Engineer, Wipro, IndiaDeveloped detailed SQL documentation covering the entire data architecture, including data flow diagrams, ETL processes, security frameworks, and integration with downstream systems for advanced analytics.Containerized Python applications using Docker for consistent environments across development, testing, and production, ensuring easy deployment and scaling.Implemented robust data pipelines using Azure Data Factory to automate the extraction, transformation, and loading of data into Azure SQL Database from various sources, including Dynamics 365, to support Power BI reporting.Developed customized Power Apps solutions that interfaced with Azure SQL Database and Dynamics 365, improving data entry processes and enabling users to update critical data on the go.Automated business processes through Power Automate, such as sending notifications, approvals, and task reminders based on predefined triggers in Dynamics 365 and Azure SQL Database, streamlining operations.Enhanced Power BI report performance through advanced DAX optimization techniques, improving calculation efficiency and reducing report load times, even for large datasets.Integrated Python scripts into Azure Data Factory pipelines to automate data transformations, making complex data more manageable and ensuring data was processed in a format ready for Power BI visualization.Conducted regular maintenance and troubleshooting of Azure Data Factory, Power BI, and Power Apps solutions, ensuring the reliability of data flows and addressing any performance or data consistency issues promptly.Built and maintained sophisticated Excel applications for business analytics using advanced functions like array formulas, complex nested formulas, and VBA scripting. Integrated these applications with Hyperion and other data sources to produce comprehensive reports and dashboards. Provided expert-level training and support on advanced Excel techniques to enhance the teams data analysis and reporting capabilities.Coordinated and expedited the entire process with Unix Shell Scripting, ensuring accuracy and efficiency in data transfer.Explored Kubernetes, containers, and microservices, contributing to the architecture and design of both new and existing systems.Part of the deployment for APAC/EMEA, involved SIT2/UAT2/PROD in SQL DB releases each quarter.Implemented custom logic and connectors in Power Apps to integrate with other Microsoft 365 services and third-party applications.Developed custom dashboards in Power BI tailored to specific business needs and KPIs. Participated in data governance initiatives to ensure compliance with data standards and policies.Involved in DWH handoff and tracking daily deployments in APAC/EMEA. Conducted thorough performance testing and optimization to ensure efficient database operations.Implemented automated scripts to monitor and log database performance metrics. Collaborated with cross-functional teams to address and resolve database-related issues promptly.Environment: Tableau, SQL, R, Python, Google Cloud Platform (GCP), Azure Data Factory (ADF v2), Azure SQL Database, Scala, Microsoft 365 applications (Outlook, SharePoint, OneDrive, Teams, Exchange), SQL server, Windows remote desktop, UNIX Shell Scripting, Adobe, Azure PowerShell, Azure Synapse, Data bricks, Python, ADLS Gen 2, Azure Cosmos DB, Azure Event Hub, Apache Spark, MySQL, Azure Machine Learning, Terraform, Cassandra, Shell Scripting, Power BI, Mongo DB, Jenkins, JIRA, Apache Spark, Git.Devarasetty Apparao |
