C#, asp.net, hyperion bi,sql server,crystal reports, ssis,ssrs

BALA DURAISAMY

Email:*******@*****.***

Phone:630-***-****

Summary of Experience:

Above 9 years of work experience in the areas of Software development, design, coding, integration in web-based and Client Server applications.

Extensive experience in VS.NET (ASP, ASP.NET, C#.NET, Win Forms, Web Forms, VB.NET, ADO.NET, COM+, REMOTING, WPF, WCF, Silver light, LINQ), Visual basic 6.0,

Oracle, Sql Server, XML, Java Script, HTML, SSRS, Crystal Reports to build applications.

Receptive to new technologies and trends.

Experience in creating Web services using XML, HTTP, TCP/IP, SOAP, REST, ADO.NET and inter-application communication using SOAP/REST based on the .NET

platform.

Expertise in SQL Server 2005/2008 encompassing design and creation of databases, queries and stored procedures. Implemented SOA architecture.

Experience in developing Object Oriented JavaScript Programming, Cross Browser and Cross Server programming using AJAX, JSON Script. Experience in developing

Web Handlers

Experience in developing ETL application using SSIS Packages and Hyperion BI.

Expert in the complete SDLC. Has been involved in Analysis and responsible for Design, Development and Implementation of medium as well as complex

Applications.

Experience in working with Applications supporting multiple languages.

Excellent skills in analyzing existing/new application architecture, usage, defining and implementing procedures.

Involved in procuring Business as well as Functional user requirements

Experience in communicating and coordinating with the Client for implementation and change requests. Trained end users while Implementation.

Self-motivated, highly committed to responsibilities. Has ability to work independently as well as in team environments.

Well versed in working on various domains like For-Ex, Insurance, Project Management and Data warehouse.

Excellent written and spoken communication skills, strong architectural skills.

Technical Skills:

Languages & Technologies

VB.NET, C#, ASP.NET, VB6.0, ASP, HTML,ADO .NET, Web Services, TCP/IP, SOAP,REST,XSL, XML, COM+, REMOTING, JSON, WCF, LINQ, WPF, WWF, Silver Light,

Web Handler

Operating System

Windows NT / 2000 / 2003 / XP/Vista

Databases

SQL Server, Oracle, MS-Access, AS400/DB2, PostgreSql

Developer Tools

Microsoft Visual Studio. NET, Microsoft Visual Studio, Visio

BI Tools

Business Objects, Oracle Hyperion BI,SSIS

Reporting Tools

Crystal Reports, SSRS

Scripting Languages

VBScript, JavaScript, JSON

Others

IIS, VSS, Syncfusion Grid/Tab/Combo Box, SVN, Ajax Tool Kit, AJAX DHTML Grid/Menu, ChilkatDotNet2.NET, WebSupergo.ABCpdf7.NET

Education: M.C.A – Master of Computer Applications, Bharathidasan University, Trichy, India.

MCP Certifications:

Microsoft .NET Framework 2.0- Application Development Foundation

Microsoft .NET Framework 2.0- Web Applications

Professional Experience:

The Fidelis Group, Little Ferry, NJ Oct ’08 – Till Date

Role: Sr. Software Engineer

Project: Campaign Management (Client AIG)

AIG is a world leader in insurance and financial services. Campaign Management is a web based application campaigning people on behalf of banking and

other marketing institutions. This system keeps track of up to date information about Prospects, Deals, Campaigns, Campaign choices, new application entry,

Application processing with status of (Sale, No Signature, No Coverage Choice, No Pay Details, Deceased, Do Not Solicit).

Responsibilities:

Designed User Interface using ASP.NET, C#, AJAX. Written Business Layer in C#

Wrote web service Interfaces using C#. NET, ADO.NET, JSON

Implemented reporting features in existing ASP site web.iceculinary.com

Wrote Cross browser and Cross server based scripts by using Ajax client Library and Object Oriented JavaScript programming.

Modified NoPayDetail, No Signature, NoCoverageChoice Generic PDF templates using WebSupergo.ABCpdf7 third party tool and provided downloadable option in

ASP.NET

Written code for downloading Sales/Approval files in ASP.Net.

Uploading Sales/Approval files in to AIG’s/LOTS ftp site using ChilkatDotNet2 component

Created Stored Procedures, Functions in Sqlserver 2008. Designed Prospects, Campaigns, campaign choices, Responses, Payment Detail tables in Sqlserver 2008

Written separate C# Win Forms application to read and load the fixed length files in to Sqlserver2008 database.

Developed Brio Query, Chart, Pivot, Table, Report, Dashboard sections in Hyperion reporting studio 9.3 using SqlServer 2008, PostgreSql 8.2, Oracle 10g

databases.

Developed lot of Hyperion dashboards with slice/dice chart analysis, dropdown selections, List Box selections and Pivot Analysis for the chart.

Developed lot of charts with dynamic X-Axis, Y-Axis and Z-Axis in Hyperion reporting studio

Developed lot of Pivots with Dynamic Side Labels and Hide/Unhide Facts in Hyperion reporting studio

Created calculated columns and setting format for the columns in Pivot and Chart Facts in Hyperion reporting studio

Extensively used Filters on tables in Hyperion reporting studio

Implemented calculated columns and grouping columns in Table section of Hyperion reporting studio

Scheduled jobs/cycles in Oracle EPM Workspace 11.1 to run on weekly/monthly/daily basis.

Created custom events for jobs in Oracle EPM Workspace 11.1.

Uploaded dashboards and setting user wise permissions to dashboards in to Oracle EPM Workspace 11.1.

Environment:

SQLServer2008, VS 2008, C#, ASP, ASP.NET, Ajax, JavaScript, JSON, ADO.NET, WEBSERVICES, REST, XML, CSS, AJAX Tool Kit, Win Forms, LINQ, ChilkatDotNet2.NET,

WebSupergo.ABCPDF7.NET, .NET 3.5,Oracle 10g,PostgreSql 8.2,Oracle EPM Workspace 11.1, Hyperion Interactive Reporting Studio 9.3

VTech, Arlington Heights, IL Aug ’08 – Sep ‘08

Role: Sr. Software Engineer

Project: POS LOAD and Validation Application (ETL)

Vetch is one of the world's largest suppliers of corded and cordless telephones and a leading supplier of electronic learning products. POS Load and

Validation Application was designed to load all the Vetch trading partner’s Purchase Order System details in to SQLSERVER database

Responsibilities:

Designed SSIS package to load the raw data from EDI 852 file into SQLSERVER database

Designed SSIS package to validate bad customer, bad part number and bad dates against the loaded Purchase Order header and Purchase Order detail records

Developed User Interfaces using XAML,WPF

Written WCF service using C#. Written LINQ Data access Layer

Created stored procedures and designed tables in SQLSERVER 2005

Configured packages using SSIS configuration utility. Tested Packages against wrong data.

Deployed packages using deployment utility. Developed reports using SSRS

Verified all the Trading partners has data in the EDI FILE, send E mail to the Vetch officials

Environment:

SQLServer2008, VS2008, SSIS, VB.NET, C#, XAML, WPF, WCF, LINQ, XML, SSRS, .NET 3.5

Trainor Glass, Alsip, IL Mar ’07 – Jul’08

Role: Sr. Software Engineer

Project: Glazing Management-Project Management Online

Trainor Glass is one of the top Glazing contractors in the United States. Gazing Management is a web based application keeps track of the project

management details up-to date in online. This system contains details about the job information, Labor/cost billing inventory and invoice details, Trade

payment setup/application, correspondence, tickets, pictures and files etc.

Responsibilities:

Designed User Interfaces using ASP.NET, Ajax Control Toolkit (Animation control, AutoComplete TextBox, Filtered TextBox, Date control), AJAXDHTML Grid/Menu.

Developed Pop up window for user task list using Animation control, AutoComplete TextBox, Ajax DHTML Grid for Project Management and Glazing Management

Projects

Wrote web service Interfaces using C#. NET, ADO.NET, JSON

Produced Object Oriented JavaScript Code to load/update the ASP.NET form’s Page values from/back to the AS400/DB2, SqlServer 2005 Databases

Performed Asynchronous JavaScript programming and Callback functions.

Constructed Web Handlers using C#. NET, XML to load the AJAX DHTML Grid/Menu.

Implemented SOA Architecture by creating services using C#

Wrote Cross browser and Cross server based scripts by using Ajax Client Library and Object Oriented JavaScript programming. Wrote custom currency format in

JavaScript

Created Stored Procedures, Functions in SqlServer 2005. Developed Reports using SSRS.

Environment:

SQLServer2005, AS400/DB2, C#, ASP.NET, JavaScript, JSON, WEBHANDLER, ADO.NET, WEBSERVICES, SOAP, REST, XML, CSS, SVN, AJAX Tool Kit, AJAX DHTML Grid/Menu,

SSRS

Transguard, Westmont, IL Aug ’06 – Feb’ 07

Role: Sr. Software Engineer

Project: SIM (Shippers Insurance Management)

SIM is a website which helps insurance agents to generate insurance certificates before they ship goods from one place to another place. This system

supports payment and reverse of the payment online

Responsibilities

Wrote Web Service for Credit Card, ACH Payment using Velocity Payment V Link Service

Written Cross browser/Cross server Scripts by using Ajax Client, Object Oriented JavaScript

Generated Web Handlers using C#. NET and XML to load the AJAX DHTML Grid

Created Stored Procedures in SqlServer 2005 for Debit Payment, Reversal, Audit and Notes

Handled Client side Validations using JavaScript in order to validate Credit Card, Bank Check. Developed Business Layer using C#. NET. XSL used for temporary

reports

Maintained the Source Code version in SVN and XML used for configuration file

Effectively utilized .NET Caching Techniques and Session Management.

Developed reports using Crystal Reports.

Environment:

SQLServer 2005, C#, ADO.NET, ASP.NET, WEBSERVICES,REST, XSL, XML, CSS, AJAX DHTML Grid, Crystal Reports, JavaScript, Web handlers, JSON, SVN, MVC

RAEE (Redha Al ansari exchange Est.), Dubai, UAE Feb’ 02 - Jul’ 06

Role: Sr Software Engineer

Project: D-Mexis (Development of Money Exchange information system)

D-MEXis was developed for Currency Exchange Company. This Multilingual system facilitates purchase and sell of foreign currencies, TC’s, Remittances, Agent

Transfers and IBT. Reverse and Refund done with the proper control and relevant postings.

Responsibilities:

Requirement gathering about the ForEx system

Designed Com+ Architecture for Data layer, Remoting Architecture for n-tier Business Layer

Written unit test cases for GUI programming

Designed English /Arabic User Interfaces using C# Win Forms, Syncfusion controls

Created Visual Inheritance/User controls for User Interface Using C# winforms and Source Code is maintained in VSS. Used Global resource strings for

English/Arabic version

Developed common reusable object oriented code and common templates used in various modules in the system. Inherited .NET base classes for form templates and

common controls as well as Syncfusion Grid/Tab/Combo Box used in Win Forms.

Written Multithreading programming for Currency Exchange rate calculations.

Implemented Layaway transaction system, with/without Token System transactions

Captured customer information according to the central bank amount limit

Implemented Walk in/ On Account/Miscellaneous/Branch/Agent Customers transactions

Generated English/Arabic version reports using Crystal Reports

Developed Web Forms for Western Union Transactions using Asp.Net,Css,JavaScript,Vb.net

Created Stored Procedures, Cursors and Functions in SQL Server 2005

Scheduled backup and jobs in SQL Server to calculate opening/closing balances for the day

Coordinating with the client for implementation. Leading the Onsite/Offshore Development.

Gathering requirement from financial department. Handling Project requirements

Environment:

SQLServer 2005, MS Access, WinForms, C#,VB.NET, ADO.NET, COM+, XSL, XML, REMOTING, TCP/IP, Crystal Reports, ASP.NET, JavaScript, CSS, VSS, Syncfusion

Grid/Tab/Combo Box

Vijay Pipe Lines, Chennai, India Dec’ 00 – Jan’02

Role: Programmer

Project: Inventory Management System

IMS was developed to maintain the control over Purchase Order and Stock. Maintain Account Master, Item Master and Customer Master. Module maintains order

booking, goods inward, goods outward, returns, and adjustment.

Responsibilities:

Design and development database entities, stored procedures and triggers using Oracle 8.0

Developed User Interfaces using Visual Basic 6.0. Involved in Documentation

Developed Reports Supplier/Customer/branches Report, sales Report using Crystal Reports

Environment:

Oracle 8.0, Visual Basic 6.0 and Crystal Reports 4.5

Manoj Builders, Chennai, India Jan’ 00 - Nov’ 00

Role: Programmer

Project: Construction Information system

This System mainly deals with movement of raw materials from supplier to warehouse, warehouse to site areas etc. It comprises various modules like purchase

order, quantity of goods allotted/used to site areas, estimated price, stock management, Customer detail etc.

Responsibilities:

Developed Master screens using Visual Basic 6.0.Created Stored Procedures in Oracle 8.0

Design and development of Reports using Crystal Reports

Environment:

Oracle 8.0, Visual Basic 6.0, Crystal Reports 4.5

Contact this candidate