Gene Fetter

IT Consultant

Personal Details:

Name: GENE FETTER (US Citizen)

Address: ***** ***** ***

Sunland

Los Angeles

91040

Phone: 818-***-****

Cell: 626-***-****

Email: ac6ejb@r.postjobfree.com

Availability: current

Professional Summary:

Systems analyst with over 20 years of technical project experience in Banking, Telecoms, Utilities, Transport and Education industries with a deep understanding of Logical and Physical Database design & development, test and integration. Experienced in business analysis in matrixed environments, resource planning, application analysis, requirements gathering, documentation, ER Diagrams, UML diagrams and Use Cases, UAT testing, cost estimations, resource requirements and estimations in environments using .NET 4.5, ASP.NET, C#, MS SQL 2016. Extensive ETL experience with MS SQL SSIS, SSRS and DTS as well as XML and XSLT since MS SQL version 7. Extensive use of VISIO to document ER Diagrams, UML diagrams and Use Cases, etc.

Professional Experience:

Contractor/Consultant

March 2017 – Apr 2018 Care1st

Monterey Park

Los Angeles, Ca

Charged with migrating Arizona customers out of the sql databases (MS SQL 2008 R2 and 2012), took over day to day Access ETL then full time BA in an Agile Kanban environment

oSSIS Migration packages

oDeveloped SSRS reports

oMaintained, tested and extended MS Access ETL processes (ETL/BI Tester)

oBecame 1 of 2 BA’s (Business Analysts) for our area

oSSIS Test Analyst (BI Tester)

oData Analysis to identify malformed records

Contractor/Consultant

Nov 2016 – Dec 2016 Kaiser Permanente

Los Angeles, Ca

Charged with creation of system storage usage metrics ETL procedures using MS SQL 2012.

o Hands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)

Contractor

Dec 2015 – Nov 2016 Spectrum Carpets

West Covina

Los Angeles, Ca

Carpet and flooring installations.

Contractor/Consultant

May 2015 – Nov 2015 Bank of America

West Lake

Los Angeles, Ca

Charged with business analysis of banking and data irregularities and system documentation.

o Hands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)

oDevelopment of documentation for bank systems

oAnalysis of system issues

oReviewing C# code then proving with MS SQL 2012

oReviewing C++ code then proving with MS SQL 2012

oMaintaining and extending reports (SSRS) based on data warehouse

Contractor/Consultant

Oct 2014 – March 2015 LACare

Los Angeles, Ca

Senior ETL developer charged with development of reports and database design/implementation for medical payment systems using MS SQL 2012

o Technical Specifications, Database design and implementation (architect)

oHands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)

oData Analysis to model process flow

oDevelopment and maintenance of SSRS reports

oDevelopment, testing (BI Testing) and maintenance of SSIS packages and systems

Contractor/Consultant

Apr 2014 – Aug 2014 KPMG

Cyprus

Los Angeles, Ca

Charged with development of reports and database design/implementation with overseas development team. Application allowed clients to see their tax exposure on demand.

o Technical Specifications, Database design and implementation (architect & DBA)

oHands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling) using MS SQL 2008 R2

oDatabase design

oDevelopment and maintenance of SSRS reports

Contractor/Consultant

Sept 2013 – Feb 2014 Bank of America

Thousand Oaks

Los Angeles, Ca

Charged with enhancing the loan appraisal system, systems analysis, Db Analysis, SSIS packages with C# and VB.Net, etc. with a mixed team of permanent and contractor staff. System allowed for appraisal of potential properties and loans associated with them.

Other duties mentoring, documentation of processes and loan investigations.

oHands on development of SQL 2008 R2 databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)

oDevelopment, testing (BI testing) and maintenance of SSIS packages

oDeveloped distributed queries and use of distributed data sources (AS400/Oracle/MS SQL/etc.)

Contractor/Consultant

Dec 2010 – May 2013 LACOE (Los Angeles County Of Education)

Downey

Los Angeles, Ca

Project Mgr/Analyst charged with Systems Analysis, Db Analysis, SSRS and SSIS packages, etc. with a mixed team of permanent and contractor staff. This included RFIs, writing application requirements, assigning and tracking developer tasks and code reviews.

Other duties involved daily progress reports and testing/review of MIS components (QA) as well as tuning and coding of various Stored Procedures, Data Transformation packages (SSIS) and RDLs (SSRS) in SQL 2008R2 and SQL 2012 as well as migration of SQL208R2 to SQL2012. Extensive use of Team Foundation Server and Visual Studio 2008-10.

o Technical Specifications, Database design and implementation (architect & DBA)

o Project Leader/PM for SEMIS project

o Requirements Gap Analysis and requirements gathering

o Documentation

o Systems Analysis

o Data Analysis

o Database design

o Support and Development for SQL2008 Dbs and 2012, stored proc.s and SSRS

o Documentation and design of applications using MS Word, MS Excel and VISIO

o Design and implementation of various applications using UML2 and Gane Sarson notation (documented in MS Word and MS VISIO)

o Hands on development of databases (SSRS, Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)

o Support and Development for C#

o Support and Development for SSRS called from web forms

Support and Development for ASP.NET

Support, Testing and Development of SSIS packages

Contractor/Consultant

Apr 2010 – May 2010 Chaddleworth Software Ltd

Worthington Grange

