Sql Server Data

NatanaSabapathy – Senior .Net & SQL Developer

*********@*****.*** - 443-***-****

https://www.linkedin.com/in/natanasabapathy

PROFESSIONAL SUMMARY

Around 16+ years of experience in systems Analysis, Design, Development and Implementation of Web Application using N-tier Architecture involving all stages of Software Development Life Cycle (SDLC) and performed post production supports.

Experience in web development using both internet and Intranet based technologies, and created most innovative web applications.

Used .Net, C# & Microsoft SQL Server, Oracle databases for many client/server & web based applications.

Good experience in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object Data Adapter Object to access databases like SQL Server 2008/2005/2000, Oracle 8.0.

Good experience with .Net web services and WCF Services.

Used MVC 4.0 to provide easy implementation of self service screens. Implemented web services through AJAX

Extensive experience in relational database development, writing database queries, Views, Stored Procedures, Cursors and Functions using T-SQL and PL/SQL (DDL, DML, DCL, TCL) in Microsoft SQL Server 2008/2005/2000 and Oracle 8.0. Strong knowledge of SQL and exposure in writing Stored Procedure, Functions and Triggers using MS SQL Server 2005/2008.

Have worked on AWS Cloud where our application is hosted and the clients used it on license based.

Hands on experience in creating ETL packages using SQL Server 2005/2008 Integration Services (SSIS). Extracted data from various source to staging area and loaded to various Targets using SQL Server Integration Services (SSIS). Extensive experience in Data Migration, Data Conversions, Data Extraction/Transformation/Loading (ETL) using DTS (DTS Import Export Data, DTS Packages, Bulk Insert and BCP, SSIS).

Developed reports using crystal reports and SSRS.

Experience in designing Database Models using ER-Win.

Experience in database performance tuning and query optimization, data integrity and statistics.

Good knowledge in the installation and configuration of SQL Server.

Excelled in Production Support & resolving tickets using Jira, Version One etc., and interacting with end-users.

Strong analytical and problem solving skills with excellent interpersonal and communication skills, having dealt with diverse professionals, clients and team members.

Highly motivated, self-starter, able to set effective priorities to achieve immediate & long-term goals.

TECHNICAL EXPERIENCE

Languages

C#, C, C++

Database

MS SQL Server, Oracle, MS Access.

Web Technologies

ASP.Net, HTML, XHTML, CSS, Web Services, Windows Forms, ADO.Net, XML, .Net MVC, WCF, Angular JS, BootStrap

Development Tools

MS Visual Studio, Visual Source Safe, Version One, MS Mgmt Studio.

Web Server

IIS6.0/7.0

BI Tools

SSIS, SSAS and SSRS

EDUCATION:

Master of Computer Applications from University of Madras in 2005

Bachelor of Science from University of Madras in 1999

PROFESSIONAL EXPERIENCE

GDIT, Towson, MD-21204. Lead/Consultant Jun ’15 – Till Date

STARS Interceptor and Sentinel – Application to find out the fraud/Waste/Abuse claims which helps the Insurance providers to sustain in the business.

Responsibilities:

Used vb.net with ADO.NET objects such as Connection, Command, Data Reader, Dataset and Data Adapter.

Effectively used Factory classes.

Converted all the .HTC files used in the behavior option to JQuery/Javascript files in order to comply with IE11.

Used HP Fortify source code analyzer tool to identify the SQL Injection, cross-site scripting issue etc and fixed/audited the issues.

Effectively implemented ASP.NET intrinsic state management functionality to store application-specific, session-specific, page-specific and user-specific information between page requests.

Designed ASP.NET web pages using data binding controls like dropdown list, grid control and various other UI controls in the Admin module of the application to bind the data.

Worked With ASP.NET Navigation Control, User Controls, and Master Pages and developed Cascading style sheets (CSS) for consistent look and feel of the website.

Implemented client side validations using Java Script and server side validations by using .NET validation controls.

Involved in trouble shooting and fixing software bugs using Visual Studio.Net, involved in post-production support, performed unit testing and debugged the application for bug fixing.

Environment: ASP.Net, VB .Net, SQL Server, Oracle

Ramco Systems. Lead/Sr. Application Developer April ’14 – Jan’15

