Database administrator (DBA) Venkatesh Ponraj, Websites, IT & Software

Provide second-level application software support for enterprise level and third party software/applications. Analyze system errors and troubleshoot network, server, and database errors. Document system bugs and maintain support ticket software.

SUMMARY A creative, well organized Information Technology professional with over twenty-five years experience in engineering, quality assurance, systems implementation & analysis, and project management, automation testing tool development, performance testing, and software development. Major strengths are in QA, testing, technical problem solving, organization, planning and team leadership. QA testing included Waterfall, CMM, and Agile Methodologies, as well as Six Sigma Testing. Expertise in both analog and digital electronics, and a wide variety of computer hardware platforms, operating systems, databases, software packages & applications, and programming languages. A dependable professional who communicates effectively and maintains high quality work standards in accomplishing tasks. ================== SUMMARY A creative, well organized Information Technology professional with over twenty-five years experience in engineering, quality assurance, systems implementation & analysis, and project management, automation testing tool development, performance testing, and software development. Major strengths are in QA, testing, technical problem solving, organization, planning and team leadership. QA testing included Waterfall, CMM, and Agile Methodologies, as well as Six Sigma Testing. Expertise in both analog and digital electronics, and a wide variety of computer hardware platforms, operating systems, databases, software packages & applications, and programming languages. A dependable professional who communicates effectively and maintains high quality work standards in accomplishing tasks. WORK HISTORY 2005-PRESENT SENIOR QUALITY ENGINEERING (CONSULTANT) • Evaluation of requirements (Business & Functional) • Test Coordination & Planning – Strategy, Plan, Cases, Procedures, Scripts, Data, etc. • Automation Testing & Manual Testing • Load Balance & Performance Testing • Problem solving, System & Data Analysis • System Analysis, System Architecture • Resource & People Management • Data Validation (Integrity, System & Business Flow, Security)  2019 SR. SOFT./ TEST ENG. (CONS.) - (Aerotek/EASi), Orlando, FL. Boeing: • Project Management – Stage Controller/SLS (Space Launch System) TRR – (Test Readiness Review) for Formal Dry Run & Formal Quality Test. • Tracking all Constraints needed to Enter & Exit TRR and driving to completion on schedule. • Liaison for TRR for the Software Test Team, interfacing with various Boeing Elements (Huntsville, AL, Titusville, FL.), NASA. • Attending and running meetings. • Risk Assessment – Evaluation of Risks for meeting constraint completion. • Document preparation, PowerPoint Presentation development and creation. • Data Analysis & Evaluation. • Lessons Learned, Process Evaluation, Testing Methodology, Improvement. • SW Test. Eng. – Configuration Management (CM) – Involved in keeping Test Lab & Configuration of software & Hardware under CM control. • Validation of any software & hardware changes to Test Environment. • 24/7 CM Control during Testing Phases. • Recording, tracking, and maintaining records of any Test Environment Changes when scheduled to support the Testing Team. • Lessons Learned, Process Evaluation, Testing Methodology, Improvement.  2017-2019 SR. SQA./ ENG. LEAD (CONS.) - (Valintry), Orlando, FL. • QA Project Lead – AR2/HR2 – Cloud Based (Microsoft), Inventory, Rental, Sales, Tracking & Management System. (Heavy Equipment for High Lifting) • Evaluation of All Requirements, Business, Functional, Role and Security. • Traceability Matrix – Integration of Business, Functional, Role and Security Requirements. • Risk Assessment – Evaluated Risks, and Testing Approach. • Shakeout, Integration, Evaluation, of AR2/HR2 System. • Functional, Business, Data Integrity, Role, and Security Testing. • Data Validation (Integrity, System & Business Flow, Security) • System Analysis and Performance Testing. • Lessons Learned, Process Evaluation, Testing Methodology, Improvement. • QA Project Lead – FLVS/VSA Password Security – Web Based, School Learning and Management System for Students, Teachers, Parents, etc. (We were there to help improve Password Security, and System Access.) • Evaluation of All Requirements, Business, Functional, Role and Security. • Traceability Matrix – Integration of Business, Functional, Role and Security Requirements. • Risk Assessment – Evaluated Risks, and Testing Approach. • Shakeout, Integration, Evaluation, of FLVS/VSA Password Security. • Functional, Business, Data Integrity, Role, and Security Testing. • Data Validation (Integrity, System & Business Flow, Security) • System Analysis and Performance Testing. • Lessons Learned, Process Evaluation, Testing Methodology, Improvement.  2015-2016 SR. SQA./ ENG. LEAD (CONS.) - (Bausch & Lomb), Clearwater, FL. • QA Project Lead – BMRAM – Web Based, COTS Inventory & Maintenance System. • Evaluation of All Requirements, URS, Functional, and Security. • Functional Specification – Reverse Engineered the BMRAM System. • Traceability Matrix – Integration of URS, Functional, and Security Requirements. • Risk Assessment – Evaluated Risks, and Testing Approach. • Shakeout, Integration, Certification, of BMRAM. • System Analysis and Performance Testing. • Data Validation (Integrity, System & Business Flow, Security) • QA Project Lead – AUTOSORTER – Integrated System to sort Production Product. • Medical Devices • Part 21-11 Compliant • FDA Compliant • IQ, OQ, PQ  2012-2014 SR.BA / QA. ENG. LEAD (CONS.) - (Walt Disney World), Orlando, FL. • ONBOARDING – Disney Project Lead to Onboard External Partners. • Direct Connect (XML Interface Messaging) Reservation Booking Interface. • Oracle SQL Database. • Requirement & Design Analysis, Data Analysis, Test Plan, User Acceptance Testing. • Shakeout, Integration, Certification, and FIT Testing. • Production Implementation Monitoring, and Post Support. • System Analysis and Performance Testing. • Data Validation (Integrity, System & Business Flow, Security) • Coordinate with External Partners (Mark Travel International, Expedia, etc.) & Disney Teams. • QA ONBOARING PROCESS - Analysis & Process Improvement. Lessons Learned.  2011-2012 SR. QA. ENG. LEAD (CONS.) - (Blue Cross & Blue Shield), Jackson, MS. • Multiple Projects – Converting Paper Process, into WEB Processes, and E-Forms. • PA (Prior Authorization) DSP, NON-DSP, Cholesterol, Testosterone. • HH & HIT (Home Health & Home Infusion). • ePre-Cert (Electronic Inpatient Pre-Certification). • Web Based System, to allow Providers (Doctors/Hospitals, etc), to certify, and process claims with BCBSMS. • Interface with Mainframe, Message Center, and AS-400. • Microsoft SQL & DB2 Databases. • HIPPA Compliant. • Requirement & Design Analysis, Data Analysis, Test Plan, User Acceptance Testing. • Production Implementation Testing, and Post Support. • System Analysis and Performance Testing. • Data Validation (Integrity, System & Business Flow, Security) • Worked closely with the Project Manager, Users, and Developers.  2011 SR. QA. ENG. (CONS.) - (Florida Virtual School), Orlando, FL. • Blackboard Integration Project. • Security Permission Testing, using an SSO (Single Sign-On). • WEB Based, Oracle Database Backend, Microsoft Windows Operating System. • System Performance, GUI Page & Data Verification. • Problem Reporting & Tracking (On-Time Tracking System). • Browsers Testing • Data Point SYNC TESTING, between VSA/Blackboard through Data Exchange. • Worked closely with the Department Manager, BAs, and Technical Lead.  2010 SR. QA. ENG. (CONS.) - (FIS), Maitland, FL. • FIS “External Transfer Application”, for FIS “ONLINE BANKING” software. • Application allowed a customer to transfer funds IN/OUT of their Bank. • WEB Based C Sharp Front End, Microsoft Database& Windows System. • System Performance, GUI Page & Data Verification, Problem Reporting & Tracking. • Testing with various different browsers (IE, Chrome, FireFox, etc.). • ADHOC TESTING, going beyond the initial requirements. • Worked closely with the Department Manager, and Testing Lead.  2009-2010 SR. QA. ENG. (CONS.) - (Motorola), Lake Mary, FL. • PTP250 (Point to Point) Wireless Network, for “MESH Connect” Application. • RAN Technology (Radio Access Network), wireless network. • Wireless Radio Network up to 80 Kilometers, to connect two LANs for Secure Internal Network. • Client/Server based, with a Java Front End, Firmware, on a Linux Operating System. • System Performance, GUI Page & Data Verification, Problem Reporting & Tracking. • Testing with various different browsers. • Coordinated testing activities, using Quality Center. • Testing applications in QTP, and Pity (Based on Python Programming Language). • Wrote communication protocols using Python to communicate and trigger actions in the application through a serial port. • Worked closely with the Department Manager, and Project Manager.  2008 SR. QA. ENG. TEST LEAD (CONS.) - (ERI), Orlando, FL. • Web Based Online Booking/Reservation System for Disney WDPRO. • Magical Celebrations - Commerce Application. • Allow guests to specifically tailor Celebration Activities, while staying at Disney. • Client/Server based, Java Front End, Oracle Back End, through Middleware. • System Load Analysis, Load Balancing, Performance, Problem Reporting & Tracking, etc. • Worked closely with the Project Manager, Technical Lead, and Developers.  2007- 2008 SR. QA. ENG. & OPEN SYSTEM IMPLEMENTATION TEST LEAD (CONS.) - (Elsevier/Harcourt Publishing), Orlando, FL. • Elsevier/Harcourt Separation/Mirror Project. • HIGH VISIBILITY PROJECT, Must Work Situation, millions of dollars invested. • System, Integration, User Acceptance Testing. • Client/Server Platforms, COPS Mainframe, PeopleSoft, Citibank, or Amazon, etc. • System Load Analysis, Load Balancing, Performance, Problem Reporting & Tracking, etc. • Audits as a secondary measure to verify that requirements, and systems check-offs were complete • Managed and coordinated all testing activities, for a Multi-Departmental team of individuals that reported to me. • Worked closely with the Project Manager, BAs, and Technical Lead.  2006-2007 SR. QA. ENG. & SOFTWARE DEVELOPMENT TEST LEAD (CONS.) - (Attorney's Title Insurance), Orlando, FL. • TPR (Title Plant Re-engineering) Project, transition Legacy Mainframe Platform & CICS Database, to Windows Based Client/Server Platform, and SQL Database. • TPR System the Heart of Attorney's Title's Business Operations. High Priority. • Test Plan, Test Procedures, and Test Cases, for Title Master Property Project. • Windows Based Client/Server User Interface to be used by Property Title Examiners. • System Load Analysis, Load Balancing, and Performance, using Visual Studio. • Worked closely with the Project Manager, Technical Lead, and Developers.  2005-2006 SENIOR QUALITY & SOFTWARE DEVELOPMENT ENGINEER (CONS.) - (Harcourt Publishing), Orlando, FL. • TRM (Trophies Resource Manager) Software Package & System. • E-Learning Version of Harcourt's “Trophies Series School Books.” • TRM developed for the New York City School System, with a Goal of becoming a National E-Learning Tool. • Web Based Windows Client/Server System (Linux), written in Java, utilizing an Oracle Database, that allowed Teachers to Schedule and Track Student Learning Activities, as well as interface with informational resources. • QA Testing (Both Manual & Automated Test – QuickTest Pro), Debugging, and Analysis of the TRM System, Identifying any Defects or Problems, and Recommended Improvements. • System Performance and Adherence to “Business & Functional Requirements”, through a Series of Software Releases. • System Load Analysis, Load Balancing, and Performance, Problem Reporting & Tracking, etc. 2005 SR. QA. ANALYST, (Premiere Trade), Altamonte Springs, FL. • C++ Windows Client/Server System (UNIX), which used an Oracle Database, which allowed customers to do Direct Stock Trades or Currency Trades in the FOREX Markets. • Formulated a Solid QA Foundation for Software Releases, and promoting good Testing Procedures, and Developing Test Cases. • QA Testing (Both Manual & Automated Test – Rational Robot) for System Load Analysis, Load Balancing, Debugging, and Problem Solution. • Rational TestManager & Rational Rose to create Automated Testing Scripts for Regression or System Load Testing. 2005 SR. PROGRAMMER, (Jardon & Howard Technologies), Orlando, FL. • C++ Windows & Linux Based System, using an Access Database, for creation of “Narrow Band” acoustic wave forms, to simulate sounds for the U.S. Navy. This required a Secret Security Clearance. • Design, Development, and Testing of that system. • Created and wrote the Test Plan, and developed Test Cases. 1999-2004 SENIOR PROGRAMMER ANALYST, FEDEX CORP., Maitland, FL. • Automated and Enhanced Performance of various complicated processes related to Testing and Data Validation. • Performance testing used TOP, and also Sysmon. Also, at the Operating System Level, looking at what programs are blocking what, Parent & Child Relationships, RAM Usage. database performance, table locking, etc. • C, C++, C Scripting, PERL Scripting (Large Data Processing), Python Scripting, Visual Basic, Expect, Tickle, SQL (SYBASE) & ORACLE Languages • Improved accuracy, eliminated redundancy, and improved Quality Assurance. • Supported Testing Environments, Maintaining Databases (Sybase & Oracle) that included File/Data Access, SQL & MYSQL, Tuxedo, FedEx Proprietor Software, Third Party Software, maintenance of all Internal Developed Software Testing Tools and (Unix & Linux) Operating Systems support. • Planned, executed, evaluated, and documented results of Software Release Testing, for various FedEx Chronos Software Releases. • Created Test Conditions & Test Cases to Validate the Software Release Business Requirements, set down by RAD (Requirements Analysis Development), Developed Test Plans, and Testing Scripts. • SES (SOFTWARE ENGINEERING SERVICES) Software Implementation & Evaluation Group. Evaluated Current SES Software, and Recommended Improvements to Upper Management. • Trained personnel on Software Tool Usage, and Testing Process Execution. 1998-1999 COMPUTER SYSTEM CONSULTANT (FEDEX), Maitland, FL. • Y2K Testing, for the FEDEX CHRONOS MANAGEMENT REVENUE SYSTEM. • Sun Systems (Solaris) / Client Server Unix based… • Evaluation of, database performance… (SYBASE), TUXEDO SERVICES, Mainframe Interface Operation (IBM LEGACY SYSTEM), Third Party Software (Java, Netscape, etc.…), and Chronos Internal Software. • Diagnosed complicated problems involving the System Environment, database access & integrity, FTP, and Chronos Internal Software. Worked with Development Teams to identify & implement corrections. 1995-1998 COMPUTER SYSTEM ENGINEER, TOPTECH SYSTEMS, Longwood, FL. • Custom Built System to Automate Petroleum & Chemical terminals. QNX (UNIX), in a GUl windows environment. This included, database management-maintenance (ISAM) and setup of TCP/IP networks, PLC's, routers, C script writing, etc. • Corrected diverse hardware/software problems, operating systems, user software, communications, etc. • Diagnosed customer problems involving TCP/IP and other host communication protocol. • Customer Training 1993-1995 ENGINEERING CONSULTANT, SYSTEM ONE STAFFING, Orlando, FL. • Diagnosed customer engineering problems, and advised improvements. • Redesigned a cumbersome engineering test reducing testing time and errors. 1982-1992 SEMICONDUCTOR QA ENGINEER - IBM CORP., East Fishkill, NY. • Project Manager - managed a team of engineers and technicians tasked to evaluate new technologies, and present findings to upper management. • Semiconductor Chip Quality Assurance Reliability Qualification • System & Tool Development • Data collection/reduction/analysis. • Interfaced with vendors for all materials/services/tool development. • Served as “Capital Coordinator" responsible for technical/budgetary planning. • Safety Coordinator, responsible for IBM/OSHA compliance. • Trained personnel. EDUCATION Union College, Schenectady, NY Courses towards B.S. In Computer Science A.A.S., Electrical Technology, Dutchess Community College, Poughkeepsie, NY, 1982 Hudson Valley O.I.C., Poughkeepsie, NY, Year long course in H.V.A.C. and Refrigeration, 1978 Additional Technical Courses C and C++ Programming Language Java Programming Language Object Oriented Programming Concepts Sybase Database Administration Oracle Database Administration PERL Programming Language PL/1 Programming Language APL Programming Language Statistics SKILLS • Programming - C, C++, Java, C Scripts, Perl Scripts, Visual Basic, Basic, Html, Flash, Python • QA, Engineering & Systems Analysis, Client/Server Testing • Operating Systems- Linux, UNIX, QNX, Windows, Mainframe, AIX • System Analysis, System Architecture • Databases - ISAM (Index Select Access Method), Sybase, Oracle, Access (Relational), Microsoft, DB2 • Graphic Tools – Visio, Photoshop • Configuration Management – PVCS, ClearCase, SourceSafe • Problem Tracking & Logging – TestTrack Pro, TestDirector, WebStar, Quality Center, ALM, Jira • QA Automation tools – Rational (TestManager, Rational Rose, Rational Robot), Mercury (QuickTest Pro, WinRunner, Visual Studio, Selenium and Custom QA Tools I designed and created. • Performance Tools – LoadRunner, TOP, Sysmon, etc. • Communication Protocols – RS232, IEEE

Dear Hiring Manager, As a well-experienced software delivery professional, I read your posting with keen interest and I felt motivated to submit my resume for your review. My flare for advancing technical performances, improving systems’ competency via the implementation of modern technical strategies, offering supports to users, and driving team advancement through trainings, gives me great mettle and confidence in my ability to bring quantifiable improvement to the technical arm of your organization. Revamping systematic productivity and competitive performance by skillfully aligning resources with objectives is one of the many ways I served an instrumental role in the success of all past employers. Equipped with firsthand experience in advancing and maintaining systems competency and capacity. I am also well-versed in multiple functions Including Requirement Gathering, Risk Assessment/Management, System Maintenance, Workflow Reengineering, Cost Management, Strategic Planning & Execution, Software QA, Technical Support, Project Management/Development, Requirement Testing, Staff Training & Development, implementation and support practices while enforcing compliance with best practices. My expertise in facilitating overall workflow, with a reputation for providing exceptional consultative support, are key strengths. As a result-oriented individual with a rigorous work ethic, my core strengths in technical needs analysis, operational direction, and systems maintenance are sure to render me an immediate asset to your organization. Thank you for your time and consideration. I would be happy to discuss my qualifications in an interview setting further. Sincerely, Charles M. Johnson.

Excellent use of excel to create reports, data and MI creation. Experience in handling helpdesk via emails, chat and calls. Onboarding and off boarding users in various platforms and application