Kamakodi Subramanian

Experience

• 

  Tata Consultancy Services

  Aug 2011 - Jul 2016

  ● Gathered requirements, by meeting, email, or phone with the clients, to improve business processes, and develop new ones. Converting them to quality user stories ● Created & reported KPIs to senior stakeholders that helped to monitor the uptime of middleware applications and the handling of tickets categorically● Implemented changes to existing reports using SQL tool for customers that ensured meeting their key requirements● Migrated production data from Oracle DB to MS SQL DB, due to changes in tech eco system that benefitted organization in terms of costs saving.● Automated weekend working report that heped the team in tracking messages/status re development of products Show less ● Designed and implemented an automation script that helped to reduce the application monitoring time from 90 minutes to 15 minutes.● Supported customers via chat, email, and phone, and helped them to resolve the issues faced by them● Ensured that the SQL reports run on time every day, so the clients can download the latest reports on time everyday for their business needs● Maintained the production and QA environments with similar configurations, by deploying, undeploying, or configuring the applications. Show less

  • IT Analyst (Team Lead)

    Aug 2014 - Jul 2016

  • Production Support Executive

    Aug 2011 - Jul 2014
• 

  Freelancer

  Mar 2018 - Jan 2019

  Software Developer

  ● Design, develop, and test various front-end layouts to make sure the website looks aesthetic, intuitive, and delivers best in class user experience● Implement a variety of essential business rules to the platform such as login, registration, and forgot password functions● Deliver incremental features to the website, as per the client requirements

• 

  Club Travel – HRG Ireland

  Feb 2019 - Dec 2019

  Graduate Business and Support Analyst

  ● Gather requirements from leads through email, phone, or meetings. Finally, log them for development after the necessary approval process.● Root cause analysis and resolution of various issues faced by the users in a suite of Club Travel web applications● Taking ownership of all the issues faced by the users in Club Travel’s invoicing system● Manage internal user access rights for a suite of Club Travel applications

• 

  Artech L.L.C.

  Apr 2020 - Aug 2020

  Senior Technical Lead (Power BI)

  ● Design KPI’s and PI’s after collecting requirements from various stakeholders, for security reporting using Power BI and R programming● Develop Power BI dashboards based on planned KPI’s and PI’s● Whet and deploy those dashboards after multiple feedback sessions

• 

  Ramco Systems

  Nov 2020 - Dec 2022

  Systems Analyst (BI Developer)

  ● Design, develop and publish Power BI dashboards based on the business requirements and support them.● Maintain Power BI access roles, provide and revoke dashboard access according to the business needs● Develop new SQL based applications based on business needs, test and deploy them.● Write medium to high complex SQL queries, to collect ad hoc data for the business needs.

• 

  Perficient

  Aug 2023 - now

  Senior Technical Consultant (MSBI & Power BI)