A Data Engineer with a proven history of turning large data sets into progressive ideas through the creation of clear, compelling info-graphics, maps, data visualizations, and interactive report designs. I also demonstrate strong Understanding of web programming languages such as HTML 5, CSS3, JavaScript, WordPress, Bootstrap, J Query, and API’s. I have experience in building websites from scratch using cutting-edge technology
Data Engineer, Data Warehouse/Business Intelligence @ • Developing Python code to extract structured and unstructured data
• Web Scrapping with Python and storing the retrieved data in CSV format or into the database.
• Using Various Python libraries such as Scipy, Pandas, BeautifulSoup, numpy to collect and extract data
• Experience with web services API integration; RESTful, JSON.
• Successfully Developed a Project management tracker in Oracle Apex to manage projects using PL/SQL, JavaScript, HTML5, CSS3
• Creating packages and Processing Flat files using SSIS.
• Logical & Physical database design and data modeling
• Develop database procedures, transformations, integrations, and queries to access and transform data.
• Creating report, Data Visualization , Dashboard, Storytelling using BI applications tools (Tableau)
• Good Data warehousing concepts including Star & Snow-Flake Schemas, Fact &Dimension Tables.
• Risk monitoring of data flows to project partners. From August 2015 to Present (5 months) Data Analyst @ • Use online data tools including but not limited to Salesforce.com, to extract data, manage and analyze data feeds.
• Analyzed SQL database and writing queries (SELECT, INSERT, UPDATE, and DELETE).
• T-SQL development skills including query optimization, stored procedures and views.
• Designing dashboards and reports using Tableau Software / Excel PowerPivot.
• Exposure to creating an Extract, Load and Transform (ETL) solution with SSIS.
• Generate reports using Microsoft SQL Reporting Services (SSRS). From September 2014 to June 2015 (10 months) Front-end Developer - Freelance @ • Developed a website for Burnside Optics Inc. using Bootstrap, LESS, HTML5, CSS, and JavaScript.
• Build a weather scraping site using PHP, HTML5 and JavaScript which tell the current weather of a city. http://www.afterbright.com/php/weather.php
• Build an Audio Player which is powered by jQuery, DOM manipulation, HTML5, JavaScript,
• Experience interacting with various API’s ~ Google Maps API, Twitter API
Link to Projects: www.afterbright.com, From July 2014 to May 2015 (11 months) Data Analyst @ • Create Powerful Reports using PowerPivot Dashboard, Timeline and Slicers
• Wrote SQL queries to extract data from Access Database.
• Automated update procedures using Excel Macros.
• Maintained and ensure data accuracy for the Fiscal team database by running queries and analyzing data
• Performed Data analysis to tracked consultants using the General Ledger detailed report.
• Experienced with advanced functions in Microsoft Excel and VBA From March 2014 to July 2014 (5 months) Greater New York City AreaData Analysis @ • Identified, analyzed, and interpreted trends or patterns in data sets.
• Managed critical dates of lease expirations, renewals and prepared new leases.
• Work closely with management to prioritize business and information needs.
• Filed 8A Loan J-51 tax abatement program for landlords. From April 2012 to May 2013 (1 year 2 months) Greater New York City Area
Bachelor of Business Administration (BBA), Computer Information Systems @ City University of New York-Baruch College From 2013 to 2015 Bachelor of Science (BSc), Mathematics and Statistics @ University of Cape Coast From 2010 to 2012 Bright Adu Poku is skilled in: Real-time Data, Data Warehousing, Data Warehouse Architecture, ETL, SSIS, Oracle SQL Developer, Dimensional Modeling, Data Modeling, SSRS, SDLC, Kimball Methodology, Machine Learning, Star Schema, Snowflake, Big Data Analytics
Websites:
http://www.afterbright.com