Solution Architect Resume

OBJECTIVE:

Looking for a challenging remote position in data development, design and architect.

SUMMARY:

Over 15 years of IT industry experience in application design, development, implementation of software project and technical expertise in Oracle, MySQL, Vertica
Highly proficient in Oracle Databases for both client - server and Data Warehousing applications (APIs/Data Mining/Integration)
Extensive experience in Data Modeling and Design.
Performance tuning for high volume data loads and aggregate data processing in most optimized time
ETL development, partitioning and database migrations
Working experience in global team 24/7 user support.
Experience working in Agile environment, start-ups
Team lead experience, project tracking and task allocation

TECHNICAL SKILLS:

Oracle: SQL, Design, PL/SQL, SQL, SQL*Plus, SQL*Loader, CDC, partitioning, query performance, ETL

Vertica: SQL, migration to Vertica, query performance, external tables, projections, Designer, ETL, Big Data MySQL (SQL, development, query tuning, design, migration)

Hadoop: HDFS, Sqoop, Hive, Pig Latin

Tools: Informatica 8.11, Talend, ErWin, Embarcadero, ErStudio, Workbench, System Architect, Toad, Oracle SQL Developer, Oracle Data Modeler, Vertica Designer

Other: Hadoop, AWS, Unix, Linux, Windows

Programming experience: SQL, Python, Java, Unix shells

Source control: CVS, Perforce, PVCS, Kintana, SVN, StarTeam

Familiar with: Spark, MongoDB, Cassandra, HBase

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect

Tools: Development Platforms and Environments:

Databases: Oracle, Teradata, MySQL, Vertica

Hadoop: Hive, Sqoop

Development: Python, Bash shell, ETL design, DW design, performance tuning, custom database migration tools, streams

Responsibilities:

Enterprise Service architect solutions: Datawarehouse migrations (Oracle/Teradata to Vertica), Big Data (petabytes) solutions.
Vertica administration (installation, tuning, design).
Custom ETL development (Python, Java, Hive, Oracle, MySQL)
Oracle/Vertica migration accelerator (Java, Swing)
Data modeling (Embarcadero, HP Vertica)
Built and support HP lab cluster (3 nodes): RedHat Ent, Hortonworks Hadoop 2.1, Oracle 12c, HP Vertica 7.1, Cassandra

Confidential

Lead DW Developer

Tools: Oracle, Vertica, PL/SQL, SQL, Oracle CDC, Python, shell. ETL design, DW design, performance tuning, Tableau

Responsibilities:

Working on building the Big Data DSR for CPG combining data from POS, syndicated, loyalty and on-line.
Replicating data form Oracle to Vertica (Oracle CDC)
Building Vertica OLAP
Tuning Vertica queries (Designer, projections, partitioning, segmentation, encoding)

Confidential

Sr. ETL Developer

Tools: MySQL (5.1), Workbench, Toad for MySQL, UNIX shell, Python, AWS, Vertica, Hive, Hadoop, Shark, SVN, Windows 7, Linux

Responsibilities:

Datawarehouse design (MySQL, Workbench)
Dashboard design (MySQL, Shell, Python, HTML)
ETL development (AWS, Hadoop, HiveQL, MySQL, shell, Python, Shark)
Framework to support ETL (DAG, Hadoop, S3, Hive, MySQL, Shell, Python)
POC (Vertica)
Ad-hoc reports (MySQL, Hive)

Confidential

Sr. Database Engineer

Tools: MySQL (5.1, 5.5), DB2, Workbench, Toad for MySQL, UNIX shell, SVN, Windows 7, Linux, SunOS 5.8

Responsibilities:

Developing APIs for SPIN (Sears Product Information Network) (MySQL, shell)
Datawarehouse design (MySQL Workbench)
ELT procedures development (MySQL)
Reports development (shell, MySQL)
Data feed APIs development (DB2, Datastage, MySQL)

Confidential

Sr. Database Engineer

Tools: Oracle 10g (PL/SQL, SQL*Plus, SQL*Loader, SQL), Oracle XML DB, UNIX shell, Vertica,SVN, Windows 7, Linux, Hadoop, Hive, Java (SOA, web-service), Perl, Databee (Python), Microstrategy, Informatica, Workday, Salesforce, Ariba

Responsibilities:

Complete Datawarehouse design for HR Analytic
Support pipelines (Hadoop, Hive)

Confidential

Sr. Database Engineer

Tools: Oracle 10g (PL/SQL, SQL*Plus, SQL*Loader, SQL), UNIX Shell, SVN, Windows XP, Linux

Responsibilities:

Datawarehouse development (partitioning, ETLs, external tables)
Data Feed Framework development (generic ETL framework)
Query tuning, ETL performance
Metadata framework (XML, Java)

Confidential

Senior Database Developer

Tools: Oracle RDBMS (PL/SQL, SQL*Plus, SQL*Loader, SQL), Informatica, UNIX shell, Dollar Universe, PVCS, Windows XP, SunOS 5.8

Responsibilities:

Datawarehouse DB re-design and Datawarehouse support (10 terabyte)
CRM (customer research management) ad-hoc reports
ETL development
Development of the process to synchronize Oracle Datawarehouse with Netezza DB

Confidential

Sr. Database Engineer

Tools: Oracle 8i, 9i (PL/SQL, SQL*Plus, SQL*Loader, SQL), Java, Oracle XML DB, ErStudio 5.5, Perforce, Windows XP, Solaris 2.6, SunOS 5.10

Responsibilities:

Datawarehouse ETL interfaces design and development.
Datawarehouse ERD design.
Database event logging system design and development
API development (XML parsing, XML storage, XML-data retrieval and queries)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship