Naveen Kumar Reddy

Client - Argus (Verisk)

Contributed to both Business Intelligence (BI) and data engineering efforts, aligning with project requirements.

Data Engineering:

• Successfully migrated SQL Server code to a Redshift-compatible format, ensuring seamless data transition.
• This involved rigorous testing and validation of the converted code, followed by reconciliation and handover to the operations team.
• I am involved in the onboarding process for multiple studies, encompassing both new studies and the integration of new banks into existing studies.
• Additionally, enhanced Excel VBA scripts and Pentaho workflows to streamline reporting and data validation processes.
• Developed by using current Macros and optimized Excel VBA scripts to streamline report generation and meet specific reporting requirements.
• Developed and implemented data integration pipelines utilizing Pentaho Data Integration (PDI) to transform and extract, transform, and load (ETL) data for further analysis.
• Utilized Pentaho workflows to automate data processing, implemented validations, and conducted thorough testing to ensure accurate and reliable results.
• I have enhanced the data quality (DQ) engine in Python that utilizes lookup tables and rule configurations to dynamically generate SQL queries in the background.
• Gained experience in the entire data processing lifecycle, including data acquisition, normalization to client specifications, report generation using VBA in Excel based on client requirements.
  
  Business Intelligence (BI)
• Successfully transitioned several Excel reports generated using VBA macros using AWS Business Intelligence (BI) tool Quick Sight, to enhance data visualization and accessibility.
• Developed reusable Business Intelligence (BI) dashboards designed to function across diverse regions with minimal configuration, requiring only adjustments to connection parameters.

Worked with two clients TD Bank & Virgin Media (UK) as a BI Developer

Data Analysis & Requirements Gathering:

• Analyzed source data and understood business requirements.
• Identified and documented system requirements.
  Involved in requirement analysis and documented specifications.
• Understood user's analysis requirements.

Power BI Expertise:

• Collaborated with cross-functional teams to design innovative software solutions.
• Developed reusable BI dashboards in Power BI Desktop.
  Created dashboards and reports (Daily, Weekly, Monthly, etc.).
• Built custom calculations (DAX) for measures and columns.
• Leveraged filters (page, report, visual) for targeted visualizations.
• Configured gateways and scheduled report refreshes.
  Published reports and dashboards to Power BI Service/Web.
• Imported data from SQL Server using Power BI Desktop.

Data Visualization:

• Streamlined development workflows to increase team efficiency and reduce time spent on repetitive tasks.
• Proactively identified areas for process improvement, implementing changes that led to significant time savings for the team.
• Created various visualizations (bar, line, pie, geographical, tree maps).
• Implemented visual level, page level, report level filters and pinning.

Report Building:

• Built reports using Report Builder in Report Manager.
• Developed different report formats (Table, Matrix, Charts, List, Sub Reports).
• Rendered reports in PDF, Word, and Excel formats (as per client needs).

Additional Skills:

• Used Quick Measure functionality for filters, time intelligence, and totals.
• Involved in error handling, deployment, and scheduling of packages.
• Performed grouping, sorting, and formatting for basic reports.