www.jarkar.com
 

Cover Letter (Word Format)

Resume Download (Word Format)

 

Christopher Singleton

Bellevue, WA 98005
206-832-7743
csnetsurfer@gmail.com

 

Employer,

 

I'm open to expanding my horizons in taking on new challenges.  Interested in a position as a data analyst/developer using the experience and skills I have.

 

With over 5 years’ experience in mechanical engineering design using CATIA V5, 4 years of Data Control and over 8 Years mechanical engineering graphics, drawings and layouts, I’m expanding my horizons to use more of my skill sets in engineering to include Business Intelligence.  I'm very strong with T-SQL Query, SQL Server 2014 and Visual Studio.Net 2013.

 

Resume

 

BI Analyst/Developer:

 

 

*Transact SQL Query (T-SQL)                                 *BI Stack (SSIS, SSAS, SSRS)                         *Star/Snowflake Schemas

 

*Data Modeling, Cube Design, Excel                         *MDX Query                                                       *Extract, Transform, Load (ETL)

 

*Cube/Excel Data Reports                                        *C# Programming                                              *VB Macros/DOS Bat File Script

 

*Data Mining                                                              *Data Warehouse (OLAP)                                *Network/Configuration

 

 
CATIA V5 Aerospace Technical Designer
 
* Generative Shape Design (G.S.D.)               *Sheet Metal Design
* Part Design (*.Part)                                     *Tube Design
* Asssembly Design (*.Product)                     *Drafting (views, ortho, A.S.M.E., ISO, Tolerances)
* Knowledgeware (Visual Basic)                    *DMU Kinematics (motion)
 
 
Work Experience
 
L & E Tubing Inc., Lynnwood, WA                                                             July 2011 - April 2015
CATIA V5 Technical Designer/Data Control
Aerospace Engineering Design / Manufacturing
Design Tubes, sheet metal Parts, Fixtures and Jigs using CATIA V5 to manufacturing specifications.
Drafting from Models to ANSI and ASME Standards including Geometric Dimensioning & Tolerances.
(G.D.&T) Create blocks and BOM's While drafting in CATIA V5.
     Use Generative Shape Design (G.S.D.) to solve engineering problems on drawings with CATIA V5.
     Edit CATIA documents for coordinates of bends and distances for manufacturing. 
Work with Quality Control Management to insure AS9100C manufacturing Quality and A.S.M.E. design
standards while designing with CATIA V5. Created 3D Part Marks and Flow Directions for Assemblies views.
    Manipulate drawings between CAD softwares, import/export file types conversions.
    Convert file types from different design programs to other engineering drawing programs.
Create, maintain master files for engineering drawings, documents and update specifications.
    Document Control: Control documents, part numbering system and revisions using the database and other 
      methods.
Manage ECN process origination, routing and and approval to implementation. 
    Set up and configuration of application software, including CATIA, CATIA Companion (TomCat Server),
     Microsoft, Printer/Plotter device, Symantec PGP Encryption and Adobe Acrobat Professional.

      

 
 
JARKAR LLC                                                                                          February 2009 - Current
Mechanical Engineering Designer
(Product Manufacturing, Customization)
Mechanical engineering design using Solid Works Premium 2010 for custom products.
Customized USB Pens, Mouse and other devices for clients including logo inscriptions.
Sell USB products and other electronic devices to other businesses. 
Performed data management and pro-active administrative organization.
Document control while continuing on-going projects and revisions to completion.
 
Costco Wholesale Corporation, Lynnwood, WA                                         March 1999 – April 2010
Computer Sales / Customer Support
Achieved goals in helping customers solve technical computer related issues.
Solved office administrative, sales floor related computer hardware and software technical problems. 
Monitored stock shortages and replenished stock levels in a timely manner.
Generated sales by creating merchandise screen savers and other related advertising materials.
Constructed steel beams to increase storage space and built display units.  
Trained co-workers about the knowledge of electronics and technical information.
 
Sverdrup & Parcel Engineering Inc., St. Louis, MO                                     September 1997 - December 1997
Civil CAD Designer  
Coordinated the projects with management phase of objectives and goals.
Drafted on Intergraph Main Frame Computer Systems with 4 screen displays to vantage point viewing of line layers and sectional vertices.
Designed and created 2D and 3D modeling of engineered diagrams according to the draft specifications and document control guidelines.
Training including direct command line interface and graphic user interface structures for beams, platforms, retaining walls and roadway civil engineering projects.
 
 Washington State Dept. of Transportation, Shoreline, WA                        April 1990 – September 1990
 Drafting Revisions / Concrete Inspector 