Actavis, Mumbai, India. – A Pharmaceuticals Company where Ramco’s Payroll, Reimbusement, Travel and Leave management modules were implemented successfully. Once the monthly payroll is complete, bank transfer file for salary credit can be generated from the application which follows the bank encryption format. Also the Journal Voucher can be generated from the application which is used to post to Finance module in SAP application. Bank files for reimbursement modules (Travel and Monthly reimbursement) are also built in the application with the respective bank’s encryption format. All employees Swipe information posted in the FTP Server by the users were captured and stored in the application with the complex logic to find out the In-Time and Out-Time along with the Over-Time information for the easy view of employees.

Responsibilities:

Actively interacted with users, DBA’s and Business analysts to fully understand the requirements of the system.

Worked in data modeling using Erwin

Hosted the application in AWS cloud due to which many of our customers shared the same application.

Have implemented WCF Services for the easy use of customers.

Self Service Screens are built using MVC 4.0 and Entity Framework along with Razor Views.

Implemented WCF Services from MVC using AJAX.

Used C# with ADO.NET objects such as Connection, Command, Data Reader, Dataset and Data Adapter.

Effectively implemented ASP.NET intrinsic state management functionality to store application-specific, session-specific, page-specific and user-specific information between page requests.

Designed ASP.NET web pages using data binding controls like dropdown list, grid control and various other UI controls in the Admin module of the application to bind the data.

Worked With ASP.NET Navigation Control, User Controls, and Master Pages and developed Cascading style sheets (CSS) for consistent look and feel of the website.

Involved in trouble shooting and fixing software bugs using Visual Studio.Net, involved in post production support, performed unit testing and debugged the application for bug fixing.

Involved in developing Web Services and invoking them by using XML, SOAP and WSDL for creating proxy classes.

Responsible for troubleshooting data issues, validated result sets and implemented process improvements.

Performance tuning of Stored Procedures and T-SQL Queries. Utilized Execution Plan and SQL Server Profiler to trace the slow running queries and optimize SQL queries for improved performance and availability.

Imported data from files using SQL BULK INSERT in user specified format to database tables.

Exported the data in/out of SQL databases quickly using BCP Command

Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers and also published Reports to SharePoint site.

Environment: ASP.Net, VB .Net, C#, SQL Server, Oracle, ETL, Erwin, SSRS.

Ramco Systems Lead/Sr. Application Developer April ’08 – Mar ‘14

GE, Bangalore, India - GE Payroll & ESS is an Employee Self Service portal where employee can allocate his monthly CTC across various components as part of Flexi Benefit Plan and view their Pay slip and Income Tax Working sheet on-line. Payroll & Tax engine which computes the monthly payroll and tax data. This application has been built and implemented for 40 GE entities across India. An additional application to interact with the KRONOS application to capture the employees leave application has been built successfully and been implemented for one of the GE entity. Employee’s personal information and salary information will be sent as a feed file from ORACLE system to our application. This information will be interpreted and fed into our application with complex business rules.

Responsibilities:

Responsible for coordinating all services provided to GE by way of strategy, business consulting, projects and operational services.

Identified the schema changes according to the varied requirements to support daily business operations.

Involved in full life cycle of the project from requirements gathering, analyzing, designing UI/Middle tier/data base and transition using Iterative AGILE Methodology and Implemented 3-Tier architecture to implement the project.

Lead a team of 7 members and assisted them in understanding the requirements. Also helped them in building the complex business logic.

Created and deployed XML Web Services using ASP.NET and C#, and generated the proxy class files based on the web services to be consumed in web application.

Used web services and XML standards, including SOAP and developed the prototype using XML web service (SOAP) for data transfer.

Used ASP.NET, C#, Data Grid, Repeater to display the data in a customized template for the purchase requisition screen.

Implemented WCF Services from MVC using AJAX.

VB .Net application was used to pull the employee information from the FTP server which was posted by the Oracle system. Also used the GPG tool to decrypt the file and to parse the data with the business rules to upload the employee’s information into our application. Once the upload is complete, exception data will be posted to the FTP server. The same was also available as part of report, so that the users can generate the report at any point of time.

Used VB .Net to pull the leave information of employees which was posted by the KRONOS system. Then the data was parsed with the business rules which was mutually agreed by the users and uploaded to our system so that the employees will be able to view the same in our application.

Worked with integration services for transferring and reviewing data from heterogeneous sources like (Progress Database, Excel, CSV, flat file, Text Format Data).

Created the connection to source data (Progress database) by creating Linked Servers using ODBC drivers and OLEDB Providers to move data from Legacy system to Source system (SQL Server database).

Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.

