Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Anusha Kadarla

Plymouth,MN

Summary

Detail-oriented and results-driven IT professional with over 18 years of experience in IT industry, specializing in data analytics, reports development and data-driven decision-making. Seeking a challenging role as a Data Engineer, Data Analyst, leveraging expertise in SQL, Python, Power BI, Tableau, Excel and advanced analytics to extract actionable insights from complex datasets. Possesses excellent presentation and communication skills, demonstrated through effective collaboration with cross-functional teams and delivering impact presentations.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Data Engineer/Sr. Data Visualization Analyst

LTCG/illumifin
01.2017 - 11.2023
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements.
  • Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
  • Designed and implemented effective database solutions and models to store and retrieve data.
  • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
  • Developed, implemented and maintained data analytics protocols, standards, and documentation.
  • Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
  • Designed data models for complex analysis needs.
  • Utilized SQL and Power BI to analyze business requirements, ensuring data integrity and quality.
  • Analyzed data from multiple sources including healthcare provider, member/patient, and third-party data
  • Developed and validated complex SQL queries for data validation and reporting.
  • Generated Power BI reports for PPM time tracking system, contributing to data-driven decision-making.
  • Knowledge of statistical, analytical, or data mining techniques including data modeling,trend analysis, and root-cause analysis.
  • Worked collaboratively with key business stakeholders to identify areas of value, developed solutions, and delivered insights to reduce overall cost
  • Conducted end-to-end data analysis and troubleshooting for data discrepancies.
  • Created pipelines and deployed latest builds in Azure DevOps
  • Created Active Batch jobs to send feeds to clients like Thrivent, NYL, BCBS etc.
  • Generated Power BI reports on Snowflake data set for client Transamerica
  • Used basic Python commands for data analysis.

Digital Data Analytics

ICF Olson Companies
02.2015 - 01.2017
    • Coordinated with clients and Digital marketing team to gather accurate data, devising strategies for digital optimization
    • Analyzed digital data from various sources like websites, mobile applications for obtaining insights on how users and customers are receiving
    • Helping marketing teams by performing analysis on campaigns and projects and translating data into less complicated terms
    • Prepared reports, conducted analysis, exploring dashboards and evaluating website visitors
    • Led data analytics efforts, analyzing HTML files on FTP server and validating data on target databases
    • Utilized SQL for database validation and performed data analysis
    • Employed data analytics tools to validate major and minor enhancements and ensure data accuracy
    • Environment: Tableau, SQL Server Management Studio, JIRA.
    • Identified, analyzed and interpreted trends or patterns in complex data sets.
    • Utilized data visualization tools to effectively communicate business insights.
    • Used statistical methods to analyze data and generate useful business reports.
    • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
    • Collaborated with business-unit leaders to identify and prioritize problems.
    • Produced monthly reports using advanced Excel spreadsheet functions.

Sr. BI Analyst

Wells Fargo Home Mortgage
08.2014 - 02.2015
  • Analyzed data for SSDM project, ensuring seamless integration from various sources to data mart layer
  • Developed and executed SQL queries for data validation and performed system integration testing
  • Contributed to end-to-end data warehouse system integration testing and delivered actionable insights
  • Environment: Teradata SQL Assistant, SQL, JIRA.
  • Collected data from wide-ranging sources.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
  • Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Handled massive quantities of business intelligence data,

BI Data Visualization Analyst

PeopleNet Communications
03.2014 - 08.2014
    • Conducted data analysis for UI reports migration, ensuring data integrity and quality
    • Utilized Business Objects for report generation and validation
    • Actively participated in Agile Scrum meetings, providing data-driven insights for decision-making
    • Environment: MS SQL Server 2008, Business Objects, JIRA.
    • Identified and resolved problems through root cause analysis and research.
    • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
    • Assessed data modeling and statistics to integrate high-level business processes with data rules.
    • Generated reports detailing findings and recommendations.

Sr. ETL Analyst

Boston Scientific Corp
09.2013 - 03.2014
  • Analyzed business requirements and data mapping specifications for ADAM-DRAGON project
  • Created and executed test data for ETL mapping rules, performing end-to-end data warehouse system integration testing
  • Employed SQL for data validation and collaborated on data analytics for ongoing reporting
  • Environment: TOAD, Informatica, SQL
  • Identified and resolved problems through root cause analysis and research.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
  • Queried databases for information needed for report processing.

Database Analyst

