Design And Development Team Resume
Charlotte, NC
SUMMARY
- 12+ years of full life cycle software development & engineering in Singapore, UK, India & USA
- Excellent communication, interpersonal, management and problem - solving skills.
TECHNICAL SKILLS
Internet: .NET 4.5, ASP.NET, ADO.NET, C#, VB.NET, SOA, Windows Services, Web Services, IIS, MTS, XML, XSLT, XPATH, XSD, DHTML, VBScript, JavaScript, Visual Studio.NET 2017.Visual Basic 6, Crystal Reports/Enterprise 10, VBA(Excel/Outlook), TFS, Git.
RDBMS: PL-SQL/Oracle11, Sybase12, T-SQL/MS SQL Server 2016, Access, Informix7, SSIS/SSRS.
Latest: Active Directory, XML RPC, Acrobat PDF SDK, XSD Schema, Entity Framework, WCF/WPF, SOAP/REST, AJAX, LIS/HL7, LINQ, JSON, Jquery, WEB API 2, MVC 5, Developer Express, Connectship/ Progistics UPS. GIT, Ruby, SASS/SCSS, Foundation/Bootstrap Responsive design, Interwoven, MS Make, Altiris WISE, Telerik, PDF4NET, DataPathExpress, AutoSys.
PROFESSIONAL EXPERIENCE
Confidential
Design and development team
Responsibilities:
- Website - Added new and enhanced existing web pages using WebForms, C#, ASP.NET in Visual Studio 2017. Generated reports and emails to users in Outlook.
- Database - Altered & added stored procedures, tables & views using SQL Server 2016/T-SQL.
- Windows Services - Altered existing windows services created using C# and run in conjunction with T-SQL Stored Procedures stored in DataStores.
- Jira - Handled stories using Jira for Issues, bugs and enhancements and discussed them for each sprint in an agile environment. . Created design documents and got approval before sprint.
Confidential
Design and development team
Responsibilities:
- Design - Involved in the overall design of the web portal with the team.
- Development - developed the database side of webportal using SQL Server and T-SQL.
- Created tables, stored procedures, functions, views and other objects in SQL Server 2012.
Release management team
Responsibilities:
- Development - Made changes to WinForms and Web Pages using ASP.NET and C#
- Altered Stored Procedures, tables and views in Oracle/SqlServer.
- Altered reports in SSRS, Excel and PDF that reflected the new changes made to application.
- Logged issues in PAC 2000 & JIRA, discussed in SPRINTs following AGILE methodology.
- Scheduled Jobs using Autosys and SQL Server Agents for import/export of data.
- Managed versions/repository - SVN, Artifactory, AHP, CodeStation.
- Monitored logs - Splunk, BIL Viewer.
- Monitored/Tested system health checks using tools like - SoapUI, AppDynamics, Wisdom etc.
- Used Change Management and Incident Management tools - Jira, BMC Remedy.
- Used deployment tools - SOA Admin Console, Widom, Udeploy
Confidential, Charlotte, NC
Developed modules
Responsibilities:
- Developed and designed reports using DataPath Express, SQL Server 2012 and Excel.
- Scheduled reports using AutoSys and coordinated with cognos team.
- Fixed issues and altered functionality for the MiSys/LoanIQ application using SQL Server 2012.
- Provided research and results of unexpected/missing data using SQL Server 2012 and Oracle.
- Code deployment across the project landscape (CIT, UAT & PROD) managed by TFS.
Confidential
web applications
Responsibilities:
- Portal - Designed/planned my own ecommerce portal for first few months.
- Websites - Enhanced websites using ASP.NET, MVC, WCF, WPF, SCSS/CSS, C#, JQuery, JSON, AJAX, bootstrap, Entity framework, Dev Express etc.
- Dynamic Data Web API - Developed a Web API in Visual Studio 2013 using Web API 2 in an MVC 5 model to return SQL Server data using REST in JSON format displayed using Jquery.
- Web API Wrapper - Designed and developed a DLL Library plug-in using C# and RestSharp to build a wrapper for Web APIs using REST concept exchanging data using JSON format.
- Windows Service - Created a Windows Forms & Service with C#, ADO.NET, SQL Server, Oracle, SSRS that migrates different file types (Excel, Text, Tabbed, CSV, Multiple) to a database. Developed a module to create, map and schedule these formats. dis simulates SSIS.
Confidential
Developed modules
Responsibilities:
- Data Generation - Designed/developed scheduled tasks for Fund Info Processing & Reporting that managed data using SSIS packages, SSRS and SQL Server 2012 Stored Procedures.
- Website - Designed and developed webpages to create and alter commentaries, bulletins, sectors and attribution labels using C#, ASP.NET, AJAX, WCF, WPF, Javascript, JSON, Jquery, Oracle 11 and SQL Server. Connected 2 parts of a system together (ASP.NET web pages and PLSQL/TSQL database objects) from 2 different teams.
- Developed a win forms app to input products, customers & suppliers & generate invoices and reports using .NET, C#, SQLServer/Excel Files & Acrobat PDF SDK, SOAP, XML
- Added functionality to also input, store, process, reports, weight & ship products using the Connectship/Progistics UPS SDK. Generated the print slips with bar codes, scan codes, name, address and other info
Confidential, MA
Software Developer
Responsibilities:
- Data Migration - Processed input data from LIS flat files or HL7 standards and migrate them initially to Access and finally to SQL Server using C#, ADO.NET, Windows forms and service.
- PDF Report Generator - Designed and developed an application that moved patient information from database to XML files and PDF reports using PDF/Acrobat SDK toolkit, C#, ADO.NET, ASP.NET, WCF, SQL Server Stored procedures and Windows Forms and Services.
- SFTP downloader - Designed and developed a service using C#, ADO.NET that downloaded zip files using SFTP from a remote server and bulk loaded them into SQL Server tables. Generated reports thru stored procedures & views using BCP tool & SSRS to generate CSV/Excel files.
- SFTP uploader - Designed and developed a service using C# & ADO.NET that would generate XML and CSV files from the SQL Server database and then upload them to a SFTP server.
- Graphic Bubble Generator - Generated graphic image of a bubble with color, size and shade depending on input data from the database using Windows Forms and VB.NET for the app. eXceL 2 XML - Migrated data from Excel to XML files using C# and XSD Schema.
Confidential, Raleigh, NC
Fund Information Management
Responsibilities:
- Website Enhancement - Made enhancement related to change in business rules and data structure. Along with enhancements also designed and developed new modules.Developed new pages using ASP/ASP.NET, Javascriptand C#. Created DLL classes and object using C#.
- Oracle 11 PL\SQL programming - Designed and created tables, views, synonyms, stored procedures in packages using Oracle/PLSQL.
Complete System Automation
Confidential
Responsibilities:
- Email Automation - Designed and developed a Windows Forms & service using ADO.NET, Win Forms, C#, which converts text file from an input queue to PDF format using Acrobat SDK toolkit and emails them to users specified in the file and stores statistic in SQL Server 2008.
- Purchase Web Application - Designed/developed a e-commerce web application to add, approve, view and edit purchase requests for the company using ASP.NET, C#, Javascript, Web Form, Ajax, ADO.NET & Sql Server 2008. Emails were sent out to group leaders.
- ADU automation - Designed/developed a Windows Forms/Service using ADO.NET, C# & SQL Server 2008 to synchronize and update data between a legacy system and Active Directory.
Confidential
Software Engineer
Responsibilities:
- Web & Win Forms - Enhanced the website and windows modules using ASP/ASP.NET, Web Forms/Services in C#, Javascript, Telerik AJAX Rad and handled localization resource files.
- XML RPC - Designed and developed a application that shares data with a SOA web service using XML RPC to read remote info and report them using C# & XML.
- Email Blast - Developed a module with C# to fetch emails from Excel & SQL and send emails.
- Citrix Automation - Developed a system to automate manual Citrix operations.
- Acrobat - Designed/developed a product using C#, XML, Acrobat SDK to convert PDF file into pages of types pdf, gif, jpg, txt etc and alter the settings and reprocess the original output.
Confidential, MA
Data Processing
Responsibilities:
- PDF/Acrobat SDK Toolkit - Designed & Developed Windows Forms & Service to populate Adobe forms with SQL Server 2005 data, using Stored Procs, ASP.NET and C#. After creating the form, we can email, print or fax these adobe forms on a batch process or regular process.
- Websites - Added and altered modules to multiple e-commerce websites using ASP.NET, ASP, VBScript, Javascript, SQL Server 2005. Had to populate the database from excel and flat files..
- Automated Generation/Email of Excel Reports - Created an automated service that moved/processes XML data to SQL and reports them daily using C# & BCP utility with Excel.
- Data Analysis & Fix - Built a tool using C# to scan thru the tables of a selected SQL Server database to identify injected/defected columns. Displays and fixes the tables.
- SSIS Packages - Created reports and processes in DTS & SSIS packages. Scheduled them to run at regular intervals to process / store data from flat/excel files into the database.
Confidential
Reservation System
Responsibilities:
- Customized and enhanced the business objects using C#, ActiveX controls, Exes and Dlls.
- Altered and developed C#, Windows Forms & Sql Server stored procedures and triggers.
- Compiled using MS Make and created builds using Altiris WISE tool.
Confidential
Data Processing
Responsibilities:
- Enhanced the existing translating system using C# Windows Service and Win Forms,
- Created stored procedures in SybaseSQL Server and Informix to alter data and read data.
- Created sophisticated SQL Queries in SQL Server, Informix, Sybase and Oracle to retrieve missing or wrong data regularly to make data consistent and fix bugs on a regular basis.
- Converted a Win Forms application from VB6 to VB.NET with data retrieval from Oracle.
- Developed interface screen to accept input for report and schedule parameters using ASP.NET.
- Developed module to process and store data into SQL Server 2000 using ADO.NET.
- Developed two Active-X dll objects to specify time periods using mixed controls.
- Developed Stored Procedures, Cursors & Views using PL/SQL & T-SQL for both systems.
- Developed code to read/write data from SQL Server 2000 using C# and ADO.NET.
- Produced dynamic online forms with Adobe's FDF and .NET inter-operable capabilities.
Confidential, Andover, MA
Intranet & Tools Development
Responsibilities:
- Designed and developed a new web module using ASP, VBScript and SQL Server 2000.
- Developed a polling system using WebForms, Web Services, ADO.NET, VB.Net and ASP.NET.
- Developed module using WinForms in VB.NET and ADO.NET to extract data in different formats (Excel/ Oracle/ Sql) from international clients into the local SQL Server database.
- Developed a module to access teamsite/interwoven DCR files and process it using XML/XSLT.
Confidential, Framingham, MA
International Website
Responsibilities:
- Developed ASP pages to display data from an XML file in the XSL format using VBScript.
- Developed SQL Server 2000 stored procedures to read/write data from/to the database.
- Handled configurable XML data and formatting XSL script using “interwoven” tool.
Confidential, MA
Menu Application
Responsibilities:
- Developed reports with ASP, Visual-Basic 6 & Crystal Reports/Enterprise v10.
- Created tables and views in SQL Server 2000, as part of the IT applications team.
- Developed cafeteria menu using ASP.NET, ADO.NET & C# to read/write from/to the database.
- Developed code in SQL Server 2000, Access and Lotus Notes nsf files.
Confidential, Natick, MA
Customer Self-Service
Responsibilities:
- Developed and maintained a timesheet administration and reporting module.
- Maintained and enhanced few older existing modules using ASP, VBScript and Javascript.
- Created webpages with ASP.NET, ADO.NET, C#, Excel VBA, actuate, crystal-reports and niku.
- Developed Views and Stored Procedures to retrieve data from the SQL Server 2000 database.
- Developed functions for auto generation of weekly reports using SQL jobs & DTS packages.
Confidential, Merrimack, NH
Software Engineer
Responsibilities:
- Hire - configured ASP page and Oracle 8 for multi clients with javascript/vbscript.
- Developed logic to control display content and how it would display and if mandatory or optional.
- Enhanced COM business objects using Visual Basic 6 as per enhancements and multi clients.
- Acquisition - Developed a new Acquisition module using ASP pages and Java object.
Confidential, Westborough, MA
IT Apps Lead Developer
Responsibilities:
- Developed modules VB6 to produce many Excel & Crystal reports from SQL-Server 7 .
- Developed Oracle stored procedures for a Lawson system connected to dis system.
- Developed ASP pages to display reports on the company website with ADO & VBScript.
- Redesigned website using ASP, CSS, VB 6 COM, VBScript, JavaScript & SQL Server 7.
- Developed a big module for noledge base search using ASP and a third party Fulcrum control.
- Developed E-Commerce module to register users for training and events with ASP & VBScript.
- Enhanced MS-Outlook messaging to add controls and functions using VBA Outlook and VB6.
- Developed modules to retrieve database content using ADO with SQL Server 7.
- Generated reports using VB 6 and Crystal Reports to report statistics.
Confidential, MA
Software EngineerResponsibilities:
- Developed code using Servlets, JSP pages, Java Classes, Java Beans & Oracle .
- Developed Java Classes and JSP/HTML interface using Visual Cafe.
- Enhanced localization & User Interface for different customers/clients using XML resource files.
- (A) Developed a tool to add/view/edit data from an XML resource file using XSLT/JavaScript.
- (B) Developed tool using Visual Basic 6 to generate and send E-Mails to multi recipients.
- (C) Developed tool to simulate the load/performance of multiple mobile users playing games.
- Developed Oracle PL-SQL stored-procedures to populate tables with test data.
- Developed administration web interface using D/HTML, ASP, JavaScript & VB 6 COM objects.
- Developed modules using ASP.NET, ADO.NET & C# & SQL Server 2000.
Confidential, Andover, MA
Software Engineer
Responsibilities:
- Generated web pages using JavaScript beans D/HTML, ASP & Java applet.
- Managed 7 language cross-browser-compatibility/localization versions using Clear Case.
- Developed modules with IIS Metabase Scripting to auto-configure virtual directory, filters & file.
- Created Windows Scripting Host scripts to read/write registry from ASP pages.
- Created ASP pages with HTML, VBScripts, Javascript, VB6 DCOM & SQL Server.
Confidential
Software ConsultantResponsibilities:
- Researched ActiveX dll/exe docs, DHTML & IIS and selected ASP with localization.
- Using ASP, VBScript & Javascript, VB 6 COM & SQL Server 6.5.
- SQL Server 6.5, VB 6, ActiveX Dll COM, Crystal reports & Excel VBA.