SQL Developer Resume Profile

PROFILE: Ph.D. in Mathematics Physical Sciences, Oracle Certified Professional, Microsoft Certified Technology Specialist, SAS Certified Programmer. Advanced analytical skills with the potential to solve complex problems. Seasoned IT professional with the 10 last years emphasizing data analytics, business intelligence and data management. Knowledge and experience in relational and dimensional databases design and data modeling. Commitment to continuous learning of new ideas, technologies and skills. Working experience in Federal agencies and commercial companies.

PROFESSIONAL SKILLS:

Translating business/IT/scientific objectives into technological solutions

Relational Database OLTP Data Modeling, Development and Reporting:

Conceptual, logical normalization, 3NF and physical data models
Development of packages, procedures, functions and triggers
Data modeling notations: IE, IDEF1X, UML, Barker's
Reporting tools: Report Server of SSRS, Crystal Reports

Data Warehouse Design and Development with OLAP technology/Business Intelligence:

Development of Data Warehouses, Data Marts, Cubes and Reporting Solutions
Working experience with Kimball Methodology and Data Vault Modeling
Dimensional modeling techniques: Star and Snowflake schemas, type 1-3 slowly changing dimensions, role playing, junk and conformed dimensions, bridge tables, aggregations, hierarchies
Data Profiling
Experience with Master Data Management MDM concepts
Oracle OLAP multidimensional solution
MS Business Intelligence Development Studio BIDS : SSIS, SSAS, SSRS
Proclarity PerformancePoint Serve as a reporting tool for multidimensional databases Cubes

Data Modeling Tools:

Erwin Enterprise Data Modeler Suite Erwin 7x, 8.2, Model Mart CA All Fusion
MS SQL Server Management Studio, Oracle SQL Developer

Data Analysis packages/skills:

SAS, Excel
Exposure to Tableau
Linear, nonlinear and multivariate regression Principal component analysis

Database Management Platforms:

Oracle 9i, 10g, 11g
SQL Server 2005, 2008
Familiarity with Teradata and data warehouse appliance concept

Related DBMS Tools and Techniques:

Database and Application Performance Tuning: OEM/SQL Server Advisors, Tuning by Index, Table Partitioning and Storage, SQL Execution Plan, Query Hints
Oracle Data Migration Tools: exp/imp Utilities, Data Pump, External Tables, SQL Loader
Oracle Backup and Recovery: RMAN, Flashback
Oracle Enterprise Manager OEM , TOAD, OEM Grid Control

Programming:

SQL, T-SQL, PL/SQL - Database back-end and ETL development
Java - JDBC and modification/implementation of customer Java based data loaders
Fortran/C - Development of codes for various statistical/scientific packages
PHP ODBC , HTML, XML - Implementation of dynamic web-based database interfaces
Operating Systems: UNIX, Windows
Collaboration Tools: SharePoint, Clear Case, Clear Quest
MS Office Productivity Suite 2007-2012 including Outlook, Word, PowerPoint, Visio

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship