We provide IT Staff Augmentation Services!

Systems Analyst Resume Profile

4.00/5 (Submit Your Rating)

EXPERTISE:

  • Databases Oracle 11g, 10g, 9i, SQL Server 2008, Data Warehouse and OLTP, DB2, MS Access,
  • MS Excel, Teradata
  • Languages Oracle PL/SQL, SQL Plus, Oracle SQL, SQL Server 2008 SQL, Transact SQL T-SQL ,
  • Teradata SQL, XML, Unix, Cobol2, Visual Basic, CICS, and JCL
  • Data
  • Modeling ERwin All Fusion 7, 8 and 9, SQL Server Management Studio, Access, IEF Composer
  • Software SQL Developer, SQL Server Management Studio, Oracle Developer/2000,
  • Oracle's 11g SOA Suite, Oracle Developer Suite, SQL Navigator, TOAD,
  • Windchill Flex PDM, Oracle Hyperion, DB2, Windows NT, XP, 8 and Teradata

EXPERIENCE: Suburban Tactics, Beaverton, Oregon

DATA MODELER 5/2014 to 11/2014 Designed and created the Firearms Training Management System data base. This relational model is used to track and record all aspects of enrollments, course requirements, grading, fire arms qualifying, and certifications. Gathered requirements, created the conceptual, logical and physical models. Software used: Visual Studio, ERwin r9.5 data modeling tool and SQL was the database language.

Columbia Sportswear, Beaverton, Oregon

  • DATA MODELER 4/2012 to 11/2012
  • Modified, designed and created data warehouses for this international apparel and footwear corporation
  • using ERwin 8 data modeling tool.
  • Performed requirements gathering, created data maps and data models both logical and
  • physical.
  • Performed data analysis and data integration between multiple ERPs and existing databases.
  • Platforms included Teradata and SQL Server.
  • SQL and T-SQL were the main database languages.

Confidential

DATA MODELER

  • Designed and created data warehouses for this international truck manufacturing corporation using
  • ERwin r7 All Fusion data modeling tool.
  • Performed requirements gathering, mapping documentation and data model creation, both logical and
  • physical.
  • Created, debugged and modified Informatica ETL sessions and workflows.
  • Interfaced applications from different platforms.
  • Platforms included Oracle 11g, DB2 UDB and SQL Server Management Studio.
  • SQL and T-SQL were the main database languages.

Confidential

TECH LEAD INFORMATION ANALYST
  • Responsible for growing the business orchestration part of this insurance claims processing system.
  • Provided process design and developed software using Oracle's 11g SOA Suite with JDeveloper 11g.
  • Gathered and documented business and technical requirements.
  • Created and tested web service data integration and business intelligence interfacing.
  • Conducted technical interviews and trained new team members on Oracle's BPM development software.

Confidential

DATA MODELER DATABASE DEVELOPER
  • Designed and created logical and physical data models normalized and dimensional for the creation of
  • a Diabetes Management Health Care System. The OLTP system was created using
  • SQL Server Visual Studios and Transact SQL T-SQL .
  • The data warehouse supports business intelligence for identifying trends and
  • areas for treatment improvements.

Confidential

SYSTEMS ANALYST DATABASE DEVELOPER
  • Performed detailed analysis, design, technical specification creation, coding and testing of enhancements
  • to the OLTP AMP Apparel Materials Purchasing System as a part of the Mid-Month Buy Project
  • within the Nike ONE Project.
  • Analyzed, modified and tested complex PL/SQL packages, SQL queries, relational and external
  • Oracle 10g database tables. Modified Excel spread sheet and macros.
  • The operating system was UNIX HP-UX

DATA MODELER DATABASE DEVELOPER

  • Created business intelligence reports for international management sales analysis.
  • These BI reports compared sales orders, sales personnel performance and business traffic for weekly,
  • monthly and daily time periods by retail store.
  • Designed and created data models normalized and dimensional for enterprise data warehouse
  • and OLTP subject areas with Erwin's All Fusion data modeler and Oracle 10g.
  • Held meetings with technical staff and subject matter expert for requirements gathering.
  • Business intelligence reports and data warehousing were created with Oracle PL/SQL, SQL,
  • Hyperion and Excel.
  • Created and maintained complex ETL for data warehouse population and data extracts for
  • web analytics by a third party vendor.
  • Created and maintained complex PL/SQL packages and queries.
  • Communications with users and business analysts was a main part of this assignment.

DATA ANALYST DATA MODELER

  • Performed data analysis on existing OLTP Oracle 10g database and Flex PDM ERP system.
  • Created logical relational and dimensional models for business intelligence reporting to support
  • management decision making, manufacturing and logistic bottlenecks on an international scale.
  • Data migration with ETL for this BI system was created and executed using Informatica Powercenter
  • 7.1.2.
  • Created data analysis tools with Oracle's 10g PL/SQL.

SYSTEMS / DATA ANALYST DATABASE DEVELOPER

  • Provided production support for the Global Analytics enterprise data warehouse.
  • Created and maintained Oracle packages, functions and procedures for BI reporting of international inventory.
  • Performed requirements gathering for impact analysis business rule changes.
  • Tuned or recreated PL/SQL and Materialized Views. Created and modified dimensional models.
  • Modified ETL logic using Oracle's external tables.
  • Created Unix and PL/SQL scripts to create and modify data mart objects.
  • SQL Navigator, SQL Plus, were the primary software development tools used.
  • The operating systems used for development were Unix and Windows.

Confidential

DATA MODELER DATABASE DEVELOPER
  • On this EAI project Enterprise Application Interface , system creation and system interfacing
  • were my job responsibilities.
  • I was also responsible for requirements gathering, interviewing staff, OLTP relational database creation and population. SQL Server Visual Studio was used to create logical and physical models.
  • I performed database population using the Oracle ETL tools, External Tables and SQL Loader.
  • For the change capture, transformation, and table population, I created table triggers, procedures, functions, and packages using Oracle's 9i PL/SQL and SQL.
  • Dimensional modeling for business intelligence reporting was performed to produce promotion and sales analysis.
  • Physical Data Modeling was performed with SQL and SQL Server Visual Studios.
  • The operating systems used for development were Unix and Windows.

Confidential

DATA MODELER DATABASE DEVELOPER
  • Designed and developed this ranching accounting system which features:
  • expense tracking and reporting
  • scheduled maintenance and history reporting of health care
  • value estimating system for livestock
  • attribute tracking and reporting for sales promotion
  • All forms, reports, and database tables were created using Oracle 9i Forms,
  • Reports, SQL Plus, and the Oracle PL/SQL programming language.
  • Logical and Physical data modeling was performed with ERwin and Access.
  • Provided the analysis, design and development of the database, forms, reports and software processes.

Confidential

MENTOR CONSULTANT
  • Taught, designed and developed Oracle 9i Forms for the Equipment Management System.
  • Assisted with database design for tracking calibration equipment and system security.
  • Created packages and stored procedures using Oracle's PL/SQL. These Oracle Forms were based on stored procedures and SQL tables.
  • Provided key solution to integrate development team and data security restrictions.
  • Instructed software engineers on Oracle Forms and PL/SQL development.

Confidential

PROGRAMMER ANALYST CONSULTANT
  • This banking credit card conversion project required the creation of SQL scripts,
  • reporting, and stored procedures using the PL/SQL programming language in
  • Oracle 8i. The Oracle software development facilities used were SQL PLUS, and
  • Oracle Reports in Developer/2000.
  • Provided analysis, design, development, and testing for this project.

Confidential

DATABASE DEVELOPER
  • Data Warehouse construction, and ETL data migration from OLTP Oracle 7.3 and Mainframe,
  • to Oracle 8.1.6 data warehouse. This business intelligence system was created for membership
  • tracking and projections over a multi state region.
  • The programming languages used were PL/SQL, SQL Plus, Unix, and Perl.
  • The operating system was Unix Solaris v2.6. Client operating system was Windows98.
  • SQL Navigator was also used for development.
  • Streamlined online time tracking system.

