EXPLORE

(0 reviews)

Aradhana G.

@agupt

0.0

SQL Developer, Crystal Report Developer

$10 USD / Hour

・

United States (1:04 AM)

・

Joined on January 4, 2012

$10 USD / Hour

・

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 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">... <a class="profileToggle" href="javascript:void(0)">Read more</a>

Verifications

See all Java Developers in United States

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

0.0 · 0 Reviews

Reviews

No reviews to see here!

MIS Analyst-Temp

May, 2012 - Jun, 2012

•

1 month

Intercare Community Health Network, Bangor MI

May, 2012 - Jun, 2012

•

1 month

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.

May, 2012 - Jun, 2012

•

1 month

Database SPecialist

Oct, 2000 - Oct, 2005

•

5 years

Wester Michigan University

Oct, 2000 - Oct, 2005

•

5 years

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

Oct, 2000 - Oct, 2005

•

5 years

Database Designer

Jun, 1999 - Aug, 1999

•

2 months

Pfizer Inc

Jun, 1999 - Aug, 1999

•

2 months

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.

Jun, 1999 - Aug, 1999

•

2 months

Kalamazoo Valley Community College

1997 - 2000

•

3 years

BIS

United States

1997 - 2000

•

3 years

Western Michigan University

1993 - 1996

•

3 years

United States

1993 - 1996

•

3 years

Batchelor and Master's Certification

2003

Millennium University- Best Software

-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

2003