SUMMARY

• Over 7+ years of specialization in OLTP/OLAP/Data Warehousing, BI tools and in analysis, design, testing, development, and implementation of client server applications.
• Extensive experience working with Cognos 10.x Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio, Transformer, Dynamic Cubes, Workspace, Workspace Advanced, PowerPlay Studio).
• Experience with the Enterprise level Cognos administration and Framework Development support, which includes the installation, configuration, administration and maintenance of a business - critical Cognos product set in a 24x7 production environment.
• Implemented Enterprise level Cognos security and Server Administration using Cognos 10.x/8.x and administration of security using Access Manager, LDAP and Custom Authentication Provider.
• Installed, configured and worked on multi server Cognos BI suite, including Business Insight & Advanced, Report Studio, Analysis Studio, Workspace Advanced, Cube Designer and Framework Manager.
• Experience in creating models and implementing the Security using User Classes in Cognos Administration.
• Created IQD’s in Framework Manager to use in Cognos Transformer using externalized method.
• Hands on Experience with Framework Manager Modelling (Physical Layer, Business Layer, Presentation Layer) and Complex Reports building with Report Studio.
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill-through, Master-Detail and Cascading) and Dashboards using Report Studio.
• Worked on Transformer for Modeling of the corporate data for building up of Multidimensional Cubes.
• Developed Power Play cubes which involved model definition in Transformer, used multiple data sources, calculated measures, Customized views and Optimized Cube building process.
• Designed Dynamic Cubes - in memory tool using Cube Designer tool and deployed in the Cognos environment to increase the performance.
• Experienced in working with RAVE Visualizations in Cognos Workspace Advanced and Report Studio for building interactive reports for the end users.
• Experienced in using Java script and HTML to create dashboard reports.
• Experienced in Migration of other reports into Cognos and version up-gradation in Cognos.
• Involved in COGNOS administration and security implementation among COGNOS Applications using Cognos Access Manager, LDAP, and Custom Authentication Provider. Performed administrative roles in COGNOS Connection and set security permissions, configured and maintained users, groups and roles using COGNOS Administration.
• Knowledge of data warehouse techniques and practices, including BI Reporting, relational modeling, OLAP, Star schema & Snowflake schema.
• Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business information requirements, technical designs, development, integrating, Implementing and Production Support using Cognos as a BI tool.
• Good knowledge in Business Objects and integration Cognos with pega using SOAP and have experience with Cognos Maps. Full understanding of the ETL (Extract, Transform and Load) solution concepts and functional knowledge of Informatica.
• Had experience in writing SQL, PL/SQL, Stored Procedures, Functions, Packages
• Experience in Designing and Deployment of Reports for the End-User requests using SSRS and Tableau. Experience in IBM Cognos, a Business Intelligence reporting tool to generate reports for non- IT users.
• Proficient in creating documentations like BRD, SRS, FRD, RFP, Wireframes, Mock-ups and conceptual design; creating Use Cases, specifications and Use case scenarios.
• Proficient in analyzing and creating Use Cases, Use Case Diagrams, Data Flow Diagrams, Activity diagrams, Class diagrams and Sequence diagrams using MS Visio.
• Major area of expertise in designing and developing Decision Support Systems (DSS) and Business Intelligence.
• Full SDLC experience includes writing design documents and test plans and conducting unit and system testing.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem-solving skills

TECHNICAL SKILLS

