SUMMARY

• 8+years of experience in Analysis, Design, Development, Testing, Documentation and Implementation of Business Intelligence Applications in Data Warehouse environment with Cognos BI(8.x,10.x, 11.x) tools including Business Intelligence Suite, Cognos Framework Manager, Report Studio, Query Studio, Analysis Studio, and Powerplay Transformer.
• Experience in full life cycle of Software Development such as Analysis, Design, Development, Customization and Testing.
• Excellent proficiency in teh usage of Cognos tools such as Framework Manager, Report Studio, Query Studio, Analysis Studio, and Powerplay Transformer.
• Highly skilled in Cognos reporting framework and interlinked databases/platforms to offer advanced BI solutions to clients
• Hands on experience in Report building (Crosstab, List, Dashboard reports) using Report Studio and Analysis Studio.
• Expertise in creating complex reports using Cognos Report Studio such as List reports, complex hierarchical list reports, Cross - tab reports, Master-Detail Reports, Burst-reports, Drill through reports and Cascading Reports using Prompts, Dynamic filtering, Conditional formatting and involved in reports performance tuning and Troubleshooting.
• Experience in using Event Studio, Triggers.
• Implemented Data Security, Object level and Package Security in Framework Manager and created user classes, roles or groups as per teh requirement.
• Involved in OLTP/OLAP system study, analysis and E-R modeling, developing database schemas including Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Strong in transformer for designing multi-dimensional Cubes using Star Schema. Developed Multi-dimensional Models in Transformer and generating Power Cubes for OLAP that comprise dimensions, hierarchies, levels, categories, and measures.
• Experience in dimensional mapping, creating dimension views to implement teh data security and also grouping and partitioning teh cubes.
• Expert in Writing, Executing, and Maintaining Test Plans, Test Procedures, Test Cases and Test Scenarios.
• Hands on experience in Tracking and Reporting of defects using Defect Tracking Tools like HP Quality Center.
• Manages day-to-day administration of Cognos infrastructure.
• Trained users in using teh Business Insight for dash boarding and teh Business Insight Advanced for Ad-hoc reporting.
• Designed Dashboards using Active Reports V10.1.
• Good understanding of business process in Banking and Financial Services.
• Extensive experience on production support User acceptance test, product support, version control, change management and Troubleshoot/Test issues with existing reports and cubes.
• Experience with Microsoft Windows OS (10, 8, 7, Vista, XP, 2000, and Win NT) and MS Office (Access, Excel, Outlook, Word, PowerPoint, and Visio).
• Highly motivated and adaptive with teh ability to grasp things quickly and possess excellent interpersonal, technical, and communication skills.
• Exceptional listener and an effective communicator with proven ability in multitasking, customer liaising, problem solving and decision making

TECHNICAL SKILLS

BI Tools: IBM Cognos Series 10.2/10.1 BI Suite (Framework Manager, Report, Query and Analysis studios), Cognos Powerplay Transformer 10.2/7.4, Cognos Active reports, AGILE methodology, MS Excel and other MS office products, Business Insight, Dynamic Cubes, Business Objects, Oracle Application Express, Autosys, Tivoli workload scheduler

BI Concepts: Data warehousing, Data and Financial Analytics, Data modeling and query optimization techniques

Big Data Tools: Hadoop, Big data- Datameer

Databases: Teradata, MS SQL, Oracle

Languages: SQL, JavaScript, UNIX Shell Scripting, XML, HTML, COS Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Sr. Cognos Developer/Data Visualization Expert

Responsibilities:

• Collaborated with international business stakeholders from Asia, EMEA, Mexico and LATAM regions for requirements analysis and collecting business reporting needs.
• Led teh offshore team and transitioned teh business requirements to technical design for cognos global solution development, integration, testing, deployment and support.
• Designed and modelled teh Databases transforming raw data into efficient Data marts and structures.
• Create Data mappings for existing reports and build new reports using Nextgen Default System.
• Worked on Agile framework in multiple projects to deliver innovative BI solutions using cognos and Teradata/SQL Server.
• Managed teh complete SDLC and ensured smooth delivery of teh project.
• Automated teh manual business reporting processes and reduced 80% of teh effort required.
• Received accolades from teh team on teh business process improvement.
• Proven expertise in excel for data analysis and validation of business financials.
• Proposed reporting solutions/ideas using big data and Cognos report studio/Powerplay transformer that halped business stakeholders in achieving their strategic goals which eventually improved teh Productivity by 60%.
• Performed Unit testing to ensure quality of teh deliverables and smooth deployment of teh objects from Development to UAT and Production environments.
• Preparation of Unit Test Case (UTC), Unit test report (UTR), Coding Standards document, Naming Conventions document, Defect logs and Review logs.
• Checking teh quality of teh software and determining its degree of compliance to standards.

Environment: Cognos 10.2/10.1.1, Cognos Report Net 1.1, Powerplay Transformer, Framework Manager, Report Studio, Query Studio, Metric Studio, Business Insight and Business Insight Advanced, Active Reports, Teradata, Autosys, Tivoli Scheduler, Oracle Application Express (APEX), UNIX/Linux.

Confidential, Chicago, IL

Sr. Cognos Developer/Data Visualization Expert

Responsibilities:

• Coordinated with business and BA teams to collect teh requirements.
• Analyze teh requirements and conduct feasibility testing.
• Led teh offshore team and transitioned teh business requirements to technical design for cognos global solution development, integration, testing, deployment and support.
• Managed teh complete SDLC and ensured smooth delivery of teh project.
• Core team member of Cognos Business Intelligence implementation team putting strong emphasis on SDLC best practices.
• Led teh offshore team and transitioned teh business requirements to technical design for cognos global solution development, integration, testing, deployment and support.
• Develops/Modify BI reports using Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, and Microsoft Reporting Services, and Performance-point Services.
• Involved in creation of Relational and Multi-dimensional models using Cognos framework manager and created packages, published to teh server for reporting needs.
• Automated teh Monthly cube refresh Process using Command Line options and scheduled it using Windows.
• Generated SQL/MDX and analyzed Cognos SQL, Native SQL to trouble shoot teh report issues.
• Performed Unit Testing to verify if teh Actual Results meets teh Expected.

Environment: Cognos 10.2/10.1.1, Cognos Report Net 1.1, Powerplay Transformer, Framework Manager, Report Studio, Query Studio, Metric Studio, Business Insight and Business Insight Advanced, Active Reports, Teradata, SQL Server, Oracle DB, Dynamic Cubes, Autosys, Tivoli Scheduler, Oracle Application Express (APEX), UNIX/Linux.

Confidential

Cognos Developer

Responsibilities:

• Involved in all phases of teh data warehouse project lifecycle, which includes assessment, businessrequirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Analyzed teh requirement to check teh new system feasibility.
• Designed and modelled teh Databases transforming raw data into efficient Data marts and structures.
• Assisted and worked with ETL developers and data modelers to make sure that model being developed isaccording to teh business requirements.
• Delivered complex visually appealing dashboards including D3 charts, maps, APIs and java scripting that halped business in analyzing and understanding financial data trend/pattern across teh globe to make informed decisions.
• Co-ordinated with teh Project management, Data modeling and ETL teams to ensure quality of teh deliverables which resulted in teh increase of efficiency by 75%.
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
• Designed Cognos Active report for offline business reporting with advanced visualization capabilities.
• Recommended and designed summary tables to be used in reports to optimize performance.
• Wrote SQL scripts and developed audit reports to compare warehouse data with teh staging and source data.
• Creating IQD files using IBM Cognos Framework Manager 10. Building teh model file for cube using IBM Cognos Powerplay Transformer 7.4
• Creating teh reports & charts using IBM Cognos ReportStudio 10. Unit testing and Integration testing with existing environment.
• Update teh code in IBM Rational Clearcase for version management.
• Checking teh quality of teh software and determining its degree of compliance to standards.
• Tuned teh performance of teh reports by creating functions, procedures and packages at teh database.
• Scheduled reports to run daily, weekly and monthly using Schedule Manager.
• Carried out bursting of reports to distribute reports to various end users by email.
• Prepared documentation for teh setup and configuration of teh Cognos application.
• Prepared training documentation for teh developers to accomplish complex tasks in Reportnet.

Environment: Cognos 10.2/10.1.1, Cognos Report Net 1.1, Powerplay Transformer, Framework Manager, Report Studio, Query Studio, Metric Studio, Business Insight and Business Insight Advanced, Active Reports, Teradata, Autosys, Tivoli Scheduler, Oracle Application Express (APEX), UNIX/Linux.EDUCATION