SUMMARY:

• Confidential Certified Cognos 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

Senior Project Lead

Responsibilities:

• Designing the Active Reports for all the representatives who are using IPAD’s for reporting.
• Involved in Designing of DMR, Complex Dynamic sorting reports.
• Implementing the complex solutions using java programs.
• Meeting various Application owners and understanding their requirements
• Using Java & Java Script Code whenever it is necessary and integrated with the Cognos reports.
• Designing the Reports, Dashboards, Workspace Reports and Framework Model using Dimensional Modeling based on the client requirement.
• Monitoring Report performance, troubleshooting and system configuration
• Providing technical direction required to the team to resolve complex issues to ensure the on-time delivery of solutions that meet customer expectations.

Environment: Cognos 10.2.1, Oracle, DB2, Toad, Developer Studio, SDK, Windows, Informatica, SAS DS

Confidential, Seattle

Project Lead

Responsibilities:

• Involved in Designing of DMR, Complex Dynamic sorting reports.
• Implementing the complex solutions using java programs.
• Meeting various Application owners and understanding their requirements
• Using Java & Java Script Code whenever it is necessary and integrated with the Cognos reports.
• 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-time delivery of solutions that meet customer expectations.

Environment: Cognos 10.2.1, Netezza, DB2, Developer Studio, Advanced Java, Windows, AS 400.

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-time delivery of solutions that meet customer expectations.

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

Confidential, Atlanta

Senior Cognos Consultant

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 current
• Problems 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-time delivery of solutions that 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

Senior Cognos Consultant

Responsibilities:

• Lead the Offshore Team of 10 developers and 5 Admin’s in 13 applications.
• Meeting various Application owners in Statefarm and understanding their current
• 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 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-time delivery of solutions that 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 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

Senior Cognos Consultant

Responsibilities:

• Lead the Offshore Team of 6 members in 2 shifts.
• More than 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

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

Confidential, Pittsburgh

Sr. Cognos Consultant

Responsibilities:

• 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 Confidential 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, North Carolina

Cognos Consultant

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, Cognos and 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

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

Responsibilities:

• 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:

• 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.

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

Confidential, Detroit

Cognos Developer

Responsibilities:

• 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

Responsibilities:

• Migration of crystal reports into Cognos Reportnet.
• 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.

Environment: Cognos Reportnet, crystal reports 9, Toad & Oracle

Confidential

Developer

Responsibilities:

• Designing reports containing details of pharmacy, Confidential ts and employees.
• Created Monthly reports for all the transactions.
• Designing Crystal reports according to client requirements
• Designing and coding of several modules.

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

Confidential

Developer

Responsibilities:

• 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.