We provide IT Staff Augmentation Services!

Cognos Architect Resume

New York City, NY

PROFESSIONAL SUMMARY

  • 5 years of experience in IT Industry in analysis, design, testing, development and documentation
  • Hands on experience of Cognos 8 BI: Installation, configuration and working with Framework Manager, Transformer, Event Studio, Report Studio and Analysis Studio
  • Experience in full life cycle project development; including design, coding, testing, implementation and product support
  • Implemented BI projects using the Cognos Solutions Implementation Methodology (CSIM)
  • Strong data modeling skills (Star Schema, Snow Flaked Schema, Fact and Dimensional based modeling)
  • Trained users for the successful execution of the project and to build reports using Report Studio and Query Studio
  • Continually provided value added services to the clients through thoughtful experience and excellent communication skills
  • BrainBench certified in RDBMS Concepts
  • Oracle Certified Associate (OCA) in Oracle 9i

TECHNICAL EXPOSURE

BI Tools: Cognos 7.x/8.x/10.x BI (Framework Manager, Transformer, Cognos Configuration, Event Studio, Report Studio, Query Studio, Analysis Studio, PowerPlay, Impromptu, Impromptu Web Reports), Cognos 8 Planning (Analyst, Contributor), Reportnet 1.1, Business Objects XI (Universe Designer, Web Intelligence)
Databases: Teradata 12/13, SQL Server 2000/2005, Oracle 9i/10g
ETL: SSIS, OLE Load, BTEQ, FastLoad, MultiLoad
OS: Windows, LINUX
Languages: C++, Java, SQL, PL/SQL, JavaScript, XML
Software Tools: TOAD, Visio, Erwin
Version Control: CVS, Subversion

EXPERIENCE

Confidential, New York City, NY
Cognos Architect,Jun. 2009 Till Date

  • Upgrading from Cognos 8 to Cognos 10
  • Execute Cognos Administration tasks such as maintaining Data source Connections, creating packages and folders, user access permissions to packages and folders
  • Deploying reports and packages among different environment Development, Test and Production
  • Migrate Business Object Universe models and WEB reports to Framework Manager Models and Report Studio reports
  • Coordinating with Data Warehouse group in defining the ETL logic
  • Implementing security, managing users, user groups and roles in the organization
  • Working with the end users and developers to understand the reporting requirements
  • Involved in performance tuning of Framework Model and Reports
  • Sharing best practices in Framework Model, Report Authoring, testing and security setup
  • Analyze methodologies for efficient structures and suggesting proper indexing to be used per the reporting requirement
  • Perform data analysis in the integrations projects
  • Created Events to trigger jobs based on the business requirement

Confidential, North Hollywood, CA
Cognos DeveloperMay 2008 Jun. 2009

  • Installed and Configured Cognos BI 8.4 Suite
  • Created Dashboards and Portlet on Cognos Connection per the business needs
  • Developed Transformer Policy and Claims Cube for analysis and report generation
  • Created Models and Packages using Cognos Framework Manager and deployed packages on Cognos Connection
  • Developed various dimensions, measures and calculations in Cognos Transformer
  • Implemented Cognos security in all three environments
  • Fine-tuned the existing models and reports to get efficient results
  • Provided training on Query Studio to create Ad-hoc Reports and Analysis Studio for data analysis

Confidential, Andover, MA
Software Engineer (Co-op) Jul. 2006 Dec. 2006

  • Communicated with the business users to document the requirement
  • Involved in the installation and configuration of Cognos 8
  • Developed templates, standard reports and master-detail reports per the business requirement
  • Migrated the existing crystal reports into Cognos 8 environment
  • Created reports to evaluate the business performance based on various financial indicators
  • Created jobs to run on a monthly, weekly, and daily basis

Confidential,India
Software Engineer Jul. 2004 Jul. 2005

  • Analyzed and gathered the requirements and converting them into technical specifications
  • Involved in code reviews and unit testing
  • Developed adhoc reports specific to the clients
  • Developed and maintained documentation

EDUCATION
M.S. Computer Science
B.E. Computer Science

Hire Now