Candidates About

Remensmos Mbah (REMS)

 Will ONLY Consider Jobs in MD, DC, and Northern VA

PROFILE

Enterprise IT Professional with 13+ Years of Industry Experience ~ Collaborative data engineer with extensive hands-on experience in developing and deploying robust and scalable cloud-based/on premise data analytics systems involving large scale CDI, MDM, MPP, data integration/migration, data lake, data warehousing, real-time data analytics and US regulatory reporting. With sound business and technical acumen is able to research, explore and leverage Big Data technologies (HDFS, Hadoop or Spark cluster, NLP/Text Mining or Machine Learning) when existing enterprise frameworks are not sufficient to effectively process and analyze terabytes of structured and unstructured data.

SKILLS SUMMARY

·         Extensive experience in architecting, prototyping, testing, and implementing Big Data analytic solutions on a Hadoop/Spark/NoSQL Platform and leveraging a broad set of big data skills and capabilities to provide innovative leadership, solution architecting and implementation guidance for robust Big Data solutions.

·         Experience in creating data ingestion and processing pipelines focused on structured, semi-structured/ unstructured data or both to assist with data visualization and machine learning algorithms including, delivering proof of concept execution to prove the value of Big Data use cases.

·         Proficient in Big Data Exploration, Profiling, Quality, Transformation with hands on experience in designing efficient and robust ETL/ELT workflows, schedulers, and event-based triggers.

·         Expertise in developing relational and NoSQL databases including OLTP, OLAP, MDM, Data Warehouse and Data Governance solutions using 3NF, Star and Snowflake schemas designs.

·         Experience in implementing Data Mining, data visualization, statistical and historical/predictive Data Analytics solutions using enterprise level BI and Big Data processing tools.

·         Strong Data modeling (Logical and Physical) experience and high proficiency in using Erwin, ER/Studio, and Entity-Relationship Modeling with in-depth understanding of business applications, dataflow and the use of stored procedures/triggers in ETL development tasks.

·         Experience in Data Dictionary implementation, Data security (SSL/ACLs/RBACs/Encryption), TOGAF, SOA, UML, data structure/model classifications, data wrangling and data cleansing.

·         Experience in RESTful APIs, Docker, Hashicorp Tools, Jenkins and Microservice architecture.

·         Have hands-on experience in implementing Big Data solutions leveraging Databricks, Azure HDInsight, Hortonworks, Cloudera-CDH, AWS; data ingestion using Kafka and Sqoop, analyzing big data using python, Pig, Impala/HiveQL, SparkSQL, and IBM BigSQL.

·         Have hands-on experience in SaaS, PaaS, IaaS, DaaS, SDLC (Agile/SCRUM framework – sprint planning, daily SRUM meeting, product/sprint backlog, sprint review, and sprint retrospective).

·         Significant training and experience in project management, unit/functional and system testing, user stories/requirements management, team(s) and tasks management using Rally Scrum/Agile, TFS (Team Foundation Server), Git/GitHUB, SharePoint, and Jira.

TECHNICAL SKILLS

Operating Systems             Windows 7 EE, Windows Server 2008/2012, and UNIX/LINUX

Databases                          MySQL, Oracle 11g/12c, Oracle RAC, SQL Server 2008-2016, DB2, Postgres, Netezza, Teradata, DynamoDB, Cassandra, HBase, MongoDB, DocumentDB, Coachbase, Red Shift, Elasticsearch.

Cloud Platform                        AWS, Salesforce, IBM, Cloudera, Microsoft Azure, Hortonworks, Databricks.

Networking                        TCP/IP, DNS, LAN, WAN, APIs, and RESTful Web Services.

Programming Languages    SQL, Xquery, JSONiq, Hive, Pig, R, Python, JSON, Avro, XML, Java, MapReduce, HDFS Shell, Jupyter, Zeppelin.

Big Data Tools                     YARN, Kafka, Zookeeper, Oozie, Ambari, HCatalog.

Big Data SQL Engines         HiveQL, SparkSQL, Presto/Airpal, IBM BigSQL, Impala, Google BigQuery.

Data Modeling                   Design OLTP & OLAP using ERwin, ER Studio, Microsoft Visio.

ETL/Data Ingestion Tools  SSIS, Informatica, Sqoop, Talend, Kafka, NiFi.

Machine Learning              WEKA, R, Python/Anaconda, SparkML, AML Studio, SSAS Data Mining.

BI Tools/Data Analysis            Tableau, Tibco Spotfire, Excel, Power BI, Kibana, SAS.

CRM & ERP Applications       Intuit Quickbase, AWS, Salesforce Sales Cloud, OBIEE.