Completed drawing revisions and administrative tasks under the supervision of a professional engineer for roadway construction at state offices.
Accomplished goals in testing wet concrete to increase quality standards by using air entrainment, slump and the grade of concrete materials.
Calculated concrete, asphalt yields and material consistencies while creating samples.
Delivered assignments with state vehicles to State offices for signature approvals while completing administrative tasks for engineering projects.
Performed all tasks in a timely fashion to meet projected goals.
 
 
Education
 
Bellevue College, Bellevue, WA
June 2014 - Current

Major: Associate of Applied Science - Business Intelligence SQL Developer/Analyst

            BUSIT 103, 105, 110, 115 Completed  (Analyst Certification Nearly Completed)

                                                                                                          
 
Lake Washington Institute of Technology, Kirkland, WA                                                                                                September 2010 – January 2012
Major: Mechanical Engineering Graphics Design                         
             CATIA V5 R20   I , II & III                                                          Certificate of Completion
             Solidworks 2010  I & II                                                                                    Completed
             Auto CAD II & III 2010 II & III                                                                         Completed
 
                                                                                                                                                                                           November 1994 - March 1996         
Major: Automotive Technician I & II                                            Certificate of Completion      
                                          
                                                                                                                                                                                                February 1993 - July 1993
•      Major: Advanced AutoCAD III & IIII                                                                      Completed                                 
                                           
                                                                                                                                                                                                  July 1988 - January 1990
Major: Structural Engineering Graphics Design                            Certificate of Completion           
               
 
Griffin Business College, Bellevue, WA                                                                                                                                 February 1985 – March 1986  
Major: Computerized Accounting                    
                                          
Job Corps, Astoria, OR                                                                                                                                                             July 1981 - February 1983   
Major: Electronics Assembly                                                          Certificate of Completion
 
 
Skills                                                                                   
 
Mechanical Engineering Graphics Design:
CATIA V5 R20, Solidworks 2010 and AutoCAD 2010: Proficient in mechanical drafting and 3D parametric model drawings, advanced surface modeling,
exploded views, section views, auxiliary views, dimensioning, orthographic extraction, assembly drawing, bill of materials and organization.
Strong proactive communication skills, organizing of engineering graphic documents, drawing analysis and problem solving. 
 
 
Structural Engineering Graphics Design: 
Mechanical engineering graphics design and civil drafting graphics designs, drawings, tolerance Beam designs for copes and other interconnecting connections
using A.I.S.C. standards for grades of Steel, loads, Beam connections and allowable gauges to determine the structural strengths of designs.   
 
 
Electronics Assembly:
Schematic design and interpretation, wire wrapping, soldering, component identification, circuit theory, diagnostics and analysis.   
 
 
Engineering Programs:
CATIA V5 R20, Solidworks 2010, AutoCAD 2010, 3D Studio Max, Maya 3D and Bryce 3D.
 
 References:
 
Loren Davis       Phone: (360) 794-5216
Position: Quality Control Specialist
Lafarge & Egge Inc. Phone: (425) 778-4123
 
 Professors:
 
Art Lovestadt   Bellevue College
Position: BI Professor BUSIT 103 (T-SQL)
Email: art.lovestedt@bellevuecollege.edu
 
Linda Rumans Bellevue College
Position: BI Professor BUSIT 105 (SSRS, SSAS, Cube Analysis)
Email: lrumans@bellevuecollege.edu
 
Scott Acton    Auto CAD Instructor, Engineering Graphics: Lake Washington Institute of Technology
Boeing Engineering Technical Designer - Seattle, WA
Email:  scott.acton@lwtc.edu
 
Adam Petersen   CATIA V5 Instructor, Engineering Graphics: Lake Washington Institute of Technology
Boeing Engineering Technical Designer - Seattle, WA
Email:  adam.peterson@lwtc.edu
 
Ken Brown     Solidworks Instructor, Engineering Graphics: Lake Washington Institute of Technology
Email:  ken.brown@lwtc.edu

 
SQL Code (Syntax): (Coming Soon)
 
 
Definitions with Examples:
 
Concantenation
Definition: Link (things) together in a chain or series.
 
SELECT [CustomerID], [Title] + ' ' + [FirstName] + ' ' + [LastName] AS CustomerName
FROM [SalesLT].[Customer]
ORDER BY [LastName], [FirstName]
 
Cast/Convert with Concatenate
 
Syntax for CAST:
CAST ( expression AS data_type [ ( length ) ] )
 
Syntax for CONVERT:
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
 
Examples (Below):
 
SELECT CAST([CustomerID] AS NVARCHAR(5)) + ' ' + [Title] + ' ' + [FirstName] + ' ' + [LastName] AS CustomerInfo
FROM [SalesLT].[Customer]
ORDER BY [LastName], [FirstName] ASC
 
SELECT 'Product'+' '+'Category'+' '+
CAST([ProductCategoryID] AS NVARCHAR(2))+':'+' '+ [Name] AS ProductCategory
FROM [SalesLT].[ProductCategory]
ORDER BY [Name] ASC
 
SELECT [SalesOrderID], [LineTotal],
CAST(UnitPrice * (1-UnitPriceDiscount)* OrderQty AS Decimal(7,2)) AS TotalCost
FROM [SalesLT].[SalesOrderDetail]
ORDER BY TotalCost DESC
 
SELECT [SalesOrderID], [LineTotal],
CONVERT(Decimal(7,2), UnitPrice * (1-UnitPriceDiscount)* OrderQty) AS TotalCost
FROM [SalesLT].[SalesOrderDetail]
ORDER BY TotalCost DESC
 
SELECT [ProductID], [Name], [ListPrice], CAST([StandardCost]*1.06 AS Decimal(6,2)) AS FutureCost,
CAST([ListPrice] - ([StandardCost]*1.06) AS Decimal(6,2)) AS Profit
FROM [SalesLT].[Product]        
ORDER BY Profit DESC
 
SELECT [PurchaseOrderNumber], [SalesOrderID], [CustomerID],
CONVERT(NVARCHAR(10), [OrderDate], 101) AS OrderDate,
CONVERT(NVARCHAR(10), [DueDate], 101) AS DueDate,
CONVERT(NVARCHAR(10), [ShipDate], 101) AS ShipDate,

DATEDIFF(DAY, [OrderDate], [ShipDate]) AS InProcessDays,
DATEDIFF(DAY, [ShipDate], [DueDate]) AS ShipDays
FROM [SalesLT].[SalesOrderHeader]
ORDER BY [SalesOrderID] ASC
 
Date Function
SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 101) as MyPCDate
 
OR/AND Function
 
SELECT [AddressLine1]
     , [City], [StateProvince]
     , [CountryRegion]
     , [PostalCode]
FROM [SalesLT].[Address]
WHERE [StateProvince] = 'Idaho' OR [StateProvince] = 'Illinois'
ORDER BY [StateProvince], [City]
 
SELECT [AddressLine1]
     , [City], [StateProvince]
     , [CountryRegion]
     , [PostalCode]
FROM [SalesLT].[Address]
WHERE ([City] = 'Victoria' OR [City] = 'Vancouver') AND [StateProvince] = 'British Columbia'
ORDER BY [City]
 
SELECT [Name]
      ,[StandardCost]
      ,[ListPrice]
      ,[Size]
      ,CAST([StandardCost] AS DECIMAL(4,2)) AS [StandardCost_Rounded]           
--      ,'$'+ CAST(CAST([StandardCost] AS DECIMAL(6,2)) AS VARCHAR(7)) AS [StandardCost_Rounded]
FROM [SalesLT].[Product]
WHERE [Size] LIKE 'XS'
   OR [Size] LIKE 'S'
   OR [Size] LIKE 'M'
   OR [Size] LIKE 'L'
   OR [Size] LIKE 'XL'

ORDER BY [Name] ASC
 
LIKE/IN
 
 SELECT [Name]
     , [ProductNumber]
     , [ProductCategoryID]
FROM [SalesLT].[Product]
WHERE [NAME] like '%Bike%'
ORDER BY  [Name]
 
SELECT [Name]
     , [ProductCategoryID]
     , [ParentProductCategoryID]
