ETL Dev Resume

SUMMARY

Over 10+ years’ experience as ETL DWH Dev / BI Architect, providing interface solutions between relational DB and cloud DB with high experience with data analytic, also including support for fix errors on productions systems and developing interfaces from design, test, phases to implement on production systems.
As a BI Architect have implementing business intelligence for the organization, Maintain, support, and enhance the business intelligence data backend, including data warehouses.
Research and measurable fulfillment of the objectives defined in each project
Efective communication
Contribution of ideas and attitude of constant collaborative learning
Precise definition of scope and responsibilities
Administration of parallel tasks
Horizontal Leadership
Rules based on best practice

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

ETL Dev

Responsibilities:

Programming: Oracle Xpress Edition 18, Azure SSAS (Reading like Source on PBI), R Studio, DAX.

Tools: Oracle XE, Azure SSAS, Power BI, Tableau .

Confidential

Power BI Dev / Architect

Responsibilities:

Dashboard designer for CEO Level reports
Definition of Source Data Cubes for BI reports Data Sources
Project leader for all projects integrated to BI
Design of Data Models within the DWH implemented with SQL Server Data tools on premises
Design of queries, scripts, views and development of Metadata
Advice for the implementation and use of tools in the satellite areas of the BI platform
Auditor of integral tests for the approval of productive projects
Documentation of the versions of technologies used in the projects for the standardization of platforms
Project Manager and Requirements Auditor for the BI area
Power BI server administrator

Programming: DAX Power BI, SQL Server

Tools:

Confidential

Data Modeling dev.

Responsibilities:

Make improvements and optimizations in loading ETL processes
Information Quality Assurance by implementing data tests
Management of the requirements from BI, documenting and implementing the best practices in the process of communication with the team
BI process auditor in the integration of functional processes towards the DWH
Follow - up and support tasks in the Development of projects as Project Manager
Planning and Define scope of support and development
Couching to maintain effective communication with functional users
Couching to SQL and DWH best practices
Programming: DAX Power BI, SQL Server

Programming: PL/SQL on Sybase IQ, MDX

Tools:

Confidential

Team Lead BI Architect

Responsibilities:

Revision of requirements and requests for integrations
Follow-up with process owners for definition and scope of integrations
Definition of requirement document, technical, flow diagram, metadata
Administrator of DWH Data base platform Staging, ODS, DWH) Environment Management DES, QA, Production
Support and maintenance to Developer, Quality Assurance & Go live enviroments
Management and audit of developments in infrastructure ETL's
Management and audit of infrastructure developments for the creation of information cubes
Environment management DES, QA, Production
Layout design (DASHBOARDS, SCORECARDS, OPERATIONAL LEVEL)
Administration and management of productive reports and server TABLEAU

Programming: SQL Server, MDX, DAX, Oracle SQL, Tableau Analysis Scripting

Tools:

Confidential

ETL Dev / BI Architect.

Responsibilities:

Administration and definition of Dimensional tables, views schemas
Modelling and document all information about design and define Data Models
Administration and support or requirements and maintained of Developer, Quality and Go live environments
Developer, document and administration of requirements, support of Data Flows ETLs
User Acceptable Test task, administration of plans, timing and upgrades on process to Data Quality Assurance
Administration of timing, plan, support for Data model repositories Dimensional repository, change of metadata, script of source data views, add columns, support and maintained

Programing: Altova code, SQL DDL,DML, PLSQL

Tools: