AAJA SEBASTIAN

Ankamaly, Kerala, India (C) +91-828******* (C) +91-907*******

(skype) aaja.sebastian (e) ac9xah@r.postjobfree.com Professional Summary

Dedicated IT Professional with experience of 4.5 years in T-SQL, SSIS, C#, Database development and maintenance.

Expertise in Database Migration using SQL and SSIS

Sound knowledge in HealthCare Domain

Ownership foe ensuring client data store and management is per HIPAA Compliance Regulation.

Experience in all aspects of the software development life cycle, including requirement

analysis, design, development and production support.

In-depth knowledge of Transact-SQL (DDL, DML) and well versed in implementing ETL Packages using SSIS 2012.

Extensive experience in SQL Programming with Stored Procedures, Functions, Triggers, Query

Optimization, SSIS & SQL Jobs

Understanding of ASP.NET, MVC 5 architecture, .Net Frameworks(4.5.2,4.5, & 4.0), SQL Server 2012 and object-oriented development.

UI design knowledge using Bootstrap 3.0 framework.

Knowledge in basics of Power BI and SAP Crystal Reports

Strong capability of handling responsibilities independently as well as with proactive team.

Strong problem solving skills with the ability to multitask effectively in challenging environments.

Highly adaptable in quickly changing technical environments with very strong organisational and analytical skills

Responsible for mentoring junior Team members and dealing directly with clients. Technical Expertise

Programming Languages : C#,T-SQL

Frameworks : .Net Framework 4.5.2,4.5 & 4.0, MVC5

Technologies : HTML 5, AJAX

IDE/BI Tools : MS Visual Studio 2012/2010,CrystalReport,Power-BI

Source Control : Team Foundation Server (TFS), VSS

Data Warehousing : MS-SQL Server 2012 Integration Services(SSIS)

Database : MS-SQL Server 2012,2008,Oracle 9i, MS Access Core Competencies

SDLC

ETL

.Net Winforms, ASP.Net, MVC 5

Bootstrap 3.0, HTML, JQuery,

AJAX MS SQL Server 2012

Web application development & deployment

Flexible in new technical environments

Zeal to Keep Learning

Quick Learner

Good Time Management Skills

Logical and Structured Thinking

Attention to Detail

Work History

Software Engineer

Finastra – Trivandrum,India 03/2018 to Present

Highlights:

Performance tuning in SQL server DB objects

Creating and maintaining SAP Crystal Reports

Data Analysis and problem solving

Project: Servicing Director (Banking Domain)

Description:

It is a self-Assessment system in banking sector is an empowering method by which management and staff of all levels collectively identify and evaluate risks and associated controls. It is a technique that adds value by increasing an operating units involvement in designing and maintaining control and risk systems as well as identifying risk exposures and determining corrective action Role:

MS SQL developer

Responsibilities:

Optimization of DB Objects(Stored procedure, Views, Functions)

Developing and modifying table structures as the part of performance optimization

Managing and maintain DB for two concurrent application

services Development of DB objects and Crystal reports for reporting

QA support

Environments:

Language: T-SQL

Database: SQL Server 2008,2012

Platform: SAP Crystal Reports

Software Engineer

Carestack – Trivandrum, India 05/2016 to 03/2018

Highlights:

server Automated data extraction & transformation of complete build process using C# and SQL

Developed a powerful tool using C#, Jquery, Ajax & HTML5 to download client data and to log issues encountered during data transformation so that the assignee can answer the queries

Project: Database Migration(QSI Dental Web to Carestack System and Softdent to CareStack Dental)

- Health care Domain

Description:

Carestack IQ has the necessary tools for extracting practice, clinical and financial data from all existing dental practice management systems. This projects includes the migration of their existing customers and their treatment information, insurance and claim settlement details from their existing old system to newly build system. Role:

ETL Developer

Responsibilities:

End to end development of SSIS packages

Data extraction, transformation & implementation

DB development for transforming client data

Warranty Support

development Managing a team of 4 people for

Development of stored procedures and SSIS Packages for migration

QA support

Environments:

Language: T-SQL, C#

Database: SQL Server 2008,2012

Platform: SSIS

Associate Software Engineer 10/2014 to 04/2016

Accenture Services Pvt. Ltd – Bangalore, India

Project: ITV : E-Form (Web application development) - CMT domain Description:

A London based TV channel competing with BBC, an ongoing project. The applications are used to schedule the programs and Ads. in a desired time slot according to the current rating of the program. A kind of registration application, used to create forms and store data related to Finance/HR and create reports. This page enables the user to add/update/view the details. User is allowed to input all the information needed to add/update data. Role:

.Net developer

Responsibilities:

requirement Developing .NET web application using C# as per the client

Unit testing

hours Health check of applications & monitoring daily jobs prior to business

Application Maintenance & Support

Provided support for .NET,VB6 & VBA applications in ITV Environments:

Language: C#

Framework: .NET Framework 4.5

Technologies: HTML 5, AJAX, JQuery

Database: SQL Server, Oracle

Project: NAGE - FS Domain

Description:

A set of applications for bank employees to handle financial services, transaction histories etc. Role:

VB developer

Responsibilities:

Development & enhancement of MS Access, Excel & VB applications

Development & support works related to Third-Party data mining tool Monarch

Application Maintenance & Support

Environments:

Language: VB6, VBA

Database: MS Access

Education

B.Tech : Electronics & Communication Engineering 2014 Vimal Jyothi Engineering College - Chemperi

Passed 4 year degree course with First class – 65% Higher Secondary : Secondary School 2010

ST.Thomas Higher Secondary School - Malayattoor

Passed HSE with distincition - 85%

SSLC : High School 2008

St.Thomas Higher Secondary School - Malayattoor

SSLC with grade A+ for all subjects

Rashtrapati Awarded Guide

Accomplishments

Greenfield Training Winner, Accenture Services Pvt. Ltd. Personal Dossier

Nationality : Indian

Date of Birth : 16/11/1992

Marital Status : Single

Gender : Female

Passport No. : M2808329

Date of Expiry : 16/10/2024

Languages Known : English, Malayalam

Permanent Address : Pynadathu(H)

Malayattoor P.O

Ernakulam(Dist), Kerala, India - 683587

Willing to Relocate: Yes

References will provide on request.

Contact this candidate