Summary:

• Over 7 years of IT Experience with Analysis, Design, Development, Customization and Implementation of various Software applications and generation of reports using Various Databases.
• 5+ years of experience in Cognos Suits OLTP/OLAP/Data Warehouse reporting tools Impromptu Administrator, PowerPlay, Transformer, Access manager, Impromptu Web Reports (IWR), PowerPlay Web Reports (PPES), Upfront, Scheduler and Visualizer.
• Experience in Report Net with Framework Manager, Report Studio, Query Studio and Cognos Connection.
• 4 years of Experience working with Cognos 8.x BI tool, Analysis Studio, Event Studio, Report Studio and Query Studio and Dashboard reports.
• Created and managed reports in Zero-footprint environment using Report Net.
• Experience with Various RDBMS Oracle 11g/10g/9i/8i, Microsoft SQL Server 2000/2005
• Working knowledge of designing multidimensional architecture for Extract, Transform, Load environment with Cognos tools and Informatica.
• Solid understanding of data warehousing, Data Marts, OLTP and OLAP concepts.
• Expertise in Data Modeling for DW using Erwin.
• Expertise in Business process modeling, Data analysis and Business Requirement gathering.
• Experience in developing applications using Oracle 9.x/8.x/7.x, Forms, Reports, SQL, PL/SQL, SQL Server 2000, and SQL Server 2005
• Excellent Communication, Interpersonal and Organizational skills.
• Experience in Migration Projects as well Maintenance and support of existing Reports and OLAP Cubes.
• Provided Professional Cognos & DW Training to the Resources.
• Good team player with excellent communication skills, analytical and learning new technologies.

Education:

BS in Electrical Engineering

Software/Hardware:
Cognos Impromptu Administrator7.x, Power Play 7.x, Transformer, Upfront, Access Manager, Impromptu Webreports (IWR), Power Play Web reports, Powerplay Enterprise Server, Scheduler, Cognos ReportNet1.1 and Cognos 8.x (Framework Manager, Query Studio, Report Studio, Analysis Studio ) Erwin, HTML, XML, SQL, PL/SQL, T-SQL and C,C++, Windows 98/NT/2000/XP, UNIX, Toad, Oracle 7.x/8.x/9.x,/10g/11g SQL Server 2000/2005 , MS Access ,MS DTS, IBM DB2

Experience:

Confidential,Orangeburg, NY Mar 2008-Current

Sr. Developer/Programmer/Administrator
Confidential,is No one CDMA Provider in USA. The Project goal was to consolidate their Data Warehouse as well Payroll system. The Project also involved in Migration from Cognos 7.3 to Cognos 8.3 and 8.4 as well as to Design and Build New Framework Models, Reports and Cubes for Various applications.

Responsibilities:

• Involved in Full life cycle of the Project from Development, Basic Admin work ,Ad-hoc testing as well Troubleshooting and support for the production applications.
• Functional lead on the Modules like Payroll/HeadCount/ELMApplications
• Extensive Interaction with Business Users for gathering Businesses Requirements
• Involved in Development of Cognos 8.3 Reports, Cognos 8.3 Cubes
• Involved in Administration tasks as tracking user activities, roles , groups
• Created and Maintained Data Sources on Cognos Connection Portal
• Involved in Export/Import Process of Cognos Objects as well Migrated No of Objects from 7.4 to 8.4 using migration assistant
• Involved in Installation and configuration of Cognos Reportnet 1.1, Cognos Frame Work Manager 8.3,IBM Cognos 8.4 Framework Manager
• Created Complex List Reports, Cross tabs Reports, Drill through, Master-Detail Relationships, Cascading Prompts, Charts, and Maps.
• Build the Customized Framework Packages and Published those to Cognos Connection Portal
• Customized data by adding filters at both the Framework level and Report level.
• Formatted reports using conditional formatting
• Experienced with trouble shooting and optimizing cube performance
• Developed advanced Reports using Report Studio, Worked with Dashboard Reports.
• Set up the Bursting tables in the Database as Well at the Framework Package Level and Performed bursting among no of user community
• Involved in migration of Cognos Objects from version 7.4 to 8.4
• Troubleshooting and Maintenance of Migrated Reports from Version 1.1 to 8.3
• Did analysis studio Reports for analysis and testing purpose.
• Created organized report folders and other contents on Cognos connection Portal.
• Customized data by adding filters, Calculations, Prompts, Summaries and Functions.
• Provided training as well end user support with reports.
• Test and debug cognos Metadata Layers.
• Performed ad-hoc testing.
• Ran SQL queries and Procedures for troubleshooting , testing and analysis of data
• Ran SQR as well PL/SQL Programs for Data Loading

Environment:
Cognos 8.3 FrameWork Manager, Cognos Connection, Cognos Report Studio 8.3, Cognos Query Studio 8.3, Cognos Analysis Studio 8.3, Windows XP Professional, Oracle 10g,Oracel 11g, Toad 9.0, Linux, Putty , IBM Cognos 8.4, Migration Assistant

