SUMMARY

• A Senior DOTNET Developer with Over 20 years of experience in design, development, implementation and testing of client - server, N-tier and web-applications across various platforms.
• Over 15 years of IT experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse.
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Extensive working experience in console, windows forms, web forms, windows services, web services and WCF.
• Experienced in development of ETL mapping and scripts.
• Strong understanding of data quality assurance processes and procedures.
• 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.
• Skilled at learning new concepts quickly, can work well under pressure and able to communicate ideas clearly and TEMPeffectively.
• Excellent team player with an ability to perform individually, good interpersonal and analytical skills
• Mentoring Junior team members

TECHNICAL SKILLS

Technical Skills: VB.NET, ASP.NET, C#, JAVA, WCF, WPF, Silverlight, Share Point, .Net, SQL Server, SSRS, SSAS, MVC, JQuery, 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 noledge of SAP Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Responsibilities:

• Migrated around 1200 Oracle Store programs to SQL Server platform.
• Fine-tuned the store procedure for better accuracy and speed.
• Created New functionalities using Dot net for the NEDSS Application.
• Made modifications in dot net for setting SQL Server instead of ORACLE.
• Created many SSIS packages for processing the data, data migration between oracle and sql server.
• Created New reports using SSRS.

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

Confidential

Team Lead/Sr. Developer

Responsibilities:

• Created complex reports using SQL Server and SSRS and tan projected to the user using VB.NET and ASP.NET.
• Created Store procedures and user-defined functions using SQL Server.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Created and used web services to process the data.
• Developed user friendly screens to projected data to the user using VB.NET and ASP.NET.
• Created web services and consumed it for the incoming data and outbound data processes.
• Performed Data Analysis and Data validation by writing SQL queries.
• Created indexes and modified existing store procedures for fastness and accuracy.

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

Confidential, Harrisburg, PA

Developed ETL processes using Store Procedures, PL/SQL

Responsibilities:

• 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 data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing
• Created Java Functions inside Oracle database and tan 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.
• Worked onPerformance Tuningof the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse
• Developed application to view the status of submissions status, submission history and sending emails reports to users (SMTP), created various reports using SSRS.
• PerformedData Analysis and Data validationby writing complexSQL queriesusing TOAD against theORACLE database.
• Maintained/updated system data flow chart, Visio documents, and system documentations
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• 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 Services.

Confidential

RCRA Handler

Responsibilities:

• 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.
• Designed for populating Tables for one time load andIncremental loads.
• Developed new Data Input forms using DOTNET and Reports usingSSRS.
• Created Java Functions inside Oracle database and tan 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.
• Maintained/updated system data flow chart, Visio documents, and system documentations
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• 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

Responsibilities:

• 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.
• PerformedData Analysis and Data validationby writing complexSQL queriesusing TOAD against theORACLE database.
• GeneratingEmail Notificationsthrough scripts that run in thePost sessionimplementations.
• Worked onPerformance Tuningof the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse
• Developed UNIX shell scripts to run the batch jobs.
• 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.
• Wrote SQL queries to perform Data Validation and Data Integrity testing.
• Implementation of client side validations using JQuery and ASP.NET MVC Validation implemented at Controller level
• 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, MVC, JQuery, VB.NET, Web Forms

Quality System

Confidential, Harrisburg, PA

Responsibilities:

• 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.
• Involved inPerformance Tuningof SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Implementation of client side validations using JQuery and ASP.NET MVC Validation implemented at Controller level
• 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. me.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.
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Done system integration with Team Foundation Server

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

Confidential

Sr .NET Developer/Lead

Responsibilities:

• 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,
• Implementation of client side validations using JQuery and ASP.NET MVC Validation implemented at Controller level
• Developing user friendly report modules using SSRS. me.e. Drill Down, Drill Through, Sub Reports, Charts, Table
• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Designed and developed GIS application for various universities comes under Confidential .
• 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, WCF, SSRS, SSIS, GIS, TFS, VB.NET, JQuery, MVC, ASP.NET, Web Forms

HR Systems

Confidential

Responsibilities:

• Designed and developed technical documents for the system
• Developed User Interface using ASP.NET, VB.NET, web services.
• Created Triggers to enforce data and referential integrity.
• Implemented MVC design pattern for developing the Web Application.
• Involved inPerformance Tuningof SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Designed and coded application components in an Agile environment utilizing a test driven development approach
• Created SSIS package to load data to SQL Server from different sources using SSIS.
• Created user friendly reports using SSRS.
• Done system integration with Team Foundation Server

Environment: SQL Server 2012, SSRS, SSIS, TFS, VB.NET,MVC, ASP.NET, Web Forms etc. All data is retrieved from MS Excel worksheets, information processing is completed and the same worksheet is updated with the most recent values.