Cognos Architect Resume
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 Developer May 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