*Reply to [email protected] <[email protected]>* *Candidates Who can come Face to Face to Michigan*
Hi, Hope you are doing well, *Job ID : 6154-1* *Title : Cognos Developer with Security Experience* *Location : Farmington Hills, MI* *Duration : 12 Months * *Job Description* Responsible for interacting with key Finance and Controlling users to support the reporting needs within Mercedes Benz Financial Services including production, ad-hoc, and manual reporting. Job Responsibilities: • Work with end users to document existing end user reporting applications in MS Excel and MS Access and identify data needs • Trace and translate SQL and MS Access queries to data warehouse source tables • Create detailed business and technical data dictionary for Finance and Controlling areas • Analyze data needs to identify gaps and work with data warehouse and other IT/project teams to resolve gaps • Generate reports and information for Finance and Controlling • Development of COGNOS repots for Finance and Controlling accurately and within estimated development times and according to the approved scope specifications. • Utilization of Cognos Report Studio, PowerPlay, MS Access, SQL, MS Excel, or VBA to develop new reports, update existing reports, and provide ad hoc support within the BICC environment. • Work with the assigned business analyst to identify data availability and development issues with the report project prior to scope creation. • Gather report requirements and create report specifications; provide estimated effort estimation of effort (in hours). • Work with IT to publish reports to the COGNOS website. • Create daily, weekly, or monthly reports according to delivery schedule. Reports must be accurate and within scheduled due dates. • Resolve production issues for existing reports. Utilize COGNOS 10.1.1 components, PowerPlay, Access, SQL , EXCEL, or VBA to trouble shoot, modify or enhance existing production reports. Reports must be accurate and within scheduled due dates. • Support BICC Team as requested with special initiatives/projects. • Provide external support/extracts when necessary (including vendors, and brand partners) • Work with Data Warehouse team as needed to define new data warehouse tables needed for reporting, including gathering requirements, documenting requirements, and user acceptance testing • Improving the reporting environment by: capturing new change requests and locating the needed data within the data warehouse or source system. • Understanding the file structure of the source systems to the extent necessary to extract and load the needed information. • Update specifications and work with IT to validate the data stage and DM changes. • Provide formal and informal reporting training for the user community. • Manage the structure of COGNOS web portal to provide an easy and intuitive interface to the user community. *Additional Skills* • 8+ Years of experience. • Bachelor’s degree in Computer Science or equivalent • Expertise in Microsoft Excel and Access • Expertise in Structured Query Language • Experience with Cognos 10 - Report Studio, Analyst Studio, Transformer • Experience with Cognos BI Licensing • Experience with Cognos 10.2 Security Object Design • Excellent communication skills • Knowledge of financial processes and terminology preferred Thanks and Regards Hemanth Kumar Sr. Recruitment Specialist Infomatics Inc., AN INC 500|5000 COMPANY 31313, Northwestern Hwy, Suite 219, Farmington Hills, MI - 48334 Direct: 248-537-9039 | Off: 248-865-0300 x 104 | Fax: 248-865-0058 Email: [email protected] | Web: www.infomatinc.com -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
