SUMMARY:

• Over 12+ years of experience in Analysis, Database Design / Development, Implementation, Debugging, Testing, Integration and Troubleshooting of Business/ Commercial / Internet /Intranet /Client Server applications in areas Telerik Controls, ASP.NET, C#, VB.NET, Web Services, Classic ASP, XML, COM, DCOM, UML, Web Services with backend like MS SQL Server2005/2008R2/2012, MS Access, Oracle, Teradata and Business Objects.
• Using programming language and technology, writes code, completes programming and documentation, and performs testing and debugging of applications. Analyzes, designs, programs, debugs and modifies software enhancements and/or new products used in local, networked, or Internet - related computer programs.
• Interacts with users to define system requirements and/or necessary modifications.
• Developed a solid understanding of Object Oriented Design and analysis for enterprise wide client/server and Internet application development in N-Tier environments.
• Excellent in developing XML applications, XSL, XSLT, DTD, Xml Schema, CSS
• More than 7 Years of experience in Database Design and Database Programming (Stored procedures, Triggers, Packages, T-SQL, PL/SQL) using SQL Server 6.5/7.0/2005/2008 R2/2012, Oracle 7.3/8.0/9.0, MS Access and Teradata.
• Hands on Experience in Extracting, Transforming and Loading Data by using DTS and SSIS.
• Developed cubes to represent and visualize the data using SSAS.
• Experience with Data Migration from SQL Server 2000/2008 to Oracle 9i using DTS/SSIS and PL/SQL scripts and from SQL Server 2000 to SQL 2005 and 2005 to 2008.
• Experience in VB to VB.Net and ASP to ASP.Net Migration.
• Used UML for generating blue prints for the software modeling.
• Developed distributed applications using .Net Remoting and Web Services.
• Excellent understanding of Software Development Life Cycle (SDLC).
• Good Knowledge in programming languages like C, C++,VB, ASP.NET, C#, VB.NET, AJAX and Coding standards.
• Experienced in Standard, Summary, Listing, Cross and Drill down reports and Graph Reports using SQL Server Reporting Services (SSRS), Crystal reports.
• Work effectively and independently or as part of a team.
• Team player, capable of working with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.
• Key Strengths include determining customer needs through Technological Knowledge and Experience

TECHNICAL SKILLS:

Web Technologies: VB.NET, ASP.NET, AJAX, ADO.NET, C#, Visual Studio.Net, Web Services

Development Tools: MS Visual Studio- 2003/ 2005/2008/2010 /2012 , Visual Basic 6.0/5.0, SQL Reporting Services (SSRS), Crystal Reports XI/10/9.0/8.5, Ajax, Telerik

Scripting Languages: VB Script, Java Script, jQuery

Languages: C, C++,Java, XML, XSL, DOM, SQL, PL/SQL, T-SQL

Interfaces: ADO, RDO, DAO, ODBC, OLE/DB, SOAP

Distributed Computing: COM, DCOM, COM+

RDBMS: SQL Server 2012/2008 R 2/2005/2000/7.0/6.5 , Oracle 9i/8i/8.0/7.x, MS-Access, Teradata, ETL, SSIS, SSRS, SSAS

Operating Systems: Windows 7, XP/2000/2003/NT, Windows 98/95

Version Control: VSS, CVS, Rational Clear Case, Starteam.

Other Tools: DTS Packages, SSRS, SSIS, SSAS, Web focus Reporting, SAP Business Objects web Intelligence Rich Client

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

Developer

Responsibilities:

