SUMMARY

• 15+ Years of experience in information technology industry with a strong background in System Analysis, Design and Development in the fields of Database, Data Warehouse, and Client - Server Technologies. Around 14 + years of experience in Reporting and modeling with Cognos Tools such as IBM Cognos Analytics, Cognos 10x,8x Suite, Cognos Reportnet 1.1.MR3, Cognos Impromptu 7.x/6.x, Hyperion and Tableau 8.x, Informatica 9.x.
• Sound knowledge in IBM Cognos Analytics (Cognos 11.x), Cognos 10.2.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace, Cognos Workspace Advanced, Cognos Transformer 10.X, and Active Reports)
• Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages) and Complex Report building with Report Studio.
• Experience in building Transformer models and publishing cubes in Cognos Connection.
• Implemented business process improvements and maintain effective client service relationships.
• Hands on Experience with Tableau 10.x, Informatica 9.x Abinitio and Hyperion.
• Expertise in OLTP/OLAP/OOAD System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Sound Skills in structured query language (Oracle, SQL).
• Involved in migrating the reports from cognos 7.x series to Cognos 8.x and from Oracle Hyperion to IBM Cognos .
• Involved in ETL mappings for adhoc and structured loads into Datawarehouse tables.
• Expertise in multiple industries such as Banking, Financial Services, Pharmaceuticals, Research, Hotel, Insurance and Retail.
• Familiarity with Big Data concepts, Hadoop, HIVE and R Programming.
• Able to keep abreast with new technology trend in IT industry
• Strong problem analysis and influencing skills
• Lead a team of BI & reporting professionals and provide coaching and mentoring

PROFESSIONAL EXPERIENCE

Confidential

Cognos BI Architect

Responsibilities:

• Work with business partners to define requirements, analyses and propose initiatives
• Development of the technical solutions to meet business requirements
• Create logical and physical data models using best practices and compliance with BI data models (Snowflake, Star Schema)
• Architect Cognos multi-dimensional cube solutions
• Designed and Implemented new dashboards using Active reports and Cognos workspace.
• Developed Active reports for users to use offline and on mobile devices.
• Design and implement security architecture which will include both row level security and object security
• Migrated around 150+ reports from Crystal Reports to Cognos giving advanced features to users to user the report more interactively.
• Responsible for performance tuning and optimization of the systems.
• Review modifications to existing framework models and data models to improve efficiency and performance
• Generated Complex reports in Cognos 10.2.1 report studio including Drill Down reports from DMR modeled Frame work model.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Actively worked in ETL mappings, understating data flows, created adhoc loads.
• Expertise in creating Data Modules and upload files to support self-service BI for end users.
• Created reports and dashboards in IBM Cognos Analytics using datasets, data modules.
• Testing of reports on Cognos 11 and error debugging.
• As part of the engagement, provided coordination of significant incidents to ensure proper analysis is performed and timely and accurate reporting of the incident is affected.

Confidential

Cognos BI Architect

Responsibilities:

• As a BI architect was responsible for all BI solutions across various data sources, design and developing Cognos reports
• Developed high level and low level design plan as per business requirements and Reviewed functional requirements and technical specification and recommended changes if any
• Validated database views and tables of architectural frameworks.
• Developed Framework model and 40+ Report Studio reports based on Business users inputs and with the existing tableau reports.
• Involved as an onsite co-coordinator for all the follow up activities with the client which includes requirement gathering, demos of the developed reports to the business users, understanding data models and security related activities.
• Built complex Report Studio with complex calculations, conditional rendering for Excel and pdf outputs. Also dashboards with using Cognos Business Insight and Advanced.
• Performed query tuning and data modeling to improve performance efficiency.
• Strongly followed agile methodologies and ensured timely deliverables from the team for each sprint.
• Developed and managed working relationships with the different LOBs at the client site and within the organization
• Involved in doing POC reports using Tableau for top management and showcased all the solutions available in Tableau dashboards.
• Worked in other initiatives in the project like data decomposing of source files like SAS reports, understanding attributes required for semantic layer. Identify SOR, tables in the data warehouse and the methods to use the forklift tables for building semantic views.

Confidential

Technical Architect

Responsibilities:

• Create Framework model and Report Studio reports based on Business users inputs and with the existing tableau reports
• Coordinated with the client and took project requirements, demos of the developed reports to the business users, understanding data models and security related activities and feedback.
• Involved in knowledge transfer sessions to understand concepts in various applications we have involved Cognos migration.
• Provided valuable input at all stages of work and created technical and functional design documents.
• Built framework model and complex Report Studio with complex calculations, conditional rendering for Excel and pdf outputs. Also dashboards with using Cognos Business Insight and Advanced.
• Developed, managed and monitored testing and production environment
• Built Cognos Active reports for various applications