SUMMARY:

• 8 years of experience in Information Technology in Design and development of Data Warehouse/BI Applications, BI Reporting, Testing and Production Support on various platforms.
• Experienced in Analysis, Design, Development, Deployment and Support of Business Intelligence applications and Reports.
• Experienced in Quality Assurance with more than 2 years of product quality testing including Test planning, implementation and execution of test cases.
• Experienced in developing interactive applications, dashboards and reports for end business users.
• Worked on wide variety of Reporting tools including SAP BO 4.0, IBM Cognos (8.2,8.3,10.1), Qlikview 11.0 and Qliksense 3.1.
• Fair understanding of Tableau Desktop, Tableau Public and Tableau Server.
• Strong experience in creating and publishing packages in Cognos Framework Manager from various data sources.
• Generated different kinds of reports in Cognos, created templates and parameterized maps
• Strong reporting skills - Drill-Through, Summary Reports, Graphs and Burst Reports.
• Extensive experience in using various Cognos components like Cognos Connection, Framework Manager, Report studio, Query studio for Ad-hoc reporting and Power Play Transformer.
• Knowledge on using power play transformer for building cubes with multiple dimensions.
• Experienced in scheduling reports in IBM cognos connection and troubleshooting any related issues.
• Worked on Report Migrations between different versions of cognos (8.3 to 8.4 and 8.4 to 10)
• Experienced in Extract transform and load data into Qlikview from multiple sources (ERP, salesforce, xml).
• Worked on development and testing of reports using Qlikview 11.0.
• Worked on migration of Qlikview reports from different environments (DEV, TEST, PROD).
• Worked on maintaining existing code and provide support to business users in Qlikview.
• Have knowledge on scheduling of Qlikview reports using QV Publisher and on trouble shooting issues in publisher.
• Strong customer and end user interaction skills.
• Experienced in handling customers from different teams including Finance, Marketing, HR etc.
• Strong interpersonal, written and oral communication skills.
• Experienced in working in a team environment or independently with little supervision.

TECHNICAL SKILLS:

• Data Warehousing and Business Intelligence
• Data Analysis
• Quality Assurance (HP ALM 11.0), JIRA, Test case writing, implementation and execution.
• SAP BO 4.0,4.1.
• Cognos 8.3, 8.4,10 BI suite (Framework Manager, Report Studio, Query Studio, Cognos Connection)
• Qlikview 10.0,11.0
• Qliksense 3.1
• Tableau 10.0
• SQL
• XML

PROFESSIONAL EXPERIENCE:

Confidential

Qliksense Developer /QA

Responsibilities:

• Worked with Fire Team in gathering and analysing requirements.
• Worked in creating Functional Design Documents and converting them to Technical documents.
• Developed QV scripts and reports as per the user requirements.
• Worked with the business users on a regular basis and updated them of the status of the dashboard and received feedback on a regular basis.
• Developed Qliksense objects like straight tables, pivot tables, line charts, Bar charts, Pie charts and buttons.
• Created powerful reports and dashboards in Excel, Power point and PDF.
• Involved in converting existing Qlikview Applications to Qliksense.
• Experienced in trouble shooting data and Report layout issues.
• Used Section access to restrict the user access and made the application available to desired users.
• Participated in Code review and User calls.

Environment: Qliksense 3.1, MS-Excel and Windows 2000, TOAD 9.5, SQL, HP ALM.

Confidential, San Diego

Qlikview Support/QA

Responsibilities:

• Worked with HR Team in gathering and analysing requirements.
• Worked in creating Functional Design Documents and converting them to Technical documents.
• Analysed QV scripts and modify existing QV dashboards as per user requirements.
• Worked extensively in testing Qlikview Reports for different service releases.
• Worked on QV server and publisher to manage user access, schedule refresh of documents.
• Review error logs and provided production support.
• Daily monitoring of QV jobs in Qv publisher and generated daily and weekly reports for the LMS team (Learning management System) of Confidential .
• Experienced in using Excel, DB, Sales Force, SharePoint and xml as sources to Qlikview and pulling the data as per the user needs.
• Involved in managing offshore team members and offshore co-ordination.

Environment: Qlikview 11.0, MS-Excel and Windows 2000, TOAD 9.5, SQL, HP ALM

Confidential, Mount Laurel, New Jersey

QA/UAT Lead

Responsibilities:

• Worked with Business users in gathering and analysing requirements and user stories for a vast web application.
• Created Manual test cases in HP ALM and executed them in the test environment.
• Prioritized User stories and Test cases according to the needs from business users and executed them accordingly.
• Effectively co-ordinated with the DEV team in getting the defects fixed.
• Daily status reporting to higher management on the % of test cases completed and reported issues if any.
• Efficiently managed a team of three in offshore (India).
• Proper planning of release cycle and migration to production environment.
• Provided on call support during and after business hours including weekends if required.
• Provided end user on the applications new features which included fair number of audience from the user group
• Effective in User acceptance testing and post production support.

