PROFESSIONAL SUMMARY:

• Over 8+ years of experience in IT includes extensive Functional and Technical experience in Data Modeling, Business Intelligence (BI), Customer OLAP Product development and Reports Generation.
• Expertise in Financial, Pharmaceutical, Government and Health care Domains.
• Expertise in leading projects across all phases of the Project life cycle (SDLC).
• Involved in gathering and Creating of Business requirements, Documentation, Technical HLD and LLD’s
• Expert in Business Intelligence Applications using Cognos Tools such as Cognos 8 - 10BI, Report Net (Framework manager, report studio, query studio, Event Studio and Analysis studio).
• Involved in Installation, Configuration, and Administration of Cognos BI version10.1,8.4and 8.3
• Experienced in developing and maintaining Dashboards based on OLAP Cubes designed on Powerplay Transformer .
• Experienced in product upgrades/Fixes/ and Migrations across various BI platforms Specializing in IBM Cognos.
• Extensively used Framework Manager, various Authoring studios (Report, Query, Analysis and Event Studio), ad-hoc reporting and used advanced authoring modes for offline reporting, Mobile reporting, Insight Advance and Dashboards .
• Exposure to client interaction and user-requirement analysis.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all business levels.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.
• Mentored and trained functional users for the successful execution of the project.
• Involved in designing of Relational and Multidimensional databases and Cubes.
• Experience in writing and debugging Index views, stored procedures and triggers.
• Knowledge and understanding of Oracle Database Installation, Configuration, Support, Space management, User management, Backup, Recovery, Oracle Net and Performance Tuning in and all support environments
• Experienced in various database client tools such as Toad for SQL server, Oracle, IBM Data Studio, SQL.
• Experience in SQL development, analysis and tuning skills.
• Expertise in version upgrades and migrating Impromptu Catalogs, PowerPlay Cubes, and ReportNet reports into Cognos 10
• Experienced in Cognos Administration, content Security and user access management within IBM Cognos
• Expertise in providing simple to complex solutions and working with the end users to completely satisfy their needs
• Extensive knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Proficient in development, execution and maintenance of Test plans, Test cases, Test scripts, Test specifications and Test scenarios. Solid analytical and dynamic troubleshooting skills.
• Expertise in Manual and Automation testing using Mercury Interactive Tools QuickTest Professional, Winrunner and Quality Center.
• Performed Functional, GUI, Regression, End-to-End, User-acceptance and Integration testing.
• Good knowledge of Front end testing and Back end testing.

TECHNICAL SKILLS:

BI Tools: BI Systems: IBM COGNOS v8.4 - v10.2 (Framework Manager, Report Studio, Metric Studio, Event Studio, Analysis Studio), Crystal Reports, Business Objects

Other: Management Tools, Server Administration Tools, Configuration Manager, Scheduler. COGNOS

PowerPlayTransformer, PowerPlay User, PowerPlay Web Reports, PowerPlay Enterprise server, Upfront Administration, Access Manager, LDAPServer, Configuration Manager.

Operating Systems: Windows 95/98, Windows 2000/XP/2008, LINUX

Languages: SQL, PL/SQL, MDX, HTML, XML, XHTML, java, UNIX shell scripting

Databases: Oracle 11g/10g, Microsoft SQL Server 7/2000/2003, 2008 R2, DB2, Teradata

Software Packages: MS-Office, Microsoft Word, Excel, MS Access and Power Point

Testing Tools: Quick Test Professional, Win Runner, Quality Center

Browsers: Internet Explorer 9.0, Firefox 16.0.2, Chrome 23.0, Netscape Navigator 4.0

PROFESSIONAL EXPERIENCE:

Confidential, Downtown, NYC

Senior Cognos Consultant

Responsibilities:

• Involved in providing both business and technical expertise in the requirements gathering, report design, report development, and support of all client/server layers and components of the data warehouse.
• Used JavaScript in order to provide additional capabilities such as dynamic sorting and list checkbox selection.
• Involved in creating an ad-hoc query model for query studio users. Created and published various packages to meet different requirements.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Used Cognos Connection for organizing,security, scheduling and distributing reports.
• Worked on Dashboard reports.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Built reports with focus on optimization: used indexes on tables and made recommendations for summary tables where needed.
• Responsible for writing various documentations like technical specifications document, report specifications document and user manual.
• Designed and developed Framework model to better suit complex report development using Oracle as backend.

Environment: Cognos 10.1 BI (Framework Manager, Report Studio, Query Studio, Analysis studio, Event Studio, Cognos Connection), Oracle, SQL Developer,, Microsoft Excel

