SUMMARY

• Over 10 plus years of professional experience in Information Technology with expertise as Cognos Senior developer /Lead /Architect, Business/data Analyst using Cognos Framework Manager, Report Studio, Cognos PowerPlay, Data Warehouse/Data Mart, PowerPlay Enterprise Server, PowerPlay Transformer, Cognos Tm1, Cognos Impromptu and Business Intelligence tools.
• Worked on the complete Life Cycle Development process SDLC using Cognos 10.2,Cognos11,Tableau 9.3, IBM Cognos SDK as a BI tool.
• Experience in gathering end - user business requirements, providing specific direction, and training the Business users.
• Extensive experience with Datawarehousing implementations
• Experienced in multi-dimensional modeling, cubing, DMR, business analytics, workspaces, DQM, planning, dimensionally modeled relations, Framework Manager, Query Studio, Cognos Connection, Analysis Studio, Transformer, PowerPlay, Event Studio and Report Studio using Cognos 10.2.
• Extensive experience building dashboards using Cognos 10.2 Go Dashboards and Cognos 10 Business Insight.
• Experience in various Mappings, Mapplets and Transformations, scheduling sessions and batches for ETL process using Informatica, Cognos Data Manager and SSIS tools.
• Hands-on experience in building simple to complex reports in Report Studio like Dashboard Reports, Charts, Master-Detail, Self-Drill through, complex crosstabs, bursting, etc.
• Proficient in usage of Cognos Connection, Query Studio and Analysis Studio workspace, workspace advanced,Cognos Enterprise, CAFÉ (cognos analysis for excel) as well as documentation. Having Knowledge on emerging technologies’ like Bigdata and Hadoop
• Excellent analytical and logical programming skills with a good understanding of the conceptual level. Possesses excellent written and verbal communication skills.

TECHNICAL SKILLS

BI Tools: Cognos 10.2.2 Report Studio, Cognos ReportNet, Cognos Business Insight, Cognos Analysis Studio, Cognos 8.1/2/3/4,Cognos TM1 10.2, Cognos Planning 10.1, Framework Manager, PowerPlay Transformer, Query Studio, Cognos Enterprise, Impromptu Web Reports, Cognos SDK 8.4, SDK, PowerPlay Enterprise Server, Turbo Integrator, SSRS, SSAS, SSIS, Qlikview, Tableau,Business Objects,SAP

ETL Tools: Informatica Power Center/ Power Mart, SSIS, Cognos Data Manager, DataStage, Hyperion Essbase

OS: Windows, UNIX (Sun Solaris, AIX, HP-UX, Linux)

GUI: TOAD 8.0, Oracle Developer 2000 (Forms 5.0/4.5 & Reports 3.0/2.5), IBM Visual Age for Java, JBuilder

Tools: ERwin Data Modeler, Excel, PowerPoint, Visio, Rational Rose, SQL* Plus, SQL* Loader

RDBMS: Oracle 12/11/10g, 9i, 8i, DB2 UDB, MS Access, SQL Server 2005/2000, Teradata

Languages: Java, Servlets, EJB, JSP, .NET, C#, ASP, Confidential -SQL, JavaScript, HTML, XML, SQL, PL/SQL, CGI-PERL

PROFESSIONAL EXPERIENCE

Confidential, Weston, Florida

Senior Cognos BI Consultant

Responsibilities:

• Using DataVault and SSIS for the ETL to migrate the DB. Analyze the existing Cognos Reports and help in migration to identify the source tables for migration
• Conduct business analysis, requirements gathering and develop new Supply Chain and financial daily consumption Reports in Cognos report studio
• Directly interact with business users on one on one basis understand the requirements and create Cognos reports .
• Participate in Client Meetings/JAD sessions/User Acceptance Testing /Project management /effort estimation and Project Tracking
• Develop Cognos Framework Model and Validate the Data in the migrated environment
• Reverse engineer Tableau / Cognos Dashboards and Reports
• Create test case documents and queries, and review the data requirements in different environments.
• Worked on SCD type2 Data models, Data / Gap analysis in various environments and suggest best approaches to team in resolving the data issues
• Create Design documents and Lineage documents and participate in the KT sessions

