SUMMARY:

• A highly skilled and detail - oriented IT professional and .Net Developer with extensive experience in user interfaces, website development/management, application design, extraction tools/programs, report generation, technical support, bug fixes, coding, testing, troubleshooting, and setup packages.
• Additional capabilities in developing user controls, creating data sets, and updating systems.
• Utilizes technical proficiency to design employee and customer applications/systems.
• An analytical and innovative producer who establishes registration systems, designs reporting tools, and generates stored procedures to drive efficiency and support company goals.

TECHNICAL SKILLS:

Languages: SSRS; C#; VB.NET; ASP.NET; MVC; AngularJS, VBScript; JavaScript; HTML; DHTML; T-SQL; XML; ADO.NET; SQL Server 2005/2008; PL/SQL; LINQ; Entity Framework

Methodologies: Data modeling, using entity relationship diagrams and normalization; Agile/Scrum

Platforms/Tools: Windows 2010/2003/2000/ NT/XP

Databases: SQL 2005/2008/2012 ; MS Access 2000; Oracle 11g

Miscellaneous: Visual Studio 2005/2008/ 2010/2012/2013 ; TextPad; Visual SourceSafe; Vault; VisualCron; Fortres; DotNetNuke; MS Excel; Team Foundation Server; JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, Texas

Software Engineer

• Part of distributed Services team that supports Microsoft Customers. Primary job involves troubleshooting Windows Communication Foundation issues. Collect the necessary data including WCF traces and dump files using Debug Diag. Analyze the dump files and provide recommendations or workaround to fix the issues.

Confidential, Texas

.Net Developer

Responsibilities:

• Involved in development of South Carolina web application for auto titling and registration process in small team environment. Added business logic to import transfer plate data from state server, using WCF.
• Worked on GA Fleet project to title and register multiple vehicles at same time for same owner, helping title clerk enter and process applications faster.
• Created lien holder console app, using C#, to read pipe delimited file from South Carolina state server and update database, including creation of backup table, insertion of new lien info, and removal and updates of existing liens.
• Supported auto titling and registration applications for Florida, Georgia, Virginia, South Carolina, and Maryland, serving over 6,000 dealers nationwide. Performed troubleshooting, bug fixes, modifications, and enhancements.
• Consumed DMS (dealer management system) web services, using WCF to retrieve data and complete T21 application process for dealers.
• Supported FeeCalc project to calculate titling and registration fees, using XAML workflows, C#, jQuery, ASP.NET, and SQL Server 2008 R2.
• Performed code reviews and mentored juniors.

Environment: MS SQL Server 2008 R2/2012, Visual Studio 2010/2012/2013, ADO.NET, ASP.NET, MVC, C#, CSS, AJAX, jQuery/JavaScript/AngularJS, SSRS, WCF, Web API, XAML workflow.

Confidential, Texas

Programmer Analyst

Responsibilities:

• Oversaw Confidential website.
• Designed, developed, and deployed Convention website, using Visual Studio 2010, including MS SQL Server 2008, ADO.NET, SSRS, ASP.NET, C#, CSS, AJAX, jQuery, and JavaScript.
• Created stored procedures, triggers, UDF, views, and tables, as well as generated T-SQL script for application.
• Tested data with complex queries, joins, and subqueries.
• Created tabular, matrix, chart, scorecard, and drilldown reports, as well as parametric and cascaded reports/dashboards according to business requirements.
• Developed complex stored procedures for increased performance in generating reports, as well as provided indexes.
• Tested stored procedures on testing server.
• Deployed and scheduled reports, using SSRS to generate daily, weekly, monthly, and quarterly reports, including current status.
• Established ad hoc, drilldown, and drillthrough reports.
• Generated report models, deploying on report server.

Environment: MS SQL Server 2008, Visual Studio 2010, ADO.NET, SSRS, ASP.NET, C#, CSS, AJAX, jQuery/JavaScript, SSRS

