Resume

Sign in

Manager Software Engineer

Location:
Atlanta, Georgia, United States
Posted:
October 17, 2018

Contact this candidate

Resume:

EXPERIENCE SUMMARY

Over * years of consolidated experience in Business Intelligence and Data Warehouse application development involving understanding of requirements, participation in design and development.

EXPERIENCE DETAILS

Functional Domain Name

Experience

Description

Insurance

4 yrs.

Worked on Underwriting process of Insurance domain

Retail

2+ yrs.

Worked on Sales, Inventory, Vendor, Warehouse modules

Supply Chain

4 months

Worked on Logistics module

TECHNICAL SKILLS

Primary Skills

Excellence

Oracle SQL, Cognos 10 Report Studio, Query Studio, Framework Manager

Mature

PL/SQL, Cognos Impromptu, Cognos Powerplay Transformer

Secondary Skills

QlikView, Microstrategy, Macromedia Dreamweaver

PROJECT EXPERIENCE

POC 1

TPAIR Reporting

Feb 14 - Apr 14

Customer Name

AIG Global Services, Inc.

Description

The POC was to recreate and enhance four existing TPAIR Inetsoft reports in Cognos Query studio and enable users to create their own adhoc and interactive reports. It also helped users to fetch bigger reports without the assistance of TPAIR helpdesk.

Tools & Technologies

Cognos 10.1 Query Studio,Framework manager,DB2

Operating System

Windows XP

Role Played

Module Lead

Responsibilities / Contribution

Set up the Cognos environment in ODC for TPAIR reporting.

Analyze the existing functionalities of the Inetsoft reports and assess the feasibility of migrating it with enhancements to Cognos Reporting.

Create a semantic layer for TPAIR reporting using Framework Manager by analyzing the database joins and different business rules.

Create the user input prompts and report components of existing reports as separate components in Cognos Query studio to ensure adhoc and interactive reporting for business users.

Worked closely with onsite coordinator in all stages of POC for environment set up, requirement gathering, report development, report testing,training the users and smooth transition of reports.

The POC was hugely successful which led to client signing up for a bigger migration project from Inetsoft to Cognos Reporting..

.

Team Size 1

POC 2

Netezza POC

Oct 13 - Jan 14

Customer Name

AIG Global Services, Inc.

Description

The focus of the POC was to showcase the performance improvement of Cognos Reports when pointing to Netezza instead of DB2 and also to demonstrating the capability and compatibility of ESRI map component in the interactive dashboard in Cognos.

Tools & Technologies

Cognos 10.1,Framework manager, Netezza

Operating System

Windows XP

Role Played

Module Lead

Responsibilities / Contribution

Develop same dashboard using different Cognos tools like Report studio, Business Insights and Active Reports.

Compare and decide the suitable track for better interactive dashboard creation.

Develop two interactive dashboard that capture TIV and Gross Exposure across different catastrophic events, Producing Offices and Inforce months with Cognos components like List, Charts, Interactive ESRI maps, Prompts and Drill through reports.

Test and Tune the dashboard to bring the dashboard generation time in less than 10 sec.

Bring the advanced visualization possibly supported by the tool to make it presentable to top executives.

.

Team Size 3

POC 3

Microstrategy POC

July 13 - Sept 13

Customer Name

AIG Global Services, Inc.

Description

Microstrategy POC - the POC on recreating the existing Cognos Dashboard report and Drill through reports, with dynamic calculations, in Microstrategy and verify the performance improvement.

Tools & Technologies

Microstrategy 9.3, DB2

Operating System

Windows XP

Role Played

Module Lead

Responsibilities / Contribution

• Understanding the existing reports and recreating the same requirement in Microstrategy.

• Recreation of existing dashboard reports with MSTR features.

Team Size 2

Project/Product 2

GLAXOSMITHKLINE_Build Capability

Mar 13 - Jun 13

Customer Name

GLAXOSMITHKLINE SERVICES UNLIMITED

Description

Glaxo SmithKline (GSK) is a British multinational pharmaceutical and consumer healthcare company. The project is mainly on the performance management of different levers of the GSK Supply Chain product movement.

Tools & Technologies

Cognos 10.2,Data Stage 8.7, Oracle 10g,PL/SQL Developer

Operating System

Windows XP

Role Played

Module Lead

Responsibilities / Contribution

• Closely worked with client to understand the process and requirements of the project as it is in the very initial stage

• Meta data model creation for Phase 1 using Framework Manager.

• Developed KPI reports as part of KPI dashboard.

• Developed the canned reports and adhoc reports on short notice without any defects.

Team Size 3

Project/Product 3

AIG - Chartis eSurety LGC T & M

Sep 12 - Jan 13

Customer Name

AIG Global Services, Inc.

Description

The project involves addition of a new method of exposure calculation parallel to the existing exposure calculation, which includes development of parallel set of existing reports with new exposure calculation. In the process we have to analyze the existing reporting modules, apply new risk calculation in line with changes in database and application and rewrite the part of the functionality on the Client Application Cognos platform.

Tools & Technologies

Cognos 8.4,Framework manager, Sybase

Operating System

Windows XP

Role Played

Senior Software Engineer

Responsibilities / Contribution

• Analyzing the existing reports and enhancement needs to be included in the reports • Develop all the reports • Test the reports against application and database • Works closely with testing team to provide them the know-how of the reports to make them acquainted with the report functionality. • Closely coordinate with the onsite team at various phases of the project to ensure that the reports are as per the expectation of the client. • Mentor junior members of the team to help them work on the critical phases of the project.

Team Size 3

Project/Product 4

AISMART Conversion

May 12 - Aug 12

Customer Name

AIG Global Services, Inc.

Description

This project involves migration of Environmental and Commercial Casualty surety processing data to the client application system. In the process we have to analyze the existing reporting modules and rewrite the part of the functionality on the Client Application Cognos platform.

Tools & Technologies

Cognos 8.4, Framework manager, Sybase

Operating System

Windows XP

Role Played

Senior Software Engineer

Responsibilities / Contribution

• Analyzed the existing reports and changes in work flow • Modified / redeveloped the reports • Tested the reports against application and database • Knowledge transfer to the junior team members.

Team Size 3

Project/Product 5

IIG-AIG-Chartis Global Exposure Solution

Dec 11 - Feb 12

Customer Name

AMERICAN INTERNATIONAL GROUP

Description

The main objective of this assignment is to do POC on the new functionalities available in the Business intelligence reporting tool-Cognos for the future project requirements.

Tools & Technologies

Cognos 8.4, Data Stage, SQL Server 2008

Operating System

Windows XP

Role Played

Senior Software Engineer

Responsibilities / Contribution

• Successfully completed the POC (Currency Conversion Logic & Multilingual) for AIG-GES.

• Designed the Conversion rate & Multilingual tables.

• Worked on ETL using Data stage.

• Implemented the Currency conversion logic on the sample reports.

• Implemented the Multilingual logic on the semantic layer.

Team Size

4

Project/Product 6

AIG AISMART T & M

Apr 10 - Sep 10

Customer Name

AIG Global Services, Inc.

Description

The AISMART application is a Surety application used by underwriters to book surety bonds. The system has a reports module used by the underwriters to generate and view reports. Crystal Reports Server is used at the backend to generate reports. In line with the customers corporate initiative it was decided to migrate from the Crystal reports technology to Cognos reporting technology. The project involved analyzing the existing reporting module and rewriting the entire functionality on the Cognos platform..

Tools & Technologies

Cognos 8.4, DB2 9.5

Operating System

Windows Server 2003

Role Played

Module Lead

Responsibilities / Contribution

• Initial setup of Cognos environment for the project and SPOC for offshore initially.

• Perform high level business and technical analysis and finalizing the migration approach.

• Worked directly with AIG contact for the migration approach finalization and weekly status calls

• Thoroughly analyzed and captured the understandings as analysis document, which served as base for SRS as well as design document later.

• Knowledge transfer to the other team members who joined later.

• Prepare metadata model using Cognos framework manager, design and develop Cognos reports.

Team Size 4

Project/Product 7

ER Analytics

Apr 06 - Apr 08

Customer Name

ESCALATE RETAIL

Description

Analytics is a business intelligence tool to transform transactional data into actionable information impacting areas of business improvement. It supports informed decision making by allowing focused retail business analysis and flexible, intuitive exploration of business information. The Analytics product has different applications like Sales, Vendor, Inventor, Finance and dashboard reporting. Advanced Reporting is a new module for complex reports in the Enterprise1 GR product – Another product of Escalate Retail, USA. The reports allow business users to analyze the key performance indicators of the organization across different Merchandising, Warehousing, Financial and Operational hierarchies. The 1.0 version of the application has all the reports required by business users of a large retail enterprise

Tools & Technologies

Oracle 9.2, Cognos 8.2,Cognos 7.x, Macromedia Dreamweaver

Operating System

Windows XP

Role Played

Software Developer

Responsibilities / Contribution

• Requirement Analysis & Estimation • Development of the application per Design and Standards. • Report development using Cognos Impromptu. • Data modeling, development and deployment of power cubes using Cognos Powerplay Transformer. • Customize and create data source for Cognos 8 reports using Oracle SQL & PL/SQL. • Review, cross-test and debug code written by team members. • Data modeling using Cognos 8 Framework manager • Report development using Cognos 8 Report studio • Report Testing Unit testing of own reports. Cross testing of team members' reports. • Validate the data in the report against database using SQL to ensure error-free reports. • Development and maintenance of web based user interface of the application using Macromedia Dreamweaver. • Initial phase development of ETL Engine using Oracle 9i. • Conduct quarterly knowledge sharing sessions on Retail, Data warehousing, Oracle or Cognos concepts.

Team Size 9

Project/Product 8

Internal Training Program

Aug 05 - Apr 06

Customer Name

Wipro Ltd

Description

Handling oracle lab sessions for campus recruitments of the company

Tools & Technologies

Oracle 9i

Operating System

Windows XP

Role Played

Lab Facilitator

Responsibilities / Contribution

• Development of mini Oracle projects for the training department of the organization • Handling the 5 day project sessions for fresh hires in Oracle stream. • Assessment of the project output on the 5th day of the session and submitting reports to authorities

Team Size 8

SPECIAL ACHIEVEMENTS

Title

Description

Month & Year

Spot Award

For proactive analysis and bridging the gap between the old and existing versions of ETL codes of the system

Jan 2008

Spot Award

Completing the creation and documentation of SQLs manually for all the existing reports (around 70) in a short timeline as part of the automation of testing.

Mar 2007

Spot Award

Received for handling the highest number of lab sessions

Mar 2006

EDUCATION

Year

Degree

Major Subject

Institution

Full Time/Part Time

2005

MCA

Computer Application

MYSORE UNIV

Full Time

2002

B.Sc.

Others

CALICUT UNIVERSITY

Full Time

CERTIFICATION

Certified In

Valid Till

IBM Certified Developer - Cognos 10 BI Metadata Models

IBM Big Data Fundamentals – Technical Mastery Test v1

PASSPORT

Passport No.

Place of Issue

Valid till

F8550439

Cochin

26-Jun-2016

VISA

Visa details not available.



Contact this candidate