SHIKSHA GUPTA

**** * **** *****, *** ***, Chicago, IL- 60616

Phone: 317-***-**** Email: ac66x6@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/guptashiksha/ GitHub: https://github.com/sgupta57

Skills

Languages

Python, R, SQL, C, C++, JAVA, Shell,

HTML, CSS, JavaScript

Database

MySQL, DB2, MongoDB, NoSQL

Tools

Git, Anaconda, Jupyter Notebook, MS Project, TOAD, MS Excel, Putty, Web Intelligence Reports, Tableau, Crystal Reports, SSIS, SSMS, SSRS, Eclipse, FTP/SFTP, JIRA, EMR, Amazon S3, RedShift, EC2, REST APIs

Other Tech Skills

UNIX, AWS, Chameleon, Business

Objects, Big Data

Operating Systems

Windows, Linux

Work Experience

BUSINESS INTELLIGENCE DEVELOPER Tata Consultancy Services Limited, Bangalore, India 01/2015 – 07/2016

● Development and maintenance of data mart to extract, load and transform (ETL) the data using SSIS packages.

● Developed reports in WEBI (Web Intelligence) and Crystal reports to support the ad hoc reporting needed to analyze current business intelligence or customer trend data to support recommendations for action.

● Performed ad-hoc requests for clients using customized SQL queries to collect and present information to satisfy clients and contributed to achieving organizational goals.

● Analyzed the reports to provide visual representation using Tableau for decisions making process to increase profit. BUSINESS INTELLIGENCE ANALYST Tata Consultancy Services Limited, Bangalore, India 03/2013 – 12/2014

● Involved in cleaning and transforming the data using python libraries such as NumPy, Pandas, and Scikit-learn.

● Developed visually impactful dashboards for data reporting by transforming data into actionable items.

● Managed tickets using JIRA and resolved the issue by troubleshooting it using Python and SQL within the given SLA.

● Automated the daily tasks by writing SQL procedural queries which reduced the monitoring task by 40 percent. BUSINESS INTELLIGENCE INTERN Tata Consultancy Services Limited, Bangalore, India 12/2012 –03/2013

● Professional Training specialization in Python, PL/SQL, Database, ETL tools, Tableau and AWS.

● Developed REST APIs in python to interact with MySQL database for managing customer records.

● Maintained database and requirement documentation including data dictionary and metadata definition storage. Education

MASTER OF SCIENCE IN COMPUTER SCIENCE Illinois Institute of Technology, Chicago 08/2016 –05/2018

● Courses: Cloud Computing, Online Social Network Analysis, Data Preparation and Analysis, Data Analytics. BACHELOR OF SCIENCE IN INFORMATION SCIENCE Visvesvaraya Technological University, India 08/2008 – 05/2012

● Courses: Software Development, Web Development, Database Management, Data Structures and Algorithms. Academic Projects

COLLECTING POLITICAL SOCIAL NETWORK USING TWITTER API

● Used Twitter API to construct a social network for 4 U.S. Presidential candidates using their account information.

● Analyzed the number of shared accounts followed by each pair of candidates to find some interesting information.

● Used libraries such as Networkx, Matplotlib to plot the links between them and print stats of resulting graph for analysis. SENTIMENT ANALYSIS USING TWITTER DATA

● Fetched friends and tweets for 10 popular singers using Twitter API using their account information.

● Performed community detection using modified Girvan-Newman algorithm for identifying clusters in network.

● Performed sentiment analysis on the tweets of 10 popular singers to find if the tweets are positive, negative or neutral. DATA ANALYSIS OF CLIMATE CHANGE ON HUMAN BEHAVIOR

● Retrieved the data for crime rate in Chicago and climate change data from different websites.

● Analyzed crime rate and climate change data using R and its packages to find the relationship between them.

● Used Tableau for visualization of the data by generating dashboards and Tableau reports on different metrics. COMMUNITY DETECTION AND LINK PREDICTION ON FACEBOOK ‘LIKE’ DATA

● Using Girvan Newman Approach, found communities from the Network Graph that was formed by the collected data.

● Made the comparative analysis using link prediction after deleting few links on the graph to suggest new friends. CRIME RATE PREDICTION

● Implemented Decision Tree, Linear Classification and Regression models to predict crime rates around the country.

● Trained, tested & calculated most predictive features on dataset and compared every model’s performance. BENCHMARKING CPU, MEMORY, DISK AND NETWORK ON AWS CLOUD

● Implemented CPU, Memory, Disk and Network benchmark code in C to measure latency and throughput over AWS.

● Used strong-scaling, AVX instructions and multithreading to compare results on different Amazon EC2 instances. TERA-SORT USING HADOOP AND SPARK USING AWS CLOUD INSTANCES

● Set up a 16-node virtual cluster on Amazon EC2 and configured Hadoop and Spark on these instances.

● Performed TeraSort in JAVA on 128 GB, 512 GB and 1 TB file using Hadoop and Spark individually on AWS.

Contact this candidate