SQL BI Developer 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

Dana  Hodgkins

309 Hemby Ridge Lane     Morrisville, NC 27001                         (919)-757-9876    dana@aol.com

Professional Summary

Database Engineer with 10 years of experience developing and designing SQL databases. Spent 17 months in Iraq designing and implementing analysis cubes and SSIS

·         Data Modeling                              ·  Data Warehousing         ·  Requirements Analysis     

·         Algorithm Development                 ·  Database Design             ·  2D and 3D Modeling/Security 

·     Data Architecture                         ·  SSIS/SSRS                    ·  ETL              

       ·    Analysis Cubes                              ·  OO Analysis/Design       

Work Experience

Greene Resources, Inc. / Consultant at Cree                                                        7/27/2010 to 8/5/2011

Durham, NC

SQL/BI Developer

·         Assisted engineers and management in developing requirements of how and what would be analyzed.

·         Coded T-SQL procedures for Financial WIP and yield ETL for OBIEE dashboards.

·         Created reports in SSRS for displaying Financial WIP data, Product yields, Product cycle-time, Pareto charts and other analytical charts. 

·         Designed and developed database data marts for storing cleaned transactional data for analysis and yield purposes.

·         Wrote stored procedures for populating and cleaning data for analytical data marts. Used data marts to supply SSRS reports and to socialize to engineers to use as the basis for analytical JMP (SAS application) scripts.

L3 C2S2                                                                                                4/22/2009 to 7/29/2009

US Falcon                                                                                             10/9/2007 to 4/21/2009

Fayetteville N.C. and Camp Victory, Iraq

SQL/BI Developer

·         Spent 17 months in Iraq (12 hour day 7days per week) as a Database Developer. 

·         Designed star and snowflake database data marts to populate data analysis cubes. 

·         Analyzed existing databases and other data to understand the schemas, tables, data types, and business rules involved with each project.

·         Worked with data owners and end users to develop business rules for calculated fields (using MDX), and to develop key performance indicators (KPI). Each Cube Project was performed as part of small teams - 2 to 3 developers in approximately 6 week cycles. 

·         Wrote SSIS packages to perform extraction, transformation, and loading (ETL).

·         Wrote Stored Procedures with table joins and cursors and table views.

·         Created Analysis Cubes from start to finish, including data source views, fact measures, dimensions, calculated fields and KPI.  Included working with more advanced calculations like moving averages that work on all measures in MDX.  ETL procedures included writing log information to tables for maintaining statistics on ETL jobs and job run information such as job run time, collecting bad data etc. Occasional troubleshooting of SQL server agent jobs. Cubes involved include BI analysis of Significant Actions reported to congress, Iraqi polling data, Iraqi electrical generation data, and data for the drawdown of US forces in Iraq.

Titan L-3                                                                                                07/2005 to 12/05

Fayetteville NC.

Database developer

·         Database for Ft Bragg to track training of special operations troops.  Worked with ERWin and Sybase Powerdesigner to design logical and physical data models and implement databases in MS SQL server by generating creation scripts, and wrote stored procedures for importing data, developed coding guidelines and database dictionaries.  Designed data warehouse applications using star and snowflake patterns and metadata needs.  Wrote scripts and procedures to extract data from an Army personnel database and to load it onto local databases. Put Erwin files and generation scripts into MS source safe.  Documented database and integrated the documentation in Erwin and into the generation scripts. Generated reports out of Erwin and powerdesigner for inclusion into design documentation. Developed and documented naming conventions for database elements. Wrote stored Procedures (with table joins), cursors and triggers

BAE Systems                                                                                       03/2004 to 4/2005

Reston, VA

Engineering Specialist

·         Used Popkin software to create System Architectures and performed Data modeling, other self directed learning, independent R&D and a white paper using Popkin and DODAF principles to design a theatre wide horizontal fusion network with information security and configurable information sharing and request rules.  Project lead on an Employee Retention tracking system, and a Telecommunications equipment and tracking database.

·         Job Function: Data modeling, Database design with logical and physical models, database implementation

Computer Systems Center Inc                                                                06/1997 to 01/2004

Springfield, VA

Principal Database/Software Architect                                               

·         Designed Databases using Logical and physical models (using ERWin)

·         Principal database/software architect on database projects including a software system for managing Special Access Required Programs (SAPS) and Sensitive Compartmented Information
(SCI) data, and managing access to SAP/SCI data. Duties included: Requirements gathering and documentation, Requirements analysis and data modeling using conceptual, Logical and physical data models, System Architecture, Implementation of packages, stored procedures, and triggers, writing test scripts for database testing, and creating Project management documents. Performed troubleshooting and requirements tracing to catch project shortfalls and problem areas.

·         Worked on a financial management database for a Joint armed services project to manage spending and road mapping system development efforts. Gathered requirements, designed and implemented an MS SQL server 7 database to support the project.

·         Served as team leader for development group for software and databases on projects to track development of Navy planning systems, Joint Command and Control ship (JCCX) systems; a radar
simulator and a tracking simulator. Incorporating DODAF and CADM components into database.

·         Worked on a Team to develop an Advanced Concept Test System (ACTS) for testing radar tracker systems and their tracking algorithms. Acted as software integrator and tester. Also inspected and
adjusted math algorithms for conversion into an objected oriented software design. Developed test software to enable analysts to gather statistics on the performance of a tracker that used
simulated data for performance evaluation

Naval Surface Warfare Center (NSWC)                                                     10/1988 to 06/1997

(formerly David Taylor Research Center), Annapolis, MD

Electrical Engineer

·         R&D environment, worked independently on widely varying complex projects including gathering requirements, designing and writing Software in C and C++, NASTRAN and code for computational Fluid dynamics

·         Designed and built pump impellers, selection and procurement of materials, wrote computer programs, in "C" for: pump design, hydraulic performance prediction, B-spline curve fitting, wrote
programs in C and C++ to create, and transfer wire model data into Tool paths and instructions for machinist to run 3 axis and 5 axis Numerically Controlled milling machines.

·         Specified, Purchased and Setup computer test systems for acquisition of low noise pump acoustic data, archiving of acoustic data, designed and wrote computer programs in C and C++ to manipulate, analyze, and display acoustic data measured on quiet rotating machinery. Wrote programs to acquire data

·         Project Engineer for evaluating "quiet" submarine pumps, coordinated test schedules with project engineers and coordinated work of technicians, specified and acquired materials and components, specified types and locations of sensors for data acquisition, including endurance tests for unmanned 24hr continuous operating of equipment, wrote test plans and reports.

·         Worked on programs to characterize the acoustic properties of pumps, pump systems, and acoustic filters for pumps in “C” and C++. Setup and maintained an IEEE 802.3 Ethernet network with Apollo Computer workstations and PC computers, including a fiberoptic cable segment - before internet was widely known.

Education

MS Johns Hopkins University, Baltimore Md. Computer Science

BS Florida Institute of Technology, Jensen Beach Fl. Oceanographic Technology/Ocean Engineering

Clearance

Top Secret 08/2003, - reinvestigated Nov 2007

Professional Development

·         Registered Engineer In Training EIT #7147, 1988 by Maryland Board of Professional Engineers.

·         ASP.Net spring 2010

·         Java programming Fall 2007

·         Popkin System Architecture April 2004

·         PLSQL Programming Aug 2003

·         Transact SQL programming Nov 2002

·         Many others not mentioned

Download Resume Format