Logo Freelancer Bagaimana Ia BerfungsiLayari Pekerjaan Log Masuk Daftar Siarkan Projek
MENJELAJAH
Data Entry Data Processing Excel Java Visual Basic
Profile cover photo
Anda sekarang mengikuti .
Ralat mengikuti pengguna.
Pengguna ini tidak membenarkan pengguna untuk mengikuti mereka.
Anda telah mengikuti pengguna ini.
Pelan keahlian anda hanya membenarkan 0 mengikuti. Naik taraf di sini.
Berjaya tidak mengikuti pengguna.
Ralat tidak mengikuti pengguna.
Anda berjaya mengesyorkan
Ralat mengesyorkan pengguna.
Sesuatu telah berlaku. Sila segar semula halaman dan cuba lagi.
E-mel berjaya disahkan.
Avatar Pengguna
$10 USD / jam
Bendera UNITED STATES
$10 USD / jam
Sekarang ini 6:49 PG di sini
Menyertai pada Januari 4, 2012
0 Syor

Aradhana G.

@agupt

0.0 (0 ulasan)
0.0
0.0
$10 USD / jam
Bendera UNITED STATES
$10 USD / jam
N/A
Pekerjaan Disiapkan
N/A
Mengikut Bajet
N/A
Tepat Pada Masa
N/A
Kadar Upah Semula

SQL Developer, Crystal Report Developer

<span> I have worked as Database designer and Database reporting person for 2 of the most prestigious company in West Michigan 6 years ago. I took off from work in 2005 to take care of family and kids. Now, I am trying to come back and looking for some projects to start with. I carry a decent understanding of relational Databases, its definition and manipulation languages, normalization, complex joins, stored procedures, User defined function, SSRS and Crystal reports. I recently completed a training as a SQL Server Developer, also completed a SQL Developer's Video course (500+ video) fr</span><span exttxt="om Learnitfirst and continue to work on it. I have also taken few VB.net and java programming classes. <br><br>I have 5 years of experience developing reports using Crystal Reports against a SQL Server Database. I have designed several hundreds of reports ranging from simple to complex acknowledgements. " class="profile_ext">... </span><a class="profileToggle" href="javascript:void(0)">Read more</a>
Freelancer Java Developers United States

Hubungi Aradhana G. mengenai pekerjaan anda

Log masuk untuk membincangkan sebarang butiran melalui sembang.

Item Portfolio

create procedure sp_Valid_Emails
--@Lname varchar(25),
--@Fname varchar(25),
--@Mname varchar(20),
--@Email varchar(50)
as
begin

if exists(Select * From dbo.tbl_Daily_Emails) 
  Insert into dbo.tbl_Valid_Emails 
  Select Lname, Fname, Mname, Email 
  From tbl_Daily_Emails 
  Where  CHARINDEX('.',REVERSE(LTRIM(RTRIM(Email)))) IN (3, 4)
  AND CHARINDEX('@',(LTRIM(RTRIM(Email)))) <> 0
  AND LEN(LTRIM(RTRIM(Email))) -    LEN(REPLACE(LTRIM(RTRIM(Email)),'@','')) = 1 
  AND CHARINDEX(' ',(LTRIM(RTRIM(Email)))) = 0
  AND CHARINDEX('/',(LTRIM(RTRIM(Email)))) = 0
  AND CHARINDEX('.',(LTRIM(RTRIM(Email)))) - CHARINDEX('@', (LTRIM(RTRIM(Email)))) > 1

Else
  Insert into dbo.tbl_NotValid_Emails	
  select Lname, Fname, Mname, Email
From tbl_Daily_Emails
stored procedure to insert emails while varifing it

Ulasan

Perubahan disimpan
Tiada ulasan pengguna
Tiada ulasan untuk dilihat di sini!

Pengalaman

MIS Analyst-Temp

Intercare Community Health Network, Bangor MI
Mei 2012 - Jun 2012 (1 bulan, 1 hari)
o Developed T-SQL Queries, Stored Procedures, SSRS matrices while extracting data from a SQL Server 2008 Legacy Health Database system with 1000+ tables, used SQL Server Profiler.

Database SPecialist

Wester Michigan University
Okt 2000 - Okt 2005 (5 tahun)
o Developed acknowledgements, Pledge reminders, Phone-a-thon calling forms, Bios, Prospecting Reports, Cross-Tab contact summary reports, Year-end analysis reports, Exports using Crystal Reports and accessing SQL Database making ODBC connections. o Developed reports that included Sub reports and Shared variables o Developed E-newsletters, reports and its templates in html o Designed supporting Databases using MS Access o Developed reports using R&R /dBase Database. o Provided customer service on d

Database Designer

Pfizer Inc
Jun 1999 - Ogo 1999 (2 bulan, 1 hari)
o Debugging & cleaning of an MS Access Accounting Database while debugging reports o Upgraded data entry form, added tables in place of free text fields avoiding typos o Made it a multiyear system by resetting the transaction number at 12:00:00 AM of every January 1st using VBA, added log in, Menu etc.

Pendidikan

BIS

Kalamazoo Valley Community College, United States 1997 - 2000
(3 tahun)

MS

Western Michigan University, United States 1993 - 1996
(3 tahun)

Kelayakan

Batchelor and Master's Certification

Millennium University- Best Software
2003
-Crystal Report + Millennium, SQL Database Training -Millennium University, JSI Fundraising Inc/Best Software (2003) o Developed Reports that included user defined functions, shared variables, sub reports, cross tabs and charts while extracting data using ODBC connection and SQL server Database o Worked on complex joins/keys for gift & accounting reports -R&R Report Writer + dBase -Millennium University, JSI Fundraising Inc (2001) o Designed Reports using R&R Report Writer and a backend dBase Database

Hubungi Aradhana G. mengenai pekerjaan anda

Log masuk untuk membincangkan sebarang butiran melalui sembang.

Pengesahan

Pekerja Bebas Pilihan
Identiti Disahkan
Pembayaran Disahkan
Telefon Disahkan
E-mel Disahkan
Facebook Dihubungkan

Kemahiran Teratas

Java Visual Basic Data Processing Data Entry Excel

Layari Pekerja Bebas Serupa

Java Developers in United States
Java Developers
Visual Basic Developers
Data Processing Executives

Layari Pameran Serupa

Java
Visual Basic
Data Processing
Data Entry
Pengguna Sebelumnya
Pengguna Seterusnya
Jemputan berjaya dihantar!
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2023 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.