SUMMARY:

• 15 years of experienced IT professional with 11 years of experience in Architecture, design, development, and implementing Data Warehouse and Business Intelligence solutions.
• Expertise and hands on experience include implementation of Data Warehouse and Business Intelligence projects using Cognos Suite (10.x, 8.x, ReportNet, 7.x, 6.x) of Tools, MicroStrategy, Epiphany 6.0.5, Informatica & decisionStream 7.1.
• Fortune 100 company experience.
• Extensive data warehousing/business intelligence development and architecture experience.
• Extensive experience deploying and supporting large, complex data warehouse/business intelligence solutions.
• Extensive experience in deploying and supporting large, complex data warehouse/business intelligence solutions (full life cycle).
• Expertise in Data modeling (Entity - Relational and Dimensional).
• Expertise in Design and development of OLAP modeling for analysis.
• Expertise in implementing template based, parameter driven reports to minimize the no of source reports.
• Expertise in developing Data marts using Cognos DecisionStream.
• Hands on experience with installation, configuration and administration of Cognos suite of products.
• Hands on experience with automation, scripting, and extending of Cognos reporting functionality.
• Extensively used Informatica Workflow Manager and Workflow Monitor for creating and monitoring workflows, worklets and sessions.
• Strong experience with Oracle, SQL Server, DB2 (SQL DDL, Performance Tuning).
• Industry focus on Health Care, Real Estate & Pharma, have been over the years involved in projects to provide technology based solutions for major global firms.
• Lead teams in capacity of project lead, tech Lead with team sizes ranging from 5 to 15 with responsibilities including estimations, delivery, architecture, quality management and project management.
• Mentoring the team members regarding both technical & functional aspects.
• Experience in simultaneously handling teams from multiple locations onsite /offshore.
• Experienced in provide training for client users and new recruits and contribute towards Data Warehouse and BI practice development activities.

TECHNICAL SKILLS:

BI Tools: Cognos 10.2.1,10.2, 10.1.1 & 8.4, Cognos Insight 10.2, Cognos Metric studio tool, Cognos TM1 10.1.1, Cognos ReportNet 1.1 MR2, Cognos Series 7, Cognos 6, Micro Strategy Desktop 8.0 and Micro Strategy Web, BRIO, IBM Cognos Mobile,Tableau.

ETL Tools: Cognos Decision Stream 7.1, Informatica - Power Center/Power Mart 6.1, Epiphany 6.0.5DataStage 7.5

CRM: Siebel 7.5.2, Siebel 7.5.2 Tools, Siebel VB, eScript, Smart Script, Siebel Sales, Siebel Marketing, Siebel Call Center, Workflow Manager, EIM, EIA, ERM

Operating Systems: AS400, Windows NT, MVS, UNIX

Databases: Oracle 9i/8i, SQL Server, DB2,Netezza

Date Modeling: Erwin, Kalido 8

Languages: Visual Basic, Java Script, HTML, Java, COBOL, Perl, CGI, CICS, JCL

Web Servers: IIS, Proxy Server, Exchange Server

Tools: Front Page, Excel VBA

PROFESSIONAL EXPERIENCE:

Confidential, Roseland, NJ

Cognos/ BI Architect

Responsibilities:

• Responsible for Cognos Framework Manager dimensional multi-layer metadata modeling for Dashboards including implementing custom aggregation rules.
• Developed dynamic dashboard reports using parameter maps and macros.
• Implemented row level security using parameter maps by generating dynamic where clauses.
• Analyzed the report queries and optimized the queries for report performance improvement.
• Tuned the report queries using QFS, Coordination plan query analysis.
• Implemented a template based, parameter driven approach for minimizing the no of source reports.
• Developed complex DMR models and reports using MDX functions and dynamic drill reports in report studio.
• Integrated cognos reports using iframes with application using parameterized URLs.
• Report views shared with other applications using CMS call references like HTML fragments &XML, JSON datasets.
• Involved in performing data analysis and developing reporting specs
• Expertise in Cognos report writing/designing and support business team to ensure successful build
• Involved in gathering and prioritization of business requirements to support an organizational analytics strategy and deployment.
• Analyzed and evaluated the new and existing environments.
• Responsible for preparation of detailed upgrade plan and setting up 10.2.1 environment
• Responsible for cleanup of content store using Content Manager size tool
• Used Lifecycle manager tool to test reports and identify issues between two versions.
• Interacted with admin team and responsible for setting of other environments (QA & PROD).
• Designed a plan to adopt and incorporate new cognos BI features in environment.
• Responsible for updating/providing new features of tool to business users.
• Involved in analyzing end user requirements and developing reports/dashboards.
• Involved/Assisted in troubleshooting post-production performance issues.
• Development and testing of new Cognos reports based of design specifications
• Responsible for migrating objects between environments.
• Developed different types of Trend and bubble charts with DMR and relational models.
• Developed multi page reports with blocks and conditional highlighting using conditional variables.
• Developed active reports using tab and check box group objects and distributed reports to users through email.
• Responsible for segmenting the active reports data over cards.
• Involved in optimizing the data deck queries.
• Setup drill through functionality between active reports.

