Professional Profile:

I’m a Senior Business Analyst with 7+ years’ experience in Business Intelligence and Data Warehousing environment. He has profound experience in Business Intelligence tool Cognos, and is proficient in designing and developing customized BI solutions. He is well versed with DW/BI concepts and is IBM Certified Metadata Modeler and Author of Cognos 10 Reports.

During my career, I’m collaborated with American, European and Indian clients. He has been involved in end to end implementation of Data warehouse projects using Informatica and Cognos.

Experience in Requirements gathering, Analysis, Design, Development and testing phases of a Business Intelligence projects. Additionally he also has Cognos administration experience including Installation and Configuration providing user security. He worked on rolling out Cognos Report Studio and Query Studio to a group of business user.

I’m performed various levels of Testing such as Unit testing, System tests, Functional testing, and Pre-Prod testing. He has good knowledge of SQL and is well versed in writing and analyzing normal SQL queries.

To enhance his technical knowledge, Venkat has undergone technical trainings in Cognos TM1, Oracle Hyperion Essbase and Informatica.

Technical Skills:

Industries: Banking, Finance, Insurance, Health Care, Retail and Travel & Transportation

Operating Systems: Windows Family

Languages: SQL, PL/SQL

Database: Oracle, SQL Server

BI Tools: Cognos (1.1MR3, 8.2, 8.3, 8.4 and 10), Dynamic Cubes,SSAS,FM and DQM.

Database Query Tools: Oracle SQL Developer, TOAD

Career History:

01/2015– to till date IBM India Pvt Ltd, India as Cognos Application Developer

05/2010 to 12/2014 Accenture India Pvt Ltd, India as Senior Software Engineer.

Recent Accomplishments:

Project : CDW BO

Period : Jan 2015 to till date

Client : H&M,Sweden

Role : Senior Cognos Developer

H & M Hennes & Mauritz AB is a Swedish multinational retail-clothing company, known for its fast-fashion clothing for men, women, teenagers and children.

Responsibilities:

• Develop and maintain Cognos reporting, querying and analysis solutions.

• Work closely with database and reporting technicians to build and support the information environment.

• Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians.

• Develop, maintain Cognos Dynamaic Cubes,SSAS Cubes and Framework Manager Models and Reports.

• Provide status on issues and progress of key business projects.

• Responsible for preparation of High level and Low level design documents and providing estimates.

• Develop and implement reports queries to help drive business processes from CQM to DQM process.

• Fill adhoc data and reporting requests.

• To create data models based on Functional Reporting Requirements, Technical reporting requirements.

• Coordinating the Production release and other deployment activities.

• Keeping all the stakeholders updated about the daily assigned.

• Gain functional and technical expertise in the assigned application area.

Project : NiFiT

Period : Jan 2013 to Dec 2014

Client : Nisource - Columbus - OH, US

Role : Senior Cognos Developer

The primary objective of NiFiT is to migrate the company’s financial processes and systems to a unified platform while addressing the issues and challenges that have come with the use of legacy software. Specifically, NiFiT Design will define the future state end-to-end business processes along with supporting technology application and infrastructure landscape. NiFiT Design will also include the review and validation of the scope, schedule and cost estimates of the overall NiFiT implementation.

Contribution:

Benefits:

1.Improve operational efficiency and effectiveness;

2.Create a platform to support growth;

3.Optimize business processes to drive automation, simplification and standardization;

4.Improve data quality and reporting to improve decision making; and Reduce risk of reporting delays due to issues with the current general ledger systems.

6. Enhance financial controls

Responsibilities:

• Develop and maintain Cognos reporting, querying and analysis solutions.

• Work closely with database and reporting technicians to build and support the information environment.

• Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians.

• Develop, maintain Framework Manager Models and Reports.

• Provide status on issues and progress of key business projects.

• Responsible for preparation of High level and Low level design documents and providing estimates.

• Develop and implement reports queries to help drive business processes.

• Fill adhoc data and reporting requests.

• To create data models based on Functional Reporting Requirements, Technical reporting requirements.

• Coordinating the Production release and other deployment activities.

• Keeping all the stakeholders updated about the daily assigned.

• Gain functional and technical expertise in the assigned application area.

• Following SDLC life cycle for new enhancements.

Environment: Relational Modeling on Cognos 10.2.1, Data stage, Oracle 11g

Project : CLDW - BI

Period : Apr 2012 to Dec 2012

Client : Travelers, US

Role : Sr Cognos Developer

LOB - BI - Filed Management

The Travelers Companies, Inc. is one of the Nation’s largest leading provider which offers a wide variety of Property & Casualty Insurance products for Auto, Home & Business, Surety products and Risk Management Services. The company’s diverse business lines offer its global customers a wide range of coverage sold primarily through independent agents and brokers. It operates in the U.S., Canada, U.K. and Ireland.

Responsibilities:

• Worked on the development of Cognos reports (8.4) & Cognos 10 and upgraded reports and packages and FM from Cognos 8.4 to Cognos 10.

• Worked on enhancement of the Cognos reports and also resolving the incident or problem tickets raised by business analysts.

• Responsible for daily Interacting with the clients to understand and freeze the business requirements for any new work allocated.

• Created Analysis documents and Estimation plans based on the complexity of the work allocated for the resources.

• Unit test Plan and Unit test case documents are created for unit testing of Cognos reports and Review/ Design Checklist is maintained, if necessary

• To ensure all the deliverables are made on time with minimal defects and also to ensure high quality

