Support Analyst

Devi Jayamangala

+1-203-***-**** ***************@*****.***

PROFILE:

Results-oriented and Dynamic Data engineer with a Master’s in Computer Science from the University of Bridgeport.

Technical Skills: SQL(Data Merging, Data Validation, Power Query), Python, HiveQL, R, Cloud Services (AWS, Azure), Web Technologies (SOAP, HTML, XML), Linux/UNIX, Git/GitHub, Splunk, AppDynamics, Ant, Maven

Software Skills: PowerBI(Dashboard Design, DAX), Tableau, MS Excel, MS Access, Snowflake, MS SQL Server, PostgreSQL, Cosmos DB, MongoDB, Eclipse, Visual Studio, Azure Synapse Analytics

Project Management Skills: Project Planning and Milestone Tracking, Stakeholder Communication and Alignment, Risk Identification and Mitigation, Cross-Functional Team Coordination, Status Reporting and Progress Updates.Excellent verbal and written communication skills,avid runner, problem solver with persistence and determination to troubleshoot complex issues and propose innovative solutions.

EDUCATION:

University of Bridgeport Bridgeport, CT

Master of Science in Computer Science

Jawaharlal Nehru Technological University Kakinada, INDIA

Bachelor of Science in Information Technology

WORK EXPERIENCE:

Bank of America North Carolina, USA Apr 2023– Present

Data Analyst

Collaborated with cross-functional teams and Director-level stakeholders to gather business requirements and translate them into actionable, data-driven insights.

Synthesized and normalized large, disparate datasets using SAP, Excel (PowerQuery), and SQL, enhancing data accuracy and business reporting efficiency.

Built and maintained executive-facing PowerBI dashboards that supported strategic capital improvement initiatives and accelerated decision-making.

Designed cloud-based data pipeline and ETL work-flows using AWS Glue, Azure Data Factory, and Python to streamline large-scale data transformations.

Utilized Azure Databricks for developing and orchestrating end-to-end data pipelines with Python/Scala, reducing batch processing times by 30%

Integrated data from SAP, SQL, and Excel to create a Power BI dashboard for tracking project progress, budgets, and KPIs.

Collaborated with cross-functional stakeholders to assess CapEx and OpEx project requirements, aligning them with strategic investment priorities.

Created and maintained dashboards in Power BI to monitor portfolio spending trends, budget adherence, and benefit realization metrics.

Partnered with Portfolio Managers to track project lifecycle stages—from initiation to closeout, ensuring alignment with enterprise goals and success metrics.

Supported resource allocation decisions by analyzing pipeline bottlenecks and proposing schedule shifts to maintain critical path integrity.

Provided support for Power BI issues including user access problems, dashboard refresh failures, and data connectivity errors.

Participated in break/fix support for user-side Excel Power Query and dashboard configuration issues.

Documented issue resolution steps in project logs to support internal audits and continuity.

Designed scalable ETL/ELT workflows using AWS Glue and Azure Data Factory, integrating structured and unstructured financial datasets into a centralized data lake architecture supporting downstream AI/ML analytics.

Integrated Azure services, AWS Redshift, and RESTful APIs for exposing curated datasets to lightweight microservices supporting real-time reporting and ML feature access.Developed end-to-end data pipelines in Azure Databricks using Python/Scala and Apache Spark, optimizing batch and near real-time workloads and collaborating with ML engineers to productionize datasets.

Collaborated with stakeholders to design executive-facing dashboards and communication materials, supporting internal marketing of strategic initiatives and data-driven campaigns.

Implemented Snowflake-based cloud data warehouse solutions, optimizing partitioning, indexing, and data governance practices to ensure high performance and data integrity.

Bajaj Finance Ltd May 2021 – Aug 2022, India

Data Analyst

Generated reports from SAP, Netezza, Oracle, and SQL Server, connecting and synthesizing large, disparate datasets using Excel, Power Query, and SQL.

Developed and trained predictive models in Python/R for asset failure forecasting, collaborating with ML engineers to deploy and monitor pipelines via Databricks and Airflow, enabling scalable model retraining.

