Ravi Kiran Chalichama
Sr. Data Engineer
Summary
Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills. Detail-oriented Data designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
15
15
years of professional experience
Work History
Senior Data Engineer
Luxoft Information Technology PTE. LTD
11.2022 - Current
- Communicated new or updated data requirements to global team.
- Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with state and federal data security guidelines.
- Used ETL and ELT techniques to load data from various source systems to Azure Data Lake and blob Storage services using Azure Data Factory (ADF)
- Ingested data into Azure services such as Azure Data Lake, Azure Storage, and Azure SQL, and processed it efficiently using Azure Databricks
- Created and scheduled ADF pipelines to seamlessly load data from diverse sources, performing data manipulations and transformations using Pyspark, Python Pandas, and Spark-SQL
- Developed robust business logic for data transformation in Azure Databricks.
- Worked with multiple file formats, extracting, transforming, and aggregating data to uncover valuable insights into customer usage patterns.
- Created Powerbi Reports for the Entity Controllers to automate their daily manual reports and for the insight views on the regulatory data.
Integration Specialist
AirLiquide Industrial Services
01.2021 - 11.2022
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Coordinated deployments of new software, feature updates and fixes.
- Migrating on Perm Applications from SQL,ORACLE server to Azure Cloud using Azure Data Factory and Databricks
- Data acquisition from internal/external data sources processing and loading into Azure DataLake.
- Build, Enhance, Optimized Data Pipelines in Azure Data Factory using Reusable frameworks
- Designed and Built data quality frame works for covering Data Quality aspects like Completeness, Accuracy, coverage using Pyspark
- Built Sort, Join, Aggregation, filters and other transformations on the datasets
- Created various Parser programs to extract data from data base views
- Extracting the Data using Pyspark from data sets in order to map and handle bad, null and partial data.
- Used various Transformations and Actions for cleansing the input data by using Scala and Python.
- Created various Data extraction and file handling activities using python
- Created various analyzing reports by using PowerBI.
- Used various charts (Waterfall, Tree chart ,Bar, Line chart..) in the powerBI reports for the quick analyzation and created quick measures .
- Maintained and implemented Application and Row Level Security in the PowerBI workspace and Apps.
Senior Application Analyst
AirLiquide Singapore Pvt.Ltd
09.2017 - 12.2020
- Documented clients' issues and processes of resolution.
- Collaborated with business owners, vendors and other team members to evaluate and recommend solutions to complex problems and requests.
- Provided training to clients in use of Hyperion systems and applications.
- Performed troubleshooting, maintenance and optimization of Hyperion applications.
- Data acquisition from internal/external data sources.
- Create and maintain optimal data pipeline architecture
- Importing Gideons,Oracle Data Into Azure Data Lake.
- Setting Up Inter BL Elimination and Cost Allocation Settings by Coordinating with Operation Controller and Business Analyst
- Modified cubes, subject area/ reports, apps as needed to use the new hierarchy rather than user defined hierarchy.
- Importing and processing sales, production and expense data from various systems and load into azure data lake.
- Creating Checking files and Month End Reports to the Finance Team in PowerBI.
- Performed Issue Management, Quality Management tasks.
- Administered user roles using shared services for reports.
- Created Event scripts in FDQM by using PYTHON.
- Populating the Data to Load into the consolidation System.
Senior Software Consultant
Technopals Pvt.Ltd
09.2012 - 09.2017
- Provided technical support using knowledge of complex technology to solve problems and support new projects.
- Evaluated multiple software solutions during early software architecture plotting and system migration planning stage.
- Prepared extensive workflow charts and diagrams describing input, output and logical operations and converted each into instructions coded in computer language to develop Hyperion applications.
- Design and development of OLAP model and Meta outlines for Essbase cube
- Played a crucial role during Essbase Integration
- Involved in Performance tuning and Performance monitoring.
- Interacted with the end users and understood the business requirements for Essbase cubes development based on the Report Requirements Written MaxL and Batch scripts to get user information
- Modified cubes, subject area/ reports, apps as needed to use the new hierarchy rather than user defined hierarchy.
- Modified and created new security filters in Essbase to accommodate new hierarchies.
- Performed Issue Management, Quality Management tasks.
- Administered user roles using shared services for reports.
- Involved in deploying of cubes from Development Server to production Server, restoring database by taking regular backup in case of database corrupt or server crash.
- Developed outline formulae, MDX scripts, developed MaxL and batch scripts to automate dimension build, data loading, backups and other Essbase processes.
- Assisted testing team with bug and defect resolutions in the testing environment.
- On time completion of all assigned tasks and desirable meeting the business expectations and timelines.
- Involved in Knowledge transfer and development transition to the other team members and to production team (onshore and offshore).
- Worked closely with production team for the end user support in resolves emergency issues.
- Developed FDQM applications to All the countries load the data into Essbase
- Mapping the dimension members in FDQM.
- Involved in the Hyperion Upgrade.
- Developed FDMEE for all the Countries to load the Data into Essbase.
Senior Software Engineer
RS software Asia Pvt. Ltd
04.2012 - 09.2012
- Worked with project managers, developers, quality assurance and customers to resolve technical issues.
- Trained and mentored junior developers and engineers, teaching skills in Hyperion and working to improve overall team performance.
- Checked client code for bugs and weaknesses using approved troubleshooting methods.
- Developed load rules, reports, security and overall maintenance of Essbase ASO/BSO applications.
- Involved in Performance tuning and Performance monitoring.
- Designed and developed web forms for data inputs as per the business requirements using Hyperion Planning.
- Monitoring the daily supporting activities and daily jobs
- Developed weekly, monthly forecast, budget and quarterly year to date (YTD) reports.
- Developed calc rules by using Calculation manager
- Updating the global variables in Calculation Manager
- Exporting the metadata from DRM
- loading the exported metadata into the EPMA and essbase applications
- Mapping the dimension members in FDQM.
- Loaded the data into Essbase by using FDQM
- Creating and maintaining Financial Reports by using Financial Reporting Studio
Senior Consultant
Capgemini India Pvt. Ltd.
12.2010 - 03.2012
- Analyzed problematic areas to provide recommendations and solutions.
- Determined areas for improvement and implemented processes to alleviate problems.
- Streamlined processes to cut downtime and optimize employee productivity.
- Designing Interface (inbound and Outbound) to pull Actual data from EApps and export budget data back to Apps.
- Involved in Designing, Building and optimizing the ASO/BSO outline and assigning member properties.
- Created Groups and User to provide authentication.
- Created UDA’s, filters, calculation scripts for cube.
- Created Planning applications and data forms to allow the end users to enter data as per the budgeting process.
- Created the business rules by using the Calculation manager and assigned the rules to the Web forms.
- Loading Metadata by using out line load utility and maintaining the metadata in the application
- Automated the metadata refresh
- Created financial reports and scheduled them as per the business needs.
- Testing the Production environment thoroughly prior to the applications being created and making them completely functional.
- Performing the Hyperion Admin role in taking charge of maintain servers and make the available all the time except the off hours.
- Maintaining Backups on all the Prod servers and will restore the database if needed as per the Business Request.
- Organized both client and internal meetings to found the outstanding issues to provide the resolutions on time.
- Monitoring of the production environment and proactively raising incident tickets for resolution.
- Provided estimates for estimate requests and implemented the changes in time as per the ITSM Process.
- Interact with the business users of the system to better understand the problem ticket
- Maintaining the Weekly Status report and sharing the same with the Onsite team.
- Loading the data into Essbase by using the FDQM.
- Maintaining the mappings in the FDQM.
- Prepared end to end documentation related to the project which involves preparing Business requirement documents, Functional specification docs, design documents, Test scripts, Application Run book and many more.
- Reviewing Time report and deliverables of my team members.
Associate Consultant
Oracle Solution Services (India) Private Limited
09.2008 - 08.2010
- Compiled research data and gave professional presentations highlighting finds and recommended optimizations.
- Evaluated diverse organizational systems to identify workflow, communication, and resource utilization issues.
- Involved in the designing of the Hyperion Planning and Essbase ASO /BSO applications.
- Developed load rules, reports, security and overall maintenance of cube.
- nvolved in Performance tuning and Performance monitoring.
- Designed and developed web forms for data inputs as per the business requirements using Hyperion Planning.
- Optimized the essbase application performance by tuning index cache and data cache.
- Used HAL flow diagrams for the dynamic dimension building and data loading into the Planning cube.
- Worked on the Excel Add-In templates. Designed and Developed 80 reports based on the client’s needs.
Education
Master of Science - Statistics
Acharya Nagarjuna University
India 04.2001 -
Bachelor of Science - Computer Science
Kakatiya University
India 04.2001 -
Skills
Data analysis
undefinedTimeline
Senior Data Engineer
Luxoft Information Technology PTE. LTD
11.2022 - Current
Integration Specialist
AirLiquide Industrial Services
01.2021 - 11.2022
Senior Application Analyst
AirLiquide Singapore Pvt.Ltd
09.2017 - 12.2020
Senior Software Consultant
Technopals Pvt.Ltd
09.2012 - 09.2017
Senior Software Engineer
RS software Asia Pvt. Ltd
04.2012 - 09.2012
Senior Consultant
Capgemini India Pvt. Ltd.
12.2010 - 03.2012
Associate Consultant
Oracle Solution Services (India) Private Limited
09.2008 - 08.2010
Master of Science - Statistics
Acharya Nagarjuna University
04.2001 -
Bachelor of Science - Computer Science
Kakatiya University
04.2001 -
Similar Profiles
Krish VeniKrish Veni
Java Spring Boot Microservice Developer at Luxoft Information TechnologyJava Spring Boot Microservice Developer at Luxoft Information Technology
Svitlana LomakaSvitlana Lomaka
Team Lead (Recruitment Group Manager) of Cross Relocation Team at Luxoft, a DXC Technology CompanyTeam Lead (Recruitment Group Manager) of Cross Relocation Team at Luxoft, a DXC Technology Company
Hao Yuan (Mark) ChenHao Yuan (Mark) Chen
Research Engineer at Institute for Information Industry (III) / Taiwan Association of Quantum Computation and Information Technology (TAQCIT)Research Engineer at Institute for Information Industry (III) / Taiwan Association of Quantum Computation and Information Technology (TAQCIT)