SEARCH

Systems Engineer Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
SYSTEMS ENGINEER
Skills
  • Java, C, C++, Shell Scripting, SQL, PL/SQL,C#.NET,R, Python
  • Database:
  • Oracle 11g, Teradata Eclipse, Putty, Visual Studio
  • Team Foundation Server, SVN
  • Operating Systems:
  • ETL Tools:
  • Reporting Tools:
  • Big Data Technologies
Experience
01/2017 to 01/2017
Company Name
  • Designed and implemented Database Management System using ER Diagram and SQL queries .The main objective of this project is to create a Database in Normalized form.
  • Relevant Courses: Data Mining, Machine learning, Big data: Storage, Analytic and visualization, Advanced Database systems, Advanced algorithms and data structures,Advanced Comp Networking& Security.
06/2014 to 08/2016
Systems EngineerCompany Name － City
  • Windows, LINUX,UNIX Informatica, DMX-h Express, SSIS SSRS, Business Objects, Tableau Having 1+ years of experience on ETL Testing - Banking domain.
  • Involved in the preparation of test cases, generation & execution of test scenarios, testing data in files through UNIX using Hadoop concepts like developing HIVE scripts and Map Reduce jobs using DMX-h Express depending on the requirements, reporting mechanism of bugs based on Functional Requirements.
  • Involved in discussions for Requirement Analysis and Gathering.
  • Involved in preparation of Test cases and test scripts.
  • Involved in different projects that are handled by our team like testing Migration Projects, Regression projects and BAU Projects etc.,.
  • The scope of Conversion projects includes.
  • In Hadoop validations, files from edge node and HDFS will be validated using Hadoop ETL tool DMX-h by preparing Map reduce tasks and executing these tasks using Unix shell scripts or by loading the same file data into Hive table and validating using Hive scripts.
  • In Mainframes validating file data by loading the data into lower environment Teradata tables using JCL and validating the tables using SQL queries in Teradata queries.
  • The scope of Regression projects includes testing the dependent systems/applications that are dependent on code change system/application using Mainframe jobs.
  • BAU testing includes creating a replica of production environment and testing the data.
  • Documented bugs found during the process of testing.
  • Defects entered, tracked and maintained with Quality Centre.
  • Mapped requirements to test cases.
  • Involved in Prod installation by testing the data during installation in parallel along with the DEV team and thereby ensuring the successful completion of install.
ETL DeveloperCompany Name
  • UPS BI is a heterogeneous system where the data is stored across multiple data sources and formats i.e.
  • Flat files, web services, Mainframe.
  • These heterogeneous sources are used to build the data warehouse.
  • SQL Server 2012 Integration Service (SSIS) will be used to load the source data from different data sources in to Staging and Data warehouse further reports are generated out of DW using SQL Server Reporting Services (SSRS).SSAS is used to analyse and making high level decisions.
  • Responsibilities:.
  • Databases - SQL Server 2012 to Create Stored Procedure, Functions, Queries for ETL design and generating SSRS reports.
  • Have done work on Stored Procedures, Queries in SQL server etc.
  • Have used SSIS for ETL process and SSAS for creating cubes (to analyse data).
  • Have used SharePoint 2013(Power view, SSRS and Excel) for reports.
  • RAA-Random Assessment Application (Initial Learning Program-TCS) Have trained in Business Intelligence and performance management.
  • Have done a small projectto determine Key Performance Indicators(KPI's) for a Retail Store which is located in across the country.
  • Worked on Informatica tool for ETL and Business Objects for reports generation.
  • Extensively used Transformations like Router, Aggregator, Joiner, Expression, Lookup, Update strategy, Sequence generator and Filter.
  • Hands over expertise on cleansing and merging part making Dashboards and Charts.
  • Academic Project: Vector Space Approaches for Face Recognition: Summer-2017 In this project we have implemented Principal component analysis (PCA) Fisher's Linear Discriminant Analysis (LDA) for Face recognition.
  • I have used python as programming language.
  • In this project I have learned some basic vector space techniques in machine learning.
  • In addition, I have seen the difference between unsupervised learning(PCA) and supervised learning(LDA).
Education and Training
Dec 2017
Master of Science: Computer ScienceUniversity of Central Missouri － City, StateComputer Science 3.88
May 2013
Bachelor of Engineering: MechanicalMechanical
VNR Vignana Jyothi institute of engineering & technology, INDIA Cumulative GPA3.53
Skills
C#.NET, Academic, Banking, basic, Big Data, BI, Business Intelligence, Business Objects, C, C++, Charts, Conversion, Version Control, Data Mining, data warehouse, Databases, Database, Database Management System, Eclipse, edge, ETL, Functional, IDE, Informatica, Java, JCL, LINUX, Machine learning, Mainframe, Mainframes, Excel, SharePoint, Windows, Migration, Networking, Operating Systems, Oracle, PL/SQL, performance management, Programming, Python, Quality, Express, reporting, Requirement, Retail, Router, scripts, Shell Scripting, SQL, SQL Server, strategy, Tableau, tables, Teradata, UNIX, Unix shell scripts, view, Visual Studio
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • University of Central Missouri

Job Titles Held:

  • Systems Engineer
  • ETL Developer

Degrees

  • Master of Science : Computer Science
    Bachelor of Engineering : Mechanical
    VNR Vignana Jyothi institute of engineering & technology, INDIA Cumulative GPA

Similar Resumes

View All
Systems-Engineer-resume-sample

Systems Engineer

Everett, Washington