Sql Server Software Development

Jayanthi Kannusamy Phone No : +1-785-***-****

Software Development Senior Specialist Email ID : ad5nbi@r.postjobfree.com

Professional Summary

Overall 12+ Years of experience in ETL-Data Integration, Informatica, PLSQL, SSIS, Web, Windows Application design and development using ASP.Net-C#, Web API, JSON, HTML5, CSS3, and SSRS reports.

Having 6+ Years of Development experience in ETL Design and Development

Having experience in Oracle PLSQL, SQL Server and .Net Tool.

Have strong experience in Insurance, Banking, Manufacturing and Logistics domains.

Have Strong working experience in Oracle-PL/SQL, Expertise in PLSQL Programming and optimization - DB Design, Procedures, Views, Functions, Packages, Triggers and Cursors Query performance tuning activities-Index creation, Normalization, Explain plan review.

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent and schedule DTS/SSIS package through Autosys (UC4) and SQL server Agent.

Good understanding of AWS Glue, Python, Postgre SQL, ADF.

Expertise in Database Creation, Managing Files.

Experience in configuring linked servers and handling distributed queries across multiple data sources.

Comprehensive knowledge on the high availability option multi node clustering (active-active/active-passive).

Running SQL profiler for slow running store procedures and looking into the execution plans.

Experienced in SQL Server Performance bottleneck troubleshooting, T-SQL and Indexing.

Worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s) for diagnosing performance issues across batch & online processes.

24/7 Production support for SQL Server databases and SQL Replications.

Have experience in Deployment activities – Code Review, Build, Deployment and Unit Testing.

Assist the design with inputs from the requirement and collate suggestions from development team to the requirement.

Strong troubleshooting and problem-solving skills.

Experienced in System Testing, Functionality Testing, and Regression Testing.

Have experience in Work estimation and Work assignment.

Design and development of Web application, web service and Windows Service using ASP.NET, C# and VB.Net

Experienced in building reports and dashboard using SSRS Reports.

Experienced in System Testing, Functionality Testing and Unit Testing.

Experience with code quality review and define standards to deliver high quality, optimized and efficient code in a timely manner.

Experience in working Incident management, Service requests and problem.

management process and delivery for production issues.

Application Experience

ETL Tools– SSIS, Informatica, DPU.

Database – Oracle PL SQL, SQL Server, Postgre SQL.

Script/Languages– VB.Net, Python, C# .

Analytical Tools -Power BI.

Web Development- ASP.NET, C#, .NET CORE, Web API, JavaScript, HTML5, CSS3, JavaScript, JSON.

Web/DB Development Tools–Visual Studio Code, Microsoft Visual Studio-2015,2017 and 2019, SQL Developer, TOAD, Microsoft SQL Server

Documentation – MS Excel, MSWord, Power Point.

AWS – S3 and AWS Glue.

Other Tools – JIRA, Confluence, Remedy, Postman, UC4 Atomics, BMC Remedy

Versioning – TFS, Github, SVN

Highlights

Design and development of ETL process, implement data quality control check and validation reports for Insurance and Annuity Financial Data.

ETL Data load using SSIS, Python Scripts, data frame.

Data Integration with Zinnia FAST and Correspondence using .Net application through batch process.

Automate the year end process. Involved in data base archive.

Optimize ETL Cycle Jobs and fix the recurring data issue with permanent fix.

Set up correspondence triggers through UC4.

Developed BOT, VADA application using C# for FAST application.

Developed SSRS reports as per business request.

Provide Technical feasibility and impact analysis with product owners and business users for necessary requirements review.

High involvement in suggestions and discussions with BA for necessary requirements.

Identify problems, develop ideas, and propose solutions.

Have experience in Team lead activities- Work Assignment, Team guidance and Training.

Experience Summary

As a Software Development Senior Specialist in NTT Data Americas Topeka from Sep-2022 to Till Date.

As a Software Development Senior Specialist in NTT Data Chennai from May-2015 to Sep-2022.

As an Assistant Manager in National Trust Housing Finance LTD Chennai from Jun-2011 to May-2015.

As a Programmer in Stahl India Private Ltd Chennai from January 2007 to July 2008.

Project Summary

