Gaurav Mazumdar

Gaurav Mazumdar Upper Darby, PA-19082, Cell -- SUMMARY Decisive, action-oriented, result-focused and self-driven leader having extensive experience in Business Analysis, Data Analysis and Modeling. Ability to take vague business problems, put structure around it, collaborate with teams to deliver meaningful solution. PROFESSIONAL EXPERIENCE M3BI LLC, Phoenix AZ (USA) 2014 – 2015 American Express – Tech Lead (2014 – 2015) Evaluated legacy systems being run by Amex for reporting and analysis. Worked with stakeholders to create a roadmap to migrate to a new system with minimal business impact. The project was successfully completed in time leading to a run rate saving of $70K per year. Evaluated the performance of client reporting tool and benchmarked it against other customers. Based on the findings worked with a team of engineers to optimize SQL code which led to 20% better performance Partnered with sales and marketing team to understand their current business model. Based on the findings we created actionable reports (peer comparison, share of wallet, Amex business transaction volume vs. total) to help them target accounts better resulting in better revenue and profit Led a team of people to create dynamic dashboard that client could share with its partners for them to have real-time view of metrics. This helped the partners get a better understanding of different issues and helped Amex increase share of wallet by 10% - 20% for each partner. Led a team to visualize partner data on a map with drill down capabilities. This helped Amex and partner understand which states, cities and customers were spending and offer them right deals Worked on optimizing performance of dynamic report that reduced latency and helped with customer experience and better adoption Built right level of access management in the reports to control access rights which helped client be industry compliant RELIABLE SOFTWARE RESOURCES, Detroit MA (USA) - Adobe, San Jose – BA/BI Consultant (2014 – 2014) Led a team to create an analytic framework and dashboard that enabled Adobe to understand how long their cloud application was down and its impact of revenue. This resulted in 10% higher uptime and better accountability. Created KPI that enabled management team to have objective conversation with the infrastructure team. This project led to better server uptime which led to better customer experience. VISA, Foster City – Microstrategy Architect/developer -) Led a team to understand the impact of running ticket promotion (Winter Olympics, Russia) by analyzing adoption rate and profit. This project helped Visa systematically build a framework to quantify the impact of promotions and increase ROI. Worked on proof of concept (POC) integration of Visa data lake (Hadoop) with Microstrategy which helped Visa leverage dark data to draw more meaningful customer insights. The process was documented for teams to test in development environments. Managed end to end deployment of Microstrategy at Visa which involved requirement gathering and headcount estimation, documenting all system changes and migration process, managing relationship with end users and development team and giving updated to the client. The project was delivered on time and help Visa get a better understanding of its installed base in real-time. Herbalife, Torrance – Microstrategy Developer -) Led a team to create reports for Herbal Life customers to understand where they were compared to their goals. Providing this transparency helped Herbal Life increase its sales across customers by 10% - 15%, and provide a better customer experience. Created management report to provide accurate revenue and unit visibility by geography. This helped customer to get a better understanding of their performance and take proactive measure (e.g., run geographic campaigns etc.) to reach their goals Acted as a Subject Matter Expert providing input to application design pertaining to production tuning and administration requirements which resulted in better optimization of the solution. INFRASOFT TECHNOLOGIES LIMITED, Mumbai (India) - HPD, London - Business Analyst -) Gathered requirements and created an application for HPD that help them with home loan processing and home listing activities. The application helped HPD streamline their sales process leading to 15%-20% increase in pipeline opportunities. Took a lead at building relationship with the customer which led to 3 fold increase in Infrasoft service and revenue with HPD and as a result was awarded Emerging Leader for the year-. Cantor Fitzgerald, New York - Senior Software Developer -) Architected an application for Cantor’s Sales operations team which enabled them to have a better visibility into salesforce performance and revenue quota attainment. The project helped Cantor to roll up sales information across teams which led to more accurate sales forecast and sales planning. Successfully led and completed multiple projects for Infrasoft with Cantor which helped built the offshore account by 24x and expanded the offshore team by 10-fold resulting into 15% hike in the company’s annual revenue. TECHNICAL SKILLS Technology:Java, J2EE, jsp, Struts Framework, Spring Framework, iBatis, Velocity Databases:Oracle, SQL, Sybase, MySQL Markup: HTML, XML Scripting: Shell, JavaScript, OOP Programming Languages: Java, Python, SQL, PL/SQL, UML GUI/Tools:MS Project, Visio, MS Word, MS Excel, Rational Rose, Enterprise Architect Application Servers:Tomcat, JBoss IDE: Eclipse 3.x, Net Beans Operating Systems:Windows, Sun Solaris, Linux Industry Standards:ISO, CMMI, Six Sigma Defect Tracking:Digite Testing Tools:WinRunner, Load Runner, Quick Test Pro BI Tools:Microstrategy. OBIEE, Tableau Concepts: Data Warehousing, Business Intelligence Methodologies: UML, Waterfall model, Agile. Functional Skills SetStrong analytical and documentation skills, Problem solving and communication skills, Strong client interaction skills EDUCATION Master of Business Administration, MBA, August 2012 HULT INTERNATIONAL BUSINESS SCHOOL, Boston, MA Harvard University – Summer School, May – August 2012 Strategy in Information Systems Bachelor of Technology in Computer Science Engineering, June 2007 JAYPEE INSTITUTE OF ENGINEERING AND TECHNOLOGY, Guna MP, India