John "Rocky" Brown Email & Phone Number

United States

• Design and develop metrics, reports and analyses to drive key business decisions
• Work with IT personnel to maintain tables and cubes, performing updates as necessary to ensure data integrity and accuracy
• Drive the collection and analysis of data from disparate systems for various types of business reports
• Understand data elements in the data warehouse at a very detailed level to support any form of user needs from research to ad hoc querying to managing large information projects
• Provide advice and education to users at all levels within the company on how to leverage BI capabilities for accurate reporting and analysis
• Work closely with business partners in gathering detailed business requirements, establishing business definitions, translating to technical requirements for development team and gaining approval

Atlanta, GA

• Locate and extract data from a variety of sources for use in reporting, analysis, and statistical modeling.
• Identify and source new data for use in reporting, analysis, and statistical modeling
• Develop complex reports and analyses with direction from Project Leaders and Managers.
• Responsible for the design, development, and optimization of TechOps reporting and analytics in support of all areas within the TechOps Division, matrix organizations, and maintenance locations.
• Create several SAS and Tableau reports that can be used by management to help with the reporting of tooling metrics and availability.

Norcross, GA

• Managed a team of analysts in the day-to-day reporting activities, including setting goals for each team member and coaching analysts through performance reviews.
• Recruited, built, and mentored a high-performance team, including providing recommendations for department reporting and process improvements that helped improve technician productivity 6%.
• Served as subject matter expert in department/subscriber information and computer languages.
• Presented data and made recommendations to management in both Tableau and Excel by querying database using Teradata SQL.
• Proved vital in developing territory tools and managed the delivery of critical data projects from requirements gathering to creating data structures, and report building.
• Oversaw the reporting and data needs of business unit initiatives designed to help the business derive value from data analytics for fact-based decision making.

Manchester, NH

• Developed and queried multiple databases in SQL, Oracle, and SAS to gather raw data for multi-departmental reporting and analysis; compiled formatted reports for analysis for internal customers.
• Accumulated cross-functional raw data in SSIS to obtain aggregated data to be used for analysis purposes.
• Recommended improvements to competitive business intelligence reports and data interpretation.
• Created, maintained, and reported relevant metrics and applied findings to help define goals/projections
• Maintained multiple on-going reports/projects while developing ad-hoc reports for several departments.
• Worked with the IT department to develop Pinnacle data that is maintained in Cognos and collaborated with national and regional teams to obtain FCR data and produce metadata for Nexidia for speech analysis.

Philadelphia

• Created and maintained SQL servers/databases for reporting and analyzing purposes for the Care Team.
• Developed and maintained SQL Server and SSRS web portal to report on agent divisional metrics.
• Worked with other regional reporting leads to develop additional reports for the agent web portal.
• Used SQL, Oracle, and SSRS to gather data; transformed SQL data to easily read spreadsheets and reports.

Philadelphia

• Contributed to the creation and maintenance of division-wide web portals.
• Audited Amdocs billing system’s Work Order tables in MicroStrategy against SQL server for discrepancies.
• Created and maintained ad-hoc reporting for several departments.
• Completed TEK Systems’ Learning to Program in Visual C# programming course.

• Collected Amdocs billing data in Access and SQL and relayed to the respective departments; programmed in SQL and VBA in order to obtain information needed for the creation of reports.
• Created and maintained Access and SQL databases for reporting purposes.
• Developed Macros in Excel to convert information from a database into more easily read format.
• Completed Learning Tree International’s SQL Server 2000 Transact-SQL Programming course.