SUMMARY:

• Over 8+years of total IT industry experience as Cognos Certified Professional in analysis, design, testing, development and implementation of client/server applications
• Good experience in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 6 / 7/ 8/10 and Cognos Report Net
• Experience with Cognos Tools such as Cognos 8 and 10 Suite (8.1/8.2/8.3/8.4/10.1), Cognos Report Net 1.1.MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x, Power Prompts, and Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x, Cognos Visualizer7.0, Access Manager and Server Installation & Maintenance.
• Good understanding with cognos architecture.
• Sound skills in Cognos 8 BI Suite(framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Transformer)
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
• Having experience on dashboard reports building using report studio.
• Installed and ConfiguredCognos 8.4/10.1 in single server Environment.
• Experience in the installation and administration of Cognos Report Net 1.0/1.1MR2 in a distributed environment
• Having experience in creating adhoc reports in cognos query studio.
• Developed database schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in DMR model designing using Framework manager.
• Very good experience in Report building using Report Studio and Analysis Studio
• Work Experience in Transformer model design and Power play cube building
• Experience in Installation and configuring the Cognos 8 and CRN environment andimplementing third security toolsTivoli directory Serverand Sun One with Single Sign on
• Familiar with cognos EP software where you can develop budgets and forecasts
• Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like star schema and snowflake schema.
• Basic knowledge of BIA (Business Insight Advanced).
• Experience in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Having knowledge on ETL tools like Informatica, Data Stage.
• Good experience in Oracle SQL and PL/SQL
• Having experience with multiple databases like Oracle, SQL server 2000/5.0, DB2 and Web Logic.
• Worked with senior academic and administrative officers in support of financial management.
• Having experience with TM1 for analytical and reporting applications
• Knowledge about BASEL and basic knowledge about calculating RWA (Risk Waited Assets) with help of LGD and EAD for Trial Balance reports
• Experience in leading offshore team from onshore.
• Experience in interacting with end users to gather requirements for reporting.
• Developed Cognos Planning solution enables a flexible and transparent process of forecast, while integrating with the in-place IBM Power Play solution.
• Excellent interpersonal and communicationskills, technically competent and result-oriented with strong problem solving skills.

CERTIFICATIONS:

• IBM Cog - 180 IBM Cognos 8.4 BI Professional

TECHNICAL SKILLS:
Reporting Tools: Cognos 8.1/8.2/8.3/8.4/10.1 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio) Cognos EP Series 7.3, Business Objects 5.1, Cognos Impromptu 7.3, Power Play 7.3, IWR, Visual Studio.
ETL: Informatica, Data Manager and data stage.
Databases: Oracle 8i/9i/10g, SQL Server 2000/5.0, DB2, Teradata
Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX, and Linux
Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)
Languages: C, C++, C#, SQL, T-SQL, PL/SQL, asp.net

PROFESSIONAL EXPERIENCE:

Confidential, Long Island City, NY Sep'11 - Present
Cognos Developer

• Gathered and Involved in analysis of end user requirements.
• Worked with team to get Cognos 10.1 infrastructure, implementation, installation and configuration done.
• Wrote Cognos report requirement document for users according to their requirement.
• Involved in creating models with Relational Data using Framework Manager including best practices and deployed packages to the Report Servers.
• Implemented Framework managersecurity for Data access, Object level access and Package access based on the Organization Level.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts inReport Studio
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Worked on Analysis Studio to develop multi-dimensional reporting. Analyzed Business requirements from the analysts.
• Involved to analyze and map data fromsource systems to targetoperational data stores and data marts (Data warehouse).
• Developed Cognos multidimensional cubes and published cubes in analysis studio to analyze the business reports.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Experience in deploying reports, migrating objects and testing reports in different environments.
• Involved in end user Cognos training to explain how effective can we use the tool.

Environment: Cognos 10.1/8.4 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio , Transformer and Event Studio), JavaScript and HTML, Oracle Database 11g, Cognos Transformer 8.4, Windows XP Professional, VB Script, T-SQL, XML and HTML.

Confidential, Pittsburgh, PA
Cognos developer Mar'11 - Sep'11

• Have been working on acquisition project to develop the model and reports accordingly.
• Knowledge in analyzing end user requirements
• Installations and configuration of cognos 8.4/7.4
• Worked on Cognos architecture and implementation
• Working knowledge on multiple servers and resolving server issues
• Experience in both Cognos 8.4 and Impromptu to create model according to the user requirement
• Involved in catalog, cube maintenance and created reports accordingly.
• Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database.
• Have been involved in Framework Manager modeling with best practises
• Expertise in Framework Manager Modeling and in creating securities at data, object and package level. Involved in creating different layers in frame work manger.
• Administerd cognos portlets and third-party portlets in Cognos Connection
• Involved in migration of reports from Cognos Series 7 to Cognos 8 using Migration Utilities.
• Knowledge of Cognos 10 installation and configuration
• Been using Report studio to develop and modify reports and analysis studio to analyze the cubes
• Good experience in developing reports, modifying filters, creating dash board reports, creating adhoc reports and format changing reports
• Involved in scheduling and implementing (to production) reports
• Performed administrative functions such as creating user accounts, user classes and roles using Access Manager
• Experience in modeling transformer, published cubes and created Power play Reports for the web users
• Provided technical support to troubleshoot Cognos issues both off and onsite
• Basic experience of ETL tools like Informatica
• Having experience in UAT and moving reports into production environment
• Experience in server tuning
• Well understanding of the entire SDLC process.
• Extensive knowledge in resolving production issues in given time
• Good experience in documentation of project