Environment: Relational Modeling on Cognos 10, Teradata data base.

Project : Cost base full accounting

Period : Sept 2010 to Mar 2012

Client : Bank of America, US.

Role : Sr Cognos Developer

Cost Basis and Full Accounting (CBFA) is a client proprietary application used by Bank of America’s GCIB Finance organization, used by an end-user for the retrieval of information and reports to analyze the cost basis and finance growth. This allows management to identify the business growth and decides the necessary improvements. The application provides various canned reports which provide business intelligence to various other internal organizations.

Responsibilities:

• Worked on the development of Cognos reports (8.2) & Cognos 10.

• Worked on enhancement of the Cognos reports, cubes and also resolving the incident or problem tickets raised by business analysts.

• Responsible for Interacting with the clients to understand and freeze the business requirements for any new work allocated.

• Created Analysis documents and Estimation plans based on the complexity of the work allocated for the resources.

• Unit test Plan and Unit test case documents are created for unit testing of Cognos reports and Review/ Design Checklist is maintained, if necessary.

• To ensure all the deliverables are made on time with minimal defects and also to ensure high quality.

Environment: Relational Modeling of Framework Manager on Cognos 8.4, Oracle 9i.

Project : GCE

Period : Jan 2010 to Aug 2010

Client : Pfizer, US.

Role : Sr Cognos Developer

Pfizer - GCE Cognos Application

Responsibilities:

• Worked on the development of Cognos reports/ packages for new requirements under Pfizer Global concur expanse management

• Worked on enhancement of the Cognos reports/ packages for existing applications in production and also resolving the incident or problem tickets raised by business analysts.

• Interaction with the clients to understand and freeze the business requirements for any new work allocated.

• Involved in designing the estimations that calculates work hours for a particular incident or problem ticket to complete. It basically decides on the complexity of Cognos Reports, which is the number of objects involved in a given Reports.

Environment: DMR Modeling and Relational on Cognos 8.3, Oracle 9i.

Project : Cummins Global Support - ORACLE

Period : Aug 2009 to Dec 2009

Client : Cummins, US

Role : Cognos Developer.

Concur is a third party tool mainly used for maintaining of expense reports. It allows Cummins employees (Over all global wise Cummins Inc. employees) to create expense report against their credit card and cash transactions; we transfer those expenses to AP, GL and to Payroll departments to get paid and maintain journals. Customization includes developments of oracle discoverer reports, includes maintenance and support.

Responsibilities:

• Worked on the development of Cognos reports/ packages under Expense management System services.

• Worked on enhancement of the Cognos reports/ packages for existing applications 3.Interaction with the clients to understand and freeze the business requirements for any new work allocated.

• Created Analysis documents and Estimation plans based on the complexity of the Cognos reports

• Unit test Plan and Unit test case documents are created for unit testing of Cognos reports.

• Worked on the development/ enhancement to the multi-dimensional reports using Cognos tools

• Proactively involved in the performance improvement of the existing Cognos reports in production by tuning from the reporting end.

• To ensure that projects have been planned effectively so that there should not be any escalations from the client end

Environment: Relational on Cognos 8.4, Oracle 9i.

Project : BMA

Period : Feb 2009 to July 2009

Client : BMA

Role : Cognos Developer

BMA is a Dubai based textile company. Basically BMA wants to know the flow of his textile business all over different branches of BMA Middle East countries. We used Cognos 8.3 as a reporting tool to answer the business questions of the client. This project mainly helps Client to take decision based on the reports, what we given to Client, in such a way that he can concentrate on the poor performance factors and lead his business into success area.

Responsibilities:

• Responsible for Interacting with the clients to understand and freeze the business requirements for any new work allocated.

• Created Analysis documents and Estimation plans based on the complexity of the work.

• Involved in Understanding the business requirements.

• Created different types of reports such as List reports, Crosstab reports and Chart reports.

• Developed simple as well as complex reports using Report studio.

• Creation of Model & Package in Framework Manager.

• Creation of Dashboard Reports.

• Applying different functionalities like filters prompts to retrieve relevant data from the database.

• Involved in unit testing of the reports and improving report performance

• RND on performance Issues of the reports and prompts.

• Testing the reports with the database to compare the results.

Environment: Relational on Cognos 8.4, Oracle 9i.

Project : FAP & OVV

Period : Jun 2008 to Dec 2008

Client : GM, US

Role : Cognos Developer

This process entirely deals with the Freight charges and relevant transactions. It includes analyzing the business transactions related to consumption of Time from Origin to Destination, reduction of expenditure and also serves as pre-audit process for allocation of transport costs.

Overall the objective is to reduce the transportation costs while improving customer service levels and total in-transit visibility.

Responsibilities:

• Responsible for Interacting with the clients to understand and freeze the business requirements for any new work extensively developed reports as per the business requirements.

• Developed simple as well as complex reports using Report studio.

• Applying different functionalities like filters prompts to retrieve relevant data from the database.

• Creation of drill-through and master-detail reports.

• Extensively developed the documents like System test cases, Unit test cases and Program Specification Documents.

• Involved in Unit Testing.

Environment: Relational on Cognos 8.3, Oracle 9i.

Educational Background:

Venkateswarareddy Dasireddy has MSc (Master of Science) degree from Nagarjuna University Campus in 2007.

Contact Information:

Email: acrrr4@r.postjobfree.com

Contact No : +91-988*******

Contact this candidate