PROFESSIONAL EXPERIENCE:

Confidential

Sr. Cognos developer

Responsibilities:

• Interface with client - side Actuaries, Modelers, Cognos Administrators, and Cognos Data Modeler to compose the Conceptual Data Model and Designs using Cognos Bl, Tableau, Qlikview for report development. Prepare detail design documents by translating the business requirements into high level and low-level technical design documents. Serve as technical lead enabling new and existing tenants on enterprise BI platforms. Responsible for installation, configuration, Cognos system upgrading and maintaining Cognos 10 BI to Cognos 11 Analytics platform in a distributed windows environment
• Develop and maintain custom applications for maintenance and scheduling purposes using Maintain Windows servers including patching, disaster recovery, and security Work with system admin and network teams to troubleshoot any system level issues impacting application health Promote, implement, document, and communicate BI best practices and
• Standard Operating Procedures Provide support for BI developers with connection to data sources (SQL, Oracle, Sybase, Hive and Hadoop). Performed structured peer reviews and walkthroughs during the SDLC cycle for all the new projects to understand the complexities and project impact on the application. Analyze technical feasibility and functional suitability of the enhancement requirement and provide consultation and recommendation of best possible solution to Business. Interact with integration infrastructure team from other parts of world (Asia, EMEA and Latin America) and collaborated with
• Business Analysts/Users and Subject Matter Experts to resolve critical issues for the new product design and implementation. Prepare reports and dashboards for support activities using Cognos Analytics, Tableau, Qlikview and external data from Databases (HlVE, SQI Server, Oracle, Redshift). Prepare Unit Test cases and perform regression testing before delivering the application. Responsible for planning all the activities that includes enhancements of IBM Cognos Bl, Tableau, Qlikview Applications, New Cognos Bl, Tableau, Qlikview server installations.

Confidential

Sr Cognos Developer

Responsibilities:Genpact

• Collaborate with Business Analysts and Stakeholders to gather requirement and provide IBM Cognos Business Intelligence (BI) design to formalize solutions and help business to enhance its scalability using IT enabled tools. Utilized IBM Cognos BI and MicroStrategy BI for Planning, Budgeting and
• Forecasting applications to enhance business capabilities. Create framework manager data relational models, DMR models, Packages and Complex dashboard reports to provide accurate information quickly to the organization. Analyze designs and builds reports, data marts and customized data by adding calculations, summaries and functions in the Framework Manager. Troubleshoot production issues and deep dive in Data level issues for the issue resolution as Citi - Insight has franchise-critical data for Citigroup. Maintain and provide code suggestions to Development teams that allow receiving data from various Citi data sources, analyzing and debugging any inconsistencies within the data received from various upstream systems and providing appropriate fix to improve the data quality prior to being loaded to the main stream system like CITIINSIGHT. Monitor performance statistics such as process execution times
• Data block usage partition utilization and memory consumption by enabling traces in and coordinating with the DBA and the shared technology teams. Ascertain and optimize the query/process performance by tuning the data extraction process defined in CITIINSIGHT reporting and Cognos and MSTR cubes are running on the Database infrastructure Develop and maintain Cognos reporting, querying and analysis solutions and Work closely with database and reporting technicians to build and support the information environment. Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians. Develop, maintain Framework Manager Models and Reports and Provided support L2 and L3 Develop and implement reports queries to help drive business processes from CQM to DQM (Dynamic Query Mode) process and Fill on Adhoc data and reporting requests.

Confidential

Cognos BI Developer

Responsibilities:

• Develop and maintain Cognos reporting, Dynamic Models, querying and analysis solutions. Developed TM1 cubes, dimensions and TI processes as per the business requirement. Created alternate hierarchy based on the Business requirement. And Added new profit center and cost center based on the business requirement. Load the data into the TM1 cubes, done the data validation process after loading the data in to the TM1 cube. Daily monitoring and run the processes. Creating Backup Folders in the Production, Development and acceptance servers. Creating user accounts and maintaining their credentials. Providing development services using Cognos TM1 for H&M team and ensure that they are delivered on time and bug free. Providing application management support to Cognos TM1 in the production environment and ensure that the Development & TEST infrastructure are operational. Providing feasible solutions to queries/clarifications raised by application owners, users for the application. Have taken full responsibilities of solving the second - and third-line calls. Understanding their OLAP data and their reporting requirements. Trained in TM1 Performance Modeler, Architect, Web, and done TM1 admin works. Cognos 11 environment installation and configuration, upgrade the version with fix packs and deploy the models, packages and report from one environment to another. Develop, maintain Framework Manager Models, Dynamic Cubes and Cognos DQM Reports. Planning and budgeting for this
• BO to develop cube using Cognos Integrated Cognos TM1 with Cognos BI and performed BI Reporting. Work closely with database and reporting technicians to build and support the information environment. Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians. Provide status on issues and progress of key business projects. Responsible for preparation of High level and Low-level design documents and providing estimates and develop functional and technical design documents. Provided Production Support for Applications and Models in Production. Develop and implement reports queries to help drive business processes from CQM to DQM process. Fill adhoc data and reporting requests. To create data models based on Functional Reporting Requirements, Technical reporting requirements. Coordinating the Production release and other deployment activities. Keeping all the stakeholders updated about the daily assigned. Gain functional and technical expertise in the assigned application area

Environment: Cognos Analytics, Cognos TM1, SSAS Cubes and Cube Designer Informatica, Netezza

Confidential

Cognos BI Developer

Responsibilities:

• Develop and maintain Cognos reporting, querying and analysis solutions. Work closely with database and reporting technicians to build and support the information environment. Collect and analyze information requirements from users, translate those needs into effective solutions and clearly communicate that information to technicians. Develop, maintain Framework Manager Models and Reports. Provide status on issues and progress of key business projects. 6.Develop and implement reports queries to help drive business processes and fill adhoc data and reporting requests.
• To create data models based on Functional Reporting Requirements, Technical reporting requirements Update stakeholders on daily assigned tasks Gain functional and technical expertise in the assigned application area Following SDLC life cycle for new enhancements.

Confidential

Cognos BI Developer

Responsibilities:

• Worked on the development of Cognos reports (8.4) & Cognos10 and upgraded reports and packages and FM from Cognos 8.4 to Cognos 10. Worked on enhancement of the Cognos reports, cubes and resolving the incident or problem tickets raised by business analysts. Responsible for daily Interacting with the clients to understand and freeze the business requirements for any new work allocated. Created Analysis documents and Estimation plans based on the complexity of the work allocated for the resources. Unit test Plan and Unit test case documents are created for unit testing of Cognos reports and Review/
• Design Checklist is maintained, if necessary To ensure all the deliverables are made on time with minimal defects and to ensure high quality.

Confidential

Cognos BI Specialist

Responsibilities:

• Worked on the development of Cognos reports (8.2) & Cognos 10. Worked on enhancement of the Cognos reports, cubes and resolving the incident or problem tickets raised by business analysts. Responsible for Interacting with the clients to understand and freeze the business requirements for any new work allocated.
• Created Analysis documents and Estimation plans based on the complexity of the work allocated for the resources. Unit test Plan and Unit test case documents are created for unit testing of Cognos reports and Review/ Design Checklist is maintained, if necessary To ensure all the deliverables are made on time with minimal defects and to ensure high quality.

Confidential

Software Engineer

Responsibilities:

• Responsible for the development of Cognos reports/packages for new requirements under Pfizer Global concur expanse management Worked on enhancement of the Cognos reports/ packages for existing applications in production and resolving the incident or problem tickets raised by business analysts. Interacted with the business to understand and freeze the business requirements for any new work allocated.

  Designed and developed reports providing the estimations that calculates work hours for an incident or problem ticket to complete. It basically decides on the complexity of Cognos Reports, which is the number of objects involved in each Reports.