Summary
Overview
Work history
Education
Skills
Languages
Timeline
CustomerServiceRepresentative
Arun Kumar Kotha

Arun Kumar Kotha

FELTHAM,UK

Summary

Business & systems Analyst / Certified Product Owner with over 13+ years of experience supporting business solution software and analysing business operations. Aiming to utilize my strong prioritization skills and analytical ability to achieve the goals of the company. Seasoned System Analyst with experience coordinating and delivering technical projects in fast-changing environments. Assesses system operation to identify and implement functionality and performance improvements. Collaborates confidently with cross-functional teams to achieve project deliverables. Data-driven Business Analyst attentive to system needs and knowledgeable about best practices. Focused on continuous improvement and optimisation in face of changing demands on efficiency, functionality and performance. Iterates professionally and delivers on-specification systems.

Overview

16
16
years of professional experience

Work history

Business Analyst

Franklin Templeton Investments
Hyderabad, India
  • Business Development
  • Job Profile, Responsible for administering, maintaining, reporting and development of TACC systems
  • As part of systems administration, responsible for setting up the users and access privileges in the applications, user maintenance such as password resets, unlocking users in accordance with SOX procedures and responsible for conducting user access certification reviews
  • As part of systems maintenance, responsible for ensuring that the TACC systems are up to date with relevant data from upstream systems and responsible for maintenance activities of applications such as setting up new Funds, company accounts in adherence to SOX compliance
  • As part of systems development, responsible for developing new reports using Crystal, MS Access, MS Excel and SharePoint
  • Develop VBA code for use in automation and reporting
  • Develop adhoc queries using SQL and TOAD involved in TACC systems enhancements, upgrades
  • Acting as a liaison of TACC department and Technology groups directly/indirectly impacting TAC systems and/or processes including complete and thorough testing of all system changes and implementations
  • Accountable for providing management reporting for all TACC departments and also act as a liaison between technology team and business teams
  • Establishing system controls in cooperation with Franklin Templeton Technologies (FTT) and Treasury Operations in order to maximize control and efficiencies of all TAC systems - TAC Application Administration and Maintenance
  • Compiling TAC's internal operating and metrics reporting to Management on a Daily, Weekly, Monthly, and Annual basis
  • To provide System Support for TAC Systems which includes, Database Management., Importing and exporting data into TACC systems
  • Project Support & Testing:
  • Provide support to Technology teams on new projects and perform the User Acceptance Testing (UAT) help report issues while performing user acceptance testing to the application development teams
  • Work closely with counterparts in Product management to align on the vision product backlog and roadmap
  • Support on Agile software process, working in conjunction with end users/stake holders, technical delivery system by Attending daily scrum meetings
  • Acting as stakeholder of specific product backlog items, work closely with technology development teams to ensure the output to be aligned with expectations
  • Review of project and coordinating with Business Processes and Technology teams to ensure Quality & Accurate results are achieved for the new system and address on-going needs
  • Participating in Disaster Recovery Exercises to Monitor the Systems, Testing the Scenarios, Performing the planned tasks on In-Scope systems and reporting the results in EOD DR Meetings
  • System Support:
  • Working closely with the Technology and Development departments to troubleshoot technical problems issues raised by users
  • Escalate second/third level technical issues to the appropriate teams and follow up on the results
  • Providing training to the Business Teams on new software's/systems launched
  • Performing the Scheduled database backups, archiving files, reports and maintaining the inventory of the same
  • Monitoring the day-to-day performance of software's/applications and systems
  • Informing internal and external teams for any outages and provide technical support to end user during outage
  • Maintenance and Administration of Applications like FISERV Frontier, Bottomline Global Payment System (GPS), TOAR, Bottom-line CMS and TOAD for ORACLE, Simcorp Dimension (SCD)
  • Administration of Banking sites like, JPMC (Access, Morgan Direct, Chase Insight and VPR), BONY (Treasury Edge, Nexen), TD Dominion Commercial Banking, CITI, HSBC Net and Standard charted Bank for Treasury Accounting Department users
  • MS SQL Database Management:
  • Inserting new Account & Account Pool names to Account Pool table as requested by Business
  • Updating or Modifying the Account & Account Pool Names in Account Pool Table
  • Insert or uploading the data to Item table upon request by Business team
  • Deport record from the table or move the data from Item table to History table upon request
  • Extracting the data from Item table for customers based on the requested criteria
  • Analysing and correcting error fields in rejected records & re-importing the record to proper table
  • Extracting Matched records for the given date
  • MS Access & MS Excel Macros and Reporting:
  • Collect customer requirements, Analyse and Develop Reports to meet data analysis needs
  • Design and develop the reports in MS Excel & MS Access using VBA for customers
  • Train the Business teams on the new reports designed & developed
  • Design and develop the Macro Modules in Excel VBA to meet customer requirements
  • Update and modify the existing MS Excel Macros as per the customer needs
  • Maintain and administer the macros owned by TAC Systems Team
  • Debug and Fix the Code level issues in MS Excel & MS Access based reports
  • Update & modify the existing MS Excel & MS Access reports
  • Updating & modifying the existing MS Access Forms to meet customer requirements
  • Troubleshoot and resolve the issues related to reports generated using Crystal Reports platform
  • Performing Updates & Modifications in Crystal Reports to meet Business needs of the customers
  • Analyse the reports and escalate the critical areas to appropriate groups
  • Suggest the possible automation and develop the reports for Business processes.

