Cognos And Informatica Developer Resume
Los Angeles, CA
SUMMARY:
- Over 8+years of progressively responsible IT experience. Professional with in - depth knowledge of system management, analysis, design, development, testing, production implementation and maintenance of the project. Extensive experience in Report Development/Administration, along with advanced SQL coding.
- Experienced in working with Cognos 10.X, 8.X (Report Studio, Query Studio, Framework Manager), Cognos series 7 (Impromptu, PowerPlay web, Transformer, Upfront, Visualizer, NoticeCast, Decision Stream, Metrics Manager) and ReportNet(Query Studio, Report Studio, Framework Manager, Cognos Configuration)
- Progressive hands-on experience in Data warehousingandETLprocesses using Informatica.
- Strong knowledge and experience in full Cognos life cycle implementations and business workflows
- Well versed with ETL procedures to load data from different sources like Oracle, flat files, XML files into DWH using Confidential .
- Extensively used various Performance Tuning techniques to improve ETL performance.
- Expertise in DWH technical architecture, design, business requirement definition and Data Modeling. Responsible for designing, coding, testing, integrating the ETL processes and implementing the reporting requirements.
- Experienced in leading a team for the entire lifecycle of the project.
- Solid understanding and sound knowledge of Data warehouse & DW Modeling concepts using Dimensional Data modeling, Star Schema modeling, FACT and Dimensions tables.
- Extensive experience in requirements gathering and end user training
- Experienced in handling multiple projects simultaneously
- Experienced in Teradata, Oracle, MS SQL Server, SQL Navigator, PL/SQL, MS Access, TOAD
- Proficient in design, analysis, development, coding, testing, modification, and optimization of reports
- Around three years of experience in design, coding and development in C, C++, OPEN GL
- Specialized in web development using Dreamweaver, Adobe Photoshop, Flash, PHP, JSP, Servlets, and JDBC
- Proficient in using C, C++, Java
- Excellent verbal and written communication skills
TECHNICAL SKILLS
Operating Systems: UNIX, Windows NT/2000/XP/7
RDBMS: DB2, Teradata,Oracle 10.x/11g, SQLServer 2005/2000, MS Access.
Languages: Java, Java Script, HTML, XML, SQL, PL/SQL, C, and C++, OPENGL, CLIPS
Modeling Tools: Erwin
OLAP /Reporting: Cognos 10.X, 8.X(Framework Manager, Report Studio, Analysis Studio, Event Studio, Metric Studio), Cognos 8.4 Go Office, Cognos ReportNet 1.1, Cognos 7.x(Impromptu, PowerPlay, Upfront Access Manager, IWR, PowerPlay Enterprise Server, Visualizer, NoticeCast, Metrics Manager, Decision Stream).
ETL Tools: Confidential 9.x/8.x/7.x, IBM Data stage 7.x
Tools: SQL Navigator, TOAD, MS Office 2000, MS Project
Web Servers: Apache/Tomcat, IIS, iPlanet Application Server, and Netscape Directory Server.
Scripting: JavaScript, PHP
Other Technologies/Utilities: XML, HTML, XML and ASP, Java Swing
PROFESSIONAL EXPERIENCE:
Confidential, Los Angeles, CA
Cognos and Informatica Developer
Responsibilities:
- Project Tasks:
- Leading a team of 4 members extensively worked on Production Load Management, support and Maintenance.
- Analyzed the source data coming from different sources like, Oracle, DB2, Flat files
- Worked on development of different cognos reports using report studio, query studio and modeled the data for the reports using framework manager.
- Worked with business users and developers to develop the model and documentation for the different projects.
- Data Modeling Tasks:
- Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
- Played active role in business requirements gathering and ambiguity reviews.
- Re-designed and re-developed conceptual, logical and physicaldatamodels using CA Erwin
- Cognos Tasks:
- Designed, and developed different Health Care reports using Report Studio.
- Developed reports in Report Studio with drill through capabilities.
- Involved in complete project life cycle of this project, which includes gathering requirements for report development and draft Functional Requirement Specifications.
- Creating Dynamic dashboards with multipage port lets for business users for comparison analysis.
- Worked on Analysis Studio to develop multi dimensional reporting.
- Modeled metadata from MS SQL server data source for use in Report studio and Query Studio using Framework Manager.
- Worked with QA team to close the bugs identified on the Cognos reports-Used Quality Center for bug tracking.
- ETL Development Tasks:
- Involved in developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected Lookup, Router, Filter, Aggregator, Expression, SQL, Stored procedure, Normalizer and Update strategy transformations.
- Extensively worked on Informatica Designer and Workflow Manager to design and develop various mapping and workflows.
- Responsible for creating Workflows and sessions using Informatica workflow manager. Monitor the workflow run and statistic properties on Informatica Workflow Monitor.
- Implemented complex ETL logic using SQL overrides in the source Qualifier.
- Performed ETL testing development work, tested the data and data integrity among various sources and targets by writing the SQL Scripts and validated the results with Business Analyst.
- Developed Unix Scripts for updating the control table based on the environments.
- Developed Informatica Mappings, Re-usable Transformations, re-usable mappings, Mapplets and re-usable sessions.
Environment: Confidential 9.1.1/9.5, DB2, Oracle 11g,Toad, Shell Scripts, CA Erwin Windows XP, Cognos 10.1 (Framework Manager, Report Studio, Business Insights Advanced, Cognos Connection)
Confidential, Houston, TX
Cognos and Informatica Consultant
Responsibilities:
- Designing datawarehouse, developing complexFM models, reports, dashboards and OLAP solutions
- Followed the agile methodology and conducted scrum meetings every day with team members
- Conducted technical grooming, backlog grooming and sprint planning sessions with team members.
- Updated the user stories depending on team input
- Interacted with different business clients to understand what new features are expected from Market Discovery.
- Customized the BIA tool to allow the user to create adhoc reports
- Customized the Cognos connection for security reasons
- Worked on the performance of the reports and enhanced the report performance by 70%
- Designed the custom filter creation page for the users
- Worked with QA team to help build the test plan and to test the various aspects of the application.
- Worked on metadata modeling tool Transformer for creating power cubes
- Worked on power play cubes modeling and development process and distribute the created cubes to the end users.
- Analyzed and explored the cube data using power play.
- Integrated the BIA reports with ESRI Maps
- Designed and developed the pipeline functions to implement the user created filter scenarios.
- Designed the report templates for Market Discovery.
- Implemented the custom authentication provider security in Cognos.
- ETL Admin/Support Tasks:
- Responsible for creating deployment groups to migrate the folders, workflows and their dependencies between different environments.
- Performed migrations of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
- Worked on the admin related task in creating users, handling the users and granting proper privileges in Informatica.
- Extensively worked in the performance tuning of the Informatica mappings, Sessions and PL/SQL packages and other processes and efficiency using cache filing and best practices of Informatica.
Environment: Cognos 10.1 (Framework Manager, Report Studio, Business Insights Advanced, Cognos Connection, Cognos SDK), Oracle 11g, Windows XP/7, ESRI
Confidential, San Diego, CA
Cognos developer
Responsibilities:
- Coordinated source data feeds to Data Warehouse; planning and implementing data integration processes for multiple source systems
- Managed day to day interactions with executive clients and sponsors
- Managed teams in the identification of business requirements, functional design, process design (including scenario design, flow mapping), prototyping, testing, training, defining support procedures.
- Responsiblefor the overall application architecture quality and performance
- Designed and developed the Asia Sell Thru Reporting package and reports based on requirement documents.
- Improved the performance of queries by analyzing the Explain Plan
- Managing User ID’s and User groups like providing privileges to users and the user groups.
- Worked on building the multidimensional analysis cubes to define the OLAP cube structure and data using power play transformer.
- Design and developed the power play model in transformer.
- Created a model plan which include design and data requirements for the model on cube distribution methodology.
- Worked on creating prompts and cascading prompts pages.
- Interacted with the QA team and helped them in building the Test Plan as per the functional specification
- Responding to alerts or emergency issues during non business hours.
- On-call responsibilities include response to emergency issues within SLA. Assist in reviewing new enhancements against business requirements to identify opportunities for scheduling, process, performance, reliability, or data management improvements.
Environment: Cognos8.4 (Framework Manager, Report Studio, Query Studio Cognos Connection, Event Studio), Teradata 12.0, Windows XP/7
Confidential / Viacom, NY
Cognos consultant
Responsibilities:
- Responsiblefor the strategy and design of enterprise reporting and analyticsarchitecture, including the conceptual, logical, and physical layers.
- Designed and developed report prototypes and technical specification document for this project.
- Assisted the project manager in allocating the resources to specific tasks in project plan
- Analyzed the existing TRAM reports in MS Office, MS Excel and came up with the report designs.
- Designed and developed Series 8 packages in Frame work Manager
- Designed specific Cognos portals for different Sales teams
- Developed specific packages in Framework Manager for query studio users.
- Design and development of TRAM reports in report studio
- Implemented various reporting techniques like Drill up, Drill down and Drill through functionality, Conditional Formatting, Conditional Blocks, Conditional Layouts, Dynamic grouping and Sorting.
- Developed complex dashboards in Report Studio using JavaScript
- Implemented the Audit Reports for TRAM project.
- Developed Crosstab reports with Spark lines for different quarters
- Developed multi query and multi prompt reports for TRAM.
- Training End users in Cognos (Report Studio, Query Studio, Scheduling)
- Implemented Scheduling, Bursting and Emailing of Reports
- Constant Interaction with the ETL and Source System users for validation of data.
- Deployment of packages from Dev to Test and Prod environments
- Developed the initial draft for the Digital TRAM and Linear Integration.
Environment: Cognos8.2 (Framework Manager, Report Studio, Query Studio Cognos Connection, Event Studio), SQL Server 2005, Windows 7
Confidential, Lansdale, PA
Programmer/ Cognos Modeler
Responsibilities:
- Coordinated with business users to understand the business rules and assigned specific tasks to the team members
- Designed and developed report prototypes and technical specification document for this project
- Responsible for administration and maintenance of reports and performance monitoring of the Cognos environment (including user management).
- Initiated version control process for Framework models and Cognos reports.
- Created materialized views to store different attributes of sales field personnel to be passed to Pedagogue.
- Created SQL packages to access the data returned from Pedagogue and update the tables at Merck.
- Developed Framework Manager Model in Cognos 8.4 to integrate the Pedagogue CBT exams data, the existing exams data in Merck and the CBT exams data from Schering Plough.
- Created and modified metadata, filters, calculations and complex case logic in Cognos Framework Model.
- Designed, and developed different certification reports using Report Studio.
- Developed adhoc completion reports for all the sales training managers from Merck and Schering Plough.
- Developed error reports in Event Studio using Audit package
- Used HTML items and JavaScript to create custom prompt pages in Report Studio.
Confidential, East Moline, IL
Cognos Consultant
Responsibilities:
- Installed and implemented Cognos Series 7.3 (Impromptu, PowerPlay, Decision Stream, Visualizer, NoticeCast), Metrics Manager 2.2, ReportNet 1.1 MR2 in all the technical colleges in Wisconsin state.
- Provided authentication-using windows Active Directory server and iPlanet Application Server.
- Analyzed the data and developed the reports according to the business requirements.
- Involved in creating different types of packages and reports using ReportNet and Framework Manager.
- Migrated impromptu reports to ReportNet using the migration tool.
- Responsible for creating templates for all the colleges (according to their specification).
- Developed the Workbook and Client Reporting System cubes.
- Provided the single user authentication for the Cognos reports and a third-party java application.
- Provided user training in ReportNet in all the colleges, after the installation.
- Created/Modified models with Framework Manager using ReportNet.
- Actively interacted with end users to identify key dimensions and measures for business performance.
- Developed the Framework Manager Model and published the reports to ReportNet Server.
- Created standalone Filters in Framework Manager Model.
- Developed reports by implementing conditional prompts.
Environment: Cognos BI Tools - Impromptu, Power Play, IWR, Upfront, Visualizer, NoticeCast, Decision Stream, Metrics Manager, ReportNet, Oracle 8i/9i, SQL Server, PPES, Scheduler, Script Editor, Deployment Manager, LDAP, and Windows 98/NT/2000/2003 Server, Unix, Netscape Directory Server, iPlanet