Summary:

• Over 8+ Years of experience in full life cycle development involving analysis, design, development, deployment, testing, implementation, maintenance and Support of large data warehouse applications in Web-based and Client/Server environment.
• Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 6 / 7/ 8, Cognos Enterprise Planning and Cognos Report Net.
• Experience in IBM Cognos 8 BI (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio andCognos Connection) and Report Net1.1 and implementing the business intelligence planning.
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Customized Reports usingHTML and JAVA SCRIPTS.
• Strong experience on Teradata as a backend support for Cognos reports.
• Experience with BTEQ to write SQL Scripts and validate data.
• Publication of reporting via Office using Cognos Office Connection (IBM Cognos 8 Go! Office) and ad-hoc querying via Cognos BI Analysis for Excel, word, power point.
• Strong Knowledge with Power play Transformer model design and Power play cube building.
• Reviewed the Cognos Framework Manager model developed in development environment by other team members. Upgraded reports from 8.2 to 8.4.
• Deployed reports into servers in Cognos connection and create the scorecard reports using the Metric Studio.
• Migrated reports from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8 BI (8.2 and 8.4)
• Move the Cognos Framework Manager model from development, test environment to production environment.
• Worked on Informatica Mappings (Transformations) to load the data into Reporting Database.
• Extensive experience in Data Warehousing tools including Informatica, Data Modeling Tools like Erwin using Oracle, DB2, MS SQL Server databases.
• Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database Schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling and Kimball methodology.
• Expertise in version Up gradations of Cognos suite such as Cognos 7.3 and Migrating Report Net reports and Impromptu intoCognos8 BI.
• Created Active Reports which made offline analytics easy to get truly portable business intelligence.
• Involved in creating and working with PL/SQL stored procedures, triggers.
• Extensive work on Data Extraction with Oracle (8i, 9i and 10g), SQL Server & MS-Access.
• Worked extensively on transformer in creating multidimensional cubes and developed Power Play reports to be published in report net server.

EDUCATION:

Bachelors in Science & Technology

CERTIFICATION

• IBM Cognos 8 BI Author (Cog-180)
• Cognos Report Net Modelling Product Professional Cognos Certification Program
• Cognos Report Net Authoring Product Professional Cognos Certification Program

SKILLS/ TOOLS

• Reporting Tools : Cognos 8.1, 8.2, 8.3, 8.4 and 10.1 & 10.2 BI Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio and Analysis Studio), TM1, CRN 1.1  MR3, Cognos EP Series 7.x (Power play Transformer, Power play Windows/Web,  Impromptu, Upfront)
• ETL Tools : Informatica, Data Stage, Data Marts, Staging, OLAP.
• Operating Systems : Windows 2003 Enterprise Server, XP, 2000, Windows XP/7 Professional,UNIX-AIX
• Web Servers : IIS, Tomcat and Apache
• LDAP Servers : Active Directory, Sun One Directory, Apache Directory.
• Programming skills : C, C++, Java, HTML, JavaScript, Visual basic, SQL, PL/SQL.
• Databases : MS SQL Server 2000/2005, Oracle 8i/ 9i, 10g/11g, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, NC Jan 12 – Till date Sr. Cognos Developer

Description: Confidential, a bank and financial holding company, provides a range of banking, investing, asset management, financial and risk management, nonbanking financial services and products to individual consumers, small- and middle-market businesses, large corporations, and governments in the United States and internationally.

Responsibilities:

• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio andcreated scorecard reports using the Metric Studio.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Worked on Analysis Studio to develop multi-dimensional reporting. Analyzed Business requirements from the analysts.
• Involved to analyze and map data from source systems to target operational data stores and data marts (Data warehouse).
• Managed TM1 data through Excel and customize active forms using TM1.
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developed reports using System Development Kit (SDK) by java scripts and Eclipse at the back end.
• Customized Reports usingHTML and JAVA SCRIPTS.
• Upgrade the report and packages version of COGNOS from 8.4 to 10 and Participate in the regression testing and unit testing.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Created Active Report which provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline.
• Developed Dash board reports to display all the information related to environment using Summary reports.

Environment: Cognos 8.4/10.1/10.2 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Cognos SDK, Transformer and Event Studio), Teradata, Hyperion, JavaScript and HTML, Oracle Data Integrator(ODI), Oracle Database 10g, Cognos Transformer 8.4, Active Reports, TM1, Windows XP Professional, VB Script, T-SQL, XML and HTML.

Confidential, PA Apr 10 – Dec 11
Sr. Cognos Developer

Description: Confidential is a global enterprise with core competencies in the fields of health care, agriculture and high-tech materials. As an innovation company, it sets trends in research-intensive areas. Confidential’s products and services are designed to benefit people and improve the quality of life. In addition to that, the Group aims to create value through innovation, growth and high earning power.

Responsibilities:

• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Involved in defining Relationships and Cardinality between query subjects, Built models containing query subjects, query items, and namespaces from scratch as well as from imported metadata in Frame work manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio andCreate the scorecard reports using the Metric Studio.
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and multiple Prompts in Boards.
• Working experience with different date functions like YTD, QTD, and MTD in Report Studio
• Designed OLAP Reports using most of the Report studio features (Conditional Formatting/Page layout, Sections, page Breaks, sorting, summaries, grouping, Drill Down, Drill Up).
• Developed stored procedures, triggers and complex packages using PL/SQL.
• Involved in customizing reports using Java Scripts and migrate the reports and packages to different environments.
• Developed reports using System Development Kit (SDK) by java scripts at the back end.
• Customized Reports usingHTML and JAVA SCRIPTS.
• Customized Cognos Connection with appropriate reports and security measures.
• Involved in setting up sign-on for Groups/Roles to secure the Models and packages.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Upgrade the report and packages version of COGNOS from 8.2 to 8.4 and Participate in the regression testing and unit testing.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.

