TECHNICAL 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/8.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 (ADLDS) 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, Packages) 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.
• Experience with ETL using SQL/PLSQL and Batch/Shell scripts.
• Extensive experience using various data sources such as Oracle, SQL Server, MySQL and XML.
• 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.
• 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
• Responsible for Interacting with users and department directors to identify information needs and business requirements.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.X, Cognos10.1.X, Cognos Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Cognos workspace, Cognos workspace advanced, Cognos Mobile, Cognos administration, Report Net, Cognos Access Manager. Tableau Public, SSRS, Business Objects, Oracle Business Intelligence Enterprise Edison 10.1.3

Modeling Tools: Cognos Cube Designer, Cognos Transformer & Cognos Framework Manger

ETL Tools: Informatica workflow designer, Workflow manager, Workflow Monitor, Data Manager

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

Project Management Tools: IBM Clear quest, IBM Clear case, VSS, IBM RTC, Star team

RDBMS: Oracle Exadata, Oracle 11g/10g/9i/8.x, MS Access/Excel, DB2, and SQL Server

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

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Cognos Admin/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.
• Analyzed existing solution containing cubes reports, materialized views and worked with the functional team to create technical documents.
• 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.
• Manage and maintain LDAP that provides direct access for users to respective applications in all Cognos environments.
• 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), Oracle 11g, Windows 2003/7, Toad, Microsoft Excel.

Confidential, Fort Lauderdale, Florida

Sr. Cognos Developer

Responsibilities:

• 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 10 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 etc.
• Created IQD’s as data sources for using in PowerPlay Transformer using Externalized method in Framework manager.
• 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.
• Applied cube security to see the cube groups and set measure properties.
• 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.

Environment: Cognos 10.x (Transformer, Cube Designer, 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, Indianapolis, IN

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.
• 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 8.4.x, 10.0 (Transformer, Workspace, Workspace Advanced, Report Studio, Analysis Studio, Cognos Connection, Framework manager), Oracle 10g, Windows 2003/7, Toad, Microsoft Excel, SQL/PLSQL, MySQL.

Confidential, Columbus, Ohio

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 bases 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, Columbus, GA

Cognos Developer

Responsibilities:

• Worked on Cognos 8.4 Framework Manger to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Implemented Security with LDAP and group level security in Cognos Connection Portal.
• Creation of procedures, views, tables and functions according to business requirements in SQL.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports.
• Worked with Stored Procedure Query Subjects and Direct SQL reports.
• Prepared User documentation to train users the functionality of each report.
• Created list reports, cross-tab reports and chart reports using multiple queries in a single report, drill-through reports and conditional formatting to highlight the business needs.
• Extensively worked in Scheduling and Deploying (Staging to Production) Reports.
• Worked on complex reports using Tabular Objects, Static Prompt conditions.
• Involved in designing and building the Power Play cubes using Transformer.
• Modifies Power cubes by adding new Dimensions, Levels and Measures. Designed Cognos Transformer cube models using reports and modelled them according to user needs.
• Build Power Play reports based on the cubes.
• Administering the business users in the portal based on the requirements. .

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

Confidential, NY

Cognos Developer

Responsibilities:

• Created Cognos Dashboard Reports for the VP level managers to understand the system based on different KPIs
• Installed and configured Cognos on a distributed platform.
• Created Standard Reports like List, Crosstab Dashboard Reports using the business rules and filters
• GatheredUser requirementsand reviewed them from atechnical perspective and conducted meetings with end users to establish business rules,schedule deliverables and identify potential issues that could impact the development effort.
• Actively written batch scripts as part of deploying and running Power Cubes on Unix prod box.
• Created scorecard reports and dashboard using Cognos 8.4 report studio.
• Developed ad-hoc reports, drill through reports and created master detail relationship to burst a crosstab report using Report Studio.
• Designed model using power play transformer and created multiple cube views.
• Created a JavaScript to execute a report with multiple parameters and to submit a job and pass parameters to the reports in the job using Cognos SDK.
• Deployed the packages and reports from Dev to QA and QA to production environments
• Involved working in Power Play Transformer models using Flat Files, IQD files and packages as data sources.
• Created Power Play reports by performing the drill down, slicing and dicing operations on the Power Play cubes to allow the business user to review the data differently.
• Documentation of the report results and updated daily with the testing results.
• Participated in testing of the developed reports and reported the defects.

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.
• Developed PL/SQL procedures, packages, triggers and other database objects.

Environment:: Cognos Report Net 1.01MR1/1.02MR2 (Framework Manager, Report Studio, Query Studio), Cognos Transformer 7.2/7.4, Cognos PowerPlay 7.4, PowerPlay Enterprise Server, Windows NT/2000, UNIX, Oracle 9i, 10g, MS-Excel.