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