Sr. Cognos Bi Developer Resume
Pleasanton, CA
SUMMARY
- Over 7+ years of professional experience on Cognos Business Intelligence as a CognosDeveloper and Developer - Analyst wif key activities in all teh stages of teh project SDLC such as support, analysis, designing, testing, debugging and documenting Cognos BI solutions across multiple industries.
- Technical expertise in Data Warehousing (Relational, Dimensional Relational (DMR), &OLAP Cubes) modeling and development, schemas (Star & Snowflake), logical data marts & table structures (fact & dimension) using Data Modeling tools such as Cognos Transformer, Cube Designer and Framework Manager.
- Installed, configured and worked on Cognos BI suite, including Business Insight & Advanced, Report Studio, Analysis Studio, Workspace Advanced, Cube Designer and Framework Manager.
- Experience in understanding existing business processes, gathering business systems requirements analysis and design thereby converting into detailed reports for strategic decision making.
- Extensive experience working wif Cognos 8.x/10.x Business Intelligence Reporting Suite (Framework Manager, Analysis Studio, Report Studio, Event Studio, Query Studio and Transformer, Dynamic Cubes, Workspace, Workspace Advanced, Power Play Studio, Cognos mobile) Applications.
- Designed and implemented enterprise wide Reporting strategies utilizing Business Intelligence (BI), Data warehouse, Data Analysis, Data Modeling, Data Mining techniques.
- Implemented teh Enterprise level Cognos security and Server Administration using Cognos 10.x/8.x and administration of security using Access Manager, LDAP and Custom Authentication Provider.
- Developed simple and complex reports including list, crosstabs and charts wif drill-thru capabilities, Master Detail relationship, Bookmarks, Prompts, Macros, and Dashboards etc.
- Experience in Database coding using ETL tools, data mining techniques, installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008, MY SQL and Oracle 10 series databases
- Extensive experience using various data sources such as Oracle, DB2, SQL Server and Access.
- Excellent noledge on SDLC/Data Warehousing implementations using Star schema and Snow flake schema and developing reporting solutions from OLTP.
- Experienced in Migration of other reports into Cognos and version up-gradation in Cognos.
- Has worked on several requests from business towards building Report Studio reports, Query Optimization and Performance Tuning of reports.
- Ability to meet deadlines and handle multiple tasks, decisive wif strong leadership qualities, flexible in work schedules.
- Solid designing and development experience in developing various kind of reports like Cascading parameters, pick lists, Drill down, Drill through, Sub Reports and Charts.
- Responsible for Interacting wif users and department directors to identify information needs and business requirements.
- Experience wif teh Enterprise level Cognos administration and Framework Development support, which includes teh installation, configuration, administration and maintenance of a business-critical Cognos product set in a 24x7 production environment.
- Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas methodologies, dimensional data structures and complex hierarchies.
- Proficient in analyzing and translating business requirements to technical requirements and architecture.
- Proficient in maintaining Data Level, Object Level and Package Level Security.
- Extensive experience in writing SQL queries and Involved in Query Level Performance tuning.
- Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
- Excellent interpersonal and communication skills, technically competent and result-oriented wif strong problem solving skills.
- Excellent team player wif problem-solving and trouble-shooting capabilities and ability to adjust to people, circumstances, wif a Drive for results through self-motivation.
TECHNICAL SKILLS
Tools: Cognos 10.2.X, Cognos10.1.1, Cognos Mobile 10.1.1, Cognos Express, 8 Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio, Metrics Studio, Framework Manager), ReportNet 1.1 MR3/1.1 (Framework Manager, Report Studio, Query Studio), Cognos Impromptu 7.x/6.x, Impromptu Web Reports (IWR), PowerPlay Transformer 7.x/6.0, PowerPlay Enterprise Server, Modeling Tools Transformer & Framework Manger 1.1/8.x, Cognos10.
ETL Tools: Informatica
Languages: SQL, PLSQL, HTML, XML, Java script.
O/S: Windows 2000/2003/2008/2012 server.
RDBMS: TOAD, Oracle 11g/10g/9i/8.x, MS Access/Excel, DB2, MY SQL and SQL Server
PROFESSIONAL EXPERIENCE
Confidential, Pleasanton, CA
Sr. Cognos BI Developer
Responsibilities:
- Worked wif Business Users to get teh user requirement for creating multi-dimensional cubes and canned reports.
- Understood business logic underlying teh requirements, based on teh report mockups.
- Implemented report prototypes layouts before teh actual report implementation.
- Conducted constant review meetings wif Business End Users to ensure teh reports are meeting teh requirements et.
- Worked extensively wif teh ETL Team for creating teh MV’s and creating Views for teh report requirements.
- Did performance tuning on Dynamic cubes to reduce query time by capturing teh Queries from teh XQE-Logs
- By usingMDX Functions developedDash Board reportsinReport Studio.
- Involved in design phase, gathered requirements from users and documented/designed/developed report specifications including report documentation for creating reports using Report Studio.
- Developed Complex reports using Report Studio which includes various report types ranging from simple lists, crosstabs and chart through complex dashboards, drill-through, master-detail and conditional formatting.
- Involved in teh Unit Testing of teh reports and preparing teh Test cases.
- Raised tickets and interact wif different teams for migration of code (Teradata views, packages and reports) to different environments
- Created multipage reports involving prompts, cascading prompts, conditional rendering and conditional highlighting.
- Designed Dynamic Cubes - in memory tool using Cube Designer tool and deployed in teh Cognos 10 environment to increase teh performance which is using large data sets.
- Created POC for Active Reports (using data tabs, data decks etc.) and Dynamic Cubes in Cognos 10.2.2
- Updated Active Reports using Scheduled jobs.
- Analyzed existing solution containing cubes reports, materialized views and worked wif teh functional team to create technical documents.
- Installed, configured and administered various Cognos components such as teh Cognos BI server, Framework Manager and Cube Designer.
- Worked wif teh user for resolving teh issues on QC, to log and close teh defects dat are raised.
- Supported teh reports in Production environment and transferred noledge on maintaining/modifying reports in teh future to teh support team.
Environment: Cognos 10.2.2 (Transformer, Cube Designer, Report Studio, Workspace, Workspace Advanced, Analysis Studio, Cognos Connection, Framework manager, Cognos Administration), Oracle 11g, Windows 2003/7, Microsoft Excel.
Confidential, Houston, TX
Sr. Cognos BI Admin/ Developer
Responsibilities:
- Defined Kraton’s BI technology architecture including database and reporting suite technologies.
- Provide design and implementation architectural solutions for data warehouse and data marts database design, ETL/data loading strategy, and business intelligence reporting data, taking into account system requirements, security, system extensibility and interoperability, costs, operations and support considerations, and BI best practices.
- Develop and maintain BI architecture principles, best practices, patterns, guidelines, standards, methods, techniques, and models.
- Logical and physical data design modeling and implementation to meet business objectives and teh needs of BI architecture other program deliverables.
- Provide an end to end solution and work wif integration partner during design and implementation of teh data warehouse, BI tool integration, and associated sub systems.
- Developed Complex ETL code through Data manager to design BI related Cubes for data analysis at corporate level.
- Formulated ETL processes to Extract Data from Operations DB to teh Reporting DWH, Designed and developed Cognos EP models and Cubes.
- Worked on MDX functions over Report Studio on Multi-dimensional sources
- Work wif MDM Data Governance Lead to implement processes to maintain integrity and quality of teh data residing in teh data warehouse and data marts.
- Design and implement production processing architecture, including performance monitoring, scheduling, and notification in teh event of failures.
- Once deployed, responsible for day to day support of teh data warehouse and marts, ETL integration, and BI application.
- ManageCognos BI licenses for projectlife cycle and reviewed teh report design and documentation.
Environment: Cognos 10.2 and 10.2.2 BI versions, Report Studio10.2.2, Query Studio 10.2.2, Framework manager 10.2.2, Dynamic Cubes, IBM Cognos Business Insight, IBM Cognos Configuration, IBM Cognos Lifecycle Manager, Cognos 10.2 tool suite, Cognos Decisionstream 7.0 and SQL, PL/SQL, Windows 2008, 2012.
Confidential, Whitehouse Station, NJ
Cognos Technical Analyst
Responsibilities:
- Extensively worked on developing simple and complex reports on Cognos Report Studio 10.1.1.
- Developing teh reports using various templates like list report, Cross-tab Report and Chart Report.
- Created cascading prompts and worked wif various prompt controls such as Value prompt, Pick list prompt, and Date and Time prompt.
- Created reports using conditional formatting and sorting options.
- Created Boolean, String and Report language variables to render teh reports to teh particular query.
- Worked on Stored Procedures in SQL Server Management Studio 2008 R2 (DEV,TEST and PROD).
- Interacting wif different application team members and fixing teh issues related to teh framework models.
- Involved in refreshing teh metadata models whenever teh changes are made in teh stored procedures.
- Worked a user application called E-sales (DEV, TEST and PROD) where teh users can access teh reports.
- Responsible for upgrading reports from Cognos 10.0 to Cognos10.1.1in Dev, UAT, QA and Production environments.
- Involved in testing and quality assurance of all teh reports before delivering them to teh end users.
- Assisted to build dashboards using Cognos Workspace, Cognos Workspace Advanced and Cube Designer.
- Developed active reports, dashboards, metrics, analysis and other information in a security-rich environment using Cognos Mobile 10.1.1 to make teh user to view and interact.
- Prepared back up plan and Fact Finder documents Disaster recovery plan forCognosBI environments.
- Develop and maintain custom audit reports forCognos usage, servers & portals monitoring plan for n Cognos environments.
- Design and implementCognosportal setup,CognosPortal Performance settings, Cognos server performance settings andCognosproduction deployment plan.
Environment: Cognos 10.1 and 10.1.1 BI versions, Cognos Mobile 10.1.1, Report Studio10.1.1, Query Studio 10.1.1, Framework manager 10.1.1, SQL Server Management Studio 2008 R2 database, XML, Excel and Windows 2008, 2012.
Confidential, Charlotte, NC
Cognos BI Developer
Responsibilities:
- Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and prepare specification documents.
- Assist in reviewing and analyzing existing system structures to provide solutions to enhance and improve system.
- Assist in conducting in-depth review of requirement specifications collected and analyzing business process to determine teh exact nature of user’s system requirements.
- Designing mapping of process flow and interacting wif analysts and core team members to select teh proper system infrastructure.
- Design and review teh processing steps and create processes for new system.
- Review project specifications, flow charts, process diagrams and system documentation for application operations and methodology.
- Create processes for new system and attend to ad-hoc issues related to day to day activities throughout project implementation and testing phases.
- Installation and configuration of Business Objects suite in all (Dev, Test and Production) environments.
- Coordinating wif other teams to improve teh quality of work.
- Extracting OM (Order Management) application data from an Oracle transactional system and Loading it into a SQL Server data warehouse.
- Designed, developed, deployed and maintained Universes using Business Objects Designer tool.
- Developed complex reports including multipage-reports, graphical reports, formulae base and well-formatted reports according to user requirements.
- Created Aliases and Contexts for resolving Loops and Checked teh Cardinality and Integrity of teh Project / Framework Model.
- Created prompts in report to restrict data fetch and ease data load.
- Restricting teh user access wif help of Access Level privileges.
- Creation of repositories and security domain wif user groups and security implementation.
- As per teh Business requirement creating teh reports to cater to Order, Orders History, Pending Orders at Tasks, Processes and Tasks subject areas of teh application.
- Provided teh security access management by creating users/groups and folders.
- Upgraded fromCognos8.4.1 to10.x.
Environment: Cognos 10.1.1, 8.4 (Framework Manager, Report Studio, Query Studio, Event Studio, Business Insight and Business Insight Advanced), Cognos Connection, Oracle 10g, SQL Server 2008, DB2 9.1 on Windows Server 2003/2008.
Confidential, Pittsburgh, PA
Cognos Developer
Responsibilities:
- Analyzed business and user needs to design Business Intelligence solutions dat supported business and operations.
- Interacted wif ETL team and teh DBA to make available certain tables and data modifications required to successfully execute report requirements.
- Involved in Metadata modeling of both Relational and Dimensional data using Framework manager.
- Experience in implementing security based on user roles in Framework Manager and publishing reports.
- Used static choice value prompts, cascading prompts, conditional variables (Boolean and string) to create reports.
- Used TM1 rules editor to create and edit rule to create various calculations.
- Maintenance of TM1 users, roles, and security, Imported teh data from ODBC and Text files using TM1 Turbo integrator.
- Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
- Used TM1 rules editor to create and edit rule to create various calculations.
- Created Conditional Block reports to dynamically hide or show report objects and provide teh end user teh option to view teh data in different formats.
- Extensively used insertable objects like query calculation, layout calculation and tables to generate efficient and user-friendly reports.
- Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
- Implemented Conditional formatting and Java Scripts for customizing teh reports. Used Java Scripts for validating Date/Time controls and adding customized buttons to facilitate teh Show/Hide requests.
- Created Drillable reports to provide users wif more detailed information for teh next levels.
- Developed various Dashboard Reports such as teh Loan Originations dashboard to see at-a glance teh volume and characteristics of new loan originations, such as credit scores and loan-to-value calculations throughout teh portfolio.
- Scheduled Burst Reports for regions, zones and districts which delivered teh appropriate output for teh concerned mangers in Cognos Connections by email.
- Created Backups of teh content store and Public folders.
- Involved in performance tuning of several Reports.
- Mentored teh end users to TEMPeffectively use teh reporting tool to build and customize their ad-hoc reports.
- Involved in unit testing of all teh reports and documented all teh test cases worked on.
- Responsible for upgrading reports from Cognos8.4 to Cognos10.1.
- Knowledge in creating Reports and Dashboards using Active Reports and Business Insight.
Environment: Cognos 10 BI, Cognos 8.3 BI Suite, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos TM1 9.5.2, Java Script, PLSQL Developer, SQL Server, SQL DBX.
Confidential - Princeton, NJ
Cognos Developer
Responsibilities:
- This included debugging and optimizing Cognos reports and used a variety of reporting packages to produce, automate, schedule, and distribute defined reports.
- Managing and Administering teh entire Cognos 8 for BI Team.
- Involved in designing teh Framework Manager Models.
- Improving existing models by Creating Alias tables and applying other techniques for TEMPeffective reporting.
- Developed several Cognos reports.
- Responsible do to Query Optimization and Performance Tuning of all reports.
- Highlight: Lead functional role involving complete estimation, scheduling and delivery of a project for one of teh business clients.
Environment: Cognos 8.4 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Oracle9i, MySQL, MSQL Server, windows 2003, Unix.
Confidential, Rochester, NY
Cognos BI Developer
Responsibilities:
- Developed and implemented Business Intelligence solutions as a part of Business Intelligence Organization.
- Involved in all phases of teh data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
- Involved in teh design and implementation of teh balanced scorecard and online analytical processing (OLAP) solutions
- Participated in teh design, development, deployment and support of Reporting solutions in teh areas of Sales & Marketing, Forecast & Planning and Supplier Performance.
- Collaborated wif business to develop high-level designs including logical models and functional specification documents.
- Actively worked wif teh BI team and Business to transition teh application into Production Environment by providing support and training through teh release cycle.
- Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
- Assisted and worked wif ETL developers and data modelers to make sure dat model being developed is according to teh business requirements
- Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables wif multiple breaks.
- Designed and developed PowerPlay cubes for multidimensional analysis for Sales & Marketing and Forecast & Planning users
- Recommended and designed summary tables to be used in reports to optimize performance.
- Wrote SQL scripts and developed audit reports to compare warehouse data wif teh staging and source data.
- Administered Cognos BI Server Environment
- Managed Package Migrations and Deployments from one Environment to another.
- Managed Data Sources, run activities, user accounts and permissions
- Used Cognos SDK to develop various java applications.
Environment: COGNOS REPORT NET Framework Manager, Report Studio, COGNOS Connection, COGNOS Configuration 7.1, Cognos 8.4 Suite, Oracle 10g, SAPBW, SQL, PLSQL, AQT, PowerPlay Transformer 7.1/7.3, Quest Central, PowerPlay Enterprise Server Administration, Windows 2000, 2003, Unix.
Confidential
Cognos Report Developer
Responsibilities:
- Created teh design documents for teh development of Cognos Report net.
- Involved in creating teh model and package using Framework manager.
- Created reports for various departments like HR, sales and production.
- Communicated wif teh business users to comprehend teh requirements.
- Involved in teh migration of catalogs from impromptu to Report Net using migration utility.
- Created customized BI reports linking various databases, to meet teh user requirements.
- Developed numerous sophisticated drill-through ReportNet Reports.
- Created standard and Ad-hoc reports using Cognos Query Studio(Simple List, Grouped List, Crosstab, and nested Crosstab) reports and represented data graphically by charts utilizing Query Studio.
Environment: Cognos Report Net, Cognos connection 7.1, Power play Enterprise Server 7.1, Oracle 9iWindows XP, Windows NT, Windows 2000.