* Excellent T - SQL Developer skills including writing, reviewing, debugging
complex Stored Procedures, Indexes, Views, User Defined Functions, T...
Created
complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T - SQL code to implement business rules
Developed and modified
complex stored procedures in supporting ETL processes in data warehousing environment.
Not exact matches
The latter contained
complex multi - table / view queries spanning several databases, packaged as SQL Server
store procedures.
Wrote
complex queries,
stored procedures, and DTS Packages; scheduled maintenance plans, ran daily backups, restored backups, etc..
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.
RELEVANT SKILLS • Strong programming and coding skills • Good exposure to web development • Strong knowledge of creating multi threaded applications in Windows environment • Ability to write
stored procedures • Experience with cloud - based products • Excellent ability to take directions • Exceptional ability to troubleshoot common and
complex software issues
SUMMARY OF QUALIFICATIONS • Over two years» working experience as a
Store Person for Tora
Stores • Highly skilled in receiving all incoming goods and placing them appropriately • Demonstrated ability to adherence to safe working practices and
procedures • Able to operate a forklift and pallet jack • Hands - on experience in
complex warehousing methods • Well versed in inventory management systems • Expert in performing data entry and using computer applications including MS Excel and Word
Design robust views,
complex queries, functions,
stored procedures, clustered and non-clustered indexes and triggers.
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
Created
complex SQL views and
stored procedures to join multiple tables for contract data interface files
Developed
complex T - SQL code such as
Stored Procedures, functions, triggers, Indexes and views for the application.
Optimized performance on over 80 % of reports with overly
complex code, views,
stored procedures and / or design.
Developed
Complex database objects like
Stored Procedures, Functions, Packages and Triggers using SQL and PL / SQL.
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.
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...
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.