Business Intelligence Engineer (SQLServer developer)) Resume Frederick, MD - Hire IT People

SKILLS:

SQL - Server T-SQL
ETL Development2
Oracle 12g PL/SQL (stored procs, functions, triggers, left/right joins, etc.)
Agile development (scrum)
Unix/Linux command scripts (including awk)
Back-end Java with embedded SQL
OLAP- and OLTP-oriented DBMS applications
ERWIN and data modeling; semantical, logical, physical models; star-, dimensional-, snowflake-schemas; source-to-target mapping
Written and verbal communication
C programming, general: front-end and back-end with embedded SQL

TECHNICAL SKILLS:

Languages and operating systems: Oracle 12g PL/SQL; Microsoft SQL-Server T-SQL; IBM-Informix SPL-SQL; Java servlets, HTML, JavaScript, Java Web Services, C (interactive, batch, multithread), C#, Visual Basic; Windows, Linux/Unix.

Data modeling tools, analytical tools, and other software: Business Objects; ERWin; ERStudio; Crystal Reports; DAG MetaCenter (metadata analysis and modeling tool); SQATest; Excel, Word, PowerPoint, WebEx and other similar teleconferencing software.

EXPERIENCE:

Business Intelligence Engineer (SQLServer developer))

Confidential, Frederick, MD

Responsibilities:

Developed statutory and accreditation-related statistical reports.
Researched and demonstrated alternative approaches for business intelligence reporting (data marts), using SQL-Server + Tableau.

Data Analyst

Confidential, Baltimore, MD

Responsibilities:

Developed ad-hoc reports (using PL/SQL packages and stored procedures).
Enhanced a web-based OLTP system to support complete, flexible, customized transaction auditing.

ETL analyst/developer

Confidential, Frederick, MD

Responsibilities:

Created entity-relationship models, mostly in third-normal form.
Optimized/tuned ETLs using index strategy, multithreading, buffer sizing, query structures (execution plans etc.).
Captured requirements, specified, designed, and coded ETL programs using Actian Pervasive5 ETL tool with complex and highly optimized SQL scripts, including multilevel-indirection dynamic SQL.
Reverse-engineered legacy Java/SQL ETLs to develop and implement Pervasive ETLs with legacy code and minimal info.

Business intelligence and data analyst

Confidential, Washington, DC

Responsibilities:

Conceived, designed, implemented ERWin and SQL-Server scripts to model, extract, transform, and load master data (normalized database), using star- and quasi-snowflake-schemas.
Created a “hypermodel” of inter-database interfaces using metadata; specified extract-transform-load (ETL) stored procedures; mapped and cleaned ca. 10,000 data element source-to-target lineages.

Web application developer

Confidential, Washington, DC

Responsibilities:

Conceived, designed, and constructed a metadata-driven software code generator tool, used by a dozen developers:
Saved at least $400,000 in development costs.
Presented this code-generation tool at the Informix International Users Group convention, Orlando, FL.
Modeled logical and physical databases using ERWin.
Designed, coded, and team-led AR-AP application (SQL embedded in C programs).

Application developer, technical trainer

Confidential, Bethesda, MD

Responsibilities:

Conceived curricula, supervised authors, edited manuscripts, wrote and taught courses in advanced database design including normalization/denormalization, data typing, data modeling; C programming with embedded dynamic SQL, and DBMS application development.
Led development teams using C, Oracle 5/6, Oracle-SQL-Forms.

We provide IT Staff Augmentation Services!

Business Intelligence Engineer (sqlserver Developer)) Resume

Frederick, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship