SUMMARY

• Strong 8 years experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications which includes (ETL,OLTP & OLAP) environment.
• Experience on Cognos TM1, Cognos Insight, Cognos Enterprise Planning, Architect, Perspectives, Turbo Integrator and Performance Modeler.
• Administered TM1 Access and EP Access Manager to implement Security among Cognos applications and working knowledge of Cognos Multi - Server Administration.
• Experience in Cognos TM1 10.2 (Architect, Perspective, Turbo Integrator, Performance Modeler, Web, CAFE), COGNOS 10.x Suite (Framework Manger, COGNOS Connection, Report Studio, Query Studio, Business Insight, Business Insight Advanced, Analysis Studio and Event Studio).
• Involved in the process analysis, catalog design and performance optimization of TM1 and EP reports
• Provided Cognos Planning model design, data model and workflow.
• Experience in ROLAP & MOLAP( Dimensional Modeling), Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements. Expertise in Data Flow Diagrams, Process Models, and ER diagrams with modeling tools like ERWIN & VISIO.
• Experience in designing and developing mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.
• Expertise in designing and developing models using Framework Manager.
• Expertise in developing Multidimensional OLAPCubes using PowerPlay Transformer, and Reports using Power Play for Windows.
• Creating the Complex Report studio reports using the different MDX expressions using the Cubes as the source data.
• Experience in creating and translating information from various corporate systems and data into, visually rich Dashboards using maps, charts, cross tabs and lists and other graphical elements. Experience in converting reports from Crystal Reports 14.1 to QlikView 11.2
• Developed dashboards in Workspace, QlikView, Qlik Sense & Tableau.
• Proficient in Performance Optimization of reports and Multidimensional Cubes. Experience in converting reports from Cognos EP 7.3, 8.4 to Cognos TM1 10.2.2
• Experience in Installation and Configuration of Cognos TM1 & Cognos BI suites in Stand-alone and Distributed Environment & configuring Admin & Application Servers.
• Extensive experience with database languages such as SQL, MDX and PL/SQL which includes writing triggers, Stored Procedures, Functions, Views and Cursors.
• Experience in writing and executing different Test scenarios (Unit, System & Integration and UAT).
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Excellent team player and self-starter with good ability to work independently; proficient at developing & implementing User Training programs and possess good analytical, problem solving and logical skills with ability to meet deadlines, multi-tasking and flexible in work schedules.

TECHNICAL SKILLS

BI Tools: CognosTM1(Architect,Perspectives,Performance Modeler,CAFE,Web,TurboIntegrator),CognosEnterprise Planning,Cognos10.x,Cognos8.x,ReportStudio,QueryStudio,Analysis Studio,MetricStudio,FrameworkManager,EventStudio,CubeDesigner,Workspace,CognosSDK,CognosSeries7 Upfront,PowerPlayTransformer,ImpromptuWebeports,Power Play Enterprise Server, Impromptu Administrator. Informatica 9.x,8.x,IBM Infosphere DataStage11.5, SSIS, Tableau Desktop 8.3, … QlikView11.2, Qlik Sense3.0, DundasBI.

Methodologies: Star, Snowflake Schema.

Databases: Oracle … SQL Server … Stored procedures, Triggers, DML, DDL, DTS), DB2, Sybase 11.5, Informix (XPS, 7.x/8.x), MS-Access, XML, JDE

OS Windows: 2000,NT, XP, 7, Server 2000, 2003, 2008, 2012, Sun Solaris 7/8, IBM AIX, UNIX, RedHat, Ubuntu, Mandriva, Fedora, Open SUSE.

Programming Skills: SQL, PL/SQL, MDX, JAVA, (Eclipse IDE and Net Beans IDE), HTML, C++, Python, XML, Java Script, VB script, Shell Scripting (K-Shell, C-Shell).

DB Tools: SQL*PLUS, SQL*LOADER, SQL*NET, Quest TOAD, SQL Server Management Studio, Oracle Enterprise Manager, Oracle WSGL/Web Tool kit.

DM Tools: Erwin, Visio

Web Servers: IIS, Apache Web Server

PROFESSIONAL EXPERIENCE

BI Developer

Confidential, Las Vegas, NV

Responsibilities:

• Leading the Forecast, Budget and Month end close cycles related to IBM Cognos planning TM1 and reporting.
• Training users on how to use Cognos TM1 Perspectives add-in for Microsoft Excel
• Involved in Upgrade process of Cognos Enterprise Planning to Cognos TM1 10.2.2
• Leading Production support according to the Forecast, Budget and month end close cycles.
• Consolidating data between the models and providing it to downstream systems like FGEN and BI Reporting.
• Generating Power Play reports and Loading actuals using FGEN reports.
• Improved the e-planning environment by suggesting best practices like reducing the Application size, reduce hard coding and fine tuning the Planning Process.
• Worked on TM1 Architect for maintenance of TM1 users, roles, groups and security.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Created Web Forms Using Infopath and Published using Enterprise Services Manager. Scheduled Chores and Monitored Data Loads on timely manner.
• Worked on TM1 Architect & created TI Processess and Rules to transfer data. Used TM1 rules editor to create and edit rule to create various calculations.
• Converted Crystal Reports 14.1 to QlikView 11.2
• Installed, Configured and Maintained Cognos 10.2.2 across multiple environments. Integrated Cognos TM1 10.2.2 with Cognos BI 10.2.2 and published packages in Framework Manager.
• Installed and Configured IBM TM1 10.2.2 suite IBM TM1 Admin Server, IBM TM1 Web, IBM TM1 Application Web, IBM TM1 Architect/Perspectives and IBM TM1 Performance Modeler
• Integrated IBM TM1 10.2.2 environment with BI CAM security.

Environment: CognosEP Series 8.4.1, Cognos Planning 10.2.2, TM1 10.2.2, Cognos TM1 Performance Modeler, Cognos TM1 Architect, Cognos TM1 Perspectives Cognos Insight, Cognos 10.2.2-Framework Manager, Transformer, Cube Designer, Report Studio, Query Studio, Analysis Studio, Metric Studio, Map Manager, Cognos Configuration, SDK, Cognos API, IBM Infosphere DataStage 11.5, QlikView 11.2, XML, HTML, MDX, SQL Server 2012R2, SQL Server Management Studio, Javascript, Visio.

Cognos-BI/Cognos TM1 Lead Developer

Confidential, Reno, NV

Responsibilities:

• Understand existing OLTP data structure and writing Technical design documents.
• Successfully upgraded TM1 9.5.2 to TM1 10.2.2 on development and production servers, including testing and validation of all TM1 models.
• Created Temporary Views, Subsets, and populated Actuals data using TurboIntegrator.
• Worked on Cognos 10.2.2 Active reports and created dashboards in Workspace.
• Enhance the existing TM1 OLAP Cubes and Dimensions in TM1 Architect.
• Worked on developing TM1 Chores, complex Rules & Feeders and TI processes
• Designed metadata models in Framework Manager & published packages in Cognos Connection.
• Worked on ROLAP & MOLAP Cubes & created reports in Report Studio and Analysis Studio with multiple queries and drill through capabilities.
• Experience in converting Actuate BIRT reports to Cognos 10.2.2
• Trained Users on TM1 Web and TM1 CAFE to publish reports based on TM1 OLAP Cubes.
• Performance fine-tuning-Leveraging TM1 10.2.2 Multithreading Query Mode to improve performance.
• Developed Dashboards & Scorecards in Qlik Sense, QlikView and Dundas BI.
• Worked on TM1 Architect for maintenance of TM1 users, roles, groups and security.
• Developed Dashboard in Cognos Workspace and QlikView.
• Cognos Administration activities including Server configuration, Security, Upgrades, Patch Installations, Implementation of Change Requests.

Environment: Cognos TM1 Architect, Perspectives, Turbo Integrator, Performance Modeler, TM1 Web, TM1 CAFE(10.2.2, 9.5.2), Cognos 10.2.2- Cube Designer, Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, QlikView 11.2, Qlik Sense 3.0, Actuate BIRT 11.0, HTML, MDX, SQL Server 2008, PL/SQL, SQL Server Management Studio, DB2, AS/400, TOAD, Javascript, MS Visio.

Sr. Cognos/TM1 Developer

Confidential, Las Vegas, NV

Responsibilities:

• Understanding existing OLTP & OLAP models and writing requirements(BRDs).
• Created the Entity Relationship Diagram implementing Star schema using VISIO
• Developed various mappings and Stored Procedure transformations using PL/SQL Framework.
• Re-designed existing models & developed new dimensional models in Cognos 10.2.1BI and published packages using Framework Manager (FM).
• Developed TM1 Input Sheets/ Reports in TM1 Perspectives.
• Prepared Budget Rollovers & Input Sheets/Reports.
• Using TM1 Architect, created dimensions with Unbalanced Hierarchy.
• Scheduled TM1 Chores and Monitored Data Loads on timely manner.
• In TM1 Architect Created Rules to transfer data between cubes.
• Worked on Skipcheck and Feeders to ensure performance issues.
• Designed and Implemented user-friendly TM1Web Websheets for data capturing and metadata management.
• Involved in generating reports using published data and data exported from Analyst cubes.
• Involved in Creating Data prep & Creating Macros for loading data into Contributor using Analyst 7.3
• Involved in building applications, setting applications, configuring application settings, publish settings, running GTP and Synch using Contributor Admin Console.
• Scheduled the reports using triggers in CAWA (Computer Associates Workload Administration).
• Converted reports from Cognos 10.2 to Tableau 8.3 & developed Dashboards in Tableau 8.3
• Created prompts with query macros by including references to Parameter Maps.
• Implemented package level, object level and data level security in the reports.
• Fine tuned the reports, underlying queries and tables using indexes.
• Worked on Automation of Cognos services restart.
• Responsible for Performance tuning by analysing and comparing the turnaround times between SQL and Cognos.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Production support and prepared documentation for reports developed with End user training
• Involved in conversion of reports from Cognos 10.2 to Tableau 8.3

Environment: Cognos 10.2.1-Framework Manager, Cube Designer, Cognos Enterprise Planning series 7.3, Analyst, Contributor Admin Console 7.3, Cognos TM1 10.1(Architect, Perspectives and Turbo Integrator, Web), EXCEL ADDIN, Report Studio, Query Studio, Analysis Studio, Metric Studio, SDK, CognosAPI, Tableau 8.3 Desktop, Tableau 8.3 Server, CAWA, Maximo 7.5.0, PL/SQL, XML, HTML, MDX, Oracle11g, SQL Developer, SQL Plus, Javascript, Visio.

Sr. Cognos/TM1 Developer

Confidential, Las Vegas, NV

Responsibilities:

• Coordinate with Business users to understand, gather and document Business
• Requirements and translate the OLTP systems and assist in creating MOLAP models.
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN
• Analysis of the General Ledger String to create TM1 Dimensions.
• Worked on TM1 Architect for Creation/ Modification of TM1 Cubes and Dimensions.
• Maintaining and updating the Hierarchies within TM1 as changes occur in Oracle Legacy system to ensure accurate Reporting.
• Writing TM1, Turbo Integrator (TI) process to copy 'ACTUAL' data from Oracle legacy system to TM1 system with ODBC as datasource.
• Writing TM1, TI process to write back planning data into Oracle Legacy system.
• Writing TI process to Load data into different Revenue and Expense Cube with .CSV file as datasource.
• Converted Cognos EP 7.3 to Cognos TM1 10.1
• Involved in creating System links and Admin Links.
• Installing Analyst on client machines, solving client side issues like opening contributor datagrid, Excel Import & Excel Print
• Installing and Configuring of Cognos TM1( Architect, Perspectives, Turbo Integrator, Web, Performance Modeler) & configuring Admin & Application Servers.
• Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions and Workflows.
• Created Logical and Physical Models in Cognos 10.2 Framework manager with a 4-Layer approach (Physical, Business, Presentation, Dimension) using Oracle 11g.
• Enhance the existing metadata models with the desired changes in 10.2 Framework Manager and publish packages.
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Worked on Cognos 10.2 Active reports and developed Dashboards in Workspace.
• Developed List, Cross tab, Drill through, Master-detail, Chart & Conditional formatting reports which involved multiple prompts in Report Studio & Burst them to General Managers.
• Created scorecards using Metric studio which included risk scorecards, profitability scorecards.
• Created reports containing multiple data containers like List, Cross-tab, Graphs and Repeater tables.
• Experience with Parameter Maps and Session parameters in creation of multi-lingual reports
• Trained Business users to make their own ad-hoc reports using Cognos 10.2 Query Studio.

