Desi Hougaz

• Consulted on migration strategies
• Converted IMS based system to Relational based
• Transformed RAW data to BLOB type in Oracle
• Compression Procedure
• Developed Production Standard Operating Procedures (SOPs)
• Translated existing Standard Operating Procedures from English to French
• Transformed data to LOB type data structure
• Analyzed problematic areas to provide recommendations and solutions
• Improved performance, hiring practices and management systems to facilitate success of client's organization
• Collaborated with teams to define, strategize and implement marketing and web strategies
• Organized and analyzed primary and secondary research to understand industry, market and company trends
• Managed multiple deadlines across several businesses to meet dynamic needs of multiple clients
• Automated system e-commerce features to improve client sales
• Analyzed problematic areas to provide recommendations and solutions.
• Organized and analyzed primary and secondary research to understand industry, market and company trends.
• Collaborated with teams to define, strategize and implement marketing and web strategies.
• Managed multiple deadlines across several businesses to meet dynamic needs of multiple clients.
• Automated system e-commerce features to improve client sales.
• Created monthly forecast templates and resource management allocations for approved projects.
• Aligned closely with business owners and employees to gather information and gain operational insight.
• Implemented practices and procedures to reduce expenditures and increase savings.
• Onboarded and managed new client accounts to boost retention rates.
• Prepared presentations to explain revisions, enhancements and process improvements of organization's systems and programs.
• Integrated technology and business operations to identify targeted solutions to customer issues.
• Supported clients with business analysis, documentation and data modeling.
• Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.
• Created and developed detailed work plans to meet business priorities and deadlines.
• Renegotiated outsourcing contracts to save considerable costs.
• Generated reports detailing findings and recommendations.
• Gathered, organized and input information into digital database.
• Evaluated staff performance and provided coaching to address inefficiencies.
• Developed effective improvement plans in alignment with goals and specifications.
• Maintained overall safe work environment with employee training programs and enforcement of safety procedures.
• Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
• Supported creation of detailed, technical financial models to value potential acquisition targets.
• Educated staff on organizational mission and goals to help employees achieve success.
• Developed and updated tracking spreadsheets for process monitoring and reporting.
• Frequently inspected production area to verify proper equipment operation.
• Optimized customer experience by delivering superior services and effectively troubleshooting issues.
• Observed packing operations to verify conformance to specifications.
• Collected, arranged and input information into database system.

• Performed unit testing execution and support to production implementation
• Production support which involved interaction with clients and other teams
• Used Explain Plan and TKPROF utilities to fine tune and improve performance of applications and database queries
• Used RMAN for various tasks
• Worked on table/index/blob compressions.
• Tested programs and databases to identify issues and make necessary modifications.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Created and implemented database designs and data models.
• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
• Created scripts and processes for data integration and maintenance.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Coordinated with project management staff on database development timelines and project scope.
• Planned and implemented security measures to safeguard vital business data.
• Installed, upgraded, configured and tuned systems and all associated middleware in LINUX and Windows environments.
• Installed, upgraded, configured and tuned systems and all associated middleware in LINUX and Windows environments.
• Installed, upgraded, configured and tuned systems and all associated middleware in LINUX and Windows environments.
• Authored and coded logical and physical database descriptions.
• Managed systems and infrastructures by defining hardware requirements and planning storage capacity for databases.
• Installed, upgraded, configured and tuned systems and all associated middleware in LINUX and Windows environments.
• Installed, upgraded, configured and tuned systems and all associated middleware in LINUX and Windows environments.
• Built databases and table structures following architecture methodology for web applications.
• Developed, updated and organized databases to handle customer and data.
• Developed, updated and organized Oracle databases to handle customer and raw data.
• Built databases and table structures following Chris Date architecture methodology for web applications.
• Eliminated downtime by accurately implementing Oracle distributed databases.
• Implemented BI solution framework for end-to-end business intelligence projects.
• Integrated Enterprise Business Objects infrastructure with Tableau for front-end reporting.
• Designed and developed internal Systems, distributed Databases and analytical data structures.
• Quickly learned new skills and applied them to daily tasks, improving efficiency and productivity.
• Adhered to set schedules to test databases for flaws and reduce downtime.
• Developed scripts and processes for data integration and maintenance.
• Authored and coded database descriptions.
• Designed and developed analytical data structures.
• Installed and configured middleware in Linux and Windows environments.
• Implemented security measures to protect vital business data.
• Built databases and table structures for web applications.
• Created and updated database designs and data models.
• Set up and controlled user access levels across databases to protect important data.
• Modified databases to meet needs and goals determined during planning process.
• Conducted tests to identify issues and make necessary modifications.
• Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
• Implemented BI solution framework for business intelligence projects.
• Coordinated with project management on database development timelines.
• Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
• Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
• Defined hardware requirements and planning storage capacity to manage systems and infrastructure.
• Developed and updated databases to handle customer data.
• Wrote and maintained technical and functional specifications to document database intentions and requirements
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers
• Adhered to set schedules to test databases for flaws and reduce downtime
• Developed scripts and processes for data integration and maintenance
• Authored and coded database descriptions
• Designed and developed analytical data structures
• Installed and configured middleware in Linux and Windows environments
• Implemented security measures to protect vital business data
• Built databases and table structures for web applications
• Created and updated database designs and data models
• Set up and controlled user access levels across databases to protect important data
• Modified databases to meet needs and goals determined during planning process
• Conducted tests to identify issues and make necessary modifications
• Utilized RDBMS tools and utilities to monitor, tune and optimize system performance
• Implemented BI solution framework for business intelligence projects
• Coordinated with project management on database development timelines
• Worked with staff to develop and implement procedures to prevent data loss and maximize system availability
• Determined database structural requirements, working with business stakeholders to identify optimal database specifications
• Defined hardware requirements and planning storage capacity to manage systems and infrastructure
• Developed and updated databases to handle customer data

• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Tested programs and databases to identify issues and make necessary modifications.
• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Created and implemented database designs and data models.
• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
• Created scripts and processes for data integration and maintenance.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Coordinated with project management staff on database development timelines and project scope.
• Authored and coded logical and physical database descriptions.
• Managed systems and infrastructures by defining hardware requirements and planning storage capacity for Data warehouses, DataMart and databases.
• Built databases and table structures following Agile architecture methodology for web applications.
• Eliminated downtime by accurately implementing distributed databases
• Integrated Enterprise Business Objects infrastructure with ERP for front-end reporting.

• Designed Reorganization tool for Relational Database DBAs
• Attended NoSQL and Big Data classes.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Tested programs and databases to identify issues and make necessary modifications.
• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Created and implemented database designs and data models.
• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
• Created scripts and processes for data integration and maintenance.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Coordinated with project management staff on database development timelines and project scope.
• Planned and implemented security measures to safeguard vital business data.
• Authored and coded logical and physical database descriptions.
• Managed systems and infrastructures by defining hardware requirements and planning storage capacity for 10 Gigabytes databases.
• Installed, upgraded, configured and tuned , systems and all associated middleware in LINUX and Windows environments.
• Installed, upgraded, configured and tuned systems and all associated middleware in LINUX and Windows environments.

Accounts:

• SIGNET Bank (Split CICS based system to its own standalone system on MVS) - Richmond, VA
• Johnson & Johnson (Designed Oracle Data Marts on MVS) - Piscataway, NJ
• GM (Built warehouse) – Denver, CO
• US West Communication (participated in enterprise design) - Denver, CO
• Responsibilities:
• Analyzed, designed, and developed complex screens and backend procedures using Oracle (5,6) databases applications development, using Oracle Packages, Stored Procedure, and Functions.
• Enhanced performance of applications using PL/SQL advanced features.
• Performed unit testing execution and support to production implementation.
• Production support which involved interaction with clients and other teams.
• Used Explain Plan and TKPROF utilities to fine tune and improve performance of application and database queries.
• Worked to maintain outstanding attendance record, consistently arriving to work ready to start immediately
• Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork
• Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting
• Developed and implemented performance improvement strategies and plans to promote continuous improvement
• Worked with customers to understand needs and provide excellent service
• Demonstrated respect, friendliness and willingness to help wherever needed
• Learned new skills and applied to daily tasks to improve efficiency and productivity
• Carried out day-to-day duties accurately and efficiently
• Actively listened to customers' requests, confirming full understanding before addressing concerns
• Worked flexible hours across night, weekend and holiday shifts
• Monitored company inventory to keep stock levels and databases updated
• Created plans and communicated deadlines to complete projects on time
• Increased customer satisfaction by resolving issues
• Maintained energy and enthusiasm in fast-paced environment
• Worked within applicable standards, policies and regulatory guidelines to promote safe working environment
• Prepared variety of different written communications, reports and documents
• Used critical thinking to break down problems, evaluate solutions and make decisions
• Handled 50 calls per day to address customer inquiries and concerns

• Product walk through, requirement analysis, design, and full cycle development & implementation.
• Responsible for design, development, and implementation of IMS databases (HDAM, HISAM, BDAM, HISAM).
• Attending FS review meetings and understanding clients’ requirements.
• Preparation of FS as per requirements.
• Schema creation, data configuration, data upload, and conversion related activities.
• Lead IMS DBA.
• DB/2 DBA.
• 24 x 7 support for production and test environments.
• IMS DBA.
• Conducted tests to identify issues and make necessary modifications
• Set up and controlled user access levels across databases to protect important data
• Modified databases to meet needs and goals determined during planning process
• Implemented security measures to protect vital business data
• Coordinated with project management on database development timelines
• Built databases and table structures for web applications
• Wrote and maintained technical and functional specifications to document database intentions and requirements
• Created and updated database designs and data models
• Designed and developed analytical data structures
• Authored and coded database descriptions
• Developed scripts and processes for data integration and maintenance
• Defined hardware requirements and planning storage capacity to manage systems and infrastructure
• Adhered to set schedules to test databases for flaws and reduce downtime

• Beta Gamma Sigma
• GPA 3.9/4.0

Courses taught: COBOL, Fortran and Systems Analysis