Sr. ETL Programmer, 15+ y.exp. (Seattle, WA)

• Proficient in working with IT/business managers to effectively prioritize activities and achieve defined objectives. Ability to translate business requirements into IT solutions processes (source to target mapping, specification of data transformation rules and development of process to move data through the warehouse environment).
• Experience in database performance tuning.
• Skilled at generating complex queries, decision support system (DSS), warehouse published reports, and other standard means of receiving/sending information from the data warehouse (ETL).
• Customizing documentation to communicate complex technical information to all levels of end-users.
• Fast-paced, flexible senior-level contributor, adept at staying on-task and on-time despite shifting priorities and tight deadlines.
• Combine creativity & problem-solving skills with a high attention to detail.
• Hands-on experience in all stages of system development efforts, including requirement definition, design, architecture, implementation, testing and support.
• Adept at developing effective data models and implementing databases for staging Metadata, data warehouse and data marts.

• Operating System: DOS, MSDOS, Windows 95/98/ XT, Vista, 2000,Windows NT, Novell, PICK, UNIX
• Technical Language: T-SQL, Stored procedures (triggers, rules, views etc…),VB6.0, ASP.NET, C#, HTML, XML, Perl,HL7, HIPAA,ICD9, ERWIN 3.52.
• Databases: SQL Server2005, 2000/6.5/7.0, MS Access, Btrieve.
• Applications: Crystal Reports, MS Office Suite, Visual Source Safe, Visio, UML, BI, B2B, B2C, SSIS, SSAS, SSRS.

• Source to target mapping and Specification of chat and customer call Metadata with transformation rule.
• Generate ETL process to load KPI incident data from DW to the data-mart using SSIS packages for the extract and stored procedures for cleansing the Dimension/Metrics data load to the reporting DM to support business score card.
• Identify KPI data to deliver business value and describe measurable business results to help determine metrics and dimension information needs that will meet the business goal and help identify targeted business process from metrics perspective (why, what and where to measure).
• Troubleshot and resolve SQL errors.
• Generate Excel macro to run SQL query/views to populate row data to feed to score-card/performance-dashboard and pivot table.

• Provide on going support for VMMC hospital for Pre-operative and Post-operative surgery process for scheduling surgical activity for 20-surgical rooms.
• Maintain Omni-Server Database (McKesson Surgical tracking database) changes and assure data/system integrity and update the database from different reporting and format (HIPAA, HL7).
• Generate waterfall surgical block utilization stats report for the surgical services provided by each surgeon (General, Neurosurgery, Ortho, Oncology, Urology, Gynecology, Plastic, Fertility and Ophthalmology).
• Created ETL process to load data from Omni-Server to ORACLE database.
• Assure the daily billing charges are generated correctly for the service rendered.
• Generated routine for transform HL7 data format to local data format upon receipt from different clinics.
• Participated in spear heading vendor selection for the new Surgery system (Surgi-Net).

• Developed a Stored Procedure, for an OLTP application of Facets’ extensions to allow making mass class changes.
• Optimized a claim payee matrix stored procedure for performance enhancement.
• Created multiple stored procedures, views and ad-hoc reports to generate usage reports.

• Generated ETL process to merge Group, Member and Claim data Provider Demography, Provider Credential and Provider contract Metadata from Legacy systems into a centralized data warehouse (FACETS) database.
• Mapped provider data from source PIMS to target FACETS data layout. Worked Created test scenarios to complete the UAT (user acceptance testing) for the quality of the extracted and merged data.
• Created stored procedure to load and scrub metadata from all the different databases to Facets.
• Produced HIPAA related Impact Analysis, High Level Design, Detail design and implementation of changes into each of the OLTP processes.
• Mapping HIPAA transactions to convert existing claims processes according to HIPAA regulations for OLTP Insurance Claims, Eligibility and Inquiry.
• Mapping HL7 transactions to convert existing all EDS data will be compliant to HL7 standards and regulations for OLTP Insurance Provider data and Inquiry.

• Created SQL stored procedure that triggers update, delete and insertion.
• Created Rules to support different business needs.
• Created multiple DTS packages to ETL data from customer acquisition databases.
• Generated multiple stored procedure and ad-hoc KPI reports/Views to generate sales reports and regional statistic reports.

• Completed case study of existing system for creating client demographic tracking system and participated in recommendation of purchasing a server to run MSSQL 7.0 Database.
• Created a 3 tier B2B OLTP application, to add/delete/update data and generate report for management needs.
• Implemented a centralize database schema using ERWIN 3.52.

• Created a PERL Scripts (for WIN32) to monitor Registry activities, test memory leaks and checks hardware integrity in all 8000 Microsoft Servers and capture the data and write back into SQL database for later analysis.

• Created Telephone Fraud application that monitors the retrieved telephone switches data from Oracle Database.
• Created a marketing database that tracks customer’s phone usage by region and advise management if any promotional incentive is needed to boost sales.

• Completed analysis, design, coding and testing of claims holding entry screen programs and conversion routine to transfer POS history to tape to support PBC’ RISC-based PICK systems.
• Modified existing reports, created membership cards printing programs, AUTOSENDBACK and DIAGNOSTIC codes reports and generated BI reports for Insurance Underwriters to analyze capitation expenses for member utilization.

• Created, Coded and tested an interface for the D.O.T. Wage Rate Files from MS-Excel and the mainframe system to download the Wage Rate data to a client server environment. Developed and installed an B2B OLTP automated Clearing House Manager application to allow preferred corporate customers to process account transaction on a secured online system for Seafirst Bank.
• Enhanced the OLTP application for Redwing Shoe Store’s Inventory Tracking Control and Sales Order entry.
• Implemented a report to track departmental sick leave and vacation information from a (CDC) Human resources database for Space Lab Technology management.
• Generated ETL process to load Insurance claims, Group enrollments, member status, and provider credentialing data from client cites to For First Choice Health Network.
• Completed a CASE study of a compliance system and created an OLTP application to allow registering and tracking of commercial motor vehicles, trains and boats for DOT.
• Completed OLTP Invoicing System for Eagle Pitcher Floor Dry Manufacturing
• Scripted SQL query to feed into the reporting process.
• Completed CASE study and requirement gathering for a manufacturing firm (DOMTAR Decorative Panels) to automate the Manufacturing of Panels. Automated the manual process (production-control, quality-control, inventory-control, purchasing, manufacturing, order processing and shipping. The OLTP system supported capturing  data from a Bar-Code system (Shopscan) that collects and distributes mfg data.
• Generated a data loss recovery System for a division of Traveler’s Insurance Company. (Intermec)
• Enhanced and streamed existing accounts receivable, billing, and medical claims application software in order to meet the request from the business needs and requirement.  (PBC)
• Implemented a Provider Credentialing OLTP System to maintain information on all PCM providers. Generated scripts to retrieve and report for PMC providers, Doctors and Clinics..

Contact: Contact information available to DataShaping clients.

URL: www.datashaping.com/resumes16707r.shtml
Please mention datashaping.com when contacting me. Thank you.