SUMMARY

• Almost 7 years of experience in Development and implementation of Business Intelligence Applications using various versions of Cognos 10, Cognos 8, Report studio, Query studio, Framework manager and Infrastructure Support & Development.
• I was involved in Requirements Analysis, Design and Development of DW projects. I have worked in various domains like Life Science, Banking & insurance domain in implementing DW solutions using Cognos and Oracle and have sound knowledge and understanding of Quality processes to be followed specially for Compliance projects.
• Interpreting business needs and translates them into application/product requirements including but not limited to business process models, functional and non - functional requirements, use cases, business rules and user interface specifications.
• Elicit requirements using Joint application development (JAD) sessions, interviews, document analysis, requirements workshops, surveys, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis.
• Serve as the conduit between the user community (internal and external users) and the software development team through which requirements flow.
• Drive and challenge business units on their assumptions of how they will successfully execute their plans.
• Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
• Installing, Configuring and working on Cognos BI Report Studio, Query Studio, Analysis Studio with both Cognos 8 & 10 BI.
• Around5 yearsof experience in working withFramework Manager,Query StudioandReport Studioformodel design,Ad-hocreporting andadvanced report authoring. Involved ininstallation, configurationandupgrade to Cognos 8.3 & 8.4
• Experience developing Metadata Models and creating filters, prompts calculations, summaries and functions in Framework manager.
• Extensive Hands on experience in developing DataWarehousing/BI applications using Cognos BI with strong business understanding of Lifescience, Insurance and Health care Domains
• Technical expertise in DataWarehousing(Star Schema and Snowflake Schema architectures) Modeling and the development of Datawarehouse with excellent understanding of schemas, fact tables, dimension table, and Data Marts
• Experience inOracle 10g/9i/8i/8.x, PL/SQL, SQL, TOAD
• Experience infull life cycle project development, including design, coding, testing and implementation and on-going product support
• Proven expertise inanalyzing the Business Intelligenceneeds of the enterprise and building the enterprise Reporting architecture.
• Mentoredandtrainedusers for the successful execution of the project. And trained the power usersto build reports usingReport Studio and Query Studio.
• Working knowledge in making display dynamic and visually appealing by integrating the concept ofDashboards.
• Worked with Business users and developed Functional and Technical design documents, Schema Diagrams based on the business process, trained power users for Adhoc Reporting.
• Knowledge in tracking, documenting, capturing, managing and communicating the requirements which helped in controlling numerous artefacts produced by the teams across the deliverables for a project, help desk ticket support & production support and maintenance using version control tools.
• Self-motivated and enjoy working in a technically challenging environment. Have excellent Communication and interpersonal skills
• Excellent work ethics,self-motivated,quick learnerandteam oriented. Continually provided value added services to the clients throughthoughtful experienceandexcellent communicationskills.

TECHNICAL SKILLS

BI & DW: COGNOS 10BI COGNOS 8BI, Framework Manger, Cognos Report Studio, Cognos 10 & Cognos 8 AdministratorAdministrator, CognosReportNet1.1, SQL Developer and Toad

DBMS: ORACLE 9i / SQL Server

Operating System: Windows 9x, Windows XP & Windows7, Linux, UNIX

OTHERS: IBM WEBSPHERE 6.2, IIS

PROFESSIONAL EXPERIENCE

Confidential, NY

Team Leader

Responsibilities:

