Nanda Kishore Ketha Email & Phone Number

India

Plano, Texas, United States

Irving, Texas, United States

• Collected and complied large datasets related to the sustainability metrics, including energy consumption, emissions etc. • Responsible for Cleansing, validating, transforming, and analyzing the raw and complex data from different source systems (Verizon Real Estate, Site listings, Electricity Billings etc.,). • Conducted thorough data cleansing, ensuring data integrity and accuracy for analysis and data loads.• Build up the database and reporting infrastructure from the ground up using SQL (MS Access) to provide insights into the Sustainability data.• Developed and implemented data transformation process, applying the statistical techniques to standardize and normalize data.• Understanding of the GHG protocol (Scope1, 2 and 3), emission factors.• Implement the ETL Transformations on the profiled data to deal with the inconsistencies in data like blank/Null and form relationships as per business needs. • Create stored procedures, SQL scripts code for the database transformations using Database tool (MS Access) • Collaborated with Project Manager in developing the insights for the Sustainable Asset Estimates in the United States and also Internationally which determined the Carbon footprint of the Company.• Generated Sustainability Data Reports for the Auditors and management stating trends, patterns, and predictions using Business Intelligence tool (So-Fi).• Experience acting as the Data warehouse owner in the team, maintaining various database management systems.• Responsible for the Monthly Data uploads into a custom Business Integration Web Application, So-Fi. • Collaborated with cross-functional teams to automate the monthly data upload processes to improve system efficiencies using Python scripts, leading to a reduction in 40% of the man-hours for the process.

Plano, Texas, United States

• Collaborated closely with Business Users to create the business requirements document (BRD) and translate requirements to the development teams during the SDLC lifecycle.• Gathered the raw auto and mortgage loan data and was responsible for cleaning the data and making sense of the data.• Responsible for profiling the data using Informatica Analyst - descriptive statistics, data types, how well the loan data is structured, inconsistencies in data like blank, NULL, and relationships.• Implemented ETL operations from different databases(auto/ mortgage) to a data warehouse to perform some data aggregation for business intelligence using Python scripts.• Created Data models for the Master data created merging the auto loan and mortgage loan data from different sources.• Analyzed the loan data using the Business intelligence tools, for better understanding in the data modeling and data profiling.• Responsible for the database changes using SQL Server which includes creation tables, views, stored procedures, user-defined functions, jobs, triggers, etc.• Performed ad hoc analysis and created reports to illustrate performance, answer business questions, and provide recommendations.• Experience in Tableau in import, shaping, and transforming data for business intelligence, visualizing data, authoring reports, schedule automated refresh of reports, and creating and sharing dashboards based on reports on Tableau desktop.• Experience with Jira Software to plan and organize tasks, workflows, and reports for the Agile Team members.• Responsible for participating and assisting Scrum Master with effective scrum ceremonies including daily scrum, backlog grooming, sprint planning, reviews, and retrospectives.

Hyderabad, India

• Understand the key business requirements of the client and performed Data Analysis and abstracted the transactional nature of data.• Collaborated with cross-functional feature teams, which include Architecture, Development, Quality Assurance, Product Management, Project Management, and Hosting Infrastructure & Operations team members.• Designed data models using PL/SQL in our high-volume database environment.• Improved existing ETL data warehouse processes.• Analyzed and resolved complex technical issues for Tier 3 Production Support of Oracle databases and PL/SQL in support of ETL batch processes.• Collaborated with scrum team, in agile methodology with sprint cycles, daily stand-ups, and story implementation.• Understanding of diverse software engineering methodologies, such as Agile, waterfall, and iterative• Considers success from the team perspective by committing and holding yourself and others accountable.• Designed Reports using Tableau for the presentation of the progress of the work.• Trained in Python programming, Java Programming, and SQL and cleared the examinations with top percentage.