SUMMARY

• 8 years of IT experience in all phases of SDLC
• Extensive experience in Cognos 8.4,Cognos Report Net MR2, Configuration Manager, Access Manager, Report studio,Query Studio, Analysis studio, Frame work manager, Transformer.
• Experience in Health Care, Travel and Entertainment Domain with Accenture
• Experience in Oracle 9i,Oracle 10g and PL/SQL development
• Involved in preparing Functional Documents after gathering the requirement from customers
• Worked on designing, developing, updating and modifying the query subjects in Frame work manager, Transformer and create report using report studio and analysis studio to match the business requirement
• Extensively worked with Stored Procedure Query Subjects in FM and Reports.
• Setting up the security in frame work manager at package level and Query subject level
• Developed List, cross tab, drill through, master - detail, chart and complex reports which involved Multiple Prompts, Conditional formatting, Conditional blocks in Report Studio and used style sheets.
• Securing Cognos Connection and setup Report Net security by assigning users to the groups and roles defined in CognosNamespace.
• Involved in Database and Application servers migration
• Expertise in handling typical technical issues for best performance to meet customer satisfaction.
• Proven track record in coordinating with different stake holders of a project, both from Business (Program Managers, Sponsors) as well as Technology (DBA, BSA)
• Conducted the end-user trainings and created the user help documents
• Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results
• Experience in Reportnet portal installation, administration, maintenance, trouble shooting the portal outage issues within SLA.
• Hands on experience in Star and Snowflake schema design and De-normalization techniques in Data Warehouse concepts.
• Experience in Administration and configuration of IBM CognosReportnet Application Servers, Content Manager, Gateway, and Transformer in Windows virtual server environments.
• Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas..
• Good inter-personal skills and can work efficiently in a team as well as independently
• Excellent verbal and written communications skills and Enthusiastic enough to learn new technologies to cater for organization needs.
• Trained in Business Objects, Informatica, SAP BI/BW.

TECHNICAL SKILLS

ReportingTools: Cognos 8.4, Cognos Report net MR2,Frame Work Manager, Transformer, Configuration Manager, Access Manager, Analysis Studio, Report Studio and Query Studio.

Data Base: Oracle 9i, Oracle 10g, SQL 2000

Tools: Toad 9.1

Operating Systems: Windows 9x, 2000 server, 200x, vista.

Incident Management: Peregrine

ETL: Informatica 8.4(Trained) SAP BI 7.x and 3.x (Trained) SAP BO (Trained)

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

Cognos Developer

Responsibilities:

• Translated the business requirement by interacting with the Business Analyst and developed Technical Specification and Test Case documents.
• Analyze functional and business requirements, managed onsite offshore coordination.
• Implemented quick solutions for different report designs and development issues.
• Created the database views for reports based on the report requirements
• Involved in setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Applied Security in Cognos Connection by controlling privileges for users, groups and roles to the various packages, reports & dashboards.
• Developed List reports, crosstab, Dashboard reports and also created Business Insights in Cognos 10
• Created and updated Multi-dimensional Power Play Cubes Using Transformer.
• Published Power Play Cubes onto Cognos Connection by using Cognos 10 BI Modeling.
• Involved in designing of Relational and multi dimensional databases (star schema and snow flake schema).
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Involved in designing the Drill UP and Drill down reports according to the customer needs.
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Performance tuning by analyzing and comparing the turnaround times between Database and Cognos reports.
• Prepared and executed unit test cases

Environment: COGNOS 10.1, Report studio, Framework Manager, Transformer, Analysis Studio, Oracle 10g

Confidential, Rochester

Cognos Developer

Responsibilities:

• Translated the business requirement by interacting with the Business Analyst and developed Technical Specification and Test Case documents.
• Analyze functional and business requirements, managed onsite offshore coordination.
• Implemented quick solutions for different report designs and development issues.
• Created the database views for reports based on the report requirements
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Involved in designing the Drill UP and Drill down reports according to the customer needs.
• Created HTML Scripts to default the values in the Prompts and also to default the search options for the prompts in Prompt page.
• Performance tuning by analyzing and comparing the turnaround times between Database and Cognos reports.
• Prepared and executed unit test cases

Environment: COGNOS 8.4 Report studio, Framework Manager, Transformer, Analysis Studio, Oracle 10g

Confidential, NY

Cognos Developer

Responsibilities:

