Sql Software

Highlights

* ***** ** **** ******** Experience

* ***** ** *** **********

* ***** ** **/*** Experience

Profile

●Excellent IT experience in gathering requirements, analyzing, designing, development, implementation and testing of applications in data warehouse.

●Eight years of experience as Oracle SQL and PL/SQL Developer in large production environments with database implementation on UNIX and Windows

●Extensively involved in writing complex SQL queries (sub queries and join conditions) and tuning SQL queries.

●Used advanced features of SQL such as Pivot and Unpivot; Merge to merge several years of data longitudinally

●Created Tables, Views, Constraints, Index

●Proficient in Oracle Tools and Utilities such as Oracle SQL developer, Toad, SQL Loader.

●Experienced in loading data into tables using SQL*Loader.

●Used Oracle SQL developer to load tables and create report templates as well

●Experience in Dynamic SQL

●Experience in data warehousing using star schema

●Experience using Microsoft SQL server

●Experience using Unix Shell scripts,

●Experience using Crystal reports and set up of automatic reports using Infoview

●Experience using both Unix and Windows operating Systems. Familiar with Linux. Comfortable with command line interfaces

●Good at reading code in a number of languages such as C, C++, PhP, Perl, Javascript, Java and figuring out what it does

●Excellent communication, quick to pick up new skills and ability to work under different software environments

Experience

Sept 2016 - current

Worked as a Application Support Analyst at NSF International. Duties involve, querying in SQL, problem solving, fixing reports using BI Publisher, a whole variety of issues that gets put on the JIRA ticketing system.

Aug 2015 - July 2016

Working as a report Analyst at Ford. Duties involve reading legacy PL/SQL code and writing requirements for development. Adhoc SQL queries and working with WallSteet reporting and Reval reporting – both vendors

Oct 2013 – Aug 2015

Application Systems Analyst/Programmer Sr, University of Michigan

Duties involve preparing datasets from our vast medical data warehouse, for our clients who are primarily doctors, to enable their research. Work involves using SQL and PL/SQL on Oracle and SQL server using Windows to connect to the database. Also set automatic reports using Crystal reports and Infoview.

Oct 2009 – Sept 2013

Programmer/Analyst, HMRC, University of Michigan

Duties involve uploading of tables into Oracle databases, working closely with the Analyst, writing queries in SQL, programs in PL/SQL and generating reports for several accounts. Also responsible for setting up of reports so we can generate reports using our in-house report generator.

Used Oracle database from windows. Also maintained our home page using HTML. Used Sharepoint to keep track of project and files. Used source control.

Mar 2009 – Sept 2009

Programmer, Kellogg Eye center, University of Michigan, Ann Arbor, MI

Created a database and uploaded large tables for a medical database in both MySQL and Oracle, the largest table had almost 800 million records. Did some data cleaning, querying and merging using SQL and PL/SQL. Altered an existing program in PHP to talk to the Oracle database and altered a JavaScript program to display the query results on a web browser. Got familiar with Ajax, JQuery, JSON and more current JavaScript.

August2007 – Feb 2009

Maintained websites for music and robotics club using Sitemaker, maintained and updated website for a realtor at Swisher Commercial and maintained the website for Ecology center using HTML and Photoshop.

Sept 98 - August 2007

Part-time instructor, Washtenaw Community College, Ann Arbor, MI

Courses taught - “Intro to Computers, “Explore the Internet”, “Windows Operating System, Internet I and Internet II, Intro to Business Information Systems. Taught Microsoft Office in all the introductory courses. Also set up Web pages for my courses using HTML and Perl for the convenience of my students. . In addition to teaching, I kept abreast of new technology by taking courses at WCC especially database and web technology.

1990 - 1995

Self-employed

Worked short term for a company in Ann Arbor

Work involved troubleshooting software and hardware problems, upgrading hardware and software and making sure existing software worked on the updated machines. One problem in particular was to do some memory management in order to run memory resident monitoring software along with their accounting software. This was in DOS operating system.

1986 - 1990

Programmer, Deucalion Resource Group. Ann Arbor, MI.

Work involved debugging and enhancing of the composition end of typesetting software written in C. Also was involved in enhancing the terminal and composition end of the typesetting software to be able to read and typeset right-to-left as in Hebrew or Arabic languages. Used Unix and DOS operating systems

1984 - 1986

Software Engineer, COSI, Ann Arbor, MI.

Work involved prototyping using shell scripts, debugging and enhancing a document writer for lawyers (written in C), which allowed communication between a UNIX based host machine and a PC. Ported UNIFY based database program to next version of UNIX. Studied different databases in particular UNIFY, ORACLE and INFORMIX to determine which one would best suit one of our projects.

Education

Masters in Computer Information and control Engineering

Kept by with new technology by taking courses at Community College

Reference

Phil Krstovski NSF 734-***-**** **********@***.***

Bill McLogan Ford Credit 734-***-**** **********@***.***

Jeff Cowall MCIT 734-***-**** *******@*******.***

Contact this candidate