Cognos Lead position

Kiran .B. Suryanarayana

#****.** Cross ** Main Road,BSK – II Stage Bangalore, India - 560070

Phone: +91-80-267*****; Mobile: +91-988*******

Email Address : ************@*****.***

BI Technology & Software Solutions ~ Project Lead/Architect

Offering 13 Experience in Developing, Production support of Dataware Housing & BI Software Solutions /Client server Software Solutions & Web technologies covering various Domains which include Finance and Manufacturing

Job Objective

Results oriented in Techno-Lead professional offering diverse experience in different capacities primarily in the areas of BI/DWH Development/Support,Application Development(VB,ASP.NET,SQL Server 2000/2005), Quality and IT Consulting. Seek to contribute in a challenging work environment in area demanding technical expertise, customer focus and people orientation.

Executive Summary

• Well-honed business / technical skill set for handling large scale end to end Dataware Housing /BI software Solutions in various platforms and technologies covering various domains which include – Private Banking, Mutual Funds, Manufacturing.

• PGDBA from Symbosis and qualified Computer Science Engineer.

- Successfully Transitioning Projects to India, setting up the project management processes and building a team from scratch - successfully transitioned a Production support and Development for a Financial Mutual fund project on DWH and BI technology.

- DWH and BI Technologies (8 Years), UNIX (1 Years) and SQL Server and & Teradata (1.5Years), VB, ASP.NET (2 Years)

- Certified Teradata (Basic) and SQL Specialist.

- Brain Bench Certified in Visual Basic, ASP (Transcript ID Number: 548740)

- Microsoft Certified Visual Basic (Distributed Applications)

• Comprehensive domain grasp across functional areas with expertise in Software Development Life Cycle (SDLC) for various platforms including

- Project Scoping

- Requirement Analysis & Technical Specifications

- Effort Estimates

- Risk Management

- Planning, Monitoring and tracking

- Reporting and Communication Management

- Ensuring Process Compliance and process Management

- Change Management

- Resource Allocation / Optimization

• Articulate communicator who can fluently speak the language of both people and technology, blending technical expertise with interpersonal skills while interacting with the cross-functional teams, customers and stakeholders.

• Decisive leader with sound understanding of Onsite/Offshore Model and deft in managing members of distributed skill sets, ensuring judicious utilization of resource, cross-functional teams comprising of On-site teams, offshore teams, Developers etc.

• Fully conversant with the application of quality and process improvement tools to facilitate smooth functioning of overall operations and thereby improve service.

• Recognized as an acknowledged trouble shooter with excellent comprehension of business processes culminating in definition and documentation of business requirements, process definition and follow-up of solution realization.

• Well versed in designing and implementing most of the BI Tools which include BO (R3), Cognos (8.2/10.1) and Actuate Bird.

• Well versed in managing Vendor Based applications @ Fidelity.

• Well versed in Creating BI/DWH proposals.

• Well versed in creating POC at the Customer site on any BI Tool which include mainly BRIO, BO (R3), Cognos (10.1) and Actuate Bird.

• Have working knowledge of Cognos TM1

• Well versed in Production support related projects with extensive experience in time critical notification and response platforms such as PACE, Alarm Point, Disaster recovery planning, co-ordination and testing.

• Well versed in Installing and configured IBM Cognos 8.0 Business Intelligence platform in multiple sites.

• Well Versed in Handling/Managing teams which were involved in Production Support of AAA Applications involving Financial Transactions.

• Setup the Automation tool (Jira) for tracking the defects present in the System.

• Well Versed in Managing Agile methodology projects on BI/DWH related technologies.

• Designed and Architected the POC of the Time Tracking, Utilization, Defects @ SG Software using Cognos 10.1 (Designed various Charts, Graphs, Drill through mechanism) across various Business Units

Areas of Expertise

Project Delivery & Transitions ~ People Management ~ Process Management / Quality ~ Resource

Optimization ~ Client Servicing / Vendor Management ‘

Technical Proficiency

Languages : Visual Basic 5.0 / 6.0, ASP, VBScript, JavaScript, ADO, Control-M.

Databases : SQL Server 2000 with SQL Analysis Manager, Access 97, Oracle 7.2, Teradata Version 2 Release 5.

Operating Systems : Windows Server, UNIX. AIX.

Tools : Visual Studio Tools like VSS, ERWIN

DW Tools:

• ETL: Informatica PowerMart, SQL Server for DTS, Ab Initio

• OLAP: Business Objects, MSOLAP, Cognos Impromptu, Cognos Transformer, Cognos PowerPlay, Brio 6.6, Crystal Reports 7.0, Cognos 10.1 Administration, Report Studio, Query Studio, Framework Manager, Access Manager, Sun Directory Server, Business Objects (R3), Xcelsius2008, Actuate Bird.

