SUMMARY

• 7+ Years of experience in Business intelligence reporting, development, analysis, design, testing and implementation of Cognos applications and maintenance of Data warehouses, Database and providing solutions for Finance, Banking, Insurance and Health Care domains.
• Well - versed in developing reporting applications using Cognos8.x/10.x, extensive experience in the usage of tools such as Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio and Event Studio.
• Excellent knowledge of Cognos Suite for reporting, analysis, scorecards and dashboards.
• Expertise in creating complex reports in Cognos Report Studio and also improved several reports performance when they run against production system.
• Highly experienced in deployment, scheduling reports and sending updated reports to recipients through e-mail by bursting.
• Expert in creating, publishing packages in the Framework Manager from various data sources.
• Experienced with Data Warehousing technologies, Requirement and Data Analysis, Requirements Gathering, Application Design and Development.
• Experience in full life cycle project development, including design, coding, testing and implementation and ongoing product support.
• Expert in creating standard filters, calculations, prompts and conditions.
• Proficient in creating variables for Complex Formatting Reports.
• Good experience and knowledge of Data warehousing & RDBMS concepts, dimensional modeling using Star Schema and Snow-Flake Schema.
• Proficient in programming languages like SQL, PL/SQL.
• Used office tools like MS-Word and MS-Excel extensively to populate reports for business users.
• Experienced with Multiple Relational Databases including Oracle 11i/9i, MS SQL Server and MS Access.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/XP/Vista, Mac, MS DOS

RDBMS: DB2, Oracle 11g/10g/9i, SQL Server 2003/2005, MS Access, Teradata

Languages: C, C++, SQL, PL/SQL, HTML, Java, VB, COBOL, JCL

OLAP /Reporting: Cognos BI v8.1,8.3,8.4,10 (Framework Manager, Report StudioQuery Studio, Analysis studio, Event Studio, Business Insight)

Tools: TOAD, MS Office, MS Project, MS Visio, SAS, SPSS

Software Skills: Use case design (UML), Data Flow diagrams, Flow charts

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Cognos Developer

Responsibilities:

• Understanding of business and data functionality.
• Validated and tested reports in both 8.4 and 10.2 environments.
• Worked on migrating Cognos reports from version 8.4 to 10.2
• Used IBM Lifecycle Manager for testing Cognos reports and comparing outputs.
• Provide weekly status report on project activities and future work flow.
• Developed and updated report validation document.
• Coordinated with the users to make sure that the reports validations are as expected.

Confidential, Atlanta, GA

Cognos Lead

Responsibilities:

• The major responsibility includes communicating between the customer and the offshore team, understanding requirements and business functionality.
• Understanding of business functionality and validating the data model.
• Prepared the high level and detailed design for framework model and reports.
• Development of Framework Model and reports in Cognos 8.x/10.x.
• Created List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts using Report Studio.
• Created adhoc reports Using Query studio.
• Worked with Oracle 9i and DB2 databases as well as used Toad query tool.
• Coordinated with End Users for UAT (User Acceptance Testing).

Confidential, NYC, NY

Cognos Developer

Responsibilities:

• Gather the requirements from Business users.
• Understanding existing business model and customer requirements.
• Provide weekly status report on project activities and future work flow to meet project timeline.
• Developed Function requirements and Design documents based on business requirements.
• Develop Test plan document.
• Involved in the development of the MetaData Model using Framework Manager using SQL Server data source and created query subjects, filters and packages from the framework manger in Cognos 8.4
• Created adhoc reports Using Query studio
• Developed Dashboard reports Using Cognos 8.4
• Created different Standard reports using prompts, filters, query calculations and conditional Formatting of measures using variables.
• Scheduled & refresh the reports and bursted reports according to user requirements in Cognos connection and sent the reports through E-mail feature.
• Tested and validated the report output against the database to measure performance of the Report.
• Worked on Toad query tool to extract data from the Oracle 9i database.

Confidential, Philadelphia, PA

Sr. Cognos Developer

Responsibilities:

• Gathered and analyzed user requirements and Participated in discussions with senior management to create the business requirement.
• Extensively worked with Framework Manager Models from ODBC data sources and Published into server.
• Created database layer and presentation layer and created packages using FM model and published in Cognos Connection
• Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
• Developed Drill through reports and conditional formatting by using report studio.
• Developed AD-Hoc Reports using Query Studio based on User requirement
• Tested and Troubleshooting of the reports and validated data it retrieves from Database.
• Designed and build multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Designed and developed reports from the Data warehouse using Cognos 8.3 report studio, Analysis Studio reports.
• Developed Dash Board reports in Report Studio.
• Trained power users to use Query Studio for Ad-Hoc reporting. Trained professional authors to write complex reports using Report Studio.
• Interacted with the End users on a regular basis for resolving issues pertaining to the reports.

Confidential, Melville, NY

Sr. Cognos Consultant

Responsibilities:

• Closely worked with Business Users to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers
• Worked on modeling the metadata extracted from multiple databases and established joins and cardinality to meet the business needs
• Developed required models for reporting using advanced Framework Manager Techniques to meet all the reporting requirements.
• Involved in designing models with Relational Data using Framework Manager and deployed packages to the Report Servers
• Created security filters at the Framework level to restrict data access created very effective and user friendly prompts which gives users flexibility to analyze the data in all possible ways and at the same time achieved tremendous performance time.
• Developed simple to complex filters, calculations, conditions, layouts using Cognos Report Studio for their several reports like Vendor Analysis, Allocation, Size-Profile Analysis, Unmatched Receipts and RTVs, Stock Ledger Audit Trail, Prepaid Unmatched
• Created various ad hoc reporting templates (list reports, chart reports, cross tab reports) for power users in Query Studio

Confidential, Jacksonville, FL

Cognos Consultant

Responsibilities:

• Gathered requirements from the various end users, analyzed the requirements and prepared documentation for the project.
• Generated various kinds of reports according to the users of the different departments and banking specialties, worked on Scheduling and Distribution of the reports.
• Planned and Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Created dashboards according to end user specifications.
• Customized data by adding Prompts Filters, Calculations, Summaries, Functions and Conditional Formatting.
• Created different types of prompts like Type in, Pick list, Cascading prompts etc.
• Enhanced the existing reports and created new reports as per the end user requirements.
• Assisted users in trouble shooting their reports.
• Worked on tuning the performance of the existing reports, and successfully completed testing the reports.

Confidential, Franklin Lakes NJ

Cognos Developer

Responsibilities:

• Gathered the Business Requirements from the end-users
• Built models, modified, and published several packages using Framework Manager according to the business needs which can be used by Report Developers
• Performed detailed documentation of design, development, testing and deployment activities
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, using Report Studio and Query Studio in Cognos 8
• Developed filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio for users
• Worked with Relational Databases - Oracle and MS SQL and involved in ETL team discussions.
• Made judgments and took decisions while addressing complex business issues with minimal supervision
• Migrated objects between Development to QA and QA to Production environments for all projects

Confidential

Analyst Programmer

Responsibilities:

• Gathered requirements and prepared Business Requirement document as well as Technical Specifications document
• Coded programs using mainframe languages like COBOL, JCL
• Prepared test plans/test cases based on different scenarios
• Performed unit testing, regression testing as well as UAT
• Provided post-implementation support.