Snigdh Resume
- 1. SNIGDH JHA Mobile: 9999665475 E-Mail: snigdhjha@yahoo.co.in Website: http://www.snigdhjha.wordpress.com Objective: To achieve professional excellence and growth in career in line with organizational growth and maximize my potential in providing Analytical advice and services to clients. Location Preference: Delhi and NCR Academic and Professional Credentials MBA (Marketing & International Business) from GIBS (GGSIPU- Delhi University) in 2012-2014 with 84 % B.TECH(E.C.E) from NIET Gr.Noida (UPTU-AIEEE) in 2008-2012 with 74 % 12th St. ANGELS SCHOOL, Delhi (CBSE) in 2007 with 73% 10th GREEN FIELDS SCHOOL, Delhi (CBSE) in 2005 with 77% Achievements Won 1st position in Brand War Inter College competition held on 13th Feb ,14 in GIBS , GGSIPU Delhi. Won 1st position in Inter College ad making in NIEC (Inflore 2014), GGSIPU Delhi. Won 3rd position for Intra College Symposium on National Education Day on 11th Nov, 2013 in GIBS, GGSIPU. Won 1st position in Brand War Intra College competition held on 11th Oct13 in GIBS, GGSIPU Delhi. Participated in CHANAKYA, 17th Student Management Games , a National Online Business Stimulation game organized by A.I.M.A in N.D.I.M , New Delhi from 17th Sep , 2013 to 18th Sep , 2013 . Won 3st Position in One-to-one conversation in French Language in BVPIR, Delhi 2013. Won 2st position in Inter College Bankwire event at NIEC, GGSIPU, 2013. Won 1st position in Intra college technical paper presentation on Web Hosted Contact Center Solutions by Cloud Computing organized by N.I.E.T 0n 12th March, 2011. Presented Paper on Cloud Computing organized by I.G.I.T Kashmere Gate.- New Delhi on 24th March , 2011 Qualified N.E.S.T 2009 (NATIONAL ENGINEERING and SCHOLARSHIP APTITUDE TEST.) Received AMUL VIDYA BHUSHAN award from Amul for academic excellence in 2007 Received Accolade of CBSE 2007 award for scoring highest in Physical Education in North-Delhi Zone. Represented as Head Boy in School Student Council. Technical Skills MS office(Power Point ,Excel, Word, Access) C, C++ , SQL Server, MySQL Expert in Excel such as:- (PivotTable,PivotChart,Sorting,Formula(Vlookup,Hookup,Sumif,Countif,Match,IFFormulas,IfError,Averag e,Count,CountA,Trim,Len,Upper,Lower,Proper,AND,OR,Left,RightRound,Date, Charts (Bar, Column, Line, Pie, Area, 3d), Graphs, Data Validation (List, Error Message), Text to column, Filter Microsoft Excel VBA Programming :- Excel VBA Programming & Coding, Create Macro, Variables, Visual Basic Editor, String Manipulation, Function and Sub, Loop, If Then Statement, Select Case, Range, Cells, Date and Time, Workbook and Worksheet, Objects, Properties and Methods, Msg. Box, Macro Comments, Macro Security, Excel Macro Recorder Etc. SAS:-Overview of SAS, Reading raw data from other files into SAS, Performing Arithmetic, Character and Date time Functions, Performing Conditions and Loops, Merging and Concatenation.
- 2. Working Experience Business Analyst (Strategic Initiatives) - Make My Trip (Gurgaon, Haryana) Nov 2015 Till Date The role is majorly about providing vital information/data analysis and interpretation to Hotel Contracting department and various stakeholders enabling them to take strategic business decisions. Part of Strategic initiatives team which provides crucial data for reviews with the leadership team. Duties Involved Leading MIB (Money In Bank)-team of Hotel Contracting Make My Trip (India) consisting of more than 800 PAN India Hotels. Develops models for PAN India Business Managers for effective business growth and Analyzing City behavior via predictive analysis. Working with senior leadership in providing information and recommendations for improvement on the basis of data analysis. Data verification on applications and data cleansing activities. Working with different teams to drive overall data reporting activities. Coordinating and communicating with Business Heads for Growth & data capturing, validation and reports Downloading the data from MySQL database by writing basic SQL queries to mine/extract data for the purpose of report-making and competition mapping Using complex Excel functions like Vlookup, Match, Sumif, Countif, conditional formatting, Filter, Advance Filter, Format cells, Data Validation & making use of Pivot tables etc to clean & analyze the data. Working closely on a project with Technology team for Automation in Extranet Adoption for PAN India Hotels and city level Business Managers. Involved in various internal IT Automation projects for making the system flow smooth in creating test cases for manual testing. Provides reports to Directors/ Associate Directors and Senior Vice President with information and support for effective decision making, and provides feedback on daily operations. Business Analyst Convas Verity Services Pvt. Ltd (World Trade Centre, New-Delhi) May 2014 Oct 2015 Responsible for scoping and analyzing the business requirements and developing solutions with end users, IT staff and cross-functional teams to improve business. Duties Involved Handling Google analytics account for companys new ecommerce website. Proficient in Data Management and Data Analytics. Creating Branding, Business, and Economic, Marketing and Technological insights and Blogs for website. Creating Client Case Studies by analyzing the business challenges and coming out with relevant solutions. Efficient in strategy consulting, corporate planning, corporate communication management and predictive modeling. Proficient with MS Excel and SQL Expertise in automation of report generation process using SAS & VBA to understand and analyze data for industry. Preparing relevant reports, MIS updates as per scheduled and requirements with data crunching. Collating business requirements, then translating these into functional specifications and detailed test plans.
- 3. Planning business analysis activities, creating business IT road maps and solutions to client case studies. Providing process definition, defect correction, documentation, and analytical solutions to new and existing clients. Write up and maintain complete and accurate business process documentation. Managing the work from initial request through estimation, approval, requirements, build and implementation. Preparing Business Data Collection, Data Analysis, Modeling and Reporting applying SAS, MS OFFICE, VBA and SQL. Researching on Big-Data Analytics and preparing vendor dashboards for an upcoming ecommerce website. Identifying new opportunities to increase efficiency and performance by implementing new designs within the Business Operating Model. Working to automate repetitive tasks and processes in order to maximize performance. Trying to gain an in-depth understanding of the companys customers. Involved in developing the implementation approach and managing bigger clients from all business areas. Internships SUMMER INTERNSHIP TRAINING (M.B.A) Company INDIAN OIL CORPORATION 4th June 2013 to 20th July 2013 Topic CUSTOMER SERVICE - A FEEDBACK (DELHI DIVISIONAL OFFICE) SUMMER INTERNSHIP & INDUSTRIAL TRAINING (B.TECH) Company INDIA TODAY GROUP DIGITAL 1st July 2011 to1st Aug 2011 Topic DIGITAL CONVERGENCE Mobile and iPad applications (RESEARCH AND DEVELOPMENT TOWARDS MOBILE DOMAIN) Seminars Attended Participated in Seminar on NANO TECHNOLOGY organized by Carlsys Technologies held at Noida Institute of Engineering and Technology on 15th November, 2009. Personal Vitae Fathers Name: Mr. Shyama Nand Jha Permanent Address: E-5/117(G.F), Sec.-16, Rohini, Delhi-110089 Date of Birth: 2ND Dec, 1990 Languages Known: English, Hindi & French