| CONFIDENTIAL, United States - Plano, TX | Oct 2002 - Present |
|
| Application DataBase Administrator |
|
CONFIDENTIAL, United States - Plano, TX
Confidential
Current role: Application DBA responsible for enterprise-level, custom-developed, web-based global system
Responsibilities:
• Gather requirements and design database schema changes
• Develop triggers, views, and stored procedures
• Create complex DTS packages to transform and export data
• Create and maintain scheduled jobs
• Optimize database through performance and stress testing
• Plan for and implement database release in each database environment
• Adhere to strict CMMI standards |
|
| i2 Technologies, Inc., United States - Dallas, TX | Mar 2000 - Oct 2002 |
|
| Program Manager |
|
Program Manager – 9/01 to 10/02
• Managed 8-person internal web app development team of analysts, developers, testers, and trainers
• Spearheaded mission critical development projects resulting in approx $500K internal cost savings through process automation
• Led project team responsible for creating highly-successful online employee benefits system and two stock option mgmt systems
• Provided technical oversight and mentoring including design brainstorming, code reviews, and specification reviews
• Worked closely with internal customers to plan application vision based on anticipated internal business needs
• Reduced corporate cost structure through identification of redundant or underutilized servers and applications
• Provided direction on technical and non-technical alternative solutions for business needs
Working Manager – 8/00 to 9/01
• Managed three small teams: New Technologies (4 team members), Web Development (3 team members), and Lotus Notes Development (2 team members)
• Implemented development life cycle process tailored for each team
• Developed strategies to integrate existing systems and data
Solution Developer – 3/00 to 8/00
• Created global employee change mgmt application resulting in the reduction of turnaround times from 1 month to less than 1 week, the improvement of data integrity and synchronization, and the elimination of a manual, paper business process |
|
| Software Architects, Inc, United States - Irving, TX | May 1998 - Mar 2000 |
|
| Managing Consultant |
|
• National banking client:
- Created and managed a star schema multi-gigabyte data mart on the Microsoft SQL Server 7 platform for marketing data of a national bank
- Developed data conversion plans and wrote data population SQL scripts to move existing relational data into a data mart star schema
• International oil and gas client:
- Analyzed financial business process to design and implement a low-technology process improvement solution
- Authored and conducted training for financial department
• Internal:
- Authored training materials and conducted MS SQL Server training classes for user groups
- Participated in mentoring program |
|
| Arthur Andersen (Computer Risk Mgmt),, United States - Dallas, TX | Apr 1997 - May 1998 |
|
| Senior Consultant |
|
• Multiple clients:
- Analyzed data to determine if corporate systems were functioning as designed and identified system failures with financial impacts
- Documented and evaluated various business processes to identify control weaknesses and inefficiencies and to recommend process improvements
- Evaluated general controls surrounding MIS departments
• National retail client:
- Reviewed system development life cycle activities of various client/server retail merchandising applications (planning, purchasing, inventory management, and distribution) to identify control weaknesses, potential risks, and opportunities for improvement
- Developed detailed system test plan and test cases for new client/server retail inventory and merchandising application
- Performed system testing for point-of-sale system and merchandising application prior to each being implemented
- Created system certification process for MIS department
• Internal:
- Designed and created Lotus Notes databases for internal use
- Supervised and evaluated the performance of multiple staff consultants and interns
- Participated in extensive recruiting efforts including campus presentations and interviews |
|
| Arthur Andersen (Computer Risk Mgmt),, United States - Dallas, TX | Jan 1996 - Apr 1997 |
|
| Staff Consultant |
|
• National oil and gas client:
- Reviewed system conversion results to verify successful conversion of financial accounts
- Evaluated system controls to identify business risk and points of failure
• National retail client:
- Documented and evaluated inventory costing business processes to identify potential causes of inventory shrinkage
- Analyzed RPG/400 and COBOL programs to identify logic errors related to inventory costing |
|
