SUMMARY

• About 13+ years of IT experience in Analysis, Design, Development and Implementation of Data warehousing Projects using Cognos BI Series and ETL Tools.
• Excellent knowledge and hands on working experience with Cognos tools: Cognos Series 8.4, 10.1, 10.2.1, Cognos ReportNet v1.1 MR2(Report Studio, Query Studio, Framework Manager, Cognos Connection) Impromptu, Power Play, Impromptu Web Reports (IWR), Power Play Enterprise Server (PPES), Macros, Upfront, NoticeCast, Access Manager, Visualizer, Cognos Query and Architect.
• Extensive experience in Cognos ReportNet1.1 (MR1, MR2&MR3) (Framework Manager, Report studio, Query Studio).
• Involved in teh installation and configuration of Cognos ReportNet 1.1 (Framework Manager, Cognos Connection, Report Studio and Query Studio) and upgradation of existing Cognos EP 7 series reports to ReportNet.
• Extensive experience in building of multi dimensional Cubes using Cognos Power Play Transformer. Optimized Catalogs using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification.
• Has experience with Business Analysis, requirement gathering, Business Process reengineering. Interfaced extensively with Management, Users and technical teams. Liaison with other project teams and system owners to help define company wide reporting requirements.
• Strong understanding of data relationships and Data Warehousing, RDBMS concepts, SQL, Oracle and SQL Server.
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Developed and published packages using Framework Manager and designed different kind of reports including Report templates, Complex reports, Cross - tabs, Charts, Dashboards, multilingual reports using Report studio& Query Studio in Cognos 8.X and ReportNet versions.
• Good exposure in Relational Databases(Oracle, MS SQL server, DB2 and MS Access) for modeling and for supporting analytical and reporting needs of Corporate Business needs
• A good understanding of Relational Database concepts, including SQL and Query Optimization, with experience in Oracle 9i.
• Extensively worked on Relational Databases like Oracle 10g, 8i/9i, MS SQL Server 2000/2005/2008 Teradata, Sybase IQ and DB2.
• Worked extensively on ERP Applications like SAP ERP (SAP ECC, SAP BW, SAP BI, SAP BO)
• Extensively worked on Data Modeling concepts, including Multi-Dimensional modeling.
• Experience in gathering of end-user business requirements and responsible to provide specific direction, training and mentoring to customers.
• Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills.
• Highly skilled and experienced in Agile Development process for diverse requirements.

TECHNICAL SKILLS

BI Tools: Cognos EP 7.3 series, Cognos Report net 1.1, Cognos Office, MR1, MR2 & MR3, Impromptu, Power Play Transformer, Access Manager, Upfront, IWR, Cognos Query, Architect, PPES, NoticeCast, Power Prompts, Visualizer.

Cognos BI Series 8 (8.1 to 8.4), Cognos 10 series: Cognos Connection, Metric Studio, Query StudioAnalysis Studio, Report Studio, Report StudioEvent Studio, Framework Manager, Metrics DesignerCognos SDK and Cognos 10.1, 10.1.1,10.2, TM1, Advance.

ETL Tools: Data Stage 7.x, Informatica 6.1, SSIS.

ERP: SAP ERP - SAP BW, SAP ECC, SAP BO

Languages: C, C++, SQL, PL/SQL, Oracle, Visual Basic 6.0/5.0.

Scripting Languages: HTML, XML, JavaScript, and VBScript.

Databases: Oracle 7.3/8i/9i, SQL Server 6.5/7.0, DB2, Teradata

GUIs: Developer 2000, Designer 2000 and Visual Basic, SAP BW.

Web/App Servers: Cognos Enterprise Server, Sun One Directory Server, IIS 5.0, Java Web Server, Netscape Directory Server, Web Logic.

DB Tools & Utilities: SQL*Loader, Erwin 3.5 and TOAD, SQL Navigator, Agile/Scrum.

