SUMMARY

• Cognos and IBM Certified with having 10 years of Experience in the Analysis, Design, Development, Administrating, Testing, Maintaining and Implementation of Business application systems for Insurance, Banking, Financial and Retail Sectors.
• Extensive experience on DB2, ORACLE 11g, SQL SERVER2000/2005 & Teradata databases
• Technical expertise in Design and Development of Data Warehouse modeling with a good understanding of star schemas, fact tables, and dimension tables.
• Experience in Installation, Configuration, Monitoring and Managing of Cognos & Oracle on Windows platforms.
• Involved in the Cognos 8.4 /10/10.2 Administration like Creating Datasource Connections, Publishing Transformer cubes to the server as a Package and Publishing FM Packages and Assigning the security for Business User Community and also Deployment of Packages and reports from Development to Production Servers
• Experiences in using SQL, PL/SQL, Indexes, Functions, Procedures, Triggers and Cursors.
• Experience in Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all the complicated calculations.
• Expertise in Cognos Transformer, Framework Manager using dimensional modeling, SDK, Report Studio, Analysis Studio, TM1, Active Reports, Dashboards, Event Studio and Query Studio.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries.
• Excellent in problem solving, logical and analytical abilities.
• Good Exposure of interaction with client, clear understanding of business requirements with excellent interpersonal, communication and organizational skills.
• Have expertise in posting and executing test cases in HP Quality Center and defect handling.
• Lead GM Development team of 5 members with outstanding client admirations and provided maintenance for several months.
• Created and deployed Work orders and resolved problem request tickets on Remedy incident management (OMAR) tool and Peregrine or using ITSM.
• Expertise in utilizing Secured Shell Client tool for interacting with UNIX operating system, Citrix Client and VPN for remote server connectivity.

TECHNICAL SKILLS

BI Tools: Cognos 10.2 BI, Actuate, Crystal reports.

Databases: Oracle 11g/10g/9i/8.x, SQL Server 2005, DB2, Teradata

Modeling: Erwin, TOAD, SQL*PLUS, SQL Developer

Data Masking Tools: File - Aid 5.3, DMSuite

Languages: SQL, PL/SQL, VB, HTML, XML, Java, J2EE

OS: AIX, Windows 2000/XP/NT, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

Cognos Project Lead

Responsibilities:

• Involved in Designing of complex Dynamic sorting reports.
• Lead the Onshore Teams of 6 Cognos developers.
• Implementing the complex solutions using java programs.
• Meeting various Application owners and understanding their requirements
• Worked on Cognos scheduler password reset issue under single sign on environment.
• Written Java & Java Script Code whenever it is necessary and integrated with the Cognos reports.
• Involved in Cognos & Dmitri E79 reports integration.
• Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all the complicated calculations
• Designing the Reports, Dashboards and Framework Model using Dimensional Modeling based on the client requirement.
• Monitoring Report performance, troubleshooting and system configuration
• Providing technical direction required to resolve complex issues to ensure the on-timedelivery of solutions dat meet customer expectations.

Environment: Cognos 10.2, Oracle11g, DB2, PLSQL Developer, Toad, Dmitri E79, Advanced Java, Windows/Linux.

Confidential, Atlanta

Cognos Lead

Roles and Responsibilities:

• Involved in Design and Development of Data Warehousing model/schema.
• Lead the Offshore Team of 6 Cognos developers.
• Meeting various Application owners in Newyork Life and understanding their currentProblems and providing them a dynamic solution using different procedures.
• Installation and Configuring of servers in client environment.
• Performance tuning of oracle queries and procedures to run the Reports faster.
• Involved in administration of granting and revoking privileges to the customers.
• Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all the complicated calculations
• Designing the Reports, Dashboards and Framework Model using Dimensional Modeling based on the client requirement.
• Integration of Cognos TM1 cube with Cognos BI
• Building TM1 Cubes as per the client requirement.
• Involved in applying security, promotion and support for cognos environment.
• Monitoring Report performance, troubleshooting, diagnostics and system configuration
• Providing technical direction required to resolve complex issues to ensure the on-timedelivery of solutions dat meet customer expectations.

Environment: Cognos 10.2, TM1, Oracle11g, DB2, Toad, Irwin, shell Scripting, windows/Linux, MS Visio, File-Aid, DM Suite, Java.

Confidential, Bloomington

Cognos Lead

Roles and Responsibilities:

• Lead the Offshore Team of 10 developers and 5 Admin’s in 13 applications.
• Meeting various Application owners in Statefarm and understanding their currentProblems and providing them a dynamic Reporting solution.
• Involved in Design and Development of Data Warehousing model/schema.
• Installation and Configuring of servers in client environment.
• Involved in administration of granting and revoking privileges to the customers.
• Designing the Reports, Dashboards and Framework using Dimensional Modeling based on the client requirement.
• Migration of Code from Dev to test and production.
• Integration of Cognos TM1 cube with Cognos BI.
• Building TM1 Cubes as per the client requirement.
• Involved in applying security, promotion and support for cognos environment.
• Consulting on projects and other Development efforts.
• Monitoring Product performance, troubleshooting, diagnostics and system configuration
• Performance tuning of oracle queries to run the Reports faster.
• Provided technical direction required to resolve complex issues to ensure the on-timedelivery of solutions dat meet customer expectations.
• Received several appreciations from client and from IBM for expertise work.
• Maintained 4 IBM offshore teams to co-ordinate for Cognos BI and TM1 Development.
• Creating XML files to extract the Dynamic Text from cognos server to Reports using HTML items and Javascript.
• Written thousand’s of lines of code in JavaScript using HTML items of cognos to implement a new functionality.
• Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all the complicated calculations and dynamic tables to fetch data.