Requirements/Code Mgt    Rally (Agile/Scrum), Jira, Team Foundation Server online/desktop, Jenkins, Git/GitHUB, Hashicorp (Terraform, Vault, and Vagrant).

PROFESSIONAL EXPERIENCE

T. Rowe Price, Baltimore MD                                                                                                          

August 2017 – Present

Senior Big Data Engineer (Cloud)

Responsibilities

·         Leverage AWS, Informatica Cloud, Snowflake Data Warehouse, Hashicorp Platform and Rally Agile/SRUM to implement Data Lake, Enterprise Data Warehouse, and advanced data analytics solutions based on data collection and integration from multiple sources (Salesforce, Salesconnect, S3, SQL Server, Oracle, MySQL, PostgreSQL, NoSQL and Mainframe systems).

·         Lead the architectural design and development of highly scalable and optimized data models, Data Marts, Data Warehouse, Data Lineage, Metadata repository and using Jenkins, Vagrant, Vault, GitHub/Git-Bash Enterprise and Terraform as IaS to provision cloud infrastructure and security.

·         Lead architect in building enterprise data warehouse and big data solutions from multiple data sources and repositories using S3, EMR, EC2, Informatica cloud, and Snowflake cloud Data Warehouse, with the objective to focus on resilience, scalability and robustness through the understanding of the client's vision, goals, limitations, data sources and timeline.

·         Implement AWS Data Lake leveraging S3, terraform, vagrant/vault, EC2, Lambda, VPC, and IAM in performing data processing and storage while writing complex SQL queries, analytical and aggregate functions on views in Snowflake data warehouse to develop near real time visualization using Tableau Desktop/Server 10.4.

·         Perform data masking and ETL process using S3, Informatica cloud, Informatica Power Center and  Informatica Test Data Management to support Snowflake Data warehousing solution in the cloud.

·         Query large data sets on Snowflake Data warehouse and distributive file systems using SQL/SparkSQL and manage JSON, XML, Parquet, CSV data format to ingestion into Snowflake Data Warehouse before perform advanced data analytics/visualization using Tableau.

·         Lead modeling and design of data architecture for operational data stores, data marts and enterprise data warehouse using Erwin.

·         Provide guidance and support in data masking/mapping tasks, data profiling, data quality checks, data standardization and metadata capture using Informatica Data Quality and Test Data Management.

·         Use Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories for Test Data Management process.

·         Provide guidance and support in developing KPIs, and evaluating alternative strategies for transactional and analytical systems to effectively share data between legacy data sources and cloud based enterprise relational/NoSQL systems.

BD Becton Dickinson & Company, Reston VA                                                                                

Oct 2015 – July 2017

Big Data Architect, Enterprise Technology Solutions

Responsibilities

·         Leveraged Microsoft Azure, Amazon Web Services and Rally Agile/SRUM in developing prototypes to build Data Lake and real-time big data analytics solutions based on data streaming and data feeds from broad range of customer-facing devices, web/mobile applications and back-end Java based systems; analyze and integrate data streams in-motion with back-office systems, processing big data using Spark and Hadoop (HDInsight/EMR) cluster, and developed machine-learning solutions in Azure Machine Learning (AML) studio and Spark MLlib.

·         Lead architect in prototyping, deploying and implementing Spark data lake cluster to support big data processing solution while leveraging AWS services, Kafka, NiFi, Amberi, Zeppelin, HDFS, ElasticSearch/Kibanna, Hive, Metadata Repository platform (Apache Atlas), and Spark Components ( SparkSQL, Spark Streaming, SparkML) in a Test-Driven Development (TDD), Continuous Integration (CI), and Continuous Delivery (CD) environment.

·         Led the architectural design and development of highly scalable and optimized Mobile solutions and Clinical Workflow Applications including management of on-site, off-site and off-shore team members and developers of Python/Java/C# applications using Jenkins and Docker.

·         Lead architect in building enterprise big data solutions from multiple data sources made up of 12 data repositories and 6 databases using S3, EMR, Data Pipeline, EC2 and Redshift.

·         Query large data sets on HDFS/distributive file systems using HiveQL/SparkSQL and managed JSON, XML, Parquet, CSV data conversion, integration, transfer and ingestion into ElasticSearch, Hbase, MongoDB, and Cassandra using Kafka/Sqoop and across Oracle 11g, MySQL and SQL Server2012 to perform real time data analytics using Power BI and Kibana.

·         Used AML service and Cortana Analytics to create and deploy cloud-based predictive analytics models that learn from existing/current data in order to forecast future outcomes and trends.

