SUMMARY

• 14+ years of experience in Business intelligence technologies.
• Good Knowledge on Data warehousing concepts.
• Worked extensively on Cognos tools like Query Studio, Report Studio, Analysis Studio, Event Studio.
• Creates, modifies, enhances and maintains Framework Manager Models within Cognos BI
• Worked on Cognos migration from Report net to Cognos10 and Cognos 10 to Cognos 11.
• Good Knowledge on SQL
• Experience in Product Support.
• Complete understanding of SDLC.
• Good Knowledge on Unit Testing/Busines functionality testing of the developed reports.
• Experienced in Functional specifications gathering and Report Designing.
• Assisting the project in process documents like Technical Specification, Coding standards, Code review checklists and other process standard documents related to reports.
• Domain Knowledge on Insurance Broking Services. (claims Settlement, Policy
• Analyzing)
• Domain Knowledge on U.S. Health Insurance & U.S. Workers Compensation.
• Possess ability for critical thinking, analysis. Good interpersonal and communication skills.
• Team - oriented, technically motivated, and creative. User oriented with a desire to learn client’s business requirements

TECHNICAL SKILLS

Technologies: Cognos Analytics 11.1.7/10/8.4/8.2(Report Studio, Query Studio, Event studio, Framework Manager), Tagetik

RDBMS: Oracle 9i,10g, SQL Server 2008, Sybase. DB2

Operating Systems: Windows Family

PROFESSIONAL EXPERIENCE

Application Developer

Confidential

Responsibilities:

• Design and Develop Business Intelligence solutions for Confidential ’s Finance and HR applications using Cognos Analytics (Cognos version 11.1.7)
• Understanding and working on dimensional modeling (normalized and Multidimensional) including under-standing facts and dimensions, star and snowflake schemas and online analytical processing (OLAP) tools and techniques.
• Prepare Business Requirement documents, Technical design documents based on the meetings and sessions with Confidential ’s information analysts, business users and business managers.
• Design and Develop Complex Cognos Business Intelligence Scorecards, Dashboards, Reports and multidimensional Cubes that utilizes the complex underlying data store(s)/ data warehouse(s) / data mart(s).
• Writing complex SQL queries to the oracle Database to fetch the data and validate the data with Cognos products.
• Design and develop complex automated burst reports which will be distributed based on Geographical region
• Using Cognos Analytics to Optimize the key financial and HR applications for performance improvements, operational process changes, automation of manual tasks and elimination of redundancies.
• Perform Cognos admin activities like User managements, dispatchers configuring, taking back up of Cognos objects.
• Schedule Cognos reports, Dashboards with the frequency daily, Weekly & Monthly to deliver to Confidential ’s business users via e-mail and via shared location.
• Perform deployment of Cognos reports, dashboards, and cubes to different Cognos environments like development, testing and production.
• Support and maintenance of all the Cognos objects in testing, User acceptance (UAT) and production environments to make sure minimal outages and on data issues occurs.
• Resolving issues related to LDAP which is integrated with Cognos.
• Develop Java Scripts for Cognos prompt pages
• Educate and train business users to use Cognos reports, cubes, scorecards and dashboards to for making decisions
• Attending daily, weekly status meetings with onshore/offshore teams.
• Responsible submitting daily status reports to Confidential management.
• Hosting meetings with all stake holders to ensure quality of the Finance and HR applications is not compromised.

Confidential

Senior Cognos Application Developer

Responsibilities:

• Provide the Technical design based on the business requirements, development of new
• functionality and enhancements to the existing functionality to their business applications
• that leverage the IBM Business Intelligence integrated product suite.
• Responsible for analysis, design, implementation and maintenance of Cognos BI using my
• expertise in Data warehousing, BI technologies and methodologies.
• Gather Business requirements for cognos reports.
• Prepare Business Requirement Documents. (BRD)
• Prepare Technical Design documents (TDD)
• Design and develop cognos reports.
• Design and develops cognos frame work meta data models
• Schedule the reports with the frequency daily and Weekly to run the reports at a latertime.
• Support UAT.
• Support and Maintain Cognos Reports.
• Manage software upgrades, patches and back-up as needed. Work with Level 3 support,
• Development team to provide application support and bug fixes as needed
• Handling Deployment process, to promote the cognos reports /packages across various
• environments.
• Responsible, Attending weekly status meetings with onshore/offshore tea

