SUMMARY:

• I am a highly organized, articulate and detail - oriented IT professional with hands-on Data collection, processing, analyses, visualization, Business Intelligence and Data warehouse skill set.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Business Intelligence Developer

Responsibilities:

• I took on the responsibility of automating the scorecard processes for delivery Associates
• I created a data pipeline which ingest route data, mentor data and DA’s attendance by creating a glue workflow leveraging CloudWatch, lambda and SNS
• Created an S3 datalake with fine grain access using lake formation which can also be queried using Athena and Redshift spectrum.
• I use AWS Glue to crawl files and create an ETL Job using Pyspark.
• I used EMR for batch data ETL while leveraging spark, hive, presto, pig ganglia etc. on the Hadoop framework by submitting jobs using steps in the EMR cluster.
• I Used amazon QuickSight and Tableau data visualization and dashboard to get pictorial insight into driver’s driving behavior.
• Created an S3 data lake, set up permissions using lake formation and query by data using Athena.
• Created a data warehouse model using Erwin Modeler
• Spinned up and managed a redshift cluster used to store historical.

Customer Representative

Confidential, Dallas, TX

Responsibilities:

• Assist customers to troubleshoot when trying to use the Confidential app.
• Supported and assisted customers with their orders.
• Inputs and processes orders received into the company computer system at an exceptional pace.
• Researches and responds to questions concerning concerts and events.
• Provides information about upcoming events, specials and concerts

Data Warehouse and Business Intelligence Developer

Confidential, Lagos, Nigeria

Responsibilities:

• • Created a data pipeline workflow using OWB to extract customer’s one-time charges, Reoccurring charges, Discounts, Tax and Adjustments and send to the billing team for bill run
• • Monitoring change of service including telephone number change, Line suspension, revoke suspension, Package change and line termination by creating a real-time report of customer’s change of service behavior.
• • Ingest, transform and load Data from application databases using OWB to create a 360-degree customer base segmentation by demographics for visualization report using OBIE to show churn rate behavior which helps marketing team to create products that attract customers and reduce churn rate
• • Partner with the sales and marketing team to design solutions to attract new customers which then drive up revenue by %11
• • Part of a team involved in data migration from SIEBEL customer relation management (CRM) and Single view (Billing system) to Agility CRM and Convergent billing application
• • Improved the billing process by cutting down the bill run process from 2 days to 6 hours
• • Analyzed usage trends and performed behavior analysis after data extraction from CRM and CDR using OWB to identify patterns, build visualizations using OBIE to tell a story which helped Marketing department to introduce accurate rental plans.
• • I analyzed customer data and built a customer segmentation report to segment customers into Platinum, Gold and silver segments based on their usage, which helped sales team pay a little more attention to more revenue generating customers.
• • Pioneered the development of automated reporting dashboards in Tableau to monitor the Key Performance Metrics providing visibility to higher management and improving operational efficiency.

Data Warehouse and BI Developer Consultant

Confidential, Lagos, Nigeria

Responsibilities:

• In a team that manages a data warehouse of the biggest telecom company in Africa (MTN).
• Performed data warehouse design and modeling using Erwin Data Modeler to create a BI-CRM stream which helped the company to better understand its customers.
• Part of a team that migrated over 300 existing reports to the BI-CRM stream in 4 phases using SAP BO.
• Worked with marketing team by providing dashboard which helped them implement strategies that resulted in 12% growth of customer base.
• Coordinated with Business users (Marketing, Sales, CR teams) to best understand what data/report they need to help drive their goals and decision making
• Trained Marketing business users on how to use and customize their reports using SAP BO.
• Part of a team that secured a multi-million dollars project called BI Next wave
• Developed an automated process for continuous monitoring and optimization of SQL query.
• Ensure the data quality and integrity in by continuously performing ETL batch jobs using OWB
• Developed best practices for Datawarehouse design and development activities by continuously researching the best practices.

SQL SERVER DEVELOPER

Confidential, Lagos, Nigeria

Responsibilities:

• Improved data capturing and processing to capture information from forms filled by pension account holder by remodeling the OCR database
• Reduced the number of days to generate pencom pin from 2 days to less than 1 hour by automating the SQL scripts processes.
• Ensured data integrity and accuracy by transforming dirty data to a more valuable data
• Took over and supported the OCR application (ABBY) which helped the company to save over 12million naira ($33,300) for annual support contract.
• Provided scheduled and ad hoc reports to senior team members.
• Writing new and testing exiting TSQL queries and packages.
• TSQL performance tuning.
• Importing and exporting data to and from flat files such as cvs and xls.

TECHNICAL SKILLS:

• Project management & Team Motivation, Project Budgeting
• Team leadership/Security Awareness.
• AWS (EC2, EBS, S3, Redshift, IAM, AMI, ELB, SNS, Athena, Redshift Spectrum
• NACL, Security Groups, Route53, VPC, VPC Peering, Auto Scaling, CloudWatch
• AWS Glue, Development Endpoint, EMR, EMR Notebook, Kinesis, Lambda, CloudFormation
• Apache Spark, Hive, Hue, Zeppelin notebook.
• SQL, PLSQL, TSQL, HiveQL, SparkSQL, Pyspark, RDS.
• Prioritizing/Multi - Tasking
• Data Warehousing, BI, SAP BO, OWB, OBIE, Tableau, Data Analysis
• A Process Improvement, Automated/Manual Testing
• Streamlining Efforts, Product Development