SUMMARY:

An innovative, solutions - driven Information Technology professional with a strong business acumen and extensive hands-on background experience. Over thirty of years experience in information systems.

RECENT PROFESSIONAL HISTORY:

Confidential, Denton, Texas

Sr. SQL Developer

Responsibilities:

• Responsible for design, coding, implantation and maintenance of SQL Server database solutions for business applications.
• Creation of complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Analyzing and developing complex logical database designs, logical data models and relational data definitions in support of business application systems requirements.
• Create new SQL Server Integration Services (SSIS) packages from the scratch and completed full life cycle deployment.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for ETLs and SSRS reports.
• Execution of ETLs in both real-time (via SQL calls) and scheduled batch jobs (via SQLAgent).
• Tune SQL Statements using Indexes and Performed Index analysis for tables to come up with more efficient solutions using Clustered and Non-Clustered Indexes for significant performance boost.
• Integration (ETL) of external third-party data sources (Epsilon, SalesForce SFDC, etc.).
• Involved in Data Warehouse System Integration.

Confidential, Dallas, Texas

Sr. Developer

Responsibilities:

• Responsible for design, coding, testing, debugging, support, and documentation of the new Global Auction application system.
• This was a re-platforming and re-factoring of an IBM i-Series (AS/400) based system written in RPG and using IBM DB2 (DB400) to a Unix based systems (AIX & Linux) using IBM DB2 which is front-ended by Java server applications, web services, and a .Net web farm, as well as an API for third-party system integration.
• Team member representing the Data layer of the AWS team migrating systems to the AWS cloud.
• Created ETL packages (using SAP BW, SSIS, Talend, Pentaho, etc.) to bring data in/out of DB2 from/to heterogeneous data sources (Oracle, SQL Server, MySql, MariaDB, Web Services, Flat files, etc.).
• Performed technical requirements definitions, design of all database aspects (including data modeling and logic partitioning) and the development of all database objects (tables, views, triggers, stored procedures,etc.) delivering a fully global system with complete localization and multi-language support. Provided guidance and code (C# & Java) to application teams to properly consume data from databases.

Confidential, Fort Worth, Texas

Application Developer

Responsibilities:

• Application Developer for .Net (full stack) Developer for Sales Tool application development project.
• Responsible for design, coding, testing, debugging, support, and documentation of Sales Tool application.
• Performed hands-on software development and design in a Microsoft environment (Windows 8, SQL Server 2008 R2, Active Directory, IIS, Windows Server 2012) using Microsoft Visual Studio 2010/2012, C# .Net, Entity Framework (Data First approach), TSQL, WCF, Javascript/JQuery, MVC 4, HTML 5, CSS 3, and Kendo UI controls.
• The Sales Tool is targeted for Laptops and Hand-held devices (tablets and smart phones).
• The tool among other things, integrates disconnected systems to provide data and reporting. Including SQL Server, JD Edwards, WCF Web services and others.

Confidential, Dallas, Texas

Database Developer/DBA (SQL)

Responsibilities:

• Lead Database Developer for database-centric software development projects (8 persons).
• Handled multiple projects simultaneously.
• Established standards and best practices.
• Performed hands-on software development and design in a Microsoft SQL Server environment.
• Develop and maintain 270+ SQL Server databases.
• Created and managed tables using Views, Sequences and Indexes.
• Programmed SSIS (ETL) packages, SSRS reports, stored procedures, queries, triggers, and scripts to met business objective.
• Optimized the queries performance and populate data. Performed debugging, unit and system testing of code.
• Additionally, migrated all databases from SQL Server 2005 to SQL Server 2008 R2. Rewrote all DTS ETL packages to SSIS ETL packages.
• Implemented SSRS for reporting.
• Created scripts to and packages to integrate/interface with other data sources (client data sources, including MySQL, MariaDB, Oracle, Files, etc.)
• Rewrote TSQL stored procedures eliminating CURSORs significantly improving performance and eliminating lock timeouts.

Confidential, Dallas, Texas

Software Developer

Responsibilities:

• New development project to develop a website that allows internal and external users to access state specific compliance and regulatory information regarding higher education throughout the US.
• Developed as a MVC 3 with RESTful URLs web application using Microsoft Visual Studio 2010 with Team Foundation Server, C# .Net 4, WCF, Entity Framework, jQuery, SQL Server 2008, IIS 7, Windows 64bit 2008 Server & Windows 7 64bit, HTML, JavaScript, CSS, XML and JSOM in an agile environment.
• UI support for Microsoft Internet Explorer, Mozilla Firefox, Apple Safari, and Google Chrome.

Confidential, Irving, Texas

Lead Architect and Developer

Responsibilities:

• Responsibilities included requirement analysis, design, encoding, data modeling, data migration and system integration.
• Developed as a MVC with RESTful URLs web application and SOAP 1.2 Web Services using Microsoft Visual Studio 2010, C# .Net 4, Java 5, Siteminder Java SDK, Oracle DB, IIS 7.0, Windows 64bit 2008 Server & Windows 7 64bit, SVN, Telerik Ajax controls, HTML, JavaScript, CSS, XML and JSOM in a modified agile environment.
• While supporting current production version written as PERL/Sybase web CGI application.
• UI support for Microsoft Internet Explorer, Mozilla Firefox, Apple Safari, and Google Chrome.

Confidential, Dallas, Texas

Lead Programmer

Responsibilities:

• Lead software development team, developing client facing web application to support franchisees in daily store operations .
• Responsibilities included requirement analysis, design, encoding, data modeling, data migration and system integration.
• Developed with Microsoft Visual Studio 2010, C# .Net 4, Tortoise SVN, SQL Server 2008, IIS 7.0, Windows 64bit 2008 Server & Windows 7 64bit, Telerik Ajax controls, HTML, JavaScript, CSS and Office automation in an agile environment.
• UI support for Microsoft Internet Explorer, Mozilla Firefox, Apple Safari, and Google Chrome, etc.