SUMMARY

• Total around 9 years of IT experience including Business Intelligence, Data Warehousing, QA Testing and Business Analyst as an Administrator, Developer, Tester and System Analyst.
• Presently working as a Cognos Architect in Confidential for Enterprise risk management.
• Experienced in data Modelling using Cognos Framework Manager and write reports in cognos Studios (Report Studio, Query Studio, and Business Insight).
• Experienced in distributed cognos installation across Windows server, Sun Solaris, Sun one web server, Sun active directory LDAP for security and Site Minder for single sign on.
• Experienced in single server installation on windows server and Microsoft Active Directory as security provider and IIS as web server.
• Worked on migration from Cognos 8.4.1 to 10.1.1 on Windows server in a distributed environment and IIS as web server.
• Wrote recycle scripts (windows batch script) for Cognos services and schedule them using a tool called Control - M. Wrote windows script to clear temp, data files from dispatchers which are older TEMPthan certain days.
• Wrote recycle scripts (UNIX shell script) for Cognos services on unix environment. Wrote shell script to check for dmp files in teh \bin folder of Content manager.
• Worked in Windows provided ‘Performance’ tool to check teh resource usage of various cognos servers for troubleshooting slowness/performance issues of cognos environment.
• Worked with MKS Tool Kit to use UNIX commands on remote windows boxes and compare files.
• Troubleshooting of various Cognos user and developer issues and deployment from one environment to another.
• Worked with IBM for Cognos issues via PMR on several Occasions.
• Exposure to Cognos SDK code for some user specific queries.
• Experienced in using utility tools like Putty, Hummingbird (Exceed), WinScp etc
• Experienced in using ticket logging tools like HP Service Manager (formerly Peregrine).
• Experienced in using defect logging tools like HP Quality Center.
• Experience in SQL, Oracle and MS Access.
• Used TOAD and PL/SQL Developer as SQL editor.
• Domain expertise: Financial, Mortgage and Insurance Industries.
• Quick learner and self motivated with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows XP/7/8, Unix

Languages: SQL, windows batch scripting, shell scripting

Tool: Cognos 8.4, 10.1.1 and 10.1.1 Administration Cognos Framework Manager 8.4.1, 10.1.1 and 10.1.1 Cognos Transformer 7, 8.4.1,10.1.1 and 10.1.1 Cognos Report Studio 8.3, 8.4.1, 10.1.1 and 10.1.1 SDK, HP Service Manager, HP Quality Center, MKS Tool Kit Toad, PL/SQL Developer, Hummingbird, Putty, Winscp

RDBMS: Oracle 8i/9i/10g/11g, Sql server, Teradata, MS Access, DB2

Models: Worked on Relational and Dimensional data models, STAR schema.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Cognos Architect

Responsibilities:

• Involved in gathering Functional requirement from teh end users and analyzed teh requirement.
• Analyzing teh requirement document and differentiating teh metrics (facts and dimension) for Cognos reports for design purpose.
• Preparing teh technical specification document for teh Project.
• Creation of packages(Relational and Dimensional) from Cognos Framework Manager 10.1.1
• Creating teh reports using Cognos 10.1.1 Report studio
• Creating dashboards in Business Intelligence and Business Intelligence Advanced
• Involved in end to end implementation of reporting project.
• Functional and system testing of teh cognos Reports.
• Involved in SSO implementation between cognos and java portal using WAS8.5 and servlet Gateway.
• Demonstration of reports to teh users and answer their questions.

Environment: Cognos 10.1.1, HIS web server, Windows server 2008, Redhat Linux, Sybase, Oracle.

Confidential, Charlotte, NC

Cognos Administrator

Responsibilities:

• Involved in end to end implementation of Cognos environment.
• Worked in a distributed installation across Windows server and Sun Solaris and Sun one web server and Sun active directory LDAP for security.
• Worked in single server installation on windows server and Microsoft Active Directory as security provider and IIS as web server.
• Working on migration to Cognos 10.1.1 from 8.4.1 on Windows server in a distributed environment and IIS as web server.
• Wrote recycle scripts for Cognos services and schedule them using a tool called Control-M.
• Wrote scripts to build cubes on both windows and unix environment.
• Troubleshooting of various user issues in Framework Manager, Report Studio, Analysis Studio and Transformer etc and deployed content from one environment to another.
• Set up security for Packages, folders in Cognos Admin portal
• Created Cognos ‘data sources’ (for Oracle, DB2, SQL server, MS Access, Cubes) and File shares in cognos Admin portal.
• Worked with IBM on various occasion for PMR opened for user/Developer issues.
• Wrote SDK code for some user specific queries.
• Performed functional testing of new cognos installation.
• Involved in Environment setup in all phases.
• Acting as a single point contact to co-ordinate with Support team and Middle Tier team.

Environment: Cognos 8.3, 8.4.1, 10.1.1 and 10.1.1, IIS 6, Sun one Web server, Windows server 2003 and 2008, Sun Solaris Unix, Shell Script, Windows Batch script, HP service Manager, MKS tool kit, Putty, Toad, PL/SQL Developer, Hummingbird, Oracle 11g, DB2.

Confidential, Irving, TX

Cognos System Analyst

Responsibilities:

• Troubleshooting of various user issues in Framework Manager, Report Studio, Query studio and Transformer.
• Content deployment from Dev to UAT and UAT to PROD.
• Set up security for Packages, folders in Cognos Admin portal and also created roles and groups in Cognos namespace.
• Created Cognos ‘data sources’ (for Oracle, DB2, SQL server, MS Access, Cubes) and File shares in cognos Admin portal.
• Run cognos maintenance tasks from cognos Admin portal (like Consistency check).
• Performance Tuning of cognos environment by setting up advanced properties in teh portal Administration page.
• Monitoring of teh servers where cognos server components (content Manager and Report server) are installed for resource (CPU usage, memory usage etc) and space constraints (temp folder, data folder etc).
• Defined routing rules in cognos admin portal to rout reports from specific package to particular dispatcher.
• Retrieved packages from content store (SDK code) for developers who accidentally lost their packages.
• Worked with LDAP and Active Directory team to set up security in Cognos.
• Created Audit reports for users for checking various parameters (like report run time, when ran, who ran etc) for specific package and schedule teh output to send them periodically.

Environment: Cognos 8.3, 8.4, IIS 5, PPES (powerplay enterprise server) Windows server 2003, Sun Solaris Unix, Shell Script, and Windows Batch script, HP Peregrine, Putty, Toad, PL/SQL Developer, Oracle, DB2.

Confidential

BI Analyst

Responsibilities:

• Involved in gathering Functional requirement from teh end users and analyzed teh requirement.
• Analyzing teh requirement document and differentiating teh metrics (facts and dimension) for PowerPlay cubes and Cognos 8 reports for design purpose.
• Preparing teh design document for PowerPlay cubes, Cognos 8 reports, Coding Standards document, Naming Conventions document, Defect logs, Review Logs.
• Creating IQD files using Cognos Framework Manager
• Building teh model file for cube using Cognos Transformer series 7, building cubes and publishing them to Cognos portal using PPES (PowerPlay enterprise server).
• Open teh cube in Powerplay and slice and dice them and create cube views.
• Writing shell script to build cube in Unix and batch script to build cube on Windows.
• Creation of packages(Relational and Dimensional) from Cognos Framework Manager
• Creating teh reports using Cognos 8

Environment: Cognos 8, PPES (powerplay enterprise server) Windows server 2003, Sun Solaris Unix, Shell Script, Windows Batch script, HP Peregrine, Putty, Toad, PL/SQL Developer, Oracle, DB2.

Confidential, Irving TX

QA Testing Analyst

Responsibilities:

• Analyzing teh existing manual test cases and designing new Test Cases from Functional Specification.
• Writing teh Functional specification document for functional testing of teh application
• Writing teh Test conditions from Test cases.
• Preparation of Test Strategy Document
• Execution of teh manual test cases
• Back end(database) testing using SQL queries in Oracle 9i database
• Tracking teh Bugs throughout teh life cycle of Testing using Mercury Quality Center.
• Execution of Regression Test cases
• Monitoring teh environment for application which are testing
• Performed negative and positive testing
• Participated in Document Reviews and Inspection
• Preparation of teh Readiness Documents, Mapping Documents
• Preparation of automation strategy
• Creation of testing framework and teh Automation test scripts using WinRunner and QTP.

Environment: Mercury Quality Center, Test Director, MS Excel, Toad, Oracle 9i.