SUMMARY:

• To obtain a challenging position in the field of database systems as a SQL server/Developer/Architect.
• Lead in a professional environment in an industry where I can explore my inherent talent & past experience to serve earnestly, increase profitability, reduce the down time and grow with an organization.
• To develop accurate and efficient data structures to access and process data.
• To automate existing processes and improve process performance, organization and efficiency.
• 14 years of IT experience & Microsoft certified database administrator (MCTS) with 10 years of experience in SQL Server 2005/00/7 and Oracle 8 - 10 Exceptional leadership skills and experienced in leading teams of 2-10 members
• Thorough knowledge and experience in relational database and object design using Erwin and Kalido for business component model development, implementation and administration.
• Expert in Database Architecture, Storage Architecture, SAN implementation and configuration, Storage Consolidation, Server Consolidation, Migration to 64 bit and SQL Server 2005, I18N Capacity Planning, management and allocation, RAID, Remote Replication (Sync or Async)
• Expert in High availability configuration and Disaster Recovery setup, Server clustering, log shipping, Replication, Database Mirroring (SQL 2005)
• Expert in installing, configuring, and performance tuning SQL Server 2K/2005, Oracle.
• Mastered the art of performance tuning SQL server. Used various tools like SQL profiler, DTA, perfmon.,SQL Refactor, SQL prompt
• Strong background in query optimization, QBE and query analysis.
• Transact SQL (T-SQL), PL-SQL, XML, UML coding, writing queries, stored procedures, cursors & triggers. Excellent experience in SSIS,SSAS,SSRS and SQL-Server Agent
• Address and resolve technical issues related to databases and provide 24/7 support.
• Experienced in detailed Database Documentation using ER Studio and meta data management, Caching Technologies, Data Warehousing, BI and ETL
• Maintain development, test and production databases in clustered environment.
• Good understanding of SQL server security and transaction management.
• Worked with databases in size ranging from 100 GB to 1 TB.
• Experienced in working with SQL server (2000/2005) in a clustered server environment (active/active and active/passive) on windows 2000 and windows 2003 server.
• Familiar with SEI CMM Level 5 and ISO 9001 quality standards.
• Six years as a developer in VB, Java script, C#, AJAX and ASP.Net technology, and Crystal Reports.

EMPLOYMENT HISTORY:

Confidential, Durham, NC

SQL-Dev/Data Architect

Responsibilities:

• Developed financial reports for the IPC(Investment Portfolio Conversion)project.
• Completed restructured the reporting process and saved 30-40 % development time by implementing changes in the linkage processs.
• This enabled a linkage process which involved 20 tables to be completed and tested in 45 minutes otherwise for 3-4 hours.
• Generated a large variety of reports Confidential status, balance sheets, security positions, multiple selection parameters and securities summary.
• Utilized Oracle 10G, Crystal Reports 10, 12 and Toad 10 Completed all reports working Saturdays and 50-60 hours per week. Completed the entire project on time and under budget.

Confidential, Roanoke, VA

Lead Developer SS2005 and C#

Responsibilities:

• Developed custom SSIS components using C# to enable the transformation of data from Confidential databases to Confidential databases.
• Actively developed the Source Adaptor, Transformation components and Destination Adaptor.
• Developed various methods along with other code components to build the classes to complete the package. Debugged and completed the error handling for the completed package.

Confidential, Burlington, NC

Lead Developer, Access to SS2005

Responsibilities:

• Converted Access databases into SQL-Server databases.
• Rebuilt all tables with indexes and Primary keys.
• Documented all metadata and ERD’s.
• Converted all queries and developed stored procedures and views.
• Performance tuned all queries and procedures. Converted Access switchboard reports to a web hosted ASP.Net report application.
• The application enabled the user to select reports or use QBE and add ad hoc parameters to develop a variety of user selected report variations.
• Developed all financial reports AR, AR aging, AP and Depr schedules.
• The application replaced over 100 different reports and enabled users to virtually develop their own reports with QBE.
• The application was developed in Visual Studio 2008 VB.Net with Crystal Reports and SSRS.
• Completed the initial phase of a Data Mart Project to provide the AR department with a tool to access historical data rapidly and accurately.
• Utilized Kimball methodology to build a model to start the project.