Environment: Cognos 8.4 /7.4 suite (Impromptu, framework manager, report studio, analysis studio, transformer, power play), Oracle 10g, cognos access manager, and windows XP.

Confidential, NJ Mar'10 - Feb'11

• Analyzed the enduser requirements and gathered all those requirements.
• Worked on Cognos8.1 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Created and maintained Cognos packages in Framework Manager.
• Expertise in deploying packages and reports to Production environment and handling production issues.
• Experience in maintaining cognos resource on and offshore.
• Have been working with Cognos workforce analytics software and involved in HR supporting.
• Moved projects from development to QA and then Production servers.
• Worked on server tuning.
• Used VB script for automation.
• Customized cognos portal and worked on some XML files to build the customized cognos portal.
• Created, refreshed and supported Cognos Transformer models and cubes to support Claims operations.
• Implemented Third Party Security with LDAP and created users and user roles.
• Involved in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Have been created and maintained SSIS packages using a visual development tool based on Microsoft Visual Studio.
• Performed Cognos administrative functions such as creating user accounts, user classes and roles using Access Manager.
• Worked on cognos Administration in assigning User groups, User roles with access permissions.
• Built and maintained Cognos reporting security.
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs (Folders, Filters, and Macros)
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model
• Created Cubes and worked on reporting on those cubes by using Report studio and Analysis Studio
• Having Good Knowledge in Data loading using ETL tools like data manager.
• Writing SQL queries by using XML data.
• Involved in implementing security at Transformer level by creating custom views.
• Created Cognos multidimensional cubes for users to be able to get business information from Cognos Power Play.
• Developed and modified Power Play reports and graphs with different layouts according user requirements.
• Prepared documentation and performed user training

Environment: Cognos 8.4/8.3 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), SQL Server2008, Cognos Access Manger, Windows XP, and UNIX.

Confidential, Louisville KY April'09 - Feb'10
Sr. Cognos Developer

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Design and Developed the Framework Manager models and Published into server.
• Created packages in Framework Manager to publish cubes to AnalysisStudio
• Design & development of the reports using Cognos 8 Report Studio, Analysis Studio reports
• Accessed virtual view manager with Framework manager.
• Experience with Cognos TM1 for planning and budgeting the business
• Extracted data from databases using ETL tools like data manager and data stage.
• Worked as an administrator on Cognos suite of products.
• Have been involved with HR professionals to track and measure talent management effectiveness.
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Extensively worked on Analysis Studio to develop multi dimensional reporting
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Used SDK kit to customize the reports.
• Involved in Migrating reports from Cognos EP Series 7/CRN to Cognos 8 Environment.
• Worked on report studio, to create complex reports and dashboards for the given requirements.
• Created complex dashboards with area charts, pie charts, crosstab and Multi prompts in Report Studio.
• Used SQL Server Management Tool to check the data in the database as compared to the requirement given.
• Exposure on Cognos Software development kit like SDK in order to customize reports.
• Designed Power Play reports to provide summarized results by measures and dimensions
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Coordinating with Development Team tasks & Deliverablesand working on high priority issues
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Used different scripts like J script and VB script.
• Have been involved in scripting for stress testing to resolve the performance issues.
• Experienced with Oracle web logic server.
• Involved into move to Deployment to UAT and Production.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection), Nateeza, Linux, Cognos Access Manger, Windows 2003 Server.

Confidential, Chicago IL Mar'08 - Mar'09

• Installed, Configured Cognos8.2 and Report Net on single and multi server environments
• Extensive Knowledge on Cognos Architecture and implementation.
• Implementation of crystal reports on different environments.
• Used business objects crystal reports to deliver information to large population of users.
• Converting crystal reports 7 to cognos reporting.
• Involved in the Server Team Gatherings for estimating the server configurations required for cognos implementation
• Have been using Cognos enterprise planning for budgeting and forecasting.
• Created metadata in framework manager created and published packages based on the security
• Constructed Drill up, Drilldown, Drill through, master-detail reports using parameterized filters in Report Studio
• Comparison of the way the IQDs and drill through are generated.
• Worked on Mdl models and Mdc power cubes
• Developed Reports using new Page sets concepts for Hierarchical reports
• Developed Reports using Queries and set operator logics
• Validated report results with the source data and sanctioned the reports to production environment
• Deploying and scheduling reports usingSSRSto generate all daily, weekly, monthly and quarterly reports.
• Worked on formulating reports scheduling strategy in Cognos Connection factored upon data refresh cycles and server contention
• Worked with Maintenance and Production support team in Scheduling activities like batch job failures and cube build Errors.
• Secured Cognos Connection and setup cognos8 security by assigning users to the groupsand roles defined in Cognos Namespace according to the Active directory groupings
• Performed reports maintenance and tested for performance (catalog maintenance)
• Administered Report Net server with the primary objective of tuning server performance to optimize speed and efficiency
• Have been using dynamic HTML (DHTML) to add animated images to reports with the combination of Java script and DOM.
• Involved in resolving the access issues for developers, business users in existing environments and also through Citrix server.
• Troubleshooting Developers Technical Issues interacting extensively with Cognos Technical Staff in determining the root causes.
• Implemented different scripts (Unix & Batch) for cube processing and control of report and server administration

