Software Engineer Resume

SUMMARY

A professional with over 3.10 years of experience in MS SQL Server 2012/2014.
Strong experience in Stored Procedure/TSQL coding, highly pro cient in the use of T - SQL for developing complex Stored Procedures. Triggers, Tables, User Defined Functions, Relational Database models and Data integrity.
Performed SQL query performance tuning by creating/modifying indexes. Setting transaction Isolation levels, Expertise inPerformance tuning, Optimization and withIndex fragmentation, Query Tuning.
Strong experience in using Joins, Set Operators, CTE and working with temp tables and table variable. Also used sub queries and views.
Have excellent Functional Knowledge of Ramco HRMS modules such as Payroll, Leave Management, Reimbursement, Performance Management and Time Management.
Familiar with ticketing tool JIRA.
Experience in upgrading different databases andmigration of dataamong multiple databases.
Experienced in working independently as well as in team-oriented environments.
A sense of urgency, commitment and focus on the right priorities to develop solutions in a timely fashion.
A keen learner with the ability to grasp concepts in a quick manner, Self-Motivated.
An effective communicator with technical, reasoning, and analytical skills.

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL

Operating Systems: Windows XP, Windows 7 and Windows 10

Defect tracking tools: JIRA

DB Query Tools: SQL Server 2012/2014.

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer

Responsibilities:

Writing SQL Code and stored procedures according to the requirement.
Responsible for creatingViewsandUser defined functions.
Responsible for developing Dynamic Queries, Query Optimization. Highly pro cient in the use of T-SQL for developing complex Stored Procedures, Cursors, Triggers and User Defined Functions.
Responsible to understand the business requirements and develop the queries to meet the requirements of the client.
Responsible for Import, reshape and model the data
Responsible for import data and build the dashboards as per the requirement
Responsible for schedule the packages according to frequency (daily, weekly)
Responsible to create Workspaces and share insights to specific business customers/partners and stakeholders.

Confidential

Programmer

Environment: Sql Server 2012

Responsibilities:

Involved in development and implementation.
Creating Procedure, Function, Triggers, Indexes, Views and other Database Objects depending upon the requirements.
Developed and deployed Dcube and ARI reports based on new requirements.
Collecting and Analysing Trace Data by using SQL profiler.
Having knowledge in Thailand and Hong Kong statutory reports and Tax calculations.
Interacted with clients to understand their requirements.
Created database maintenance plans for SQL backups, optimization, and integrity check.
Created logics in PEX interface files to POP data into system based on new requirement.
Creating new calendar for Payroll, Leave, reimbursement as year-end activities and map to these for Employees.
Provided technical support from offshore to various customers.
Performed many database and system upgrades using SQL server and deploying the new code from product team related to UAT and production Environments.
Involved in Troubleshootingperformanceissues and bugs within stored procedures using SQL server tool.