Francis Mello Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

- Using Oracle database system (tables, functions, procedures) to import, transform, and load data into our staging and production environments; writing, modifying, and running queries and stored procedures to analyze data (our main analysis objectives include determining record matches and redundancies between different data releases; looking for hierarchies, e.g., main table – sub table relationships between related tables; and verifying data integrity).- Understanding and documenting user data requirements to ensure that the data that is transformed and loaded into our database meets the needs of our end users/end product specifications- Developing data policies and standards, and later, writing queries, stored procedures, and functions (software code) to ensure adherence to said policies and standards.- Operate database management systems to analyze data and perform data mining analysis.- Research and document data requirements, data collection and administration policy, data access rules and security.- Conduct research and provide advice to other informatics professionals regarding the selection, application and implementation of database management tools.- ETL- PL/SQL- SQL- Data Modeler

Vancouver, Canada Area

- Developed Oracle PL/SQL procedures - Evaluated the Data Quality with SQL and PL/SQL- Developed and updated documentation- Developed project documentation templates- Worked closely with CTO to discuss ongoing and new projects- Built queries (SQL) in Oracle - Developed reports using SQL and Crystal Reports

Porto Alegre Area, Brazil

- Built ETL using Oracle PL/SQL and Oracle Data Integrator (ODI)- Used Oracle PL/SQL for creation of various Packages, Tables, Views and Materialized View creation- Performed Data Modeling creating: a Staging Area, an Operational Data Store(ODS), a Data Warehouse (DWH), Data Marts and Flat Tables- Performed projects in different areas: Marketing, Credit, Risk, Investment, Cards,- Checking Account, Insurance, Consortium- Developed ETL, Dashboards and Reports to Campaigns (FIFA World Cup 2010/2014and other), Prospecting Customers- Developed reports, dashboards, ad-hoc querys using OBIEE- Assisted with ETLs (SQL, PL/SQL) troubleshooting and performance optimization- Supported the software developer with guidelines to build the solutions- Participated in the definition and design of new systems and enhancements - Analyzed business requirements- Prepared and updated the documentation to develop the applications- Performed Unit Testing, Integration Testing, System Testing- Assisted with the resolution of problem fixes - Reviewed code of stored procedures and gave consultations to other developers- Developed reports using SQL Language- Provided stress test results of data integration to development team- Maintained Test Beds for Transform, Traffic and Transport- Worked as a Scrum Master- Led development of requirements and all documentation- Was responsible for effective allocation of resources to project- Technologies Used: Oracle PL/SQL, SQL, ODI, OBIEE, Enterprise Architect, Teradata, Oracle Database, MS SQL Server, ERwin, PL/SQL Developer, MS Project, Excel

Porto Alegre Area, Brazil

- Team Leader- Recruitment of people- Task management- Coaching- Assigning Work- Performance Appraisals

Sicredi

- Project management with PMBOK methodology;- Business Analyst.

Porto Alegre Area, Brazil

• Developed Packages, Procedures, Functions, Triggers, Tables, Views and Materialized Views• Developed documentation, appraising users of vital information• Built several queries (SQL) in Oracle to manipulate data files• Built several queries (SQL) and Oracle PL/SQL • Developed load, performance and test automation- Assisted with the resolution of problem fixes- Built SQL scripts to evaluate the data quality- Performed the ETL architecture- Worked with technical writers for reviewing technical documents - Performed both Relational and Dimensional Data Modeling- Provided production support 24-7- Technologies Used: Oracle PL/SQL, SQL, Oracle Data Integrator, OBIEE, Oracle Database, PL/SQL Developer, Enterprise Architect, ERWin, MS Project

Porto Alegre Area, Brazil

- Performed software development- Developed stored procedures, functions, triggers- Assisted with the resolution of problem fixes- Created design documentation designed data structure- Built data base and wrote code- Developed reports using SQL, Oracle PL/SQL- Performed Data Modeling of Transactional Data Store- Prepared Test Data, executed Test Cases and reported Test Results- Technologies Used: Delphi, Oracle PL/SQL, SQL, Oracle Database, Enterprise Architect, CA ERWin

Novo Hamburgo Area, Brazil

- Performed software development - Executed code review, inspection and unit testing, debugging- Prepared Test Data, executed Test Cases and reported Test Results- Provided production support 24-7- Developed reports- Performed Data Modeling of Transactional Data Store- Maintained network system- Provided customer support to 90+ stores in Brazil- Technologies Used: Delphi, Oracle PL/SQL, SQL, Crystal Reports, HTML, CSS, ASP, Clipper, Oracle Database, PostgreSQL, Linux, Novell, Windows

Certificate In Management Of Enterprise Data Analytics, Big Data

Manage a Big Data/predictive analytics initiative. Address methodology, quality control, change management and other related matters. Know.

Full Stack Web Development Certification, Computer Software Engineering

Master Of Business Administration (Mba), Project Management (Recognized By Wes)

Pos Graduation with focus in project management. Using the PMBOK methodology.

Bachelor In Information Systems (Recognized By Wes), Process, Data Base And Data Quality

Technician In Data Processing, Computer Software Technology/Technician

Activities and Societies: Soccer