Summary:

• Extensive experience in OLAP tools and Cognos Application.
• Experienced with Cognos reporting and Business Intelligence tools such as Cognos 10/8, ReportNet, Impromptu, PowerPlay, Access Manager and Transformer
• Received official Cognos TM1 training.
• Intermediate experience with Informatica tool.
• Experience in Cognos 10/8 tools for advanced Report authoring and Meta Data Modeling
• Involved in building Dimensional Models using Framework Manger in Cognos 10/8
• Created packages in Framework Manager and published to Cognos Connection
• Created and managed reports in Zero-footprint environment using ReportNet
• Administered Access Manager to implement Security among Cognos applications
• Migrated Impromptu catalog to ReportNet using Metadata Migration Utility.
• Migrated Catalogs and Reports to Congos 8 environment.
• Optimized cubes in PowerPlay Transformer by auto-partitioning and caching
• Created Business Intelligence Reports using Cognos Impromptu and Cognos PowerPlay
• Installed and Configured Cognos for building multidimensional Cubes as per the Business requirements
• Used Event Studio for scheduling and emailing reports
• Automated Reports and generated Documents using Scheduler
• Published Reports in Various Cognos Portal environments.
• Gathered Requirements and reporting issues from the end users
• Provided End User Training and Support

Technical skills:

OLAP TOOLS: IBM Cognos 10/8.4/8.3, ReportNet 1.0/1.1 (Query Studio, Report Studio, Framework Manager, Cognos Connection), Cognos 7.X (Impromptu, PowerPlay, Transformer, Access Manager etc)
Database systems: Oracle 11g/10g/ 9i/8i, SQL Server 2005/2000, MS Access, DB2
Web Servers: Sun One 5.2, Microsoft Internet Information Server (IIS) 4.0/3.0
Programming Skills: C, SQL, HTML
Microsoft Tools: MS Excel, MS Word, MS Visio, MS PowerPoint and MS Access
Operating Systems: Windows 95/98/2000/NT/XP

Education/ Certifications:

• Master of Science
• Bachelors of Technology

Professional Experience:

Confidential,temecula , ca Apr 2011 Present

Sr. Cognos Developer/Administrator/ETL

• Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Conducted the JAD sessions and business trips to the user location to get the requirements.
• Developed the Cognos Impromptu query definition (.iqd) files that will feed Cognos cubes.
• Defined dimensions, levels, categories and measures.
• Worked on the design documentation, deployment guide and user guide.
• Created the mapping document between the UI, transactional system and the analytics.
• Modified the PL/SQL scripts to introduce the new columns in the tables and to refresh the data in the Analytics.
• Involved in design and development ETL mappings and Fine-tuned existing Informatica maps for performance optimization
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica

Designer.

• Defined the keys, Joins, cardinalities and global filters in FM.
• Developed and managed Dimensionally Modeled Relational model (DMR) using Framework Manager Utility.
• Troubleshooting and tuning of FM models and reports for better performance.
• Eliminated the ambiguous joins and loops by creating the aliases.
• Used the package level security and the folder level security.
• Created complex reports which involves Joins, Unions, Drill Through, Prompts, Report Library, Table of

Content, Report Layout, template, Dashboards etc

• Created and maintained complex dashboard report studio reports using Business Insight for quick analysis.
• Upgraded reports from Cognos 8.4 to Cognos 10 and created new active reports in Cognos 10
• Created and maintained complex report studio reports using Business Insight for sales analysis.
• Performed the administrative duties of scheduling, creating User Groups, deployment across different environment etc.
• Provided technical assistance, training and mentoring to Users and Business Partners.
• Created the mapping and scalability document to find out the scope of UI, transactional and analytics systems

Environment: Cognos 10/8.4 (Framework Manager, Transformer, Query Studio, Analysis Studio, Report Studio, Business Insight), Linux, Informatica 9, Oracle11g, Windows 2005, SQL Developer, WinSCP, Putty, LDAP

Confidential, chicago, il Jan 2011- Apr 2011
Sr. Cognos Developer

