SUMMARY:

• 13+ years of IT Experience in Software Design, Development, and Analysis, Testing, Data Warehouse and Business Intelligence.
• Expertise with Cognos Version 8 /10 (Report Studio, Framework manager, Metric Studio, Analysis Studio)
• Experience in building and publishing packages, managed security issues, designed Meta data models created consolidated views and presentation views using Framework Manager.
• Designed and Developed Dynamic Dashboards to evaluate the company’s performance.
• Extensive experience in Analysis and E - R Modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional & multidimensional modeling.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying Security (Access manager, Object level, Data level, Package level, Row level)
• Developed web, client/server using restful API’s like IBM COGNOS, Jersy and Jackson.
• Manage all aspects of Cognos TM1 Application including Architect, Perspectives applications. Functions include configuration, support, maintenance and enhancement Cognos TM1 applications.
• Designed and developed Complex TI process.
• Extensive experience with managing Cognos TM1 Planning and Reporting Tool
• Strong analytical and problem solving skills.
• Design, Develop and Executed Model Split during company split.
• Created Business requirements, Technical Documentation and installed procedures.

TECHNICAL SKILLS:

BI Tools: Cognos 10/8, Cognos TM 1 9.4.1/9.5.2, Turbo Integrator, Perspective, Report Net 1.1, Framework manager, Power Play Transformer, Cognos Access Manager, and Report Studio, Query Studio, Analysis Studio, Metric Designer, Metric Studio

Operating system: Windows NT/2000/XP, MS-DOS, Unix (Solaris).

Database Technologies: SQL Server 7.0/2000/2005, Oracle8i/9i, Oracle 10g, MS ODBC/JDBC, Access, T-SQL, SQL, PL/SQL, Informatica 6.x/7.x, Data Stage 7

DB Development Tool: Informatics 5.1/6.2 (Power Center/Power mart), Designer

Languages: XML, HTML, VBScript, VB 6.0, Shell Scripts, Java, C/C++

Web Servers: IIS 5.0, Netscape Directory Server, Apache/1.3.2.8

PROFESSIONAL EXPERIENCE:

Confidential, Fremont CA

Data Analytics

Responsibilities:

• Confidential is a company who designers Wide Format Printers and Software for the digital printing Industry. Data is extracted from the SAP source to Datawrehouse and Reports and analytics build in Cognos. Other sources involve Sale force and Jira for reporting and Analytics. Planning data from Tm1 and Actual from the SAP source used to calculate the delta or variance.
• Have designed and developed complex and advanced TM1 Turbo Integrator script.
• Designed and developed sub-process, Copy process and Hierarchy designs using script.
• Implemented different level of security in TM1 like cell level element level dimension level and cube level.
• Designed and developed TI process to ETL Data as well as manipulate Meta data as needed writing scripts.
• Responsible for Data modeling and Cognos report development, integrated REST API services with Cognos reports using JavaScript, WebSphere Designed and developed scripts for dynamic views (source view and zero out views).
• Experience in integrating BI Publisher with OBIEE.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Architect and lead teams to build interfaces to integrate applications like ERP, CRM and Business Intelligence
• Played role of Subject Matter expert SCM architectfor CRM
• Moved the developed code from Dev to production server.
• Have worked with contributor and workflow management.
• Keep track of log files and weekly cleanup.
• Worked very closely with users on design perspective reports as well as data input templates and active forms.
• Designed and developed complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio .

Confidential, San Francisco CA

Information Manager Cognos Architect/Analyst

Responsibility:

• Expert in developing reporting applications using Cognos 10 BI components (Framework Manager, Business Insight, Business insight advanced, Report Studio, Query Studio, Analysis Studio, Active Reports and Cognos Connection).
• Developed and Published Packages using Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Used REST API at IBM InfoSphere
• Complex Report building experience in Report studio by using filters customized prompts, conditional formatting, drill-through, Cross tab, bursting, Master/details queries, and HTML Scripting .
• Deliver advanced reporting solutions such as Dashboards . Created complex Dashboards with Area charts, Pie charts, Cross tabs and Multi prompts in Report Studio .
• Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like Star schema and snowflake schema .
• Experience in Designing Transformer models and developing for corporate data for building Multidimensional Cubes (MOLAP/OLAP/ROLAP) .
• Strong troubleshooting and production support skills and interaction abilities with end users.
• Developed multidimensional models (DMR) and published packages using framework manager and then generated reports from these packages.
• Architect and Develop Big Data ETL using Pig and Flume, with Storage in Sequential / Avro Format and expose it using Hive to Visualization tools like Tableu.
• Created corporate and departmental dashboards using OBIEE and Tableau.
• Managed TM1 application end to end
• Weekly recycling of the TM1 services.
• Maintain and Deploy Cognos TM1 application between Development & Production environments.
• Design, Develop and Executed Model Split during company split.
• Build Cubes in Cognos TM1 and applied rules to customize the calculation.
• Developed cube, complex rules and setup feeders based on the requirement
• Maintain Cognos, Cognos TM1, Cube, Dimension, Element level security.
• Create Cognos TM1 models including cube design, dimensions, subsets, Rules Editor usage/design, log files, and TI processes.
• Developed and designed the ETL login in TI process.
• Performed Troubleshooting by Diagnosing errors by viewing error log files.
• ETL logic was designed for dynamic views (source view and zero put views).

Environment: Oracle 11i, Cognos TM1 9.5.2, Turbo Integrator, TM1 Perspective, TM1 Architect, Cognos 10, Report Studio, Analysis Studio, Active Reports Cognos Connection, Business Insight Advance, Business Insight

Confidential, Fremont CA

Cognos Architect

Responsibilities:

• WLS Data mart is an infrastructure used to consolidate loans tracking information into a single repository from multiple applications and to provide operational level reporting to various managers in WLS.
• Managed, coordinated and monitored the overall delivery of projects from Inception to Production.
• Produced and maintained project plans, produced all controlling and tracking documentation.
• Closely worked to main the quality of the, delivery of project work products, and management of budget and costs.
• Designed, Developed and implemented information management solutions as Business Intelligence solutions.
• Extensively involved in all phases BI Project t implementation which includes assessment, requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model, report Development, performance tuning, and report Delivery mechanism.
• Developed and developed the Technical Design Specification.
• Collaborated with business and developed high-level designs, including logical models and functional specification documents.
• Designed and developed the Cognos 10 implementation strategy.
• Installed and configured Cognos 10.1.1 in a multi-server environment.
• Developed complex Reports with multiple report page and drill-through.
• Involved in user training for Report Studio and Framework manger Modeling.
• Prepared training materials, developing Business models and training users in Query Studio, Report Studio according to their specific needs and requirements.
• Developed the Power play transformer cubes for analysis.
• Involved in, daily, weekly meeting in resolving issues and updating the changes to the reports.
• Designed and implementation the balanced scorecard, and online analytical processing (OLAP) solutions.
• Defined the scope for Cognos 10 Migration Project.
• Installed and configured the Lifecycle Manager, created projects and compared the source and target output.
• Designed and developed Power play cubes for multidimensional analysis.
• Recommended and designed summary tables to be used in reports to optimize performance.
• Wrote SQL queries as part of Data Validation.
• Administered Cognos BI Server Environment.
• Managed Package Migrations and Deployments between environments (Dev, QA, Prod) .
• Managed Data Sources, run activities, user accounts and permissions
• Implemented Lifecycle Manger to validate source and target reports.
• Successfully upgraded Cognos 8.4 to Cognos 10.1(Content Store: Cubes, Framework Manger Package, and Reports)

Environment: Oracle 10g, Cognos 8.3, Cognos 10.1.1, Report Studio, Query Studio, Analysis Studio, Powderly Transformer.

Confidential, Oakland CA

BI Architect/ Lead

Responsibility:

• Designed and developed executive Dashboard.
• Designed and developed a Cognos Framework Manger Package.
• Provide the extensive training for the users on report design and development.
• Designed and Developed complex reporting solutions.
• Fine tuned the reports for performance.
• Participated in conference calls and meetings with the users.

Environment: DB2, Oracle, SQL Server, Cognos 8.4, Report Studio, Analysis Studio, Query Studio.

Confidential, Warren NJ

Cognos BI Lead

Responsibility:

• Created a Project plan for the BI team.
• Involved in requirement gathering with the users.
• Designed Technical Design Document based on the Functional Design.
• Delegated Task to subordinates and update the status to Managers.
• Designed a Consolidated Data Model using Erwin.

  Defined Logical Names Physical Names and created a Data Dictionary.

• Designed the Cognso FM Model with the consolidated view.
• Created 3 Layer architecture at FM, Database Layer Business Layer Presentation Layer.
• Applied Row level security in Fact table.
• Designed Complex reports with calculations.
• Created Drill through reports and Dashboard type reports in Report Studio.
• Participated in conference calls and meetings.
• Installed and configured TM1 in a single server environment.
• Created a POC environment and designed some cubes and analysis.

Environment: Oracle 10g, Sybase IQ 12, Cognos TM9.4, Cognos 8.4, Report studio, Analysis Studio, Framework Manager

Confidential, Beaverton OR

Sr. Cognos Consultant

Responsibility:

• Worked with users to finalize the requirement, prepared the Technical Specification from Functional Specification.
• Extensively involved in designing Metadata Model using Framework Manger.
• Create a Multilayer Design in Framework Manager to separate the Business Layer from Data layer for Manageability and readability.
• Applied best practice in FM for Effective query generation.
• Design the Standard template for report by applying standard prompt pages.
• Prepared the reporting best practice document about how to name the Query, parameter and variable of the report.
• Created render variable for a report so the users can choose from Available fields to insert into reports.
• Created dimensions and cubes using Cognos TM1 9.4
• Created rules and worked with Turbo Integrator
• Installed and Configured Cognos Enterprises Planning for POC in a single server.
• Extensive experience with IBM Cognos TM1 (Applix) tools including IBM Cognos TM1 Web and Turbo-Integrator
• Extensive design and implementation experience with TM1 cubes
• Created Framework Manager Specification Document

Environment: Teradata, Cognos 8.3 (Query Studio, Report Studio, Analysis Studio, Framework Manager), Teradata, Cognos TM1 9.4

Confidential, Portland OR

Sr. Cognos Admin/Architect

Responsibility:

• Created technical Design document from Functional specification.
• Identified the Data Elements parameters, Inclusions, Exclusion for each individual report and document them.
• Identified the format for each data element and document them accordingly.
• Created Framework Manager Model using best practices.
• Participated in conference calls and Meeting with users for functional design verification and requirement change.
• Designed and developed complex reports with multiple prompt pages.
• Involved in isolating the issues and finding the solutions (Server level, Product level, Report level, User level)
• If necessary, repair and create new joins, built standalone filters, prompts, merge query subjects in to new query subject by determine hierarchy and dimension information.
• Complete environment administration, models creation in Framework Manager.
• Engage users in analysis and evaluation of functional models and prototypes; identify dependencies and priorities.

Environment: DB2, Cognos 8.3, Report Studio, Analysis Studio, Metric Studio, Query Studio

Confidential, Minneapolis MN

Sr. Cognos Architect/Analyst

Responsibility:

• Designed and Developed Meta Data Models in Framework Manager.
• Extracted data from recruiting department to flat files and load the data to the target database by creating DTS Packages.
• Conducted a formal training program for the Report Authors.
• Designed and Developed List Reports, Cross tab Reports, Charts by using Report Studio.
• Created Interactive Reports by building regular prompts, cascading prompts.
• Cleaned up the FM Package and set up basic standards for the packages and models to follow the best practices.
• Developed reports in Report Studio and implemented grouping, calculations and filters.
• Upgraded Report from Impromptu to CRN and to Cognos 8.
• Rewritten those reports which were not upgradeable.
• Created user groups and roles as per the company standard and integrated Active Directory for authentication.
• Created drill through reports.
• Scheduled reports in Cognos Connection based on the reports to run daily, weekly or monthly basis.
• Involved in creating views and stored procedures that are required for the Cognos reports.

Environment: SQL Server 2005, SQL Server 2000, Cognos 8.1, Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection

Confidential, Eden Prairie, MN

Cognos Admin/Architect/Lead Developer

Responsibility:

• Installed and configured Cognos 8.2 in Dev, Standalone Environment and Cognos 8.3 in Multi server Production Environment.
• Created DMR in Framework manager and Published to Report Server.
• Extensive understanding of BI architecture and the workflow.
• Administered User Groups and Roles by creating permissions in Cognos Report Net.
• Designed Access Policy for Cognos Report Net users.
• Migrated Reports from Cognos 8.2 to 8.3
• Initiated a training class for the users to build the Framework Model and Report Studio.
• Extensive experience on Structuring Metadata and Cognos Models using Framework Manager Environment.
• Designed and Prepared a Training Material for the Users.
• Thorough knowledge of Cognos 8 architecture and administration functions including Content Store, Framework Manager, and Report Studio/Analysis/Query Studios /Metric Studio reports development).
• Extensive experience in Security Administration based on and Microsoft Active Directory.
• Formalized the reporting process by creating the technical specification and requirement specification.
• Upgraded the .mdl and .pyj file form cognos 8.2 to Cognos 8.3 and rebuild the cubes.
• Migrated the Metric Model using Metric Designer from 8.2 to 8.3

Environment: Oracle 10g, SQL Server 2005, Cognos 8.2, Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, DB2

Confidential, Plymouth, MN

Senior Cognos Consultan

Responsibility:

• Produced, published and distribute reports relating to the performance and availability of UHG systems.
• Gather data from various data sources and applications incorporating metrics and measurements on Incident, Change, Problem, Configuration, Availability, Capacity and Service Level Management.
• Reports are used to drive business decisions on the continuous improvement of system availability and the quality of customer service delivered by UHG.
• Analyzed and evaluated client requests for information and develop procedures to extract data from the various relational databases utilizing Cognos, Crystal Reports, SQL and other data analysis tools.
• Preparing deployment archives of reporting packages and deploying archived packages from Development, Production and QA.
• Created groups and users, roles, folder deployment, grant access permissions, scheduling reports and setting up default prompt values, application of patches.
• Complete environment administration, models creation in Framework Manager
• Develop and Maintain reports to support the Customers requirements on a weekly, monthly, quarterly, or yearly basis

Environment: Report Net 1.1 MR3 (Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL, Oracle 9i, Windows NT, UNIX, DB2

Confidential, CA

Senior Cognos Developer

Responsibility:

• Consultation with users for requirement gathering and close interaction in detail for accurate outcome with DBA and BA.
• Involved in installation and administration of Cognos Report Net including Framework Manager.
• Involved in data management, including modeling of tables, and data marts, and mapping of data between source systems and delivery infrastructure.
• Set user roles, define governors and set access authority for the packages to different users.
• Was involved in installing Cognos in the Server.
• Test the model and verify if the results of queries are accurate and published to cognos connection.
• Implemented Security Administration based on and Microsoft Active Directory.
• Installed, Configured and customized the Development, Production and QA environment.
• Worked with Framework Manager to create Metadata models.
• Developed List Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Generated various kinds of reports (daily, monthly etc.) in ReportNet .
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection

Environment: Report Net 1.1 MR3, Framework Manager, Report Studio, Cognos Connection, Windows 2000, Sql Server 2000, Oracle 9i

Confidential, Beverly, MA

Report Net Developer

Responsibility:

• Involved in installation and administration of Cognos ReportNet including Framework Manager.
• Worked on gathering User Requirements, Created Cognos Impromptu Catalogs for Impromptu Reporting and Power Cube development.
• Worked with Framework Manager to create metadata models.
• Worked with ReportNet SDK to automate and customize the report generation.
• Secure the ReportNet portal by disabling anonymous access and authenticating the users with Single Sign-on from the One Source portal.
• Developed standard templates. Developing standard reports, charts, drill through reports, master detail reports, bursting reports and multilingual reports using Report Studio and Query Studio.
• Designed models by mapping business needs using PowerPlay Transformer and created multi dimensional cubes, cube groups, PowerPlay reports.
• Implemented security and granted privileges according to user classes using Access Manager.
• Creation of standard filters, calculations, prompts and conditions in catalog.

  Query optimization, weighing the tables in Cognos.

Environment: Cognos ReportNet 1.0 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio), CRN-SDK, Impromptu, PowerPlay v7.2, PowerPlay Transformer v7.2, Cognos Query, Upfront, SQL Server2000, Access Manager, Visualizer.