SUMMARY

• Over 8 years of IT experience as a Cognos Consultant in the development of Data Warehousing, Reporting Solutions, design and development of Transformer models, simple and complex Reports using Cognos Series 7.x/8.x/10.1 development and administration of Framework manager models using Cognos TM1/BI Suite.
• Experience in various COGNOS Tools - Cognos 10/8.4/8.3 / 8.2 / 8.1 B.I Suite includes Report Studio, Analysis Studio, Query Studio, Cognos Connection, Impromptu, IWR, Power Play Transformer and Power Play Tools, Business Insight, Business Insight advance and Active Reports.
• Worked on multiple Cognos BI/Data Warehouse projects with strong technical skills (Modeling and Report Authoring) and deep Functional/Business knowledge.
• Extensively worked on Framework Manger in creating models and implementing ‘best practices’
• Designed & Developed TM1 Processes, Dimensions, Cubes and Applications,
• Solved most of the Complex part in TM1 and Cognos BI integration.
• Designed Business Models to meet complex reporting requirement using Cognos Framework Manger, Report Studio, and Query Studio.
• Worked on complete BI Life Cycle Development process which includes requirement Gathering, Modeling, Authoring, Testing, Maintenance, and End-User Training
• Experience in advanced reporting like List, Cross tab, Repeater, charts and Dashboards using cognos8.x, cognos10.1 report studios and ad hock reporting using cognos8/10 Query Studio.
• Complex Report Building Experience by using SQL, Filters, Customized Prompts, Conditional Formatting and Complex Layouts like Cross tabs, sub reporting and Bursting.
• Planned and constructed OLAP models and Transformer Cubes using Transformer.
• Proficient in using Cognos connection in scheduling report, creating report view, managing portals, customizing pages, adding portlets to portlets communication and working on Cognos administration.
• Strong experience in Dimensional data modeling, Star Schema/Snowflake modeling, Physical & Logical data modeling.
• Experienced in working with databases like Oracle, MS SQL Server 2005/2008, and DB2.
• Experience in taking end-user business requirements and translate them into design specifications.
• Created Ad-Hoc reports using Query studio, Analysis studio and Trained power users to use Query studio, Analysis studio for Ad-Hoc reporting
• Designed, developed Cognos data models and published Packages in Framework Manager to COGNOS 10 BI Server/Report Net Server.
• Experience in Creating Models and publishing packages, and creating different layers like Database Layer, Business Layer, and Logical Layer in Framework manager.
• Experienced in applying package level, data level and object level securities at metadata level in framework Manager.
• Adept in creating Cognos roles in LDAP
• Vast industry experience in diverse areas of Finance, Accounting, Marketing, Retail, Chemical, Insurance, Sales and services.

TECHNICAL SKILLS

BI/OLAP: Cognos TM1 and BI 10/8.4/8.3/8.2/8.1 (Report Studio, Query Studio, Cognos Connection, Analysis Studio, Event Studio and Framework Manager), Cognos Go Office, Reportnet 1.1, Powerplay Transformer, Impromptu Web Reports (IWR), Upfront, Cognos Impromptu Administrator, Cognos SDK and MS-Excel

Databases: Oracle 11g/10g/9i/8i, MS SQL Server, MS Access.

Database Tools: TOAD, Rapid SQL, Query Analyzer, SQL Developer.

Data Modeling: ER/Studio 3.5/4.0, Erwin 7.3/4.1, Power Designer.

Languages: C, C++, Java, Excel VBA, SQL, PL/SQL.

Operating Systems: Windows 7/XP/2000, UNIX (AIX, HP-UX), LINUX.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Provided BI solutions across all areas of Cognos including Cognos Administration, support, design and development of BI applications and Data Warehouse projects.
• Developed the projects as per Agile methodologies.
• Interacting with business analysts to gather requirements to design and develop the reports.
• Involved in peer review process to review the reports created by developers.
• Worked closely with Business analysts and Data Warehouse team to design the best BI models for reporting and analysis.
• Understanding the TM1 Cube built requirements and Post population calculation behind each scenario.
• Taking updates from onsite on daily bases and transferring that knowledge to offshore team.
• Preparing documents for the integration of TM1 and Cognos BI, and shared to onsite and offshore team.
• Developed User Interfaces, Reports, Rules and Turbo Integrator processes using Cognos TM1 for Expenses, Revenues, Salary and Incentive Compensation, Headcount, Budget Variance and Summary.
• Worked with advenced features of IBM Cognos Incentive Compensation Management V8.0 like workflow and routing functionality that simplifies the management of compensation related business processes and Performance improvements that may result in faster sales compensation calculation times.
• Using IBM Cognos Incentive Compensation Management (ICM), you can change your password after you log in to the web client.
• Effectively enhanced the changes to compensation plans and configured the system to streamline the compensation process as per users requirement.
• Build the incentive compensation management reports for user to manage very complex compensation programs.
• Enabled incentive compensation management reports and function assignment through a web interface between users; such as approving a compensation plan document, assigning quota targets and administering commission splits or adjustments.
• Created/developed a customized business HR process/procedure and SQR report for all store managers compensation increases based on sales performance and current salary ratios.
• Created a project plan and made team to working accordingly to reach the goal on time.
• Involved in developing TM1 input page in .ASPX and understanding the Code behind it.
• Developed a Java Script to pull the TM1 input Page to Cognos and also java script for handshaking of TM1 and Cognos BI.
• Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
• Solved most of the Complex part in TM1 and Cognos BI integration.
• Training resources on TM1 and Cognos.
• Created most of the Documents like Technical Document, LLD, TM1 and BI integration document, Work flow Document, Project Plan, Document on report format and Standards etc.
• Worked on different projects that involved creating project plans, managing the project.
• Created Framework packages with various security settings and published onto Cognos Connection.
• Created Database layer, Business layer in the model by defining appropriate relationship between query subjects.
• Defined package level, object level securities to allow users create calculations over the query items.
• Modeled the metadata in the project by adding business rules such as filters and calculations.
• Build power cubes with package as source using power play transformer.
• Generated packages out of the cubes and published onto cognos connection.
• Upgraded reports from Cognos 8.4 to Cognos 10.1
• Developed complex reports like multipage reports with master detail relationships, Prompts, Calculations and Conditions using cognos report studio In PDF and excel and adhoc reports using query studio.
• Responsible for creation of metadata models in Framework Manager and cubes in Transformer Responsible for upgrading their Enterprise Planning and Cognos BI Content from Cognos 8.4 to Cognos 10.1.1 and troubleshooting upgrade process
• Developed various dimensional and relational reports by employing lists, crosstabs, charts, union, joins, burst, master-detail, drill through and drill down, report burst techniques
• Administering user access to reporting applications which includes setting up cognos security by assigning users to the groups and roles defined in the cognos Namespace.
• Giving Access to different folders, Packages, Reports based on the users request.
• Scheduled and distributed reports using Schedule Management In cognos connection.
• Worked with ETL team to design datamarts by understanding user requirements and increasing the reporting efficiency.
• Performed unit testing and documented test cases and detail design of the project.

Environment: Cognos 10 Suite, Windows XP., Cognos TM1 Oracle 11g, Windows 2003 Server, Unix Shell scripting, SQLServer2005, Shell scripting, UNIX, Tomcat/Apache, Cognos SDK.

Confidential, Bloomington, IL

Responsibilities:

• Responsibilities: Managed the Cognos Planning and TM1 project as IBM Cognos implementation methodologies standards.
• Planned, and successfully implemented the cross functional projects within defined budgets and timelines.
• Identified and assembled the project resources and directed project team tasks to assure effective project completion.
• Led the overall Cognos Planning architecture in the development and production multi server environments.
• Designed and implemented the migration and upgrading to the current version EP 8.3 to 8.4 in both the environments.
• Designed the analyst models, libraries and application workflow for financial planning and forecasting system.
• Design & coding of programs for the layered inventory & retail compensationsystems.
• Developed and enhanced the merchant forecast and budgeting applications as business needs in Cognos Planning.
• Designed and created rolling planning and forecasting process within the existing planning applications.
• Managed all the design, development and implementation strategy and process in Cognos Enterprise Planning.
• Designed functional solution for planning applications in TM1 financial performance management environment.
• Developed and implemented the best practices in designing and development for TM1 financial planning applications.
• Led the TM1 proven solutions in business process, performance improvement, and system implementation.
• Designed and implemented TM1 architecture for the corporate planning system and applications.
• Migrated EP planning models and applications to new Cognos TM1 system.
• Developed and maintained the planning models in TM1 environment.
• Managed the on-site and offshore team and developed client relationship through all phase of the implementation cycle.
• Managed the change and control process in the financial planning solution design and architecture documentation.
• Involved in Designing DMR models with Relational Data and Relational models using Framework Manager and deployed packages to the Report Servers.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, query subject level and the query item level.
• Used Governing techniques for improving performance of the Query.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Involved in building the complex cubes and optimizing the cube creation.
• Built Multidimensional Cubes, Sub cubes for user groups using PowerPlay Transformer.
• Created and managed jobs and schedules.

Environment: Cognos 10/8.4 Suite, Windows XP., Cognos TM1 Oracle 10g, Windows 2003 Server, Unix Shell scripting, SQLServer2005, Shell scripting, UNIX, Tomcat/Apache, Cognos SDK.

Confidential, Dallas, TX

Responsibilities:

• Involved in analyzing and gathering requirements and provide input into project timelines and ensure adherence to project timelines.
• Designed, implemented technical solutions that address complex business requirements and served as a main technical support and perform root cause analysis for problems experienced within all the cognos reports/Models.
• Designed and developed/modified the Framework Manager model packages defining the cardinalities and namespaces
• Designed and developed complex cognos reports and dashboards per business requirements.
• Created list reports and cross tab reports, charts, Maps and drill through reports. Created complex filters, Conditions and complex financial calculations for developing the reports using report studio as per the user requirements.
• Created Multi page reports with grouping and sorting, creating -master detail relationships.
• Used Conditional formatting to discard unwanted columns in the report using style variables
• Used render variable on some report pages and also on List, Bar Graphs to render the list and the graph based on the user selection.
• Used Conditional blocks to display the graphs, crosstab and list based on selection of a value from the value prompt.
• Experience in developing Dashboards for data management, data quality, and decision making ability and analyzing requirements. Knowledge of logical and physical data modeling and data warehouse architecture.
• Worked extensively in development of Framework Manager Model for development of dashboard style complex reports like Global Clinical Dashboard, Protocol Enrollment, Site Enrollment, Country Enrollment, Milestones and Management Reports throughout the project.
• Implemented Security prototype for cognos business intelligence environment incorporating row level, object level, data level, and package level and report level security.
• Identifying and implementing process improvements in the existing cognos reports/dashboards.
• Performed scheduling of the reports and created report view of a report for the users.
• Deployed reports and packages from development to test and from test to production using cognos administration.
• Worked with cognos support team and Involved in production support by resolving users problems.
• Support unit testing, integration testing and user acceptance testing.

Environment: Cognos 8.3 BI (Report Studio, Query Studio, Framework Manager, Connection), PowerPlay Transformer, PowerPlay Windows, Access Manager, Oracle 10g/9i, Erwin 4.0, 7.1, SQL Server 2000, Flat Files, Windows NT

Confidential, Richmond, VA

Responsibilities:

• Worked with Cognos 8.1 during this requirement because Confidential was migrating Impromptu Catalogs to Cognos 8.1 and PowerPlay cubes to Cognos 8.1
• Worked extensively on creating the Model and publishing the package on Cognos Connection for future reporting.
• Designed and developed the Cognos 8.1 Framework Manager Metadata Model using PowerPlay cubes, Impromptu Catalogs as Data Sources to accommodate future growth in reporting requirements.
• Single Handedly Migrated cubes and Impromptu Catalogs from Series 7 to Cognos 8.1 MR1.
• Created cube model packages in FrameWork Manager. A folder structure is used to group the cubes of the same nature in Upfront.
• Optimized the cubes and set up Framework Manger model so that the cubes can be used in Analysis Studio and Report Studio.
• Gathered the requirements from Business Users and created the reports based on those requirements in Analysis Studio as well as in Report Studio.
• Upgraded Reportnet to Cognos 8.1 to get the required results as per the client requirement.
• Designed, developed, Tested and improved Report Performance.
• Created reports using cube views in production Series 7 in the Upfront folder.
• Trained Business users in Analysis Studio.
• Created reports by using data from various data marts created by DataStage jobs.
• Created Frame Work Manager Models using PL/SQL stored Procedures.
• Migrated ReportNet 1.1 MR1 package on to Cognos 8.1
• Created Dashboards in Cognos 8 BI to communicate complex information quickly.

Environment: Cognos 8.1 BI, Analysis Studio, Event Studio, Framework Manager, Metrics Studio, Cognos Connection, Report Studio, Query Studio, Upfront, Cognos 7 series Impromptu, PowerPlay, IWR, Cognos Configuration Manager, Content Manger, Windows 2000, Oracle 9i, PL/SQL, Microsoft Excel, Microsoft Word, MS Visual SourceSafe 6.0

Confidential

Responsibilities:

• Study the client requirements gather and manage the requirements and assure that the requirements are met in collaboration with the project manager
• Develops functional specifications and system design specifications for client engagements. Assists in enforcement of project deadlines and schedules
• Quickly understands the business issues and data challenges of client's organization and industry.
• Identifies client organization's strengths and weaknesses and suggests areas of improvement
• In corporate the components of running a fiscally successful project
• Identification and segregation of source systems like Finacle for Corporate Assets Liabilities, Finone for Retail lending, Oracle General Ledger for internal accounts, Calypso for Treasury (Bonds), KTP for Treasury (Equities, Forex, Derivatives, Options and swaps) from the Conducting the UAT with the Business users and Reconciliation of Balances for all the reports
• Preparation of scope document for the Customer relationship management (CRM) reports.
• Developing query and mapping for CRM reports.
• Creation of requirement specification documents for CRM reports.
• Created Framework model, giving joins to tables and fields, publishing package.
• Involved in performance tuning and testing reports.
• Responsible for Lead testing efforts; Ensure issues are identified, tracked, reported on and resolved in a timely manner; Communicate needed changes to development team

Environment: Cognos 8.2/8.4 BI (Frame work Manager, Analysis Studio, Event Studio, Report Studio, Query Studio, Cognos Connection), Cognos Series 7 Version 4 (PowerPlay Transformer, PowerPlay Enterprise Server, Oracle10g/11g, TOAD 9.0, Java Script, Informatica 8