SUMMARY

• Over Approximately 5 years of experience with Business Intelligence tools like Cognos 10/8.x (Report studio, Query Studio, Analysis Studio, Event Studio, Metric Studio Framework Manager), Cognos Administrator, Transformer, Power Play Enterprise Server (OLAP), Upfront, Access Manager and Directory Server.
• Expertise in creating complex reports like Executive Dashboards, Cross tab reports, Top ten reports, ad - hoc reports, Charts and Score card reports using Report Studio.
• Strong working experience in Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical Data Modeling, Fact and Dimension tables.
• Excellent knowledge on MDX Functions in Report Studio using Multi-Dimensional Sources (DMR Model and Power play Cube) and IQD Packages through transformers.
• Expertise in Cognos (Framework Manager, Query Studio, Report Studio, Essbase, Cognos Connection).
• Strong experience in generating various reports (Dashboards, Master-Detail, etc.,) using Report studio.
• Usage of Query Studio to build ad hoc Business reports and Report Studio to build advanced reports (multi-page, multi-query reports) against multiple databases.
• Experience in deploying packages from one environment to other.
• Migration of Cubes and Reports from One environment to different environments In Cognos 8.
• Expert in all stages of Software development life cycle (SDLC) which includes requirement analysis, design, development, testing and documentation.
• Expertise with the set of code libraries, ie. jars or dlls by using SDK language.
• Experience in Migration of the applications from Cognos Series 8.3 to 8.4 BI.
• Experienced in Installation, Up Gradation and Production Support of Cognos Series 7 and Cognos 8.
• Designed the architect model, developed the Cognos Query and packages for production and demonstrations.
• Extensively worked on performance tuning for existing reports in Report Studio and Testing and improving Report Performance and performing Query optimization through SQL.
• Experience in coming up with data cleansing, backup and restoration strategies.
• Excellent Verbal and Communication skills with strong potential to learn new technology and adapting to new tools/environment.
• Ability to meet deadlines, multi tasking, flexible in work schedules, team player and posses good communication skills.

TECHNICAL SKILLS

Cognos Tools: Cognos 10/8 BI, Framework Manager, Query Studio, Report Studio, Cognos Connection, Cognos Configuration, Analysis Studio, Event Studio, Metric Studio, Cognos Report Net, Cognos Power Play Transformer, Upfront Server Administration, Cognos Enterprise Server, Access Manager.

Databases: Oracle 8i/9i, SQL Server 2000/2005

Data Modeling: Site scope, Solar winds, Data Analytics, Star schema and Snowflake-Schema Modeling.

Languages: C, C++, PL/SQL, SQL, HTML, JavaScript, SDK.

Operation Systems: Windows 2000/NT Servers, Windows NT/95/98/XP, Windows XP Professional, Unix

PROFESSIONAL EXPERIENCE

Confidential

Cognos BI Admin

Responsibilities:

• Creating User accounts and providing access to them through Access Manager.
• Migration activities from one environment to another environment.
• Migration of reports and cubes and packages from Dev, Qa to Prod.
• Expertise in Reverse Migration of reports and packages.
• Migration of Cube Model and package from on server to another server and Hands on cube building.
• Expertise in scheduling of jobs and reports on Cognos environment.
• Monitoring of all servers and monitoring of scheduled jobs on production server.
• Expertise in resolving the issues occurs on servers by logging and checking through log activities.
• Providing security through Access Manager(LDAP) and also providing security through Cognos Namespace.
• Resolving Data level security issues.
• Created Data sources in all environments and also ODBC connections for that Data sources.
• Resolving security issue to user due to individual Transformer, FWM tool security activities.
• Dealing with Data base whenever there performance is required.
• Increasing the size of Memory on server with the help of Data base team.
• Monitoring and Performing the Site scope and Solar winds performance activity for Status of performance and memory used on all servers.
• Expertise in Down time and up time activities on all servers in required queue system.
• Expertise in taking Content Manager and Metric Studio schema backups.
• Expertise in upgrading and Installation of Hot sites on all the servers for performance issues.
• Involved in upgrading of reports and concept of reports in report studio.
• Involved in various Development activities of reports in report studio.
• Active performance on Change Request activities in Cognos Environment.
• Communicating with Users and Developers regarding there status of issues.
• Resolving various kind of Remedy tickets and Incidents.
• Refreshing Java Metrics status in Cognos Configuration on required servers.
• Communicating with Windows OPS team when ever it is required.
• Monitoring Citrix servers and fixing the issues occurs on servers.
• Monitoring Task Manger activities.
• Performed Unit testing for all developed reports.
• Updating the KPI and Owners of KPI’s in Metric Studio. Expertise in Data loading jobs from Staging to EPM content store.

Environment: Cognos 8.3 (Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Connection, Cognos Configuration, Access Manager), Metric Studio, SQL Server 2005, Windows XP, Cognos Prod servers, Citrix servers, Cognos QA and DEV servers, Site scope, Solar Winds, Installations of Hot sites, ETL.

Confidential, Wilmington, DE

Cognos BI Developer

Responsibilities:

• Communicated with business users on requirements gathering
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created model using SQL Server 2005 as Data Source
• Upgraded model and reports from Cognos 8.4 to Cognos 10
• Created security at package level, object level in model and security to package in cognos connection.
• Created stored procedure Query Subject in Frame Work (FM) model.
• Created Report Using SQL code in Report Studio.
• Created Adhoc reports based on user requirements using Query Studio.
• Created Managerial reports like List, Crosstab by using Report Studio.
• Created Drill through reports and Conditional Formatting by using Report Studio.
• Involved in deploying packages and reports from Dev to QA.
• Involved in Resolving the Performance issues of the Reports.
• Testing the report and the validity of the data it retrieves from the database.
• Verification of the data in the back end database.

Environment: Cognos 10/8.4, (Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Connection, Cognos Configuration, Access Manager), SQL Server 2005, Windows XP.

Confidential

Cognos Developer

Responsibilities:

• Analyzed & defined customer requirements/ specifications & offered solutions to fit the customer’s need.
• Designed Reports and security using Cognos Administrator.
• Created standard filters, calculation, prompts, and conditions.
• Published reports to the upfront web portal to provide accessibility to the staff.
• Created cascading prompts in Impromptu reports to help users refine their search.
• Created Drill-Through reports to provide users with more detailed information.
• Published Impromptu Web Reports using Distribution Shuttle Builder created posting folders.
• Developed reports for purchase orders, sales orders, and goods issued and goods receipt.
• Coded database procedure to calculate average purchase price of material for current financial year for costing purpose.
• Used Java scripting in executing the queries and upfront.
• Trouble shoot and evaluated report effectiveness by tuning query data’s and controlling user access.

Environment: Cognos (report studio), Testing, Unit testing, MS SQL Server, Java scripting, MS Excel, MS Visio, UNIX and Windows.