tag:blogger.com,1999:blog-55057726465390292052024-02-08T09:53:34.966-08:00Cognos ConsultingYou're all in one source for finding your next Cognos resource specializing in all Cognos BI components.Unknownnoreply@blogger.comBlogger22125tag:blogger.com,1999:blog-5505772646539029205.post-22161400884939894252011-03-05T07:26:00.000-08:002011-03-05T07:36:44.601-08:00New Cognos BI resource 050311-001<b><a href="mailto:businessintelligencecentre@gmail.com">Email</a> us if you would like to contact this new resource. </b><br />
<br />
PROFESSIONAL SUMMARY<br />
<br />
Over 12 Years of experience in IT includes 10 Years of experience in all phases of data warehouse development lifecycle, from gathering requirements to testing, Application Design, Development, implementation, and support. 2 Years in Web and Windows Application design and development using Microsoft technologies.<br />
<br />
• Extensive experience in design and implementation of Data marts and Data warehouses using Cognos Suite 7 (Impromptu, Transformer, Power play, ReportNet) ; Cognos 8.1/8.2/8.3/8.4 BI.<br />
• Experience on Cognos 8 BI tools (Framework Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, PPES, PowerPlay Transformer, Data Manager, Cognos Macros) as a developer, administrator and Architect.<br />
• Expert in creating Data Models in the Framework Manager from various data sources.<br />
• Generated different kinds of reports in ReportStudio & QueryStudio, created templates and multilingual reports. Deployed the reports into various environments like test and production.<br />
•Migrated Cognos Series 7 catalogs and reports to Cognos 8 using utilities.<br />
• Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.<br />
•Solid understanding of data warehousing, OLTP and OLAP concepts. Performed data extracts.<br />
• Working knowledge of designing multidimensional architecture for Extract, Transform, Load environment with Informatica and Cognos tools.<br />
• Have experience in IWR (Impromptu Web Reports), Publishing using Upfront, maintaining Users, User classes, Deployment, Scheduling the Reports and sending Updated Reports to Recipients through E-Mail by using Notice Cast.<br />
• Provided technical and functional consulting to corporate and divisional users for Cognos.<br />
• Experienced in Data Mining, Multidimensional Data Analysis using Power Cubes.<br />
•Extensively worked with databases like SQL Server 2000/2005/2008; Oracle 9i/10g.<br />
•Experienced in Installing & configuring various Cognos environments. Customized environments using Cognos SDK.<br />
• Good team player with excellent communication skills, analytical and learning new technologies.<br />
•Strong experience in Client interaction and understanding business applications, business data flow and data relations.<br />
•Having domain expertise in Finance, Insurance, Healthcare and Manufacturing.<br />
<br />
•TECHNICAL SKILLS<br />
<br />
BI TOOLS: COGNOS 8BI:<br />
REPORTNET 1.1(MR1/MR2):<br />
COGNOS SERIES 7.X:<br />
DATA MODELLING TOOLS:<br />
OPERATING SYSTEMS<br />
<br />
LANGUAGES:<br />
<br />
DATABASES:<br />
<br />
SOFTWARE PACKAGES:<br />
<br />
TOOLS & UTILITIES:<br />
<br />
Framework Manager, Analysis Studio, Report Studio, Metric Studio, Event Studio<br />
<br />
COGNOS connection, Framework Manager, Query studio, Report studio, Management Tools, Server Administration Tools, Configuration Manager, Scheduler.<br />
<br />
COGNOS Impromptu Administrator, Impromptu User, Impromptu Web<br />
Reports, COGNOS PowerPlay Transformer, PowerPlay User, PowerPlay<br />
Web Reports, PowerPlay Enterprise server, Upfront Administration,<br />
Access Manager, LDAP Server, Configuration Manager, Scheduler.<br />
<br />
Informatica Power Mart 4.7, Power Centre 4.7, ER win 4.0, Cognos<br />
Decision Stream 7.1<br />
<br />
Ms-DOS, Windows 95/98/2000, NT, SCO-UNIX<br />
<br />
SQL, PL/SQL, C, C++, VB 6.0, ASP.Net, VB.Net<br />
<br />
SQL Server 2000/2005/2008, Oracle 9i/10g, DB2, MS-Access<br />
<br />
MS-Office 2003, Microsoft Word, Excel and Power Point<br />
<br />
Toad, FrontPage, Visual Interdev<br />
<br />
PROJECTS PROFILE<br />
<br />
AIG Insurance, NYC, NY<br />
Cognos Architect<br />
<br />
Project Description: AIG is a is a world leading property-casualty and general insurance<br />
organization serving more than 40 million clients in over 160 countries and jurisdictions.<br />
Worked on several projects like LRMS (Liquidity Risk Management System) and RPC (Regional<br />
Pricing committee) for the enterprise Risk Management Team and Marketing Risk Management<br />
Team.<br />
<br />
LRMS Application is a Liquidity risk management system for calculating Assets Cash flows,<br />
Liquidity Cashflows for various buckets. The systems also shows Sensitivities in the reports.<br />
<br />
Regional Pricing Committee system helps in estimating Market Price, compare Market prices,<br />
calculate variance between month ends for various products of the types Fixed Income and<br />
Equities.<br />
<br />
Contributions:<br />
• Involved in interacting with the Business Analysts/Users to get the high level<br />
requirements and translating them to functional definitions, and ultimately to technical<br />
design and implementation.<br />
•<br />
Performed data quality analysis, gathered information to determine data sources, data<br />
targets, data definitions, data relationships, and documented the business rules.<br />
• Worked with data architects to develop data models, design specifications, and<br />
metadata documentation.<br />
•Prioritized the deliverables for the Developers based on Business priority.<br />
•Interacted with the supporting IT groups, in order to ensure that there wouldn't be any<br />
delays which would slow down the project progress..<br />
• Analyzed the old reports in Java and did a reverse engineering to come up with the<br />
design of Data Marts.<br />
•Designed Data Marts with various Dimensions and Fact Tables.<br />
<br />
(10/09) – Till Date<br />
<br />
Implemented several complex queries in SQL and used Report Studio.<br />
Used JavaScript to validation of prompt page and created several Conditional Block in<br />
reports to display different outputs based on prompt page selections.<br />
• Designed and implemented security at different levels, one at Framework Manager,<br />
other at folder level in Cognos Connection and third was data level security built at division<br />
level.<br />
• Involved in defining mappings to build the Framework Manager Model and Package<br />
with customized Query Subjects and Query items and published package from Framework<br />
Manager to Cognos Connection.<br />
•Presented the report deliverables to the Business Users for UAT and implemented the<br />
changes based on their recommendations.<br />
• Extensively involved in writing Oracle PL/SQL Procedures, Triggers, Views,<br />
Materialized views and Sequences for the application.<br />
•Involved in scheduling, distributing, bursting of reports.<br />
•Involved in developing POC using Cognos TM1.<br />
•Migrated successfully Cognos 8.4.1 reports to Cognos 10.<br />
<br />
•Environment: Cognos 10, Cognos 8.4.1 BI(Report Studio, Analysis Studio, Query Studio, Event<br />
Studio and Metric Studio), Cognos TM1, Oracle 11i, PL/SQL Developer,PVCS, Windows 2003<br />
<br />
UBS, NYC, NY<br />
Lead Cognos Developer<br />
<br />
Project Description: UBS Wealth Management Reporting portal is highly functional and<br />
Interactive portal where management, advisors can track client portfolio’s, identify the trends<br />
and events affecting global and local markets, and apply them to the interests and financial<br />
objectives of private clients.<br />
<br />
Contributions:<br />
• Interacting with the users for understanding of Data Analysis and gathering business<br />
requirements.<br />
• Prepared all the required documents for Cognos objects like high level design<br />
documents, unit test plan documents.<br />
•Worked with users for design finalizations and assessments of the requirements.<br />
•Extracted and Transformed data from Heterogeneous Databases based in SQL Server<br />
2005, DB2 UDB and Oracle 10g using Decision Stream.<br />
•Presented proof of concept to demonstrate that heterogeneous data sources can be used<br />
in Cognos.<br />
•Worked with data architects to develop data models, design specifications, and metadata<br />
documentation.<br />
•Assist in the development and architecting data warehouse initiatives and reporting needs<br />
for the business.<br />
•Design and create complex framework manager models connecting to various databases<br />
like Oracle, SQL Server and DB2 UDB in a single model. Also making the model<br />
consistent with the reporting requirements.<br />
•Performed model refinement from time to time to enhance performance by incorporating<br />
lookup tables to avoid CASE and DECODE statements used at Framework Manager<br />
level.<br />
• Involved in defining mappings to build the Framework Manager Model and Package<br />
with customized Query Subjects and Query items and published package from<br />
Framework Manager to Cognos Connection.<br />
•Created folders, filters, prompts, and complex business calculations in Framework<br />
Manager Model.<br />
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts,<br />
Multiple-levels of Drill through Reports and Master Detail Reports Using Report<br />
Studio.<br />
•Created Ad-hoc reports in Query Studio for users.<br />
•Customized reports using Cognos SDK according to reporting requirements.<br />
• Created Score Cards, Dashboards and Key performance Indicators for decision support<br />
<br />
(04/08) – (09/09)<br />
<br />
using Metric Studio.<br />
Scheduled reports, maintained public and individual folders, user groups and roles using Cognos Connection in Report Studio. Extensively worked on Performance tuning, Testing and validating the data in Cognos.<br />
<br />
•Environment: Cognos 8.4 BI, Cognos 8.3 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio), Cognos Decision Stream 7.1, SQL Server 2005, Oracle 10g, TOAD 8.6, Windows 2003<br />
<br />
IFC (International Finance Corporation), Washington, DC<br />
Cognos ReportNet Consultant<br />
<br />
Project Description: CAPRI (Capital Pricing and Risk) application objective is to provide the<br />
business analyst an integrated data and a flexible analysis and reporting framework, for their<br />
financial and risk assessment activities in the department IFC of World Bank.<br />
<br />
Contribution<br />
• Work with Business Units to define Business strategy and create a centralized reporting<br />
capability for users to perform analytical, and ad-hoc reporting for business applications<br />
and provide accurate information available to Decision Makers.<br />
• Created Relational Data models and Dimension Data models using Framework<br />
Manager to represent the business information and making the model consistent with the<br />
reporting requirements.<br />
•Created User Groups, Roles in Cognos Connection to implement the Security Filters in<br />
Framework Manager Model.<br />
•Created Technical Specifications and Functional Specifications for all reports.<br />
• Created Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of<br />
Drill through Reports and Master Detail Reports Using Report Studio.<br />
• Created, organized and formatted reports, folders and other contents on Cognos<br />
Connection Portal.<br />
•Developed Cognos transformer models using Cognos Powerplay Transformer.<br />
•Developed Analysis studio Reports and cubes using Analysis Studio.<br />
•Developed Customize and Burst Reports using Report Studio.<br />
• Performance tuning by analyzing and comparing the turn around times between SQL and Cognos.<br />
•Created Run and Schedule Reports and Jobs using Cognos Connection.<br />
•Provided technical assistance, training and mentoring to Users and Business Partners.<br />
<br />
Environment: Cognos 8.1 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio),Oracle 9i, Windows2000 Server<br />
<br />
GSK (Glaxo Smithkline), King of Prussia, PA<br />
OLAP Developer<br />
<br />
Project Description: The purpose of the Profit Management Analysis and Reporting (PMAR) Tool is to enable GSKTS (GSK Trading Services) and GSKE (GSK Export) to perform the profit management reviews. These reviews are required to ensure that the target profit is achieved by GSKTS and GSKE.<br />
<br />
In addition to transfer prices and sales volumes, the profit is also dependent on associated expenses and costs for example Promotional expenses, Freight charges etc for which the allocation will be performed in PMAR.<br />
<br />
(08/06) – (03/08)<br />
<br />
(01/05) – (07/06)<br />
<br />
Contribution<br />
• Involved in Installing and Configuring ReportNet Server, Framework Manager, Report Studio, Query Studio and Cognos Connection Portal.<br />
•Interacted with business users for their requirement.<br />
•Involved in Startegic Planning for Cognos ReportNet Framework Model.<br />
•Built Models and published Packages utilizing Framework Manager.<br />
•Created database connections for different data sources.<br />
•Created Reports (Simple & Complex) using Query Studio and Report Studio for training purpose.<br />
• Created, organized and formatted reports, folders and other contents on Cognos Connection Portal.<br />
• Created several different types of ad-hoc (Simple List, Grouped List, Section Heading, Crosstab, and Nested Crosstab) Reports and represented data graphically by Charts utilizing Query Studio.<br />
• Created several different types of Professional Reports (Mailing Labels, Cascading, Linked /Drill Through, Production, Business, Ranking, etc.) with complex formatting utilizing Report Studio.<br />
•Loaded data from the files got in different formats into the development and production systems using DTS.<br />
•Used DTS to migrate the existing data from MS-Access to Sql Server 2000.<br />
•Worked with ETL team in designing the data model using Star Schema.<br />
• Created a model using Framework Manager and packed the model with Reports and published on to the ReportNet Server.<br />
•Developed Customize and Burst Reports using Report Studio.<br />
• Produced Queries and Reports in Multiple Languages, Format, Present and Distribute Reports utilizing Different Layouts, Multiple Report Objects and Multiple Logical Pages.<br />
•Created Run and Schedule Reports and Jobs using Cognos Connection.<br />
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.<br />
•Tested and debugged Cognos metadata layer reports.<br />
•Developed Standard templates in Report Studio for developing reports.<br />
•Performed Unit testing for all developed reports.<br />
<br />
Environment: Reportnet1.1MR2, Framework Manager, Query Studio, Report Studio,<br />
Cognos Connection, SQL, Oracle 9i, TOAD 7.4., UNIX<br />
<br />
CISCO, San Jose, CA<br />
Cognos ReportNet Consultant<br />
<br />
Project Description: Sarbanes-Oxley Express (SOX Express) is an Internal Controls Management System that empowers CEOs, CFOs and financial management officers to document internal controls as setup by the Sarbanes-Oxley Act.<br />
<br />
SOX Express allows users to easily see the status of their internal controls documentation project, and provides a secure repository for the storage of their IC documentation.<br />
<br />
SOX Express has many features that assist users in documenting their internal controls. Some of the most important are:<br />
• The Compliance Repository<br />
• Powerful Compliance Automation<br />
• Configurable Interactive Monitoring<br />
• Unparalleled User Productivity<br />
<br />
Reports which help the management to view the data captured using Sox Express tool are<br />
developed using Cognos ReportNet.<br />
<br />
Contribution<br />
•<br />
Co-ordinate with On-site team in gathering the business requirements of reports.<br />
<br />
(01/04) – (12/04)<br />
<br />
•<br />
<br />
Modifications in the package already developed by Open Pages (Third Party) based on the reporting requirements.<br />
Responsible for getting the reports developed by the team members and delivering the same to the user after doing unit testing Deployed packages, folders, and content store in production environment.<br />
<br />
•Environment: Cognos ReportNet 1.1 MR1, Oracle 9i, TOAD 7.4., UNIX<br />
<br />
CISCO, San Jose, CA<br />
ETL Developer<br />
<br />
Project Description: Channel Bookings, maintains the orders CISCO gets from customers.<br />
Bookings could be Entered i.e., customer places an order and Not Cisco Booked (NCB) i.e.,<br />
Order raised but not purchased or No revenue on that order. After the order is booked, if it<br />
satisfies the Cisco Policy then it is Invoiced and then GL-posted, Credit Memo or Debit Memo<br />
accordingly.<br />
<br />
Contribution<br />
•<br />
Co-ordinate with On-site team in gathering the business requirements. <br />
• Developed and implemented the enhancements in ETL procedures using Informatica tool and deployed successfully.<br />
•Developed and implemented PL\SQL procedures.<br />
•Involved in testing phase.<br />
• Responsible for documentation of the anticipatory risk factors where failure of the ETL mappings can take place and necessary steps to be taken when failure occurs.<br />
<br />
Environment: Informatica Power Mart 4.7, Power Centre 4.7, Oracle 9i, TOAD 7.4.,Unix<br />
<br />
Bear Stearns (Investment Banking firm),NYC,NY<br />
Cognos Consultant<br />
<br />
Project Description: Bear Stearns is one of the leading companies in Investment Banking. Bear Stearns plan was to migrate all their reports from Infomaker, Power Builder to Cognos Impromptu. There were nearly 200 reports to be converted into cognos - impromptu from power builder. Impromptu reports were developed using catalog where the catalog is built using tables, views and stored procedures (OLTP design). The reports were developed in impromptu and published in Upfront where the user is provided to view the report in four<br />
different formats (Pdf, Excel, CSV, Html). Power prompt applications for some of the above mentioned reports are also developed to facilitate the validations of input parameters more appropriately.<br />
<br />
Contribution<br />
<br />
•Interacted with the users for understanding and gathering business requirements.<br />
Involved in the analysis, design, develop, testing, deployment and user training of analytical transactional reporting system.<br />
Involved in design and development of user classes, filters, calculations, prompts and conditions in Catalog and query definition files in Impromptu Administrator.<br />
Optimized by assigning relative weights to the tables in the Catalog and Query Performance (in Governor's settings).<br />
Created Catalog in Impromptu Administrator to create Reports.<br />
Generated reports using Cognos Impromptu tools querying database.<br />
Created list reports and cross tab reports and drill through reports.<br />
Created various Drill through reports from report to report.<br />
Created User Classes and Users in Access manager.<br />
Created Cubes by using Cognos Power Play to analysis.<br />
Worked on Cognos Security Administration to restrict the Users.<br />
Created Models by using Impromptu Query Definition (IQD) in Power Play<br />
Transformer.<br />
<br />
<br />
(12/02) – (12/03)<br />
<br />
(08/01) – (11/02)<br />
<br />
Extensively worked on Power Prompts.<br />
Used Power Prompts Developer Studio for Designing Application.<br />
Created Prompts to User Defined Filters.<br />
Used Power Play Enterprise Server to publish the cubes.<br />
Maintain the Cube Security by Category level and Dimension level.<br />
Used Cognos Scheduler to schedule the Reports.<br />
Updated Impromptu Catalog by adding tables and creating new joins.<br />
Good knowledge in Unit/integration Testing.<br />
Extensively worked on TOAD tool, testing the queries.<br />
• Discussed business requirements and mapped business needs using Cognos Transformer.<br />
•Successfully developed and implemented Metrics using Cognos Impromptu.<br />
•Developed Visualizer Charts to make better decisions.<br />
• Installed, Configured and did Performance Tuning Cognos EP Series as Business Intelligence tool.<br />
<br />
•Environment: COGNOS EP Series (Impromptu Administrator, Impromptu Web Reports Power<br />
Play, Transformer, Power Play Enterprise Server, Access Manager, Server Administrator,<br />
Upfront (for Web),Power Builder,DB2 (UDB) 8.1,Windows2000 Server<br />
<br />
Universal Textile Mills , India<br />
Cognos Consultant<br />
<br />
Project Description: Processes that Identify, Prioritize and Improve areas of performance that have the greatest impact on customer loyalty. Keep as many customers as possible, keep them satisfied, keep them loyal, and keep them for life. Measuring their performance over time and against competitors, how they drive customer feedback through the organization to build lasting customer relationships.<br />
<br />
Contribution<br />
<br />
•Extensive interaction with Business Users and gather information and requirements.<br />
Installed and configured Cognos Power Play and Impromptu software<br />
Developed reports like drill through reports, sub reports, list reports using Cognos Impromptu.<br />
Created catalogs from multiple databases with the help of Hot Files (.ims)<br />
Enhanced the existing reports and created new reports as per the user requirements.<br />
Handled optimization of queries for better response from impromptu.<br />
Created Models by using Impromptu Query Definition (IQD) in Power Play Transformer.<br />
Created Catalog and assigned joins as per the requirements.<br />
Generated the reports using Cognos Impromptu by querying the data from different database tables as per the requirement.<br />
Customized the reports by adding calculations, conditions and functions.<br />
Created List Reports, Cross Tab Reports and Drill through reports.<br />
Created Filters, Conditions and Prompts in Catalog.<br />
Defined, created, maintained and published Power cube and PowerPlay web reports and published IWR reports on the web.<br />
Worked extensively on Oracle database. Troubleshoot for SQL issues/performance issues.<br />
Participated in the development of catalogs, multiple queries with complicated reports and query definition files using various join and filter conditions in Impromptu.<br />
Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through.<br />
Did detailed reports, catalogs, folders filters, prompts, calculated columns and conditions for multi dimensional analysis.<br />
Published on IWR Server.<br />
Worked extensively with Power Play Enterprise Server and the Upfront in publishing the cube.<br />
Automating tasks with Cognos Scheduler using Macros, Cognos Script Editor and Cognos Script Dialog Editor.<br />
<br />
•(03/00) – (07/01)<br />
<br />
•Optimized Catalog by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.<br />
<br />
Environment: Cognos EP Series 7, SQL Server 7.0, Windows 2000<br />
<br />
Client Dalmia Securities Limited, India<br />
Senior Developer<br />
<br />
Project Description: BrokBO is the Product, which handles the brokers back office activities.<br />
This product provides a complete solution to automate the back office activities. The system allows to define various related brokers and handle their trading activities like…<br />
<br />
•Processing the trade files (both Capital Market and Futures & Options)<br />
•Handling the Deliveries of Securities to Clients and Stock Exchange.<br />
•Managing Accounts of Brokers defined in BrokBO system.<br />
Generating various reports for brokers like trade summary report, Obligation reports, service tax reports, stamp charges reports etc.,<br />
<br />
Contribution<br />
<br />
<br />
Responsible in the Analysis of client specification, designing and documentation.<br />
Developed dynamic web pages using ASP.NET.<br />
Involved in manual functional testing.<br />
Developed Test Scenarios and Test Cases.<br />
Responsible in the analysis and evaluation of third party tools.<br />
Responsible in developing stored procedures and database design in SQL Server<br />
<br />
Environment: Asp.Net, VB.Net, Ado.Net, SQL Server 7.0, Windows 2000<br />
<br />
Delco Remy Electricals India Ltd, India<br />
Senior Developer<br />
<br />
Project Description: Information Management System (IMS - Prod) is a Production based system including Production Plan, Material Requirement Plan and Marketing plan. Basically it is made in to a product which suites any type of production environment. The various modules included in this product are Marketing, Engineering, Purchase, Stores, Sub Contract, Production and Dispatch. Each module deals with the corresponding department in depth to input all the required data and let us to analyze the data for generating detailed reports for designing the plans (like production plan, marketing plan etc)<br />
<br />
Contribution<br />
<br />
•Responsible in design and development.<br />
Developed dynamic web pages using ASP.<br />
Responsible for developing Database design.<br />
Responsible for developing User Interface.<br />
<br />
•Environment: Visual Basic 6.0, Ms-Access2000 / Oracle, Windows 98<br />
<br />
Academic Qualification:<br />
<br />
Msc (S/W Applications), Bharathiyar University, Coimbartore, India<br />
BSc(Computer Science) , Sri Venkateswara University, India<br />
<br />
(03/99 - 02/00)<br />
<br />
(06/98) – (02/99)<br />
<br />
Certifications :<br />
<br />
1. Cognos ReportNet Modeling Product Professional<br />
2. Cognos ReportNet Server Administration<br />
3. PowerPlay Series 7 Product ProfessionalUnknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-83124562269289371802010-09-19T17:29:00.000-07:002010-09-19T17:29:04.386-07:00New BI Resource Available 20100919-001<h3 class="post-title entry-title"> New BI Resource Available 20100919-001</h3><div class="post-header"> </div><span style="font-weight: bold;"><a href="mailto:busienssintelligencecentre@gmail.com?subject=20100919-001">Email us today</a> if you`re interested in this resource</span><br />
<br />
Looking for a part-time remote Cognos Developer/Architect job.<br />
<br />
<br />
<div>Experience developing different Cognos solutions for last 4.5 years as an architect/developer/project manager.</div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-67761709582168030592010-07-15T19:51:00.001-07:002010-07-15T19:51:50.256-07:00new cognos job<a href="http://c8jobs.blogspot.com/2010/07/forrester-research-is-hiring-for-data.html">http://c8jobs.blogspot.com/2010/07/forrester-research-is-hiring-for-data.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-15813102031754520332010-07-08T17:58:00.000-07:002010-07-08T17:58:37.798-07:00Cognos 8 Diagnostic: Cognos 8 Diagnostic tools are coming soon...Be s...<a href="http://cognos8diagnostic.blogspot.com/2010/07/cognos-8-diagnostic-tools-are-coming.html?spref=bl">Cognos 8 Diagnostic: Cognos 8 Diagnostic tools are coming soon...<br /><br />Be s...</a>: "Cognos 8 Diagnostic tools are coming soon... Be sure to visit: http://bicentre.blogspot.com/ http://bicentresdkguide.blogspot.com/ http:..."Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-13999277610508407752010-04-27T18:18:00.000-07:002010-04-27T18:22:17.938-07:00New BI Resource Available 20100427-001<div style="margin: 1ex;"> <div> <span style="font-weight: bold;"><a href="mailto:busienssintelligencecentre@gmail.com?subject=20100427-001">Email us today</a> if you`re interested in this resource</span><br /><ul><p align="justify"><span style=";font-family:Verdana;font-size:78%;" >To work with team spirit in an esteemed organization where my knowledge of Information Systems can be utilized in organizational and personal growth. A challenging position in the field of Information Systems that would provide an opportunity for learning and applying Software Engineering and Database Development skills based on the knowledge of current tools, trends and technologies. I am confident, self-motivated and hard working. I usually get pleased to meet new people and user groups to keep myself up to date. I am target oriented and willing to swim on horizon of Information Technology Management.</span></p></ul> <li><br /></li> <ul><ul><li><span style=";font-family:Arial;font-size:100%;" ><b>Summary:</b></span></li></ul><ul><p align="justify"><span style=";font-family:Verdana;font-size:78%;" >A Senior Application Developer/Team Lead with over 5 years experience in full Life Cycle development including business analysis, architecture, design, development, deployment & Management using Microsoft technologies. Extensive experience in Design & Architecture of Data Models and Database for MS SQL Server. 3 years of experience in Business Intelligence using Pentaho, Cognos 7 and Cognos8. 3 years experience in designing and developing desktop applications on Microsoft platform using VB, <a href="http://vb.net/" target="_blank">VB.NET</a>, SQL Server 2000 and Crystal Reports. Have domain knowledge of various businesses like Banking, Stock Exchange, Mortgages, E-Learning and Insurance division. Developed various desktop and web enterprise applications using Cognos, VB, <a href="http://vb.net/" target="_blank">VB.NET</a>, Crystal Reports, Teradata, Microsoft SQL Server and MS Access. </span></p></ul><li><br /></li><ul><ul><li><span style=";font-family:Arial;font-size:100%;" ><b>Technical Skills</b></span></li></ul><br /><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>B.I Tools: </b> Cognos 7, Cognos 8, Pentaho Kettle</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Databases: </b> Teradata, MS SQL Server 2000 & 2005, MS Access, Oracle and DB2.</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Languages: </b> VB, <a href="http://vb.net/" target="_blank">VB.NET</a>.</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Development Tools:</b> Visual Studio.NET, MS Visio, MS Project and MS Office.</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Reporting Tools: </b> Crystal Reports, JReports, Active Reports, SQL Server Reporting Services, Crystal Xcelsius</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Live Cycle Tools: </b> Adobe Live Cycle Designer 7.1 & 8.1</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Version and Source Control: </b> Visual Source Safe, SVN</span></p></ul><ul><ul><li><span style=";font-family:Arial;font-size:100%;" ><b>Education & Credentials</b></span></li></ul><br /><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>SZABIST</b>- Karachi, Pakistan</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>M.S in Computer Science</b>, completed in 2006 with 3.66 CGPA.</span></p></ul><br /><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>BAHRIA UNIVERSITY</b>- Karachi, Pakistan</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>B.S.E in Computer Science</b>, completed in 2004 with 3.28 CGPA.</span></p></ul><br /><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Adamjee Science College</b>- Karachi, Pakistan</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Intermediate – Pre Engineering </b>, completed in 2000 with B Grade.</span></p></ul><br /><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Al Murtaza School</b>- Karachi, Pakistan</span></p></ul><ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>Matriculation - Science</b>, completed in 1998 with A Grade.</span></p></ul><br /><p><span style=";font-family:Arial;font-size:100%;" ><b>Awards</b></span></p><br /><ul type="DISC"><li><span style=";font-family:Verdana;font-size:78%;" ><b>Certificate of Achievement</b> – Outstanding Performance from RBS</span></li><li><span style=";font-family:Verdana;font-size:78%;" ><b>Exceptional Team Award</b> from Systems Limited.(Worked as Component Lead in this project) </span></li><li><span style=";font-family:Verdana;font-size:78%;" ><b>Outstanding Team Award</b> from Systems Limited.(Worked as Team Lead in this project)</span></li></ul><li><br /></li><li><br /></li><li><br /></li><li><br /></li><ul><ul><li><span style=";font-family:Arial;font-size:100%;" ><b>Professional Experience </b></span></li></ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>From: December 2009-Till Date Data Warehouse Engineer at 360Training</b></span></p><p><span style=";font-family:Verdana;font-size:78%;" ><b>Description: </b></span></p><p align="justify"><span style=";font-family:Verdana;font-size:78%;" >Responsibilities include Designing and Development of Data warehouse and to keep intact with all of the systems running in company. Be involved in full life cycle development and implementation of enterprise data warehouse, BI reporting and analytical services. </span></p><br /><ul type="DISC"><li><span style=";font-family:Verdana;font-size:78%;" >Designed and Developed Data Warehouse to be capable of containing all Revenue Related Data. <b> Tools</b>: SQL Server 2005/2008 </span></li><li><span style=";font-family:Verdana;font-size:78%;" >Developed ETL to migrate data from all the Systems that are currently being used in company which include Virtual University , Learner MS , Learner Course MS , My Classroom Management. <b>Tools</b>: Pentaho Kettle , SQL Server 2005/2008</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Improvement of the Database Designs and Optimization of queries that are not performing effectively. <b> Tools:</b> SQL Server 2005/2008</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Working with Network Operations team to resolve Performance and Other Database related issues. Helping out other teams in Query Optimization and Database Development.</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Migration of Store Front(IBM) Data to Data Warehouse . <b>Tools</b>: Pentaho Kettle , SQL Server 2005, DB2</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Migration of Quick books Data to Data Warehouse . <b>Tools</b>: Pentaho Kettle , SQL Server 2005, QODBC</span></li></ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>From: June 2008-December 2009 Assistant Manager – Business Intelligence Unit at RBS</b></span></p><p><span style=";font-family:Verdana;font-size:78%;" ><b>Description: </b></span></p><p align="justify"><span style=";font-family:Verdana;font-size:78%;" >Responsibilities include Managing a Data Warehouse, understanding new requirements, analyze the problems, suggest the solutions, implement the changes, develop BI analytics such as (Reports, Cubes and Dashboard), and perform the verification with associate department.</span></p><ul type="DISC"><li><span style=";font-family:Verdana;font-size:78%;" >Developed Cubes for Operations, AD&E, Liabilities and Asset Marketing by which user can perform various analytics like Cross Sell, CM Retention and Segmentation. <b> Tools:</b> Cognos 7, Teradata</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Designed strategic reporting for Consumer Risk Management some of which includes IS-Was analysis, Vintage Analysis, Utilization Analysis, Collection & Collection Performance Reports, and Product Caps Report. <b>Tools:</b> Cognos 8, Teradata</span></li><li><span style=";font-family:Verdana;font-size:78%;" >DWH Administration <b>Tools:</b> Teradata</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Providing demand analytics and reports for different departments like Operations, Finance, AD&E, Business Quality, Branch Banking, Wealth Management Unit, Secured Assets and Unsecured Assets. <b>Tools:</b> Teradata, Excel</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Designed and Developed Reports & Dashboards for Business Heads/Branch Banking Users which include Weekly Dashboard , Monthly Dashboard , Comparison of Current Picture with SPLM , Branch Performance Report , Turnover Report, Account Deepening Report.</span></li></ul><p align="justify"> <span style=";font-family:Verdana;font-size:78%;" ><b>Tools:</b> Teradata, Cognos 8</span></p><p><span style=";font-family:Verdana;font-size:78%;" ><b>From: Feb 2007-May 2008 Senior Software Engineer at Systems Limited</b></span></p><p><span style=";font-family:Verdana;font-size:78%;" ><b>Description: </b></span></p><p align="justify"><span style=";font-family:Verdana;font-size:78%;" >Responsibilities include Managing Team, understanding new requirements, analyze the problems, making project plan, initiate development and implement the changes, updating stakeholders, taking care of each and every step from analysis till deployment.</span></p><ul type="DISC"><li><span style=";font-family:Verdana;font-size:78%;" >Worked as DBA/Team Lead for Reporting Module/Forms of Victors Application designed for Lenders First Choice (Title Insurance Application). <b>Tools: </b> Cognos 8.2 (BI Tool) / SQL SERVER 2005 (Back end)/Adobe Live Cycle 7.1,8.1(LiveCycle Tool)</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Worked as Team Lead for Reporting Module of Registrar/Transfer Authority system designed for Central Depository Company. Reports were designed for Corporate Actions, Administration, General, Transfer and SBP sections.<b> Tools: </b> JReports (Reporting Tool) / Oracle 10g (Back end).</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Developed the Reporting module of Visi Loan Review designed for Bank of America and Freddie Mac. Reports for all type of loans were developed.</span></li></ul><ul><p align="justify"> <span style=";font-family:Verdana;font-size:78%;" ><b>Tools: </b> Crystal Report (Reporting Tool) / SQL SERVER (Back end) / <a href="http://asp.net/" target="_blank">ASP.NET</a> (Front end)</span></p></ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>From: July 2006-Feb 2007 Software Engineer at Wavetec Pvt. Ltd.</b></span></p><p><span style=";font-family:Verdana;font-size:78%;" ><b>Description: </b></span></p><ul type="DISC"><li><span style=";font-family:Verdana;font-size:78%;" >Developed Stock Game for Dubai Financial Market. This project is a game and all the operations and functionality are same as of Real Stock Market. SG is designed for the competition which is arranged by DFM for the students of different schools every year. Important feature of this project is that it was designed in such a way that it’s not restricted to one market and one student can play in more than one market at a time with the same portfolio affected. <b>Tools: </b>ASP (Front end) / SQL SERVER (Back end).</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Designed and Developed eqConfiguration System. This project is basically a configuration system for Electronic Queue Management System It was designed various clients in UAE. This project has two other parts, which are Desktop Ticket Dispensing Unit, which talk with router and get the ticket number and then print that ticket, other part was LCD TDU Screen that is a picture based screen, it also have the same functions as Desktop TDU, but from pictures.<b> Tools: </b>VB 6.0 (Front end) / SQL SERVER (Back end) / ROUTER (Linux Based)</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Designed and Developed Attendance Management System for HR Department. Basically this project was having two parts, one was related to Attendance itself and other was a small portion of HR, so that other salary calculation and other matter of HR could also be resolved using this system. This project also consists of some reports and other process to implement other management policy. <b> Tools: </b><a href="http://vb.net/" target="_blank">VB.NET</a> (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting) </span></li></ul><p><span style=";font-family:Verdana;font-size:78%;" ><b>From: March 2005-July 2006 Assistant MIS at Crescent Leasing Corporation Limited</b></span></p><p><span style=";font-family:Verdana;font-size:78%;" ><b>Description: </b></span></p><ul type="DISC"><li><span style=";font-family:Verdana;font-size:78%;" >Designed and Developed Lease Management System. This project consisted module for Leasing, Depreciation, Assets and CIB.<b> Tools: </b>VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting).</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Developed CresTreasury. This project consist modules for Treasury and Money Marketing.<b> Tools: </b> VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting)</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Developed Attendance Management System. This project was having two parts, first the interface with the IGAURD Machine which recorded the Attendance and secondly the reports and other process to implement other management policy. <b>Tools: </b> VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting) / IGAURD (Server)</span></li><li><span style=";font-family:Verdana;font-size:78%;" >Designed and Developed ChequeInfo System, which main aim was to do the cheque management and other issues related to cheques.<b> Tools: </b>VB 6.0 (Front end) / SQL SERVER (Back end) / Crystal Report (Reporting)</span></li></ul></ul></ul></ul></ul></div> </div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-61084783288049941572010-04-24T06:38:00.001-07:002010-04-24T06:38:49.569-07:00Does your Cognos 8 report need to follow Section 508?<a href="http://cognos8help.blogspot.com/2010/04/section-508-compliance-guide-now.html">http://cognos8help.blogspot.com/2010/04/section-508-compliance-guide-now.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-88711523362641794212010-04-08T19:08:00.000-07:002010-04-08T19:09:03.947-07:00new cognos job<a href="http://c8jobs.blogspot.com/2010/04/ibm-cognos-business-intelligence.html">http://c8jobs.blogspot.com/2010/04/ibm-cognos-business-intelligence.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-32587634017714936392010-01-09T19:07:00.001-08:002010-01-09T19:07:19.629-08:00New Cognos Job<a href="http://c8jobs.blogspot.com/2010/01/senior-technical-specialist.html">http://c8jobs.blogspot.com/2010/01/senior-technical-specialist.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-87709104290411308712009-10-12T20:00:00.001-07:002009-10-12T20:00:40.647-07:00New Cognos Job<a href="http://c8jobs.blogspot.com/2009/10/cognos-planning-and-performance.html">http://c8jobs.blogspot.com/2009/10/cognos-planning-and-performance.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-50444593186287037462009-07-02T04:51:00.000-07:002009-07-02T04:59:27.914-07:0020090702-001<h3 class="post-title entry-title"> </h3> <div class="post-body entry-content"> <b><span style="font-size:9;"></span></b><b><span style="font-size:9;"> </span></b><span style="font-size:9;"><span style="font-size:130%;"><a style="font-weight: bold;" href="mailto:busienssintelligencecentre@gmail.com?subject=20090702-001">Email us today if you're interested in this resource.</a></span></span><br /></div><h1 style="font-family:arial;"><span style="font-size:85%;">PROFILE</span></h1> <p align="justify" style="font-family:arial;"><span style="font-size:85%;">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.</span><span style="font-size:85%;"><br /></span></p> <p align="justify" style="font-family:arial;"><span style="font-size:85%;">Earlier experience – Worked for HSBC Software Development India Pvt Ltd for 54 months as Senior Software Engineer.</span></p> <div style="font-family:arial;"><li><span style="font-size:85%;">SKILL</span></li> <span style="font-size:85%;"><br /><a name="0.1_table01"></a></span> <div align="left"> <table style="width: 466px; height: 188px;" border="2" cellspacing="0"> <tbody><tr valign="top"><td height="12"><ul type="disc"><li><span style="font-size:85%;">Reporting</span></li></ul> </td> <td><span style="font-size:85%;">Cognos 8, Framework Manager, OLAP/DMR Modeling, Report Studio, Query Studio, Analysis Studio, Powerplay-Transformer.</span></td></tr> <tr valign="top"><td height="13"><ul type="disc"><li><span style="font-size:85%;">Web Programming:</span></li></ul> </td> <td><span style="font-size:85%;">Core Java, JavaScript, HTML, XML, XSLT</span></td></tr> <tr valign="top"><td height="13"><ul type="disc"><li><span style="font-size:85%;">Databases:</span></li></ul> </td> <td><span style="font-size:85%;">Oracle, DB2</span></td></tr> <tr valign="top"><td height="12"><ul type="disc"><li><span style="font-size:85%;">MISC</span></li></ul> </td> <td><span style="font-size:85%;">UML, Rational Rose, Quality Center, Dom Doc, Clarity</span></td></tr> </tbody></table> </div> <h1><span style="font-size:85%;">TRAINING:</span></h1> <p><span style="font-size:85%;"><b>CA Unicenter based (At Computer Associates training center - Chicago):</b></span></p> <ul type="disc"><li><span style="font-size:85%;">UR376 Unicenter Service Desk: Analyst Operations</span></li><li><span style="font-size:85%;">URV386 Unicenter Service Desk: Administration</span></li></ul> <p><span style="font-size:85%;"><b>Cognos Reporting (At Cognos Incorporated training center - Chicago): </b></span></p> <ul type="disc"><li><span style="font-size:85%;">Cognos 8 BI - Report Authoring - Part 1</span></li><li><span style="font-size:85%;">Cognos 8 BI - Report Authoring - Part 2</span></li><li><span style="font-size:85%;">Cognos 8 BI - Metadata Modeling - Part 1</span></li><li><span style="font-size:85%;">Cognos 8 BI - Metadata Modeling - Part 2</span></li><li><span style="font-size:85%;">PowerPlay OLAP Modeling for Series 7 Version 3 & Cognos 8 BI</span></li><li><span style="font-size:85%;">Cognos 8 BI - Server Administration</span></li><li><span style="font-size:85%;">Cognos 8 BI - Content Administration</span></li></ul> <h1><span style="font-size:85%;">PROFESSIONAL EXPERIENCE</span></h1> <p><span style="font-size:85%;">TietoEnator Corporation, Senior Software Proffesional (<b>May 2009 – Till date</b>)</span></p> <p><span style="font-size:85%;">HSBC - Pune, Senior Software Developer (<b>Nov 2004 – May 2009</b>)</span></p> <h1><span style="font-size:85%;">Project Details:</span></h1> <span style="font-size:85%;"><br /><br /><a name="0.1_table02"></a></span> <div align="left"> <table style="width: 437px; height: 594px;" border="2" cellspacing="0"> <tbody><tr valign="top"><td><span style="font-size:85%;"><b>Project Name:</b></span></td> <td><span style="font-size:85%;"><b>Gepardi - Mankeli Reporting (Cognos 8 Reporting)</b></span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Duration:</b></span></td> <td><span style="font-size:85%;">May 2009 – Till Date</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Organization:</b></span></td> <td><span style="font-size:85%;">TietoEnator Corporation, Pune</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Client:</b></span></td> <td><span style="font-size:85%;">Elisa Telecommunications, Finland</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Summary:</b></span></td> <td><span style="font-size:85%;">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.</span><span style="font-size:85%;"><br /></span> <p align="justify"><span style="font-size:85%;">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.</span><span style="font-size:85%;"><br /></span> </p> <p align="justify"><span style="font-size:85%;">Cognos system has 12 packages, 5 CUBES, 120 reports and 470 users.</span></p></td></tr> <tr valign="top"><td height="62"><span style="font-size:85%;"><b>Role:</b></span></td> <td><span style="font-size:85%;">Development Lead: </span> <ul type="disc"><li><span style="font-size:85%;"><b>Attended Knowledge transfer sessions at Elisa premises in Finland by IBM to TietoEnator Corp.</b></span></li><li><span style="font-size:85%;">Involved in acquiring knowledge about Project Architecture (both technical and business).</span></li><li><span style="font-size:85%;">Involved in knowledge transfer on existing Cognos reporting solution.</span></li><li><span style="font-size:85%;">Prepared resource estimation based on the work for next quarter.</span></li><li><span style="font-size:85%;">Prepared workshop notes which will help the new team members who will join the team.</span></li><li><span style="font-size:85%;">Prepared the ROTA for taking up support stuff</span></li></ul> </td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Environment</b></span></td> <td><span style="font-size:85%;">Cognos 8</span></td></tr> </tbody></table> </div> <span style="font-size:85%;"><br /><br /><br /><br /><a name="0.1_table03"></a></span> <div align="left"> <table style="width: 398px; height: 696px;" border="2" cellspacing="0"> <tbody><tr valign="top"><td><span style="font-size:85%;"><b>Project Name:</b></span></td> <td><span style="font-size:85%;"><b>Global Service Desk (Cognos 8 Reporting)</b></span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Duration:</b></span></td> <td><span style="font-size:85%;">Aug 2006 – May 2009</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Organization:</b></span></td> <td><span style="font-size:85%;">HSBC GLT Pune</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Client:</b></span></td> <td><span style="font-size:85%;">HSBC USA</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Summary:</b></span></td> <td><span style="font-size:85%;">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.</span> <p align="justify"><span style="font-size:85%;">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.</span></p></td></tr> <tr valign="top"><td height="62"><span style="font-size:85%;"><b>Role:</b></span></td> <td><span style="font-size:85%;">Framework Modeler and Report author. </span> <ul type="disc"><li><span style="font-size:85%;">Analysis of user requirements.</span></li><li><span style="font-size:85%;">Involved in Data warehouse design</span></li><li><span style="font-size:85%;">Identify fields from OLTP system to be migrated to Data warehouse depending on reporting requirements</span></li><li><span style="font-size:85%;">Creation of data warehouse requester spreadsheet</span></li><li><span style="font-size:85%;">Written transformation logic to de normalize data warehouse</span></li><li><span style="font-size:85%;">Written scripts to test data in data warehouse in all three environments viz Dev, UAT and PROD</span></li><li><span style="font-size:85%;">Involved in metadata modeling using framework manager.</span></li><li><span style="font-size:85%;">Involved in creation of IQD for input to Transformer.</span></li><li><span style="font-size:85%;">Involved in creation of Dimensional data model. </span></li><li><span style="font-size:85%;">Involved in preparing Prototype (Screen mockups for reports).</span></li><li><span style="font-size:85%;">Involved in preparation of Unit Test Cases</span></li><li><span style="font-size:85%;">Involved in Framework Modeling and peer review.</span></li><li><span style="font-size:85%;">Involved in development of reports.</span></li><li><span style="font-size:85%;"><b>Working as Onsite coordinator at client side in Chicago US. Coordinating with client on user requirements and responsible for all the deliveries from offshore.</b></span></li><li><span style="font-size:85%;">Involved in development of reports.</span></li><li><span style="font-size:85%;">Supporting the existing reports and working on amendments to reports post production of release 1.</span></li></ul> </td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Environment</b></span></td> <td><span style="font-size:85%;">Cognos 8</span></td></tr> </tbody></table> </div> <span style="font-size:85%;"><br /><br /><br /><br /><br /><a name="0.1_table04"></a></span> <div align="left"> <table style="width: 368px; height: 234px;" border="2" cellspacing="0"> <tbody><tr valign="top"><td><span style="font-size:85%;"><b>Project Name:</b></span></td> <td><span style="font-size:85%;"><b>Global Service Desk – PLADA Integration (Cognos 8 Reporting)</b></span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Duration:</b></span></td> <td><span style="font-size:85%;">Jan 2006 – July 2006</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Organization:</b></span></td> <td><span style="font-size:85%;">HSBC GLT Pune</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Client:</b></span></td> <td><span style="font-size:85%;">HSBC USA</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Summary:</b></span></td> <td><span style="font-size:85%;">PLADA stands for Performance Level Agreement Database Application. PLADA is tool to document service level agreement between IT Service and business.</span></td></tr> <tr valign="top"><td height="62"><span style="font-size:85%;"><b>Role:</b></span></td> <td><ul type="disc"><li><span style="font-size:85%;">Started analysis of PLADA OLTP system (Oracle). Based on reporting requirements I will be designing data warehouse.</span></li></ul> </td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Environment</b></span></td> <td><span style="font-size:85%;">Cognos 8</span></td></tr> </tbody></table> </div> <span style="font-size:85%;"><br /><br /><br /><br /><br /><a name="0.1_table05"></a></span> <div align="left"> <table style="width: 383px; height: 504px;" border="2" cellspacing="0"> <tbody><tr valign="top"><td><span style="font-size:85%;"><b>Project Name:</b></span></td> <td><span style="font-size:85%;"><b>Global Service Desk (Customization of CA Unicenter Service desk as per HSBC Global requirement)</b></span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Duration:</b></span></td> <td><span style="font-size:85%;">Jun 2005 – Dec 2005</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Organization:</b></span></td> <td><span style="font-size:85%;">HSBC GLT Pune</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Client:</b></span></td> <td><span style="font-size:85%;">HSBC USA</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Summary:</b></span></td> <td><span style="font-size:85%;">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.</span></td></tr> <tr valign="top"><td height="62"><span style="font-size:85%;"><b>Role:</b></span></td> <td><span style="font-size:85%;">Software Developer – Team Member</span> <ul type="disc"><li><span style="font-size:85%;">Understanding of design and architectural documents.</span></li><li><span style="font-size:85%;">Involved in preparation of Page Specification and Functional Specification Document.</span></li><li><span style="font-size:85%;">Involved in preparing Prototype.</span></li><li><span style="font-size:85%;">Involved in preparation of Unit Test Cases</span></li><li><span style="font-size:85%;">Involved in coding and peer review.</span></li><li><span style="font-size:85%;"><b>Worked for 18 months as Onsite coordinator at client side in Chicago US. Coordinating with different offshore teams i.e. Development Team, Cognos Reporting Team, Testing Team and Technical Writing Team.</b></span></li><li><span style="font-size:85%;">Involved in promoting the package from development to UAT and then from UAT to Production environment.</span></li><li><span style="font-size:85%;">Involved in Requirement discussion for Reports (Using Cognos).</span></li><li><span style="font-size:85%;">Involved in development of reports.</span></li></ul> </td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Environment</b></span></td> <td><span style="font-size:85%;">Unix, Oracle, HTMPL and spell code (propriety CA’s Language.) </span></td></tr> </tbody></table> </div> <span style="font-size:85%;"><br /><br /><br /><a name="0.1_table06"></a></span> <div align="left"> <table style="width: 368px; height: 560px;" border="2" cellspacing="0"> <tbody><tr valign="top"><td><span style="font-size:85%;"><b>Project Name:</b></span></td> <td><span style="font-size:85%;"><b>HSBCnet eSecurities </b></span> </td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Duration:</b></span></td> <td><span style="font-size:85%;">Jan 2005 – Jun 2005 Worked on four releases i.e. Release 8, Release FT2, Release 9 and Release 10. </span> </td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Organization:</b></span></td> <td><span style="font-size:85%;">HSBC GLT Pune</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Client:</b></span></td> <td><span style="font-size:85%;">HSBC Vancouver Canada</span></td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Summary:</b></span></td> <td><span style="font-size:85%;">HSBCnet is the service provided by HSBC to its corporate clients. </span> <p><span style="font-size:85%;">HSBC eSecurities plays the role of custodian. HSBC Securities Services (HSS) provides comprehensive global, regional and domestic securities services to corporate and institutional clients.</span></p> <p align="justify"><span style="font-size:85%;">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</span></p></td></tr> <tr valign="top"><td height="62"><span style="font-size:85%;"><b>Role:</b></span></td> <td><span style="font-size:85%;">Software Developer – Team Member</span> <ul type="disc"><li><span style="font-size:85%;">Preparation and Understanding of design document i.e. Use Cases, EDR, and IDR.</span></li><li><span style="font-size:85%;">Involved actively in writing Unit test cases and E2E test cases uploading them to Quality Center and also involved in manual execution of test cases.</span></li><li><span style="font-size:85%;">Involved actively in XML, XSLT and Java Coding.</span></li><li><span style="font-size:85%;">Involved in peer-peer testing phase.</span></li><li><span style="font-size:85%;"><b>Worked as Onsite Coordinator for four months at client side in CANADA.</b></span></li></ul> </td></tr> <tr valign="top"><td><span style="font-size:85%;"><b>Environment</b></span></td> <td><span style="font-size:85%;">XSLT, Servlets Using UIMS AND EBSA Framework</span> <p align="justify"><span style="font-size:85%;">Web Server/Application Server: WepSphere 5.0</span></p> <p align="justify"><span style="font-size:85%;">IDE: WSAD 5.1.2</span></p> </td></tr> </tbody></table> </div> <h1><span style="font-size:85%;">EDUCATION</span></h1> <span style="font-size:85%;"><br /><a name="0.1_table07"></a></span> <div align="left"> <table style="width: 367px; height: 24px;" border="2" cellspacing="0"> <tbody><tr valign="top"><td><span style="font-size:85%;">July 2004</span></td> <td><span style="font-size:85%;">Bachelor of Engineering (Information Technology), RGPV University, Bhopal</span></td></tr></tbody></table></div></div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-6996002905648148012009-07-01T09:29:00.001-07:002009-07-01T09:29:49.908-07:00Remote Cognos Development OpportunityDoes your organization require temporary support doing Cognos development? If so, then the BI Centre can give you that short term, or long term, support to help you meet your deliverable.<br /><br />We can assist with model development, report development, SDK coding, testing, QA, technical documentation and even project management.<br /><br />Feel free to contact us today to discuss your needs.<br /><br />email: businessintelligencecentre@gmail.comUnknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-15028101472648992502009-01-25T07:27:00.000-08:002009-01-25T07:32:34.341-08:003+ years Cognos Developer -- 20090125-001<b><span style="font-size: 9pt;"></span></b><b><span style="font-size: 9pt;"> </span></b><span style="font-size: 9pt;"><span style="font-size:130%;"><a style="font-weight: bold;" href="mailto:busienssintelligencecentre@gmail.com?subject=20090125-001">Email us today if you're interested in this resource. </a><span style="font-weight: bold;"> </span></span> <wbr> <wbr> </span> <p style="text-align: justify; line-height: 13pt;"><b><u><span style="font-size: 9pt;">Professional Summary </span></u></b></p> <ul type="disc"><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">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 </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Extensive experience in Cognos Report Net 1.1,Cognos Impromptu </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Having knowledge in Cognos 8, Cognos Power Play and Framework manager </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Developed different types of reports using Report studio, Query studio and Cognos Impromptu </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Excellent knowledge in Data warehousing concepts </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Can play a vital role in the team and able to absorb technical knowledge quickly </span></li></ul> <p style="text-align: justify; line-height: 13pt;"><b><u><span style="font-size: 9pt;">Employment History </span></u></b></p> <ul type="disc"><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Working as a Cognos Consultant for <b>Satyam Computers, hyd</b>,<b> </b>since july2007 to Till Date. <wbr> </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Worked as a Software Engineer for<b> FCG SOFTWARE, Bangalore </b>from Sep 2005 – July 2007.</span></li></ul> <p style="text-align: justify; line-height: 13pt;"><b><u><span style="font-size: 9pt;">Technical Skills </span></u></b></p> <p style="text-align: justify;"><b><u><span style="font-size: 9pt;"><span style="text-decoration: none;"> </span></span></u></b><span style="font-size: 9pt;"> </span><span style="font-size: 9pt;"> <b> OLAP Tools : Cognos Report Net 1.1, EP 7 Series and Cognos8</b></span></p> <p style="text-align: justify;"><b><span style="font-size: 9pt;"> ETL Tools : Informatica 7.1.1</span></b></p> <h4 style="text-align: justify; line-height: normal;"><span style="font-size: 9pt;"> Databases : Oracle 9i</span></h4> <h3 style="text-align: justify;"><span style="font-size: 9pt;"> Operating Systems : Windows 2000/XP</span></h3> <p style="text-align: justify;"><b><span style="font-size: 9pt;"> Languages : C, C++ and SQL </span></b></p> <p style="background: rgb(230, 230, 230) none repeat scroll 0% 0%; text-align: justify; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><span style="font-size: 9pt; letter-spacing: 3pt;">project profile</span></p> <h4 style="text-align: justify; line-height: 13pt;"><u><span style="font-size: 9pt; color: black;"><span style="text-decoration: none;"> </span></span></u><span style="font-size: 9pt;"> <b>Project #1</b></span></h4> <p style="margin-right: 9pt; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> </span></b></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> Title </span></b><b><span style="font-size: 9pt;">: Sales Information System (Aug 2007 to Till Date)</span></b></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> Client : San Miguel Corporation (SMC)</span></b></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> Environment : </span></b><b><span style="font-size: 9pt;">Reportnet1.1, Oracle 9i</span></b></p> <p style="margin-right: 9pt; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> Role : Report Developer</span></b><b><span style="font-size: 9pt;"></span></b></p> <p style="margin-right: 9pt; text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;"> <wbr> </span></p> <p style="margin-right: 9pt; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;">Description: </span></b></p><span style="font-size: 9pt;"> 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. Data </span> <p style="margin-right: 9pt; text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">From Operational Source System was extracted, transformed and loaded into data warehouse <br /></span><b><span style="font-size: 9pt;"></span></b></p><p style="margin-right: 9pt; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;">Responsibilities:</span></b></p> <ul type="disc"><li style="text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> </span></b><span style="font-size: 9pt;">Developed Master detail, drill through and rank reports by using report studio. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Created Daily backups by using Cognos Connection </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Reviewed the reports developed by other team members. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Created HTML Items , packages , templates and reusable components </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Developed Complex reports by using Conditional formatting and Conditional blocking </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Interact with client on a daily basis and Detailed Requirements Study </span></li></ul> <p style="text-align: justify;"><b><span style="font-size: 9pt;">Project #2:</span></b></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify;"><b><span style="font-size: 9pt;"> Title : 7Eleven Sales analysis (May 2006 to July 2007)</span></b><span style="font-size: 9pt;"></span></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify;"><span style="font-size: 9pt;"> <b>Client : 7Eleven, Malaysia</b> </span></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify;"><span style="font-size: 9pt;"> <b>Environment : Cognos impromptu, power play</b></span></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify;"><b><span style="font-size: 9pt;"> Role : Report Developer</span></b></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify;"><span style="font-size: 9pt;"> </span><span style="font-size: 9pt; line-height: 150%;">Description:</span></p> <p style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">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. </span></p> <p style="text-align: justify;"><b><span style="font-size: 9pt;">Role& Responsibilities:</span></b><span style="font-size: 9pt;"> </span></p> <ul type="disc"><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">List Reports, Cross-tab Reports and Drill-through Reports. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Created reports using cascading prompts. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Created various types of reports Developed for various user levels. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Queried from different database tables as per the requirement. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Scheduling the reports. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Created and enhanced existing Power Cube as per user requirements. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Imported IQD files created in impromptu into transformer to construct a power cube Involved in optimizing Power Cubes. </span></li></ul> <p style="text-align: justify;"><b><span style="font-size: 9pt;">Project #3</span></b></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> Title : Extra Mile Sales analysis (Sep 2005 to Apr 2006)</span></b></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;"> <b>Client : Extra Mile, USA</b></span></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> Environment : Cognos impromptu and Oracle 9i</span></b><span style="font-size: 9pt;"></span></p> <p style="margin-right: 0in; margin-bottom: 2pt; margin-left: 0in; text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;"> Role : Report Developer </span></b><span style="font-size: 9pt;"></span></p> <p style="text-align: justify;"><b><span style="font-size: 9pt;"><br /></span></b></p> <p style="text-align: justify;"><b><span style="font-size: 9pt;">Description:</span></b><span style="font-size: 9pt;"></span></p> <p style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">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. </span></p> <p style="text-align: justify; line-height: 13pt;"><b><span style="font-size: 9pt;">Role & Responsibilities:</span></b><span style="font-size: 9pt;"> </span></p> <ul type="disc"><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Have done modifications to the catalogs </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Created Catalog prompts, Conditions and Calculations. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Created cross tab report, mailing labels reports by using cognos impromptu. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Created Snapshot, Hot file, Thumbnail reports. </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Worked on giving privileges to the User profiles like Governor settings, Table access, Folder access </span></li><li style="text-align: justify; line-height: 13pt;"><span style="font-size: 9pt;">Scheduled various reports </span></li></ul> <p style="text-align: justify; line-height: 13pt;"><b><u><span style="font-size: 9pt;">Educational Qualifications:</span></u></b></p> <p style="margin-left: 0.5in; text-align: justify; text-indent: -0.25in; line-height: 13pt;"><b><u><span style="font-size: 9pt;"><span style="text-decoration: none;"> </span></span></u></b><span style="font-size: 9pt; font-family: Symbol;"><span>·<span style="font-family: "Times New Roman"; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> </span></span></span><b><span style="font-size: 9pt;">BS.C(COMPUTERS)FROM S.K.UNIVERSITY.ATP</span></b></p>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-51704820432371754682008-08-19T15:04:00.000-07:002008-08-19T15:07:11.415-07:00Cognos Developer -- 20080819-0001<div style="margin: 1ex;"><div><a href="mailto:businessintelligencecentre@gmail.com?subject=20080819-0001">Email us today if you're interested in this resource.</a><span style="font-family:Verdana;font-size:100%;"><a href="mailto:businessintelligencecentre@gmail.com?subject=20080819-0001"><b><wbr> </b> </a><br /></span><p align="justify"><span style="font-family:Verdana;font-size:100%;"><b>OBJECTIVE <wbr> <wbr> <wbr> <wbr> </b></span></p> <a name="0.1_table01"></a> <div align="left"> <ul><ul><table border="2" cellspacing="0" width="0"> <tbody><tr valign="top"><td height="22" width="100%"> <span style="font-family:Verdana;font-size:85%;"> I am looking for a challenging position in the IT industry, which shall provide me with opportunities to explore my potential. </span></td></tr> </tbody></table></ul></ul> </div> <br /><p align="justify"><span style="font-family:Verdana;font-size:100%;"><b>educational qualifications </b></span><br /></p> <a name="0.1_table02"></a> <div align="left"> <table border="2" cellspacing="0" width="0"> <tbody><tr valign="top"><td height="31" width="26%"> <span style="font-family:Verdana;font-size:100%;"><b>EXAMINATION</b></span></td> <td width="22%"><span style="font-family:Verdana;font-size:100%;"><b>BOARD</b></span></td> <td width="25%"><span style="font-family:Verdana;font-size:100%;"><b>INSTITUTION</b></span></td> <td width="25%"><br /><span style="font-family:Verdana;font-size:100%;"><b>AGGREGATE</b></span></td></tr> <tr valign="top"><td height="38"><br /><span style="font-family:Verdana;font-size:100%;"><b>BE,</b> Computer Science And Engineering</span> </td> <td><span style="font-family:Verdana;font-size:100%;">Visveswaraih Technological</span> <p align="justify"><span style="font-family:Verdana;font-size:100%;">University</span></p></td> <td><span style="font-family:Verdana;font-size:100%;">Kalpataru Instituteof <wbr> Technology,Tiptur</span></td> <td><br /><span style="font-family:Verdana;font-size:100%;"><b>65.10%</b></span> </td></tr> <tr valign="top"><td height="37"><br /><span style="font-family:Verdana;font-size:100%;"><b>II PUC</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">Pre university Board, Karnataka</span> </td> <td><span style="font-family:Verdana;font-size:100%;">VVNL PU college</span> <p align="justify"><span style="font-family:Verdana;font-size:100%;">Jogfalls </span></p> <p align="justify"><span style="font-family:Verdana;font-size:100%;">Shivamogga(dist)</span></p></td> <td><br /><span style="font-family:Verdana;font-size:100%;"><b>62.16%</b></span> </td></tr> <tr valign="top"><td height="39"><span style="font-family:Verdana;font-size:100%;"><b>SSLC </b></span> </td> <td><span style="font-family:Verdana;font-size:100%;">State Board, Karnataka</span></td> <td><span style="font-family:Verdana;font-size:100%;">Government High School </span> <p align="justify"><span style="font-family:Verdana;font-size:100%;">Kargal</span></p> <p align="justify"><span style="font-family:Verdana;font-size:100%;">Shivamogga(dist)</span></p></td> <td><br /><span style="font-family:Verdana;font-size:100%;"><b>82.32%</b></span></td></tr> </tbody></table> </div> <br /><p align="justify"><a name="0.1_graphic03"></a></p> <p align="justify"><a name="0.1_graphic04"></a></p> <h4 align="center"><span style="font-family:Arial;font-size:85%;">Completed </span><span style="font-family:Arial;font-size:100%;"><b>Bachelor of Engineering in <i>Computer science and Engineering</i></b></span><span style="font-family:Arial;font-size:85%;"> in the year <b>2007</b></span></h4> <br /><p align="justify"><span style="font-family:Verdana;font-size:100%;"><b>SKILL PROFILE </b></span></p> <a name="0.1_table03"></a> <div align="left"> <table border="2" cellspacing="0" width="0"> <tbody><tr valign="top"><td height="13" width="24%"> <span style="font-family:Verdana;font-size:100%;"><b>Primary Skills : </b></span></td> <td width="75%"><span style="font-family:Verdana;font-size:100%;"> C, Java, SQL, Data modeling, Data warehousing and BI concepts.. </span></td></tr> <tr valign="top"><td height="3"><span style="font-family:Verdana;font-size:100%;"><b>Platform:</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">Windows 98, Windows XP, Linux</span></td></tr> <tr valign="top"><td height="3"><span style="font-family:Verdana;font-size:100%;"><b>ETL Tool:</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">Microsoft SSIS</span> </td></tr> <tr valign="top"><td height="3"><br /><span style="font-family:Verdana;font-size:100%;"><b>OLAP Tool:</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">COGNOS 8: Query Studio, Report Studio. Framework Manager</span> </td></tr> </tbody></table> </div> <p align="justify"><span style="font-family:Verdana;font-size:100%;"><b>Experience SUMMARY</b></span><br /></p> <ul><ul type="disc"><li><span style="font-family:Verdana;font-size:85%;">1.8 years of experience as a DWH and BI developer at Aviana nrit,Bengaluru.</span></li><li><span style="font-family:Verdana;font-size:85%;">Expertise, knowledge and hands on experience with MS SSIS 2005</span></li><li><span style="font-family:Verdana;font-size:85%;">Extensive experience in Extraction, Transformation, Loading (ETL) data from various Sources into Data Warehouses and Data Marts.</span></li><li><span style="font-family:Verdana;font-size:85%;">Exposure to COGNOS 8(Query Studio, Report Studio, Framework Manager)</span></li><li><span style="font-family:Verdana;font-size:85%;">Zeal and ability to learn new concepts, new tools.</span></li><li><span style="font-family:Verdana;font-size:85%;">Sincere and hard working.</span></li></ul></ul> <br /><br /><p align="justify"><span style="font-family:Verdana;font-size:100%;"><b>PROJECTS:</b></span></p> <p align="justify"><span style="font-family:Verdana;font-size:100%;"><b> 1.Project Details</b></span></p> <a name="0.1_table04"></a> <div align="left"> <ul><table width="0"> <tbody><tr valign="top"><td bg height="16" width="19%" style="color:#f2f2f2;"> <span style="font-family:Verdana;font-size:100%;"> </span></td> <td bg width="80%" style="color:#f2f2f2;"><span style="font-family:Verdana;font-size:100%;"><b>Insurance BI System</b></span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Client</b></span></td> <td><span style="font-family:Verdana;font-size:100%;"><b>ING Vysya</b></span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Role</b></span></td> <td><span style="font-family:Verdana;font-size:100%;"> DWH and BI Developer</span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Organization</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">Aviana Nrit limited, Bangalore</span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Environment</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005, </span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Duration</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">Feb 2007 – Jun 2007</span></td></tr> </tbody></table></ul> </div> <h5 align="justify"><span style="font-family:Verdana;font-size:100%;"><b>Description</b></span></h5> <br /><p><span style="font-family:Verdana;font-size:85%;">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.</span><br /></p> <p align="justify"><span style="font-family:Verdana;font-size:100%;"><b>Responsibilities: </b></span><br /></p> <ul type="disc"><li><span style="font-family:Verdana;font-size:85%;">Understanding the Business Requirement and Design as per it.</span></li><li><span style="font-family:Verdana;font-size:85%;">Developed a solution to the need by gathering and analyzing client data. </span></li><li><span style="font-family:Verdana;font-size:85%;">Generated I.Q.D files from Impromptu as a source for power play cubes</span></li><li><span style="font-family:Verdana;font-size:85%;">Performed calculations and conditions in Impromptu reports</span></li><li><span style="font-family:Verdana;font-size:85%;">Knowledge in making the model plans in Power Play Transformer to Generate Power Cubes</span></li><li><span style="font-family:Verdana;font-size:85%;">Standard Reports like Simple to Cross-tab to Group Cross-tab are generated using Impromptu. </span></li><li><span style="font-family:Verdana;font-size:85%;">Multi Dimensional Drill Up / Drill Down Analysis Reports are developed using Power Play </span></li><li><span style="font-family:Verdana;font-size:85%;">Created Levels with in Dimensions for better Analysis using Power play Transformer. </span></li></ul> <p><span style="font-family:Verdana;font-size:85%;">COGNOS Power Play has been used to analyze and present the Cube data in the form of multi-dimensional Reports & Charts</span><span style="font-family:Arial;font-size:85%;">.</span></p> <p><span style="font-family:Verdana;font-size:100%;"><b>Team Size: 5</b></span><br /><br /><br /></p> <p><span style="font-family:Verdana;font-size:100%;"><b> 2. Project Details</b></span><br /></p> <a name="0.1_table05"></a> <div align="left"> <ul><table width="0"> <tbody><tr valign="top"><td bg height="16" width="19%" style="color:#f2f2f2;"> <span style="font-family:Verdana;font-size:100%;"> </span></td> <td bg width="80%" style="color:#f2f2f2;"><span style="font-family:Verdana;font-size:100%;"><b>General Sales Data Mart</b></span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Client</b></span></td> <td><span style="font-family:Verdana;font-size:100%;"><b>BAJAJ AUTOMOBILE</b></span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Role</b></span></td> <td><span style="font-family:Verdana;font-size:100%;"> DWH and BI Developer</span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Organization</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">Aviana Nrit limited, Bangalore</span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Environment</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005, </span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:100%;"><b>Duration</b></span></td> <td><span style="font-family:Verdana;font-size:100%;">JUL 2007 – DEC 2007</span></td></tr> </tbody></table></ul> </div> <br /><ul><p><span style="font-family:Verdana;font-size:100%;"><b>Description:</b></span></p></ul> <ul><p><span style="font-family:Verdana;font-size:85%;">The project is involved in Analyze, design and development of Bajaj<b> </b> 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.</span></p></ul> <ul><p><span style="font-family:Verdana;font-size:100%;"><b>Responsibilities:</b></span><br /></p></ul> <ul><ul type="disc"><li><span style="font-family:Verdana;font-size:85%;">Understanding the Requirement Specifications & Business Logic.</span></li><li><span style="font-family:Verdana;font-size:85%;">Developed solutions to meet business needs by gathering and analyzing client resource.</span></li><li><span style="font-family:Verdana;font-size:85%;">Developed various Mappings, Transformations for migration of data using SSIS 2005.</span></li><li><span style="font-family:Verdana;font-size:85%;">Used various transformations in SSIS 2005.</span></li><li><span style="font-family:Verdana;font-size:85%;">Done data aggregation while transformation.</span></li><li><span style="font-family:Verdana;font-size:85%;">Extraction of data from the enterprise data warehouse for analytical and multi-dimensional reporting system for specific Corporate Business Unit </span></li><li><span style="font-family:Verdana;font-size:85%;">Developed simple as well as complex reports using Reporting studio.</span></li><li><span style="font-family:Verdana;font-size:85%;">Developed List, Cross tab, Drill through, Master-detail and chart which involved Multiple Prompts, Filters, and Multi-page.</span></li></ul></ul> <p> <span style="font-family:Verdana;font-size:100%;"><b>Team Size</b>: 5</span><br /><br /><br /></p> <p><span style="font-family:Verdana;font-size:100%;"><br /></span></p> <ol start="3" type="1"><li><span style="font-family:Verdana;font-size:100%;"><b>Project details:</b></span></li></ol> <br /><a name="0.1_table06"></a> <div align="left"> <ul><table width="0"> <tbody><tr valign="top"><td bg height="16" width="19%" style="color:#f2f2f2;"> <span style="font-family:Verdana;font-size:85%;"> </span></td> <td bg width="80%" style="color:#f2f2f2;"><span style="font-family:Verdana;font-size:85%;"><b>General Sales Data Mart</b></span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:85%;"><b>Client</b></span></td> <td><span style="font-family:Verdana;font-size:85%;"><b>Prism Cements</b> </span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:85%;"><b>Role</b></span></td> <td><span style="font-family:Verdana;font-size:85%;"> DWH and BI Developer</span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:85%;"><b>Organization</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">Aviana Nrit limited, Bangalore</span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:85%;"><b>Environment</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">Windows 2000, Cognos 8 BI, SSIS, MS SQL Server 2005, </span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:85%;"><b>Duration</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">JAN 2008 – till date.</span></td></tr> </tbody></table></ul> </div> <br /><p> <span style="font-family:Verdana;font-size:100%;"><b>Description:</b></span></p> <ul><p> <span style="font-family:Verdana;font-size:85%;">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. </span><br /></p></ul> <ul><p><span style="font-family:Verdana;font-size:100%;"><b>Responsibilities:</b></span></p></ul> <ul><ul type="disc"><li><span style="font-family:Verdana;font-size:85%;">Understanding the Requirement Specifications & Business Logic.</span></li><li><span style="font-family:Verdana;font-size:85%;">Developed solutions to meet business needs by gathering and analyzing client resource.</span></li><li><span style="font-family:Verdana;font-size:85%;">Developed various Mappings, Transformations for migration of data using MS SSIS 2005.</span></li><li><span style="font-family:Verdana;font-size:85%;">Used various transformations in SSIS 2005.</span></li><li><span style="font-family:Verdana;font-size:85%;">Done data cleansing and aggregation while transformation.</span></li><li><span style="font-family:Verdana;font-size:85%;">Extraction of data from the enterprise data warehouse for analytical and multi-dimensional reporting system for specific Corporate Business Unit </span></li><li><span style="font-family:Verdana;font-size:85%;">Developed simple as well as complex reports using Reporting studio.</span></li><li><span style="font-family:Verdana;font-size:85%;">Developed List, Cross tab, Drill through, Master-detail and chart which involved Multiple Prompts, Filters, and Multi-page.</span></li></ul></ul> <p><span style="font-family:Verdana;font-size:100%;"><b>Team Size</b>: 5<br /></span></p> <p align="justify"><span style="font-family:Verdana;font-size:100%;"><b>PERSONAL PROFILE </b></span></p> <a name="0.1_table07"></a> <div align="left"> <ul><ul><table border="2" cellspacing="0" width="0"> <tbody><tr valign="top"><td height="21" width="24%"> <span style="font-family:Verdana;font-size:85%;"><b>Name:</b></span></td> <td width="75%"><span style="font-family:Verdana;font-size:85%;">Naganayan D S</span></td></tr> <tr valign="top"><td height="18"><span style="font-family:Verdana;font-size:85%;"><b>Father’s Name:</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">Dr D K S Aradhya</span></td></tr> <tr valign="top"><td height="15"><span style="font-family:Verdana;font-size:85%;"><b>Date Of Birth:</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">03/10/1983</span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:85%;"><b>Current ctc</b> </span> </td> <td><span style="font-family:Verdana;font-size:85%;">1.44 lakhs/annum</span></td></tr> <tr valign="top"><td height="17"><span style="font-family:Verdana;font-size:85%;"><b>Expected ctc</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">2.70 lakhs/annum</span></td></tr> <tr valign="top"><td height="16"><span style="font-family:Verdana;font-size:85%;"><b>Languages:</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">English, Kannada, Hindi.</span></td></tr> <tr valign="top"><td height="19"><span style="font-family:Verdana;font-size:85%;"><b>Hobbies:</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">Reading novels, Playing Cricket, watching tech shows</span></td></tr> <tr valign="top"><td height="19"><span style="font-family:Verdana;font-size:85%;"><b>Notice Period:</b></span></td> <td><span style="font-family:Verdana;font-size:85%;">2 week</span></td></tr> </tbody></table></ul></ul> </div> </div> </div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-34486232130219161832008-08-01T15:32:00.001-07:002008-08-01T15:32:54.016-07:00New Cognos job!<a href="http://c8jobs.blogspot.com/2008/08/finance-systems-analyst-and-programmer.html">http://c8jobs.blogspot.com/2008/08/finance-systems-analyst-and-programmer.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-25765594958622822372008-06-19T18:37:00.000-07:002008-06-19T18:41:28.759-07:00Cognos ETL Specialist 20080619-0001<div style="margin: 1ex;"> <div><a href="mailto:businessintelligencecentre@gmail.com?subject=20080619-0001">Email us today if you're interested in contacting this resource</a><br /><br />C<span style=";font-family:Times New Roman;font-size:100%;" >urrent Location : In Singapore, On Social Visit Pass </span><br /><p><span style=";font-family:Times New Roman;font-size:100%;" ><b>EDUCATIONAL QUALIFICATION</b></span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Bachelor’s Degree in Mechanical Engineering 2005</b></span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >SK University, Kurnool, India</span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >TECHNICAL SKILLS</span><br /></p> <ul><ul><ul><ul><p><span style=";font-family:Times New Roman;font-size:100%;" >ETL Tools : Cognos8, Business Objects, DataStage 7.5.2 Enterprise Edition, DataStage 7.5 Server Edition</span></p></ul></ul></ul></ul> <ul><ul><ul><ul><p><span style=";font-family:Times New Roman;font-size:100%;" >Reporting Tools : Cognos, Business Objects</span></p></ul></ul></ul></ul> <p><span style=";font-family:Times New Roman;font-size:100%;" >Languages : C, C++, SQL, PL/SQL </span></p> <h2 align="justify"><span style=";font-family:Times New Roman;font-size:100%;" >Operating Systems : Win 95/98/NT/2000/XP, Unix </span></h2> <p><span style=";font-family:Times New Roman;font-size:100%;" >Databases : Oracle 8.i/9.i</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Other Tools : TOAD</span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >CERTIFICATIONS</span><br /></p> <ul type="disc"><li><span style=";font-family:Times New Roman;font-size:100%;" >Quality Management Systems(QMS) Satyam Computer Services Pte Ltd, India</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >SQL – OCA Oracle, India</span></li></ul><br /><p><span style=";font-family:Times New Roman;font-size:100%;" >TRAININGS</span><br /></p> <ul type="disc"><li><span style=";font-family:Times New Roman;font-size:100%;" >Oracle, Unix Training at Satyam Computer Services.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >DataStage Training at IBM in April ‘07.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Cognos and Business Objects Training at Satyam Computer Services in Feb’08</span></li></ul><br /><br /><br /><p><span style=";font-family:Times New Roman;font-size:100%;" ><b>CAREER SUMMARY</b></span><br /></p> <ul type="disc"><li><span style=";font-family:Times New Roman;font-size:100%;" >More than 2 yrs. of experience in Data Stage - ETL Developer and Cognos.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Involved in Functional and Technical Systems Analysis & Design, Systems, Star Schema, Snowflake, changing dimension and Documentation.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >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.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Implementation of ETL (Extraction, Transformation and Loading) methodology using DataStage.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Integration of various Data Sources like Oracle and Flat files into the Staging Area.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Good knowledge in Database Concepts.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Strong knowledge in Data warehousing concepts and hands on experience in Data Stage and Cognos.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Have Good Programming knowledge in SQL, PL/SQL.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Strong Understanding of Software Lifecycle Methodology. </span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Experience in functional analysis, establishing business rules and process flows.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Excellent User interaction skills.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Having Good Communication Skills, Can learn new Technologies and Tools quickly. </span></li></ul><br /><br /><p><span style=";font-family:Times New Roman;font-size:100%;" ><b>EXPERIENCE</b></span></p> <h6><span style=";font-family:Times New Roman;font-size:100%;" ><b>Mar 06 – Till Date Satyam Computer Services, Hyderabad, India</b></span></h6> <p> <span style=";font-family:Times New Roman;font-size:100%;" >Software Engineer</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Oct 07 – Apr 08</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Project 3 GNE </b> (Gulf & Near East) – Secondary Sales Reporting System</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Client GSK (Glaxo Smithkline), UK</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Team Size 6</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Environment Cognos 8, DataStage 7.5.1, Oracle 10g, TOAD, UNIX </span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Project Description</b></span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >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.</span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Responsibilities</b></span><br /></p> <ul type="disc"><li><span style=";font-family:Times New Roman;font-size:100%;" >Designed and Created Reports in Cognos.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Authored Report Specifications.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Documented Package Configuration and System test case.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Involved in Unit Testing and System Testing</span></li></ul> <p><span style=";font-family:Times New Roman;font-size:100%;" >Jun 06 – Sep 07</span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Project 2 DRSF </b>(Data Reporting System Foundation)</span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Client GSK (Glaxo Smithkline), Ware, UK</span></p> <ul><ul><ul><ul><p><span style=";font-family:Times New Roman;font-size:100%;" >Team Size 30</span></p></ul></ul></ul></ul> <ul><ul><ul><ul><p><span style=";font-family:Times New Roman;font-size:100%;" >Environment DataStage 7.5 Enterprise Edition (Px), Oracle 10g, TOAD, UNIX </span><br /></p></ul></ul></ul></ul> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Project Description</b></span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >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.</span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Responsibilities</b></span><br /></p> <ul type="disc"><li><span style=";font-family:Times New Roman;font-size:100%;" >Analysis of the specifications provided by the client.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Developed parallel jobs for extracting, Transforming and loading the required data into Foundation Layer.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >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.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Developed jobs in the Local containers.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Designed and developed job sequences for parallel jobs according to the requirement. </span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Used DataStage director to validate, to test and to monitor the resulting executable jobs.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Interaction with the onsite team.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Involved in unit testing by authoring and executing the unit test cases</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Adhered to Quality procedures related to the project.</span></li></ul><br /><br /><p><span style=";font-family:Times New Roman;font-size:100%;" >Jul 06 – Oct 06</span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Project 1</b> <b>PMAR </b> (Profit Management Analysis & Reporting)</span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Client GSK (Glaxo Smithkline), UK</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Team Size 16</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >Environment DataStage 7.5.1, Cognos, Oracle 9i, TOAD, UNIX </span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Project Description</b></span><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" >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).</span></p> <p><span style=";font-family:Times New Roman;font-size:100%;" > </span><br /><br /><br /></p> <p><span style=";font-family:Times New Roman;font-size:100%;" ><b>Responsibilities</b></span><br /></p> <ul type="disc"><li><span style=";font-family:Times New Roman;font-size:100%;" >Preparing Unit Test Case Documents for Data Stage jobs.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Preparing System Test Case Documents for Data Stage jobs.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Reviewing SQL Queries using TOAD.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Unit Testing for Data stage jobs.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >System Testing for Data Stage jobs.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Created Simple jobs in Ascential Data Stage.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Prepared documents for the UAT.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Checked the Data Integrity in both JDE and Data Stage.</span></li><li><span style=";font-family:Times New Roman;font-size:100%;" >Created Deployment Document for production support.</span></li></ul><br /><br /><p align="justify"><span style=";font-family:Times New Roman;font-size:100%;" ><b>COMPENSATION DETAILS</b></span><br /></p> <ul type="disc"><li><span style=";font-family:Times New Roman;font-size:100%;" >Currently on 4 Lakhs Indian Rupees per annum, plus Medical for self and parents, plus annual Leave Travel Allowance, and 15 – 25% annual Appraisal.</span></li></ul><br /><br /><p align="justify"><span style=";font-family:Times New Roman;font-size:100%;" ><b>NOTICE PERIOD</b></span><br /></p> <ul type="disc"><li><span style=";font-family:Times New Roman;font-size:100%;" >Available Immediately</span></li></ul> </div> </div>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-57961132238027657362008-05-12T17:19:00.000-07:002008-05-12T17:20:09.347-07:00New C8 SDK Utility --- Cognos 8 Modification Check<a href="http://bicentresdkguide.blogspot.com/2008/05/new-c8-sdk-utility-cognos-8.html">http://bicentresdkguide.blogspot.com/2008/05/new-c8-sdk-utility-cognos-8.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-5923193471646248242008-05-10T07:42:00.000-07:002008-05-10T07:43:19.270-07:00Cognos Developer in New York<a href="http://c8jobs.blogspot.com/2008/05/cognos-developer-in-new-york.html">http://c8jobs.blogspot.com/2008/05/cognos-developer-in-new-york.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-82384377082092697352008-03-22T08:43:00.000-07:002008-03-22T08:51:47.850-07:00Cognos Data Warehouse 20080322-0001<a href="mailto:businessintelligencecentre@gmail.com?subject=20080322-0001">Email us today if you're interested in contacting this resource</a><br /><br />Objective <br /><br />To work in a challenging and progressive environment where, I can contribute for achievement of goals of the organization and my growth. <br /><br />Summary <br /><br />1 year of total experience in IT industry, with 1 years of experience in Data Warehousing using PL/SQL, tools like Cognos 7,Cognos 8,SAP BW. <br /><br />Work Experience<br /> <br /> o Working as Software Engineer in HCL Technologies Ltd, Chennai from Jan 2007 to till date<br /><br />Qualification <br />o Master of Computer Applications from Anna University with 78% in 2007.<br />o Bachlore of Computer Application From Bharathiyar University with 68% in 2004.<br />o Higher secondary from Immaculate with 61.5% in 2001<br />o 10th from Immaculate with 66% in 1999.<br /> <br /><br />Assets <br /><br />o Good communication skills.<br />o Excellent analyzing skills, good grasping capabilities and ability to learn new things.<br />o Self directed, self motivated and committed individual.<br /><br />Skillset <br /><br /> Reports : Cognos 8,Cognos 7 & SQL server 2005(SSRS) <br /><br /> Databases : Oracle9i/10g, SQL server 2005 <br /><br /> Languages : C,C++, SQL, PL/SQL, UNIX Shell Script <br /><br /> DB Related : TOAD 7.3, SQL Loader <br /><br /> Operating Systems : Windows NT/2000, UNIX & Linux. <br /><br /> <br /><br />Project Profile<br /><br />Project # 1 <br /><br />Title : CODMAN SALES REPORTING.<br /><br />Client : JOHNSON & JOHNSON, US<br /><br />Duration : Jan 2008 – Till date<br /><br />Team Size : 6<br /><br />Environment : Cognos 8.2,ORACLE 10g,Unix. <br /><br />Project Description: <br /><br /> JOHNSON & JOHNSON (J & J) was one of the leading pharmaceutical company. Codman is a group of this J &J company. This project was initially kicked off as a migration of reports from Cognos 7 series to Cognos 8. But the client needed few alterations in the reports. So the project then started as a development project. Reports were generated on varios categories like Sales vs Objective (SVO), Monthly and Daily basis, Business Reporting.<br /><br /> Specifications were given to the developers which had the report layout and query that generated the reports. These requirements were gathered by my onsite lead. <br /> <br /><br />Responsibilities carried out:<br /><br /> o Was involved in the model creation in Framework Manager.<br /> o Created relationships, cardinalities and calculations at the FWM level to satisfy the given query.<br /> o Developed complex reports which involved creation of many queries and joining them at the Report Studio level.<br /><br /> <br /><br />Project # 2 <br /><br />Title : DB- FSR Rollout.<br /><br />Client : Deutsche Bank, Singapore<br /><br />Duration : Jun 2007 – Jan 2008<br /><br />Team Size : 20<br /><br />Environment : Cognos 8.2/8.3, SAP BW. <br /><br />Project Description: <br /><br /> Deutsche Bank is one of the world's leading financial service providers. Rollout of FSR happened for Honk Kong, Korea, Indonesia and Singapore. It is an Onsite-Offshore model of development project we have developed around 550 reports using cognos Report studio and few query studio reports. Reports has been developed in the Dev environment and after the quality process reports has been moved to the QA and PROD successfully.<br /><br /> The functional design documents provided by the client, Deutsche Bank, were presented in Excel format. The same was then replicated in Report Studio. A concept called Cell Based reporting was followed in which a data item is assigned only one value at which it is placed. This is called RFP (Report Form Position). The value against the RFP is stored in the source database i.e. SAP BW. Cognos picks up the values against the RFP from BW and populates the values for that particular position. A share point was maintained from where the defects raised by the users were taken and then fixed based on the priority. Versioning of the reports were to be maintained to make sure that the last updated report was worked upon the defects. This last updated report was then used for migration to the corresponding environment. <br /><br />Responsibilities carried out:<br /><br /> o A total of 190 Indonesian reports were handled.<br /> o Tested, validated and migrated the reports to different environments during the implementation phase at onsite (Singapore).<br /> o Fixing the defects as per the priority and updating the same in the share point.<br /> o Change Request for all the regions were handled effectively.<br /><br /> <br /><br />Project # 3 <br /><br />Title : PnC DashBoard<br /><br />Client : HCL Technologies<br /><br />Duration : Apr’2007 – May’2007<br /><br />Team Size : 6<br /><br />Environment : Cognos 8.2,TOAD 7.3, Oracle 8.1.7 <br /><br />Project Description: <br /><br /> * Created Metadata models from the DWH ORACLE database schema.<br /> * Developed models using star schema grouping.<br /> * Created short-cuts to resolve some join issues.<br /> * Created folder structure and namespace to maintain Database view and presentation view.<br /> * Developed Report design specification for few reports.<br /> * Created list and cross-tab reports as per report design spec.<br /> * Created two dashboards based on the given reports as per requirements using ReportStudio.<br /><br /> <br /> <br /><br />Project # 4 <br /><br />Title : Hospital Management System<br /><br />Client : HCL Tecnologies.<br /><br />Duration : Jan 2007 – Apr 2007<br /><br />Team Size : 2<br /><br />Environment : SQL Server 2005(SSAS,SSRS), TOAD 7.3,Oracle 8.1.7 <br /><br />Project Description:<br /><br /> * We have moved the source data to staging area database using SQLSERVER scripts.<br /> * From staging area to DWH SQLSERVER database we used sort, merge, and join, aggregate transformations using SSIS.<br /> * We have designed the Metadata model using star schema using SSAS.<br /> * We rectified some join issues in the model.<br /> * Created four cubes using SSAS.<br /> * Created reports like list, cross-tab, charts using SSRS.<br /> * Used some of the features like Drill-through, KPI, drill-down and conditional-formatting using SSRS.<br /> * Created reports are scheduled as per the given frequency period.Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-5788581807775460602008-01-24T16:45:00.000-08:002008-01-24T16:46:32.241-08:00New Job Posted!<a href="http://c8jobs.blogspot.com/2008/01/reporting-developer-analyst-20080124.html">http://c8jobs.blogspot.com/2008/01/reporting-developer-analyst-20080124.html</a>Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-82011220097340136682008-01-24T05:23:00.000-08:002008-01-24T05:33:31.475-08:00Cognos 8 Migration Specialist 20080124-0001<a href="mailto:businessintelligencecentre@gmail.com?Subject=CV%2020080124-0001">Email us today if you're interested in contacting this resource.</a><br /><br />Primary Skills: Series 7 to Cognos 8 Migration Specialist<br /><br />Location: Waltham, Mass USA<br /><br />Years Experience: 12 years<br /><br />Introduction: I have been using the Cognos BI suite of products since 1998 and I have recently gained significant project experience using Cognos 8.2.<br /><br />Recent Projects:<br /><br />Project 1.<br />Worked as a primary consultant for a leading insurance specialist. My main task was to upgrade their 300 Impromptu reports and user interface into a Cognos 8.2 infrastructure. This involved establishing a migration plan, series of user acceptance unit testing, generating documenation, and providing general training on the usage of Cognos Connection, Report Studio, and Query Studio.<br /><br />Project 2.<br />Employed as a primary consultant the United States Department of Defense. I was directly involved with reviewing their Cognos Impromptu catalogue and 220 Impromptu reports before planning a migration strategy to Cognos 8. This involved interaction with their Business Analysts to review their current and near future reporting requirements.Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-50808387249057164532008-01-16T16:01:00.000-08:002008-01-16T16:21:46.663-08:00BI Consultant / Oracle DBA 20080116-0001<a href="mailto:businessintelligencecentre@gmail.com?Subject=CV%2020080116-0001">Email us today if you're interested in contacting this resource.</a><br /><br />Primary Skills: Oracle DBA/Datawarehouse, Cognos 8.1 MR1, Informatica ETL<br /><br />Location: San Francisco, California USA<br /><br />Years Experience: 8 years<br /><br />Introduction: My 8 years experience involves mainly working as an Oracle DBA that was responsible for working with a Fortune 500 Data Warehouse. I was involved with supporting the Warehouse design, generating Cognos reports and testing Cube development. I am looking for a position as a Senior Cognos Developer in the California area.<br /><br />Recent Projects:<br /><br />Project 1.<br />Responsible for Oracle 9i upgrade to 10g sizing around 300GB running on Solaris server for a Fortune 500 company.<br />• Database upgrade, and performance tuning<br />• Data Mart creation, data repository/metadata creation/management<br />• Database Backup/Recovery strategy/Planning<br />• Cognos 8 BI Server, Framework Manager installation and data modelling<br />• Reports design/development using Cognos Query Studio and Report Studio, add/manage/schedule tasks using Event Studio<br /><br />Project 2.<br />Responsible for administering multiple Oracle 9i production databases, which were around 5TB running on Compaq Alpha servers using Compaq TRU64 Unix. Managed 7 Oracle development instance on Compaq Tru64 Alpha servers and 2 Oracle 9i instances on Sun Solaris servers.<br />• Database Performance Tuning<br />• Datawarehouse management (i.e. data profiling, data quality metrics, cleansing, transformation, mapping and loading into multiple targets)<br />• ER Data Modelling using Erwin 4.x<br />• Cognos 8 Framework Manager, report development using Query Studio and Report Studio <br />• Cognos Event Studio <br />• Implemented Peoplsoft HRMS data mart to Warehouse<br />• Informatica Infrastructure, installations, patch application<br />• Team Lead support services for a project of 34 resources<br />• Applied database upgrades and patches on yearly maintenance cycle<br />• Installation of Dev, QA, and PROD database instances<br />• Database Backup/Recovery strategy/PlanningUnknownnoreply@blogger.comtag:blogger.com,1999:blog-5505772646539029205.post-5811978317802234672008-01-14T16:37:00.001-08:002008-01-14T16:41:14.035-08:00Cognos Consulting will post your CV for freeWelcome to our blog where we match Cognos consultants with potential employers. If you're an IT recruiter, corporate head hunter, or just a HR rep looking to fill a Cognos position within your organization then you have come to the right place to find your Cognos talent.<br /><br />We will post Cognos CVs free of charge so that you can find the skill set that you need to help make your project a success.Unknownnoreply@blogger.com