email@gmail.com
999.999.9999
http://www.linkedin.com/in/profile
John Smith
SQL Developer / Database Administrator / Data Analyst
Summary
Highly motivated, genuine and reliable Developer / Analyst specializing in Oracle 10g delivering exceptional database administration, database optimization, performance tuning, referential integrity, reporting and quality assurance through creative problem-solving strategies and tactics.
Specialties
Oracle database 10g Release 2, SQL language, Toad for Oracle, Crystal Reports, Oracle Reporting Services, Microsoft SQL Server 2005 Reporting Services (SSRS), All Microsoft Windows Operating Systems, Microsoft Office, Excel, Word, PowerPoint. Access, SQL Plus, CA ERwin Data Modeler, Iopus Imacros, Microsoft Visual Studio 2005, Tortoise SVN, Eclipse.
Experience
Data Modeler and Business Rules Administrator at ABC Corporation June 2007 – August 2009
- Data administrator for multiple business areas of the Internal Revenue Service. Participated in the construction of the corporate business entity relationship data model for the IRS. Classified, determined standards and implemented business rules concerning the data quality and behavior of the corporate model.
- Physical relational database project leader for the main corporate database of the Internal Revenue, including the business areas of tax payers, returns, credit collection, auditing and current accounts of the many federal taxable entities.
- Experience implementing business rules with triggers and DB procedures, Oracle snapshots (distributing information over all the IRS agencies).
- Established corporate strategies and patterns for the data administration of the Internal Revenue Service.
Data Architect & Modeler at BCD, Inc. October 2006 – June 2007
- Knowledge of Siebel 7.5 and generally accepted data modeling techniques, used to create Logical and Physical Data Models and database schema.
- Conducted JAD sessions to verify business processes and system requirements.
- Designed mapping for migration of data from Siebel 6.3 to 7.5.
- Tuned the Oracle database and wrote PL/SQL scripts to extend the functionality of the database design.
Business Modeling Consultant at XYZ Corporation March 2005 – October 2006
- Define business CONOPS and business requirements.
- Understand automation needs and provide consultation to project teams for developing system requirements.
- Develop business process flows while identifying detailed activities and responsibilities.
Education and Training:
- NY University – Oracle Database Administration
- NY University – SQL and SQL Plus (Oracle).
- New York High School Diploma, New York, New York.