PRATEEK MATHUR

• Proficient in Technology leadership, architecture, building great teams, strategy planning, project management, client management and budget planning etc
• Proven abilities and insightful experience in project management activities including project scoping, estimation, planning, risk management, finalization of specifications and resource administration in multiple projects within budget and execution timelines
• Crafting technology strategic vision, define roadmap and leading data teams to deliver creative solutions leveraging OnPrem, Cloud & open-source technologies
• Coordinating with various business and engineering functions for positive impact. Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Developed strong organizational and communication skills through coursework and volunteer activities.

Engagement Highlights:

• Hands-on experience delivering a data reporting platform (PowerBI) for a UK bank, integrating 40+ OLTP sources (SQL Server) and external sources through robust automated workflows on Azure Synapse Analytics platform
• Designed and implemented scaleable lakehouse architectures on Azure Databricks platform for the Marketing Mix Modelling engagements, leveraging innovative tech-stack including Delta Lake files, Databricks SQL Serverless computes & SQL-to-PowerBI direct connect, for leading Pharma client’s multiple regions/countries

• Managed a team of Data Engineering Managers and Data Engineers for Subscription business vertical
• Lead the migration project of data workflows from OnPrem to AWS Snowflake, ingesting and integrating data from multiple sources including Salesforce, Zuora etc
• Liaised between data engineering and BI teams to communicate ongoing data pipelines implementation and BI reporting requirements
• Adaptable and proficient in learning new concepts quickly and efficiently.
• Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
• Contributed to internal activities for overall process improvements, efficiencies and innovation.
• Acted as a team leader in group projects, delegating tasks and providing feedback.

• Responsible for building and maintaining the Data Capability Marts through robust data-pipeline on GCP
• Lead migration project, from on-premises (Hadoop) to Cloud (GCP), to achieve strategic goal of scalability of platform and to leverage the computational power of Cloud platform
• Expertise with Big-Data technology stack including, Hadoop (CHD), Cloud (GCP), Oracle Exadata and SAS –Advance, in different verticals and domains of data engineering world
• Provide inputs to define and execute strategic roadmap for enterprise data architecture by identifying the current landscape and future business goals
• Actively involved in cost-saving optimizations on GCP, i.e
• Efficient utilization of computational services
• Provide project-level resource and workplan projection to the business sponsors for Costing and ROI calculations
• Leading a team of senior data engineers who are responsible for developing data engineering solutions (Data model design and development, ETL development as well as reporting and analytical solutions)
• Actively identify up-skilling opportunities for team on technology advancements and ensure team get required environment and support
• Evokes creative and innovative thinking from team members while helping them to bring their ideas and career plans to fruition
• Managed multiple, large-scale projects across North America Regions' sites

• Developed and managed complex data-pipelines for some of the key clients for the company
• Lead many cost saving initiatives projects, including QMF report migration to SAS
• Managed projects task management by reviewing tasks regularly and provided project's status updates to stakeholders as per defined roles and responsibilities of each member in team
• Involved in evaluation of team member's productivity and delegated project tasks
• Responsible for hiring Software Engineers/Trainees and provided them with on-boarding training and mentoring