Environment: Cognos 10.2.2,Cognos11, Tableau 9.3, Sql Server, SQL Server Management Studio, Report Studio,Query Studio, Cube Designer 10.2.2,Microsoft Excel,HP ALM, Visio, PowerPoint, Erwin, Cognos Framework Manager 10.2, Transformer 10,workspace

Confidential, Deerfield, Illinois

Senior Cognos BI Consultant

Responsibilities:

• Conduct Business analysis, Requirements gathering to develop new Reports and Dashboard and create high level design documents and technical specifications.
• Communicate with staff or clients to understand specific system requirements. Provide advice on project costs, design concepts, and/or design changes.
• Document design specifications, installation instructions, and other system-related information.
• Deploying business intelligence applications using Cognos Query, Analysis and Report Studios.
• Design, develop complex reports, dashboards, and scorecards and schedule reports in IBM Cognos 10.2.2
• Reverse engineer Tableau Dashboards and Reports
• Design and review Technical Design Documents and queries through onsite/offshore mail coordination.
• Participate in daily /weekly status calls and meetings to discuss the project issues and work with all the teams to close the issues.
• Used HPALM to log the defects and fix them as part of Quality Assurance
• Logical and Physical data modelling, OLAP analysis and cube development with cognos Dynamic cubes
• Performed analytics using Active reports, rave visualisations .worked in resolve data, system issues and performance issues

Environment: Cognos 10.2.2, Siebel, Sal Server, Tableau 9,Cognos Tm1 10.2,Event studio, Oracle SQL Developer, Report Studio,Query Studio,Analysis studio,SAS,Qlickview, Cube Designer 10.2.2,Microsoft Excel, Visio, PowerPoint, HP ALM, Erwin, Cognos Framework Manager 10.2, Transformer 10,workspace and workspace advanced,CAFE (cognos analysis for excel)

Confidential, Austin, Texas

Cognos BI Architect/ Lead Developer

Responsibilities:

• Worked on Cognos Advanced and Workspace Advanced Business Insight to create Executive Dashboards and Active Reports.
• Upgraded/Migration environment from 8.2 to 10.2 and tested the reports.
• Used SQL for report design and development
• Worked on Life Cycle Manager in upgrading the Report Studio and Query Studio Reports.
• Performed requirements gathering and developed new Reports and Dashboards.
• Worked with IBM Cognos support as part of logging bugs and enhancements.
• Created reporting template to be used by Report Studio developers. Created custom portlets and deployed them.
• Modified system configuration files and customized Cognos 10 portal and added enterprise logos.
• Worked on Cognos DQM model enhancements and changes to framework model.
• Documented the flow of data across various systems in the organization and proposed new changes.
• Made enhancements to the existing Data Manager Packages and SSIS packages.

Environment: Cognos 10.2, SQL Server 2008, Cognos Tm1 10.2,Report Studio, Linux, Cognos JavaScript, Cognos SDK API, Supply Chain Methodoligies,Cognos 10.2 Framework Manager, Informatica, Query Studio, SSRS, SSIS, SSAS, Cognos Metric Studio, Analysis Studio

Confidential, Indianapolis, Indiana

Cognos BI Architect/Lead Developer

Responsibilities:

• Created detailed Cognos technical documents based on Cognos architecture and Functional Requirement Specifications (FRS)/System Use Cases (SUC).
• Gathered business requirements, performed data analysis, created mapping documents and conducted code reviews.
• Performed source to target data mappings for the SSIS ETL and Cognos Reporting teams.
• Designed and managed physical and logical data models of enterprise data warehouses, data marts and operational data stores.
• Involved in daily meetings and calls with various teams for the project development status and issues.
• Upgraded the Cognos 8 reports to Cognos 10.2
• Conducted performance tuning of the reports based on the report queries generated Confidential the database level.
• Analyzed and debugged the data issues with the SSIS ETL jobs.
• Monitored data quality, resolving problem data issues with SSIS ETL jobs and ensuring timely updates.
• Improved cube build time and access time by consolidating data and incrementally updating the cube.
• Monitored SSIS ETL jobs and packages.
• Installed and configured Cognos 10, Oracle and Apache on a distributed environment
• Administered the Reporting environment
• Scheduled and refreshed reports and Burst Reports according to user requirements in Cognos Connection and sent the reports through email feature.
• Actively involved on C-10 migration project. Created the regression test plan.
• Installed and configured C-10.2 on distributed servers. Deployed Cognos Content from Test to QA to UAT through to Production.
• Worked with architecture and configuration options for Cognos Gateway, Dispatchers, Content Manager and Audit Stores.
• Worked with IBM Cognos support as part of logging bugs and enhancements.
• Created reporting template to be used by Report Studio Developers. Created custom portlets and deployed them.
• Modified system configuration files, customized Cognos 10 portal and added enterprise logos.

Environment: Cognos 10.2, Cognos TM1 10.1, SQL Server 2008, Report Studio, Cognos Data Manager, Linux, Cognos JavaScript, Cognos SDK API,COGNOS 10.2 framework manager, COGNOS Data Manager Designer, Informatica, Query Studio, SSRS,SSIS, SSAS, COGNOS Decision Stream, Cognos Metric Studio, Analysis Studio, IBM OpenPages, Metric Studio, Event Studio, IBM Rational Insight, cognos mashup services

Confidential, New York, New York

Senior Cognos Developer/Lead

Responsibilities:

• Created around 50 Cognos Dashboard Reports for the Vice President level managers to understand the system based on different KPIs for finance.
• Designed, developed and maintained relational data models, metadata models, reporting and metrics using Cognos 10.1.
• Conducted performance tuning and query optimization in SQL Server environment.
• Created data sources and deployed the contents from QA to Production environments.
• Created a JavaScript to execute a report with multiple parameters and to submit a job and pass parameters to the reports in the job using Cognos 10.
• Deployed the packages and reports from Development to QA and
• Worked on architecture and configuration options for Cognos Gateway, Dispatchers, Content Manager and Audit Stores.

Environment: Cognos 10.1.1 (Report Studio, Query Studio, Analysis Studio), PowerPlay Transformer, Cognos 10.1.1 Framework Manager, Cognos SDK 10.1.1, CognosDataManager, Informatica, Oracle 11i,UNIX, Event Studio

Confidential, Birmingham, Alabama

Cognos Developer

Responsibilities:

• Created detailed Cognos technical documents based on Cognos architecture and Functional Requirement Specifications (FRS)/ System Use Cases (SUC).
• Performed source to target data mapping. Designed and managed physical and logical data models of enterprise data warehouses, data marts and operational data stores.
• Converted over 100 reports from Impromptu to Report Studio (C8) and over 50 PowerPlay reports into Analysis Studio. Created data sources for various phases of the project.
• Followed Cognos best practices by creating database and presentation views. Created cubes and defined rules in Cognos PowerPlay Transformer.
• Accommodated repetitive calculations within the framework for increased performance levels.
• Explored new features and created reports using data and conditional formatting in Query Studio.
• Developed complex reports in Report Studio using advanced features like Cascading Prompts, Drill Through and Bursting.

Environment: Cognos 10.1.1 (Report Studio, Query Studio, Analysis Studio), PowerPlay Transformer, Cognos Tm1 Turbo Integrator, Cognos SDK, Cognos 10.1.1 Framework Manager, Cognos SDK 10.1.1, Informatica, Cognos Data Manager, Cognos PowerPlay, Oracle 11i, JavaScript, UNIX, Event Studio