BestBuy Mobile
01.2012 - 08.2013
  • Led data analytics processes for Bounty calculation, involving matching activation data with POS activity
  • Responsible for commission values, store credit information, and downstream application system propagation
  • Coordinated deliverables between offshore and onsite teams
  • Ensured adherence to data analytics standards
  • Worked in Agile Methodology, participating in Sprint meetings
  • Gathered Requirement Documents and Design Specifications
  • Created data analysis scenarios and cases based on business requirements
  • Conducted System Integration, Functional, and Regression analysis
  • Managed continuous change requests from both US and CA countries
  • Served as escalation point for data analysis issues
  • Provided weekly status reports with data analytics metrics
  • Verified data between Web Java Based Back Office UI tool and backend database
  • Environment: SQL Developer for Oracle, PVCS Tracker, SSH Client, UI, SOAP UI web service, Java Based web application.
  • Maintained data dictionary by revising and entering definitions.
  • Completed data mining and electronic documentation reviews.
  • Conducted tests to identify issues and make necessary modifications.

ETL Analyst

Blue Cross Blue Shield
08.2011 - 01.2012
    • Led data analytics efforts to populate existing BCBSMN Data Warehouse tables with NASCO adjudication data, including Claim data, ITS, Financial, and Supplemental data
    • Analyzed functional requirement specifications
    • Verified mapping documents and design templates for data analysis
    • Conducted source system analysis, data transformation, and validation
    • Used Informatica Designer for reviewing data mappings
    • Created SQL Queries in TOAD for data analysis and validation
    • Utilized SAS Enterprise Guide for creating data analysis reports
    • Environment: Informatica 8.6, TOAD for DB2, SQL Server, Teradata SQL Assistant, SAS Enterprise Guide 4.3
    • Identified and resolved problems through root cause analysis and research.
    • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
    • Assessed data modeling and statistics to integrate high-level business processes with data rules.
    • Generated reports detailing findings and recommendations.

ETL Analyst

United Health Group
02.2011 - 08.2011
  • Contributed to user acceptance testing of Data Warehouse - CRP, integrating data from various source systems with focus on data analytics
  • Created data analytics documentation, including Data Analysis Scripts, Requirement Traceability Matrices, and Data Analysis Summary Reports
  • Facilitated cross-functional reviews of Data Analysis Plan
  • Worked with Business Team to identify Business Scenarios for data analytics
  • Monitored workflow transformations in Informatica workflow monitor
  • Executed Data Analysis Scenarios, running queries against Source and Client systems
  • Used Informatica for data loading from Oracle and flat files
  • Generated SAS BI Reports using SAS Web Report Studio
  • Environment: Aqua Data Studio Version 8, TOAD for Oracle 10.5, SAS Web Report Studio 3.1.
  • Identified and resolved problems through root cause analysis and research.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Recommended process improvements to continually identify, analyze and fix constraints and challenges.
  • Queried databases for information needed for report processing.

BI Analyst

Blue Cross Blue Shield
11.2010 - 02.2011
    • Led data analytics efforts for moving Provider information from SDS tables to DW level
    • Compared source tables with target tables for database analysis
    • Used Informatica Workflow Manager for running data workflows
    • Validated Dashboard and customized reports
    • Monitored session logs/log files in Informatica Workflow Monitor
    • Utilized SAS Enterprise Guide for creating data analysis reports
    • Environment: SAS Enterprise Guide 4.3, TOAD for DB2, Informatica.
    • Collected data from wide-ranging sources.
    • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
    • Optimized BI reporting capabilities for secure server environment.
    • Created data analysis tools to allow teams to query acquired information for unique details.
    • Analyzed data to identify root causes of problems and recommend corrective actions.

BI Analyst

Wells Fargo Insurance Inc.
11.2009 - 11.2010
  • Contributed to data analytics interfaces from Wachovia Application Handling origination systems to Wells Fargo SHAW servicing systems
  • Reviewed SRS documents and prepared Test Bed for data analytics
  • Executed SQL scripts for NDB Contract Support using T.O.A.D and SQL Plus
  • Environment: Mainframe, SQL
  • Collected data from wide-ranging sources.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.
  • Created data analysis tools to allow teams to query acquired information for unique details.
  • Maintained proficiency with latest database technologies.
  • Designed customized data collection models for specific visualization tasks.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Developed customized reports, summarizing and presenting data in visually appealing format.

Jr. Data Analyst

Citibank Asia Pacific
08.2007 - 09.2009
  • Contributed to data analytics on Enhanced Credit Management System, Vision plus based application dealing with credit management in Cards realm
  • Worked on Transaction Posting data analytics of Credit Cards and full cycle of Credit Card Billing Process
  • Worked on UI Web application called Advanced Merchant Working Station (AWS)
  • Worked with both support teams in Onshore-Offshore model
  • Developed and implemented functionality and regression data analytics tests.
  • Investigated system issues and implemented resolutions to reduce downtime.
  • Provided recommendations regarding new hardware and software to keep IT infrastructure up to date.
  • Assessed business requirements to create focused solutions.
  • Improved systems with addition of new features and infrastructure.
  • Enhanced interfaces to promote better functionality for users.
  • Educated stakeholders on data protection tactics to reduce breaches.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Developed customized reports, summarizing and presenting data in visually appealing format.
  • Assessed business requirements to create focused solutions

