SUMMARY

• Expert in Business Intelligence Applications using Cognos Tools such as Cognos 8 - 10BI, ReportNet (Framework manager, report studio, query studio, Event Studio and Analysis studio)
• Team player with good interpersonal and communication skills and the ability to work in a team environment.
• Expertise on Financial, Pharmaceutical, Higher Ed, Government and Health care Domains.
• Good understanding of business process especially in the Finance, Property Insurance and Health insurance.
• Experienced in migrating reports from Business Objects to Cognos.
• Served as a Lead Reporting Architect on an aggressive timed ERP implementation.
• Worked with clients to gather requirement, developed specification and documented success factors.
• Extensively worked on Banner/ODS solution for higher education by Ellucian
• Created high level analytics for senior leadership.
• 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.
• Exposure to client interaction and user-requirement analysis.
• Mentored and trained users for the successful execution of the project.
• 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.
• Experienced in Toad for SQL server, Oracle, IBM Data Studio
• Assisted in ETL development using SSIS, Informatica
• Experienced in Cognos Administration, content Security and user access management within IBM Cognos
• Expertise in providing simple to complex solutions and working with the end users to completely satisfy their needs.
• Skilled Accounting Knowledge with 1year of experience in hotel industry.
• 6 month internship in stock brokerage firm.
• Work on Netezza and Aginity Workbench.

TECHNICAL SKILLS

• Cognos 8.4 10 BI
• Cognos Connection
• Cognos office Connection
• Report Studio
• Query Studio
• Analysis studio
• Metric studio
• Frame Work Manager
• DB2
• SQL
• XML
• Windows NT/4.0.

PROFESSIONAL EXPERIENCE

Confidential, St Louis, Missouri

Cognos Developer

Responsibilities:

• Worked as a BI Lead for Confidential Service.
• The work involved in leading a team Off-Shore developers and Developers in here in St.Louis location.
• Worked involved meeting with Off-shore team to take status of the project and prioritize the work for the on-Shore team.
• Use Cognos Analytics to create simple/complex Dashboards and reports.
• Create and maintain Framework Manager projects and reporting packages
• Replace older reporting system withReporting System, and also upgrade from Cognos 10.2 to Cognos Analytics.
• Modify and Maintain existing reports in Cognos11.
• Solve production issues and allocate resources to handle Tickets.
• Set up meetings with users and take new requirements and ad-hoc changes to reports and fixes to any of the current reports.
• Coordinate with the team and prioritize the work for the team.
• Manage and migrate existing Cognos Reports to Cognos11

Environment: Oracle 11, Cognos 10.2.2, Cognos11, CognosFM, Netezza, Aginity, SSIS.

Confidential, New York, NY

Cognos Developer / Finance Reporting Lead

Responsibilities:

• Managed Touro enterprise reporting environment.
• Worked with Functional leads and scope future reporting needs.
• Developed a standard reporting process: RDLC, PROD migrations, defect tracking and user access.
• Worked with senior management to maintain university reporting standards.
• Worked closely with users to understand the business requirements
• Created reports in subject areas like HR, Payroll, Finance, Accounts Receivables, Advancement, Student Information Systems and Financial Aid departments on ODS and Banner data
• Maintained and enhanced existing Finance reports.
• Created reports primarily focused on providing Yearly and Quarterly Revenue and Profit Accounting.
• Customized reports using Javascript in HTML objects to dynamically change the behavior of prompts in Report studio.
• Maintained strong business relationships withFinanceand IT.
• SupportedFinancestaff as point of contact for BI financial systems.
• Understood client needs & effectively managed expectations
• Customized default ODS packages from Ellucian in framework manager and published to Cognos connection for reporting purpose.
• Involved with business requirements gathering with end users, business analysts, managers and business directors and designing and develop Metadata model in Operational Data Store (ODS) from the ERP systems
• Provided training material and hands on training for ad-hoc reporting.
• Created advanced reports that require temporary table relationships (SQL joins)