Environment: Cognos 8.4.2, 10.2.1, Cognos Active reports, IBM Cognos Mobile, Oracle 10g, UNIX shell scripting, Informatica.

Confidential, Warren, NJ

Cognos/ BI Architect/ Lead

Responsibilities:

• Developed dimensions and cubes using cognos TM1 architect.
• Expertize in writing Turbo Integrator processes for integrating with DBs and Metadata management.
• Responsible for TM1 modeling security and integrated TM1 with LDAP.
• Responsible for supporting user report building activities using TM1 excel and active forms.
• Responsible for Cognos TM1 Code deployment to QA and Production environments.
• Tuned the TM1 performance tuning using modeling techniques (feeders).
• Responsible for writing TM1 rules to perform various business functions such as Fx calculations, risk reporting.
• Integrated TM1 application with existing Cognos 10.1.1 BI application
• Setup drill through between TM1 cubes by specifying drill assignment rules.
• Used Rules tracer to analyze the performance of feeders implemented.
• Involved in requirements gathering and technical design of mart for risk reporting.
• Implemented scheduling of TI processes using Chores
• Responsible for designing the metadata model for different reporting models.
• Responsible for conversion of Oracle reports into Cognos report studio reports.
• Created multiple cubes as per the requirements and developed reports on top of cube/dmr data models.
• Held responsible for creating iqd queries for building the models using cognos transformer.
• Responsible for tuning the performance of cubes.
• Fixed the issues which were existing with migrated dynamic reports.
• Implemented security at cube level as per the process and business requirements.
• Responsible for designing Transformer Models for corporate data for building Multidimensional Cubes.
• Designed dashboards based on power cubes, relational and dimensional models.
• Involved in developing the cognos reports using DMR/Cube models.
• Responsible for developing the complex reports using MDX queries in report studio.
• Responsible for unit testing, successful migration and Go-Live of Cognos8.
• Responsible for setting up security based on user credentials in cognos Transformer.
• Experience with Cognos upgrade from Cognos 8.3/8.4 to Cognos 10.1.1/10.2.
• Designed complex cubes using cognos 10.1.1 transformer.
• Tuned the transformer models using partition strategies.
• Automated the transformer cube refresh process end-end.
• Designed a Dynamic query model using cognos 10.2 Dynamic query designer for complex modules part of POC
• Designed adhoc dimension models using business Insight for business use.
• Trained business on using Cognos business Insight for adhoc reporting.
• Created in-memory queries using 10.2 dynamic query designer.
• Successfully tested the in-memory cubes for performance gains.

Environment: Cognos 8.4.1, 10.1.1 & 10.2,Cognos business Insight, Oracle 10g, Cognos Transformer 7.3, 8.4.1, 10.1.1, Cognos TM1 10.1.1, PeopleSoft EPM 8.9 & UNIX shell script

Confidential, Hartford, CT

Cognos/ BI Architect/ Lead

Responsibilities:

• Responsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiatives
• Involved in requirement gathering and converting functional requirements into technical specifications.
• Responsible for analyzing business requirements and developing appropriate system architectures
• Responsible for analysis and design of tech specifications after discussion with business.
• Built multi fact, multi grain star schemas at using Cognos metadata modeling tool.
• Responsible for fixing the multi fact granularity issues using determinants.
• Worked closely with technical teams and business users of the data warehouse/business intelligence environments
• Built multi fact models in such a way to pull latest attribute in all reports.
• Performed Analysis on existing Cognos 7.3 reports to explore them with the new capabilities of Cognos BI.
• Business Analysis and Reports Requirement Gathering, designed functional specifications and technical specifications.
• Resolved all errors generated during migrations, re-formatted reports to match with Impromptu reports and validate the report by using QA Testing.
• Prepared the documentation on catalog analysis to analyze the catalog and report specification.
• Created the new reports when it requires after migration.
• Created Models, Packages and Importing Meta data using catalog .xml file in Frame work Manager.
• 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.
• Involved in designing materialized views where necessary to improve report performance.
• Created multi tab excel reports as per requirement.
• Analyzed application, quality, and data integration problems, provided solutions and recommend corrective actions.
• Involved in building the complex reports like dynamic display attribute and measures for different entities of Confidential .
• Involved in performance tuning of reports by analyzing the queries and requirements at report level.
• Held responsible for setting up security for Cognos reports as per the organization needs.
• Responsible for unit testing, performance tuning, enhancement analysis and bug fixing of reports.
• Built complex Dashboard reports using multiple queries and other Cognos tools like conditional block and variables.
• Involved in building cubes for different entities by creating IQD’s at FM level.
• Responsible for preparing effort estimate and Defect Causal Analysis.
• Involved in installation and configuration of Cognos8 in multi system environments
• Migrated Cognos 8.3 environment to 8.4.
• Administered the Cognos jobs and Schedules periodically for different entities.
• Managed dispatchers and their associated services using Server Administration Tool.
• Responsible for unit testing, successful migration and Go-Live of Cognos8.
• Involving in QRM related activities and took the responsible for quality deliverables
• Implementing different levels of security at FM as per user requirements.
• Developing the simple to complex reports using Report Studio.
• Responsible for building Dashboard reports by highlighting opportunity values above or below threshold values.
• Responsible for setting up the Cognos system configuration to improve the performance by setting different server settings.
• Streamlined and automated reporting processes in order to achieve higher efficiency.
• Developed dashboard reports for key performance indicator monitoring using metric studio tools.
• Developed metric extracts in metric designer as a cube sources.
• Developed Scorecards, Metric Types and Metrics in Metric Studio.
• Partner with internal customers on developing report specification and documenting data definitions
• Provided ongoing support of the EDW environment as well as continually reevaluate current processes and techniques for increased accuracy, efficiency, and maintainability.
• Involved in defining the Listeners to copy the first and last copy of each report to local file system
• Responsible for bug fixing of defects during system/integration testing and for delivery of objects.
• Managing scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in Cognos8.3.
• Implemented the security by using bursting functionality of Cognos8.
• Responsible for knowledge transfer, user training documentation and training.

Environment: Cognos 7.3, Cognos 8.3/8.4, Cognos Metric Studio tools, IBM DB2, Cognos Transformer 7.3, BRIO, DataStage 7.5

Confidential, Ohio

Asst Manager/ Cognos

Responsibilities:

• Gathered the user requirements from end users and worked on designing the Metadata Models in Framework Manager and published them to the Cognos connection for the report authors.
• Responsible for setting up business knowledge sharing sessions with business.
• Involved in preparing functional and technical specifications for user requirements.
• Created the technical specifications and the Unit test plans for the ETL builds after analyzing the data model and functional specification
• Developed the ETL builds using Cognos DecisionStream Designer and Unit tested them successfully
• Performed peer review of ETL builds and the mapping documents created by team members
• Created dimension, fact builds and Job Streams.
• Created derivations at Transformation model level.
• Created complex models for cubes and fixed issues raised during externalization of IQD’s.
• Dimensionally modeled the metadata using star schema and allow end users to build their own analysis.
• Responsible for Dimensionally Modeling the data in FM as per requirements.
• Responsible for preparing effort estimate and Defect Causal Analysis.
• Involved in installation and configuration of Cognos8 in different environments
• Involved in preparation of migration plan from CRN to Cognos8.2.
• Administered secured function and features in Cognos 8 that has to be available for users based on the Job title.
• Managed dispatchers and their associated services using Server Administration Tool.
• Responsible for migration of models and reports to Cognos8.
• Identified the issues during migration and fixed them.
• Responsible for unit testing, successful migration and Go-Live of Cognos8.
• Involving in QRM related activities and took the responsible for quality deliverables
• Implementing different levels of security at FM as per user requirements.
• Implementing the Self Service model.
• Developing the simple to complex reports using Report Studio.
• Involved in building complex Dashboard reports using conditional highlighting, blocks & multiple queries.
• Responsible for building Dashboard reports by highlighting opportunity values above or below threshold values.
• Responsible for bug fixing of defects raised during system/integration testing and for delivery of objects.
• Involving in building cubes using query subjects in FM and published them to Cognos8.
• Managing scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in Cognos8.
• Implemented the security by using bursting functionality of Cognos8.
• Responsible for knowledge transfer to support team and user training.

