SUMMARY

14 years of IT experience in analysis, design development, implementation of Data warehousing, as well as in Business Intelligence tools such as COGNOS BI and Data Modeling. Experience in Cognos Connection, OLAP building on client-server environment and Oracle, SQL Server, DB2 based applications with Windows XP/NT, and Unix Solaris, AIX operating systems. Expertise in full life cycle development with emphasis on project management, user acceptance programming and documentation. Experience in Insurance, Telecommunications, healthcare, financial automotive industries and Department of Education. As a team player with strong communicational, organizational and problem solving skills and is confident interacting with all levels of professionals.

TECHNICAL SKILLS

• Business Intelligence: Cognos BI / Suite 10.2 PowerPlay Studio, Report Studio, Query Studio, Analysis Studio, Metric Studio , Framework Manager, crystal Reports, Business Objects,
• ETL Tools: Informatica, Cognos Decision Stream.
• Programming: Visual Basic, Java, JSP, ASP, C, SQL/SQR, SQL, PL/SQL
• Web Portal Technologies: XML, HTML 4.0, DHTML, JavaScript, VB Scripting,
• Front End: Developer 2000, Designer 2000, Lotus Notes, Visual Interdev, Visual Basic6.0, PowerBuilder5.0.
• Modeling Tools: Erwin4.1, Rational Rose, UML.
• Databases: Oracle 8.x, 9i, 10g , DB2 UDB, Sybase 12.0, Informix, MS Access2000, SQL Server 2007, Netezza 7.0
• Operating Systems: Windows NT 4.0, Unix Solaris, AIX , VM-Ware Linux , Windows XP/'07.
• Hardware: RS 6000, HP E8400. SUN, IBM, PENTIUM PC.

PROFESSIONAL EXPERIENCE

Sr Cognos Developer/Administrator

Responsibilities:

• Involve designing Dimensional modeling, Star Schema.
• Create functional and technical design report specifications and best practices documents.
• Requirements gathering and Understanding the business process and users requirements.
• Validation of the business rules and requirements for the report categories.
• Design and Development of the Metadata/Cognos Framework Models.
• Develop Business Reports, Ad-hoc Reports using Report Studio and Query Studio.
• Develop Transformer models, Cubes, dashboards and Performance metrics.
• Administer Cognos application and monitor server performance.
• Provide corporate user security using Active Directory.
• Provide Ad-hoc reporting capabilities to users.
• Provide functional and design specification documents.
• Coordinate and work with offshore team for the reporting development effort.
• Testing efforts to ensure issues are identified, tracked, reported and resolved in a timely manner.

ENVIRONMENT: Cognos BI Suit 10.2, Report Studio, Query Studio, Framework Manager, SQL Server 2008 R2, Netezza 7.0, Informatica 9.2, Windows XP, Windows NT.

Confidential

Sr. Cognos Analyst

Responsibilities:

• Administer Cognos application and manage user security using active directory.
• Monitor server performance and implement server patches and Cognos fix pacs.
• Involved in report requirements gathering.
• Developed Framework Manager Model and published to Cognos connection.
• Developed Report specifications, design documents.
• Developed Cognos reports using Report Studio and Query Studio.
• Troubleshoot and resolved production reports issues and performance tuning.
• Test reports for data validation optimizing performance.

ENVIRONMENT: Cognos BI Suit 8.4.1, Report Studio, Query Studio, Framework Manager, Oracle 10g R2, TOAD, Windows XP, Sun Solaris 10.

Confidential Sr. Cognos Developer

Responsibilities:

• Report requirements gathering for Reporting.
• Developed Framework Manager Model and published to Cognos connection.
• Developed Cognos active reports using Report Studio and Ad-hoc reports using Query Studio.
• Developed Transformer models and Generated Cognos cubes.
• Designed multiple portlets with crosstab reports/ dashboards and created portal pages.
• Created Summary Dashboards using Business Insight.

