SUMMARY

• Cognos and Confidential Certified with having 10 years of Experience in teh 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 teh Cognos 8.4 /10/10.2 Administration like Creating Datasource Connections, Publishing Transformer cubes to teh server as a Package and Publishing FM Packages and Assigning teh 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 teh complicated calculations.
• Expertise in Cognos Transformer, Framework Manager using dimensional modeling, SDK, Report Studio, Analysis Studio, TM1, Active Reports, Event Studio and Query Studio.
• Excellent skills in retrieving teh 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 teh Onshore Teams of 6 Cognos developers.
• Implementing teh 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 teh 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 teh complicated calculations
• Designing teh Reports and Framework Model using Dimensional Modeling based on teh client requirement.
• Monitoring Report performance, troubleshooting and system configuration
• Providing technical direction required to resolve complex issues to ensure teh on-timedelivery of solutions dat meet customer expectations.

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

Confidential

Senior Cognos Consultant / Architect

Responsibilities:

• Involved in Design and Development of Data Warehousing model/schema.
• Lead teh 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 teh Reports faster.
• Involved in administration of granting and revoking privileges to teh customers.
• Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all teh complicated calculations
• Designing teh Reports and Framework Model using Dimensional Modeling based on teh client requirement.
• Integration of Cognos TM1 cube with Cognos BI
• Building TM1 Cubes as per teh 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 teh 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

Senior Cognos Consultant / Architect

Responsibilities:

• Lead teh Offshore Team of 10 developers and 5 Admin’s in 13 applications.
• Problems 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 teh customers.
• Designing teh Reports and Framework using Dimensional Modeling based on teh client requirement.
• Migration of Code from Dev to test and production.
• Integration of Cognos TM1 cube with Cognos BI.
• Building TM1 Cubes as per teh 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 teh Reports faster.
• Provided technical direction required to resolve complex issues to ensure teh on-timedelivery of solutions dat meet customer expectations.
• Received several appreciations from client and from Confidential for expertise work.
• Maintained 4 Confidential offshore teams to co-ordinate for Cognos BI and TM1 Development.
• Creating XML files to extract teh 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 teh 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

Senior Cognos Consultant

Responsibilities

• Lead teh 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 teh Reports and Framework using Dimensional Modeling based on teh client requirement.
• Monitoring deliverables having critical SLA’s (Service Level Agreements).
• Interacting with customers to resolve teh Application / Reports related issues
• Involved in Application health checks after deployment.
• Preparing solution trees and error logging database which halps in Problem and Incident Management.
• Writing user defined stored procedures.
• Involved in fixing of errors identified during production support.
• Provide solution for teh Customer Service Requests which requires application related attention.
• Troubleshooting teh causes of daily production job failures.
• Used Quality Control tool to raise defects and assign it to Development team

Environment: Cognos 8.4, Unix, Oracle 10g, Java, Jasper, Data Stage, shell Scripting

Confidential, Pittsburgh

Sr. Cognos Consultant

Roles & Responsibilities:

• Interacting with teh Client for all teh application support issues, Knowledge transition and for all teh 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 teh problem tickets by interacting with teh customers
• Designing teh Model and reports based on teh client requirement
• Generating daily Reports / Cubes for Confidential Account.
• To prepare and Put teh Task in ManageNow Tool to promote teh Reports from UAT to production.
• Preparing teh Schedule for teh Reports using RM(Report Management) Tool and Event studio based on teh customer requirement.
• Tuning teh Cognos server / Reports to extract best performance.
• Deploying teh standard Report by changing teh required labels based on teh customer Requirement Document.

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

Confidential, North Carolina

Cognos Consultant

Roles & Responsibilities:

• Interacting with teh Client & Onsite Coordinator for all teh application support issues, Knowledge transition and for all teh gaps at different Levels.
• Installation and Configuring of servers in client environment.
• Involved in teh design and development of several Reports in Actuate, Cognosand E-Spread Sheet designer Reports.
• Routing teh problem tickets by acting as duty developer depending on teh availability of teh 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 teh Task in ManageNow Tool to promote teh Reports from UAT to production.
• Prepare teh Schedule for Reports using RM Tool based on teh customer requirement.
• Deploying teh standard Report by changing teh labels based on teh customer Requirement Document.
• Coordinating between ETL, Database and Testing Teams to get teh Reports successfully implemented

Environment: Actuate 9, Cognos 8, SDK, Power play Transformer, SQL Developer, Cognos Event, Analysis Studio, SQL Server 2005, DB2, E-SpreadSheet Designer, Maximo, ManageNow and RM Tool

Confidential, Dallas

Cognos Developer

Roles & Responsibilities:

• Prepare teh reports using report studio taking teh 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 teh 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 teh cubes on UNIX.
• Publish reports to Upfront, teh 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 tan published teh same on upfront.
• Involved in performance tuning enhancements of Reports & Cubes.

Confidential, Detroit

Cognos Developer

Roles & Responsibilities:

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

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

Confidential

Cognos Developer

Roles & Responsibilities:

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

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