Data Software

Purvi Patki

817-***-**** ************@*****.*** Arlington, Texas

Technical Skills

Programming languages : C#, Visual Basic, C, PHP, Java, Python

Databases : MS Visual Studio, MS Access, MS SQL Server, Oracle.

Operating Systems : Windows, UNIX, LINUX.

Tools/Editors : Eclipse, VBA, Macros, MS Visual Studio, MS Office.

Testing Tools : Junit, Jacoco & PIT.

Work Experience

Lear Corporation IT Analyst Aug 2017 – Present

•Test, maintain, and monitor computer programs and systems, including coordinating the installation of antiviruses. Administered LANs/WANs.

•Designed internal databases using the language SQL and evaluated queries for huge data sets.

•Built high level Application projects for Production and Materials department using Visual Studio 2017, C# language and VBA in Macros. Maintained various records and documentation for departments computer systems; wrote straightforward report generation programs.

•Installed and tested new products and improvements to the computer systems. Developed database model describing data elements and how they are used, following procedures using pen, template or computer software.

•Established procedures to back up data storage in the computers and provided technical support to production, quality, maintenance, shipping and other departments as needed.

Lear Corporation Systems Analyst Internship May 2017 – Aug 2017

•Collaborated with SharePoint team and internal IT team to assist in managing the current SharePoint 2017 environment.

•Supported high paced production lines running 24/7, building seats for General Motor Arlington operations.

•Used applied research, information gathering and analytical skills to complex activities and issues. Research involved selection of appropriate alternatives from identified options. Collection of customer needs and its translation to appropriate solutions. Tracked, maintained and produced regular and ad hoc reports.

•Role involved troubleshooting and support within the databases. Equipment configuration - PCs, Printers, Scanners, Windows server environments and thin client hardware running on Windows XP/XPE/WES7/WES9.

Corporate Business Solutions Data Analyst Internship May 2016 - May 2017

•Interpreted data, analyzed the results using statistical techniques and provided ongoing reports to business. (Cass report, qualification report, Postage statement)

•Performed data analytics and other strategies, which optimize statistical efficiency and quality, on FedEx, USPS data collection systems.

•Acquired data from primary or secondary data source clients and maintained database systems. Developed and updated the database schema using SQL.

Apartment and Residence Life Resident Assistant August 2015 - May 2016

•Utilized management and organizational skills for responsibilities like event management, handling complaints, and monthly audits.

•Was awarded RA of the Year 2015-16 for an outstanding performance.

University Tutorial Department Instructor August 2014 - May 2015

•Taught pre-calculus to freshmen students on campus. Did one-on-one tutoring for various subjects like English, math, political science, and economics.

Education

Bachelor of Science in Computer Science and Engineering

The University of Texas, Arlington Aug 2013 – Aug 2017

GPA: 3.43

Key Courses: Algorithm and Data structures, Database Implementation & Theory, Senior Design, Software Engineering, Software Testing, Theoretical concepts.

Projects

Design of Windows Application Graphical User Interface using C# Aug - 2017

•Designed and implemented a Windows Application GUI and a SQL database for keeping track of information about the Trailers going in and coming out of the Materials department at Lear.

•This was done using SQL server express to establish a connection between the database and the application. Visual Studio 2017 was used to create the application in which a user can enter the trailer #, shipping information etc. The application also provided the Inbound, Outbound and Pending Status reports. All the code was written in C# and database was managed in SQL language. Lastly, I tested the application with multiple error generation and resolving conflicts.

Design of Client User Interface using SQL Oct - 2016

•Designed a database within CBSI’s mailing software writing queries to add specific fields to database like zip code, state, tracking number barcode. CSV file contained 50,000 records with 50 columns or more which needed to be sorted as good data and non-deliverable record.

•This was done using the excel functions like to combine and remove bad data. Concatenation, text to columns V-Lookup table and MACROS creation and many such functions were used.

Design of Virtual Reality 3-D Camera Jan - 2017

•Created a 360-degree camera system capable of recording and capturing videos with a viewing angle of 360 degrees around. Users of this system will be able to create 360 degree images and video media for various uses like entertainment and virtual reality. Programming was done in Python.

•I was involved with the design, structure, documentation, testing and programming the software for the camera. The system architecture creation and documenting main source problems was my main role in this project.

Software testing tools Mar - 2016

•Used Junit and Jacoco (Eclipse) for unit testing third party java code. The two types of testing techniques involved:

-Unit testing- testing individual program units in isolation. Developed test cases on application testing and worked around with Junit in Java programming.

-Integration testing – testing units that were assembled to construct larger groups.

Linux project Nov - 2016

•Shell Programming: Created a shell (msh), like bourne shell (bash), or korn shell (ksh) that accepted commands, forked child process and executed those commands. The shell, like csh or bash, ran and accepted commands until the user exits the shell.

Other Skills

•Requirements Gathering & Analysis, fixing software problems, troubleshooting.

•Unit/Integration Testing, Worked on Antivirus issues with the PC.

•Project Management and Excellent written and verbal communication skills.

•Strong business and technical acumen, with the ability to quickly understand and communicate technical concepts and challenges across wide-ranging audiences

•Strong Analytical Background in problem solving and software testing.

•Excellent Math/ Algorithm/data structure skill.

Contact this candidate