K

Kartayani Ravva

About

Detail

Senior Data Engineer | Power BI | AWS | DevOps | Azure | Data Warehouse | Data Modeling | Tableau
Milwaukee, Wisconsin, United States

Contact Kartayani regarding: 
work
Full-time jobs

Timeline


work
Job

Résumé


Jobs verified_user 0% verified
  • Northwestern Mutual
    SENIOR DATA ENGINEER
    Northwestern Mutual
    Jun 2020 - Dec 2023 (3 years 7 months)
    • Utilize engineering best practices to analyze, design, develop and support software solutions to create an industry leading digital experience.
    • Involved in end-to-end redesigning of DWH databases to a Lakehouse in AWS using Databricks &
    PySpark programming.
    • Created, managed and controlled access for Delta Hive metastores in Databricks.
    • Developed Power BI Datasets and reports then published as an app for end users.
    • Analyzed existing IBM BPM reports and redesigned them in Power BI for better user experience with interactive reporting.
    • Administered Power BI Premium nodes, security, gateways along with monitoring usage and costs
    • Replicated on-prem DB2 databases to AWS cloud using Data Migr
  • Vivent Health
    SR. BUSINESS INTELLIGENCE ENGINEER
    Vivent Health
    Dec 2017 - May 2020 (2 years 6 months)
    • Gathered requirements by organizing meetings with pharmacy users for creating new reports and
    report changes.
    • Coordinated with cross functional teams to explore & research about data sources or applying business rules before pulling it into Power BI reports.
    • Implemented Row level security in Power BI models to restrict data relevant to the users logged in.
    • Worked on setting up of Talend studio and Talend remote engines for dev and prod environments.
    • Created data stewardship tables on Talend for the data review and validation.
    • Implemented ETL workloads and analytical models for reports refreshed daily/ monthly using MSBI Stack
    • Redesigned Data Warehouse to make more efficient and support
  • Aurea
    BUSINESS INTELLIGENCE ENGINEER
    Aurea
    Jul 2016 - Dec 2017 (1 year 6 months)
    • Interact with new business users for requirement analysis and persuade them to opt SQL Server Suite (or) MSBI Self Service for their Application and Reporting needs.
    • Utilized scrum practices to increase the velocity and improve communication between cross functional teams.
    • Involved in developing Data Mart by creating Facts/ Dimensions and leveraged data for creating reports for billing team.
    • Developed visualizations in Power BI for various features like Invoice, Usage, readings and so on to embed the reports into CRM application.
    • Trained managers and business Analysts to make use of Power BI and MSBI Self Service for
    generating ad-hoc reports.
    • Involved in incident/ problem resolutions and requ
  • Altisource
    BI DEVELOPER
    Altisource
    Feb 2015 - Jul 2016 (1 year 6 months)
    • Involved in requirement gathering and analysis for developing ETL mappings and documented.
    • Implemented custom logging mechanism to check the progress and handle errors at every level of executables in control and data flows in SSIS.
    • Created stored procedures and functions that converts data to XML format for service endpoints.
    • Implemented complex stored procedures by optimizing them by Pivoting the tables, way of joining tables that reduce logical reads and several optimization techniques.
    • Implemented efficient ETL strategy to load Gigabytes of compressed data and files and load into Equator systems by uncompressing, integrating and distributing mechanisms with reliable error
    handling methods.
  • P
    BI ANALYST
    Pepsi-Cola Venezuela
    May 2014 - Jan 2015 (9 months)
    • Involved in the requirements elicitation and gathering by conducting meetings with the stakeholders.
    • Accommodated JAD sessions to gather the technical requirements and discuss the weekly status of the project.
    • Worked with Database Administrators, Business Analysts and Content Developers to conduct
    design reviews and validate the developed models for reporting.
    • Created the whole project documentation including the business and technical requirements.
    • Provided support to any issues created by the clients which could be a data fix or process implementation.
Education verified_user 0% verified
  • National Institute Of Technology
    Bachelor of Technology
    National Institute Of Technology