FROM [SalesLT].[ProductCategory]
WHERE  [NAME] LIKE '%Bike%'
ORDER BY [ParentProductCategoryID]
 
SELECT DISTINCT p.[ProductKey]
               ,p.[EnglishProductName]
               ,c.[EnglishEducation]
FROM [dbo].[DimProduct] AS p
     INNER JOIN [dbo].[FactInternetSales] AS fis ON p.[ProductKey] = fis.[ProductKey]
     INNER JOIN  [dbo].[DimCustomer] AS c ON fis.[CustomerKey] = c.[CustomerKey]
WHERE c.[EnglishEducation] IN ('High School', 'Partial High School', 'Partial College')
ORDER BY p.[EnglishProductName]
        ,c.[EnglishEducation]
 
Distinct
 
Unions
 
 

INNER JOIN
 
Definition:
An inner join requires each record in the two joined tables to have matching records, and is a commonly used join operation in applications but should not be assumed to be the best choice in all situations. Inner join creates a new result table by combining column values of two tables (A and B) based upon the join-predicate. The query compares each row of A with each row of B to find all pairs of rows which satisfy the join-predicate. When the join-predicate is satisfied by matching non-NULL values, column values for each matched pair of rows of A and B are combined into a result row.
 
Syntax for INNER JOIN:
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;
 
Examples:
 
SELECT p.[Name] AS ProductName
       , p.[ProductID]
       , pr.[Comments] AS ProductReviewComments
FROM [Production].[Product] AS p
    INNER JOIN [Production].[ProductReview] AS pr
        ON p.ProductID = pr.ProductID

          ORDER BY [Name] ASC
 
SELECT pm.[ProductModelID]
     , pm.[Name] AS ProductModelName
     , p.[ProductID]
     , p.[Name] AS ProductName
     , CAST([StandardCost] AS DECIMAL(6,2)) AS [StandardCost_Rounded]
     , p.[Class] AS ProductClass
  FROM [Production].[Product] AS p
    INNER JOIN [Production].[ProductModel] AS pm
      ON p.ProductModelID = pm.ProductModelID

        ORDER BY [StandardCost] DESC
 
SELECT pm.[Name] AS ProductModelName
     , pc.[Name] AS ProductCategoryName
     , ps.[Name] AS ProductSubCategoryName
     , p.[ProductID]
     , p.[Name] AS ProductName
  -- , pm.[ProductModelID] AS ProductModelID
FROM [Production].[Product] AS p
     INNER JOIN [Production].[ProductSubcategory] AS ps
       ON p.ProductSubcategoryID = ps.ProductSubcategoryID
     INNER JOIN [Production].[ProductCategory] AS pc
       ON ps.ProductCategoryID = pc.ProductCategoryID
     INNER JOIN [Production].[ProductModel] AS pm
       ON p.ProductModelID = pm.ProductModelID

       WHERE (pm.[ProductModelID] = 23) AND p.[Name] LIKE '%Black%'
           ORDER BY p.[ProductID] ASC
 
SELECT oh.[SalesOrderID]
      , p.[ProductID]
      , p.[Name] AS ProductName
      , od.[OrderQty]
      , CAST(od.[LineTotal] AS DECIMAL(6,2)) AS [LineTotal_Rounded] --Decimal two places. (Look's better rounded)
--    , od.[LineTotal] AS OrderDetailLineTotal
--    , oh.[OrderDate] AS OrderHeaderOrderDate
--    , CAST(oh.[OrderDate] AS DATE) AS [OrderDate]   --Only in 2007 OrderDate Without Time. (Looks better without time)
FROM [Production].[Product] AS p
      INNER JOIN [Sales].[SalesOrderDetail] AS od
         ON p.[ProductID] = od.[ProductID]
      INNER JOIN [Sales].[SalesOrderHeader] AS oh
         ON od.[SalesOrderID] = oh.[SalesOrderID]
      INNER JOIN [Production].[ProductSubcategory] AS ps
         ON p.ProductSubcategoryID = ps.ProductSubcategoryID
      INNER JOIN [Production].[ProductCategory] AS pc
         ON ps.ProductCategoryID = pc.ProductCategoryID

           WHERE pc.[ProductCategoryID] = 3  AND  YEAR(oh.[OrderDate]) = 2007
 
SELECT p.[Name] AS ProductName
      ,CAST(oh.[OrderDate] AS DATE) AS OrderDate                 --CAST Date (Do Away with Time)
      ,ps.[ProductSubcategoryID]      
      ,pc.[Name] AS ProductCategoryName
      ,od.[OrderQty] AS TotalOrderQuantity
      ,CAST(oh.[Freight] AS DECIMAL(6,2)) AS FreightCost         --CAST to two Decimal Places.
      ,CAST(oh.[TaxAmt] AS DECIMAL(6,2)) AS TaxAmount            --CAST to two Decimal Places.
      ,CAST(oh.[SubTotal] AS DECIMAL(7,2)) AS SalesSubTotal      --CAST to two Decimal Places.
      ,CAST(oh.[TotalDue] AS DECIMAL(8,2)) AS SalesTotalDue      --CAST to two Decimal Places.
FROM [Production].[Product] AS p                                 --Proction.Product Table Alias
      INNER JOIN [Sales].[SalesOrderDetail] AS od                --INNER JOIN Sales.SalesOrderDetail Table.
         ON p.[ProductID] = od.[ProductID]                       --Common Key in both tables.
      INNER JOIN [Sales].[SalesOrderHeader] AS oh                --INNER JOIN Sales.SalesOrderHeader Table.
         ON od.[SalesOrderID] = oh.[SalesOrderID]                --Common Key in both tables.
      INNER JOIN [Production].[ProductSubCategory] AS ps         --INNER JOIN Production.ProductSubCategory Table.
         ON p.ProductSubcategoryID = ps.ProductSubCategoryID     --Common Key in both tables.
      INNER JOIN [Production].[ProductCategory] AS pc            --INNER JOIN Production.ProductCategory Table.
         ON ps.ProductCategoryID = pc.ProductCategoryID          --Common Key in both tables.

WHERE ps.[ProductSubcategoryID] IN (1, 2, 3)                   --Use the IN Keyword to filter all Bike Categories.
      AND oh.[OrderDate] BETWEEN '2007-12-01' AND '2007-12-31'  --December 2007 (One Whole Month Only)     
ORDER BY CAST(oh.[TotalDue] AS DECIMAL(8,2)) DESC                --Sort by SalesTotalDue highest to lowest.
 
 
LEFT OUTERJOIN / RIGHT OUTER JOIN
 
Definition:
The SQL OUTER JOIN differs from the inner join in a useful way, it enables us to join data from two tables and return all specified rows from one of the two tables regardless of whether a related record is found in the other table.
 
Note: When no match is found any columns in the SELECT column list that are from the table which is not going to return all rows will contain NULL.
 
Left Outer Join Syntax:

SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name=table2.column_name;

or

SELECT column_name(s)
FROM table1
LEFT OUTER JOIN table2
ON table1.column_name=table2.column_name;

 
Examples: 
 
SELECT DISTINCT
       dp.[EnglishPromotionName]
      ,dr.[ResellerName]
      ,CONVERT(VARCHAR(10), frs.[OrderDate], 101) AS OrderDate
FROM [dbo].[DimPromotion] AS dp
     LEFT JOIN [dbo].[FactResellerSales] AS frs ON dp.PromotionKey = frs.PromotionKey
     LEFT JOIN [dbo].[DimReseller] AS dr ON frs.ResellerKey = dr.ResellerKey

WHERE dp.[EnglishPromotionName] <> 'No Discount'  -- <> meaning !=
ORDER BY dp.[EnglishPromotionName]
 
SELECT DISTINCT
       dg.EnglishCountryRegionName
      ,dg.StateProvinceName
      ,dg.PostalCode
FROM [dbo].[DimGeography] AS dg
     LEFT JOIN [dbo].[DimCustomer] dc ON dg.GeographyKey = dc.GeographyKey
     LEFT JOIN [dbo].[FactInternetSales] AS fis ON dc.CustomerKey = fis.CustomerKey

WHERE fis.CustomerKey IS NULL
 
Full Join
 
SubClauses
 
Aggregation with Sub-clauses
 
AVG with Sum Subclauses
 
 
CATIA V5 projects and 3D Models:
(All Links Open in a New Window)
 
Generative Shape Design:
 
Dune Buggy CATIA V5 Model
 
Dune Buggie Tire (GSD Surfaces)

Dune Buggy (Automobile Surface Model Rendered)