SUMMARY:

• Technocrat with abilities to lead projects for the organization; seeking a challenging assignment in IT Production Support, Service Management
• An accomplished and enthusiastic professional with nearly 10 years of experience in IT Industry
• IBM Certified Designer for Cognos 10 BI Reports, Cognos 8 BI Reports, Cognos 10 BI, Cognos 8 BI
• Extensive experience in building BI Solutions for Healthcare, Insurance, Life Science, Retail and Investment Banks domain
• Well - versed in developing reporting applications usingCognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Metric Studio and Cognos Connection
• Expert in providing IT Production Support, Systems Support, Service Management & leading teams
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses
• Driving the projects through various phases of SDLC viz., Application Development, Coding & Testing
• Skilled in Design, Development and Implementation of an Enterprise Wide Reporting system using Cognos 8.0/10 BI Suite, Designing BI Applications, and retrieving data
• Excellent Analytical, Consulting & Interpersonal skills; good team player with ability to foster team’s performance through s
• Proven competency in handling entire project lifecycle from inception to delivery, including Business requirement gathering/ analysis, design & development of DW Projects, clear choice preparation, Project Management, Tracking, Quality Assurance
• Instrumental in providing robust modeling and reporting to facilitate executive-level decision making
• Innate ability to understand customer requirements, improve resource allocation and lead teams to translate into IT deliveries with maximum efficiency and optimize profitable growth
• Strong customer service focus and champion in bridging the gap between the Business and IT
• Result-driven communicator; liaised across various business units and promote organizational success
• Outstanding problem solving techniques with enthusiasm towards continuous quality improvements
• Exceptional understanding of criticalities and providing creative solutions within the stringent timelines
• Technical Solutions
• Stakeholder Management
• Project /Program Management
• Leadership / Team Work
• Requirements Analysis
• Documentation Management
• Quality Assurance
• Application Designing
• & Development

TECHNICAL SKILLS:

BI & DW: COGNOS 10BI COGNOS 8BI, Framework Manger, Cognos Report Studio, Cognos 10 & Cognos 8 Administrator, Administrator, CognosReportNet1.1, SQL Developer and Toad

DBMS: ORACLE 9i / SQL Server

Operating Systems: Windows9x, Windows 2000/7, Windows XP, OS/400,UNIX

Others: IBM WEBSPHERE 6.2, IIS /HP Quality Center

PROFESSIONAL EXPERIENCE:

Confidential

Cognos Developer / Senior Associate

Environment: Cognos 10BI,Cognos 8.4 Framework Manager, Report Studio, Oracle 9i/10g, Unix, IIS 6.0, Apache, Informatica9.1.0, HP Quality Center

Responsibilities:

• Involved in setting up Entire Cognos Set Up with respect Cognos Installation
• Collaborating with Business Analyst, Gathered BRD’s and related various Specification Documents
• Worked with Report Studio, Framework Manager to create reports containing complex calculations prompts and charts according to the user requirements
• Creating and supporting the development of complex reports in Cognos while working with features including Conditional formatting, Drill through, Cascading prompts, Query calculation, Layout Calculation, Conditional Blocks, Master Detail Relationships, Page breaks and render variables
• Tracing the performance of the reports and validated them from the DB level and FM level, to the Report Studio level and tuned the reports for better performance
• Conducting to Business Analyst under Confidential for getting use of Cognos connection and query studio
• Developing and Implementing Best practices (Development Standards, Modeling standards & Security Models)
• Supporting multiple Applications for client this involved admin task like granting access to the user, new data source creation, Report Scheduling, Providing support to the performance metrics reports that were based out of HP QC Tool to determine the Tickets performance
• Performing Cognos Upgrade for current Applications from Cognos 8.4 to Cognos 10.2.1

Confidential

Cognos Developer / Lead

Environment: Cognos 8.4 Framework Manager, Report studio, Oracle 9i/10g,Informatica9.1.0,Unix, IIS 6.0, Apache

