Bernard Stooks Email & Phone Number

Durham, Nc, Us

Raleigh-Durham, North Carolina Area

Environment: Exalytics X2-4, Exadata X3-2, ASM SAN, OVM, Oracle EE 11g, OBIEE 11g, Weblogic 11g, BI Publisher, AWM, JFreeChart, Syncsort DMExpress (ETL), Attunity Replicate (CDC), ER/Studio, Toad, Oracle SQL Developer, Git, Win SVN. Involvement in all aspects of Data Warehouse development and administration, ETL process, monitoring performance and query/database tuning. Collaborate with senior management on the Data Warehouse status and future enhancement requests. Define and enforce governance protocols as well as master data management policies that support the enterprise. Manage multiple teams of technical resources (both onsite and offshore) and ensure milestones are met within the agile framework. Review existing data architecture and make recommendations for enhancements. Performance tuning and enforcing repository best practices. Collaborate with business areas and data owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution. Develop front-end, metadata and ETL specification to support business requirements for reporting across the organization. Responsible for the design, set up and maintenance of both Production and Non-Production environments (User Acceptance, Sandbox, Development). Troubleshoot Production issues, identify root cause and migrate fixes. Develop reporting standards and best practices to ensure data standardization and consistency. Perform data cleansing and data auditing as necessary to ensure data quality. Define and develop physical and logical data models to support departmental and functional reporting needs. Create, maintain, and manage documentation for all data warehouse and reporting development efforts. Help create and implement a long term storage and business continuity strategy including backup & recovery and data storage and archiving.

Environment: Oracle 10g, Sql Server 7.0, ASM SAN, PL/SQL, SQL Loader, DTS, Crystal Reports, .NET, VBS, FLOT, Visio, Maven, Apache Ant, Toad, Oracle SQL Developer, VBA, CVS, Win SVN.Implemented the data model required by the rules engine.Created schema objects while insuring data integrity.Wrote server-side PL/SQL or Java subprograms and client-side procedural code that incorporates business logic. Instantiate applications in different databases for development, testing, education, and deployment in a production environment.Design, code, and maintain the Oracle systems based on established standards. Understand project requirements and develop design specifications. Perform initial design reviews and recommend improvements. Provide technical assistance to other Developers as needed. Analyze and troubleshoot system issues in a timely manner.

Raleigh-Durham, North Carolina Area

Environment: DB2, UDB 8.1, SQL Server, Iway Data Management (ETL), Informatica Powermart, Quest, Q+E Database Editor,Visio, ERwin, IBM Websphere Studio, Visual Studio.net, COBOL, Java , VB, VBA, C++, SQL, Windows, MVS, Win SVN.Responsible for the development and maintenance of the database infrastructure needed for successful analytic processing, providing data interfaces with external databases, and report production. Responsible for a thorough assessment of the business needs behind the requests for new programming functionality. Enhanced existing data warehouses by adding new fields, writing reports, creating dashboards and creating Business Objects filters, measures and objects. Worked with other departments, including Information Technology in the development, testing and promotion of SQL stored procedures and other programming deployments to ensure the work is completed according to established IT processes and appropriate security, version control, and other safeguards are followed. Designed dimensional models with conformed dimensions based on business processes. Constructed and automated that include reconciliation and error handling. Designed and built the reporting environment utilizing SAP Business Objects. Developed processes for capturing and/or maintaining metadata. Acquired an in-depth understanding of the NCFB Ins. business processes and applications and how they affect data and reporting and use this knowledge in the design of the data warehouse and reports. Worked with end users to define and document requirements for new and existing data warehouse components and reports.