Pramod SV
Data Engineer
Bengaluru
Summary
- Over 4+ years’ experience in Business Intelligence using SAP Business Objects 4.2, Web Intelligence, Webi Rich Client, Central Management Console (CMC), Central Management Server (CMS), Central Configuration Management (CCM).
- Experience on Aure Data Factory, Databricks, Azure Stream Analytics, Spark.
- Extensive knowledge in SQL & python programming and trouble shooting.
- Strong Knowledge and Experience in Business Objects tools & SAP Business Objects.
- Designing Business Objects universes, BO reports both full client and Web Intelligence Reports.
- Worked on ETL methodology in banking domain for Data Extraction, transformations, loading using Data Integrator.
- Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.
- Debugging and Performance Tuning of targets, sources, mapping, and sessions.
- Experience in Type I, II SCD (Slowly changing Dimensions) Jobs.
- Excellent communication, interpersonal, training, analytical and technical skills.
- Thoroughly tested all universes, reports, and connection after upgrade.
- Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyse the data.
- Interacting with business users who submit tickets for issues or enhancements and working to resolve issues in a timely manner and proposing solutions to end users related to enhancement requests along with estimates of effort.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
1
1
Certification
3
3
Languages
Work History
Senior Data Engineer
LNT Infotech
Bengaluru
07.2022 - Current
- Extract Transform and Load data from source systems to Azure Data Storage using a combination of Azure Data Factory, T-SQL,Spark-SQL and Azure Data Lake Analytics.Data Integration to one ot more Azure Services- (Azure Data Lake, Azure Storage, Azure SQL,Azure DW) and processing the data in Azure Databricks.
- Responsible for estimating the cluster size, monitoring and troubleshooting of the spark databricks cluster.
- Hands-on experience on developing SQL scripts for automation purpose.
- Developed, implemented and maintained data analytics protocols, standards and documentation.
- Designed and developed analytical data structures.
- Used SQL, Bash/Linux shell scripting and Python to design and update databases.
SAP Business Objects Developer
Ahana Systems and Solutions
Bengaluru
03.2018 - 07.2021
- Developed, Tested, promoted, and Maintained the WEBI Reports, also had modified the existing reports based on user requirements, also solved any issues/errors encountered.
- Worked on ETL methodology for Data Extraction, transformations, loading using Data Integrator.
- Created Projects, Workflow, and Data Flows and applied business logics to pull the data from various source to Target.
- Used query, match, validate transforms and look up function for data integration purposes.
- Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis. Debugging the Problems in the Webi Reports.
- Interacting with business users who submit tickets for issues or enhancements and working to resolve issues in a timely manner and proposing solutions to end users related to enhancement requests along with estimates of effort.
- Trained all the Users of the Reports on using Info view and exporting reports to various formats.
- Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
- Created On-Demand Sub-reports and Hierarchical Grouping.
Education
Bachelor of Engineering - Computer Science
Kalpataru Institute of Technology
Tiptur 06.2013 - 08.2017
Skills
SQL, Azure SQL
Linux Shell Scripting
Python
SAP BODS,BI
Azure Data Factory
Azure Storage
Azure Databricks
Azure Portal
Certification
Azure Data Engineer Associate(DP-203)
Hobbies
Photo and video editing, badminton, Travelling, Trekking, Hangouts with friends.
Timeline
Senior Data Engineer
LNT Infotech
07.2022 - Current
Azure Data Engineer Associate(DP-203)
12-2021
SAP Business Objects Developer
Ahana Systems and Solutions
03.2018 - 07.2021
Bachelor of Engineering - Computer Science
Kalpataru Institute of Technology
06.2013 - 08.2017