Virain Malhotra Email & Phone Number

Amritsar, Pb, In

Toronto, Ontario, Canada

• Thoroughly documented the requirements to ensure clear understanding to development team and avoid any ambiguity.• Developed ETL Pipeline to generate credit reports using Talend, calculated Totals and rendered the data using Python and SQL(DB2).• Wrote custom scripts in Python to automate data processes, transform the data and optimize data workflows.• The goal was to optimize the report generation process for TSYS System and make the data processing smooth in high traffic environments.• Used version control system (Bitbucket) and collaborated with cross functional teams to manage codebase and ensure smooth integration of data pipelines.

Toronto, Ontario, Canada

• Collaborated with internal and external stakeholders to gather requirements in order to build applications following an agilemethodology.• Developed end-to-end applications that automated manual tasks such as collecting data from customers through speech-to-text viaIVR, rendered the data using Python libraries and processed it using Machine Learning Algorithms which predicted the best-suitedofferings for the user.• Automated processing of the gathered data using RPA tools such as Pega Robotics in a manner that allowed it to be utilized indisconnected systems without human intervention.• Increased the overall accuracy of the system to 91% while reducing the process SLAs by 45%.

Toronto, Ontario, Canada

• Utilized Python and numerous data science libraries such as Numpy, Pandas to analyze and process large data sets.• Spearheaded diverse projects for data capture, storage, configuration, and forecast analysis.• Conceptualized and launched production ready machine learning models like regression, predictive models, classification, NLP, and Anomaly Detection etc.• Formulated, defined, and documented system specifications and recommended data analysis tools to address business issues.• Created, validated, and applied of statistical models, time series analysis models, and implemented digital solutions.• Liaised with stakeholders to gather requirements and devise solutions for preprocessing and modeling issues.• Solved business problems through data science and internal evaluation processes and procedures. • Generated forecasts and identified trends through data processing and trend tracking.

Noida Area, India

• Tested and reformulated models and created PowerBI dashboards to foster actionable analytics insights for business strategies.• Identified and analyzed business strategy implications to increase longevity and growth.• Strategized and built NLP classification models using NLTK, and various segmentation and parsing techniques.• Collaborated cross-functionally across various geographies to distill data to devise solutions and deliver projects on time.• Orchestrated graphs/ charts detailing data analysis results using advanced PowerBI tools and techniques such as Bookmarks, Parametric reports, Drill through report to create UI reports for end users and published the reports to the report server and scheduled the data refresh.• Collected, tracked, and organized statistical quality of semi-structured data to evaluate current business and market trends using advanced SQL (MS SQL Server), SSIS tools and tasks such Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, and Data Flow Task.• Systemized and developed new functions to support sophisticated analysis.• Extracted and transformed data using Data Conversion, Derived Columns, Look Up, Conditional Split, Aggregate, Union All, Merge Join, and Multi Cast Transformations.

Gurgaon, India

Master Of Engineering - Meng, Computer Engineering

Bachelor'S Degree, Computer Science