We provide IT Staff Augmentation Services!

Cognos Report Developer Resume

Phoenix, AZ

PROFESSIONAL SUMMARY

  • 5+ years of working experience in IBM Cognos BI Tools using Report Studio, Query Studio, Analysis Studio, Workspace (Business Insight).
  • Strong experience with advance data manipulating and presentation using IBM Cognos Reporting Tools, based on OLTP and OLAP data sources; Data Grouping with Subtotals, Filtering, Sorting, Drill - Down and Drill-Trough, Static and Dynamic Prompts, Expressions, etc;
  • Strong experience in Cognos Reports rendering for a variety of client-viewing formats.
  • Proficient in design and development of complex Graphical Reports, using various charts types and drill-through technics.
  • Hands-on experience in developing Dashboards Reports in Cognos 10, using Report Studio and Workspace (multi-tab, global area filters, drill-though functionality)
  • Used advanced features like Conditional Formatting, Auto Cascading single and multi-value Prompts in Report Studio in generating dynamic choice-driven Reports.
  • Experience in designing complex multi-step Joins/Unions inside Report Studio to prepare custom Report queries.
  • Understanding of multi-layers Framework Models. Focus on proper relationships, usage, cardinalities, report-friendly names, global filters.
  • Familiar with creating and publishing packages in Framework Manager.
  • Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
  • Experience with Query Studio and Report Studio for report model design, ad-hoc reporting and advanced report authoring.
  • Involved in a data migration process between Cognos 8.4 and 10.1/10.2.
  • Experience managing subscriptions, scheduling and deployment of reports and uploading files to a report server catalog from the report manager.
  • Strong understanding of dimensional modeling (Star and Snowflake Schemas Methodologies) for building enterprise data warehouses (EDW).
  • Experience in all phases of Data warehousing concepts, based on dimensional modeling using Star and Snowflake Schemas, Data Marts, time dimension, confirmed dimensions.
  • Strong experience in client interaction and understanding business application, business data flow and data relations from them.
  • Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.
  • Experience with ErWin logical/physical DB diagrams design, reverse engineering, reports.
  • Experience using Windiff for files comparison.
  • Experience using Oracle, SQL Server, MS Access as reports’ data sources.
  • Excellent communication and interpersonal skills.
  • Experience in writing SOW (statement of work), POC (proof of concept), business/technical/functional requirements, user manuals, deployment instructions, etc.
  • Experience working in Reporting teams as well as stand-alone Report Developer with very light supervision.
  • Attentive to details, focused on deadlines, eager to design user-friendly, well-designed and presentable Report solutions.

TECHNICAL SKILLS

Reporting Tools: IBM Cognos Business Suite 8.4/10.1/10.2 (Report Studio, Query Studio, Analysis Studio, Workspace), SSRS, MS Access, Seagate Crystal Reports

Databases: MS SQL Server 2005/2008/2012, Oracle 10g/11g, MySQL, MS Access

Supporting Tools and Software: SQL, XML, HTML, TFS (Team Foundation Server), Visual SourceSafe, Perforce, VBScript, Visual Basic, ADO, ODBC, MS SharePoint, MS Office (Word/Excel/Outlook/Access/PowerPoint/Publisher), Erwin, WS FTP Pro, CuteFTP, FileZilla, WinDiff

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Cognos Report Developer

Responsibilities:

  • Remote, visiting and on-site positions for multiple company clients.
  • Based on client requirements and existing data warehouse and/or transactional databases designed and developed Cognos reports/dashboards to represent claims / sales / marketing / medical billing / educational -related information by different aspects.
  • Responsible for managing new and existing Cognos connections, report formats and delivery methods, etc.
  • Used various Reports technic: List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
  • Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.
  • Created Dashboards to present critical company data in a single report.
  • Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio
  • Was responsible for reviewing and verifying all Framework elements according to users’ and reports’ specifications.
  • Gathered and analyzed business requirements from users on various level of authority and expertise.
  • Analyzed existing transactional database schemas and star schema models to better understand and implement users reporting needs and requirements.
  • Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
  • Was heavily involved in interaction with various levels of user: Management, Business users, IT teams, analytical team, sales team, marketing teams, etc.
  • Wrote business rules, functional and technical documentation for various projects based on company-approved templates and practices.

Confidential, New York, NY

Cognos Report Developer

Responsibilities:

  • Designed, developed, deployed and supported multiple Cognos reports for non-profit educational organization, one of company clients.
  • Developed multiple Cross-tab reports, graphical dashboards with drill-through capabilities.
  • Managed report bursting, subscriptions, connections.
  • Was heavily involved in interaction with various levels of user: Management, Business users, IT teams, analytical team.
  • Wrote business rules, functional and technical documentation for various projects based on company-approved templates and practices.

Confidential, New York, NY

Report Developer

Responsibilities:

  • Designed, developed, deployed and supported multiple SSRS and Cognos reports for the company clients.
  • Participated in Cognos 8.4 to 10.1 conversion process.
  • Was heavily involved in user interactions and negotiations.
  • Gathered and analyzed business requirements from users on various level of authority and expertise.
  • Acted as QA Analyst for various company clients.
  • Wrote data quality, functional and technical documentation for various projects based on company-approved templates and practices

Hire Now