Data Analyst Power Bi

Yuvana Rani Gundu

Sr. Data Analyst

******************@*****.*** 817-***-**** linkedin.com/in/yuvana987 PROFILE

A results-driven professional with 5 years of experience in Data Analysis, ETL Development, and Data Modeling, specializing in Business Intelligence tools like Tableau and Power BI, as well as Big Data and Hadoop technologies. Skilled in Data Migration, Quality, Integration, and Analytics, with strong proficiency in SQL and statistical analysis. EDUCATION

Computer Science Engineering

University of North Texas

SKILLS

•Frameworks and Methodologies: Data Modeling (ER & Dimensional), Database Design, Requirement Analysis, ETL Design, Object Oriented Design, Development, Testing, Data Mapping, Metadata Management, Master Data Management, Data Profiling, Deployment, Documentation, Project Management, Semantic Layer, Data Warehousing, Data Storage Technologies, · Analytical Skills, Data Analysis, Data Visualization, Data Governance, Statistical Analysis, Predictive Analytics.

•Modeling Tools: Erwin 8.x/9.x, ERStudio 9.x, Power Designer.

•Big Data Technologies: Hadoop, Hive, HDFS, MapReduce, Pig, Kafka.

•Reporting Tools: Cognos 8/10, Oracle Reports, Tableau, Business Objects, IDQ, Microsoft Power BI, Looker.

•Other Tools: SQL Navigator, TOAD, T-SQL, Informatica Power Center, Denodo, Ab Initio, Teradata SQL Assistant, Google Analytics, Google Tag Manager.

•Databases: SQL, Sybase, Teradata, DB2, MySQL, PostgreSQL.

•Programming Languages: C, C++, VB, Java, PHP, Python, R, PL/SQL, SQL, SAS, Julia.

•Additional Skills: Dashboards, Extract, Transform, Load (ETL), Datasets, Data Analytics, Microsoft Excel, Microsoft Office, Data Storytelling, A/B Testing, Data Cleaning and Preparation. PROFESSIONAL EXPERIENCE

Data Analyst

Cardinal Health

01/2024 – present Texas, USA

•Documented Source to Target Mapping with data transformation logic to support ETL processes and ensure data quality.

•Translated requirements into efficient data structures for storage, manipulation, and retrieval.

•Collaborated with data modelers and ETL developers to create Data Functional Design documents.

•Ensured models adhered to best practices, including normalization and cost-effective adaptability.

•Utilized Teradata utilities (FastLoad, MultiLoad, TPump) for data loading and wrote, tested, and implemented scripts (BTEQ, DML, DDL).

•Migrated data from Oracle/DB2 warehouses to Teradata and used tools like Teradata Manager, TDWM, PMON, DBQL, and SQL Assistant.

•Designed reports and automated recurring reporting processes using Tableau, Power BI, MS Excel, UNIX scripting, and Teradata utilities.

•Built data-marts as part of Business Objects Universes, replacing manual reporting systems with automated Teradata-based reporting platforms.

•Migrated critical reporting systems to Business Objects and Web Intelligence on Teradata platforms.

•Provided design recommendations to stakeholders, improving processes and resolving technical issues.

•Developed logical and physical ER/Studio data models aligned with corporate standards.

•Applied data analysis techniques to validate business rules and address data quality issues in an Enterprise Data Warehouse

(EDW).

•Tested raw data, identified design flaws in data warehouses, and executed performance scripts.

•Environment: MS Excel, Tableau, Power BI, Oracle 10g, UNIX, SQL, PL/SQL, Power Designer, Informatica, HDFS, Hive, MapReduce, Linux, HBase, Flume, Sqoop, Matlab, SAS. Sr. Data Analyst

Paycom

05/2023 – 12/2023 Texas, USA

•Performed data profiling on source systems for Dual Medicare Medicaid Data Mart.

•Documented process flows, including program development, logic, testing, implementation, application integration, and coding.

•Designed, developed, and integrated ETL components using Talend ETL Platform and Java Technology.

•Managed data duplication and storage into specific data warehouses using Talend for Data Management and MDM.

•Defined trumping rules, list codes, and code conversions between source systems and Master Data Repository (MDR).

•Collaborated with architects to develop current and target state enterprise data architectures.

•Ensured logical and physical ER/Studio data models adhered to corporate standards and guidelines.

•Defined source-to-target data mappings, business rules, and data definitions, including key identifiers and functional requirements for interfaces.

•Documented data quality, traceability, and process flows for change requests and coordinated with development and testing teams.

•Reverse-engineered source databases using Embarcadero and assisted business users with reporting needs.

•Designed and implemented data integration modules for ETL functions, focusing on Data Warehouse and Data Mart design.

•Validated business rules, identified low-quality or missing data, and analyzed their impact on the Humana Enterprise Data Warehouse (EDW).

•Leveraged experience with mainframe enterprise billing systems and defined transformation rules for Dual Medicare Medicaid data.

Environment: SQL Server, Oracle 10g/11g, MS Office, Embarcadero, Netezza, Teradata, Enterprise Architect, Informatica, ER Studio, XML, OBIEE.

Sr. Data Analyst

Databricks

01/2021 – 08/2022 Bangalore, India

•Developed data integration and analysis solutions on Databricks, collaborating with teams to gather requirements, validate data, and document transformation logic for optimized data management.

•Met with customers to determine user requirements and business goals.

•Bridged technical and business objectives by acting as an IT liaison for business users, blending technical expertise with communication skills.

•Worked closely with claims processing teams to identify patterns in fraudulent claims using text mining in R.

•Conducted JAD sessions to gather requirements, performed use case and workflow analysis, outlined business rules, and developed domain object models.

•Performed data analysis and validation with complex SQL queries using TOAD on Oracle databases.

•Wrote Teradata Macros and utilized analytic functions, while migrating data from Oracle/DB2 to Teradata platforms.

•Managed data duplication and storage in data warehouses using the Talend Platform for Data Management and MDM.

•Documented Source-to-Target Mapping with data transformation logic and collaborated with SMEs to analyze legacy system data extracts.

•Designed data structures to efficiently store, manipulate, and retrieve information.

•Worked with internal architects to develop current and target state enterprise data architectures.

•Ensured logical and physical ER/Studio data models adhered to corporate standards, best practices, and normalization rules.

•Assisted in creating Data Functional Design documents with data modelers and ETL developers.

•Environment: Databricks, Oracle 10g, Microsoft Excel, MicroStrategy, MS Visio, MS Project, Informatica, Talend, R, Matlab, SAS. Programmer Analyst

Paypal

03/2019 – 12/2020 Hyderabad, India

•Collaborated with Project Management to create project estimates and performed data analysis to identify data sources and mappings for HCFG.

•Documented Source-to-Target Mapping with data transformation logic and collaborated with SMEs to analyze legacy system extracts from mainframes and COBOL files.

•Designed and transformed requirements into efficient data structures for storage, manipulation, and retrieval.

•Partnered with data modelers and ETL developers to create Data Functional Design documents and ensure models adhered to best practices, including normalization rules.

•Enforced standards for proper naming of data elements and attributes and resolved data-related issues with business and ETL teams.

•Provided 24x7 problem management support for development teams working with supported databases.

•Documented Data Quality mappings and ensured audit and security compliance.

•Performed small enhancements, including SOR element additions and data cleansing, while creating Data Mapping Repository documents for metadata services (EMR).

•Supported ETL processes for extracting, transforming, and loading data from multiple SORs into Data Marts and Data Warehouses.

•Assisted development teams in maintaining ETL workflows and resolving issues.

•Environment: MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL.

Contact this candidate