We provide IT Staff Augmentation Services!

Database Developer Resume

San Francisco, CA

KEY STRENGTHS:

  • Results driven senior level consultant with twenty - two professional experience in Information Technology.
  • Reporting Design Hardware/ Software
  • Support Quality & Process Improvement Analysis
  • Database Design & Development Analytics

TECHNICAL SKILLS:

  • Program Planning
  • Reporting Solution Delivery
  • Cost Control Risk Management
  • High level Change and Budget Management
  • Full Lifecycle Quality & Process Improvement
  • Root Cause Analysis
  • Database Design & Development
  • Proof of Concept

PROFESSIONAL EXPERIENCE:

Database Developer

Confidential, San Francisco, CA

Responsibilities:

  • Work with local and offsite groups - obtain database development and deployment requirements
  • Map and design functional processes for database relational design and migration strategy
  • Create. dsn files for end user inks to Access database files located on shared servers
  • Create and automate high level reports including dashboards and graphs.
  • Create project plans and flow diagrams using MS project and Visio as the main database artifacts
  • Write VBA code for Access to link automatically to Outlook and other Web based applications for reporting needs
  • Oversee Office and SQL deployment security groups (AD). Adding modifying and deleting users
  • Maintained objects, backend and modifications on SQL and Access databases
  • Very high-level Forms, query’s and reports for end user daily workloads
  • Act as “go to” person for end user access to security groups, share drives and other outside security sources
  • Advance use and development “VBA” and T-SQL writing/coding
  • Run test cases and POC during migration and exportation of tables and data
  • Maintain Access/SQL links during regular use and updates as needed
  • Oversee SQL/Access table modifications doing migration efforts
  • Transfer 95% macro based code to VBA (Access/Excel) for deployment streamline and future miniatous
  • Oversee Enterprise deployment efforts during Office to SQL migration

Confidential, San Ramon, CA

Database Developer

Responsibilities:

  • Scope, review, gather end user requirements while projecting a working team environment
  • Create advance Tables, Queries, Forms, Reports based on end - user requirements (Access)
  • Create plug ins to extract data from multiple outside sources (T-SQL transactions)
  • Create NPL (Non Performance Loan) database for tracking and reporting inconsistencies
  • Utilize VB.net in conjunction with SQL for streamline/best practice coding
  • Create table/data models against to be new DW then utilize against Tableau tool
  • Database Performance tuning and SQL Query Tuning and Optimization
  • Automate ODBC SQL to Access database connectivity
  • Create high level views, stored procedures, tables, queries using T-SQL/DDL statements.
  • Create custom or modify current reports (pivot tables) importing and exporting from Excel
  • Document and integrate scalable database into DW platform.
  • Create ad hoc reports used with Excel, OBIEE, Tableau and other 3rd party tools
  • Create in-depth queries for report extracts and email automations
  • Build custom forms and reports with one click automation for end user ease of use

Database Report Writer/Analyst

Confidential, Concord, CA

Responsibilities:

  • Create mitigations for risk tag sheets as requested by system admins and developers
  • Review project scope and out scope activities to determine overall project requirements
  • Work with large datasets from multi applications sources to produce KPIs and Pivot Table results
  • Review project scope and out scope activities to determine overall project requirements
  • Develop, produce complex reports utilizing on sites tools and applications (vb.net, Access)
  • Utilize, SharePoint, Remedy, Discovery, Maximo, Excel and Access
  • Analyze and determine service level tickets to locate better business practices and apply accordingly
  • Construct daily project plans and updates. Consolidation data and milestones for II and III level managers
  • Design, test and execute database migration efforts
  • Schedule and moderate team and all hands - on meetings for project rewind
  • Construct ad hoc reports as needed utilizing SQL and Excel for meeting presentations

Access/VBA Developer

Confidential, San Rafael, CA

Responsibilities:

  • Scope/Design and Develop Acquisition management database
  • Align with core team members to establish requirements and functionality
  • Lead team members though different process and stages during pre - build and project scope create test cases for project scope and end user testing phases
  • Applications utilized SQL, VB.net, Access, Excel and Workday for import and exporting of data
  • High level Project management skills using MS project 2010. Complete custom scheduling and tracking management
  • Create and implement risk management and change request as needed.
  • Create/Work from in-depth/detailed project plan
  • Provide options for new database to enhance functionality utilizing Workday and other outside internal applications
  • Apply best practices with off shore account/acquisitions for acquiring new accounts
  • Create tables and in-depth data modeling for relationship build to 3NF normalization model
  • Establish team environment and auto workflow between the teams
  • Coordinate/ schedule all committee and update meetings
  • Align groups and teams to provide a consistent workflow with 100% on time delivery

Analyst/Developer

Confidential, San Francisco, CA

