Sql Server Management

Paulette Warrick SQL Developer Resume Document Transcript

Paulette Warrick Baldwin, NY 11510 516-***-****, 516-***-**** *******.********@*****.************* Developer with experience using SQL Server Management Studio and Visual Studio2008; having over 12 years of progressive experience in software development whichinvolved working in all stages of the system development life cycle. Organize and analyticalwith excellent oral and written communication and interpersonal skills; adapting rapidly tochanging environments, to ensure bottom line success. Effective in resolving issues thatsurfaced; complemented as being meticulous and creative; showing detail to specificationand design.TECHNICAL SKILLSDatabase Management Systems:Microsoft SQL Server 2008, Microsoft SQL Server 2000, VSAM, DB2, MySQL 5, Oracle 9iSoftware:MS SQL Server 2008 Integration Services (SSIS), MS SQL Server 2008 Reporting Services(SSRS), Microsoft Office, Foxpro 5.0, Crystal Reports 11, PeopleSoftTools:SQL Server Management Studio, Microsoft Visio, Business Intelligence Development Studio,TurnoverProgramming Languages:COBOL, CICS, JCL, REXX, PHP 5.0, Ajax, CSS, HTML/XHTM, JavaScriptOperating Systems:UNIX, OS/400 V5R4, Windows 2000/XP/7SetFocus, LLC. Baldwin, NY Nov 2010 Dec 2010SQL Master s ProgramThe SetFocus SQL Server Master s Program is an intensive, hands on, project orientedprogram where participants gain knowledge and valuable experience putting the SQL Serverskill set to use in a simulated work environment. Created numerous simple to complex queries involving self joins, correlated subqueries, CTE s and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies. As part of a team, analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu- Ray) rental company. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS. *******.********@*****.*** As part of a team, created various reports according to the business requirements for the movie rental company. Individually authored, installed, deployed and managed reports using SSRS for a library database. Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities. Created an ETL solution that reads Product, Vendor, and Order data from .CSV files on a network share into a SQL Server database. The solution also validated incoming data and performed notifications when jobs complete. The order data thus loaded into SQL Server was used to generate reports using the new SSRS 2008 reporting functionality (including the Tablix control). The reports were set up for automatic delivery based on standard report subscriptions.PROFESSIONAL EXPERIENCEGuardian Life of the Caribbean Limited Trinidad W.I. Sep 2001-Nov 2009Project Leader Managed the core system Ingenium 5.0 (COBOL) insurance system running on an IBM AS400 (mainframe) machine Managed the COBOL team which included recommended system enhancements; estimated, scheduled, and monitored projects Maintained Data interfaces between the AS400 and Oracle, PeopleSoft and Microsoft SQL server Implemented complex stored procedures and views using PL/SQL and T-SQL. Interfaced with user departments with respect to requirements gathering and coordinating promotion of new Projects Ensured data integrity, and data recoverability Minimized system downtime and adeptly resolved production (batch and on-line) disputes within time constraints which included monitoring system resources and performing on-call dutiesTatil Life Insurance Limited Trinidad W.I Mar 1998-Aug 2001Programmer/Analyst Successfully completed implementation of Y2K compliant Insurance Package Ingenium 5.5 utilizing COBOL Maintained and enhanced system providing accurate and timely resolutions Proficiently reduced system down time resolving all production issues and concerns in a timely manner Collaborated with team members to ensure data integrity and recoverability Liaised with user departments to ensure all functional specifications were clearly defined Created and edited stored procedures and user defined functions using DB2 SQL.EDUCATIONUniversity of West Indies Trinidad W.I Jun 1995Bachelor of Science in Computer Science, minor in Mathematics *******.********@*****.********* of Life Management Institute (FLMI) designation Jun 2000