Confidential

DATA MODELER DATABASE DEVELOPER
  • Created and modified logical and physical models for OLTP sales campaigns systems.
  • Performed data analysis and created ETL processes to cleanse client data for
  • system integration and business intelligence sales and survey reporting.
  • Modified logical and physical relational and dimensional models for sales analysis BI reporting.
  • The operating systems used for the business software development were
  • Windows NT, 98, and Unix.
  • Clients included GTE Wireless, Discover Card, Airtouch, and more.
  • Logical and Physical data modeling was performed with ERwin and Access
  • for Oracle 9i databases.
  • > Awarded bonus for successful extra effort.

Confidential

SYSTEMS ANALYST CONSULTANT
  • Designed and created the Point Of Sale accounting system for this mail order sales company.
  • ERwin was used for Logical and Physical data modeling.
  • Oracle 8i was used for database construction. Forms and reports were created with Oracle's Developer/2000 Forms6.0, Reports6.0 and Procedure Builder6.0.
  • The programming language used was PL/SQL. The operating system used was Windows NT.
  • Performed all phases of the systems development life cycle.

Confidential

  • SYSTEMS ANALYST CONSULTANT
  • Provided the analysis and design, to interface the MCMS system to the Oracle Financials Accounts Payable system, also the conversion of Legacy to MCMS systems.
  • Project required knowledge and use of Relational Database design, Online
  • and Batch systems, Oracle Financials, PL/SQL, SQL, DB2, Cobol, and CICS.

Confidential

TEAM LEAD, DATA ANALYST CONSULTANT
  • Performed data modification impact analysis, supervised modification and testing.
  • Created and turned over Year 2000 project requirements documentation.
  • Resolved technical and client issues. Interviewed and supervised employees.
  • Technologies included DB2, SQL, CICS, Cobol, JCL, Access, Office 97, and Viasoft tools.
  • Selected as point man by client manager.

Confidential

DESIGNER, PROGRAMMER/ANALYST

Wrote data conversion programs from DB2 to the SAIF corporation's Oracle

  • accounting system. PL/SQL, SQL, DB2, and Cobol were used for transferring and editing data for specific selection criteria, as required by the Oracle system.
  • All editing and data selection was performed with SQL and Cobol2.
  • Rehired a second time by Computer People Consulting.

Confidential

DESIGNER, PROGRAMMER/ANALYST CONSULTANT
  • Used Oracle7, PL/SQL2, SQL Plus, Visual Basic 4.0, SQL Server, and Windows NT to create a system for monitoring the Salmon survival for the Oregon Fish and Wildlife Agency. Also created PL/SQL Procedures and Functions for
  • Willamette Industries Human Resource systems.

Confidential

DESIGNER, PROGRAMMER/ANALYST CONSULTANT
  • Maintained and wrote programs for Nike's Returns system, and production
  • support using SQL, DB2, Cobol2 and CSP.
  • Also created an office system using Visual Basic Access and Windows 95, which produces the contracts, work orders, reports, and timesheets for PRODX.
  • Performed maintenance on OLE legal software using Visual Basic and Access.
  • Rehired for a third assignment by PRODX.

Confidential

DESIGNER, DATA ANALYST CONSULTANT
  • Performed logical and physical database modeling. Participated in JAD sessions and constructed database designs using IEF's Composer CASE tool.
  • The project was for the Accounts Receivable Management System.
  • Composer was used for Logical and Physical data modeling.

Confidential

DESIGNER, PROGRAMMER/ANALYST CONSULTANT
  • Designed and programmed online and batch Resource Management applications for First Interstate
  • Bank of Portland using DB2, SQL, CICS, Cobol2.
  • Improved production software performance for database access.

We'd love your feedback!