Engineer Data

Tejaswini Nama

**** ****** ***** **, *** ***, Irving, TX-75038

Email: *********.****@*****.***, M: +1-972-***-****, LinkedIn: https://www.linkedin.com/in/tejaswininama/

EXECUTIVE SUMMARY

A result oriented professional with 3+ years of experience as a Systems Engineer, managing projects with clients under banking domain would like to leverage her skill set as a Full-time employee in the areas of ETL and Business Analytics.

Expertise in developing strategies for Extraction, Transformation, and Loading (ETL) mechanism using Ab Initio.

Proficiency in Database systems like SQL Server, Oracle, Teradata.

Competent in Business System and Requirement Analysis.

Self-starter with great communication skills, quick learner and ability to work in teams.

EDUCATION

MS in Management Information Systems (MIS), University of Texas at Arlington, CGPA:3.25 Aug ‘16 – Dec ‘17

Courses: Data Science, Data Mining, Business and Economic Forecasting, Advanced Statistics, Database Management Systems, Analysis and Design, Project Management.

Current Courses: Big Data Analytics (Hadoop, Pyspark, Hive, Pig, MapReduce), Data Warehouse, Management Information Technologies Aug ‘17 – Dec ‘17

BE in Civil Engineering, VNR VJIET, CGPA: 3.5 Jul ‘09 – May ‘13

PROFESSIONAL EXPERIENCE Systems Engineer, Tata Consultancy Services Ltd. Dec ’15 – Aug ’16

Created 100+ Shell scripts, to delete previous month input files and replace them with new input files, to notify client via email the status of graph success and explanation behind failure which is particularly helpful for BAU (Business as Usual)

Developed highly generic parameterized graphs which can be used dynamically.

Developed complex Ab Initio XFR’s to derive new fields.

Proactively tuned applications to minimize execution time and improved performance of code.

Systems Engineer Trainee, Tata Consultancy Services Ltd. Dec ’14 – Dec ‘15

Handled design, development, testing, and supported project implementation.

Scheduled and monitored jobs through Autosys (Job Scheduler).

Created load Ready Files and validated the results.

Involved in end-to-end data validation with continuous business interaction.

Generated the output files, pushed them into Risk Datamart and stored in both Risk and Treasury containers.

Performed migration of data from various Databases like Oracle 11g, Sybase to Teradata.

Assistant Systems Engineer Trainee– Tata Consultancy Services Ltd. Jun ’13 – Dec ‘14

Involved in requirement gathering of project.

Worked on data extraction from various databases (excel, SAS Datasets, Sybase, Teradata, Oracle, EDW) and sorted down into Delimited files which were considered as input files for the ETL process.

Performed data cleansing and applied transformations as per the requirements of the project.

Extensively involved in Ab Initio graph development, testing, and performance tuning.

ACADEMIC PROJECTS

Social Media Analytics – Python, UTA

Worked on project to analyze people’s sentiment and topics discussed about the newly formed American Govt., Used Twitter API to collect tweets about Trump, conduct sentiment analysis to see the kind of topics are discussed. Created word clouds and conducted topic modeling on the collected tweets. Saw the geographic variation in opinions, by collecting tweets from 5 different states and conduct the analyses and gave insights based on the conducted analysis.

Pokémon Go! Analytics – Python, UTA

Pokémon Go! a famous augmented reality (AR) game was taken to understand the success of the mobile app game. Did web scraping, construct a Pandas data frame, explore/visualize the numeric data, build machine learning models to predict the app’s review counts and finally analyze the app’s screenshot images using deep learning.

IMDb Movie Analysis – Python, UTA

Led a team of 3 to understand an online database of information related to movies, investigated the dataset to understand how genres, directors, and other variables affect the gross and IMDb score for a movie and predict the success of the movie before the release.

Prediction of the Legitimacy of a Website – Weka, UTA

Led a team of 4 to predict the legitimacy of the website. Worked on cleansing the data, understanding the most important attributes that help in the prediction, ran the classifiers that helped in the prediction.

SKILLS

ETL Tools

:

Ab Initio, Informatica Power Center

Programming Languages

:

Python, Unix Shell Scripting

Data Analysis Tools

:

R, Tableau

Database Systems

:

Oracle 11g, Teradata SQL Assistant 13.0

PM Techniques

:

Agile PM, Scrum PM, Waterfall PM

Utilities and Tools

:

MS Office Suite, Open Office Suite

Scheduling tools

:

Autosys

EXTRA-CURRICULAR ACTIVITIES

Been actively part of M.A.D (Make a Difference) teaching life skills which empowers children living in orphanages to discover their true strengths and unleash their full potential.

One of the founder of FUN @ WORK in TCS, Hyderabad, India, April 2014. Organized recreational activities, to maintain good social relationship among the associates.

References available on request

Contact this candidate