SUMMARY:

• OverSeven years of professional experience in analysis, design and development of financial, insurance and marketing systems.
• Experienced in using various Cognos tools such as Cognos 8BI, Cognos CAFÉ, Report Net (Framework Manager, Report studio, Query studio, Analysis studio, Event Studio, Cognos Connection), Impromptu, Impromptu Web Reports (IWR), PowerPlay, Transformer and Access manager.
• Proficient in designing Model using Framework Manager, Query Studio and Report Studio for ad-hoc reporting and Advanced Report Authoring.
• Experience in Designing, Developing and Maintaining Catalogs, Cognos Impromptu and PowerPlay Reports. Using PowerPlay Transformer created Multidimensional models and Cubes.
• Created Score Cards, Dashboards and Key performance Indicators for decision support using Metric Studio.
• Knowledge in ETL processes/mappings with the collection of Sources, Targets and Transformation, using Informatica Designer.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience in Oracle 10g/9i/8i,PL/SQL,SQL,TOAD, Stored Procedures, Functions, Triggers and SQL Server 7/2000.
• Worked on complete Life Cycle Development process, which includes analyzing business needs, documenting business information requirements, technical designs, development, integrating, Implementing and Production Support using Cognos as a BI tool.
• Excellent communication, organizational and problem solving skills and ability to work individually or in a group.

TECHNICAL SKILLS
BI Tools: Cognos 8.4, 8.3, 8.2, 8.1 BI: Frame work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio, Cognos Planning.
ReportNet 1.1: Cognos Connection, Framework Manager, Query Studio, Report Studio, Configuration Manager, Scheduler.
COGNOS Series 7.x: Cognos Impromptu Administrator, Impromptu Web Reports, Cognos PowerPlay Transformer, PowerPlay Web Reports, PowerPlay Enterprise Upfront Administration, Access Manager, LDAP Server, Configuration Manager, Scheduler.
RDBMS: Oracle 8i/9i/10g, SQL server 2005, Teradata, MS Access.
Languages: SQL, PL/SQL, Java,J2EE, C, C++, VB.
PM Tools: Microsoft Project
CRM Tools: Salesforce.com
Other: HTML, Javascript, XML

EDUCATION:

Masters in Information Systems

Bachelor of Computer Science & Engineering

Certifications:

IBM Cognos 8.4 Certified Report Author.
Cognos Reportnet Product Professional.

PROFESSIONAL EXPERIENCE:

Confidential,Itasca, Chicago May 2007- Present
Role: Sr. Cognos Developer/Admin

Environment: Cognos 8.2 and Cognos 8.4(Report Studio, Query Studio, Analysis Studio, Metrics Manager, Powerplay Transformer 7.4,Access Manager 7.4,CAFÉ 8.3),Cognos Planning 8.4.
Database: MS SQL Server 2005; ERP: JD Edwards; ETL: Data Manager

Description: Confidential,is a Sales and Marketing Company dedicated to provide excellence in Risk Management Services. I worked as a report developer in a team which was responsible for creating custom reports using data in following subject areas General Ledger, Accounts Payable, Accounts Receivable and Fixed assets module.

As a senior report developer my responsibilities include

• Involved in gathering and documenting reporting requirements from business users.
• Involved in JAD sessions with user
• Worked on numerous flavors of Income Statement and Balance Sheet which is used for SEC reporting.
• Worked on creating pixel perfect report which is used for reporting to senior management and SEC. Worked extensively using report studio and build reports against relational model, DMR model and cube.
• Built lot of reports for senior management using CAFÉ (Cognos Analysis For Excel) product. CAFÉ reports are built against DMR/Cubes. Creating troubleshooting and best practices guide to CAFÉ users.
• Worked on creating a financial dashboard for corporate controller to help him monitor key KPI’s. Provided drill-through capability for further analysis.
• Worked on migrating existing cognos 8.2 reports to cognos 8.4 environment.
• Administered cognos portal in both development and production environment. I was responsible for deploying reports, cubes and publishing FM models.
• Worked on creating user manual and did training to end users on creating adhoc reports using query studio.
• Worked on maintaining existing FM model
• Mentored offshore team in India to build report studio reports.
• Worked on validating the report by writing custom SQL.

