May 2017 – Jul 2019 · 2 yrs 2 mos · New Delhi Area, India

• QED’s Monitoring, Evaluation and Learning (MEL) practice works across all levels of government and with their stakeholders to improve government performance, accountability, responsiveness, and transparency. QED helps clients such as the U.S. Agency for International Development, U.S. Department of State, and U.K. Department for International Development develop best practices and lessons learned, learn from projects’ strengths and weaknesses, and improve the quality of their service.
• As a data scientist we focus to brings an understanding of human centered design principles and how to best communicate and convey information to a non- technical audience.

Feb 2011 – Apr 2017 · 6 yrs 2 mos · Gurgaon, India

• Big Data Preparation/Programming/Loading & Statistics:
•  Developed a predictive analytics model that can be scaled to any time period, source or processing bucket name and holds power to be expanded to many more parameters. The model is translated using powerful & dynamic logics to online reporting that can be accessed anywhere & anytime. The engagements resulted in streamlined processes leading to cost savings, process efficiency, better management control and improved operating efficiency.
• Developed a process to migrate historical SAS data sets to Hadoop. The main components will add attributes to the dataset from the dataset name to use for partitioning in Hadoop. Tables with the same layout should be added as one data table in Hadoop.
•  Platform-oriented support & Metadata management

Nov 2007 – Feb 2010 · 2 yrs 3 mos · Gurgaon, India

• Responsible for having client/on-site team interaction and understanding clients' business problems and defining the analytical approach to solving them.
• Carries out all aspects of client engagements including work planning, estimation, scope refinement, quality and delivery.
• Responsible for drill down analysis of key business problems, interpret results, generate insight and recommend strategies.
• Analyze and condense complex data into a clear written report and to present a compelling argument to our US counterparts.

Feb 2010 – Feb 2011 · 1 yr · Noida Area, India

• Developed automated analytical tests in SQL and ACL for Derivatives Continues Audit to identify exceptions, control breaks and unique trends. This approach provides automated testing of an entire population of data and is replicated quarterly.
• Tests performed verified that:
• a) Transactions are executed by approved traders
• b) Transactions are executed with approved counter-parties
• c) Transaction concentration levels appear appropriate.
• Developed automated testing procedures for FAS 157 using hierarchies provided by Investments Finance to re-perform the FAS157 disclosure report. This will be compared to the disclosure report provided by SSKC in order to identify any differences.

Feb 2007 – Nov 2007 · 9 mos · Gurugram, Haryana, India

• Spend Analyzer Tool for Two Major airlines: In a project was responsible for a regular job of collecting, cleansing, classifying and analyzing expenditure data with the purpose of reducing procurement costs, improving efficiency and monitoring compliance.
• Credit risk scorecard model Major Asian/European Banks: In a project where the work involved cleaning the data, processing it, create statistical summary and writing observations by producing cross tabs and graphs using SAS. We helped the consulting team develop a state of the art risk scoring system to monitor and approve credit.

Nov 2005 – Jan 2007 · 1 yr 2 mos · Greater Delhi Area

• Creating/refining Excel templates and reports generations.
• Formatting/designing the files to make them look consistent and professional.
• Write a VBA code to automate a process of slicing / analyzing the data.
• Migrate data from Excel to Access where data sets are large or have relational structure & analyze it.

Jun 2004 – Jul 2004 · 1 mo · Greater Agra Area

• Summer internship at Indian Oil Corporation Limited Mathura Refinery.