Gary Pollock Email & Phone Number

Austin, Texas Area

Develop and maintain ASP.NET Forms application to maintain medical and drug records for stop loss functions● Create conformed reporting tables to consolidate interpretations of data● Maintain and improve a conformed data warehouse that implements Kimball ideologies to "pre-answer" business questions● Create and maintain hierarchical cubes for drill-down reporting● Develop and maintain database maintenance procedures to ensure maximum performance of existing resources● Implement encryption and other security measures to safeguard confidential information● Research and coordinate with team to implement improved workflow of jobs for easier maintenance and improved functionality● Research improved development methods and present them to team members for increased productivity● Coordinate with team members to identify obstacles with delivering effective solutions, and assist with presenting solutions● Implement visual-based dashboards that allow customers to identify anomalies faster

Austin, Texas Area

• Develop and maintain ETL jobs within Data Manager• Obtain user requirements for reporting and implement them to create clear and simple reports• Met with users to develop Executive-level dashboards• Champion “Five second rule” with dashboards: within five seconds of viewing a dashboard, the user should know if there is an issue that requires their attention• Lead initiative to implement Column Store indexes for improved SQL Server performance• Managed deprecated SSIS packages, and rebuilt where appropriate.• Managed technical relationships with third-party vendors and customers; developed requirements, and built and maintained data feeds• Worked to rebuild Data Manager jobs into SSIS package to simplify the ETL process• Synchronized work with team members via TFS source control, and coordinated efforts to build a focus-oriented development strategy• Developed technical presentations to demonstrate new features and technologies, both to team members and users• Mentored team members in new development strategies and understanding of business processes. Listened to concerns of team numbers to adapt processes and existing resources where appropriate• Assisted users in reconciling POS sales data with processed invoices to improve reporting quality• Rebuilt gift card reporting from scratch. Built system to identify source of gift card transactions for third-party reconciliation. Identified data connects to pair a gift card transaction from gift card processor with the internal sales order to better report on gift card trends, customers, and uplift• Reporting lead on major CRM overhaul. Built solutions to assist with customer consolidation and identifying customers on sales orders from five different POS systems• Revamped process for report delivery to stores to a single folder location for user ease and data security. Built system that captures store-specific reports and routes them to a single folder for each store, using XML and XSLT.

Greater Los Angeles Area

Develop and maintain stored procedures, functions, and tables for ahouse­made ERP system● Monitor and trace third party procedures to reverse­engineer processes forin­house customization● Manage FTP file loads from numerous clients and federal agencies and exportreport information to user websites and FTP locations● Analyze performance metrics, recommend indexes and organizationalstrategies, and coordinate scheduled jobs and maintenance procedures forserver efficiency.● Work with users for RAD of websites and .Net executables● Determine user requirements and translate into technical documentation● Work with end users to determine and correct system shortfalls● Help create and contribute to internal Wiki to illustrate and document processes● Lead efforts to organize and coordinate development through Team FoundationServer● Develop and implement strategies to synchronize common data and routinesacross multiple architectures in two countries● Develop strategies to distribute workload evenly across multiple servers toensure efficient processing and user response times● Work on and maintain a high­availability system to ensure minimal downtime● Coordinate with a team to facilitate mirroring across multiple states● Assist with testing and actual fail­overs to determine needed processimprovements● Lead developers in creating and implementing strategies for effectively findingand fixing issues● Develop plans for correcting scheduled jobs and after hours tasks● Create system to organize corporate actions in the securities industry, andcorrectly apply it to customer positions● Organize and rebuild complicated federal compliance processes for simple andaccurate workflow

Santa Clarita, Ca

● Led a team using Cognos Data Manager to extract and transform data from aSQL Server database and load it into a level three normalized data warehouse.● Maintained fact tables and type 0/1/2 dimensions. Instructed other users inmaintenance and development● Built and managed metadata models using Framework Manager into starschemas● Led team members in developing new models and conforming dimensionsacross multiple data marts● Used Cognos Transformer to build and maintain OLAP cubes for analytics anddrill­down reporting● Instructed developers and users in proper techniques regarding hierarchies anddimensions, as well as drill­through reports● Worked with consultants and business users in determining requirements,creating simple diagrams of systems, and tailoring the system to the users'needs● Created instructional videos and led web conferences instructing users inCognos capabilities, and anticipating future needs● Maintained security and object migration● Received formal training from the Festus Group in Houston, TX. in Cognostools, as well as Janosys Group in studying and implementing Kimble principles● Attended IBM conferences● Maintained JDE forms, reports, and business functions in sales, purchasing,inventory, and warehousing modules● Developed custom JDE forms and reports to meet the needs of a complexdistribution center● Worked on and developed a comprehensive change management system thatallowed rapid development and detailed auditing● Developed with a team detailed regression testing plans for critical systems● Developed processes and led efforts to successfully integrate ERP systemsthrough two company mergers● Rebuilt critical sales and inventory during a JDE upgrade from the ground up,giving significantly increased performance and additional reporting capabilities● Built a new supply and demand system utilizing sales, purchasing, and contractinformation.

Computer Science

Bachelor Of Science (B.S.), Computer Science