SUMMARY:

A senior software engineer with over 14 years in the industry specializing in SQL Server development, ETL design/development, and SSRS report writing. Looking for an opportunity to assist businesses in database design, analysis, ETL processing, and reporting.

TECHNICAL SKILLS:

Operating Systems: Windows 2003 Server, Windows Vista, Windows XP, Windows 2K

Web Technologies: ASP, ASP.NET, VBScript, IIS, XML

RDBMS: MS SQL Server 2005 (expert), MS SQL Server 2000 (expert), Oracle, DB2, Sybase

Integration Technologies: SSIS/DTS (expert)

Reporting Tools: SSRS (expert), Crystal Report

Languages: Transact - SQL (expert ), VB.Net, VB (expert), VBA (expert),C/C++

OLAP: MS SQL Server 2000

Other Tools: MS Office 2007/2003, MS Access (expert), Visio, TOAD (Oracle tool)

WORK EXPERIENCE:

Senior SQL Server Developer

Confidential, Redmond, WA

Responsibilities:

• Installed and configured SQL server 2005. Developed a database to create daily and month-end data on Xbox inventories. Developed stored procedures and SSIS packages for ETLs, retrieving data from daily flat files produce by vendor and number of data warehouses, and applied logic to prepare and consolidate inventory data. Developed algorithm to date-stamp daily data with previous day considering daily manual feed of Flat file during long week-ends and holidays to ensure data will exist for Fridays in which Fiscal Months end. Wrote technical and user documentation.
• Reviewed and enhanced existing Freight-in processes in MS Access 2007 by normalizing data structure, modifying logic, and adding additional steps to increase data processing accuracy. Developed UIs automating ETL process, and allowing manual update of specific tables by validation and restricted data selection. Created numerous reports for data validations, troubleshooting data discrepancies, and for reporting fiscal month-end figures for account balancing and journal entries. Troubleshot data discrepancies between internal and external data sources and communicated causes and resolutions.

Technical Specialist

Confidential, Seattle, WA

Responsibilities:

• Designed and developed databases in data mart environment, Developed DTS packages and jobs to populate normalized and de-normalized tables, to import data from DB2 and Oracle into SQL Server 2000 accommodating arrays of customer base i.e.: Vendor Management, Consumer Lending, product development.
• Developed OLTP data structures, stored procedures and DTS packages for web applications’ DML objects, and data maintenance processes.
• Helped maintaining databases, stored procedures, DTS packages, and jobs in SQL Server, and process optimization.
• Developed extensively ETLs, writing complex T-SQL and designing DTS packages to upload and update data marts’ regular tables, fact, and dimension tables, to implement requirements assisting Consumer Lending Business Plan and Development, to improve services, reduce costs, and meet customer needs for Digital Loan Files program, National Direct Sales, and Product and Portfolio Management teams, to project future lending pipeline and funding for senior management in setting short and long term goals, and to provide vendor services’ cost analysis and performance.
• Diligently leveraged data in SQL Server databases and worked with team members to ensure new processes are in line with existing procedural operations. Wrote stored procedure processes to modify and/or correlate data according to organizational changes.
• Enhanced data quality by communicating details on data problems to external data sources.
• Developed extensive SSRS scorecard reports and associated linked reports with complex logic to provide monthly and month-to-date measures - flexible with numerous parameters - on various loan processing KPIs for internal process centers and vendor services. Troubleshot data questions in reports and resolved discrepancies in between reports authored by others. Used Excel for quick delivery of data on ad-hoc requests from SQL server on via ODBC connections.
• Developed a search tool in SSRS to determine all related loans and loans' relationship on searched loan numbers/borrower names for Electronic Loan File users.
• Developed cross sell reports in crystal reports in MERSI-1 environment using DB2 data sources. Managed reports migration to MERSI-2 environment.
• Developed OLTP front-end with rich GUI web based interface using VB.NET and ASP.Net to assist loan processors in new digitized environment to track and complete outstanding loan tasks without having physical files. Application was designed with grid functionality. Development included capturing application requirements and developing prototype.
• Converted an elaborate client-server application developed in MS Access into SQL Server back-end. Converted application's queries into stored procedures. Modified User Interfaces' code to operate with SQL Server RDBMS, and stored procedures, and to optimize UI performance. Consolidated databases of 4 locations with complex many-to-many data dependencies into one SQL server database. Managed builds and testing process. Wrote scripts for final data migration and handled deployment process to all sites.

