Cognos TM1 Developer/Data Analyst Resume Example
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.
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 |
Developed and supported forecasting and budgeting applications that eliminated manual tasks and facilitated better integration among users globally.
November 2013 to Current2K － Petaluma , CA
- 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.
November 2013 to CurrentCognos GE Capital － City , STATE
October 2009 to January 2013Fifth Third Bank － 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.
Project Management
Business Informatics
Member, African Professionals Network (APNET).
Member, NKU Veterans Association
Member, African American Forum
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
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.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
- Completeness
- Formatting
- Word choice
- Measurable results
- Typos
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
