CAREER SUMMARY:

• Over 7 years of experience in Information Technology including 6 years of expertise in Data warehousing and Business Intelligence.
• Business Intelligence experience in building Metadata models, developing reports, and analyzing OLAP data using Cognos 10.2/10.1.1/8.4/8.3/8.2 (Report Studio, Workspace, Workspace Advanced, Business Insight, Business Insight Advanced, Query Studio, Analysis Studio, PowerPlay Transformer, Lifecycle Manager, and Framework Manager), and Cognos Administration.
• Experience in developing the reports using Report Studio, Query Studio, Workspace/Business Insight Advanced and Analysis Studio.
• Experience in developing the Dashboards using Report Studio and Workspace/Business Insight.
• Experience in building Framework Manager Models and publishing packages.
• Experience in Cognos 10.2/10.1.1/8.4/8.3/8.2 tools like Event Studio, Cognos Connection, and Configuration Manager.
• Experience in migrating/upgrading the objects from Cognos 8.3 to Cognos 8.4 and to 10.1.1.
• Created and published packages in Framework Manager from various data sources.
• Developed Multi - dimensional Cubes, Manual levels, Level Plans, Sub Cubes, Alternate Drill Downs and Alternate Levels using Cognos PowerPlay Transformer.
• Expertise in working with different data sources such as flat files, and databases such as Oracle11g/10g/9i/8i, SQL Server, DB2, Teradata and MS Access.
• Data Modeling: Knowledge in planning, designing, developing and deploying Data Warehouses / Data Marts with experience in both relational and multidimensional databases. Design of Star Schema and Snowflake Schema methodology, and Logical Data Modeling.
• Well rounded IT professional with solid client interaction, understanding business applications, and business data flow and data relations.
• Excellent verbal and written communication skills, and am a self-motivated team player.

TECHNICAL SKILLS:

BI Tools: Cognos 10.2/10.1.1/8.4/8.3/8.2/ CRN (Framework Manager, Query Studio, Report Studio, Analysis Studio, Workspace/Business Insight, Workspace Advanced/Business Insight Advanced, Event Studio, Cognos Connection, Configuration Manager, PowerPlay Transformer, Lifecycle Manager).

Formal Methods: Agile Modeling, SDLC

Database Servers: Oracle 11g/10g/9i/8i, MS SQL Server2000/2005, MS Access

Operating Systems: Windows Server 2003/2000/NT, Windows Vista/ XP/ME/98/95, DOS, UNIX

Languages: SQL, PL/SQL, C, XML, HTML

Query Tools: TOAD for Oracle v8.6.1, SQL*PLUS, SQL*Loader, SQL Navigator

Software Packages: Microsoft Office, Microsoft Project, Microsoft Visio; ODBC

PROFESSIONAL EXPERIENCE:

Confidential, Rosemont, IL

Cognos Developer

Responsibilities:

• Involved in gathering requirements from business users.
• Worked with business users in designing the Report Layouts.
• Participated in the Installation of COGNOS 10.2.
• Created metadata models from Tables and PL/SQL procedures and published packages using Framework Manager.
• Implemented security at Object level and Package level in Framework Manager.
• Developed various reports like List, Crosstab, Charts, Drill-through, and Master detail using Cognos Report studio.
• Created Dashboards using Report Studio.
• Created Value Prompt, Date Prompt, and Textbox Prompts to filter the data.
• Created prompt pages, and applied Filters, Calculations, Functions and Conditional formatting to the detailed data.
• Designed Transformer models and build PowerPlay cubes using PowerPlay Transformer.
• Explored the cube data, slice & Dice using Report Studio and Analysis Studio.
• Involved in upgrading objects from Cognos 8.4 to Cognos 10.2.
• Prepared deployment builds and deployed Cognos objects from development to Test environment using Cognos deployment tools.
• Implemented security to Cognos objects.
• Validated the report data against database by writing SQL queries.
• Created technical specification, unit test, deployment document for the reports.
• Participated in cross-training activities within the team.

Environment: Cognos 10.2/8.4 (Framework Manger, Report Studio, Workspace/Business Insight Advanced, Workspace/Business Insight, Query Studio, Analysis Studio, Cognos Connection, Lifecycle Manger), PowerPlay Transformer, Oracle 11g/10g, PL/SQL, Unix, Windows 7/Windows 2008/XP.

Confidential, Napa, CA

Business Objects Developer

Responsibilities:

• Worked closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions.
• Worked on technical design specs for Framework manager, and reporting per the requirements.
• Created project, namespace (Database View, and Business View), and folders and imported required metadata in Cognos Framework Manager.
• Created model query subjects, Data source query subjects, stored procedure query subjects as per the business requirements in the Framework Manager
• Created standard reports in Cognos Report Studio, and Analysis Studio.
• Responsible to build the Framework Manager Models and packages as per the business requirements.
• Worked on various reports like, List, Crosstab, drill-thru, multi-query, master/detail, prompted, dashboards, portlets, and tabular reports.
• Designed complex reports with union queries, and SQL queries.
• Involved in migrating the Cognos reports from Cognos 8.3 to 8.4 and to 10.1.1.
• Designed transformer models, and PowerPlay cubes using transformer.
• Worked on PowerPlay studio to slice/dice Cognos cubes,
• Provided customer training in Report Studio, and Query Studio.

Environment: Cognos 10.1.1/8.4/8.3 (Framework Manger, Report Studio, Business Insight Advanced, Business Insight, Query Studio, Analysis Studio, Cognos Connection, Lifecycle Manger), PowerPlay Transformer, SQL Server 2005, OLAP, Oracle 10g, RDBMS, SQL, PL/SQL, Windows 2003/XP, SQL plus, SAP Business Objects suite.

Confidential, Renton, WA

Cognos Developer

Responsibilities:

• Designed Metadata model in Framework Manager by creating database layer and business layer, defining appropriate relationship between query subjects in Framework Manager and then deployed packages into Cognos connection portal.
• Developed List, Crosstab, and Drill through, Master-detail, Tabular, Chart and Dashboard reports which involved multiple prompts like Cascading, Date and Value.
• Executed Unit test, Dry run and formal execution test cases for each report.
• Developed reports that allow user to select a particular report to execute using render variable.
• Setup Data Level, Package Level and Folder Level Security in Framework manager.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Created Filters, Prompts, Calculations both at package level and report level.
• Conditional Variable to display different colors and for text according to format
• Unit testing of each reports and working with testing team to get user sign off.
• Deployment of Packages & Reports between Development and Production Environment using
• Created Unions and Joins for combining different tables in Query Subjects.
• Cognos Administrative Tools.
• Created jobs to schedule reports using schedule management in Cognos connection.
• Attending weekly status Calls and updating the status of the project to the Client.

Environment: Cognos8.3/8.4 BI (Framework Manger, Report Studio), SQL, SQL Server 2008, Oracle 9i, Windows 2003.

Confidential, Princeton, NJ

Cognos Developer

Responsibilities:

• Requirement Analysis & EstimationInteraction with business users/analysts to clarify doubts provide technical inputs to them.
• Analyze the complexity of the requirement and communicate the effort estimate to client.
• Maintained the offshore team by passing the requirements after interacted with the Business users.
• Developed model in framework manager and created dashboard reports in Report studio.
• Migrated Impromptu Reports 7.4 to Cognos 8.3 using Cognos migration tools and manual updates.
• Modified and updated the Framework Manager according to different layers like Database, Intermediate and Business.
• Tune the performance of reports to meet business expectations.
• Handle all requests for user role and application access security and synchronizing production and development Servers and monitoring the services and migrating and scheduling.
• Setup Data Level, Package Level and Folder Level Security in Framework manager.

Environment: Cognos 8.3 BI (Framework Manager, Query Studio, Report Studio, Cognos Connection), Cognos Impromptu, PowerPlay Transformer, Oracle 9i/8i, SQL, PL/SQL, TOAD, MS Office, Window 2003/XP, Unix.

Confidential

Cognos Developer

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Involved in Installed & configured Cognos component such as the ReportNet/Cognos8.x.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Building models and publishing packages in Framework Manager to the ReportNet server.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio and Development of ad-hoc reporting interfaces using Cognos Query Studio.
• Used Tabular SQL for some of the Complex Reports In Report Studio.
• Created various IQD packages in Framework Manager and from this IQD integrated toPowerPlay Transformer to create various models and cubes.
• Business Data Analysis, Design, Development of Multidimensional OLAP Cubes.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• Provided technical assistance, training and mentoring to Users and Business Partners.

Environment: Cognos 8.x/ ReportNet 1.1 MR3 (Framework Manager, Report Studio, Query Studio), Oracle 9i, SQL Server 2000, SQL, PL/SQL, Decision Stream, EP7 series version 3, Windows