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, Power Play 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.
• 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 and in Migration of other reports into Cognos and version up-gradation.
• 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.
• 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 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

EXPERIENCE:

Confidential, Ohio

Sr. Cognos BI Developer

Responsibilities:

• Analyzed data to understand business requirements and created a new functional design.
• Worked with dimensional modeling of relational data sources using Cognos Framework Manager.
• 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.
• Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, publish packages to Cognos connection.
• Wrote reports using Report Studio for creating dashboards by using specific color coding schemes for Charts, Trend Lines, and 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 migration of reports from Cognos 10.2.2 and to Cognos 11 and Build active reports and dashboards for C-Level in Cognos Analytics and created POC’s for Cognos 11.
• Upgraded Cognos from 10.2.1 to Cognos 11 and tested for multiple environments like Development, Testing, UAT and Production using Cognos life cycle manager and had experience in conversion of Cognos 10 SDK to Cognos 11.
• Involved in building Portal Pages and designing them according to user requirements and developed Performance Charts, Dashboards and Scorecards using Report Studio.
• Involved in Metadata modeling of both Relational and Dimensional data using Framework manager and involved in conversion of CQM models to DQM models.
• Experience in implementing security based on groups and roles in LDAP and CJAP.
• Had extensive experience in creating Active reports in Cognos and involved in Agile development lifecycle
• 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. Developed few reports using Micro strategy and Tableau.
• Proficiently customized the look and feel of the dashboard using HTML items for improved visual presentation.
• Trained end users on how to use Cognos Connection, Query Studio and Analysis Studio.
• 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.
• Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like star schema and snowflake schema in DB2.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures (Using Tableau).

Environment: Cognos 11.x/10.2.2 (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

Confidential, TX

Sr. Cognos BI Developer

Responsibilities:

• Worked with Business Users to get the user requirement for creating multi-dimensional cubes and canned reports.
• Refined the multi-dimensional models using special categories like excel, IQD, packages, alternate drill-down path, calculated measures, etc. to better suit user needs.
• 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.
• Installed, configured and administered various Cognos components such as the Cognos BI server, Framework Manager, Transformer.
• 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.
• Experience in implementing security based on user roles in Framework Manager in MUD environment and publishing reports and worked on Netezza and involved in environment set up and in deliverables in UAT/ST environment and has experience with Data warehouse concepts and in SDLC.
• Used static choice value prompts, cascading prompts, master detail relationships, conditional variables (Boolean and string) to create reports and had experience in validation using Java Scripts and had experience in DQM models.
• Involved in retrieving the My folders content using SDK. Involved in creating the replica of Motio tool for Cognos using SDK.
• Understand business requirements and translate into IT solutions with the use of FM, Cognos TM1 Cube and Cognos Report Studio.
• Providing training to the end users and involved in design with the SME's and involved in writing TSQL using Sybase database. Created Triggers, views, stored procedures using TSQL in Sybase database.
• Implemented Drill Through and Prompts for better utilization of reports and implemented DMR modelling using mdx queries and worked on Tableau for one of the other project.
• Created Backups of the content store and Public folders and involved in performance tuning of several Reports and involved in migrating the Packages/Reports across environments (DEV, UAT, and PROD).
• Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate the Show/Hide requests.
• Scheduled Burst Reports for regions, zones and districts which delivered the appropriate output for the concerned mangers in Cognos Connections by email and involved in agile development cycle.

Environment: Cognos 10.2.2 (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager), Cognos Administration, 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.2.2 (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.