Marcos Mychel R.
Data Engineer Advisor @Desjardins
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer Advisor @Desjardins
EDUCATION
Faculdade Integrada do Ceará
Degree in Technology Analysis and Software Development
ABOUT MARCOS MYCHEL R.
Business Intelligence developer with 7+ years of experience plus a 5+ SQL Server DBA experience background in parallel where I´ve had participated in numerous projects to analyze the database(s) with a focus on: • Capacity planning and performance of critical applications;• Developing complex SQL queries in diverse SGBD´s platforms (SQL Server, Oracle (8i/10g), DB2, SolidDB, MySQL);• Performance tuning (SQL Server focused);• Development of stored procedures, triggers and views for bank withdrawal with low fault tolerance in a complex data replication environment; • Cluster service and very large databases that require an expert troubleshooting vision.As a Business Intelligence developer, I´ve been:• Gathering business end users requirements; • Building ETL jobs (Cognos Data Manager, SQL Server DTS / Integration Services);• Data modeling (Relational and Dimensional), Data Dictionary and physical database design;• Metadata Modeling in IBM Cognos Framework manager; • Modeling and building Cubes In IBM Cognos Transformer and SQL Server Analysis Services; • Delivering useful data by Reports, Dashboards and Predictivity Analysis using Cognos Report Studio, SQL Server Report Services, and Power BI.Furthermore, I´m always eager to learn new tools, technologies and concepts putting them in practice.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.