SUMMARY

• Over 9 yrs of 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, Informatica training.
• Experience in Cognos 10/8 tools for advanced Report authoring and Metadata 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
• 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), Informatica 9

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

PROFESSIONAL EXPERIENCE

Confidential, El Segundo, CA

Principal BI Consultant

Responsibilities:

• Interacted with internal team and external team for Cognos project allocation and service requsts.
• Maintained strict adherence to all project milestone and timely execution for all issues
• Provided technical assistance, training and mentoring to Users and business analyst
• Involved in migration process to map the scope of the reports from Cognos 8 to Cognos 10
• Performed the administrative duties of scheduling, creating User Groups, triggers etc
• Troubleshooting and tuned FM models.
• Report Design using Cognos Report Studio, Analysis Studio and Query Studio
• Developing and tuning report studio reports using TM1 cubes and Transformer cubes
• Created and maintained complex report studio reports with multiple complex queries, joins, unions, conditional formatting and customized SQL based reports.
• Provided inputs to design global reporting template across all business segments
• Performed Unit Testing and User Acceptance Testing
• Performed and interacting with database team to tune the SQL
• Wrote and tuned Pass Through SQL for ad hoc report requests
• Implemented security at Package level, Object level, Data level using Framework Manager
• Enhanced Transformer cubes with new reporting updates
• Developed test cases for the validation and verification of the reports.
• Worked on the design documentation, deployment guide and user guide.
• Worked on ticket tracking system to work with priorities
• Involved in the production support activity to resolved the issues with high priority reports

Environment: Cognos 10/8.3 (Framework Manager, Transformer, Query Studio, Analysis Studio, Report Studio, Active Reports), Informatica 9, Teradata, BSP Meta Manager

Confidential, CA

BI Architect/Principal Consultant

Responsibilities:

• 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.
• Worked with offshore team and lay down project scope and project deliverables.
• Worked on the design documentation, deployment guide and user guide.
• Created the mapping document between the UI, transactional system and the analytics.
• Participated in the discussion of design and development ETL mappings and Fine-tuned existing Informatica maps for performance optimization
• Troubleshed and tuned of FM models and reports for better performance.
• Created and maintained complex report studio reports with multiple complex queries, joins, unions etc
• Performed the administrative duties of scheduling, creating User Groups, deployment across different environment
• Provided technical assistance, training and mentoring to Users and Business Partners.
• Worked on Proof of Concepts (POCs) for Active Reports etc
• Created the mapping and scalability document to find out the scope of UI, transactional and analytics systems

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

Confidential

Sr. Cognos Developer

Responsibilities:

• 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.
• 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

Sr. Cognos Developer/Administrator

Responsibilities:

• 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 connections.
• Mapped LDAP groups to the Cognos user groups and roles.
• Recommended and implemented the sizing, scaling and load balancing to optimize the burst report output performance.
• Developed disaster recovery plan by configuring primary/secondary content manager and application servers.
• Involved in System Performance monitoring task.
• 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 Contents and Report Layout.
• 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 and slicers.
• 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