PROFESSIONAL SUMMARY:

• 7+ Years of experience in IBM Cognos TM1 as Senior Developer, by successfully delivering Business Performance and Process Management Solutions within a fast - paced, intellectually challenging & analytical environment with extensive experience in IT industry as Cognos Developer/ TM1 Developer/ Admin. Have experience working in Banking, Health Care, Finance and Retail Industries.
• Understanding requirements and processes and architect solutions and system design through effectively communicating with senior management.
• Extensive experience in carrying out all phases of SDLC including Requirement Gathering/Analysis, Planning, Design, Development, Testing and Implementation of complex Planning, Budgeting, Forecasting applications.
• Developing ETL processes in Turbo integrator using a modular approach, importing from various data sources including, cubes and SQL tables and creating cubes, dimensions, load actual data, calculating percentages and moving data from cube to cube(ODBO) and back to Relational Database(ODBC).
• Hands on experience with TM1 Environment, architecture and the application tools includes WEB, CAFÉ, Perspectives, Cognos Planning, Performance modeler. Hands on experience in production support and maintenance of reports.
• Worked with Business Users and end users in understanding, and preparing functional, technical requirements and designed documents. Experience in understanding and working with On-site Off-shore environment. Provided end user training and support.
• Excellent problem solving ability coupled with good communication skills to interact with end-users, customers, and team members. Responsible for handling end to end Cognos TM1 applications, design, maintenance and security maintenance.
• Hands on experience on modifying the existing processes for improvements and to increase efficiency and accuracy in reporting and data analysis.
• Proficient in writing complex business rules, optimizing it via appropriate feeders as well as effectively writing conditional feeders for better performance by reviewing against set benchmarks.
• Experience in creating financial reports based out of Cognos 8 and 10 and tableau.
• Migration from IBM Cognos TM1 Perspectives interfaces to PAX (Planning Analytics for Excel)

TECHNICAL SKILLS:

BI Tools: Cognos 11 Analytics, Cognos 8.x/10.x Framework Manager, Query Studio, Analysis Studio, Report Studio, Transformers, Workspace, Tableau, QlikView

FPM Tools: TM1 perspective, TM1 Architect, Performance Modeler, T1 Caf, Turbo integrator, Cube Viewer, TM1 Rules editor, TM1 Web reports, TM1 Application Web - TM1 Versions (9.0/9.4/9.5/ 10.1/10.2 ) Cognos Planning - 8, Hyperion Essbase - 7, Planning Analytics

Database System: Oracle 10g/9i/8i, SQL 2005/7, Access

Analytics Tools: SPSS, Tableau

Programming Languages: SQL, PLSQL, MDX, VB, C

Web Servers: Microsoft Internet Information server (IIS) 4.0, Sun one 5.2

PROFESSIONAL EXPERIENCE:

Confidential - Seattle, Washington

TM1 Architect Developer/Report Developer/ Admin

Responsibilities:

• Built and delivered successful technical solutions that involve all TM1 components e.g. cubes, dimensions, TI processes, rules, securities, workflows, applications, web deployments, etc.
• Executed the completion of the TM1 architecture and support TM1 models through all stages of the project life cycle.
• Integrated third part source data into TM1 solution and automated the exchange of data with other internal systems
• Fine-tuned TM1 the model to maximize the application performance and hardware utilization.
• Expert in writing TM1 rules with feeders
• Hands on experience in creating dynamic subsets using MDX in dimension editor and in turbo integrator scripting.
• Implemented security at application level, Cube level, Dimension level, Element level and Data level.
• Experience in scheduling the turbo integrator process using chores
• Responsible for daily financial data validation to ensure accurate and current data.
• Provided production support as well as troubleshoot any incident.
• Authors advanced reports in Cognos and Troubleshoot capabilities in Cognos reporting tier.
• Experience in building complex dashboards with rich visualizations and complex data sets.
• Understood the Adaptive Planning system and functionality and conducted JAD sessions for gathering requirements from old planning system users (adaptive planning system users) and also gathered new requirements to translate into TM1 structures and applications user interface
• Designed and stabilized the current TM1 system at IMC with TM1 web interface
• Streamlined the workflow of the monthly open and close process by automation
• Working on the TM1 application user interface for field users
• Worked on upgrading TM1 from 10.1 to 10.2 Version including fix pack and backup and recovery plans
• Designing the prototypes models for the existing models changes
• Redeveloping / Re formatting the TM1 objects via code and rules for better performance
• Identify all project dependencies and risks, ensuring they are effectively managed, and ensure
• Mitigation/contingency plans are in place.
• Developing Project Plans and miscellaneous knowledge base documents
• Prepare the weekly Status Report and facilitate Status Meeting
• Maintaining and administering TM1 application by following complete SDLC.
• Working with the FP&A team for enhancing the existing applications and also helping with the Quarterly PNL and reporting the same
• Stream lined and automated the data flow for the downstream system for dash boarding in Cognos
• Enhancing the TI code and rules for better performance and working on enhancements
• Managing a team of TM1 developers
• End User training (by setting boot camps) during the start of the cycle.

Environment: - Cognos TM1 (10.2/ 10.3), Turbo Integrator, TM1 Architect, TM1 Perspective, TM1 Performance modeler, Application Web, Oracle 10g, ASCII files, Oracle, Adaptive Planning, Tableau, MS excel Cognos (8.4/10), SQL

Confidential - Sacramento, California.

Cognos TM1 Developer/ Cognos BI Developer

Responsibilities:

• Maintaining and administering TM1 application on eight different Production servers by streamlining the daily process by performing automations.
• Monitoring huge applications data sets with the help of operations console.
• Supporting and maintaining TM1 SOX and Non SOX applications by creating the audit reports.
• Working with the FP&A team for enhancing the existing applications and also helping with the Quarterly PNL and reporting the same.
• Enhancing the TI code and rules for better performance and working on enhancements.
• Administering and maintaining the existing TM1 Security.
• Maintaining and updating the handbooks with different scenarios and following the Confidential process of maintenance.
• Managed onsite and offshore team.
• Following complete SDLC process plus maintaining Confidential standards for all 3 environments.
• Upgraded the TM1 applications from version 9.0 to 10.1.1.
• Worked with IBM teams for PMR creations and also followed up also mimicked the scenarios with Confidential cubes.
• Worked on fix pack patch updates for existing environments.
• Provide end user training and also create change (analysis, technical and user) documentation.

Environment: - Cognos TM1 (10.1.1/10.2 ), Turbo Integrator, TM1 Architect, TM1 Perspective, TM1 Performance modeler, Application Web, Oracle 10g, Siebel Database, ASCII files, Oracle, Adaptive Planning, Tableau, SPSS Teradata, MS excel, Cognos Analytics (11.3)

Confidential - Jacksonville, FL

Cognos Developer/ Architect /Report Developer

Responsibilities:

• Involved in meetings with the users which included discussing and gathering the business requirements,
• Used different functionalities like Cascading Prompts, Optional prompts, Conditional Formatting, Conditional Variables, Render Variables, Page Break, Page Sectioning, drill through, Drill Down, Drill up, Bookmarks and Conditional Blocking.
• Development using Planning Analytics.
• Migration and converting IBM Cognos TM1 Perspectives interfaces to PAX (Planning Analytics for Excel)
• Business analytics professional experienced in building Cognos TM1, analysis, reporting and dashboards applications within global, cross-functional agile teams with on-shore and offshore clients.
• Participated in the requirements process to help elucidate business and technical requirements for various financial applications.
• Utilized Complex SQL queries to pull data from multiple sources to meet defined requirements.
• Created, enhanced and implemented Turbo integrator processes and Cognos TM 1 solutions to automate.
• Developed and scheduled chores and processes to load, process and retrieved data from database tables and other data sources to feed Cognos TM 1 applications and other downstream applications.
• Published Cognos objects to be utilized to build reports within framework manager.
• Created web forms and reports to enable managers to make effective, real time resource and financial decisions.
• Automated deployment processes between environments to reduce cost, eliminate human error and to simplify processes.
• Enhanced, optimized and streamlined current financial models in production.
• Created user groups and roles to manage security and access rights of objects and reports to end users.

