Soham Munjapara

Results-oriented professional specializing in data analysis and stakeholder communication, developed at Amazon. Achieved a 20% increase in operational efficiency through effective conversion of technical data into actionable insights. Demonstrated expertise in business process analysis and project management, with a focus on creating clear and impactful documentation.

• Excel Capstone | Quantitative Analysis, 04/23, Analyzed employee data deploying INDEX/MATCH function to identify employee information based on ID, and conditional formatting to visually highlight employee eligibility (Y/N) for benefits., Imported and transformed data from Orders, Warehouse, and Inventory tables in eApp_Cap_Orders.accdb using Power Query., Formatted date columns and loaded data into separate worksheets., Constructed a loan amortization table for a new construction project. Used IPMT, CUMIPMT, and CUMPRINC functions with loan details (amount, interest rate, term) to calculate interest paid, principal paid, and remaining balance for each payment period.
• Data Warehouse Creation and Documentation | Database Management Systems, 04/23, Integrated MySQL, a detailed database, was built for a client wanting to enforce referential integrity on the FACT and COMMAND tables., Designed a data warehouse based on client requirements, leveraging MySQL, where users cannot add data., Created a database by adding fields and inserting data manually leveraging MySQL query., Drew a VISIO diagram showcasing relationships with tables operating Microsoft VISIO platform., Documented mail responses of client with all queries and diagrams operating MS Word.
• CIBC Expansion Capstone | Business Analysis Capstone, 04/24, Utilized networking tactics to build a team consisting of talented Business Analyst lead by a project manager., Researched CIBC's open data and reports to form the current understanding of its standing. Analyzed reports and data to design requirements table and created RACI to divide work among group members., Presented information on Global expansion on power point presentation tool and delivered in front of client., Structured in a team to expand AS-IS and Future AS-IS diagram on VISIO shows structured processing in a swim lane.