We provide IT Staff Augmentation Services!

Senior Sql Developer Resume

San Diego, CA

PROFESSIONAL PROFILE

  • Over 20 years of experience in many areas of information technology as a manager, developer, programmer/analyst and systems administrator.
  • Specialization includes in large part Microsoft’s suite of technologies, database design, development, deployment, security, maintenance, performance tuning, backup and recovery.
  • Experience in gathering business requirements, conducting interviews, developing customized applications, design, testing, and deployment of enterprise - wide ERP solutions.
  • Experience in managing computer operations with several companies, maintaining mission-critical systems, providing and delivering recommendations/reporting to all levels of management and the business user community.
  • Good team player with great verbal, written communication and interpersonal skills; proven ability to multi-task, experience in delivering applications and working with cross-functional teams in a results-driven project environment.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008/2012 , Greenplum, Hadoop, MySQL, Access 2010, IBM Mainframe/OS390, UNIX

Languages: COBOL, T-SQL, PostgresSQL, VBA, ASP, ASP.NET, VB.NET, C#, AJAX, HTML, XHTML, JQuery, Javascript, XML, VBScript, Shell, VB

Reporting: SSRS, SSAS, OLAP cubes, Business Objects, Crystal Reports, Access

ETL Tools: SSIS, Visual Studio, BIDS, Data Tools, SSMS, Pervasive Data Integrator

Methodologies: SDLC, Agile/Scrum, Kimball, InmonStar/Snowflake schemas

Network: VMWare, SQL Clustering, TFS, N-tier environments, VPN, TCP/IP, FTP

Other: Dimensional modeling, data mining, MS Word, Excel, Powerpoint, Project, SQL Replication/Mirroring, Adobe Dreamweaver, Flash

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior SQL Developer

  • Created a SQL data warehouse via Kimball dimensional modeling, develop OLAP cubes and

SSAS sales dashboards, and daily/weekly/monthly sales reports with SSRS.

  • Responsible for all SQL database development and administration on company’s ERP platform.
  • Streamlined data replication from ERP system to multiple web site environments.
  • Developed an automated shipping process with C#.NET, AJAX and T-SQL.
  • Coordinated and installed all releases, patches, upgrades of ERP, e-commerce software.

Confidential, San Diego, CA (Contract) September 2012 - February 2013

Programmer Analyst

  • Responsible for software development of organization’s proprietary software, packaging of product releases, performing software enhancements and fixes.
  • Developed in the upstream flow of data from MVS mainframe to SQL Server-based data Warehouses with SSIS, developed reports with SSRS.
  • Collaborated/developed with BI engineer using OLAP cubes and OLTP data sets.
  • Re-engineered client portal, using .NET technologies and SQL Server, the repository for product release Information and universal and client-specific software updates.

Confidential, San Ramon, CA

SQL Developer

  • Created interfaces from MS Access to SQL Server databases using SQL stored procedures, created SSIS packages, and created and customized VBScripts and javascripts.
  • Responsible for streamlining daily processing of various financial systems - working funds, cash receipts, lottery in a linked database MS Access environment.
  • Developed project plan for migrating MS Access systems architecture to .NET/SQL Server environment.

Confidential, McLean, VA

Senior Programmer Analyst

  • Created SSIS packages to extract and archive data from enterprise-wide timecard system (.NET).
  • Developed financial/payroll reports, data constructs using SSRS, SSAS.
  • Created incremental interfaces from host (UNIX), to data warehouse and budget systems (SQL Server), via SSIS packages, stored procedures, OLAP cube design.
  • Streamlined employee data flow from HR/Payroll to and from the financial, timecard systems, using HR/Payroll (People soft - Oracle), to SQL Server-based time and expense systems with SSIS and data modeling.

Confidential, Rockville, MD

Programmer Analyst

  • Successfully completed conversions of both Financial and HR/Payroll systems from legacy mainframe to web-based, .NET application and SQL database server environments.
  • Automated the City’s internal/external forms, including time and attendance, purchase orders, and vendor inquiries using ASP, ASP.NET, Web Services, Crystal Reports.
  • Developed front-end intranet application with ASP, AJAX, JQuery, and SQL DTS packages for daily exporting of expense and revenue budget data from mainframe to web-based platform. This allowed for easier access to financial data throughout the City’s end-user community, and a cost savings with the removal of antiquated equipment
  • Developed SQL data warehouse environments (Kimball methodology), universes with Business Objects for both financial and HR/payroll modules.
  • Responsible for the City’s Financial and HR/Payroll systems: application and database management interfaces, nightly cycle and payroll processes; application of new releases/sub-releases and patches; database maintenance, backups, optimizations, integrity checks. Data modeling used extensively to re-engineer processes for the data conversion and the streamlining of data flow in the new environment.

Confidential, Rockville, MD

Supervisor, Computer Operations

  • Responsible for the mid-Atlantic region data communications hub between host mainframe and 35 regional sales offices, and center personnel. Maintained regional client database.
  • Installed ADP LAN network for operations center personnel, maintained telecommunications node/modems, coordinated links with private, network-wide satellite broadcasts.
  • Supervised 24/7 operations staff. Instituted security platform for client data access.

Hire Now