EDWARD SUMAILA
Columbus
Summary
Industrious Business Analyst with successful history developing Business intelligence to improve business operational planning and implementation. Exceptional at applying vast knowledge of business best practices, regulatory standards and optimal control systems to support growth and success. Reliable quantitative analyst with accuracy and efficiency in comprehension of company metrics.
Renowned Business Analyst bringing exceptional abilities in competitor analysis, business intelligence development, and performance trend assessment. Consistent at reaching revenue targets through leveraging BI data and production of well-executed recommendations. Providing solutions to professional challenges utilizing interpersonal skills, excellent time management, and problem-solving skills.
Overview
13
13
years of professional experience
1
1
Certification
Work History
AWS Certified Solutions Architect
Liberty Mutual (Contractor: Cloudtitians)
Boston, MA
11.2018 - Current
- 5+ years of broad technology experience and knowledge across multiple disciplines such as database, security, ETL, and rule engines
- Top-tier professional with the ability to make architecture and design decisions and tradeoffs for solution architecture that looks across the applications landscape and adheres to enterprise standards.
- Participated in continuous improvement by generating suggestions, and engaging in problem-solving activities to support teamwork.
- Proved successful working within tight deadlines and a fast-paced atmosphere.
- 5+ years of AWS Cloud experience working with various AWS services such as EC2, ELB, ASG, EKS, EMR, Lambda, API Gateway, Route53, S3, RDS, Aurora, ElastiCache, SNS and SQS.
- 5+ years of large-scale digital transformation & AWS Cloud migration hands on experience with multiple technology areas like API Platform, Microservices, Event Streaming, Logging & Monitoring, Databases (SQL & NOSQL), Containers, Serverless Frameworks, AI & ML etc., Kafka, AMQ
- 5+ years of hands-on experience in solution, data, and architecture applied to multiple large-scale enterprise systems
5+ years' extensive knowledge and experience in the Databases - SQL and NoSQL (DB2, Oracle, Sybase, Postgres, MySQL, MongoDB, DynamoDB). - 5+ years experience in various technologies like Web Services, API, Integration/EAI technologies like Informatica, XML, JSON
Saved $750K by implementing cost-saving initiatives that addressed long-standing problems. Drove operational improvements which resulted in savings and improved profit margins. - Learned new skills and applied to daily tasks to improve efficiency and productivity. Increased customer satisfaction by resolving issues.
Business Intelligence Data Analyst
Kmart Pharmacy (Contractor: Swiftlearn IT Solution
Sebring
05.2018 - Current
- Developed wireframes, site maps, and content inventories for new website designs.
- Wrote queries to fetch data from different tables using JOINs, Sub-queries, Correlated sub-queries, and derived tables on Teradata platform
- Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
- Connected Tableau server to publish dashboard to a central location for portal integration.
- Collaborated with product development and Finance departments to respond to questions and concerns regarding project details.
- Developed complex PROC SQL queries within SAS environment using advanced SQL concepts like aggregate functions, Group By, string Functions
- Researched and resolved issues regarding the integrity of data flow into relational and operational databases.
- Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results.
- Structured the dashboard with a consistent layout with visuals chart at the top and corresponding cross-tabs data and the bottom.
- Created visualization for logistics calculation and department spending analysis.
- Responsible for interaction with business stakeholders, gathering requirements, and managing the delivery.
- Developed prescription and usage reports in tableau for the pharmacy unit.
- Incorporated pharmacy best practice in developing analytics applications for the pharmacy unit
Tableau Developer /Business Data Analyst
Suncoast Credit Union (Contractor: Swiftlearn IT
Tampa
06.2017 - 11.2021
- Experienced delivering more IAM implementations as a Business Analyst/Data Analyst. Solid understanding of Identity Governance and Administration ("IGA") concepts, such as Access Lifecycle Management, Access Request Management, Access Fulfillment, Password Management, and Privileged Access Management.
- Good grasp of operational, regulatory, and other risks related to the area of IAM. Advanced analytical skills, specifically data analysis. Good written and verbal communication skills, presentation, and interpersonal skills.
- Optimized system and platform performance capabilities in the most efficient, practical way possible.
- Mapped process activities to identify shortfalls and propose options to rectify operational inefficiencies.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Worked closely with all product development departments to create and maintain marketing materials for sales presentations and client meetings.
- Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance, and functionality.
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
- Achieved 98% success in automation by analyzing claim operations, data and system issues to identify discrepancies for troubleshooting and corrective action.
Education
Master of Arts - Actuarial Science And Statistics (Dual)
Ball State University
Muncie, IN05.2017
Master of Science - Petroleum, Energy Economics And Finance
University of Aberdeen
Aberdeen, Scotland - UK11.2015
Bachelor of Science - Actuarial Science
• University For Development Studies
Navrongo, Ghana11.2010
Skills
Hands-on experience in SAS programming for extracting data from Flat files, Excel spreadsheets, and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility
- Business process mapping, data collection, and analysis, Predictive Modeling, and Workflow Analysis
- Software development, cloud computing, systems engineering, infrastructure, security, networking, data & analytics, Oracle, Microsoft SQL Server, PostgreSQL, or MySQL
- critical thinking, problem-solving skills, presentation, oral, and written communication skills, and confidence through competence
- ETL/Other Tools: SAS Base 9 x, SAS Enterprise Guide, SSIS, Erwin Data Modeler
- Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL Developer, Toad
- Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix
Strong ability to write SQL queries using PROC SQL
- Business Intelligence Tools: Tableau 92, 93, 104, Excel and Power BI, SSRS, MicroStrategy
- Querying language: SQL, PL/SQL, TSQL
- Databases: MS SQL Server 2008/2012, MySQL 52, 57, Oracle 10g, 11g, 12c, DB2, SAS
- Relationship development, Problem resolution, Supervision, Process improvement, Communications, Project organization, Business Development, Operational improvement
Certification
AWS Certified Solutions Architect - Associate (SAA) - June 2022.
CompTIA Security+ Certified - May, 2022
SOA Exams P- Probability - May 2017
Property Insurance License - November 2017
Causality Insurance License - November 2017
Life Insurance License - November 2017
Accident and Health Insurance License - November 2017
Timeline
AWS Certified Solutions Architect
Liberty Mutual (Contractor: Cloudtitians)
11.2018 - Current
Business Intelligence Data Analyst
Kmart Pharmacy (Contractor: Swiftlearn IT Solution
05.2018 - Current
Tableau Developer /Business Data Analyst
Suncoast Credit Union (Contractor: Swiftlearn IT
06.2017 - 11.2021
Master of Arts - Actuarial Science And Statistics (Dual)
Ball State University
Master of Science - Petroleum, Energy Economics And Finance
University of Aberdeen
Bachelor of Science - Actuarial Science
• University For Development Studies
AWS Certified Solutions Architect - Associate (SAA) - June 2022.
CompTIA Security+ Certified - May, 2022
SOA Exams P- Probability - May 2017
Property Insurance License - November 2017
Causality Insurance License - November 2017
Life Insurance License - November 2017
Accident and Health Insurance License - November 2017
Similar Profiles
Dethera McGeeDethera McGee
Customer Service Representative at Liberty Mutual/AdeccoCustomer Service Representative at Liberty Mutual/Adecco
Simone ButlerSimone Butler
Auto Claims Adjuster at LIBERTY MUTUAL INSURANCE COMPANYAuto Claims Adjuster at LIBERTY MUTUAL INSURANCE COMPANY
Sherrelle WilliamsonSherrelle Williamson
Sr. Salvage Assistant -Personal Lines at Liberty Mutual InsuranceSr. Salvage Assistant -Personal Lines at Liberty Mutual Insurance