SUMMARY

• 7+ Years of IT Experience in analyzing, designing, developing and implementing Data Warehouse in different Business Intelligence Environments with Emphasis on generation of complex reports using data modeling and Business Intelligence reporting tool.
• Strong Experience in Cognos 10.1.1/8.4, ReportNet 1.1 (Cognos Connection, Query Studio, Report Studio and Framework Manager), Cognos 7 (Impromptu, PowerPlay, Transformer, Metric Studio)
• Developed Framework Manager Models (Layers, Joins, Prompts, Filters and Calculations)
• Expert in designing & developing complex reports (List, Crosstab, Chart, drill - through, scorecards, dashboards & master-detail)
• Created multiple report pages, prompt pages, burst reports, and cascading reports.
• Created and ad-hoc reports (Query Studio) and done data mining (Analysis Studio).
• Experience in Migrating data from Cognos 8.4 to 10(Life-Cycle Manager) and Dynamic Query Analyzer
• Implemented Data Security, Object Security and Package Security in Framework Manager and created user classes as per the requirement
• Experience in developing Scorecards (Metric Studio) and executive Dashboards (Business Insight)
• Experience with Cognos Administration and Architecture
• Built in-memory OLAP cubes using TM1.
• Developed Active Reports using Cognos 10.1.1
• Good Experience in Business Insight and Business Insight Advance
• Designed and Developed Transformer Models and Cubes
• Developed Dashboard Reports against Cube Data Sources and DMR Models
• Experience with Scheduling, Report Bursting and delivery via e-mail
• Experience in Data Mining, Multidimensional Data Analysis using Power cubes. Star Schema, Snowflake Schema used in relational, dimensional and multidimensional
• Strong Knowledge of Data Warehousing, OLTP and OLAP concepts
• Sound Knowledge in SQL Queries and Databases concepts
• Experience with ETL tools like Informatica, SSIS
• Proficient in requirements gathering and analysis, validations, and SDLC, Business Requirements documents (BRD) and Functional Specifications documents (FSD) and Use cases
• Performance tuning of the reports by using more drill-through, reducing SQL queries, using more inbuilt functions and applying star schema where possible.

TECHNICAL SKILLS

• Cognos 10.1/8.4
• Report Studio
• Query Studio
• Analysis Studio
• Dynamic Query Analyzer
• FrameWork Manager
• Impromptu
• Cognos PowerPlay
• Cognos Connection
• TM1
• Cognos IWR administration
• Cognos Transformer
• Life Cycle Manager
• Oracle 11i
• 10g
• 9i
• Teradata
• SQL Server 2008/2005
• Apache
• IIS
• IBM HTTP Server
• ERWIN 7
• SSIS
• UNIX
• IIS 7.5

PROFESSIONAL EXPERIENCE

Confidential, Queens, NY

Sr Cognos Developer

Responsibilities:

• Migrated the Data from Cognos 8.4 to 10.0 using Life Cycle Manager
• Analyzed and understood the reporting requirements.
• Developed Business view of the data (Metadata Models) with Namespaces, Folders, Query Subjects and Query Items in Framework Manager.
• Built relationships between Query subjects, which represent the logical structure of the business and user requirements.
• Built complex/summary query subjects, reusable filters and calculations based on relational data sources.
• Created BI Dashboards, charts/graphs, drill through reports, dynamic reports to meet the requirements specification based on KPI’s
• Used Cognos connection for organizing the content, enabling security, scheduling and distributing reports.
• Developed complex reports in Report Studio and ad-hoc reports in Query Studio
• Created list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations and conditions
• Created prompts and cascading prompt pages in report studio
• Created scorecard reports using Metrics studio, and Dashboards using Business Insights
• Experience with AFS
• Created Bilingual Reports.
• Setup event notifications using Event Studio.
• Performed SQL tuning to enhance the performance of the reports.
• Implemented complex SQL Queries to for retrieving the data.
• Implemented performance tuning of the reports by getting rid of extra queries for report generation.
• Used Conditional blocks/variables and associated them with queries to show data only when the conditions were satisfied
• Developed dimensional cubes using Cognos Planning and Cognos TM1
• Experience with LDAP authentification system

Tools: and Technologies: Cognos 10, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Access Manager, TM1 10, Cognos Planning, Transformer, Word, Excel and Access, SQL Server 2008, TOAD 9.5, UNIX

Confidential, Fort Lauderdale, FL

Sr. Cognos Developer

Responsibilities:

• Updated & administered the security privileges at object level in Cognos connection and data level
• Created user profiles in Framework Manager.
• Created and published packages for different subject areas, using Data Source Query Subjects
• Created Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Created list, crosstab and Chart reports and implemented drill-though conditions and Master-Detail relationships.
• Created Burst Reports and scheduled reports.
• Administered different users with access/revoke and given grants.
• Experience in Cognos Architecture and with all 9 layers of it.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, and multiple queries for data extraction in reports.
• Customized prompts using HTML Items.
• Used Union, Intersection, joins between queries in report studio.
• Design scorecards, trends, actions using Metric Studio to monitor the customer satisfaction and performance of organization.
• Created metric package with customized calendar settings. Defined metric groups, target values and variance in Metric studio for score carding application.
• Built power-play cubes in Transformer for dimensional analysis.
• Implemented data level security in cubes using user group Custom views.
• Worked on scheduling the weekly and monthly auto-rebuild of the cubes. Implemented incremental update.
• Developed several Dashboard reports using MDX with multiple pages having cube as data source.
• Implemented Drill-up and Drill-down with advanced options.
• Deployed reports, models and cubes from Dev to Test and Prod environments.
• Worked on Unit testing and data validation of various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out
• Validation and verification of the reports.
• Carried out performance tuning of reports, both on database side and cognos report and modeling side
• Upgraded the Cognos environment by Installing and Configuring Cognos 10 on multi-server.
• Upgrade a set of reports and FM Models to Cognos 10.
• Used Business Insights and Business Insights Advanced to arrange individual reports and dashboards.

Confidential, Harrison, NY

Cognos Developer

Responsibilities:

• Administered the reporting environment.
• Involved in building multi-dimensional cubes, Sub-Cubes for user groups using PowerPlay Transformer.
• Developed data specific reports with various filter conditions to retrieve data
• Created trend over time reports, Productivity, Variance, Reports and Finance Reports
• Developed several Reports including Burst Reports
• Created and performed the unit and Integrity test cases and assisted the testing team in System Test and Production move process.
• Created reports with conditional formatting to enhance the readability of the report outputs and enabled Prompts and Cascading Prompt pages to give users the ability to derive focused reports.
• Involved in complete Software Development Life Cycle using Agile and Scrum.
• Created functions, stored procedures for inserting, updating data based on conditions.
• Wrote database triggers for complex business rule validations.
• Involved in testing the package developed by co-developers.
• Involved in SQL Query Optimization.
• Prepared User documentation to train users and functionality of each report.
• Involved in troubleshooting and data gathering during the business analysis and planning phase of the project.
• Involved in writing SQL & PL/SQL queries.
• Created Stored procedures, Macros, Functions and Collitions
• Troubleshoot database related issues.
• Created Star Schema using fact and dimension tables and further created dimensions, levels and hierarchies.
• Design, develop and test new queries with end users.
• Tuned Performance of reports by reconfiguring join strategy in SQL Queries/ Framework Metadata Models and requested the DBA to create summary tables/views at the database level or enable the indexes on the columns used in the joins when appropriate

Confidential, Westpoint, PA

Cognos Developer

Responsibilities:

• Core team member of Cognos Business Intelligence implementation team putting strong emphasis on SDLC best practices.
• Design and develop query models that support their tactical and strategic reporting needs
• Develops/Modify BI reports using Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, and Microsoft Reporting Services, and Performance-point Services.
• Design and develop metadata model in Cognos Framework Manager
• Design and develop logical dimensional models implemented in both multi-dimensional databases and cubes in the form of star schema database.
• Assess technical requirements, existing infrastructure and data sources.
• Design, Develop, Build and Support metadata/ models and cubes in powerplay and Microsoft SSAS
• Work with business analyst, SME and IS to build DW data marts and data sources for modeling and reporting
• Plan, design and implement BI architecture along with IS
• Gather/Design report requirements and build sophisticated reports/ dashboards / scorecards, analysis and queries
• Deploy/certify the reports, build complex drill-throughs using dashboards, scorecards and reports
• Develop macros, create job/event schedules to automate report execution & delivery.
• Design and Develop dashboards, analytics, scorecards and KPIs in Microsoft Performance- Point and integrate it with Excel Services and Sharepoint.
• Create/Maintain BI Dev, Test and Production environments, user creations and management, license management, application deployments between servers, change management with BI Admin & IS Dept .
• Provide security, control report access
• Identify/manage security requirements and access for departments with BI Admin and IS Dept
• Develop multidimensional cubes using SQL Server Analysis Services and Cognos Transformer
• Design, develop and test new queries with end users.

Confidential, Portland, OR

Cognos Developer

Responsibilities:

• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Extensive interaction with Business Users and gather information and requirements.
• Migrated Reportnet Models and reports to Cognos 8.2.1 environment.
• Managing User IDs and User groups like providing privileges to the users and User Groups in Access Manager.
• Designed and Developed projects, packages, Reports using Framework Manager, Query Studio and Report Studio.
• Modifying relationship between different databases tables and building models using Framework Manager.
• Implemented Data Security, Object Security, Package Security and created user classes as per the requirements.
• Analysing the existing reports and preparing checklists starting from generating new reports in Report Studio, creating all the query items that match the expressions with the previous reports.
• Created Dynamic Dashboards to evaluate the business performance based on various KPIs.
• Developed Templates, Master Detail Reports, Chart Reports and Multilingual Reports using Report Studio and Query Studio.
• Design, Develop and test new queries with end-users.

Confidential

Jr. Cognos Developer

Responsibilities:

• Interacted with team members to transform the business specification into technical requirements.
• Involved in logical, physical and relational modelling of data as per the information available in the organization.
• Involved in creating models and packages in Framework Manager.
• Wrote SQL Queries and Procedures to simplify some of the jobs.
• Developed List, Crosstab, Drill-through, Master-Detail, Charts and complex reports which involved Multiple Prompts, Filters, Pages, Multi-Queries against multiple databases using Report Studio.
• Customized data by adding Filters Prompts, Calculations, Summaries and Functions.
• Created standard and Ad-hoc reports using Cognos Query Studio.
• Implemented security for the developed Models, Data and Packages
• Involved in various stages like Development, System Analysis and Design.
• Involved in optimizing SQL Queries for performance tuning.
• Created users and applied user level security to the data.
• Developed/Modified scripts to create tables, views and executed them using SQL Plus.
• Involved in troubleshooting and fine-tuning of databases for its performance and high availability.
• Validated single and cascaded databases, triggers, stored procedures and integrity constraints.

Tools: & Technologies: Cognos Reportnet 1.1, Impromptu 7.3, Transformer 7.3, Upfront, Oracle 9i, MS SQL Server 2000/2005