• Involved in all Phases of the Software Development Life-Cycle (requirements, design, development, testing, release, support), utilizing multiple development methodologies, including OOD, Extreme Programming, Structured Programming and Database.
• Assemble and analyze data for business reports, make sure data and calculations are accurate.
• Maintain systems for recording business and financial data.
• Created the Reports and queries using SAP Business Objects web Intelligence Rich Client.
• Used Teradata SQL Assistant to pull the data from vast database of Sales Market.
• Created Incentives reports to analyze the daily sales for the Sales representatives and higher positions along with their earned points and Cash.
• Created and maintained Database driven email Incentive Subscriptions to send daily/weekly/Monthly basis to the Sales representatives and higher positions recipients along with their earned points and Cash.
• Automated the process to calculate the Payout at the end of the Incentive period for the involved Sales representatives, Managers and higher positions as per the assigned Cash/Reward points.
• Developed a Business Layer, which has all Business Validations using VB.NET.
• Designed and developed Interactive Incentive Subscriptions Sign-in Application using Ajax Validation on User Login ID, mandatory field using Telerik Controls, ASP.NET 4.0 and VB.net.
• Designed and developed RLDP Attendance Web Application which manages and keeps track of Retail Leadership Development Program attendance of Retail Store Managers using ASP.net 4.0 and VB.net.
• Designed and developed RLDP Attrition Web Application which manages and keeps track of Attrition score of Retail Store Managers using ASP.net 4.0 and VB.net.
• Designed and developed RLDP Employee Ethnicity Web Application which reviews and manages of Ethnicity score of Retail Store Managers using ASP.net 4.0 and VB.net and Ajax Control Toolkit.
• Created the tables and Stored procedures for each Sales web applications as well as Compensation reports.
• Designed and developed Compensation Trial by year - Comp Plan Management multiple cells editable grid and File Import Functionality using ASP.net, Vb.net and Report Viewer Control to keep track of Revenue Management to control to analyze Revenue for YTD period for Revenue Management purpose.
• Created Various Web Application Module for single file as well as asynchronous File Upload.
• Created the front-end using Web Forms. All database queries were handled using ADO.NET. The application also required many stored procedures.
• Trouble-shoot and maintain the existing Application Code written in VB.net and Asp.net 4.0 and Java script.
• Data Grid View control is used with ADO.NET to manipulate the data and display the required information.
• Created the Master page of the Web Application.
• Trouble-shoot the Stored Procedure related to existing Application.
• Involved, working on database scripts, Store Procedures, View, Indexes, Functions and Linked Servers in Microsoft SQL Server 2008R2.
• Writing the new Business oriented Stored Procedure using T-SQL in Microsoft SQL Server 2008R2.
• Responsible for production support and maintenance of Application Modules.
• Created new SQL jobs in SQL Server Agent as well as maintained the existing scheduled jobs.
• Used Import Export wizard to keep the data transaction in sync between the Production and Development server.
• Automated many processes using SSRS and SSIS cutting down many hours of manual processing.
• Responsible for creating complex SSRS reports based on client specifications. Users can access them both as a web report as well as in PDF format using acrobat reader and MS Excel.
• SSIS an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading and exporting operations for application.
• Writing of Stored Procedure using Cursor, Loop, Nested Stored Procedures, and created Tables and Index’s.
• Carried rigorous testing of all functional and non-function features of the website before it goes into production.
• Involved in writing Cascading Style Sheets (CSS) for styles, and used them in ASP.NET Pages.
• Improved application stability through performance tuning and optimization.
• Created and automated Import Export process of the existing Application (ETL).
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Identify the repetitive problems in application and came up with the solutions to fix them.
• Maintains, creates, and monitors or observes various database processes.
• Used SQL Profiler to optimize the functionality.
• Monitors and validates that the various database backup operations are successful.
• Independently creates, modifies and implements complex database scripts.
• Independently investigates and resolves complex database issues.
• Monitor database schema for efficiency and disk space.
• Maintain Server Updates, Database maintenance, security, and Audit logs.
• Creates ETL Process to pull the essential sales Data on daily basis for reporting purposes.
• Keep RLDP front-end application code optimized and up to date with new data and Database changes.

Environment: VB.NET, ASP.Net 3.5/4.0, AJAX, C#, WEB Forms, ADO.NET, OLEDB, VS 2008/2010, Web Services, XML, XSL, XPATH, SOAP, UDDI, WSDL, HTML, UML, Teradata, SQL 2008-R2, Java Script, SSIS, SSRS, SSAS, SAP Business Objects web Intelligence Rich Client, MS Office 2003/2007/2010 , MS Visio 2002, Crystal Reports XI (R2),Windows XP/2003/NT/7/2012, Visual Studio 2008/2010.

Confidential, Peachtree City, Georgia

Sr. Software Engineer

Responsibilities:

• Involved in all Phases of the Software Development Life-Cycle (requirements, design, development, testing, release, support), utilizing multiple development methodologies, including OOD, Extreme Programming, Structured Programming and Database.
• Developed a Business Layer, which has all Business Validations using VB.NET
• Created the GADSL Reference File Import System to import yearly new Version update into the Database using ASP.net and VB.net and Java script.
• Designed and developed Interactive IMDS  Request Submission Form using Ajax Validation on User Login ID, mandatory field using Ajax Control Toolkit, ASP.NET 3.5, VB.net and Java script.
• Designed and developed Interactive IMDS  Submission Request Maintenance Web Application module using ASP.NET 3.5 and VB.net and Java script.
• Designed and developed Agile BOM and Warrant Upload System Web Application module using ASP.net and VB.net and Java script.
• Designed and developed Fault Codes Rule System using ASP.net and VB.net.
• Involved in Analysis, Redesign and define User Requirements sessions of the System development life cycle (SDLC).
• Designed and developed EICC (Electronic Industry Citizenship Coalition) Conflict Minerals Import System to import Multiple Files at a time using ASP.net, VB.net, Java script and Ajax Technology.
• Created EICC Review Screen to provide the current inventory of Database based on Parameter provided by the User.
• Created Various Web Application Module for single file as well as asynchronous File Upload.
• Created the front-end using Web Forms. All database queries were handled using ADO.NET. The application also required many stored procedures.
• Created the Part Screen Web Application Module to check the inventory of the Parts, Models and Suppliers in EBS Database with rich User Interface.
• Created the Supplier Audit Web Application Module to check the inventory of the OES (ORIGINAL EQUIPMENT SUPPLIERS) and OEMS (ORIGINAL EQUIPMENT MANUFACTURE’S) of each Part in the Database.
• Trouble-shoot and maintain the existing Application Code written in VB.net and Asp.net and Java script.
• Data Grid View control is used with ADO.NET to manipulate the data and display the required information.
• Created the Master page of the Web Application.
• Trouble-shoot the Stored Procedure related to existing Application.
• Involved, working on database scripts, Store Procedures, View, Indexes, Functions and Linked Servers in Microsoft SQL Server 2005.
• Writing the new Business oriented Stored Procedure using T-SQL in Microsoft SQL Server 2005 and Microsoft SQL Server 2012.
• Responsible for production support and maintenance of Application Modules.
• Created new Sql jobs as well as maintained the existing scheduled jobs.
• Used Import Export wizard to keep the data transaction in sync between the Production and Development server.
• Automated many processes using SSRS and SSIS cutting down many hours of manual processing.
• Responsible for creating complex SSRS reports based on client specifications. Users can access them both as a web report as well as in PDF format using acrobat reader and MS Excel.
• SSIS an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading and exporting operations for application.
• Writing of Stored Procedure using Cursor, Loop, Nested Stored Procedures, and created Tables and Index’s.
• Carried rigorous testing of all functional and non-function features of the website before it goes into production.
• Working on Database migration from Microsoft SQL Server 2005 to Microsoft SQL Server 2012.
• Involved in writing Cascading Style Sheets (CSS) for styles, and used them in ASP.NET Pages.
• Improved application stability through performance tuning and optimization.
• Handled the Import Export process of the existing Application (ETL).
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Identify the repetitive problems in application and came up with the solutions to fix them.
• Maintains, creates, and monitors or observes various database processes.
• Monitors and validates that the various database backup operations are successful.
• Independently creates, modifies and implements complex database scripts.
• Independently investigates and resolves complex database issues.

Environment: VB.NET, ASP.Net 2.0/3.5/4.5, AJAX, C#, WEB Forms, ADO.NET, OLEDB, VS 2008/2012, Web Services, XML, XSL, XPATH, SOAP, UDDI, WSDL, HTML, UML, SQL 2005/2008-R2/2012, Java Script, SSIS, SSRS, MS Office 2003/2007/2010 , MS Visio 2002, Crystal Reports XI (R2),Windows XP/2003/NT/7/2012,Visual Studio 2008/2010/2012.

Confidential, Atlanta, Georgia

.Net / BI Developer

Responsibilities:

• Involved in Analysis, Redesign and defined User Requirements sessions of the System development life cycle (SDLC).
• Involved in development, maintenance and user training of TMW/MRS Base Rate, Carrier Mail Merge and OSB Master Truck Rate modules.
• Developed a Business Layer, which has all Business Validations using VB.NET and C#.
• Automated many processes using SSRS and SSIS cutting down many hours of manual processing.
• Improved application stability through performance tuning and optimization.
• Created the front-end using Win forms. All database queries were handled using ADO.NET. The application also required many stored procedures.
• Assisted in the middle-tier design of XML, XSD’s, and XSLT’s for communicating data to and from database via Web Service.
• Developed and implemented different server controls, custom controls to provide the rich user interface reusability.
• Features like Typed Datasets, Data Reader and Data Adapter used to develop a Data Access Layer Using ADO.NET.
• Data Grid View control is used with ADO.NET to manipulate the data and display the required information.
• Used T-SQL SSEM to write Stored Procedures, Indexing and written database triggers for various operations.
• SSIS an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading and exporting operations for application.
• Assisted other technical staff working on .Net and SQL database objects like views, procedures.
• Designed and developed database tables required for possessing data to create extract files in the required format.
• Responsible for creating complex SSRS reports based on client specifications. Users can access them both as a web report as well as in PDF format using acrobat reader and MS Excel.
• Done various activities of SSRS like Publishing, Unpublishing the reports, providing rights to reports and controlling reports using SSRS Subscription.
• Involved in Formal Software Unit testing and Integration testing.
• Provided the Technical Documentation for User manuals, Training Plans and Installation Guide.

Environment: VB.NET, C#, WIN Forms, ADO.NET, VS 2005/2008/2010 , Web Services, XML, XSL, XPATH, SOAP, UDDI, WSDL, HTML, UML, SQL 2005/2008-R2, SSIS, SSRS, SSAS, TFS 2005, MS Office 2010, MS Visio 2002, Java Script, Crystal Reports XI (R2), Windows XP/2003/NT/7, Visual Studio 2005/2008/2010.

Confidential, Atlanta, Georgia

Programmer/ Analyst

Responsibilities:

• Involved in Structured Analysis, Structured Design and defined User Requirements sessions of the System development life cycle (SDLC).
• Extensively used Office Suite to provide Power Point Presentations, I/O definition Document and General Rule Document etc.
• Created the front-end using Win forms and Infragistic controls. All database queries were handled using the SQL in ADO.NET. The application also required many stored procedures.
• Developed components and user controls using VB.NET.
• Developed and implemented different server controls, custom controls to provide the rich user interface reusability.
• Developed a Business Layer, which has all Business Validations using C#.
• Assisted in the middle-tier design of XML, XSD’s, and XSLT’s for communicating data to and from database via Web Service.
• Features like Typed Datasets, Data Reader and Data Adapter used to develop a Data Access Layer Using ADO.NET.
• Data Gridview control is used with ADO.NET to manipulate the data and display the required information.
• Used T/SQL SSEM to write Stored Procedures, Indexing and written database triggers for various operations.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Assisted other technical staff working on .Net and ORACLE database objects like views, procedures.
• Used MSVISIO to generate E-R diagrams, Flow Diagrams and Non-Technical diagrams.
• Designed and developed database tables required for possessing data to create extract files in the required format.
• Responsible for creating complex SSRS reports based on client specifications. Users can access them both as a web report as well as in PDF format using acrobat reader and Ms-Excel.
• Done various activities of SSRS like Publishing, Unpublishing the reports, providing rights to reports and controlling reports using SSRS Subscription.
• Have worked with Cascading Style Sheets (CSS) for providing look and feel structure for the web pages.
• Involved in Formal Software Unit testing and Integration testing.
• Provided the Technical Documentation for User manuals, Training Plans and Installation Guide.

