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 the 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.
• Have 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 the 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 the User groups on Report Views, Scheduling, Query Studio, Business Insight, and Business Insight Advanced.
• Gathered information, Designed, Developed a Legal Spend Dashboard for the senior level Managers.
• Used Drill through & parameterized URLS on Cognos Dashboard to point to the 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 the date and time columns updated dynamically based on the User deployed Time Zone using Session Parameter and Oracle Function.
• Modified the Cascading Style Sheets, system.xml files to give a customized look to the 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 the users on UAT and Production.
• Developed and Maintained technical documentation of the implementation.
• Assisted the users on Production for the 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 that data exists to meet the requirements. Ensured the Extract, Transformation and Load (ETL) mappings are compliant to the Enterprise ETL standards.
• Used Informatica (Power Center) tool as ETL tool for constantly moving the data from sources(DB2, Oracle, Flat Files) into Data service Layer area
• Coordinate with the 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 the user requirements to capture Technical and functional design details of the 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 the 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 the daily sales.
• Created Transformer cubes forAd HocReporting.
• Extensive usage of Java Scripts to enhance the look and feel of the reporting prompt objects.
• Interact with the IBM Cognos consultants in resolving the outstanding issues with our existing system by logging tickets.
• Trained users on using the Cognos report studio environment and creating Ad Hoc reports for on the 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 the reports, build complex drill-through using dashboards, scorecards and reports.
• Applied row level security using session parameters.
• Implemented language translation based on the 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 the Star-schema/Snow flake schema model for the Cognos reporting tools (Report studio).
• Developed Multi page reports with prompt pages, parameter maps and conditional variables according to the end user requirements.
• Scheduled reports using the Schedule Management tool, Event Studio in Cognos Connection
• Used HP ALM (application lifecycle system) for risk and issue tracking and production support for the clients applications.
• Provided training to the user for the ad hoc report requirements and usability of the 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 the 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 the 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 the 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 the reports.
• Distributed Reports through Bursting, E-mail and uploading to folders
• Row level securities have 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 the new requirements
• Used INFORMATICA (Power Center) tool as ETL tool for constantly moving the 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 the development cycle to ensure that systems achieve the user’s business objectives.
• Creating and documenting BI report specifications with detailed database mapping and made Necessary changes in the DWH structure
• Collaborated with Data Architect/DBA to develop/optimize the Star-schema/Snow flake schema model for the 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 the performance and usability of the reports by creating appropriate prompts and filters.
• Developed Multi page reports with prompt pages, parameter maps and conditional variables according to the end user requirements
• Involved in the Administration and implementing Security.
• Involved in Migration of reports, packages from 8.4 to Cognos 10.1.1.
• Scheduled reports using the Schedule Management tool, Event Studio in Cognos Connection
• Involved Cognos Security, user roles and groups in 3-tier environment and administered the Cognos Access manager user access, adding new users and modifying the existing user access
• Developed Models and packages according to the business users’ specifications and assigned object level and data level security.
• Created the Business view and database view structures for the better use of query studio users.
• Creating User Classes and restricted the user access with the help of User Class Privileges.
• Responsible for the delivery of solution-oriented complex reports using Report Studio.
• Used SQL Profiler monitor Performance of Queries and to index the Tables.
• Used JIRA for risk and issue tracking and production support for the clients applications.
• Ability to train/teach others on the 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 the 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 the Business view and published the 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 the various packages, reports & dashboards.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Created custom templates and updated the default XML code in the Cognos install files to show the Template in welcome screen of Report studio.
• Created Users, User Classes in Access Manager.
• Optimizing the 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 the 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 the data into metric studio.
• Created SQL scripts to load the 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 the complex SQL queries to track the issues, creating tables, indexes, triggers, constraints, sequences and altering the 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 the European prototype to meet North American Standards.
• Monitored and administered Cognos BI Series 8.4 Servers (Remote Servers) for their performance and tuned the performance using the 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 the 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 the Cognos Access manager user access, adding new users and modifying the existing user access.
• Provided Cognos On-Call Technical support for international users (India, Belgium).
• Used share point portal for deploying the 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 the 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 the Star-schema model for the 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 the 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 the production server in UNIX environment.
• Installed Cognos Office connection and configured it for the users to work with the 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 the 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 the new capabilities of Cognos 8 BI.
• Business Analysis and Reports Requirement Gathering, designed functional specifications and technical specifications.
• Migrated impromptu catalogs and reports using the utilities.
• Resolved all errors generated during migrations, re-formatted reports to match with Impromptu reports and validate the 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 the documentation on catalog analysis to analyze the catalog and report specification.
• Created the 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 the 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 the Model and Package using Framework Manager.
• Daily execution of the project, issue escalation, work allocation, review of deliverables and quality assurance.
• Communicated with the business users to comprehend the 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 the 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 the Estimation of Efforts for the 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 the 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.