SUMMARY

Over 8+ years of experience in DataWareHousing
Over 3 years of experience in Cognos Report net 1.1 and 5+ Years’ experience in Cognos 10 BI, Cognos 8.4/8.3/8.2 (Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos Power Play and Transformer
Certified Cognos reports developer (IBM Cognos 8 BI Author)
Having strong and working knowledge on Cognos Connection, Query Studio , Report Studio and Frame work manager
Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos
Having rich experience in creating various types of reports using Report Studio
Experienced with complete application development life-cycle including requirements gathering, analysis and design, implementing, testing and deployment
Having good knowledge on HTML and JavaScript and ability to implement those technologies in Cognos reports.
Strong working knowledge in tools like TOAD, SQL Developer etc.,

• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role.

TECHNICAL PROFIENCY

Cognos

Cognos 10 BI, Cognos 8.4/8.3/8.2 Cognos Connection, Query Studio, Report Studio & Report Net 1.1, Frame work manager
Business Intelligence Reports, OLAP solutions and designing and analyzing business and technical models.
Installation, Configuration, Developing Reports and Content administration.

Programming

C and Java

Internet Development

HTML, DHTML, CSS, XML & Java Script.
Microsoft IIS

Applications/Tools

Microsoft Office 2007, Toad, SQL *Plus and WinSqL.
Text pad.

Database

Teradata, SQL Server, Oracle & MySQL.

Platforms

• Windows.

Certifications:

• IBM Cognos 8 BI Author

Education

• Masters in Electronics and Communications [M.Tech]

PROFESSIONAL EXPERIENCE:
Confidential,OH
Apr 2011 – present
Sr. Cognos BI Developer
Confidential,business is a leading global provider of avionics, electrical power systems, actuation, landing gear, aero structures and propeller systems for aircraft with an extensive global service network to support these products. There are various applications which take care of the business and various types of reports are being used according to different purposes.
Environment: Cognos 8.4/10.1, Teradata 12.0, HPSD 4.5
Responsibilities:

• Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
• Involved with business and functional people to collect and gather requirements
• Implemented Mock report layouts before the actual report implementation.
• Creating value prompts, Date & time prompts, Text box prompts, cascading prompts
• Hide and Show the objects by using conditional blocks
• Implemented java script in reports.
• Involved and performed unit testing (manual testing) for the reports that have been developed.
• Developed multi format reports (PDF, Word, HTML & Excel).
• Raised tickets and interact with different teams for migration of code (Teradata views, packages and reports) to different environments.
• Creating & publishing the packages according to the business requirements
• Involved in the scheduling and deployment of the reports
• Involved in the Unit Testing of the reports and preparing the Test cases

Confidential,NJ
Feb 2010– Mar 2011
Sr. Cognos BI Developer
Confidential, Global Consumer Bank and CitiFinancial wish to implement a new regional credit initiation system to handle the initiation process for credit cards, diners cards, ready credit and loans. The ACIS system will support all types of cards ( credit cards, charge cards for individual and corporate), ready credit and loans (unsecured as well as secured, personal loans, mortgage as well as auto loans). ACIS will handle the needs of both Citibank Global Consumer Bank as well as CitiFinancial. ACIS will be the common system supporting all GCB/CitiFinancial countries. ACIS will work in tandem with StrategyWare, a decision engine product.

Environment: Cognos 8.4, Oracle 8.1.7, Windows XP.

Responsibilities:

• Gathered Business requirements for creating the Models.
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Using Scheduler Schedule the reports Daily, Monthly, Yearly.
• Created Prompts to User Defined Filters.
• Good knowledge in Unit/integration Testing
• Extensively worked on TOAD tool, testing the queries

Confidential,Philadelphia
Apr 2009 – Jan 2010
Cognos Developer

Confidential,world leaders in insurance and financial services, is the leading international insurance organization with operations in more than 130 countries and jurisdictions. AIG companies serve commercial, institutional and individual customers through the most extensive worldwide property-casualty and life insurance networks of any insurer. In the United States, AIG companies are the largest underwriters of commercial and industrial insurance.

Environment: Cognos Report Net 1.1, IIS, TOAD 7.0, Oracle 8.1.7, Windows XP.
Responsibilities:

• Gathered Business requirements for creating the Models.
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Using Scheduler Schedule the reports Daily, Monthly, Yearly.
• Created Catalog in Impromptu Administrator to create Reports.
• Created Prompts to User Defined Filters.
• Used Cognos Scheduler to schedule the Reports
• Good knowledge in Unit/integration Testing
• Extensively worked on TOAD tool, testing the queries

Confidential,Florida, U.S.A
Sep 2008 –Mar 2009
Cognos Developer

Confidential,. The main aim of the project is to estimate the BTS (Basic Telecom Services) Charges.
The enterprise data warehouse layer provides a shared, cross –functional store of subject –oriented data, based on an application natural relational data model, designed to support historical trend analysis and decision support reporting .The data is integrated across subject areas spanning the whole enterprise. It is normalized and highly detailed.

Environment: Cognos 8.1 ,Windows XP, SQL Server – 2005, Powerplay ransformer 7.2

Responsibilities:

• Created various reports using different lists in single and multiple pages according to filter conditions.
• Requirement gathering from business and client interaction.
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis.
• Used Conditional Variable to display different colors and for text according to format.
• Used Designing the reports and bursting the reports.
• Used Schedule Management to schedule the reports.
• Involved in migration of Cognos ReportNet to Cognos 8.

Confidential,TX
Sep 2007 –Aug 2008
Cognos Developer

Confidential,is world’s recognizable brand providing global financial services since more than 100 years. Apart from card fees, discount fees, revolving money and other income sources, Asset Backed Securitization is another income source to AMEX.
Asset backed securitization is a funding vehicle in which American Express Card member receivables are linked to the global capital markets. Card member’s receivables are sold to third party trusts, which then sell certificates, backed by those receivables, to outside investors. This will improve the company’s liquidity and frees up capital. The main objective of the project is to generate reports using Cognos8 to facilitate the client for strategic decisions

Responsibilities:

• Creation of framework manager models and packages
• Configuration of Web server and cognos configuration
• Working with different projects in Framework manager
• Creation of packages in framework manager
• Working with cognos connection to run and schedule the reports
• Creation of Reports using Report studio
• Conducted training sessions on cognos8

Environment : Cognos8.3 BI Modeling, Cognos8.3 BI Server, SQL Server 2005

Project: Production Management Analysis
Oct 2006 – Aug 2007
Confidential,Role: Reports Developer

Confidential,deals with manufacturing of shoe uppers and exporting to foreign countries. All standard types of stock movements (e.g. Goods Receipts, Goods Issued, and Adjustments etc.) are catered for. Future demand, by week or month is calculated from the forward order demand suitably expanded for assemblies and taking into account manufacturing and purchase lead times. Stock control provided for finished parts ensuring that relevant traceability data is stored per batch. Its part number issue level identifies all stock. The inventory details deals with the details of materials, name of supplier, quantity, Price, unit and date of arrivals. Full Transaction movement history is maintained for all parts and their associated batches. The project is aided at gathering efficient, accurate and updated reports, which would help the management to take timely actions.
Environment: Cognos8.1, Oracle 8.1 & Windows XP, Power play transformer 7.2

Responsibilities:

• Creating list reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi-Dimensional Analysis
• Creating & publishing the packages according to the business requirements
• Hide and Show the objects by using conditional blocks
• Creating value prompts, Date & time prompts, Text box prompts and cascading prompts
• Involved in the scheduling and deployment of the reports
• Involved in the Unit Testing of the reports and preparing the Test cases

Missouri Department of Transportation, Missouri
Nov 2005– Sep 2006
Cognos Reports Developer

The Primary goal of the Project is to generate multiple user Reports for the Missouri Department of Transportation for budgeting and planning of highways and bridges in the State. Transportation Management System (TMS) and State Transportation Information Systems (STIP) are the planning projects of the Missouri state to provide world-class transportation experience to its customers with better safety and satisfaction.
Environment: Cognos Report Net 1.1, SQL Server 2000 and Windows XP.
Responsibilities:

• Created List Reports, Cross-tab Reports, Chart Reports, Repeaters, Drill-Thru and Master Detail query Reports using Report Studio.
• Created Reports using Tabular SQL to reduce the load on the Framework Manager model
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entries in the report.
• Closely worked with ETL team to design data marts by understanding user requirements and increasing the reporting efficiency.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Involved in Documentation and Training Users on Query Studio for Ad-Hoc Reporting

Confidential,Dallas, TX
Aug 2004 – Oct 2005
Cognos Developer

Confidential,is an emerging biopharmaceutical company. Access Pharmaceuticals involves in creating various kinds of reports like product wise. They have some catalogues giving description about the medicine like name, formula, expiration date, etc. On the basis of this data is gathered, organized, distributed and reports are generated for clinical trials testing. The data has all info about the manufacturing locations, organizational contacts and customer service and company-wise news.
Environment: Cognos Report Net 1.1, SQL Server 2000 and Windows XP.
Responsibilities:

• Interact with the business users and documented their query, business analysis and reporting needs.
• Understood business logic underlying the requirements, based on that developed test data.
• Involved in developing a Star Schema using Erwin.
• Oraganized daily status call with the team and Monitored Reporting and ETL developers.
• Provide the mockup reports to help the developers.
• Restructured and reorganized several tables, and created indexes for better performance.
• Involved in migration of catalogs, Reports from Impromptu to Cognos8 & Report Net using Migration Utility.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.