SUMMARY

• Eight Years of experience in IT includes extensive Functional and Technical experience in, Data Modeling, Business Intelligence (BI) and Customer OLAP, product development and Reports Generation.
• Expert in Business Intelligence Applications using Cognos Tools such as Cognos 8 series, Cognos Express, Cognos 10.2, Cognos 10.1, Cognos 10.1.1, ReportNet (Framework Manager, Report studio, Query studio, Business Insight, Business Insight Advance and Analysis studio.
• Expert in installation, configuration of Cognos BI
• Worked on Framework Manager, Analysis Studio, Query Studio and Report Studio for Model and Report design in Cognos BI
• Expertise on Financial, Pharmaceutical, Government and Health care Domains.
• Good understanding of Metadata Modelling.
• Expert in Cognos content Import & Export.
• Experienced in Cognos Administration including security set up in Cognos using Active directory.
• Expert in Report Tuning
• Involved in gathering of business requirements Documented them technically with all phases of SDLC life cycle.
• Translate business requirements into technical specifications
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad - hoc reporting and advanced report authoring.
• Basic understanding of PowerPlay Transformer and client to design models and analyze the Power Cubes.
• Exposure to client interaction and user-requirement analysis.
• Mentored and trained users for the successful execution of the project.
• Involved in designing of Relational and Multidimensional databases.
• Good understanding of business process especially in the Financial and Insurance areas.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.

TECHNICAL SKILLS

BI Tools: COGNOS BI Framework Manager, Report Studio, Event Studio, Analysis Studio, Query Studio, Business Insight, Business Insight Advance.

REPORT NET 1.1(MR1/MR2/MR3): COGNOS connection, Framework Manager, Query studio, Report studio, Management Tools, Server Administration Tools, Configuration Manager, Scheduler. COGNOS PowerPlay Transformer, PowerPlay User, PowerPlay Web Reports, PowerPlay Enterprise server, Upfront Administration, Access Manager, LDAP Server, Configuration Manager, Scheduler.

Operating Systems: Windows 95/98, Windows NT 4.0, Windows 2000/XP, UNIX

Languages: SQL, PL/SQL, MDX, HTML

Databases: Oracle 10g/9i/8i/8.x, SQL Server 2000/2003/2005/2008 , DB2, Teradata.

Software Packages: MS-Office 2008 & 2010, Microsoft Word, Excel and Power Point

Other Tools: Toad, Query Analyzer, Management Studio

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Senior Cognos Developer

Responsibilities:

• Developed multi query crosstab reports in Cognos 10.2 Report studio.
• Worked with Business users and developed functional and technical design specification documents, and prepared Cognos reports accordingly.
• Provided multiple reports in Cognos BI Workspace, Workspace Advanced, Report studio, Query studio, Analysis studio.
• Remapped hierarchies from Current State to Future State at node level and leaf level and verified these states against database.
• Analyzed Data Mart dimensions for data discrepancies and suggested correct mappings with the data source.
• Used workbook functions to change the Cognos output formatting from one tab to custom multi tabs.
• Enhanced reports for MS Office
• Used complex logic in filters in Cognos queries.
• Developed Crosstab, drill through, master-detail and complex report which involved multiple prompts in report studio.
• Used conditional formatting to highlight the business needs.
• Cooperated with QA team to verify data against the test cases.
• Set up advance crosstab reports using multiple crosstab spaces on rows
• Defined big formatting data items for advance sorting in crosstab reports
• Created multi page reports and set up the format for MS Office
• Enhanced FM models to fulfill business needs
• Set up the security on multiple levels of folders.
• Fine-tuned the reports
• Set up the share drive and defined Archive locations for different departments and users.
• Set up the schedules to delivered the report to user’s email
• Set up bursting to send the extracts to share drive and the users
• Used internal tools to co-operate QA and user testing.
• Provided training to end user and to power user to enhance the workspace advance reports.

Environment: - Cognos 10.2, Report Studio, Query Studio, Analysis Studio, Workspace, Workspace Advance, Frame Work Manager, DB2, SQL Server 2008, Oracle, Toad, Query Analyzer

Confidential, Brooklyn, NY

Cognos Developer

Responsibilities:

• Generated Complex reports in Cognos 10.1.1 Report Studio including Drill through reports.
• Gathered and analyzed business requirements from users and business community.
• Tested the created reports by executing the Test Scripts
• Migration of reports and catalogs from Cognos series 8.4 to Cognos series 10.1.1
• Upgraded reports from 8.4 to 10.1.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Used Conditional blocks and conditional variables for generation of reports.
• Manually modified the SQL in Report Studio to tune and/or to write reports.
• Created Sophisticated Reports using Report Studio.
• Experience in developing models using Macros, prompts and filters.
• Performed BI Content Administration tasks including scheduling and content management
• Creating security set up on object and row level.
• Created SQL extract reports and writing scripts for loading and scheduling on FTP site.
• Provided End users training on BI Cognos
• Provided Ad-hoc reporting training to power users.
• Tuned the Framework Manager Models using Shortcuts
• Derived data dictionary from Framework Manager
• Setup the Report Bursting
• Defined advance filter and Context filters for slicing and dicing the class schedules
• Accessed multiple data sources to combined data from multiple sources and defined advance query subjects in Framework Manager to meet the Ad-hoc reporting requirements.
• Set up the Audit Packages and Reports
• Configure the share drive to Cognos to extract reports from Cognos to share drive
• Used CSVs to retrieve manual data in reports
• Defined multi query and multi pages reports
• Used static choice and Rendering to monitor multi page reports

Environment: - Cognos 10.1.1, Cognos 8.4, Report Studio, Query Studio, Analysis Studio, Metric Studio, Frame Work Manager, DB2, SQL Server 2008, Oracle 10g, Windows server 2003/2008

Confidential, New York, NY

Cognos Developer

Responsibilities:

• Developed various Reports like List Reports, Cross tab Reports, Charts, Drill-Down and Drill-Through Reports.
• Created Drill Up/Drill down Reports using TM1 Cubes as source.
• Developed complex reports in 10.1.1 using advance techniques of String and Boolean variables.
• Upgraded reports in Cognos 10.1.1 from Cognos Express.
• Manually modified SQL in reports and database to tune and/or to the complicated reports
• Developed various Framework Manager Models
• Worked with non-technical and technical end users and business community.
• Developed advanced Framework Manager Models using advance techniques of Star Schema and Snow Flake Schema.
• Applied security within multiple Group to provide proper access and capabilities on different levels of organization

Environment: - Cognos 10.1.1,Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric studio, Framework Manager, DB2, Oracle, SQL Server

Confidential, Dubuque, IA

Cognos Developer

Responsibilities:

• Generated Complex reports in Cognos 8.3 report studio including Drill through reports.
• Gathered and analyzed business requirements from users and business community.
• Tested the created reports by executing the Test Scripts
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3
• Upgraded reports from 8.2 to 8.3.
• Created Cash Product Dashboard reports to present critical company data in a single report using cognos 8 metric studio.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Used Conditional blocks and conditional variables for generation of reports.
• Manually modified the SQL in Report Studio to tune and/or to write reports.
• Experience in developing Framework Manager models both Relational and Dimensional (DMR modelling)
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio.
• Experience in developing models using prompts and filters.
• Distributed reports to various agents using Bursting.
• Added new Dimensions and Measures in the already existing reports in the Production.
• Performed BI Content Administration tasks including scheduling and content management

Environment: - Cognos 8.3BI, Report Studio, Query Studio, Analysis Studio, Framework Manager, ORACLE, Teradata, Microsoft SQL services.

Confidential, Bethlem, PA

Cognos Admin & Developer

Responsibilities:

• Gathered requirements from end users.
• Involved in the development of the Metadata Model using Framework Manager and created query subjects, filters and packages from the framework manger in Cognos 8.3.
• The Meta data was standardized for easy writing of the reports by the users.
• Used Power Designer for Data modeling.
• Used Third Normal Form in building Data Models.
• Published packages with appropriate security settings to Cognos connection
• Created List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts using Cognos 8.3 Report Studio
• Administered the Reporting Environment.
• Developed Scorecards, Dashboards reports Using Cognos8 BI Metric studio/Report Studio.
• Developed complex reports using drill-through options and Master-detail relationships in Report Studio.
• Created different Standard reports using prompts, filters, query calculations, cascading prompts and conditional
• Formatting of measures using variables in Report Studio.
• Trained few people on Cognos to support users.
• Developed Complex Crosstab reports in Analysis studio.
• Created adhoc reports Using Query studio.
• Used Cognos Go Office to import reports from report studio to MS office
• Administered tasks such as Scheduling, Deployment, Dispatchers
• Scheduled & refresh the reports and bursted reports according to user requirements in Cognos connection and sent the reports through E-mail feature.
• Migration of Cognos 7 to Cognos 8.
• Migration of Cognos 8 to cognos 8.2
• Tested and validated the report output against the database to measure performance of the Report.
• Involved in training sessions and demonstrated Cognos 8 tools to Power Users end-users.
• Involved in Production Support which involves solving End - user problems.
• Involved in fixing the issues, defects in the Packages.
• Involved in solving report errors.
• Provided 24/7 Production Support.
• Involved in Analysis on reports to support business Decisions.

Environment: Oracle 9i/10g, Teradata, Cognos 8.1/8.2/8.3, SQL Navigator, TOAD.

Confidential, NJ

Cognos Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Installed and Configured Cognos Impromptu and Cognos Power Play along with Upfront server
• Designed, developed, maintained and tested Catalogs for supporting ad hoc queries and canned reports.
• Designed and developed Prompted reports, Drill Through reports.
• Created Power Cubes using power play.
• Worked with Administrator module in creating users and users groups for different areas and setting privileges to them.
• Created the reports using Cognos functionalities like Queries, Slice and Dice, Filters, Drill down, Functions,
• Cross Tab, Master/Detail and Formulas etc.
• Administered tasks such as scheduling, deployment, and security.
• Production Support which involves solving user problems.

Environment: Oracle 8i/7, SQL Server, DB2, Cognos BI 8

Confidential, Maryland

Cognos Consultant

Responsibilities:

• Created Report design.
• Analysis of the functional requirements
• Created drill-thru reports and cross-tab reports in Report Studio.
• Analysis of the requirements
• Design and development of Report Studio Reports using filters and prompts.
• Designing of reports in Report Net and testing of formatted reports.

Environment: Oracle 9i, Framework Manager / ReportNet