SUMMARY

• Over 8 years of experience in Business Intelligence and DWH/Database Applications on multiple domains.
• Strong abilities and Hands on experience in analysis, design, testing, development and implementation of client/server and web applications.
• Strong experience with Cognos Tools such as Cognos BI10.1/8.4 Suite, Cognos TM 1 9.5/10.1/10.2 and Analysis Tools such as Cognos Transformer & Power Play.
• Strong Experience on Installation & Configuring the Cognos 10.1 BI Environment. Worked on Migrating reports from Cognos 8.4.1 to Cognos 10.1 series
• Hands on Experience with Framework Manager Modelling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Expertise in developing Database Schemas such as StarSchema and Snowflake Schema, which are used in relational, dimensional and multidimensional modelling.
• Good Experience with MDX Functions in Report Studio using Multi - dimensional Sources.
• Expertise in developing reports using Active Reports, Report Studio, Query Studio and Analysis Studio.
• Expertise in developing dashboards using Business Insight and Business Insight Advanced.
• Experience in design, develop, and implement financial planning and budgeting models with complex rules.
• Experience in maintaining Cognos enterprise planning (EP) environment for Forecasting and Budgeting life cycles.
• Experience in TM1 Turbo Integrator mapping (Prolog, Metadata, Data & Epilog) and Rules Editor.
• Expertise in creating Dimensions, Cubes& TI processes in Cognos TM1.
• Created regularly scheduled automated jobs to loadTM1data structures and managedTM1data through Excel and Spreadsheets
• Worked on creating packages in MSSQL Server Business Intelligence Studio 2008.
• Experience in various industry sectors such as Taxation, Pharma, Manufacturing and Retailers.
• Involved in Performance Tuning, Developed Stored Procedures, Functions and Packages.
• Worked on Cognos 10 TM1 Insight and Performance Modeler for building Applications, Cubes, Dimensions, Replications, Processes and Models.
• Knowledge on QlikView (Design and Development).
• Strong problem solving skills, ability to develop strategies for clients, and provide detaileddocumentsto clients.
• Extensive experience in Multiple Relational Databases including SQL SERVER, ORACLE, TERADATA.
• Deploying Models and reports from Staging to Production and administering users/groups/roles.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.
• Excellent Team coordinating Skillswith theDevelopmentTeamand Deliverable dates.
• Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem solving skills.
• Proficient at developing and implementing training programs to enhance the efficiency, competency and motivation levels of the employees in line with organizational objectives.
• A keen communicator with honed problem solving & analytical abilities.

TECHNICAL SKILLS

Databases: Teradata,MS SQL Server 2008, Oracle 9i/10g/11g

Cognos Tools: Cognos TM 1 9.5/10.1/10.2 (Performance Modeler, TurboIntegrator, Architect, Perspectives), Cognos EP 8.4(Analyst & CAC),Cognos 8.4/10.1/10.2 Suite (Reports Studio, Analysis Studio, Workspace Insight, Workspace Insight Advanced, Framework Manager, Transformer),SQL Server Business Intelligence studio

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS)

Versioning Tools: Clear case, Share Point, Bug Track

Oracle Tools: SQL*Plus, Toad, SQL*Loader, PL/SQL Developer, SQL Developer, Teradata SQL Assistant

Languages: SQL, PL/SQL Programming

Operating Systems: Windows7/2008 R2/2000/XP, Unix/Linux

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

TM1 Consultant

Responsibilities:

• Developed a custom TM1 solution to maintain dimension Hierarchies across TM1 models and depended applications - Cognos BI & Qlikview.
• Developed Hierarchy Versioning solution, to archive old dimension hierarchies.
• Implemented modular TM1 approach to improve performance of application.
• Worked with Business users to resolve their Ad Hoc reporting issues, and creating user defined custom views.
• Updated existing Rules as per new business requirements.

Environment: Cognos TM1 10.1/10.2(Architect, Perspectives, Active Form, Turbo Integrator, CAFE),SQL Server 2008.

Confidential, Waukegan, IL

TM1 Consultant

Responsibilities:

• DevelopedTurbo Integrator (TI) processes (PROLOG,METADATA,and DATA & EPILOG) to build and update dimensions hierarchies .
• Developed TI wrapper process to handle hierarchy changes of dimensions, deleting consolidated elements and adding them back from data source.
• Developed Rejected Cube populated with TI’s to capture missing metadata either in master/transactional levels.
• DevelopedInformation Log Cube to count number of elements in each dimensionwith recent updated date.
• Created TI to generate subsets for all dimension levels dynamically and assigning them to user views.
• Created TI’s to export data from TM1 cubes to text files. Dynamically created views by developing subsets using MDX functions in PROLOG and assigning them to required view.
• Created Turbo Integrator processes to populate TM1 Cubes with latest forecast data from Data Repository.
• CreatedTM1 rules to handle various calculations in cubes and also to transfer data between cubes
• Worked on skip checks and Feeders while updating Cube Rules.
• Developed web sheets for user to automate monthly forecasting cycles.
• Created rules on Element security cubes and assigned security based on user groups
• Responsible for adding TM1 users, roles, and maintaining security.
• Created TI’s to automate monthly closures and Load Historical data from Data Repository to Monthly Reporting Cubes using TI Process.
• Created POC on TM1 10.2 CAFÉ( Explorations & Flexviews)
• PublishedFramework Manager Model using TM1 cube as Data source and publish packages in Cognos Connection for developing Analysis Reports.
• Created multidimensional crosstab, multi prompt, conditional reports from published TM1 cubes in report studio.
• Support DEV, QA and PROD environments including daily administration, batch processing, configuration management, environmentmigration, and tool automation
• Created SSIS package to extract actuals data from Oracle to SQL Server 2008.
• Created reports in Cognos to find out Deltas between Workday loads (Transactional and Master data).
• Delivered Cognos TM1 integrated with Cognos BI Solutions to a range of areas within the business.

Environment: Cognos TM1 10.1/10.2(Performance modeler, Architect, Perspectives, Active Form, Turbo Integrator,CAFE), Oracle 10g, Cognos 10.2(Cognos Connection, Framework Manger, Report Studio, Analysis studio, Workspace, Workspace Advanced), SQL Server 2008(SSIS and SSMS)

Confidential, Pleasanton, CA

CognosEP/TM1 Consultant

Responsibilities:

• Created TM1 Turbo Integrator processes for populating TM1 cubes from source data.
• Created rules to transfer data between cubes.
• Used TM1 rules editor to create and edit rule to create various calculations.
• Creating regularly scheduled automated jobs to load TM1 data structures.
• Created TI to load data from staging cube to Input Cubes for each region dynamically.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Worked on Active Forms,Slicer and Snapshots to update current Worksheets.
• Scheduled TM1 Chores and Monitored Data Loads on timely manner.
• Responsible for modifying the existing TM1 perspective Excel reports.
• Worked on skip checks and Feeders while updating Cube Rules.
• Updated Prolog, Metadata, Data and Epilog tabs as part of updating current TI processes.
• Worked with End Users for updating metadata for Forecast Rollover Cycle.
• Designed and developed Cognos BI environment to support high concurrency.
• Worked with Business Analysts, end users and internal systems resources to translate business requirements into technical specifications.
• Handled complete range of BI capabilities such as reporting, analysis, dashboards and business event management.
• Provided technical support for Cognos applications including report analysis, development, maintenance, and report migration.
• Responsible for all technical design deliverables
• Enhanced existing Cognos development processes
• Collaborated with peer business intelligence and data warehouse architects on reporting solution designs.
• Prepared power point and excel report based on Cognos GO Office
• Developed IQDS, reports using SQL queries.
• Implemented FM level security based on the user roles and region level security in cubes
• Created batch script to update and publish Cognos power play cubes daily
• Responsible for maintaining current Cognos EP Budgeting & Forecasting system for each roll over cycle.
• Handled updating Cognos EP Analyst objects(D-Lists, D-Cubes, D-Links,A-Tables, E-lists), CAC (Contributor Administration Console - Loading Rights for each roll over cycle, updating Admin Links, Macros,GTP) based on requirements.

