Sign in

Data Analyst

Jersey City, NJ
November 14, 2018

Contact this candidate


Mallika Singh

Jersey City, NJ, ***** +1-631-***-**** EDUCATION

Pace University, Seidenberg School of Computer Science & Information Systems New York, NY Masters in Information Systems GPA: 3.77 December 2018 Amity University, Amity School of Engineering & Technology Noida, India Bachelors of Technology in Information Technology GPA: 7.15 (10) May 2014 RELEVANT COURSEWORK

Database Programming Information Systems Design & Development Data Warehousing, Mining & Visualization Information Systems Project & Change Management Business Telecommunications Information Security Controls Big Data & Information Systems Business Analytics for Decision Making Database Design & Development of Web


Programming Languages: Basic Knowledge of C, C++, Java, HTML and PHP Software: Proficient in MS Office (Word, Excel, Power Point), Rapid Miner, Tableau, Hadoop, Power BI, Jira, MS Teams Database: Operational Knowledge of MySQL, Neo4j, Sapient Synapse ACADEMIC PROJECTS

Extracting and Analyzing Twitter data using Hadoop February 2018 – May 2018

Extracted data from Twitter Search API using R and stored it in HDFS to make it available for querying using Hive to find the most active user and the most frequently used words

Implementing Different Techniques of Computer Forensics September 2017 - December 2017

Implemented techniques such as Data Carving, Index Search and Live Search using Forensic Tool Kit to encrypt and decrypt data Pace Online Examination System February 2017 - May 2017

Implemented a web application to allow students to take exams online and faculty to manage results as well as input student records Lost Mobile Tracking System with Remote Security January 2014 - May 2014

Created an Android application to send the location of a lost mobile phone to user by tracking GPS coordinates EXPERIENCE

Lazard Freres and Co., LLC New York, NY

IT Intern- Emerging Technology & Data Analytics March 2018- Present

Worked with RPA platforms such as Automation Anywhere, Kofax KaPow and WorkFusion to create bots to automate manual processes related to web scraping, data entry, downloading reports from FactSet and creating company profiles

Researched latest emerging technologies related to AI and analytics platforms that could be incorporated within the organization, and created an Excel database for the same

Created an interactive dashboard using Power BI to track the themes, trends and testing stages of technologies in the Emerging Technology and Data Science teams

Researched and prepared an assessment for various collaboration tools that can be used within the firm

Assessed whether Neo4j graph database can be used as a possible Master Data Management system for Client Institutions data

Created Technical Documentations and Data Dictionary for the Shareholder Tool and the Relationship Disclosure Tool

Created a Staffer Tool web application for analysts to replace the manual process of staffing hours worked on projects

Automated process of sorting and creating charts by industry and sector for M&A data with the help of Excel macros

Created a Power BI dashboard from HR data to track employees across regions, corporate titles and hiring dates HCL Technologies Limited, Infrastructure Services Division Noida, India System Analyst November 2014 - January 2017

Provided technical support for Dr. Pepper Snapple Group (DPSG) by managing network data and voice related issues for more than 100 sites in the US and handled user tickets using the tool, BMC Remedy

Worked as part of the Critical Incident Management team to handle high severity issues and monitor database and storage alerts

Worked with UC4, Cisco and Avaya phone systems, and managed vendors to troubleshoot issues

Acted as team lead in the absence of manager for three months to supervise staff JCB India Limited Haryana, India

Intern May 2013 - June 2013

Studied the SAP ERP System of the organization to help maintain records of people entering the organization ACTIVITIES AND HONOURS

Awarded Best Employee in the ‘Above and Beyond Expectations’ category while working in DPSG Project

Participant, Confluence 2012- The Next Generation Information Technology Summit

Participant, Big Data Analysis Workshop

Participant, Imagine 2018: Automation Anywhere conference

Participant, E&Y Business and Accounting Insights Summit

Wrote a Research Paper on How to Manage Risks in IT Projects LANGUAGES

Fluent in English, French and Hindi

Contact this candidate