EXPERIENCE 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 effectively.
• 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 knowledge 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.
• Created complex reports using SQL Server and SSRS and then 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

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 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.
• 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.
• 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 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.
• 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

Developed

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. 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.
• 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. 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.
• 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
• 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

Confidential, PA

EPHT

Responsibilities:

• Developed SSIS packages for exporting data from CSV, EXCEL files.
• Developed Complex reports (Tabular, Bar and Map) reports (for Cancer, Lead poisoning, Birth defects, Asthma, Heart Attacks, Carbon Monoxide) using SSRS2008 R2 and SQL Server.
• Designed and developed GIS reports for various counties within the PA state.
• Developed complex store procedures and user functions in SQL Server.
• Worked in a Scrum Agile process with two week iterations delivering new features and working software.
• Developed UI using ASP.NET, VB.NET.
• Integrated reports and Web Application.

Environment: SQL Server, SSRS, SSIS, WCF, VB.NET, GIS Reports, TFS, ASP.NET

State of Delaware Project

Confidential

Responsibilities:

• Confidential is a web site that allows individuals and community based organizations access to screen and apply for a broad range of social service programs like Long Term Care, Health Care Coverage, Food Supplement Program, Cash Assistance, Child Care Assistance, National School Lunch Program, Low Income Home Energy Assistance Program, Food Bank etc.
• Developed service gateway for the retrieval of information of status and corresponding details of cases from their mainframe using C#, WSDL.
• Developed service gateway to update the information of status and corresponding details of cases to their mainframe using C#, WSDL
• Designed and coded application components in an Agile environment utilizing a test driven development approach
• Developed the WCF (including the Data, message, Interface, service) to consume the data from the service gateway, update the corresponding SQL server tables.
• Developed LINQ queries to retrieve and update the data from the databases utilizing entity framework.
• Developed the Bus. Layer for the application.
• Created documentation.

Environment: SQL Server, SSRS, SSIS, WCF, VB.NET, ASP.NET

Sr.NET Developer/Lead

Confidential

Responsibilities:

• Worked on porting existing Internet/intra-net application to Portal(BEA AquaLogic )
• Created and maintained community pages and folders
• Worked on designing of the portlets
• Created Knowledge directory to organize files in the folders and sub folders which is updated/uploaded by users and web crawlers.
• Defined taxonomy to organize the knowledge directory to delegate administrative responsibility for the content and facilitate managed access with access control lists.
• Created Collaboration so that users can manually publish files into the Knowledge Directory (“KD”) by configuring the Collaboration Publishing Content Source.
• Created portals that will integrate with the portal to support the various business functions
• Configured and maintained work flow on folders in the Publisher component
• Configured and maintained security as established by project management leads using AquaLogic Community Concepts.
• Created portlet to bring DSF (Dynamic Site Framework ) in HTML to Aqualogic.
• Created Web Crawler to import content from an external content repository into the portal.
• Worked on Collaboration tools that helps to organize share and manage information on site
• Created AquaLogic presentation Templates
• Created and maintained the user documents for the Application

Environment: BEA Aqualogic. Portlets, Aqua logic Collaboration, Aqualogic Studio, SQL Server 2005,Web-services PL SQL, Store procedures, C#, Win Forms, Photo-shop, Web Methods, Store procedures, Microsoft Reporting Services, Visual Source Safe(Ver. 6.0), ADO.NET, VB.NET(2008), WINDOWS XP.