Database Architect
Resume:
BEULAH KINGSLY
Johns Creek, GA 30022
*************@*****.***
Education/Certifications
Masters Degree, Computer Applications, University of Madras, India (Year 2000)
Microsoft Certified IT Professional (MCITP – SQL Server 2005 Database Administrator)
Microsoft Certified Professional (MCP)
Microsoft Certified Solution Developer (MCSD)
Microsoft Certified Database Administrator (SQL 7.0 Track and SQL 2000 Track)
Microsoft Certified Application Developer (MCAD)
Microsoft Certified Professional+Site Building (MCP +SB)
MS Transcript: https://mcp.microsoft.com/Anonymous//Transcript/Validate
Transcript ID: 708509
Access code: BeulahKingsly
Summary of Qualifications
I am a certified SQL Server Database Administrator and Solution Developer with around sixteen years of experience in Design and Development of commercial Client-Server applications for various companies; I have excellent exposure to SQL Server Transactional Replication; Good exposure to HealthCare domain; Expertise in optimizing poorly performing queries and simplifying complex queries.
Professional Experience
Database Architect, Complia Health, Schaumburg, IL (2010-Present)
http://www.compliahealth.com/
(Location: Main office at IL and second office at Boca Raton, FL)
(Working from home for the product ContinuLink – SQL Server 2005, 2008, 2012, 2014)
Set up databases for new customers and for existing customers
Import data received from Customers in various formats to ContinuLink
Optimize queries that perform poorly
Troubleshoot issues related to replication and performance
Write complex queries
Create ad-hoc reports for management
Troubleshoot Support issues related to data/database
Analyze the requirements of customers and create new extracts and reports
.
Database Architect, FEI.com, Columbia, MD (2006-2010)
http://www.feisystems.com/
(SQL Server 2000, 2005)
Worked with Business analysts and architects to develop logical and physical database schemas
Worked with developers to create and optimize database views and query statements.
Developed scripts to migrate database from one version to the next.
Supported multiple development and production environments.
Consistency and integrity of data
Involved in optimizing the poorly performing queries
Analyzed data flows and report production
Translated business rules into application requirements
Database normalization and de-normalization for performance.
SQL DBA / VB and .Net Programmer, Prime Associates (Compliance software) (2005-2006)
(SQL Server 2000)
Prime Associates, Inc. provides compliance solutions for the USA PATRIOT Act, the Bank Secrecy Act, OFAC and enhanced due diligence legislation requirements for banks, insurance companies and broker dealers. This software is used to identify Money laundering. Based on the requirements of the clients, Service packs and Patches are created for both the VB version and the ASP .Net version of the product. Responsibilities included:
Analyzing the enhancement requirements for specific banks.
Involved in modifying the product to cater to the enhancement requirements for banks.
Involved in maintaining the database in the Development environment
Involved in optimizing the Queries
Involved in reviewing the queries written by the SQL Developers
Involved in releasing the Service Packs and Patches.
Involved in making code changes related to Analysis Services.
DBA / ETL Analyst, Department of Revenue, State of Washington (2005)
(SQL Server 2000)
Department of Revenue (DOR), Washington State has a data warehouse maintained on SQL Server 2000. The Department uses some external datasets for identifying non-filers of Tax. The external datasets had undergone some changes in the data structure, which involved addition of new fields and deletion of old fields. This project involved Analysis of the feasibility of the user requirements to incorporate changes in the input dataset to the Data warehouse. This also required a study of the ETL packages and the Business Object Universes existing in the DOR. The project also involved analysis of using a Third party Name and Address matching tool that they were using to improve the Name and address Matching Scores by changing the settings of a file used by the software.
Database Analyst/DBA, Interim Healthcare, Florida (2002-2005)
(SQL Server 2000)
Involved in managing the Database Team.
Involved in system study and System Design.
Involved in designing the architecture of the System.
Involved in designing the architecture for the Database structure.
Designed the Database for the System.
Created DTS Packages to transfer data.
Involved in maintaining the databases for around 50 Business Units for the Organization
Involved in Creating, Analyzing and optimizing Stored Procedures, tuning Queries, maintaining Replication, Backup and recovery.
Involved in writing complex Queries for the system.
Involved in maintaining Backup and recovery and Transactional replication for the system.
Systems and Database Analyst, ICSA (2001)
Involved in Designing the Database
Analyzed the existing data in centura and Transferred the Data from Centura (SQLBase) to SQL Server 2000
Implemented the Workflow engine.
Created the Stored Procedures and triggers for implementing Workflow Engine
Was responsible in identifying the business logic, design and development of the Application.
Involved in Project Discussions and Requirement Specification Documentation.
Involved in creating XML templates that are used for reading and writing to the database.
Involved in coming up with generalized templates in XSL for presentation layer.
QA – Team Lead and DBA, Defect Tracking System (2000)
Checked whether the Database Design was normalized
Set up the Database for testing
Created scripts for sample data
Involved in maintaining the QA Database
Checked for the performance of the Queries used using SQL Profiler
Involved in testing the Application and reporting the bugs
QA – Team Lead and DBA, Sishya-Alumni (2000)
Checked whether the Database Design was normalized
Checked for the performance and efficiency of the Queries and stored procedures used by the development team using SQL Profiler
Involved in testing the Application and reporting the bugs
Team Lead and Database Analyst, Banquets Reservation System (2000)
Converted the data from Btrieve to SQL Server 6.5
Involved in the design of the database
Involved in normalizing the Database
Created an Application to transfer the data from Btrieve to SQL Server 6.5 using the Data Transformation Services in SQL Server 7.0
Created the constraints required to meet the Business rules of the Organization
Involved in maintaining the Database
Used ADO to store and retrieve data from SQL Server 6.5 database
Reviewed the code in Visual Basic and modified the code to satisfy the requirements.
Incorporated the enhancements required in Visual Basic Code.
Contact this candidate