ENVIRONMENT: Cognos BI Suit Cognos 10.1.1, Report Studio, Query Studio, Transformer, Business Insight, SQL Server 2007, Oracle 10g R2, TOAD, LDAP Active Directory, SQL DTS, Visio, Windows XP.

Confidential Tech Lead/Cognos Administrator

Responsibilities:

• Cognos administration and support that includes software install, upgrade, configuration, application security, load balancing, SAN capacity planning and admin support to multiple development teams.
• Report requirements gathering for Reporting.
• Documenting reporting requirements and develop architectural design, hardware and software specifications.
• Provide strategic planning and project framework to management.
• Involve designing Dimensional modeling, Star Schema.
• Create functional and technical design report specifications
• Develop, design, and publish Cognos framework models.
• Develop Business Reports, Ad-hoc Reports, Dashboards and Performance metrics.
• Develop standard report templates and developer best practices.
• Test reports for data validation and performance tuning.
• Assist DBA team to implement applications in ITC and Production environments.
• Participated in training to business users to teach easy Reports navigation on portal.
• Create and maintain user security
• Production support for Cognos monthly refresh, update data source connections, scheduling reports, setup cron jobs, trouble shoot issues to resolved production incident tickets.
• Upgrade Cognos ReportNet to higher version and upgrade Cognos framework models
• Co-ordinate with ITC and Production teams to deploy applications.
• Administrative support other internal Cognos teams.

ENVIRONMENT: Cognos ReportNet, Cognos BI Suit 8.2, Access Manger, Oracle 10g R2, TOAD, Unix-Sun Solaris, PVCS, Oracle OWB, Visio, Erwin 4.1

Confidential Sr.Cognos Developer

Responsibilities:

• Designed technical documentation.
• Creating detail technical design document which specify the reports and tools along with the SQLs, the logics and method of delivery.
• Create a Framework Manager project and import the required metadata, creating a business view that contains model query subjects and shortcuts.
• Add business rules, such as calculations, filter, and prompts that define the information users can retrieve.
• Creating List and Crosstab Reports and customize reports with conditional formatting.
• Creating the Chart to present data graphically.
• Setup drill-through target from other cognos applications.
• Customize cognos portal with new logos, portal name.
• Develop Architectural design document, Hardware and Software specifications document.
• Develop Standard Report templates, developer best practices document for reports and framework models.
• Test reports for data validation and performance tuning.

ENVIRONMENT: Cognos ReportNet 1.1 MR2, TOAD, SQL Server, Query Analyzer, Oracle 10g, LDAP, Unix-AIX, HomeSite 5.5, Windows XP.

Confidential Sr.Cognos Developer

Responsibilities:

• Analyzing user requirements.
• Created metadata models from corporate data using Framework Manager and published packages to CRN Server.
• Create a business view that contains model query subjects and shortcuts for user's presentation.
• Created corporate Report Template.
• Created List, Crosstab, and Chart reports.
• Added business rules, filter, calculations and prompts to reports.
• Set up as drill through targets from other cognos reports.
• Manage reports in cognos connection.
• Creating Technical design documentation and troubleshooting.
• Tested reports for data validation optimizing performance.

ENVIRONMENT: Cognos ReportNet 1.1 MR2, SQL Server, Query Analyzer, PL/SQL, Crystal 11.0, Visual SourceSafe 6.1, Windows NT.

Confidential Sr.Cognos Developer

• Involved in Requirements Gathering for Reporting.
• Installed and configured Framework Manager to Cognos Connection.
• Involved in Analysis, Design and Development of ReportNet models.
• Created Alias tables and folders in model for user's presentation.
• Published the models to ReportNet server.
• Developed List Reports, Crosstab Reports and Charts.
• Used Cascading Prompts for users selection criteria.
• Used Conditional Blocks to display data upon the prompt selections.
• Created Report Templates with customized Headers and Footers.
• Prepared Cognos Web Portal Documentation.
• Tested the reports for Data validation.

ENVIRONMENT: Cognos ReportNet 1.1 MR2, Framework Manager, Oracle 8i, TOAD, LDAP

Confidential Cognos Developer

Responsibilities:

• Involved in creating and developing catalogs, impromptu reports as per user requirements.
• Involved in developing OLAP metadata for report generation.
• Installed and configured Cognos Software Client Tools.
• Created Power play reports and multidimensional cubes.
• Customized data by adding calculations, summaries and functions.
• Used various functions for calculation and manipulation using Cognos Impromptu.
• Created complex List Reports, Cross-tab Reports and Drill through Reports.
• Worked with Transformer to create models by using IQD as Data source.
• Designed and developed the powerplay cubes and Drill Through cubes.
• Involved in Performance tuning of Powerplay Cubes, Impromptu reports and IWR reports.
• Created Packages in Framework Manager and published to CRN server.
• Created Reports in Report Net using Report Studio.
• Involved in setting up testing environments.
• Involved in Reports Testing in different testing environments as Integration Testing, System testing and User acceptance testing.
• Involved in fixing report defects in testing environments.
• Documented functional specifications and design procedures.

Environment: ReportNet1.1, Framework Manager, Cognos Enterprise Edition7.2, Cognos Impromptu 7.2, PowerPlay 7.2, Access Manager, Cognos Enterprise Server, Upfront, DB2, Oracle 9i, win SQL, TWS, Unix , Visio, Windows NT.

Confidential Cognos Developer

Responsibilities:

• Involved in Gathering report requirements, Dimensions and measures.
• Created prototypes of cognos reports.
• Designed and developed catalog and used catalog filters and calculations.
• Developed Impromptu reports and published to Cognos Upfront.
• Designed and developed Powerprompt screens to dynamically run reports based on cascading prompt selection.
• Prepared Design procedures and Functional Specifications document and troubleshooting.
• Involved in unit testing and integration testing and successfully moved in to production.

Environment: Cognos Enterprise Edition 7.2, Cognos Impromptu 7.2, Cognos Enterprise Server, Powerprompts, Java Script, HTML, DB2, Oracle 8i, Oracle Designer, Homesite 4.2, SQL Navigator, Windows NT

Confidential Cognos Developer

Responsibilities:

• Involved in designing Architecture and system specifications requirements.
• Prepared prototypes of all the reports and an approval for the requirements and the prototypes were obtained from business owners.
• Created complex List Reports, Cross-tab Reports and Drill through Reports.
• Used Cognos Impromptu to create Catalog files, created IMR/IQD and Cubes using Cognos 7.2 Series, Impromptu and Transformer.
• Developed Power prompts to dynamically run the report based on user prompt selections.
• Published Impromptu Web Reports IWR on Cognos Upfront.
• Designing and developing the required cubes and Drill Through cubes for the project Dealer Operations.
• Testing and validating the data on Impromptu reports as well as Cognos Cubes.
• Created / enhanced catalogs and set User profiles to grant user permissions for querying.
• Created different joins according to User requirements.
• Documented Powerplay cubes and IWR Reports.
• Involved in Performance tuning of Powerplay Cubes and IWR Reports.
• Created Architect model using Cognos Architect from different sources.
• Generated reports using Cognos Impromptu.
• Used various functions for calculation and manipulation using Cognos Impromptu.
• Testing and validating the data on target data system.
• Documented design procedures, operating instructions test procedures and troubleshooting procedures.
• Successfully move the programs in to production.

Environment: Cognos Enterprise Edition 7.2, Cognos Impromptu 7.2, Cognos Script, Power Play 7.2, Power Prompts, Access Manager, Cognos Enterprise Server 7.2, Java Script, Sybase 12.0, Rapid SQL 7.1, Unix AIX, Windows NT.

Confidential Cognos Developer