Business systems Analyst

Franklin Templeton Investments
05.2013 - 07.2023
  • With over 13+ years of experience supporting business solution software and analysing business operations
  • Aiming to utilize my strong prioritization skills and analytical ability to achieve the goals of the company.

Business Analyst

Thomson Reuters
10.2011 - 01.2013
  • Creating of functional specifications, business requirements analysis, flowcharts and process maps
  • Liaising with technical leads and with business stakeholders across the business
  • Analysing the US Taxation requirements and specifications and building macros as per product definitions and parameters
  • Work with Production data to validate business requirements
  • Perform meaningful data analysis with existing reporting tools and basic database queries
  • Analyse and document business information requirements, PTS Tools Installer and Updates
  • Main aspect of this project is automation of PTS Tool with Installer using various scripts to run the Access Database
  • Once the application installed in user system and user opened the database followed by it checks for updates
  • If any update found user will be noticed a popup window with an update message
  • If user says click on install button, then updates will be installed in the system else user has an option to cancel the update
  • Roles & Responsibilities:
  • Module level analysis, Designing and Coding
  • Involved in Database design, code for running tool
  • Development windows form for getting updates
  • Design and Development of windows form using VB.Net and Maintaining Database updates, Source data is provided in Excel format by state from Client
  • Data manipulation and creating an import file as per requirements which are being given by client in order to prepare it for import into OPT .It maintains the Asset data which get from client, and process them for importing asset file after including building steps
  • Roles & Responsibilities:
  • Design and Development of Database tool
  • Coding in VBA
  • Data manipulation, Field mapping and validation
  • Testing
  • Documentation
  • Maintaining database
  • Project, The main aspect of this project is retrieving the user information from SharePoint and sending email to the user's outlook for those who are committed errors
  • If user already got the email, then he will not get it again for same error
  • Roles & Responsibilities:
  • Coding in VBA to send emails, Macro for Importing the data from SharePoint
  • Participated in developing and executing
  • Test with source database
  • Maintaining the database.

Programmer

CMC
11.2007 - 10.2009
  • Designing, generating reports as per requirements and Installation of applications
  • Maintain the databases, Data integration and segregation
  • ERMS (ELECTORAL ROLL MANAGEMENT SYSTEM, Election Commission of India (A.P, The main aspect of this project is maintaining the database of different constituency's polling station wise, Continuous revision of data and generation of Epic numbers and generation of rolls
  • This project contains Integration, Data entry, Report generation modules
  • Data entry module is used for modifying the existing data
  • Integration module is used for merging of data
  • Report generation module is used for generating reports and rolls.

Education

MTech -

JNTU University
2011

BTech - undefined

JNTU University
2007

Skills

  • Expert skills in
  • MS-EXCEL, MS-ACCESS, Excel-VBA, Visual Studio, VBNET, and Share point workflow, SCRUM Methodology using Agile principles
  • Strong Knowledge on GPS, Frontier, CMS, TRILLIUM and SIM CORP Dimension
  • Strong knowledge in working with MS-SQL server
  • Good knowledge in MS-POWERPOINT, MS VISIO, MS-OFFICE and OFFICE 365


Languages

English
Fluent

Timeline

Business systems Analyst

Franklin Templeton Investments
05.2013 - 07.2023

Business Analyst

Thomson Reuters
10.2011 - 01.2013

Programmer

CMC
11.2007 - 10.2009

MTech -

JNTU University

BTech - undefined

JNTU University

Business Analyst

Franklin Templeton Investments

Similar Profiles

Create profile
Arun Kumar Kotha