Confidential, New York, NY

Cognos Report Specialist

Responsibilities:

• Use Cognos 10.1.1 to create simple/complex Dashboards and reports
• Create and maintain Framework Manager projects and reporting packages
• Create Transformer models and multidimensional cubes
• Maintain Cognos server environment, including portal and security administration
• Develop and maintain Cognos content using Query Studio, Report Studio, Analysis Studio and Event Studio
• BI Administrator / Professional responsible for maintaining the Framework Manager projects and administering the security and web environment
• Use Report Studio to create and distribute the full spectrum of report types, including complex and Multi-source reports.
• Work with LDAP/Active Directory if Cognos users are maintained in the directory.
• Maintain Cognos Roles and groups within cognos environment.
• Manage cognos content using cognos Administration
• Migrate reports across environments (SIT - UAT - PROD)
• Create advanced reports that require temporary table relationships (SQL joins)
• Use SQL experience to troubleshoot query performance issues.
• Integrated Development Environment (IDE) to develop reports, maintain versions, change templates, and manage access.
• Work with business experts to develop the reports and design mockups.
• Manage and migrate existing Crystal Reports to Cognos10
• Work with stakeholders to gather report specifications.

Environment: Cognos 10, Report Studio, Framework Manager, Cognos Administration, IIS, LDAP/AD, Crystal Reports, SQL Server, Toad for SQL server.

Confidential

Cognos Consultant

Responsibilities:

• Extensively used Cognos 10 to create simple/complex Dashboards and reports
• Create and maintain Framework Manager projects and reporting packages
• Create Transformer models and multidimensional cubes
• Develop and maintain Cognos content using Query Studio, Report Studio, Analysis
• Studio and Event Studio
• Designed Excel reports in Cognos and used automated Macros built excel PPT to
• BI Administrator / Professional responsible for maintaining the Framework Manager projects and administering the security and web environment
• Use Report Studio to create and distribute the full spectrum of report types, including complex and
• Multi-source reports.
• Work with LDAP/Active Directory if Cognos users are maintained in the directory.
• Migrate reports across environments
• Create advanced reports that require temporary table relationships (SQL joins)
• Use SQL experience to troubleshoot query performance issues.
• Integrated Development Environment (IDE) to develop reports, maintain versions, change templates, and
• Manage access.
• Work with business experts to develop the reports and design mockups.
• Manage and migrate existing Crystal Reports to Cognos10
• Create custom SSIS packages to load custom query’s into the Database
• Trained business users to develop/use reports using Report Studio/Query Studio
• Work with stakeholders to gather report specifications.

Environment: Cognos 10.1.1, Report Studio, Framework Manager, Cognos Administration, IIS, LDAP/AD, SQL Server 2008R2, SSIS, IBM AS400 I series, Safari Mobile.

Confidential

Cognos Developer

Responsibilities:

• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Generated Complex reports in Cognos 8.4 report studio including Drill Down reports from DMR modeled Frame work model.
• Created Dashboards to present critical company data in a single report.
• Created list reports & cross tab reports using cognos 8, 10.
• Upgraded reports from 8.2 to 8.4 and sandbox testing in version 10
• Used Apache Tomcat tool for configuration and management of the Cognos tool.
• Used IIS (Internet information server) web server for configuration and management.
• Used Cognos SDK to customize the cognos connection Portal.
• Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.4, 10
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio
• Experience in developing Framework Manager Models and analyzed those models in analysis studio.
• Gathered and analyzed business requirements from users and business community.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Converted reports from Microstrategy to Cognos 8.4, 10
• Creating Transformer Models, Cubes and Dimensional Reports.
• Developed Power Play models using Transformer by developing various dimensions, measures and calculations in Cognos Transformer.

Environment: - Cognos 8.4, 10 BI, Cognos Connection, Cognos office Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, DB2, SQL,XML and Windows NT/4.0.