Manager Software Engineer

SUMAN

Mobile: +91-961******* E-mail:

*******.*****@*****.***

Objective:

> To achieve a challenging career in the software development field and

to grow with your organization by proving my analyzing,designing and

development skills.

Professional Summary:

> Having 4+ years of experience in the areas of Business Analysis,solution

providing,development and testing of distributed BI & DWH Applications

using Cognos BI in Insurance,Health Care, Banking and Financial domains.

> Excellent knowledge and hands-on experience with cognos tools:( Report

Studio, Query Studio, Framework manager and Cognos connection)

> Export Meta Data Models and creating packages using Framework Manager

> Developed different kind of reports including List, Cross-tab, Chart

Reports using Report Studio and Query studio.

> Worked on different types of reports like Master Detail, Drill Through,

Conditional formatting and Prompts in the Report studio.

> Knowledge in providing Security to models and reports in terms of Data

level security, Object level security and Package level security.

> knowledge on Data warehousing concepts and Dimensional Modelling.

> Expertise in installation and configuration of Cognos.

> Having Knowledge on ETL tool INFORMATICA.

> Proven track record of delivering large-scale, mission-critical projects

reports on time, using leading-edge technologies to solve critical

business problems

> Strong analytic skills, self driven, keen to learn and adopt new

technologies

and processes.

Education:

> B.Tech in Computer Science and engineering from Jawaharlal Nehru

Technological University, Hyderabad.

Technical Skills:

> Programming Language : C,Cache

> BI Tools : Cognos 10.1 & 8BI(Framework

Manager,Report Studio

QueryStudio) and Cognos Reportnet 1.1,

Cognos Powerplay Transformer.

> Database skills : Oracle 9i/10g/11g, MSSQL Server

2000/2005.

> Operating environment : Windows NT/ 2000 / 2003 / XP / 7

Experience:

> Working as a Senior Software Engineer in ValueMomentum, Hyderabad from

January 2013 to Till Date.

> Worked as a BI Developer in APOLLO HEALTH STREET, Hyderabd from

OCTOBER 2010 to November 2012.

> Worked as a Software Engineer in Wipro Technologies, Bangalore from

Dec 2008 to OCTOBER 2010.

Project Details:

PROJECT#1:

Title : Farmers Alliance Insurance.

Client : Farmers Alliance Company.

Duration : Jan '13 to Till Date.

Role : Senior Software Engineer.

Environment : Cognos 10.1(Report Studio), Framework Manager,

Oracle 9i.

Description:

Farmers Alliance began in 1888 in the small, rural community of McPherson,

Kansas. Started as a fire insurance company to share the mutual exposures

of local farmers in the county, Farmers Alliance has grown to an

organization that writes more than $130 million of premium across an eight-

state region. Insurance products are oriented to a predominately rural

market, and more than 50% of the total business is written in the farm

insurance area. Farmers Alliance Companies include three regional insurance

companies providing property and casualty insurance for homes, autos,

businesses and farms.

Role& Responsibilities:

> Collecting the Requirements for the report development and preparing

the Gap analysis documents for the detailed level information.

> Created model by using Framework manager.

> Created Dimensional Modeling in Framework Manager by creating Regular

dimensions and Measure dimensions.

> Creating & publishing the packages according to the business

requirements.

> Created and Developed Dashboards, summary and detail level reports in

report studio.

> Worked on analysis studio and Query studio, Report studio,Chart

reports.

> Creating value prompts, Date & time prompts, Text box prompts,

cascading prompts and Tree prompts.

> Updating the reports according to the client requirements.

> Involved in the entire process of developing the new reports and

delivering to the respective user communities.

PROJECT#2:

Title : Centricity Business intelligence

Client : GE HealthCare.

Duration : Oct '10 to Nov'12.

Role : BI Developer.

Environment : Cognos 8.4 & 10.1,Report Studio, Framework Manager,

Oracle 9i.

Description:

GE Health care is leading a key role in USA Healthcare. In Health

Care domain using these applications like EMR, BAR, EWS tools it provides a

better understanding in healthcare environment. Medical informatics

benefits the health and human services industry. They create and maintain

new ways for hospitals to keep records, making essential medical

information as accessible as possible. Centricity Business intelligence

