OBJECTIVE:

Application Developer, Software Architect, Applications Development Manager, DBA

SUMMARY:

11 years’ experience with .NET/DBA/ETL/SSIS. A full stack developer using C#/VB.NET on front end website, and DBA/ETL/SSIS on back end.10 years’ experience with AS/400, RPG and COBOL. 10 years in banking and manufacturing

TECHNICAL SKILLS:

VB.NET (11 years), C# (6 years+), ASP.NET with Web Form/MVC/Entity Framework/AJAX/web services/WCF/WebAPI/LINQ (11 years), T - SQL (11 years+), MS SQL Server ( 2000/2008/2012 ) DBA with ETL/SSIS and Stored Procedures/Functions/Triggers (11 years), SSRS, IIS, JavaScript, jQuery, JSON, AngularJS, Knockout js, Bootstrap, HTML5, CSS, XML, Crystal Reports, Check 21 (Checks Image Processing), Fiserv/Spectrum (Credit Union banking system-11 years), RepGen/PowerOn/Symitar/Episys/Synergy Document Management, Data Modeling (ERD, UML)AS/400 (10 years+), ILE RPG IV, RPG/400 (10 years+) / RPG II (15 years), COBOL (15 years), SQL/CL/Query/Subfile (10 years+)LMS Hotel System (1 year and 4 months), CMS Casino System (1 year and 4 months), Optimum Payroll System (1 year and 4 months)Banking system using RepGen/PowerOn/Symitar/Episys on RS/6000 Unix (Credit Union system- 2 years)JD Edwards-Order Processing, Accounts Payable/Accounts Receivable/ General Ledger (3 months)LANSA (2 years), Manufacturing/Distribution experience (15 years), Shipping system (3 years), EDI, MS Access (1 year), Visual Basic, VBA, ASP, Java, MySQL, C++, PHP

HARDWARE/SOFTWARE:

Hardware: HP9000 Unix (11 years), MS SQL server 2000/2008/2012 (11 years), AS/400 (10 years+), RS/6000 Unix (2 years)

Languages: VB.NET, C#, T-SQL/SSIS/Stored Procedures/Functions/Triggers, ASP.NET with Web Form/MVC/Entity Framework/AJAX/web services/WCF/WebAPI/LINQ, JavaScript, jQuery, JSON, AngularJS, Knockout js, Bootstrap, HTML5, CSS, XML, RPG IV, ILE, RPG/400, RPG II, COBOL, AS400 SQL, CL, LMS and CMS hotel and casino systems, RepGen/PowerOn/Symitar/Episys (2 years), LANSA, JD Edwards, MySQL, MS Access, VISUAL BASIC, MS Office (Excel/Word/Visio), ASP, PHP, Java, C++, SML, Prolog, WML/WAP, FTP, PASCAL, FORTRAN, BASIC, CLIPPER, DBASE IV

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Sr. Application Developer/Architect

Responsibilities:

• Applications Design, VB.NET/C# Programming, DBA/ETL/SSIS, T-SQL and Stored Procedures, Web programming-C#/VB.NET/JavaScript/jQuery/AngularJS 1.x/HTML/XML/JSON, Fiserv/Spectrum, RepGen/PowerOn/Symitar/Episys/Synergy Document Management architect and team lead since January 2015, supervising 2 developers working on system design, programming as well as SQL server database administration working on documentation of both new or existing projects
• Handle Ah Hoc reports using TSQL (such as credit card fraud)
• Perform full SDLC as below:
• Meet with end users when they request a new project gather user requirements system design, define details and functions of each module decision to go for C# projects or SSIS projects define project deadline perform coding, monitor the status of each developer monitor unit testing perform system integration testing, and UAT user training and project implementation

Confidential, Las Vegas, NV

Sr. Application Developer/DBA

Responsibilities:

• VB.NET and C# Programming, ETL/SSIS, T-SQL and Stored Procedures, MS SQL Server 2008/2012 DBA, Crystal Reports, Web programming-C#/VB.NET/JavaScript/HTML/XML, Unix Mainframe programming using Fiserv/Spectrum
• Team lead of a team of 3 providing leadership on multiple projects, both on system design and documentation working on programming as well as database administration

Confidential, Las Vegas, NV

Programmer / Analyst

Responsibilities:

• LMS hotel software package, CMS casino software package, Optimum Payroll System, AS400 RPG IV, RPG/400ILE, CL, Help desk support
• AS400 RPG programming reporting to the IT Director, we had a small team of 5 including network guys and system operator. program modification and maintenance of LMS and CMS systems (hotel and casino management) system operations support help desk support, and network support