Environment:Cognos Report net 1.1, Cognos 8.2, Impromptu, Power play, Decision Stream 7.1.5, Access Manager 6.5,Remedy 6.3, SQL Navigator 4, Informatica 7X, Facets, Sql server 2005 and Oracle 9i on Windows 2000/XP. Cognos 8 System Development Toolkit (SDK)

Cognos developer/Administrator

• Work as accounting programmer using Cognos Impromptu, SQL, and Cognos Power Play.
• Interviewed business community to identify business, data, and delivery requirements.
• Involved in Gathering Requirements and the reporting issues from the End users
• Analyzed Business requirements from the analysts.
• Interacting with Development and Management Teams
• Involved in Designing models using Framework Manager and deployed packages to the Report Net Servers
• Implemented SAP BW core business rules (Security (roles), Calculated Key figures, Restricted Key figures, Query variables) in Cognos tools.
• Involved in cognos enterprise planning.
• Involved in the Integration of Cognos Reporting with BW functional areas for detailed reporting
• Implemented Framework manager security for Data access, Object level access and Package access.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
• Provided End User Training and Support
• Modeled metadata from SQL Server 2005 data source for use in Report studio and Query Studio using Framework Manager in Report Net
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Created custom templates and custom toolboxes for the use of reporting.
• Customized Cognos Connection with appropriate reports and security measures
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Have been involved with Microsoft Visio 2007 to create diagrams.
• Moved projects from development to QA and then Production servers
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Involved in the Testing of the reports and updating the Bug Tracking Tool
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members

Environment: Cognos 8.2 BI Suite, Cognos FrameworkManager8.2, Cognos Impromptu 7.3, Cognos Power Play 7.3, Cognos Transformer 7.3, SQL Server2005.

Confidential, Newark, NJ Sep'05 - Dec'06
Cognos Developer

• Worked on Cognos8.1 framework manager 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.
• Worked with multiple data sources like Oracle.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Worked with Stored Procedure Query Subjects and Direct SQL reports in Report Studio.
• Creating 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.
• Built Power Play Reports based on these cubes and published to Report Net Server.
• Administering the business users in the portal based on the requirements.

Environment:Cognos 8.1, Cognos ReportNet1.1 MR3 (Framework Manager, Cognos Connection, Query Studio, Report Studio), Oracle 9i, Toad, Tivoli LDAP, Migration Utilities (Impcat2xml, Migratetoc8, Deploytoc8), Windows XP.

Confidential, Miami, FL April'04 - Aug'05
Cognos Consultant

• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs (Folders, Filters, and Macros)
• Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Developed Complex Report Studio Reports using Bursting, Tabular Objects.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Prepared User documentation to train users and functionality of each report.
• Production Support, which involves solving user problems.
• Securing Cognos Connection and setup Report Net security by assigning users to the groups and roles defined in Cognos Namespace.
• Creating IQD files from Report net and designed Power play models in Transformer.
• Involved in building the Cubes and optimizing the cube creation.
• Publishing cubes and created Power play Reports for the web users.
• Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas.
• Developed Stored Procedures and Database Triggers in PL/SQL.
• Designed extensive sample business Reports to cater the needs, which can meet their future demands on behavioral, trend analysis.
• Created Drill-Down Hierarchies and used slicing and dicing technologies to provide optimized Reports.
• Responsible for overseeing the Quality procedures and Software configuration management related to the project
• Production Support, which involves solving user problems.

Environment: Cognos ReportNet1.1 MR2 (Framework Manager, Query Studio, Report Studio) Power Play Enterprise Server 7.3, Transformer 7.3, DB2, and Windows 2000.

Confidential, Sep'03- Mar'04

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL.
• Used SQL* Loader to load data into different tables.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Extensively used PL/SQL to extract data from different tables with 20 Million records in some of the tables
• Based on the user selection and finally storing the output as a flat file for further processing for the next module.
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used.
• Incorporated validation rules for promotion history table and updating tables.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Confidential, Oct'02-Aug'03

• Clarified the requirements by talking to the user groups and accordingly modified the functional and technical specifications
• Developed / modified Oracle PL/SQL codes like stored procedures, functions, triggers etc based on technical and functional specification documents
• Developed / modified scripts to create tables, views and executed them using SQL Plus
• Developed / modified scripts to rectify data errors and executed them using SQL Plus
• Ran batch jobs for loading database tables from flat files using SQL Loader
• Prepared unit test cases and executed the same.

Environment: Oracle 8i, PL/SQL, SQL*Plus, UNIX

EDUCATION:

• Bachelor of Technology