Bhaskaran Jayakodi

Around 9.5 years of industrial experience.

Experience in complete Software Development Life Cycle. Proficient in programming using Microsoft technologies such as VBA and good exposure in C programming.

Experience in gathering data from various sources and transforming it into insightful reports and dashboards. Proficient in data modelling and integrating reporting components from multiple data sources.

Experience in coding and debugging in VBA environment to generate graphical reports and statistical reports in MS Word, MS Excel and MS Access which consists of quantity analysis, creating forms, queries, reports, the writing VBA code.

Senior Consultant - LTIMindtree

(2021-10)

• Gathered and analyzed data from various sources like Excel.
• Utilized advanced Excel features such as pivot tables and V-lookups increasing data accuracy and reliability in financial reporting.
• writing queries on sql scripts.

Senior VBA Developer - Capgemini

(2019-04 - 2020-04)

• Read data from the SQL Server and generate report in Excel.
• Read the data from different Excel files and consolidate with the report.

VBA Developer - JPMorgan Chase Bank

(2019-01 - 2019-03)

• Involved in designing, development, and coding in MS Excel using VBA and responsible to creating new user defined functions in MS Excel.
• Responsible for requirements gathering, understanding business requirements, interacting with clients, creating forms, queries, reports, and writing VBA code and deploying the applications to clients was a daily routine.

VBA Developer - Deliotte (Kelly Services)

(2018-04 - 2018-06)

• Built Code for Get Data and Update table buttons to make adjustments in data.
• Inserted/ deleted columns and populating data and generated pivot table.
• Built code for checking availability of existing file, opening the file, and generated pivot tables after populating the data as source.

Senior Consultant - HCL Technologies

(2016-05 - 2016-12)

• Responsible for database design and modifications and report development to support new customer required functionality.
• Coded and debugged in VBA environment to generate graphical report in MS Excel which consists of quantity analysis.

Senior Business Analyst - Blue Crimson (HP)

(2014-10 - 2015-03)

• Provided access database support and provided access database enhancements based on client requirement.
• Created ActiveX buttons in the worksheets and generated the code related to the requirement.

VBA DEVELOPER - Oracle Corporation (Highpoints Technologies)

(2010-05 - 2013-10)

Creating ActiveX buttons in the worksheets and generating the code related to the requirement. Generated code for creating drop downs items in the worksheet. Generated code for generating the Pivot Tables and get data from different Pivot tables to generate final data. Built code for generating progress bar and hiding worksheets. Generated code for building ranges for generating pivot tables.

PG Diploma - Computers - Computers - niset (2009 - 2009)

BCA - Bachelor of Computer Applications - Computer Applications (General) - Guru Ghasidas University (GGU) (2007 - 2007)

12th - English - Andhra Pradesh (2006 - 2006)

10th - English - Andhra Pradesh (2004 - 2004)