Debbie Schiller

• Optimizing existing queries for better performance using SQL query tuning techniques.

• Analyzing business requirements and translating them into logical data models.

• Testing changes to ensure that the system works correctly after implementation.

• Using T-SQL scripting language for creating stored procedures and functions.

• Designing and developing complex SQL queries for data analysis and extraction to support business decisions.

• Automating routine database tasks through scripting, reducing manual intervention and improving productivity.

• CoreCivic's Cognos advisor for all Cognos developers in various departments.

• Assisted in troubleshooting and teaching new methods of writing reports.

• Provided guidance on best practices for developing efficient reporting solutions.

• Developed and maintained complex report models and packages in Framework Manager to support reporting needs.

• Modeled metadata from Oracle data source for use in Cognos 11 Framework Manager.

• Worked with end users to gather requirements and documented requirements.

• Worked closely with Business Analysts and End Users to ensure that their reporting requirements are met accurately according to their specific needs.

• Translated and performed business data analysis for user needs into technical requirements.

• Developed and maintained Cognos 11 reports for management and analyst end users.

• Identified and implemented efficiencies and process improvements by working with other teams.

• Managed a team of 20 offshore contractors for the Cognos Reporting conversion to Power BI project.

• Trained new and existing users on how to develop reports using Cognos 11.

• Created SQL queries to extract data from Oracle databases for use in Power BI.

• Developed, maintained, and managed Cognos packages using Framework Manager
• Monitored and supported multiple jobs, scripts, and events
• Analyzed, prepared and completed report conversion of Cognos 10.2.2 to Cognos 11.0.9 Analytics
• Developed user reports in Cognos 10.2.2 and 11.9 for departments without analysts and developers
• Deployed and supported Cognos reports, ad-hoc packages and OLAP cubes
• Set-up, maintained, monitored, and supported Cognos security groups and accounts
• Tuned and configured Enterprise platform based on IBM Cognos best practices and recommendations
• Monitored and managed scheduled jobs to assure that stakeholders receive analytics to drive their business
• Wrote and maintained technical documentation

• Administered application architecture and ongoing production support of COGNOS BI suite of products

• Performed COGNOS enhancements, installations and upgrades (COGNOS 10.2.2) – Distributed and single server installs

• Created, planned, and implemented security protocols to support HIPAA standards. Used Microsoft Active Directory groups to set up Security groups.

• Audited and defined environments

• COGNOS subject matter expert for Premera Blue Cross and its division users

• Project lead on project modules within the Application Management team

• Promoted disciplines of business intelligence lifecycles

• Developed, architected, and maintained COGNOS Framework Manager models, OLAP security models (COGNOS Transformer)

• Managed the scheduling and distribution of business intelligence views, reports, and OLAP applications

• Partnered with required Information Technology staff to troubleshoot and resolve system problems

• Responsible for Tableau administration

• Performed analysis, design, and document report requirements

• Worked with business users to capture reporting requirements. Users include VP’s, directors, managers, CPA’s, accountants, analysts, and consultants

• Project lead on project modules within the Application Management team

• Created and documented COGNOS report specifications with detailed database mapping

• Developed, architected, and maintained COGNOS Framework Manager models, OLAP security models (COGNOS Transformer)

• Managed the scheduling and distribution of business intelligence views, reports, and OLAP applications