SUMMARY

• 8+ years of IT experience wif sound knowledge and experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and production. Strong understanding of relational database design concepts and indepth knowledge of OLAP solutions, Cognos 10.2.2, Cognos 10.1, Cognos ReportNet, Cognos Impromptu, Framework Manager, Access Manager, Transformer, Power Play, Cognos Visualizer, Cognos Scheduler, IWR, Cognos Query, Cognos Upfront.
• Experience wif Cognos Analytics 11 (Report, Dashboard, Data Module and Stories).
• Experience in installation and configuration of Cognos 10.2.2, Cognos 10.
• Experience in designing models wif Framework Manager involving Relational Models and Dimensional models.
• Deployed packages and reports from one environment to another environment (Dev, QA and Prod).
• Experience working in Data Mart and Data Warehouse kind of environment.
• Experience in converting MS Access Reports to Cognos Reporting from MS Access Database.
• Experience in Security Implementation in Cognos8, ReportNet, on various levels such as User level, Object Level, Row Level Security Implementation.
• Experience in installation, configuration and customization of different Cognos Environments especially Cognos TM1
• Familiar wif TM1 rules editor to create various calculations.
• Expertise inTurboIntegrator processes to load and retrieve data from database tables and other data sources, creating complex Active Forms.
• Expertise in Building Cube, Dimensions using TM1 Turbo Integrator processes.
• Good experience wif Data warehouse concepts, Star Schema, SnowFlake Schema
• Developed OLAP applications using Cognos suite of tools and extracted data from the enterprise data warehouse to support the analytical and reporting for all Corporate Business Units.
• Implement large - scale data ecosystems including data management, governance and the integration of structured and unstructured data to generate insights leveraging cloud-based platforms.
• EUsed Cognos SDK to integrate the reports and java script.
• Experience on Running the SDK Scripts on Security.
• Experience in development wif TM1 and PAX 2.0
• Experience in providing support to PAX
• Experience working wif dimensional modeling, including facts and dimensions, star and snowflake schema and OLAP tools and techniques
• Experience wif IBM Cognos SDK development and Business Intelligence Technologies.
• Good understanding of RDBMS concepts and experienced in writing queries etc using Oracle, MS SQL Server, Teradata and IBM DB2 UDB.
• Developed PL/SQL database stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.

TECHNICAL SKILLS

BI Tools: Cognos Analytics 11.0.6/11.0.9 , Cognos Series 10.2.2/10. 1/8.4/ BI Suite, Go-Office Report Net 1.0/1.1 MR2, Impromptu6.0/7, Upfront, Access Manager, Cognos Scheduler

OLAP Tools: Cognos TM 1 10.2.2/10.1/9.4 , Architect, Turbo Integrator, Perspective, TM1 Web, Planning Analytics, PAX, PAW

Operating Systems: Windows 95/98/NT/2000/XP7/8, UNIX (Sun Solaris), AIX

Languages: C, C++, SQL, PL/SQL

Databases: Oracle8i/9i/10g/11.x, MS SQL server 2000/05/10/12 , DB2 UDB, Teradata 13.x/14.x/V2R6

Development Tools: TOAD, SQL Query Analyzer

Web Technologies: HTML, XML, JavaScript, VB Script, Microsoft FrontPage

Microsoft Tools: Microsoft Office, Visio, MS Excel, MS Word, MS Power Point

Other BI Tools: Tableau, Microstrategy, Power BI, Business Objects 5.1

Methodologies: Ralph Kimball’s Data Modeling, Star and Snowflake Schema

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr Cognos Developer

Responsibilities:

• Explored new features of Cognos 11 and given training to users on how to use Cognos 11 Analytics.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Facilitates root cause analysis of system issues. Works wif experienced team members to conduct root cause analysis of issues, review new and existing reports and/or perform unit testing.
• Metadata creation, creating report specifications, integration, test planning, testing and implementation support.
• Create new models and cubes using a variety of data sources available in Cognos 10.
• Capture analytical requirements through collaboration wif business analysts and data experts.
• Translate requirements into business intelligence solutions.
• Working wif Cognos BI Reporting tool including and not limited to Cognos UI, Reporting Studio, Query Studio, Analysis Studio, Drill through reports, Framework Manager, Cognos Workspace
• Created new reports, maintain existing reports, and troubleshoot performance and design-related issues using Report Studio.
• Created various Reports like List Reports, Cross tab Reports, Charts, Drill-Down and Drill-Through Reports
• Development activities from gathering requirements, designing solutions, and developing code. Assist during project release / deployment
• Design and develop Training data metadata models catalogs, transformer model and packages using transformer and Framework Manager respectively.
• Deploy Cognos content from Development environment to Production environment.
• Analyze business requirements from users and business teams.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Identifies ideas to improve report performance and impact availability. Resolves complex technical design issues.
• Work on conditional Formatting in Report Studio and generating multipage Reports.
• Create relational models in Framework Manager using best practices.