Operating Systems: Sun Solaris 8, HP-UNIX 11/10.2, Windows 95/98/NT/XP, Windows 2000

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Cognos BI/ETL Developer

Responsibilities:

• Designed, Developed and Maintained Cognos Framework Manager to meet teh Standard Reporting and Adhoc Reporting needs.
• Followed design and naming standards in order to ensure consistency from application to application.
• Work closely with Business Users, Platform Team, and Power Users to gather Business and System requirements.
• Conducted Training sessions to teh User groups on Report Views, Scheduling, Query Studio, Business Insight, and Business Insight Advanced.
• Gatheird information, Designed, Developed a Legal Spend Dashboard for teh senior level Managers.
• Used Drill through & parameterized URLS on Cognos Dashboard to point to teh nightly pre run detailed reports.
• Developed reports with Drill through Functionality, Conditional Formatting, Conditional Blocks, Dynamic Grouping and Sorting, Master-Detail.
• Developed Framework Manager Models to show teh date and time columns updated dynamically based on teh User deployed Time Zone using Session Parameter and Oracle Function.
• Modified teh Cascading Style Sheets, system.xml files to give a customized look to teh Cognos environments.
• Automated Complex formula based Excel reports to Cognos Reports.
• Developed dashboard reports and US Financial Lines, UK Claims and Corporate reports.
• Migrated SAP BO report into Cognos reports.
• Developed, and Optimized FL, UK and BIC Model in FM.
• Consolidated multiple details level reports into summary report.
• Customized Reports using HTML and JAVA SCRIPTS.
• Designed models &cubes in Cognos Transformerusing IQD’s fromFramework Manager.
• Developed Legal spend Transformer model to generate various power Cubes and to created reports and dashboard.
• Performed Unit testing on Dev and supported teh users on UAT and Production.
• Developed and Maintained technical documentation of teh implementation.
• Assisted teh users on Production for teh latest enhancements and production fixes.
• Responsible to Manage/track/production issues/document defects and retest defects as needed.
• Automated Legal Spend cube process using shell script and Autosys Process.
• Converted business requirements into source to target mappings to ensure dat data exists to meet teh requirements. Ensured teh Extract, Transformation and Load (ETL) mappings are compliant to teh Enterprise ETL standards.
• Used Informatica (Power Center) tool as ETL tool for constantly moving teh data from sources(DB2, Oracle, Flat Files) into Data service Layer area
• Coordinate with teh Release Management Team during release relates activity into production.

Environment: Cognos 10.2.1 (Framework Manager, Report Studio, Analysis Studio, Transformer), Oracle 10g, DB2, SQL, Informatica, SAP BO.

Confidential, Seattle, WA

Sr. Cognos BI Developer

Responsibilities:

• Creation of functional design documents based on teh user requirements to capture Technical and functional design details of teh reporting application requirement.
• Dimensional reportingon top of SAP BW system using Business Explorer(BEX Queries)
• Creation of Cognos Reports as per user needs based on teh business areas such as Asset Accounting(AA), General Ledger(GL), Account Payable and Accounts Receivables(APAR) and Inventory Monetary Management(IMM).
• Creation of Active reports for building dashboards based on teh daily sales.
• Created Transformer cubes forAd HocReporting.
• Extensive usage of Java Scripts to enhance teh look and feel of teh reporting prompt objects.
• Interact with teh IBM Cognos consultants in resolving teh outstanding issues with our existing system by logging tickets.
• Trained users on using teh Cognos report studio environment and creating Ad Hoc reports for on teh go report requirements.
• Creation ofFM Models based onBW Data sourcesand relational databases.
• Develop macros/create job/event schedules to automate report execution & delivery.
• Deploy /certify teh reports, build complex drill-through using dashboards, scorecards and reports.
• Applied row level security using session parameters.
• Implemented language translation based on teh country as a criterion using Parameter Maps.
• Performance tuningof Dimensional reports for better performance for huge data sets.
• Upgraded reports from Cognos 10.1 to Cognos 10.2.1.
• Collaborated with Data Architect/DBA to develop/optimize teh Star-schema/Snow flake schema model for teh Cognos reporting tools (Report studio).
• Developed Multi page reports with prompt pages, parameter maps and conditional variables according to teh end user requirements.
• Scheduled reports using teh Schedule Management tool, Event Studio in Cognos Connection
• Used HP ALM (application lifecycle system) for risk and issue tracking and production support for teh clients applications.
• Provided training to teh user for teh ad hoc report requirements and usability of teh application.