• Gathered reports requirements with Business Users and converting them in to project documentation.
• Created Informatica ETL mappings that transfer data from Oracle and Flat File source systems to the ODS and Data Mart.
• Used aggregator, updated strategy, Lookup, stored procedure, Filter and Expression transformation.
• Created reusable transformations and mappings.
• Configured and ran test sessions using Server Manager available with Informatica.
• Installed and configured Cognos Software Client Tools.
• Involved in developing OLAP metadata for report generation.
• Created catalogs and provided security to client / server balance.
• Generated reports using Cognos Impromptu tools querying database.
• Customized data by adding calculations, summaries and functions.
• Designed Catalogs that stores the reporting data.
• Queried from different database tables as per the requirement.
• Created models by using IQD as Data source using Transformer.
• Generated Multi-Dimensional reports using Power Play Cubes.
• Published Power Play reports to Upfront.
• Drilled down, sliced, diced and changed displays.
• Developed Impromptu Web Reports IWR .
• Developed graphical representation of entire data using Visualizer.
• Published charts on upfront using Visualizer Server Administration.
• Used KPI to monitor the current Business Status in PowerPlay resports.
• Defined PowerPrompts to guide users through actions.
• Participated in training to business users to teach them easy Report navigation.
• Prepared user/technical documentation.

Environment: Cognos Enterprise Edition 7.0, Cognos Impromptu 7.0, PowerPlay 7.0, IWR 7.0, Cognos Enterprise Server 7.0, Power Play Web, Cognos Visualizer, Cognos Script, Access Manager, Upfront, TOAD, PVCS VM, Informatica PowerCenter.5, Erwin4.5, Power Prompts, Visio, HTML, Oracle 8i, SQL Server, Sun Solaris 7.0.

Confidential Cognos Developer

• Developed Object models using Rational Unified Process and Use cases.
• Designed and developed OLAP data Modeling, database schemas using tools like ERwin and warehouse designer of Informatica.
• Installed and configured the PowerCenter Client Tools.
• Created ETL scripts with the help of Power center Informatica .
• Create and administered repositories using Repository manager of Informatica.
• Used Architect model, which describes the enterprise reporting, and querying environment of the production metadata sources.
• Scheduled sessions and transformations using designer tool of Informatica.
• Imported the source definitions from Oracle database and also Flat Files using the Source Analyzer.
• Imported the target definitions using the Warehouse Designer of PowerCenter.
• Created of Mappings using the Mapping Designer of PowerCenter.
• Developed object models and flow charts using Rational Unified Process UML .
• Created shell scripts to run the sessions and batches on informatica server.

Power Play Reports:

• Created Multi-Dimensional reports using Power Play.
• Worked with Transformer to create models by using IQD as Data source.
• Data retrieval, Multidimensional analysis, Power Play structure.
• Created and enhanced existing Power Cube as per user requirements.
• Defined PowerPrompts to guide users through actions.
• Generated financial reports on distributor sales.
• Generated HR reports for exchange of personal information and available resources.
• Customized the content of reports and publishing to Upfront.
• Changed filters, layers and measures.
• Exception Highlighting, sorting, ranking etc.
• Implemented KPI in PowerPlay reports.
• Performed Reporter operations such as Sum and Average, Intersection, etc.,
• Developed dashboards using Gauge charts, Bar charts, Pie charts.
• Published on UpFront using Server Administration, also involved in performance optimization.

Developing and Customizing Impromptu Web Reports:

• Generated reports using Cognos Impromptu tools querying database.
• Customized data by adding calculations, summaries and functions.
• Created Cross Tab Reports and drill through reports.
• Scheduled catalogs and PowerPlay repots using Cognos Scheduler.
• Created Prompts for web reports to meet individual reporting requirements.
• Designed Meta data, which stores the reporting data.
• Queried from different database tables as per the requirement.
• Created reports in HTML format for easy navigating of data from web browser.
• Involved in data model that supports the identified reporting requirements using Erwin tool

