Sentences with phrase «complex sql»

* Coded complex SQL scripts and cursors to extract customer data from an 18 million subscriber database for direct marketing promotions.

IT Specialist II — State of Arizona, Dept. of Economic Security, Phoenix, AZ 2001 — 2005 Provided coding and testing for complex SQL 2000 stored procedures, views, and triggers for business applications that included parameters, generation of server unique object identification numbers (OIDs), and calculated values.

EXPERTISE * 6 + years» experience in database development in PL / SQL Oracle, database experience in writing Packages, Procedures, Functions, Triggers, Complex SQL.

Created new EJBs, form beans, backing beans for the new tables being added for the HCPP3.0, also created DTOS, DAOs, and worked on complex SQL Queries.

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back - end testing and worked with data quality issues.

Created complex SQL views and stored procedures to join multiple tables for contract data interface files

Developed and executed test plans and over 300 functional test cases using complex SQL in Teradata and Oracle 9i using SQL Assistant and TOAD for 5 projects for data warehousing environment from project documents and Data Model in Erwin.

Responsible for creating oracle reports in the project and have dealt with complex SQL queries

Conducted extensive data analysis / verification by writing and executing complex SQL queries in Microsoft Access.

Developed inline view queries and complex SQL queries and improved the query performance for the same.

Created complex SQL queries to troubleshoot, identify and correct issues with end - user data entry and external data imports

Should be well experienced in coding complex SQL Queries...

Work closely with the business areas to understand the requirements and to write complex SQL queries.

Not exact matches

If your business» data is only accessible via complex coding and processing functions such as SQL queries, then of course the average employee will require relatively intense training to be able to even input or extract data day - to - day.

A results oriented, analytical and detail oriented problem resolution solver with the ability to direct complex projects from concept to fully operational status and the ability to work well with customers, technical personnel and marketing.Technical ExperienceSoftware: CFSW, WPLC, PSLC, RETAIN, SDSF, RSVSF, RMDS, JES2, JES3, ISPF / PDF, TSO / E, SMP / E, MVS, DF / SMS, VTAM, NCP, SNA, RACF, VSAM, NPDA, IDNX, EP, NETVIEW, OPC / ESA, OPC / A, RMF / SAM, SMF, Information Management, TSP, SRC, CRM, VM, VSE, AS / 400Basic Skills in IMS, DB2, CICSProgramming Languages: JCL, Clist, Utilities, COBOLOperating Systems: z / OS, OS / 390, S390, MVS / ESA, MVS / XA, VM, VSE, DOS, Windows, XP Professional, 98, 95, 2000Office Tools: Lotus 123, Lotus Notes, LOTUS Wordpro, BRIO, Profs, SQL, QMF, Excel, Word, MS Project, Outlook, Outlook ExpressHardware: IBM S / 390, AS / 400, IDNX, MSS, VM, VSEProfessional ExperienceAdministrative Assistant for IT / Director for County Government 2005Responsibilities: Attended in - house classes on MS Project Management to become oneof the MS Project Administrators.

The latter contained complex multi - table / view queries spanning several databases, packaged as SQL Server store procedures.

Designed and Developed Complex Custom Clarity WEBI and Crystal Reports (Using Views, PL / SQL Stored Procedures, and Packages) to provide clients with reports on Project Management, Portfolio Management, Program Management, Financial Management, Resource Management, Time Management and Capacity Planning modules.

Known as system knowledge expert consultant, managed complex client relational database configurations, and uploaded «hot fixes» via SQL to debug existing issues according to database / system releases.

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T - SQL code to implement business rules

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.

Responsible for resolving complex transactional database processing issues on MS SQL Server 2010 - complex joins / queries, stored procs, views, T - SQL - and advanced custom reporting.

My experience includes designing and developing complex software used for technology startup and working with database design and SQL.

Develop complex T - SQL queries for data - analysis and data extract utilizing knowledge of joins and understanding database landscape.

Created complex T - SQL stored procedures to manipulate data in real time in large, highly transactional

Developed complex T - SQL stored procedures and views for customers» highly customized reporting demands

Performed System test on Cognos Reports for WAMMIS Data warehouse system which involved analyzing functional specifications and writing test analysis, executing reports with test data for test scenarios and writing complex Test SQLs for the reports and logging defects in Clear Quest.

Developed complex T - SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL / SQL.

PROFESSIONAL SUMMARY: * Extensive experience in design, development and implementation of application in Client / Server and Web technologies * Expertise in n - tier development architecture and proficiencies in all phases of SDLC coupled with ample experience in applying them in project development * Experience in developing complex queries, stored procedure, triggers and cursors using SQL * Excellent analytical, communication...

Tags for this Online Resume: agile, software, sql, it jobs, business operations, implementations, systems configuration, managed health care, X12 HIPAA transactions, project management, process improvement, relationship management, staff development, SDLC methodology, complex / large scale initiatives, change management, budget planning / management

Have comprehensive skills of Designing (SSIS ETL Packages Complex T - SQL Queries, Partitioning and Indexing.

* Professional experience in Database Administration and Development for very large and complex databases in SQL Server 2014 / 2012 / 2008R2 / 2008/2005 / 2000.

SUMMARY: * 11 + years of professional experience as Database architect, Administrator / Developer related to Financial, Mortgage, Health care and Manufacturing databases on SQL Server 2008 R2 / 2005 / 2000 / 7.0, Greenplum 3.3.4 / 4.1, Oracle 10g, PostgreSQL 9.0 / 9.1 * Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.

* Admirable database administration skills and involved in Installation, Configuration, Security Management, Schema designing, Tablespace Management, Backup strategies and Performance tuning * Expert in creating Indexes, Data integrity and Relational Database Models and SQL joins and complex queries.

* Excellent T - SQL Developer skills including writing, reviewing, debugging complex Stored Procedures, Indexes, Views, User Defined Functions, T...

Participated in several engineering efforts for Aerospace, Department of Defense, Biomedical Engineering, Broadcast Communications, ISO 9001 regulated environments, as well as the Media and Entertainment Business environment QA Expertise: * Motivated and dedicated Software Quality Assurance and Testing Professional * Excellent verbal and written communication skills * Participated in test executions, requirements analysis, configurations of complex software / firmware and systems in a variety of environments * Experience in creating QA Procedures and metrics, establishing QA Standards, proficient in writing Test Plans, Use Cases, and Test Cases for manual tests and automation * Experience in executing SQL command scripts for Data Validation * Solved mission critical customer related issues and helped organizations solve several complex engineering anomalies * Great exposure related to testing on Web / Windows based, Business Class multi-user client server application software and Back End system validation * Ability to work independently or in a team environment and capable of establishing rapport with a variety of diverse functional working groups

Operations Manager — Duties & Responsibilities Prepare complex technical standard operating procedures for organizational implementation Oversee organizational ethics and compliance training administration at facility level Develop and implement training to ensure workforce peak performance Perform safety management studies and approve / disapprove proposed procedures Administer employee appraisals and increase employee motivation and organizational citizenship Manage multi-million dollar air traffic control contracts Effectively lead culturally diverse workforce in domestic and international settings Develop and implement air traffic control flow procedures saving cliental thousands of dollars on a daily basis Serve as liaison with cliental customers and mediate solutions resulting in increased customer investments Develop and administer varied software solutions for clients including KPMG, USAF, and the Chicago Board of Trade Oversee software projects through the various facets of developmental lifecycle Develop software applications using Visual Basic and SQL Server increasing business operation efficiency Create safety management systems which track aircraft incidents and trends Network and manage numerous air traffic control systems decreasing system downtime Develop an employee management system increasing operational efficiency Represent company brand with poise, integrity, and positivity

Created complex T - SQL queries to develop and improve Stored Procedures, User - Defined Functions, Indexed Views and Triggers to maintain database operations, and facilitate ETL processes.