Facility : NTT DATA –Zinnia (Formerly known as SE2) Topeka US.

Duration :Sep 2022-Till Now

Position/Title : Software Development Senior Specialist

Skills : PL/SQL, SQL Server, ETL, SSIS, C#, VB.NET

Description:

Data services is a staging system to receive the data from various upstream with different format of data &pass the data into multiple downstream system. Data are get extracted from various source system like FAST, LC, CORE using oracle package and moved to Data services central point using SSIS packages and C# console application. Through UC4 and FTP, the data moved to Tango / Correspondence / Print center with different formats like xml, JSON, text files.

Primary Responsibilities:

Interact with client and gather requirements for Data modeling, ETL- Design and development.

Analyses and evaluate user requirements and develop ETL Process nightly batch jobs.

Work with UC4 Team to design job flow and schedule and execute ETL Code using UC4

Atomic system.

Performance tuning and code optimization to improve runtime of ETL Process

Data Validation Check Code development using PLSQL to validate data between source and

Data service database.

Co-ordinate with multiple teams and involved in project estimation.

New product implementation, Product on boarding, Client meetings.

Develop console applications for data load.

Create Oracle packages, data base changes.

Involved in Database creation, based on functional create/enhance automation using stored procedures, triggers, function, views as required.

Performance tuning and code optimization to improve runtime of ETL Process.

Involved in Code Review, Build, Deployment, Unit Testing and FTEV

Perform root cause analysis for any failures.

Manage, Development and production support activities with extensive availability.

Co-ordinate with offshore team members and resolve their technical challenges to obtain seamless business continuity.

Facility : NTT DATA –Zinnia (Formerly known as SE2) India.

Duration :May-2015-Sep-2022

Position/Title :Software Development Senior Specialist

Skills :PL/SQL, SQL Server, ETL, Informatic PowerCenter, SSIS, SSRS, C#, VB.NET, AWS Glue,

Python scripts, S3.

Description:

FAST is a policy administration system. It covers the whole life cycle of Annuity products for various insurance companies. FAST handles various source system inputs and functional areas. New policies are entered by FAST system and split over sixteen sub systems. It includes various modules like Payouts, Rates, Fund Management, MCS, Web mart, ORION….

Primary Responsibilities:

Develop and implement the custom solution by leveraging the FAST admin platform framework; Partner with FAST vendor to address the existing issues in FAST application and collaborate in deploying new FAST release in client environments.

Design and implement the product configuration that assist new client on boarding, Work with Technical architect in solutioning the current existing Fast platform to cloud.

Implemented incremental data load for SSIS package.

Created data integrity check points, Data validation, domain transfers, Data transformation in SSIS.

Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent and schedule DTS/SSIS package through Autosys (UC4) and SQL server Agent.

Work with UC4 Team to design job flow and schedule and execute ETL Code using UC4

Atomic system.

Performance tuning and code optimization to improve runtime of SSIS Package &ETL Process.

Worked on the data archival process and validating it SSIS package.

Separated few ETL workflows from SSIS into AWS and cloud (ADF) for client based.

Data Validation Check Code development using PLSQL to validate data between source and

Data service database.

Collaborate with other client enterprise architect during new FAST release to accommodate the changes for new client details in enterprise sub system like CORE, Correspondence, Broker Com Agent related information and Others.

Resolving any critical /showstopper in nightly batch processing in quick turnaround time and their by eliminating slippage with client SLA.

Collaborate with offshore team to address any issue or showstopper that prevents team from resolving incident ticket.

Involve in providing estimates for all deliverables of fixed price projects as well as discretionary projects.

As a Subject Mater Expert act as an escalation point for the team in the event of an issue arising during development, following the escalation process.

Act as the single point of contact between the client and offshore support team Design release management strategies to deploy the Discretionary Project Product in Production and manage go-live.

Conduct and participate in triage meetings with Business and Architect’s team for requirement gathering, identifying complexities and challenges.

Review daily status report and keep NTT DATA management informed of development progress and communicate with SE2 project manager update the progress of open items.

Communicate and interact with SE2 Business and Quality analyst for clarifications, issues and concerns.

Facility/ Project :National Trust Housing Finance Ltd - ERP

