Shashank Jain Email & Phone Number

Dallas, Tx, Us

New York, New York, Us

1. Leading and executing projects following SDLC best practices.2. People Management.3. Providing analytical solutions to variety of projects

New York, New York, Us

1. Leveraged Anaplan to streamline Budget and Financial Planning & Analysis through model building and optimization.2. Engineered key components of a centralized Year End Compensation Planning Anaplan model to eliminate dependency on decentralized Excel models3. Developed Alteryx workflows to automate multiple processes saving significant time for stakeholders across the firm.4. Created Excel Macros to automate multiple manual tasks triggering several hours per week of collective time saving firmwide. Further integrated key macros together to create a 1-click and 1-time installation Add-in available for all users.5. Designed Tableau dashboards to provide a quick yet comprehensive overview of the divisions’ key metrics providing important insights to top management to help drive decision making for future strategy building.6. Leveraged SAP Business objects to create detailed reports and facilitated seamless delivery of recurring reporting requirements.7. Performed complex analysis for ad-hoc requests leveraging an ensemble mix of tools including Excel, Alteryx, Tableau etc.8. Represented the broader team at various internal platforms by conducting various sessions, demonstrations etc to large audience across the firm.9. Provided training and mentorship to new joiners in the team ensuring a strong and reliable workforce.

New York, New York, Us

San Francisco, Ca, Us

• Developed tool to provide recommendations to optimize inventory level improving store sales by 6% for targeted products• Automated reports in Excel using VBA to reduce processing time and auto update frequently monitored dashboards• Planned & designed dynamic dashboards in Power BI replacing existing Excel dashboards reducing processing time by 70%• Designed SQL queries for ad-hoc reports and extracting data from server for auto-updating Power BI dashboards

Oakland, California, Us

• Generated dynamic reports in Tableau as an alternate to pre-existing manual Excel reports reducing reporting time by 60%• Utilized customer data to generate heat map in Tableau and presented areas of opportunity & concern to management• Led an initiative for centralizing data collection reducing processing time from 18 to 2.5 hours/week saving $18200 a year• Integrated Excel model with server using ODBC connection for auto-updating data and to reduce manual entries by 95%• Automated multiple reports using VBA coding saving approx. 62 hours of company time worth $22320 per year• Built reports on SAP Business Objects to further integrate them with data from other sources for robust reporting• Designed and executed complex SQL queries upon ad-hoc requests providing reports crucial for daily Business activities

Dallas, Tx, Us

 Leveraged flight data to create dashboards in Tableau to assist management in identifying trends and making decisions Designed Excel model to forecast future utilization of airport facilities derived from flight schedules identifying key airports Simulated baggage handling system through complex logic in Excel to recommend potential investment in selected airports Identified growth opportunities and designed complex SQL queries to generate reports providing data to pursue them Delivered ad-hoc capacity and demand reports to upper management for use in executive presentations Administered project records on different project management tools to recommend priority list of steps for project completion

Richardson, Texas, Us

Maintained relations with UTD Alumni as a school representative over the phone.

Charlotte, Nc, Us

Provided front desk assistance to the students.

Master Of Science (Ms), Information Technology And Management

Bachelor Of Engineering (B.E.), Electronics And Communications Engineering