Lead BI Engineer Resume San Francisco - Hire IT People

SUMMARY:

Highly - skilled IT professional with 16 years of IT experience including 7 years of Data Warehouse development and 3 years of Hadoop development.
Excellent team player with the ability to work independently, without a supervision. Also have strong communication and management skills. Work on the field of Data Warehousing and Business Intelligence.
Involved in all phases of the project - gathering the requirements, analysis, communication and coordination, task distribution, development, testing, deployment, maintenance and support.
Fast learner with the strong willing to explore new technologies and put them to use.

TECHNICAL SKILLS:

ETL/DWH development: Informatica PowerCenter 9.x • Apache Hadoop • Hue • Hive • AWS (S3/EMR)

Databases: Oracle 11g/12c/ExaData • DB2 • Teradata • Sybase ASE

Workload automation: Control-M 8.x • Cron • Apache Oozie

Languages: Java • PL/SQL • T-SQL • HiveQL

Scripting: Unix /Linux Shell • Python

Data Modeling: ERwin 7 • Power Designer 12 • MySQL Workbench 6.3 • Visio 2007

API formats: XML, JSON

Net protocols: SSH, TCP, HTTP(S), FTP/SFTP

Version control: PerForce, SVN, Stash/Git

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco

Lead BI Engineer

Responsibilities:

Assist with translating business requirements from onsite business teams (business analysts, product owners, etc.) to offshore development team;
Collaborate with offshore team to delegate the workload and review the status of the project;
Collaborate with business owners, architects, and other BI engineers to ensure developing high quality product;
Review the offshore development team’s work to improve the quality of production code;
Participate in the implementation effort (developing, testing, debugging and deployment) of various Data Warehouse projects using Informatica 9.6.1, Control-M 8.0, Cron, Oracle 12c Exadata, Apache Hadoop and AWS;
Support current data warehouse loading process (including on-call rotation);
Perform ad-hoc analysis required for end users;

Confidential

Lead BI Engineer

Responsibilities:

Coordinated a communication and work between offshore and local BI teams;
Communicated with business analysts and product owners to define scope of work and priorities;
Converted business requirements to technical tasks and distributed them in local BI team;
Communicated closely with offshore BI team to define development best practices, deployment strategies and QA processes.
Developed ETL processes (mappings, worklets, workflows, automation jobs, Shell scripts, data upload/download scripts) for Data Warehouse usung Informatica 9.0.1, Control-M 7.0, Cron, Oracle Exadata, and Apache Hadoop;
Developed logical and physical data models for Data Warehouse using MySQL Workbench 5.2.

Confidential

Senior ETL Developer

Responsibilities:

Analyzed business requirements and business rules to convert them into technical tasks;
Developed ETL processes (mappings, worklets, workflows) using Informatica 9.0.1;
Developed logical and physical data models for Data Warehouse and data marts using MySQL Workbench 5.2;
Worked with Informatica Web Services Hub - tuning WSH for workflow remote control (using HTTP clients).

Confidential

Senior ETL Developer/DWH Architect

Responsibilities:

Designed architectural solutions and presented them to customer;
Analyzed business requirements and business rules to convert them into technical tasks;
Developed ETL processes (mappings, worklets, workflows, automation jobs, Shell scripts, data upload/download scripts) using Informatica 8.6.1, Control-M and Oracle 11g;
Was responsible for architecture and design in different Data Warehouse areas: staging area, ODS, DWH Core, data marts;
Developed logical and physical data models using Erwin 7.3.7;
Wrote Project Architecture Documents (PAD) and Technical Design Documents (TDD).

Confidential

Database Architect

Responsibilities:

Analyzed business requirements and rules to define main concepts of database architecture and high-level design using Sybase Power Designer 12.0;
Developed logical and physical data models for application databases;
Developed database structure and functionality (objects and relationships, stored procedures and packages) for Oracle 10i and Sybase ASE 12.5;
Programmed the functionality of applications (PL/SQL, C#, Java, Delphi).

Confidential

Software Developer

Responsibilities:

Programmed the functionality of applications (T-SQL, PL/SQL, Delphi)
Developed database structure and functionality (objects and relationships, stored procedures and packages) for Oracle 9i and Sybase ASE 12.0.

Confidential

Software developer

Responsibilities:

Programmed the functionality of applications and reports (T-SQL, Power Builder)
Supported different bank databases (Sybase ASA, Sybase ASE)

We provide IT Staff Augmentation Services!

Lead Bi Engineer Resume

San, FranciscO

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship