Experience Summary

• A Senior .NET Developer with Over 24 years of experience in design, development, implementation and testing of client-server, N-tier and web-applications across various platforms.
• Extensive working experience in console, windows forms, web forms, windows services, web services and WCF.
• Extensive experience in Relational Database Management systems.
• Extensive experience with Object Oriented Analysis and Design
• Extensive experience with SQL, PL/SQL, T/SQL, Stored Procedures, Triggers, Views, Materialized Views, Types and RDBMS Concepts.
• Extensive experience in SSIS, SSRS, Crystal Reports.
• Worked upon different roles such as Developer/Senior Developer/Lead Developer.
• Expertise in design and development of various applications in diverse industries.
• Diverse technology experience DOS, UNIX, LINUX, Windows, Pro C, COBOL, VB, FoxPro, C, C , ASP.NET, VB.NET, T/SQL. PL/SQL and UML.
• Team player with strong interpersonal and communication skills.
• Mentoring Junior team members
• Experience in documenting technical facts in a way a business user can understands.

Technical Skills

VB.NET, ASP.NET, C , JAVA, WCF, WPF, Silverlight, Share Point , .Net, SQL Server, SSRS, VSS, C, Aqua logic, Web Services, Custom Controls, COBOL,VB6, Clipper, SSIS, FoxPro, SDK, ORACLE, Crystal Reports, Visio, WINDOWS, UNIX, RS 232, Commerce Server, Internet Technologies.Very good knowledge of SAP Business Objects.

Employment History

Confidential

Sr. Developer / Lead

• Created services in OpenNode2 to process the above data using RCRA XML Schema so that the processes get automated.
• Developed ETL processes using Store Procedures, PL/SQL, and Functions to load data from various data sources to the staging table and automated it using Oracle Cloud.
• Created Java Functions inside Oracle database and then called by store procedure and functions to processes the data according to the business rules.
• Developed shell scripts and services for Oracle Cloud/Grid for automating the loading Bi-weekly the staging tables using the developed scripts and setup automated emails.
• Developed application to view the status of submissions status, submission history and sending emails reports to users SMTP , created various reports using SSRS.
• Created functions to unzip zip file s and parse file to get the submission details through VB.NET.

Environment: Oracle 12c, Oracle Cloud/Grid, Shell Scripting, Java, OpenNode2, SSIS, TFS, VB.NET.

Confidential

• Developed ETL processes using Store Procedures, PL/SQL, Functions to load data from various data sources to the staging table using OpenNode2 and RCRA Handler Standard.
• Created services in OpenNode2 to process the above data using RCRA Handler XML Schema so that the processes get automated.
• Created Java Functions inside Oracle database and then called by store procedure and functions to processes the data according to the business rules.
• Developed shell scripts and services for Oracle Cloud/Grid for automating the loading weekly the staging tables using the developed scripts and setup automated emails.
• Developed application to view the status of submissions, how many records processed, rejected etc. and sending emails reports to users SMTP , created various reports using SSRS.
• Created functions to unzip zip file s and parse file to get the submission details through VB.NET.

Environment: Oracle 12c, Oracle Cloud/Grid, Shell Scripting, Java, OpenNode2, SSIS, TFS, VB.NET.

Confidential

• Developed ETL processes, stored procedures, functions, PL SQL, views using Oracle 12c, Java to develop DEP's data warehouse for the FRS system.
• Created services in OpenNode2 to process the above data FACID 3.0 XML Schema so that the processes get automated.
• Created Java Functions inside Oracle database and called by store procedure and functions to processes the data according to the business rule.
• Developed shell scripts and services for Oracle Cloud/Grid for automating the loading Bi-weekly the staging tables using the developed scripts and setup automated emails.
• Developed application to view the status of submissions, how many records processed, rejected etc. and sending emails reports to users SMTP , created various reports using SSRS.
• Created functions to unzip zip file s and parse file to get the submission details through VB.NET.

Environment: Oracle 12c, Oracle Cloud/Grid, Shell Scripting, Java, OpenNode2, SSIS, TFS, VB.NET, Web Forms

AQS Air Quality System

• Developed functions. Store procedures to create and refresh the AQS Data for Lead, PM 1.0, PM 2.5. CO etc.
• Created mapping using Map Force to create the XML

Environment: Oracle 12c,PL SQL, Store Procedures, Functions Map force.

Oher works

Modified many store procedures/ Functions for porting from Oracle 11g to Oracle 12c.

Confidential

• Designed and developed technical documents for the system
• Developed User Interface using ASP.NET, VB.NET, web services.
• Converted existing modules from VB6 to Dot net.
• Created dynamic menu using XML.
• Developed complex stored procedures and user functions in SQL Server.
• Created SSIS Package to load data from Flat File, EXCEL to SQL Server 2012 using Lookup, Derived Columns, Condition Split, Term Extraction,
• Developing user friendly report modules using SSRS. i.e. Drill Down, Drill Through, Sub Reports, Charts, Table
• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Examined functional requirements by collaborating with external and internal customers.
• Developed Data access layer DL implemented using VB.NET with SQL Server 2012 database by creating functions, triggers and stored procedures in T-SQL.
• Done system integration with Team Foundation Server

Environment : SQL Server 2012, SSRS, SSIS, TFS, VB.NET, ASP.NET, Web Services, XML, Web Forms, Win forms

Confidential

• Designed and developed technical documents for the system
• Developed User Interface using ASP.NET, VB.NET, web services.
• Developed complex stored procedures and user functions in SQL Server.
• Created SSIS Package to load data from Flat File, EXCEL to SQL Server 2012 using Lookup, Derived Columns, Condition Split, Term Extraction,
• Developing user friendly report modules using SSRS. i.e. Drill Down, Drill Through, Sub Reports, Charts, Table
• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Examined functional requirements by collaborating with external and internal customers.
• Developed Data access layer DL implemented using VB.NET with SQL Server 2012 database by creating functions, triggers and stored procedures in T-SQL.
• Done system integration with Team Foundation Server
• implemented MS SQL Server Security and database permissions

Environment : SQL Server 2012, SSRS, SSIS, TFS, VB.NET, ASP.NET, Web Forms