Environment: - Cognos TM1 (9.0/10.01), Turbo Integrator, TM1 Architect, TM1 Perspective, Oracle 10g, ASCII files, SQL, SSIS, SSRS, Cognos (10.01/10.2.2 ), Planning Analytics

Confidential - Portland, OR

Cognos Developer/ TM1 Developer

Responsibilities:

• Installed and configured Cognos 10.1 in distributed environment.
• Used IIS for configuring web server and set up security using Active Directory.
• Provided access to users to respective groups and roles.
• Monitored servers, schedules and set up Audit database for Cognos Audits.
• Analyzed business requirements and prepared functional specifications/system technical design documentation.
• Designed Framework Manager Projects, Model & Packages by importing the Metadata from various Data Source tables, Views, Data Marts and Macros.
• Defined cardinalities between the data objects for ad-hoc query users and power users.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.
• 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.
• Provided technical guidance and solution to junior developers in the team
• Managed data load, batch monitoring, cube refresh schedule and production support activities
• Planned and conducted user training sessions for super level user. Trained users on TM1 Perspective, Cognos Query Studio and Event studio.
• Understood the design of the Financial Planning cube.
• Suggested changes to the Hierarchical changes for reporting requirement.
• Satisfied the prototype reporting requirement for 3 different departments.
• Created templates in excel and Cognos BI for prototype model.
• Created a financial reporting TM1 cube with minimal changes to the existing structure.
• Developed reconciliation strategy for the prototype.
• Managed onsite and offshore team.
• Created the Document for reporting

Environment: - Cognos TM1 (9.5.1), Turbo Integrator, TM1 Architect, TM1 Perspective, Oracle 10g, ASCII files, Cognos Transformer cubes, Cognos BI 10.1.0/10.2.2, Report Studio, Query Studio, MS Excel, Tableau

Confidential, Redwood City, CA

BI Consultant

Responsibilities:

• Understanding the multidimensionality of the data for designing DMR models in Cognos impromptu as well as for designing dimensions and cubes in Cognos TM1 by analyzing and identifying different data sources
• Gathered the requirements for regular analysis and for Financial Performances during the JAD sessions
• Created a prototype model for the users.
• Created DMR models in Framework Manager and analyzed the same in Query studio.
• Worked and supported existing reporting structure.
• Created dimensions and cubes using Turbo integrator process using ASCII Flat files and loaded the data by TI process.
• Published DMR models and cubes to Cognos Portal.
• Used best practices in Cognos TM1 for creating dimensions, cubes in TI process (ordering, indexing, loading the data in cubes, also includes naming convention) and rule statements.
• Worked on the scenario modeling (what if analysis) for Confidential
• Involved in Replication of cubes between servers and synchronized the cubes on demand.
• Created process chores in TM1 Turbo Integrator.
• Strongly analyzed and created different budgeting scenarios by using combinations of different subsets and using data spreading technique.
• Improved the performance of the cubes and DMR models.
• Controlled the cubes and dimensions in TM1.
• Browsed the data after creating the cubes in cube viewer and In-spreadsheet browser.
• Sliced and diced the views in cube viewer (using zero suppression method).
• Created static subsets (by narrow down list method).
• Worked with the database team for cleaning the data by regular fishing routine
• Supported the Metrics after it was open enterprise wide
• Created Ad hoc reports in query studio for top level management
• Prepared documentation to train end users regarding the functionality of TM1

Environment: - Cognos impromptu (Frame work Manager), Query Studio, Cognos TM1 (9.4), Turbo integrator, TM1 Architect, TM1 Perspective, Oracle 10g, Metadata Manager, ASCII files.