SUMMARY

• 10+ years of IT industry experience in analysis, design, and development phases of Data warehousing
• Strong Experience of Data Warehousing, ETL Work flow, Data processing and Systems Architecture.
• Experienced in Cognos Administration and Production support
• Wide domain knowledge across Telecom, Banking, Insurance and Financial Analytics.
• Extensive experience in Business Intelligence tools Cognos 8.4/10.1/10.2.1.1 BI Suite (Framework Manager, Report studio, Cognos Workspace Advanced, Query Studio, Analysis Studio), Transformer, Cognos 10 series (PowerPlay Transformer), Access Manager, Scheduler
• Expert level with developing metadata models in Framework Manager following best practices
• Expert level with developing OLAP models, using Powerplay Transformer.
• Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio
• Skilled at training users to use Query Studio and Analysis Studio, Cognos Workspace
• Created Multi - Dimensional Cubes using the Cognos Transformer
• Built various Active Reports for Business Offline Reporting and Executive Demo presentations.
• Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill through, Master-Detail, and Cascading) and Dashboards using Report studio/Cognos Workspace Advanced
• Experience in migrating Reports & Packages from Cognos 7 series to Cognos 8/10 BI
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Experience working with databases including DB2, Oracle, MS SQL Server 2008/2012
• Strong Knowledge of Data Warehousing, OLTP, OLAP concepts
• Strong understanding of Dimensional Modeling (Star and Snowflake Schemas)
• Sound knowledge in SQL Queries and databases concepts
• Strong analytical and Problem Solving Capability
• Experience in Troubleshooting production issues and Data Analysis
• Involved in various activities of the Software Life Cycle in Cognos suite of products
• Self-starter with drive, initiative and a positive attitude
• Strong analytical & good communication skills

TECHNICAL SKILLS

Cognos Series: Cognos BI 10.2.1.1, 10.1 & 8.4.1 (Framework Manager, Transformer, Cognos Workspace, Cognos Workspace Advanced, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio), Qlickview, Cognos Data Manager, Cognos Series 7.x, Power play Transformer 7.x, Impromptu Web reports, Access Manager 7.x, Powerplay Enterprise Server 7.x, Macros,TM1,Café, TM1 Cog BI integration, TM1.Architect

Cognos Report: Net 1.1MR3, 1.1MR2, 1.1(Framework Manager, Report Studio, QueryStudio, Cognos Connection, Administration and Security), Cognos SDK.:

Databases: SQL Server 2000/2005/2008, Oracle 9i/10g/11g, IBM DB2, SAP.

Operating System: Windows 2008 R2/2003/98/95 and MS DOS

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Team Lead / Architect

Tools: Cognos10.2, Framework Manager10.2, Report Studio10.2, TM1,Café, TM1 Cog BI integration, TM1.Architect SQL, Server2005, Oracle 11g, SAP Database.

Responsibilities:

• Developed TM1 Rules, Turbo Integrator process, Dimension, Hierarchy and Dimension subset
• Implementing TM1 Security, User Access on cube, users rights, Cube View, Core, Metadata
• Integrated TM1 to cognos software
• Developed Reports of list, chart, crosstab, cascading, burst, Master - Detail, Drill Through in Report Studio
• Assign user security, user roles and responsibilities
• Set up new database and audit database in Cognos configuration
• Developed Dashboards in Cognos Workspace and Report Studio
• Have Built Reports with various Conditional Styles and Render Variables.
• Assisted Business users to create reports in Cognos Workspace Advanced
• Working in Cognos Administration and Production support
• Working knowledge of Cognos SDK
• IBM Cognos BI solution design, administration, installation, server configuration, and technical support
• Built Active Reports in Cognos 10.2 for Business Offline Reporting and Executive Demo presentations
• Implemented complex data, object and package security filters within the IBM Cognos BI suite of tools
• Creating dynamic cubes in cognos10.2
• Built Complex Reports having child reports, HTML items in Report Studio
• Assisted Users in Creating Custom Definition Groups for better presentation of Reports
• Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio
• Experience in creating Ad-hoc reports using Cognos Query Studio
• Efficient in writing SQL Queries in SQL Server
• Fine-tuned the reports, underlying queries and tables using indexes.
• Worked on Production Support and fixing report/package/data issues.
• Worked on Data Analysis, Validate reports and find data quality issues
• Production Support which involves solving user problems and Provided End User Training and Support
• Prepared User documentation to train users and functionality of each report

Technical Environment: Cognos BI 10.2.1.1, Framework Manager, Report Studio, Query Studio, Windows 7, Teradata, Access Database

Confidential

Senior BI Report Developer

Tools: Cognos10.1.1, Framework Manager8.4, Report Studio10.1.1, SQL Server2005,TM1,Café, TM1 Cog BI integration, TM1.Architect, PowerPlay8.4.

Responsibilities:

• Involved in entire project life cycle from analysis, installation, development, testing, production and end user support
• Worked closely with business users while gathering requirements
• Designed and Implemented new dashboards using Portets pages and cognos workspace
• Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer
• Worked in Cognos Administration and Production support
• Authored various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources.
• Working knowledge of Cognos SDK
• Successfully designed and implemented security on different levels including object and row level security.
• Implemented complex data, object and package security filters within the IBM Cognos BI suite of tools
• Implemented IBM Cognos BI application security using Active Directory(AD)
• Implemented report bursting to distribute reports effectively.
• Used Cognos Event Studio to manage scripts, cubes refreshes, report runs and notifications.
• Developed models and published packages in Cognos connection using Framework Manager
• Created Models by creating various joins between query subjects
• Used Framework Manager to model metadata from different data sources and published packages.
• Built Active Reports in Cognos 10.1 for Business Offline Reporting and Executive Demo presentations
• Migrated Cognos Legacy Reports, Cognos 8.4 BI Reports to Cognos 10.1
• Involved in building Multidimensional Cubes using Transformer
• Creating/Modifying various finance reports as per Business User requirements
• Developed Reports of list, chart, crosstab, cascading, burst, Master - Detail, Drill Through in Report Studio
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab reports with multiple breaks.
• Developed Complex Reports having many Aging calculations, child reports, HTML items in Report Studio
• Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio
• Experience in creating Ad-hoc reports using Cognos Query Studio
• Creating and setting privileges on Users/User Groups
• Involved in Testing and improving Report Performance
• Efficient in writing SQL Queries in Oracle/SQL server 2000/2005/2008
• Scheduled reports using the Schedule Management tool, Event Studio in Cognos Connection
• Performed content/portal Administration
• Implemented package level, object level and data level security in the reports.
• Fine tuned the reports, underlying queries and tables using indexes.
• Worked on Production Support and fixing report/package/data issues.
• Worked on Data Analysis, Validate reports and find data quality issues
• Applied security on data level and in package level to enable respective users to see their reports and data.
• Prepared Weekly Status Reports (PMO) and shared with the Managers
• Production Support which involves solving user problems and Provided End User Training and Support
• Prepared User documentation to train users and functionality of each report

Confidential

Server2005, PowerPlay8.4.

Responsibilities:

• Migrated the all reports in report studio, Cube and Packages in new version.
• Involved in creating application design document SPR and co-ordinates with onsite team while producing functional specifications.
• Co-ordinates with testing team.
• IBM Cognos BI solution design, administration, installation, server configuration, and technical support
• Tested all the report, cubes and Jobs in testing environment and fixed the issues
• Making the process flow and documents them.
• Working on difference and functionality difference between 8.3 to 10.1.1
• Have Built Reports with various Conditional Styles and Render Variables.
• Built Active Reports in Cognos 10.2 for Business Offline Reporting and Executive Demo presentations
• Implemented complex data, object and package security filters within the IBM Cognos BI suite of tools
• Built Complex Reports having child reports, HTML items in Report Studio
• Assisted Users in Creating Custom Definition Groups for better presentation of Reports
• Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio
• Experience in creating Ad-hoc reports using Cognos Query Studio
• Efficient in writing SQL Queries in Teradata
• Fine tuned the reports, underlying queries and tables using indexes.
• Prepared User documentation to train users and functionality of each report
• Making the process flow and documents them.

Senior BI Report Developer

Confidential

Tools: Cognos8.4, Framework Manager8.4, Report Studio8.4, SQL Server2000, PowerPlay8.4.

Responsibilities:

• Automate excel, foxfro reports in report studio and in Cube.
• Make Power cube and do the calculation and design them,
• Involved in creating application design document and co-ordinates with onsite
• Team while producing functional specifications.
• Implemented complex data, object and package security filters within the IBM Cognos BI suite of tools
• Developed models in Framework Manager and applying table level and data level Security.
• Utilizing the report studio to develop analysis types of reports such as list reports, cross tab reports, chart reports, and master detailed reports.
• Created various query calculations, filters and logical statements to get the desired data in the report level.
• Applying different functionalities like Filters and Prompts to retrieve data from the database.
• Developed complex functionalities like conditional formatting and conditional display using conditional explorer.
• Created bookmark reports so that users can quickly move one part report to another part Co-ordinates with testing team.
• Making the process flow and documents them.

Confidential, San Francisco, CA

Senior BI Developer

Tools: Cognos8.4, Framework Manager, Report Studio, SQL Server.

Responsibilities:

• Developed report in report studio by which you can update your database and see the output in Report Studio.
• Involved in creating application design document and co-ordinates with onsite team while producing functional specifications.
• Developed models in Framework Manager and applying table level and data level
• Security.
• Utilizing the report studio to develop analysis types of reports such as list reports, cross tab reports, chart reports, and master detailed reports.
• Developed dashboard reports.
• Created various query calculations, filters and logical statements to get the desired data in the report level.
• Applying different functionalities like Filters and Prompts to retrieve data from the database.
• Developed complex functionalities like conditional formatting and conditional display using conditional explorer.
• Involved in Cognos Connection.
• Created bookmark reports so that users can quickly move one part report to another part
• Co-ordinates with testing team.

Confidential

Telecom Expense Management

Tools: Cognos8.3, Framework Manager, ReportStudio, Query Studio.

Responsibilities:

• Understand the requirement of the business users
• Developed Reports in ReportNet from MS Access, SQL, Excel Reports
• Creating Master Details Relationship, prompts and creating Cascading prompts
• Built Models, Query Subject, Packages, Published Packages using Framework Manager a tool of ReportNet
• Developing Standard Templates, Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using ReportStudio and Query Studio.
• Developed advanced reports using Report Studio and Adhoc reports using Query Studio.
• Creating Query Prompts, Advance Prompts, Slicer, calculations, conditions & filters Developing Prompt pages and Conditional Variables Filtering data, adding prompts, conditional formatting.
• Performance Tuning
• Peer to Peer Reviews
• Unit testing of Cubes via SQL’s and Technical Specification Documentation.
• In Framework manager made IQD (Externalized Query Method).
• Interacted with end users for creating the reports according to their requirements
• Creation of standard filters, calculations, prompts
• Developed PowerPlay reports in explorer and reporter mode from the mdc (multidimensional Cubes)