Deployed models into production using Databricks, Airflow, and AWS CloudWatch, and explored API-based access to model outputs for integration into decision-support systems.

Built and published Power BI dashboards for Director-level decision-making, incorporating advanced DAX calculations, row-level security, and real-time KPI monitoring.

Standardized and integrated data-sets for seamless visualization across Power BI, QlikView, and Tableau platforms, enhancing project tracking and forecasting accuracy.

Built distributed data pipelines using PySpark/Scala on Azure Databricks, enabling scalable processing of multi-terabyte datasets.

Developed forecasting models and financial impact analysis for capital-intensive initiatives, enhancing benefit realization tracking.

Used documentation systems to track and update anomaly rule changes and investigation notes.

Developed predictive models using Python/R to forecast maintenance needs and equipment failure, while embedding anomaly detection capabilities to flag irregular patterns that may indicate operational risks or financial discrepancies aligned with AML controls

Developed business rules to identify anomalies and ensure data integrity, leading to a 30% reduction in reporting errors and improved data quality standards.

Conducted market trend and competitor data analysis to support business positioning and promotional strategy in retail finance segments.

Developed visual reports and presentations that acted as internal marketing tools for showcasing operational performance and strategic direction.

Broke down projects into measurable milestones, maintained a living data dictionary, and effectively communicated progress through project status reports and stakeholder meetings.

Designed and deployed an anomaly detection system using Python/R to flag outliers and suspicious patterns in large-scale utility data.

Developed Collaborated closely with internal and external teams to translate business requirements into actionable, data-driven insights supporting construction and operations projects

business logic to support fraud detection and financial crime risk identification.

Supported internal quality assurance frameworks and audit compliance by generating rule-based alerts and documentation.

Automated data extraction and reporting workflows, accelerating dashboard refresh cycles and improving decision-making speed for sales and operational leadership.

·

INTERNSHIP:

HNM Solutions Group April 2020 – September 2020, India

Data Analyst

Worked closely with senior analysts to synthesize and normalize large datasets from various platforms, including SAP, SQL, and Excel, to support project tracking and forecasting.

Built and maintained interactive PowerBI dashboards for project monitoring and decision-making, delivering clear visualizations of key performance indicators (KPIs).

Supported the migration of data from legacy systems to cloud-based platforms, ensuring seamless integration with PowerBI and other reporting tools.

Supported data migration from legacy systems to cloud-based data lakes, ensuring compatibility with Power BI and future ML analytics use cases.

Created and formatted marketing support visuals (dashboards and presentations) for leadership, aiding stakeholder engagement and adoption of new analytics tools.

Developed and implemented data quality checks and business rules to identify anomalies and ensure the data aligned with business needs and objectives.

Assisted in project management tasks, breaking down projects into milestones, providing regular progress updates, and facilitating communication between stakeholders.

Participated in cross-functional team meetings to ensure the successful execution of data-related projects and to foster alignment on deliverables.

Contributed to maintaining a data dictionary and documentation, improving data accessibility and ensuring consistency across the data infrastructure.

RELEVANT PROJECTS:

Data Integration and Dashboard Development for Utility Project Tracking

-Integrated data from SAP, SQL, and Excel to create a comprehensive PowerBI dashboard tracking project progress budgets, and KPIs.

Predictive Analytics for Utility Maintenance and Asset Management

-Developed predictive models using Python/R to forecast maintenance needs and equipment failure, improving asset management.

Anomaly Detection System for Utility Data

-Developed predictive models using Python/R to forecast maintenance needs and equipment failure, improving asset management.

Cloud-Based Data Warehouse for Project Data Consolidation

· -Designed and implemented a cloud-based data warehouse (Snowflake/Azure Synapse) for centralizing utility project data, enhancing reporting efficiency.

CERTIFICATIONS & TRAININGS:

Data Visualization with Power BI.

SQL for Data Analysis

Certified Amazon Web Services (AWS)

Certified Business Analysis Professional (CBAP)

Data Analyst Associate (Power BI)

Excel Data Analysis: Forecasting and Trend Analysis

Contact this candidate