PM role : Managed projects on Business Intelligence /Dataware House, .Net Technologies

Professional Experience and Accomplishments

Societe Generale Global Solution Centre Aug 2010 till date

Manager.

Key Accomplishments of the project @ SG Software.

• Managing a Team of 4 People for the Prism HO Application.

• Managing the Team/ Release activities of Prism application on the .NET Framework

• Designed and architected the whole Ware House of the Head Office Application.

• Involved in Requirement Gathering, Client Interaction, Weekly Status Meetings with the Counterpart in Paris.

• Also providing the weekly Status Reporting for the Onsite Counter parts and also to the Top Management @ SG.

• Involved in providing inputs to the Onsite counter parts for Licensing of Cognos 10.1

• Designed the Frame work Model derived from the Ware House using the STAR Schema.

• Designed and Developed complex Reports for the Business Users using the Cognos 10.1 (Report Studio, Query Studio, Analysis Studio).

• Mentored and Monitored the Resources for the Timely execution of the Project.

• Responsible for status reporting, client management, people management and project management

• Successfully Implemented the First and Second phase reporting for the Business Users @ Paris and Switzerland.

• Involved with the Team in Providing the Technical Guidance as and when required resolving the Technical Issues.

• Remotely implemented /cross trained people across U.K, Paris, Switzerland of the Security Features usage in Cognos.

• Involved and designed the customization to the Cognos portal as per the Customer Requirements, which include redesigning the Cognos Login page and also restricting the Language setting to Eng and France and also applying security settings to the Portal.

• Guided the team in onsite to Install and Configure Cognos 10.1.in Paris in UAT and Production Environments.

• Have used Cognos TM1 for Financial Planning and Budget Allocation

Major Projects Undertaken

Project Lead and Architect (BI --Cognos) managing the teams for the following projects:

• PRISM: (Client : SGGSCS Paris, August 2010 till date)

• The PRISM overall objective is to design & implement a PRIV-wide credit risk steering and

monitoring system, based on the Global Credit Policy (GCP) functional requirements and taking

into consideration both the existing systems landscape (and related investments) as well as

PRIV’s global IT strategy.

HCL Computers Ltd March 29 2010 till Aug 6,2010.

Senior Technical Lead

Key Accomplishments of the project @ HCL Computers Ltd

• Involved in preparing the Proposals for BI Solutions.

Fidelity Business Services India Pvt Ltd June 2004 till Dec 31,2009

Lead Software Engineer

Key Accomplishments of the projects @ Fidelity Business Services India Pvt Ltd

• Responsible for mentoring new team members and training for Production Support and Maintenance, Development Related Projects on BI/DWH Platform.

• Developed Informatica Design documents for ETL Purpose

• Configured Cognos Server based in United Kingdom including user management, access control, creation of packages using Framework Manager, deployment of packages on the web for report creation using Report Studio and Query Studio and deployment of Cubes using Power play and Transformer.

• Deployed the packages in Development and deployed to Production servers.

• Successful in Setting the Cognos 8.0 Administrator and crossed trained people in the Team.

• Deployed the Cognos packages in Development and deployed to Production servers.

• Involved in weekly calls with the customer for new requests/assignments.

• Responsible for mentoring new team members and training for Production Support and Maintenance

• Developed Informatica Design documents for ETL Purpose

• Configured different types of transformations in Informatica

• Configured Cognos Server based in United Kingdom including user management, access control, creation of packages using Framework Manager, deployment of packages on the web for report creation using Report Studio and Query Studio and deployment of Cubes using Power play and Transformer.

• Successfully trained approx 100 Associates on basics of Equity.

• Well versed in Vendor Management.

• Management of portal including Vendor Management for all performance issues, Upgrade Management (build, patch deployment)

• Management of IIS servers (Development, Pre-Production, Disaster Recovery, Production)

• Mentored and Monitored the team to create Test cases for Functional Testing in Cognos and SSIS.

Major Projects Undertaken

HR Access – Datawarehouse (Client: HR Access Paris) July 2007 to December 31, 2009

• HR Access supported Human Resource activities such as training, vacation, compensation and medical information management. The system consisted of two components:

- Loading data from different database systems into the data warehouse using Informatica

Maintaining the enhancement of the reporting using Cognos8.0 and ETL (Informatica) environment.

Technical manager leading a team of 15 People on various roles.

eRecruitment Portal (Vendor Management/Project Management) Client : Fidelity Business Services India (July 2007 to December 31, 2009)

• Managed the vendor in developing the application and also transitioned the project to Fidelity for Business users to access the application which was developed at the vendor site to Fidelity and also mentored 3 resources on Cognos and 2 resources in Production support @ Fidelity.

• Trained resources on Cognos Administrator.

eRecruitment is a Job Portal used for resume management, job requirement creation and

assignment, interview scheduling and remuneration negotiation process.

The portal used Fidelity eBusiness Security Architecture (FeBSec) authentication process on iPlanet server.

• Also involved in Creation of packages using Framework Manager, deployment of packages on the web for report creation using Report Studio and Query Studio

• Deployed the packages in Development and Production servers.

• Production support in high-availability, high-volume web site (https://india.fidelity.com/india)

• Worked as a Cognos Administrator

Fidelity Funds Information Warehouse System (Technical Manager)Client :Fidelity Business services India Pvt Ltd (Boston – USA) (July 2005 to July 2007)

• Managed team of 10 resources and trained them on the project.

• Involved in Status call with the customer on a daily basis.

• Loading data from different systems into datawarehouse using Informatica and other scripts.

• Analyzed the different mappings and created documents for mappings and getting approvals.

• Managed weekly reviews with the customer for initiating new requests/assignments.

• Developed Reports format in Brio.

• Migrated reports to Brio Server so that Business Users can view the Reports in Microsoft Excel and PDF formats.

• Worked as a Brio versions 6.6 and 8.0 Administrator

The warehouse greatly enhances the level of service that business units across the FESCo organization are able to provide to customers, resulting in considerable cost savings while significantly reducing Fidelity’s risk exposure. The construction of a data warehouse which is accessible to other tools to pull data from and a user friendly graphical user interface (GUI) will offer FIRSCo and FITSCo the opportunity to:

Provide consistent information across all channels of delivery

Significantly increase organizational efficiencies in the production of materials

Improve the timeliness and accuracy of information delivered to clients

Reduce Fidelity’s risk exposure through the promotion of timely and accurate information.

Substantially reduce costs associated with the compilation and distribution of client material

Increase organizational effectiveness and reduce cost through the promotion of timely and accurate information to internal partners.

Fidelity Employer Services Company (FESCo) – Analytics and Operational Reporting System Client: Fidelity Business services India Pvt Ltd (Boston – USA) July 2004 to July 2007

• Management of 8 - member Production Support team

• Responsible for mentoring new team members and training on Informatica and Brio

• Involved in Weekly call with the Customer for initiating new requests and assignments.

Fidelity Employer Services Company (FESCo) provides defined contribution and defined benefit retirement services, employer benefits and human resources administration, and payroll services to approximately 21 million participants in the United States. FESCo Operational reporting and Analytics System consists of:

Loading data from different mainframe systems into the data warehouse using Informatica and other scripts.

Maintaining the production reporting environment.

Satyam Computers Ltd July 2003 – March 2004

Systems Analyst

Selected Achievements

• Lead a seven member team working Informatica/TeraData and BRIO.

• Analyzed the Requirements and translated to DWH on SQL Server DTS and BRIO

• Designed the warehouse in STAR SCHEMA.

• Developed DWH Applications on TeraData

Projects Undertaken @ Satyam Computers Ltd .

• Customer Experience – Delivery to Target (DTT)

• Rocket Dataware Housing

Career Profile

Aug 16,2010 – Till date Societe Generale Global Solution Centre Manager

March 29,2010- Aug 6,2010 HCL Computers India Ltd Senior Technical Lead

June7,2004 – Dec 30, 2009 Fidelity Business India Private Ltd Lead software Engineer

July 2003 – March 31 2004 Satyam Computers Ltd Systems Analyst

Dec 2002- July 2003 Vmoksha Technologies Pvt Ltd IT Specialist

Jun 2000 – Dec 2002 PSI Data systems Ltd Senior Software Engineer

Nov 1999 – March 2000 Wipro Infotech Ltd Systems Executive

March 1999 – Nov 1999 Nagaraj Technologies Pvt Ltd Consultant Software Engineer

Feb 1998 – March 1999 Processware Systems Pvt Ltd Software Engineer

Academic Credentials

Bachelor of Engineering - Computer science and Engineering 1998

B.M.S.C.E, Bangalore

PGDBA (Marketing) - Symbiosis Center of Distance Learning (Pune)

Training/ Certifications

• IBI Web Focus on Web Focus - Generating Reports and writing Web Focus Code

• Teradata Factory by NCR - Teradata Architecture, Writing BTEQ Scripts, Fast Load, Multi Load scripts.

• Informatica PowerMart - Creating workflows, scheduling the workflows, Creating Database Connections.

• Business Objects - Creating Universe, ODBC Database Connections and Generating Reports.

• People Soft 8.0 - People code, People Tools

• HRMS Customization

• Global Payroll - Global Payroll Customization for UK and France

• Actuate - Creating reports and Database connection.

• Ab Initio - Creating Maps, Graphs and Scheduling.

• Project Management Training @SABCONS.

• Agile Methodology and Best Practices.

• ITIL v3 Training on Production support methodology.

References & Details of other Projects Available upon Request

Contact this candidate