Responsibilities:

• Analyzed Business requirements from the analysts, read functional documents, and prepared Cognos reports accordingly
• Acted as an Onshore - Offshore Coordinator and handled the team of around more than 5 members to drive the following Technical Designs of reports Offshore/Onshore Model), Report Build, Testing and defects resolution for the Cognos report & Cognos code.
• Created Database layer, Business layer and Presentation layer, defining appropriate relationship between Query Subjects and Fact Table in FM
• Developed List, Cross Tab, Drill Through, Master Detail, Chart and Complex reports which involved Multiple Prompts in Report Studio.
• Performed performance Tuning for Cognos Reports and assisted team on troubleshooting and resolving issues with respect to complex Cognos reports for project requirements and customer expectations
• Co-ordinated with Functional users for Users Acceptance Testing prior to releasing system changes in production

Confidential

Developer

Environment: Cognos 8.4 Framework Manager, Report studio, Oracle 9i/10g, Unix, IIS 6.0, Apache

Responsibilities:

• Involved in Cognos Framework Model Package Development and Reports development. Support Reports Testing and creation of Unit Test Cases along with Functional SME’s/BA’s.
• Gathered and Analysed user requirements and the reporting issues from the users
• Worked on Functional Design and Technical Design Documents of the Cognos Reports
• Created packages combining data from different sources using FM
• Cognos Reports Migration and testing between different environments and Versions.
• Created reports using Report Studio and performed ad-hoc queries using Query Studio.
• Created out bursting of reports in Report Studio
• Developed List, Cross Tab, drill through, master-detail and other complex reports which involved multiple prompts in Report Studio
• Proofread the reports to drill down to the smallest factor, or key performance indicator, to see the implications of a change on a forecast

Confidential

Team Lead

Environment: Cognos 8.4 Framework Manager, Report studio, Oracle 9i/10g

Responsibilities:

• Analyzed the specifications provided by the clients and developed specification documents for reports as per client requirements
• Installed & configured the Cognos 8.4 BI Environment, Administering the Servers, Troubleshooting, and Performance Tuning
• Developed and published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
• Performed Performance tuning by analysing and comparing the turnaround times between SQL and Cognos
• Co-facilitate client workshops and, typically small to medium group of clients

Confidential

Cognos Administrator / Application Designer

Environment: Cognos 8.4 Framework Manager, Report studio, Oracle 9i/10g

Responsibilities:

• Involved in the Cognos Administration like creating new DataSource Connections and Creating Packages, handling the Deployment of reports copying from Development to Production server and also handling the user permissions on the Packages and Folders.
• Prepared the Functional Specification Document and Detail Design document of the project
• Created Complex Reports (List Report, Master Detail Report, Pageset, Chart Report, and Drill through Report) in Report Studio Data source creation
• Developed burst reports using Query Studio, Report Studio and other Cognos 7 tools

Confidential

Cognos Administrator / Application Designer

Environment: Cognos 8.3 BI, Framework Manager, Oracle, DB2

Responsibilities:

• Involved in cube creation, further performing the enhancement cases in the Cognos cube
• Created Complex Reports in Report Studio
• Granted access to the users in Cognos Administration
• Deployment of the packages from one environment to the other environment
• Prepared User documentation to train users and functionality of each report
• Provided Production Support which involves solving user problems
• Prepared the Functional Specification Document and Detail design document of the project

Confidential

Cognos Report Developer / Software Engineer

Environment: Cognos 8.4 Report Studio, Cognos FM & Oracle

Responsibilities:

• Installed and configured Cognos 8 client at offshore with client server
• Created and published packages for report authors using cube as data source further developing reports in report studio using cubes as data source
• Implemented and created test cases and provided the support after the production deployment/Go Live
• Worked on Cognos8.1 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server
• Created relationships between query subjects to better represent the logical structure of the business and the user requirements