SUMMARY

• Over 10+years of experience in Data Warehousing
• Strong experience with Cognos Tools such as Cognos 10.2/10.1/8.4/8.3/8.2/8.1 MR2 Suite and Analysis Tools such as Cognos Transformer & Power Play.
• Certified Cognos reports developer ( Confidential Cognos 8 BI Author)
• Having strong and working knowledge on Cognos Connection, Query Studio, Report Studio and Frame work manager
• Have knowledge on Informatica suite.
• Excellent ability to gather and understand business requirements and translate into IT solutions with the use of Cognos
• Having rich experience in creating various types of reports using Report Studio
• Experienced with complete application development life - cycle including requirements gathering, analysis and design, implementing, testing and deployment
• Having good knowledge on HTML and JavaScript and ability to implement those technologies in Cognos reports.
• Excellent Team coordinating Skills with the Development Team and Deliverable dates.
• Excellent problem resolution and communication skills with ability to work under pressure in a highly visible role.
• Have working experience on Cognos 7, Cognos 8 and Cognos 10.1/10.2/10.2.1
• Automated Reports and generated documents using Scheduler
• Migrated reports from Hyperion to Cognos
• Good Knowledge on Data Ware Housing concepts and Cognos Reporting Tool.
• Excellent oral and written communication skills.
• Good ability to analyze and solve problems.
• Flair for new learning new concepts. Good listener with outgoing and friendly demeanor.

TECHNICAL SKILLS

OLAP(BI)Tools: Cognos (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Power Play, Power play Transformer, Impromptu)

Languages: C, C++, Core Java, Oracle, Perl

Data Base: Oracle 8i /9i & 10g/11g

Database Languages: SQL & PL/SQL

Operating Systems: WINDOWS NT, Windows 95,98, 2000,XP

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Cognos Developer /lead

Responsibilities:

• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Used filters for efficient data retrieval.
• Share point reports maintenance and Schedule management for the daily email reports.
• Creation of Power Play models and cubes Using Power play Transformer and Testing the report by comparing data with Cube data by using power play web explorer and the validity of the data it retrieves from the database.
• Migrating Power play Client HTML reports that are tabular and pivot oriented and convert them to pictorial/dashboard oriented reports for executive management sales.
• Experience with conditional blocks and conditional layouts.
• Creating Dash Board Reports from cube using Report studio MDX Functions and adding it to the portal page using HTML Items.
• Working knowledge of Linux shell scripting, perl scripting.
• Experience in VB Scripting, Java Scripting, Shell Scripting, perl scripting, cgi scripting
• Modifying the existing report based upon the change request by the user.
• Prepare test data files using Linux Shell scripts, Perl script as per the business requirements

Confidential, Raleigh, NC

Cognos Developer

Responsibilities:

• Understanding the Stakeholder requirement
• Standardized the reports across the SRCOE for Confidential Sales Team on Cognos Based on 10+5 Model
• Successfully migrated from Cognos 8 to 10
• Successfully migrated reports from Hyperion and Excel to Cognos
• Set a Quality Bench Mark for all the Standard Reports.
• Experience in VB Scripting, Java Scripting, Shell Scripting, perl scripting, cgi scripting.
• Continuing to focus on becoming more effective and efficient
• Evaluating additional strategic areas to optimize processes, programs, organization design, resources and tools standardizing work and work products across CoEs, IOTs/IMTs/GMU/GMTs, and BU’s
• Design, Development and Maintenance of Report Studio reports
• Creating the Reports to users for daily and monthly transactions.
• Providing the reports accessibility to privileged users Involved in testing the reports Sharing best practices
• Ensure strong linkages and partnerships with external and internal (e.g., IOTs/IMTs/GMU/GMTs and BUs) Stake Holders
• Analyzing pre-exits reports and solving the existing issues within it
• Worked with client to understand business requirements and converted to technical requirements. Created Design documents Functional and Technical specifications for COGNOS reporting
• Working knowledge of Linux shell scripting, perl scripting.
• Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Created the reports Using SQLobject by writing the queries manually
• Performed Technical and functional reviews of reports during development phase
• Documented all the reports specification.
• Responsible for the UAT and deployment. Performed key role in getting project signoff from client.

Confidential, Burlington, NC

Cognos Developer

Responsibilities:

• Interacted with business users for their requirement.
• Defining standards for report development following industry best practices.
• Created cross tab reports, chart reports and reports with conditional formatting using Report Studio.
• Developed Standard templates in Report Studio for developing reports.
• Supported the users and the management in providing the analysis and forecasting reports.
• Primary support representative responsible for handling and resolving reporting issues related to existing data warehouse environments.
• Prepared the Estimation of Efforts for the Development of COGNOS Reports.
• Create Run and Schedule Reports and Jobs using COGNOS Connection.
• Responsible for defining and documenting report requirements, designing, developing and validating reports.
• Testing the reports against the online data capturing systems.
• Analyze the ETL mappings and finding the details about source, target and Mapping logic
• Developed the ETL mappings according to technical standards
• Responsible for the creation and configuration of session tasks and workflows using Workflow Manager.
• Collect the data from the different teams like BO,PL/SQL,BODS
• Creating the tables based on the requirements.
• Involved in Unit Testing and preparing the test cases.

Confidential, FL

Cognos Developer

Responsibilities:

• Interacted with business users to gather business requirements and designed functional and technical requirements documentation.
• Designed, developed and maintained Catalogs according to the business requirements.
• Generated Simple list, Cross tab and Sub reports and customized them by the addition of filters, calculations, prompts and conditions as required by the end users
• Optimized the performance of Cognos reports using performance-tuning measures such as client server load balancing, governor settings..
• Page explorer, query explorer and variable explorer were used to manage the content of the reports.
• Prompt pages were developed based on the built framework models to select data in specific groups.
• Created user groups and roles in Cognos Connection and applied data level and group level security for various entries.
• Extensively created burst reports in Report Studio.
• Scheduled and distributed reports to the end users by schedule management in Cognos connection.

Confidential

Business Analyst

Responsibilities:

• Worked on Project A/R, Cash and other resolution oriented reporting to the client directly
• Worked on RFP (Requisition for Proposal) whenever a new project proposal is put forth by a Confidential director
• Providing FTE requirements for a start-up project, setting up the database for initial kick off and go live of any healthcare client
• Representing the analyzed data in Excel or on PPT representation.
• Extensive experience in Cognos8 BI including Framework manager, Report studio, Query Studio, Analysis studio.
• Involved in the Dimensional modeling in the Framework manager.
• Major areas of expertise in designing and developing, creating and modifying different reports like List, Crosstab and Chart reports using Report studio, Ad-hoc reports using Query studio and Analysis studio.
• Worked on different types of reports like Cross tab, Master/Detail, Drill through reports Created Advanced Prompts.
• Experienced with Complete application development life-cycle including requirements gathering, analysis and design, implementing and testing.