SUMMARY

• Over 7 years of experience in the area of Business Intelligence. Worked with various products in the IBM Cognos Business Intelligence Suite.
• Extensive knowledge in the area of Data Warehouse. Experience in designing and developing the data marts.
• Experience in working with end users in understanding their reporting needs and designing a reporting framework to best suit their needs.
• Well - versed in developing reporting applications using Cognos BI components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio, Cognos Connection and SDK.
• Extensive knowledge in Dimensional Data modeling, Star Schema / Snowflakes schema, Fact and Dimension tables, Indexes and triggers.
• Worked on Cognos 10 tools like Active Reports, Business Insight and Business Insight Advanced.
• Expertise in developing reporting metadata as per the end user needs using Cognos Framework manager.
• Experience in designing creating complex models (dimensions/hierarchies/categories), multi dimensional cubes using Transformer and sourcing the cubes for dashboard creation. Proficient in using multi dimensional expression (MDX) in Report Studio.
• Interacted with the business users extensively to understand their reporting requirements, effective analysis and also trained them on the tools to get them started with Cognos suite.
• Experience in installing and configuring the EP Series 7, CRN and C8 Environments with third-party authentication providers.
• Experience in developing multi dimensional OLAP based applications using Cognos PowerPlay.
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Good experience in developing and successfully deploying multiple initiatives withExecutive Dashboardswith charts andreports with easy navigation into subsequent reports by drill down feature.
• Experienced in closely coordinating with the ETL team to get the data required by the reports into the data-marts.
• Expertise in developing complex SQL queries and writing PL/SQL Scripts to create stored procedures, functions, packages and database triggers
• Solid experience in performance tuning in the reporting environment.
• Ability to manage multiple concurrent processes while understanding and successfully solving business problems in a customer-focused, consensus-driven environment.
• Project management capability with ability to multitask, team-oriented approach and strong interpersonal and communication skills.

TECHNICAL SKILLS

BI tools: Cognos 10, 8 BI 8.4/8.2 (Framework Manager, Report Studio, Query Studio, Metric Studio), ReportNet1.1 (MR1,MR2,MR3), CognosSeries7.3 MR3 (PowerPlay Enterprise Server, PowerPlayTransformer), OLAP cubes, Cognos TM1, Impromptu, Cognos Access Manager, Cognos Visualizer, Management Tools, Server Administration Tools, Configuration Manager, Scheduler.

Languages: SQL, PL/SQL, MDX,VB, HTML, XML, XHTML, JavaScript

ETL Tools: Data Stage, Informatica Power Center 7.x/6.x,ERwin4.0/3.5

RDBMS: Oracle9i/10g, TeraData, MS SQL Server6.5/7/2000, MS-Access, MS-Excel, DB2, Vertica.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point.

Platforms: Windows NT/2000/XP, DOS, UNIX

Web & Directory Servers: IIS5.0, Apacheweb Server, Sun One Directory Server, Active Directory Server.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Cognos Developer

Responsibilities:

• Involved in the full cycle development and implementation of reporting framework using IBM Cognos.
• Worked with end users of various departments to understand their reporting needs and documented the reporting requirements.
• Design the reporting Meta data layer using Framework Manager. Implemented the business transfer rules in the reporting metadata.
• Designed the roadmap to upgrade the reporting environment from 8.4 to 10.1.1.
• Worked on Cognos 10 Business insight, Business Insight Advanced for creation of the various Dashboards.
• Used Cognos Data Manager to build data marts.
• Involved in Setting up an Audit database to track report failures and report usage.
• Developed advanced reports using Report Studio. Used a range of features such as Page Sets, Cascading Prompts, Union of Queries, Master Detail reports, Charts etc.
• Good Knowledge in Cognos SDK.
• Worked in automating regularly used reports using Report Bursting so that reports are available by email at desired frequency.
• Reports and Query optimization using Cognos Toolset. Worked extensively in performance tuning of reports. Worked with the DBA group to fine tune long running reports by analyzing the underlying SQL.
• Assist the Cognos Administrator in the administration activities like user addition; maintain user groups and roles etc.
• Developed report prototypes to get user’s feedback, incorporated user’s feedback in the reports.
• Setting up cardinality (minimum, maximum & optional), Determinants to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Implemented Dimensionally Modeled Relational models to create multi dimensional view from Relational data.
• Designed the dashboards for better presentation of key performance metrics. Dashboards have been extensively used by the top management in their day to day decision making.
• Worked on customizing Cognos connection and experience with Portal Layout.
• Trained end users in Cognos Connection (View reports, Schedule reports etc) and Query studio to enable them to create Adhoc reports

Environment: Cognos 10 / 8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Framework Manager, Business insight and Business insight advanced, Life Cycle Manager), MS SQL server, Cognos Data Manager, SSIS, SSRS, Informix, SQL, PL/SQL, Java Script, UNIX

Confidential, Schaumburg, IL

Cognos Developer

Responsibilities:

• Facilitated the requirements gathering process and fact-finding sessions with business users to identify report requirements/design.
• Worked extensively in developing reporting metadata using Cognos Framework manager.
• Created metadata models, made appropriate Joins, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security, using LDAP.
• Consulted with business partners understand requirements and provided technology recommendations.
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Nested Crosstab, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Created several different types of Professional Reports (Mailing Labels, Cascading, Linked /Drill Through, Production, Business etc.) with complex formatting utilizing Report Studio.
• Created IC dashboards which display a 20 day view of all work orders scheduled for each IC Technician along with the status of the work.
• Setting Data and Object security, giving access permission to objects and Packages.
• Designed Customer Snapshot and Product Snapshot dashboards that give multi faceted information about the customer’s rental history, yield statistics, YTD revenues, balances and accrued cost information.
• Developed Standard ( AR, Security Deposit and Account Administrator Aging Reports, Ledger Reports, Accrued Costs and Deferred Income Reports) and Non-Standard (Manual cash posting Reports, Lock Box reports, VERTEX Sales tax reports) reports to improve efficiency in day to day operations of the business.
• Scheduled reports in Cognos Connection (Web Portal). Created, organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Developed multidimensional models using Cognos Transformer.
• Developed reports using Cognos PowerPlay and published to PowerPlay Enterprise Server.
• Involved in verification and validation of the Project.
• Addressed the tickets that were raised during System Test, UAT and worked on them.

