Data Analyst A Team

Surya Nagesh Kantamani

Email: ********************@*****.***

Mobile: +1-901-***-****

Aspiring Data Analyst

PROFESSIONAL SUMMARY:

Leveraged 4 years of experience applying analytical thinking and problem-solving skills to design and implement data solutions, ensuring attention to detail and innovative approaches. As a team player, I effectively prioritize tasks and manage multiple projects.

Migrated legacy systems, demonstrating strong PL/SQL skills in writing and analyzing complex queries and stored procedures, while working in Agile/Scrum teams for prioritization and resource assignments. I connect dots across applications.

Automated ETL workflows, reducing manual effort and improving data accuracy, while exhibiting expertise in Microsoft Office suite usage for reporting and analysis. I am willing to ask questions and reach out for assistance.

Collaborated with cross-functional teams, communicating effectively with both technical and non-technical audiences, to implement scalable data solutions aligned with business needs. I can influence and guide teams.

Conducted advanced data analysis, delivering insights through statistical modeling and exploratory data visualizations, demonstrating an analytical mindset and attention to detail. I work well in a team environment.

Executed A/B testing and hypothesis testing to evaluate marketing campaigns, optimize digital strategies, and guide decision-making with measurable results. I understand effort and financials estimation.

Automated ETL pipelines and recurring business reports by integrating APIs and external data sources, reducing reporting time and eliminating manual errors. I have experience with Oracle Exadata or 10g and above.

Authored reusable, optimized SQL scripts and stored procedures for cleansing and transforming large datasets, demonstrating strong PL/SQL skills and attention to detail. I understand the E2E view.

Collaborated with cross-functional teams to deliver scalable analytics projects aligned with agile sprint cycles and stakeholder goals, communicating effectively across the organization. I am a strong team player.

Developed Looker dashboards to support departmental KPIs and strategic forecasting, streamlining operational visibility across distributed teams, and demonstrating proficiency with query tools. I work with minimal supervision.

Ensured compliance with enterprise data governance standards, demonstrating attention to detail and problem-solving skills in protecting sensitive information. I am good with identifying priorities and managing projects.

Delivered customer behavior insights through segmentation and churn analysis, helping marketing and product teams boost engagement and improve campaign ROI. I possess strong communication and presentation skills.

TECHNICAL SKILLS:

Languages - SQL, Python, R, PL/SQL

Data Visualization - Power BI, Tableau, Google Data Studio

Databases - MySQL, PostgreSQL, MS SQL Server, BigQuery, Oracle Exadata, Oracle 10g

Cloud Platforms - Google Cloud Platform (BigQuery, GCS, Cloud Functions), AWS (basic)

ETL Tools - Apache Beam, Dataflow, Python (Pandas), Airflow (basic)

Statistical Methods - Regression, Clustering, A/B Testing, Hypothesis Testing, Forecasting

Tools - Excel (Pivot Tables, VLOOKUP), Git, Jupyter, Google Sheets, Microsoft Office Suite

Processes - Agile, Scrum

PROFESSIONAL EXPERIENCE:

Bank of America May 2024 – Present

Data Analyst

Responsibilities:

Demonstrated expertise in analytical thinking by building scalable GCP pipelines using BigQuery and Dataflow for real-time and batch ingestion, accelerating analytics delivery across financial transaction datasets. This work required attention to detail and innovative thinking skills to optimize performance.

Designed executive Power BI dashboards monitoring over 100K transactions daily, detecting behavioral anomalies and automating high-risk flags to enhance regulatory compliance and fraud detection efficiency, showcasing strong communication and presentation skills to stakeholders. This improved the E2E view.

Developed advanced PL/SQL queries and stored procedures to standardize multi-source data, reducing processing time by 45% and improving data quality for downstream reporting layers, demonstrating proficiency with query tools and strong PL/SQL skills. This required problem solving skills.

Automated credit scorecards and customer risk profiling in collaboration with risk teams, integrating macroeconomic signals and behavioral models to support lending decisions and compliance monitoring, requiring the ability to effectively communicate across the organization. This was done with minimal supervision.

