Bilal Jamil, M.S. Email & Phone Number

Woodland Hills, Ca, Us

• Achievements:o Promoted to a Data Scientist to work on advance data science projects. o Developed production level machine learning solutions using many models like linear regression, logistic step-wise regression and random forrest.o Successfully gave 2+ R&D project demos to company CTO, 1 demo to company CEO.o Successfully shipped BlackLine's first AI platform "Intercompany Predictive Guidance". o Developed a fully-functional UI interface giving AI predictions to the user.o Developed a robust data-engineering infrastructure for our team.o Developed a hierarchical clustering model which can create profiles of financial transactions and their likelihood group of billing cycle.o Developed a matching algorithm to match past financial transactions with their future versions.• Role Background:o Part of the Research and Development team within the Engineering org where I am working with internal senior stakeholders, process owners and subject matter experts for our projects.o My role is of a 'Full-stack' Data scientist, where I am doing data exploration, data collection, designing and developing ETL pipelines from multiple databases, doing EDA on collected data, designing and developing web interfaces using Gradio and R Shiny. Last but not the least developing machine learning models and deploying them in the web application for on-the-fly predictions. • Tech-stack:o Programming languages: Python, R, SQL. o Databases: Oracle RDS, and PostgreSQL RDS. o Devops and cloud services: AWS Lambda, AWS S3, AWS EKS, AWS ECR, AWS EC2, Jenkins, Hashi-Corp Vault.o Data Visualization: Tableau, Gradio, Shiny. o Code repository: GitHub.o IDE: Visual Studio Code, Jupyter Notebook and R Studio.

Woodland Hills, Ca, Us

FourQ Systems did a merger with BlackLine, I am currently part of the Billing Operations team at BlackLine, I am the process owner for a Billing(invoice management and intercompany) product that processes financial data worth $7B+ a year. My role is focused on maintaining the overall operations of the process, handle financial data and applying data analysis strategies to correctly understand the data, make sure all the billings of our clients are taking place correctly. Following are some of my responsibilities and achievements so far:• Writing SQL queries to do investigative data analysis work on huge sizes of data sets.• Automate SQL queries using Python scripts for daily, biweekly, and monthly billing reports.• Doing advanced level SQL using Common Table Expressions (CTEs), Views, Subqueries, Window Functions, Aggregate Functions, and various sorts of Joins (Inner, Left, Right).• Handling terabytes and petabytes of structured and unstructured datasets.• Working on Data Analytics Techniques to improve data quality, build Tableau Dashboards for operations performance and metrics.• Create, update, manage and optimize Alteryx workflows.• Documented billing processes worth Billions of Dollars using Microsoft Visio and build training manuals, SOPs, tool kits, data models, and data dictionaries for the team to understand everything.• Working on Data warehousing techniques such as star and snowflake schemas.• Working on very advanced visualization techniques for day-to-day metric reporting using Tableau, build user stories, and various graphical analyses for executives.• Working on Agile Development Methodologies, optimizing JIRA board, conducting daily scrums with the production team on operational and technical issues.• Tools: SQL, PL/SQL, Python, Alteryx, SAS, Tableau, PowerBI, Oracle Database, JIRA, ServiceNow, SAP Business Objects, Microsoft Visio and Excel, Smartsheet's, etc.

Manhattan, Ny, Us

Graduated with a 3.8 GPA.

Dallas, Texas, Us

• Utilized statistical methods using SQL to analyze and translate data to close more than $318,200+ from Q1 – Q2 2020.• Designed workflows with SQL and MS Excel and automated processes which improved customer satisfaction rate by over 38%.• Compiled performance data for the sales team using MS Excel with a focus on growing business revenue by $2 Million.• Deployed NCache product in AWS and Microsoft Azure marketplace and helped clients deploy the product in their own environment.• Designed charts and dashboards using MS Excel of 1900+ leads which helped analyzed sales patterns to generate revenue of approximately $151,000.• Applying ad-hoc analysis on spreadsheets which resulted in an 18% increase in sales-qualification of prospects and their turnover to successful customers.• Designed more than 5+ region-wise visualizations using MS Excel and SQL across US East-Cost, US Central, LATAM, EMEA, and APAC regions on 5% business growth to focus marketing operations.• Worked closely with companies like State Street, BMW, Willis Towers Watson, Invesco, North Carolina Department of Revenue, Association of Internal Medicine, Nagarro, Halk-bank etc.

Dallas, Texas, Us

• Initially started working on a portfolio of SMEs from US$ 1 - 49 Million of Eastern, Central region of the United States and Latin America region (Total of 32 countries).• Together with the Technical Support Team delivered more than 35+ Technical Demos of our product which ended up as successful enterprise sales using GoToMeeting.• Produce weekly reports from data using SQL and MS Excel.• Mined company data for key metrics relevant to company priorities using MS Excel and SQL. • Created reports from data in MS Excel for managers. • Updated client data systems in PipeDrive CRM and MS Excel.• Assisted the IT team in developing detailed business specifications. • Interpreted company reports determining the effectiveness of current processes, procedures, and strategies using PipeDrive and MS Excel.

Islamabad, Pk

• Helped develop new marketing strategies using SQL on historical data which slashed 25% in marketing costs.• Developed an online UAT module which improved Service Level Payments by 35%.• Established and managed billing database and ensured compliance with billing protocols, reducing errors by 19%.• Modeled and developed a database in the SQL database of more than 200+ leads from the company's historical data in MS Excel.• Deployed the product “RobotWala” using agile methodology and suggested more than 5+ features into the SaaS product which onboarded 2 new clients in my tenure.• To liaison with stakeholders for product and project progress.• Oversee various processes for timely project progress and implementation using MS Project, Basecamp, SalesForce.

Greater New York City, Ny, Us

Greater New York City, Ny, Us

Master Of Science - Ms, Data Analytics And Visualization

Bachelor Of Science (Bs), Electrical (Computer) Engineering