• As a Senior Developer - plan and implement Cognos Reporting Solution for Confidential ’s T&E Reporting.
• Provide Production Support for Reporting portal
• Fixing the current report issues as reported in the service management tool
• Analyzed and fixed major issues, concerns and pain points for the reports functionality and performance
• Involved solving issues with in Report net server during unscheduled outages
• Co-ordinate with the Cognos Support in the addition of dispatcher to the existing setup
• Developed Technical Specification and Test Case documents.
• Implemented FM Level Security as Row Level & Data Level Security.
• Implemented Best Practices in Developing Framework Manager Models.
• Proposed and implemented the process to purge key tables, there by increasing the portal performance and reduce in the refresh time with the existing setup.
• Designing and implementing the updated user security set up model.
• Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Securing Cognos Connection and setup Report Net security by assigning users to the groups and roles defined in CognosNamespace.
• Responsible for overseeing the Quality procedures and Software configuration management related to the project.
• Implemented Data Security, Object Security, Package Security and created user classes as per the requirements.
• Update the Ad-hoc reporting model
• Coordinated of client, end users calls and follow ups with respect to the change management and additional requests.
• Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas.
• Production Support which involves solving user problems.

Environment: COGNOS Report net 1.1 MR 2, Frame work manager, Oracle 9i/Toad for SQL tuning efforts, SQL 2000, Perigreen for tracking Issue Resolution

Confidential, NY

Cognos Developer

Responsibilities:

• Analyzed and determined the pitfalls of the existing Reports Requirement functionality
• Created the list of all the query items required for the report and map them from the source
• Involved in project management by interacting with users and prioritized the reports and assisted in creating the development and test plans.
• Designed and created the generic new database structure and updated the Framework model
• Involved in report creation, unit testing and testing support
• Fine tuned the performance of the report by altering the database structure and report structure SQL and Cognos.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of new Reports.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle.
• Developed various reports with calculations, Conditions & Filters, Query Prompts, Prompt Pages,Variables using Cognos Report studio.
• Developed Prompt pages, used Conditional Variables for Conditional Formatting in Report Studio.
• Created Ad-hoc reports using Query Studio.
• Created reports using Filters, multiple Prompts (Select & Search prompt, value prompt, tree prompt) and provided option for Bursting of reports.
• Created drill through to several reports for providing better functionality.
• Implemented tuning settings changes for Cognos query time limit in both Dev and Prod environment as per the user requirement.
• Modified the tuning setting changes for both High affinity jobs and low affinity jobs based on Peak hour times.
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Performance tuning by analyzing and comparing the turnaround times between Database and Cognos reports.
• Created Scorecards and Metrics using Metric studio.
• Created reports in Analysis Studio

Environment: COGNOS Report net 1.1 MR 2, Frame work manager, Oracle 9i/Toad for SQL tuning efforts, SQL 2000 Perigreen for tracking Issue Resolution

Confidential, NY

Cognos Developer

Responsibilities:

• Co-ordinated with the CIT team for the database server setup schedule
• Involved in the string testing for the new database located on M5000 server
• Modified the CognosReportnet setting to point the new data base on M5000
• Created the test matrix and co-ordinate with the testing team for the test results and constantly updated the status to all the stakeholders

Environment: COGNOS Report net 1.1 MR 2 Configuration Manager, Access Manager, Oracle 9i/Toad for SQL tuning efforts.

Confidential, NY

Cognos Developer

Responsibilities:

• Built the prototype successfully by using Oracle Materlizied views and completed all the design documents
• Created the technical documents documenting all the changes at tables, indexes, constrains, materialized view logs, views along with the details of the PL/SQL Package
• Co-Ordinated with DBA’s to ensure the prototype was optimized by creating necessary indexes and constraints
• Created scripts and co-ordinated with the testing team to check the performance
• Involved in Implementation and cut-over activities
• Post Production Performance activities along with performance improvement monitoring

Environment: Oracle 9i and Toad,PL/SQL6.

Confidential, NY

Cognos Developer

Responsibilities:

• Involved in identifying the unused process and objects.
• Designing the optimized approach by applying filters and dropping unused indexes, constrains.
• Worked along with DBA’s to ensure the indexes and primary keys are used while querying the database
• Involved in the design, analysis and coding and testing support.
• Involved in Implementation by making sure all the new indexes and constraints are properly utilized in the new setup
• Creating new dimensional tables to reduce the usage of look up tables

Environment: Oracle 9i aInd Toad and SQL 2000 DTS, Cognos Framework Manager, Cognos Report Studio.

Confidential

Responsibilities:

• Interacted with customers to create business documents converted them to technical documents
• Created and modified stored procedures and packages to view, update and enter the check-in and checkout procedures.
• Optimize the SQL statements using hints.
• Created SQL scripts to tune performances

Environment: PL/SQL, SQL, Toad