- Featured in:
Additional Data Systems Administration Resume Samples
Senior Database Developer Resume Samples
No results found
0-5 years of experience
I utilized all the capabilities of SQL 2005 in innovative ways to maximize efficiency for a state of the art travel software system. In order to improve performance, I used the XML features for coding efficiency and used the BI capabilities for management reporting. Created a unique data-centric interface to inventories of travel data consolidated from a wide variety of business sources. Constantly tuned and improved performance of existing packages as inventory grew to maintain and improve speed and responsiveness.
- Designed new databases for inventory storage and travel details.
- Created database and service for housing inventory by exploiting SQL 2005 XML.
- Standardized security, versioning and architecture to improve maintainability.
- Code demo was used to obtain new financing.
- Introduced BI to company with SQL 2005.
- Trained company in SSAS and SSRS reporting.
0-5 years of experience
Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing, and implementation.
- Documented technical requirement specifications and detailed designs for database design changes.
- Designed database schemas for new features with optimum level of normalization and relationships.
- Implemented various logics through stored procedures, triggers, and user defined functions using SQL Server 2000.
- Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.
- Assisted the testing team in preparing the test cases and validation of data.
- Involved in the defect analysis along with testers to understand the data and to make any modifications to code.
- Designed and implemented the backup strategy for the production databases.
6-10 years of experience
Helped port an existing MySQL design workflow profiling solution to MSSQL, designing and implementing a scalable alternative to support the existing demands for 15 million daily updates.
- Designed and implemented a new test measurement database for a validation team, creating a new data model that is flexible for storing hierarchical data and eliminating the need for never-ending schema changes that were required by the previous solution.
- Identified and addressed the performance bottlenecks for the NSGTest data warehouse, resulting in space savings and a reduction of query processing time (from potentially several hours to minutes).
- Implemented the SSD Channel Return database, making the importing process 50% quicker than the alternative and allowing data from previously different sources to be unified for querying purposes.
- Implemented, delivered and to support the NAND manufacturing data warehouse that was critical for the manufacturing team to support their subcontractor.
- Designed and implemented a component traceability data warehouse and ETL process to allow monitoring of the manufacturing process and enable anomaly detection.
- Designed and implemented a business intelligence solution for analyzing chipset performance, from data warehouse architecture design through ETL processes implementation to report sampling and user training.
0-5 years of experience
Redesigned and built a set of new stored procedures for Cession Load. It was taking 12-14 hours and now takes less than 15 minutes.
- Gathered requirements, designed and built and gained acceptance for a matching algorithm in Transact SQL to replace a piece of software whose license was expiring.
- Gathered Requirements, designed and built and gained acceptance on a dynamic process to automate ingestion of data in to the CRE database from the existing Excel application.
- Provided general knowledge and help with database design, Transact SQL Language and Best Practices.
0-5 years of experience
I utilized all the capabilities of SQL 2005 in innovative ways to maximize efficiency for a state of the art travel software system. In order to improve performance, I used the XML features for coding efficiency and used the BI capabilities for management reporting. Created a unique data-centric interface to inventories of travel data consolidated from a wide variety of business sources. Constantly tuned and improved performance of existing packages as inventory grew to maintain and improve speed and responsiveness.
- Designed new databases is SQL 2005 for inventory storage and travel details.
- Created database and service for housing inventory by exploiting SQL 2005 XML.
- Standardized security, versioning and architecture to improve maintainability.
- Code demo was used to obtain new financing.
- Introduced BI to company with SQL 2005.
- Trained company in SSAS and SSRS reporting.
0-5 years of experience
Designed and implemented a PL/SQL object framework to insulate the application logic from changes in the underlying database schema and to centralize all database access.
- Designed and implemented an XML and XSLT based database querying system hosted on IIS and accessed via ASP pages.
- Developed a product plan and requirements for a web-based, self-service application to allow patients access to their medical records.
- Architectural reorganization of the Oracle PL/SQL database packages and procedures.
- Consulted on performance issues within the middle-tier and the database.
0-5 years of experience
Participated in design and development of system for a medical data exchange.
- Led user sessions for requirements gathering and testing
- Developed data load procedures and ETL jobs
- Provided data validation, data cleansing, data transformation as well as writing and scheduling complex ETL jobs
- Designed, tuned and maintained complicated stored procedures, views and quires.
0-5 years of experience
As Senior Business Information Developer for Automotive Finance Group of Hong Kong Shanghai Banking Company (HSBC) worked directly with business users to develop report requirements and establish department reporting project objectives. Worked independently to create report applications using SQL and Microsoft Visual Basic.
- Developed program code and methods for automating report generation. Automation of report creation reduced time spent each day creating and disseminating reports to end-users.
- Used Crystal Reports, Actuate, or electronic file format such as Excel or Word as end user requirements may dictate to create professional accurate reports in a rapid fast paced environment.
- Accurately mapped and extracted data elements from multiple data sources including Oracle, SQL Server, DB2 and Sybase databases.
- Created supporting documentation of business requirements, functional flow diagrams and specifications to facilitate maintenance of programming projects.
6-10 years of experience
Lead the Data Conversion Team (consisting of technical and non-technical people) in converting over 12 physicians' offices legacy Electronic Health Record (EHR) and Practice Management (PM) systems (variety of heterogeneous data sources, e.g., GE Centricity EHR) to the complex data model housed in the Allscripts PM and EHR systems.
- Gathered requirements, analyzed, designed, and developed a complex ETL BI healthcare EHR and PM data conversion system using BIDS (Visual Studio 2008), SSIS (SQL Server 2008 R2), VB.NET (Visual Basic 2010), SSRS (SQL Server 2008 R2), .NET 3.5/4.0. Created the entire application from scratch - from front-end (user interface and business rules) to backend (e.g., tables, stored procedures, indexes, cursors, user-defined functions, relational data model, referential integrity, normalization and de-normalization, and tuning). Required extensive development of complex T-SQL (DML and DDL) programming code. Created the SSIS Packages using Control Flow Tasks (e.g., Data Flow, Execute SQL, File System, and Script) and Data Flow Components (Sources, Transformations, and Destinations). Wrote very complex Script Components in VB.NET. Required analyzing and retrieving data from many heterogeneous data sources (e.g., Oracle, MS Access, proprietary, etc.).
- Used SSIS to automate the importing and exporting of data to and from SQL Server.
- Gathered requirements, analyzed, designed, and developed a C# (2010)/ASP.NET 4 interface app that sends an ADT feed to the Sharp hospital interface system to write the [company name]'s Medical Record Number to the patient's hospital record.
- Maintained an ASP.NET issue tracking and CRM website using Visual Web Developer 2010, VB 2010 (.NET 4.0), and SQL Server 2008 R2.
- Developed an HL7 engine (parser) using SQL Server Functions to parse incoming HL7 result, patient demographics, and patient registration messages.
0-5 years of experience
Reviewed Data Standard changes and performed impact analysis on the PEIMS system for each year's collection.
- Developed, modified and reviewed SQL scripts, Python ETL jobs and stored procedures to process, validate and verify data, to support reports and application.
- Worked with database administrators and identified Slow Performing Queries, User Defined Functions, and Stored Procedures in the Production Environment and optimized their performance by adding/modifying Indexes, and rewriting them.
- Worked with testers and developers to review and validate test results
0-5 years of experience
Involved in the design, development and implementation of the enterprise-level database systems for corporate tax software solution targeted at various phases of the tax life cycle.
- Collaboratively worked with business users to analyze and document database system requirements, and communicate progress.
- Performed logical database modeling based on Relational and Object Oriented design concepts. Converted logical database model into physical database schema.
- Worked closely with developers while creating, testing and debugging stored procedures, triggers and views to implement business logic and ensure optimal performance of the application.
- SQL Server database development includes logical data modeling, ER diagrams design, building relational database structures, creating and troubleshooting the database objects with high-performance requirements.
- Used SSRS to create interactive, tabular, matrix, graphical or free from reports.
- Leveraged Microsoft Visual Studio Team System (VSTS) for software development collaboration, including the source control and development activity tracking.
0-5 years of experience
Lead DBA responsible for assigning tasks and supervising 2 other DBA's. Primary DBA for Commercial Loan Originations.
- Data Modeling and Capacity planning and Administration; MS SQL Server, Oracle, Access, Visual Basic.
- Monitored and trouble-shot Databases using SQL tools, Monitor systems performance, Analyze and Tune processes.
- Developed and maintained system documentation, security and standards. Develop D.R.plans.
0-5 years of experience
The Web Analytics team is responsible for the My [company name] Reporting Data Mart. The team produces Online Customer Engagement Scorecard (OCE), which tracks certain metrics. The different metrics include billing data, registration information, Customer care information, Calling Center information, web activity, etc. The objective of the project is to move the server to be maintained by IT and to automate it to data sources like BI Tool Microstrategy.
- Validating the data being reported by the two different sources (Server maintained by IT and Web-Analytics team).
- Querying the Data mart to identify discrepancy in data.
- Troubleshooting with the Technical team for issues relating to Oracle Databases.
- Provide suggestions for Optimizing queries, pl/sql code which already exist and for new database objects.
0-5 years of experience
- Provided development, project management and database coordination and support to a large rapid development programming team for a local service support division.
- Defined procedures and methodologies for the life cycle development of the $8+ million project with Project Managers, Systems Engineers, and DBA's.
- The team created and installed all manner of database stored procedures and triggers on both Oracle and SQL/Server platforms.
- Duties included participation of setup and administration of database components and security as well problem identification and solution creation and deployment.
6-10 years of experience
Designed, developed, and delivered Fire/EMS Computer Aided Dispatch System, the guiding principles of which were 99.999% availability, sub-second performance of all API calls, and absolute reliability within a hardened security environment
- Designed and developed database tier, including entity relationships, physical models, data access components, and analysis/reporting
- Developed C# data-tier and client-tier UI software
- Participated in test-based design and development within an Agile/Scrum practice
- Performed functional, work-flow, and load testing of database components
- SQL Server backup, restore, tuning, and maintenance
- Created functional specification documents, use cases, design documents, and participated in design and product strategy
- Environment: Win XP, .NET, C#, SQL Server
0-5 years of experience
Designed and implemented a data warehousing system for database marketing.
- Performed logical and physical database design and implementation.
- Developed packages and stored procedures to enforce business rules.
- Developed data mining and reporting applications integrated to the warehouse.
0-5 years of experience
As a member of design and development team I was tasked with analysis, design and development of Telespectrum Enterprise System Solutions (TESS). This software was developed for telemarketing business and it enabled the systems department to load and unload data from DIALER system to Oracle database and vice versa. The final output was delivered to the clients as per the requested format. The processes were automated in such a way that it handled different format (text, excel, etc.) of data using Oracle Gateway and ODBC. Three Tier architecture was implemented in this system.
- Designed and constructed data services tier for key system components, which includes Input/Output process, Scrubbing, System Security, Error handling and event log.
- Served as PL/SQL and Unix Scripting technical expert.
- Developed Management Reports using Microsoft Active Server Pages (ASP).
- Developed UNIX shell scripts to automate data transfer to different machines at different locations.
- Tuned the database PLSQL packages and procedures for better performance.
- Wrote programs in FoxPro to read data from Dialer system that used FoxPro DBF files.
- Error logging was done using DBMS_PIPE package to communicate between sessions.
- Dynamic SQL feature was used in packages to process Meta data.
0-5 years of experience
CoStar provides information services to commercial real estate professionals in the United States and the United Kingdom
- Provided technical team leadership and documentation for database development team.
- Successfully migrated the Enterprise Databases from MS SQL 2000 to 2005 and 2008
- Developed complex T-SQL scripts, stored procedures, functions, views and other database objects.
- Created and deployed ETL\SSIS packages to meet project requirements.
- Performed database performance tuning and query optimization.
- Researched and resolved all production T-SQL related application errors and job failures.
- Performed database change impact analysis
- Used database administration experience to work with DBA team to implement database schema and programmability changes
- Created database performance reports using Microsoft Reporting Services.
0-5 years of experience
Modeled central customer database to centralize the management of customers across small business units.
- Automated nightly address correction software (called ZP4) to cleanse addresses and identify duplicate records.
- Cleansed data of duplicate company records, incorrect order records, and other invalid data.
- Responsible for ten production servers and seven development SQL Servers running SQL 2000/7.0.
- Created project plans, including Operational Data Store and Data Mart implementation.
- Assisted web developers with stored procedure development, schema design, ADO calls, and ASP coding.
- Developed automated infrastructure for reporting needs using linked servers, stored procedures, and DTS.
- Active participation in management meetings to translate business requirements into database solutions.
0-5 years of experience
Developed OLAP databases in Essbase for a variety of applications, both financial and operational in nature.
- Supported Finance and Accounting.
- Interfaced with all levels of management and users to determine business and data requirements.
- Analyzed business needs to provide best technical solutions.
- Functioned as member of data warehouse team. Continuously worked to improve processes, trouble shoot problems within the entire data warehouse, including Oracle, Essbase and Informatica processes.
- Automated many existing database loads
- Improved load times and accuracy of databases by modifying load processes, calculations and SQL queries
0-5 years of experience
Converted their complex DTS packages to SSIS for migration to SQL Server 2008 from 2005
- Created new reports for application credit grouped by branch and time
- Enhanced reports to drill down by hierarchy rather than branch information
- Created SSIS packages to process transaction files from legacy systems to enable reporting
0-5 years of experience
- Designed and developed SQL Server 2008 SSIS ETL Packages.
- Responsible for a re-factor effort consolidating IAS SQL Server 2008 objects to a single instance reducing overall complexity of the IAS enterprise model and redundant database objects.
- Built production database deployment scripts from TFS and deploy database modifications to QA and Production environments.
- Developed and deployed SSRS reports.
0-5 years of experience
Design and development of SQL Server objects (tables, views, stored procedures, functions, triggers, logging tables, indexes, schemas, databases) to support defined application and/or solution requirements.
- Create reports utilizing excel macros and SQL server tables.
- Design and migrate data purchased from GMA guns into our system utilizing SSIS and T-SQL
- Design and implement complete database architecture to migrate the wine department's Access db system to our SQL Server system utilizing SSIS and T-SQL. The wine department previously sent files for each auction requiring a lengthy, manual process to merge the two systems
- Work independently from home utilizing JIRA software ticketing system
- Design and develop statistical method to present alternative commonly viewed items to customers viewing auction items on the web.
- Design and implement automated text messaging system to notify customers when they are outbid for an auction item or have an item of interest coming up for sale
0-5 years of experience
- Contracted to make modifications to an existing system in Excel (VBA) with a backend of SQL Server 2005 owned by CCE and to be used in CBS.
- Worked from home and attended meetings in office.
- Set up ETL process to pull large amounts of data weekly coming from stores in all 50 states supplied such as Wal-Mart, Sam's Club, Target, CVS, Walgreens, Rite Aid, Dollar General, Family Dollar, Kroger, Save-A-Lot as well as others setup to run over the weekend do to the large amounts of data. Data was transformed from CVS (Coma delimited files) or TXT files to separate SQL Server databases using DTS packages.
- Worked remotely from home.
6-10 years of experience
Designed and developed database objects for trade clearing system.
- Converted the Unix scripts and DTS Packages to SSIS packages
- Designed and developed canned reports using SSRS and Business objects.
- Developed service broker scripts for moving the data from one server to another on real time basis
- Responsible for successfully deploying T +1 Reconciliation tool.
- Actively participated in high visibility projects.
- Responsible for managing sprint (Agile methodology) for the department.
- Provided support to operations and clearing business users
0-5 years of experience
Trading System Portfolio/Money Market conversion from MS Access to MS SQL Sever.
- Data modeling (VISIO) of more than 17 scattered ms access databases to a unified MS SQL server database.
- All business functionality in Access' VBA script translated to DTS Active X.
- DTS/ETL developed for replacing VBSCRIPT loading routines from various sources (CSV, ms excel, SDF).
- Crystal reports front end for report generation.
0-5 years of experience
- Created an Insert -Update stored procedure using SQL 2008 to process new eBook order(s) OR to update any existing order(s).
- Suggested a name for eBook application as eBook Order Management System they accepted it as eBook Management System.
- Created /implemented ER schema diagram using Toad Data Modeler i.e. added new columns, tables to Order Recon Database.
- Particpated in Design meetings on weekly basis for front end of this eBook project and helped in fixing lots of design issues.
- Created a Complex C# application with visual Studio 2008 using classes like DirectoryInfo, DirectoryPath and methods like GetDirectories,GetParent, purpose of this application was to loop through all folders, sub folders starting from root directory and to move all the files from every .Ingest folder to one level up folder.
0-5 years of experience
- Wrote triggers to perform validation on changes being made to tables, tune and optimize complicate SQL queries and scripts that used to generate Report.
- Designed DB table structure for Security Network Walled Garden project.
- Worked on a project using KSH, Stored Procedure to convert IPv4 to IPv6.
- Tune and optimize PL/SQL package, enhance package, write scripts to execute stored procedure.
0-5 years of experience
Tuned and Optimized Stored Procedures
- Analyzed existing database and determined major areas of performance degradation
- Replaced cursors with set operations
- Redesigned stored procedures to eliminate deadlocks
- Used conditional algorithms and conditional indexing on temporary tables
0-5 years of experience
- Data warehousing and batch processing applications (SQL Server 6.5).
- Database related consultancy to the development and management teams.
- Data modeling, database design, functional design, physical design, and implementation.
- SQL Server and NT Administration.
- Projects developed for MSPress: HART Orders Export Process, PubSched to MSP Product Data Transfer, Destiny Data Model Cleanup, PubSched Batch Processing Performance Tuning, RR Donnelley Data Import Process, BISAC 832 Product Catalog Export Process, PressTIGER - Sales and Distribution Data Warehouse.
- Three month loan spell working on the SHARP HRDataMart during the crucial time of final implementation and rollout.