Deepanshu Bansal Email & Phone Number

Gurugram, Haryana, India

Noida, Uttar Pradesh, India

 Primary owner of major 90+ Business MIS/Reporting for business users and other tech teams  Worked directly with Product managers to introduce new features on the product level side  Worked on large data sets of payment domain with about 300+ million users and about (20+) TB of data  Working on Big Data using Hadoop, Hive, Python, Spark, Scala, SQL, AWS and Airflow Creating analytical dashboards and predicting business trends using Superset, Tableau and Quick sight Managed payouts and settlement reports of Paytm payment gateway using AliCloud, an Alibaba cloud offering Creating pipeline from scratch for settlement to merchants at customized timings

Gurgaon, Haryana, India

 Conceptualized and developed BI applications, showing key performance indicators (KPIs) using TIBCO Spotfire Professional Lead different project phases of Spotfire dashboards - requirement elicitation, design and development  Revamped the pre-existing dashboards to modernize their aesthetics and make them more efficient Revitalized the usage statistics by introducing the Spotfire dashboards for mobile devices – iPad, iPhone Went beyond tool limitations and used IronPython scripts to expand the dashboards’ capability Used calculated columns, custom expressions, action controls, property controls in Spotfire reporting to provide the best solution to the business users Expert in using information designer to create the data elements and information links Responsible for first in-house personalized analytics project increasing dashboard usage by 25% Designed UX presentations for client meetings and other stakeholders Single POC for clients’ queries regarding business rules and market trends Worked with onshore and client teams to understand business requirements, set expectations, address concerns Responsible for designing ETL and code review of peers and junior team members

Gurgaon, Haryana, India

 Designed data models for data warehouses maintaining the principles of optimization and flexibility using Informatica and Oracle Documented metric/functional requirements and use cases for the project Created test plan and performed unit testing, SIT and UAT Developed case studies to help the brand managers formulate brand plan and envision 15% increase in annual sales Innovated Excel-based tool analyzing performance of field reps Innovated and built a consolidated tool showing correlation of promotional strategies to sales performance Deliver analytical ad-hoc reports for clients Taking initiatives to enhance the automation and optimization of daily operation process – reduced overall run time by 40% Achieved 100% error-free daily runs by introducing automated Data Quality Management solution  Creating extensive quality - reducing data anomalies in daily run by 7%  Optimized the deliverables to improve consistency and accuracy using VBA – reduced the effort by 50% Automated the process of QC control, developed Excel reports improving delivery margin by 12% Acknowledging, logging and resolving incidents reported by clients using OnTrak Scheduling and maintaining ETL jobs using Autosys

Gurgaon, India

 Developed an Android App named Route Planner using APIs

Noida Area, India

 Developed a Java software on Airline Ticket Reservation System

Bachelor Of Technology (B.Tech.), Computer Science, 74.5%

Activities and Societies: Organized technical events at college fest (Techsurge & Mridang) in 2013 and 2014 Attended workshops on Business.

10+2, Non-Medical, 90.2%

Activities and Societies: School badminton team Consistent performer House prefectI was in the school badminton team and played in CBSE.