IS Data Analyst

United Health Care
10.2006 - 07.2007
  • Contributed to data analytics for Release Management project supporting three business groups: Emptoris, PPO One, and NDB
  • Performed System data analytics, Functional data analytics, Integration data analytics, and Regression data analytics
  • Executed SQL scripts for NDB Contract Support
  • Environment: UI, F-Secure SSH File Transfer 5.2 Build 10, Attachmate Reflection SFTP Client 6.1.1, T.O.A.D (8.5.3), SQL Plus, Microsoft .NET Framework 2.0.
  • Provided technical recommendations and support documentation to aid in GIS process improvement.
  • Combined remotely-collected and on-site data acquisition to generate unified geographic mapping information.
  • Designed standardized protocols for data collection, creating cohesive database input guidelines to streamline intelligence retrieval and exploitation.
  • Worked with clients to meet specific technical specifications and solve operational concerns.
  • Leveraged skills in modeling, rendering and plotting to visually represent geospatial data.

Systems Data Analyst

Wells Fargo Home Mortgage
03.2006 - 10.2006
  • Focused on data analytics and re-positioning ALT-A Product set with more competitive offering
  • Designed data analytics scenarios for testing of software programs
  • Developed and implemented software program Functional and Regression Data Analytics Tests
  • Conducted System data analytics, Functional data analytics, Integration data analytics, and Regression data analytics
  • Created and designed data analytics scenarios
  • Prepared reports on defects and problems during data analytics.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Utilized data visualization tools to effectively communicate business insights.
  • Participated in requirements meetings to understand business needs.
  • Used statistical methods to analyze data and generate useful business reports.
  • Documented effective and applicable methods for extracting data and organizing data sources.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Created data models to support decision-making processes.

Database Validation Spec

Wells Fargo Home Mortgage
08.2005 - 03.2006
  • Contributed to data analytics by verifying loan documents and processing them by looking for type of loans and loan numbers, then sending them to Auditing
  • Customer's information needs to be verified
  • Creation and design of data analytics scenarios for testing
  • Review and checking of data analytics scenarios
  • Development and implementation of Functional and Regression Data Analytics.
  • Documented entire validation process, noting changes or alterations completed.
  • Trained and assisted staff in validation techniques, methods and testing processes.
  • Participated in system design and commissioning phase, interfacing directly with clients to ascertain clear, concise milestones for integration into development timelines.
  • Met tight deadlines to satisfy client demands and project timelines.
  • Trained and guided onsite and offshore team members in quality assurance standards, policies and procedures.
  • Monitored and reported on test results and performance data to identify areas of opportunity for improvement.
  • Worked with stakeholders and team members on quality assurance efforts for hardware components.

Education

Bachelor of Technology in Computer Science and Engineering - Computer Science And Engineering

India
04.2005

Skills

  • Windows
  • UNIX
  • SQL Server
  • Teradata
  • Oracle
  • DB2
  • Snowflake
  • SQL
  • Python
  • Jupyter
  • Visual Studio Code
  • Power BI
  • Business Objects
  • Tableau
  • SAS
  • Microsoft Excel
  • Statistical Analysis
  • Azure DevOps
  • Azure Data Factory
  • Azure Synapse Analytics
  • Data Engineer
  • ETL Processes

Certification

Certified Professional in Power BI, https://courses.edx.org/certificates/46361510e82c4af1860fca00d701102d

Timeline

Data Engineer/Sr. Data Visualization Analyst

LTCG/illumifin
01.2017 - 11.2023

Digital Data Analytics

ICF Olson Companies
02.2015 - 01.2017

Sr. BI Analyst

Wells Fargo Home Mortgage
08.2014 - 02.2015

BI Data Visualization Analyst

PeopleNet Communications
03.2014 - 08.2014

Sr. ETL Analyst

Boston Scientific Corp
09.2013 - 03.2014

Database Analyst

BestBuy Mobile
01.2012 - 08.2013

ETL Analyst

Blue Cross Blue Shield
08.2011 - 01.2012

ETL Analyst

United Health Group
02.2011 - 08.2011

BI Analyst

Blue Cross Blue Shield
11.2010 - 02.2011

BI Analyst

Wells Fargo Insurance Inc.
11.2009 - 11.2010

Jr. Data Analyst

Citibank Asia Pacific
08.2007 - 09.2009

IS Data Analyst

United Health Care
10.2006 - 07.2007

Systems Data Analyst

Wells Fargo Home Mortgage
03.2006 - 10.2006

Database Validation Spec

Wells Fargo Home Mortgage
08.2005 - 03.2006

Bachelor of Technology in Computer Science and Engineering - Computer Science And Engineering

India

Similar Profiles

CREATE PROFILE
Anusha Kadarla