NEHA AERI
Email: ****.****@*****.*** Mobile No: +1-804-***-****
SUMMARY
• 3+ years of progressive Business Analysis work experience and expertise in research tools & techniques with professional qualifications in Engineering, MBA and CFA Level-I certification
• Led BA activities for data mining and analysis solution implementation and enhancement projects
• Proficient in complex SQL and relational databases such as Teradata, MS-SQL Server 2008, Oracle 10/11g
• Extensive experience working with North American clients across all phases of software development lifecycle in Waterfall, Agile and Iterative projects and leading & directing geographically distributed teams
• Expertise using business analysis techniques - conducting requirement workshops, brainstorming, interviews, business process modeling, scenarios and use cases
• Expertise in creating & reviewing business requirement documents, functional specifications, use cases, test plans and leading system and acceptance testing activities
• Dynamic & highly motivated self-learner with good communication skills EDUCATION
PhD Student in Management w Major in Information Systems Katz Graduate School of Management, University of Pittsburgh, US Relevant Electives: Data Analysis using Python and R, Stat 2: Analysis of Variance, Applied Regression Analysis, Experimental Design, Applied Multivariate Analysis, Hierarchical Linear Modeling, Applied Econometrics (using Stata), Network Security
Master of Business Administration w Major in General Management Indian Institute of Management Ahmedabad, India
Relevant Electives: Business Research Methods, Corporate Finance, Financial Markets, Financial Reporting & Analysis, Market Research, Written Analysis and Communication Bachelor of Engineering w Major in Electronics & Electrical Communication Panjab University, India
CERTIFICATIONS
CFA Institute
Passed CFA Level-I June 2014
NSE ACADEMY’S Certification in Financial Markets (NCFM) Certifications in Financial Markets, AMFI- Mutual Funds Module, Derivatives Markets PROFESSIONAL EXPERIENCE
Research Assistant – University of Pittsburgh May-2015 to Present Key responsibilities:
• Identifying suitable techniques for the collection and analysis of data
• Data coding, data entry, transcribing, data analysis & assistance with writing up
• Assisting in the development & preparation of continuing funding opportunities
• Integrating, improving, and analyzing large databases using Excel, SPSS and R
• Supervising undergraduates by organizing responsibilities, designing and coordinating experiments Manager, Gujarat State Fertilizers & Chemicals Ltd. Apr-2013 to Oct-2014 Gujarat State Fertilizers & Chemicals Ltd.is a Fortune500 India company providing crop nutrition solutions and engaged in agronomic development activities with a pan-India presence, large scale marketing network and international operations
Key responsibilities:
• Worked as a Marketing Manager handling Market Research & Analysis along with Business Development
• Analyzed the growth drivers and challenges in agri-inputs business for expansion in North India
• Prepared overall strategic road map for the company in North India including 7 states Page 2 of 3
• Development of new channel of dealers and retailers as alternative channel in Gujarat and other states
• Strategy planning and category mapping for the sales and product department
• Co-ordination with sales and supply-chain department for effective execution of marketing strategy
• Analyzed sales trend and accordingly improved or amended marketing plans
• Coordinated with consultants from KPMG and National Institute of Design for strategy development
• Prepared MIS reports and provided inputs to improve management reporting Business Analyst, Accenture Feb-2010 to March-2011 Project: Data analytics and data mining solution for a leading North American healthcare client for tracking performance details of individual agents to maximize customer contact center usage Project highlights:
• Determined & documented reporting requirements of business
• Performed requirement analysis including requirement prioritization, organizing requirement, specifying and modelling requirement, documenting assumption and constrains, verifying & validating requirement
• Prepared Level of Effort in terms of hours and dollar amount needed
• Translated business & stakeholder requirement to solution requirement and captured it in Functional Design Document (FDD) and Use Case Specification Document
• Created data flow models using modelling tools such as Microsoft VISIO
• Received Business Sign-off
• Conducted structured walkthrough to development and testing team
• Assisted Development team in preparing Technical Response, Unit Test Case Document (UTC) and Technical Design Document (TDD)
• Assisted Testing team in preparing test scenarios and test cases
• Coordinated with business for any support needed by development/ testing during any phase of SDLC
• Conducted daily triage discussion calls with Dev and test team
• Worked with development team to create standard Report Templates for IVR and Genesys
• Created reporting metric mapping document showcasing the formula used to derive the corresponding metric and its business description
• Troubleshoot anomalies in reporting data by validating the database through SQL queries
• Daily status update to onshore team/Client by means of dashboard report
• Provided functional support to team members and functional training to new team members Software Engineer, Accenture Aug-2009 to Feb-2010
Project: Data management and reconciliation solutions for a leading North American Investment Bank Project highlights:
• Responsible for gap analysis, requirement gathering & user training
• Developed, implemented and maintained a New Portfolio Management application
• Reduced team effort by designing and developing a number of applications with proper documentation
• Saved 2 hours per week of support teams by developing automatic trade reconciliation reporting tool
• Conducted Level-1 Internal Training in Capital Markets at IDC (India Development Centre) level
• Single-handedly developed the platform for employee’s self-training and skill up gradation for Accenture TECHNICAL SKILLS
• Domain areas: Commercial banking, Retail banking, Healthcare, Telecommunication solution provider, Logistics, Business process outsourcing, Professional services
• Functional areas: Customer Relationship Management, Sales, Service management, Campaign and offer management, Risk management, Basel compliance, Finance and accounting
• Tools: MS Office Applications (Visio, Word, Excel, PowerPoint), SPSS, Stata, Python, R, C/C++, Java, PL/SQL, Toad for Oracle, TeraData/SQL Assistant, Eclipse, MyEclipse, RubyMine
• Trainings: Agile for Business Analysts - Role of the Product Owner, Facilitation Techniques for Requirements Development, How to Gather and Document User Requirements INTERNSHIP & INDEPENDENT PROJECTS
Forum for Industry Interaction (FII), IIM Ahmedabad Oct-2012 to Feb-2013 Page 3 of 3
Forum for Industry Interaction is a student run management consulting company at IIM Ahmedabad which maps companies’ requirements and students’ expertise to ensure optimum solutions for real-time challenges
• Worked on a project to develop an algorithm to select new geographical locations for dairy business expansion of one of the top 100 social ventures in India
• Performed a market analysis of the dairy sector in India along with study of the best practices Excel Crop Care, International Business Division May-2012 to Jul-2012 Excel Crop Care provides end-to-end solutions in agriculture sector across more than 70 countries Key responsibilities:
• Performed sector and competitor analysis for crop protection sector with leading companies worldwide
• Worked on Brand Strategy & communication mix to differentiate company's number one brand in Africa
• Recommended changes in internal operations by conducting primary research in India and Africa
• Appreciated by senior management - Recommendations to be implemented in strategy building AWARDS AND RECOGNITIONS
• Appreciated by client for impressive presentation to senior director level associates on complex solutions
• Rated outstanding performer and “Highly effective” in annual performance appraisal for excellent business analysis skills, proactive attitude, ability to adapt to dynamic work environment and perform under pressure
• Received Celebrating Performance awards at Accenture for multiple useful contributions across verticals
• Won an international virtual Mutual Fund management competition held at a top business school