SUMMARY:

• Around 9 years of experience in Requirement Gathering, Software Design & Development, Project Implementation, Data Modelling, Report Authoring, ETL & Data Warehousing, Testing and Technical Support
• Demonstrated excellence in analysing & translating business requirements to technical requirements
• Excellent skills in interacting with clients for business / technical problem analysis and solution consulting
• Prepare documents regarding technical design, high level system flows, project estimates, project plan, code reviews and issues, unit test plan and weekly status reports for project management
• Strong organization skills with the ability to work on multiple projects/assignments simultaneously
• IBM Certified Solution Expert - Cognos 8/10 BI
• Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.
• Expertise in writing OLAP reports using Cognos 10.2 (Report Studio, Query Studio, Analysis Studio), Cognos 8 Series, Cognos Series 7, Report Net 1.1
• Experience in defining system flow, architecture and cognos capacity planning.
• Involved in installation, configuration and upgrade of COGNOS BI suites (series 7,8 and 10)
• Developed and published packages in Framework manager using clear conventions, a multi-layered structure, and package, data, and object level security.
• Worked on in-depth Report Studio development, automated delivery, and performance-tuning

TECHNICAL SKILLS:

BI Reporting Tools: Cognos BI Suite 10 (Report Studio, Query Studio, Framework Manager, Metrics Studio, Analysis Studio & Transformer), Cognos Adaptive analytics and TM1, Cognos 7.x (Impromptu, Transformer, Upfront and Access Manager)

ETL Tools: Cognos Data manager & Decision Stream, Microsoft SSIS, TM1 Turbo Integrator

Databases: Oracle 9i, DB2 and SQL Server

Operating Systems: Windows NT/2000/2003/XP

Configuration Management: Microsoft VSS

Microsoft Skills: MS Access, Word, PowerPoint, Excel

Other Tools: Rational Portfolio Manager, Rational Clear Quest, HP Service manager

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Solution Architect /senior developer/Admin

Responsibilities:

• Overseeing requirement analysis, design decisions, micro design, reviews of design documents, development, code reviews and defect remediation processes
• Preparation of high level estimation and project plan
• Handling Cognos admin related activities and user management using LDAP
• Troubleshooting issues related to database and report performance
• Recommending and implementing improvements and efficiencies
• Developing deployment best practices for the Business Intelligence solution
• Leading customers through discussions around success criteria and data analysis
• Allocating and tracking work assignments to the off-shore team members. Leading the offshore team and providing the team members necessary and guidance as and when required
• Designed Framework Manager Model using star schema and multiple layers with package level security.
• Created complex reports utilizing prompts, conditional formatting, conditional variables and drill through
• Actively involved in Customizing Cognos Connection with appropriate reports and security measures
• Developed Dashboard reports using Cognos Report Studio and published portals onto Cognos Connection
• Developed List Reports, Cross Tab Reports, Charts, Drill Through Reports, used Conditional blocks/Variables
• Looked after maintenance & support of the existing applications
• Translating complex business requirements into technical design and developing proof of concepts
• Created templates for report authors
• Integrated the security of Cognos and Active directory to a single sign-on.
• Wrote cognos batch files and scripts for end to end Powerplay cube build automation.
• Troubleshooting all cognos environment issues.
• Regular maintenance activities

Environment: Cognos 10 (Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager), SQL Server 2005, Oracle, Windows

Confidential

Senior Cognos developer

Responsibilities:

• Interacted with clients in requirement gathering phase
• Designed the Data Model for end reports authoring
• Involved in the process loading the data using Data Stage
• Development of reports using report studio and query studio
• Responsible for all Cognos Admin related activities and User management using LDAP
• Maintained all versions of deliverables like Framework manager models and Report codes in Rational Clear Case which was used as the Configuration Management tool
• Troubleshooting issues related to database and report performance

Environment: Cognos Metrics Studio, Cognos Report Studio, Cognos Query studio, Cognos Framework manager and Cognos TM1

Confidential

Senior Cognos developer

Responsibilities:

• Use of Adaptive warehouse to load the data
• Use of Adaptive Analytics to deliver sample reports
• Creation of SABA package which can be integrated with Workforce Performance for PeopleSoft

Environment: Cognos Adaptive Analytics and Adaptive warehouse

Confidential

Senior Cognos developer

Responsibilities:

• Interacted with clients in requirement gathering phase
• Designed the Data Model for GVI for end reports authoring
• Involved in the process of loading the data using Data Stage
• Provided guidance to the team members in creating customized reports

Environment: Cognos Report studio, framework manager

Confidential

Senior Cognos developer

Responsibilities:

• Entire project implementation
• Design & development of Cognos Report Studio reports
• Validation of report studio reports
• Enhancement of ETL using Cognos Data Manager
• Data modelling using Framework Manager
• Overseeing creation and reviews of test specifications
• Leading maintenance of the database and production support
• Installing, upgrading, configuring & administering Cognos products including ETL

Environment: Cognos Report studio, framework manager, Cognos data manager, Microsoft BI Reporting and MS-VSS (for source code control)

Confidential

Cognos developer

Responsibilities:

• Supported project Confidential involving daily support activities, enhancements in existing ETL & reports to meet new business requirements
• Requirement analysis for RDW (Regional Data Warehouse) for Confidential
• Development of customized routine (ETL system) to capture and load data from external (Oracle 9i Flat files) data sources into Oracle database
• Fine tuning the existing application
• Preparation of technical specifications
• Maintenance of the Database and production support
• Data analysis for verifying RDW data, by generating and comparing reports from RDW with reports from existing legacy systems
• Code review of the releases
• Test Specification creation and reviews
• Led development & enhancement of RDW related Cognos Impromptu Reports and Cubes
• ETL job streams using Cognos Decision Stream

Environment: Cognos Report studio, framework manager, Cognos data manager, Microsoft BI Reporting and MS-VSS (for source code control)