Sql Server Software

Location:

Fair Lawn, NJ

Posted:

December 30, 2013

Contact this candidate

Resume:

SUMMARY OF QUALIFICATIONS:

. Strong knowledge and 10+ years of Practical experience with Visual

Basic Excel and Access Programming languages, spreadsheets & access

databases

. Practical experience with SQL, Create, edit, modify Tables Oracle 9i,

10g and 11g with ODBC various connections

. Established aptitude to use and administer large databases using

analytical tools

. Able to deal effectively with unclear situations and short time frames

. Self-motivated, Team Oriented, Detail Oriented, Responsible &

Independent.

. Excellent organization, multitasking, communication skills, Analysis,

Microsoft Excel, Financial Reporting and Database management

. Strong numerical, interpretative, analytical and diagnostic skills

EDUCATION:

Post Graduate Certificate

1999 - 2001

Major: Computer Management/Programming Language

Computer Learning Institute of Technology, Paramus, NJ

Microsoft OS's, Microsoft Office, Visual Basic, Computer

Hardware/Troubleshoot

Bachelor of Computer Science 1992 -

1996

Major: Information Technology

DAV College, Punjab, India

RELATED SKILLS:

Technical Skills:

. Software: SQL Developer, SQL, SQL Navigator, MS Office 2007, 2010,

Jira, Crystal Report, Oracle Discover Navigation (Advanced in Excel

formula's and Access)

. Knowledge of basic Programming Languages: C/C++, C#, ASP.Net, HTML

. Databases: SQL Server 2005/2008, Oracle 9i, 10g, 11g

. Networks and Protocols: WLAN, WAN and LAN networks / SMTP, POP, FTP,

TCP/IP, HTTP

. Operating Systems: Microsoft Windows XP, Vista, 7 and Windows 8 & MAC

IO's

. Knowledge of Intuit Software: QuickBooks and Quicken, Online Mint

Application

WORK EXPERIENCE:

IT / Data Analyst

Asta Funding, Inc., Englewood Cliffs, NJ

Jun 2012 - Jan 2013

. Outsource accounts to external vendors (law firms & agencies)

. Manage internal various documents and forward to external vendors

. Automate/Manage daily reports for various departments

. Assist IT with installing all new hardware, troubleshoot systems,

Installing software, all system back-up and restore

. Designing ETL flow, batch job creation, responsible for identifying

and monitoring data warehouse usage across several applications

. Perform troubleshooting analysis of servers, workstations and

associated systems

. Document network problems and resolution for future reference

. Monitor system performance and implements performance tuning

. Arranged analysis reports and be accountable to answer any queries for

from various departments

. Manage user accounts, permissions and Emails with Microsoft SQL Server

. Manage PGP - Encryption software

. Track daily issues on Jira software for tracking/cost purposes

. Support and setup CISCO VPN (Virtual Private Network)

Document Specialist

Asta Funding, Inc., Englewood Cliffs, NJ

Jun 2001 - Jun 2012

. Submit document requests to various banks on weekly bases

. Manage documents storage of 15mm charged off accounts

. Track invoices using internal designed database to avoid any errors

. Execute various reports for management on various documents using

Oracle SQL Navigator and Microsoft Visual Basic Access/Crystal Reports

. Assist IT with implement in-house documents retainer application

. Handled PGP encryption files exchange with external servicers

. Maintained the research database, renew and improve it from time to

time and make sure safe storage of data

. Designed in-house interface using combination of Oracle 9i/Microsoft

Access Visual Basic interface to execute various reports

. Educated new employees in the department

. Arranged analysis reports and be accountable to answer any queries