PROFILE SUMMARY

Over 8 Years experience as an Administrator and Developer, experience in design, analysis, development, documentation and implementation on client/server environment using Cognos for about 7 Years, in various versions like Cognos 8 BI(8.4/8.3/8.2 /8.1)

• Experience in Business Intelligence.
• Experience in Cognos 8 BI (8.4/8.3/8.2 /8.1) , Cognos Go! Office, Cognos Report Net 1.1 Involved in the installation and configuration of Report Net 1.1 and Cognos8 Report Net Framework manager, Cognos Report Net Report studio, Cognos8 Report Net Query Studio and Cognos8 Analysis studio, and Metric studio, Metric manager and Cognos connection.
• A Highly motivated and energetic Professional, dedicated to understanding and meeting the client needs. Knowledgeable in project management tools, processes and techniques.
• Strong knowledge of many software development life cycle (SDLC) methodologies including Rational Unified Process (RUP), Waterfall, Spiral Model.
• Developed dimensional data marts using Informatica/Cognos Data manager.
• Involved in building Data Models using Framework Manager.
• Builded Data Models on Third Normal Form.
• Well versed in Training users and preparing manuals.
• Experience in Cognos EP7 Series.
• Experience with Oracle BI Discoverer.
• Experience on OLAP cubes, relational and multi-dimensional Datamodels.
• Experience in Migration of Cognos EP 7 series to Cognos 8.
• Experience in Migration of Cognos 8 to Cognos 8.2.
• Had knowledge in TM1 and Enterprise Planning
• Good understanding of data warehousing and ETL (Extraction, Transformation and Loading) tools like Data manager, including good knowledge of dimensional modeling.
• Expert in creating List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts, Macros, filters, calculations using Cognos.
• Experience in Scorecards, metrics in metric studio.
• Experience in complex Crosstab reports in Analysis Studio.
• Well versed with Crystal Reports.
• Responsible for managing the Cognos security strategy for users/groups and provide BI publishing and Monitoring reports.
• Experience in Writing SQL Queries to write Free form SQL in Cognos
• Created models in framework manager from various data sources such as Nettezza, Oracle10g/9i, SQL Server and DB2 and published package to Cognos Connection.
• Migration experience from CRN to Cognos8 Environment.
• Excellent understanding of RDBMS and OLAP concepts.
• Experience on UNIX, shell scripting.
• Hands-on experience in implementing Data warehousing methodologies including STAR SCHEMAS and SNOW-FLAKE SCHEMAS for huge data warehouses.
• Oversaw planning for the technology lifecycle for all infrastructure components and development methodologies, policies and procedures.
• Possess excellent analytical, logical, interpersonal, communication and organizational skills.
• Interaction with the Users and Business Analysts for better understanding of the reporting requirements and Client needs.

SKILL SET

