SUMMARY

• More than 7 years of IT experience in data analysis, data architecture, application design, dimensional data modeling, implementation and testing of Enterprise Data Warehousing, NoSQL data, Enterprise Database and Data Mining.
• More than 7 years of hands on experience with Modeling (Object models, Logical models, Physical models for relational databases).
• Excellent experience in the design of UML diagrams using modeling tools such as Erwin and Visual Parading.
• Experienced in data analysis and data profiling using complex SQL in various source systems, including Oracle, SQL Server, Sybase IQ, Teradata, DB2, PostgreSQL platforms.
• Experienced in server monitoring, enabling and using records for multiple platforms such as MariaDB, Oracle / PostgreSQL / MySQL / SQLite / SQL Server / DB2/ Sybase IQ.
• Strong experience in the configuration of replication processes and data clustering for many tool such as: Pgpool, Symmetry, SharePlex, MariaDB Galera, Oracle Golden Gate, Reko.
• Strong knowledge in the Manipulation and index development, partitioning tables, writing better queries and adjusting variables in various source systems, including MariaDB, Oracle, SQL Server, Sybase IQ, Teradata, DB2, PostgreSQL platforms.
• Excellent experience in the design of transactional, dimensional and multidimensional data structures using data modeling tools such as Erwin and Visual Parading.
• Strong experience in physical modeling for multiple platforms such as Oracle / PostgreSQL / MySQL / SQLite / SQL Server / DB2/ Sybase IQ.
• Strong experience in SQL and ETL development including data mapping, data cleansing and data profiling
• Detailed knowledge of, SSAS, SSRS, SSIS, T - SQL, Reports and Analysis.
• Experience in the standardization method of the database defined by E.F CODD (3NF- Third Normal Form)
• Experience in data warehouse design, data modeling and database administration activities.
• Extensively worked on the Cassandra data modeling and designing of the database
• Experience in incorporating commercial requirements into conceptual and logical quality data models using Visual Parading and physical data models created using advanced engineering techniques to generate DDL scripts.

TECHNICAL SKILLS

• Databases: Oracle 11g/ 12c, PostgreSQL 8.x /9.x, MySQL, SQL Server, SQLite, DB2, MS Access, MariaDB, Sybase, Cassandra, MongoDB.
• ETL/Data warehouse Tools: ODI, Informatica, Talend, Ab Initio, Microstrategy, Pentaho, SSAS and SSIS.
• Data Modeling: Erwin, Visual Parading, Crystal Reports.
• Tools: SSRS, MS - Office suite (Word, Excel, MS Project and Outlook)
• Operating System: Windows, Linux(Ubuntu, Debian)
• Tools: & Software: GIT, Subversion, AWS, Pgpool, Symmetry, SharePlex, Oracle Golden Gate, Reko
• Project Execution Methodologies: Ralph Kimball and Bill Inmon, XP, SCRUM, Rational Unified Process (RUP)
• Programming Languages: SQL, PL/SQL, T-SQL, DQL, C, UNIX shell Scripting, Python, PHP
• Protocols HTTPS, HTTP, SSL, SMS, MMS, OpenSSL, SMTP, FTP.

PROFESSIONAL EXPERIENCE

Data Architect/Data Modeler

Confidential

Responsibilities:

• The concepts related to the process of replication, migration and centralization of the information for multiple data centers were studied in depth. Different replication tools were installed, configured and assimilated (Pgpool, Symmetry, SharePlex, Oracle Golden Gate, Reko), in order to determine the functional and non-functional requirements for the replication tool to be developed.
• Translated business requirements into conceptual, logical and physical data models using Erwin.
• Created tables, views, sequences, indexes, constraints and generated SQL scripts for implementing physical data model.
• Implementation of triggers in C language that will manage the process of capturing the information, in an agile and efficient way using libpq - C Library.
• Development aggregations, key performance indicators and browser perspectives extensively developed.
• I created, maintain and optimize database objects for multiple managers.
• I manage the Lead design and code reviews.
• Developed and maintained the data dictionary to create metadata reports for technical and commercial purposes.
• I work in the construction of queries and complex SQL functions associated with the business, interacting with the attributes and data collected in the System Catalogs and Information Schema.
• Development and maintained metadata and metadata management strategies for the data model.
• Segmentation of information through criteria guaranteeing greater performance in queries and availability of information.
• I performed analysis, developed specifications, designed and developed reports and dashboards using Crystal Reports, MS Excel and other standardized reporting tools.

Environment: Oracle 11g, PostgreSQL 9.0, SQL Server 2008, Pgpool, Symmetry, SharePlex, Oracle Golden Gate, Reko, Erwin, SQL, PL / SQL, C, DQL, libpq-C, Crystal Reports, MS Excel 2007, Modules pgcrypto, uuid-ossp, Sybase IQ, JSON, BJSON, XML, System Catalogs and Information Schema.

Data Architect/Data Modeler

Confidential

Responsibilities:

• Worked in data analysis, data profiles and data governance, identifying datasets, source data, source metadata, data definitions and data formats.
• Designed the Logical Data Model using ERWIN for each thematic area.
• Worked on T-SQL query scripts, complex stored procedures, user defined functions, database triggers, etc.
• Developed a roadmap and long-term data warehouse architectures, design and build the data warehouse framework.
• Involved in the analysis, design, testing and implementation of Business Intelligence solutions using Data Warehouse, ETL, OLAP, Client / Server applications.
• Managed the import of data from various data sources and transformations.
• I designed and developed architecture for the data services ecosystem that encompasses Relational and NoSQL technologies.
• Specify the general data architecture for all areas and domains of the company, including data acquisition, Data Warehouse, Data Migration, ETL and BI.
• Install and configure servers and clients using SQL Server. Creating and updating SQL databases.
• SSRS reports of complex subtrees were created using OLTP and OLAP databases.

Environment: Oracle, MySQL, PostgreSQL, SQL Server, NoSQL, ETL, OLAP, OLTP, T-SQL, SQL, PL/SQL language, Erwin, SSRS, SSIS, JSON and XML.

Data Analyst/Data Modeler

Confidential

Responsibilities:

• I developed the logic and the physical model from the conceptual model with the use of Visual Parading, based on the analysis of business requirements.
• Responsible for designing and implementing efficient stored procedures and packages in PDI.
• I designed a high level ETL architecture for the general transfer of data from OLTP to OLAP.
• ETL packages were created and executed to complete data from various data sources for different data loading operations for many applications.
• Determine the best approach to design data structures that support easy data consumption, trend identification and the ability to highlight exceptions through reporting tools and dashboards.
• Used reverse engineering for a wide variety of RDBMS, including MS Access, Oracle and DB2 to connect to an existing database and create a graphical representation using Visual Parading.
• Data migrated from PostgreSQL to the data warehouse using the integration services to generate the reports.
• Created and Designed Data Source and Data Source Views and also configured OLAP Cubes (Scheme of Stars and Snow Scales) using Pentaho Reporting and Pentaho Dashboard.

Environment: SQL, Visual Parading, XML, JSON, UML, including MS Access, Oracle and MySQL, PostgreSQL, MS-Excel, PowerPoint, MS-Word, Microsoft SQL, Pentaho Reporting, Pentaho Dashboard and Pentaho Data Integration.

Data scientist

Confidential

Responsibilities:

• As an architect, he designs conceptual, logical and physical models using Visual Parading and builds DataMarts using hybrid methodologies of Inmon and Kimball DW.
• Worked closely with companies, data management and suppliers to define data requirements.
• Worked with research, discovery and data mapping tools to scan each data record from several sources.
• Designed the Data Mart prototype and documented the result for the end user.
• Involved in the modeling of business processes using UML.
• Developed and maintained the data dictionary to create metadata reports for technical and commercial purposes.
• Created SQL tables with referential integrity and queries developed using SQL and PL / SQL.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and DB2.
• Implementation of the replication, encryption, aggregation, indexing and security of the information.
• Design, coding, unit tests in ETL packages using Talend.

Environment: Talend, PostgreSQL, OLTP, Oracle 10g, OLAP, DB2, metadata, MS Excel, Visual Parade, Rational Rose, PL / SQL, SQL, SQLite, XML, JSON, Tortoise SVN, etc.