Analyst

Ledlie A. Williams

*** **** ****** ***. **

Newark, NJ 07104

Cell Phone 973-***-****

**********@*****.***

EDUCATION

Bloomfield College: May 2008 Graduate

Major: Computer Information Systems

NJIT: INFORMATION TECHNOLOGY CERTIFICATE 2002

SUMMARY OF QUALIFICATIONS

* Excellent communication, presentation abilities, analytical and inter personal skills to learn new concepts and adapt to any new environment/project.

* Exceptional business intelligence skills to customize client applications to maximize performance.

* Hands-on experience in object creation such as Tables, Views, Normalization, Indexes, Stored Procedures, Denormalization and Triggers.

* Extensive knowledge in T-SQL queries (DDL-DML).

* Proficient in utilizing Microsoft Office Suite (Word, Excel, PowerPoint, Outlook and Access).

TECHNICAL SKILLS

RDBMS/DBMS: SQL Server 2000/2005 and MS Access.

Tools: SQL Server Enterprise Manager, Query Analyzer, DTS

Programming Languages: Transact SQL (T-SQL), Java, HTML, Visual Basic, VB.NET

Applications:   Microsoft Office, PeopleSoft and Microsoft Visio

Operating Systems: Windows XP, 2003, 2000, 98, 95

PROFESSIONAL EXPERIENCE

Special Operations Maplewood, NJ April 2007 – October 2009

Security Consultant

* Monitored Security Guards and sites to ensure efficient operation.

* Created a database in MS Access.

* Generate reports from the database.

* Communicates with clients to assess status of security process.

US Tech Solutions Jersey City, NJ October 2007 – February 2008

SQL Consultant Internship

* Involved in complete life cycle requirement gathering, analysis, design, development.

* Managed database changes based on feedback.

* Developed new objects (queries, tables and views) in SQL Server 2000/2005.

* Performed tuning on database.

* Performed Performance tuning of SQL queries using SQL Profiler and Index tuning wizard.

* Created DTS Packages to import and export data from SQL Server to Text and Excel files

Transportation Security Administration Newark, NJ November 2002 – March 2007

Transportation Security Screener

* Provided security and screening of 7000 airline passengers per day at Newark Liberty Airport.

* Ensured compliance of federal airline security regulations.

* Composed reports detailing various incidents and delegated passengers to appropriate area.

* Created Database and Tables in MS Access to smooth the progress of scheduling process for screening managers.

* Created Queries based on business rules to generate reports.

* Converted data from hard copy into a computerized database.

Realty Management Associates Newark, NJ June 2001 - February 2002

Occupancy Assistant

* Configured MicroHud Database for company.

* Communicated with vendors to initiate and resolve purchase orders.

* Interacted with tenants to address issues concerning various situations.

* Recertified tenants for rent subsidies.

Muze Inc. (via Forum Staffing Service) New York, NY July 1999 – June 2000

Implementation Specialist

* Converted data from hard copy into a computerized database.

* Maintained and updated content to world’s largest music information database trained new employees.

* Coordinated quality control inspection of accuracy of artist’s information in database.

* Prepared user manual including gathering requirements from the business users.

* Developed technical specifications and reports.

Contact this candidate