Data Entry Analytics

Afroz Mohammed

**** ******* **** *********, ** L*X 2B7 647-***-**** ***********@*****.***

Objective

To utilize knowledge of project planning theory in conjunction with electrical engineering theory. Furthermore, to advance my skillset to fulfill company objectives and to achieve professional goals. Seeking a challenging and fulfilling role to broaden my horizon and to excel within the organization. NOTE: Canadian Citizen

Skills Summary

Technical Skills Soft Skills

● Expert knowledge of Informatica 10.

● Comprehensive knowledge of Microsoft

Office.

● Knowledge of programming languages such

as C++, Python, MATLAB Scripting, R

Studio and NumPy.

● Knowledge of data mining, machine learning,

data analytics and signal processing.

● Proficient at writing technical reports.

● In depth knowledge of SQL+ and Tableau.

● Proven success in managing project scopes,

schedules, reports and other technical

deliverables throughout all the phases of the

project development lifecycle.

● Exceptional time management and

communication skills.

● Able to perform well under pressure.

● Detail oriented and meticulously follows

procedures.

● Internal and external collaboration.

Certifications

Data Analytics and Decision Making Graduate Certificate April 2020 Durham College, Oshawa, ON

Professional Experience

Senior System Analyst (Production) May 2022 - Present CIBC (Toronto)

Highly skilled and analytical Senior Informatica ETL Analyst with extensive experience in the design, development, performance tuning, and maintenance of complex ETL processes using Informatica PowerCenter. Adept at optimizing SQL queries and ensuring data integrity for robust data warehousing and business intelligence solutions. Demonstrated expertise in production issue resolution, root cause analysis, and proactive monitoring utilizing Broadcom AutoSys, Splunk, Grafana, Dynatrace, and ALM. Contributes to best practices, automation via Jenkins, and fosters collaborative teamwork to deliver high-quality data solutions.

● Lead the design and development of ETL solutions using Informatica PowerCenter, optimizing SQL queries for seamless data flow.

● Ensure data quality and consistency through continuous refinement of data rules.

● Provide expert production support, actively monitoring ETL jobs, and performing root cause analysis with tools like Splunk, Grafana, and Dynatrace.

● Collaborate closely with cross-functional teams to align data solutions with business objectives.

● Conduct performance tuning of Informatica mappings and database queries for enhanced scalability.

● Maintain comprehensive documentation and mentor junior team members, fostering knowledge sharing.

● Manage and track production defects using ALM, ensuring timely resolution.

● Implement automation enhancements for ETL job scheduling and monitoring, leveraging Broadcom AutoSys and Jenkins.

● Contribute to strategic ETL design and data warehousing initiatives, supporting business intelligence and analytics.

● Drive process improvement and best practices for ETL development, aiming for greater efficiency.

● Participate in on-call rotations to ensure continuous critical production support.

● Engage in continuous learning to integrate emerging technologies and deliver ongoing value. Data Analyst,February 2016 – April 2022

IQ Network (Toronto)

● Automated ETL processes across billions of rows of data which reduced manual workload by 33% monthly.

● Built data visualizations using SQL and Tableau for business KPIs that reduced manual reporting work by 8 hours weekly.

● Led a team of one full-time employee and three contractors

● Built out the data and reporting infrastructure from the ground up using

● Tableau and SQL to provide real-time insights into the product, marketing funnels, and business KPIs.

● Built data visualizations using SQL and Tableau for business KPIs that reduced manual reporting work by 8 hours weekly.

● Worked with product managers to perform cohort analysis that identified an opportunity to reduce pricing by 25% for a segment of users to boost yearly revenue by $720,000.

● Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

● Built operational reporting in Tableau to find areas of improvement for contractors resulting in

$210,000 in annual incremental revenue.

● Acquire data from primary or secondary data sources and maintain databases/data systems. Identify, analyze, and interpret trends or patterns in complex data sets.

● Designed and implemented A/B experiments for our product to improve the conversion rate by 18 basis points and reduce churn by 11 basis points.

● Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels, and business KPIs.

● Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.

Data Engineer,2011 – 2016

IQ Network

● Developed tools to provide real-time data around international currency exchange, reducing latency by 12%.

● Automated ETL processes across billions of rows of data which reduced manual workload by 33% monthly.

● Ingested data from disparate data sources using a combination of SQL, Google Analytics API, and Salesforce API using Python to create data views to be used in BI tools like Tableau. Network Operation Engineer,2007 – 2010

DU Telecom

● Provided technical input in reviewing architecture, policies and procedures to ensure that security, backup, failover, alerting and disaster recovery mechanisms were in place.

● Ensured production environments and data centers were equipped with the proper level of resources to scale per business needs.

● Participated in and reviewed resting procedures for change and configuration management in production environments.

● Provided technical input in reviewing architecture, policies and procedures to ensure that security, backup, failover, alerting and disaster recovery mechanisms were in place.

● Acted as an escalation point between support team and engineering to help identify and troubleshoot service problems.

● Implemented regular alerting and monitoring of network performance which reduced network down-time by 11% through quicker response times.

● Deployed on premises platforms Arista and Fortinet for 110 client accounts. Education

Masters of Business Administration (MBA)April 2006 Osmania University, Hyderabad, India

Bachelor in Computer Application (BCA), April 2004 Osmania University, Hyderabad, India

Contact this candidate