Akshatha Dharmappa

Experience

• 

  EVRY India

  Aug 2013 - Dec 2016

  APQC DW ASSESSMENTAPQC’s Knowledge Management Capability Assessment Tool (KM CAT) offers a rigorous way to measure and evaluate your organization’s knowledge Management (KM) competencies across four categories: strategy, people, process, and content and information technology.Key Challenges:• Understanding the existing business logic, Business requirements• Develop new procedures and jobs having good performance and accurate result.• Migration of Server 2005 to 2014.Responsibilities:• Complete Analysis on the Jobs used between various external servers and its documentation.• Involved in coding and designing of packages using SSIS and in Developing, Deploying, Scheduling and Monitoring of Jobs.• Working with SSRS for Report creation and modification according to Business needs.• Involved in developing Cubes and Analysis service according to Business Needs.• Involved in migration of server (Packages developed and deployed using SSIS 2005) to 2014 servers Show less Forex Administration Tool is a Windows Application which is deployed in the Forex back office. It is a tool to perform the centralized operations. It consists of modules like Administration, Client\Contact, Dealer,Report, IT, Tools and Cash Guide's.Key Challenges:1.Understanding the existing business logic, Business requirements2.Develop new procedures and jobs having good performance and accurate result.3.Migration of Server.Responsibilities:1.Complete Analysis on the Jobs used and the file movement involved between various external servers and documentation.2.Involved in coding and designing of packages using SQL Server Integration Services(SSIS)3.Involved in analyzing the requirement , suggesting the appropriate solution/alternatives and Writing Procedures fulling customers requirement4.Working with SSRS for Report creation and modification according to Business needs.5.Involved in Developing,Deploying,Scheduling and Monitoring of Jobs.6.Involved in migration of server (Packages developed and deployed using SSIS 2005) to newer servers(BIDS and SSDT) Show less TIME ADVANTAGETimeAdvantage is owned by Advantek solutions, US. Time & Attendance domain based productTimeAdvantage allows employees payable hours to be calculated based on various rules and parameters setup along with employee scheduling, accrual of absence time, payout, exceptions, point system, time tracking facility and payroll generation.Key Challenges :1.The worked hours and application of various rules is directly related to payroll generation, which isvery much sensitive data.2.Any modification/ enhancement in company level will drill down till employers’ payout .3.The data will be flowed across the application, so if there is any change in one screen will impact all over the application.Responsibilities:1.Involved in creating new procedures / bug fixation in the existing procedures in the application.2.Involved in analyzing the requirement for enhancement, suggesting the appropriatesolution/alternatives ,clarifying the queries posted by clients.3.Providing the estimation and requirement review.4.Testing the performance of the developed Queries.5.Generating License files on request of Clients.6.Involved in script generation for Release testing. Show less TIME ADVANTAGETeam size : 8TimeAdvantage is owned by Advantek solutions, US. Time & Attendance domain based product.TimeAdvantage allows employees payable hours to be calculated based on various rules and parameters setup along with employee scheduling, accrual of absence time, payout, exceptions, point system, time tracking facility and payroll generation.Key Challenges:The worked hours and application of various rules is directly related to payroll generation, which isVery much sensitive data.Any modification/ enhancement in company level will drill down till employers’ payout.The data will be flowed across the application, so if there is any change in one screen will impact all over the application.Responsibilities:Involved in creating new procedures / bug fixation in the existing procedures in the application.Involved in analyzing the requirement for enhancement, suggesting the appropriate solution/alternatives, clarifying the queries posted by clients.Providing the estimation and requirement review.Testing the performance of the developed Queries.Generating License files on request of Clients.Involved in script generation for Release testing.Involved in coding and designing of packages using SQL Server Integration Services(SSIS)Involved in Data Analytics for the Time and Attendance Domain. Show less

  • Senior Software Engineer

    May 2016 - Dec 2016

  • Software Engineer

    Jul 2015 - Apr 2016

  • Software Engineer

    Jan 2014 - Jul 2015

  • Associate Software Engineer

    Aug 2013 - Jan 2014
• 

  SchoolCity Learning India Pvt Ltd

  Dec 2016 - May 2017

  Senior Software Engineer

  Team Size - 4SchoolCity Suite is a fully integrated online system for educators that provides curriculum and instruction tools, assesses performance, reports progress and provides next steps in teaching. It also features Common Core-aligned tests, a student-friendly online testing interface, Common Core instruction resources and formative assessments.Key Challenges:Understanding the existing business logic, Business requirements and domain.Develop new procedures and jobs having good performance and accurate result.Improving the Performance of Query called in Procedures and functions.Responsibilities:Complete Analysis on the Data Modeling of US Education Domain used for Product development and its documentation.Involved in Query Optimzation for better Performance.Involved in creating new procedures for Enhancement or Development task and also bug fixation in the existing procedures in the application.Involved in coding and designing of packages using SSIS and in Developing, Deploying, Scheduling and Monitoring of Jobs. Show less

• 

  EF Education First

  May 2017 - Mar 2018

  Senior Software Engineer

  Title: ElektraTeam Size: 18Description: Elektra is a production system used by and owned by Education First company which assists the School users in creating and maintaining the life cycle of EF student (Transportation, Accommodation, Academics, Activities, Certificates) and also provides insights about the sales of years, helping the higher management in making better decision for upcoming years. It also features user friendly application for EF students like MY-EF app, Attendance app, Academic Board and Emergency Board.Key Challenges: To understand the existing business logic, business requirements and domain Develop new procedures and jobs having good performance and accurate result Develop Reports in the form of certificates and Capacity management.Responsibilities: Providing support in creating new procedures / bug fixation in the existing procedures in the application Contributing in coding and designing of packages using SSIS and in developing, deploying, scheduling & monitoring of jobs Contributing in designing, developing, deploying of reports using SSRS and their subscriptions. Conducting Performance Tuning of existing procedures Show less

• 

  TEKsystems

  May 2018 - Apr 2020

  Senior Software Engineer

  Client : Hewlett-PackardProject : ISCS (Hp online store)Team size :26Description: ISCS is HP’s e-commerce Project, which hosts their Products for American, Asia and Europe Countries. Upstream systems flow data like Product Catalog, Pricing, Taxing etc ...using batch jobs to ISCS Projects which are in-turn displayed in hp.com website according to the country region. After confirmation of placement of order by user, necessary information’s are given to downstream system.Key Challenges:o To understand the existing business logic, business requirements and domaino Develop new procedures and jobs having good performance and accurate resulto Develop Package according to business needs and efficient management of data.Responsibilities:o Providing support in creating new procedures / bug fixation in the existing procedures in the applicationo Contributing in coding and designing of packages using SSIS and in developing, deploying, scheduling & monitoring of jobso Conducting Performance Tuning of existing procedures Show less

• 

  Tesco Bengaluru

  Jun 2020 - Aug 2021

  Technical Lead

  Title: Product InductionTeam Size: 5Description: Product Induction is TESCO’s (UK’s Largest Retailers) core project, which is based on SSIS, .NET and SQL 2012. This ETL project is responsible for uploading Product, Range, Price and Promotion information to TESCO UK, ROI and Wine Grocery Online Websites. Business-critical data such as Product/Price/Promotions from various upstream like ODS, SH CR are extracted on daily basis and transformed data is then loaded to Sonetto. Sonetto is a third-party application used for enriching Products with Promotions. Business users also use this application to manage the data. Post the Sonetto processing the data is loaded into the Product database. Show less

• 

  Dublin City University

  Jun 2022 - Sept 2022

  Postgraduate Student Ambassador
• 

  EY Technology Solutions

  Jul 2022 - now

  • Manager

    Mar 2025 - now

  • Assistant Manager

    Jul 2022 - Apr 2025