Environment: Cognos, Oracle, Cognos TM1, IBM DB2,Qlikview, Cognos Admin

Confidential

Senior Cognos Application Developer

Responsibilities:

• Monitoring of Cognos and TM1 windows servers.
• Migration of Cognos Objects (Reports, packages, Images, Drill through etc.) from Development to UAT to Production.
• Using Cognos SDK cleaned Cognos users 'My Folder' objects.
• Cube building and publishing in Transformer by using .pyj files and .mdc files.
• Cognos Data source creation in Cognos connection and Catalog Data sources on Cognos Servers.
• Maintenance and Monitoring of Cognos log files, Checking of ISS logs, EWR updates, security patch updates.
• Checking Cognos environment monitoring, dump files, disk space, server health (CPU and memory usage etc.)
• Assigning security groups for Cognos objects in Dev., UAT & Production.
• Assigning security groups for Cognos TM1 objects in Dev., UAT & Production.
• Reboot of Cognos and TM1 servers
• Starting and stopping Cognos and Cognos TM1 services.
• Publishing Cognos environment impact report to business user when environment is down.
• Designing Cognos reports by using Audit database to monitor the work load on Cognos servers.
• Scheduling of Cognos reports, Cognos jobs and supporting of Audit reports.
• Migration of Cognos TM1 objects (chores, processes, rules etc.) from Development to UAT to Production.
• Designing Event Studio Reports to send e-mail to users for the failed scheduled reports.
• Import Rights/ Refresh rights in TM1 Web Applications
• Database Connections to Cognos TM1
• Activate and Deactivate TM1Chores

Environment: Cognos, Oracle, Cognos TM1, IBM DB2,Qlikview, Cognos Admin

Confidential

Senior Cognos Application Developer

Responsibilities:

• To Understand and acquire knowledge in BO webi, BO Universe & BO crystal reports.
• To implement acquired BO knowledge to migrate the reports from BO to Cognos.
• To design reports as per BO report requirements.
• To validate Cognos FM models as per BO universes.
• To meet report performances as per BO report requirement.
• To support system testing.
• To fix technical review comments on Report.
• To support UAT.
• To attend calls and co-ordinate with onshore BO developers.
• To participate in internal review and status meetings.
• To maintain good relationship with client, onshore IBM team and other Cognos developers.
• To help and guide Junior Cognos developers in the team.

Environment: Cognos, Oracle, Cognos TM1, IBM DB2,Qlikview, Cognos Admin

Confidential

Cognos Application Developer

Responsibilities:

• To Understand and acquire knowledge in BO webi, BO Universe & BO crystal reports.
• To implement acquired BO knowledge to migrate the reports from BO to Cognos.
• To design reports as per BO report requirements.
• To validate Cognos FM models as per BO universes.
• To meet report performances as per BO report requirement.
• To support system testing.
• To fix technical review comments on Report.
• To support UAT.
• To attend calls and co-ordinate with onshore BO developers.
• To participate in internal review and status meetings.
• To maintain good relationship with client, onshore IBM team and other Cognos developers.
• To help and guide Junior Cognos developers in the team.

Environment: Cognos, Oracle, Cognos TM1, IBM DB2, Qlikview, Cognos Admin

Confidential

Tagetik Application Developer

Responsibilities:

• Migration of Cognos reports from Report net 1.1 to Cognos 10.1
• Migration of Cognos reports from Impromptu Web Reporting to Cognos 10.1
• Migration of report schedules from Report net 1.1 to Cognos 10.1
• Based on Impromptu reports, designing Frame work model in Cognos 10 and then using these model to design Cognos 10 reports.
• Creating Framework model and package based on Oracle Stored Procedures.
• Prompt Pages are created in JSP for Cognos 10 reports.

Environment: Cognos, Oracle