Confidential,Marietta, GA Oct 2007- Feb 2008
Cognos BI Developer
Confidential, Is a leading and Growing Pharmaceuticals. It has diversified business, which also involves Manufacturing, Invention of Drugs and by Products. The Project goal was to create some of the reports and cubes to meet their requirements.
Responsibilities:

• Involved in gathering Business Requirements.
• Involved in Creation of Cognos 8 Reports, Dashboard Reports.
• Created Complex Reports using Report studio , Plugged Prompts , Drill through

Master- Detail Reports.

• Built Framework Manager Models, Did Database Connections and Published to the Reportnet server.
• Created Cognos Cubes and use it in Framework Packages.
• Created burst table and did Bursting of reports.
• Developed No of Charts and customized it according to requirement.
• Experienced with trouble shooting and optimizing Report performance.
• Customized data by adding filters at both the Framework level and Report level.
• Formatted reports for various Output formats.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Created List Reports, Cross tabs, Cascading Prompts
• Customized data by adding Filters, Calculations, Prompts, Summaries and Functions.
• Provided Training and End User Support with my reports and also Knowledge transfer.

Environment:
Cognos FrameWork Manager 8.1, Cognos Connection, Report Studio, Query Studio, Windows XP Professional, Oracle 10g, Toad 8.6.

Confidential,Aug 2007 – Oct 2007
Cognos Consultant
Newark Beth Israel Medical Center is among the top 10 leading Medical Center in the country and The Project goal was to create some dashboard reports as a Part of Pilot Project.
Responsibilities:

• Involved in gathering Business Requirements.
• Involved in Creation of Cognos 8 Reports, Metrics Manager, and Dashboards Reports.
• Created Complex Reports and also developed charts for various users.
• Built Framework Manager Models, Did Database Connections and Published to the reportnet server.
• Created MSAS Cubes and use it in Framework Packages.
• Experienced with trouble shooting and optimizing Report performance.
• Customized data by adding filters at both the Framework level and Report level.
• Formatted reports for various Output formats.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Developed advanced Reports using Report Studio.
• Created List Reports, Cross tabs, Drill throughs, Cascading Prompts, Charts.
• Customized data by adding Filters, Calculations, Prompts, Summaries and Functions.
• Provided Training and End User Support with my reports and also Knowledge transfer.

Environment:
Cognos FrameWork Manager 8.1, Cognos Connection, Report Studio, Query Studio, Windows XP Professional, Microsoft SQL Server 2000/2005, MSAS, SSAS, DTS

Confidential,Los Angles, CA Mar 2007– Aug 2007
Cognos ReportNet Consultant
Confidential,is the fastest growing auto insurance company and is a source of summary information for executives on various components like Claims, Membership, Customer Service, and Provider Network. The goal of this project is to automate the entire claims component by making changes to Data warehouse and create reports for various clients and internal persons.
Responsibilities:

• Functional lead in Claims, Events and Exhibits packages. Took decisions pertaining to the report design.
• Interacted with Business Users for Reporting Requirments.
• Involved in gathering Business Requirments.
• Involved in Creation of Cognos 8 Reports, Cognos 8 Cubes, and Dashboards Reports.
• Build Model, Created database Connections, and Published Packages in Frame Work Manager.
• Experienced with trouble shooting and optimizing cube performance.
• Customized data by adding filters at both the Framework level and Report level.
• Formatted reports for various Output formats.
• Created organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Developed advanced Reports using Report Studio.
• Created List Reports, Cross tabs, Drill throughs, Cascading Prompts, Charts, and Maps.
• Involved in Installation of Cognos Reportnet Server, Frame Work Manager, Report Studio, Query Studio, and Cognos Connection Portal.
• Performed Bursting Reports and Multilingual Reports using Report Studio and Query Studio.
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions.
• Provided Training and End User Support with my reports and also Knowledge transfer.
• Tested and Debugged Cognos Metadata Layers.
• Performed Unit testing.

Environment:
Cognos 8, FrameWork Manager, Cognos Connection, Report Studio, Query Studio, Windows XP Professional, Oracle 9i, Toad 8.0, Informatica Power Center 7.0, IBM DB2

Confidential,Nashville, TN Feb 2006 – Feb2007

Project goal is to meet the users and get the requirements and develop a set of reports and for user access and develop a Data Warehouse for analysis and decision support in areas of Tracking the Physician, Patients, Costs, by sourcing Data Warehouse system and to Create Reports & Cubes in for Internal users and Clients.
Responsibilities:

• Involved in Installing and Configuring ReportNet Server, FrameWork Manager, ReportStudio, QueryStudio and Cognos Connection Portal.
• Involved in understanding the Business in all Departments.
• Interacted with business users for their requirement.
• Involved in Startegic Planning for Cognos ReportNet Framework Model.
• Built Models and published Packages utilizing Framework Manager.
• Created database connections for different data sources.
• Created Reports (Simple & Complex) using Query Studio and Report Studio for training purpose.
• Created, organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab) Reports and represented data graphically by Charts utilizing Query Studio. Created several different types of Professional Reports (Mailing Labels, Web Page Style, Cascading, Linked /Drill Through, Production, Business, Ranking, ets…) with complex formatting utilizing Report Studio.
• Created reports for various departments like Finance, Sales, HR, Inventory, and Production.
• Developed, Customized and Burst Reports using Report Studio.
• Produced Queries and Reports in Multiple Languages, Format, Present and Distribute Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical Pages.
• Involved in Conversion of Impromptu catalogs into Reportnet 1.1
• Created, Ran and Scheduled Reports and Jobs using Cognos Connection.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Tested and debugged Cognos metadata layer reports.
• Developed Standard templates in Report Studio for developing reports.
• Wrote SQL and Stored Procedures.
• Performed Unit testing for all developed reports.

