SUMMARY

• More than 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), CognosReportnet 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.
• Expertisewith 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.

TECHNICAL SKILLS

Hardware: IBM PC Compatibles and NT servers

OS: Windows, UNIX, Linux

OLAP tools: Cognos 10.x,8.x (Report Studio, Frame work manger, Analysis Studio, Business Workspace, Business Workspace advanced), Transformer 8.3, Impromptu Administrator,Powerplay Transformer, Powerplay, ReportNet,Oracle

ETL Tools: Informatica 6.0, 7.1,8.1,8.6, Data stage 7.5

Databases: Oracle 7.x/8.x/9.x/10g, SqlServer, sql* loader, Teradata

RDBMS: Stored Procedures, Database Triggers, and Packages.

Languages: C, C++, Java, Cobol, VB, .net,php, Assembly language

Multimedia: Adobe Photoshop, Flash, Dreamweaver.

Tools: Make, RCS, Autosys, Clear Case,Toad, BTEQ

Miscellaneous: TCP/IP Sockets, Sun RPC, XML

Version Control: CVS

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

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.
• Developed Reports for Mobile phone applications Cognos Mobile Reports
• Experience migrating reports from OBIEE to Cognos 10.2.
• 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.
• Worked on Cognos mobile reports and testing.
• 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.
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc.
• Develop dashboards using IBM Cognos 10.2.1 Business Insight Advanced.
• 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.
• Set up automation for IBM Cognos10.2.1 daily and monthly cube build process.
• Develop complex reports using Tabular Set and Tabular SQL to meet business requirement.
• 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.
• Developed complex, dashboard reports for Mobile Applications
• Use various prompts like value, text and date prompts with customization for all the reports developed in IBM Cognos 10.2.1
• Publish cognos power cubes as data source and packages to IBM Cognos10.2.1 connection.
• Help off-shore development team members to overcome technical challenges in using IBM Cognos tools and
• Develop system process documentation and debugging procedures.
• Prepare Business logic for existing reports.
• Worked on Congas 10 SDK platform.
• 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 Basemaps, demographics, and landscape.
• Worked on Geo spatial Mappings using ArcGIS 10.1

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

Confidential, Jacksonville, FL

COGNOS Developer / Administrator

Responsibilities:

• Work directly with business customers to build portals, reports, dashboards with the Confidential 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.
• ManageCognosmetadata, Folder structure and utilizeCognos10.2 advanced features.
• Responsible for implementing best practices onCognosDashboards, 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 BurstReports and MultilingualReports based on groups of users &Preferencesfor 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, Productsetc.

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, Tampa, FL

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, IL

Sr. Cognos Consultant/Analyst

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 CognosFramework 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: CognosReportNet 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, Lansdale, PA

Cognos Developer/Consultant/Analyst

Responsibilities:

• Involved in requirement gathering during the business analysis and planning phase of the project.
• Built Framework Manager models and established the cardinalities to suit the business needs.
• Created list, cross tab, chart reports including report studio features such as filters, calculations, prompts, Conditional Formatting, sections and Page Breaks.
• Developed various report formats, which were approved by the business Users.
• Created Drill- through and Master -Detailed Reports with Prompts (List. Cross tab).
• Involved in Cognos Administration using Cognos Connection for security implementation, scheduling, distributing reports and performance tuning.
• Developed various complex models in framework manager which included the tables from two different data sources i.e. SQL SERVER and ORACLE.
• Developed Adhoc reports using Query Studio.
• Configure, support and maintain online BI applications and SQL reporting.
• Involved in performance tuning for Reports and Framework model.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Provided extensive end user support and training on Ad-hoc reporting using Query Studio.
• Documented Entire Data Flow, Program Development, Logic, Testing, Changes and Corrections.
• Conducted the training session for the employee and users

Environment: Cognos 8.4(Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformer) SQL Server, Oracle10 g, Toad.

Confidential

SQL/Cognos Developer

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: CognosReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Cognos Transformer 7.x, Impromptu 7.x, PowerPlay 7.x, Cognos Upfront, CognosScript Editor, Microsoft Excel, Oracle 9i asend MS SQL Server 2000