Chennakesavulu Gurramkonda
Summary
A results-oriented VBA developer with a proven track record of developing robust Excel macros, significantly improving data processing speed and streamlining reporting processes for various departments.
Overview
14
14
years of professional experience
Work History
Senior Data Analyst
Societe Generale Global Solution Centre
10.2019 - Current
- Developed and maintained over 20 complex macros in Excel to automate data processing, reducing processing time by 90%.
- Collaborated with cross-functional teams to identify automation opportunities and implement macro solutions, enhancing overall operational efficiency.
- Developed and automated user-friendly dashboards and reports using Excel, VBA, and Power BI to enhance operational efficiency.
- Independent in under taking projects by taking initiative to fetch the data inputs as per the client requirement in order to develop the data, testing and deployment in production environment that ensures to accomplish the projects within timelines.
- Built user-friendly Power BI dashboards to visualize key performance indicators.
- Created and maintained advanced ETL processes for data integration from various reports.
- Maintained all the process documents and version controls up to date.
- Consistent in Providing enduring support to the end users.
- Performed testing and debugging to ensure macro reliability and accuracy.
Senior VBA Developer
Ciber Sites India Pvt Ltd (SONY Client)
07.2018 - 09.2019
- Developed the price submission template by using VBA macros, the objective of price submission template is creating the price list based on the conditions and price lines will be upload to IBP tool.
- Playing both roles as VBA Administrator and Developer.
- Implemented Error-Handling and Exceptions.
- Implemented the Log file creation by using macros.
- Reduced human error in data processing by implementing robust error handling techniques in VBA code.
- Maintained excellent communication throughout projects, providing regular updates and seeking feedback to ensure alignment with stakeholder objectives.
Senior Reporting Analyst
Concentrix Technologies
07.2012 - 02.2018
- End to end handling and deliver all the Leadership reports to the business partners.
- Perform routine data quality checks to identify data source ETL problems and report the data integrity issues to HRIS team.
- Schedule the auto generated reports to the Business from HRCRUSIE Repository.
- Conducted extensive data validation to ensure the highest level of accuracy in all reports generated.
- Collaborated with cross-functional teams to gather data requirements and optimize reporting outputs.
- Maintained strong relationships with stakeholders to better understand their needs and prepare the reports accordingly.
- Leveraged advanced Excel functions and macros to automate repetitive tasks, increasing overall productivity.
Process Associate
EXL SERVICES Pvt. Ltd, (KPMG)
03.2011 - 03.2012
- Financial reporting and report gathering.
- Analyzing the Trail Balance and Income statements.
- Analyzing the Balance sheet.
- Auditing the financial statements and preparing of lead sheets.
- Meeting SLA & TAT as per the client requirements
Education
MBA - Computer Science, IMS
S.V. University
Chittoor, India07-2010
Bachelor of Arts - B. Com (Computer Applications
S.V. University
Chittoor, India07-2008
Skills
- Data visualization techniques
- Power BI tool proficiency
- Analytical thinking
- Adaptability
- Creative problem-solving
- ETL processes
- Advanced Excel
- Data quality assurance
- Data and analytics
- Data visualization
- Effective communication
- Analytical skills
- Team leadership
Languages
English
Telugu
Kanada
Tamil
Achivements
Being Consistent top performer from the start of the career to till date, amongst in all the organizations that have been worked with and received recognitions such as Star Performer, Best Employee and Spot Awards from clients.
Timeline
Senior Data Analyst
Societe Generale Global Solution Centre
10.2019 - Current
Senior VBA Developer
Ciber Sites India Pvt Ltd (SONY Client)
07.2018 - 09.2019
Senior Reporting Analyst
Concentrix Technologies
07.2012 - 02.2018
Process Associate
EXL SERVICES Pvt. Ltd, (KPMG)
03.2011 - 03.2012
MBA - Computer Science, IMS
S.V. University
Bachelor of Arts - B. Com (Computer Applications
S.V. University
Similar Profiles
Harsh ShahHarsh Shah
Software Engineer at Societe Generale Global Solution CentreSoftware Engineer at Societe Generale Global Solution Centre
Chaithrashree ACChaithrashree AC
Specialist support engineer at Societe Generale Global Solution CentreSpecialist support engineer at Societe Generale Global Solution Centre
Smruti SwainSmruti Swain
Tribe Head at SOCIETE GENERALE GLOBAL SOLUTION CENTRE PRIVATE LIMITEDTribe Head at SOCIETE GENERALE GLOBAL SOLUTION CENTRE PRIVATE LIMITED