ALVES CARVALHO, ALLYSON
** **** ******, *********, ** 024**-***-*** 1497 *******.********@*****.***
SUMMARY
My objectives as an IT Professional Analyst is to learn, explore new challenges, and achieve both personal and company goals. I describe myself as a diligent and dedicated worker and enjoy leading as well as collaborating with team members. These qualities will allow me to achieve success in any new challenge or project.
COMPUTER SKILLS
Languages
SQL Languages (T-SQL and PL/SQL)
Java, Selenium, Android SDK, JavaScript, JQuery, JQuery Mobile, PHP, Python, Hadoop, Hive, Sqoop, Natural
Software
Vertica Database
Power BI
EXPERIENCE
May 2015 - Recent
QA Engineer, Boston University
Assist the Information systems department in creating automation scripts in Java and Selenium
Create and assist on planning, designing, and coding a software/automation system for automation procedures
Perform smoke test, functional, and regression tests using Java/Selenium scripts
Tasks:
oDevelopment of a automation test for a specific project using Selenium and Java
oAnalysis and adjustment of daily automation tasks
oDefect tracking using IBM QTP
oSmoke and function tests performed in the Faculty System BBEC Blackbaud.
Tools, Programming Languages and APIs used:
oJava
oPython
oSelenium
oApache POI
API Django Restful Framework
March 2014 – December 2014
Business Intelligence Consultant, Five Acts
Assist pre-sales team and proof of concept preparation using Tableau Desktop. Assist using technical skills and sales skills
Training company’s new members in Business Intelligence concepts and tools provided by the company
Analysis and gathering of new business requirements for projects in the sales phase and/or in the initial phase of the project using SDLC
Development of Business Intelligence projects (remotely) using SSIS for extraction, transform, and load and SSAS along with SSRS to build cubes, reports, and dashboards
Development of customized dashboards. Adding front-end programming language so the dashboard could be more interactive and richer for analysis
Software used:
oTableau Desktop Software (OLAP)
oT-SQL and PL/SQL for writing ETL(extraction, transform, and load) scripts in order to process the high amount of data
oIBM Datastage for project development. Using a migration tool in some cases
oMicrosoft SSIS, SSAS, and SSRS
oSQL Server 2008 Database
January 2010 – January 2014
IT Director, Provide Intelligence
Manage IT Development team in Business Intelligence projects
Assign and review project development directives as well as the business process involved in the current methodology
Benchmark IT solutions, software, and systems for future development
Work with different departments in order to plan, develop, evaluate, monitor, and manage the progress of projects as well as clients expectations towards the goal
Train Business Intelligence new collaborators
Build sales technical presentation in support of the sales and executive teams. Present projects and proposal as needed
Manage relationships with clients and partners (solution provider)
Provide guidance for the development team as needed, in addition to hands-on implementation, when task force was and teams were in need
Review and analyze business company directives using balanced scorecards (BSC) to keep track of company’s goals, evaluate root causes, and use all techniques within the technology to monitor progress
Provide assistance as needed for other departments in terms of technical solutions, solution evaluation, proof of concept, and technological guidance
September 2013 – December 2013
Business Intelligence Team Leader, 4Sight Technologies
Assist pre-sales team in multiple meetings across America and technical proposals for Em360 platform BI Solutions and deployment
Lead requirements gathering interview for projects in Bogota and Panama (The interviews were conducted in Spanish)
Analyze and assist in the Business Intelligence department creation. Plan process workflow as well as the methodology for project development – BI life cycle
Build a Business Intelligence team for the company. Train employees in BI concepts, tools, ETL, and implementation patterns
Build ETL procedures in order to process the data
Build reports and dashboards on EM360. In addition, customize each dashboard and view
Perform benchmark of ETL and BI tools for the company’s C-level as well as presentations of each technology and how well are they aligned with the company’s objective
Software and programming language used:
oEM360 Business intelligence Platform
oT-SQL, PL/SQL as part of the ETL process involved on each project
oOracle Database 10g, Oracle Database 11g for administration and development.
Acted as database administrator for a short period of time. Monitoring, configuring, and customizing were part of the responsibilities for each project in order to obtain the best performance
March 2008 – August 2013
Business Intelligence Analyst / Project Leader, CDS
Assist sales team to perform technical sales and build proof of concept in order to help clients to evaluate the Business Intelligence technology
Lead a team of 3-5 collaborators to develop a project or proof of concept. Many times, the job function required communication with other departments, such as Database and Network, in order to build a solid BI system.
Responsible for managing team’s synergy with other departments and clients.
Responsible for tracking project’s deadlines, goals, and reports along with a project manager. In addition, presenting a weekly basis report to managers and clients following an agile methodology in Business Intelligence.
Responsible in helping the team during project’s development phase. Guiding and hands-on coding were required during this phase
Software and programming languages were used:
oT-SQL and PL/SQL for ETL development. Sometimes inside an ETL tool such as Oracle Data Integrator and others in procedures in the database
oDTS and SSIS for ETL processes in projects that required a Microsoft stack of tools
oOracle Database 10g and 11g during development phases. Database administration skills were required in some cases where the client didn’t have any database available or contract to use it
oSAP Business Objects (BO) in projects that were required to use it
oOracle Warehouse Builder and Oracle Business Intelligence Enterprise Edition (OBIEE) during OLAP project phases
oOracle Data Integrator (ODI)
Honorable Mention - 2013 Year Award
oFor overcoming the presented obstacles, the quality and delivery of project
Project: SEBRAE – Brazilian Support Service for Micro and Small Companies
EDUCATION
2014 - 2015
Master’s Degree – Computer Information Systems with concentration in Business Intelligence and Database Management, Boston University
2006 - 2011
Bachelor’s Degree – Information Systems / Computer Science, UPIS (Brazil)
CERTIFICATIONS
June 2014
Tableau Desktop 8 Qualified Associate, Tableau
February 2013
Oracle Business Intelligence Foundation Suite 11g Essentials, Oracle
October 2011
Oracle Business Intelligence Foundation Suite 11g Essentials, Oracle
INDEPENDENT COURSEWORK
SENAC
Object Oriented Programming Concepts
Database Administration with SQL Server
Java Programming Language
JSP Programming Language
TERADATA
Teradata Active EDW 5600 & Data Warehouse Appliance 2580: Overview
Teradata Extreme Data Appliance 1600 Overview & Data Warehouse Appliance 2580 with 1TB Drives Update
Teradata Extreme Data Appliance 1600 Technical Overview
Teradata Platform Overview Update: Teradata Active EDW 5555 and Appliances
Phase 3: Teradata Live: All About Teradata
New Hire MBA Phase 3: Teradata Live: Selling Teradata with Confidence Workshop
CDS
ETL Powercenter Training - Workshop
SERPRO
JCL – Job Control Language
TSO / ROSCOE