Badges
Certifications
shaheryar_92 has not earned any certificates yet.
Work Experience
Data Conversion Analyst
Contour Pvt Ltd•  September 2020 - June 2021
- Managed and retrieve data from multiple sources by SQL, performed data cleansing and exploratory data analysis with python to obtain constructed dataset for reporting and modeling - Conducted statistical analysis and machine learning models using Python to identify key features, customer segmentation, consumer behavior, integrated reports into the recommendation tool - Perform Tableau & Python visualization and analysis to help stakeholders making data-driven decisions. - Develop/test/execute data conversion routines within an established conversion framework in a timely and accurate manner. - Identified issues, analyzed information and provided solutions to problems. - Convert data from multiple data sources into Microsoft SQL Server. - Create Complex T-SQL scripts with limited assistance - Write and maintain automation scripts. - Verify data integrity and identify data cleanliness issues. - Reconcile converted data to ensure accuracy.
Data Analyst
US Based Startup•  August 2019 - August 2020
- Automated internal and external reports in SQL, creating executive-level dashboards in Tableau, and presenting information to help executives and others understand the operational impact of the data. - Mechanized a report for the outreach group utilizing channels, boundaries, and determined sets that consequently qualified potential customers bringing about a lift in transformation pace of 27% - Applied forecasting models using Python to predict a trend in the monthly trading volume, directly contributing to the revenue - Built insightful reports to incorporate Key Performance Indicators (KPI) that facilitated the decision making of executives - Automated the daily data mart ad-hoc reports, using SQL and Tableau, to maximize efficiency and reduce time by 12% - Measured significant advancements in information and recognized large scale patterns to help customers settle on educated choices - Enthusiastically finding stories and experiences behind the information in various extents of view as an information master
Inventory Analyst Executive
Mudita Pvt. Ltd.•  May 2018 - July 2019
- Database design, Database Modelling, ETL Job Monitoring and Support - Automation of reconciliation process. - Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL - Using Python automation read all data from various sources like (pdf, excel, csv, text)and dumped. - Developed reporting portal for their internal use using PHP, Python, JavaScript, Bootstrap. - Automate daily routine and provide technical support. - Using Data Warehouse technique store historical data into - Database and perform automated tasks. - Implement and analyze data to create weekly, monthly, and quarterly reports. - Expertise in creating and supporting OLAP Cubes. - Designed many Packages using SSIS Designer by using Control Flow and Data Flow tasks with ETL Tool. - Create multiple BI reports in Power BI and SSRS. - Identifying methods and processes on improving operations efficiencies. - Collected and analyzed sales, marketing, and customers data and suggested measures for improvement. - Conduct data mining and data modeling in the coordination reporting department
Freelancer
Freelancer'•  April 2016 - April 2018
- Developing machine learning models for market research classification and segmentation - Wrangling, analyzing, and visualizing data with Python (pandas, sklearn, numpy, and scipy) - Database Design and Administration. - Data Acquisition, Integration & Analysis - Implement and analysis data to create weekly, monthly, and quarterly BI reports. - Automate task as per client requirement. -Collecting and analyzing data and identifying areas and methods for improvement. - Identifying methods and processes on improving operations efficiencies. - Collected and analyzed sales, marketing, and customers data and suggested measures for improvement. - Conduct data mining and data modeling in coordination with client. - Web Scraping and Crawling using python
Product Development Executive
Background Check Pvt. Ltd•  October 2015 - April 2016
- Managed management information system effectively. - Developed systems to support MIS utilized approved development system. - Designed and maintained information system to support company management. - Configure, monitor and maintain databases, monitor jobs, schedule tasks. - Monitor SQL profiler and, performance tuning etc. - SQL Server instance and system improvement. - Backup and disaster recovery of SQL Server databases. - Evaluate audit findings and implement appropriate corrective actions. - Business Intelligence Dashboards for Marketing, Sales, and Warehouse using Power BI.
Senior Officer
Tadekey Pvt. Ltd.•  March 2014 - October 2015
- Installation, Administration and Maintenance of SQL Server Instances. - Create Users and assign permissions based on the level of database access the user would need. - Business unit TK digitals worked on different clients and giving them solutions with respect to their inquiries. - Constant communication and feedback with Clients over new features, enhancements, and customer requirements. - Communicate and collaborate with customers on project status & technical issues. - Once created the database Backup, monitor those backups are being performed regularly. - Advanced SQL Queries and stored procedures. - Troubleshoot various problems that arise in day-to-day work and fix the issues.(Monitoring SQL Server Error Logs and checking your email alert (if there is one configured)
Education
Mohammad Ali Jinnah University
Data Science, BS•  January 2019 - December 2020
Skills
shaheryar_92 has not updated skills details yet.