Environment: Cognos TM1 9.5/10.1(Performance modeler, Architect, Contributor, Perspectives, Active Form, Turbo Integrator), Oracle 10g, Java Scripts (HTML), Cognos 8.4(Cognos Connection, Framework Manger, Report Studio, Analysis Studio) Cognos Go Office, Cognos Enterprise Planning 8.4(CAC and Analyst).

Confidential, Beaverton, OR

Cognos Consultant

Responsibilities:

• Collecting and analysing information requirements from users and translate those needs into requirements documentation
• Worked with Data Warehouse team as needed to define new data warehouse tables needed for reporting,
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Burst Reports against database.
• Developing the Dashboards using Business Insight and Business Insight Advanced.
• Converted existing high level reports in to Active Reports.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Extensively worked on Analysis Studio to develop multi-dimensional reporting.
• Coordinate/assist /develop Cognos framework manager model adjustments to accommodate new and existing business requirements.
• Scheduled and distributed reports using Schedule Management in Cognos Connection.
• Trained end users on reporting tool to build and customize their BI and BIA reports.
• Fine-tuned the performance of the reports by creating appropriate indexes and using performance parameters
• Created client documents like Technical Design Document, Unit Test Execution Plan, Test Case Evidence and Explain Plan for developed reports

Environment: Cognos 10.1(Cognos Connection, Framework Manger, Report Studio, Analysis Studio, Business Insight, Business Insight Advanced, Active Reports), CognosGo Office, Teradata, Java Scripts (HTML).

Confidential, OH

Cognos Consultant

Responsibilities:

• Requirement analysisand created the Framework manger model.
• Designed the logical model that conforms to star schema concepts, different views (import, business, and external) as per Business requirement.
• Created views as per the business and reporting requirement.Creating the Determinants for the Views.
• Implemented Framework manager security for Data access, Object level access and Package access.
• Developed the List Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Import Views to the Framework manager model and set the cardinality between them as per the business requirements.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Created Business layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio, Burst Reports against database.
• Adding business rules by defining different kinds of calculations and filter.
• Creating prompts with query macros by including references to parameter maps.
• Worked with different date functions in Report Studio.
• Created the multidimensional model using the framework manager IQD’s.
• Performance tuning byanalysing and comparing the turnaround times between SQL and Cognos.
• Deployed reports and package from Development to testing, Testing to Production environments.
• Developed a logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement
• Used HTML/Java Script in Cognos report studio reports as per the requirements.
• Dynamic sorting the List report Columns based on the requirements.
• Displayed the Default date to yesterday date in date prompt using the Java Script.
• Created new page in the Cognos connection and embedded the different reports in the same page.
• Applied the security to display data based on the user security.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Worked along with other administrators while migration from Cognos 8.4.1 toCognos 10.1.
• Created Client documents like Technical Design Document, Unit Test Execution Plan, Test Case Evidence and Explain Plan for developed reports

Environment: Cognos 10.1/8.4.1 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio, Metric Designer, Metric Studio Event Studio), Power Play Transformer, Oracle 11g,Java Scripts (HTML)

Confidential, Columbus, OH

Cognos Consultant

Responsibilities:

• Developed clear query paths by resolving ambiguous relationships (loops, reflexive and recursive).
• Created the DMR (dimensional model) using the Frame Work Manager.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Updated SQL scripts as per thebusiness requirements.
• Designed Meta Data Model’s - Packages in Framework Manager.
• Administer Security in Reports based on the user role (Executive, Team Leads and Manager).
• Java Script for complex validation, navigation, communication and format customization.
• Performance Tuning and load balancing of complex reports.
• Export and Import of Packages / Reports for Auto / Manual Deployment to UNIX Box (Dev, QA and PROD).
• Followed the proper coding standards while creating the reports.
• CreatedOLAPTransformer Cubes from IQD’s /Cognos Connection Package.
• Customized user class security views in Cube by user classes / Roles.
• Batch script automation for Power Cube refresh.
• Reporting Power Play cubes in Analysis Studio and Conditional formatting of Cube Reports in Report Studio
• Executed test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Developedthe reports using analysis studio.

Environment: Cognos 8.1 BI Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Manager, Metric Studio, Cognos Power play Transformer), Cognos Access Manger, Windows 2003 Server, Oracle 10g,Teradata, Unix Aix server, Tomcat/Apache, Cognos 8.2 suite .