Curriculum Vitae- Pranav Tripathi

Resume: PRANAV TRIPATHI Contact Details Mobile: 9807545449 E-mail: [email protected] Past Experience and Objective:   

Seeking work in the field of Research, Data Analysis and Data Mining. Owner of YouTube channel: The Info Simplifier (TIS) Freelance Author. Former Systems Engineer at TCS, worked for six years.

Freelance Work Experience:________________________________________________ YouTube:  Owner of channel The Info Simplifier (TIS).  Knows Video editing using tools like Da Vinci 15 and Active Presenter. Authorship:  Authored following eBooks available on Amazoni. India’s Foreign Relations and Issues of National Importance. ii. Data Warehousing (including basics of SQL and Informatica PowerCenter).  Occasionally looks for guest lecture in the subjects of International Law and Foreign Relations. Education:

______

Professional Qualification: Post Graduation PGDM (with 72%) specialization in Financial Markets Year of Passing : 2017 College : National Institute of Financial Management, Faridabad (An Institute of Ministry of Finance, Government of India) Professional Qualification: Graduation B.Tech (Honours with 79.28%) specialization in Electrical & Electronics Engineering) Year of Passing : 2010 College : Integral University, Lucknow. PGDM (Financial Market):_______________________________________________ Duration : 1 year Subject of interest :  Data Analysis and Mining in Macroeconomics.  Working knowledge of Bloomberg as well as Excel, PPT and MS Word. Certifications in Finance:

 NISM-Certifications  Bloomberg Market Concepts (BMC) certification Achievements:  Research Paper based on “Environment, Forests and Natural Resources-Management” selected by SUSCON6 committee of IIM Shillong.  CCC Certified, MAT qualified.  Able to do Hindi typing @ 25 WPM in Mangal font. TCS Work Experience:_____________________________________________________ Joining Date Leaving Date Total Work –Ex

: 15 Nov, 2010 : 24 Sep, 2016 : 5 year 10 months

Work domain: Datawarehousing, Business Intelligence and Performance Management (BIPM) Primary IT skills :  ETL Tool- Informatica PowerCenter (9.1)  Database Oracle (10g)  Linux Shell scripting.  PL/SQL programming Routine Work Experience :  Worked as a developer in two Data Warehousing projects for the development of: o Operational Datastore (ODS) in a CoE project o Finance Datamart in an Agile project. Technical description Domain Experience

:

Business Intelligence and Performance Management (BIPM). Worked in two Data Warehousing projects using tools Informatica (9.1) and Oracle Database (10g) along with Linux Shell Scripting. Management 1. Managed various interfaces of Alignment interface such as Worker, WorkerExperience Sales Area, EMAT, Customer-Territory, Geography alignment, Call Commitment. 2. Maintained Project Status Report of Finance Datamart by consolidating data from various multi-locational team. Business Independently developed Educational Material interface of Alignment project. Its Development business is based upon the fact that there are educational materials like pamphlets of doses used by Sales Representatives, the addition and expiration of which will be decided based upon the logic existing in this interface. Also had some hands on over the windows scripts used for loading worker, worker to territory, customer, hierarchy, and product alignments data from Organizational Manager tool to Alignment ODS via Adapter mappings. Certifications AHM250 Certification pursued in Healthcare domain.

Engineering:

_____________________________________

Achievements :  GATE Qualified silver medalist in graduation.  On-Campus selection in Tata Consultancy Services (TCS). Summer Training :  Completed Summer Training at 132/33 KV substation of UPPCL, Gomti Nagar, Lucknow from 15 June, 2009 to 11 July, 2009. Project :  Final year project topic was Study of AC to DC Converters using MATLAB simulink. Myself and Extra-Curricular:

___________ _________________________________

Seminar Attended:  Data Science with Python Webinar (2019)  Annual Capital Markets Conference 2016 (Mumbai-2016)  Seminar upon topics such as PLCs and SCADA (2010), Power Scenario in U.P. (2010). Seminar Given:  Delivered seminar on the topic: - Current Conveyors during graduation. Important Visits and Travelling Experience:  Visited Singapore on five day study trip which included Singapore Stock Exchange and Bloomberg Office.  Visited Mumbai on three day study trip which included visit to conferences in RBI and SEBI Head office.  Visited Trivandrum for undergoing two and half month training in Data Warehousing during tenure in Tata Consultancy Services.  Visited Nanda Devi Biosphere Reserve, a UNESCO recognized site, in Uttarakhand as a part of eleven day long organized trekking. Important Readings:  The Rise and Fall of Nations (by Ruchir Sharma)  Mastering Modern World History (by Norman Lowe)  Hindi Literature- Books by Harishankar Parsai and Premchand. Declaration:_____________________________________________________________ I here by declare that the above information is correct to the best of my knowledge and belief. Place: Lucknow Date: 1-Oct-2019

Signature: (Pranav Tripathi)