Solomon Mulualem, PMP, ITIL

Experience

• 

  IBM

  Apr 2002 - May 2007

  Advisory Technical Specialist - BI/ETL Developer

  • Collected Requirements, Designed, Developed, Implemented and Supported BI Projects.• Designed, Developed and Deployed Complex Reports (On demand, AdHoc, Frequency, Summary, Drill-down, Cross-Tab, Graphical Reports) using Actuate, Crystal Report, C. Enterprise XI/10.0/9.0/8.5• Scheduled Actuate reports on Mainframe: IBM Tivoli Workload Scheduler• Developed Stored Procedures, Triggers and Views using DB2 SQL• Developed, Implemented and Supported ETL Process.• Designed, Developed and Implemented Exceptional Reports using SQL Script and Crystal Report (from Multiple Datasources) • Designed and Developed BI Report Job Monitoring Program using VB• Used Various Tools to Access, Update or Analyze Database.• Analyzed Requirements and Created High Level Design Document.• Coordinated Changes and Releases to Implement Web-based Reports.Use of Time: 70% Project (Design, Development, Implementation); 30% Operational Show less

• 

  CIBC

  Aug 2007 - Mar 2015

  Technical Consultant - SAS/Cognos/Actuate/Informatica/SQLBI

  SAS• Upgraded SAS Platform on Unix/Windows Environment• Installed, Configured SAS Activity-Based Management and Information Map Studio on Multiple Servers – Metadata, OLAP, Calculation and Mid-Tier • Installed and Supported SAS Clients (SAS EG, SAS EM, SAS DI Studio, SAS ABM)• Performed SAS Metadata and Unix Promotion Between Environments• Wrote Unix Script and Automated Unix Portion of SAS Promotion.• Created and Supported AutoSys and Tidal ETL Report Scheduling Jobs • Configured/Scripted HP Openview, SiteScope, AutoSys to Monitor Servers Cognos• Installed, Configured and Supported Congos Suite in Cluster Environment• Designed and Developed Metadata/OLAP Models using Framework Manager and Cognos Transformer• Used and Supported various Cognos BI Tools - Framework Manager, Report Studio, Cognos Connection, Metric Studio, Query Studio, and Event Studio, Report Net, Impromptu, Powerplay Transformer; Impromptu Web Reports (IWR), Access Manager, Cognos TM1, etc• Secure the Environment and Performed Disaster Recovery (DR) Procedures• Upgraded Cognos and Decommissioned older Environment.Informatica • Installed/Upgraded Informatica Power Center in UNIX Environment• Performed Code promotion Export/Import, Direct/Folder Promotion• Provided Support - User/Folder Creation, Configuring DB Connections, etc • Configured HP-OVPA Metrics to Monitor Memory/CPU Usage of Applications/LOBs (In the Shared Environment)• Supported Production Batch jobs 24x7 during weekly on-call rotations.Actuate (OpenText)• Installed, Configured Actuate iServer and created Active/Fail-Over Cluster• Deployed Actuate Reports and JAR files DEV/UAT/PROD• Maintained License and Performed DR Test• Trained Team Members to Support Actuate Environment. Show less

• 

  Canadian Tire Corporation

  May 2015 - Oct 2016

  Sr SAS Administrator / Hadoop Administrator

  • Installed, Configured SAS Platform v9.4 on Linux RHEL - Three Servers Tiers Environment (Metadata, Compute and Mid-Tier) • Installed and Configured SAS Visual Analytics and SAS Visual Statistics (Distributed Mode/Multi-node) on Linux SUSE (on Teradata 720 Appliance).• Installed and Supported SAS Enterprise Miner and SAS Enterprise Guide • Configured Kerberos Authentication with Centrify-Active Directory Integration.• Installed and Configured Hortonworks HDP Cluster in Lab Environment.• Acquired Experience in Hortonworks Hadoop (HDP) Installation and Administration• Secured Metadata and Created Data Sources, Libraries, Users/User Groups• Configured SAS Environment Manager and Monitor/Audit Resource Usage.• Applied Patches/Fixes, Renewed Licenses and Performed Backups• Coordinated with SAS, Hortonworks, Teradata Vendors and resolved SAS-VA/Hadoop Connectivity and Performance issues. • Prepared Build Document, SAS User Guide and Access Request Form. Show less

• 

  TD

  Nov 2016 - Feb 2017

  IT Support Analyst IV - SAS/ETL Developer

  • Provided day-to-day Support for DB2 Data Warehouse/SAS Grid Applications• Used SAS/Macro, DB2 SQL, JCL Unix Scripts to Load DB2 Tables• Executed and Tested Standard Code and Reference Table Updates • Created SAS View/Table from UDB query (using SAS Macro)• Loaded DB2 tables using PROC SQL/Data Step (SAS Macro) from SAS EG• Updated and Tested SAS Data load Macro with Binary/Char Compression • Monitored Mainframe Batch Jobs using CA7 Scheduler• Access Provisioning to Enterprise Data Warehouse and SAS Grid System• Provided Support for SAS and Data Questions from Business Analysts Show less

• 

  Canadian Tire Corporation

  Apr 2017 - Nov 2017

  Senior SAS Administrator - Consultant

  • Supported SAS Visual Analytics Environment Cluster (Metadata, Compute and Mid-Tier) • Secured Metadata and Created Data Sources, Libraries, Users/User Groups• Created Production Test Server (SandBox) using VirtualBox and Vagrant• Tested KNIME (Integration/Analytics Tool) in Hadoop ecosystem• Created/Tested Data Mining and Predictive Models using KNIME• Applied Patches/Fixes and Renewed License on Servers• Onboard New SAS EM / EG Users and Provided help on SAS Issues• Installed and Configured Open Source Reporting/Analytics Software on Linux VM• Acquired Experience in Hortonworks Hadoop (HDP) Administration Show less

• 

  Walmart Canada

  Aug 2017 - Aug 2017

  SAS Consultant (Part-time/Contract)

  • Installed, Configured and Tested SAS 9.4_M4 on a new Server and Migrated Metadata and SAS Datasets from SAS 9.2.• Installed and Configured SAS Enterprise Miner 14.2 and SAS EG 7.13

• 

  CGI

  Dec 2017 - Aug 2018

  Senior Technical Consultant (SAS)

  • Helped Stabilize SAS Grid Environment (Metadata, Compute and Mid-Tier)• Created/Scheduled SAS Flows/Jobs using Platform Editor/Manager• Automated Critical ETL/Report Job Monitoring using Linux Script and Cron• Developed Job Flow Status Report using SAS code and Teradata• Configured and Connected SAS to Cloudera Hadoop (CDH) • Provided SAS Admin Training to Offshore team as part of KT Initiative• Led/Performed Regular Incident and Problem Management Activities • Participated in Tech Governance, Incident, Change Management Sessions• Prepared Operational Documents/Runbooks and Performed Webinars Show less

• 

  Manulife

  Sept 2018 - now

  Data Operations Analyst

  • Implemented and Managed Advanced Analytics Tools: SAS, Neo4j, RStudio/Posit Connect, Python, JupyterHub, MATLAB• Migrated Neo4j and Posit Connect Configuration, Database and Artifacts from RHEL-7 to RHEL-8 VMs• Installed R Packages from CRAN, Configured Posit Connect and sync Packages from Package Manager and Repository/Artifactory.• Implemented Neo4j Graph Database on Azure using Helm Charts and Administered the DBMS• Configured AD/LDAP Authentication, On-boarded Users and Assigned Roles, etc.• Supported EDL Platform in Hadoop Ecosystem and Toolset: NIFI, Kafka, Spark, HDFS, Hive, Oozie, HBase, Atlas, Atscale, Sqoop etc. • Support Azure Cloud ,Data Analytics and Cloud Technologies: Azure Synapse, ADF, AKS, Azure Storage, Azure Purview and Databricks• Implement/Maintain SAS 9.4 Global Three Tier Environments (Metadata, Compute and Mid-Tier) and Upgraded SAS 9.4_M2 to SAS 9.4_M6 on RHEL• Installed, Configured and Supported Monitoring Tools: New Relic, Kibana, Devo, Grafana, Ambari, etc• Support SAS Studio, Enterprise Guide, Enterprise Miner, SAS Access Interface to Hadoop/ODBC/SQL Server• Coordinate with SAS, POSIT, Microsoft, Cloudera, Neo4j and MATLAB Vendors to work on Issues/Licensing • Automated Kafka Rolling Restart and Disaster Recovery process using REST API and implemented Automated SSL CERT Update.• Responsible for Applying Patches, Hotfix, Software Upgrades and Maintain Licenses and Certificates.• Lead and Coordinate Various Advanced Analytics Tools implementation and Annual DR Projects.• Work with Data Scientists/Engineers/Business Users and Handle Incidents, Changes, Requests, etc• Prepare Software Utilization and Chargebacks to Allocate Cost to Business Units• Prepare Installation/Upgrade Documents, Runbooks, SRD, etcTechnical Environment: Hadoop Stack, Azure Cloud, AKS, SAS Cluster, Neo4j, RStudio/POSIT, Python, JupyterHub, VS Code, Github Copilot, Terraform, Helm Chart, Azure CLI, Jenkins Show less