Data Analyst Analytics

SPURTHI GAJJALA

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

Phone: 217-***-****

SUMMARY:

A versatile, skilled, and results-driven Data Analyst with over 9 years of experience in logical data modeling, developing technical data requirements, and application support with Big data analytics and metadata management. Expertise in data curation, implementing data governance frameworks, and ensuring the integrity and accuracy of data. Proficient in building, optimizing, and maintaining large-scale data pipelines using Hadoop, Spark, and Hive. Thrives in dynamic and fast paced environments with outstanding technical, interpersonal, people management and stakeholder relationship management skills.

CERTIFICATIONS:

IT Project Management - May 2016

Business Process Management - Jul 2017

SQL certification - https://certification.w3schools.com/w3certified.asp?id=11315782

Tableau Desktop 1 and 2 – Certificate of Completion

Certified Scrum Master - https://www.scrum.org/certificates/650309 (Verification email - **********@*****.***)

TECHNICAL SKILLS:

Databases: Snowflake, Oracle, DB2,Azure SQL DB MS SQL Server, MySQL, SAS Enterprise Miner.

Big Data Technologies: Hadoop (HDFS, MapReduce), Apache Hive, Apache Pig, Apache Spark, HBase, YARN

Tools: Jira, Datadog, Splunk, Insomnia, Miro, Selenium, Confluence, Mural, MS Office Suite

Reporting Tools: SQL Server Reporting Services, Power BI Desktop, Tableau

Cloud Platforms: AWS (S3, EC2, Lambda, RDS), Azure DevOps, Salesforce, Azure HDInsight

ITIL Processes: Incident Management, Change Management, Problem Management, ServiceNow

Data Management: Azure Databricks, Apache Airflow, Spark, Kafka, Talend, Salesforce

Data Governance: Collibra, Informatica, Alation

EDUCATION:

University of Illinois - Springfield, IL Jan 2016 - Dec 2017

Master of Science: Management Information Systems

Jawaharlal Nehru Technological University – Hyderabad, India Aug 2011 - May 2015

Bachelor of Science: Electronics and Communications Engineering

PROFESSIONAL EXPERIENCE:

Fidelity, Raleigh, NC Jul 2022 – Current

Senior Data Analyst

Collaborate with multiple data analytics projects using Hadoop and Azure Databricks to process and analyze high-volume financial transactions, market data, and customer behavior across multiple platforms.

Collaborating with business and technology partners to manage and administer Azure DevOps organizations, projects, users, and permissions.

Oversaw and prioritized the Product Backlog in Azure DevOps by maintaining a comprehensive list of data quality requirements, including data validation rules, data integration tasks, and data governance improvements.

Lead the creation and optimization of ETL pipelines using Azure Data Factory and Apache Spark to seamlessly move, transform, and analyze transactional and financial data from various internal and external sources, reducing processing times.

Implemented Azure Data Factory pipelines to ingest data from on-premises SQL Server databases into Azure SQL Database, achieving a reduction in data processing time.

Assisted in building scalable, high-performance data processing frameworks leveraging Hadoop, Azure Data Lake, and Azure SQL Database to handle structured and unstructured financial data for reporting and analysis.

Utilized Azure Synapse Analytics to develop interactive dashboards and real-time analytics solutions that provided executives with key insights

Work with version control tools like Git, GitHub and Bitbucket to mainline code quality across all environments throughout the development lifecycle.

Developed robust data pipelines using Python to automate data collection, transformation, and loading, significantly increasing efficiency in vulnerability data processing.

Utilized Python's advanced data libraries (such as Pandas and NumPy) for complex data analysis, enabling the identification and remediation of security vulnerabilities through actionable insights.

Implemented Python scripts to perform data quality checks, ensuring high standards of data integrity for accurate security analytics and reporting.

Utilized data mining techniques like clustering, classification, regression to analyze large datasets and extract actionable insights for business stakeholders.

Created ad-hoc reports and data visualizations using Power BI to support various business units and Report and dashboard creation, DAX, Power Query, data modeling

Create and maintain CI/CD pipelines for different types of applications and deployment scenarios.

Humana, Louisville, KY Sep 2021 – Jun 2022

Data Analyst

Lead and manage healthcare data analytics projects using the Hadoop ecosystem (HDFS, MapReduce, Hive) to process and analyze large-scale clinical, operational, and claims data from hospitals and insurance providers.