Environment: Core Java, HP ALM 11.0, SQL, MS-Excel and Windows 2000.

Confidential, San Diego

Cognos/Qlikview Developer

Responsibilities:

• Worked with Business users in gathering and analysing requirements.
• Worked in creating Functional Design Documents and converting them to Technical documents.
• Created Models and Packages using cognos Framework Manager modelling tool.
• Experience in creating User Groups, Roles in Cognos Connection to implement the Security Filters in Framework Manager Model as well as implementing complex filters in Framework manager model.
• Generated various standard reports, List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down, Drill-Through Reports and Master Detail Reports Using Report Studio.
• Involved in the POC of Active reports using cognos 10.1
• Used advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Analyzed the impact on the reports due to the changes in the Source systems.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio
• Developed and supported powerplay cubes using powerplay transformer and involved in Performance Tuning of reports.
• Involved in the migration of the reports from cognos 8.4 to cognos 10.1 version as well as environments (DEV, TEST, PROD)
• Developed reports on top of Netezza database by writing complex views.
• Supported wide variety of Query studio reports by working directly with business users.
• Involved in extensive data, layout, and functionality testing of the cognos reports.
• Developed and supported various Qlikview Reports for Supply chain management as well as finance users
• Developed Shipments Report for Supply chain management users.
• Worked on Development and support of existing Qlikview reports.
• Have worked on migration of Qlikview reports from one environment to other.
• Worked extensively in testing Qlikview Reports for different service releases.
• Educating Business users on how to view the reports from cognos and Qlikview.
• Also prepared documentation of existing cognos and QV reports.
• Experienced in using sales force and SharePoint.
• Involved in managing offshore team members and offshore co-ordination.
• Also involved in the support and requirement gathering for Cognos TM1 9.5 reports and cubes to support wide variety of Finance users and involved in the Month end activities for Finance team.

Environment: Cognos 10.1(Business Insight Advance, Report Studio), Cognos Suite 8.4 (Framework Manager, Cognos Connection, Report Studio, Query Studio) Qlikview 11.0, MS-Excel and Windows 2000, TOAD 9.5, Aginity Workbench 4.1 for Netezza, cognos TM1 9.5

Confidential, Atlanta

SAP BO Developer

Responsibilities:

• Understanding of Universe Design, Development, Alteration, Maintenance using Information Design Tool(IDT) and Universe Design Tool(UDT).
• Applied and used functions such as filters, conditions, sorting etc.
• Created different types of reports, Charts and Master-Detail Reports.
• Involved in the support and issue fixing of existing reports.
• Able to work with cross functional teams with ownership and strong customer focus.
• Provided post-implementation work and on-going production support for the reports developed.
• Worked on ticketing tool Salesforce used to resolve service tickets which are assigned.
• Excellent ability of designing, developing and troubleshooting issues simple to complex reports in SAP BO.
• Expertise in working with Oracle PL/SQL.

Environment: SAP Business Objects 4.0,4.1, Report Net, Design Studio, BEX Analyser, BO Explorer.

Confidential

Cognos Developer/Tester

Responsibilities:

• Analyse the requirement documents and get the requirements clarified with onsite team.
• Generated various standard reports, List Reports, Cross tab Reports, Charts, Drill-Down, Drill-Through Reports and Master Detail Reports Using Report Studio 8.3.
• Implemented Security for Data access, Object level access and Package access.
• Analyzed the impact on the reports due to the changes in the Source systems.
• Modified the Framework Manger Models to in corporate the new data elements.
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports
• Formalized the reporting process by creating the technical specification and requirement specification.
• Created test scripts for unit testing.
• Involved in the migration activities to different environments and post production support.
• Used to maintain good communication with the onsite team and business users.

Environment: Oracle 9i Database, Cognos 8.3, Cognos Framework Manager, Cognos PowerPlay Transformer, Cognos Access Manager, Informatica PowerCenter 8, Windows 2000 Server.

Confidential

Jr Cognos Developer

Responsibilities:

• Analyze the requirement documents and get the requirements clarified with onsite team
• Develop the Framework Manager model using Cognos Framework Manager.
• Supported the finance team by creating reports using Oracle Discoverer plus.
• Develop reports using Cognos Report Studio (Cognos 8.2).
• Involved in performance tuning of the reports.
• Worked with admins to get the lost Framework manger models from cognos connection.
• Developed and coded complex views in database and built reports on top of views.
• Developed Multi page reports and scheduled the reports based on weekly monthly daily basis and made sure that the business users receive them without fail.
• Assignment of developed code for review and incorporating the review comments.
• Create test scripts for unit testing.
• Deploying the code from Development environment to test environment and to production.
• Provide support to the QA team during the QA process.
• Provide maintenance and enhancement support for the deliverables that are being done.
• Experienced in creating Technical documents for the developed reports and code.

Environment: Oracle 9i Database, Cognos 8.2, Cognos Framework Manager, Informatica PowerCenter 8, Oracle Discoverer Administrator, Discoverer Desktop, and Discoverer Plus, Windows 2000 Server.