Environment:
Reportnet1.1MR1, Framework Manager, Query Studio, Report Studio, Cognos Connection, Windows 2003, SQL Server 2000, Informatica Power Center 7.0

Confidential,Weston, FL Nov 2004 - Jan 2006

Confidential,is a leading specialty pharmaceutical company that uses innovative science and market insight to develop responsive products for a changing world. Since its founding Andrx has pursued a growth strategy combining internal product development, strategic alliances and collaborations, and synergistic acquisitions of products and businesses.
Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, develop, testing, deployment and user training of analytical &transactional reporting system.
• Involved in development of Report Net with Framework Manager, Report Studio, Query Studio and Cognos Connection.
• Involved in design and development of user classes, filters, calculations, prompts and conditions in Catalog and query definition files in Impromptu Administrator.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance (in Governor\'s settings).
• Discussed business requirements and mapped business needs using Cognos Transformer.
• Successfully developed and implemented Metrics using Cognos Impromptu.
• Developed Visualizer Charts to make better decisions.
• Created Architect models for business requirements including Joins, Prompts, and Filters.
• Used Cognos Query for ad hoc Reports and Users design Custom Queries on the Web.
• Installed, Configured and did Performance Tuning Cognos EP Series as Business Intelligence tool.
• Involved in Report Administration & Server Administration.
• Performed Data Modeling using Erwin.
• Used stored procedure to return a value (like a function call) and created a result set in the same way as an SQL SELECT statement.

Environment:
Cognos Report Net MR1.1, COGNOS EP Series 7.x (Impromptu Administrator, Impromptu Web Reports Power Play, Transformer, Power Play Enterprise Server, Access Manager, Server Administrator, Upfront (for Web), HTML, XML, Netscape Directory Server, Oracle 8i/9i, MS Access, SQL, PL SQL, Toad, and Window.

Confidential,Roswell, GA Jul 2003 - Nov 2004

Confidential,is the world\'s largest package delivery company and a global leader in supply chain services, offering an extensive range of options for synchronizing the movement of goods, information and funds. Its business unit, UPS Supply Chain Solutions, offers transportation and freight services, logistics and distribution, consulting, and international trade services.
Responsibilities:

• Extensively interacted with Business Users and gather information and requirements.
• Developed and created classes with Dimension & Measure Objects and specified the hierarchies.
• Worked extensively on Oracle database. Troubleshoot for SQL issues/performance issues.
• Installed and configured Cognos Power Play and Impromptu software.
• Participated in the development of catalogs, multiple queries with complicated reports and query definitionfiles using various join and filter conditions in Impromptu.
• Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through.
• Performed detailed reports, catalogs, folders filters, prompts, calculated columns and conditions for multi dimensional analysis.
• Defined, and created Impromptu web reports using Distribution Shuttle Builder.
• Published on IWR Server.
• Worked extensively with Power Play Enterprise Server and the Upfront in publishing the cube.
• Automated tasks with Cognos Scheduler using Macros, Cognos Script Editor and Cognos Script Dialog Editor.
• Created Snapshots to minimize data processing when the network traffic for the database is heavy.
• Optimized Catalog by using Database Interaction, Client/Server balancing, and Database functions, Table Weighting and Qualification, Governors Settings.

Environment:
Cognos Impromptu 6.06, Cognos Power Play 6.6, Cognos Transformer, Cognos Impromptu Web Reports, Cognos Power Play Enterprise Server, Access Manager, Cognos Upfront, SQL *Loader, Oracle 9.0, Windows NT/2000.

Confidential,Newark, NJ Sep 2002- Jul 2003

Confidential,is one of the leading financial Corporations in North America. Used Cognos as front end and Oracle as back end and ReportNet to develop and publish web reports.
Responsibilities:

• Designed and developed catalogs that reflect business view of the data.
• Extensively interacted with users to develop catalogs and various reports as per their requirement.
• Integrated multiple feeds from relational sources.
• Extensively used Power play Transformer to move relative data mart data into power cubes and Power play reports.
• Automated reports and cube generation through scheduler using macros.
• Published Impromptu Web Reports using Distribution Shuttle Builder created posting folders, plp file to NT server.
• Published cubes and power play reports to UPFRONT through PPES administration.
• Trouble shot and evaluated report effectiveness by tuning query data’s and controlling user access.
• Installed various Cognos tools, performed ODBC connections/defined data sources.

Environment:
Cognos Impromptu, Power Play, PP Enterprise Server Oracle 8, Windows NT/2000,
Upfront (for Web) and Access Manager.