Seema Tailor Email & Phone Number

Dallas, Tx, Us

Plano, Texas, United States

* Gather process data , perform analysis, and prepare findings* Investigate issues and identify underlying root causes. Use MS Visual Studio (TSQL) to create queries for gathering needed ad-hoc data.* Utilize Tableau and Excel for analyzing collected data.

Dallas, Tx

* Worked at the client site and was the first point of contact for North Texas Tollway Authority (NTTA) issues/incidents/tickets. This involved the capacity to investigate and track problems in all the various areas at NTTA. * Communicate with client to gather requirements for reporting needs.* Provide ad-hoc SQL reports and data analysis from an Oracle database to NTTA manager and executives. * Turned some of my frequent queries into reports via Report Builder and Toad. *… Show more * Worked at the client site and was the first point of contact for North Texas Tollway Authority (NTTA) issues/incidents/tickets. This involved the capacity to investigate and track problems in all the various areas at NTTA. * Communicate with client to gather requirements for reporting needs.* Provide ad-hoc SQL reports and data analysis from an Oracle database to NTTA manager and executives. * Turned some of my frequent queries into reports via Report Builder and Toad. * Perform first level software support, acting as a liaison between users and the software development team. * Support NTTA’s internal and external auditors providing SQL queries, and other supporting documentation. * Responsible for Credit Card reconciliation. * Develop/document a system to maintain the numerous reports that were run frequently so that anyone could run them. Show less

Irving, Tx

Contractor for Boy Scouts of America: Brought in on a short-term contract to help resolve a backlog of trouble tickets. This required using TOAD to run sql queries and update/delete data and using Oracle Forms and Reports to clean the ‘bad’ data. Also analyze and debug PL/SQL packages and procedures, and queries and program units in the reports/forms as needed to resolve the issues. Understanding the relationship between all the tables was important to ensure the data was corrected in all… Show more Contractor for Boy Scouts of America: Brought in on a short-term contract to help resolve a backlog of trouble tickets. This required using TOAD to run sql queries and update/delete data and using Oracle Forms and Reports to clean the ‘bad’ data. Also analyze and debug PL/SQL packages and procedures, and queries and program units in the reports/forms as needed to resolve the issues. Understanding the relationship between all the tables was important to ensure the data was corrected in all the right areas. Show less

Houston, Texas, United States

[Project: ExxonMobil]Primary onsite analyst for a large number of various, critical client server applications by utilizing a varied set of technologies (primarily SQL server and Access); Worked closely with offshore delivery team in global, distributed model to streamline request requirements and provide functional and technical assistance to a team of seven offshore developers for critical applications; Performed customer interface functions to capture requirements, triage problems and… Show more [Project: ExxonMobil]Primary onsite analyst for a large number of various, critical client server applications by utilizing a varied set of technologies (primarily SQL server and Access); Worked closely with offshore delivery team in global, distributed model to streamline request requirements and provide functional and technical assistance to a team of seven offshore developers for critical applications; Performed customer interface functions to capture requirements, triage problems and communicate status of items; Coordinated user acceptance testing for application changes; Supported users across US and Canada; Worked with vendor and various IT groups across client organization to help resolve issues and complete requests; Provided application support for business critical requests for two key critical applications. Resolved over 50% of issues and requests. These include: CDSS - This is a very complex application that handles employee training and skill information. It is a vendor package that consists of a database server, web server and a Messenger Express component that sends email notifications to employees. There are seven integrated technical components to this application. RateServer - This is a vendor package written in PowerBuilder. Inquiries for this application required mostly investigation on the front end to replicate the users processes, and going into the SQL server backend for data-related issues. Show less

Houston, Texas, United States