Confidential, East Hanover, NJ

Senior Cognos Consultant

Responsibilities:

• Gathered and analyzed requirements directly from the business users.
• Used Report Studio to build multi-page, multi-query reports against multiple databases.
• Expertise in creating Standard, List, Cross tab and Master Detail reports.
• Investigated join issues in the Frame Work Model and worked along with the data modelers in resolving the issues for better report functionality.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Incorporated calculations in the model, and used them in report for faster performance.
• Created filters within the Model for improving the performance of the Model.
• Developed Prompt pages and Conditional Variables.
• Developed, Customized and Busted Reports using Report Studio.
• Scheduled reports thru Schedule Management and Assigned user privileges using Cognos Connection.
• Deployed the final product and set the report output requirements.
• Attended User Acceptance sessions, and worked on the feedback from the business users.

Environment: Cognos 10 (Query Studio, Report Studio, Analysis Studio, Cognos Connection, Framework manager), Oracle, PL/SQL Developer, Microsoft Excel, Windows XP .

Confidential, Brooklyn, NY

Senior Cognos Consultant

Responsibilities:

• Work with back office operations teams, project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Developed complex reports and analytics to meet the needs of business analysts.
• Updated business logic on various reports based on loan officers’ feedback
• Fixed numerous production bugs in report studio
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Extensive use of Drill-through reports
• Involved in designing and creating various projects in Framework Manager.
• Participated in JAD Sessions provided the session Deliverables to the client for the approval.
• Created complex reports based on business user requirements.

Environment: Cognos 8.4 BI, Framework Manager, Oracle 10G, Windows 2000, MS Excel and Word.

Confidential, VA

Senior Cognos Consultant

Responsibilities:

• Understanding existing business model and customer requirements.
• Work with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Developed standard reports and analytics to meet the needs of business analysts.
• Proven experience building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Extensive use of master-detail reports using repeater and repeater tables
• Demonstrated the Spec Documents and obtained Sign-off from the Users.
• Involved in designing and creating various projects in Framework Manager.
• Involved in designing Models using Framework Manager.
• Moving applications from one server to other using Deployment Manager
• Involved in setting up sign-on for Groups/Roles to secure the Models and packages.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Experienced in creating security setup in Cognos 8 BI environment.
• Created complex reports based on business user requirements.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Moved projects from development to QA and then Production servers.

Environment: Cognos 8.4 BI, Cognos 8.3, Framework Manager, Oracle 10G, Windows 2000, MS Excel/Word.

Confidential, CT

Q.A Tester

Responsibilities:

• Involved in creating test plan, with the help of software requirement specification (SRS).
• Involved in Inspection, walkthrough reviews of the Documents.
• Responsible for Designing and creating the test cases and test data as per, following the guidelines of testPlan.
• Responsible for set up the test bad,
• Responsible conducting Regression testing,Retesting,BrowserCompatability testing,End to end testing.,Back end testing, Web testing of entire Application.
• Responsible for testing the dashboard gauging the status of the tool.
• Responsible in creating bugs in JIRA.

Environment: Php, Linux,Samba,SQL Server,Jira Bug tracking tool.Microsoft Office.

Confidential, NY/NJ

QA Tester

Responsibilities:

• Test planning, writing detailed test cases/scripts, test case automation and test execution.
• Define and track quality assurance metrics such as defects, defect counts, test results and test status.
• Collect and analyze data for software process evaluation and improvements, and integrate them into business processes to address the needs of the business.
• Document all problems and assists in their resolution.
• Deliver quality process to technical staff and acts as an internal quality consultant to advise or influence business or technical partners.
• Perform quality audits across the various IT functions to ensure quality standards, procedures and methodologies are being followed.

Environment: Quick Test Professional, Quality Center, VBScript, SQL, XML, Oracle, SQL Server 2008, DB2,UNIX, Windows .NET

Confidential, New York, NY

QA Consultant

Responsibilities:

• Assisted in the preparation and execution of Quality Assurance (QA) testing of new or modified applications/systems across multiple computing environments (e.g., host based, distributed systems, client server).
• Participated in the analysis and development of new or revised QA procedures and processes.
• Reported directly to Quality Team Manager.
• Analyzes systems requirements, developed test plans and test scripts, participated in and/or conducted QA Reviews.
• Performed testing activities based upon test plans and scripts.
• .

Environment: Quick Test Professional 10.0, Quality Center 9.5, VBScript, SQL, XML, Oracle, DB2, Rumba, UNIX,