Available List of my consultants from Infovision Technologies.

Hi Friends,

This is Surya from Infovision Technologies. I have two Excellent
consultants for Oracle Developer and SQL

Developer.Please kindly let me know if you have requirements with you.
If you have any requirements please

contact me on my number 732-798-3119


Name: Jaspreet,
Skill: Oracle Pl/SQL Developer,
Experience: 7+ Years,
Rate: Open,
Location: New York,
Relocation: Yes
Availability: Immediate.

Summary

* An IT professional with more than 7 years experience in positions of
increasing responsibilities.
* Experienced in writing SQL statements, PL/SQL code for the database
objects such as tables, views, indexes, sequences, procedures,
functions, packages, and triggers
* Excellent experience and understanding of system development life
cycle (SDLC) such as analysis, design, development, testing,
implementation and support with exposure in database
* Extensive knowledge of Relational Database Management Systems
(RDBMS)
* Excellent understanding of the relational and normalized databases
* Expertise in using Oracle 9i/10g database and PL/SQL programming to
develop stored procedures, packages and advanced features like
function overloading, dynamic SQL, query optimizer, nested loops
* Extensively used indexes for fine tuning and optimizing SQL and PL/
SQL queries.
* Extensive experience in using cursors and ref-cursors for processing
the data.
* Expertise in handling various errors using exceptions.
* Applicable knowledge of Oracle tools like SQL*PLUS, iSQL*PLUS,
SQL*Loader, export/import and data pump utilities like expdp/impdp.
* Worked on several Oracle provided packages such as UTL_FILE and
DBMS_JOB
* Extensive experience in application development of the database
using TOAD
* Experienced in using the version control tool such as VSS (Visual
source safe)
* Experienced in scheduling reports for maintaining up to date
information and managing folders for sharing reports
* Transferred data using FTP (File Transfer Protocol) and storing the
back-ups of data using SCP (Secured Copy)
* Expert in writing shell scripts and setting the Cron tab for
repetitive database processes in UNIX
* Excellent knowledge of data warehousing concepts like star schema
and snowflake schema, data marts used in relational and dimensional
modeling
* Documented business rules, functional and technical designs, test
cases, and user guides
* Possess excellent communication, interpersonal and technical skills
* Self-motivated with analytical, problem solving and presentation
skills.
* Excellent team player with the ability to work independently and
interact with people at all levels

CERTIFICATIONS

* Introduction to Oracle SQL 9i (1Z0-007)
* Oracle 9i Program with PL/SQL (1Z0-147)

TECHNICAL SKILLS

Operating Systems UNIX, Sun Solaris 5.8/5.6, RedHat Linux, DOS, Win 98/
NT/2000/XP/Vista
Database Oracle 8i/9i/10g
Languages UNIX, Shell Scripting (Bourne, Korn),SQL, PL/SQL, C, C++
Tools Putty, SQL Plus, iSQL Plus, TOAD 8.5/9.0
Case Tools Erwin
GUI Oracle Forms 9i/10g
Utilities Vi Editor, FTP, SQL*Loader, SQL Developer, PL/SQL Developer,
Explain Plan, TKProf, Import/Export, Impdp/Expdp




PROFESSIONAL EXPERIENCE

Merck & Co. Inc, Blue Bell,
PA
Mar' 08 - Till Date
Role: Sr. PL/SQL Developer

Description:
Merck & Co. Inc. is a global research-driven pharmaceutical company
dedicated to putting patients first. The Company devotes extensive
efforts to increase access to medicines through far-reaching programs
that not only donate Merck medicines but help deliver them to the
people who need them. Merck also publishes unbiased health information
as a not-for-profit service.

Responsiblities:
* Involved in database development by creating Oracle PL/SQL
Functions, Stored Procedures, Triggers, and Packages.
* Worked with different types of sub queries (Inline, correlated) and
used loops to suit the business logic.
* Written a number of Cursors to select various types of records.
* Worked with Bulk Collects to improve the performance of multi-row
queries.
* Used the Pragma Exception_INIT to name the system exceptions that
are raised by the program.
* Extensively involved in Export (exp) and Import (imp) utilities to
move data between different databases and schemas.
* Created various PL/SQL Scripts involving Insert, Sequences,
Constraint and Index scripts.
* Worked with Bulk Collects to improve the performance of multi-row
queries.
* Created Records, Tables, Objects, Collections (Nested Tables and
Varrays).
* Handled errors using system defined exceptions and user defined
exceptions like INVALID_NUMBER, NO_DATA_FOUND and PRAGMA
EXCEPTION_INIT.
* Creation of database objects like Tables, Views, Materialized
views, Procedures, Packages using SQL*Plus, TOAD.

Environment: Oracle 9i/10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, UNIX,
TOAD



2. Name: Ravi,
Skill: SQL Developer,
Experience: 7+ Years,
Rate: Open,
Location: New Jersy,
Relocation: Yes
Availability: Immediate.


Professional Summary
* 7+ years of SQL Server Development experience, Stored Procedure/TSQL
coding, Performance Tuning, Physical and logical Database Design.
* Expert in MS SQL Server suite of products like SSRS and SSIS of MS
SQL Server 2005.
* Experienced in using global variables, expressions and functions for
the reports.
* Experienced in sorting the data, defining data source and subtotals
for the reports.
* Expert in using Bulk Copy Program (BCP), Data Transformation
Services (DTS) packages and SSIS (integration services) with MS SQL
Server 2000/2005.
* Experience in enhancing and deploying the SSIS Packages from
development server to production server.
* Excellent knowledge in creating Databases, Tables, Stored Procedure,
DDL/DML Triggers, Views, User defined data types, Cursors and Indexes
using T-SQL.
* Implemented complex business logic into database design and
maintained the referential integrity via triggers and constraints.
* Experienced in the installation and configuration of SQL Server
2005.
* Experience in Creating Roles and Assigning Permissions to the users.
* Implemented different types of Replication Models such as
Transaction, Snapshot and Merge in SQL Server 2000 and SQL Server 2005
in OLTP Environments.
* Experience In Database Backup, Recovery and Disaster Recovery
Procedures.
* Experience in writing complex T-SQL queries using Inner, Outer and
Cross Joins.
* Extensive knowledge in Tuning SQL queries & improving the
performance of the Database by creating and updating clustered and non-
clustered indexes.
* Hands on experience in Log shipping with SQL Server 2000/2005.
* Experience in Analyzing Execution Plan and managing indexes and
troubleshooting deadlocks.
* Experience in using profilers, Index Tuning Wizard and performance
monitor to monitor SQL Server.
* Experience in Partitioning tables to achieve better performance for
access and writes.
* Strong experience with data modeling, logical and physical database
design using Erwin.
* Good knowledge in Normalizing and De-normalizing the tables and
maintaining Referential Integrity by using Triggers and Primary and
Foreign Keys.
* Conversant with all phases of Software Development Life Cycle
involving Systems Analysis, Design, Development and Implementation.

Technical Skills:
Languages C, C++, T-SQL,
RDBMS MS SQL Server 2005, 2000, 7.0, MS-Access.
Web Technologies HTML, XML and Java Script
Reporting Tools Crystal Reports, SQL Server Reporting services (2000
and 2005)
Web Server Technologies IIS 5.1/6.0
Data Modeling Tool ERWIN 4.0, Visio 2002
Operating System Windows Server 2003, Windows 2000 Advanced Server,
Windows 2000 data center, Windows NT, Windows 95/98/2000 XP


Certifications:
? 70-431 Microsoft SQL Server 2005 - Implementation and Maintenance

Professional Experience:

Glaxo Smith Kline, Durham, NC
SQL Server
Developer
(May 08 - Till Date)
GSK is one of the few pharmaceutical companies researching both
medicines and vaccines for the World Health Organization's three
priority diseases - HIV/AIDS, tuberculosis and malaria, and is very
proud to have developed some of the leading global medicines in these
fields. Headquartered in the UK and with operations based in the US,
GSK is one of the industry leaders, with an estimated seven per cent
of the world's pharmaceutical market. GSK produces medicines that
treat six major disease areas - asthma, virus control, infections,
mental health, diabetes and digestive conditions. In addition, GSK is
a leader in the important area of vaccines and are developing new
treatments for cancer.
Responsibilities:
* Designed dynamic DTS Packages for Landing-Pad to transfer data
between servers, load data into database, and archived data file from
different DBMS.
* DTS to SQL Server 2005 Integration Services (SSIS) Migration using
the Upgrade Advisor.
* Created basic SSIS Packages to import and export data from Excel
Spreadsheets, Text files and CSV files.
* Created SSIS Packages to migrate users, logins, stored procedures,
and tables.
* Implemented Source Control and Version Control using SSIS 2005.
* Imported and exported data using BCP and Bulk Insert.
* Created SSIS packages in SQL Server 2008 to successfully migrate
data from SQL server 2005.
* Created reports based on the requirements using SSRS 2005.
* Used SSRS to create ad-hoc, parameterized, drill-down and drill-
through reports.
* Debugging, Troubleshooting very large stored procedures and assisted
Data Cleansing over the ODBC.
* Created and developed the stored procedures to handle complex
business rules, history data and audit analysis.
* Scheduled and monitored all maintenance activities of SQL Server
2005 including database consistency check, and index defragmentation.
* Wrote several SQL Scripts such as finding long running queries,
blocking sessions, archiving data from production to archive server
and populating reporting data.
* Created SQL Server Profiler traces and used with Database Tuning
Advisor (DTA) for optimum performance of queries.
* Created database objects like tables, views, indexes, stored-
procedures, triggers, cursors.
* Developed, modified, and optimized complex queries to data retrieval
and modification.
* Created DML/DDL triggers as per company policy.
* Created logical and physical database design, data structures, and
implemented large databases using Erwin.
* Monitored and Tuned queries and stored procedures for optimum
performance.
* Worked with development teams in the design of physical databases
and in modification including Denormalization of physical databases
and partial reconstruction of Stored Procedures.
* Provided technical support to internal developers and external
clients.

Environment: Microsoft Windows Server 2003 Enterprise Edition,
Microsoft Windows 2000 Server, Microsoft SQL Server 2000/2005/2008,
Microsoft SQL Server Data Transformation Services, Microsoft SQL
Server Reporting Services, Microsoft SQL server SSIS, Erwin, etc.
.

Relevant Pages