SUMMARY:

• Strong hands on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
• Deployment of Models, Packages, Folders, Reports, Cubes, Data Sources from Development environment to production environment.
• Experience in Performance tuning of the existing Cognos Reports.
• Experience with Events Studio with creating alerts, executing tasks and distributing reports.
• Proficient in developing Scorecard, Dashboard reports using JavaScript in Report studio and Implemented Security among various COGNOS applications.
• Experience developing complex reports List, Cross Tab, Chart, Singleton Repeater, Active Reports using drill-through, prompts, master-detail, burst options, dynamic filtering in Cognos BI.
• Over 7 years of IT Experience in design, analysis, development and implementation of Various applications in Client/Server OLAP environment using BI Tools
• Worked in various phases of software development life cycle SDLC including Analysis, Design, Development, Testing and Production.
• Experience in Data Warehousing and Business Intelligence area in various domains.
• Good knowledge of Data Warehousing concepts, RDBMS and multi-dimensional schema Star Schema and Snowflake Schema and worked on both OLAP and OLTP databases.
• Developed Framework Manager Models Layers, Relations, Query Subjects, Star-Schema and Packages and published packages.
• Build DMR model based on data hierarchies. Developed reports against DMR model.
• Experience in migrating/upgrading Reports Packages from Cognos 7 series to Cognos 8 and Cognos 10.1.1.
• Developed reports using advance functionality of Analysis Studio such as drill up and drill down, rank, slicers .
• Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Ability to handle multiple tasks concurrently and meet the deadlines.

TECHNICAL SKILLS:

• BI Tools : Cognos 10.2/10.1/8.x suite Framework Manager, Query Studio, Business Insight Advanced, Report Studio, Analysis Studio, Metric Studio and Event Studio , Cognos ReportNet 1.1 and Cognos Series 7.X Power play Transformer, Impromptu Tableau Desktop 8
• ETL Tools : Informatica, DataStage
• Web server : IIS Web Server, Apache, Tomcat
• Databases : Oracle 8i/9i/10g/11g, Teradata, MS SQL Server 2005/2008/2012 and DB2
• Tools : MS Excel, MS Word, MS PowerPoint, MS project, MS Front MS Expressions Web, TOAD, Sql Developer, Sql Star Plus.
• Programming Languages : Microsoft. NET ASP.NET,C .NET and VB.NET , Tsql, SQL
• WEB Technologies : JavaScript, XML, HTML.

PROFFESIONAL EXPRIENCE:

Confidential

Sr. Cognos Developer

This project is about assisting the Financial and Sales Management System and to build and facilitate the data warehousing of various business departments like Sales, Inventory Management, Budgeting, Production and Forecasting. To integrate multiple feeds from relational sources and generated reports using Cognos tools to provide deep insights into sales, revenues, regions, costs and profits down to the level of individual salesman.

Responsibilities:

• Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs.
• Understood the business requirements document and Data model design document to come up with the Cognos model design.
• Created Cognos model design document and which was reviewed with the technical lead and database architecture.
• Implemented Models in Framework Manager in Cognos 10.1 using three layered approach and star schema groupings.
• Installed and configured Cognos Framework Manager for modelers.
• Worked with large number of role playing dimensions and merged query subjects.
• Wrote Custom SQL to support business requirements.
• Implemented macros to apply security to query subjects.
• Implemented filters and Cognos calculations as per the business requirements.
• Developed complex multi-page financial reports with multiple prompts and charts, lists and drill-through functionality using join and Union in queries.
• Worked on Cognos 10.1 new features like Active reporting and imported data in report studio from external data sources.
• Validated data at the row level and data level to ensure completeness and correctness of data
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Created custom date time calculations and macros in the reports.
• Created jobs, schedules and report views for the business users.
• Involved in administrative activities, doing deployment and monitoring schedules and jobs.
• Worked on Cognos Security Administration to restrict the users.
• Deployed Framework Manager Models and Reports and Packages from Dev to Test and Test to Production Environment and troubleshoot deployment issues.
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.
• Provided customer support to Tableau users.
• Provided Assistance to users in building reports in Report Studio, Query Studio, and Analysis Studio
• Provided solution to users who raised tickets and educated new users with basic Cognos reporting.

