Objective:

Seeking for an opportunity to work as a Cognos BI Professional in a quality environment where my technical knowledge and experience can be shared and enriched.

Summary:

Over 7 years of experience in Information Technology and a wide range of progressive experience in providing design, analysis, development, documentation, coding and implementation of the business technology solutions.

• 3 years of strong working experience in Cognos BI tools using Cognos Framework Manager, Report studio, Query studio, Analysis studio, Cognos connection, Cognos administration, PowerPlay Transformer.
• Strong experience in creating and publishing packages on Cognos BI Server.
• Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Query Studio and Analysis Studio.
• Extensively used Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
• Good knowledge of IBM Cognos Framework Manager and Transformer.
• Strong complex reporting skills complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.
• Expertise of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
• Experience in a data migration process between different versions of Cognos.
• Experience in developing Dashboards Reports in Cognos 8.
• Expertise in Scheduling Deploying the Reports.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Worked with Different Databases like SQL Server, DB2, MS Access.
• Possess Excellent Communication Interpersonal skills. Technically sound, Result-Oriented with strong Problem Solving skills.
• Great Team Player, innovative, strong desire to keep pace with latest technologies.
• Accustomed to working in a fast paced time-frame goal oriented environment and able to deliver under pressure and time constraints.

Technical Skills:

• Business Intelligence Tool : Cognos 8.3/8.4/10.2 BI tools Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Connection , Framework Manager, PowerPlay Transformer, Access Manager, Scheduler.
• Databases : DB2, SQL Server, Access.
• Applications : Sharepoint
• Tools: Mantis, Eclipse, RAD, Microsoft Office, Visual Studio, Oracle, Toad, Dreamweaver , Tomcat, Macros.
• Languages : Java, C, C , SQL.
• Web Technologies : HTML, JavaScript, CSS , jsp.
• Operating Systems : Linux/Windows NT/2000/XP/Windows 2007

PROFESSIONAL EXPERIENCE:

Confidential

Cognos Developer

• I was involved in maintenance or modification of existing packages or totally rebuilding new package or creating package from start to end.
• Following are some of the projects I have worked on:-
• Confidential On this project I am playing a technical lead, report designer and developer role. As my dual role in this project I was critically involved in takeover of asset management system.

RESPONSIBILITIES:

• Highly involved in designing and developing new reports.
• Maintenance of existing reports.
• Creating Ad-hoc reports for customers.

RESPONSIBILITIES:

• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill Reports and Bursted Reports.
• Created Dashboards to present critical company data in a single report.
• Manually modified the SQL in ReportStudio to tune and to write complicated reports. Used union/Join objects in ReportStudio.
• Gathered and analyzed business requirements from users and business community.
• Created Sophisticated Reports using Report Studio.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Scheduled Reports and Jobs to run and update database periodically.
• Designed and developed List, cross tab, filtered, drill through, master-detail and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports .
• Tested reports using review checklists for Quality Assurance before delivering to the end users.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Created Sophisticated Reports using MS Access, MS Excel, Visual Basic and Macros.
• Moved Reports from Test environment to Production.
• Validated report results with the source data and authorized the reports to production environment.
• Created Jobs to Schedule multiple reports in Cognos Connection.

RESPONSIBILITIES:

• Planning migration of existing Business Object Reports to Cognos 10.2.
• Designing, developing or rebuilding existing reports.

Confidential

Cognos Developer/Financial Analyst 2

I have worked on several different assignments and projects at Blue Cross playing different roles under different or no supervision which has impressively enhanced my application and business knowledge. In this short time frame I have gained lot of knowledge in different systems in regards of maintenance or modification of existing packages or totally rebuilding new package or creating package from start to end.

RESPONSIBILITIES:

• Conversion of data in SQL Server to DB2.
• Planned the strategy to migrate existing Asset management reporting on Cognos 8.3 to Cognos 10.2.
• Migrated the entire asset management reporting to Cognos 10.2 on scheduled timeframe.
• Interact with customers to collect the requirement.
• Designed, developed and tested new asset management reports which involves extensive use of Cognos bursting functionality.
• Distribute the reports through email, Cognos portal and Sharepoint.
• Designed database to track the activities on Asset Management applications and tables.
• Designed and developed conditionally formatted Excel reports.

RESPONSIBILITIES:

• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill Reports and Bursted Reports.
• Created Dashboards to present critical company data in a single report.
• Manually modified the SQL in ReportStudio to tune and to write complicated reports. Used union/Join objects in ReportStudio.
• Developed Framework Manager Models and analyzed those models in analysis studio.
• Gathered and analyzed business requirements from users and business community.
• Analyzed existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Scheduled Reports and Jobs to run and update database periodically.
• Designed and developed List, cross tab, filtered, drill through, master-detail and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports .
• Migrated reports from Business Object to Cognos 8.3 , Cognos 8.3 to Cognos 8.4 and Cognos 8.4 to Cognos 10.2 Environment.
• Customized Cognos studio reports using HTML and jsp.
• Tested reports using review checklists for Quality Assurance before delivering to the end users.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Created Sophisticated Reports using MS Access, MS Excel, Visual Basic and Macros.
• Moved Reports from Test environment to Production.
• Validated report results with the source data and authorized the reports to production environment.
• Created Jobs to Schedule multiple reports in Cognos Connection.

RESPONSIBILITIES:

• Planning migration of existing Business Object Reports to Cognos 10.2.
• Designing, developing or rebuilding existing reports.

Confidential

Confidential Software provides Registration of Commercial Vehicle in Department of Motor Vehicle. IFTA system facilitates to file tax return for fuel consumption by commercial vehicle in various jurisdiction.

RESPONSIBILITIES:

• Participated in the testing of the software for Commercial Motor Vehicle Registration Plan and Fuel Tax Agreement for DMV , South Carolina to ensure the highest level of quality.
• Managing all phases of testing for assigned components ensuring test plans and test cases are completed and met business requirements.
• Working with development teams investigating and correcting software bugs and deficiencies based on the testing results using Mantis issue tracking tools.
• Creating and Generating System test scripts for different test scenarios covering all aspects of project functionality.
• Creating test plan, Walk through, integration approach and strategy document, test cases, test scenarios, conditions and scripts,
• Performing various types of testing, such as functional, regression, user acceptance, negative , Parallel Testing, System Testing , stress Testing, performance testing and installation testing.
• Performing Security testing of the basic security levels in the User Link application security mechanism.
• Record and document test result-using PVCS version controller.

Environment : Windows NT , Windows 2000, PVCS, Mantis

Confidential

The Confidential offers a variety of products and services, including life insurance, group insurance, mutual funds and annuities. Group Insurance segment manufactures and distributes a full range of group life, long-term and short-term group disability, and long-term corporate- and trust-owned life insurance in the U.S. primarily to institutional clients for use in connection with employee and membership benefits plans.

RESPONSIBILITIES:

• Furnished QA/test plan and test script for web-based Client Enrollment software products on Windows NT and Windows 2000 operating systems.
• Tested functionality, compatibility, security features and various GUI of the software.
• Documented various issues / bugs using Mercury Quality Center.
• Worked as a part of team and individual.

Environment : Windows NT , Windows 2000, Mercury Quality Center

Confidential Market developing for featuring client/server and internet technology, Money Control System allows investor to get updates on stock market and research on various companies financial health and future development of the company. Using Microsoft SQL Server Oracle database, J2EE technology STRUTS Framework. The front-end display was developed using JSP's. The Package integrates the Stock listing, Financial news, Financial analysis, Interviews and link to other CNBC portals.

RESPONSIBILITIES:

• Participated in reviewing requirements for testability and usability, consulted development staff with regards to system functionality.
• Performed Functional, GUI, Regression, System Integration, User Acceptance, Configuration and content testing for web-based application.
• Tested application security features including session expiry, book marking, passwords and compatibility across multiple browser types and encryption levels.
• Developed and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for the application.
• Analyzing and verifying test results, providing status and progress reports.
• Performed Scalability, Performance and Load Testing using Load Runner 6.0 Running Load Test Scenario, Monitoring the Performance, Analyzing Results .

RESPONSIBILITIES:

• Participated at testing of marketing and online services pages of PC Banking Application Banking and Investment Personal/Business Products and Services .
• Analyzed business requirements, functional specifications and mock ups of financial to provide functional decomposition.
• Performed functional and regression testing of Web-Admin application Windows NT .
• Developed of testing strategies for Internet application.
• Generated test scenarios, test cases and test data. Executed tests, created problem reports.
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Worked with business analysts, developers, and content department to resolve issues.