Prateek Jain
Gurugram, Haryana
Summary
5+ years experienced, currently working as a dedicated Data Analyst Consultant bringing dynamic skills in client oversight, delivery, issue resolution, and presentation.
Have excellent problem solving skills and eager to work with proactive approach, great work ethic and quick learner as well.
Ability to juggle multiple tasks and projects simultaneously and perform well in a fast-paced/deadline-driven team environments.
Overview
5
5
years of professional experience
Work History
Staff Consultant (Data Analyst)
Apps Associates (I) Pvt. Ltd
Gurugram
04.2022 - Current
- Worked as a Data Analyst to set up Mckinsey's Periscope for Multiple International consumer goods companies which empowered them to drive profitable growth. This solution focus on insights creation, marketing optimization, and pricing, promotion, and category management.
- Built Pre-Processing ETLs in Pyspark,Python,SQL for multiple clients to perform Data Quality Checks, Data Transformations to generate data in Client Facing Data Schema to be loaded into Central ETL.
- Deployed Central ETL on client to client requirements and regular updates as per version upgrades in the Central ETL.
- Ran and debugged Central ETL as and when required on projects.
- Developed post ETL SQL scripts to load data into database and transform as and when required in post ETL DB scripts.
- Configured end to end YAML config for the Periscope tool on multiple projects.
- Developed test cases to be performed as per Technical/Business requirements to perform 100% quality checks to maintain Delivery efficiency and quality.
- Developed Multiple Alteryx workflows for Data QC, Data transformation and adhoc data tasks.
- Weekly check in with clients to keep them in loop on progress over time and to understand adhoc requirements/feedbacks.
- Daily check in with the team to track work plan and PS when required.
Member Of Technical Staff-II
Mavenir Systems Pvt. Ltd.
Gurugram
08.2020 - 04.2022
- Managed Technical Services for one of country's top Telecom Operator
- Developed Python,Linux and awk scripts to automate multiple tasks like performance monitoring,data fetching/analysis,health checkup
- Involved in Development of multiple web applications using Django framework
- Deployed multiple logic templates in Application tool Xura Analytics to fetch data based on multiple different requirements
- Worked on SpamShield services that employs advanced machine learning techniques to rapidly identify and automatically control fraudulent traffic
- Load distribution of high traffic over multiple Clusters/Hubs based on requirements
- Initializing TCP dump over system and analysis of end to end packets using Wireshark network analyzer
- Experience of working in a high pressure situations to avoid critical outages.
Engineer
Comviva Technologies
Gurugram
11.2018 - 08.2020
- Worked on Performance Reporting of the System deeply using tools like Excel to rectify issues proactively with the team inorder to avoid any visible impact
- Working on multiple protocols like SS7,SMPP,HTTP,TCP/IP
- Developed multiple test cases in different scenarios to make the rules/logic efficient of the system
- Coordinating with client as well as multiple teams during outages/any other critical requirements.
Education
B.E in Information Technology -
SRIT
Jabalpur06.2018
Higher Secondary Schooling -
MVM
Birsinghpur Pali04.2014
Skills
- Python
- PySpark
- Spark
- PostgreSQL
- SQL
- Alteryx
- Pandas
- Databricks
- Microsoft Excel
- Bash Scripting
- NumPy
- Django
- Flask
- CherryPy
- Matplotlib
- SciPy
- Data Structures & Algorithms
- OOPs
- Visual Studio Code
- Rest API
Timeline
Staff Consultant (Data Analyst)
Apps Associates (I) Pvt. Ltd
04.2022 - Current
Member Of Technical Staff-II
Mavenir Systems Pvt. Ltd.
08.2020 - 04.2022
Engineer
Comviva Technologies
11.2018 - 08.2020
B.E in Information Technology -
SRIT
Higher Secondary Schooling -
MVM
Similar Profiles
Ritesh MishraRitesh Mishra
Principal Consultant at Apps Associates (I) Pvt LtdPrincipal Consultant at Apps Associates (I) Pvt Ltd
Ramakrishna Vasista TatapudiRamakrishna Vasista Tatapudi
Principal Consultant at Apps Associates India Pvt LtdPrincipal Consultant at Apps Associates India Pvt Ltd
Derrick AshikoyeDerrick Ashikoye
Web Developer at IWeb Developer at I