Summary:

• Having 10 years of total IT industry experience analysis, design, testing, development and implementation of client/server applications
• Proven experience at building, motivating and leading professional teams, managing projects and supporting client relationships.
• Extensive experience in Data Warehousing projects, preparation of data dimensioning, physical data modeling, Logical Data Modeling.
• Having 9 years of experience with Cognos Tools such as Cognos Suite, Report net 1.1.MR3, Cognos Impromptu 7.x/6.x, Cognos IWR 7.x/6.x and Analysis Tools such as Cognos Transformer Power Play 7.x/6.x, Access Manager and Server Installation Maintenance.
• Sound Knowledge on Cognos 10.1, Cognos 8.4 BI Suite framework Manager, Cognos connection, Report Studio, Metric Studio, analysis Studio and Query Studio .
• Hands on Experience with Framework Manager Modeling Physical Layer, Business Layer, Packages and Complex Report building with Report Studio.
• Sound Skills on Developing Score Card Applications using Metric Manger and Metric Studio.
• Sound Skills on Dash Board Report building using Report Studio and Analysis Studio. Experience on Custom Java Script in Report Studio Reports.
• Strong Experience in Cognos TM1 9.5.1 TM1 Architect, TM1 Excell, TM1 Web, TM1 Executive Viewer .
• Strong ETL Experience with Data Manager, Decision Stream, Informatica.
• Extensively involved in Cognos Production Support, Tickets, Patches, Hot Fixes.
• Good Experience with MDX Functions in Report Studio using Multi-dimensional Sources.
• Strong Knowledge with Transformer model design and Power play cube building.
• Strong Experience on SQL, Pl/SQL while validating data, writing SQL Scripts.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Capability of creating different types of prompts and cascading prompts using prompt pages, Master Detail Relationships and also applied conditional formatting for reports in Report Studio
• Experience in creating Dashboards using Report Studio, Business Insight and Business Insight Advanced
• Experience in creating ad-hoc reports using Query Studio, Analysis Studio and Business Insight Advanced
• Experience in creating reports using proven and best practice methods
• Working knowledge on Data warehousing concepts
• Strong knowledge in data bases like Oracle 11g, MS SQL Server SQL and PL/SQL stored procedures
• Competency in documenting functional and technical requirements for the BI reports
• Experience in providing extensive end user training and support
• Proficiency in analyzing the report specifications and identified the source data systems
• Experience in designing Logical database using ERWIN for BI report support systems
• Ability to work in teams and take prompt decisions
• Highly motivated, diligent and a quick learner

Work Experience:

Lead Cognos Report Developer

SunGard, Wayne, PA

March 2010 to till date,

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Design development of the reports using Cognos 8 Report Studio, Analysis Studio reports
• Design development of multiple reports using various templates like list reports, cross-tab reports and chart reports
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Extensively worked with Stored Procedure Query Subjects in FM and Reports.
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Design and Developed the Framework Manager models and Published into server.
• Developed Report Studio and Analysis Studio Reports in Cognos 8 portal
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Coordinating with Development Team tasks Deliverables and working on high priority issues.
• Migrated Crystal web portal application using Cognos 8 BI Java SDK
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Worked with users and business analysts to define reporting requirements for various services and processes using Cognos BI 10.1 Cognos connection, Query Studio, Business Insight Advanced, Business Insight and Report studio
• Used several reporting packages to produce and automate defined reports
• Developed standard report templates using Report Studio and Business Insight Advanced
• Developed List reports, Charts, Drill Through reports, Master Detail reports using Report Studio and Business Insight Advanced
• Created calculations, filters and prompts in Report Studio reports
• Distributed and scheduled reports based on frequency Daily, monthly etc. in Cognos 10.1
• Responsible for creating ad- hoc reports for business users
• Developed Master Detail reports and list reports using report studio
• Unit testing of reports done through querying from different database tables as per the requirement
• Created different joins and unions in reports using report studio.

Environment: Cognos 10.1, 8.4 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio , Cognos TM1 9.5.1, SAP R4, SAP HRMS, SQL Server 2005, Oracle 9i, DB2 Cognos Access Manger, Windows 2003 Server.

Cognos Report Developer

Confidential

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Design development of the reports using Cognos 8 Report Studio, Analysis Studio reports
• Design development of multiple reports using various templates like list reports, cross-tab reports and chart reports
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Design and Developed the Framework Manager models and Published into server.
• Developed Report Studio and Analysis Studio Reports in Cognos 8 portal
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Migrated catalogs and reports from Cognos 7.3 to Cognos 8.2 and CRN Reports to Cognos 8.2.
• coordinating with Development Team tasks Deliverables and working on high priority issues
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Extracting data from tables and formatting and populating files for validation.
• Write and troubleshoot SQL queries and stored procedures.
• Developed complex DMR and relational models in Framework Manager Model
• Developed dimensional reports using multidimensional data sources Cubes and DMR in Report Studio.
• Primary development resource participating in core development activities including the creation of data models, application code, on-line help facilities and test plans.
• Responsible for contributing to the development of system documentation including scoping, requirements specification, system design and user documentation necessary for development projects.
• Upgrading existing reports into new, more reliable and user friendly environment.
• Assess and propose solutions to improve the performance of report outputs by recommending changes to the data warehouse and/or Data Mart.
• Devise strategies for ETL load, Data migration Integration Building Meta data models
• Understand the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimization.
• Assist in Data analysis, Data modeling, Database design, Data migration, and Business intelligence solutions.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio
• Processing data available in Message Queues, Flat Files and Relational Databases
• Generated complex reports in Cognos 10.1.1 report studio including Drill Down reports from DMR modeled Framework model
• Translate user requirements into technical specifications that describe program development, data modeling, coding, testing, changes and corrections
• Assist in development of new products and enhancements for existing products
• Responsible for clearly communicating technical material, either orally or in writing, to technical and non-technical audiences.
• Created Dashboards to present critical company data in a single report and deploy company dashboard in mobile application.
• Building Reports, Dynamic Dashboards, Scorecards.
• Used IBM Cognos BI Suite including use of Framework Modeling, Active Reports, Transformer Cubes, Report Studio, Query Studio, Analysis Studio
• Worked on Excel macros for data extraction.
• Work with QA team to create and/or validate system acceptance and user acceptance test plans and test scripts to ensure error free delivery of tools and reports as required
• Distributed reports to various agents using Bursting.
• Used IIS Internet information server web server for configuration and management
• Experience in developing Framework Manager Models and analyzed those models in analysis studio

Environment: Cognos 8.2 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio , Siebel, Oracle 9i, Cognos Access Manger, Windows 2003 Server. Cognos BI suite 10.1 Frame work manager, Cognos Connection, Report Studio, Query Studio, Business Insight and Business Insight Advanced , Power Play Transformer, Oracle 10g.

Project Name: Global Trade Reporting

Cognos Report Developer

Confidential

Responsibilities:

• Created Framework Manager models/packages Relational and Dimensional using single and multiple databases
• Developed Data Layer, Business layer and Presentation Layer, with appropriately defined relationship and cardinality between query subjects maintaining data integrity in Framework Manager
• Generated ad-hoc Reports using Query Studio and Analysis Studio
• Created Parameters, Prompt Pages using various Prompt types Value, Text Box, Date, Select Search, and Interval Prompts on the reports
• Created report templates using Report Studio
• Developed reports using List, Crosstab, Chart and Repeater Table
• Created complex calculation on query items and applied various filters like detail and summary filters to report queries
• Created conditional formatting in Report Studio
• Created Drill-through connection to link different Reports, Book Marks and Conditional Block Lists
• Created stored procedures using Oracle PL/ SQL
• Provided support training to business users and partners in Report Studio and Query Studio
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Design and Developed the Framework Manager models and Published into server.
• Developed IQD's from Framework Manager and Published into the Network.
• Design and Developed Transformer Models and Cubes as sources of Metric Extracts.
• Developed Metric Extracts in Metric Designer as a Cube Sources.
• Developed Scorecards, Metric Types and Metrics in Metric Studio.
• Loading data into Metric Studio from Cube Sources.
• Provided Drill - Through from Metric studio to Report Studio Reports
• Developed Drill reports from Report Studio to Analysis Studio Reports and vice versa.
• Developed Report Studio and Analysis Studio Reports in Cognos 8 portal
• coordinating with Development Team tasks Deliverables and working on high priority issues
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Responsible for interfacing with other department teams i.e. Development, Technical, Customer Service, Training and Quality Management and/or vendors to support existing and new applications, products and tools.
• Designing and developing ETL strategies using SQL Server Integration Service SSIS
• Generated Complex reports in Cognos 10.1.1 report studio including Drill Down reports from DMR modeled Framework model
• Used advanced features like Conditional Formatting in Report Studio in generating multipage Reports
• Provide payroll solutions streamline for payroll process, improve productivity and simplify administration
• Provide training sessions and materials, and knowledge transfer, increase understanding of programming techniques and design principles.
• Created 3 different reports that included report functionality such as prompt pages, cascading prompts, conditional filters etc.
• Worked with List Reports and various formats of report generation e.g., PDF, XML etc.
• Assisted with SQL and procedural SQL in SQL Server and Teradata
• Implemented data warehouse concepts, methodologies and infrastructure including dimensional data modeling, change data capture, data quality, operational data stores, data warehouses, Meta data management, data marts and business intelligence reporting platforms.
• DBMS indexing and partitioning schemes to identify and optimize performance of ETL and BI reporting layers.
• Identify and resolve a wide variety of database problems
• Migration of reports and catalogs from Cognos series 8.4 to Cognos 10.1.1
• Data warehouse design build experience including star schema and data modeling
• Enterprise data modeling layers including presentation, logical, and physical Mapping Data Elements from various data sources
• Implement security at Package level, Object level, Data level using Framework Manager
• Ensure timely and thorough issue escalation and resolution as well as strict adherence to all project milestones and deadlines
• Develop Framework Manager Models and analyzed those models in analysis studio.
• Created sophisticated Reports and Portal page Dashboard reports by using Report Studio
• Created Dashboards to present critical company data in a single report
• Created list reports cross tab reports Active reports by using Cognos 10.1.1
• Distributed reports to various agents using Bursting.
• Used IIS Internet information server web server for configuration and management
• Migration of reports and catalogs from Cognos series 8.4 to Cognos 10.1.1
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio

Environment:

Cognos 8.4/10.1.1BI, Cognos Connection, Cognos office Connection, Report Studio, Business Insight, Business insight Advance Query Studio, Analysis studio, Frame Work Manager, SQL Server, SSIS, XML and Windows XP, Cognos BI Suite 8.4 Framework Manager, Query Studio, Report Studio, Power Play Studio, Access Manager , Oracle 11g, Toad, SAP BW, Windows

Project Name: Rebates and Chargebacks, Cognos 8.2 Suite Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio , DB2, Oracle 9i, SQL Server 2000, Cognos Access Manger, Windows 2003 Server.

Sr. Cognos Consultant

Confidential

Responsibilities:

• Involved in Requirement gathering from Business Users.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Design development of the reports using Cognos 8 Report Studio, Analysis Studio.
• Design development of multiple reports using various templates like list reports, cross-tab reports and chart reports
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.
• Installation and Configuring the Cognos 8.2 suite.
• Design and Developed the Framework Manager models and Published into server.
• Developed Report Studio and Analysis Studio Reports in Cognos 8 portal
• Co-facilitate client workshops and training, typically small to medium group of clients.
• Migrated catalogs and reports from Cognos 7.3 to Cognos 8.2 and CRN Reports to Cognos 8.2.
• Providing Report and Query Studio access to DAG Super Users, Developers, and Sustain groups to continue ongoing report development
• coordinating with Development Team tasks Deliverables and working on high priority issues
• Testing reports using review checklists for Quality Assurance before delivering to the end users.
• Involved into move to Deployment to UAT and Production.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Gathered functional requirements from analysts.
• Mentored and trained technical staff to enhance their Cognos BI competency level
• Created user groups and roles using Cognos Administrator
• Published multiple Cognos Framework Manager packages using data level and user level security
• Developing, customizing, and testing reports using the Cognos 8.3 and 8.4 BI tools
• Created Trend line and Combination charts and dash board reports using life science data in Report Studio
• Prepared necessary project related documents for reporting
• Designed customized welcome page using portal tabs in Cognos Connection
• Created complex reports using Cognos BI 8.3/8.4 Report Studio and Ad-hoc web based reports using Cognos 8.3/8.4 BI Query Studio
• Tested and validated the report output against the database to measure performance of reports
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query in Report Studio
• Created Scheduled Jobs by scheduling multiple reports in a job
• Created conditional formatting in Report Studio
• Created report templates using Report Studio
• Created Drill-through connection to link different Reports, Book Marks and Conditional Block Lists
• Implement security at Package level, Object level, Data level using Framework Manager
• Installed and configure the Cognos 8.4.
• Gathered and analyzed business requirements from users and business community.
• Ensure timely and thorough issue escalation and resolution as well as strict adherence to all project milestones and deadlines
• Modify and develop the queries used in the Ad Hoc environment Query Studio that will be used to access data from Oracle and SQL Server data structures.
• Serve as a technical resource for other members of the development team to ensure that data processing standards, guidelines, and procedures are practiced.
• Work with QA team to validate system acceptance and user acceptance test plans
• Developed UML Diagram following all phases of SDLC.
• Tested the created reports by executing the Test Scripts
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3
• Upgraded reports from 8.3 to 8.4.
• Created Cash Product Dashboard reports to present critical company data in a single report using Cognos 8 metric studios.
• Used some advanced features like Conditional Formatting in Report Studio in generating multi page Reports.
• Used Conditional blocks and conditional variables for generation of reports.
• Manually modified the SQL in Report Studio to tune and/or to write reports.
• Develop Framework Manager models both Relational and Dimensional DMR modeling
• Develop models using prompts and filters.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management.
• Worked with List Reports and various formats of report generation e.g., PDF, XML etc.
• Monitoring Cube updates, monitoring the performance of the Power Play cubes, Star Schema, Snow Flaks Schemas

