Data Assistant

Heena Sharma

Arlington, TX *****, USA

Ph.: +1-682-***-****; Email: *****.******@*****.***: LinkedIn: https://www.linkedin.com/in/heena-sharma-812365187/ CAREER OBJECTIVE

To help organizations improve their Business or Technical processes by using various Analytical techniques. To contribute to the growth of the organization and to be committed and deliver best results over expectation. EDUCATIONAL BACKGROUND

University of Texas Arlington, United States of America Aug’19- Present Masters’ of Science in Information Systems GPA: 3.67 Programming Proficiency: SQL, Python (pandas, scikit-learn), JavaScript, XML,R, SAP, Web Scraping Tools/Technologies/Platforms: JIRA, Informatica Cloud, Linux, Teradata, SAP Business Objects and Data Services, Tableau, ERWIN Data model, Power BI, Batch Script, BTEQ, Shell Script, Amazon AWS, Microsoft Excel, SAS, PowerPoint. RDBMS: Teradata 14, Teradata 14.10, Teradata 15, Netezza, Oracle Other Tools and Utilities: Data Mining and Visualization, Fast Load, Teradata Tools and Utilities, Teradata SQL Assistant, Teradata Administrator, Teradata Viewpoint, BTEQ, Teradata Parallel Transporter Wizard 15.0, AGILE framework methodology, DEVOPS. Domain Knowledge: Finance, Marketing, Data foundation Integrated Datawarehouse, E-commerce, Networking Languages: English (Fluent), French (Intermediate), Hindi (Fluent), Marathi, Guajarati WORK EXPERIENCE:

TERADATA CORPORATION, San Diego, California – Data Architect Intern 05’20 –12’20 o Responsible for developing robust pragmatic data models that meet requirements while supporting the data architectural design principles and designs of the broader IT organization. o Building the enterprise conceptual, logical, and physical data models for analytics, operational, and reporting structures in accordance to Teradata’s industry best practices. Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community.

o Working with consultants to translate LDMs and Semantic Models into their physical representations. Technical Associate, TERADATA India Pvt Ltd., Mumbai - ETL SQL Developer 04’15 –07’19 o At least 3 plus years of experience in Data ware housing (DWH) concepts, ETL Process, Design and Implementation and source code management, Database Management Systems, RDBMS, SAP BODS and Agile process. o Competent in Deployment and Operation of Large-Scale Networks, integrating automation to provide a scalable and cost- effective solution.

o Experience throughout the software development life cycle (SDLC) from strategy, planning, coding, building and testing through deploying, operating and monitoring.

o Capable of operating tools to automate tasks and manage configurations at a different stage of configuration delivery. o Experience in handling development, deployment and production issues, analyzing the root cause and fix the issue within the minimum turnaround time.

o Good Experience on Informatica Cloud for creating task flows, developing and implementing the mappings, Tableau, Teradata architecture, Teradata parallelism, Teradata Administration, Teradata Utilities. PROJECTS:

• Transcend IDW and BODS to INFA Migration Project, Mumbai, India - Team Lead /SME 06’17- 07’19 o Developed and maintained Informatica Cloud ETL jobs for data warehouses/marts o Worked in Migrating the existing jobs from BODS ETL data tool to Informatica Cloud to improve efficiency using SQL, Batch Script automation, BTEQ scripts

o Built automated tests using existing tools and frameworks to expose defects in product code using Agile testing methodology o Developed a fully automated dashboard using tableau to provide insights for retailers/wholesalers Product Sales availability

• Premier INC. (Data Integration and Migration Project) 06’16-06’17 o Successfully converted SQL codes and Scripts from Netezza (IBM RDBMS) to Teradata SQL o Successfully involved in Data Generation and data loading using Data Gen Migration Tool

• Developer / Database Administrator, Teradata Warehouse Development Project, Mumbai, India 05’15 -06’16 o Created databases for Staging area, Core and Semantic view. Created Roles according to the different types of user access requirements.

o Loaded the data into Staging area using Teradata utilities, generated DDL scripts to load data into Core database

• Ecommerce Executive at IKSULA, Mumbai, India 06’14 -04’15 o Conducted data quality checks for retail products and conducted working sessions with retailers to gather and document data of products to ensure client understands content-based processes. o Serviced Tickets (Zendesk) for issues related to uploaded products and communicated with image and content team for ways to improve process.

AWARDS AND ACHIEVEMENTS:

• Graduate Teaching Assistant at University of Texas at Arlington, 01/2020- 05/2020

• Awarded as Appreciation Certificate “Quarter Smile Award” from client for Revenue by Customer Project at Teradata.

• Received Employee of the quarter award for the quarter 1, 2017 at Teradata India Pvt Ltd.

• An Active Member at Data Analytics Club, University of Texas Arlington – 09/19 -Present CERTIFICATIONS:

• TD 14 Teradata Basic Certification (TEO-141) - 2015

• UDEMY course training in Python Basics and Linux shell course -2018

• AWS Business Professional and AWS Technical Professional -12/16 SKILLS: Good Communication, Problem Solving, Team building, Multitasking TECHNICAL SKILLS :

Contact this candidate