Cognos Developer And Administrator Resume Profile
Professional Summary :
- 17 years of experience in IT. 12 years of experience in leading and managing Datawarehouse project
- Around Thirteen Years of Experience in System Analysis, Design, Development and Administrating in the fields of Data warehousing, Database and Mainframe Technologies
- Around Ten years of Experience with Cognos 10/8.4 Report Studio,Query Studio, Framework Manager, Event Studio, Powerplay Studio, Transformer Development and administration
- Experience in Installation, Configuration, Monitoring and Managing of Cognos 8/10 on Solaris/ z/Linux / Windows 2003 SP1/2008 R2 platforms
- Expertise in Migration from Reportnet to Cognos 8 and upgrades from Cognos 8 to Cognos 10
- Experience in creating Packages and maintaining Models in Frame Work Manager using Report Net 1.1 MR2, Cognos 8 Cognos 10.
- Over Three and half years of Experience with Cognos Series 7 Cognos Impromptu 7/7.x, Cognos IWR 7/7.x, Analysis Tools such as Cognos Transformer Power Play 7/7.x, Access Manager
- Expertise in deploying packages and reports to Production environment and handling production issues
- Thoroughly documented the steps, provided production support and Knowledge Transfer to end-users for Cognos 10, Cognos 8, Report Net, Power Play and Impromptu Administration
- Lead and Managed DW and Mainframe projects
- 100 focused on achieving results and providing superior customer service. Known for soft skills such as being calm under pressure, a good listener, out of the box thinker, people manager. Accustomed to working closely with all levels of the senior management teams
Skill Set:
| : | Healthcare, Automotive, Supply Chain, Finance |
| : | Cognos 10 and Cognos 8 Framework Manager, Report Studio, Query Studio, Event Studio, Powerplay Studio, Cognos Administration , COGNOS Series 7 Impromptu Administrator, Server Administrator, Powerplay, Powerplay Transformer, Access Manager |
| : | Informatica 8.6 |
| : | SAP |
| : | COBOL, AIX UNIX , JCL, VSAM, DB2, IMS DB/DC, MQ series, TSO, ISPF, Xpediter, Strobe, File-Aid, Abend-Aid, Changeman, Jobtrac, CA-7 |
| : | Oracle, Teradata, DB2, UDB, SQL Server 2005, |
| : | Sun Solaris, UNIX, Windows 2000/2005/2008, MVS, DOS |
| : | MS- Excel, MS Word, MS PowerPoint, MS Visio, MS-Project |
| : | COGNOS 8 training Framework Manager and Report Studio from IBM, CICS, Assembly Language for Mainframe |
Experience details:
A. From Nov 2011 till Date working with APEX IT Services, LLC. Presently working as Cognos Administrator at Baltimore, MD, USA for CMS Center for Medicare and Medicaid Services |
Projects Details:
Cognos Developer and Administrator
Platform: Sun Solaris, z/Linux, DB2 UDB, Teradata, Oracle 11g, Cognos 10.2.1, Cognos 10.1.1, Cognos 8.4.1, Cognos 8.4,As a Cognos lead,
- Designed and Implemented dashboards
- Developed Active reports for users to use offline and on mobile devices
- Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer
- Established an audit reporting system for the internal team to monitor, analyze performance and usage of different reports, cubes and other objects
- Authored various types of reports in Report Studio using functionalities like Render Variables, Conditional Blocking, Cascading Prompts and Conditional Formatting
- Successfully designed and implemented security on different levels including object and row level security
- Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT process
- Provided Training to different business users to develop dashboards in workspace and workspace advanced
- Performance tuning for long running reports
- Install, configure, deploy and support Cognos solutions
- Support upgrades and technical releases Involved in WAS 6 -> WAS 7 -> WAS 8.5 upgrade, Cognos 8.4.1 -> 10.1.1 -> 10.2.1 upgrade
- Coordinate with shared support personnel for server OS and database maintenance and trouble shooting
- Consult and interface with internal/external team members as well as IBM Cognos for service requests, maintenance and patching
- Configure, maintain and administer Cognos models, packages, reports and dashboards
- Troubleshoot issues identified by business and IT stakeholders
- LDAP migration
- Windows 2003 Server, Windows 2008 Server, z/Linux, DB2 UDB, SQL Server 2000/2005, BI COGNOS Series 7 Impromptu Administrator, Powerplay, Powerplay Transformer, Access Manager , Cognos 8.4, Cognos 8.4.1, Cognos 10.1, TM1 9.5.2
- Received Make a Difference award from DTNA for upgrade to Cognos 10.1
- As a Cognos Administrator, involved in
- Improve system performance
- Setup Audit for keeping track of licenses
- Monitor report failures by setting up Audit
- Installing Cognos products on Windows Servers and users machine client version like Imprompru Admin, Framework Manager, Powerplay transformer
- Server maintenance on monthly basis MS patch installed
- Lay down processes and documenting the same for setting up access in cognos, granting access to folder/package, cube access, publishing and setting up drill thru reports from cube, assigning capabilities to users
- Involve in SQL server migration
- Deploying packages and reports to Production environment and handling production issues
- Maintaining user access using series 7 Windows server and Sun one console z/Linux
- Migration from Cognos series 7 / CRN to Cognos 8.4.1
- Upgrade from Cognos 8.4.1 to Cognos 10.1
- Provide technical guidance to users for report / query / powerplay studio
- Helping developers for design of Framework Manager and Reports and building the same
- Work with IBM support and open PMR as and when required