Environment: Cognos 10.2-Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Metric Studio, IBM Cognos Enterprise Planning Series version 7.3 & 8.3, Cognos TM1 10.1(Architect, Perspectives and Turbo Integrator, Web), SDK, Cognos API, Workspace, Informatica Power Center 9.0, XML, HTML, MDX, Oracle11g, SQL Server 2008, SQL Server Management Studio, JavaScript, Erwin.

Sr. Cognos Developer

Confidential, Las Vegas, NV

Responsibilities:

• Understanding existing business model and user requirements.
• Created the Entity Relationship Diagram implementing Star schema using VISIO
• Developed various mappings using Mapping Designer and worked with Aggregator,
• Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression,
• Stored Procedure, Sorter and Sequence Generator transformations.
• Created and Configured Workflows and Sessions to transport the data to target
• Warehouse tables using Informatica Workflow Manager
• Re-designed Impromptu catalog & developed the model in Cognos 10 BI and published packages using Framework Manager (FM).
• Involved in migrating the Impromptu reports to Cognos 10.2 BI.
• Worked on Framework Manager to solve ambiguous relationships (loops, reflexive and recursive) in metadata models and published packages.
• Created and adopted multi layered approach to avoid data complexity for end users in FM.
• Developed the List Reports, Cross Tabs, Charts, Drill Through Reports, Master Detail Reports using Report Studio and Query Studio.
• Developed the Report Studio reports using the Dynamic Cube as a data source.
• Developed the Dashboard reports using Cognos Report Studio and Metric Studio.
• Created prompts with query macros by including references to Parameter Maps.
• Involved in upgrading Cognos 8.2 BI reports to Cognos 10.2 BI and deployment.
• Implemented package level, object level and data level security in the reports.
• Fine tuned the reports, underlying queries and tables using indexes.
• Worked on Data Analysis, Validate reports and troubleshoot the errors.
• Responsible for Performance tuning by analysing and comparing the turnaround times between SQL and Cognos.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Involved in fixing invalid Mappings, testing of Informatica Sessions, and the Target Data
• Deployed the Ad-hoc Model Reports from Dev. to Val. and to Prod. Environments.
• Prepared Weekly Status Reports (PMO) and shared with the Managers.
• Production support and prepared documentation for reports developed.

Environment: Cognos 10.2-Framework Manager, Transformer, Cube Designer, Report Studio, Query Studio, Analysis Studio, Metric Studio, Impromptu 6.0 Admin, Map Manager, Cognos Configuration, SDK, Cognos API, Informatica Power Center 8.5, Power Exchange 8.1 XML, HTML, MDX, Oracle11g, Oracle 8i, JDE, SQL Developer, SQL Plus, Javascript, Visio.

Sr. Cognos Developer

Confidential, Reno, NV

Responsibilities:

• Created Star schema, dimensional models, Data Level Security in the Framework Manager Metadata model.
• Interact with Business Users in multiple locations to finalize or clarify Requirements and assist in creating the Dimensional data models.
• Worked on Cognos 10.1 Active reports and created dashboards in Business Insight.
• Enhance the existing metadata models with the required changes in Framework Manager and published them to the Cognos connection.
• Created Requirements and Technical design documents. Attend the project meetings, Reviews and Walk-throughs for requirements, design and test plans.
• Created reports in Report Studio and Analysis Studio with multiple queries and drill through capabilities.
• Created reports in Cognos 10.1 using Native SQL.
• Customization of prompt and report pages functionality using JavaScript.
• Worked with Database Administrators, Security Teams, and IT Infrastructure teams to resolve technical issues and coordinate changes that impact user communities.
• Cognos Administration activities including Server configuration, Security, Upgrades, Patch Installations, Implementation of Change Requests.
• Coordinate with IBM on Issues, Upgrades and Installations.
• Process Improvements and Research on optimizing the Cognos Functionalities from the Application perspective.

Environment: Cognos 10.1-Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Map Manager, Cognos Configuration, HTML, MDX, Oracle10g, PL/SQL, SQL Developer, SQL Plus, TOAD, Javascript, Visio, Windows Server 2003, LDAP.

Sr. Cognos Developer

Confidential, LasVegas, NV

Responsibilities:

• Interacted with the Business to draft Business Requirements which includes sources, granularity of data, fields in the tables, and business rules.
• Created various Report Technical Specification (RTS) documents to define detailed user requirements.
• Defined various Functional Specification document to outline various reporting standards, Business rules and Data Mapping.
• Worked with the BI team to develop a versatile Framework Manager Model using the MDDW data warehouse data model in Oracle 8i Database which follows the Functional Specifications document.
• Created Business Views, Namespaces, Model query subjects in Framework Manager for easier report development and to enhance multi-user environment.
• Implemented model level security leveraging the same security levels as implemented at the back end Sales application.
• Built Multidimensional Cubes using PowerPlay Transformer and published them to Cognos connection using Framework Manager.
• We were able to complete around 200 reports successfully before the deadlines.
• Ensured that developed reports meet specifications, run efficiently and are error free through
• Data validation and performance testing.
• Developed various reports using Pass-Through SQL as required to improve performance.
• Actively involved in Data Warehouse design.
• Involved in administration of Cognos 8 BI environments.
• Involved in deployment (import /export) of reports and packages in different environments.
• Used SQL in TOAD for Oracle to test and validate data in reports.
• Conducted various training sessions on basic/advanced report authoring to familiarize end users to the new reporting environment.
• Created various user guides, report technical specifications as required.

Environment: Cognos 8.x BI Suite (Cognos Connection, Framework Manger, Query StudioReport Studio, Cognos SDK), MDX, Oracle 9i, Windows Server 2003, Datastage 7.0.

Cognos Developer

Confidential, NV

Responsibilities:

• Very Strong in Interacting with the Business Users and Supervisors to get a better understanding of Client Business Processes and gather Business Requirements and converting them into Business Requirement Documents, Use Case Document, test methodology, designing test plan, preparing documentation, standardizing procedures.
• Extensively worked with Business users and the Board of Directors to understand their needs and generated various reports using Impromptu, Power Play, and Report studio.
• Worked with the data center closely for various automation processes and managed distribution lists.
• Published OLAP Cubes and Reports on the Cognos Sever Administration Portal.
• Installed Cognos 8.3 on a test server for migrating the cubes from 7.1/7.3
• Analyzed the Business needs and proposed models to consolidate the framework projects.
• Designed Framework models to explain the capability of Cognos 8 and the advanced features such as Dashboards/ Scorecards.
• Trained Business users to use Query Studio and Cognos Connection using Cognos 8.3
• Worked on Cognos Security Administration to restrict the Users.
• Created UAT plan documents for the managed reports.
• Created and Managed Catalog's in Impromptu Administrator by adding tables and creating new joins, and created distributed catalogs when required.
• Tested and validated reports based on source system data.
• Provided training to end users on Cognos Impromptu, and Power play
• Worked on migrating the reports from the Legacy systems (Mainframe) to Cognos.
• Used Macros for automation of reports.
• Created portfolio's for various Retail & Wholesale divisions
• Represented the Cognos Team at the Cognos User Group Meetings of Middle Tennessee.

Environment: Cognos 8.3, Cognos ReportNet, Cognos Impromptu 7.1/7.4, Impromptu Web Reports 7.1(IWR), Cognos Power Play 7.1/7.3, Cognos Power Play Transformer 7.3, Cognos Upfront 7.1, Portfolio, Access Manager 7.1, Configuration Manager 7.1, SQL Server, SQL Tools, Toad, Oracle, MS-Excel, Windows NT, Citrix Client tools.

Cognos Developer

Confidential, Las Vegas, NV

Responsibilities:

• Interacted with business users for requirement gathering.
• Modeled metadata with Framework Manager to provide efficient Model and packages for Sales and Finance departments.
• Customized metadata to dynamically control the data returned, using Session Parameters, Parameter Maps, and Macros.
• Implemented security using Views.
• Involved in administration of Cognos 8 BI environment.
• Developed reports envisioning those created in Access.
• Developed reports using dynamic Pass-Through SQL when required.
• Involved in importing and exporting of data between all three environments.
• We were able to complete around 50 reports successfully before the deadlines.
• Conducted user training to familiarize end users to the new reporting environment

Environment: Cognos 8.2 BI Suite (Cognos Connection, Framework Manger, Query Studio, Report