Environment: Cognos 10.2.1, SAP BW, UNIX, Shell Scripting, Informatica, Teradata, Unix.

Confidential, Wilmington, DE

Sr. Cognos BI /ETL Developer

Responsibilities:

• Involved in teh entire agile development project life cycle from analysis, development, testing, production and end user support, worked closely with business users while gathering requirements.
• Analyze reporting data requirements, data mapping and data source analyzes and design, identify ETL, model issues, missing data etc and worked close with DM/ETL developer to resolve them.
• Developed ETL scripts to extract from flat files and cleanse data then loaded into Oracle databases for Cognos application.
• Created Enterprise-wide Framework Manager Models, Developed multi-dimensional and relational packages using Framework Manager and published packages to Cognos Connection.
• Deploy /certify teh reports, build complex drill through using dashboards, scorecards and reports.
• Develop macros/create job/event schedules to automate report execution & delivery.
• Create/Maintain BI Dev, Test and Production environments, user creations and management, application deployments between servers, change management etc with BI Admin & DW Dept.
• BI Gap analysis, data source study and analysis and data mapping.
• Perform unit testing of all models, cubes, reports, scorecards, dashboards etc developed
• Provided assistance for integration of front end and back end applications
• Created FDIS Sales reports and provided regular updates and maintenance for teh same.
• Develop requirements and subsequent information validation procedures to ensure customer satisfaction and data accuracy.
• Responsible for creating users, groups and roles to manage security of teh reports.
• Distributed Reports through Bursting, E-mail and uploading to folders
• Row level securities has been applied using session parameters and macros in FM.
• Involved inadministrationof reports by assigning appropriate user classes and providing permissions.
• Involved in ETL design for teh new requirements
• Used INFORMATICA (Power Center) tool as ETL tool for constantly moving teh data from sources(SQL Server, Oracle, Flat Files) into DSL (Data service Layer) area
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, Connected and unconnected lookup, Normalizer and Router.
• Wrote Shell Script to Load history data. and other Shell Scripts to handle inbound and outbound files.

Environment: Cognos 8.4 BI, Cognos 10.1.1, Report Administration, Access manager, upfront, Oracle 10g,UNIX,Shell Scripting, Informatica, Teradata, Unix.

Confidential, Warren, NJ

Sr. Cognos BI Consultant.

Responsibilities:

• Independently and as a member of a development group, performs system analysis, design, programming, testing, documentation, installation, user training and system maintenance and support.
• Consults with user management and staff throughout all stages of teh development cycle to ensure dat systems achieve teh user’s business objectives.
• Creating and documenting BI report specifications with detailed database mapping and made Necessary changes in teh DWH structure
• Collaborated with Data Architect/DBA to develop/optimize teh Star-schema/Snow flake schema model for teh Cognos reporting tools (Power Play and Report studio).
• Created Enterprise-wide Framework Manager Models, Developed multi dimensional and relational packages using Framework Manager and Published packages to Cognos Connection.
• Consolidated multiple individual Credit risk reports into standard reports based on specification, functionality, complexity and performance.
• Improved teh performance and usability of teh reports by creating appropriate prompts and filters.
• Developed Multi page reports with prompt pages, parameter maps and conditional variables according to teh end user requirements
• Involved in teh Administration and implementing Security.
• Involved in Migration of reports, packages from 8.4 to Cognos 10.1.1.
• Scheduled reports using teh Schedule Management tool, Event Studio in Cognos Connection
• Involved Cognos Security, user roles and groups in 3-tier environment and administered teh Cognos Access manager user access, adding new users and modifying teh existing user access
• Developed Models and packages according to teh business users’ specifications and assigned object level and data level security.
• Created teh Business view and database view structures for teh better use of query studio users.
• Creating User Classes and restricted teh user access with teh help of User Class Privileges.
• Responsible for teh delivery of solution-oriented complex reports using Report Studio.
• Used SQL Profiler monitor Performance of Queries and to index teh Tables.
• Used JIRA for risk and issue tracking and production support for teh clients applications.
• Ability to train/teach others on teh use of all Cognos functions - including Power Play, Framework Manager, Queries, Reports, Scheduler, etc.

