About Me

I'm a Full-Stack Product Developer, an optimistic and cheerful person who loves to solve refreshing and intriguing challenges. I'm looking for exciting and interesting opportunities in Berlin, Germany and have a valid visa to work in Germany. I was a part of Freshdesk Inc, Chennai, India before I moved to the buzzing tech hub of Europe - Berlin, Germany. I'm have been into Web Development for the past 4+ years trying out different aspects of software engineering. I've handled end to end feature requests using technologies such as Node JS, Angular JS, MySQL, Dynamo DB, Redis and Elasticsearch. I also have hands-on experience in using javascript libraries such as jQuery, version control systems such as Git and scripting languages such as Perl. I've been participating in architectural design discussions, keenly watching, learning and contributing to production level designs. I'm keen on automating things within the product to boost productivity. I love to lend a hand to crack a doozy challenge at work and wish there was one every day I get to work.

I'm always looking for a new problem to solve. So if you’ve got a humdinger of a challenge you need a hand with, feel free to contact me directly at sapnasivakumar@gmail.com.

Contact Details

Sapna Sivakumar
Lehrter Straße 3
10557, Berlin
Germany
+4915213904413
sivakumarsapna@gmail.com

Download Resume

Education

Graduation

Bachelor of Engineering in Computer Scince • April 2012

I did my Bachelor's degree in Engineering with specialization in Computer Science at Bannari Amman Institute of Technology an affiliated institution to Anna University Chennai, Tamil Nadu, India.

Certifications

Business English Certificate (BEC) Higher • The University of Cambridge

I have been qualified in Business English Certificate (BEC) Higher – Grade ‘B’ with 79% (Council of Europe level C1) from Cambridge English Language Assessment Counsil (part of the University of Cambridge).

Special Accolades

The Best Speaker of Cambridge English in Asia-2011

Was given this accolade by The British Council (Chennai, India) as a result of a national level competition conducted under the regional zone of South India by The University of Cambridge, UK.

The Achiever’s Award-2012

Was awarded “The Achiever’s Award-2012” by the college of graduation for the Achievement as The Best Speaker of Cambridge English in Asia-2011.

>

Freshdesk Inc

Livechat

JavaScript, Node.js, Angular.js, jQuery, Dynamo DB, MySql

Freshdesk’s integrated live-chat solution is designed to work with any helpdesk to face customer queries live via a chat channel. The application has features like provisions to transfer chats to another agent, convert chat transcripts to tickets, report generation, a private agent-to-agent chat channel, etc., The chat history could be viewed as an archive with all the transferred chats available for view in a single page with eager loading.

Challenges and Responsibilities
  • Implemented test coverage report for the Node js application using Istanbul
  • Optimised the use of Elasticsearch on the Archive page of the application
  • Was an integral part of handling Production level bug fixes and deployments
  • Consolidated the issues found on a revamp of the base APIs and fixed them
Other Learnings
  • Had a good learning curve with third party Data Stream Networks (such as PubNub) and in-memory data structure stores such as Redis.

Sequelize integration

I integrated Sequelize, the Node.js ORM into the architecture. In the process, I cleaned up the data layer. The setup enhanced development and made the codebase flexible to switch between multiple database back-ends.

Challenges and Responsibilities
  • Checked for compatability issues while removing the old code used for direct API calls to the database

Transfer Workflow

This workflow aimed at making the transfer of chats among agents visible on a single page using eager loading to show all connected chats. It required altering the existing database schema to suit the requirements.

Challenges and Responsibilities
  • Had a chance to dig in a little into the HTML and CSS portions of the workflow to render the transcript
  • Altered the schema of the databases to suit requirements
  • Wrote the migration scripts for the schema changes and deployed them across multiple regions in the Production environment
  • Checked and fixed the whole application for compatibility issues
  • Rendered Production level support for the feature during and after the release

athenahealth Inc

Devnet (VerifyCodeHub)

Javascript, Perl

I developed a tool to check if coding conventions were followed in the changelist of the task. The tool simplified the manual process by checking the changelist and also provides a UI to display the results and attaches them to the task in the task management system. On failure of standards, the tool provides an option to re-run the script for the latest version of the particular file which had failed.

Challenges and Learnings
  • Integrating the tool with the task management system was a challenging task
  • Working with the UI for the tool was a new experience in understanding a user's perspective

Airlock

JavaScript,Perl

The project involved the testing of the new application which was a complete refactor of an existent healthcare application of athenahealth pvt., The application was spread across most areas of the old application which was important and required acute testing.

Challenges and Responsibilites
  • Was the single point of contact from India's QA team for the visual changes going on in the application
  • The maintenance of the state of the old application was a challenging experience

Re-Skin

Javascript, Perl

This project involved the testing of the work for updating the visuals for all of the existing pages of the current application.

Challenges and Responsibilities
  • This project mainly involved many visual changes and needed extensive testing
  • Usability testing was also done across pages.

Skills

  • Node.js
  • Angular.js
  • jQuery
  • MySQL, DynamoDB

Get In Touch.

You can always reach me on my phone @ +4915213904413 , or can drop an email to sivakumarsapna@gmail.com.