Home

harshita - data analyst

[email protected]

Location: Taft, Texas, USA

Relocation:

Visa: H1B

Harshita Kadaluri [email protected] | +1(972)-431-0493 | PROFESSIONAL SUMMARY Experienced Data Analyst with over 9+ years of hands-on expertise in analyzing complex datasets, extracting actionable insights and presenting findings to drive strategic business decisions. Proficient in SQL, Python, and R for data manipulation, statistical analysis, and predictive modeling. Skilled in developing interactive dashboards and reports using Tableau and Power BI to visualize trends and KPIs effectively. Strong background in ETL processes, data cleansing, and database management across Oracle, MySQL, and MongoDB environments. Managed data consistency and integrity across different ERP modules, identifying discrepancies and ensuring data accuracy in multi-system environments. Proven ability to collaborate cross-functionally to optimize data workflows and ensure data integrity, contributing to organizational success. Developed and executed comprehensive data migration strategies for moving data between legacy systems and modern databases or cloud platforms. Utilized Hadoop, Spark, and Hive for processing and analyzing large-scale datasets, enhancing scalability and performance of data operations. Implemented data governance strategies, including data quality assurance, security protocols, and regulatory compliance (e.g., GDPR, HIPAA). Designed and optimized relational database schemas in Third Normal Form (3NF) to eliminate data redundancy and ensure data integrity, improving overall database performance. Performed extensive data cleansing and transformation tasks during migration to ensure data quality, removing duplicates, inconsistencies, and outdated records. Proficiency in geospatial data analysis using tools such as GeoPandas or ArcGIS for mapping and spatial visualization, facilitating location-based insights and strategic planning. Developed scripts in Python using libraries like Beautiful Soup or Scrapy for web scraping and accessed APIs (e.g., RESTful APIs) to collect data from various online sources, enriching datasets for analysis. Extracted, transformed, and analyzed large datasets from various SAP modules (e.g., SAP ERP, SAP ,SAP FICO, SAP MM) to provide actionable insights and support business decisions. Leveraged YAML for data serialization in application development, enhancing readability and ease of data manipulation. Applied deep learning techniques using frameworks like TensorFlow or PyTorch for image recognition, natural language processing, and anomaly detection, improving accuracy in predictive modeling and data classification tasks. Expertise in Amazon Redshift, leveraging MPP, columnar storage, and advanced compression for scalable data warehousing solutions. Conducted data extraction from various sources and performed extensive cleaning and preprocessing to ensure high-quality datasets for analysis Proficient in optimizing query performance, integrating with AWS services, and ensuring data security and compliance. Managed and analyzed product data related to engineering change requests (ECRs) and change orders (ECOs), ensuring that changes were accurately reflected in the PLM system and communicated across teams. Skilled in Redshift Spectrum for cost-effective analysis of data stored in Amazon S3, supporting data lake architectures. Utilized association rule mining to uncover relationships within transactional data, leading to optimized product recommendations and increased sales Experienced in automatic query optimization, concurrency scaling, and managing workload priorities for efficient operations. TECHNICAL SKILLS Programming Languages: Python, R, Java, Scala, JavaScript Data Analysis: Pandas, NumPy, SciPy, SAS Machine Learning: TensorFlow, PyTorch, scikit-learn Data Visualization: Tableau, Power BI, matplotlib, seaborn, Plotly, Bokeh, D3.js, Grafana ETL Tools: Talend, Apache NiFi, SSIS, Informatica PowerCenter, DataStage, Alteryx Database Management: Oracle, MySQL, MongoDB, SQL Server, PostgreSQL, Cassandra Big Data Technologies: Hadoop, Spark, Hive, Kafka, Apache Airflow Cloud Platforms: AWS (Amazon Redshift, S3), Google Cloud Platform (GCP), Microsoft Azure Data Governance: Data Quality Assurance, Security Protocols (GDPR, HIPAA), Compliance Geospatial Analysis: GeoPandas, ArcGIS Web Scraping and APIs: Beautiful Soup, Scrapy, RESTful APIs Version Control: Git Development Environments: Jupiter Notebook, IDEs (Eclipse, IntelliJ IDEA) Containerization: Docker, Kubernetes Operating Systems: Windows, Unix/Linux PROFESSIONAL EXPERIENCE Client: BCBS July 2022 Present Role: Data Analyst Responsibilities: Participated in Scrum meetings and data mapping sessions to understand business needs and discussions on BR document. Identified and documented detailed business rules. To acquire the necessary knowledge become subject matter expert. Designed and developed custom ERP reports and dashboards using tools like SAP BI, Oracle Analytics, and Power BI to provide stakeholders with real-time visibility into operational performance and key business metrics. Created SAP Crystal Reports and SAP Lumira dashboards to visualize data, track KPIs, and monitor operational performance across multiple business units. Managed large-scale product data migrations from legacy systems to PLM platforms, ensuring the accurate transfer of BOMs, design files, and product history. Developed automated reporting systems using tools like Tableau, Power BI, or Excel, allowing real-time monitoring of product lifecycle metrics (time-to-market, product revisions, and costs). Reduced data duplication and redundancy through normalization to Third Normal Form, ensuring efficient storage and faster query response times. Used Power Query / Query Editor for Data transformation like Pivot and UN Pivot the data model as per the reporting needs. Participated in data migration projects during ERP system implementations and upgrades, ensuring the smooth transition of legacy data into new ERP environments. Designed and executed A/B tests to evaluate website and product changes, leading to a 20% increase in conversion rates. Created calculated columns and measures using DAX over data models for the purpose of enhancing Power BI visuals. Monitored the performance of ERP systems and identified areas for optimization, improving the efficiency of data extraction and report generation processes. Applied data validation techniques to ensure data extracted from SAP met business requirements, minimizing reporting errors and improving analysis accuracy. Identified inefficiencies in PLM workflows and collaborated with IT and development teams to automate manual processes, reducing data entry errors and improving operational efficiency. Developed logical data models in 3NF to define relationships between data entities and ensure efficient database design for scalable systems. Experience in creating visuals like Matrix, Clustered Bar Chart, and Multi-Row Card, KPI Visuals, Bar charts etc. Developed at least two - three visual options for each report for discussion with stakeholders and customers. Created/Updated Stored Procedures in T-SQL Server to fetch data from multiple sources and load into target. Worked closely with development teams to implement 3NF databases, ensuring seamless integration with front-end applications and downstream analytics platforms. Interpreted A/B test outcomes and presented findings to cross-functional teams, providing actionable insights that drove strategic decisions. Applied Row-Level security in Power BI Service. Worked on extracts and scheduling them on Power BI service. Managed access of reports, dashboards and data for individual users using roles. Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports and Review accuracy of all data, results, and conclusions of the team Proactively identify areas of opportunity and/or improvement based on trends in the data and use these insights to inform new products and/or operational improvement. Client: Paypal June 2020 - June 2022 Role: Data Analyst Responsibilities: Analyze integrated and extensive datasets to extract value, which directly impacts and influences business decisions. Monitored data performance and system efficiency within SAP, identifying opportunities to streamline data processes and improve report generation times. Improved query performance by designing databases in 3NF, ensuring that data is stored in the most efficient structure, reducing the need for costly join operations and improving access speed. Work collaboratively with key business stakeholders to identify areas of value, develop solutions, and deliver insights to reduce overall cost of care for members and improve their clinical outcomes Developed data capture and navigation desktop and mobile apps in Microsoft Power apps that connect to distribution center solutions design analytics in Power Bl. Interpret and analyze data from multiple sources including healthcare provider, member/patient, and third-party data. Expertise in developing applications using PowerApps, canvas, model driven app, Common Data Service CDS, T-SQL, Forms, SharePoint online, Dynamics 365 CRM, Azure, Web Services Created Dashboards style of reports using Power Bi Desktop Visualizations like Bar Chart, Line Chart, Area Chart and Slicer etc. Developed and implemented ETL pipelines that load data into a 3NF-compliant data warehouse, ensuring that data is clean, structured, and ready for analysis. Developed calculated measures using Data analysis expression language (DAX). Utilized power query in power bi to pivot and UN pivot the data model. Created the reports using charts like Pie, Bar, Line, KPI Visuals, Custom visuals, etc. Charts are used in making reports more user-friendly in analysis purposes. Configure and set up Power BI Service / Report Server Environment and Gateways. Published reports into Power BI publisher and schedule the data sets. Troubleshooting and performance tuning of the SSIS packages. Involved in creating Jobs, T-SQL Mail Agent, Alerts and Scheduling. Identify and perform root-cause analysis of data irregularities and present findings and proposed solutions to leadership and/or customers. Manage multiple, variable tasks and data review processes with limited supervision within targeted timelines. Collaborated with stakeholders to define data migration requirements and mapping rules, ensuring alignment with business objectives and minimizing disruptions during the migration process. Support the design, testing, and implementation of process enhancements and identify opportunities for automation. Apply expertise in quantitative analysis, data mining, and the presentation of data to see beyond the numbers and understand how customers interact with analytic products. Support multiple functions and levels of the organization and effectively, both verbally and visually, communicate findings and insights to non-technical business partners. Client: Master card Sep 2017 - May 2020 Role: Data Analyst Responsibilities: Collaborated with marketing teams to capture requirements for targeted marketing campaigns, ensuring alignment with client objectives. Developed and executed targeted digital advertising strategies using Unica to reach specific demographics and increase brand visibility. Utilized Unica's audience segmentation features to tailor advertising content to different market segments, improving engagement and conversion rates. Leveraged Unica's analytics tools to analyze the performance of digital campaigns, extracting valuable insights for continuous optimization. Conducted data validation and reconciliation after migration to verify data accuracy, ensuring that the new system matches the original data sets with X% accuracy. Provided strategic recommendations and valuable insights to assist in the design and development of marketing requests and campaigns, resulting in a 15% increase in campaign effectiveness. Implemented and managed marketing automation workflows in Salesforce Pardot, streamlining lead nurturing processes and reducing manual tasks. Developed and optimized lead scoring models in Pardot to prioritize leads based on engagement, improving the efficiency of the sales team. Utilized Pardot's dynamic content and personalization features to create targeted and personalized marketing communications, enhancing customer engagement. Created use cases and test scenarios to validate solutions, improving campaign success rates by 20%. Developed functional specifications and system design specifications in collaboration with marketing, legal, and cross-functional teams, ensuring seamless execution. Applied advanced data mining techniques using SQL, excelling in processes such as inner & outer joins, data aggregation, temporary table creation, and data formatting. Performed quality checks on team members' campaigns with 100% accuracy, ensuring data integrity and client satisfaction. Skills: SQL, Salesforce Marketing Cloud, Palantir, Campaign Targeting Tools, Data Research Tools, Microsoft Power BI, IBM Unica Client: Cognizant June 2014 - April 2017 Role: Data Analyst Responsibilities: Analysed business requirements and data specifications to develop efficient data models and ETL processes using SQL and Python. Implemented statistical techniques such as regression analysis and hypothesis testing to extract insights from large datasets, contributing to strategic decision-making. Developed interactive dashboards and reports using Tableau, enabling stakeholders to visualize trends and patterns in data. Collaborated with cross-functional teams in Agile environments to prioritize tasks, ensuring timely delivery of analytical insights aligned with business objectives. Conducted data cleansing and validation procedures to maintain data integrity and accuracy across multiple databases. Presented findings and recommendations to senior management in clear, concise reports, facilitating informed decisions and operational improvements. Improved data accessibility by designing and implementing automated ETL pipelines using Talend, reducing manual effort and enhancing data quality. Implemented big data technologies such as Hadoop and Spark to process and analyze petabyte-scale datasets, driving operational efficiencies and scalability. Designed and deployed data pipelines using Apache NiFi to automate ETL workflows and streamline data integration from disparate sources. Conducted data profiling and quality assessments to identify and rectify anomalies, maintaining high standards of data accuracy and reliability. Developed predictive models using machine learning algorithms to forecast customer churn and support strategic decision-making processes. Presented analytical findings and strategic recommendations to senior management through executive-level reports and presentations. Keywords: javascript materials management business intelligence sthree rlang information technology