Extracted data from various sources like SQL Server, Oracle, CSV, Excel and Text file from Client servers and through FTP. Performed Bulk data migration using DTS and SSIS from flat files.

Created reports using SSRS from various sources like SQL Server and Cubes from Analysis Services.

Designed reports using MS SQL server Power Pivot-tables, bar-charts, Line-charts and Pie-charts on data from SQL Server in Excel.

Interacted with Business Users to help them understand how to generate reports/look at the business data with various drill down options with Excel 2003/Excel 2007 via connecting to SQL Server.

Environment: ASP .Net, C#, VB .Net, SQL Server, SSRS, SSIS, Oracle

Covansys, Chennai, India Sr. Developer Dec ’03 – Apr ‘08

Infodebt - Centralized system for CARRS, Merrill Lynch, UK. - Infodebt is a management information system that collated data from various bonds and repo core systems. This centralised system was built-up to measure improvements in performance and for better unit costing analysis. Also we can run adhoc queries based on the need. CARRS, Client Analysis Revenue and Reporting System is a reporting tool which collects trades from Infodebt systems and does the processing for calculating Production Credit, Assigning Sales Person and many other details related to traders.

Responsibilities:

Upgraded from SQL Server 2000 to SQL Server 2005.

Migrated SQL DTS packages to SQL Server 2005 integration services (SSIS) packages.

Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Created logical and physical data models according to the business requirements.

Designed SQL Server database tables, views, stored procedures, triggers and functions.

Monitored the performance of SQL Server using SQL Server Profiler.

Performed data transformation services and bulk inserts for large amounts of data.

Developed, modified, and optimized complex queries for data retrieval and modification.

Managed the backup and recovery of the database.

Experienced in setting up SQL Server and database configuration parameters.

Environment: SQL Server, SSIS, ETL, ASP .NET, C#

Broker Bills - Manages commission Details of Brokers, Merrill Lynch, UK. - The system provides a mechanism by which the operations team can process, reconcile and pay brokerage fees allocated to trades within the source systems, Blotter, Summit, Vaster, Aurora and Bloomberg.

.

Responsibilities:

Developed all modules using ASP to access the data.

Extensively used ADO to access and manipulate data from database.

Used XML and XSLT for data transformation.

Went to LONDON, U.K. as part of this assignment for implementation and support activities.

Supporting the team at offshore by conducting regular teleconferences.

Environment: SQL Server 2000, ASP 3.0, Java Script, COM/COM+, HTML, DHTML, XML/XSL, MSXML DOM4.0, IIS5.0, Windows 2000.

Special Purpose Vehicles, Merrill Lynch, UK. - SPV (Special Purpose Vehicles) is web based systems used to track down/maintain the transaction details taken place in different bankruptcy companies located in various tax beneficial locations. These companies are basically involved in purchasing and re-packaging the underlying assets (from Merrill Lynch). These are then resold as customized bonds by sometimes combining them with swaps and options.

.

Responsibilities:

Maintained the ASP Application and deployed the COM+ components in the COM+ server.

Coordinated with the onsite team for further enhancements to the system.

Optimized queries and wrote new queries as required for generating reports.

Maintained Activity Cum Review logs for Quality Assurance and the batch files.

Went to LONDON, U.K. as part of this assignment to gather client requirements.

Supporting the team at offshore by conducting regular teleconferences and mentored the team.

Environment: SQL-Server 2000, ASP, VB Script, Java Script

Altosys, Chennai, India ASP & VB Developer Jul ‘03 – Nov ‘03

Altosite: It is an enterprise level content management system. It simplifies the Challenge of creating, managing, distributing content in complex environments. It allows business users across the organization to easily add or modify their own web content without any technical assistance. Altosite is easy to deploy, flexible to manage and highly cost effective. Leverages open standards such as XML, 100% browser driven, Superior workflow management, Extensive interoperability with External systems, Enhanced scheduling & archiving, Version management and roll Back capabilities, Altosite has two major modules viz content management and content publishing. The content management module is a repository of articles organized into various folders based on the nature of the articles. The web administrator can define the overall structure of the articles (for e.g. title, abstract, image, main body, related links etc.,) and the authors can create articles and send for review. Once an article is ready for publishing it is pushed to the content publishing module.

.

Responsibilities:

Designed & developed application in VB & ASP with SQL server.

Designed the GUI using HTML and DHTML and functions and properties using COM+ components.

Used JavaScript for client side validations and VB Script for server side validations.

Published content using COM+ components.