Environment Cognos 10.1/10.2 suite Report Studio, Analysis Studio, Query Studio, Event Studio Cognos Connection, Framework Manager , Power Play Transformer 7.3, ReportNet1.1/8.3, Microsoft SQL Server 2012, Tableau Desktop 8.0.

Confidential

Sr. Cognos Developer/ Analyst

• Biosense Webster part of the Johnson and Johnsons family of companies is recognized as a leader in the science behind the diagnosis and treatment of cardiac arrhythmias.
• The project was with Finance, Manufacturing, Research and sales departments of Biosense to analyze laboratory and clinic testing data to gain actionable insight into manufacturing processes, in order to produce a high volume, disposable product, which is cost effective to manufacture and yet also technically very precise and safe for the end user.

Responsibilities:

• Analyzed the business requirements and worked with ETL and Cognos team to provide solutions.
• Proposed ETL/Data Stage to suit the requirement and business model.
• Extracted data from Oracle database and spreadsheets and staged into single place and applied business logic to load them in central oracle
• Involved in Creation of model by using framework manager, Developed and published Packages in Framework Manager - Connecting and testing the data source, created the Physical Layer Logical Layer and defining appropriate relationship between query subjects
• Creating List, Cross Tab Reports and Drill Through reports using Report Studio.
• Creating Value Prompts, Date and Time Prompts, Text box prompts, cascading prompts and Select and Search Prompts.
• Creating Conditional formatting like highlight data and to show or hide.
• Creating Layout Component Reference object for the report in Report Studio.
• Creating Conditional Block according to the client requirements.
• Creating Multiple Dashboards.
• Scheduling the Reports on quarterly, monthly and weekly according to the client requirements using Report Studio.
• Responsible for gathering and analyzing the requirements from the business users and designing the mockups based on the needs.
• Responsible for developing the reports in Report Studio 10.1.1 and exporting into various formats Excel 2007, Excel 2002 and PDF .
• Updating the Reports according to the client Requirements.
• Prepared Unit Test Cases for reports.

Environment Cognos 10.1.1 suite Report Studio, Event Studio, Analysis studio Framework Manager , Oracle 11g, SQL Developer, SAP Business Objects 11.2 Desktop Intelligence, Designer

Confidential

Cognos Developer

The project is to identify, analyze and assist the Business Requirements of the Financial Department and create Reports, create the Packages, which would be used for ad-hoc and canned reporting needs. Validation and testing of reports were also some of the responsibilities performed.

Responsibilities:

• Involved in gathering business requirements from the users
• Created project scope and timelines.
• Work with Business Analysts, client users and internal systems resources on Cognos installations, upgrades, troubleshooting, and bug resolution.
• Proposed ETL/Data Stage to suit the requirement and business model.
• Created different types of reports like List, Cross-tab, Chart, Drill-Through and Master-Detail Reports.
• Created multiple Dashboard reports for multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Provide technical support for Cognos 10 applications including report analysis, development, maintenance, and report migration.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Initiated training for the users to do ad-hoc reporting using Query Studio.
• Extensive experience on Structuring Metadata and Cognos Models using Framework Manager.
• Provided support for slowly changing dimensions in data marts.
• Implemented data profiling and quality check in Data Manager.
• Designed and Prepared a Training Material for the Users.
• Closely Involved in Requirement gathering and Analysis with the customers.
• Created List Reports, Cross tab Reports and Control Charts.
• Implemented Security for Data access, Object level access and Package level access.

Environment Cognos BI 10.1 and 8.x Series Report Studio, Analysis Studio, Query Studio, Event Studio,

Confidential

Cognos Developer

Confidential. is a cooperative data exchange formed by the North American life insurance industry in 1909. MIB is the only insurance consumer reporting agency in North America and operates a database of medical information on some individuals who have previously applied for health insurance, life insurance, disability insurance, critical illness insurance and long-term care insurance.

Responsibilities:

• Involved in gathering business requirements from the users.
• Designed Functional Requirement Specifications for report development.
• Proposed ETL/Data Stage to suit the requirement and business model.
• Developed Data warehouse design, Implemented Staging, QA and Prod Environments.
• Creating reports based on DMR Model, Cubes using MDX Functions.
• Creating the different types of Chart, List, Cross tab reports using Report Studio.
• Analyzed the Visual Script Code and Excel Reports which were based on that code.
• Built Dashboards using several Report Studio concepts like Cascading Prompts, Drill-Through, Master Detail Relationship, Filters, Page Break, Conditional Formatting.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Involved in designing of Test Plans, Test Cases, and Executed Test Cases.

Environment Cognos BI 8.4 Series, Cognos ReportNet1.1/8.3, Sql Server 2008/2005, Oracle 10g, Crystal Reports

Confidential

Cognos Developer

• LTC Application Transition initiative CARE John Hancock provides leading insurance and financial services products including life insurance, 401 k plans, and mutual funds.
• GLTC CARE system is homegrown Long Term Care policy administration system. The system is designed to handle all the administrative functionalities apart from Claims. The functional features of the system are driven by and has direct relationship with DB2 Database Tables.

Responsibilities:

• Installed Configured Cognos Office Connection and Developed Templates for Cognos, Office Word, Excel and PowerPoint.
• Extensively worked with business experts and end users to identify the business.
• Process/ requirements and verify/validate the data and discuss the Cognos capabilities.
• Gathered data requirements, created pre-project documents with Cognos functionalities/options such as report distribution, archives and security for the project.
• Developed List, Crosstab, Drill through, Master-detail, Chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Used the formatting options like crosstab representation, section breaks, data sort options, calculations, font.
• Extensively used Designer to design various universes for different business groups.
• Involved in report bursting using Broadcast agent server.
• Involved in design and development of user classes, filters, calculations, prompts and conditions in Catalog and query definition files in Impromptu Administrator.
• Implemented security for Data Access, Object level Access and Package access.
• Built Power Play Reports based on these cubes and published to Report Net Server.
• Built Power Play Cubes for Sales, Inventory and Stock Ledger.
• Created Dashboards visualizations using Visualizer.
• Worked on Cognos Security Administration to restrict the users.
• Created User Classes and Users in Access manager and provided the user credentials.
• Created Different types of Reports like Forecast, Master Detail, Customer and Variance Reports.

Environment Cognos BI 8.4 Series, Sql Server 2008/2005, Oracle 10g and Crystal Reports.

Confidential

Cognos Developer

• MetLife has bought an Insurance product INGENIUM from Insurance Solutions Corporation SOLCORP . LTC Replatforming deals with developing a 'Total Long Term Care System' for Metlife. This will replace the current LTC system in Clipper.
• LTC deals with re-plat forming of current Long Term Care System from Clipper to a web-based product INGENIUM by customizing INGENIUM for LTC and participating in the initial requirements phase, Logical Data model, Physical Design. Development which includes Requirements, Project Startup, Design, Construction/Unit Testing, Integration Testing, Delivery and Project Completion.

Responsibilities:

• Involved in the System Analysis, Design and Development of the project.
• Created List, Group report, Master and Detail, Cross Tab Drill-Through.
• Created Cascade prompt.
• Involved in creating Reports using Cognos Report studio/Query Studio.
• Created the reports daily, weekly and monthly basis.
• Provided client reporting Batch , Scheduling On-Demand scheduling.
• Created weekly, monthly, quarterly and yearly reports.
• Reporter Operations such as Sum and Average.
• Exception highlighting, Sorting, Ranking.
• Changing filters, layers and measures.
• Customized data by adding Custom calculations, summaries and functions.
• Used SQL tools like TOAD, SQL Developer, SQL PLUS to run SQL queries and troubleshoot.
• Created Database and Tables structures for storing user information in SQL Server 2005.
• Developed Stored Procedures and functions to accomplish several computations.
• Involved in Testing and Debugging.
• Involved in designing of Test Plans, Test Cases, Executed Test Cases.
• Created and managed Jobs and schedules.

Environnent Cognos ReportNet1.1/8.3, Report Studio, Query Studio, Cognos Connection, Framework Manager, Cognos Scheduler, Oracle 8i/9i, PL/SQL, SQL Server, HTML, MS-Access, MS- Excel.