Broadway

Worcestershire, U.K.

Project Mgr charged with development/team lead of “MasterAsset” system within CSL. Duties included analysis of user requirements with external businesses within the insurance industry as well as reverse engineering various CLRs from VB.net to C# using Reflection.

o Technical Specifications, Database design and implementation (DBA & architect)

o Project Leader for MasterAsset project

o Requirements Gap Analysis

o Documentation

o Systems Analysis

o Support and Development for SQL2005 and SQL2008 Dbs, reports and SSIS packages

o Documentation and design of applications using MS Word, MS Excel and VISIO

o Design and implementation of various applications using UML2 and Gane Sarson notation (documented in MS Word and MS VISIO)

o Hands on development of databases (SSIS, Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)

o Support and Development for VB.NET

o Development with C#

o Development with ASP.NET

o Support and Development for VB6

Owner

Nov 2009 –Apr 2010 Survey Yellow Pages

Charged with design and coding of website as well as generation of articles for use in ad campaigns

o Site development and SEO for Google, Bing and Yahoo and investigating the use of Facebook, Myspace and Linkedin for ad campaigns at SurveyYellowPages.com.

o JavaScript

o Photoshop CS3 development/editing of icons, trademark and photos

o Back link development

Employee

Apr 2004 – May 2009 Morrisons

Hampden House

Hitchin Road

Arlesey, U.K.

Title – Developer/Analyst/Team Lead/Project Lead/etc.

Charged with full application lifecycle (developing, supporting, analyzing, documenting, functional specifications, ER Diagrams etc.) of “Utility Services Planning and Management systems” within Morrison’s Utility Services. Charged with requirements gathering, customer facing and analysis of changing government regulations as well as project set-up, scoping and strategy planning both within the company and with external businesses. Investigated the costs and requirements (Data and Hardware) involved with upgrading our SQL servers to SQL 2005 and migration of existing DTS packages to new SQL Integration Services (SSIS). Migrated applications to Integrated/Trusted Security where possible. Stand in DBA when requested.

o Project Mgr for various projects

o Team/Project Leader for various projects

o Requirements Gap Analysis

o Documentation

o Systems Analysis

o Business Analysis

o Support and Development for VB.NET, VB6, SQL2000, SQL2005, C#

o Tech Specifications, Database design and implementation (architect)

o Documentation and design of applications using MS Word, MS Excel and MS VISIO

o Design and implementation of various applications using UML2 and Gane Sarson notation (documented in MS Word and MS VISIO)

o Implementation of PRINCE 2 Project Management practices

o Project development/management using MS Project

o Various extensions using XML, XHTML, XST, DHTML, DTD, XDR, XML Schema’s (XSD’s), CSS, XSL, XSLT, XPATH Queries, XML DOM, SOAP

o XML Development using XML Stylus Studio

o Data Migration development with SQL 2000 and 2005 (DTS to SSIS, etc)

o Hands on development of databases (Stored Procedures, T-SQL, Db/Query Tuning & ER Modeling)

o Implementation of XPATH queries in SQL Server

o development of SOA application with Google Maps and TMC (satellite mapping and text messaging)

o Development of Unit Testing

o Migration of Data Structures and conversion of DTS packages to SQL 2005 Integration Services (SSIS)

o Construction of tabular data warehouse using SSAS

o Tech Specifications, Database design and implementation

o Implementation of PRINCE 2 Project Management practices

o Data cleansing and Archiving of data

o Implementation of Active Directory Roles on SQL servers

o Development and migration to SalesForce.com

Technical Skill Summary:

Documentation :

Developing Procedures, Policies & Documentation

Information Mapping

Analysis & Design:

OOD/OOA (GUIDS Method and OOAD)

Gane Sarson

USE CASE Systems Analysis (OBJECTORY and Rational Rose)

Information Engineering (Db design/data mapping)

ALT - Application Lifecycle Testing (System Development Lifecycle)

OO Design Patterns

Unit Testing

SEO (Search Engine Optimization)

Test Driven Development (TDD)

Computer Languages:

MS SQL (4.2 – 2016), Stored Procedures, T SQL, SSMS, SSDT, DTS, SSIS, SSAS and SSRS

MS VB Script

XML, XHTML, HTML and DHTML

MS VISUAL C#

MS VB6

MS ASP.NET 3 – 4.7

MS .NET Core 2

MS PowerShell

Packages Used :

MS Project for Windows 4.0, 4.1, 98 – 2010

MS Team Foundation Server (TFS) 2008-2015

MS VSTEST and VSTESD (MS VISUAL STUDIO TEAM)

MS Visual Studio 2005, 2008, 2010, 2012 & 2015

MS Access for Windows 1-2003

MS SQL Server 4.2, 6, 6.5, 7, 2000, 2005, 2008, 2012, 2014 and 2016

Microsoft Enterprise Library v5

VISIO 4-2010

VISIO UML

Stylus Studio (XML, etc)

EasyCase (Case tools)

Action Designer (Case tools)

ERWin

Educational Background:

University: Computer Sci BSc (Victoria Wellington, NZ)

AA (Phoenix U, Phoenix Az)

PRINCE 2 Practitioner and Foundation (European equivalent to Six Sigma and PMI)

MS SQL MCP

UML and Use Case (Learning Tree International)

Contact this candidate