SUMMARY:

Information Technology experience in design, development, documentation, troubleshooting, database migration, architectural modeling, testing and network administration with Government, contract organizations and private industry. Federal Government experience in a wide variety of computer hardware/software architectures supporting military base level finance, accounting, safety, security, and personnel management. Software quality assurance and testing experience including functionality, compatibility, reliability, usability, installation, configuration, security and regression testing. Tested web and maintenance applications, client - server, network, multimedia, ETL’s and databases.

TECHNICAL SKILLS:

DATABASES: Oracle Client versions 7,8i,9i,10g and 11g, Teradata Client version 13, Microsoft SQL Server versions 2005, 2008 R2, 2012, MySQL, Sybase SQL Anywhere, Informix, Microsoft Access, Microsoft Active Directory.

ADVAnced SQL DEVelopment: Oracle PL/SQL, Oracle E Business Suite, Functions, Views/Tables, Procedures, Triggers, SSIS, SSRS, T-SQL.

Operating systems: HP UX, IBM AIX, Solaris, Linux, UNIX, Windows Advanced Server, Windows 3.1/ 95/98/2000/ XP/Vista/Windows 7.

SCRIPTING: XML, HTML, Teradata Fast Load,/Export, Unix Shell scripting, Windows scripts, VBA, Control M automation.

Hardware: Sun SPARC Solaris, HP L1000, HP 9000.

VERSIONIng: CVS, Serena PVCS, Microsoft Source Safe, Subversion, Clear Quest, DOORS, Documentum.

EXTRACT, TRANSFORM & LOAD: Informatica PowerCenter v 8.5/9, Microsoft SSIS packages.

Business Intelligence/CRM: OLAP, Data Mining, Process Mining, Business Performance Management, Digital Dashboards, Oracle BI suite v10.1, Oracle E Business Suite 11i and 12i, Seibel.

REPORT development Tools: Cognos 11/Impromptu, Oracle Discoverer, Crystal Reports, Business Objects, MS Access, SSRS, MS Excel.

Gui tools: MS Project, Visio, MS Office suite, Crystal Reports 8.5/10, Business Objects X/XI, Teradata SQL Assistant v13, MS Office for Mac, SQL Plus GUI, Toad version 8.5,/9, Toad, Oracle SQL Developer version 12, Dreamweaver.

Defect tracking: Serena Team Track, BMC Remedy, HP Service Manager, Clear Quest, HP Quality Center.

IT Methodology: Agile, Scrum, ITIL, SDLC, Waterfall.

Testing tools: Junit Test, HP Mercury Test Suite v11, LoadRunner, WinRunner, Test Director, Quick Test Pro, IBM Rational Test Suite, Rational Robot-Test Manager v7.

DATA Modeling TOOLS or CASE TOOLS: Erwin 2.5, BPwin, Vizio, UML, IDEF0, IDEF1X, Power Designer.
 

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer/Analyst

• Developed SQL scripts, Procedures to retrieve Uniform Listing of All Tell Wireless data from Oracle Databases.
• Developed UNIX shell scripts to automate process of execution of Oracle SQL scripts and conversion of data.

Confidential, San Antonio, TX

SQL Developer/Systems Analyst

• Uploaded Confidential Customer Care data from Oracle databases and Teradata Data Warehouse to Vendor.
• Developed Automation of Oracle and Teradata SQL and T-SQL scripts of Confidential Customer care data to Vendor.
• Designed Device by OS, Enterprise by OS, and Device Swap Type Confidential Customer care reports in MS Excel, Business Objects and SSRS.
• Provided Call Center and Customer Specialist Retail Store customer data for Pulse initiative.
• Developed Customer Survey data automatically to Confidential management in SSIS package and T-SQL scripts.
• Designed and automated Teradata Fast Export scripts exporting Confidential Care data to Vendor location.
• Developed Procedures, Stored Procedures in Oracle and MS SQL Server for automation of SQL/data tasks.

Confidential - San Antonio, TX

Data Analyst

• Developed SQL queries for AT&T U-verse marketing campaign MS Excel pivot tables, dashboards, and reports in Business Objects and SSRS.
• Developed U-verse marketing campaign reports utilizing Teradata SQL Assistant, and Toad Data Analysis.
• Analyst responsible for Teradata, Toad for Data Analyst client installations to U-verse Marketing Team.
• Performed data cleansing/analysis of U-verse marketing campaign data for trend reporting requirements.
• Developed Teradata and Oracle views, procedures, and tables for reporting requirements.

PDS Technical Services, Inc. - San Antonio, TX - Systems Analyst

• Business and Data Application Support Analyst responsible for 787 mechanic, inspector, and engineer support staff.
• Equipment and Application Defect Support Analyst providing resolutions in HP Quality Center Service Manager.
• Application Support Trainer for 787 project applications.
• Developed Cognos BI Operations reports on 787 aircraft/Line Numbers for 787 Operations Management.
• Systems and applications development consultant for product enhancements and deliverables.