Deployed the entire application on IIS Server and the components in COM+ Application Server.

Prepared test cases and conducted unit testing.

Environment: ASP, JavaScript, VB Script, VB, COM+, DHTML, HTML, SQL-Server 2000, XML

Ramco Systems, Chennai, India VB Developer Jan ‘02 – Jun ‘03

IAFS - Indian Air force, Nasik - India has a total of 23 BRDs (Base Repair Depot) where all the Indian Air Fighters such as MIG-23, MIG-29 will be serviced. This project is the complete automation of 11BRD. This service starts from the Ferry in of an Indian Air Fighter and ends with the Ferry Out of the same. All the process in-between this Ferry-In and Ferry-Out will be taken care by our IAFS System.

Responsibilities:

Provided technical guidance to the team.

Done the entire coding in VB for this application.

Written generic functions, which are used in the entire system and conducted testing activities.

Prepare and update the Project plan documents.

Environment: VB, SQL Server 2000

RAG - This is a tool developed to create VB Project based on the Input given using the User Interface. It has three Phases. A) User Interface B) BE Generation and C) FE Generation. BE Generation Part takes care of the Back End Procedure Creation, FE Generation Part takes care of the VB Project Creation and User Interface Part is the actual Data Entry Part.

Responsibilities:

Provided technical guidance to the team and done the entire coding and GUI Design in VB for this application.

Written generic functions, which are used in the entire system and conducted testing activities.

Environment: VB 6.0, SQL Server 2000.

Pentasoft Technologies VB Developer Apr ‘01 – Jan ‘02

Cash Management System (Allahabad Bank, Calcutta – India): Cash Management Services offers an effective solution to Banks to enable them to render best service to their customers in the Collection and Payment of local/outstation cheques and in providing instant information to their customers. The entire process of cash management system is automated backed by effective communication channels and supported by competent software, which enables easier handling of large volumes of transactions.

Responsibilities:

Designing of the database using sql server.

Done the entire coding and GUI Design in VB for this application.

Written generic functions, which are used in the entire system and conducted testing activities.

Porting the files from the testing server to the Staging server

Environment: VB 6.0, SQL-Server 7.0

Inventzo Systems Private Limited VB & ASP Developer Mar ‘00 – Mar ‘01

MK Project (MK Electricals India Limited - India)

Description: MK Electrical being leading electrical goods Manufacturers wanted to automate their transactions. MK will have its carrying and forwarding agents in major cities like Delhi, Bombay, Chennai etc. MK will instruct the C&F Agent to supply goods to their dealers according to the sales order. Then the Material Receipt Note will be sent to its Corporate Office. MK may also buy some goods from its vendors. These materials will be sent directly to the C&F Agent in turn C&F Agent will send an MRN to its Corporate Office.

Responsibilities:

Designing of the database using sql server.

Done the entire coding and GUI Design in ASP and VB for this application.

Used JavaScript for client side validations.

Reports are generated using ASP and HTML.

Deployed the entire application on IIS Server.

Environment: ASP, SQL Server 6.0, HTML, XML, JavaScript and Visual Basic 6.0

Selco (SELCO Products India Limited, Bangalore – India)

Description: This Project has many modules like Material Management, Vendor and Vendor Quotation Management, Material Transformation Management, Material Requirement Plan etc. Based on the purchase order raised by the company the vendors can submit their quotation. The company has three types of purchase orders: Local for local vendors, Import for foreign vendors and Sub-contract for its sub-contractors. Based on the Purchase order raised by the company, the vendors can submit their quotation. The company having many branches all over India, on some situation will transfer the components from one location to another. This process is said to be Inter Branch Material Transfer. If the branch needs materials either the Head Office can raise a Purchase Order or it can transfer the material from one branch to another. If it raises a Purchase Order, based on that the vendors can submit their quotations. For material transfer, Transfer Note will be used. I.e., what are the components transferred, From and To location, Quantity of the component etc., will be maintained. This is actually a plan through which we can calculate the monthly and annual material requirements. Based on the previous year consumption, component replaced and component wastage we will be calculating the current year’s approximate material requirement.

Responsibilities:

Designing and implementation of the Application and Database and provided technical guidance to the team.

Written generic functions, which are used in the entire system and conducted testing activities.

Reports are generated using Crystal Reports

Played the role of configuration manager in order to port the source files to the VSS (Visual Source Safe).

Environment: VB 6.0, SQL Server 6.0, and Crystal Reports

Contact this candidate