System Architect Developer & Consultant Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Objective:

To assist companies in creation of information systems that meet their needs, enhance productivity, reduce cost, and support business development and continuity.

Technical Skill Set:

 Hardware:            PC/HP-UX/Linux Client/Server environment, AS/400, networking equipment, Macintosh, IBM Mainframe.

Software/Tools:    Microsoft Access, Excel, Visual Basic (VBA/.NET), ORACLE, ORACLE  PL/SQL, Visual Studio, Microsoft SQL Server 2008R2, SSRS, ETL, DTS, SSIS, T_SQL, Crystal Reports, Unix, Linux, Focus reporting software, Windows, Word, Outlook, PowerPoint, SharePoint, Project, Explorer, Visual Studio, ORACLE Forms/Reports, OS/400, DB2, Hyperion, ERWin, Visual Source Safe, Java, PowerBuilder, Silverstream, COBOL, Sybase

Certifications:      Certified Information System Auditor (CISA), Certified Information Systems Security Professional (CISSP)

Professional Organizations:

                          Asst. Treasurer - Information Systems Audit and Control Association (ISACA) Willamette Valley Chapter.

                          Member – Information Systems Security Association (ISSA) Oregon Chapter

Education:

University of Portland: B.S., Mathematics, programming courses

Portland Community College: Studies in Accounting and Information Technology (Computer Operations, Systems Analysis, Java, Oracle Forms 6i/Oracle Reports 6i, Win2000 Administration, COBOL, Assemblers, Basic)

Self Studies/Other Training:  MS SQL Server Database Design, Oracle PL/SQL and Advanced Database Concepts, Fundamentals of IT Audit, Crystal Reports, Advanced Excel.

Information Technology Experience:

Hewlett Packard, Inc.                                                                                    04/11-03/12

System Architect / Developer - Consultant

• Integrated external contract management system and external supplier system into an MS Access Database. Created data quality controls, metrics and reporting.
• Created MS Access Engagement Tracking system for software contracts. Included 24 automated weekly Excel charts. Automated SharePoint posting.
• Created tools for Intellectual Property management.
• Participated in system testing new release of contract management system. Created a tool for and led data cleansing and migration for department contracts.

Environments: MS Access, Excel, SharePoint, Ariba Contract Management System.

Portland Energy Conservation, Inc.                                                               03/11-03/11

Database Programmer - Consultant

• Migrated MS Access application tables to SQL Server back end. Developed scripts to create database, logins, users, tables, primary and foreign keys, privileges, and migration of data from Test environment to Production. Database documentation.

Environments: SQL Server, MS Access.

Standard Insurance Company                                                                        11/09-11/10

Information  Analyst

• Worked with clients and other analysts to develop the Excel/Access/Oracle/SAS automated update and production of 297 process monitoring boxplots and outlier PDF reports.  Automated posting to SharePoint.
• Created dynamic Bubble Charts and Trend Charts
• Database maintenance
• Created automated import to database for Audit worksheets (non-table Excel workbooks).

Environments: Oracle 10G, MS Access, Excel macros and charts, PDFs and SharePoint.

Pacific Crest Technology                                                                             01/08-01/09

Business Analyst

• Worked with clients and developers to clarify project requirements. Developed functional designs, business rules and test cases. Participated in testing and system conversions.
• Created overall SDLC process improvement by rewriting company’s functional design standard. Created hierarchical framework for requirements definition, functional design, business rules and test cases and implemented in software creating a project documentation and status reporting system with QA controls. Integrated with existing test documentation system via ODBC and CSV Import/Export.
• Awards: Management Team certificates of recognition for project completion.

Project Coordinator

• Performed project documentation audits.
• Archived project documentation.
• Set up, attended and documented portfolio review meetings. Updated and reported portfolio status.
• Confirmed authorization, established, monitored, renewed and terminated user access to client environments.
• Established projects in accounting and documentation systems of record.

Environments: IBM Mainframe via emulator, Web, My SQL, Microsoft Access, VBA, Oracle 10G, Oracle stored procedures, COBOL, Web conferencing, Visual Basic, Excel macros and charts.

Consultant(Reporting Analyst) - Hewlett Packard                           01/07-12/07

• Automated daily manual audit and reporting process, reducing a 2-hour process to 45 minutes and eliminating substantial data entry error risk.
• Designed, developed, documented and trained users on VMS Tools expert system. System imported sales and product information from external systems, validated, transformed, combined and summarized data, exported CSV files for Excel reports and charts, combined and zipped reports for distribution, created emails and archived reports. Reports included daily, monthly and YTD sales and product summaries, daily and monthly inter-report control audit reports and Cybersource (Payment Card Processing provider) Reconciliation report.
• Maintained Excel macros and charts for production reports

Environment: Informatica, SCP, ORACLE 10G, Cybersource, Microsoft Access, VBA, Excel, and Outlook, Zip, Sharepoint

Robert Half International                                                                                

Consultant – Lucy Activewear, a retailer                                         10/06-12/06 

·         Designed, developed, documented and trained users on InfoPort Reporting System, integrating and reconciling product ordering and distribution databases. Scheduled imports to optimize system currency and performance. System included 27 different reports.

Environment: Microsoft SQL Server 2000, DTS (Data Transformation Services), stored procedures, Microsoft Access, VBA, Excel macros and charts, ODBC, CSV Import.

Protiviti                                                                                                           12/05-09/06 

Consultant

• Member of a SOX Internal Audit team for a manufacturing client. Performed process walkthroughs, documentation audits and testing.
• Performed IT SOX General Controls Audit for a gambling casino.
• Performed GLBA network traffic assessment for a bank.
• Performed data inventory and worked on data retention and data sensitivity policies for an international corporation.
• Developed supply chain risk software for manufacturing clients.
• Worked on team auditing major telecom switch center equipment.

Environments: NOC, Web, SAP, Oracle 10G, Oracle Financials, Microsoft Access, MS SQL Server stored procedures, Visual Basic, Excel

Comsys Computer Services                                                          09/05-12/05       

Consultant – Hewlett Packard

• Developed software for data entry of printer test information.
• Developed software to automate the creation of Excel charts displaying performance of printers with various paper types in various environments.

Environment: Microsoft Access, Visual Basic, Excel, Hyperion, Oracle 10G

Robert Half International                                                    10/04-12/04     

Information Systems Auditor

• Member of validation testing team for SOX 404 pre-assessment of application and general controls at a major wireless telecom provider.
• Performed process walkthrough interviews, re-performance and independent validation testing and reporting, access management studies and assessments, documentation, project tracking, collection and organization of evidence for external audit.

Environment: Microsoft Access, Excel, Web

PCTest Corporation                                                                            06/04-09/04         

Consultant

• Performed data center risk assessment and business continuity planning. 
• Did market research and made sales calls.
• Participated in CRM/Project Management tool design.
• Developed customer and internal surveys for continuous improvement measurements.
• Worked with automated scripting tool for application load testing.
• Researched automated vulnerability assessment tools.

Environment: 100-PC Load Test Lab, Load Test software, VMWare

Electric Lightwave, Inc.                                                                04/95 – 05/02 

Senior Programmer/Developer

• Analyst/administrator for telecom CRM and Billing Systems.
• Developed MS Access software integrating internal systems with external provider systems.
• Coordinated and established user access to external systems.
• Developed and managed an MS Access revenue data mart and multiple reporting systems for Billing and Collections.
• Performed data mining and report development as needed. Created and maintained over 50 production revenue reports and numerous ad-hoc reports.
• Responsible for accuracy of monthly A/R in excess of $1,000,000. Performed revenue report audits verifying consistency between billing and reporting systems.
• Created database infrastructure and multiple views for different security levels. 
• Developed and managed web-based (J2EE), Oracle-backed tech support service request system and survey analysis system. 
• Participated in acquisition of telecom billing software.
• Participated in multiple system migrations and application testing.
• Maintained internal websites.
• Provided support to users from executive management to front-line.
• Awards: Vice President's Letter of Recognition for work resulting in refund of over $500,000 in excess taxes.  Council of Leaders Award. Awards for Process and Service Improvements. Awards for Cost Savings and System Conversion.

Environments: IBM Mainframe, DB2, IXPlus telecom billing, CRM and provisioning software, Arbor telecom billing software, ASAP Provisioning and CRM software, HP/UX Client/Server, Microsoft Access, VBA, Web, Sybase, Oracle 8i, Oracle and T-SQL stored procedures, Focus reporting software, Java, HTML, Unix, Perl, COBOL, Excel

Northwest Telco                                                                                             06/90 – 02/95

Coordinator of Information Services

• Conversion project lead on system migrations.
• Supervised production assistant and computer operators.
• Systems administrator. Performed configuration management, software upgrades.
• Primary contact for production control. Scheduled batch jobs to optimize system performance.
• Vendor Liaison.
• Database Administrator. Tailored access to users’ roles.
• Primary contact for hardware/software support for users in 4 cities.
• Billing Production Manager. Responsible for revenue/data control for monthly billings in excess of $2,000,000.
• Analysis and Programming. Tailored canned billing system to meet company requirements.
• Data mining, ad-hoc and production report development as needed.
• Awards: Chairman's Excellence Award.

Environment: AS/400, DB2, SQL, COBOL, Networking

Download Resume Format