Environment: Cognos 8.4 BI, Cognos 10.1.1, MS SQL Server 2005 and SQL Navigator, SSIS, MS

Confidential, Parsippany, NJ

Sr. Cognos BI Developer/ SSIS Developer

Responsibilities:

• Created complex reports using Report Studio and Ad-hoc web based reports using Query Studio.
• Involved in Relational and Star schema database design and loading data.
• Designed Standard List Reports, Cross-tab Reports, Charts, Master-Detail and Drill through Reports using Report Studio.
• Created complex Dashboards using Cognos connection like displaying Cognos navigator, Cognos search & Cognos viewer in a single page.
• Deploying teh Reports, Packages & dashboards from testing environment to production environment.
• Validated multiple FM packages & ETL Business rules.
• Developed metadata models with appropriate Joins, organized Folders according to teh Business view and published teh packages using Framework Manager onto Cognos Connection.
• Extensively used Microsoft Share Point for issue tracking purposes.
• Applied Security in Cognos Connection by controlling privileges for users, groups and roles to teh various packages, reports & dashboards.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Created custom templates and updated teh default XML code in teh Cognos install files to show teh Template in welcome screen of Report studio.
• Created Users, User Classes in Access Manager.
• Optimizing teh complex reports developed in Report studio.
• Used advanced report options like Table of contents, Reference objects & Report Bursting etc.

Environment: Cognos 8.4 BI, Cognos 10.1, MS SQL Server 2005 and SQL Navigator, SSIS MS

Confidential, New Brunswick, NJ

Sr.Cognos BI Consultant/ Metrics Developer

Responsibilities:

• Performing business analysis, requirement gathering and design functional, technical specifications, balanced scorecard concepts, build scorecard structures, metric status, and stage data for teh metric store and develop reporting management, business intelligence solution to meet business needs.
• Applied techniques and modeling approaches to minimize SQL generation.
• Created complex reports like Multi page report, Drill through reports, Drill through from analysis studio report to RS report, reports with complicated SQL queries, Repeater reports and Different kinds of chart reports.
• Created metrics designer object extracts; derive metrics, metric types, formula based calculation metrics, score card structures, timeframes and loading extracted data into metric store database and then migrate teh data into metric studio.
• Created SQL scripts to load teh data from staging data mart to metric store staging tables
• Used SQL scripts in SSIS ETL package to generate metric related objects likes scorecards, metric types, metrics, groups and associated values
• Involved in database work such as writing teh complex SQL queries to track teh issues, creating tables, indexes, triggers, constraints, sequences and altering teh tables.
• Implemented database and reporting solution using SQL, MDX.
• Responsible for assisting with projects development with European business partners, understanding their development methodologies and practices and converting teh European prototype to meet North American Standards.
• Monitored and administered Cognos BI Series 8.4 Servers (Remote Servers) for their performance and tuned teh performance using teh metrics in Cognos connection.
• Developed impact diagrams, performance graphics and related metric reports and organizing metrics by strategy maps and groups.
• Configured authentication & authorization related security groups and roles in Cognos connection administration for metric related packages and reports for deploying metric related web content.
• Trained end users on teh use of metric applications such as Cognos metric functions, metric related queries, reports, scheduler, scorecards and dashboards etc.
• Set up Cognos Security, user roles and groups in 3-tier environment and administered teh Cognos Access manager user access, adding new users and modifying teh existing user access.
• Provided Cognos On-Call Technical support for international users (India, Belgium).
• Used share point portal for deploying teh Cognos reports for end user access.