Contributed to the Sprint Backlog in Azure DevOps by helping define and document user stories related to data quality, including data cleansing tasks and data validation processes.

Collaborate with stakeholders to design and implement ETL pipelines for healthcare data, ensuring seamless extraction from various sources (EMRs, EHRs, clinical trial data, insurance claims).

Assisted in automating data transformation workflows using Apache Spark to streamline the processing of large healthcare datasets, reducing processing time by 30%.

Worked extensively with healthcare claims data to perform detailed analysis on reimbursement patterns, provider performance, patient outcomes, and cost analytics.

Assisted in tracking and updating the status of sprint tasks in Azure DevOps, ensuring alignment with sprint goals and providing regular updates to stakeholders.

Successfully migrated legacy ETL processes to Azure Data Factory, resulting in improvement in data processing efficiency.

Managed/supported release cycle, coordinated with Application & Infrastructure Teams using Azure DevOps

Improved data processing performance by optimizing MapReduce jobs and leveraging Apache Spark for more efficient data transformations.

Creating Power BI reports using DAX queries and writing custom measures.

Defined relationships between OLAP cubes and Dimensions cube in MS Azure Analysis Services.

Implemented data validation and integrity checks within Snowflake, ensuring the accuracy and quality of security-related data.

Maintained dimensional data models (star schema, snowflake schema) to support analytical reporting and business intelligence (BI) needs

Conducted exploratory data analysis (EDA) and applied data mining techniques, clustering algorithms to identify different data segments.

Led the transformation of incident support processes by integrating Power BI analytics, providing faster and more efficient response capabilities.

Fidelity, Raleigh, NC May 2020 – Aug 2021

Data Analyst

Analyzed investment portfolios, market data, and customer transaction histories to identify patterns, trends, and opportunities for portfolio optimization and risk mitigation using the Hadoop ecosystem.

Used Apache Hive and Pig to query large datasets and produce financial reports for internal teams and external regulatory bodies, reducing report generation time by 30%.

Conducted trend analysis and statistical modeling to analyze the impact of macroeconomic factors on stock prices, helping portfolio managers make data-driven decisions.

Performed independent and complex functional data analysis for multiple projects supporting several data conversions at one time and extract data from different sources to build insightful reports in Tableau.

Developed and maintained ETL workflows using SSIS to extract, transform, and load data from various sources into Snowflake data warehouse

Using Stored Procedures, Indexes, Functions, and various types of constraints to increase the efficiency.

Spearheaded end-to-end project lifecycle planning for analytics initiatives, leveraging Snowflake's scalable architecture to manage large sets of security data.

Enhanced the detection of system vulnerabilities by creating complex SQL queries within Snowflake, streamlining data analysis and reporting processes.

Optimized performance and scalability of Power Platform applications by fine-tuning Dataverse entities, relationships, and security configurations

Scheduled and maintained Jobs weekly and monthly basis as per the client requirements.

Provided production support to Tableau users and wrote custom SQL queries to support business requirements.

Performed functional analysis for projects to support the transition with documentation such as the Conversion Strategy Document(CSD).

Received data from external record keepers and posted those records to the mainframe environment for programming. Interacted with external record keepers to understand and decipher file layouts to convert them to Fidelity layouts.

Lead the team through continuous refinement, planning and story mapping while identifying critical test scenarios for UAT testing, Functional testing, and XRAY testing.

Working familiarity with integration testing and tools such as Datadog and Splunk and familiarity with cloud migration tools and strategies.

Wells Fargo, Charlotte, NC Apr 2019 – Apr 2020

Data Analyst

Worked in Data Extraction, Transformation and Loading from source to target system using SQL Server Integration Services.

Created different ETL packages using SSIS from Excel to SQL server.

Assisted in developing financial reports from large datasets sourced from transactions, stock exchanges, and internal systems.

Performed exploratory data analysis (EDA) on market trends, customer segmentation, and financial transactions to identify key drivers of business performance.

Cleaned and transformed financial data from legacy systems and external sources into a standardized format for analysis, using SQL and Hadoop.

Developed ad-hoc reports for senior management, highlighting key financial metrics such as liquidity ratios, profitability, and credit risk exposures.

Crafted and maintained Python-based analytical tools to support dynamic dashboards and visualizations in Tableau, enhancing data-driven decision-making for security management.

