Programmer Analyst Resume
Walnut Creek, CA
SUMMARY:
- 13 - years of experience designing and developing high-level object-oriented .NET applications using C#, ASP.NET, MVC, AJAX, JavaScript, HTML and VB.NET.
- 16-years of SQL Server 2000, 2005, 2008, 2012, 2014, Azure operations and T-SQL and Strong experience of Analysis (SSAS), Integration, Reporting Services (SSRS) and SSIS package creation internally. 11-years of experience with Microsoft Access
- 5-year of experience designing WCF services ASP.NET Web API and with SOA.
- 4-year of experience designing Silverlight Clients.
- 7-years of experiences with LINQ and ADO.NET entities.
- 5-years of experience with ASP.NET MVC 3, MVC 4, MVC 5, .Net Core and HTML 5.
- Analyze business and technical requirements, as well as logical data and object oriented models for project and implement detail data management requirements.
- Experience with Software modeling tools such as MS Visio.
- Write AJAX and JavaScript code for Validation, Verification and Security Authentication.
- Design, develop and implement secure user login and roles for web interface.
- Extensive knowledge and experience with object-oriented concepts and methodologies.
- Developed and modeled object-oriented concepts using UML diagrams.
- Work with different designs patterns, such as Singleton, Observer, and Abstract Factories.
- Knowledge about packaging Microsoft application.
- Experience on migrating application from different windows OS versions.
- Work through the full SDLC methodology.
- Work with and within cross QA, Test and Production Teams.
- 16-years of experience with Visual Studio, Visual Studio Team Foundation Server, NET Framework and CLR. Currently working with Visual Studio 2013, 2015 and 2017.
- Configure, implement and set up IIS for different version of .NET.
- Configure, maintain and troubleshoot IPv4 and IPv6 and internet protocols.
- Highly proficient, with a deep understanding, knowledge and experience in the use of Object Oriented Methodologies.
- Develop classes, interfaces, assemblies, and work with design patterns.
- Manage and supervise a group of seven employees.
TECHNICAL SKILLS:
.Net Framework: C, C++, C#, VB.Net, Visual Basic 6.0/ .NET, ASP, ASP.NET, ASP.NET 4.0, ASP.NET Web API, ASP.NET Core, ADO.NET, AspDotNetStorefront, AJAX, MVC, MVVM Visual Studio 2010/2013 and 2017, Team Foundation Server LINQ, WPF, XAML, WCF, Enterprise Library, SOAP, .NET 4.0, .NET 4.5, .NET 4.6 and .NET 4.7, LINQ, Entity Frame Work, Silverlight, Borland, JavaScript, VBScript, Unit Testing, Avatax, MAS 90.
Database: SQL Server 2008/2012/2014, MS SQL Server Integration Service 2008/2012/2014, MS Access, Oracle, ODBC, FoxPro, Peopletools, PeopleSoft, Stored Procedures, Triggers, Queries, T-SQL
Reporting: SQL Server Reporting Service 2012/2014, SQL Server Analysis Services 2012/2014, Crystal Reports, MS Access, MS Excel, MS Office, Brio, Hyperion
Programming Languages: Java, JDBC, RMI, JUnit, Pearl, Scheme, HTML, HTML 5, DHTML, XML, Assembly Language, OPENGL
PROFESSIONAL EXPERIENCE:
Confidential
.Net Programmer
Responsibilities:
- Design and develop ASP.Net MVC5 Application using C#, jQuery.
- Implement web security with Identity and dependency injection design patterns.
- Write C#, asp.net MVC5 and Html5 code using Visual Studio 2015.
- Design and develop security interface and database for the MVC application.
- Design develop data access layer using Entity Framework and LINQ.
- Write and implement JQuery scripts and functions and data functions.
- Write SQL queries, stored procedures, data views and functions.
- Design and develop SSRS and XML reports.
- Write test and validation code.
Confidential
.Net Programmer
Responsibilities:
- Work on ASP.Net Applications using C#, jQuery
- Write C# and asp.net code using Visual Studio 2012.
- Find and fix bug and implement changes on assigned tickets and bugs
- Implement jQWidgets Web UI Widgets controls write jQuery code
- Writing and updating JSON queries.
- Write SQL queries DB2 to update application
- Run, test and validate code changes.
Confidential
.Net Programmer
Responsibilities:
- Work on LIGHTSWITCH Application using C#, Silverlight
- Write C# using Visual Studio 2012.
- Implement and write code to implement SSRS reports
- Gather requirements from the end user gather and implemented standard business rules.
- Install and setup web application.
- Write PSQL functions and queries to update application
- Run, test and validate ETL packages.
Confidential, Vancouver, WA
.Net Programmer
Responsibilities:
- Implement and create Asp.net Web Application using C# and VB.NET.
- Create C# Windows Form application for yearly and quarterly taxes.
- Write C# and VB.NET Code using Visual Studio 2008 and 2010.
- Implement and write code to consume WCF Services.
- Write AJAX and JavaScript code for Validation, Verification and Security.
- Gather requirements from the end user gather and implemented standard business rules.
- Model, design, develop and update database tables, stored procedure and functions.
- Write T-SQL functions and queries.
Confidential
.Net Programmer
Hardware/Software:Visual Studio 2008, Visual Studio 2010, ASP.NET 2.0, 3.5 and 4.0, AJAX, AspDotNetStorefront, MS SQL Server 2005, 2008, T-SQL, Visio 2010, Office 2010, Windows 7, Windows Server 2008, IIS, Sage Accounting Software, Avatax Service.
Responsibilities:
- Customize and install AspDotNetStorefront web application for numerous clients.
- Implement and create Asp.net Web Application using C# and VB.NET.
- Write C# and VB.NET Code using Visual Studio 2008 and 2010.
- Implement and write code to consume WCF Services.
- Write AJAX and JavaScript code for Validation, Verification and Security.
- Gather requirements from the end user gather and implemented standard business rules.
- Configure, implement and set up IIS for ASP.NET web application.
- Model, design, develop and update database tables, stored procedure and functions.
- Write T-SQL functions and queries.
- Implement business rules and write code to connect to Avatax web service and MAS 90.
Confidential
.Net Programmer
Hardware/Software: Visual Studio 2010, ASP.NET 4.0, AJAX, MS SQL Server 2008,, T-SQL, Oracle 10g, PL/SQL, Visio 2010, Office 2010, Windows 7, Windows Server 2008, IIS.
Responsibilities:
- Implement and write code to consume WCF Services.
- Implement and create Asp.net Web Application using C#
- Write AJAX and JavaScript code for Validation, Verification and Security.
- Write C# Code using Visual Studio 2010.
- Gather requirements from the end user gather and implemented standard business rules.
- Write technical requirement documents, design documents, testing documents, and software documents.
- Create object-oriented UML diagrams.
- Configure, implement and set up IIS for ASP.NET web application.
- Design data models and Entity relationship diagrams using MS Visio.
- Model, design and develop database tables, stored procedure and functions.
- Write T-SQL and PL/SQL functions and queries.
- Configure and setup IIS, IPv4 and IPv6 internet protocols.
Confidential
.Net Programmer
Hardware/Software: Visual Studio 2010 and Team Foundation Server, ASP.NET 4.0, Asp.net MVC 3, Razor Engine AJAX, MS SQL Server 2008, T-SQL, Visio 2010, Office 2010, Windows 7, IIS, Active Directory.
Responsibilities:
- Write AJAX and JavaScript code for Validation, Verification and Security.
- Write C# Code using Visual Studio 2010.
- Design, model and create user interface, write HTML, HTML 5, XAML and DHTML code.
- Gather requirements from the end user gather and implemented standard business rules.
- Write technical requirement documents, design documents, testing documents, and software documents.
- Implement and write code to consume WCF Services.
- Implement and write code to for role based and claim based security model.
- Create object-oriented UML diagrams.
- Configure, implement and set up IIS for ASP.NET web application.
- Design data models and Entity relationship diagrams using MS Visio.
- Model, design and develop database tables, stored procedure and functions.
Confidential
.Net Programmer
Hardware/Software: Visual Studio 2010 and Team Foundation Server, ASP.NET 4.0, AJAX, MS SQL Server 2008, T-SQL, Visio 2010, Office 2010, Windows 7, IIS, Telerick Controls.
Responsibilities:
- Write AJAX and JavaScript code for Validation, Verification and Security.
- Write C# Code using Visual Studio 2010.
- Design, model and create user interface, write HTML, XAML and DHTML code.
- Worked with telerick controls on Web UI.
- Gather requirements from the end user gather and implemented standard business rules.
- Write technical requirement documents, design documents, testing documents, and software documents.
- Implement and write code to consume WCF Services.
- Create object-oriented UML diagrams.
- Create N-tier front-end applications from queries and WCF Services for development hierarchies, file upload and validations using ASP. Net and C#.
- Configure, implement and set up IIS for ASP.NET web application.
- Design data models and Entity relationship diagrams using MS Visio.
Confidential,Vancouver,WA
Software Programmer
Hardware/Software: MS SQL Server 2008, MS Office 2010, Windows 7, Visual Studio 2008, Visual Studio 2010, Business Intelligent Studio, SharePoint, Oracle, Excel and MS Office.
Responsibilities:
- Write C# Code using Visual Studio 2008 and Visual Studio 2010
- Write HTML and JavaScript code NET 3.0, 3.5 and 4.0
- Develop source to target specifications for Data Transformation Services.
- Database algebra, Database Architecture and database schema.
- Work with Star and Snowflake Schema
- Write technical requirement documents, design documents, testing documents and software documents.
- Create SSIS packages data from different clients.
- Implement business rules.
- Create various Table and Views to ensure the increase performance of application
- Identify and correct data anomalies.
- Create drill-through reports and sub-reports to show necessary information using SSRS Crystal Reports, and Hyperion.
- ETL from MS Access, Oracle.
- Write Stored Procedures and Complex SQL Queries.
- Perform Quality Assurance Testing.
- Create data Cubes for SSAS Analysis.
- Write TSQL and Oracle statements.
- UI design and development.
- Notepad++
- Coding in JAVA
- Writing PL/SQL Scripts for Oracle data warehouse.
Confidential,Pleasant Hill, CA
.NET Developer
Hardware/Software:. NET 2.0, 3.0, 3.5, 4.0, LINQ, MS SQL Server 2008, MS Office 2010, Windows 7, Visual Studio 2008 and Team Foundation Server. Visual Studio 2010
Responsibilities:
- Write C# Code using Visual Studio 2008 Team Foundation Server
- Design and model user interface using ASP.NET.
- Gather requirements from the end user.
- Gather and implemented standard business rules.
- Setup and write connection strings.
- Add functionality to existing code.
- Modify and update SharePoint list.
- Prepare and implement test scripts.
- Write code to integrate and access data from SharePoint and SQL Server.
- Modify and update Asp user controls.
- Create three-tier front-end applications from queries for development hierarchies, file upload and validations using ASP. Net and Visual Basic .NET.
- Configure, implement and set up IIS, IPv4 and IPV6 internet protocol for .NET 2.0, 3.0, and 3.5.
- Use BIDS to create and launch SSR Reports to web.
- Write complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions.
Confidential,Sausalito, CA
Software Engineer
Hardware/Software:. NET 3.0, 3.5, MS Access, MS SQL Server 2008, SSRS, MS Word, MS Excel, Windows Vista, IIS 7.0, Windows 2003, C#, WCF, WPF, Silverlight, ASP.NET, Enterprise Libraries, SSRS, SOA, Source Safe
Responsibilities:
- Write AJAX and JavaScript code for Validation, Verification and Security.
- Write C# and Visual Basic .Net Codes using Visual Studio 2005, 2008.
- Design and model user interface using ASP.NET.
- Write HTML, XAML and DHTML code.
- Gather requirements from the end user.
- Gather and implemented standard business rules.
- Implement setup and write code for ODBC connections.
- Setup and write connection strings.
- Integrate code with Amazon S3 and Campaign Monitor API.
- Design, develop and implement secured user login authentication and roles for web interface.
- Prepare and implement test scripts.
- Create three-tier front-end applications for queries for development hierarchies, file upload and validations using ASP. Net and Visual Basic .NET.
- Configure, implement and set up IIS for .NET 2.0, 3.0, and 3.5.
- Use BIDS to create and launch SSR Reports to web.
- Created real time SSRS and Crystal Reports.
- Write complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions.
Confidential,San Lorenzo,CA
Software Developer
Hardware/Software:. NET 3.0, 3.5, MS Access, MS SQL Server 2008, SSRS, MS Word, MS Excel, Windows Vista, IIS 7.0, Windows 2003, C#, WCF, WPF, Silverlight, ASP.NET, Enterprise Libraries, SSRS, SOA
Responsibilities:
- Write AJAX and JavaScript code for Validation, Verification and Security.
- Write C# and Visual Basic .Net Codes using Visual Studio 2008, 2010.
- Write LINQ queries and build ADO.net Entities. Design applications using Silverlight.
- SOA service oriented application code using WCF.
- Working with SOAP protocols and configuring Endpoints, write contracts and bindings.
- Write code for WCF applications and work with Enterprise library.
- Design and model user interface using WPF and ASP.NET, HTML, XAML and DHTML.
- Gather requirements from the end user and implemented standard business rules.
- Database algebra, Database Architecture and database schema.
- Write technical requirement documents, design documents, testing documents, and software documents.
- Develop physical software models and created three-tier applications.
- Develop and implements MVC applications.
- Implement and write code for ODBC connections setup and write connection strings.
- Create object-oriented UML diagrams. Prepare and implement test scripts.
- Use different design patterns, the waterfall and spiral methodologies full SDLC.
- Design, develop and implement secured user login authentication and roles for web interface.
- Create three-tier front-end applications for queries for development hierarchies, file upload and validations using ASP. Net and C#.
- Configure, implement and set up IIS for .NET 2.0, 3.0, and 3.5. Deploy and launch ASP.NET web application.
- Configure, maintain and troubleshoot IPv4 and IPv6 and internet protocols.
- Use BIDS to create and launch SSR Reports to web and created real time SSRS and Crystal Reports.
- Design data models and Entity relationship diagrams using MS Visio.
- Write complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions.
- ADO.NET Entity Frame Work
Confidential,Oakland,CA
Systems Analyst /Database
Hardware/Software:MS Access, MySQL, MS SQL Server 2005, MS Word, MS Excel, UNIX, Windows NT, Windows 2003, IMS, Visual Basics.
Responsibilities:
- Create various Table and Views to ensure the increase security and application performance.
- Gather real time operation data to create flight, truck dispatcher and sort reports.
- Analyze operation data and provide real time operation updates.
- Normalize database using Boyce-Codd normal forms
- Work with Database algebra, Database Architecture and database schema.
- Work with Star and Snowflake Schema
- Write technical requirement documents, design documents, testing documents and software documents.
- ETL data from IMS to Microsoft Access to provide real time reports and reconcile data.
- Schedule jobs to streamline and automate cumbersome repeated tasks using MS Access.
- Gather and implement standard business rules. Quality Assurance Testing. UNIX Shell Scripting
- Input and ETL from the IMS UNIX mainframe and flight operation system.
- Write Visual Basic Scripts for Microsoft Access applications.
- Create SQL server and MS Access reports and graphs for the manager and the senior manager. Format report layout for the requirement of the end users.
- Write user requirement documents based on functional specification.
- Develop functions, views and triggers for automation. Software, data flow modeling, and work flow analysis.
- Create indexes, Constraints and rules on database objects for optimization.
- Provide system and network maintenance and update. Implement and Monitor TCP /IP.
- Responsible for database performance tuning.
- Direct and manage a team of seven people and train other employees
- Customer Service and vendor interaction.
Confidential,Walnut Creek,CA
Programmer Analyst
Hardware/Software: Visual Studio 2003, 2005, 2008 ASP.NET, AJAX, MS SQL Server 2000/2005, MS SQL Server Reporting service 2005 SSRS, MS SSIS, MS SSAS, DTS, FOX Pro, T-SQL, MS Access, Visio, Word, Excel, Crystal Reports, Windows Server 2003, Windows XP, IIS
Responsibilities:
- Write AJAX and JavaScript code for Validation, Verification and Security.
- Write C# and Visual Basic .Net Codes using Visual Studio 2003, 2005 and 2008.
- Design, model and create user interface, write HTML, XAML and DHTML code.
- Gather requirements from the end user gather and implemented standard business rules.
- Database algebra, Database Architecture and database schema.
- Write technical requirement documents, design documents, testing documents, and software documents.
- Develop physical software models and created three-tier and MVC applications.
- Implement and write code for ODBC connections.
- Setup and write connection strings, create object-oriented UML diagrams.
- Write user requirement technical documents based on functional specification.
- Use different design patterns, the waterfall and spiral methodologies.
- Design, develop and implement secured user login authentication and roles for web interface.
- Work through the full SDLC, using waterfall, and spiral methodology.
- Create three-tier front-end applications for queries for development hierarchies, file upload and validations using ASP. Net and C#.
- Configure, implement and set up IIS for .NET 2.0 and 3.0. Deploy and launch ASP.NET web application. Prepare and implement test scripts.
- Develop physical data models and create DDL scripts to create database schema and database objects, use BIDS to create and launch SSR Reports to web
- Design data models and Entity relationship diagrams using MS Visio.
- Write complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions.
- Develop source to target specifications for DTS and functions, views and triggers for automation.
- Create DTS/SSIS packages to schedule the jobs for batch processing for FOX PRO, Access
- Migrate and upgrade SQL SERVER 2000 /2005 database and DTS Package to SQL SERVER 2005. Create real time SSRS and Crystal Reports.
- Create indexes, Constraints and rules on database objects for optimization
- Performance tuning to optimize SQL queries using query analyzer.
- Add, and restore users logins and password to system database
- Schedule the jobs to streamline and automate cumbersome repeated tasks using SSIS.
- Normalize production database using Boyce-Codd normal forms
- Provide and implement database replication. Quality Assurance Testing.
- Create indexes, Constraints and rules on database objects for optimization.
- Create various Table and Views to ensure the increase performance of application
- Develop SAP BAPIs to ETL data for application development and reporting purposes.
- Use SAP connector of Microsoft .Net to bridge .Net applications and SAP BAPIs.
- Implement and Monitor TCP /IP protocol, start up shut down and configure SQL Server
- Enforce project deadlines and provide application end-user training.