grads work in a variety of environments: hospitals, medical research

laboratories, health insurance companies, health information technology

suppliers, consulting organizations and more. Using Cognos BI tools will

provide reports and dashboards to end users.

Role& Responsibilities:

> Collecting the Requirements for the report development and preparing

the Gap analysis documents for the detailed level information.

> Created Models in Framework Manager and Imported metadata from

different data sources into these models.

> Created physical layer, Dimensional layer and Business layer in

Framework manager.

> Created Dimensional Modeling(DMR) in Framework Manager by creating

Regular dimensions and Measure dimensions.

> Created filters within the Model for improving the performance of the

Model.

> Implemented Framework manager security for Data access, Object level

access and Package access based on the Organization Level.

> Creating & publishing the packages according to the business

requirements.

> Created Standard Reports using Report Studio and Ad- Hoc Reports using

Query Studio like List Reports,Crosstab Reports and Chart Reports.

> Created and developed Dashboard Reports.

> Applied various kinds of prompts such as Value prompt, Date prompt,

Textbox Prompt, Cascading prompt, Select & Search Prompt for report's

better performance.

> Involved in handling Administration tasks like bursting and scheduling

the reports.

> Upgraded the Reports from Cognos 8.4 to Cognos 10.

> creation of Drill-Through and Master-Detail reports.

> Involved in testing and data validation of reports.

> Scheduled and distributed reports using schedule management in Cognos

connection.

> Involved in the entire process of developing the new reports and

delivering to the respective user communities.

PROJECT#3:

Project Title : HR-Payroll.

Client : UniCorn HRO, USA.

Duration : JAN 10' to Oct'10.

Role : Report Developer.

Environment : Cognos 8.4, Oracle 9i, Windows 2000.

Description:

Unicorn Hro is a team of research and & development,quality

assurance and systems Architecture professionals have developed and

maintained several different proprietary HR,Payroll and Benefits management

solutions. We are providing human resource reporting solutions by creating

reports for our customer according to their requirements.We have many

series of reports like Payroll earnings, termination analysis, current head

count .Involved in Creating Models in Framework Manager according to the

Business requirement and generating reports using Cognos.

Role& Responsibilities:

> Understanding the business requirements and designing applications to

meet the End users Requirements

> Created Standard Reports using Report Studio and Ad- Hoc Reports using

Query Studio, like List Reports,Crosstab Reports and Chart Reports.

> Created Lists and Cross-tab reports with Drill-through functionality.

> Created Simple list, Grouped list and Cross-tab reports using Report

studio.

> Created Filters, Prompts and Calculations.

> Involved in creation of Drill-Through and Master-Detail reports.

> Worked with Conditional variables to highlight the data based on

reporting requirements.

> Scheduled and distributed reports weekly basis using schedule

management in Cognos connection.

> Involving in reviewing the developed reports & performed unit testing.

Project #4:

Project Title : BRITISH BANK .

Client : British Bank, UK.

Duration : DEC '08 to DEC '09.

Role : Report Developer.

Environment : Cognos 8.3BI, Oracle 9i, Windows 2000.

Description:

British Bank is leading finical institution to provide below mentioned

finical services to customers. Retail Banking Solutions (ATM, phone

banking, branch banking, lending, collections). Banking Solutions (Core

Banking, Liquidity Management, Trade Finance). Investment Banking

(Derivatives, Fixed Income, Forex, Money Markets)

Credit Cards (Issuers, Acquirers, Reward Management System, Fraud

Early Warning System (FEWS) Insurance (Life Insurance, Non-life Insurance).

End of the business day or end of week or end of month or yearly the

management team using Cognos Reporting tool to generate reports to view,

study and analyze their business need and forecast the future growth.

Role& Responsibilities:

> Created different kinds of business reports as per client's

requirements

> Developed various types of simple and complex reports by using report

studio.

> Developed list, cross-tab and chart reports using report studio.

> Involved in creation of Drill-Through and Master-Detail reports.

> Scheduled and distributed reports using schedule management in Cognos

connection.

> Created various types of Prompts including Cascading Prompts Pages.

> Developed Ranked Reports and Section Reports using Report Studio.

> Created Filters, Prompts and Calculations into Reports.

> Performed Unit testing on reports to check for the expected results.

Contact this candidate