Consultant Manager Resume
SUMMARY:
- Over 11 years of solid technical experience in Applications, Data Management, Database Design, Development and Operations by leveragingInformation Technology Service
- Management (ITIL V3) practices, Capability Maturity Model Integration V1.2 (CMMI) process areas and Agile Scrum framework, with proven track record in leading onshore and offshore teams and successfully delivering strategic data management solutions and providing ongoing support work.
TECHNICAL SKILLS:
Databases: DataStax Apache Cassandra, Pivotal Greenplum, PostgreSQL, Teradata, Oracle (12c, 11g, 10g, 9i, and 8i), and SQL Server
Programming Languages: SQL (ORACLE SQL, PL/SQL, Transact SQL, PL/pgSQL, and CQL), JAVA, VB .NET, C#. NET, C++, Pro*C, XML, VB Scripting, UNIX BASH and KORN SHELL scripting, and LISP
Source Control: Serena Dimensions, Lotus Notes, SVN, AND CVS
Framework/Process Models/Methods: ITIL V3, CMMI V1.2, Agile Scrum
Data Modeling Tools: Oracle SQL Developer/Data Modeler, ERwin, ERStudio Data Architect, and Toad Data Modeler
IDE Tools: Toad, SQL Navigator, Oracle SQL Developer, RazorSQLOther Tools: Oracle Data Integrator 12c, Talend Open Studio, Oracle EXADATA, Oracle Grid/Cloud Control (12c, 11g, and 10g), Oracle Streams, Oracle Heterogeneous Management, Oracle Real Application Testing, RMAN, Datapump, OracleReal Application Clusters (RAC), Oracle Data Guard, Oracle Wallet, SQL Plus, SQL Loader, Oracle Scheduler, Oracle Resource Manager, DataStax DSE, HP Service Manager, HP ALM and PPM, MS SharePoint, JIRA, Remedy, ServiceNow, SAP Business Objects XI, UML 2.0, Docker Containers, and Virtualization
Network/Operating Systems: Windows 7 and 10. HP UX, CentOS (Linux), Oracle Linux 7, Red Hat Enterprise Linux, IBM AIX
WORK EXPERIENCE:
CONSULTANT MANAGER
Confidential
Responsibilities:
- Restructured the logical data model of the transactional and data warehouse pieces of the application from Teradata and moved the application schema changes to Oracle and Pivotal Greenplum databases using ERwin Data Modeler and ERStudio Data Architect.
- Ensured that the database designs fulfill the requirements, including data volume, frequency needs, and the long - term growth of data base3d from user stories filed in Jira.
- Assisted in deciding the cross-application data standards, data distribution standards, and tuning strategies. Worked with other architects to ensure that all components will work together to meet goals and performance goals as defined in the requirements. Identified and communicated any cross-area or cross-release issues that may affect other areas of the project
- Ensured that the programmers and operations database administrators responsible for developing the database thoroughly understand the requirements and designs as part of IT Service Management
- Reviewed the database deliverables throughout development to ensure quality and traceability to requirements and adherence to all quality management plans and standards.
- Reviewed and revised the FDM Oracle database parameters and application SQL code, and implemented performance fixes by applying SQL plan baselines, SQL profiles, or rewriting the SQL code. Designed and implemented Oracle Resource Manager to the Oracle databases to manage database resource allocation and scheduling for database sessions and reassessed and implemented changes in system and objects statistics gathering for FDM application database tables for optimal SQL execution.
- Revised logical structures of application tables to make use of Oracle Materialized views and Query Rewrites to improve on SQL execution of ETL and ELT jobs for data lake data propagation.
- Performed basic Oracle DBA functions such as database refreshes using Oracle datapump, performance tuning, data modeling, availability, backup, and recovery using RMAN, ASM, RAC, and database flashback, monitoring using Oracle Grid Control and other DBA functions as needed. Designed and created the Sogeti environment for DataStax Cassandra DB learning and initiatives.
- Served as the main contact point for technical issues filed in ServiceNow by Informatica team and MRO/OSB teams in loading SAP data files to Oracle databases.
DATA ENGINEER III
Confidential
Responsibilities:
- Worked with the customer and end users to define application and technical requirements based from ITIL V3 and CMMI standards
- Defined the structure of the application and technical architecture, ensuring that the structure meets the security business requirements and performance goals, and ensuring that the technical direction is consistent with the client’s long-term direction.
- Reviewed and integrated all requirements for the application, including functional, security, performance, quality, and operations requirements.
- Reviewed and integrated the technical architecture requirements for the development, execution, and operations environments. Obtained stakeholder buy-in for application and technical designs.
- Reviewed application and technical architecture deliverables throughout development to ensure quality and traceability to requirements. Led the application and technical architecture analysis, design, and implementation, and ensure that the product fulfills the requirements.
- Ensured that the database designs fulfill the requirements, including data volume, frequency needs, and the long-term growth of data. Assisted in finding the cross-application data standards, data distribution standards, and tuning strategies.
- Performed basic Oracle DBA functions such as database refreshes using Oracle datapump, performance tuning, data modeling, availability,
DATA ENGINEER III
Confidential
Responsibilities:
- Provided advance technical consulting and advice to others on proposal efforts, solution design, system management, tuning and modification solutions for DB performance issues. Assisted the technical architect to plan and test disaster recovery actions.
- Built, tested, and implemented changes to the databases, analyzed and revised disaster recovery plans, and operations documentation needed by approved work requests. Designed, supported and enhanced design data dictionaries, physical and logical database models using ERwin Data Modeler, and performance tuning.
- Maintained the Configuration Management database for the Data Management team. Developed instructions and maintained operational documents and provided for the operations domain to perform data dictionary back-up and recovery.
- Monitored database performance and space requirements, and perform or supervise database performance tuning.
- Provided instructions and trained operations team for routine maintenance and support tasks.
- Provided second tier support for problems outside the scope of operations personnel and addressed all issues assigned in HP Service Manager.
SENIOR SOFTWARE ENGINEER
Confidential
Responsibilities:
- Led the team in customizing and supporting more than fifty strategic applications, which are written in different technologies such as Oracle PL/SQL, MS Access, VBA, Java, and T-SQL.
- Monitored capacity allocation required in performing application support as needed and escalate capacity shortage as required to the Delivery Lead and ensured compliance with SOX Audit Requirements.
- Developed good working relationship with internal clients to understand and discuss their needs.
- Ensured all source control procedures are followed, technical and application project documentation is complete and up-to-date, and proper release procedures are followed.
- Served a Quality Manager for the projects making sure all Development and Operational work and deliverables adhere to CMMI and ITIL standards and guidelines
