SUMMARY:

• 8+ Years of experience in Information Technology with a strong background in Business Intelligence reporting, development, analysis, design, testing and maintenance of Cognos applications, Tableau, Database, Data warehouses, Data Marts and providing solutions for Finance, and Health industries.
• Strong understanding of complete Software Development Life Cycle (SDLC) process including requirement analysis, documentation, development, testing, implementation, and maintenance.
• Experience in Cognos 10 (10.2, 10.1), 8 (8.4/8.3) Suite (Cognos Connection, Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight Advanced, Cognos Workspace, Cognos Workspace Advanced).
• Extensively worked on Framework Manger in creating models and implementing best practices while modifying relationships, resolving the loops and developing Dimensionally Modeled Relational data (DMR/ROLAP).
• Complex Report Building Experience by using Tabular Objects, Tabular SQL, Filters, Customized Prompts, Conditional Formatting and Complex Layouts like Cross tabs, nested Charts and Bursting.
• Proficient in Dash boarding and Implemented Security among various Cognos applications.
• Migration of Cognos reports from 10.1 to 10.2
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms
• Involved in QA process of the developed reports.
• Knowledge of OLTP/OLAP system study, analysis, E - R modeling and Database schemas like Star Schema and Snowflake Schema.
• Experienced in working with MS SQL Server 2008, MS SQL Server 2014, IBM Netezza and MS Access.
• Experience in taking end-user business requirements and translating them into design specifications through Cognos.
• Extensively worked with SQL Queries, Stored Procedures and have good experience in Database Tuning, Database performance techniques.
• Experience in Data migration from heterogeneous database like Excel, MS Access, DB2 to MS SQL Server by using Import Export Wizard and SSIS.
• Strong understanding of data warehousing concepts, principles and techniques. E.g. indexing strategies, schema design, data structures (facts, dimensions, star schemas etc.)
• Excellent Team Coordinating Skills with the Development Teams and Deliverable dates.
• Experience working with offshore team and Leading teams across USA.
• Exceptional analytical, problem solving and communication skills.
• Exceptional ability to quickly master new concepts and technologies.

TECHNICAL SKILLS:

BI Tools: Cognos 10.2, Cognos 10.1, Cognos 8.4/8.3. (Cognos Connection, Framework manager, Transformer, Report Studio, Query Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, Cognos Workspace, Cognos Workspace Advanced), IBM Watson, Tableau Desktop 8.2, Tableau Desktop 10.1.7.

Database: MS SQL Server 2008, MS SQL Server 2014, IBM Netezza, MS Access.

ETL Tools: SQL Server Integration Services (SSIS)

Languages: SQL, JavaScript.

OS: Windows 7, Windows XP and MS-DOS.

Other Tools: eSales, BlueStar, VAS, VMS, Fidelity.

PROFESSIONAL EXPERIENCE:

Confidential, Darien, IL

Sr. BI/Cognos Consultant

Responsibilities:

• Gathered requirements from functional teams and business analysts and translated them into technical design specifications.
• Communicated with the business users for reviewing the developed reports and taking feedback for any updates/improvements.
• Involved in Designing DMR models with Relational Data using Framework Manager
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio .
• Created Tabbed Reports in Report Studio.
• Developed complex reports using drill through and conditional formatting in Report Studio.
• Created Dashboards to present critical company data in a Workspace for Executives of Confidential .
• Provided production support for the existing reports for any changes or trouble shooting.
• Design and creation of Standard and Complex Reports using List, Cross Tabs, Drill Through, Charts, HTML objects and images.
• Developed Conditional Reports and did data-driven formatting and layout.
• Developed summary and detail reports and customized page orientation and pagination for PDF reports.
• Created multi query and multi-page reports.
• Developed complex reports using joins and set operations in report Studio.
• Developed Active reports for users to use offline and on mobile devices.
• Analyzed the data in Workspace Advanced using DMR.
• Worked on Migration of Cognos reports to Tableau.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality for Business Units.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Managers, and End Users.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

Environment: Cognos 10.2, Framework Manager, Report Studio, Cognos Workspace Advanced, Cognos Workspace, Tableau Desktop V10, IBM Netezza, Windows 7.

Confidential, Chicago, IL

Sr. BI Consultant

Responsibilities:

• Gathered requirements from functional teams and business analysts and translated them into technical design specifications.
• Communicated with the business users for reviewing the developed reports and taking feedback for any updates/improvements.
• Developed complex reports using drill through and conditional formatting in report Studio.
• Provided production support for the existing reports for any changes or trouble shooting.
• Design and creation of Standard and Complex Reports using List, Cross Tabs, Drill Through, Charts, HTML objects and images.
• Developed Conditional Reports and did data-driven formatting and layout.
• Developed summary and detail reports and customized page orientation and pagination for PDF reports.
• Created multi query and multi-page reports.
• Developed complex reports using joins and set operations in report Studio.
• Created dashboard Style reports to emphasize on business metrics.
• Developed Active reports for users to use offline and on mobile devices.
• Migration and development of more than hundred Cognos reports from 10.1 to 10.2
• Provided to different business users to develop dashboards in workspace and workspace advanced.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality for Business Units.
• Coded Stored procedures to load, update data tables for reporting purpose.
• Analyze the report queries and optimizing the SQL queries to use indexes.
• Created and documented Change Orders (CO) and Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Responsible for leading 4-6 Cognos Developers on multiple projects across USA and manage resource allocation for reports/dashboards.

Environment: Cognos 10.1, Cognos 10.2, Framework Manager, Report Studio, Query Studio, Business Insight Advanced, Cognos Workspace Advanced, Tableau Desktop V8, MS SQL Server 2008, Windows 7.

Confidential, Naperville, IL

Cognos/BI Consultant

Responsibilities:

• Gathered requirements from functional teams and senior business analysts and translated them into technical design specifications.
• Communicate with the business users for reviewing the developed reports and taking feedback for any updates/improvements.
• Developed complex reports using drill through and conditional formatting in report Studio.
• Gave production support for the existing reports for any changes or trouble shooting.
• Design and creation of Standard and Complex Reports using List, Cross Tabs, Drill Through, Charts, HTML objects and images.
• Developed Conditional Reports and did data-driven formatting and layout.
• Developed summary and detail reports and customized page orientation and pagination for PDF reports.
• Developed complex reports using joins and set operations in report Studio.
• Created dashboard Style reports to emphasize on business metrics.
• Built Multi-Dimensional Models (DMR) with Relational Data using Framework Manager.
• Created Data Layer, Business Layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Setting up cardinality (minimum, maximum & optional), Determents to avoid double counting, support loop joins, optimize data source, and identify dimensions and facts.
• Adding the new Hierarchy to the existing cubes as per the report and business requirements.
• Working with different Regular and time state rollup functions in Power play transformer as per the business requirements.
• Creating the manual categories and special categories to meet the business requirements and reporting needs.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Analyze the report queries and optimizing the SQL queries to use indexes.
• Worked with offshore team of 10 Cognos and SQL Developers.

Environment: Cognos 8.4, Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, MS SQL Server 2008, SSIS.

Confidential, Irving, TX

Cognos BI Developer

Responsibilities:

• Gathered requirements from functional teams and senior business analysts and translated them into technical design specifications.
• Communicate with the business users for reviewing the developed reports and taking feedback for any updates/improvements.
• Created models for ad-hoc querying for the users in Query Studio.
• Designed models in Framework Manager from multiple data sources.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Set up the Security at the package level, object level and data level.
• Developed complex reports using drill through, bursting and conditional formatting in report Studio.
• Worked in a multi environment setup and deployed the reports/packages between DEV, QA and production environments.
• Provided production support for the existing reports for any changes or trouble shooting.
• Documented the work using standard templates.
• Design and creation of Standard and Complex Reports using List, Cross Tabs, Drill Through, Charts, HTML objects and images.
• Developed Conditional Reports and did data-driven formatting and layout.
• Developed summary and detail reports and customized page orientation and pagination for PDF reports. Created multi query and multi-page reports.
• Developed complex reports using joins and set operations in report Studio.
• Created dashboard Style reports to emphasize on business metrics.
• Created burst reports on a single and master details queries to distribute the sensitive data accordingly to multiple users.
• User for creating Ad hoc Reports using Query Studio.

Environment: Cognos 8.4/8.3, Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, MS SQL Server 2008, Windows 2003, Excel, MS Visio.