Lydia Grace Soans
Bangalore, India
Phone: +91-990*******
Email ID : **********@*****.***
Job Objective: To secure a challenging and rewarding position as Cognos Developer with an established organization that can utilize my skills and experience.
EDUCATION DETAILS: Master’s Degree in Software Engineering – MTech
CERTIFICATIONS:
IBM Certified Developer - Cognos 10 BI Metadata Models,
IBM Certified Designer - Cognos 10 BI Report Author
Summary of Qualifications
Having 5+ years of professional experience in IT Industry with Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence Applications.
In-depth knowledge of developing reports and applications using business intelligence tools
Proficient in Cognos 10.x and Cognos Framework Manager
Sound knowledge of Cognos Server Architecture and dependencies
Proficient with Oracle and SQL Server
Strong database and analytical skills
Excellent written and verbal communication and interpersonal skills
Self-motivated, team orientated, ability to handle multiple projects and meet deadlines
PROFESSIONAL EXPERIENCE
Company : Wipro Technologies -Bangalore, India
Client: Western Power – Perth, Australia
Nov 2010- Jun 2011
Role
COGNOS DEVELOPER - L2
Domain
UTILITIES
Team size
15
Project environment
WINDOWS
Skills
ORACLE,COGNOS FRAMEWORK MANAGER,COGNOS BI
Western Power initiated the WP EDW IT3 BUILD PH1 data warehouse project with a vision to deploy over time a single source data for analytical use across the entire enterprise. This initiative involves analysis, design, build and deployment of the data warehouse.
Responsibilities:
Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.
Involved with business and functional people to collect and gather requirements
Creating value prompts, Date & time prompts, Text box prompts, cascading prompts
Hide and Show the objects by using conditional blocks
Implemented java script in reports.
Involved and performed unit testing (manual testing) for the reports that have been developed.
Developed multi format reports (PDF, Word, and HTML & Excel).
Involved in the Unit Testing of the reports and preparing the Test cases
Involved in preparing Technical Documentation
Company : Wipro Technologies -Bangalore, India
Client: Western Power – Perth, Australia
Jul 2011 – Sep 2012
Role
DEVELOPER - L2
Domain
UTILITIES
Team size
15
Project environment
WINDOWS
Skills
ORACLE,COGNOS FRAMEWORK MANAGER,COGNOS BI
Western Power initiated the NETWORK AND RELIABILITY data warehouse project with a vision to deploy over time a single source data for analytical use across the entire enterprise. This initiative involves analysis, design, build and deployment of the data warehouse.
Responsibilities:
Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
Created Prompts to User Defined Filters.
Good knowledge in Unit/integration Testing
Extensively worked on TOAD tool, testing the queries
Coordinate/assist /develop Framework Manager Model adjustments to accommodate new and existing business requirements.
Company : Wipro Technologies -Bangalore, India
Client: State Street – Boston
Dec 2012 – Jan 2014
Role
DEVELOPER
Domain
SECURITIES
Team size
20
Project environment
WINDOWS
Skills
BIDW,ORACLE, IRD REPORTING TOOL
State Street Global Advisors creates customized investment strategies for institutions. SSGA manages the assets for clients by setting up commingled funds. The company services financial clients by creating and managing investment strategies for non-profit foundations, businesses, corporations, associations, governments, educational institutions, and religious organizations. The aim of the project is to build reports that handles client's portfolio.
Responsibilities:
Responsible for development, support, maintenance and implementation of small to medium complex components of a project module.
Developed multi format reports (PDF and Excel)
Involved in the Unit Testing of the reports and preparing the Test cases
Involved in preparing Technical Documentation
Company : Wipro Technologies -Bangalore, India
Client: GlaxoSmithKline
Feb 2014 – Apr 2014
Role
DEVELOPER
Domain
HEALTHCARE
Team size
8
Project environment
WINDOWS
Skills
BIDW,COGNOS FRAMEWORK MANAGER,COGNOS BI
The project aims in providing Cognos solutions for client to aid the Clinical research programs.
Responsibilities:
Design, develop and support Cognos BI content including reports, dashboards etc.
Involved in the Unit Testing of the reports and preparing the Test cases
Involved in preparing Technical Documentation
Company : Wipro Technologies -Bangalore, India
Client: PHILIPS – Eindhoven, Netherlands
May 2014 – May 2015
Role
DEVELOPER
Domain
MANUFACTURING
Team size
10
Project environment
WINDOWS
Skills
COGNOS BI, PTC Windchill
Philips is a Dutch Technology Company with primary divisions focused in the areas of electronics, healthcare and lighting. This project is focused to provide PLM (Product lifecycle Management) solutions to the Client.
Responsibility:
Build queries using PTC Windchill Query builder.
Involved with business and functional people to collect and gather requirements
Implemented Mock report layouts before the actual report implementation.
Creating value prompts, Date & time prompts, Text box prompts, cascading prompts
Hide and Show the objects by using conditional blocks
Implemented java script in reports.
Involved and performed unit testing (manual testing) for the reports that have been developed.
Involved in deployment of the reports
Involved in the Unit Testing of the reports and preparing the Test cases
Company : Wipro Technologies -Bangalore, India
Client: State Street – Boston
Jun 2015- Dec 2015
Role
DEVELOPER
Domain
SECURITIES
Team size
4
Project environment
WINDOWS
Skills
BIDW, TABLEAU, SQL SERVER 2012
State Street was facing surge in number of Major Incidents. To overcome this, we came up with a solution to design dashboards which aims the higher management to make informed decision.
Responsibilities:
Gathered Business requirements for creating the Models.
Design Dashboards with Tableau Desktop
Conducted Training sessions on Tableau
Preparing Design Document
Develop and perform tests on various enterprises and provide dashboard solutions with help of Tableau software and assist all end users.
Company : Concur Technologies -Bangalore, India
Feb 2016 to Present Date
Role
COGNOS REPORT WRITER
Domain
TRAVEL MANAGEMENT
Team size
8
Project environment
WINDOWS
Skills
COGNOS, FRAMEWORK MANAGER
Concur Technologies is an American travel management company, providing travel and expense management services to businesses.
Responsibilities:
Design, develop and support Cognos BI content including reports, dashboards etc.
Involved in the Unit Testing of the reports and preparing the Test cases.