SUMMARY

• Over 9yrs 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, Temecula, CA

BI Architect/Principal Consultant

Responsibilities:

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

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 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 utput 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