Environment: Data Stage 7.5.3, Tableau 8.1/2018.1, Windows Server, Teradata 12(Teradata View Cognos Analytics 11.1/11.0.6/11.1 , Cognos 10.2.2 (Cognos Workspace, Cognos Workspace Advance, Report Studio, Query Studio, Analysis Studio and Event Studio), Cognos Connection, Frame Work Manager Point and Teradata SQL Assistant), Data Stage 8, Windows Server, Oracle 10g, Toad

Confidential, Fargo, ND

Senior Cognos BI Developer

Responsibilities:

• Work on Cognos to develop reports for Claim center, Policy Center and Billing Center.
• Creation of policies and procedures for Quality Assurance and BI change management.
• Design and develop Cognos solutions using IBM Cognos, Guidewire DataHub, Dynamic Cubes and Data Modeling.
• Implement end to end Guidewire DataHub/InfoCenter for conversation of Property and Casualty Insurance Legacy system software for Policy and Claims center.
• Analyze and review business requirements and rules, gather information and determine the project scope, effort estimation, timeline, and software development strategy.
• Developed Relational models using Framework manager for Policy and Claims.
• Create different types of reports like List, Cross-tab, Charts, Scorecards, drill-thru, Master-Detail Reports, Cubes and dashboard report according to the report specification documents and business requirements.
• Develop various kinds of prompts and filter to increase retrieval speed wifout compromising on the scope of BI reports.
• Develop solutions using Dashboard, Workspace Reports, Data modules and Active reports& Report Studio reports.
• Used layout component, bookmarks, rendering variables, master detail relationship for various reports.
• Provide training and assistance to users for generation of ad-hoc reports.
• Design and implement technology best practices, guidelines and repeatable process.
• Ensure dat all project deliverables meet quality objectives in data, functionality, performance and stability.
• Integrated Cognos Reports wif share point portal for central location access.
• Leading Guidewire Policy and Claim data conversion effort, Converting data from Legacy systems into Datahub and Designing the Cognos Active Reports for the offline reporting who are using IPAD’s.
• Managed Financial Reporting solutions using Cognos Planning & TM1
• Tested developed Reports by the peers against the Product and implemented test plans
• Worked on report neutralization, performance tuning of the existing reports

Environment: Cognos Analytics 11.1/11.0.6/11.1 , Cognos 10.2.2 (Cognos Workspace, Cognos Workspace Advance, Report Studio, Query Studio, Analysis Studio and Event Studio), Cognos Connection, Frame Work Manager, Data Stage 7.5.3, Tableau 8.1/2018.1, Windows Server, Teradata 12(Teradata View Point and Teradata SQL Assistant), Data Stage 8, Windows Server, Oracle 10g, Toad

Confidential, Atlanta, GA

Sr. Cognos BI Developer

Responsibilities:

• Involved in requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Involved in requirement gathering from Business Users and Developed Technical Documentation for the Business and Team. Analyzing the specifications provided by the clients and developing specification documents for reports as per client requirements.
• Installed and configured Cognos 10.2.2 wif multi-tier architecture.
• Migrated reports and packages from Cognos 8.4 to Cognos 10.2.2
• Fixed the issues and bugs in migration process.
• Migrated content from Dev to QA and Prod.
• Troubleshoot and resolve the applications or integrations issues.
• Admin roles involve giving access to users for various groups and roles, monitoring the servers, on support calls etc.
• Worked on the tickets open by users on various issues.
• Followed agile methodology for both the projects.
• Developed Cognos Framework Manager Model and packages for metadata layer using Cognos best practices.
• Conduct troubleshooting, root cause analysis, Data Validation, and problem resolution for Cognos Framework Manager models/packages
• Added business rules to the Cognos Framework models by creating calculations, filters, prompts, session parameters and parameter maps, cardinalities.
• Implemented object/row/package level security in Cognos Framework Manager models
• Conducted training session on new features on Cognos 11.
• Used HTML items and Java scripts in the Dashboards and reports to make them every interactive and show more content during layering functionality.
• Created drill through reports for the pie charts created in the interactive dashboard as per the requirement.

Environment: Cognos Analyitcs 11.0.6/11.0.9 , Cognos 10.2.2/8.4/8.3 (Frame Work Manager, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Workspace, Advance), Power Play Transformer 10.2/8.4, Informatica 9.6, Oracle 11.x/10g, Teradata 13.x/14.x, SQL Server 2010, Business Objects, Oracle Apps R12

Confidential, Arlington, TX

Sr. Cognos BI Consultant

Responsibilities:

• Participated in meetings wif client to understand and gather new technical requirement and conducted feasibility tests for the new 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 assigned work to onshore and offshore resources.
• Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Delivered Advanced Multidimensional reporting solutions using Report Studio.
• Delivered advanced/ complex reporting solutions such as Dashboards, Scorecards and Standardized Reporting (including the bursting of reports) using Cognos 10.1.
• Handled Critical situations in QA and Production Support in the final Stages of the project.
• 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.
• Worked extensively in development of Framework Manager Model for development of dashboard style complex reports like Dashboards, Region Enrollment, Division Enrollment, Milestones and Management Reports throughout the project.
• 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.

Environment: Cognos BI 10.1 (Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Business Insight and Event Studio), Cognos TM1 10.1.1 (Architect, Contributor, and Perspective), Informatica 8.6.1 and Oracle 10g.