Environment: Cognos 10.2, TM1, Framework Manager, SQL Server 2008, Active reports, Oracle11g, DB Studio, SQL Developer, DB2, shell Scripting, windows/Linux, MS Visio.

Confidential, Dallas

Cognos Lead

Roles and Responsibilities

• Lead the Offshore Team of 6 members in 2 shifts.
• More TEMPthan 2 lakhs Reports are monitored on daily basis and investigating issues in different report schedules / packages.
• Designing the Reports and Framework using Dimensional Modeling based on the client requirement.
• Monitoring deliverables having critical SLA’s (Service Level Agreements).
• Interacting with customers to resolve the Application / Reports related issues
• Involved in Application health checks after deployment.
• Preparing solution trees and error logging database which helps in Problem and Incident Management.
• Writing user defined stored procedures.
• Involved in fixing of errors identified during production support.
• Provide solution for the Customer Service Requests which requires application related attention.
• Troubleshooting the causes of daily production job failures.
• Used Quality Control tool to raise defects and assign it to Development team
• Interacting with the Client for all the application support issues, Knowledge transition and for all the gaps at different Levels.
• Installation and Configuring of servers in client environment.
• Involved in Cognos administration of granting and revoking privileges to 1100 customer globally.
• Solving the problem tickets by interacting with the customers
• Designing the Model and reports based on the client requirement
• Generating daily Reports / Cubes for Heinz Account.
• To prepare and Put the Task in ManageNow Tool to promote the Reports from UAT to production.
• Preparing the Schedule for the Reports using RM(Report Management) Tool and Event studio based on the customer requirement.
• Tuning the Cognos server / Reports to extract best performance.
• Deploying the standard Report by changing the required labels based on the customer Requirement Document.

Environment: Cognos 8.4, Transformer, SDK, Toad, Analysis Studio, Event Studio, Oracle 10g, SQL Server 2005, MS Visio

Confidential

Cognos Lead Consultant

Roles & Responsibilities:

• Interacting with the Client & Onsite Coordinator for all the application support issues, Knowledge transition and for all the gaps at different Levels.
• Installation and Configuring of servers in client environment.
• Involved in the design and development of several Reports, Dashboards in Actuate, Cognosand E-Spread Sheet designer Reports.
• Routing the problem tickets by acting as duty developer depending on the availability of the primary/secondary developers.
• Preparing of Framework Manager model using Star schema.
• Worked on E.Spreaddesigner & Maximo reporting Tool based on Customer Requirement.
• Prepare and Place the Task in ManageNow Tool to promote the Reports from UAT to production.
• Prepare the Schedule for Reports using RM Tool based on the customer requirement.
• Deploying the standard Report by changing the labels based on the customer Requirement Document.
• Coordinating between ETL, Database and Testing Teams to get the Reports successfully implemented
• Prepare the reports using report studio taking the data from cognos cubes as a Data source.
• Involved in Migration of Reportnet Reports to cognos 8 Bi Reports
• Involved in cognos server Installation and setting up the users using LDAP Server.
• Involved in scheduling & running cognos cubes on daily basis in UNIX server for customer availability.
• Involved in migration of models and cubes to UNIX production server from windows.
• Created Shell scripts for running the cubes on UNIX.
• Publish reports to Upfront, the Cognos Web portal, to make them available to users as News Items in HTML, PDF, Excel and CSV format.
• Created Snapshot reports on monthly basis and then published the same on upfront.
• Involved in performance tuning enhancements of Reports & Cubes.

Confidential, Detroit

Cognos Developer

Responsibilities:

• Gathering the requirements from the client and preparing the prototype (SRS).
• Integrated the Cognos reports inside Java Application by passing parameters in the URL
• Designing Framework Manager Package by importing the tables, framing relations between them using Star schema and designing packages to publish them in the cognos Portal.
• Mentored the team in the position of a Team Lead.
• Involved in Migration of lower version Reportnet Reports to cognos 8 Bi Reports.
• Creating XML files to extract the Dynamic Text from cognos server to Reports.
• Designing Framework Manager Package by importing the tables, framing relations between them and designing packages to publish them in the cognos Portal.
• Mentored the team in the position of a Team Lead.
• Involved in Migration of lower version Reportnet Reports to cognos 8 BI Reports.
• Preparing of Framework Manager model using Star schema.
• Integrated the Cognos reports inside Java Application by passing parameters in the URL

Environment: Cognos Reportnet, cognos 8 BI, Framework manager, Toad & Oracle.

Confidential, Detroit

Cognos Developer

Roles & Responsibilities:

• Creating drill through reports to give more detail information to the user.
• Analyzing the issues raised by the client and fixing them.
• Involved in performance tuning of Reports.
• Verifying the outputs with existing crystal reports.
• Designing reports containing details of pharmacy, patients and employees.
• Created Monthly reports for all the transactions.
• Designing Crystal reports according to client requirements
• Designing and coding of several modules.
• Developed reports for the various departments.
• Creating monthly reports for all the transactions for all departments.
• Created reports which containing profit and loss statements.
• Created reports to track the movement of the goods.

Environment: Crystal Reports, Visual Basic, Sql Server & Oracle.