Data Analyst Senior
Resume:
Enoch Asamoah
Lavon, Texas *****
ad5uzu@r.postjobfree.com
SKILLS SUMMARY:
Focused and highly motivated Technical and data professional, 13 + years of total experience working in Software engineering and development and a proven track record of optimizing systems for performance and reliability.
Tested but with amazing storytelling skills that can answer most complex problems for the customers, I am excited about the opportunity to bring my leadership skills, and passion for data solutions to the agency.
I have more than 6+ years of experience utilizing business knowledge, policy deployment, delegating, planning, and strategic thinking to effectively completed successful projects which resulted in revenue increase.
I have more than 10 years of experience working with data using SQL and 4 years skilled in using python to develop insights from raw data.
I have more than 2+ years of experience utilizing machine learning algorithms to extract meaningful insights from large and complex datasets.
Deep understanding of data management, analysis, and data visualization techniques such Tableau and Power BI.
As Snr Apps Developer I managed and collaborated with the staff of 30+ internal and external personnel to complete migration of ~200 Tableau and database AutoSys jobs from old CSID unique identifier to new unique identifiers. With skill set such as effective communication and collaboration with technical and non-technical stakeholders and a proven track record of translating these insights into actionable items, completed the configuration, development and testing of AutoSys JIL scripts within limited time and finally deployed them to all environments. This resulted in significant time and cost savings, and revenue growth rate by 15%.
As Snr Apps Developer I successfully collaborated with technical and non-technical stakeholders to develop predictive models to optimize marketing campaigns, analyzed customers behavior who have a higher probability of purchasing new loans to identify opportunities for revenue growth, this resulted in an increase in revenue by 20% and also improved customer retention.
PROFESSIONAL EXPERIENCE:
Citigroup Inc. Irving TX
Apps Dev Snr Programmer Analyst 10/2019 – Present
Database developer
Developed PL/SQL scripts, packages, procedures, etc for data manipulation and validation and materialized views to implement business logic using SQL developer for reporting tools.
Wrote packages to fetch data from different tables in remote databases using joins, sub queries and database links for reporting tools.
I worked in Production Support Environment as well as QA/SIT environments for projects, work orders, bug fixes, enhancements, data changes, etc.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the applications.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Collaborated on full development cycle of requirement gathering, solution design, and delivery.
Collaborated with the staff of 30+ internal and external personnel to complete migration of ~200 Tableau and database AutoSys jobs from old CSID unique identifier to new unique identifiers. This resulted in significant time and cost savings, and revenue growth rate by 15%.
Big Data developer
Designed and implemented a new big data pipeline, stream processing and highly scalable data storage in ETL process, resulting in a 40% improvement in data quality and integrity.
Developed Spark code using Scala and Spark-SQL/Streaming for faster testing and processing of data.
Implemented Spark SQL optimized joins to gather data from different sources and run ad-hoc queries on top of them.
Developed using SQOOP for importing and exporting data between RDBMS and HDFS..
Developed using Hive DDLS to create, later and drop Hive tables.
Developed complete big data flow of the application starting from data ingestion from upstream to HDFS, processing and analyzing the data in HDFS.
Automated all processes (copying input files, data ingestion and data loading) in all the environments to run at specific times.
All development were implemented in cloud-based data warehouse RedShift.
ETL Data developer
I worked on a project to replace ab initio ETL process with ETL data pipeline built on Data Transformation Service (DTS) using HDFS and PySpark/Python on AWS Cloud. Implemented data integration, combining data from multiple sources, enriching, and aggregation of large data volumes.
Developed source data view for Tableau reports interacting with Hadoop to identify assessment entity to relevant assessment unit.
Created complex queries using risk data as ETL for tableau dashboards and improving risk reduction by 15%.
Data Engineer
I worked on risk assessment data projects to mitigate risk. Data testing, analyzed and data remediation to mitigate risk during assessment cycle.
I worked as data analysts in a reporting project migrating from excel macro to micro strategy dashboard and exported in XML format.
As data analyst analyzed data, created mapping document, and created SQL queries on the complex input data and extracted insights data to help micro strategy developers completed a project migrating from excel macro to micro strategy dashboard.
Coordinated with technical project managers and database developers to architect data structures and schemas to support a suite of scalable business applications.
Ericsson, Plano TX
Application Developer / Data Analyst 08/2017 – 10/2019
Data analyst-visualization
Researched data issues on both the reporting and source (SQL database or big data) layers and provided recommendation for corrections based on either customer or internal requests.
Ingested data from disparate data sources using a combination of SQL to create data views to be used in BI tools
Developed and optimized complex SQL queries, improving query speed by 35%.
Application developer
Created configuration tables as dimensions or fact using python in Apache Hadoop data-lake based business needs.
Collaborated with software development teams to integrate database solutions into new applications during data migration strategy from relational database to big data platform.
I worked with stakeholders, developers and production teams across units to identify business needs and solution options.
BI reporting developer
Collaborated with clients to understand business needs and translated those business needs into actionable reports.
Created new or fixed broken Tableau or SAP business objects reports using relational database (MS Server) or Big Data (Hadoop data-lake) as source. All reports were tested in DEV and QA environment then promoted to PROD.
PepsiCo Inc. Plano TX
Testing/Functional Analyst 08/2016 – 06/2017
Performed detailed test case design and executed tests for main global projects (source to reporting). Created test plan, test cases and completed test result documentation for all KPIs.
Analyzed all test results and made recommendations stakeholders. Published test summary reports.
Nike Inc. Beaverton OR
BI /Data Analyst/ETL 01/2016 - 08/2016
Led a team of 2 consultants (onshore) for requirement gathering, functional design and delivery of ETL projects. Created PL/SQL stored procedures to extract QA data, transform and load fact and dimension tables into oracle database for cognos reporting.
Implemented data integration, combining data from multiple database sources, cleaning and verifying it by removing errors, enriching, and aggregation, and storing it in a single location.
Developed ETL pipeline processes using PL/SQL procedures in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
Tuned procedures and reduced ETL runtimes for data quality and improved response time, resulting in 30% reduction in CPU consumption.
Developed content for RFPs (Request for Proposal) focused on migrating from Cognos to Tableau dashboards. Management did not approve because of budget.
Payless HQ. Topeka KS
Data Analyst Lead 07/2015 – 12/2015
Project was to fix broken management reports after migrating from DB2 source to Oracle.
Analysis Phase:
Assessed the target data needs by understanding the business requirements, conducted gap analysis between the target (Micro Strategy reports) and source data (Oracle DB), and helped client understood the current and corrected data warehouse.
Fixing Phase:
I led a team of 5 consultants (onshore, offshore) to mitigate those gaps by working with the developers. We corrected the scripts in the following layers source, operational data store (ODS), ETL (Teradata DB) and Micro Strategy. Project size: 6 practitioners, overall budget $750,000.
Capital One Inc. Plano TX
BI Developer/Data Analyst 11/2011 – 07/2015
I worked on requirement gathering, functional design and delivery of incentive scorecard report, BAU reports for defaulted loans and other Business Objects reports using data from Teradata database. Collaborated with multiple cross-functional stakeholders and successfully delivered to various clients.
Developed and executed complex SQL queries for the reports, achieved seamless transition with zero or fewer data loss and minimal downtime.
Maintained SQL scripts indexes and complex queries for analysis, extraction and efficient management of data resources.
SKILLS DEVELOPED
Functional Skills: Data Strategy, Project Planning/Timeline Development, Stakeholder Communication, Agile and Waterfall Project Execution Methodologies, Requirements Gathering, Functional Design.
Technical Skills: SQL, Python, PL/SQL, UNIX, Visio, Visual Studio, MS Office, Pyspark, Big Data, Hives, Autosys, Jenkins, RLM, Git, Data Design, Java, Docker, HDFS, MagicDraw.
Algorithms: Linear and logistic regression, decision tree, random forest, xgboost, gradient boosting, PCA, Kmeans, HC, DNN, CNN, Recommendations systems.
Data Manipulation: Pandas, Numpy, Apache Spark, Python, Excel, Jupyter Notebook, SQL Developer, Tensor Flow.
Visualization: Seaborn, Matplotlib, Tableau, Power BI, SAP Business Object
Databases: Oracle, MS Access, MS SQL Server, Teradata, DB2, Hadoop, MySQL, JDBC
Operating Systems: Windows, AIX, HP-Unix, Ubuntu, Linux
EDUCATION:
Post Graduate Program –AI & Machine Learning: Great Learning (Olympus)/UT at Austin (McCombs)
MS Software Engineering -University of Texas at Dallas, Richardson, TX
Linkedin: https://www.linkedin.com/in/enoch-asamoah-977b3416/
Great Learning: https://eportfolio.mygreatlearning.com/enoch-asamoah
Certifications:
ICAgile ICP
ICAgile Agile Project and Delivery Management
IIL,Inc - Project Estimating and Scheduling
IIL,Inc – Advanced Project Communications
Contact this candidate