Environment:

Cognos 8.4BI, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, ORACLE, .net, SQL, PL SQL, Web logic , HTML and UNIX, Internet Information Service, Microsoft SQL Server Integration Services SSIS , Cognos 8.3/8.4 Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Metric Studio and Transformer , Cognos SDK, JavaScript and HTML, Oracle 10i, Data Stage 7.5, Teradata, Windows XP Professional, XML and HTML.

Cognos Developer

Confidential

Responsibilities:

• Analyzed different business intelligence solutions satisfying client requirements
• Understand and develop database views/ ETL for FPS Applications.
• Analyzed and documented the requirement the client system for creating financial reporting packages.
• Coordinated oracle BI financial reporting implementation project for medical services company
• Prioritized development stages based on report groups and data sources.
• Developed business model with dimensions, hierarchies, metrics, aggregation, time series based on financial reporting package requirements.
• Verified data integrity between source systems and BI data marts based on aggregation rules.
• Created functional design specification to be used by database/repo preparing low level design documents in the design phase.
• Performing impact analysis of the requirements for existing applications.
• Categorization of defects and analysis using causal analysis tool.
• Created catalogs with the help of Impromptu utilizing relational databases.
• Developed impromptu reports with various functionalities Drill - through, Cascading prompts .
• Created templates utilizing Impromptu, Created ad hoc reports utilizing Cognos Query.
• Created user prompts, conditions and filters to improve report generation.
• Created hierarchies to provide drill-down options for end-users.
• Created Power Play cubes using Power Play Transformer to permit multi-dimensional cross sectioning and drill down analysis.
• Coordinated training sessions and demonstration of Cognos tools to end-users.
• Used various OLAP query/reporting tool to maximize or reinforce the data delivery function in a data warehouse environment.
• Provided support to projects for new applications / report needs.

Environment: Cognos 8.1, Oracle 10i, SQL Server 2005, Oracle 7.3/8.1, PL/SQL, MS SQL Server 7.0, ODBC, Cognos Transformer 6.x, Impromptu 6.x, Power Play 6.x, Cognos Upfront, Microsoft Access and Adobe Acrobat.

Additional Information:

• Operating Systems: Windows 2003 Enterprise Server, XP, 2000, UNIX
• Databases: SQL Server2005, Oracle 9i/10g, DB2
• Cognos Tools: Cognos Suite, CRN 1.1 MR3, Cognos EP Series 7.3 Power play Transformer, Power play Windows/Web, Impromptu, Upfront and Metric Manager, Metric Studio , SDK
• Servers: Application Servers WAS, Tomcat , Web Servers IIS, IHS
• OLAP/BI Tools
• Cognos BI Suite Cognos Connection, Report Studio, Query Studio, Business Insight, Business Insight Advanced, Analysis Studio, Framework Manager and Administration
• Databases Oracle 11g /10g/ 9i, SQL-Server MS-Access
• Programming Languages PL/SQL