SQL DeveloperÂ Resume

SUMMARY:

Long - term employee of EDS->HPE->DXC Incorporated.
Accomplished individual performer with 11 years of new development and 13 years of maintenance experience as a developer, technical lead, application & data architect.
Full SDLC for 15 new applications and partial SDLC for 7 maintenance applications.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

SQL Developer

Responsibilities:

Submitted and monitored workflows with Informatica’s PowerCenter
Updated complex SQL to improve performance by reducing sub-query answer set size
Created SQL to query 1 billion+ row Oracle tables to identify data errors daily and answer ad hoc questions from the Business Users
Developed and ran ad hoc SQL scripts to resolve data integrity errors in Oracle tables
Created SQL queries for use by the MDM dashboard to provide status information

Confidential

Project Manager

Responsibilities:

Managed the migration of 28 applications from the GRIP SQL Server data warehouse to using the Oracle Enterprise Services Data Warehouse (ESDW) as a data source
Generated security certificate for ESDW web services and distributed to the applications

Confidential

Data Modeler

Responsibilities:

Converted data models from ERwin to ER Studio Data Architect
Created source to target mapping spreadsheets to communicate new requirements to ETL developers
Updated data model for requested changes and published metadata
Generated and applied DDL for Vertica database table changes
Created SQL scripts to populate new configuration tables

Confidential

Data Architect

Responsibilities:

Created architecture diagram to capture scope and focus communication with Business Users, Project Management, System Architects, ETL & Report Developers and Testers
Created the logical and physical data models with ERwin by meeting with Business Users
Generated and applied DDL for new SQL Server tables
Wrote ETL requirements to automate pulling the data and pushing into SQL Server database
Designed database views to support dashboard development by Qlikview team

Confidential

Data Architect

Responsibilities:

Created context diagrams and scope documents for the workflow (Athena) and knowledge sharing (Insight) applications by meeting with Business Users and the Application Architect
Created/updated the logical and physical ERwin data models, object lifecycle diagrams, elementary processes, applied database changes in SFDC and loaded configuration tables prior to each two-week Agile sprint by leading meetings with the Business Users
Reviewed updates to the data model, object lifecycle diagrams and elementary processes with the Athena (China) and Insight (India) development teams at sprint kickoff

Confidential

Data Architect

Responsibilities:

Developed conceptual ERwin data model, object lifecycle diagrams, elementary processes and web page mockups by leading discussions with Business Users
Created the logical and physical data models, generated DDL, created database tables & indexes in SQL Server database and loaded configuration tables during design
Answered Development Team’s questions during design and construction phases
Provided test cases to Testing Team to ensure coverage of elementary process corner cases
Provided application’s database structure and metadata for inclusion in the data warehouse

Confidential

Data Architect

Responsibilities:

Created a physical data model by reverse engineering the SQL Server database into ERwin
Designed the data model changes for each release of the application by meeting with Business Users and the Application Architect to understand the requirements
Generated DDL and applied changes to the SQL Server database
Started the policy of keeping a copy of each record received/sent by/from the application and requiring an archive process for database tables

Confidential

Data Modeler

Responsibilities:

Created an initial detailed conceptual data model for a multi-supplier product catalog and orders application by reviewing the written requirements
Refined the detailed conceptual data model by leading data model review meetings with SMEs to discuss what the requirements were trying to say

Confidential

.NET Programmer and Data Modeler

Responsibilities:

Developed business & technical design documents to review with Users and the Architect
Designed and programmed (Visual Studio, ASP.NET, VB.NET, CSS, JavaScript, Web Services, and SQL Server), tested and verified implementation of enhancements
Created and maintained the logical and physical ERwin data models for a team of 5 developers
Provided application’s database structure and metadata for inclusion in the data warehouse