SUMMARY

• 9+ years experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, and Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Finance, Insurance, Retail, Networking and Manufacturing
• Proven experience at building, motivating and working under professional teams and supporting client relationships
• Experienced in implementing large - scale applications with leading technologies in Business Intelligence and involved in complete software development life cycle (SDLC)
• Handling complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management
• Very Good experience on Cognos Tools - Cognos 10 Suite (Framework Manager, Cognos Cube Designer, Report Studio, Analysis Studio, Workspace Advanced, Event Studio and Cognos Connection), Cognos 8.4 (framework Manager, Report Studio, Metric Studio, Power Play Studio and Query Studio), Cognos Reportnet 1.1 Mr3, Cognos EP Series 7.3(Impromptu, IWR, Power Play Transformer and Power Play Windows/Web, upfront)
• Experience in reports migration from Cognos impromptu 7.3, Cognos 8 and Business Objects to Cognos 10.2.1
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio
• 1 plus years of extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0 and 8.1 as a Developer and Analyst. Excellent knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Sound Skills in Report Development, Modeling (Relational, DMR) in Cognos 8.
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional specifications
• Good understanding of ETL tools like Data Stage on of Cognos reports, cubes, and decision support applications using Cognos series 8 business intelligence tools.
• Experience in Troubleshooting Cognos problems and tunes for performance
• Extensive experience in Multiple Relational Databases including SQL SERVER and ORACLE
• Experience with Oracle PL/SQL Stored Procedures, Functions, Cursors and Triggers
• Experience in Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers
• Expertise in OLTP/OLAP/OOAD System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling
• Excellent Presentation and communication skills, Team Player, Quick learner, Organized and self-motivated. Enthusiastic to learn new systems and technologies and fast adaptability to new platforms and environment

TECHNICAL SKILLS

Reporting Tools: Cognos BI Suite 10.x /8.x/7.x (Workspace Advanced, Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manager, PowerPlay Transformer) ReportNet 1.1, IWR, Upfront, Business Objects XIR2 (Designer, Desktop Intelligence), Tableau (Tableau Desktop, Tableau Reader and Tableau Server)

Databases: Oracle 10g/9i, MS SQL Server 2000/7.0., Sybase 12.5, Netezza

Data Modeling: Erwin, Microsoft Visio.

Oracle Tools: SQL*Plus, Toad, SQL*Loader, PL/SQL Developer, WinSql.

Languages: C, C++, SQL, PL/SQL Programming, Visual Basic.

Operating Systems: Windows98/2000/NT/XP, Unix/Linux, Sun-Solaris, Mac OS.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Cognos Developer

Responsibilities:

• Worked closely with the users, business analysts in gathering requirements, developing prototypes, getting the BRD approval and participated in project meetings.
• Involved in ETL Mapping Team discussions to solve the issues in mapping document or design.
• Worked as a part of sprint team in agile methodology.
• Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
• Worked on integrating Cognos with java application using SDK for running and archiving reports for different submissions.
• Developed Cognos dashboard report to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis on Digital Marketing data, Finance data.
• Created sophisticated dashboard reports for various reporting requirements like using legacy charts for the ECOMM dashboard reports.
• Created multi page reports by using Cascading prompts, conditional formatting and page rendering.
• Modified Cognos reports with rearranging the columns, editing the filter criteria, adding new fields for Outlet Integration project.
• Tested and validated the report output against the database to measure the performance of the reports and data validation.
• Involved in writing, analyzing SQL queries using Aginity Netezza Workbench.
• Worked closely with users understanding their adhoc needs and developed packages accordingly
• Assisted QA team in documenting and analyzing their current process and then make recommendations for improvement in their functional areas.
• Scheduled reports to run on weekly basis using Cognos connection scheduler

Environment: Cognos 10.1.1(Framework Manager, Report Studio, Analysis Studio, Query Studio, Business Insight Advanced, Business Insight), Web Sphere application server, JSP, HTML, Java, Shell Script, Netezza, Linux 5.4.3

Confidential, NJ

Sr. Cognos Developer

Responsibilities:

• Involved in requirements gathering from business users, report design, report development, and support of all client/server layers and components of the data warehouse.
• Worked on developing Cognos Framework models with segmentation, branching and complex object level security based on user requirements.
• Design & development of the reports using Cognos Report studio, Analysis Studio, Query studio, and Event Studio.
• Responsible to build the Framework Manager Models and packages as per the business requirements.
• Developed Complex dashboard reports for various reporting requirements and also created multi page reports by using Cascading prompts, conditional formatting and page rendering.
• Tested and validated the report output against the database to measure performance of reports.
• Built DMR and Cubes in Transformer using IQDs, packages, reports, etc., as a data source.
• Identified various dimensions and measures required for the generation of a cube.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created rich dashboards using Tableau Dashboard
• Exposure on Cognos development Software development kit like SDK to customize reports.
• Involved in the Installation of Cognos components in various environments.
• Involved in move the developed reports from Dev to UAT and UAT to production.

Environment: Cognos 10.2.2(Framework Manager, Report Studio, Analysis Studio, Query Studio, Workspace Advanced, Workspace), Web Sphere application server, JSP, HTML, Java, Shell Script, Oracle 11g, MS SQL Server 2008, Linux 5.4.3, Tableau 8.0

Confidential, NJ

Sr. Cognos Developer

Responsibilities:

• Gathered report requirements from Business Users and converted them in to technical documents
• Added new tables, worked on cardinality, folder structure, filters and security for Framework manager model
• Created and modified reports with additional prompts, report columns and conditional variables to support user requirements with the merge.
• Worked on java script to clear prompt parameter selection between prompt pages, switch between prompt radio buttons based prompt values and validation of the report based prompt values.
• Worked cube drill through reports with dynamic column selection, cross tab and complex reports with union, join quires in report studio.
• Optimized report SQL queries using Aginity workbench against Netezza database
• Worked closely with user on Cognos workspace advanced training and guidance.
• Developed multiple Cognos workspace advanced reports to support user adhoc requests.
• Involved modifying transformer model data sources from IQD files to framework manager packages
• Developed transformer models with alternate hierarchy dimensions, cube groups and drill through reports.
• PerformedCognosadministrative functions such as creating user accounts, user classes and roles using Access Manager. Deployed models and reports with in Cognos environments.
• Interacting with theEnd userson a regular basis for resolving issues pertaining to the reports

Environment: Cognos 10.2.2(Framework Manager, Report Studio, Analysis Studio, Query Studio, Workspace Advanced, Workspace), Web Sphere application server, JSP, HTML, Java, Shell Script, Netezza, Oracle 11g, MS SQL Server 2008, Linux 5.4.3

Confidential, NJ

Sr. Cognos Developer/Administrator

Responsibilities:

• Gathered report requirements from Business Users and converted them in to technical documents
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
• Developed Cognos Transformer OLAP models and Power Play cubes. Worked on migrating long running Power Play cubes to Cognos Dynamic cubes.
• Developed Dash board reports to display all the information related to environment using summary reports
• Worked with Cognos workspace & Advanced and prepared user guides for the same.
• Experienced on working with performance issues with the reports.
• Installed Cognos on distributed server’s architecture. Involved in Cognos upgrade from 10.2.1 to 10.2.2.
• Maintained User security using third party tool (Security Studio). Worked on folder level and data level user security.
• Promoted packages to production using Import/Export utility. Created and maintained Cognos jobs
• Interacting with theEnd userson a regular basis for resolving issues pertaining to the reports
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support

Environment: Cognos 10.2.1(Framework Manager, Report Studio, Analysis Studio, Query Studio, Workspace Advanced, Workspace), Web Sphere application server, JSP, HTML, Java, Shell Script, Oracle 11g, MS SQL Server 2008, Linux 5.4.3

Confidential, NY

Sr. Cognos Developer

Responsibilities:

• Gathered report requirements from Business Users and converted them in to technical documents
• Involved in designing multiple metadata models (Relational and DMR) in Framework Manager while following best practices and specific corporate standards.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting
• Created Report Reference, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization
• Trained the end users to effectively use the reporting tool like Cognos Workspace Advanced to build and customize their ad-hoc reports
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.
• Assisted Quality Assurance Team in documenting and analyzing their current process and then make recommendations for improvements in their functional areas
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support

Environment: Cognos 10.2.1 (Framework Manager, Cognos Cube Designer, Report Studio, Analysis Studio, Query Studio), Cognos Power Play Transformer, HTML, Java, Oracle 11g, MS SQL Server 2008, Linux 5.4.3

Confidential, NY

Sr. Cognos Developer/Administrator

Responsibilities:

• Analyzed Business requirements from the analysts
• Involved in Designing models using Framework Manager and deployed packages to the Cognos Connection
• Implemented Framework manager security for Data access, Object level access and Package access
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various business’s needs (Folders, Filters, and Macros)
• Upgraded Framework Manager Models, Transformer Cubes from Cognos Version 8.4 to 10
• Involved in Cognos Migration project from Cognos Impromptu 7.3 to Cognos 10.2.1 Migrated Impromptu catalogs, IMR and PPX reports to Cognos 10.1.2.
• Migrated Powerplay stuido reports to Analysis studio reports, assisted user in understanding analysis studio features
• Involved in complete project life cycle for migrating Business Objects Universe and Deski reports to Cognos 10.2.1
• Purchasing, Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it. Embedded Tableau views in to SharePoint.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP - ROLAP)
• Refreshed and supportedCognosPower Play cubes. Designed batch jobs to automate cube build process.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Deploying models and reports from Development to Production and administering users/groups/roles
• Prepared User documentation to train users and functionality of each report

Environment: Cognos 10.2.1/8.4 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos Power Play Transformer v7.4, Access Manager, BO XIR2, HTML, Java, Oracle 11g, MS SQL Server 2008, Linux 5.4.3

Confidential, NJ

Business Data Analyst/Cognos Developer

Responsibilities:

• Gathered report requirements from Business Users and converted them in to technical documents
• Involved in creating User groups, Roles and implementing security across the organization
• Created Database view and Business view for better understating of the model and help users with Ad-hoc reporting
• Experience in setting up the Publish containers and publishing the data depending on the dimension for reporting requirements
• Developing Framework manager packages and modifying the existing ones for use in building various reports
• Created several different types of Professional Reports (Mailing Labels, Cascading, Linked /Drill Through, Production, Business, Ranking, etc…) with complex formatting utilizing Report
• Worked closely with business users while gathering requirements, analyzing data and supporting existing reporting solutions
• Created tables and imported data into tables using TOAD. Effectively worked on SQL query optimization techniques to reduce Cognos report running time.
• Created and maintainedCognospackages in Framework Manager. Designed production rollout process forCognosapplications
• Promoted packages to production using Import/Export utility. Created and maintained Cognos jobs
• PerformedCognosadministrative functions such as creating user accounts, user classes and roles using Access Manager
• Created documentation of installations and developments at all stages of the project

Environment: Cognos 10.x, Series 10 Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric designer, Metric Studio, Event Studio, Cognos7.1, PowerPlay Transformer, Oracle 10.2, TOAD, DB2, Windows 2003 Server, IIS, Active Directory

Confidential, NY

Cognos Developer

Responsibilities:

• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager
• Developed customized packages to be used by the query studio users, as per the business specifications
• Enhanced the existing models and reports for better representation, better formatting, performance and new requirements to end users.
• Implemented Row Level security using predefined Peoplesoft tables in framework model.
• Experience in distributing reports using bursting, email, scheduling.
• Performance tuningby analyzing and comparing the turnaround times betweenSQL andCognos
• Creating User Classes and restricted the user access with the help of User Class Privileges.
• Created the documentation for all the developments and Installations.
• Interacting with theEnd userson a regular basis for resolving issues pertaining to the reports
• Involved in the end user training sessions on Query studio, and Cognos Connection.

Environment: Cognos 8.3 BI, Series 8 Framework Manager, Report Studio, Query Studio, Analysis Studio, Oracle 9i, TOAD, Windows 2003 Server, Windows 2000 Server, IIS, Active Directory Server

Confidential, NY

Cognos Developer

Responsibilities:

• Analyzed Business requirements from the analysts
• Customized Cognos Connection with appropriate reports and security measures
• Discussed with clients about their present reporting system and understand their current reporting issues to meet their needs
• Demonstrate the flexibility of Cognos using Cognos Report Studio, Analysis Studio and how
• Performed the distributed installation and configuration of Cognos 8.3 on new servers in Production, Testing and Development environments.
• Built new packages using Cognos Framework Manager and converted the existing reports from Excel to Cognos reports using Cognos Report Studio.
• Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager in Report Net
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database
• Built Power Play Reports based on the cubes and published to Report Net Server
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various business’s needs (Folders, Filters, and Macros)

Environment: Cognos 8.3/8.2 /8.1 BI, Cognos 8 Framework Manager, Report Studio, Cognos Decision Stream Analyst, Transformer, TOAD, Oracle 10g,MS SQL server, Windows XP

Confidential

Cognos Report Net Developer

Responsibilities:

• Gathered business requirements from users and understanding the report specifications
• Created relationships in Framework Manager Model and established cardinalities to suit business needs.
• Worked on Cognos components Report Studio, Query studio and Cognos connection
• Set up drill through reports to provide users with detailed information using Impromptu Administration.
• Developed multi-dimensional analysis and business reports using PowerPlay Transformer.
• Created Ad-hoc reports via Cognos Impromptu
• Developed standard reports and dash boards
• Tested and improved report performance. Also, provided technical support for users.
• Created Power Play secured models using PowerPlay Transformer
• Published Impromptu reports and PowerPlay cubes using Cognos Report Net and Power Play Transformer respectively.

Environment: Cognos Report Net 1.0(Cognos connection, Framework Manager, Query Studio, Analysis Studio), Access Manager, Power Play Transformer 7.3, Impromptu 7.3 and Oracle 10g, MS-Excel, PL/SQLTOAD v8.5