Test Analyst

Confidential, Bothell, WA

Responsibilities:

• Wrote test cases and obtained sign-off for System and integration testing of CRM / Siebel application and in-house applications by analyzing requirements and technical design documents and communicating with business analyst and developers. Test cases covered point-to-point, middleware, and external systems validations. Executed System integration, and ad-hoc testing of 2G and 3G CRM and Table Maintenance applications for number of releases. Identified and reported defects. Utilized Switch Manager, JISQL, Citrix client, OpenStep/Unix, Numeritrack, CBIS, ClearCase, ClearQuest, Visual Source Safe, and in-house tracking systems to fulfill testing process.

Software Engineer, Project Lead

Confidential, Seattle, WA

Responsibilities:

• Developed a Quality Review System in client/server environment for Consumer Lending Quality Review Department and managed project using Bank's SDLC methodology.
• System was successfully launched in four sites tracking loan reviews, maintaining QA referential data chronologically, producing detailed loan review analysis for any given time-period, and handling data transfer between sites.
• Designed and implemented system's data models, interfaces, security, folder structure, and import/export program via defining system requirements, prototyping, and obtaining signoff from business owner and business analyst.
• Programmed front-end interfaces, process automation, and import/export processes implementing elaborate specifications for Main and Sub sites.
• Established INI files to maintain sites' specific features.
• Oversaw reports' development.
• Obtained peer review signoff. Massaged legacy data to produce specific chronological reference data for new system, and converted all legacy data into new system. Wrote system documentation, test plan, test cases for DIT and SIT testing.
• Obtained signoffs on system integration and user acceptance testing. Created user manuals for main and sub sites, covering system navigation, import/export processes, and reports' definition.
• Prepared install instruction and coordinated deployment schedule with groups involved. Established procedures for deploying future sites.
• Using VB developed a Search tool in a client/server environment for Employee Litigation Data Tracking, allowing user to search by a wide range of criteria, and choose desired fields for searching results. Designed and implemented ELDT system's data model, contributed in analysis and documentation of system's requirement definition and functional design.
• Wrote unit test cases for Search tool. Migrated legacy data into new database. Using VB designed and programmed an automated migration program to convert and transfer databases of 3 merged Savings and Loans' Corporate Loss Investigation and Prevention Departments into new system. Participated in peer code reviews and interviewing process of department hiring.

Software Engineer

Confidential, Bothell, WA

Responsibilities:

• Developed an automated Point of Sale data processing application in client/server environment, using VBA and SQL Server, to read, import, and massage distributors' data received in different file formats and settings into databases.
• Import results were time-stamped in log table, reporting on import process i.e.: total number of accepted records, dollar amounts, import duration, and details on each rejected record.
• System's data processing accuracy and performance were extensively tested, by which confirmed 100% accuracy of processed data and 75% improvement in processing time over legacy system.
• Gathered and defined program specifications and business rules by communicating with programmer of legacy system, database administrator, system users, business analyst, and management.
• Designed data map and column definition models to retrieve data from different text file formats, various file settings, and different zip formats.
• Wrote system's technical and user documentation and built program installs via MS ODE tools.

Programmer

Confidential, Seattle, WA

Responsibilities:

• Used FoxPro, Business Objects, DOS, MultiEdit, Visual Basic, and Sybase SQL Anywhere, to customize PORTICO application for each clientele to track and report company's airline activities. Customization process required a detailed and thorough understanding of system's design, logic and various program interactions.
• Participated in system integration testing of new release.
• Developed number of applications in to assist help desk track PORTICO clients' issues and calls' duration and produce various daily and monthly status reports, POTICO programmer and Decision Support production team to track components of existing installs, and synchronize conversion schedule of clientele systems with schedule of existing installs' upgrade and schedule of building new installs.

Application Developer

Confidential, Seattle, WA

Responsibilities:

• Developed a client server application for a brokerage office to track client portfolios of stocks, mutual funds, fixed/variable annuities, and all insurance variation.
• System maintains statement activities on account and sub account levels for reporting growth analysis, updates prices and logs broker's calls made to investment companies on clients' accounts.
• Reports were designed for investment analysis and portfolio maintenance.