Environment: Cognos8.2/8.3, Cognos ReportNet V1.1, Oracle 9i, Kalido, Cognos Transformer 7.2, DecisionStream 7.1

Confidential, Chicago

Asst Manager/ Cognos

Responsibilities:

• Responsible for gathering requirements from user groups
• Designed the data model and data mart for reporting system
• Responsible for overall technical and functional architecture, efforts estimate and traceability matrix
• Involved in analysis of the requirements, preparing technical spec design and unit test
• Plans/scripts
• Various standard data cleansing operations were performed on the daily extracts and staged in an in house environment.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica.
• Mappings were designed to cater the slowly changing dimensions.
• Maintained Shared Folders and Shortcuts, Repositories and User Security via Repository Manger.
• Worked extensively on the Defect analysis and fixing using Test Director.
• Used various transformations like Source Qualifier, Lookup, Router, Filter, Update, Expression, Aggregator, Sorter, Sequence Generator etc
• Created various tasks like sessions, worklets, and workflows in the workflow manager during development.
• Used Workflow monitor to see the work flows running and get the session properties and session log.
• Developed different types of metrics like simple to compound and prompts based on existing filters.
• Developed new reports and enhanced the existing reports functionality.
• Created Drill Maps for drilling to lowest level as per the business requirements.
• Created reports using Consolidation to meet user requirements.
• Created formatted reports using MicroStrategy Document.
• Supervised report development activities and bug fixes.
• Involved in cause analysis and QRM reviews.
• Involved in peer review of reports developed by peers and unit testing of new reports.

Environment: MicroStrategy 8i, Sql Server 2000, Windows2000, Informatica 7.1

Confidential, Ohio

Asst Manager/ Cognos

Responsibilities:

• Prepared the technical architecture for the Data Warehouse and Business Intelligence systems
• Gathered requirements, analyzed and prepared the project scope
• Documented functional and non-functional requirements
• Prepared Use cases, high-level and low-level design documents for meta data models and reports
• Developed pilot models and ad-hoc queries for proof of concept and better understanding of the user needs
• Involved in the creation of mappings for Extraction, Transformation, and Loading the data.
• Participated in System Analysis Activities for prototyping, design, Case creation.
• Presented Report Options to business based on Requirements.
• Initiated all new projects and was responsible to adhere to the TE Cognos Policies (Vanguard) while design and Implementation.
• Managed and worked along various development teams to deliver on Time.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection in ReportNet
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager in ReportNet
• Published various Packages from Framework manager Models based on the data needs for reports for different departments.
• Developed dynamic client reports by utilizing Developed professional multi-page reports using Report Studio with advanced formatting and features
• Developed complex reports using Tabular Set and Tabular SQL.
• Created Drill Through Reports Using Report Studio.
• Creating Ad-hoc report using Query Studio.
• Provided End User and Support Training

Environment: Cognos 8.1, Cognos ReportNet V1.1, UNIX, Oracle 8i, Kalido, Informatica 7.X

Confidential, NJ

Consultant - Cognos Developer

Responsibilities:

• Interacted with business people for gathering the business requirements
• Designed and developed Catalogs, Impromptu Reports, IQD’s
• Modified existing catalog using Cognos Impromptu
• Developed Power Cubes using Power play
• Extensively used Drill Up/Down, filter, Aggregators, Slice and Dice Operations for all OLAP applications
• Developed various types of reports such as Simple, Crosstab, Drill through, Sub reports etc
• Involved in performance tuning
• Worked extensively on Cube optimization
• Published the reports to web
• Documented the whole process

Environment: Cognos Impromptu, Cognos PowerPlay, PowerPlay Enterprise Server, Impromptu Web Reports, Oracle, SQL Server, WinNT, MS-Excel, MS-Access, HTML.

Confidential, Thousand Oaks, CA

Consultant - Senior Application Developer

Responsibilities:

• Involved in creating catalog (Monthly detail) using Impromptu
• Used Informatica Power Center V (6.1) for extracting the database from Legacy database and load into Oracle8i
• Implemented Impromptu catalog based security, model security is used to secure transformation models
• Created different types of joins and views according to specification
• Involved in exporting the Impromptu reports (imr) into Excel, HTML and PDF format
• Created, tested and deployed reports using Impromptu Administrator.
• Involved in creating the Transformer Cubes by saving the impromptu reports as IQD (Impromptu Query definition).
• Created Multi-Dimensional reports using Power Play Transformer
• Customized cubes as per users requirements.
• Developed Impromptu and Power Play Burst Reports
• Developed stand-alone Application (Afaria) and integrated with IBR and PBR
• Developed automation tools using macros to format, stack and merge the impromptu reports in a single workbook.
• Created pivot tables in MS Excel.
• Automated the total process using Process Watch Dog (PWD).
• Publish the Cubes on the Web using Power Play Enterprises Server and setup Security that will allow users to log on into the cubes using Access Manager.
• Involved in designing model by using framework manager.
• According to the business rules added some relationships, filters and calculations to the existing Model.
• Created packages by using Models in framework manager and published for report author to the query studio and report studio.
• Reports were bursted upto Territory Level using ReportNet.
• Developed reports using query studio and report studio.

Environment: Cognos (7.1), Power Play Enterprise Server, Impromptu Web Reports Server with Oracle 8i, MS Excel, Excel VBA, Cognos ReportNet, Cognos Visualiser, Informatica - Power Center/Power Mart 6.1

Confidential, CA

Asst Manager/ Cognos

Responsibilities:

• Business Requirements gathering
• Created functional and technical design documents necessary for the project.
• Involved in Analysis and Design of Fact and Dimension tables in Epiphany data mart.
• Involved in creating the staging data source for new LSCA data mart.
• Involved in synchronizing the staging data source with data from GDW source system.
• Involved in test and running of epiphany jobs in development environment.
• Created Topics and Glossary entries to the existing attributes in the user interface
• Created dimension roles necessary for the schema
• Involved in analysis and design of security system to the existing LSCA data mart.

Environment: Epiphany 6.0.5, Oracle 9i, UNIX

Confidential, NJ

Consultant - Cognos Developer

Responsibilities:

• Interacted with business people for gathering the business requirements
• Designed and developed Catalogs, Impromptu Reports, IQD’s
• Modified existing catalog using Cognos Impromptu
• Developed Power Cubes using Power play
• Extensively used Drill Up/Down, filter, Aggregators, Slice and Dice Operations for all OLAP applications
• Developed various types of reports such as Simple, Crosstab, Drill through, Sub reports etc
• Involved in performance tuning
• Worked extensively on Cube optimization
• Published the reports to web
• Documented the whole process

Environment: Cognos Impromptu, Cognos PowerPlay, PowerPlay Enterprise Server, Impromptu Web Reports, Oracle, SQL Server, WinNT, MS-Excel, MS-Access, HTML.

Confidential, NC

Consultant - Cognos Developer

Responsibilities:

• Extensively worked on understanding the business requirements and designing applications to meet their needs.
• Data transferred from various sources such as relational and non-relational databases
• Responsible for performance tuning
• Involved in user training
• Created and modified the existing Catalogs, Reports and IQD’S as per the business requirement
• Created various types of reports, which include Crosstab, Grouped Crosstab, Sub reports.
• Used several functions such as Filters, Drill Up/Drill Down etc
• Involved in the optimization of cubes to improve the performance
• Created several Templates for reports
• Scheduled the reports using Cognos Scheduler as per the business requirement
• Published the packages to Impromptu Web Reports using Report Administrator
• Responsible for documenting the entire process
• Coordinated in end user training

Environment: Cognos Impromptu, Cognos PowerPlay, Impromptu Web Reports, Cognos Scheduler, PL/SQL, Oracle 8.x, SQL Server, Windows NT

Confidential, NJ

Consultant - Senior Cognos Developer

Responsibilities:

• Created List Reports, Cross-tab Reports and Drill through Reports.
• Queried from different database tables as per the requirement
• Created / enhanced catalogs and set User profiles to grant user permissions for querying
• Created different joins according to User requirements
• Created multi dimensional cubes using Transformer
• Created reports in HTML format for easy navigation of data from web browser
• Created and modified the existing Catalogs, Impromptu reports and Cubes.
• Designed the dimensional metrics matrix prototype. This matrix would identify the Dimension, hierarchies and the granules required for the Cognos cube
• Used various fields for calculation and manipulation using Cognos Impromptu
• Used Cognos Impromptu to create Catalog files, created IMR/IQD and Cubes using Cognos 7.1 Series, Impromptu and Transformer. Scheduled the cubes
• Published IWR, used Distribution Shuttle Builder to schedule the cubes
• Customized cubes as per users requirements
• Designing and developing the required cubes and Drill Through cubes for the project

Environment: Cognos (V7.1), Power Play Enterprise Server, Impromptu Web Reports, Cognos Upfront, Cognos Transformer with Oracle 9i.