Environment: Oracle 8.1.5, SQL Server, Informatica 1.5, Cognos Power Play 6.6, Cognos Impromptu 6.0, IWR 6.0, Cognos Scheduler, Cognos Visualizer1.5,PowerPrompts, Cognos Enterprise Server 6.61, Java 1.2, WebSphere, HTML, Java Script, UML, Win NT, Unix, MS-Projects, MS-Excel.

Confidential Cognos Developer

Power Play Reports:

• Created and enhanced existing Power Cube as per user requirements.
• Used DSS Architect for designing the Data Modeling.
• Created Multi-Dimensional reports using Power Play.
• Drilled down, sliced, diced and changed displays.
• Exception highlighting, sorting, ranking etc.
• Performed Reporter operations such as sum and average, intersection, etc.,
• Knowledge on Creating Business views, reports for financial status and inventory control.
• Knowledge on creating RDA, TDA for business view generation.

Developing and Customizing Impromptu Reports:

• Generated reports using Cognos Impromptu tools querying database.
• Meta data Management.
• Customized data by adding calculations, summaries and functions.
• Created List Reports and Cross Tab Reports and Drill through reports.
• Created the Business Mix report and Top Ten reports.
• Created standard and Adhoc reports using Cognos Impromptu tool.
• Developed front-end screens using PowerBuilder Foundation classes.
• Reports were presented using Portfolio.

Environment: Cognos PowerPlay, Cognos Impromptu, Transformer, PowerBuilder5.0, HTML, Java Script, DB2, Oracle 8i, SQL Server, AIX and Windows NT.

Confidential Programmer

• Generated reports using Crystal reports.
• Created different joins according to requirements, also created database definitions.
• Managed the impact on the network and database.
• Created Meta data to store the analyzed data for reporting.
• Optimized by Query performance
• Created the time dimension properties as per the requirement.
• Created reports in PowerBuilder for easy navigation of data from web browser.
• Created template for impromptu reports and mailing labels.

Environment: Oracle Developer2000, Oracle Forms, PowerBuilder5.0, HTML, Oracle 7.3 Crystal Reports, DB2, UNIX AIX, Win NT.

Confidential

Programmer

Automated Inventory and Account Tracking System

• Involved in design and development of an application for automation of cement factory. This interactive application has the following features.
• Alerted officials about depletion of raw material and auto ordering of raw materials.
• Kept trace of consumer payments and interest calculations.
• Accepted orders from consumer and allot goods taking into a account the priority or demand of each consumer
• Involved in configuration management and quality assurance
• Simple Report generation on daily statistics using Actuate reports.
• Generated master detail reports and mailing labels using Actuate.
• Responsible for development of tracer for raw materials using PL / SQL and Oracle reports

Environment: Oracle PL /SQL, Oracle Designer and Forms4.5, Crystal Reports , Actuate 4.1, Visual Basic, SQL Server.

Library Management System

• Library management system is user-friendly software used for the maintenance of a library. It maintained the transaction of books, record of members and the list of returnable books. It provided reports such as categorized by members, group codes, author and publishers. It also gave the listing of members, issues, outstanding and all the facilities and options required for an efficient library management system.
• Analyzed the requirements and prepared the analysis report.
• Designed and developed the forms to enter item details and item issues, developed the stock report.
• Created simple, cross tab reports with report wizard.
• Hyperlinked from one report design to another.
• Created mailing labels.
• Tested and implemented
• Prepared the user / technical documentation.

Environment: Visual Basic, Oracle 7.1, Crystal Reports, SQL Server, Actuate 4.1, Windows 95.

Confidential

• Analyzed the requirements and prepared the analysis report.
• Developed Java Applets.
• Developed Server procedures using JDBC for accessing database.
• Involved in developing Java Servlets to capture data from Server Objects.
• Used Java Script for front forms validation, also performed testing and implementation.

Environment: Oracle 7.1, Visual Basic, SQL Server, Java, Java Applets, Java Script, Servlets, Windows '95.