Environment: Cognos 8.2 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Cognos SDK, Transformer and Event Studio), Teradata, Hyperion, JavaScript and HTML, Oracle Data Integrator(ODI), Oracle Database 10g, Cognos Transformer 8.4, Windows XP Professional, VB Script, T-SQL, XML and HTML.

Confidential, NYC Jan 09 – Mar 10
Sr. Cognos Developer

Description: One of the world\'s top investment banks, Confidential serves up a smorgasbord of financial services. The company operates in three primary business segments: institutional securities, global wealth management group, and asset management. Confidential has more than 1,300 office in more than 40 nations serving corporate, institutional, government, and individual clients which is headquartered in the Confidential Building,Midtown Manhattan, New York City.

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources and manage TM1 data through Excel.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Developed dynamic drill down, expand collapse, on-click sort using Java Scripts and customize Active forms using new TM1 functions.
• Developed reports using System Development Kit (SDK) by java scripts.
• Implemented dynamic measures, dynamic column selection in Report Studio.
• Used Cognos Transformer to build multidimensional cubes and used it in Dashboards.
• Developing Analysis Studio views of analysis from dimensional modeled packages.
• Create the scorecard reports using the Metric Studio.
• Analyzing all reports and Standardize these reports using Power Prompts and Charts
• Extensively used informatica Web Services Wizard to extract data from XMI files stored in web server.
• Implemented developing and deploying Stored Procedures, Triggers, DTS Packages, SSIS, SQL Jobs, Data Imports and Transformations.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Involved in Informatica administrative work such as creating Informatica folders, repositories and managing folder permissions. Involved in installation of the patches for informatica power center.
• Involved in migrating reports from Development to Testing and from Testing to Production Environments, creating Connect Strings and synchronizing the Connect Strings and Connection Objects in Dev, Test and Prod environments.

Environment: Cognos 8.2 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Powerplay Transformer), Cognos SDK, Teradata, Hyperion,Oracle 10g, TOAD, Cognos Access Manger, Windows 2003 Server.

Description: Today Confidential has approximately 1,400 branches, up to 3,600 ATMs, and more than 19,000 colleagues in 12 states covering New England, the Mid-Atlantic and the Midwest. Through acquisitions and organic growth, Confidential evolved from the fifth-largest bank in the U.S. into as one of the 15 largest commercial banking companies in the country.

Responsibilities:

• Customized Cognos Connection with appropriate reports and security measures
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP – ROLAP).
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Involved in Designing models using Framework Manager and deployed packages to the Report Servers.
• Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager in Report Net.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio.
• Involved in assess and analyze large data sets for completeness and quality.
• Built Power Play Reports based on the cubes and published to Report Net Server

Environment: Cognos 8.2/8.3 BI Suite, Cognos Report Net 1.1 MR3 (Framework Manager, Report Studio, Transformer and Query Studio), DB2, Impromptu 7.4,Cognos Power Play 7.4, Cognos Transformer 7.4,Informatica 7.0, T-SQL, Teradata, Hyperion, XML and HTML.

Confidential, NYC Aug07 – Jan 08
Cognos Developer

Description: Confidential is one of the world’s leading creators of entertainment content, with brands that engage and connect diverse audiences across television, online, mobile, games, virtual worlds and consumer products. The company’s portfolio has more than 150 television channels and 400 digital media properties worldwide. Recognized across the globe, Confidential diverse holdings allow all of the network’s programming services to be seen worldwide.

Responsibilities:

• Analyzed Business requirements from the analysts.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework Manager Security for Data access, Object level access and Package access based on the Organization Level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Upgrade the report and packages version of COGNOS from 8.0 to 8.1 and Participate in the regression testing and unit testing.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Designed models & cubes in Cognos 7.2 Transformer using existing IQD’s from Framework Manager.
• Worked on Analysis Studio to develop multi-dimensional reporting.

Environment: Cognos 8.0/8.1 Bi Suite (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Transformer and Event Studio), Teradata, JavaScript and HTML, MS Visio Standard 2003, Impromptu 7.4, Cognos Power Play 7.3, Cognos Transformer 7.3, Oracle 9.2i client, VB Script, SQL and PL/SQL, IIS, Windows XP Professional.

Description: Confidential is a leader in the globalization of services and a pioneer in managing business processes for companies around the world. The company combines process expertise, information technology and analytical capabilities with operational insight and experience in diverse industries to provide a wide range of services using its global delivery platform.

Responsibilities:

• Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Involved in Creating IQD files from Report net and designed Power play models in Transformer
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Created Dash board reports to get all the information from other reports.
• Production Support, which involves solving user problems.

Environment: Cognos Report net 1.1 MR2 (Framework Manager, Query Studio, Report Studio), Impromptu 7.2, Power Play Enterprise Server 7.2, Transformer 7.2, Informatica 7.0, Oracle 9i, T-SQL, XML and HTML.