PROFESSIONAL SUMMARY

* ***** ** ********* ********** in IT industry as Cognos Developer / ETL Developer which includes extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), OLAP, ETL tools, Product Development and Reports Generation.

Experience in Migration from Cognos 8 series, ReportNet to Cognos 10 BI series and experience in Installing and Configuration of Cognos8 on client-server architecture.

Hands-on experience in COGNOS 11.x/10.x/8.x Suite (Framework Manger, Cognos Transformer, COGNOS Connection, Report Studio, Query Studio, Business Insight, Advanced Business Insight, Analysis Studio and Event Studio) with expertise in Metadata Modeling-Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, set security and publish into portal.

Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.

Move the Cognos Framework Manager model from development, test environment to production environment.

Experience installing and configuring Cognos 8x/Cognos 10x in distributed environment.

Performed Defect Prevention Activities in Project.

Expertise in developing SQL programming.

Experience using IBM Cognos Cube Designer and Integrated Dynamic Cubes to develop Virtual Cubes.

Excellent understanding of OLAP data processing methodology.

Worked with Business Analysts and end users in understanding and preparing functional, technical specifications and designed documents..

Experience in understanding and working with On-site Off-shore environment.

Excellent problem solving ability coupled with good communication skills to interact with end-users, customers, and team members.

Customized Reports using HTML and JAVA SCRIPTS.

Strong Knowledge with Power Play Transformer model design and Power play cube building.

Extensive experience in Data Warehousing tools including SSIS, Data Modeling Tools like Erwin using Oracle, DB2, MS SQL Server databases, SAP.

Experience in OLTP/OLAP System Study, Analysis and ER Modeling, Maintaining Database like Star Schema and Snowflake Schema used in relational and dimensional modeling and Kimball methodology.

Technical Skills

BI Tools

Cognos Analytics11, Cognos 10.2.2/10.2, Cognos 10.1, Cognos 8x,Cognos 10.2.2/, Business Objects XI Rel2.0, Web, Tableau 9/9.2

ETL Tools

Informatica 8.6/9, Data stage 7.5, Microsoft SSIS 2008, Cognos Data Manager.

Database’s

Oracle 10G/11g, SQL Server 2005/2008/2010/2012, Teradata 12/V2R6, DB2 8.0

Web Server’s

Apache web server, IIS 7.0.

Language’s

C, HTML, SQL, PL/SQL.

Internet Technologies

HTML, DHTML, ASP, Java Script and VB Script, XML.

Professional Experience

BB&T,Nashville,TN OCT 2016 –Sep 2017

Cognos Developer

BB&T (Branch Banking and Trust) is one of the largest financial services holding companies in the U.S. Based in Winston-Salem, N.C., the company operates 2,196 financial centers in 15 states and Washington, D.C., and offers a range of consumer and commercial banking, securities brokerage, asset management, mortgage and insurance products and services.

Responsibilities:

●Installed and configured Cognos Analytics 11 on R&D servers.

●Developed some POC reports using Cognos Analytics 11.

●Involved in meetings with the users which included discussing and gathering the business requirements, reporting enhancements, changes and issues.

●Worked on enhancements and modifications of the Meta data models using Framework Manager.

●Used Framework Manager to create different layers like Database Layer, Transformation Layer and Presentation Layer by defining appropriate relationships between query subjects.

●Designed Meta Data Model’s - Packages in Framework Manager.

●Experienced in creating a dynamic excel templates by creating temporary view, export data to excel and destroy the view

●Extensively worked on Active forms to create user input templates and reports with conditional formatting and security

●Experience in creating dynamic subsets using mdx in dimension editor and also in turbo integrator scripting for loading cubes from database, creation of dimensions etc.

●Experience in Cognos Report Studio, in creating different types of reports using Prompts, Drill-through, master-detail query relationships, conditional formatting, grouping and sorting features of Report Studio to generate efficient and user-friendly reports

●Implemented security at Application level, Cube level, Dimension level, Element level and Data level.

●Experience in scheduling the turbo integrator process using chores

●Developed various reports, and they include, lists, cross tabs, charts, complex reports with conditional blocks, static choices in prompt, bursting etc.

●Performance optimization on the Cognos front was done using slicers instead of detail filters for reports generated out of the database. Reduce the number of queries to be processed, use necessary macros for prompts, check on query properties such as local cache, processing etc.

●Worked closely with the ETL and QA teams and involved in meetings to discuss test case documents and resolve any kind of issues reported during the testing process.

●Wrote simple to complex SQL queries in the process of unit testing of the reports.

●Involved in Scheduling and distributing the reports using Cognos administration.

●Created the export and import packages in content administration.

●Worked closely with the migration team to deploy the reports and packages from Development to QA, UAT and Production environments.

●Customized Cognos Data Source Connection with appropriate reports and security measures.

