Sujay Kaushik Ravi
Data Engineer
Raleigh,NC
Summary
7 Years of extensive experience in data and business analysis, including requirement gathering, data manipulation, merging, cleansing, and preparation/transformation/load. Proficient in designing and developing various worksheets, data visualization dashboards, and reports using Power BI, Tableau and Advanced Excel. Results-driven Azure Data Engineer with experience designing, implementing, and optimizing end-to-end data solutions on the Microsoft Azure cloud platform. Proven expertise in developing robust data pipelines, implementing ETL processes, and optimizing data storage and retrieval for enhanced business intelligence. Adept at collaborating with cross-functional teams, with a track record of successfully architecting and deploying scalable data solutions using Azure Data Factory, Azure SQL Data Warehouse, Azure Databricks, and other key Azure data services. Experienced in identifying Key Performance Indicators (KPIs) with clear objectives and using Power BI Gateways to keep dashboards and reports up to date. Proficient in using Jira for backlog management, sprint planning, and issue tracking, enabling efficient Scrum project management. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
7
7
years of professional experience
6
6
years of post-secondary education
Work History
Analytics Engineer
Indrasol
07.2023 - Current
- Develop and maintain suite of reports and dashboards using Power BI, providing valuable insights into sales trends and customer behavior
- Configured Azure SQL Server, establishing metadata/schema tables for the storage of date field format information. Enabled dynamic data validation and transformation by leveraging the stored metadata.
- Develop and maintain ETL processes using Azure Data Factory, ensuring timely and accurate data extraction, transformation, and loading
- Assist in creation of centralized data repository, streamlining data access and improving data governance
- Apply Scrum framework to oversee software development projects, facilitate iterative development and continuous improvement through coordination of sprint planning, daily stand-ups, sprint reviews, and retrospectives
- Enhance SQL query performance, reducing report generation time by 33% through query optimization techniques
- Collaborate with internal and external stakeholders to optimize data sourcing pipelines and verify data quality.
- Improved data visualization capabilities by designing easy-to-understand charts and graphs that facilitated better decision making.
BI Developer
US Bank
08.2022 - 05.2023
- Defined and prioritized work needed to be done to facilitate modernization process, with the Adoption and Enablement team
- Provided metrics for modernization accomplishments and blockers by exporting data from on-premises Presto ODBC to Power BI cloud
- Performed extensive data manipulation on Teradata and Presto Systems, writing queries in SQL, Report Builder and TOAD
- Designed and implemented user-friendly dashboards, leading to a 40% increase in dashboard adoption.
- Utilized Azure Databricks for advanced analytics and machine learning applications, enhancing predictive modeling and data-driven decision support
- Responsible for mapping data from both internal and external sources for ingestion into Client's data lake, maintaining data lineage and ensuring that data management standards were met
- Responsible for completing tasks within JIRA, following Agile methodology and maintaining project SCRUM rigor
- Provided timely responses to ad hoc requests for information from management staff, allowing for informed decision-making based on accurate data insights
BI Analyst
West Virginia Department of Health and Human Resources
04.2021 - 08.2022
- Responsible for exporting SQL data from statewide data systems used to monitor the COVID-19 pandemic in West Virginia, allowing the governor's office to make effective decisions about lockdown policies
- Liaised with epidemiologists, academic professionals and the CDC to ensure data accuracy in numbers of active cases, breakthrough cases, vaccinations, and other essential statewide numbers.
- Applied Power BI tool to generate reports and trends in disease occurrence and disease risk in vulnerable communities for government public health officials
- Conducted training sessions, resulting in 25% increase in user proficiency with BI tools.
- Established a dashboard that highlights overdose fatality rates, emergency room visits, Naloxone administration and pharmacy information with the Office of Drug Control Policy
- Collaborated with privacy and security teams to ensure compliance with HIPAA regulations and safeguard patient confidentiality and data privacy
- Designed and implemented scalable and cost-effective analytics solutions in Azure, optimizing resource utilization and performance
- Dedicated to staying updated on Scrum best practices and encouraged team members to participate in training and workshops, resulting in a team-wide improvement of Scrum knowledge and skills
- Kept abreast of latest Azure analytics tools, technologies, and best practices to continuously enhance analytics capabilities and stay ahead of industry trends.
Quality Assurance Analyst
Waymo
09.2020 - 02.2021
- Performed complex statistical analysis and data modeling to analyze self-driving car collision scenarios to identify false positives and safety issues
- Maintained an efficiency score of above 85% by performing quality assurance and software testing on software, identifying and reporting bugs in mapping, behavior planning and prediction and radar features
- Contributed as Operations Associate within the team, actively participating in coding, testing, and other SDLC tasks to ensure delivery of high-quality software
- Carried out Descriptive Analysis on Google's SDC collision reports on Tableau
- Performed compatibility testing on Waymo's autonomous driving systems across different platforms and configurations to ensure consistent performance and user experience
- Conducted performance and reliability testing to validate system's capability under various scenarios, such as adverse weather conditions, complex road conditions, and high-traffic situations
- Triaged driving events on company's internal software such as X-View, CarCraft, Buganizer and recorded production metrics by comparing previous data analyses with verified results to improve future simulations.
BI Engineer Trainee
VMStack IT
05.2019 - 05.2020
- Responsible for executing full data life cycle of analysis and design
- Worked on all types of data transformations that are available in Tableau
- Created dashboards using Tableau which includes drillings, sorts etc
- Set up Azure SQL Server and created metadata/schema tables to store information about date field formats, allowing for dynamic data validation and transformation based on stored metadata.
- Ensured repository of information is complete, unique, aligned, and traceable with best-in-class data source and unique calculation criteria, ran and validated current scripts provided by data warehouse team and managed JIRA issues updated in advance of daily scrum
- Responsible for supporting Legacy data marts and tasks to decommission them as functionality was moved to Big Data environment
- Created multiple Tableau dashboards and data visualization reports for users to give them location wise availability of resources
- Worked closely with Data Warehouse and Business Intelligence teams to test data load processes and participated in project tasks assigned to team, ensuring deadlines were met and risks were escalated appropriately
- Facilitated Proof of Concept (POC) in evaluating new technologies and tools such as Hadoop, DM Express
- Created metadata upload documents for new elements such as column names, tables, views, code values, new applications, and source systems.
Procurement BI Analyst
CormSquare
02.2018 - 07.2018
- Performed ETL and data cleaning techniques on e-procurement data extracted from corporate database, via SQL server to carry out data analysis transformations and load the data in a standard format
- Worked on Tableau software to Interpret and evaluate data and report them through informative visualizations and summarize information and trends in the form of dashboards and stories
- Created custom SQL Scripts for automating the update of Client information and reports for staff, which saved about 4 hours per week
- Increased customer satisfaction by 65% as a result of using Scrum SDLC techniques to consistently deliver software with better functionality, performance, and alignment with customer needs
- Communicated insights inferred, to team lead and directors and published the same to company website
- Identified procedural areas of improvement through client data to help improve sales profitability of the procurement portal
- Developed and maintained E-procurement KPIs and metrics, such as cost savings, vendor performance scorecards, and contract compliance, to measure and record performance
- Conducted training and knowledge transfer sessions for end-users, ensuring effective use of E-Procurement systems and data analytics tools.
Technical Analyst
CrownCloud
08.2016 - 02.2018
- Conducted detailed analyses, generated insights and visualizations, and published reports using advanced Microsoft Excel to create PivotTables
- Defined KPIs for new data migration projects, handled data reporting and virtual machine (virtualization) related tasks such as maintenance, and quality management
- Performed customer-oriented technical documentation and site development; Evaluated and handled server tickets and platform support
- Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets business requirements
- Responded to support tickets, emails, and live chats in a timely manner, ensuring high levels of customer satisfaction and adherence to service level agreements (SLAs)
- Provided exceptional customer service, effectively communicating technical concepts to non-technical users, and ensuring a positive support experience.
Education
Master of Science - Information Technology
Lawrence Technological University
Southfield, MI 08.2018 - 05.2020
Bachelor of Science - Information Science
Bangalore Institute of Technology
Bangalore, India 08.2013 - 05.2017
Skills
Python
undefinedTimeline
Analytics Engineer
Indrasol
07.2023 - Current
BI Developer
US Bank
08.2022 - 05.2023
BI Analyst
West Virginia Department of Health and Human Resources
04.2021 - 08.2022
Quality Assurance Analyst
Waymo
09.2020 - 02.2021
BI Engineer Trainee
VMStack IT
05.2019 - 05.2020
Master of Science - Information Technology
Lawrence Technological University
08.2018 - 05.2020
Procurement BI Analyst
CormSquare
02.2018 - 07.2018
Technical Analyst
CrownCloud
08.2016 - 02.2018
Bachelor of Science - Information Science
Bangalore Institute of Technology
08.2013 - 05.2017
Similar Profiles
Melissa VarnesMelissa Varnes
Pediatric Nurse Practitioner at UNC Pediatrics at WakefieldPediatric Nurse Practitioner at UNC Pediatrics at Wakefield
Latoya TaylorLatoya Taylor
Health Insurance Financial Advisor at Sutherland / Horizon BCBSHealth Insurance Financial Advisor at Sutherland / Horizon BCBS
Darius FisherDarius Fisher
BUSINESS DEVELOPMENT REPRESENTATIVE at Total Assure – IBSS CorpBUSINESS DEVELOPMENT REPRESENTATIVE at Total Assure – IBSS Corp
Tara GuevaraTara Guevara
Certified Nursing Assistant at Promed Staffing ResourcesCertified Nursing Assistant at Promed Staffing Resources
Irina TanciucIrina Tanciuc
Analytics Engineer at Mantel GroupAnalytics Engineer at Mantel Group