At Zirous, we've provided IT Solutions to our customers for 30 years. Our ultimate goal is to improve our customer's business process by leveraging cutting edge technologies. We aim to increase efficiency, productivity and profitability with:-Identity Management-Integration-Data Analytics-Hadoop/Big Data-Cloud-Database

• Managed a data infrastructure team that supports the Risk Analytics and Corporate Pricing teams• Managed a team of developers utilizing Base SAS 9.4 and IBM Netezza to create and maintain the data repository for the Risk Analytics department• Implemented a process to document, track, and prioritize all incoming requests in order to more efficiently serve our customers• Oversee the development of dashboards in Tableau and the planning phase to convert many Excel based reports to Tableau

• Design and implement data warehouse database structures using a star schema model• Architect data models for transactional applications• Implemented database changes to our current transactional system database to create a more scalable data model• Assign, coordinate, and review work of current database developers and business intelligence report developers• Converted over 300 Oracle database objects (packages, views, functions, procedures) as part of a migration to a modified enterprise data model• Maintain the transactional system and data warehouse data model using PowerDesigner• Maintained the relationships with our external MicroStrategy consultants• Implemented and maintained the MicroStrategy reporting application• Write, update, and maintain Oracle packages, procedures, and views for new and current applications• Interview, hire, train and supervise staff for the database and business intelligence teams

• Participated in the selection of a new business intelligence application• Researched and completed database maintenance related tasks as requested by the business users

• Developed ETL procedures (Oracle PL/SQL) between source systems and the data warehouse• Created enterprise reports using Business Objects• Designed and maintained the Business Object universes

• Conduct meetings with members of the Operations department to gather requirements for requested reports. Research the table location of the relevant data and write the report specification document and present it to the end user for verification. Present the data to the end users in Oracle Discoverer or though Microsoft Excel using an ODBC connection to the database.• Create custom tables, views, procedures, and custom indexes using PL/SQL as needed to improve reporting efficiency• Generate ad-hoc queries as requested by the business units and utilizing TOAD and presenting the data to the end user in Microsoft Excel• Created a GUI application in Microsoft Access for a business unit that allows the end user to maintain data in the Access database and click a button to extract data from the ERP database• Designed a Microsoft Access database to organize and maintain a listing of the department’s reports• Managed a group of two people on a project to convert custom ZPL (Zebra Programming Language) labels to a new format for a major implementation.

• Gathered business requirements from the client and translate the requirements into detailed technical specifications for report building• Created on-request reports based on the requirements from the client using Business Objects and free hand SQL• Created universes using Business Objects and administered the security of Business Objects using Business Objects Supervisor

• Conducted formal internal and external audits for Fortune 500 companies (financial industry)• Assisted in the assessment of business risks and made recommendations on improving internal controls• Participated as a core member of a team that performed internal control reviews for Sarbanes-Oxley clients by interviewing clients, reviewing current documentation, and testing the controls in place