Sentences with phrase «sql stored procedures»

• Developed numerous oracle objects combined with SQL scripts and PL / SQL stored procedures.

My clients are a well known financial services company now expanding the team and looking to recruit a Data Analyst You will be responsible for the extraction of information from SQL Server and MySQL database, developing T - SQL Stored procedures and working with the managers on reports and integration...

IT Project Manager — Professional Highlights Serve multinational corporations in a variety of technology based strategic planning and administration roles Offer expertise as a consultant, programmer, engineer, business analyst, and database administrator Lead technology projects for NASA, U.S. Customs, American Express, and General Electric Design and implement reporting, customer service, marketing, sales, and financial management software Responsible for network and database design, administration, and security Oversee enterprise - wide hardware and software upgrades resulting in increased efficiency Minimize operational and manpower costs through effective technology solutions Serve as forecast budget analyst for Joint Project Management Operations at Kennedy Space Center Develop reporting application tool using crystal reports engine on CD throughout Kennedy Space Center and Cape Canaveral Air Station resulting in $ 500,000 savings on user licensing fees Create detailed project plan with well - defined tasks, milestones, client sign - offs, test cycles, and specifications which served to communicate project progress to management Develop visual basic application for financial banking Institution using crystal reports to reduce the company's response time resulting in initial reporting from 2 - 3 hours to just 45 seconds Oversee multimillion - dollar software implementation for Miami Air from a consultancy level Upgrade Great Plains software platform and administered security access for Miami internal databases Write over 200 SQL stored procedures from access databases for financial institutions Compose business correspondence and prepared statistical spreadsheet analysis for Kennedy Space Center Recognized by colleagues and superiors for outstanding job performance, reliability, and efficiency Conduct surveys of operations to assess needs and identify high priority improvements Complete major product releases meeting very aggressive schedules and budgets Serve as a member of the International Cyber Threat Task Force Utilize fluencies in English, Portuguese, Arabic, French, and German to communicate with a diverse clientele Continually study emerging technologies and industry best practices Perform all duties with positivity, professionalism, and integrity

GXP, GMP, GLP, GCP, Lean Six Sigma Green Belt expertise, C, Oracle 10g / 11g, SQL Server, PL / SQL Stored Procedures, Costing, Project Scheduling, Cross-Functional Supervision, Team Building, Client Relations Presentations, Business / IT Planning, Vendor Management, UML Designing, MS Project, Gantt Chart, MS Office, Rational Rose, URS, FRS, SDD, Installation, Traceability Matrix, BI, Cognos, QlikView, Infomaker Report, MS Test Manager, Sharepoint, Business Operation Excellence, Process Improvement Excellence

Analysis of mapping fields, creating PL / SQL stored Procedures, views, functions, packages; MS SQL SERVER 2008 stored Procedures, DML, DDL and functions using Rapid SQL and SQL Server Management Studio.

Developed T - SQL stored procedures, user - defined functions, views and ad hoc queries to support reporting requirements.

Used shell scripts, PL / SQL stored procedures, packages and cursors to load data from the employee data source to the data warehouse.

The core application comprised of a front end developed in ASP.NET, CSS, Ajax tool kit, and backend database was developed using Oracle 10g and PL / SQL stored procedures.

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

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

Worked as a SQL Developer responsible for creating SQL stored procedures, functions and triggers.

Gathered business requirements and converted it into SQL stored procedures for database specific projects

Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T - SQL stored procedures, user defined functions (UDFs) for data analysis

Developed PL / SQL stored procedures and packages to populate the custom reporting tables from the Datamart tables.

To optimize performance, developed data warehouse with SQL stored procedures on SQL server 2008 R2 while using SSRS to develop business intelligence reports to deliver to Apple iOS Apps on iPhone and iPad.

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.

Developed EHS Compliance Reports including: designing and writing technical specification also developing T - SQL stored procedures, ETL and SSRS reports, UAT and deployment.

NET controls, as well as, Telerik RAD Controls; web services and SSIS packages that run from the web application triggered by SQL stored procedures to process heavy amounts of data.

Performed all updates to SQL stored procedures, functions, tables, views and jobs in support of weekly and monthly commission payouts for all customers.

NET, RPG, ILE RPG, RPG free, CL, SQL Stored Procedures, and Binding Directories.

Automated the existing HRMS reports which accounted for the reduced resource requirement by 50 % using SQL stored procedures and SAP Business Objects and Crystal Reports

Developed administration tools using C, UNIX and Perl shell scripts, and SQL stored procedures to assist DBA's in performing daily functions.

Developed custom reports in from the EPIC Clarity Database using SQL stored procedures and Crystal Reports.

Not exact matches

Tags for this Online Resume: Stored Procedures, Structured Query Language, Triggers, Informatica, Microsoft SQL Server, Oracle, Oracle PL / SQL Programming language, Test, Legacy, Support

Efficient in creating Transact SQL (DDL, DML, DCL), Indexed, Views, Stored Procedures, CTE, Recursive CTE, Joins, Pivot, User Defined Functions to facilitate efficient data manipulations and consistent data storage.

Created data layer class modules that passed parameters to and executed stored procedures in SQL Server.

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

This included: database modeling and design (SQL Server 6.5), development of stored procedures, triggers and reporting with Crystal Reports.

Report Conversion from Crystal Reports to SQL Server Reporting Services 2008 and stored procedure reporting.

Scripted and modified stored procedures, user - defined functions and report objects within Microsoft SQL server

Involved in database design on SQL Server 2008 and development of different database objects containing functions, triggers, store procedures.

Implemented the elements of T - SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.

TECHNICAL SKILLS SQL, Informix, MySQL, MSSQL, Oracle, DBAccess, SOAP, ASP, PHP, Java, HTML, CSS, X12 Healthcare XML / EDI, Cognos, Data Cubes, ETL, Data Warehouse, OLAP, OLTP, Relational Table Modeling, Report Table Modeling, Indexing, Database Optimization, Linux, UNIX, Bash, VI, VIM, CVS, Subversion, PHP MVC, PHP Zend Framework, PHP GD, Cognos Report Writing, Cognos Modeling, Business Intelligence, Database Administration, cURL, Fedora, Compiled PHP, Distributed PHP, AJAX, JavaScript, Roberts Rules, Governance Modeling, Samba SMB, SCP, PL / SQL, MySQL Stored Procedures and Triggers, Database conversion, Data Mining, Fact tables, Dimension tables, Slowly changing dimensions, Metadata, Ralph Kimball Data Warehouse Technology, Dimensional modeling, Normalized Database, Dimensional data storage, Conformed Dimensions, 1NF, 2NF, 3NF, 4NF, Enterprise Replication

100 % of the Oracle Web transactions were through permission secured PL / SQL and stored procedures.

Edison, NJ / Republic National Bank 01/1998 — 09/1999 Developer / Analyst — Consumer Banking Data Warehouse Analyzed and interpreted business rules and writing stored in PL / SQL procedures and functions.

Tags for this Online Resume: C# Programming Language, Extensible Markup Language (XML), Microsoft ASP.Net, Microsoft Internet Information Server, Microsoft SQL Server, Stored Procedures, Structured Query Language, Applications, HyperText Markup Language, javascript, asp.net mvc, SQL Server 2014, Visual Studio 2015

Tags for this Online Resume: Microsoft SQL Server, Structured Query Language, Stored Procedures, Management, Services, T - SQL, Business Requirements, Data Warehouse, ETL, Integrate

Tags for this Online Resume: Active Server Pages, AJAX, C# Programming Language, Database, Javascript, Microsoft ASP.Net, Microsoft SQL Server, Microsoft Visual Studio, Servers, Stored Procedures, javascript, sql, c#, html, agile, software, Angular js, SQL Server, Microsoft Visual Studio, Servers, Stored Procedures, javascript, sql, c#, html, agile, software, Angular js, sql, c#, html, agile, software, Angular js, MVC

Experienced with SQL Queries, Stored Procedures and PL / SQL programs.

* Excellent database programming skills using SQL, Stored Procedures, Views and Functions.

Net, Microsoft ADO.Net, Microsoft ASP.Net, Microsoft SQL Server, Microsoft Visual Studio, Services, Stored Procedures, Structured Query Language, TFS

Developed new SQL Server stored procedures to streamline the data collection and validation processes.

Design, maintain and optimize Database, write stored procedures, triggers, index, and functions in SQL Server database environment.

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

Develop new and maintain existing store procedures for financial compensation logic written in T - SQL utilizing database knowledge of store procedure development, financial knowledge and understanding of relational database.

Using T - SQL / store procedure to fetch, transform and merge data.

Created a monitoring database, stored procedures and SQL agent jobs to capture index fragmentation, database usage, table usage, LUN usage and stats.

Created triggers, stored procedure with T - SQL programming, As well as used ADO.Net for SQL Server database, interaction using Data Adapter, Data Reader, and Datasets.

Create stored procedures and SQL scripts to query databases, develop processes that simplified and made more efficient data entry and transaction processes to extract / load / update data in SQL Server database.

Developed various SQL servers queries, Stored procedures and trigger to meet the organization reporting needs.