Environment: Cognos 8.4 BI, Cognos7.3, Oracle9i&10g, TOAD, MS SQL Server 2005 and SQL Navigator, SSIS, MS Access

Confidential, Southfield, MI

Sr.Cognos BI Consultant/ Metrics Developer

Responsibilities:

• Designed & created scorecards and dashboards using Cognos Metric Studio, Report studio (Cognos 8.3 Series) and also determined teh trend.
• Generated various types of reports like Dashboard, List, Grouped, Crosstab, Chart, and Drill -Through, master details reports using Cognos BI Series 8.3.
• Created Enterprise-wide Framework Manager Models, Developed multi dimensional and relational packages using Framework Manager and Published packages to Cognos Connection.
• Collaborated with Data Architect/DBA to develop/optimize teh Star-schema model for teh Cognos reporting tools (Power Play and Report studio).
• Created Metric packages and used them for Dashboard reports creation using Metric Studio.
• Created derived metrics and metric types, formula-based calculated metrics. Created Metrics Designer objects extracts.
• Executed and published extracts, loaded data from a relational database. Organize metrics by strategy, groups. Create performance graphics using diagrams, Passed Metric Studio parameters to a Cognos 8 reports. Add Metric Studio content to teh portal
• Migrated Power Play cubes into Cognos Connection.
• Developed logical, physical data model by defining strategy for star schema with Fact, Dimension tables using Cognos Power Play.
• Developed Power Play Transformer model to generate various power Cubes.
• Installed and Configured Cognos 8.3 on multiple servers, maintained development server and deployed report applications into teh production server in UNIX environment.
• Installed Cognos Office connection and configured it for teh users to work with teh data.
• Provided training for business users on Cognos 8.3 MR2 Analysis Studio, query Studio and responsible to provide specific direction, training and mentoring to Business users.
• Created Oracle materialized views, stored procedures and database packages for reporting data.
• Exposure to web infrastructure technologies (Portals, firewalls, networking, etc.).
• Organize and post web content, apply appropriate role security in Cognos Connection Administration.
• Involved in setting up Groups/Roles to secure teh Models and packages.
• Performed Cognos configuration, administration and system performance.

Environment: Cognos 8.3 BI, Cognos7.3, Unix, Oracle9i&10g, TOAD, SAP BW, MS SQL Server 2000 and SQL Navigator, Data Stage, MS Access, Essbase.

Confidential, Pittsburgh, PA.

Cognos Upgradation Consultant/Developer

Responsibilities:

• Performed Analysis on existing Cognos 7.3 reports to explore them with teh new capabilities of Cognos 8 BI.
• Business Analysis and Reports Requirement Gathering, designed functional specifications and technical specifications.
• Migrated impromptu catalogs and reports using teh utilities.
• Resolved all errors generated during migrations, re-formatted reports to match with Impromptu reports and validate teh report by using QA Testing.
• Generated various types of reports like Dashboard, List, Grouped, Crosstab, Chart, and Drill -Through, master details reports using Cognos BI Series 8.2 for different functional areas like Supply chain, Transportation etc.
• Prepared teh documentation on catalog analysis to analyze teh catalog and report specification.
• Created teh new reports when it requires after migration.
• Developed Cognos Power Play Web reports to replace existing Excel reports.
• Created Models, Packages and Importing Meta data using catalog.xml file in Framework Manager.
• Created various types of Filters Model Filters, Query Filters, Detail filters and Summary Filters.
• Responsible for documenting migration strategy, standards and best practices, and additional functional and technical specifications for upgrade from Cognos Series 7 to Cognos Series 8.
• Resolved several Critical issues occurred after migration - like incorrect sort orders, failure of JavaScript customizations, layout issues, CSS issues and SDK application issues
• Worked with Cognos Security portal and SDK.