[Project: FERC Data Repository for BP's Downstream Pipelines]Involved in generating a process by which data will be loaded into the FERC Data Repository with the new in-coming data from SAP and other legacy systems to generate the needed reported. This included: Development and refinement of the Oracle database; Provide support for the development of reports in Business Objects; Creating tables in Oracle (primary keys, triggers, sequences); Creating E-R diagram; Loading data into tables… Show more [Project: FERC Data Repository for BP's Downstream Pipelines]Involved in generating a process by which data will be loaded into the FERC Data Repository with the new in-coming data from SAP and other legacy systems to generate the needed reported. This included: Development and refinement of the Oracle database; Provide support for the development of reports in Business Objects; Creating tables in Oracle (primary keys, triggers, sequences); Creating E-R diagram; Loading data into tables using TOAD and sqlloader; Create design documents and report templates to reflect the users requirements; Create new procedure that would be used as a part of Monarch DataPump and fire upon arrival of new data. Show less

Houston, Texas, United States

[Project: Comets (Commercial Operation Management Energy Trading System)]Oracle developer responsible for investigating, coding, testing and aiding in the implementation of SIRs (System Investigation Requests). These SIRs are in the form of fixes and/or enhancements to Forms, Reports and PL/SQL modules; Utilize deep skills gained in Oracle Reports, Forms and PL/SQL to “fix” the SIRs; Build new complex oracle reports and forms manually as well as by using the wizards; Create/modify PL/SQL… Show more [Project: Comets (Commercial Operation Management Energy Trading System)]Oracle developer responsible for investigating, coding, testing and aiding in the implementation of SIRs (System Investigation Requests). These SIRs are in the form of fixes and/or enhancements to Forms, Reports and PL/SQL modules; Utilize deep skills gained in Oracle Reports, Forms and PL/SQL to “fix” the SIRs; Build new complex oracle reports and forms manually as well as by using the wizards; Create/modify PL/SQL packages and procedures using various techniques including cursors and utl_file; Work in TOAD and SQL Plus to run and debug packages/procedures; Tune SQL with the aid of explain plans; Create design documents for building new reports and forms which contains the purpose and functionality of the new module as well as pseudocode and testing scenarios; Accurately document code, unit test plans, unit test results, code fix resolutions and design document updates; Use Unix and Appworx to look for absent data that is sent to us; Serve as a technical mentor to less experienced resources; Work as a team with Accenture consultants, vendor contractors and client personnel to resolve issues. Communicate clearly and develop strong working relationships with the clients for the fixes needing to be done to the modules; create templates for reports and forms documentation as well as document the forms and reports for comets lay-down effort. Show less

Houston, Texas, United States

[Project: REP (Retail Enterprise Program)]Utilize Oracle development skills in the completion of custom modules; work as a team with Accenture consultants, vendor contractors and client personnel to resolve issues; transfer to the system test team to fix software "bugs" related to Oracle coded modules; accurately document code, unit test plans, unit test results, code fix resolutions and design document updates.

Houston, Texas, United States

[Project: X-ray Valuation Database]Developed a database system for acquiring, processing, and reporting measurement data on medical x-ray systems to verify state compliance. This included stylized reports and forms generation and automated decision making.

Houston, Texas, United States

Assist with the conversion of Rbase to Oracle; Use SQL to export, modify, and analyze statistics in Oracle and Rbase; Design various aspects of the Oracle database (screens and reports); Train personnel in software; Test screens in the new testing database; Compile data CDs with indexing capabilities.

Houston, Texas, United States

Assist with conversion of the current database (Rbase) to Oracle; Use MS Access to “clean-up” and organize data; Write the user manual for our new Oracle database using RoboHelp; Use database designer to create entity-relationship diagrams.

Houston, Texas, United States

Mail, receive, and process Thermoluminescent Dosimeters (TLD) and generate TLD reports; Enter data and graph charts into computer; Assist in keeping comprehensive records.

Houston, Texas, United States

Visually review RPC documents for appropriate data, visually and manually verify data by using a calculator, and enter data into database using a computer keyboard; backup for phone coverage; Filing.

Master'S Degree, Business Computer Information Systems

Bachelor'S Degree, Biology, General