Cognos Developer

Zeeshan Shahid

**** *** ***** **, *******, NC, **616

ste7de@r.postjobfree.com; Phone: 919-***-****

______________________________________________________________________

Professional Skills:

Programming Languages

SQL, PL/SQL, HTML, PHP, C, C++, Java, Apache, XML, Perl, VB, ASAP.NET

Tools

Dreamweaver, Logmein, Photoshop CS, SQL*Plus, SQL Loader, SQL analyzer, TOAD, Access, MySQL, MS Office suite (word, Excel, Power point, etc.), Visio, Adobe Acrobat Professional, ODBC/JDBC, Cpanel, Dev C++, microsoft studio 2005.

RDBMS

Oracle; MS SQL Server 2005/2008; MS Access Database.

Operating Systems

DOS, Windows 95, Windows 98, Windows server 2000/2003, Windows XP, Vista, Windows Home Server, and Windows 7, UNIX/LINUX

Education/Certifications:

• Computer Science Degree from NC STATE -in progress

• Oracle9i Database Administrator Certified Associate – 2009

• Oracle10g Database Administrator Certified Associate – 2010

• Wake Tech Community College - transfer

Job History: Variety Pic up 2007-2010

• Responsible for Oracle 9i logical and physical database design, implementation, and maintenance on Windows NT

• Created new databases and users: set up backups, export, and other monitoring scripts

• Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.

• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance.

• Identify, recommend, and implement all new database technologies and Oracle license management.

• Over 3 years of experience working with Linux.

• Design and document database architecture. Data Modeling.

• Design Data Warehousing and Business Intelligence platform

• Build database scheme, tables, procedures and permissions

• Set up data sharing and disk partitioning

• Develop database utilities and automated reporting

• Create shell scripts for task automation

• Create, test and execute data management languages

• Analyze and sustain capacity and performance requirements

• Analyze, consolidate and tune database for optimal efficiency

• Monitor systems and platforms for availability.

• Oversee backup, clustering, mirroring, replication and failover

• Restore and recover corrupted databases

• Install and test upgrades and patches

• Implement security and encryption

• Provide 24/7 support for critical situations

• Evaluate and recommend new database technologies

•

Project Description: made a project using MS Access about music database where each band has relationship with every table.

Responsibilities:

• Find out the sale for each band.

• Calculate the total income raise by each band by selling their shirts.

• Find out each show that has been booked in North Carolina

• Locate the show by location.

• Make reports based on forms.

• Find which band is selling what products.

• Find which singer is specializing in which instrument.

• Make reports by city, location, by band, and by year.

• Make queries to find out each CD has been sold by each band.

• Make queries based on their instrument skills.

• Make queries to find the price range for each CD.

• Make queries to find out the total sales for all of the bands.

• Make macros to perform different commands.

• Make macros to make hyperlink between different tables

Contact this candidate