Confidential- San Antonio, TX

Enterprise Service Help Desk Project SQL Developer

• Reports Developer utilizing SSRS, Business Objects and Excel for Enterprise Service Help Desk website reports.
• UNIX shell script developer responsible for production maintenance, SQL Server testing, MySQL, Oracle databases.
• Applications Support Analyst responsible for installation of client databases, and troubleshooting desktops.
• Developer responsible for exporting Remedy Help desk reports developed in Business Objects or SSRS to SharePoint portal.
• Business Analyst responsible for requirements gathering for Visio technical diagrams, workflows, flowcharts and technical documents.
• Application Workflow Analyst responsible for SSIS, ETL processes, developing T-SQL scripts and Procedures.

Confidential - San Antonio, TX

SQL Developer Public Trust Clearance

• Business Analyst created financial reports of AR, AP, and GL data.
• Oracle Process Manager responsible for configuring development environment concurrent manager scripts.
• Requirements Analyst utilizing Serena Team Track for version control of code or configuration management.
• Oracle Programmer responsible for database support, and data analysis for AF Services application.
• Oracle E Business Applications Analyst responsible for SQL scripting, testing and data mapping.
• Oracle Discoverer Reports Developer responsible for customer AR, AP, and GL financial reports design.
• Business Requirements Analyst responsible for Visio diagrams, workflows, flowcharts, reports, and ETL packages developed in Informatica Power Center.

Confidential- San Antonio, TX

Systems Analyst

• Web Applications Programmer Analyst responsible for gathering technical business requirements for application projects.
• Documentation Specialist responsible for all SDLC phases of change management, discovery items, and conversion documentation.
• Testing Analyst responsible for Data Conversion, FoxPro database testing, data integrity, data migration to SQL Server.
• Business Analyst responsible for translating business requirements into technical diagrams, workflows, flowcharts, and create technical documents.
• Developed Procedures, T -SQL scripts, Views/Tables, SSIS Packages for web app development in MS SQL Server.

Confidential - San Antonio, TX

Systems Analyst

• Responsible for updates and modification to Command Core database for the Department of Air Force.
• Responsible for all data throughout the USAF bases in Oracle databases versions 8i/9i and 10g.
• Built and maintained PL/SQL packages in Oracle databases to support Command Core.
• Built MS Access application to provide Ad hoc reports, and ticket metrics to USAF Program management.
• Developed USAF Bio Environmental Engineering Data Warehouse reports utilizing Oracle Discoverer and Business Objects.
• Documentation Specialist responsible for content and portal site management of Command Core Home Page, data migration, data mapping, data analysis, data cleansing, gathering/translating business requirements.
• Business Requirements Analyst responsible for technical diagrams, workflows, flowcharts, and documents.
• Coordinated Hardware Tech support of Unix Solaris/HP hardware platforms.
• Application Tester responsible for beta testing of Command Core application and coordinating schedule release.
• Developed Unix/shell scripts to support file maintenance and backup Oracle databases in all environments.

Confidential - San Antonio, TX

Systems Analyst

• Performance Tester responsible for Legacy Mark IV, COBOL and JCL Physician’s Mutual applications for Yellow Freight and other projects utilizing TMGi's analytical code inspection tool.
• Responsible for noncompliance issues and problem resolution for company’s reporting system tool.
• Responsible for gathering and translating business requirements to technical documents for customer projects.
• Provided customer support in resolving Research and Development issues in designing Microsoft Visual Basic applications. Business Objects and Crystal Reports.
• Quality Assurance Tester responsible for movement of all objects associated with application revisions to the production environment for customer support.
• Business Requirements Analyst responsible for technical diagrams, workflows, flowcharts, and documents.

Confidential - Overland Park, KS

Software Engineer IV

• Software Test Engineer responsible for System Test, Regression, Integration and functional testing of Java applications utilizing Rational Test, Mercury Interactive testing suite tools and HP Quality Center for defects.
• Requirements Analyst responsible for gathering and translating customer technical business requirements.
• Testing Analyst responsible for coordinating requirements with development teams, release and project managers.
• Data Analyst responsible for requirements gathering, configuration management, data mapping, creating Informatica ETL packages and testing for Testing and Application Project teams within Confidential Enterprise..
• Reports developer used Cognos Impromptu and Toad to query/collect data for Confidential testing and development teams.
• Senior Business Analyst responsible for budgetary support group business customer requirements.
• Crystal Reports developer responsible for creating reports for BI upper management release testing metrics.
• Oracle and MS SQL Server 2005 SQL Developer responsible for SQL development, ETL packages and reports.
• Developed Unix Shell scripts for database and file maintenance and developed in Seibel CRM tools.