Migrated warehousing workloads to BigQuery, redesigning schemas and optimizing job execution to increase data accessibility and system performance while cutting cloud query costs, demonstrating proficiency in connecting dots across various applications and business units. This was done as a team player.

Applied Python-based statistical models to detect suspicious activity patterns, embedding anomaly scoring logic into operational dashboards for real-time fraud surveillance by compliance officers, ensuring full compliance with internal audit protocols and data governance standards. This required innovative thinking.

Reduced manual reporting by 70% through Google Data Studio and Power BI automation, enabling timely stakeholder insights across lending, fraud operations, and financial planning teams, demonstrating good prioritization and managing multiple projects simultaneously. This improved the E2E view.

Built Airflow DAGs to schedule transformation jobs in BigQuery, enabling near real-time refresh of financial metrics and dashboards used by executive leadership and audit teams, showcasing willingness to ask questions and reach out for assistance as required. This was done as a team player.

Conducted robust QA, regression testing, and data validation for dashboards, ensuring metric consistency and integrity in critical regulatory, operational, and performance reporting assets, demonstrating attention to detail and problem solving skills. This was done with minimal supervision.

Authored internal documentation and conducted knowledge sharing sessions, enabling onboarding of new analysts and maintaining continuity across ETL and data visualization processes, demonstrating strong communication and presentation skills to both technical and non-technical audiences. This improved the E2E view.

Johnson & Johnson Jun 2021 – Jul 2023

Data Analyst

Responsibilities:

Partnered with supply chain teams to analyze inventory across warehouses, identifying excess stock and reducing overstock by 22% through actionable insights derived from consumption and fulfillment trends, demonstrating expertise in analytical thinking and problem solving skills. This improved the E2E view.

Created real-time Power BI dashboards displaying consumption, inventory, and shipment metrics to help procurement teams forecast demand and resolve supplier issues proactively and efficiently, showcasing strong communication and presentation skills to stakeholders. This required attention to detail.

Conducted root cause analysis on delivery failures by merging SAP ERP and logistics data, reducing issue recurrence by 15% and improving shipment reliability across critical distribution centers, demonstrating proficiency with query tools and strong PL/SQL skills. This was done as a team player.

Created and enforced SQL-based data validation rules to standardize records, identify inconsistencies, and ensure clean, trustworthy data across supply chain management systems and Excel processes, requiring the ability to effectively communicate across the organization. This was done with minimal supervision.

Performed EDA in Python using Pandas and NumPy to uncover delays, temperature deviations, and return patterns across cold-chain healthcare shipments, improving quality control procedures, demonstrating proficiency in connecting dots across various applications and business units. This required innovative thinking.

Collaborated with data governance teams to define business logic, create data dictionaries, and document KPI lineage, ensuring metric accuracy and consistency across all supply chain analytics functions, ensuring full compliance with internal audit protocols and data governance standards. This was done as a team player.

Centralized supply and logistics data using GCP BigQuery, replacing manual spreadsheet-based workflows and improving data accessibility for planning and fulfillment teams, demonstrating good prioritization and managing multiple projects simultaneously. This improved the E2E view.

Analyzed SKU-level performance using historical trends and seasonality, generating time-series charts that improved replenishment strategies across 12+ product lines and various warehouse zones, showcasing willingness to ask questions and reach out for assistance as required. This was done with minimal supervision.

Designed dynamic Power BI reports for regional distribution managers to track shipment timelines, pinpoint delays, and take corrective action across complex interdependent routes, demonstrating attention to detail and problem solving skills. This was done as a team player.

Automated ingestion and cleansing of shipment files from 15+ vendors by creating a Python-based pipeline integrated with Google Cloud Storage, reducing manual pre-processing errors, demonstrating strong communication and presentation skills to both technical and non-technical audiences. This improved the E2E view.

Educational Details:

Master of Science in Computer and Information Systems - Christian Brother University

Contact this candidate