SUMMARY:

• Experienced professional, DBA, team leader and DB application developer in SQL Server, DB2, Mainframe, AS400 - iSeries and Object Oriented multi-platform IT Environments for over 25 years.
• Specialized in Data Migration and Transformations between DB2, Sybase, Excel and Text Files into MS SQL database.
• Solely performing the entire process started with software installation, analysis, creating all Database Objects, Data Transitions and Load, verifying data and testing.
• Experience working with AGILE Technology, DevOps, SCRUM, Kanban, JIRA and Confluence.
• Data Architect with Business Intelligence BI and DW Design and implementation Skills.
• Design and Develop Data transformation and Migration using MS SSIS, Informatica, Pervasive and SAP BODS ETL, PowerBI Tools within different Data Warehousing and BI platforms.
• Specialized in developing interfaces from Java to Legacy system using Java and SQL Server Stored Procedures or DB2 (Native SQL & Cobol SPs) and ETL tools.
• Physical & Logical Database Design using Erwin Modeling tools generating DDL Scripts, creating all DB2 and SQL Server DB Objects in Development, Test and Production Environment,
• Design detailed specifications for program modules using UML and use cases.
• Plan and coordinate all level and types of testing for projects and programs throughout the project life cycle including production implementation and support.
• Document systems, programs, operations, and user stories and procedures.
• Analyze and rectify production problems as required and makes recommendations for non-recurrence of such problems as well as solving those problems by myself.
• Making a significant Performance Improvement with the best approach in Database and Application Design, Modifying SQLs, Stored Procedures, Creating the best performing Indexes when needed on DB2 and SQL Server platform, documenting all tasks in JIRA.

TECHNICAL BACKGROUND:

Databases and Tools: MS SQL Server, MySQL, UDB, DB2 on z/OS & iSeries(AS400) & LUW, Oracle, Sybase, JIRA, TSQL MS Management & Visual Studio, IDERA

ETL: SSIS, Pervasive, Informatica, SAP BODS, UML, WinSQL,VisualAge, Java SmallTalk, Data Studio, SQL, QMF, Crystal Reports, SPUFI, TSO/ISPF, FILE-AID, IBM File Manager, SyncSort, Erwin, XPEDITER, CICS, CHANGEMAN, RMF ENDEVOR, BMC Utility, CA Insight, SCRUM, Kanban, Confluence SharePoint

Applications and Areas: Insurance Claims, Policies and Billing Collage Works By Web, Customer Relationship (CRM), Loan Processing through the Life Cycle, Vendor and Customer Management, Item & UPC Management

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Consultant - SSIS Developer/DBA

Responsibilities:

• Working on extremely complex Database Migration from DB2 on AS400 to MS SQL using MS SSIS ETL tool.
• Downloaded all needed software to do the assignment: Installed MS SQL Server 2017, MS Visual Studio 2017, Management Studio, SSDT, ODBC drivers, set DSN Data Source to access DB2 from SQL Server.
• Generated DB2 tables DDLs, adjusted them to be compliant with SQL Server standards and created all corresponding Databases, Tables, Views and Indexes on SQL Server.
• The Migration was over complicated and designed when I came on board with verifying only number of records.
• I made the all adjustment in the shortest time with all data validation and verification.
• Migration included merging Cardinal data on DB2 and LoanIQ data on SQL Server, so had to develop extremely complex SQLs and handle lots of updates, inserts and merge statements to get all correct.
• Performed implementation into Production for Confidential as the first association of Confidential .
• The project finished with the big success
• Documenting the entire process, DDL files, Queries and created Instructions for creating and using Linked Servers, SSIS Projects and Packages.
• Created and provided Bank Management with much better design which will optimize the process, reduce the testing and execution time for all other 11 Confidential associations.

Confidential, Austin, TX

Consultant - SQL Server DBA

Responsibilities:

• Working on Database Migration from DB2 to MS SQL Server for all Databases Confidential need to migrate.
• Downloaded all needed software to do the assignment: Installed MS SQL Server 2017, MS Visual Studio 2017, Management Studio, SSDT, ODBC drivers, set DSN Data Source to access DB2 from SQL Server.
• Setup Always-on High Availability Groups.
• Generated DB2 tables DDLs, adjusted them to be compliant with SQL Server standards and created all corresponding Databases, Tables, Views and Indexes on SQL Server.
• Migrated first set of DB2 Schemas to SQL Server using SQL Server SSIS Packages and Import/Export Utility and verified all data are transferred and match DB2 data.
• Applied Transparent Data Encryption (TDE) to Databases containing NPI and HIPA data.
• Analyzing existed and new reports users will need and creating queries to retrieve data for reports. Using SSRS to produce first set of reports.
• Documenting the entire process, DDL files, Queries and created Instructions for creating and using SSIS Projects and Packages.

Confidential, Austin, TX

DBA Architect/Senior System Analyst

Responsibilities:

• Worked as DBA on the SQL Server installation, upgrade, administration, monitoring, optimization and maintenance.
• Supported all in-house projects by designing and creating the logical and physical database structure such as data model, database, tables, indexes, stored procedures, triggers, etc.
• Database Modeling using Erwin for all required DB2i on AS400 and SQL Server DB objects.
• Perform day to day Database Maintenance tasks - Database and replication Monitoring, Backups, Space Management, Resource Utilization, SQL Optimization and Performance tuning and improvement.
• Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks diagnose issues on the server. Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Storage, using IDERA Diagnostic Manager Tool. Monitor log files to proactively resolving issues.
• Designed and fully performed the entire process of mass migration including data transformation from DB2 on iSeries into brand new created SQL Server Databases using MS Import/Export utility and MS SSIS packages. Automated any repeatable data load creating and scheduling SQL Server Agent jobs to execute all needed steps including executing SSIS packages, Stored Procedures and PowerShell Scripts.
• Performed Data refresh of DB2 Database and sole developed a fully automated Data refresh process for SQL Server tables applying all changes in non-production environment.
• Analyzing the access path of any bad performing Query. Coding a new or modifying existed SQLs, T-SQLs and SQL Stored Procedures either DB2 on AS400 or SQL Servers.
• Highly involved in the company transition into AGILE Technology and DevOps.
• Attended a few workshops for SQL Server DB transition into MS Azure and MONGO DB.

Confidential, Austin, TX

Application DBA/System Analyst

Responsibilities:

• Took Over SQL Server 2005 Data Base Administration Role from the Vendor and started managing MS SQL Server 2005 Data Base as DBA, performing DB Backups, Restores and Replication of Production Data and performed daily routine monitoring, administration, repairbackup / restore and maintenance of Production MS SQL database.
• Created Scheduled Tasks automating the process of SQL DB Maintenance, SQL DDL Scripts for new DB Objects: tables, views, indexes, stored procedures, UDFs.
• Designing and developing ETLs (extract, transfer and load) processes used by companies to transfer electronic data between DB2 & Sybase into MS SQL Server using Pervasive Software and Titanium Application.
• Also developed ETL to Store docs into MySQL DB and SQLs to query them.
• Performed the full SQL Server 2008 R2 Installation (Upgrade) on Development, Production and Reporting Server and supported FileNet application on MS SQL Server 2012.
• Performing Application DBA DB2 on z/OS role for new developments and production support.
• Evaluating DB2 Version 10 database features to in corporate them in the new Project.
• Developing a new DB2 on z/OS Database Design from existed DACCS System to accommodate requests for DCS Government Project.
• Performing Database application tuning and performance monitoring with CA Insight, Sysview and Detector tools, optimizing existing SQLs within Informatica, Crystal Reports, Dynamic Java SQLs, JDBC, Stored Procedures (Native SQL and Cobol) on WL Servers and Mainframe.
• Developing a new Database Design from existed DACCS System to accommodate requests for DCS Government Project.
• Provide consultation and trouble shooting for the development team and a constant production Database and Application Support, creating DDL and DML Scripts for Data Fix.
• Participated in the Disaster Recovery Planning and Testing fixing any shown issue in 04/13.
• Performing Application DBA role for DB2 (UDB) on LUW for new developments, production support and managing all Universal Data Base Environments for Advantage Web and Profile Management Projects.
• Designing, Creating and Modifying Data Base Schema, Creating Tables, Views, Indexes, Constrains, Triggers, User Defined Functions and UDB Stored Procedures.
• Analyzing and optimizing DB2 performances using Visual Explain & Advanced Query Tool, modifying complex SQLs, redesigning Stored Procedures and Data Base Processes, gaining significant saving in CPU and total execution time.
• Creating and Maintaining all Test and QA Data Base Environments, modifying DB schema, setting up test data, building SQL Scripts for Production Data Base implementation.
• As a part of DBA team participated in the developing a generic Data Base model with metadata to finalize a Data Base design for Profile Management Project.
• Initially significantly contributed in setting up the environment to compile, bind and run Cobol and SQL DB2 stored procedures including DB2 Connect environment as well.
• Analyzing business requirements and developing complex DB2 stored procedures to allow update DB2 and IDMS database and keep them in sync.
• Developed code, created mapping documents, test plans and performed testing.
• Significantly contributed in optimizing other projects like DMR and Data Warehouse, Suggesting and Modifying Design, Changing Queries based on my own SQL access path Analysis.

Technical environment: MS SQL, IBM OS/390, COBOL, CICS, IDMS, UDB, DB2, VSAM, QMF, CA7, SyncSort, Windows XP, DB2 Connect and MS Office (Word, Excel, Visio, Access and Project).

Confidential, Dallas, TX

Consultant - System Analyst

Responsibilities:

• Lead for analysis, design and documenting CICS applications for the Fusion Project as a part of the assimilation to First American Real Estate Tax Services applications.
• Analyzed business requirements and created technical specs together with logical DB design for Loan Delinquencies application and Reporting.
• Developed complex DB2 stored procedures to allow WEB access to legacy application.
• Performed DB2 logical and physical design for the enhancement of Loan Delinquencies Project.
• Developed code, created test plans, performed testing and implementation through Endevor.
• Maintenance/support for Loan applications and production problem solving.

Technical environment: IBM z/OS, OS/390, COBOL, CICS, DB2, VSAM, QMF, Endevor, XPEDITER, IBM File Manager, IBM File Manager/DB2, View Direct, CA7, SyncSort, Control-M, Erwin, Windows NT, AS/400 and Microsoft Office (Word, Excel, Visio, Access and Project).

Confidential, Knoxville, TN

Consultant - System Analyst

Responsibilities:

• Performed analysis, coding, debugging, unit and system testing, using DB2 and VisualAge Generator 4.5 (generates Java, JSP and Cobol source code) in IMS environment. Developed a model scrolling for TUI applications and GUI prototype.
• Developed applications for Student Curriculum Project that can be accessed on the WEB using three-tier architecture as a replacement of the Legacy System developed with Cobol, CSP, DB2, CICS and IMS.

Technical environment: IBM OS390, IMS, CSP, COBOL, CICS, DB2, VSAM, QMF, PLATINUM, Windows XP and Microsoft Office (Outlook, Word, Excel, Visio, Access and Project).

Confidential, Temple, TX

Consultant - System Analyst

Responsibilities:

• Redesigned and developed Vendor and Customer WEB based Project, performing analysis, coding, unit and system testing, using WebSphere Application Server, Visualage for Java, JavaScript, HTML, EJB, JSP HTML and Cobol-DB2 Stored Procedures.
• Created a new Interface for transfer data from MPN to VM System, generating ChangeMan Packages and promoting them to production.
• Responsible for the significant application development and design of the same project using VisualAge Generator 3.1 and VisualAge for SmallTalk developed previously ( ).
• Participated in generating the SQL and custom queries in the Oracle database, provided help for the developers within the group, mostly improving optimization and performance.
• Constructed and developed UPC Validation Project converting it from VA Generator to VA Java and DB2 Stored procedures running on the Websphere application server.
• Performed analysis of VA Generator code, screen design, coding, unit, system and integration testing, using VA Java, JavaScript, Servlets, JSP, HTML and Cobol-DB2 SPs.
• Created QA test plans and change specs and participated in the deployment and installation.
• Redesigned and reprogrammed Item Management Project that was utilizing Websphere application server and integrating it with the Legacy System through CICS Transaction Geteway, mapping CICS/Cobol programs with Java front end.
• Performed analysis, coding, code review, created QA Test Plans, conducted unit and system testing, using Java, JavaScript, HTML and JSP.
• Prepared application implementation and was responsible for the production support.
• Responsible for the significant application development and design of the same project using VisualAge Generator 3.1 and VisualAge for SmallTalk developed previously ( ).

Technical environment: WebSphere VisualAge Java & SmallTalk, Java Swing, IBM OS390, MVS/XA, COBOL, CICS, DB2, VSAM, VIASOFT Tools, CHGMAN, CLIST, Windows NT and UNIX and Microsoft Office (Outlook, Word, Excel, Visio, PowerPoint and Project).

Confidential, Portland, OR

Consultant - Team Lead

Responsibilities:

• Led the team of developers to perform analysis, coding changes, code review, unit and system testing for the Shipment Control, Invoicing and Imaging System Applications at CTS.
• Conducted installation of modified programs and supported implemented applications.
• Performing Code AUDIT for all Cobol and Easytrieve programs, creating final documentation.
• Led and supervised a group of 5 developers, performing analysis, JCL changes, code review, creating documentation and managing the implementation to production.

Technical environment: IBM 3090, MVS/XA, COBOL, CICS, DB2, VSAM, VIASOFT Tools, XCHANGE, XPEDITER, CHGMAN, ENDEVOR, PANVALET, REXX, CLIST, Windows NT and UNIX.

Confidential

Consultant - System Analyst

Responsibilities:

• Analyzed, developed, maintained, performed unit and system testing applications of BOSS (Billing Ordering Shipping System) project for both Confidential.
• BOSS system is initially developed using CSP/DB2 on the IBM 3090 and than migrated to the OS390, utilizing Visual GEN and DB2/2.
• Conducted migration of CSP applications to Visual GEN running on OS2 client server base and continued developing new applications and enhancement using Visual GEN and DB2/2.
• Interaction with end users to develop program specifications for new applications and did production support for Confidential Oil, fixing and solving all production problems and issues.
• Analyzed JDE users’ needs and developed mainframe interface applications to JDE.

Technical environment: IBM Mainframe 3090, MVS/XA, CSP, Visual GEN, COBOL, CICS, DB2,VSAM, QMF, PLATINUM, PROEDIT, REXX, CLIST, OS/2 and Windows NT.

Confidential

Consultant - System Analyst

Responsibilities:

• Developed and tested new ARCS & ORCS record maintenance system using CSP, DB2, and QMF in a MVS/CICS environment.
• Designed, developed and tested applications of Asset Management system using CSP, DB2, SQL/DS, QMF in a VM/CMS and MVS/CICS environment. Design included screen and report design, application flow and program specifications.
• Migrated CSP source code of HR package of about one hundred applications from MVS to VM and conversed CSP 3.3 to CSP 4.1 version under MVS/CICS environment. Defined all transactions and applications driver in CICS, as old driver was COBOL program.

Technical environment: IBM Mainframe, MVS/XA, VM/CMS, CSP, COBOL, CICS, DB2, VSAM, QMF, PROEDIT, REXX, CLIST and Windows 3.1.