Led data engineering initiatives by writing Python code for extracting and integrating data from various sources, which directly supported the development of comprehensive security posture analytics.

Migrated Tableau reports from SSRS reports and published to the end users.

Developed SQL queries, stored procedures, and functions for SQL Server databases on On-Premises

Check tickets in ServiceNow for various applications and ensure resolution within defined SLA.

Migrated data from legacy system to Oracle database and completed 99% records mapping.

Mentored and managed a cross-functional team of 15 resources to deliver quality products.

Enforced Agile principles that reduced the Cycle time by 25% which increased the team's throughput.

Crisis Assistance Ministry, Charlotte, NC Jan 2018 - Mar 2019

Salesforce Data Analyst

Maintained and documented performance processes to continuously monitor data quality and integrity in Salesforce.com.

Creation and management of dashboard, reports, forms, templates, and layouts within Salesforce.

Advising a diverse and ambitious group of stakeholders on Salesforce issues with the ability to translate technical conversations to non-technical audiences.

Customizing Salesforce using workflows while maintaining all objects, layouts, fields, and pages to keep the CRM current and user friendly.

Gathered business requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.

Responsible for maintaining the integrity of the SQL database and reporting any issues to the database architect.

Extensively used Visio to create Use Cases Diagrams and Activity Diagrams.

Worked on salesforce.com standard objects like Accounts, Contacts, Opportunities, Products, Price books, Cases, Leads, Campaigns, Forecasting, Reports and Dashboards

Write and maintain Apex classes, triggers, and batch processes to automate business processes and extend Salesforce functionality.

Implement and maintain Salesforce security settings, including object-level and field-level security

Communicate effectively with cross-functional teams, stakeholders, and leadership to provide project updates and ensure transparency.

Perform code reviews, unit testing, and deployment activities following best practices and release management processes.

Swell Vision, Charlotte, NC Jun 2016 - Dec 2017

Salesforce Analyst

Administered and configured Salesforce platform to support sales, marketing, and service operations, including user setup, profiles, roles, and permission sets.

Developed and maintained custom objects, fields, validation rules, workflows, and process builder flows to automate business processes and improve efficiency

Capture e-commerce KPIs and analyze trends over time. Perform deep dive analysis into specific KPI’s to understand the underlying influencers.

Configure Salesforce solutions to address business needs, including sales, service, marketing, and community cloud implementations

Developed automated data mining processes that generated weekly reports on sales trends, contributing to improvement in forecasting accuracy

Applied data mining techniques like clustering, classification, regression to analyze customer behavior data, resulting in targeted marketing strategies and an increase in customer retention.

Experience providing training to development teams on how to track, plan and analyze using JIRA.

Developed reports for the SEO, leadership teams and other business areas to gain buy-in for SEO projects and report on progress of SEO.

Worked alongside of content team and product team to increase conversion rate by 17% and optimize email marketing with Click Through Rate (CTR) by 13%

Used Google Ad-words, Webmaster Tools, and Hit-wise to monitor keyword performance.

Conducted system integration testing between Shopify, Quick-books and Prosper-works for defects in website and made new enhancements.

Maintained and developed Test Plans while documenting reusable Test Cases for both systems testing and end-to-end business(B2B) testing.

Sri and Associates, Delhi, India June 2015 - Dec 2015

Salesforce Analyst

Engaged with business stakeholders to gather/analyze requirements and mapped them to solutions that leveraged Salesforce functionality.

Collaborated with cross-functional teams to design and implement custom solutions using declarative tools and Apex code

Worked with salesforce.com standard objects like Accounts, Contacts, Opportunities, Products, Price books, Cases, Leads, Campaigns, Forecasting, Reports and Dashboards.

Created data flow diagrams and process flow diagrams to facilitate better system understanding.

Update lead assignment tables, workflow rules, approval process, validation rules, visual force pages, Apex triggers, Apex classes, page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.

Performing database de-duping and clean up procedures. Maintaining customer portal, multiple user roles, security, profiles, permission sets

Assisted in the development and maintenance of Salesforce governance policies, data security standards, and data management procedure

Creating business processes for custom and standard objects with appropriate record type and assigned them to specific profiles and page layouts.

Developed and performed standard queries using SQL to ensure data quality.

Assist with project implementation and control monitoring process related to quality assurance (QA) and user assisted testing (UAT) and A/B testing.

Contact this candidate