PROFESSIONAL SUMMARY:

• 17+ yearsof experience in Systems Analysis, Design, Development and Implementation of various applications includingWeb, n - tierandClient/ServerApplication development usingMicrosoft .NET Framework,.NET Core,C#.NET,ASP.NET, AJAX.net.
• Ability to migrate data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Extensive experience with T-SQL in constructingTriggers,Tables, implementingStored Procedures, Functions, Views and CTE’s.
• Expertise inVisual Studio.Netenvironment andMicrosoft .Net Framework up to 4.6/core.
• Strong knowledge and experience onobject oriented programming (OOPS).
• Knowledge and Experience in Setup, configuration& Maintenance of IIS and Active Directory.
• Expertise in all phases of software development life cycle: Insightful experience in project planning, designing application, formulation of deployment strategy and creation of software products as per client requirements.
• Excellent communication, analytical and interpersonal skills; ability to perform as part of a team as well as an individual contributor.

SKILL:

ASP.net VB.net SSIS SSRS AJAX WCF C# Visual Studio.Net ADO.Net XML DotNetNuke Visual Basic 5/6 ADO Access 97/2000/XP/2003 ASP COM/COM+ HTML SQL Server 7.0/2000/2005/2008 T-SQL Visual FoxPro Bilingual English Spanish read write and conduct business

WORK EXPERIENCE:

Confidential, Los Angeles, CA

Programmer

Responsibilities:

• Create and maintain websites using ASP.NET MVC - Bootstrap C#, multi threading, WebAPI, .Net Core. SQL Server 2014 (Views, Stored procedures, CTE’s).
• Use SSIS for ETL to import data from various different databases and files.
• Manage repositories using AWS CodeCommit.
• Setup and maintain AWS SQS and AWS Lambdas.
• Lead an offshore team of 4 developers and 1 project manager. Integrate with Workday and Concred.

Confidential, Temecula, CA

Programmer

Responsibilities:

• Created and maintained an intranet website using ASP.NET MVC - Bootstrap Angular 8, Bootstrap, KendoUI, C#, multi threading, WebAPI, .Net Core. SQL Server 2014 (Views, Stored procedures, CTE’s).
• Created ad-hoc reports in Tableau. Used SSIS for ETL to import data from various different databases and files.

Confidential, El Segundo, CA

Programmer

Responsibilities:

• Created and maintained intranet and client facing websites using ASP.NET MVC - Bootstrap, Angular 8, KendoUI, C#, multi threading, WCF, web services. .Net core. Entity Framework. Kestrel. SQL Server 2014.
• Created ad-hoc reports in SSRS.
• Used SSIS for ETL to import client data in various forms.

Confidential, Anaheim, CA

Programmer

Responsibilities:

• ASP.NET MVC - Bootstrap ), KendoUI, C#, multi threading, WCF, web services.
• Connected to both Ups and Fedex web services for tracking and creation of airbills.
• Create tables and stored procedures in SQL Server.

Confidential, Costa Mesa, CA

Programmer

Responsibilities:

• Maintain ASP.NET websites using vb.net.
• Create and maintain web services using vb.net.
• Create web services using vb.net. Maintain and setup websites in IIS.
• Use front end tools like Angularjs (JavaScript/jquery) and bootstrap to connect to web services and serve dynamic content.
• Convert classic ASP websites into ASP.net websites.
• Create tables and stored procedures in SQL Server.

Confidential, Anaheim, CA

Programmer

Responsibilities:

• Maintain ASP.NET websites using vb.net.
• Create new and maintain winforms applications using vb.net and SQL server 2008.
• Create and maintain console applications using vb.net.
• Create and maintain web services using vb.net.
• Create WCF services using vb.net.
• SSIS to load and transform data(ETL) from files into SQL server.
• Maintain and setup websites in IIS.
• Used SSRS to create and distribute reports.
• Used Kofax for document indexing.

Confidential, Cerritos, CA

Programmer

Responsibilities:

• Maintain ASP.NET sales website using vb.net and ajax.
• Maintain the production and non-production software environments including Microsoft Internet Information Server (IIS), Microsoft SQL Server 2008 and Windows Server.
• Designed web services to connect to Salesforce.com database using c#.
• Create SSIS packages (ETL) to pull data from Salesforce.com using custom web services.
• Maintained Access databases and used VBA to add new features.
• Created and maintained winforms application using vb.net.

Confidential, San Diego, CA

Lead Programmer

Responsibilities:

• Write complete ASP.NET applications with vb.net, including the databases and performs functional testing to ensure adherence to documented requirements and specifications.
• Design, builds, tests and implements normalized SQL databases, including their stored procedures, functions and triggers, based on the requirements and specifications gathered in the project documentation, including maintenance plans, jobs and procedures required to keep the application in peak condition.
• Prepare and install solutions by determining and designing system specifications, standards, and programming. Write T-SQL queries on-the-fly to answer critical business questions under tight deadlines.
• Manage the production and non-production software environments including Microsoft Internet Information Server (IIS), Microsoft SQL Server 2008 and Windows Server.
• Maintained Access databases and used VBA to add new features.

Confidential, Chatsworth, CA

Lead Programmer

Responsibilities:

• Design new components using OO design methodology.
• Implemented business logic as .NET Framework assemblies (VB.NET) Define the hierarchy of classes to in corporate the business logic and implemented key components using web forms.
• Create services in WCF for data transfer to vendors.
• Create sophisticated SQL Server database to responsively handle complex queries (T-SQL, SSIS, triggers, stored procedures, functions, optimization) and .NET data access components.
• Create Web Forms using ASP.NET, MS Visual Studio .NET, VB.NET and C#.
• Perform business and system analysis. Design application and database structure.
• Create reports using SSRS.
• Created a survey application pulling different clients based on their account type using SSIS.
• Modified older programs in VB6, Access and VBA.

Confidential, Los Angeles, CA

Programmer

Responsibilities:

• Using visual studio tfs, created and maintained a vb.net/asp.net application programmed using entity framework and linq to entities used for wire transfer and other online banking services.
• Connected to WCF services for account online services.

Confidential, CA

Lead Programmer

Responsibilities:

• Design new components using OO design methodology.
• Implemented business logic as .NET Framework assemblies (VB.NET/C#)
• Defined the hierarchy of classes to in corporate the business logic and implemented key components using web forms.
• Created services in WCF for data transfer between stores and corporate.
• Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, SSIS, triggers, stored procedures, functions, optimization) and .NET data access components.
• Created Web Forms using ASP.NET, MS Visual Studio .NET and VB.NET.
• Performed business and system analysis, designed application and database structure.
• Created and maintained reports in Crystal and SSRS.
• Created a backend bakery ordering system (ftp order files) using SSIS (ETL).

Confidential, Cerritos, CA

Programmer/Software Engineer

Responsibilities:

• Designed, developed and implemented the modules for many applications using web forms and windows forms all in .net 3.5.
• Developed wcf services to be implemented as business logic for many applications.
• Maintained legacy system in VB6 and added new functionality as needed.
• Defined the hierarchy of classes to in corporate the business logic and implemented key components using web forms.
• Created services in WCF.
• Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, SSIS, triggers, stored procedures, functions, optimization) and .NET data access components Gathered requirements for creating new reports in Crystal 11 and SSRS.
• Created Web Forms using ASP.NET, MS Visual Studio .NET, VB.NET, XML, VBScript, HTML, DHTML, CSS, JavaScript and AJAX.
• Performed business and system analysis, designed application and database structure, designed in UML the structure of three-tier solution.
• Helped in formulating the business case for the site, designed the logical and physical structure of the application.
• Design new components using OO design methodology and document the OO design using the UML.
• Implemented business logic as .NET Framework assemblies (VB.NET).
• Converted existing data into SQL Server using SSIS (ETL). Programmed HIPPA compliant applications.
• Used SSIS to created a dialysis trip scheduler for patients.