SUMMARY

• 8 years of IT experience in Software Design, Development, and Analysis, Testing, Data Warehouse and Business Intelligence tools.
• Hands on experience in Cognos 10.2, 10.1, 8.x Query Studio, Report Studio, Analysis Studio, Business Insight/Workspace, Business Insight/Workspace Advanced, Metric Studio Score carding , Framework Manager, Cognos Connection , Cognos Reportnet 1.1, Cognos Impromptu, Cognos Power Play Transformer, Cognos Power Play, Cognos Scheduler, Cognos Access Manager, Upfront.
• Involved in gathering the requirements from the end user and translated them into the technical specifications.
• Expertise with Framework Manager Modeling Physical Layer, Business Layer, Packages and Complex Report building with Report Studio.
• Hands on experience in Report building Crosstab, List, Dashboard reports using Report Studio and Analysis Studio.
• Experience developing complex reports using drill-through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos.
• Expertise in creating Dashboard reports using Java Script in Report studio.
• Experienced in building scorecard reports and dashboard reports using metric studio.
• Experience with Transformer models and cubes that were used in Power play analysis and also these cubes were used in various Analysis Studio reports.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Extensive experience with Cognos security LDAP, Active Directory, Access manager, object level security, data security .
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8.X Environment.
• Created Active Reports with Tabbed Inter-phases and with Interactive Behavior of value based chart highlighting.
• Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, functions, packages.
• Expertise in Oracle 10G, 9i and MS SQL Server 2005 2008.
• Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Ability to translate business requirements into technical specifications and interact with end users to gather requirements for reporting
• Good understanding of business process in Financial, Insurance and Healthcare areas.
• Good work ethics, detail oriented, fast learner, team oriented, flexible and adaptable to all kinds of stressful environments. Possess excellent communication and interpersonal skills.
• IBM Certified Developer Cognos 8 BI Professional Studio Cog 180 .

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

COGNOS Developer / Administrator

Responsibilities:

• Prepare Technical Design Documents based on Functional requirements and implement most complex business requirements using BI tools.
• Develop List, Crosstab, Chart Reports in Report Studio using Framework Manager Package, SQL and PL/SQL.
• Design and develop complex drill through, master detail and Burst reports using IBM Cognos 10.1.1 functionality.
• Develop new relational and dimensional Framework manager Package using OLTP and OLAP data source and maintain existing packages to meet the business requirement.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Created Burst Reports and Multilingual Reports based on groups of users Preferences for our Asian, African and European partners.
• Created Drill Through Reports Master Detail Reports for Accounts Department.
• Used Union, Intersection for creating queries.
• Created dashboards, portlets for various HR and payroll related reports. E.g. investments related to 401Kplan were displayed as dashboards showing their investments, returns, losses, dividends earned, etc.
• Developed various HR reports MTD, QTD, YTD, last fiscal year, current fiscal year reports, employee taxable, paid time offs, holidays, sick leaves, workers compensation report WCR etc. These reports were mainly on employee level but I also developed scorecard and dashboard reports which were mainly developed for the departmental heads and regional heads.
• develop system process documentation and debugging procedures.
• Help off-shore development team members to overcome technical challenges in using IBM Cognos tools and
• Publish cognos power cubes as data source and packages to IBM Cognos 10.2.1 connection.
• Use various prompts like value, text and date prompts with customization for all the reports developed in IBM Cognos 10.2.1
• Design and develop reports using of Conditional Blocks and Conditional Styles to fulfill complex business requirement into a single report and to highlight key data.
• Develop complex reports using Tabular Set and Tabular SQL to meet business requirement.
• Set up automation for IBM Cognos10.2.1 daily and monthly cube build process.
• Design and develop IBM Cognos Power Cubes on windows platform to fulfill business requirement which helps management and customers in making key business decisions based on cube analysis.
• Develop dashboards using IBM Cognos 10.2.1 Business Insight Advanced.
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.
• Prepare Business logic for existing reports.
• Help end users to understand Data warehouse and BI Tools.
• Good Experience working on the Esri Maps 4 and 5.
• Worked on content including ArcGIS Online Base maps, demographics, and landscape.

Environment: Cognos 10.2/10.1.1 ,Transformer, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX,ArcGis.

Confidential

COGNOS Developer / Administrator

Responsibilities:

• Work directly with business customers to build portals, reports, dashboards with the COGNOS BI authoring suite Framework Manager, Report Studio and Transformer.
• Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, cubes and integrating with SharePoint..
• Manage Cognos metadata, Folder structure and utilize Cognos 10.2 advanced features.
• Responsible for implementing best practices on Cognos Dashboards, Scorecards, Portal, report design, development and testing.
• Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10.2.1.
• Created Burst Reports and Multilingual Reports based on groups of users Preferences for our Asian, African and European partners.
• Created Drill Through Reports Master Detail Reports for Accounts Department.
• Creating OLAP cubes using Transformer, creating Framework models.
• Developed various Management reports MTD, QTD, YTD, last fiscal year, current fiscal year reports, and employee taxable. MTD, QTD, YTD, Clients, Costumers, sales, shops, Products etc.

Environment: Cognos 10.2/10.1.1 ,Transformer, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX.

Confidential

COGNOS Developer/Cognos Administrator

Responsibilities:

• Developed Technical Design Documents.
• Developed logical physical modeling as per business requirements using ERWIN 3.5
• Designed and developed snow flake /star schemas for better understanding of models using ERWIN.
• Designed DMR models in Framework Manager
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created list, crosstab and drill through reports for departments like claims, billing, members/subscribers in Report Studio
• Created complex reports in Cognos mainly dealing with Member Data, Claims data and Provider Data.
• Created score cards using Metric Studio.
• Wrote Procedures and triggers in Oracle for file handling, data validation, Inserting data etc.
• Created models in Transformer, built cubes and published cubes to Analysis Studio
• Carried out performance tuning of reports.
• Migrated content from 8.4 to 10.2 environments
• Worked on Cognos dynamic cubes to replace the existing OLAP cubes and repoint the reports to hit the In memory cubes developed.

Environment: Cognos 10.2/10.1.1,Transformer, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX.

Confidential

Position: Sr. Cognos Consultant

Responsibilities

• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Managed Core Project, Responsible for delivery and resource allocation etc.
• Creating Teradata views and imported views and employed relation between views.
• Developed DMR modeling using Cognos 8 Framework manager.
• Enhanced the model, Tested and Created replacement IQDs' using Framework Manager.
• Created Dimension IQD's and Fact queries in Frame work Manager.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Installed and configured Cognos 8.4 BI and worked with Cognos 8 BI modeling, Report Studio.
• Responsible for Access permission and administrating the server.
• Created highly Customized reports in Cognos 8.2 Report Studio and some of the Ad-hoc reports in Query Studio.
• Used HTML and Java Scripts for Advanced reporting purpose.
• Gathered information like attempted calls, type of call long distance, local , length of call, originated number, destination number, rates, time of call for creating report for billing of a customer.
• Implemented security in reports according to employee groups and roles according to the requirement.
• Involved in Creating Content store, installation and Configurations of the ReportNet.
• Implemented Tree prompt and MDX Commands in Cognos.
• Developed Portlets and dashboards reports according to the user requirements.
• Tuned cube builds Impromptu Reports and ReportNet reports and servers for better performance.
• Implemented Data Security using LDAP in Framework Manager 8.2.

Environment: Cognos ReportNet 8.1/8.2,8.4,Framework Manager, Report Studio, Query Studio, Analysis Studio , Transformer, PowerPlay Enterprise Server, Cognos Impromptu, LDAP, Access Manager, IIS, Informatica, PeopleSoft, server 2005,Oracle 9i,TOAD.

Confidential

Position: Cognos Developer

Responsibilities:

• Interviewed business community to identify business, data, and delivery requirements.
• Designed models in Framework Manager.
• Updated administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Worked with Complex reports in Report Studio using master-detail relationship, drill through, burst options, cascading options and PROMPTS depending on user requirements.
• Created reports using cascaded prompts, value prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio
• Created models in Transformer, built cubes and published cubes to Power Play server.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Involved in monitoring Data stage jobs/processes and generating reports after successful job scheduling.
• Optimized and modified the triggers, complex store functions, procedures, user base data type.

Environment: Cognos 8.2 , Transformer 8.3, Report Studio, Query Studio, Metric Studio, Oracle 10g, Erwin 4.0, TOAD, PL/SQL, Data stage, UNIX, Cognos 8 RTM SDK.

Confidential

Position: SQL/Cognos Developer

My Job responsibilities:

• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Created the deployment scripts after the development is done for every project.
• Developed and customized Impromptu Reports and PowerPlay Reports.
• Used Cognos Impromptu tool to create standard and ad-hoc reports .
• Customized catalogs and created user profiles to grant user permission for accessing data from different database tables .
• Customized data by adding Filters, Prompts, Calculations, Summaries, and Functions .
• Developed Multi-dimensional Cubes using PowerPlay .

Environment: Cognos ReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Cognos Transformer 7.x, Impromptu 7.x, PowerPlay 7.x, Cognos Upfront, Cognos Script Editor, Microsoft Excel, Oracle 9i and MS SQL Server 2000