Kaiser Permanente, Silver Spring, MD                                                                                            

May 2011 – Oct 2015

Data Architect & Tableau Developer

Responsibilities

·         Lead Architect to evaluate, restructure/upgrade the information systems applications and using AWS cloud (VPC, IAM, Lambda, EC2, Redshift, S3, EMR, RDS, AWS Data Migration/Schema Conversion services) in performing data processing, migration, integration, and storage including implementing BI tools in claims administration and data analytics and providing recommendations to enhance data quality and the cloud DW solution.

·         Used Sqoop as the main Hadoop ETL tool for data transfer between HDFS and SQL Server 2012 operational data store and Netezza EDW solution.

·         Implemented data marts and data warehouse systems with de-normalized database schema objects using the star schema approach and performed data extraction from operational data stores and data marts on DB2, MySQL and SQL Server 2008/2012.

·         Deployed intensive use of ER/Studio and ERwin data modeler in the creation of conceptual, logical, and physical data models, database schemas for both data Server 2012, and transformed/loaded the data into Amazon Redshift.

·         Responsible for analyzing large and complex data sets to uncover anomalies, discover key patterns/trends, develop OLAP cubes and BI solutions using SSIS/SASS and Tableau.

·         Worked with Tableau Desktop 9x/Server to develop Dashboard and scorecard reports on KPIs using rich graphic visualizations with drill down and drop down menu option and various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Sets, Groups, and Parameters.

·         Worked on building queries/scripts to retrieve data into Python, R, and Tableau from SQL Server 2012, Oracle 11g, Netezza, MySQL and other external sources.

·         Implemented big data solution using CDH 4.7 and CDH 5x to process semi structured data.

·         Designed, reviewed, implemented and optimized data transformation processes in the Hadoop ecosystems including developing HiveQL scripts to parse the raw data, populate staging tables and store the refined data in partitioned tables in Netezza EDW.

·         Implemented MDM solutions using MS MDM service and IBM Initiate (MDM tool). 

·         Created pivot tables, dimensions, cubes, dashboards using Tableau, SSAS, and MS Add-in for Excel (power pivot, power query, and power view), while representing aggregates in different data visualization to highlight KPIs.

Community Credit Company Plc (Capital Market Corporation), Yaoundé                                   

April 2004 – Aug 2010

Financial/Data Analyst

Responsibilities

·         Leveraged Global Banking application to analyze the risk factor involved in a loan and the possibility of default on a loan to help the credit administrator make a reasonable decision on approving the loan and determining the rate of interest, or even deny lending of loan.

·         Collected all loan applicants’ information and performed analysis on the credit history of the loan applicants and making use of statistics in assessing risks associated with lending loans.

·         Reviewed and synthesized large amounts of financial data from Core Banking and Financial Banking System Applications to produce reports for management and decision-makers.

·         Performed data extraction and manipulation using Microsoft SQL Server Management Studio 2005/2008 and Microsoft Excel to create and manipulate spreadsheets with intensive use of financial and statistical functions, v-look-up, pivot tables, charts and graphing.

·         Performed a lead role in the re-engineering of SQL Server 2008 OLTP/OLAP operations into Microsoft Access with use of linked tables, complex queries, and macros in implementing database tasks automation; importing and exporting data, and using various tools to manipulate and present data in a comprehensible format.

·         Used MS Expression Builder and functions such as string functions, mathematical functions, date functions, logical functions, aggregate and group by functions to extract and manipulate data.

·         Created new MS Access databases and also made major modifications to the existing databases and database's user interface forms and corrected data integrity and constraints issues.

EDUCATION AND TRAINING

·         Aug 2014: MSc in Information Technology; Data Mining/Machine Learning, Data Warehouse and Database Systems Technology Specialization; University of Maryland University College, Adelphi, Maryland.

·         Dec 2014: Graduate Certificate Program in Data Analytics and Database Systems Technology, University of Maryland University College (UMUC), Adelphi, Maryland.

·         Aug 2004: Bachelor of Science Honors in Accounting, Minors in Business, Mathematics and Computer Science, University of Buea, Cameroon

·         2010 to Present: Data Science, Big Data Analytics, Hadoop & Spark online training; Coursera.org, edX.org, tutorialspoint.com, BigDataUniversity.com, datasciencecentral.com, Databricks MOOCs, IBM BigInsights (Big SQL, BigSheets, Big R, and Text Analytics), GitHUB, Pluralsight.

Additional Training:

·         Succeeded in Praxis I Mathematics and Praxis II – Content Knowledge Advanced Mathematics for Maryland/Virginia/Washington DC Certification.