• Installed and configured of Cognos 8 BI (Framework Manager).
• Gathered, analyzed and documented user requirements for reporting.
• Enhanced the existing Framework Manager and Transformer model for the new enhancements.
• Modified the Cognos Impromptu query definition (.iqd) files.
• Developed Complex Report Studio Reports and Dashboards using Lists, Crosstabs, charts, singleton, sections, Drill Through, Joins, Unions, Images and HTML applications using Report Studio
• Developed the Analysis Studio report using the Transformer cube.
• Involved in the performance tuning of SQL queries.
• Involved in verification and validation of reports using SQL developer.
• Participated in Unit Testing and System Testing.
• Worked as a Team Lead and Coordinated with offshore team to finish the task.
• Documented the deployment process and assisted to the administrator to finish the task.

Environment: Cognos 8.4 (Framework Manager, Transformer, Query Studio, Report Studio), Oracle10, Windows 2005

Confidential, chicago, IL July 2009- Dec 2010
Sr. Cognos Developer/Administrator

• Involved in the entire project life cycle from analysis, installation, development, testing, production and
• end user support.
• Involve in the LDAP securities with creating/modifying different user groups and roles based on the plan information and Created/modified data source connection .
• Mapped LDAP groups to the Cognos user groups and roles.
• Interacting with Business Users to map the data.
• Developed FM model based on the transactional data for ad hoc reporting.
• Using Stored Procedure in Framework Manager to update the information in the database.
• Troubleshoot and optimized FM models.
• Provided row level securities to control the plan information for care managers in FM.
• Worked on geophysical mapping solution using ESRI and VISIO software and integrated in Cognos reports.
• Handling independent projects such as LDAP reporting and integration of Google Maps.
• created complex reports and briefing books involves JavaScript, Joins, Unions, Drill Through, Prompts Bursting, Report Library, Table of Content, Report Layout etc
• Created canned reports and ad hoc reports using Report Studio and Analysis Studio.
• Use the advance functionality of Analysis Studio such as drill up and drill down, rank, slicers etc
• Used Event Studio to trigger the jobs.
• Tuned the reports by modifying queries to minimize the execution time.
• Developed Structural and Transactional IQD’s from Framework Manager and used it for Transformer.
• Created Transformer Cube in UNIX environment by running script.
• Provided security in Transformer Cube by using Custom Views.
• Interacted with QA team for Unit Testing, System Testing and Performance Testing
• Worked on deployment of packages and reports in UNIX environment,
• Working with Control Center (DB2) to execute the query for report testing and update the table for report bursting.
• Involved in Production Support.
• Analyzed the impact on the models and reports before the data loading for Market Research application.

Environment: Cognos 8.4(Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio,Transformer) DB2.x, Windows 2003, AIX 3.0, Tivoli LDAP, ESRI, WebSphere

Confidential,atlanta, ga Feb 2009 - May 2009
Sr. Cognos Developer

• Interacted with end users to gather requirement and solve issues.
• Interacted with the Business Analyst to determine the scope of the project.
• Installation and Configuration of Cognos 8, Oracle Client and Toad on window server.
• Imported metadata into Framework Manager and created packages in Cognos 8
• Worked on Dimensional Modeling in FM.
• Generated the relationships for different tables and set the Cardinalities for it.
• Updated the package as per the user requirement.
• Assisted in user securities and administration for LDAP
• Assisted ETL team to developed summarized tables.
• Used Macro and Parameter Map to perform the row level security for pharmacies.
• Created complex reports using Report Studio such as Dashboard, Page Break, Master Detail, Joins, Unions, Classes, Sections etc
• Created various Advance Prompts, Filters and Calculation in Report Studio
• Developed the Custom Templates for reporting purpose.
• Used various conditional formatting for list, crosstab report and prompt page
• Wrote the native SQL for ad hoc queries for quick reporting.
• Involved in the tuning of the reports to optimized the report response time
• Migrated reports to Cognos 8 from the RxER environment.
• Modified the SDK code in Report Studio
• Perform the unit testing of report using Toad
• Worked closely with QA team using JRAC Tracking System
• Deployment of packages, folders, reports and jobs from Development to Production.
• Created Events in Event Studio to run the Weekly and Monthly jobs
• Schedule the jobs and maintain the public folder in Cognos Connection portal
• Troubleshooting in Development and Production environment.
• Updated the tables in Dev Environment for the testing purpose.
• Worked on the user documentation and requirements

Environment: Cognos 8.2/8.4(Framework Manager, Report Studio, Query Studio, Event Studio) Oracle10.0, Windows2000, Toad 9.5, JTRAC

Confidential,Gaithersburg, md Oct 2007- Jan 2009
Cognos Developer

• Gathered end user requirements
• Created metadata model using Framework Manager and published packages in the Cognos 8.2
• Created calculation and filters in the metadata model to improve performance.
• Migrated Catalogs and Reports to Congos 8 environment.
• Provided data security, object security and package security in Framework Manager
• Created complex report using Report Studio and ad hoc reports using Query Studio
• Worked on Drill Through from Report Studio to Report Studio in Cognos 8.2
• Perform validation of reports by using Query Analyzer
• Created dashboard reports in Report Studio and burst them to the Cognos Connection web portal
• Carried out bursting of reports to distribute reports to different end users
• Used IQD’s to create cubes and created reports in report studio
• Used Access Manager to provide security for transformer models.
• Scheduled reports, maintained public and individual folders, distribution lists, users, groups and roles using Cognos Connection in Cognos 8.2
• Worked on knowledge transfer and end user training.

Environment: Cognos 8.2 (Framework Manager, Report Studio, Query Studio), Powerplay Transformer, , Oracle9.0, Cognos Series 7.x,SQL Server2000, Windows2003

Confidential, Fort Worth, TxJan 2006- Aug 2007
Report Author /Developer

Responsibilities:

• Worked extensively on Framework Manager, Report Studio and Query Studio of Cognos 8.2
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and Roles using Cognos connection in Cognos 8.2
• Worked on Multidimensional Models (OLAP) in Framework Manager and used it in Analysis Studio for in depth analysis
• Created Filters, Calculations and Prompts in Framework Manager.
• Created various packages in Framework Manager and published it to Cognos Connection
• Used Framework Manager in ReportNet to model metadata from different databases for use in Report and Query Studio.
• Extensively used prompts, drill-through, master-detail query relationships, summaries, conditional formats, grouping and sorting features of ReportNet to generate efficient and user-friendly reports
• Created Complex reports using Report Studio and performed ad-hoc queries using Query Studio
• Created Business mix reports, Trend over time reports, Forecast reports and Charts using PowerPlay
• Involved in the entire project life cycle from evaluation, installation and development of end user Reports

Environment: Cognos 8.2 (Framework Manager, Query Studio, Report Studio, Query Analyzer), Reportnet1.1, Oracle 9.0

Confidential,Houston, TxAug 2004- Oct 2005

Responsibilities:

• Involved in Migration of Impromptu catalogs to ReportNet using Metadata Migration Utility
• Scheduled ReportNet reports using the Schedule Management tool in Cognos Connection
• Applied Drill through to reports in Report Studio.
• Created sub-reports to show different queries in the same report
• Updated standard reports using Scheduler to inform the staff in different locations
• Worked in a team to build Multidimensional Cubes from the Data marts
• Created Time variance reports and analyzed the revenue breakup for the client base
• Extensively used cascading prompts, drill-through, sub-reports, summaries, conditional formats,
• grouping and association features of Impromptu to generate efficient and user-friendly reports
• Developed Reports in Cognos Impromptu and PowerPlay relating to the HR Department
• Published reports to the Upfront web portal to provide accessibility to the staff
• Used Access Manager to provide security to the Cognos applications

Environment: ReportNet 1.1(Query studio, Framework Manager, Report Studio), Cognos EP Series 7.4 (Impromptu, PowerPlay, Visualizer, IWR Server, Transformer, Upfront, Access Manager), Oracle 8i and Windows 2000

Responsibilities:

• Installed and Configured ReportNet both in a single server and distributed environment
• Created master detail reports, drill through reports, cascading reports, report templates and even combined multiple reports using Report Studio in ReportNet.
• Created Multi-dimension cubes using PowerPlay Transformer to create reports in PowerPlay.
• Administered changes to PowerPlay Cube based upon new requirements for customer identification Project Provided security to cubes based on various organizational hierarchy requirements using
  Access Manager
• Implemented Drill Through in cubes using Power Play Transformer
• Optimized the cube performance and the report response time
• Created Trend Over Time Reports, Ranking, Variance Reports and Forecast Reports
• Customized Upfront based on various user requirements
• Used Report Auditing to assess report activity and system performance of PPES
• Updated standard reports using Scheduler to inform the sales staff in different locations
• Created tool oriented presentations for management and end users
• Provided End User Training and Support for Business Analysts

Environment: ReportNet 1.1, Cognos Series 7.0 (PowerPlay, Transformer, PPES, Access Manager, Upfront, Scheduler), Oracle 8i