Reporting Analyst-GCCX Finance, General Motors, Detroit, MI. Translate OnStar business reqmts to technical specs &technical design documents. Perform anlys on data structures &data elements to design &present reporting solution to support month end close. Analyze &optimize IT month-end financial system processing mgmt &support. Design &dvlp data warehouse interfaces connecting enterprise’s business analytics &reporting needs, using IBM DataStage version 11.3 Extract, Transform, Load (ETL) tool. Implement slowly changing dimensions to preserve history of record &facilitate historical reporting. Gather reqmts, analyze, perform integration &systems testing, &write test cases. Perform user acceptance testing. Optimize &tune SQL queries for high performance &quicker run times. Design reporting solution using Cognos BI tool to automate &schedule daily &monthly reports. Design Business Intelligence Analytics for 4G data plan &refunds. Dvlp &generate reporting analytics for B2B client invoicing. Perform unit, system, integration &user acceptance testing. Create key performance indicator (KPI) dashboard visualization using Tableau tool for leadership. Bachelor, Information Technology, Computer Science, Computer Engrg or Electronics and Communication Engrg, or related. 60 mos exp as Software Developer, ETL Developer, Reporting Analyst or related, designing &/or dvlpg data warehouse using ETL tool. Mail resume to Ref#2155-108, GM Global Mobility, 300 Renaissance Center, MC:482-C32-C66, Detroit, MI 48265.