Syed Ahmed

acp4ve@r.postjobfree.com

516-***-****

SUMMARY

Over 5+ 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 - 10BI, ReportNet (Framework manager, report studio, query studio, Event Studio and Analysis studio).

Knowledgeable in installation, configuration of Cognos BI version 8.X

Experienced in Framework Manager, Analysis Studio, Query Studio and Report Studio for Model and Report development in Cognos BI version 7.1, 8.4, 10.X

Expertise on Financial, Pharmaceutical, Government and Health care Domains.

Expertise in Insurance Claims Reporting, Property Insurance Reporting and Health insurance reporting.

Experienced in migrating reports from Business Objects to Cognos.

Involved in gathering of business requirements Documented them technically with all phases of SDLC life cycle.

Translate business requirements into technical specifications

Involved in installation, configuration and upgrade of COGNOS ReportNet 1.1 MR3.

Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.

Expert understanding of PowerPlay Transformer and client to design multidimensional models and analyze the Power Cubes.

Involved with administration of IWR Server, PowerPlay Enterprise Server and Report Net Server.

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.

Expert in migrations from series 7.1 to Reportnet 1.1MR1 and Cognos 8.X to 10.X

Experienced in content management tools such as Motio PI and Tortoise SVN

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

Expert in Documentation and process flow tool using Data Cookbook

Technical Skills:

BI Tools: IBM COGNOS 8.4, 10.X BI: Framework Manager, Report Studio, Metric Studio, Event Studio, Analysis Studio, Crystal Reports.

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.

Operating Systems: Windows 95/98, Windows 2000/XP/2008 R2, 7, 8, 8.1, UNIX, LINUX

Languages: SQL, PL/SQL, MDX, HTML, XML, XHTML, java, UNIX shell scripting

Databases: Oracle 11g/10g, Microsoft SQL Server 7/2000/2003, 2008 R2, DB2, Teradata

Software Packages: MS-Office 2000-2010, Microsoft Word, Excel, MS Access and Power Point

Other Tools: Toad for SQL Server/Oracle, Informatica Powercenter 8, Deployment Tool &

Migration Utility (Impcat2xml), Motio PI/CI, Tortoise SVN (subversion tool),

Apache Tomcat, Teradata SQL Analyst, Test Director and Microsoft

SharePoint, Data Cookbook.

EngagePoint, Calverton, MD Nov ‘14 to Current

Sr. Cognos Administrator

EngagePoint is a Healthcare software and IT services company that accelerates the government’s transition to a modern, integrated, sustainable enterprise by delivering software and services for program modernization and integrity. Serving the State of Missouri, Maryland, Minnesota and Florida in developing a statewide Health Insurance exchange.

Responsibilities:

Use Cognos 10.2.1 to create simple/complex Dashboards and reports

Interact with Business users for requirement gathering.

Analyzing the specifications provided by the clients and Developing specification documents for client requirements.

Used Framework Manager to build models, packages and publish packages to Cognos Connection.

Develop and maintain Cognos content using Query Studio, Report Studio, Analysis

Studio and Event Studio

Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, Drill through Reports, Master-detail and Conditional formatting reports using Report Studio.

Deployed Reports, Packages and Folders from one environment to another.

Implemented security for reports and packages

Maintain Cognos Roles and groups within the environment.

Manage Cognos content using Cognos Administration

Maintain Cognos server environment, including portal and security administration

Implemented Cognos 10.1 to 10.2.1 upgrade. Was involved in installation, configuration, migration and testing of all objects in multiple environments

Created packages to suit the business needs and to improve the performance of reports by defining filters, adding calculations and performing SQL turning on the model/report level using DB2

Coded Stored procedures and SQL scripts to load and update data tables

Designed and implemented various Materialized views in DB2 to use in Cognos Reporting

Environment: Cognos 10.2.1, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Administration, SQL Server 2008 R2, Toad for DB2

TC/University, New York, NY Feb ‘13 to Oct ‘14

Cognos Project Specialist (intern)

Touro is a sponsored independent institution of higher and professional education worldwide. Offers a range of graduate programs, including Education, Law, MBA, Medicine, Nursing, Pharmacy, Social Work, Technology, and other degree programs that prepare graduates for professional careers

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

oStudio 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

oMulti-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 report from one

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, Crystal Reports, SQL Server 2008R2, SSIS, IBM AS400 I series, Safari Mobile, Infomaker, Toad for SQL server, Motio PI/CI

AT&T Cellular/IBM, New York, NY Sept ‘12 to Feb ‘13

Cognos Consultant

ATT is the world leader in innovative mobile applications and communications technology, connecting human potential to the power business. ATT serves both large and small organizations across all industry sectors through four main brands and offerings for every home and business sector worldwide: Worked for AT&T and IBM as a contractor, extensively using tools such as Cognos/Excel and various databases.

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

oStudio and Event Studio

oDesigned 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

oMulti-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

oManage 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, Crystal Reports, SQL Server 2008R2, SSIS, IBM AS400 I series, Safari Mobile, Infomaker

Arinc.inc/Segment BI, Annapolis, MD Sept ‘09 to Aug’12

Cognos Developer

This Project is based on creating complex reports for the Department of Defense.

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.

Contact this candidate