Mohan Pasupulati
Verified Expert in Engineering
Data Analytics Developer
Cumming, GA, United States
Toptal member since August 23, 2024
Mohan is an IT application specialist with over 23 years of experience in the data warehouse arena, including approximately 16 years at AT&T. Throughout his tenure, he has held roles such as lead data analyst, architect, ETL developer, administrator, and project manager. Mohan possesses extensive experience with cloud platforms, including Azure, Snowflake, Palantir, and Databricks. He also has a profound knowledge of cloud computing and holds a certification in Azure.
Portfolio
Experience
- Unix Shell Scripting - 20 years
- Teradata - 20 years
- SQL - 20 years
- Azure - 4 years
- Snowflake - 4 years
- Palantir - 4 years
- Microsoft Power BI - 3 years
- Python - 3 years
Preferred Environment
Azure, Snowflake, SQL, Databricks, Teradata, AWS IoT, Unix Shell Scripting, Palantir, Python, Spark
The most amazing...
...thing I've developed is a dashboard for the ACE team's response for external triggers (RENT) program, which could save $25 million over a 24-month period.
Work Experience
Lead Data Engineer and Analyst
AT&T
- Received multiple awards for various projects, including the AT&T Spot Award, Customer Excellence Award, and several Big Win accolades at the VP level.
- Built a dashboard for the RENT program for the access construction and engineering (ACE) team, with potential savings of $25 million over 24 months.
- Served as lead data engineer to gather and analyze requirements from business clients, document data integration needs, and translate them into functional and technical solutions.
- Integrated data from various sources, including Snowflake, Teradata, Oracle, Vertica, Aster, and Hadoop.
- Architected ETL solutions using Palantir by designing ETL pipelines for projects such as AIA with Python and PySpark.
- Coded and modified scripts using PySpark and Python for various projects. Employed Python for complex transformations such as change data capture (CDC) and full historical loads when table metadata changes using change scripts.
- Performed extensive system testing of data for critical projects such as email solutions to ensure the quality and reliability of data integration. Designed, coded, tested, and implemented a campaign dashboard using Snowflake.
- Acted as a liaison between business clients, stakeholders, and the technical team, translating business needs into specifications. Built ad hoc reports and dashboards using Power BI, Tableau, and MicroStrategy.
- Migrated projects such as D2D Salesforce and Mass Markets Xsell Promo from Palantir to Snowflake. Served as ETL architect for the marketing team, establishing standards, procedures, and ETL processes.
- Analyzed and resolved data integration, synchronization, and performance issues with technical expertise. Procured Unix servers and set up a new data warehouse environment featuring Informatica (ETL), Oracle (repository), and Tivoli (scheduler).
Experience
RENT Dashboard
Education
Bachelor's Degree in Computer Engineering
Gulbarga University - Gulbarga, India
Certifications
Microsoft Certified: Azure Fundamentals
Microsoft
Skills
Tools
Microsoft Power BI, Tableau
Languages
SQL, Snowflake, Python, COBOL, C
Storage
Teradata
Frameworks
Spark
Platforms
Azure, Databricks, AWS IoT
Other
Unix Shell Scripting, Palantir, Cloud
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring