SUMMARY:

• Confidential is a highly motivated Web, Windows Application and BI Developer with proven ability to transform concepts into interactive reality. Possesses more than ten years of comprehensive IT experience and has successfully served in both analytic and technical capabilities during all stages of project implementation in various large and small - scale applications. He is an efficiency-driven, detailed developer comfortable in multifaceted development environments.
• Extensive experience in SDLC which includes design, development, testing and implementation of Client Server, Windows and Web applications
• Extensive experience in writing Transact-SQL(DDL, DML) queries in SQL Server 2000, 2005 and 2008 R2
• Excellent knowledge in creating Tables, Relationships and expertise working with SQL Queries, Stored Procedures, Functions, Views and Triggers
• Excellent skills in implementing ETL Packages using DTS in SQL Server 2000 and SSIS in SQL Server 2008 R2
• Experience in creating master and child packages, Package Configurations and Logging
• Excellent knowledge of using Variables, Expressions, VB script in packages and migrating
• Experience in creating Jobs, Alerts and Scheduling DTS/SSIS Packages through SQL Server Agent
• Expertise in generating reports using SQL Server Reporting Services 2008 R2(SSRS) and Report Builder 3.0
• Experience in developing Parameterized, Chart, Sub report, Drill-down and Linked reports
• Proven ability in using Shared and Embedded Data Sources and Datasets and generating reports by creating stored procedures and complex queries
• Experience in MS Access Queries, Forms and Reports
• Extensive experience in Web Development using server side scripting ASP
• Expertise in designing and developing GUI for Web applications with HTML, DHTML, CSS and Java Script
• Experience in Visual Basic 6.0 development for Management Information System and Content Management System for B2B web portal
• Experience in TeamSite, Open Deploy and Crown Peak for enterprise content management
• Knowledge of ASP.NET for designing and developing Web based applications using C#

TECHNICAL SKILLS:

Languages: T-SQL, Visual Basic 6.0, C#, C, C++, Java

RDBMS: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008 R2, MS Access 2000/2003/2007

Business Intelligence: BI Development Studio(BIDS), SSIS, SSRS

Web Technologies: ASP 3.0, PHP, ASP.NET, HTML, DHTML, JQuery, Mootools

Scripting Languages: VB Script, JavaScript

Tools: Visual Studio 2005, Perforce 2006, Clear Quest, Team Site 7.1, Crown Peak CMS, Git, Cacoo, Dreamweaver, Team Foundation Server

Web Servers: IIS 5.0, IIS 6.0, Apache Tomcat

Operating Systems: Windows 98, Windows NT / 2000 workstations, Windows NT / 2000 servers, Windows XP, Windows 7

Web Analytics: Coremetrics, Omniture

PROFESSIONAL EXPERIENCE:

Developer

Confidential

Responsibilities:

• Development of ASP based web forms to capture Service Authorization, Services, Providers and Invoice information
• Creation of Stored Procedures and Functions in T-SQL to capture data provided through Web Forms, generate reports and data pull by DTS package
• Fixing the bugs in existing iCIS application by making necessary changes to ASP, JS, stored procedure and functions
• Designed and developed DTS packages for transmitting SAF information to service providers, loading drug test results and invoice data into SQL Server 2008 R2, and shooting status email
• Building DTS and SSIS packages to export SAF information into flat files, transmitting to Treatment Service Providers via FTP and archiving files
• Upgraded/Migrated DTS packages in SQL Server 2000 to SSIS in SQL Server 2008 R2
• Developed SSIS package to pull various case data from OLTP database to load in reporting environment and exporting into flat files for general public usage
• Scheduling jobs in SQL Server 2000 and 2008 R2 to execute stored procedure to prepare report data and executing DTS and SSIS packages to generate data files
• Developed Drill down, Parameterized Reports and Subreports to display Juvenile drug test results and invoice data based on selected period
• Built reports to present the justice court case statistics in the form of Chart and Linked reports
• Participated in deployment of code files, T-SQL scripts, packages and jobs on test and production environment
• Support, Maintenance and Enhancement of existing iCIS application to support new processes

Environment: SQL Server 2000, SQL Server 2008 R2, DTS, SSIS, SSRS, HTML, CSS, Java Script, ASP, BIDS, Team Foundation Server, IIS 6.0

Developer

Confidential

Responsibilities:

• Support & Maintenance of corporate web-site and contract customers’ microsites.
• Managing the website content and deployment through TeamSite and OpenDeploy.
• Crown Peak CMS operations to manage life-cycle of microsites, environment based publishing, trouble shooting and CMS administration.
• Co-ordination with the CMS provider for development and enhancing existing features, QA and roll-out to various environments.
• Development & Deployment of dynamic ASP web-pages to relay lead information.
• Creation of Stored Procedures and Functions in T-SQL to generate lead reports for analytic purpose.
• Designed and developed SSIS packages to export leads data from OLTP database and generating flat, XLS files on the file server
• Deployment of the SSIS packages, Scheduling Jobs and Alerts
• Building reports using SSRS to analyze the campaign performance based on leads data considering LOBs, duration as parameters, highlighting key areas with conditional formatting and depicting statistics by charts
• Created report snapshots with maintaining history and caching based on schedule for better performance
• Web analytics - Coremetrics & Omniture implementation on corporate web-sites to measure the effectiveness of marketing programs and campaigns.
• Web sites, applications and data migration from PHP/MySQL/Apache/Linux environment to MSSQL/IIS/Windows based dedicated hosting environment.
• Domain registration, DNS records configuration for new and existing web-sites, and hosting on IIS web servers.
• Co-ordination with hosting service provider for load balancer configurations and Linux/Windows environment maintenance.
• Development of VBA tool for dynamic verification of broken links on microsites and generating Excel based Coremetrics page views reports from given CSV files.
• Developed Excel based tool using VBA to pull product images from a list of servers available on the network via FTP connections