Environment: Cognos 8 BI, Cognos7.3, Oracle9i, TOAD, MS SQL Server 2000 and SQL Navigator.

Confidential, Las Vegas, NV

Cognos consultant

Responsibilities:

• Business Analysis and Reports Requirement Gathering.
• Developed Dashboard reports for Retail sales and Hotel Management Phase.
• Designed functional specifications and technical specifications.
• Prepared teh physical layout diagram of Hotel Management.
• Involved in Data Modeling and Data Quality Analysis.
• Created ‘Drill Through’ for navigation between Cubes and reports in Analysis Studio.
• Built Power play Transformer models combining data from corporate data store and transactional database.
• Created and maintained scripts to build and refresh Power Cubes on Windows server.
• Created Models, Packages and Importing Meta data using Framework Manager.
• Migrating Power play cubes in to Cognos Connection.

Environment: Cognos ReportNet 1.1(MR1/MR2), Cognos Series 8.0, SQL, PL/SQL, Analysis Services 2005,SSIS.

Confidential, San Diego, California

BI Report Developer

Responsibilities:

• Involved in installation and configuration of Cognos Report Net 1.1 MR2.
• Involved in creating teh Model and Package using Framework Manager.
• Daily execution of teh project, issue escalation, work allocation, review of deliverables and quality assurance.
• Communicated with teh business users to comprehend teh requirements.
• Designed Cognos Transformer cube models using reports modeled according to user needs.
• Involved in administration, development and support of existing & new (20+) Catalogs and query definition files using various joins and filtering conditions using Impromptu administrator.
• Designed and developed Cubes for Sales, Sales and Inventory, Inventory, Stock Ledger.
• Created customized BI reports linking various databases, to meet teh user requirements.
• Developed numerous sophisticated drill-through Power Play and ReportNet reports.
• Developed Templates, standard Reports, Master Detail Reports, Bursting Reports using Report Studio and Query studio.
• Defined user access and user classes for different user groups, to provide security using Access Manager.
• Developed Integration System Test cases and Unit Test cases for assigned work units.

Environment: Cognos BI Series 8, Cognos Report Net 1.1 MR2, Cognos 7.3, Oracle9i, TOAD, MS SQL Server 2000 and Win2k.

Confidential, New York, NY

Cognos Report net Consultant

Responsibilities:

• Involved designing of Functional Requirement Specifications for report development, defining relationships between different database tables and building models using Framework Manager.
• Involved in installation and configuration of Cognos Report Net Server 1.1.
• Prepared teh Estimation of Efforts for teh Development of Cognos Report Net Reports.
• Involved in Creating Package for report generation using Framework Manager Module in ReportNet. As a part of Package development, created views, different query subjects, cardinalities.
• Security was built in to system to access information, depending teh type and roles of users.
• Created power play cubes, reports, publish Impromptu reports, Power Play Cubes, reports, publish Framework Manager Models.
• Analyzed, evaluated ReportNet, its components against Cognos Impromptu for feasibility of migrating Impromptu catalos/reports to ReportNet.
• Resolved all errors generated during migrations, re-formatted reports to match with Impromptu reports.
• Created, modified, published Framework Manager Models on ReportNet Server.
• Developed logical, physical data model by defining strategy for star schema with Fact, Dimension tables using Cognos Power Play.
• Published Power Play Cubes, Reports to Upfront using Power Play Enterprise Server.
• Primary support representative responsible for handling and resolving reporting issues related to existing data warehouse environments.
• Testing, improving Performance of different types of reports.
• Conduct code and QA review sessions with development team.

Environment: Cognos Report Net 1.1 MR2, Oracle 9i, Cognos Impromptu 7.3, Cognos Power play 7.3 (Windows / Excel / Web), Access Manager 6.5, IWR Server 7.2, ETL Informatica 6.1, MS Access 2000, SQL Server 2000.