Jackson John Email & Phone Number

United States

• Five plus years of hands-on experience with IBM Optim data archival tool• Good understanding of database Life Cycle management• Good command of SQL for multiple relational database environments (e.g., Oracle, DB2 LUW, DB2 Mainframe, Postgres, MS SQL Server, Teradata etc.)• End to end Optim data archive expertise (like Create Access Definition, Archive Request, Extract Request, Restore Request, DB alias configuration on multiple sources• Extensive knowledge on Optim Connect• Generate Reports for archive requests and delete requests for audit purpose• Experience on Unstructured data archival• Automation skills with Python, shell script, Power Shell• Knowledge to apply ifix for Optim when needed• Knowledge on upgrading Optim version• Manage and maintain Data Archival processes• Monitor and tune data archival performance• Create storage profiles• Create Legal holds based on the data retention policies• Mentor team members to develop talent on the data archival• Provide insight to team leadership regarding best practices for data archival• Level 3 support for on call support• Setup security standards, guidelines• Experience with cloud implementation with Data Archival• Experience with database level encryption

Maplewood, Minnesota, United States

• Administered IBM Infosphere suite of archive tools. (MS SQL, DB2, IBM Optim, and various other scripting tools)• Designed and executed archive of structured data sources including DB2, MS SQL, Oracle, etc.• Designed and executed archive of non-relational data sources including IMS, Datacom, Mainframe, etc.• Designed and executed archive unstructured document sources including.PDF, XLS, CSV, TIFF, DOC, JPEG, etc…• Participated in the development and implementation of data analysis processes.• Consulted with IT subject matter experts and business data owners to analyze application data required for archive retention. • Contributed to the strategic direction of the project tools and systems used to perform data staging and archiving.• Worked with software vendors and 3M IT technical support groups to provide product support for the project tools and resolve technical issues.• Collected and reported application system metrics and archive management metrics.• Frequently presented archive verification decisions confidently in meetings.• Frequently connected to and utilize all types of database systems and files systems. • Articulate complicated technical details to technical and non-technical team members.

St Paul-Maplewood

Key Result:- Led a development and support of Corporate Security's internal web and non-web integrated security applications.- Participated in setting the strategic direction for Corporate Security application architechures, tools, technologies and processes.- Provided technical leadership and support for externally purchased application tools and solutions.- Develop solutions for complex and diverse issues that may be interrelated, requiring significant interpretation and the use of strong analytical skills.- Cultivated and maintained liaison between Corporate Security I.T, HR administration and other key Business staff organizations.- Developed and maintained documentation for system and user components and processes

Minneapolis

Responsible for eliciting business requirements and investigating new opportunities business may benefit from. Analyzed the opportunities and proposed suitable solution to the business. Documented and communicated the solution to senior management for decision. Manage vendor relations regarding application enhancements and new releases. Led team of six in testing application releases and developed releases processes. Key Results:- Managed a project of migrating documents from an old system to the new application, which was delivered on time and under budget.- Developed request for information (RFI) documents for selecting vendor to implement electronic case management system.- Developed proccess of evaluating how IT can provide services to the line of business and led group of IT managers to understand the operations.- Developed training instructions and trained the line of business staffs how to use the case management system.- Created reports specification for the line of business to captured client's that has criminal records with active probation.

Greater Minneapolis-St. Paul Area

Assumed responsibility for elicit, investigated, analyzed, communicated, documented and evaluated of business requirements to developed customized solutions and business process model. Participated in technical analysis of systems-applications and coordination of system implementation plans, and make recommendations for automation solutions via written proposal or presentations.Key Results:- Developed and managed project schedules for case service tracking system (CSTS), a $2M software deployment project.- Facilitated Joint Application Development (JAD) sessions and developed Business Requirement Document (BRD) for the development of recidivism reports, which measure the effectiveness and efficiency of the programs to rehabilitation of inmates.- Developed AS-IS and TO-BE business process models to streamline central intake clients processing time for probation or booking to county jail.- Developed user acceptance test plans document with the framework of software testing circle, which has helped in the implementation of case services tracking system (CSTS) project and delivered on scheduled.

Greater Minneapolis-St. Paul Area

Identified and analyzed business processes to improve efficiencies, recommended and implemented technology solutions from concept to implementation. Modeled new business processes and customized solutions.Key Results:- Designed and implemented fully automated breakfast online ordering and e-mail notification system utilizing ASP.NET, which resulting in a reduction of 75% daily breakfast ordering time cycle.- Led a team of eight and successfully implement the Domestic Relationship Software (DRS) for Family Court Service.- Developed and deployed employees' vacation request form, which provide paperless and timely approval process.- Developed RFP for a scheduling software for Hennepin County Home School for managing employees schedules.- Maintained smaller scale database for employees' management system to mitigate union's overtime regulation, which is non existence in HR application.

Minnetonka

Provided tier II technical support to1000+ customers and resolved complex application system issues. Responsible for the development and communication of quality assurance reports to senior managers.Key Results:- Led team of four to performed quality assurance (QA) on IRS new released forms and updated Convey Compliance System tax forms according to IRS instruction.- Developed training manaual for Tier one technical support.

Master, Software System

Bachelor, Computer Information System

Associates, Computer Science & Liberal Art