Confidential, Raleigh, NC

Project Manager/Developer

Responsibilities:

• Completed use cases with medical and office staff to develop use case diagrams and flow charts.
• Completed business components and data architecture with ERD models.
• Developed class and object models. Implemented a conversion from NT server to Windows 2000 server and completed the active directory.
• Utilized Dreamweaver, Fireworks, javascript, .net to build a website to schedule all appointments, renew prescriptions and search capability through medical info portals.
• Also converted the databases from SQL-Server 7 to 2000.
• Upgraded all financials to Oracle 9i for the business office.
• Implemented all conversions and provided training and support for the next six months.

Confidential, RTP, NC

Lead Dev SSIS, Sharepoint

Responsibilities:

• Completed the team building and sharing application for Confidential in which seven disparate data streams were merged into one real time system with an SSIS package. This system enabled the Confidential inventory team to manage their inventory systems. The implementation of this system required several complex ETL package configurations which were mapped and turned into packages. These packages enabled transfers from Oracle, Excel, Lotus Notes, DB2 and flat files. All data and sign-offs were on the Sharepoint dashboards. Through this collaboration all inventory decisions were made and signed off. SQL-Server 2000 was the main database with sharepoint as the front end. Completed the project with performance tuning using Profiler, DTA and Index defrag. Completed an online reporting system with Crystal reports.

Confidential, Durham, NC

Lead Dev/PM SS2005

Responsibilities:

• The business component models were developed using UML models and diagrams.
• These updates involved new procedures, a conversion to SQL-Server 2005 and financial system update utilizing SSIS.
• Completed the upgrade and trained the new DBA.
• Utilized SQL Server Agent to develop a reporting system through SSRS that ran all reports Confidential night for delivery the next day.
• Follow up included performace tuning with Profiler and DTA and resolved several SSIS issues.
• Completed a retuning of their system by rebuilding all index structures and developing several new stored procedures.
• Developed an ad hoc reporting system using QBE and parameter selections.
• Assisted with the design and implementation of a Kimball Methodology data mart to track oncology patients over the past ten years.

Confidential, RTP, NC

Lead Dev SS2005

Responsibilities:

• Completed class and component models for Confidential & Confidential along with financials.
• This application created job orders, developed and managed schedules for engineers and invoiced for services.
• This database was created from models and application implemented with SSIS and stub code to complete the build.
• Followed up with performance tuning and index building to complete the application.

Confidential, Durham, NC

Lead DEV SS2005

Responsibilities:

• Developed all IT/IS systems for RM Patch construction company.
• Set up all office software and developed estimating and scheduling software for various construction projects.
• Completed all storage and back-ups.
• Instituted a disaster recovery program, server clustering, log shipping, replication, database mirroring (SQL 2005).
• Performance tuned the databases with Profiler, DTA and index defrag.
• Wrote numerous stored procedures, triggers and functions.

Confidential, Tampa, FL

Lead Dev SS2005 BI

Responsibilities:

• Developed a BI system to track and forecast prison system information to aid in forecasting and achieving overall prison management objectives for Confidential .
• Developed data warehouse. Defined all relationships and hierarchies. Developed data source and built and modified cubes.
• Built MDX queries on query and slicer axes.
• Configured dimensions and measures in MOLAP.
• Implemented KPIs, Actions, Translations and Perspectives.
• Optimized aggregations and created data mining model.
• Developed data mining solution with Kalido to measure recidivism results from various programs.
• Resurrected a SQL-Server installation Confidentialin which company had attempted to build its own database.
• Defined requirements with use case models. B uilt the database and managed the application development in C#.
• Performance tuned application with profiler and DTA.
• Developed stored procedures to enhance the financial capabilities of the application along with a SSRS reporting system.
• Rebuilt a poorly performing application for Munn Construction.
• Application was extremely slow and ineffective.
• Repaired problems by rebuilding and performance tuning the application.
• The database was never normalized and never defragged.
• After normalization and defrag the system returned to normal operation.
• Afterwards several stored procedures were added to provide a more efficient operation.