SEARCH

Cognos TM1 Developer/Data Analyst Resume Example

Resume Score: 100%

Love this resume?Build Your Own Now
COGNOS TM1 DEVELOPER/DATA ANALYST
Summary

Meticulous Software Engineer bringing over 6 years experience in the financial industry. In-depth understanding of business intelligence technologies and tools with a focus on delivering innovative business solutions.

Skill Highlights

Buisiness intelligence: Cognos 10.2, Framework manager, Query Studio, Report studio, TM1 10.2, (Architect, Perspectives, Turobointegrator), OBIEE10.1.3.3.1 to 11.1.1.6

Languages: SQL, PL/SQL, HTML, C, XML

Databases: Oracle 11g, Microsoft SQL SERVER 2000, 2005,

OS: Windows 95/98/2000/XP, 2008

Other Tools: TOAD, SQL Developer

Core Accomplishments

Developed and supported forecasting and budgeting applications that eliminated manual tasks and facilitated better integration among users globally.

Experience
Cognos TM1 Developer/Data Analyst
November 2013 to CurrentCompany Name － City, State
  • Over 6 years of IT experience, 4 years of Financial Planning Solutions from requirements through design and testing, implementation and production support.
  • Experience working within SDLC framework like Waterfall and Agile.
  • Analyze existing business processes and explore system automation.
  • Design, develop, and implement Cognos TM1 10.2 Applications for Financial Planning and Budgeting models with complex rules.
  • Development of Turobointegrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
  • Utilizing Turobointegrator to integrate business logic to load data into various cubes.
  • Maintained TM1 users, roles, and security to manage data authentication and authorization.
  • Created dynamic subsets and views using Turobointegrator.
  • Created temporary Views, Subsets using Turbo Integrator and populated data for scheduled chores and Monitored Data Loads in a timely manner.
  • UseTM1 rules editor to create , edit and implement rules for complex business logic calculations.
  • Implemented powerful drill downs using MDX queries to allow for filtering and data analysis.
  • Proficient in creating complex Active Forms for reporting and enhancing the performance of existing Active forms.
  • Manage development environment, assign user permissions, creating user accounts, providing security access to users and groups.
  • Prepared Logical and Physical solutions documentation by gathering the content from the technical solution delivery teams and prepared UAT scripts to validate functionality against the business requirements.
Software Engineer
November 2013 to CurrentCompany Name － City, State
OBIEE Analyst/Developer
October 2009 to January 2013Company Name － City, State
  • Worked with internal clients, stakeholders, data architects, and database teams to develop and enhance an enterprise infrastructure solution that provides key end clients throughout the company with robust analytics and reporting.
  • Responsible for gathering requirements, designing, rolling out analytics and reporting solutions, and end user training of OBIEE functionality.
  • Gathered business requirements by interacting with the business users, defined subject areas for analytical data requirements.
  • Developed and customized metadata repositories (Physical layer, BMM layer, & Presentation layer) including creation of connection pools, setting alias tables, BMM, applying business logic, dimensional hierarch modeling, time series modeling, aggregation, creating logical column, and calculation wizards.
  • Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
  • Created dimension hierarchies, aggregates, and keys in the BMM layer to improve system performance.
  • Modified presentation layer to add presentation tables and columns to meet the business user needs.
  • Setup usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance using SQL.
  • Customized reporting with OBIEE answers and integrated them into the dashboards.
  • Designed and developed dynamic dashboards to enable end-users to evaluate company's performance.
  • Generated reports and created dashboards with global prompts, column selectors, navigation, and automatic drill-down using report features like pivot tables, charts and view selector.
  • Created user level security for intelligence dashboards based on Business Requirement.
  • Performed data validation of the reports and dashboards to ensure completeness and accuracy.
  • Prepared and documented Unit Testing (UT) and User Acceptance Testing (UAT) for all components in OBIEE and documented and reviewed test results with the business to confirm expected results.
  • Evaluated Oracle BI Enterprise Edition updates including new utilities such as BI Server, Answers, Delivers and Publisher.
  • Coordinated with QA testers for end-to-end unit testing and post-production testing.
  • Recommended and executed plans to improve development tools and processes.
Education
MBA : Project Management, 2016Southern New Hampshire University － City, State, USA

Project Management

Bachelor of Science : Business InformaticsNorthern Kentucky University － City, State, USA

Business Informatics

Certified Specialist in Cognos TM1 and Oracle Business Intelligence Foundation Suite 11g
Professional Affiliations

Member, African Professionals Network (APNET).

Member, NKU Veterans Association

Member, African American Forum

Skills

Agile, Architect, automation, Budgeting, BI, Business Intelligence, business processes, C, charts, Cognos, content, clients, data analysis, data validation, Databases, database, delivery, designing, dimensions, documentation, edit, editor, XML, features, Financial Planning, Forms, HTML, logic, access, Publisher, 2000, 3.1, Windows 95, 98, modeling, Enterprise, navigation, OS, optimization, Oracle, Developer, PL/SQL, pivot tables, Processes, reporting, Requirement, SDLC, scripts, Microsoft SQL SERVER, SQL, tables, user training, TOAD, utilities, view

Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Southern New Hampshire University
  • Northern Kentucky University

Job Titles Held:

  • Cognos TM1 Developer/Data Analyst
  • Software Engineer
  • OBIEE Analyst/Developer

Degrees

  • MBA : Project Management , 2016
    Bachelor of Science : Business Informatics
    Certified Specialist in Cognos TM1 and Oracle Business Intelligence Foundation Suite 11g

Similar Resumes

View All
TM1-Developer-resume-sample

TM1 Developer

Royal Oak, Michigan