CORE SKILLS:

• RWD (Responsive Web Design)
• Web pages for mobile / tablets / desktop applications
• Visual Studio 6.0/2003/2005/2008/2010/2013
• Web sites, web applications, web services, windows forms, RWD applications, computer programs using VB, VB.Net and C #
• ASP.net framework 2.0/3.0/3.5/4.0/4.5
• Web application development
• ASP & HTML
• Support & Migrations
• Access 97/2000/2007
• Desktop applications & MIS Reports
• Ajax.net
• UI enhancements with auto complete, hover menu, drag panel, pop up controls etc.
• Java Script
• Function & Validations
• Telerik Controls 3.0/4.0/5.0
• Rad control for UI (Grid, menu, window, Ajax manager etc.)
• Win forms VS 97/6.0/VS 2008
• Desktop, Client server & N’ tire applications
• CSS
• Bing Maps
• Style sheet for UI
• Dashboard and data entry screens
• C# VS 2003/05/08/10/12
• N’ tire business applications, Web services & WCF
• VB.net VS 2003/05/08/10/13
• N’ tire business applications, SSIS script tasks
• Visual Basic 5.0/6.0/9.0
• Desktop & Client server applications
• VBA
• Business logics in Access and Access reports
• LINQ
• Data access and business layers
• Sql Server 7.0/2000/2005/2008/2012/2014
• Design, Development, Administration, ER diagrams & DTS
• Access 97/2000/2005
• Desktop applications & MIS Reports
• SSRS 2008/2008 R2
• MIS reports using report manager & visual studio
• SSIS 2008/2008 R2
• Import / Export data, Script tasks, FTP task etc.
• DTS
• Import / Export data
• Crystal Reports
• MIS Reports
• Web Service VS 2008/2010
• Create/Consume information & Page methods
• WCF VS 2008/2010
• Hosting / Consuming organization information
• VB Script
• Scripting for performance monitoring tasks, System info & mailing
• Entity Frame Work 4.0/6.0
• Data access layer
• LINQ to SQL
• Data access layer
• Team Foundation Server 2008
• Installing, configuring, administration, source control, merging, branching & builds
• Visual Source Safe
• Source control
• SharePoint 2.0/3.0
• Installing, configuring and administration
• Enterprise Library 5.0
• Logging
• IIS
• Creating application pools, deploying applications & web site administration
• XML
• Web Services, Document read, Compare, Upload

TECHNICAL SKILLS:

Skills: SQL server 2008 / 2014 R2, ASP.net 4.5, VB.net, C#, SSIS, SSRS, Visual Studio 2013, Linq, Entity framework, JavaScript, CSS 3.0, Visual source safe 6.0, Team foundation server, Bing Maps V7, Responsive web design

Database: Sql Server 2008 R2 /2014

Data access layer: Entity framework with LINQ

Business layer: LINQ, VB.net & C#

Web forms: CSS 3.0, JavaScript, LINQ, VB.net, C#, ASP.net 4.5

Bing Maps: V7 Dashboard with pushpins plotted by given criteria and in data entry screens to plot locations.

SSRS reports: Management Information System reports.

SSIS packages: Legacy data migration from oracle using attunity for oracle.

Software development methodology: Agile

PROFESSIONAL EXPERIENCE:

Confidential, North Carolina

Technical Architect

Responsibilities:

• Designed a home page for drivers to view their deliveries and pickup
• Gives details of each stops like address and delivery / pickup time for the drivers
• On click of a delivery address it takes to a page which gives invoice details and record shortages if any.
• Signature panels to collect signatures of customer and drivers.
• Synchronization is scheduled to update the food distribution servers with data and signatures from local database.
• Created web services and stored procedure for synchronization process.
• Created reports in SSRS as per user requirements.
• Enhanced ware house tablet by adding a history tab to view previous loadings for store clerk.
• Fixed the issue of check box images randomly appearing on screen.
• Fixed the issue of multiple invoices for same agency by filtering by date time of delivery.

Confidential, Raleigh, NC

Sr. Developer

Responsibilities:

• Designed database in sql server 2008 R2 and created relationships with different entities.
• Created data access layer using entity framework.
• Used function imports and complex types in business layer.
• Responsive web pages for desktop and mobile devices.
• Used media queries to customize the web pages for smaller mobile devices.
• Using SSRS created contracts, invoices, failure notices and other reports.
• Data conversion form excel to sql server and mapping fields to new tables.
• Used CSS 3.0 style sheets for web pages.
• Weekly meetings with project manager and business owners to review the progress of the project, get feedback from testing and update requirements if any.
• Converted application from VB.net to C#.net in Jan 2016.
• Reviewed the existing business requirements with the NCFS business owners to develop a clear understanding of the requirements.
• Made modifications to the application design documents wherever necessary due to change from static web pages to responsive design for mobile, tablets and desktop devices.
• Reviewed the current application and database design for conversion to sql server.
• Designed and developed database in sql server 2008 taking the legacy data into consideration and also the new business requirements.
• Created CSS stylesheets for containers, grids and other controls for standard layout and maintenance.
• Created dashboard to review the status of fire records entered by users filtered for each user role and status.
• Designed fire map page In - cooperating it with GIS to record the point of origin and map the fire using web services and JavaScript.
• Used land owner parcel data returned from web services to search database for existing customers and rank them on 0-100 scale and display the most relevant information in a grid.
• Using JavaScript and server code added validation to controls and button submit to enforce business rules and data integrity.
• Created web pages to record the landowner information’s, impacts of the fire, personnel and equipment’s used in the fire, determine the cause of the fire, record responsible party, charges and court actions taken on responsible party.
• Programming to detect the completion status of each record and display it on the concerned users dashboard based on their status and role.
• Debugging and fixing code based on the test cases prepared from business requirements.
• Created SSIS packages for migrating data from oracle database to sql server(legacy data from 1970)
• Mapped legacy data fields to new database and created management reports to view data from legacy and current database into a single report.
• Created several reports in SSRS according to the user requirements.
• Document vault to store final snap shot of fire report in pdf as images in the database.
• Weekly meetings with project manager and business owners to gauge the project progress and present software deliverables for review.
• Converted application from VB.net to C#.net in Jan 2016
• Designed tables and created relationship with different entities.
• Using bing maps V7 created a dashboard to display event locations on map using pushpins.
• Pushpins on click displays information of the event and a clickable link to the data entry / view page.
• Map zoos to user county and pushpins are color coded based on event status.
• Using bing REST services get longitude and latitude from address and plotting points on the map.
• Drag and drop pushpins for users to plot points on the map.
• ASP.net calendar control to display events on the calendar and a customized day cell with the information of the event and clickable link to that event.
• Document vault to store images of events and other documents.
• Data entry screens to record event details, school presentation data, service request and attendance.
• Master grids with child grids to schedule staffs for the events and record staff duty time.
• Created user / management reports in SSRS as per requirements.
• Designed and created new tables in the shared database and created entity relationship with other tables.
• Used geometry and geography fields to accommodate the spatial data,
• Created dashboard using Bing map v7 to display pests affected area with color coded pushpins for pest type.
• Pushpin info box to display date, county, requester etc. and a clickable link to the record.
• Using Bing map REST services get address information from the plotted point on the map.
• Using java script and REST services plot points on map using given address.
• A single dynamic data entry screen with validations and fields enabled based on the data source (General observation, phone call, forest health assist, trap upload etc.).
• Admin utility to configure data entry screen and validations in the form.
• Java script and code behind validations for various business rules.
• Document vault to upload images.
• Created an asp.net page handler to display images inside a control with navigation buttons to move next and previous records.
• Wrote functions to check size and type of the image files and resizing it to thumbnail and also to a standard size.
• Used RedGate dependency tracker to find dependencies of tables and stored procedures before making changes.
• Search function based on date, status, pest type, host type etc. and display results in grid with thumbnail image.
• SSRS report with Bing map showing pest affected areas with statistics.

Confidential, Raleigh, NC

Sr. Developer

Responsibilities:

• Created ER diagrams and designed database in sql server 2008 R2 with the new requirements and data migration into consideration.
• Created several stored procedures & functions for data modification and queries for master table maintenance, funds, contracts, payment requests, refunds, cancellations and reports
• Used triggers to check excess payments, deletions and other updates.
• Used LINQ to query tables and then to insert, update and deletes.
• Grid views for displaying data and edit inline or using popup screen.
• Created several user controls to display and edit data.
• Bulk data entry for fund allocation by importing excel spread sheet with pre-defined templates.
• ASP.net web forms using CCS 3.0 making compactable with IE, Firefox, google chrome and safari.
• Java script functions to validate data entry on key up and text changes to reduce post backs.
• Linking BMP locations in the contract to google maps using the latitude and longitude values.
• Using style sheet for all labels, text boxes, buttons, grids, tables and all other controls to have a standard look and dynamically changing the color schemes for each day of the week.
• Progress bar inside the grid view for each contract to show the completed and uncompleted tasks.
• Progress bar for contract payments to show the total number of components, paid components and components for payments in one grid view cell. Also the grid shows the percentage paid with other details of contract
• Created a separate class for logging. Used reflection to get method name and other information to write to log files
• Used roles and membership database to implement security.
• Dynamically loading menu items based on user privileges.
• Created SSIS packages to migrate and transform data from oracle using oracle client and oracle connectors for SSIS.
• Created SSRS reports for statutory contract forms.
• Deploying code in development and production environment, documenting the application and knowledge transfer for technical support.
• Weekly meetings to gauge project progress and present software deliverables to the project team for review.

Confidential, Lakeland, FL

Sr. Developer

Responsibilities:

• Analyzing the requirements for cyber ark safe report
• Discuss with business owners & users and prepare entity relationship & UML diagrams.
• Created C# application to query active directory to get the group members and populating the sql data base, join the information in entitlement tables and prepare user privileges reports.
• Converted siteminder VB 6 project to VB.net
• Designed SSIS packages to import data from text files, transform data and uploading to sql server.
• Modifying MS Access VBA code to export data to excel.
• Supporting existing DTS, VB, C# and windows services in production environment.
• Promoting code in TFS using TFS builds from development, staging & production environment.
• Modifying existing VB code in DTS packages according to new user requirements.
• Creating scripts in Power Shell for deploying applications in staging and production servers.
• Used redgate sql compare to find changes in different database instances.

Confidential, Raleigh, NC

Sr. Developer

Responsibilities:

• Gathering requirements through business meetings for existing issues, UI modifications & prioritizing the tasks.
• Rewriting LINQ statements in recommendations module to load data and files separately by separating the events & changing the eager loading to improve performance.
• Reading XML files and comparing the lab instrument data with lab limits then displaying data in data grid and color formatting the normal, upper & lower limit values.
• Updating the contents in the recommendations (parent form) with the values from pop up form using java script call back function and page method.
• Developed new user controls for plant lab and used validation controls for validating data.
• Configuring and reading data strings from EC meter attached to the windows application and populating the text boxes with values from the meter.
• Modifying the key up event for tab control in windows form for nematode data collection to filter key values for alphabets and focus control on textboxes based on the key values without using mouse.
• Validating textboxes for numeric values only on key down event in windows data collection form by filtering key values.
• Fixing bugs / issues by troubleshooting errors by gathering more details of the error, getting screen shots, reproducing the error in test environment, stepping through the code, watching the values, testing values & correcting the code.
• Modifying functions & stored procedures to fix errors in application.
• Using query analyzer viewing the execution plan of stored procedure, analyzing each statement and modifying the statements.
• Creating reports for nematode & providing functionality to export it to excel for analyzing the nematode data per sample and to verify nematode counts by grouping it by lab technicians.
• Weekly meetings with business owners, demonstrating the achievements, discussing the outstanding tasks, prioritizing the tasks & expected completions dates.

Confidential, Raleigh, NC

Sr. Developer

Responsibilities:

• Gathering information and Verifying the ER diagrams and design documents with business analysts and users
• Creating entity model and relationship from Sql database
• Creating business layer for patients, vitals & glucose.
• Created UI for entering critical values for glucose and vitals using asp.net, C#, user controls and Telerik rad controls.
• Created new functions and complex types in entity framework for stored procedures and tables.
• Validating data input and using rad Ajax controls for updates without post back.
• Created several SSRS local reports for patient reports and administrative reviews.
• Unit and regression testing UI for various modules.
• Used Java script, added attributes and user controls for adding and editing forms for various modules.
• Designed search screens to find patients with several criteria’s and combinations.
• Writing LINQ queries to add, update and delete records from tables.
• Writing LINQ queries to select records from multiple tables using joins and select new subset of records from the list.
• Used cascade style sheets (CSS) for uniform look for web pages.
• Used java script to call server based methods using web methods to avoid a post back and page refresh.
• Created services using WCF to transfer vehicle & driver data between various agencies.
• Created methods for reading XML files and importing data into the database.
• Master Entity Index(MEI): Created scripts to transfer records from other entity’s (person & vehicle information’s) from other data sources to master index database, updating the data with vehicle manufactures databases and linking data with person and vehicle records.
• Creating full text search queries for querying person and vehicle information from master entity table optimizing the indexes for full text queries.
• Created SSIS packages for transferring data from several text files into Master Entity Index database and analyzing data for errors.
• Created stored procedures to add data to the repository database using web services.(XML & C#)
• Worked with the development team in trouble shooting performance issues using Sql query analyzer, Sql profiler and system monitor.
• Rewriting stored procedures and functions after reviewing the execution plan to improve performance.
• Prepared technical & functional documents for support and maintenance team.
• Weekly meetings with solution architect, project manager and team members and prioritizing the outstanding tasks.

.Confidential, Raleigh, NC

Sr. Developer

Responsibilities:

• Designed web forms using asp.net 3.5 and telerik controls for adding, editing and deleting records from grid. Users could edit each row or select multiple rows and edit or add records from a popup form.
• Created procedures using linq and vb.net 9.0 for verifying data according to the user requirements and business rules and updating the data with business and data access layers.
• Created data entry screen and validating the control using validation controls and updated data using web services.
• Created web forms to display summary of work list with telerik controls with add, edit, delete and filtering capabilities.
• Created user controls and used java script to add/edit records to reduce post backs
• Preparing reports for various labs using crystal reports.
• Wrote LINQ queries for data modification.
• Writing LINQ queries for selecting records and applying conditions and deriving several record sets for display in gridviews, dropdown boxes & lists.
• Used Java script functions, callback and page methods to update database and select values without post back and page refresh.
• Created windows forms for data entry for soil ammonium, EC, soil skalar, solution skalar, nitrates, organic matter with laboratory equipment interfaces and importing data from excel and test files, validating the data and transferring to the data base.
• Created windows forms for Nematode lab and capturing data using specifically assigned keys using key codes and disables other keys in the key board using key codes and key press events.
• Created windows forms with windows explorer like tree view, populating the nodes with group items and on drill down displaying the details in a grid on right side. Users could then add or edit each item in the grid or in bulk.
• Created data grids for displaying records and formatting it with various colors for different criteria’s and enabling and disabling cells based on given conditions.
• Used VB script to transfer files from various instruments to sql server databases.
• Designed tables and created relationships for capturing data according to the business requirements.
• Created stored procedures and user defined functions for adding and editing data.
• Automated recommendation: Created a procedure to calculate threshold, hazard index and give an automated recommendation based on the calculations and results to the Agronomists.
• Created reports as per user requirements for various labs.
• Import / Export excel / text files from various instrument readings using VB.net

Confidential, Rochester, NY

Developer

Responsibilities:

• Migration of Excel VBA & VB applications to .net. Used asp.net and grid views to replace excel sheets with VB connections to sql database
• DTS packages to SSIS packages. Replaced Active X components in DTS packages with SSIS script task and used file/db connectors to import/export data
• Used VB script to transfer files from legacy system to sql server databases.
• Modifying custom windows services and uninstalling and installing on new servers.
• Changed HTML tables in asp application s to use asp.net and grid views
• Migration of applications from ASP to ASP.net and IIS 5.0 To IIS 7.0
• Created application pools in new windows server, application pool identities, assigned appropriate permissions in local security policy - user rights assignments
• Moved applications from windows 2000 server to 2008, created virtual directories, setting permissions and troubleshooting issues with the IIS and application,
• Created Sql pass through queries and linked access databases to sql server for querying and reports.
• Prepared work flow and functional documents for SSIS packages for support team.