Environment: HTML, XHTML, CSS, Java Script, JQuery, ASP, PHP,SQL Server 2005, SQL Server 2008 R2,SSIS, SSRS, VBA, MS Access 2007, Coremetrics, Omniture, Brightcove, Interwoven TeamSite 7.1, Crown Peak, IIS 6.0

ASP Developer

Confidential

Responsibilities:

• Modifying legacy ASP web sites to support a newly created Unicode database via dynamic message coding.
• Conceptualize efficient methodologies to perform mass swapping of HTML tags attributes across multiple web sites
• Building channel applications web sites using Perl script and configuring web sites on IIS
• Testing and Debugging ASP pages and conducting quality-assurance testing on client web sites.

Environment: HTML, CSS, Java Script, ASP, SQL Server 2005, IIS 6.0

Senior Programmer / Web Developer

Confidential

Responsibilities:

• Involved in designing and implementation of the database tables.
• Created database maintenance plan for optimization and tuning of complex queries using indexes.
• Presentation layer developed using HTML, JavaScript, CSS, ASP and data access accomplished using ADO.
• Extensively used INCLUDE files for better maintenance and giving uniform look to the application.
• Written Stored Procedures and User Defined Functions to perform DML operations.
• Participated in deployment and configuration on production server at client location.
• Performed testing and bug fixing.
• Written the Snippets for the repetitive use.

Environment: HTML, DHTML, CSS, Java Script, ASP, SQL Server 2005

Senior Programmer / Web Developer

Confidential

Responsibilities:

• Fully involved in the designing of database tables considering relationships, input validation by implementing constraints and creating indexes.
• Development of Visual Basic software that stores and manages information about suppliers, products, tradeshows and members.
• Publishing web pages using VB software periodically and uploading on server.
• Developed ASP pages for server side processing
• Written Stored Procedures and User Defined Functions.
• Deployment of portal for real time use.

Environment: HTML, DHTML, CSS, Java Script, ASP, Visual Basic 6.0, SQL Server 2000

Senior Programmer / Web Developer

Confidential

Responsibilities:

• Involved in designing and implementation of the database tables considering relationships.
• Created Presentation Layer pages using HTML, CSS and JavaScript for client side validations
• Written SQL queries, Stored Procedures, Functions & Triggers.
• Developed modules using ASP and ADO which provide functionalities to the system.

Environment: HTML, DHTML, CSS, Java Script, ASP, SQL Server 2000

Web Developer

Confidential

Responsibilities:

• Database designing in MS Access 2003
• Data access accomplished using ADO
• Created web pages using ASP 3.0
• Used Java Scripts for Client side validations.
• Responsible for creating Shopping Cart using Dictionary Object and Class to store product information.
• Integration with payment gateway.
• Integration of modules developed by subordinates.
• Ensuring that the work meets the quality requirements and zero defects.

Environment: HTML, DHTML, CSS, Java Script, ASP, MS Access 2003

Web Developer

Confidential

Responsibilities:

• Involved in the entire designing of database tables.
• Involved in Payment gateway integration for online purchase.
• Responsible for Content management system development.
• Completed the deployment and configuration on production server using FTP.

Environment: HTML, DHTML, CSS, Java Script, ASP, MS SQL Server 2000

Senior Software Programmer

Confidential

Responsibilities:

• Fully involved in the development of the website from designing database to development of each module.
• Designing of web pages using HTML, DHTML, CSS and JavaScript.
• Used ASP to link External CSS file based on date to provide different look on each weekday.
• Written queries for Data Access using ADO
• Maintenance of deployed website which involves price and part information updating and keeping them up to date.

Environment: HTML, DHTML, CSS, Java Script, ASP, MS Access 2000

Confidential

Responsibilities:

• Involved in database designing tables considering relationships and implementation.
• Developed Graphical User Interface using HTML, DHTML and CSS.
• Used JavaScript and VBScript for client side validation.
• Coding, debugging, testing and deployment of modules used by purchase, sales department and admin.
• Developed HTML help files.
• Forms, Queries and Reports creation using MS Access 2000.
• Checking and Updating price by running Access Queries.
• User, Deployment, Customization and Maintenance.

Environment: HTML, DHTML, CSS, Java Script, VB Script, ASP, VBA, MS Access 2000, IIS 5.0

Software Programmer

Confidential

Responsibilities:

• Understanding requirement with users’ interaction.
• Designing database and development of the entire system using MS Access Forms.
• Developed HTML help files and user manuals
• User .

Environment: Visual Basic 6.0, MS Access 2000

Software Programmer

Confidential

Responsibilities:

• Involved in feasibility study and application design.
• Design and developed database.
• Application development, debugging, testing and deployment.
• Created GUI to grant and revoke excess of menus by system admin.

Environment: HTML, DHTML, Java Script, ASP, MS Access 2000, IIS 5.0