| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
PHONE NUMBER AVAILABLE | EMAIL AVAILABLE | LINKEDIN LINK AVAILABLEHighly analytical and detail-oriented Senior Data Analyst with 13 years of experience in Data Analytics, Business Intelligence and Reporting. Proven track of record in analyzing data, identifying trends, patterns and correlations. Generating insights, providing recommendations and presenting findings to both technical and non-technical stakeholders.Skills Summary: Extensive experience in Data Analysis, Audit, Quality Control/Assurance, Reporting and Visualization Fraud and Risk Management Analysis (Early Detection, Mitigation and Prevention). MS Excel (Dashboard, Pivot table, graphs, charts, trend analysis, Macros, VLOOKUP, HLOOKUP, XLOOKUP) T-SQL (Joins, CTEs, Window functions, User functions, stored procedures, triggers, tables, views, jobs, alerts) Power BI, Tableau (Reports, Dashboards, Visualization, Analysis, DAX (functions, measures))
Python (coding, NumPy, Pandas, Matplotlib) Databases Manipulation through Python (MySQL, PostgreSQL, NoSQL, PL/SQL) Cloud computing (AWS, Azure, GCP (Google BigQuery), Snowflake) Generative AI Prompting: ChatGPT, DALL-E, GPT-4Professional Experience:CVS Health, Woonsocket, RI |August 2022 to July 2024Marketing Data Analyst (Contract) Developed SQL queries (CTEs, Joins, Sub-queries) to extract and manipulate data from OLTP RDBMS. Used Python libraries such as Pandas and NumPy to extract, clean, and analyze data. Executed complex SQL queries in Snowflake to extract, transform, and analyze large datasets. Built, designed and maintained an OLAP Data Warehouse for analytics and reporting purposes. Developed ETL process for data ingestion in the Data Warehouse. Worked closely with the team to define metrics and KPIs for performance tracking. Lead data analysis projects to assess Marketing campaign/offer performances. Developed interactive dashboards to Identify, analyze and visualize trends/patterns of campaigns in Power BI. Automated reports and dashboards with Power BI (ETL, Data modeling, Reporting, DAX, Measures) Performed and led Data reconciliation and gap analysis from various sources to improve data accuracy. Collaborated with cross-functional teams to create AI-driven visualizations, enhancing data presentation.Mattress Firm, Houston, TX |January 2021 to July 2022Master Data Analyst | Pricing Analyst (Contract) Mapped and transformed large datasets to load in the ERP system and ensured 100% accuracy. Documented data transformations and relationships between source and target data systems. Developed SQL queries (CTEs, Joins, Sub-queries) to extract and manipulate data from the ERP System. Extracted, cleaned, and analyzed data using Python libraries such as Pandas and NumPy. Conducted ad-hoc analysis and generated actionable insights to drive decision-making processes.
Automated reports and dashboards with Tableau.Medline Industries, Katy, TX |January 2019 to January 2021Business Intelligence Analyst | Power BI Developer (Contract) Connected and imported data from SQL Database or Cloud (Redshift, Azure SQL) to Power BI. Created data models using Power Query, defined relationships between tables. Transformed / Cleaned data and wrote measures and calculations using DAX for analysis. Designed interactive and visually appealing reports/dashboards. Published reports through Power BI Service. Automated data refresh processes to ensure data accuracy and reduced manual process by 80% Identified, analyzed, and interpreted trends/patterns and KPIs in complex Supply Chain data sets. Presented findings and insights to stakeholders, enabling informed decision-making. Implemented T-SQL codes to automate various tasks (scripts, stored procedures, user functions, CTEs, jobs).LSI Industries, Houston, TX |May 2017 to January 2019IT Support Technician (Contract) Served as a SPOC for IT and non-IT issues. Performed equipment installations. Performed Hardware and Software maintenance. Helped and assisted users on different issues. Maintain a high Service Level Agreement (Received a 4.7 point on every annual survey)Bharti Airtel, Libreville Gabon |January 2011 to November 2016Billing Systems Analyst | Fraud Management Analyst | Reporting Analyst (FTE) Collected and cleansed data from multiple sources, ensuring accuracy and reliability for analysis. Managed Fraud and Risk Analysis (Detection & Prevention) allowing the company to make $100Ks of saving. Designed Incident Reports with Root Cause Analysis and Financial Impact. Quality Assurance Testing. Developed and maintained interactive dashboards using (Excel dashboards and pivot tables, Charts). Data reconciliation and gap analysis from various sources, optimizing the data accuracy for decision making. Implemented T-SQL codes to automate various tasks (scripts, stored procedures, functions, jobs). Led the fraud management strategy (Analysis, Detection and Prevention using fraud management system). Developed reports on SSRS (multiple data sources connection, created expression and calculations, designed tabular and matrix reports) Developed ETL processes using SSIS (Source and destination connection, Package development and deployment, control flow and data flow tasks)Bharti Airtel, Libreville Gabon |September 2007 to January 2011NOC Engineer (FTE) Served as a SPOC for all network issues and support for customer service complaints. Conducted network supervision with OSS/BSS NAGIOS/ WINFIOL (Ericsson Technologies). Monitored all RBS alarms, network outage or equipment failure prevent, remote maintenance. Performed network performance analysis and monitoring the KPIs. Ensured 99.9% network availability. Served as 1ER line support operation. Performed network usage analysis. Maintained 0.01% network outage.Education and Certification Bachelor s Degree, Electronics and Computer Systems (2012) ITA Libreville - GABON Associates Degree, Networks and Systems Administration (2007) ESGIS Lom -TOGOLanguages:
English (Fluent), French (Native), Spanish (Basic) |