Confidential, Texas

Developer

Responsibilities:

• Developed and supported multi-tier web-based application for Bloomingdale’s, using .NET 2.0 and .NET 3.5. Wrote console applications to process daily transaction logs received from customers. Added web services functionality to register credit cards. Supported customer service sites.
• Completed Amex conversion project to replace members’ Visa mask IDs with Amex mask IDs. Created external tables for incoming data files received daily. Wrote stored procedures to validate data and extract unprocessed data. Set up VisualCron to process data daily. Modified existing procedures, tables, C# processors, and websites to accommodate change.
• Oversaw outlet project. Added logic to identify outlet stores in TLogs and give loyalty points accordingly. Enhanced C# method in class file for points logic. Attached division column in store table to differentiate between retail stores and outlet stores. Modified existing procedure to set outlet store flag.
• Wrote procedure in PL/SQL to provide customers 500 points for birthday-month purchases, running batch processor daily.
• Redesigned member-facing site to increase attractiveness to members.
• Established console program, using C# to read daily transaction logs and update attribute sets.
• Wrote year-end PL/SQL script to forfeit points of members based on criteria given by client, encouraging members to shop more aggressively to avoid points forfeiture.

Environment: .NET 2.0/3.5, ASP.NET, C#, Oracle 11g, PL/SQL, Agile Scrum, SQL *Plus, SQL Loader, T-SQL, VB.NET, SQL Server 2008

Confidential, Dallas, Texas

System Specialist

Responsibilities:

• Generated system to allow retailer/customer to print catalogs on request. Created web-based UI to call async method, using delegates and sending necessary parameters to generate catalogs.
• Developed UI, using ASP.NET.
• Wrote method in C#.
• Created async method call, using delegates.
• Wrote DTS package, using SQL 2000.

Environment: .NET 2.0, ASP.NET, C#, SQL Server 2000, DTS Package

• Worked on master files strategy project, allowing user to categorize product SKUs to correct product category. Created stored procedure to retrieve data from item master file and update necessary tables on weekly basis.
• Developed UI in MS Access 2000 and VB6.
• Created stored procedure and views for back-end processing.
• Generated low-level design based on user requirements and high-level design.
• Connected to SQL database, using ADOdb connection.

Environment: MS Access, ADOdb, SQL Server 2005

Confidential, Dallas, Texas

.Net Developer

Responsibilities:

• Developed Windows-based desktop print shop application, allowing users to enter print requests and edits and perform costing for print jobs. Oversaw gathering of user requirements, design, analysis, coding, testing, creation of setup packages, and deployment.
• Enabled users to print summaries and detailed reports based on date ranges.
• Converted application from MS Access 2000 to .NET 2.0 framework.
• Wrote code, using VB.NET, and generated data sets and TableAdapter to fill tables. Created stored procedures and views, using SQL Server 2005.
• Developed user controls for user interface.
• Established middle tier logic, using VB.NET.
• Implemented ADO.NET objects for database access.
• Created data sets, using TableAdapter.
• Generated stored procedures and views for querying database.
• Implemented delegates for event handling.
• Designed documentation for developer testing.
• Implemented role-based security to restrict access to users.
• Completed reports, using Visual Studio 2005 ReportViewer and Crystal Reports.
• Created Windows-based UI, utilizing C#, to allow users to select text files from drive/folder path and dump into data set table. Enabled users to save tables in database.
• Designed controls for user interface.
• Developed middle tier logic, using C#.
• Created data sets, using TableAdapter for table updates.
• Implemented delegates for event handling.
• Performed unit testing.
• Designed Expense Mate, Windows-based application for employees to submit business expenses, including travel, meals, books, etc.
• Troubleshot key data conflict error occurring when multiple updates applied to database. Resolved error by changing seed value to zero in data set table key field and incrementing by -1.
• Wrote stored procedure to allow supervisor to view hierarchical data of immediate employees and subordinates.