Chanawee Mingmongkol Email & Phone Number

Greater Chicago Area

• Administer, provide backup and recovery processes, and design and development work for ETL processes and data models in an Oracle 10-12, SQL Server 2008-2014 environment. Serve as an individual contributor or manage ad hoc teams of internal employees or external consultants based upon scope and timelines. • Selected as a team member for a key data warehousing project. Supported the team working with Kimball methodology, SSIS and Subversion.• Currently developing a series of dashboards for the executive team running off the data warehouse for use in performance metrics and providing advanced drill down reports to aid in decision-making.Selected Achievements• Revised source code from a defunct vendor package resolving incompatibility with new ordinance changes, generating millions of dollars in annual revenues. • Eliminated a previous manual process for insertion of SQL scripts in previous builds for evaluation or possible reuse.• Developed a configurable SQL Server database with event notification to automate and aid with database administration tasks, including automated backup and recovery processes.• Minimized development and testing turnaround times with extensive use of modular design and reusable code.• Contributed to cost reductions with data optimization and storage strategies, employing improved planning and technological enhancements.• Saved $100K in annual SQL Server and Oracle licensing fees through database consolidation.• Provided in-house conversion services for Oracle database to SQL Server within two weeks. The project was estimated by outside vendors at $80K with a three-month turnaround.

Greater Pittsburgh Area

• Designed, tested, and deployed back-end SQL Server solutions with integrations from multiple data sources to existing front-end systems functionality interfaces, for healthcare insurance claim processing. • Worked with clients and Business Analyst in development of customized functionalities; defined business requirements into functional specifications for development.• Used debugging tools within PowerBuilder, SQL Profiler, and Visual Expert in new development or troubleshooting and repair of existing code.• Employed an in-house development application in testing automation, database analysis, project control, source code revision control, and source code documentation. • Maintained quality standards congruent with internal standards and client specifications throughout development and testing.• Conducted UI demonstrations with development team members ensuring intuitive, easily navigated interfaces. Selected Accomplishments• Streamlined the back-end process for the HIPAA 835 and 837 forms by storing core and customized procedure calls within a table in the order of execution.• Conducted performance tuning identifying bottlenecks and reducing in some cases, processes taking hours to seconds. • Promoted after 14 months in the previous position to provide senior-level development and customization, due to demonstrated technical and leadership capabilities. • Received UPMC's Award for Commitment and Excellence in Service for 2007, which was bestowed to less than 0.5% of employees across UPMC Health System’s 45,000 employees.

Greater Pittsburgh Area

• Managed a workload matrix of 65%-35% back-end, front-end respectfully in database design and front-end functionalities.• Promoted into this position to revive a stalled HIPAA regulatory compliance project two years’ behind schedule.• Catapulted the development effort getting the product ready for release within six months.• Recognized for successfully designing a complex algorithm that cascaded through each patient’s insurance programs calculating max reimbursement, while meeting compliance requirements that changed in project mid-stream.

Greater Pittsburgh Area

• Developed functionality and performance acceptance testing scenarios to determine system stability; documented and reported test results.• Proactively provided assistance and training to junior developers in unit testing and QA best practices for minimizing defect/enhancement tickets.

Master’S Degree, Computer Information Systems, 3.94

Bachelor’S Degree, Computer Science, Finance