Duration :July2012 – May2015

Position/Title : Assistant Manager

Skills :ASP.Net, C#, PL/SQL, SQL Server, SSRS, Web Service

Description:

ERPS is a fully automatic system of a housing finance banking sector.

Main modules are Credit, Accounts, Recovery and HR.

Credit: Starts from Lead, Loan processing, Scrutinizing [like Verification, LSR, TSR], sanctioning & disbursement .

Accounts: Disbursement & maintain user accounts.

Recovery: Customer tracking, dues, NPA, Auction, Demand Notice & possession

HR: All HR activities.

It covers PO management, Help desk Management, Vendor Payment, Auditing

Primary Responsibilities:

Involved in understanding the application, Database designing, Coding, Implementing and maintenance.

Code Changes, Bug Fix and Deployment.

Design Document preparation.

Implement C# console application to schedule jobs.

Facility/ Project :National Trust Housing Finance Ltd - CRM

Duration :Jan 2012 – June2012

Position/Title :Software Engineer.

Skills : ASP.NET, C#, VB.Net, SQL Server, Crystal Report

CRM – Customer Relationship Management. This portal enabled the ability that the customer can post their queries for the company service. Individual employees’ dashboard will pop up the respective area queries and based on the hierarchy it will move.

Primary Responsibilities: Involved in requirement gathering, product design, data base design, development, testing and deployment the project.

Facility/ Project :National Trust Housing Finance Ltd - Cashflow

Duration :June 2011 – Dec 2011

Position/Title :Software Engineer.

Skills : VB.Net, SQL Server, Crystal Report

This Cash flow project used to plan & project the funds in right direction. It handles Cash Inflow, Cash Outflow,Projection, Broad Forward, Planning Vs Actual

Cash Inflow – what are all the income through various way .

Cash Outflow – Expenses within or outside the company.

Projection – Planning for next 6 months. what is the P& L and Cash flow for the next six months. we can plan accordingly.

Broad Forward – Comparison between inflow and outflow and projection

Planning Vs Actual – Gives the variation between Real and planning collection and expenses. This is done for department wise In / Out flow. Each transaction has a separate report format. User level security is maintained.

Primary Responsibilities: Involved in data base design, development and testing the project .

Facility : Stahl India Pvt LTD, Chennai

Duration : 1.6 year

Position/Title : Programmer

Environment :PL/SQL, SQL Server,VB

This project has full life cycle of manufacturing company. It tracks all the activities from Purchase to FAS. It has modules of Planning, Purchase, BOM, Shop Floor, Receiving, Inventory, Sales.

Each modules shared common data base . It is accessed by multiple Users through remote server.

Planning - starts from the forecast and Manpower . This module deals with Forecast, Planning,MPS,RM requirement,Shortfall And Capacity . It consider current stock and tells the purchase department what is the Requirement for current month . It produces the MPS based on the lead time and stock position .

Purchase – According to planning status purchase RM, Intermediate and FG goods purchased .It affects in FAS.

BOM- After purchase the required material BOM created. BOM tells what is the RM required for creating a particular FG.

Shop Floor- In this module work order are created. After shop receipt inventory high. Stock range is high. In shop floor Batch NO created . Every sales linked with Batch no .

Receiving - We can increase the stock position by Purchase goods or produce the materials . After purchase it comes to Receiving . Each goods are received with GRR number it comes across with Gate entry, receipt entry, Qc acceptance, Movement Warehouse .

Inventory – Mainly deals with stock level . Here various report are available to see the stock position and account related module

Sales – Sales order, DC and Invoice are made here . Sales value linked with FAS and Qty linked with Inventory . It deals with Customer related data .It tells the terms about Abnormal Demand, Revalidation, COA ..

In this project we create triggers, Indexes, Procedures, complex and normal Views. Each module has separate reports for All Master and Transaction . Here we use Spread Sheet for report purpose .

Primary Responsibilities:

Involved in design, database analysis and development of the project

Educational Summary:

• MCA: Graduated from Alagappa University, Tamil Nadu-India.

• B. Sc., (CS): Graduated from Indira Gandhi College -Bharathidasan University, Tamil Nadu-India

Contact this candidate