Madhu Erappareddy Email & Phone Number

New York, Ny, Us

New York City Metropolitan Area

 Implemented a cost-effective SnapLogic ETL pipeline to archive data from AWS RDS to Snowflake, reducing relational database costs while enhancing scalability and query efficiency.  This initiative optimized data management, ensuring integrity and compliance while facilitating future growth and advanced analytics capabilities, and help saving the costs by $40,000 per year. Worked on AWS S3 bucket, creating policy and uploading the data from s3 bucket to snowflake. Built multiple dashboards using Power BI/Tableau, integrating data from SQL Server, Snowflake, and other financial systems, improving decision-making speed by 20%. Successfully migrated SSIS packages to SnapLogic, enhancing data integration efficiency and scalability while leveraging SnapLogic's cloud-native platform for seamless migration and improved performance. Architect and implement a scalable data warehousing solution using Snaplogic and Snowflake, improving query performance by 50%. Successfully plan and execute migration of on-premises solutions to cloud infrastructure on AWS EC2 instance, enhancing scalability, performance, and cost efficiency.

New York City Metropolitan Area

 Designed and developed complex financial systems for Revenue Recognition and Reconciliation Automation; Month-End Accounting Journal Creation/Automation and Transportation Cost Reconciliation and Reporting Automation. Coordinated cross-functional projects with eCommerce, accounting, finance, and BI teams to streamline financial systems and improve reporting, achieving 10% cost savings and improving accrual accuracy by 20%. Successfully redesigned and implemented revenue reconciliation processes utilizing SQL and SSIS technologies during the transition from PayPal's cash collection model to eBay's, facilitating processing for $4+ billion revenue across 150+ million transactions. Effectively orchestrated the implementation of VAT calculation adjustments post-Brexit, ensuring compliance and accuracy for orders dispatched to EU nations.  Conducted detailed parcel-level cost and profitability analysis for eCommerce cross-border operations, utilizing advanced financial models and data analytics to optimize operational efficiencies and maximize profitability. Developed and deployed daily KPI reports in Power BI and Tableau, utilizing data from Snowflake Database to enhance business insights and decision-making capabilities.Technologies Utilized: C#, SQL Server 2012/2017, T-SQL, XML, SSIS 2015/2017, Power BI, Gitlab, Snowflake, AWS

Montville, New Jersey, United States

Data Interpretation to determine vendor related costs and business performance. Designed a process in BI (SSIS) to calculate cost allocation at parcel level for all the invoice payments made to Line Haul, Clearance and Final Mile vendors. Designed and transitioned the revenue calculation process from MS Access to SQL Server for GSP business. Monthly cost analysis and cost allocation for international shipments. Continuously supported a team of auditors with data and reporting during the month end financial close. Worked with developers to build efficient SQL Server Integration Service (SSIS) packages and deploy them on target servers.

Master Of Science - Ms, Electrical Engineering, 3.67

Activities and Societies: Teaching AssistantConducting labs and evaluating assignments for undergrad students, worked for Professor Baback.

Bachelor Of Engineering - Be, Electronics And Communication