Summary
Overview
Work History
Education
Skills
Projects Summary
Personal Information
Languages
Disclaimer
Timeline
Generic
Jai Kumar Lingampalli

Jai Kumar Lingampalli

Hyderabad

Summary

Well-qualified Business Intelligence Developer with demonstrated success in taking complex requirements and building efficient, successful systems. Knowledgeable about machine learning, programming and complex statistical analysis.

Talented Software Developer equipped with great coding, debugging and project management abilities. Accomplishes project goals consistently with elegant, scalable code. Works great with team members under Agile and Scrum frameworks.

Overview

6
6
years of professional experience

Work History

Lead BI Developer

Praval Infotech
Hyderabad
07.2023 - Current
  • Integrated new systems with legacy applications using APIs or web services as needed.
  • Built OLAP cubes using SSAS for advanced analytics capabilities.
  • Conceived, developed and implemented wide range of BI solutions.
  • Developed requirements for system modifications and new system installations.
  • Established clear system performance standards and wrote specifications.

BI Data Analyst

Technovert Solutions
Hyderabad
11.2020 - 06.2023
  • Conducted exploratory analysis to discover patterns, correlations, and opportunities for improvement.
  • Analyzed large datasets from multiple sources using SQL queries and Excel formulas.

BI Developer

Cognizant
12.2017 - 10.2020
  • Developed data models and ETL processes to extract, transform, and load data from various sources into the BI platform.
  • Designed and implemented dashboards using Tableau to provide interactive visualizations of business data.
  • Collaborated with stakeholders to identify key performance indicators for reporting purposes.

Education

B.E - ECE

CBIT
01.2017

Diploma - EIE

GIOE
01.2013

SSC -

IHS
01.2010

Skills

  • Requirements Gathering
  • Dashboard creation
  • Big data technologies
  • Data Warehousing
  • Python Programming

Projects Summary

  • Sql Server Integration Services (SSIS) to ODI Migration, Nov -2020 to till Date, ODI Developer and Production Support, Developing ETL Mappings to load data from different source systems such as Oracle, Microsoft SQL, Flat Files, Oracle BICC and Oracle BIP, My SQL Database., Development of ODI Packages and Scenarios as per the business requirement., Creating load plans and scheduling ODI jobs to load data from different environments., Migration of code between environments, As part of Production Support, responsible for diagnosing and resolving application issues to ensure optimal performance and usability for the various system users and providing root cause analysis with recommendations for improvements., Worked on tickets (Bugs logged by client), Monitoring ETL loads and Reporting services., Automated OAC reports testing using BI validator tool.
  • Upgrading OUA 2.4 to OUA 2.7, June-2018 to October 2020, ODI Role, Building Custom Mappings to update User defined Columns of table, Building Alter Scripts for OUA 2.4.0 to match with OUA 2.7.0, Loading data into Facts and Dimensions, Validating and debugging Data load issues between the NMS and the OUA, Data validation for all Dimensions ,Facts, Views, and other database objects, Testing of 54 MSRS Reports pointing to OUA 2.4 VS OUA 2.7
  • Windows Servers Version Upgrade for OBIEE 10g, Jan -2018 to May-2018, OBIEE Role, Performed Installation of OBIEE 10g in different Client Environments, Preparation of Installation and Configuration documents, Uploaded RPD and Catalog in different Client Environments, Functional analysis and Testing of 50+ Reports., Worked on tickets (Bugs logged by client), Monitoring OBIEE Services

Personal Information

  • Father's Name: L.MALLIKARJUN
  • Date of Birth: 12/02/94
  • Gender: Male
  • Nationality: Indian
  • Marital Status: Unmarried

Languages

English, Hindi & Telugu

Disclaimer

I hereby declare that the above-mentioned information is correct up to my knowledge.

Timeline

Lead BI Developer

Praval Infotech
07.2023 - Current

BI Data Analyst

Technovert Solutions
11.2020 - 06.2023

BI Developer

Cognizant
12.2017 - 10.2020

B.E - ECE

CBIT

Diploma - EIE

GIOE

SSC -

IHS
Jai Kumar Lingampalli