Pooja Pant Email & Phone Number

Harrisburg, NC, US

• Managing the overall engagement and delivery for all Lockton projects.
• Meeting with client's business/functional analysts to record and understand the requirements.
• Collaborate with various internal IT Teams and other stakeholders to perform impact and feasibility analysis.
• Creating High Level and Low Level Design documents based on the business requirements and translating into technical designs and prepare requirement documents.
• Design and develop data transformation logic using SQL, Databricks and spark, load strategy to handle large data volumes.
• Dimensional modelling and design / development of Datawarehouse to integrate revenue data with Producers, Client, Organizations Structure, Line of Business and Statutory Account.

• Design and develop data transformation logic using SQL, Databricks and spark, load strategy to handle large data volumes.
• Dimensional modelling and design / development of Datawarehouse to integrate revenue data with Producers, Client, Organizations Structure, Line of Business and Statutory Account.
• Review code and arti-facts created by team members to ensure deliverables quality. Provide feedback and recommend changes as warranted.
• Performance tuning of ETL and SQL queries for efficient data loads and reporting.
• Create and maintain documentation, supporting training, code deployment and operational process/procedures.

• Implementing Large Scale Data Warehouse solutions using Snowflake for payment processing service.
• Developing and executing ETL Pipelines using SnowSQL and DBT.
• Performing Continuous Integration and Continuous Delivery using GIT and Jenkins.
• High level and low level design documentation for data models and pipeline.

• Developing AI/ML software products on cloud-Microsoft Azure.
• Setting up Virtual Machine on Azure and configuring setups for R, Rstudio, RServer and Shiny apps.
• Developing and deploying Shiny apps through Shiny server on Linux Virtual Machine.
• Implementing Agile in development using Azure DevOps.
• Building end to end cloud solutions on Azure (Azure SQL DW, Azure Data Factory, SQL on Azure)

Charlotte, North Carolina Area

• Developed and optimized data extraction process from CPSC’s website, using web scraping and Python scripts. (Consumer Products Safety Commission)
• Transformed semi structured XML data using Python and loading it to MySQL database.
• Extracted meaningful insights and recall patterns using Tableau dashboards.
• Developed machine learning models to predict products which are likely to be recalled.

• Hands on experience of Machine Learning algorithms in retail/Food chain industry.
• Built customer segmentation system using RFM technique in Python.
• Tested existing predictive models and their ability to forecast sales and traffic in the fast food industry.
• Detected outlying occurrences and offering customized promotion.

Gurgaon, India

• Client: Lloyds Banking Group.
• Corroborated business requirement and extrapolated time and effort for software testing of mainframe-based bank applications.
• Prepared Daily Status Report to demonstrate to client using Excel and Tableau.
• Led a team of 4 in a complex project and ensured completion of all the deliverables within timelines using agile methodology.

Gurgaon, Haryana, India

• Client: CVS pharmacy
• Ensured product delivery as per industry standards, market benchmarks and client requirements.
• Performed Exploratory Data Analysis using Python libraries and prepared data profiling reports to confirm data quality for better execution.
• Performed extraction and transformation of relevant data set for quality testing using Alteryx.
• Ensured data preparation and data loading for testing cycles using control-m in test environment.
• Data validation using SQL queries: select, insert, update and delete test data in the database.

Pithoragarh Area, India

• Motivating and talented Electrical Engineering Professor driven to inspire students to pursue Academic and personal excellence.
• Consistently strive to create a challenging and engaging learning in which studentsBecome lifelong scholars and learners.
• Providing required practical knowledge along with theoretical concepts.
• Awarded with ‘Most talented young teacher’ by college management for my unique teaching skills.

Master'S Degree, Information Technology, 4.0

• Enhanced Big Data analytical knowledge along with programming skills and tools. • Created a strong foundation in statistics involved in.

B.Tech, Electrical Engineering, Honors

• Gold Medal at University convocation for academic excellence. • Merit Scholarship for all years in B.Tech from Uttarakhand Technical.

Intermediate, Physics,Chemistry,Mathematics, Honors

• Secured top rank throughout schooling. • Actively participated in Inter school competitions and won several prizes in Quiz Competition.