• Design, develop and implement data warehouse consisting of more than 150 tables and views.• Develop, test, implement, monitor and maintain ETL solutions to load data into data warehouse from 3 transactional production systems as well as multiple user-maintained data sources.• Complete solutioning of the enterprise-wide ETL implementation of the data warehouse containing more than 15 million active records and 200 million archived records.• Implement a completely… Show more • Design, develop and implement data warehouse consisting of more than 150 tables and views.• Develop, test, implement, monitor and maintain ETL solutions to load data into data warehouse from 3 transactional production systems as well as multiple user-maintained data sources.• Complete solutioning of the enterprise-wide ETL implementation of the data warehouse containing more than 15 million active records and 200 million archived records.• Implement a completely automated data exchange solution utilizing eDelivery system and Unix scripting to transfer multiple files to and from external vendor for daily end-to-end processing.• Create data feeds for Cognos reporting and Tableau dashboards.• Development of a catalog of over 100 scheduled and ad-hoc Cognos reports.• Project management utilizing Agile methodologies.• Member of the team that received the Diamond Award for implementing the data warehouse.• Lean Six Sigma Yellow Belt Certification Show less

Administrative Responsibilities:• Install, configure, fine-tune and monitor Cognos application servers within the enterprise.• Implement security groups and roles for all Cognos project areas.• Review and approve or deny requests for Cognos licenses and access to application areas.• Upgrade Cognos products to leverage new and enhanced system capabilities.• Train and mentor end users to develop Cognos models and reports.• Provide second tier support for more than… Show more Administrative Responsibilities:• Install, configure, fine-tune and monitor Cognos application servers within the enterprise.• Implement security groups and roles for all Cognos project areas.• Review and approve or deny requests for Cognos licenses and access to application areas.• Upgrade Cognos products to leverage new and enhanced system capabilities.• Train and mentor end users to develop Cognos models and reports.• Provide second tier support for more than 2,500 licensed end users of Cognos products with an on-call rotation to accommodate 24x7 support and system availability with 0 SLA breaches in more than 5 years.• Install, configure and manage IIS web servers for the Cognos environments.• Provide subject matter expertise as the lead administrator for the R2 (Reliability and Resiliency) Fault Tolerance initiative for Cognos.• Developed batch scripts to automate the weekly process of system restarts and environment refreshes to optimize system performance.• Completion of disaster recovery documentation and successful implementation during annual exercise.• System administration of Business Object and Crystal Reports. Show less

Development Accomplishments:• Designed, developed and implemented more than 15 different Cognos Framework Manager reporting packages currently being used in production.• Collaborated as the primary Cognos cube and report developer to create and implement a solution to report on application defects pulling data from several different data sources including ClearQuest. The finalized reports were distributed to several levels of management, including the Chief Information Officer, on a… Show more Development Accomplishments:• Designed, developed and implemented more than 15 different Cognos Framework Manager reporting packages currently being used in production.• Collaborated as the primary Cognos cube and report developer to create and implement a solution to report on application defects pulling data from several different data sources including ClearQuest. The finalized reports were distributed to several levels of management, including the Chief Information Officer, on a monthly basis.• Developed a set of management reports from the Service Manager incident and request ticketing system detailing key performance indicators for monthly status reporting. • Developed of a solution for SAS-70, MAR, SSAE-16 and SOC2 compliance certification and compliance reporting pulling data from several different sources of data including SRWT and SAM Jupiter.• Consulted with finance team and developed financial reconciliation reports from BlueMGIC.• Developed a catalog of ASP client access audit reports to prevent data security breaches.• Developed a set of reports that detail direct database update activities in DB2 and Oracle for management to review and justify with staff who performed the updates.• Implementd a solution to track Cognos license distribution and utilization. The reports are used to reclaim unused licenses to contain costs and redistribute licenses as needed in addition to maintaining compliance within our license agreement with IBM. Show less

• Planned, created and maintained all database tables, views, stored procedures and transformations at the enterprise level.• Designed and maintained all relational databases, data warehouses and data marts throughout the organization.• Developed and implemented ETL (extract / translate / load) processes for real time replication and standardization of data from native systems to data warehouses and data marts providing the most current sales data for Susquehanna… Show more • Planned, created and maintained all database tables, views, stored procedures and transformations at the enterprise level.• Designed and maintained all relational databases, data warehouses and data marts throughout the organization.• Developed and implemented ETL (extract / translate / load) processes for real time replication and standardization of data from native systems to data warehouses and data marts providing the most current sales data for Susquehanna Radio customers.• Planned, developed, and implemented business intelligence solutions within the Susquehanna Radio company.• Developed enterprise-wide reporting solutions for all management levels ranging from supervisors to senior executives, including creation of daily Cognos OLAP cubes and reports for real time sales summary analysis highlighting key performance indicators.• Built metadata mappings of sales, financial, and customer relationship data used in OLAP cubes, automated reports and ad-hoc reports.• Managed projects and lead development of CRM packages utilized by 24 Radio Stations in 8 markets nationwide allowing Susquehanna Radio to build superior customer relationships.• Supervised Applications Developer in all short-term and long-term projects throughout entire development life cycle. Determine Application Developer project priorities, goals and bonus objectives in conjunction with senior management.• Recommended system process improvements for customer service, marketing, sales and accounting departments enhancing productivity while maintaining overall corporate objectives. • Researched, recommended, installed, configured and supported purchased software solutions.• Promoted in position to include enterprise level Database Administration of 24 Microsoft Show less

Analyzed, developed, implemented and supported client/server and web based applications for all departments within the divisions of the company nationwide. Developed Contract Tracking Application for $500 million company, tracking 20 different types of critical leases and agreements producing a significant cost savings through elimination of penalties and maximization of discounted renewal rates. Developed applications to expand the functionalities of centralized and… Show more Analyzed, developed, implemented and supported client/server and web based applications for all departments within the divisions of the company nationwide. Developed Contract Tracking Application for $500 million company, tracking 20 different types of critical leases and agreements producing a significant cost savings through elimination of penalties and maximization of discounted renewal rates. Developed applications to expand the functionalities of centralized and distributed accounting software packages. Customized third-party purchased budgeting software to meet the specific needs of the Radio division, resulting in individual employee level budgeting for more than 250 employees with the ability to roll up the budgets to the corporate level. Show less

Developed applications from conception to implementation automating the application, approval and processing functions of all consumer loans within the Retail Credit Division. Planned, developed and implemented several daily processes to run during peak and off peak business hours to facilitate the work flow and balanced distribution of consumer loan applications. Managed File Net document imaging system, including application support and database … Show more Developed applications from conception to implementation automating the application, approval and processing functions of all consumer loans within the Retail Credit Division. Planned, developed and implemented several daily processes to run during peak and off peak business hours to facilitate the work flow and balanced distribution of consumer loan applications. Managed File Net document imaging system, including application support and database Administration. Supported over 300 employees in use of internally developed and purchased desktop Applications. Promoted from Systems Specialist to Senior Systems Specialist. Show less