Vennam Pavani

 SUMMARY Experienced SAP BO and SSIS Developer with a strong background in data integration, business intelligence, and reporting solutions. Proficient in developing, deploying, and maintaining SAP BusinessObjects reports and data visualizations to support business decision-making. Extensive experience with SSIS for ETL processes, data transformation, and integration between SQL Server databases and external systems. TECHNICAL PROFICIENCIES Primary: SAP BO, SAP BI, SQL, ETL Secondary: SSIS, SSRS PROFESSIONAL EXPERIENCE Accenture, Bangalore Application Development Analyst (April 2021-Present) Project: DUKE | Support, Enhancement Providing Support to Client for Business Object 4.2 System. Working as SAP Administrator. Managing users Finance WEBI Report. Managing universes developed on UDT and IDT Tool. Handling CMC Tool and Managing Users Accesses, Servers Patching Activities, Migration of Reports/Universes/Connection etc. Handling complete BO Servers on CCM. Utilize SAP BusinessObjects Monitoring and logging tools to identify issues and provide solutions effectively. Work with SAP BO logs (e.g., error logs, audit logs) to troubleshoot and resolve system issues. SAP BO AND SAP WEBI REPORT Developed and maintained universes based on UDT tool. Developed several WEBI reports by using Bex queries and universes. Tested and reset multiple Reports and got migrated to other systems. provided Access to multiple users to access WEBI report through CMC Tool. Handling complete Business Objects 4.2 System Servers. Project: Truist| Development, Enhancement Designed, developed, and deployed ETL (Extract, Transform, Load) processes using SSIS to integrate and transform large volumes of financial data from various sources into data warehouse for reporting and analytics. Developed complex SSIS packages for data migration, data validation, and reconciliation to ensure seamless integration across Truist’s banking systems, ensuring accuracy and timeliness of financial data. Utilized SQL Server to create stored procedures, functions, and triggers, optimizing data processing workflows and enhancing performance for large-scale ETL processes. Automated and scheduled SSIS package execution using SQL Server Agent, improving data pipeline efficiency and reducing manual intervention in daily data workflows. Implemented data quality checks and monitoring mechanisms to ensure that data loaded into Truist’s data warehouse was complete, accurate, and up to date, adhering to internal compliance standards. Led performance tuning and optimization of SSIS packages, improving execution times for large data volumes and enhancing overall system efficiency. Participated in regular code reviews, contributing to maintaining high-quality ETL processes and promoting best practices within the team. Performed complex data transformation, cleansing, validation and enrichment to ensure high data quality and consistency. Experienced in using ServiceNow for raising incidents, change requests and managing releases across multiple projects. ACCENTURE TRAININGS SSIS SQL EDUCATION Kuppam Engineering College, Kuppam B.Tech in Mechanical Engineering -) Government Polytechnic College, Anantapur Diploma in Mechanical Technology -) KEY STRENGTHS Strong analytical and problem-solving skills. Excellent communication and stakeholder management. Proven ability to optimize and streamline ETL and BI processes. Experience working in fast-paced and deadline-driven environments. ADDITIONAL INFORMATION Open to new challenges. Available for immediate discussions.