Monday, October 12, 2009
Thursday, July 2, 2009
20090702-001
PROFILE
Around 56 Months of IT industry experience. Currently, working as a Senior Software Proffesional for TietoEnator Corporation, Pune for last 2 months. Experience in BI - Cognos 8.
Earlier experience – Worked for HSBC Software Development India Pvt Ltd for 54 months as Senior Software Engineer.
| Cognos 8, Framework Manager, OLAP/DMR Modeling, Report Studio, Query Studio, Analysis Studio, Powerplay-Transformer. |
| Core Java, JavaScript, HTML, XML, XSLT |
| Oracle, DB2 |
| UML, Rational Rose, Quality Center, Dom Doc, Clarity |
TRAINING:
CA Unicenter based (At Computer Associates training center - Chicago):
- UR376 Unicenter Service Desk: Analyst Operations
- URV386 Unicenter Service Desk: Administration
Cognos Reporting (At Cognos Incorporated training center - Chicago):
- Cognos 8 BI - Report Authoring - Part 1
- Cognos 8 BI - Report Authoring - Part 2
- Cognos 8 BI - Metadata Modeling - Part 1
- Cognos 8 BI - Metadata Modeling - Part 2
- PowerPlay OLAP Modeling for Series 7 Version 3 & Cognos 8 BI
- Cognos 8 BI - Server Administration
- Cognos 8 BI - Content Administration
PROFESSIONAL EXPERIENCE
TietoEnator Corporation, Senior Software Proffesional (May 2009 – Till date)
HSBC - Pune, Senior Software Developer (Nov 2004 – May 2009)
Project Details:
| Project Name: | Gepardi - Mankeli Reporting (Cognos 8 Reporting) |
| Duration: | May 2009 – Till Date |
| Organization: | TietoEnator Corporation, Pune |
| Client: | Elisa Telecommunications, Finland |
| Summary: | Elisa Telecommunications is Finland’s second largest telecom company. Gepardi is the project contains around 120 applications which are maintained and enhanced by TietoEnator. Out of 120 applications 25 applications are BI applications and Mankeli is one of the 25 applications which is the most important reporting solution as it is the financial reporting for Elisa. Mankeli reporting is used as CMS (Corporate performance management solution) by finance department to report on the sales data on monthly, quarterly, six monthly, year to date and yearly basis. Earlier this project was maintained and enhanced by IBM and we have taken over the project from them. Proper knowledge workshops were organizes at Elisa premises in Finland. I was there at Finland to represent Cognos Reporting area. Also the project involves Informatica and Oracle related work. Cognos system has 12 packages, 5 CUBES, 120 reports and 470 users. |
| Role: | Development Lead:
|
| Environment | Cognos 8 |
| Project Name: | Global Service Desk (Cognos 8 Reporting) |
| Duration: | Aug 2006 – May 2009 |
| Organization: | HSBC GLT Pune |
| Client: | HSBC USA |
| Summary: | Global Service desk is service management tool. This will be used across HSBC group to log and record incidents, problem, request, issues, and change order. This application will be implementing the best practices of ITIL recommendation on to the out of box application from CA called Unicenter Service Desk. We are creating reports out of both real time database i.e. Oracle and Data warehouse i.e. DB2 for customers all over the globe in HSBC. We have reports out of relational model and cubes. |
| Role: | Framework Modeler and Report author.
|
| Environment | Cognos 8 |
| Project Name: | Global Service Desk – PLADA Integration (Cognos 8 Reporting) |
| Duration: | Jan 2006 – July 2006 |
| Organization: | HSBC GLT Pune |
| Client: | HSBC USA |
| Summary: | PLADA stands for Performance Level Agreement Database Application. PLADA is tool to document service level agreement between IT Service and business. |
| Role: |
|
| Environment | Cognos 8 |
| Project Name: | Global Service Desk (Customization of CA Unicenter Service desk as per HSBC Global requirement) |
| Duration: | Jun 2005 – Dec 2005 |
| Organization: | HSBC GLT Pune |
| Client: | HSBC USA |
| Summary: | Global Service desk is service management tool. This will be used across HSBC group to log and record incidents, problem, request, issues, and change order. This application will be implementing the best practices of ITIL recommendation on to the out of box application from CA called Unicenter Service Desk. |
| Role: | Software Developer – Team Member
|
| Environment | Unix, Oracle, HTMPL and spell code (propriety CA’s Language.) |
| Project Name: | HSBCnet eSecurities |
| Duration: | Jan 2005 – Jun 2005 Worked on four releases i.e. Release 8, Release FT2, Release 9 and Release 10. |
| Organization: | HSBC GLT Pune |
| Client: | HSBC Vancouver Canada |
| Summary: | HSBCnet is the service provided by HSBC to its corporate clients. HSBC eSecurities plays the role of custodian. HSBC Securities Services (HSS) provides comprehensive global, regional and domestic securities services to corporate and institutional clients. Development and testing (unit and end-to-end) for eSecurities as per technical specifications provided and to the HSBCnet and the eCommerce CoE general development guidelines |
| Role: | Software Developer – Team Member
|
| Environment | XSLT, Servlets Using UIMS AND EBSA Framework Web Server/Application Server: WepSphere 5.0 IDE: WSAD 5.1.2 |
EDUCATION
| July 2004 | Bachelor of Engineering (Information Technology), RGPV University, Bhopal |
Wednesday, July 1, 2009
Remote Cognos Development Opportunity
We can assist with model development, report development, SDK coding, testing, QA, technical documentation and even project management.
Feel free to contact us today to discuss your needs.
email: businessintelligencecentre@gmail.com
Sunday, January 25, 2009
3+ years Cognos Developer -- 20090125-001
Professional Summary
- Having 3+ Years of experience in IT industry of which 2.9 years of experience in the area of data warehousing as a Report developer
- Extensive experience in Cognos Report Net 1.1,Cognos Impromptu
- Having knowledge in Cognos 8, Cognos Power Play and Framework manager
- Developed different types of reports using Report studio, Query studio and Cognos Impromptu
- Excellent knowledge in Data warehousing concepts
- Can play a vital role in the team and able to absorb technical knowledge quickly
Employment History
- Working as a Cognos Consultant for Satyam Computers, hyd, since july2007 to Till Date.
- Worked as a Software Engineer for FCG SOFTWARE, Bangalore from Sep 2005 – July 2007.
Technical Skills
OLAP Tools : Cognos Report Net 1.1, EP 7 Series and Cognos8
ETL Tools : Informatica 7.1.1
Databases : Oracle 9i
Operating Systems : Windows 2000/XP
Languages : C, C++ and SQL
project profile
Project #1
Title : Sales Information System (Aug 2007 to Till Date)
Client : San Miguel Corporation (SMC)
Environment : Reportnet1.1, Oracle 9i
Role : Report Developer
Description:
San Miguel Corporation (SMC), Philippines is the largest publicly listed food, beverage and packaging company in Philippines. SMC's food and agribusiness units make animal feed, Coconut oil, dairy and meat products the scope of this Project is to capture the Sales and Marketing processes and data warehouse to maintain client’s history and current data. DataFrom Operational Source System was extracted, transformed and loaded into data warehouse
Responsibilities:
- Developed Master detail, drill through and rank reports by using report studio.
- Created Daily backups by using Cognos Connection
- Reviewed the reports developed by other team members.
- Created HTML Items , packages , templates and reusable components
- Developed Complex reports by using Conditional formatting and Conditional blocking
- Interact with client on a daily basis and Detailed Requirements Study
Project #2:
Title : 7Eleven Sales analysis (May 2006 to July 2007)
Client : 7Eleven, Malaysia
Environment : Cognos impromptu, power play
Role : Report Developer
Description:
7Eleven is one of the largest retail companies operating in Malaysia. It manufactures and distributes a wide variety of retail products. This is designed for the purpose of sales analysis that basically helps the decision makers to analyze the sales. This system helps to keep track the impact of advertising and other promotion on sales. It is also used to test the effects of pricing changes and varying media weights on local markets. It can compare today’s sales results to those of previous year, as well as compare results among chains, geographic regions, and products down to the brand level.
Role& Responsibilities:
- List Reports, Cross-tab Reports and Drill-through Reports.
- Created reports using cascading prompts.
- Created various types of reports Developed for various user levels.
- Queried from different database tables as per the requirement.
- Scheduling the reports.
- Created and enhanced existing Power Cube as per user requirements.
- Imported IQD files created in impromptu into transformer to construct a power cube Involved in optimizing Power Cubes.
Project #3
Title : Extra Mile Sales analysis (Sep 2005 to Apr 2006)
Client : Extra Mile, USA
Environment : Cognos impromptu and Oracle 9i
Role : Report Developer
Description:
Extra Mile, a global scale, it supplies collection of products to consumers like sports products, outdoor products, home appliances and fruits. Extra Mile sales does business in participating suppliers provides the largest selection of high quality merchandise available anywhere. Marketing strategies are based on built purchasing of slow selling, first quality merchandise and reselling these goods at discount prices. Suppliers store products until they are ordered. Reporting requirements are many and diverse and include standard accounting, sales, financial, marketing and inventory.
Role & Responsibilities:
- Have done modifications to the catalogs
- Created Catalog prompts, Conditions and Calculations.
- Created cross tab report, mailing labels reports by using cognos impromptu.
- Created Snapshot, Hot file, Thumbnail reports.
- Worked on giving privileges to the User profiles like Governor settings, Table access, Folder access
- Scheduled various reports
Educational Qualifications:
· BS.C(COMPUTERS)FROM S.K.UNIVERSITY.ATP
Tuesday, August 19, 2008
Cognos Developer -- 20080819-0001
OBJECTIVE
| I am looking for a challenging position in the IT industry, which shall provide me with opportunities to explore my potential. |
educational qualifications
| EXAMINATION | BOARD | INSTITUTION | AGGREGATE |
BE, Computer Science And Engineering | Visveswaraih Technological University | Kalpataru Instituteof | 65.10% |
II PUC | Pre university Board, Karnataka | VVNL PU college Jogfalls Shivamogga(dist) | 62.16% |
| SSLC | State Board, Karnataka | Government High School Kargal Shivamogga(dist) | 82.32% |
Completed Bachelor of Engineering in Computer science and Engineering in the year 2007
SKILL PROFILE
| Primary Skills : | C, Java, SQL, Data modeling, Data warehousing and BI concepts.. |
| Platform: | Windows 98, Windows XP, Linux |
| ETL Tool: | Microsoft SSIS |
OLAP Tool: | COGNOS 8: Query Studio, Report Studio. Framework Manager |
Experience SUMMARY
- 1.8 years of experience as a DWH and BI developer at Aviana nrit,Bengaluru.
- Expertise, knowledge and hands on experience with MS SSIS 2005
- Extensive experience in Extraction, Transformation, Loading (ETL) data from various Sources into Data Warehouses and Data Marts.
- Exposure to COGNOS 8(Query Studio, Report Studio, Framework Manager)
- Zeal and ability to learn new concepts, new tools.
- Sincere and hard working.
PROJECTS:
1.Project Details
| Insurance BI System | |
| Client | ING Vysya |
| Role | DWH and BI Developer |
| Organization | Aviana Nrit limited, Bangalore |
| Environment | Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005, |
| Duration | Feb 2007 – Jun 2007 |
Description
The project involve in BI solution (the “Insurance BI System”) for a “standard” insurance company, which gives support to e-Reporting system that can serve as web based analytical reporting process using Cognos suite of BI products. The IBI System will depend on underlying data marts.The IBI System will support the reporting structure followed in the insurance banking industry, and be designed to be customizable according the needs of specific customers. Customizable dimensional model is core of the IBI Data Mart solution. This model serves as a base for rapid implementation of insurance banking business intelligence applications.
Responsibilities:
- Understanding the Business Requirement and Design as per it.
- Developed a solution to the need by gathering and analyzing client data.
- Generated I.Q.D files from Impromptu as a source for power play cubes
- Performed calculations and conditions in Impromptu reports
- Knowledge in making the model plans in Power Play Transformer to Generate Power Cubes
- Standard Reports like Simple to Cross-tab to Group Cross-tab are generated using Impromptu.
- Multi Dimensional Drill Up / Drill Down Analysis Reports are developed using Power Play
- Created Levels with in Dimensions for better Analysis using Power play Transformer.
COGNOS Power Play has been used to analyze and present the Cube data in the form of multi-dimensional Reports & Charts.
Team Size: 5
2. Project Details
| General Sales Data Mart | |
| Client | BAJAJ AUTOMOBILE |
| Role | DWH and BI Developer |
| Organization | Aviana Nrit limited, Bangalore |
| Environment | Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005, |
| Duration | JUL 2007 – DEC 2007 |
Description:
The project is involved in Analyze, design and development of Bajaj Motorcycles sales and service maintenance system. The purpose of this project is to build a Data Warehouse database to the Sale Division of the company, which will give a support in generate the multi-dimensional summarized, reports to track the performance on services provided to their customers. This project is overall about claim data analysis. Bajaj Automobile wants to analyze the claims data generated by the system so that they can identify various factors influencing it, look at the trends, optimize through put and reduce losses by way of claims for faulty spares.
Responsibilities:
- Understanding the Requirement Specifications & Business Logic.
- Developed solutions to meet business needs by gathering and analyzing client resource.
- Developed various Mappings, Transformations for migration of data using SSIS 2005.
- Used various transformations in SSIS 2005.
- Done data aggregation while transformation.
- Extraction of data from the enterprise data warehouse for analytical and multi-dimensional reporting system for specific Corporate Business Unit
- Developed simple as well as complex reports using Reporting studio.
- Developed List, Cross tab, Drill through, Master-detail and chart which involved Multiple Prompts, Filters, and Multi-page.
Team Size: 5
- Project details:
| General Sales Data Mart | |
| Client | Prism Cements |
| Role | DWH and BI Developer |
| Organization | Aviana Nrit limited, Bangalore |
| Environment | Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005, |
| Duration | JAN 2008 – till date. |
Description:
The project involves in both execution & building a data warehouse Database for the sales department where the data was from different sources of oracle and flat files. The company serves the mass merchandisers, department and independent chain stores .The Company’s mission statement is "Strengthening Both Supplier and Retailer". This is accomplished through providing quality servicing at store level.
Responsibilities:
- Understanding the Requirement Specifications & Business Logic.
- Developed solutions to meet business needs by gathering and analyzing client resource.
- Developed various Mappings, Transformations for migration of data using MS SSIS 2005.
- Used various transformations in SSIS 2005.
- Done data cleansing and aggregation while transformation.
- Extraction of data from the enterprise data warehouse for analytical and multi-dimensional reporting system for specific Corporate Business Unit
- Developed simple as well as complex reports using Reporting studio.
- Developed List, Cross tab, Drill through, Master-detail and chart which involved Multiple Prompts, Filters, and Multi-page.
Team Size: 5
PERSONAL PROFILE
| Name: | Naganayan D S |
| Father’s Name: | Dr D K S Aradhya |
| Date Of Birth: | 03/10/1983 |
| Current ctc | 1.44 lakhs/annum |
| Expected ctc | 2.70 lakhs/annum |
| Languages: | English, Kannada, Hindi. |
| Hobbies: | Reading novels, Playing Cricket, watching tech shows |
| Notice Period: | 2 week |
Friday, August 1, 2008
Thursday, June 19, 2008
Cognos ETL Specialist 20080619-0001
Current Location : In Singapore, On Social Visit Pass
EDUCATIONAL QUALIFICATION
Bachelor’s Degree in Mechanical Engineering 2005
SK University, Kurnool, India
TECHNICAL SKILLS
ETL Tools : Cognos8, Business Objects, DataStage 7.5.2 Enterprise Edition, DataStage 7.5 Server Edition
Reporting Tools : Cognos, Business Objects
Languages : C, C++, SQL, PL/SQL
Operating Systems : Win 95/98/NT/2000/XP, Unix
Databases : Oracle 8.i/9.i
Other Tools : TOAD
CERTIFICATIONS
- Quality Management Systems(QMS) Satyam Computer Services Pte Ltd, India
- SQL – OCA Oracle, India
TRAININGS
- Oracle, Unix Training at Satyam Computer Services.
- DataStage Training at IBM in April ‘07.
- Cognos and Business Objects Training at Satyam Computer Services in Feb’08
CAREER SUMMARY
- More than 2 yrs. of experience in Data Stage - ETL Developer and Cognos.
- Involved in Functional and Technical Systems Analysis & Design, Systems, Star Schema, Snowflake, changing dimension and Documentation.
- Developed server and parallel jobs using different types of stages such as Transformer stage, Lookup Stage, Join stage and created the Reports in Cognos according to the requirement.
- Implementation of ETL (Extraction, Transformation and Loading) methodology using DataStage.
- Integration of various Data Sources like Oracle and Flat files into the Staging Area.
- Good knowledge in Database Concepts.
- Strong knowledge in Data warehousing concepts and hands on experience in Data Stage and Cognos.
- Have Good Programming knowledge in SQL, PL/SQL.
- Strong Understanding of Software Lifecycle Methodology.
- Experience in functional analysis, establishing business rules and process flows.
- Excellent User interaction skills.
- Having Good Communication Skills, Can learn new Technologies and Tools quickly.
EXPERIENCE
Mar 06 – Till Date Satyam Computer Services, Hyderabad, India
Software Engineer
Oct 07 – Apr 08
Project 3 GNE (Gulf & Near East) – Secondary Sales Reporting System
Client GSK (Glaxo Smithkline), UK
Team Size 6
Environment Cognos 8, DataStage 7.5.1, Oracle 10g, TOAD, UNIX
Project Description
GNE – Secondary Sales Reporting system is to develop reporting solution for GSK Gulf and Near East (GNE) which would provide easy access and drilled-down capability to retailer level. This is expected to improve the decision making by providing data with multidimensional analysis. The Secondary Sales reporting system is to replace existing excel based reports and provide additional functionality to enhance analysis and reporting capabilities.
Responsibilities
- Designed and Created Reports in Cognos.
- Authored Report Specifications.
- Documented Package Configuration and System test case.
- Involved in Unit Testing and System Testing
Jun 06 – Sep 07
Project 2 DRSF (Data Reporting System Foundation)
Client GSK (Glaxo Smithkline), Ware, UK
Team Size 30
Environment DataStage 7.5 Enterprise Edition (Px), Oracle 10g, TOAD, UNIX
Project Description
GlaxoSmithKline (GSK) is a world leading research-based pharmaceutical company. The Data Reporting System Foundation (DRSF) will provide a system for automatically gathering information from a range of sources by automatic and manual means. This information will be stored, processed and presented to the users of the system in a form that they can readily analyze.
Responsibilities
- Analysis of the specifications provided by the client.
- Developed parallel jobs for extracting, Transforming and loading the required data into Foundation Layer.
- Used Datastage designer to create mappings (jobs) using different types of Stages such as Transformer stage, Lookup stage, Sequential file Stage, Sort stage, Join Stage etc.
- Developed jobs in the Local containers.
- Designed and developed job sequences for parallel jobs according to the requirement.
- Used DataStage director to validate, to test and to monitor the resulting executable jobs.
- Interaction with the onsite team.
- Involved in unit testing by authoring and executing the unit test cases
- Adhered to Quality procedures related to the project.
Jul 06 – Oct 06
Project 1 PMAR (Profit Management Analysis & Reporting)
Client GSK (Glaxo Smithkline), UK
Team Size 16
Environment DataStage 7.5.1, Cognos, Oracle 9i, TOAD, UNIX
Project Description
PMAR (Profit Management Analysis & Reporting) is used for analysis of profit & associated financial details of GSK. The Analysis is done for two establishments of GSK, namely GSKE (Glaxo & SmithKline Exports) and GSKTS (Glaxo & SmithKline Trading Services).
Responsibilities
- Preparing Unit Test Case Documents for Data Stage jobs.
- Preparing System Test Case Documents for Data Stage jobs.
- Reviewing SQL Queries using TOAD.
- Unit Testing for Data stage jobs.
- System Testing for Data Stage jobs.
- Created Simple jobs in Ascential Data Stage.
- Prepared documents for the UAT.
- Checked the Data Integrity in both JDE and Data Stage.
- Created Deployment Document for production support.
COMPENSATION DETAILS
- Currently on 4 Lakhs Indian Rupees per annum, plus Medical for self and parents, plus annual Leave Travel Allowance, and 15 – 25% annual Appraisal.
NOTICE PERIOD
- Available Immediately