Software Engineer Data

Chetna Mohapatra Fremont, CA

669-***-**** *********************@*****.***

Software Engineering graduate with 2.5+ years of experience in Business Intelligence domain involving data ingestion, curation, manipulation,visualization to furnish insights and analytics for data driven business decisions. Education

International Technological University, San Jose, CA Jan 2017- Apr 2018 Master of Science in Software Engineering GPA(3.80 continuing) Academic Projects

• Designed a Retail Sales DataMart using Star Shema Dimensional Modelling, developed ETL load scripts using Python and Oracle SQL to populate Customer,Product, Date, Promotion, Location Dimension tables using SCD concepts and daily and monthly Sales and Revenue Fact tables. Developed various Revenue and Cost KPI Reports using Tableau for insights generation.

• Built a Weather Reporting Application using Python, Redshift Database, Tableau Visualization and TWILIO API for SMS services.

Institute of Technical Education and Research, Bhubaneswar, India Sept 2009- May 2013 Bachelor of Technology in Electrical Engineering

Professional Qualifications & Technical Skills

• Data Processing • Python Numpy and Pandas • Data Mining

• Data Analysis • Software and Languages: SQL, Python • Regression Analysis

• Data Warehousing Scripting and Unix. • Data Structures and

• Data Visualization • Tools: Tableau, Talend, Microsoft Algorithms

• Tableau Reporting Access, Microsoft Excel, JIRA, • Clustering

• Business Intelligence Zendesk, Salesforce • Predictive Analytics

• ETL using Talend • AWS S3, EC2,Redshift Database • Big Data Analytics Professional Experience

Software Engineer Intern (Data) Dec 2017 – Till date Strikedeck, Sunnyvale California

• Gathering customer requirements in the business calls and preparing requirement documents.

• Working on customer related data sources as AWS S3 files, Salesforce, Redshift table and building data pipelines using Talend ETL tool, Python and SQL scripts to populate the various Fact and Dimension tables in warehouse in Redshift database.

• Analyzing the data using Python Pandas and NumPy, reconciling and testing with the source data. Created visually impactful dashboards in Excel and Tableau for data reporting by using Pivot tables and VLOOKUP. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.

Assistant Software Engineer (Business Intelligence) Dec 2013 – July 2016 Tata Consultancy Services, Bangalore, India (client Thomson Reuters)

• Interacted with the customers to analyze and understand the requirements on various financial products.

• Designed and built ETL pipelines using SQL/PL SQL to populate data models in EDW for business analysis and reporting.

• Generated various reports such as Daily/Monthly/Quarterly metrics of Product details, Order Details, Order Billing details, Customer Details, Account Details.

• Built and tested Tableau reports accessing Oracle database and SQL server database. Community Involvement

Student Coordinator for Event Management Team May 2011– Feb 2013 Institute of Technical Education and Research

• Involved in organizing various Socio-Cultural activities on campus and was a member of the Genesis Team involved in organizing the Tech fest on campus.

Contact this candidate