Data Developer
Resume:
JELLICOE STEVE AIDOO ***********@*****.***
RELEVANT EXPERIENCE
•ETL Informatica – 6 + Years
•Data Analysis – 6 years
•Tableau – 6 years
•Data Modeling – 4+ Years
SKILLS AND ACCOMPLISHMENTS
Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and VBA).
Excellent knowledge and usage of reporting tools such as Tableau.
Experience in data scrubbing and cleansing.
Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM using SharePoint Tracker and IBM Rational).
Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
Exceptional organizational and time management skills and the ability to work independently.
Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.
Utilize business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and Excel.
Experience in data analysis and ETL techniques for loading enormous amounts of data.
Experience with data mining.
Identify issues when reports are created from several and complex data sources.
Perform data modeling, data migration, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension Table, Physical and Logical Data Modeling using Erwin 3.x/4. x.
Excellent knowledge and usage of statistical/mathematical analytics software like R Statistical Software, SPSS, Matlab.
TECHNICAL SKILLS
Operating Systems
Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64)
Databases
MS SQL Server 2005/2008/2012, Teradata 12/13, MySQL 5.2, 5.7,
Oracle 9i, 10g, 11g
ETL/Other Tools
Informatica 9.5.1/9.6.1, SAS Base 9.x, R Statistical Software,
SAS, SSIS (Visual Studio), UNIX Shell Scripting, Erwin Data Modeler, ER Assistant
Querying Tools
SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL
Plus, SQL Developer, Toad, PL/SQL
Querying language
SQL, PL/SQL, TSQL
Business Intelligence
Tableau 9.3,10.0, 10.1, Excel and PowerPivot, SSRS
Tools
PROFESSIONAL EXPERIENCE
CSRA/GDIT
ETL Informatica Developer
Sept. 2017 – Date
•Designing and developing ETL with informatica power center processes for data warehouse; from the acquisition and staging of data, storing records within the warehouses historical archive and transforming records for loading into the reporting tables
•Experience in monitoring the environments and suggesting improvements for stability and performance tuning.
•Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
•Communicated with business customers to discuss the issues and requirements.
•Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
•Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
•Performed unit testing at various levels of the ETL and actively involved in team code reviews.
Center for Health Information and Analysis, Boston, MA
ETL Informatica Developer/Analyst
Aug. 2015 – June 2017
•Created complex PL/SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
•Experienced in optimizing performance in relational and dimensional database environments by making proper use of Indexes and Partitioning techniques.
•Designing and developing ETL with informatica power center processes for data warehouse; from the acquisition and staging of data, storing records within the warehouses historical archive and transforming records for loading into the reporting tables
•Performed various operations like Data Cleansing, Data Scrubbing, Data Profiling and maintained data governance
•Experience in monitoring the environments and suggesting improvements for stability and performance tuning.
•Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
•Communicated with business customers to discuss the issues and requirements.
•Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
•Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
•Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
•Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
•Performed unit testing at various levels of the ETL and actively involved in team code reviews.
PNC Bank, Pittsburg, PA
Oct. 2014 - June 2015
Data Analyst/ Data Architect
•Wrote queries to fetch data from different table by using joins, sub-queries, correlated sub-queries and derived tables on SQL Server platform.
•Extensive experience in designing the Data models for OLTP & OLAP database system. Strong Data Modeling experience using ER diagram, Dimensional data modeling, Star
Schema modeling, Snow-flake modeling using tools like Erwin, ERStudio.
•Wrote complex SQL queries using advanced SQL concepts like aggregate functions, group by and OLAP (Online Analytical Functions).
•Developed Tableau visualizations and dashboards using Tableau Desktop.
•Used SAS to import and export data from and into SQL Server tables.
•Used Pivot tables to create reports that performed dicing and slicing functions on data. This is called dimensional analysis and gives business a 360 view of what is going on.
•Developed leading routines and data extracts with Informatica and SAS and SQL procedures.
•Involved in the performance tuning of database and Informatica and improved performance by identifying and rectifying the performance bottlenecks.
•Extensive experience in Database Design, Normalization, Selective De-normalization, Forward/ Reverse Engineering of Applications, Conceptual, Logical and Physical data modeling using Erwin, E/R Studio .
•Carried out data extraction and data manipulation using SQL as per business requirements.
•Performed ETL mapping and designed transformation document as per business requirements with informatica.
•Developed and implemented strategies to handle errors by the ETL teams.
•Extracted data from flat files, Oracle, DB2, and SQL Server 2014, and loaded the data into the target database.
•Developed automated tool for updating and running quality checks on ERWIN data models.
•Created logical and physical models using ERWIN.
Staples Inc., Framingham, MA
July 2012 – August 2014
Tableau Developer/Analyst
•Used Tableau Server as a frontend BI tool and MS SQL Server 2012 as a backend database to design and develop workbooks, dashboards, global filter page, and complex parameters-based calculations.
•Worked with team of developers and designed, developed and implemented a BI solution for sales, product and customer KPIs.
•Gathered business requirements and translated them into functional requirement for ETL process.
•Carrying out data extraction and data manipulation using SQL as per business requirements.
•Performed ETL mapping and designed transformation document as per business requirements with informatica.
•Created compelling dashboards using Tableau dashboard and prepared user stories to deliver actionable insights.
•Connected Tableau Server to publish dashboard to a central location for portal integration.
•Implemented Tableau mobile dashboards via Tableau mobile application.
•Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
•Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
•Developed Tableau workbooks from numerous data sources using Data Blending.
•Developed Tableau visualizations and dashboards using Tableau Desktop.
Goldfields Ghana Limited, Ghana.
Junior Analyst (Grad Intern)
March 2010 – August 2011
Responsibilities:
Worked with a team to design, develop and maintain employee and servicing client databases using MS Access.
•Prepared reports using advance Excel functions.
•Used Power Pivot as a data mining tool to obtain business requirement.
•Used lookup and data validation in Excel to generate servicing client billing reports.
•Modeled occupational injury with SPSS.
•Worked with a team to design and optimize shortest path for dump trucks from crushing plants to waste dumps.
EDUCATION
M.Phil. Mathematics, University of Mines and Technology, Ghana
BSc. Mathematics, Kwame Nkrumah University of Science and Technology, Ghana
Short Scholar, Montana Tech of the University of Montana, Butte, Montana
Contact this candidate