Responsibilities:

  • Work with management to establish development/scope practice for multi user database development
  • Create SOW, risk analysis and project plan (timeline) to 2nd and 3rd level management
  • Modify, enhance, write high level queries, code, reports utilizing SQL scripts
  • Create custom modifications and enhancements for reports, forms and databases features
  • Relational modifications, review, scope and determine best development practices current databases
  • Create custom sysAdmin panels for database initialization complete with developers backend panels/forms for walk away developers to continue
  • Track DDL changes against objects utilizing DDL triggers
  • Enhance 90% of the objects to work with new enhancements under Access 2010 platform
  • Build plug ins for CMDB database and Hemisphere (Oracle) databases create/write stored procedures, triggers and views for optimal database functionality

SR. Project Manager

Confidential, Fairfield, CA

Responsibilities:

  • Plan/Manage and integrate multiple SaaS/PaaS projects 50M +
  • Plan projects by accurately defining resource requirements, project scope, and deliverables
  • Plan and lead SDLC projects ensuring resource, budget and deliverables are met and on time.
  • Breakdown/set up Data centers management though out different locations within the US and abroad
  • Work directly with telecommunications for break down and setup for wireless services
  • Establish/create best practice processes to ensure all team/vendors are aligned per project scope.
  • Establish, identify and implement new governance process throughout project lifecycle
  • Work directly with legal and external vendors to establish new acceptance guidelines for LOA (Letter Of Acceptance)
  • Align outside vendors and internal teams from inception to CMO+ ( transformation) of data center and Cloud environment implementation
  • Work directly with Telecom, Datacenters (Reno, Vegas, Dallas and UK), VIOP server and team members to establish freeze/cutover for transition to the new environment
  • Asset inventory management for 7 corporate offices and 165 external yards across the US, Canada and UK.
  • Communicate and create reports for both internal and external CIO s, CFO s, directors and regional managers within a PMO environment.
  • High level creation and development (custom) project management with MS project
  • Establish and test Cloud environment POC (proof of concept) between infrastructure and Applications move to new data centers

Data/Hardware/Software Migration Enginner

Confidential, Emeryville, CA

Responsibilities:

  • Work with SME's, managers and end - user to establish resources for complex application deployment.
  • Test and configure applications/hardware and PCs prior to deployment via virtual server test slices
  • Write/rewrite process for global tracking/delivery of assets to sales force staff
  • Align offices with new network infrastructure to replace outdated systems
  • Work with Global staff locations for timing of physical and no touch implementation and migrations.
  • Best practices and Agile methods (waterfall) for asset tracking and deployments
  • Coordinate scheduling Plans for hardware and software deployments with minimal user downtime
  • Test/build/refresh new users PC's for deployment of Win7
  • Work directly with helpdesk to establish new Remedy application and ticketing system
  • Analyze data\applications and configure for OS functionality
  • Manage SCCM for software applications distribution
  • Utilize MS Project to review risk assessments, track milestones and schedules.
  • Evaluate/troubleshoot code, designs and relational concept methods for Connect (Win7) project

Project Management III /Developer

Confidential

Responsibilities:

  • Initiate meetings with stake holders for weekly updates on risk, milestones and Requirements management for in - depth design and layout.
  • Best practices played a large role in the conversions. prepare work documentations on process flows and design methods
  • Worked with the customers/SME (subject matter experts) gathering requirements, for new software development and or maintenance work orders
  • Install Hyperion products, Essbase, HME etc on Oracle db systems
  • After software completion work with customers on deployment strategies
  • Depending on client request software life cycle may be part of the work order request.

VBA/Access/SQL Database Developer

Confidential

Responsibilities:

  • Requirement/Application gathering for restructured platform utilizing VB 6.0 and SQL commands
  • Support SQL database during migration efforts
  • Train end - users on current application that have reached extensive modifications during enhancement development. create triggers, stored procedures and views for optimal performance database admin efforts with supporting databases for migration
  • Create ad hoc reports, SQL scripts, queries and SQL commands

Database Developer

Confidential, Redmond, WA

Responsibilities:

  • Writing and developing Microsoft's Asset Management Tracking Systems (A.M.T.S) for MSN LIVE computer system directory
  • Worked under aggressive timelines to model, design and develop a database system that would be utilized by end - users worldwide
  • Generate, create SQL statements to be used for analytical decisions for AMTS
  • Interview PM'S, End-users, and bi-lingual users to provide certain formats provided by Windows Live conversions platforms to produce and convert to English language formats
  • Database set up to receive data and export data into different containers to keep track of assets at different locations throughout the world while utilizing SharePoint as our main web platform
  • SharePoint Server is used to transfer data into MSN Live for translation conversion of the tracking database

Access/SQL maintence Developer/Analyst

Confidential, Bellevue, WA

Responsibilities:

  • Develop Physical data models and implement in - depth query sets and reports from a main-frame environment (Navigator/Paris) into Access 2003 front-end utilizing SQL for the table Back-end platform environment Automate the formatting cells and exportation from Access to Excel spreadsheets which used Hyperion Excel add in for most reports which were migrated by the individual user
  • Work with BA, End-Users and Analyst to ensure project is on course and achieving milestones within a timely manner
  • Performance tune unstable SQL database - SQL statements, queries, indexes etc

Hire Now