Environment: Cognos Analytics 11.0.3/11.0.4 (Report Studio, Cognos Workspace Advanced, Data Module, Cognos Workspace, Cognos Connection, Framework Manger, Query Studio, Event Studio), Cognos 10.2.2/10.2.1 (Cognos Analytics 11, SAP, Oracle 10g/11gSQL Server 2008/2010/2012, SSIS, Informatica 9.

Acosta Jacksonville,FL Aug 2015-Aug 2016

Cognos developer

OHSU, formerly known as Oregon Health and Science University is an American apparel company based in Portland, Oregon. OHSU’s contributions like other academic health centers nationwide are the result, in large part, of the synergism among its innovative patient care and nationally recognized education and research activities.

Responsibilities:

Installed and configured Cognos 10.1 in distributed environment.

Used IIS for configuring web server and set up security using Active Directory.

Provided access to users to respective groups and roles.

Monitored servers, schedules and set up Audit database for Cognos Audits.

Analyzed business requirements and prepared functional specifications/system technical design documentation.

Designed Framework Manager Projects, Model & Packages by importing the Metadata from various Data Source tables, Views, Data Marts and Macros.

Defined cardinalities between the data objects for ad-hoc query users and power users.

Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements.

Created most of the Documents like Technical Document, LLD, TM1 and BI integration document, Work flow Document, Project Plan, Document on report format and Standards, etc.

Managed and designed the Cognos BI and TM1 integration for reporting and analysis.

Designed and implemented TM1 architecture for the corporate planning system and applications.

Created solutions pertaining to financial budgeting, planning and forecasting, sales and profitability solutions for companywide analysis using Cognos TM1 suite.

Provided technical guidance and solution to junior developers in the team

Managed data load, batch monitoring, cube refresh schedule and production support activities

Planned and conducted user training sessions for super level user. Trained users on TM1 Perspective, Cognos Query Studio and Event studio.

Participated in data model creation resulting in creating Star schema architecture, Snow-Flake Model and Fact and Dimensional Models as per project requirements.

Developed Prompt Pages and used Conditional Formatting.

Developed the Drill Through Reports, Master Detail Reports Using Report Studio and Query Studio

Developed some custom report templates based on user requirements.

Designed summary and detail reports which involves the key functionalities of the report studio like conditional blocks, conditional layouts.

Developed OLAP cubes from the Cognos Power Play Transformer using IQD files that were generated from the Framework Manager.

Created URL’s to navigate from one report to another report using Java Script functionality.

Creating Analyses from the published cubes using Analysis Studio as per the Business needs.

Creating the scripts for the automation of cube building and publishing.

Writing the Java Script in Report Studio Reports to display default values in value prompt.

Bursting complex reports and scheduling them to improve server performance and delivered the reports through email.

Tested all the reports against UAT and Production from the test cases provided by Database team.

Provided extensive training to end users, how to use the Dashboard reports in Cognos 8.

Installation & Configuring the Cognos 8.4 on Windows Environment.

Environment: Cognos 10.1(Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio), Cognos 8.4 FP2 Suite, Cognos Data Manager, Power Play Transformer, SQL Server2005, Toad, Cognos Access Manger, Oracle 10g, Cognos TM1 9.4, TM1 Web, Windows 2003 Server, IIS, Informatica 8.

SOA Software,Hyderabad,India sep 2012-April 2015

Cognos Developer

A service-oriented architecture (SOA) is a style of software design where services are provided to the other components by application components, through a communication protocol over a network. The basic principles of service oriented architecture are independent of vendors, products and technologies.[1] A service is a discrete unit of functionality that can be accessed remotely and acted upon and updated independently, such as retrieving a credit card statement online. In SOA, services use protocols which describe how they pass and parse messages using description metadata

Responsibilities:

Used Framework Manager to create models, packages and publish packages to the Cognos 8 Server.

Migration of reports and catalogs from Cognos series 7.1 to Cognos series 8.3. Upgrading of reports from series 7.1 to series 7.3

Experience in developing models using prompts and filters.

Distributed reports to various agents using Bursting.

Added new Dimensions and Measures in the already existing reports in the Production.

Performed BI Content Administration tasks including scheduling and content management

Developed SQL in TOAD and exported results to Access Database.

Developed SQL Driven reports.

Administered user access protocols and managed user accounts and access privileges.

Setting up different environments(development, testing and production)

Deployed the reports from development to QA and QA to production using deployment tool.

Used Cognos Connection for organizing, security, scheduling and distributing reports.

Created various portals involving Cognos 8 port lets.

Administer user access protocols and created user accounts and access privileges

Environment: Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler,XML and Windows NT/4.0

Soft Tech Solutions,Hyerabad,India Jan2006-Aug 2008

BI Consultant

Softtech Solutions has offices in the United States, Italy, Germany and France. Headquartered in Lowell, Ma. SofTech has provided Product Lifecycle Management, Product Data Management, and CAD CAM solutions. SofTech acquired Workgroup Technology Corporation (WTC), developer of Product Center, the company's PDM/PLM solution. WTC was one of the earliest PDM/PLM providers in the industry, having delivered PLM software products beginning with its first software product.

Responsibilities:

Created Packages and Folders in Framework Manager1.1 and published them to Cognos Connection.

Gathered and analyzed business requirements from users and business community.

Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.

Created Sophisticated Reports using Report Studio 1.1

Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

Supported Business Users in generating Adhoc Reports using Query Studio1.1.

Catalogs were Optimized by using Database Interaction, Client/Server balancing, Database functions, Table Weighting and Qualification, Governors Settings.

Created filters, prompts, sub reports, provide drill through capabilities

Creating User Classes and Restricting the user access with the help of User Class Privileges in the Governor settings.

Worked on Star Schema Database Design.

Environment: Cognos Report Net 1.1MR2, Cognos Connection, Report Studio, Framework Manager1.1 MR2, Cognos Impromptu 7.1 MR3, Cognos Access Manager, Cognos Scheduler, SQL, PL/SQL, Oracle 8i, Windows XP.

Contact this candidate