Resume

Sign in

Data Sql Server

Location:
Silver Spring, Maryland, United States
Posted:
October 30, 2016

Contact this candidate

Resume:

REMENSMOS MBAH (REMS)

Email: acxa71@r.postjobfree.com Preferred locations: MD, DC, and Northern VA

Corporate IT Professional with 12+ Years of Industry Experience

PROFILE

A 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 Massively Parallel Processing (MPP), data integration/migration and storage, data warehousing, real-time data analytics and reporting. With sound business and technical acumen is able to research, explore and leverage Big Data technologies (HDFS, Apache Hadoop/Spark/Storm, 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

Expertise in developing OLTP, OLAP, and Data Warehouse systems (using 3NF, Multidimensional Star and Snowflake schemas designs), NoSQL databases, MDM and Data Governance solutions, Data/Text Mining, statistical data analysis, historical and predictive Data Analytics Solutions.

Extensive hands on experience in IT Governance frameworks, concepts, methodologies and modeling techniques including Cloud and Virtualization technologies.

Have hands-on experience in big data processing with Hadoop/Storm and Spark, loading data using Flume and Sqoop, analyzing big data using python, Pig, Impala/Hive SQL editor in Hue, implementing Big Data solutions using HDInsight/BigInsights, Cloudera-CDH, AWS, Google cloud.

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 restrospective).

Significant training and experience in project management, unit/functional and system testing, SharePoint/TFS, Microsoft Azure and IBM BigInsights/AWS Big Data cloud solutions.

Have demonstrated strong troubleshooting, problem solving, leadership and team work skills as well as the ability to accomplish tasks under minimal directions and supervision.

Have strong communication and presentation skills, with experience in translating complex business requirements into detailed functional and/or technical specifications, developing alternative data solutions/strategies to complex problems and recommending the best solution/strategy to the business process and project team.

TECHNICAL SKILLS

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

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

Cloud Platform VMware, AWS, Salesforce, IBM, Cloudera, Microsoft Azure.

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

Programming Languages SQL, Hive, Pig, R, Python, JSON, Avro, XML, MapReduce, YARN, Kafka.

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

ETL Tools SSIS, SQL Loader, Informatica Power Center, Pentaho, Sqoop, Flume.

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

BI Tools/Data Analysis Tableau, Excel, Power BI, SSIS, SSAS & SSRS, SAS, B.O, Google Analytics,

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

Requirements/Process Mgt IBM Rational DOORS, SIX SIGMA, Team Foundation Server online/desktop.

EDUCATION AND TRAINING

Aug 2014: MSc in Information Technology; Data Mining/ML, 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, IBM BigInsights (Big SQL, BigSheets, Big R, and Text Analytics), Github, Pluralsight.

PROFESSIONAL EXPERIENCE

BD Becton Dickinson & Company, Reston VA May 2016 – Present

Big Data Engineer

Responsibilities

Use Microsoft's cloud platform and Agile/SRUM methodology to leverage the power of data collection and migration/integration, data streaming and real-time big data analytics on data from a broad range of devices/web applications; analyze and integrate data streams in-motion with back-office systems, use cloud based Hadoop solution (HDInsight) for batch processing, and develop machine-learning solutions by integrating code from R and Python directly into cloud based Azure Machine Learning (AML) studio.

Develop data architectures and data models/schemas for complex, highly visible business initiatives/enterprise projects and also provide consulting support in cloud data management to project teams to support Mobile solutions and Clinical Workflow Applications.

Manage JSON/XML/CSV data flow/transfer in a cloud based SQLDB and NoSQL DocumentDB, and across MangoDB, Hadoop, Oracle 11g, and SQL Server2012 to perform real time data analytics with Azure IoT Suite, Power BI, and stream analytics solutions.

Use 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.

Provide guidance and support in developing KPIs, data quality metrics, and metadata capture including evaluating alternative strategies for transactional and analytical systems to effectively share data between legacy data sources and cloud based enterprise relational/nonrelation systems.

AMTRAK (National Railroad Passenger Corporation), Washington DC Jan 2016 – April 2016

Sr. Data Architect/BI Developer

Responsibilities

Implemented Amazon AWS (Amazon EC2, Amazon Redshift, and Amazon cloud front) in performing data migration and integration, writing complex SQL queries, analytical and aggregate functions to understand the current state of Amtrak data assets and how those data assets can be leveraged to provide enhanced near real time decision making.

Performed data extraction and migration, data cleaning, analysis, and visualization using SSIS, SSAS, Tableau, and Power BI to support OneCloud Data warehousing solution on AWS.

Performed data streaming into HDFS from AWS and Arrow web servers using Flume and R.

Used Spark and sqoop as the main Hadoop ETL tools for both batch and streaming data processing to extract, transform and load data coming from many heterogeneous into the integrated SQL Server 2012 operational data store and enterprise data warehouse solution.

Prototyped BI solutions using Tableau desktop 9.1 and Business Objects 4.0 and lead the BI product design and the development of data models, testing, and integration of Sales ODS.

Developed reports using Tableau and materialized/updatable views for real-time data analytics.

Played a leading role in modeling and constructing of data architecture for operational data stores, data marts and enterprise data warehouse with DB2, SQL server 2012 and Oracle 11g.

Kaiser Permanente, Silver Spring MD Sept 2015 – Dec 2015

Sr. Data Architect & Data Analytics Lead

Responsibilities

Lead Architect to evaluate, restructure/upgrade and provide resolutions for information systems applications and in applying a variety of analytical functions in claims administration and reporting including making recommendations to enhance data quality and the cloud data warehouse solution.

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

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

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 the EDW.

ASAP Services Corporation, Washington DC Jun 2015 – Aug 2015

Data Architect/Tableau Developer

Responsibilities

Implemented MDM solutions using MS Data Quality Services and Master Data Services.

Developed data models for SQL Server 2012, and Access 2013 databases; gathered and analyzed requirements, normalized data entities and defined their relationships using ERwin data model and the star schema approach.

Created OLAP 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 2012, and transformed/loaded the data into Netezza using SSIS.

Worked with Tableau Desktop/Server to develop Dashboard and scorecard reports on KPIs to help top management in strategic planning and quick decision making 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 to retrieve data into Tableau from SQL Server 2012, Oracle 11g, Netezza, MySQL and other external sources.

Capital Care Inc., Silver Spring, MD May 2011 – May 2015

Data Modeler/Data Analyst

Responsibilities

Deployed intensive use of ERwin data modeler in the creation of conceptual, logical, and physical data models, database schemas for both operational databases and Data Warehouse systems running on Oracle 11g and SQL Server 2012; partnered with business analysts, business users and other stakeholders to define, capture, and communicate requirements.

Designing, developing, automating & optimizing ETL processes on the source DB2, Oracle, SQL Server environments for enterprise data warehouse.

Performed data mapping tasks, data profiling, data cleansing, data validation and quality assurance, including intensive data migration and the creating, executing, and documenting of test cases in SSIS and Informatica power center ETL processes to bring data from diverse sources .

Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.

Extracted data from the databases (Oracle 11g, SQL Server 2012, and DB2) using Informatica to load it into a single data warehouse repository and developed many stored procedures to manage different aspects of the company’s database and data warehouse systems.

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.

Created reports and dashboards using structured and unstructured data.

Community Credit Company (CCC Bank), Yaoundé Dec 2005 – Aug 2010

Financial/Data Analyst

Responsibilities

•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.

•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.

Additional Training:

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



Contact this candidate