Confidential, Las Vegas, NV

System Specialist

Responsibilities:

• Programming- RepGen, Symitar on RS/6000 (Unix), Web-ASP, HTML, JavaScript, T-SQL reporting to the Software Development Manager, we had a team of 3 developers programming with RepGen (Symitar system) programming with classic ASP, VB scripts web programming with HTML, JavaScript and TSQL help desk support

Confidential, Las Vegas, NV)

IT Consultant

Responsibilities:

• System design & programming, Leading 2 programmers, IBM AS400, RPG/400, LANSA

Confidential

Systems Analyst

Responsibilities:

• System design & programming, Leading 1 programmer, IBM AS400, RPG/400, JD Edwards system

Confidential

MIS Manager

Responsibilities:

• System management, design & programming, Manufacturing system- logistics, inventory control, sales marketing, GL, AP, AR, Y2K project, Leading a team of 2 system support clerksIBM AS400, COBOL/400, RPG/400, EDI

Confidential

EDP Manager

Responsibilities:

• System management, design & Programming, Shipping system- outstanding orders, sales confirmationL/C, pro-forma invoice, Leading 1 programmer, Discarding S36 and rewriting new Shipping system on AS400 using RPG/400, IBM AS400, RPG/400

Confidential

SystemsAnalyst

Responsibilities:

• System design & programming, Reporting to DP Manager, I lead a team of 1 AP and 3 programmersIBM AS400, IBM S36, RPG/400, RPG II, COBOL, LANSABASIS Coke software package - manufacturing, GL, AP, ARLocal system developments - Payroll, Commission, Fixed Asset
• Programming using RPG/COBOL, Manufacturing and Distribution systems populate and store monthly GL transaction balances on SQL server data warehouse account review variance parameter calculate variances in accounts over time allow user to document the review of variances report variance review information
• Importing XML data into SQL server. This project reads XML data from vehicle dealers, and imports XML data into SQL database using .NET programs. The website reads the imported tables and allows our loan processing staff to update and track the status of each loan app based on import data such as app number, loan amount requested, and app status (initiated/approved/declined).
• Importing vendors CSV file into SQL database using SSIS. The .NET programs will be processing the data and showing monthly statistics on a website (such as no. of active policies, no. of active clients, upcoming renewal amount ..), and showing charts such as production amount by agents (insurance agent1, agent2 )
• Account inquiry website, using AJAX to pull out account information. Using the auto - complete feature, end user keys in partial account name, and can view a number of matching names on screen
• Using web services, real time posting of fees to members accounts.
• Examples of SQL server DBA
• MS SQL Server 2000/2008/2012 DBA and SSIS development.
• Migrating SQL2000 DTS to SQL2008 SSIS
• SSIS with Secured FTP
• Creating secured FTP task using VB script to access remote files on vendors’ FTP sites.
• Reading data from data warehouse, and creating output files in different formats such as TXT, CSV or Excel file (VB script task or Import/Export wizard).
• ETL on FED loan data - SSIS to pull out loan data and export to Excel as required by the FED
• ETL on credit scores - SSIS to extract member credit scores for inquiry on website
• SSIS ETL - creating and maintaining master tables, using ODBC for daily or monthly ETL processes to pull out data from LIVE host computer into data warehouse.
• SSIS project can include different tasks such as Execute SQL Task, Data Flow Task. VB script can be included to create a TXT report file, to evaluate SSIS package variables such as month end date which can be seen throughout the whole SSIS package.
• SSIS with C# script - reading a text report file, filtering to include useful information, and inserting the useful information into SQL database.
• Using RPG to develop a shipping system from scratch: To keep track of outstanding orders, sales confirmation, L/C, pro-forma invoice. Using the SDLC, it included system analysis, system design, programming, system testing, user training, system implementation.
• Y2K project, modifying a COBOL manufacturing software package to make it Y2K compliant.
• I have been using both the Waterfall approach and Agile approach in software development.
• For smaller projects like dashboard website that can be completed in weeks, I use the Agile approach that promotes:
• Communication between end users and other team members
• Simple and clean designs
• Feedback given on Day 1 of software testing
• Early delivery and implementation of suggested changes.
• Requirement analysis - meetings with all related users to gather their requirements (like what reports they need)
• System design - to decide on data flow and development tools to be used (pseudo codes, flow charts, ERD, programming languages, reporting tools…)
• Implementation - program development
• Program testing and parallel runs to verify new system output matches with end user requirements. After that, we need user training to use the new system, and the new system will be put into production.
• Evaluation and maintenance - to evaluate the new system with users and maintain and modify the programs if needed