Environment: Cognos 8.3 BI, Report Studio, Query Studio, Framework Manager, Transformer, PowerPlay MS SQL, Toad 7.0, SQL, PL/SQL, Windows.

Confidential, Columbus, OH.

Cognos Developer

Responsibilities:

• Involved in Installing and Configuring ReportNet Server, Framework Manager, Report Studio, Query Studio and Cognos Connection Portal.
• 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, Cascading, Linked /Drill Through, Production, Business, Ranking, etc.) with complex formatting utilizing Report Studio.
• Loaded data from the files got in different formats into the development and production systems using DTS.
• Used DTS to migrate the existing data from MS-Access to Sql Server 2000.
• Worked with ETL team in designing the data model using Star Schema.
• Created a model using Framework Manager and packed the model with Reports and published on to the ReportNet Server.
• Developed Customize 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.
• Created Run and Schedule 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.
• Performed Unit testing for all developed reports.

Environment: Reportnet1.1 MR1, Framework Manager, Query Studio, Report Studio, Cognos Connection, Windows, SQL Server.

Confidential, Albuquerque, NM

Cognos Developer

Responsibilities:

• Wrote many transfer rules and update rules to support the business logic and conditions.
• Updating the Framework Model when new metadata is imported.
• Developed SDK script to maintain the public folders across different users. Developed a java script to copy the "My Folders" of different users to a single location.
• Developed advanced reports using Cognos 8. Conditional formatting, variables, page breaks, drill through, master detail reports etc.
• Created the marketing dashboard using Cognos 8.
• Identified the required dimensions and, measures for the reports.
• Thoroughly tested the developed reports to make sure that all functionality worked correctly.
• Scheduled the reports using Cognos Scheduler and Cognos connection.
• Implemented package level security in framework manager and report level security in Cognos connection.
• Implemented table level and Query subject level security by using embedded filters.
• Developing Standard Reports, Charts, Drill through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio and Query Studio.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, and multiple queries for data extraction in reports.
• Used Union, Intersection, etc for creating queries.
• Used custom queries in certain reports.
• Worked extensively with burst reports and Event-triggered emails.
• Implemented Filters, Calculations, Conditions, and Graphs & Prompts in Impromptu reports
• Developed transactional reports using complex SQL and PL/SQL querying. Checked the queries for performance. Used sub queries wherever required.
• Extensively used OLAP functions in SQL queries for complex reporting needs.

Environment: Cognos 8 Suite, Cognos Report Net 1.1 MR3 (Report Studio, Query Studio, Framework Manager), CognosPowerplay, TeraData, Oracle10g, PL/SQL, SQL*Plus, SQL*Loader, Windows NT 4.0, Java Script, UNIX.

Confidential

Cognos Developer

Responsibilities:

• Designed, developed and maintained catalogs, Impromptu reports, templates, hot files, PDF files, snapshots, drill through.
• Created IQDs using Impromptu Administrator.
• Generated reports as per the requirements using Cognos Impromptu
• Used Multidimensional analysis for Data Retrieval using Powerplay structure
• Extensively worked on prompts based on the user needs and format required
• Defined conditions, calculations and prompts in the catalog
• Different department users used the Powerplay environment that is customized for each user depending on the requirements.
• Created Hierarchies from providing drill down options for the end-user.
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email.
• Used impromptu’s optimizing features like table weighing, governors, bulk fetch.
• Reporter Operations such as Sum and Average, Intersection, etc., Exception Highlighting Sorting, Ranking etc.
• Created various reports (List, Crosstab, Mailing Labels, Form Letter, Free Style) using Cognos.
• Impromptu tool by querying the database Query.
• Created standard and Adhoc reports (Formats, Layouts, quality data to carry) using Cognos
• Published the IWR reports on the web server.
• Created User Prompts, Conditions and Filters to improve the report generation

Environment: Cognos 7 Series (Impromptu, Cognos Server Administration, Cognos Upfront, Impromptu Web Reports (IWR), Cognos Query, Metrics Manager) Erwin Data Modeler, Windows 2000 server, MS Access, Windows XP.

Confidential

Report Developer/BI Developer

Responsibilities:

• Coordinated with users, analyzed the requirements, developed and tested the reports as per the requirements.
• Design and development of ad-hoc reports in Impromptu and PowerPlay.
• Development of Catalogs in Impromptu.
• Created Impromptu reports to Drill Through from one report to another.
• Impromptu features, prompts, query filters, grouping, sorting and calculations were created and used.
• Planned and Created professional reports using Impromptu.
• Created and tested Multidimensional Models using Transformer with and without drill through functionality providing Calculated Categories, Measures and generated OLAP cubes in Power Play as per the user requirements.
• Developed sub-reports and various reports using different types of prompts like catalog pick list, File pick list, type in, cascading prompts and using conditional formatting as well.
• Involved in fixings the bugs and enhancing performance of existing reports and gave the training to end-users as well.

Environment: Cognos Powerplay, Impromptu, Windows 2000 server, SQL, PL/SQL.