Environment: Cognos 8 (Framework Manager, Query Studio, Report Studio, SDK), MDX, Oracle 10g, Cognos 7.3 Impromptu, Power Play Transformer, Power Play, IIS web server and Windows 2000, Erwin.
Confidential,is the leader in creating and delivering, Marketing and Consumer services, providing access to travel, shopping, auto and other services to over 75 million consumers primarily through direct marketing to constituents of affinity partners. The project dealt with Framework Manger, Report studio, Query studio and crafted several OLAP cubes to implement Profitability Analysis, Gross Margin, and Sales Report to enable merchandisers to monitor their assigned department on a weekly basis.
Responsibilities:

• Worked with business units to create centralized reporting capability to perform analytical and ad-hoc reporting for business applications and provide accurate information available for decision makers.
• Gathered Business requirements for creating the Models and create metadata models using the Cognos8 Framework Manager and published the packages.
• Created dimensions, levels and hierarchies using Framework Manager.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Used cognos connection for organizing, security, scheduling and distributing reports.
• Customized data by adding Filters Prompts, cascading prompts, Calculations, Summaries, Functions, Conditional blocks and Conditional reporting. Worked on multiple report pages and multiple prompt pages.
• Created and Migrated Impromptu catalogs, Impromptu reports and PowerPlay Reports from Cognos7 to Cognos 8.
• Published Impromptu web Reports (IWR) on IWR Server.
• Worked on developing Transformer cubes and publishing Power Play web reports to Power Play Enterprise Server environment.
• Responsible for documenting all the issues and solutions.

Confidential,Dallas - TX. Dec’ 2005 - May 2006
Report Developer

Environment: Cognos 8 BI, Cognos ReportNet 1.1 MR2, Framework Manager, Cognos Connection, Report Studio, Query Studio, Microsoft Access, Microsoft Excel, MS SQL Server 7.0/2000, Salesforce.com
Description: Confidential,is a provider of telecommunications services to big-small and medium-sized businesses in major metropolitan areas across the United States. The Company offers an integrated set of telecommunications services, including local, long distance, data and a full suite of Internet services. It had very complex internal and external sales database, as well as there was a challenge in every day basis to meet business user reporting requirements.
Project goal was to migrate existing ReportNet environment to cognos 8 BI environment and enhance FM model to address business users reporting requirements..
Responsibilities:

• Involved in gathering Business Requirements for the Model.
• Work with Management and Development teams to gather reporting requirements.
• Worked extensively on enhancing the Model using Framework Manager to reporting needs of the user.
• Developed standard templates, reports, charts, drill through Reports, Master Detail Reports and bursting reports using report studio.
• Created query prompts, calculations, conditions & Filters.
• Developed prompt pages, multi page reports and conditional variables.
• Scheduling and distributing reports through schedule Management in Cognos Connection.

Cognos Developer

Environment: Framework Manager, Cognos ReportNet 1.1 MR2,Cognos 7.4, Access Manager 7.4, Oracle 9i,Unix.

Description: This reporting system was implemented to improve access, distribution and integration of real time performance information of different project.

Responsibilities:

• Understand the Impromptu Catalog.
• Created ReportNet FM Model similar to Impromptu Catalog
• Created Business View of namespace and query subject as per folder structure of the Impromptu Catalog.
• Created joins as per catalog in the ReportNet Model.
• Created ReportNet reports and matched with Impromptu Report for testing.
• Externalize IQD using Framework Manager.
• Created various IQD package in Framework Manager and from this IQD, integrated to PowerPlay Transformer to create various models and cubes.
• Created User Classes in Cognos Access Manager 7.4

Application Developer

Environment: Windows NT, VB.6, MS-Access, and Oracle

Description: Confidential,we developed a health Insurance application which allows the users to store and offer the policies and keep track of premiums to be paid by the customers. This application is developed to automate policy holder\'s information which includes policy expiry and policy commencing dates. Annual reports were Automated to provide, Individual Insurance policy focus, Gathering Data about Agents and Payroll. This application also features about maintaining terms and conditions of the company and loss and profits to a particular branch.

Responsibilities:

• Involved in Database requirement planning, database roles maintenance and assigning privileges.
• Involved in Design, Creation, Normalization, screen design and maintenance of table script and integrity constraints.
• Given necessary support for developer in writing SQL-query, stored procedures and SQL query tuning.