BI Tools: Cognos Analytics 11.X, Cognos 10.2.X, Cognos10.1.X, Cognos (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace, Cognos workspace advanced, Cognos Mobile, Cognos administration, Tableau Desktop 9.X, Tableau Server 9.X

Modeling Tools: Cognos Transformer, Cognos Framework Manger & Cognos Cube Designer, Cognos Dynamic Query Mode

ETL Tools: Informatica, Oracle Data Integrator(ODI)

Languages: SQL, PL/SQL, HTML, MDX, Java script, Python

Databases: SQL Server, MySQL, Oracle 11g, Teradata, MS Access, Vertica

Cloud Platforms: IBM Bluemix, Amazon Redshift

Operating Systems: Windows 2003/2008/2012 R2, UNIX, Sun SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, Ohio

Sr. Cognos BI Consultant

Responsibilities:

• Analyzed data to understand business requirements and created a new functional design.
• Identified data sources and build pilot reports and cubes to keep the requirements in sync with business needs.
• Worked with dimensional modeling of relational data sources (DMR) using Cognos Framework Manager.
• Designed, developed, refreshed and maintained the Cognos Power cubes using Power Play Transformer.
• Developed Framework Manager Models for different reporting projects within the organization to satisfy the needs of different departments and various projects and published packages to the Cognos Connection.
• Created various joins, filters, calculations and followed the aesthetics of package development.
• Wrote reports using Report Studio for creating dashboards by using specific color coding schemes for Charts, Trend Lines, Bar graphs, Stacked Charts, Pie Charts and Inline Charts.
• Used various query components of Report Studio including Join, Union and Intersect.
• Implemented Data Source level, Object level, Data level, Package level, Folder level security on Cognos by creating new security Groups and Roles.
• Involved in building Portal Pages and designing them according to user requirements.
• Developed Performance Charts, Dashboards and Scorecards using Report Studio.
• Extensively worked on cube refreshing on daily, weekly and monthly basis using scheduled tasks.
• Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, publish packages to Cognos connection.
• Implemented data level security using parameter maps, session parameters and macros.
• Cognos Active reports were used to develop interactive reports and dashboards using data decks, tab control items
• Developed drill through definitions to create drill through between Analysis studio and canned reports.
• Used SQL Developer to access and analyze data directly from Oracle databases and testing reports data with Hand written SQL.
• Proficiently customized the look and feel of the dashboard using HTML items for improved visual presentation.
• Worked on third party integration of Cognos with PEGA by utilizing Cognos Mashup services.
• Trained end users on how to use Cognos Connection, Query Studio and Analysis Studio.
• Developed few reports using Microstrategy and Tableau.
• Developed Dashboards using Cognos Workspace tool and trained end users how to create custom Dashboard using Cognos Workspace.
• Supported the reports in Production environment and transferred knowledge on maintaining/modifying reports in the future to the support team.

Environment: Cognos 11.x/10.x (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration, Cognos DQM), IBM DB2, Windows 2003/7, Toad, Microsoft Excel, SOAPUI.

Confidential, TX

Sr. Cognos BI Developer

Responsibilities:

• Worked with Business Users to get the user requirement for creating multi-dimensional cubes and canned reports.
• Developed multidimensional models from multiple data sources using PowerPlay Transformer.
• Refined the multi-dimensional models using special categories like excel, IQD, packages, alternate drill-down path, calculated measures, etc. to better suit user needs.
• Partitioned Power cubes and updated the cube using incremental update.
• Did performance tuning on power-cubes to reduce query time and partitioned cubes.
• Updated Power Cubes with new data base columns using IQDs generated in Framework Manager via externalized method.
• Used PowerPlay for further analysis, slice and dice, drill down and creating reports from cubes.
• Involved in design phase, gathered requirements from users and documented/designed/developed report specifications including report documentation for creating reports using Report Studio.
• Developed Complex reports using Report Studio which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.
• Created multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting.
• Worked on 3 tier metadata modeling in Framework Manager and published multiple packages.
• Designed Dynamic Cubes - in memory tool using Cube Designer tool and deployed in the Cognos 10 environment to increase the performance which is using large data sets.
• Worked with the RAVE Visualizations in Cognos Workspace Advanced and Report Studio for building interactive reports for the end users.
• Created POC for Active Reports (using data tabs, data decks etc.) and Dynamic Cubes in Cognos 10.2.
• Updated Active Reports using Scheduled jobs.
• Installed, configured and administered various Cognos components such as the Cognos BI server, Framework Manager, Transformer and Cube Designer.
• Upgraded Cognos from 10.1.1 to 10.2.1 and tested for multiple environments like Development, Testing, UAT and Production using Cognos life cycle manager.
• Used Cognos Dynamic Query mode (DQM) to check detailed logging and query visualization for reports.
• Supported the reports in Production environment and transferred knowledge on maintaining/modifying reports in the future to the support team.

Environment: Cognos 10.x (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration, Cognos DQM), Pentaho(Kettle), Windows 2003/07, Toad, Microsoft Excel.

Confidential, CA

Sr. Cognos Report Developer

Responsibilities:

• Analyzing and reviewed business requirements and Technical Specifications for Report development.
• Involved in troubleshooting of Complex reports by identifying Query subjects, Query items that needs to be fixed.
• Modified the existing report designing according to the new business requirements.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Incorporated different reporting functionalities such as Master Detail, Cascading prompts, Drill down, Drill-Through and Conditional formatting into multiple reports.
• Design of Cognos mobile reports using IBM Cognos apps for Android and IOS using Active report functionality in Cognos.
• Scheduled and distributed reports to the end users by scheduled management in Cognos connection. Implemented bursting and event trigger function when it’s needed.
• Created multiple prompt pages using Java Scripts to validate the data on each report for narrowing the report output.
• Extensively implemented complex reporting functionalities using Conditional formatting, Conditional blocks using multiple variables and parameters.
• Created multiple layout component Objects and incorporated into the reports.
• Created multiple report templates which help developers to create new reports according to the company standards and created 'Read Me' documents.
• Created multiple Documents for report testing.
• Created reports in Analysis Studio by using cubes and multidimensional models.
• Involved in performance tuning of complex reports and analyzed Cognos SQL with native SQL.
• Created and modified dashboard reports for business managers.
• Developed Complex reports which services multiple business requirements in a single report.
• Created ad-hoc reports using Cognos Query studio.
• Scheduled and Distributed reports through schedule management in Cognos connection.
• Upgraded Cognos from 8.4.1 to 10.0.
• Designed and developed Tableau visualizations which include preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies. Build some automated jobs using AWS, Azure.
• Deploying models and reports from Development to Production and administering users/groups/roles.
• Created optional filters/prompts in report studio using Java Script and HTML and had extensive experience in creating master detail relationship in Report studio
• Actively involved in trouble shooting, customization before and after upgrade. Customized various Reports after the upgrade process.
• Provided production support for the report and involved in activities including program analysis, testing and system enhancements.

Environment: Cognos 10.x (Transformer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration), Oracle 11g, Windows 2003/7, Toad, Microsoft Excel, Microsoft Access, SQL Server

Confidential, PA

Cognos Developer

Responsibilities:

• Analyzed the reporting requirements, data sources and current systems that are used for modeling and reporting data.
• Worked with project lead and business users to understand requirements, conduct analysis and recommended solution options.
• Imported tables in to the Framework Manager from different data sources like SQL Server and Oracle and created relationship between the dimensions and facts.
• Developed new reports using functionalities like Layout Component Reference to reuse Report Header and Footer.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary reports to Detail Reports.
• Created complex reports with multiple queried using SQL, Master-Detail Relationships, Joins, Sub queried, Query references and Query Calculations.
• Designed and developed Power play cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users.
• Created cubes in Transformer using Framework Manager IQD’s packages and report studio reports as a source.
• Modified power cubes by adding new dimensions, levels and measures.
• Performed basic administrative tasks such as scheduling and delivering reports in different formats (for example HTML, PDF and Excel)
• Scheduled reports to run on a monthly, weekly and daily basis using Cognos Connection.
• Used Event Studio to create agents that monitored status changes and priority customers that was important for the Business users.
• Ensured that all assigned task was customer focused, results oriented, performance driven, and in compliance with all applicable internal and external requirements.
• Worked closely with the deployment team to ensure a smooth transition from development to production operation and support.
• Design, review and implement functional specifications. Attend client meetings along with business analysts to discuss technical design for new features.

Environment: Cognos 8.4(Cognos Report Studio, Query Studio, Cognos Framework Manager, Cognos Connection, Powerplay Transformer), Oracle 10g, SQL Server.

Confidential

Cognos Developer

Responsibilities:

• Understanding of Data warehousing concepts and framework of BI Tools.
• Involved in documenting the project.
• Created Multiple Reports using Report Net and Power Play.
• Created List, Group and Cross tab Reports with Drill through Functionality.
• Created Multi-Dimensional Cubes using Power play Transformer for multidimensional (IQD) reports.
• Drill Down and Drill Through functionalities were used in the cubes and reports
• Data retrieval, Multidimensional analysis, Power Play structure. Reporter Operations such as Sum and Average, Intersection, Exception Highlighting, Sorting, Ranking etc.
• Developed solution models for Ad-hoc reports.
• Created Multi-Dimensional Cubes using Powerplay Transformer for multidimensional (IQD) reports.
• Used Report Net SDK to customize and automate various Report Net Tasks.
• Developed PL/SQL procedures, packages, triggers and other database objects
• Implemented Package level security and object level security in Framework manager.

Environment: Cognos 8.4(Cognos Report Studio, Query Studio, Cognos Framework Manager, Cognos Connection) Oracle 10g, SQL Server.