Manager Developer

Neeraj Mogla

Email: - ***********@*****.*** Phone: 330-***-****

Summary

. Cognos 8 BI Developer/Consultant with 4+ years of experience in

various industries and deep experience in Cognos Business Intelligence

products

. Worked as Software Developer and Support Analyst using various

technologies like Apache Tomcat, ColdFusion, C sharp, Java, Flex,

MySQL and MS-SQL Server.

Skill Set

Roles

Cognos BI Developer, Consultant

Business Intelligence Tools

Cognos 8 BI, Data Stage 7.5

Operating Systems

Linux based, Windows Vista/XP/2003

Database Tools

MySQL, MS-SQL Server, Oracle 9i

ETL Tools

IBM Cognos Data Manager, Data Stage 7.5

Others

Active Directory, LDAP, Tomcat Server, ColdFusion, C sharp and Java.

Employment History

Feb 2009-Present Cognos

Developer/R & D Support

eClinicalWorks LLC (Healthcare Software Industry)

. Trouble shoot issues related to integration of Tomcat with MySQL/ MS

SQL on a Multi server environment with multiple Application Servers

(using Load Balancing) and multiple Database servers(using Clustering,

Replication)

. Integrating & Deploying Cognos 8 on multi-server Linux environment and

implementing Enterprise Monitors to oversee the performance of Report

server, replication and other parameters.

. Developed Cognos Data manger Jobs, builds and refresh processes for

numerous projects by extracting data from different sources and

loading into data warehouse(ETL)

. Developing Framework Manager Models for different reporting projects

within the organization to satisfy the needs of different departments

and various project sites.

. Developed customized Reports on depicting Ticket Status for enterprise

clients only using drill down capabilities.

. Developing Account based Reports on Ticket Closure for Internal

Assessments of Teams and Team members.

. Responsible in the administration and setup of Cognos 8 Development,

Test and Production Server. All installations are multiple server

installs

. Customized Cognos 8 Portal using Cognos System files, port lets as

well as Cascading Style Sheets

. Responsible in the setup of Cognos 8 Security. Setup of User Groups,

Roles, etc.

Environment: Cognos 8, Cognos Report Net 1.1 MR2, Cognos Data Manager,

Cognos SDK, Data Stage, Microsoft SQL Server, MySQL, Oracle 9i, Visual

Studio 2008, Multi Server Install.

Jan 2007-Dec 2008 Cognos

BI Developer

Azure Hues Inc.

Toronto, ON

. Worked as a member of data warehouse team for the implementation of

numerous reporting projects

. Optimized database and tuned SQL with Oracle 9i.

. Developed an end to end solution by extracting data from transactional

system and creating reports in Cognos 8 Report Studio. Technologies

used were Cognos 8 Data Manager (ETL), Framework Manager (Modeling)

and Cognos Report Studio for reporting. Reports were developed based

on hierarchies (Time, Demographics, Products, Categories, etc.)

. Provided data from data warehouse to various applications in

organization by creating individual interfaces

. Developing Report Studio reports with drill up/drill down, bursting,

etc. capabilities

. Designed and developed ad hoc reports mainly to analyze the customer

buying behavior, comparison reports and product wise sales reporting

Education

Masters Degree - Computer Sciences and Engineering, University of

Akron OH

Professional Training

. Cognos 8 Data Manager

. Cognos 8 Metadata Modeling (Framework Manager)

. Cognos Report Net 1.1(certified)

. .Net development using Visual Studio

. Application development using C sharp, Flex and Java

Contact this candidate