Environment: VB.NET, C#, WIN Forms, ADO.NET, VS 2005, infragistic controls 6.2, XML, XSL, XPATH, SOAP, UDDI, WSDL, HTML, UML, Oracle 10g, SQL/PLSQL Developer 7.0, TFS 2005, MS Office 2000, MS Visio 2002, Java Script, Web Services, Crystal Reports XI (R2), Windows XP/2003/NT/7

Confidential, McDonough, Georgia

Programmer/Developer

Responsibilities:

• Used MSVISIO 2002 to generate E-R diagrams, Flow Diagrams and Non-Technical diagrams
• Extensively used Office Suite to provide Power Point Presentations, I/O definition Document and General Rule Document.
• Participated in providing direct internal support within the framework of the team’s responsibilities.
• Created and deployed ASP.NET Web forms (Master Pages) Clients and Case Managers information using CSS, HTML and ASP.NET Server controls.
• Implemented Security using Forms Authentication.
• Developed a Business Layer, which has all Business Validations using VB.NET.
• Data Gridview Server controls are used with ADO.NET to manipulate the data and display the required information.
• Designed and developed database tables required for possessing data to create extract files in the required format.
• Used SQL programs in writing Stored Procedures, Indexing and written database triggers for various operations.
• Importing data from heterogeneous data sources like Excel, Oracle and ASCII text files to SQL server and populate the reports in Microsoft Excel.
• Assisted other technical staff working on ASP.Net and SQL Server 2005 database objects like views, procedures etc.
• Developed T/SQL functions and procedures to provide APIs for the front-end developers to manipulate the database efficiently.
• Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.
• Created weekly, monthly reports using reporting services.
• Reduced customer service calls by 40% by creating error handler, and analyzing user behavior to track down and obscure bug that was causing frequent errors.
• Migration of DTS packages to SSIS packages.
• Assisted in the middle-tier design of XML, XSD’s, and XSLT’s for communicating data to and from database via Web Service.
• Responsible for creating complex Crystal reports based on client specifications. Users can access them both as a web report as well as in PDF format using acrobat reader and Ms-Excel.
• Administered & Maintained Solving access, web security issues, Virtual directory allocation, and web application pointer.
• Have worked with Cascading Style Sheets (CSS) for providing look and feel structure for the web pages.
• Involved in Formal Software Unit testing and Integration testing.
• Provided the Technical Documentation for User manuals, Training Plans and Installation Guide.

Environment: VB.NET ASP.NET 2.0, ADO.NET, VS 2005, XML, XSL, XPATH, SOAP, UDDI, WSDL, HTML, UML, SQL Server 2005,SSRS,SSIS, VSS 2005, Acrobat Professional 8,MS Office 2000, MS Visio 2002, Java Script, Web Services, Crystal Reports, Windows XP/2000/NT.

Confidential

Programmer/Developer

Responsibilities:

• Articulated the use cases and documented the specifications.
• Involved in creating new articles and modifying existing articles for different tenet products
• Involved in tagging the articles for different products.
• Implemented Framework and developed action and form classes for User interface.
• Developed a Business Layer, which has all Business Validations using VB.
• Created and deployed ASP.NET Web forms vendor information using CSS, HTML and ASP.NET Server controls.
• Developed data access logic using ADO.NET.
• Used ASP to create the front-end screens for the module.
• Involved in development of presentation layer using ASP/VB and custom tag libraries.
• Involved in bug fixing.
• Used VSS for version control of the application.

Environment: HTML, VB, ASP, CSS, ODBC, SQL, VSS, ASP.NET, ADO.NET, C#, XML, XSL, XPATH, WSDL, HTML/DHTML, Windows NT