Jai Kumar Lingampalli

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.

• 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

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

English, Hindi & Telugu

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