Report/ETL Tools : Cognos 8BI, (Cognos Report Net 1.0/1.1, Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis studio, Event Studio) Cognos 7.x Series (Impromptu, Power Play, Power play Transformer, Impromptu Web Reports (IWR), Upfront, Cognos Access Manager, Architecture, Cognos Script Editor, Cognos Configuration, Cognos connection, Crsytal Reports,Datamanager,Informatica Data Modeling/
Databases : ORACLE 10g/9i/8i, DB2, Informix, MS Access, MS SQL Server.
Languages : SQL, PL/SQL, C, C++, COBOL and Visual Basic 6.0.
Web Technologies : VBScript, HTML 3.2/4.0, IIS 4.0/5.0,
Operating Systems : UNIX, MS-Dos, Windows 3.1/95, and Windows NT 4.0/2000.

Education: Bachelors in Computer Science Eng

EXPERIENCE

Confidential, MN Jan’09 to Present
Cognos Consultant

Responsibilities:

• Interacted with the Users for collecting their requirements for developing metadata models.
• The Meta data was standardized for easy writing of the reports by the users.
• Prepared User Manuals for training the users.
• Trained users on adhoc reporting and report studio.
• Created packages using Framework manager.
• Administered tasks such as Scheduling, Deployment, and Dispatchers.
• Involved in Migration of Cognos 8.3 to Cognos 8.4
• Created adhoc reports Using Query studio in Cognos 8.4.
• Created different Standard reports using prompts, filters, query calculations, cascading prompts and conditional Formatting of measures using variables in Report Studio, Analysis studio in Cognos 8.4.
• Created dashboard reports using report studio.
• Created balanced scorecards using metric studio.
• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica mappings for data loads.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
• Created logical & physical data models and Meta Data to support the requirements.
• Scheduled & refresh the reports and bursted reports according to user requirements in Cognos connection and sent the reports through E-mail feature.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using.
• Assisted Data Modelers in creating ETL specification sheet.• Performance tuning in the context of dimensional design by creating Mini Dimensions thus providing smaller entries in to the Fact table.
• Flattening out Many to Many relations by creating Bridge tables as in the case of account and customer dimension tables. End-to-end ETL development of the Data Mart. Designed and developed Informatica mappings for data loads..
• Provided report scheduling support to the users.
• Involved in SQL scripting to build the free form SQL reports.
• Involved in UAT of reports and promoted to production process including production check out
• Sign off the BW reports and co-ordinate with end users for critical issues.
• Tested and validated the report output against the database to measure performance of the Reports.
• Production Support which involves solving End - user problems.
• Involved in fixing the issues, defects in the Packages.
• Involved in solving report errors in report studio.
• Involved in Analysis on reports to support business Decision

Environment: Windows XP, Oracle 9i/10g, Cognos 8.4/8.3, SQL Navigator, LDAP, IIS, TOAD, UNIX.

Confidential, pittsburg, PA Feb 2007 – Dec 2008
Cognos Admin & Developer

Responsibilities:

• Gathered requirements from end users.
• Involved in the development of the Metadata Model using Framework Manager and created query subjects, filters and packages from the framework manger in Cognos 8.3.
• The Meta data was standardized for easy writing of the reports by the users.
• Used Power Designer for Data modeling.
• Used Third Normal Form in building Data Models.
• Published packages with appropriate security settings to Cognos connection
• Created List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts using Cognos 8.3 Report Studio
• Administered the Reporting Environment.
• Developed Scorecards, Dashboards reports Using Cognos8 BI Metric studio/Report Studio.
• Developed complex reports using drill-through options and Master-detail relationships in Report Studio.
• Created different Standard reports using prompts, filters, query calculations, cascading prompts and conditional Formatting of measures using variables in Report Studio.
• Trained few people on Cognos to support users.
• Developed Complex Crosstab reports in Analysis studio.
• Created adhoc reports Using Query studio.
• Used Cognos Go! Office to import reports from report studio to Ms office
• Administered tasks such as Scheduling, Deployment, Dispatchers
• Scheduled & refresh the reports and bursted reports according to user requirements in Cognos connection and sent the reports through E-mail feature.
• Used Cognos SDK to integrate the reports and java script.
• Migration of Cognos 7 to Cognos 8.
• Migration of Cognos 8 to cognos 8.2
• Tested and validated the report output against the database to measure performance of the Report.
• Involved in training sessions and demonstrated Cognos 8 tools to Power Users end-users.
• Involved in Production Support which involves solving End - user problems.
• Involved in fixing the issues, defects in the Packages.
• Involved in solving report errors.
• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database. Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Extensively used Power exchange CDC option to capture changes and load them from oracle data base. • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance. Implemented Slowly Changing dimension types (I, II &III) methodologies for accessing the full history of accounts and transaction information, designed and developed change capture solutions (CDC) for the project, which captures
• Provided 24/7 Production Support.
• Involved in Analysis on reports to support business Decisions.

Environment: Windows 2003, IIS,Unix, Web sphere 5.X, Teradata, Oracle 9i/10g, Composite Server 3.7.1, Windows XP, Apache, Cognos 8.1/8.2/8.3, SQL Navigator, TOAD, Microsoft Visio, Http Servers, Load Runner, Html.

Confidential, NJ Nov 2005 – Jan 2007
Cognos Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Worked on Informatica– Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Involved in the development of Informatica mappings and tuned them for better performance.
• Installed and Configured Cognos Impromptu and Cognos Power Play along with Upfront server.
• Designed, developed, maintained and tested Catalogs for supporting ad hoc queries and canned reports.
• Designed and developed Prompted reports, Drill Through reports.
• Created Power Cubes using power play.
• Worked with Administrator module in creating users and users groups for different areas and setting privileges to them.
• Created the reports using Cognos functionalities like Queries, Slice and Dice, Filters, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc.
• Administered tasks such as scheduling, deployment, and security.
• Production Support which involves solving user problems.

Environment: Oracle 8i/7, Informatica Power Mart 4.6/PowerCenter 1.6 (Designer, Server Manager), Cognos Impromptu5.0, Cognos Power play, Cognos Upfront Server, MS SQL Server, UNIX, SQL, PL/SQL, MS Access.

Confidential, INDIA Jan2004 – Oct 2005
DW Consultant

Responsibilities:

• Gathering Requirements from the end user and checking the structure of the schema and data with the Data Modular.
• Worked on Informatica– Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Involved in the development of Informatica mappings and tuned them for better performance.
• Used most of the transformations such as the Source qualifier, Aggregators, Connected & unconnected lookups, Filters & Sequence.
• Designed, developed, maintained and tested Catalogs for supporting ad hoc queries and canned reports.
• Designed and developed Prompted reports, Drill Through reports.
• Created Power Cubes using power play.
• Worked with Administrator module in creating users and users groups for different areas and setting privileges to them.
• Created the reports using Cognos functionalities like Queries, Slice and Dice, Filters, Drill down, Functions, Cross Tab, Master/Detail and Formulas etc.
• Administered tasks such as scheduling, deployment, and security.
• Production Support which involves solving user problems.

Environment: Oracle 8i/7, Informatica Power Mart 4.6/PowerCenter 1.6 , Cognos Impromptu5.0, Cognos Power play, SQL, PL/SQL, MS Access.

Confidential, INDIA Jun2002-Dec 2003
Cognos Developer
Responsibilities

• Created the packages using Framework Manager and involved in publishing the packages in the Report net server.
• Performed the import and export of data using the Deployment option in the cognos connection portal.
• Developed reports according to business requirements using the Report Studio and the Query Studio.
• Applied security to the reports created in the Report studio by setting up the permissions in the properties of that report.
• Involved in applying the security at the folder level and also at the report level.
• Created calculated columns and applied conditional formatting on the reports.
• Created list reports, Drill through reports, chart reports using Report studio.
• Applied filters on the reports and created prompts for the reports.
• Involved in creation of reports in different formats like pdf, HTML according to the user specific requirement.
• Organized the folders in the My folders tab.
• Created shortcuts to the entries in the to view the reports.
• Scheduled the reports at specific intervals and distributed the reports using the Report Bursting option in the report studio.

Environment: Cognos Reportnet 1.1, SQL, Windows 2000, Terminal server, UNIX, Oracle 9i.