• Setting up Entire Cognos Set Up with respect Cognos Installation.
• Responsible for understanding new requirement for Government Pricing Project for Reporting and developing Functional and Technical specification document in working with SME’s and Participating in Client meetings on Integration project Design and Development.
• Cognos Framework Model Package Development and changes according to the New DM design proposed.
• Involved in Development Activities as per complete SDLC Cycle in terms of Requirement Gathering, Development, Testing, UAT Support report enhancements/Defect fixing and exposure to Revitas Application used for Government Pricing.
• Interacted with Business Analyst, Gathered BRD’s and related various Specification Documents.
• Handled and supported multiple teams across in the Project such as (Cognos Reports Deployment/Data Analysis/Cognos Reports.
• Created relational models using Framework manager with multiple layers, and parameter maps and implemented Package level, Object levels and Data level Security.
• Responsible for Creating Training Material for Query Studio (Adhoc reports, Cognos connection overview, Package Design, FM Changes implementation) etc. and Providing periodic status reports as required by the client
• Extensively worked with Report Studio, Framework manager to create reports containing complex calculations, prompts and charts according to the user requirements.
• Created and supported the development of complex reports in Cognos while working with features including Conditional formatting, Drill through, Cascading prompts, Query calculation, Layout Calculation, Conditional Blocks, Master Detail Relationships, Page breaks And render variables.
• Traced the performance of the reports and validated them from the DB level and FM level, to the Report Studio level and tuned the reports for better performance.
• Worked with QA team in documenting and capturing test cases and Involved in review sessions and demos with business users and draft design/Solutions
• Trained Business Analyst under Pfizer for getting use of Cognos connection and query studio.
• Developed and Implemented Best practices(Development Standards, Modeling standards & Security Models)

Confidential

Team Leader

Responsibilities:

• Analysed Business requirements from the analysts, read functional documents, and prepared Cognos reports accordingly.
• Onshore - Offshore Coordinator and Handling the team of around more than 5 members to drive the following Technical Designs of reports Offshore/Onshore Model), Report Build, Testing and defects resolution for the Cognos report & Cognos code.
• Assessment of the requirements to identify the processes required for the report build in the project. Estimate the work effort. Plan the releases and project work plan.
• Drive the development efforts - the report design, build (Framework Manager Design and reports development), and test phase for the report development in Claims Area.
• Prepared the work plan based on the report estimations and managed the report Assignments to the team on time. (Report Build/Unit Test /Defect Resolution) and Review of the Report Code and overall Unit Testing once the report is build and before handing it over to TCoE.
• Conducting report handover sessions with Business upon the Report build and Test completion.
• Responsible for the requirements study, by interacting with the business, to gather the requirement for the Claims process/Enhancements/New Development
• Created Database layer, Business layer and Presentation layer, defining appropriate relationship between Query Subjects and Fact Table in FM.
• Worked in Bug Fixing and enhancements to existing Cognos reports in Report Studio & Models n FM and development of any new reports.
• Developed List, Cross Tab, Drill Through, Master Detail, Chart and Complex reports which involved Multiple Prompts in Report Studio.
• Involved in Cognos Installation reports, development and Migration activities.
• Report enhancements and bug fixing for existing reports.
• Analysing root cause of repeated failures, raising change request to avoid such providing periodic status reports as required by the client.
• Co-ordinated with Functional users for Users Acceptance Testing prior to releasing system changes in production.

Confidential

Team Leader

Responsibilities:

• Involved in the entire Project life cycle Evaluation, design and development of end user reports.
• Setting up Entire Cognos Set Up with respect Cognos Installation.
• Responsible for understanding new requirement for Government Pricing Project for Reporting and developing Functional and Technical specification document in working with SME’s and Participating in Client meetings on Integration project Design and Development.
• Cognos Framework Model Package Development and Reports development. Support Reports Testing and creation of Unit Test Cases along with Functional SME’s/BA’s.
• Gathered and Analysed user requirements and the reporting issues from the users.
• Worked On Functional Design and Technical Design Documents of the Cognos Reports.
• Created packages combining data from Different sources using FM.
• Cognos Reports Migration and testing between different environments and Versions.
• Created reports using Report Studio and performed ad-hoc queries using Query Studio.
• Created out bursting of reports in Report Studio
• Developed List, Cross Tab, drill through, master-detail and other complex reports which involved multiple prompts in Report Studio.
• Created Time Variance reports and analysed the revenue breakup for the client base
• Scheduled report using Schedule Management tool, maintained Public and individual folders, distribution lists, users, groups and roles using Cognos Connections.
• Drill through reports to drill down to the smallest factor, or key performance indicator, to see the implications of a change on a forecast.
• Created appropriate User classes, users and Database signons in Access manager to provide different levels of security for the users.
• Closely worked with ETL team to design Data Marts by understanding user requirements and increasing the reporting efficiency.
• Analysed source systems, metadata definitions, report structures, DWH infrastructure including performing of data traceability matrix, data profiling, hardware capacity planning, sizing, data Audits and identifying process gaps, conflicts, redundancies, opportunities of improvement.
• Mentored and engaged in Design, Development, SIT & UAT phases of implementing Data Marts, ETL mappings, routines, BI Reports & Dashboards.
• Conducted regular project meetings, follow-up & provided timely project reports - project status, upcoming tasks, outstanding issues & risks.

Confidential

Team Lead

Responsibilities:

• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Installed & configured the Cognos 8.4 BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Design and Developed the Framework Manager models using Stored procedures, Relational tables and published in to server.
• Providing support from the Cognos perspective by testing Cognos reports for which the request used to come for testing by running the given Cognos Query in the TOAD in the given databases and fixing defects in case if the report would not run and also providing the concern solutions for fixing the errors for the reports.
• Performed analysis for the Cognos reports which was done against the Cognos report and also against the query which pulls the data into the Cognos reports. The analysis would include the functionality, purpose, report specifications and the query description for the report. There were two databases which Cognos report uses for generating the data into it, the analysis for the report was done against both these databases.
• Customizing Cognos Connection Portal based on user specifications.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Performance tuning the by analyzing and comparing the turnaround times between SQL and Cognos.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Involved into move to Deployment to UAT and Production.
• 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& Deliverables and working on high priority issues
• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Confidential

Cognos Administrator/ Application Designer

Responsibilities:

• Installed Cognos and configured the server of the clients.
• Prepared manuals and trained the staff on duty.
• Developed, managed and monitored testing and production environment.
• Handled multiple projects including over 20 application servers.
• Coordinated with the client and took project requirements and feedback.
• Provided valuable input at all stages of work.
• Took care of the technical and operational issues.
• Ensured proper scheduling and administration of Cognos connection.
• Enhanced the system developments to improve productivity of the clients.
• Involved in installation Cognos 8.4 Suite on Unix and Windows.
• Creation of Groups and Roles. Adding users in Cognos Administration and supporting Deployments.
• Resolving incident tickets by providing Production Support which involves solving user problems and Scheduling, Deployment and administering Dispatchers.
• Involved in Performance Tuning of the reports.
• Preparing User manuals, Operational Guides, Planning and Conducting User trainings.
• Involved in the Cognos Administration like creating new DataSource Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Collecting and sharing best practices and tips in Framework Manager Modeling, security setup, Report Authoring, Stress testing and Performance tuning.
• Addressing the Performance and other Production issues with the Cognos 8 reports and Powerplay cubes.
• Created various SQL for the test cases and also used some User-Defined SQL’s In Framework Manager.
• Preparing the Functional Specification Document and Detail design document of the project.
• Creation and publishing of the package using the Framework Manager model in the Framework Manager considering the User requirement Specification.
• Creation of Multidimensional Cube using Powerplay Transformer along with complex reports using Multidimensional Cube as data source.
• Performance tuning and monitoring of the cube.
• Creating Complex Reports (List Report, Master Detail Report, Pageset, Chart Report, and Drill through Report) in Report Studio Data source creation.
• Developed burst reports using Query Studio, Report Studio and other Cognos 7 tools.

Confidential

Cognos Administrator/ Application

Responsibilities:

• Granting access to the users in Cognos Administration.
• Creation of data sources.
• Deployment of the packages from one environment to the other environment.
• Adding users to the access manager.
• Handling the content manager status.
• Cube creation, further performing the enhancement cases in the Cognos cube.
• Monitoring Cube, Report performance.
• Involved in Cognos administration and in performing the enhancement cases related to Cognos Powerplay.
• Creating Complex Reports in Report Studio.
• Granting access to the users in Cognos Administration.
• Creation of data source.
• Deployment of the packages from one environment to the other environment.
• Adding users to the access manager.
• Handling the content manager status.
• Cube creation, further performing the enhancement cases in the Cognos cube.
• Monitoring Cube, Report performance.
• Prepared User documentation to train users and functionality of each report.
• Production Support which involves solving user problems.

Confidential

Cognos Report Developer/Software Engineer

Responsibilities:

• Installed and configured Cognos 8 client at offshore with client server.
• Creating and publishing packages for report authors using cube as data source further developing reports in report studio using cubes as data source.
• Implemented and created test cases and provided the support after the production deployment/Go Live.
• 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.
• Created Standard Reports using Report Studio and Ad- Hoc Reports using Query Studio.
• Interpreted complex Business specifications developed by the client and generated cubes and reports to meet customer specifications.
• Created standard and Ad hoc reports using Cognos Impromptu Designed catalogs and defined User Classes, Security and Privileges.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query 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.
• Administering the business users in the portal based on the requirements.