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.
• 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.

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

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