Mamata Barik

Experience

• 

  Highmark Health

  Sept 2017 - Mar 2018

  Junior Healthcare Data Analyst

  Simplified complex data sets for the creation of advanced, easy-to-use health records system.•Managed complex healthcare datasets and wrangled them into a more usable format by mastering advanced Excel.•Established benchmarks for quality assurance outcome measurement, resulting in 15% increased department accountability.•Contributed to data cleaning, anonymization, and standardization procedures that increased dataset usability by 20%.

• 

  NCR Corporation

  Apr 2018 - Jun 2019

  Database Analyst

  • Designed and implemented an ETL process to integrate data from multiple sources into a centralized data warehouse• Ensured data consistency and accuracy through data mapping and transformation• Enabled stakeholders to access and analyze integrated data for reporting and analysis purposes• Assisted in creating and presenting informational reports for management based on SQL data.• Often called on to help make changes to the SQL database that would prevent data corruption.• Engineered complex SQL queries to extract data from multiple tables, improving report accuracy by 20%• Developed interactive Power BI dashboards for business users, resulting in 50% faster decision making Show less

• 

  Sprint

  Jul 2019 - Sept 2022

  Data Management Analyst

  ⦁ Developing and executing a long-term strategy for ⦁ enterprise test data management⦁ Estimating testing-related tasks, analyzing testing requirements, designing and developing supporting tools, testing, and implementing TDM processes and solutions⦁ Identifying the ⦁ Type of Data required for Software Testing ⦁ Developed PL/SQL Package, procedure, functions, triggers, indexes and collections to implement business logic.⦁ Created indexes on the table for faster retrieval for enhance database performance.⦁ Creating consistent and repeatable processes to support multiple functions, such as identifying and masking test data for different applications and refreshing/updating test data as needed⦁ Ensuring compliance with IT security guidelines and ⦁ data compliance regulations⦁ Provisioning data for QA testing, user acceptance testing, and performance testing.⦁ Developed UNIX shell scripts that help as a scheduler for data load.⦁ Created data mapping files for the data coming from different web services.⦁ Worked on customer service call data from different web services⦁ Proven track record in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.⦁ Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into staging tables. Show less

• 

  Charter Communications

  Sept 2022 - now

  SQL Data Analyst

  ⦁Wrote complex SQL queries to extract, manipulate, and analyze data from large databases• Developed and maintained stored procedures, functions, and triggers to automate data processing tasks• Created and optimized database indexes and views to improve query performance• Generated ad-hoc reports and dashboards to visualize key metrics and trends for stakeholders• Design, develop, validate, and troubleshoot the ETL workflows and datasets in Alteryx• Hands-on skills and work experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Parsing, Transforms, and Predictive• Write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx• Document and Publish Alteryx workbooks and data extracts/ Alteryx workflows/macros•Managing and designing the reporting environment, including data sources, security, and metadata.•Supporting the data warehouse in identifying and revising reporting requirements.•Supporting initiatives for data integrity and normalizationWrote complex SQL queries to extract, manipulate, and analyze data from large databases• Developed and maintained stored procedures, functions, and triggers to automate data processing tasks• Created and optimized database indexes and views to improve query performance• Generated ad-hoc reports and dashboards to visualize key metrics and trends for stakeholders• Design, develop, validate, and troubleshoot the ETL workflows and datasets in Alteryx• Hands-on skills and work experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Parsing, Transforms, and Predictive• Write complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx• Document and Publish Alteryx workbooks and data extracts/ Alteryx workflows/macros•Managing and designing the reporting environment, including data sources, security, and metadata.• Show less