Rohan Pathak Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

Lead Data Engineer for Macy’s Tech.

Atlanta, Ga, Us

• Led a team in developing Looker dashboards utilizing Python to monitor accuracy of data across multiple business rule transformations, increasing Reliability quotient by ~25%.• Collaborated with cross-functional teams to create statistical models for data validation and predictive analysis, improving forecast accuracy by 15%.• Built and maintained complex pipelines using Python, DataFlow and Vertex AI to ingest and process ~2TB of data daily from multiple sources for Quality, Reliability and Compliance dashboards.• Developed compliance dashboards using Tableau, linking Inquiries and Contributions with a potential for annual saving of $1.2 million. • Built custom data extraction tools to automate the gathering of large datasets, significantly reducing manual intervention and improving data accuracy using SQL for background querying.• Created stored procedures allowing any multi-nested AVRO file to be queried, streamlining process for dashboard integration and query optimization.• Migrated ~100TB of commercial PII data from Mainframe to GCP BigQuery using JavaScript, SQL and PySpark, to align with company goals of Cloud Transformation.• Built dashboard for Fraud’s Investigations team, migrating their process from MS Excel and saving 16 engineer hours per week.• Developed Data Furnisher Illogical conditions dashboard, translating business rules to SQL, checking expected and actual values post transformations.• Developed 7Cs for Commercial data to provide visibility of data throughout pipeline across multiple stages of transformations.• Developed Data Furnisher Illogical conditions dashboard, translating business rules to SQL, checking expected and actual values post transformations.• Developed scripts for loading ~2TB of data to BigQuery in partitioned tables and generating dynamic metrics tables.• Defined business transformation rules for Specialty Finance written in Java to SQL for Collibra.

Atlanta, Ga, Us

Led a team of Graduate Research Assistants for Evidence Based Cybersecurity Group. Work includes web scraping, data cleaning, data ingestion, modeling, and visualization.

Hanover, Maryland, Us

As part of the Automation team, was part of team overhauling device deployment software. The project included decreasing load times for increasingly complex bootstrap scenarios for a product line of 25+ hardware flavors, while keeping the solution easily scalable and modular.Created and maintained a data pipeline utilizing SQL to ingest 400 million rows of data daily from 12 real-time data sources, piping it into Azure. Successfully decreased usage of Snowflake compute power by identifying and converting full load tables to incremental resulting in reduction of engineer hours by ~60%.Led development of Tableau dashboards automating quality reporting, merging outputs from 30 live sources using Python.Implemented ETL/ELT workflows using Python, to extract, transform and load data from multiple sources into a centralized data warehouse for analysis, increasing data accuracy by 25% and reducing processing time by 30%.Selected for the "Thrive" development program, one of only 25 such employees from the whole organization. The program was selected for high leadership potential individuals, teaching different Management & Leadership techniques along with teaching EI, Design Thinking, and Storytelling.Developed dashboard to display key insights from the large amounts of data captured.Mapped best practices and codified them in documents.

Hanover, Maryland, Us

As part of the Continuous Integration team, enhanced the existing TCL based automation framework to work with the newly created Python based framework for a virtualized operating system.Led taskforce to reduce redundancy and time wastage due to device unavailability, script instability and outages.Sole owner for multiple features for Security, Layer 2 and Layer 3, including Zero Touch Provisioning, Border Gateway Protocol, L3VPN, LLDP and SAT.

Florham Park, New Jersey , Us

I was a part of Incedo's Communication Engineering vertical, catering to a North America based Industrial Networking and Security giant, assisting our clients to be flagbearers in their respective fields.Worked parallely on multiple products, including an Industrial Routing Solution Hardware, a centralised network management application, an on-wire plug-in network security solution, and a cloud based secure key repository thus giving.Engaged with customers from the initial planning phase through the build, testing, delivery and sustenance stages. Shared ideas and collaborating with global CE team to isolate possible challenges and viable solutions.Developed and enhanced in-house automation framework for testing client product lines.Helped in capability development and team-building exercises by volunteering for community events and knowledge sharing sessions.Coordinated with vendors thus understanding and verifying their respective use cases, making it possible to deliver bespoke solutions while maintaining quality by focusing on required features.

Florham Park, New Jersey , Us

Doorstep Fitness Solutions/Localized organic rooftop gardens--Determined scope of the services offered along with the pricing, tailoring the solutions provided according to market research and use case validation.-Strategic Tie ups with merchants and service providers.-Lead sales and operations team of interns for initiating service launch.

Masters In Information Systems, Big Data Analytics

Bachelor Of Technology (B.Tech.), Electronics And Communications Engineering

Inter, English, Physics, Maths, Chemistry, Computer.