SUMMARY

• Team oriented approach to success (foremost) while managing customer expectations and understanding the business culture.
• Continuous learning mindset in all aspects of Data Analytics with strong ability to work with both the business and technology.
• 3 years of experience in creating dashboards and reports in Cognos Analytics 11.x (11.08) (Cloud)
• 3 years of experience in upgrade and migration from Cognos 10.x to Cognos 11.x
• 11 plus years of working experience in Cognos BI Suite (Cognos 10.x/ 8/ 7, ReportNet) using Framework Manager, Report studio, Query studio, Analysis studio, PowerPlay Transformer, Workspace Advanced, Business Insight Advanced, Cognos Connection, Event Studio, Metric Studio, Dynamic Cubes, Impromptu Web Reports (IWR), Cognos Connecton and Cognos administrative and security tasks
• Strong experience in client interaction, business requirement gathering and understanding business application, business data flow and data relations from them.
• Excellent communication and interpersonal skills.
• 3 years of experience in Tableau, Power BI and other visualization tools.
• Experience with Motio CI and Moti PI and BSP Meta Manager
• Proven methodology and track record of success in an industry where there is a 75% failure rate according to Gartner.

PROFESSIONAL EXPERIENCE

Cognos Developer

Confidential, Denver, CO

Responsibilities:

• Upgrade from Cognos 10 to Cognos 11 (Both On Premise & Cloud)
• Developed new reports, dashboards and data modules in Cognos 11 using visualizations
• Developed Cognos Framework Manager models/packages (DMR and Relational), Transformer models.
• Performed Cognos administrative tasks including security, user accounts, software installations and deployments and Installed & Configured the Cognos 10 and Cognos 11 BI environment, administering the servers, Troubleshooting etc
• Developed Dynamic Cubes using IBM Dynamic cube designer
• Experienced with Motio PI and Motio CI and other Motio add ons
• Mentoring and training Cognos support professionals
• Experience developing JavaScript controls in Cognos including experience in Cognos version 11.x
• Created Active Reports , Query Prompts, calculations, conditional highlighting and conditional hide/show report objects, Standard Templates, conditions & Filters using Report Studio.

Cognos Developer

Confidential, Denver, CO

Responsibilities:

• Developed Cognos Framework Manager models/packages (DMR and Relational), Transformer models (Powerplay Cubes), Dynamic Cubes using IBM Dynamic cube designer
• Created Dashboard reports using Heat Maps, Tree Maps, Lists, crosstabs, geography maps, prompts and chart reports in Cognos 10 Report Studio, Business Insight and Workspace for depicting Sales Revenue and Equipment Rentals.
• Created dashboards, Reports and data modules in Cognos 11
• Cognos Administration (Creating data source connections, configuration, user profiles, security, permissions etc.)
• Training/Mentoring Cognos users and customers on Report Studio, Query Studio, Business Insight Advanced, Workspace Advanced, Business Insight, Workspace, Analysis Studio, Query Studio and preparing training documents
• Setup Row level, Object level security in the Framework Models and star schema grouping
• Created Reports and Dashboards using advanced visualizations and the RAVE engine

.

Environment: Cognos 11.x, Cognos 10.x (Framework Manager, Transformer, Dynamic Cubes, Business Insight / Advanced, Workspace, Report Studio, Query Studio, Oracle 10g/11g, SQL Server 2005/2006/2008 , Motio CI.

Business Intelligence Developer

Confidential, Wichita

Responsibilities:

• Development and maintenance of Cognos reports, dashboards reports, active reports, drill through reports, Master Detail reports, burst reports, using Cognos 10 Report Studio, Query Studio, Workspace and Business Insight
• Created slice n dice reports and analysis reports using Powerplay, Analysis Studio
• Developed Cognos Framework Manager models/packages (DMR and Relational), IBM Cube Designer (Dynamic Cubes), Transformer models (Powerplay Cubes), Cognos TM1 cubes to solve the BI needs of the user community
• Implemented object level, row level and package level security in Framework Manager
• Established an audit reporting system for the internal team to monitor, analyze performance and usage of different reports, cubes and other objects
• Designed and developed Powerplay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users

Environment: Cognos 10.x (Framework Manager, Transformer, Dynamic Cubes, Business Insight/ Advanced, Workspace, Report Studio, Query Studio, Oracle 10g/11g, IBM DB2, SQL Server 2005/2006, Motio CI, Salesforce

BI Analyst /Cognos Developer

Confidential, Nashville

Responsibilities:

• Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer.
• Developed reports including Active reports, Dashboard reports, dimensional reports using Report Studio, Query Studio, Business Insight, Analysis Studio
• Designed and Implemented 40 Relational and DMR (dimensional) metadata models in Cognos Framework Manager using Cognos Best Practices
• Developed reports using Power Play Studio, Drill down, slice and dice and change displays, Analysis of Power Play cubes in Analysis Studio
• Developed interactive Dashboards using in - report prompts, custom portal pages and inter-portlet communication technique

Environment: Cognos 10.x (Framework, Transformer, Business Insight, Workspace, Report Studio, Oracle 10g)

Cognos Developer

Confidential

Responsibilities:

• Developed metrics, calculations, aggregations using Metric Designer and source as Framework Package
• Developed various reports in Report Net which includes goals vs actuals comparison, alignment and affiliation and net gain/loss reports
• Worked on very complex Cognos reports and re-designed reports so that it can be executed in acceptable time using Query Studio, Report Studio
• Developed models and published packages using Framework Manager.
• Created Power Play models and cubes using Transformer

Environment: Cognos 8, ReportNet (Framework, Transformer, Report Studio, Query Studio)

Cognos Developer

Confidential, Chicago

Responsibilities:

• Built Cognos Framework Manager Models, and established the cardinalities to suit the business needs, published packages, physical and presentation layers in Cognos Series 8 and Cognos ReportNet
• Developed List, crosstab, drill through, master-detail, chart and complex reports using Report Studio and Query Studio
• Created reports with Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases in Report Studio

Environment: Cognos 8, ReportNet (Framework Manager, Transformer, Report Studio, Query Studio)