Hi Folks, Hope you are doing great,
Please find the below job description for one of our reputed client, if you are interested please send me your updated resume at *dipesh.man...@ngtechinc.com <dipesh.man...@ngtechinc.com>.* Job Title: Cognos Consultant Location: Menomonee Falls, WI Duration: 6 Months Contract to Hire *Job Description* Candidate's primary responsibility is to support and assist Wells Fargo's Funds Management Groups (FMG) Business Reporting technical team (BRT). Evaluate and enhance current state BRT reporting processes by documenting process and dimension overlaps, identifying improvements/consolidation areas and successfully implementing new processes. Handle and lead complex or critical data/ database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or data modeling. The candidate will work as part of a Business Intelligence Team (BI) that is responsible and accountable for the creation, maintenance, and support of the BI environment within FMG. A qualified candidate will: · Provide strong business sense and communication skills to work easily within the BRT and business community; acting as a member within a BI Team, working as a liaison and interface with internal customers of the BI environment. · Understand specific business rules and data flow (i.e. becoming a business subject matter expert for each subject areas within the BI environment). · Provide thorough understanding and ability to work alone within a Cognos reporting environment. · Maintain detailed documentation for the BI architecture, policies, procedures, and standards; ensuring these policies, procedures, and standards are followed according to Wells Fargo policy. *Desired Skills* · *Cognos 10.2 or 10.2.1* - *Framework Manager* - *Transformer* - *Report Studio (relational, DMR, and DMX)* - *Query Studio* - *Event Studio* - *Analysis Studio* - *Business Insight* - *Business Insight Advanced* · *Cognos Workspace* · *Cognos Workspace Advanced* · *Cognos Insight* · *Dynamic Cubes* · *SQL* · *PL/SQL* *Detailed Activities (not all inclusive):* · Evaluate current state Business Reporting Team (BRT) reporting processes. · Document process and dimension overlaps, identify improvement/consolidation areas and implement new processes. · Functional requirements for new and changing processes · Create and document standard workflow processes, procedures, column and dimension lineage and column mapping to tables · Identify, document and help build solutions for common processing and inefficiencies within the BRT · Identify common dimensions used in Marketing and Sales analysis processes · Identify areas to eliminate and/or minimize tools used within BRT (*SAS, PL/SQL, Cognos, Access*, etc.) · Identify, document and help build solutions (SQL coding) for common processing, inefficiencies and new processes within the BRT · *ARD* and *RD* *activity* *code* · *Retail Intermediary cube build code* · Integrity reporting and processes to feed errors back to proper groups · Channel report code · Territory management code · Code to combine flows, AUM and activity · Eliminate unnecessary columns and standardize naming · Identify common dimensions used in Marketing and Sales analysis processes and create standard structures · Create Cognos 10 reporting solutions · *Drill through reporting (cube to cube, cube to report, report to report)* · *Interactive and static scorecards and dashboards* · Standard reporting in Report and Analysis studio using *relational* and *OLAP* *sources* · *Cube tuning* · Review all dimensions in cube, figure out what is being used, eliminate those columns/dimensions that are not being used from code and cube · Eliminate unnecessary columns · Dimensionally model source queries for models Thanks & Regards Dipesh Kumar Mandal Office: 224-764-8408 E-Mail: dipesh.man...@ngtechinc.com www.ngtechinc.com Consulting-Development-Staffing "*Please consider the environment before printing this email.*" -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/groups/opt_out.