OBJECTIVE

• Seeking a position that will continue to develop and challenge my skills in the IT/IS profession. EXPERIENCE Application Web Developer Confidential
• Support primary facility as well as global facilities through development of data-driven web tools that track labor functions, defects, and overall performance as well as tools that assist with determining business and facility trends.
• Create data-driven sites that provide real-time results based on user input, ability to store, retrieve, and delete as needed and accessibility for users across the entire network to include Eastern United and North American facilities using tools like PHP, Java, Jquery, curling, and sql data.
• Create adhoc and scheduled SQL queries using Oracle and MySql databases.
• Maintain and develop SQL queries and web tools as the DBA owner of a MySQL database running off a Linux server, an ETL Oracle Database, and administrator of 1 Linux server running LAMPP with RHEL5 and an EC2 cloud server running XAMPP and RHEL5.
• I/S Application Developer Confidential Assisted in the migration of the portfolio system from the former Wachovia to Wells Fargo.
• Created JCL and procedures for production and testing capability based on corporate standards that afforded minimization in future support.
• Developed, maintained, and supported tables, table names, and data on a UNIX system.
• Created scripts for research, testing, and manipulation of databases and relevant data.
• I/S Application Programmer Analyst III Confidential Maintained and modified programs made approved changes by amending flow charts, developed detailed programming logic, and coding changes. Tested and developed programming modifications. Documented programming problems and resolutions for future reference
• Maintained, designed, developed, tested, implemented, monitored and supported complex client/server databases with respect to data validation checks, organization, protection, security, and documentation including overall monitoring of standards and procedures, and systems integration. Programming and design experience with SQL Server 2000/2005/2008 and Oracle 8i/9i Database Systems queries, stored procedures, views, and triggers .
• Conferred with users to gain understanding of needed changes or modifications of existing programs. Resolve questions of program intent, data input, output requirements, and inclusion of internal checks and controls.
• Planned, designed, and implemented application database code objects, such as stored procedures and views. Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Create test data based on needed application which may include GSAM, VSAM, flat dataset files, or online data for screen verification
• Create test scenarios or research production issues by retrieving database information using SQL to generate reports
• Create regression testing for system changes or new coded programs for end to end results using test matrixes, smart tool, test data files, or assumed break/fix test case scenarios
• Documented defect and system code issues for traceability and research for possible future issues of similar instance
• Verify job statuses, program completion codes, or research potential job issues through SDSF
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages. Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability. Wrote triggers and stored procedures to integrate 3rd party applications into in-house apps such as project management systems with a minimum of development time, helping the company build new partnerships faster.
• Designed and populated reporting tables, views and stored procedures, implemented partitioning to handle tables with over 300 million rows. Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
• Authorized technical documentation for the system enhancements and bug fixes for written codes. Evaluated simple interrelationships between programs such as whether a contemplated change in one part of a program would cause unwanted results in a related part.
• Responsible for disaster recovery planning for SQL Servers, Mainframe programs, and Online screens.
• Created database triggers and managed the subprograms and triggers. Reviewed data access controls and provided recommendations in improving the security. Analyzed, identified and implemented user roles and assigned relative database access privileges. Reviewed security around the database by monitoring the Critical Roles of the Oracle database.
• Suggested, developed and implemented Scaling out solution with Data partitioning.
• Maintained confidentiality with regard to the information being processed, stored or accessed.
• Worked with project manager to plan, estimate, schedule and implement programming tasks provided recommendations for application and system improvements.
• Maintain new and existing elements in Endevor through a TSO mainframe session
• Provide outside customers the ability to successfully research enrolled members by claim and/or Social Security number using online CICS screens
• Handle work requests and/or projects mandated by the Federal government to include system fixes or upgrades to satisfy their needs by creating scope design documents and technical specs that outline the business needs
• Research and resolve any production issues that may arise that could cause the system cycle to not complete successfully in addition to normal daily programming tasks
• Interact with internal and external customers to create a business plan to include: estimated time of completion and high level estimate of efforts, scope/design document outlining the business requirements, and technical specifications that identify the business need and system approach for all elements affected and the programming changes needed to achieve the customers expected results
• The application development methods used include: COBOL, CICS, JCL, APS, DB2/IMS, StreamWeaver and TSO programming conventions
• Used Visual Basic to create VBScripts in order to automate job scheduling, program manipulation, and system routines that helped speed up productivity and enhance proficiency
• Ability to work in Operating system environments, Database concepts and facilities, Telecommunications and networking concepts and capabilities in a Mainframe, Midrange, and/or PC/LAN environment
• I/S Production Support Analyst II/AFP Administrator Confidential
• Processing all Advanced Function Printing AFP requests for changes or creation of new print resources
• Create production ad-hoc reports from DB2 tables using SQL commands
• Coding new forms static page layouts , formdefs allows multi page document to have print resources for each individual page and pagedefs programmatically aligns the variable data on each page upon customer request or in order to resolve any production issues that may need attention
• Create regression testing for system changes or new coded programs for end to end results using test matrixes, smart tool, test data files, or assumed break/fix test case scenarios
• Troubleshooting Cobol or CICS programs as well as production data files in order to resolve print issues or any programming problems
• The application development methods used include: COBOL, CICS, JCL, APS, DB2/IMS, and TSO programming conventions
• Create test data based on needed application which may include GSAM, VSAM, flat dataset files
• Maintained confidentiality with regard to the information being processed, stored or accessed.
• Worked with project manager to plan, estimate, schedule, and implement programming tasks provided recommendations for application and system improvements.
• Maintaining all mainframe and UNIX system libraries using SQL and Unix commands in order to successfully research, update, and or edit print resources or system resources needed to complete customer requests
• Create any digitized logos or signatures that may be needed upon customer request
• Assist in the creation and testing of data cards, using programs such as CorelDraw and Corel Photo Paint
• I/S Production Support Analyst/AFP Administrator Confidential
• Running all production jobs including mail center and corporate mail for the purpose of adding into the InfoPrint Workflow System IPW
• The application development methods used include: COBOL, JCL, APS, DB2/IMS, and TSO programming conventions
• Testing all production jobs in order to create an AFP control or ACIF control file, whichever may be applicable or setup document types for each individual job ensuring 2d barcodes are in sufficient placement as to avoid conflict with data on each document
• Keep customer relations close with programming staff, accounting personnel, and customer area
• Maintained confidentiality with regard to the information being processed, stored or accessed.
• Worked with project manager to plan, estimate, schedule and implement programming tasks provided recommendations for application and system improvements.
• I do any production reprints from any other lines of business containing JCL's job control language running through the scheduling system
• I maintain the resource system libraries on the AIX server , adding new pagedefs, formdefs, psegs logos and overlays static forms when needed, and keeping the production libraries on AIX current compared to what is added to the mainframe using Unix script commands.
• Provide assistance with the creation and testing of Insurance data cards by using CorelDraw to design an outline and running test cards through the data card machine to be sent to the customer for approval

I/S Production Control Specialist

Confidential

• Balancing cutoffs, creating new cutoff sheets, and keeping all documentation current. Making sure all appropriate work is accounted for and rerun any work that needs to run before release of checks
• Provide a communication link between the correct areas of responsibility about the cutoffs and provide a resolution for any complications

Skills

• DB2
• IMS/DB
• SQL Server
• Oracle 8i,9i,
• MySQL
• ETL
• Visual Basic
• Redhat5
• IBM DB2
• AIX/Linux/UNIX
• Windows Vista/XP
• MS Office Suite
• Visio 2000/2002
• Advanced JCL
• AFP Indexing
• Cobol
• Easytrieve
• CICS
• IMS
• TSO
• Endevor
• APS
• ISPF/SDSF
• CSS
• HTML/XHTML
• PHP
• XML/XSL
• jQuery
• Java
• SharePoint
• Adobe
• Dreamweaver
• Adobe Photoshop
• Corel Paint
• Shop Pro
• Excel
• PowerPoint