SUMMARY

• 7+ years of IT experience in Software Application Design, Build, Testing and Documentation.
• 5+ years of extensive experience on Cognos 10 Reporting Tools Reporting against various Data sources
• Developed and maintained a high level of Active Decision Engine dashboards and reports.
• Migrated Actuate reports to Cognos specification
• Very well experienced with Cognos Framework Manager, Report Studio, Query Studio
• Well versed with the various databases like SQL Server, Oracle, Teradata, DB2
• Written SQL queries to conduct unit testing for various reports
• Interacted with Business Users for Requirements gathering and coordinated on User Acceptance Test efforts
• Built and delivered Ad - hoc Reporting capabilities to Confidential business users
• Successfully built Framework Manger Models for reporting in various studios for the Fraud Security and Acquisitions departments
• Designed and created KPI Dashboards for the Manufacturing cost analysis.
• Used Javascript and HTML to create report drill through capability

TECHNICAL SKILLS

Reporting Tools: Cognos 10.1, 10.2, 8.1, 8.2, 8.3, 8.4 and ReportNet Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Framework Manager, Metric Designer Cognos 7 Series PowerPlay Transformer, PowerPlay ClientDatabases Teradata, SQL Server 2000/2005, MS Access, DB2, and Oracle 10g/9i/8

Web Servers: IIS, Apache LDAP SunOne Directory Server

Microsoft Office: MS Access, MS Word, MS Excel and PowerPoint

Programming Skills: C, C++, HTML and SQL

Operating Systems: Windows 9x/NT/2000/2003/XP/Vista/7

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Cognos Developer

Responsibilities:

• Created a dashboard using drill through capability
• Presented reports in both Numerical and Graphical methods for better visualization of data.
• Created a one stop report for users to access various reports using a set of prompt selections.
• Modified and maintained the exiting FM models.
• Analyzed and converted Business Requirements to Technical Specifications
• Maintained report and FM model version using SVN tortoise and SCM tools.
• Used Javascript and HTML to create report drill through capability
• Conducting extensive testing during the migration from Cognos 10.1 to Cognos 10.2
• Prepare and executed Regression Testing Scenarios
• Maintained and created documentation for reports and report enhancement for every quarterly and maintenance releases.
• Created reports using conditional formatting, unions and joins.
• Worked on JIRA tickets for various enhancements of reports.
• Created event studio reports which triggered a set of daily jobs.

Environment: Cognos 10.2, Cognos 10.1.1, Report Studio, Analysis Studio, Query Studio, Framework Manager, Oracle, SVN Tortoise

Confidential, El Segundo CA

Cognos Developer

Responsibilities:

• Analyze functional and business requirements Development of enterprise conceptual modeling solutions working collaboratively with Business and project teams serving on data integration.
• Developed reports, Dashboards and created Framework Models for ADE(Active Decisioning Engine) Projects and worked on SDR’s.
• Developed and maintained ADE dashboards and reports.
• Modified and created documentation for existing and new reports that are developed in report studio.
• Worked closely with the Project/Program Manager and enhance and develop the enterprise Business Intelligence model as needed.
• Created different types of reports like list, crosstab, chart and also dashboards in the cognos portal using conditional blocks and drill through.
• Worked with the business unit to gather requirements and created reports as per the requirement
• Modeled Relational data creating relationships, organizing the model satisfying most of the operational reporting needs for Business at a fast paced environment using Cognos Framework Manager.
• Involved in System Testing and created Test cases for different reports.
• Developed reports which involved using both SQL.
• Converted SQL based reports to use the FM.
• Worked on SDR’s which focuses on the various business areas of Confidential .

Environment: Cognos 10.2,Cognos 10.1.1, Cognos 8 BI (8.3 & 8.4) Report Studio, Analysis Studio, Query Studio, Framework Manager, Teradata

Confidential, Scottsdale, AZ

Cognos Developer

Responsibilities:

• Analyzed the actuate requirements and converted them to Cognos reporting specs.
• Developed Cognos technical requirements from the Actuate Reports.
• Created conditional formatted reports using tokens and conditional blocks.
• Created reports for dynamically sorted columns
• Created customized reports to meet the business requirements CSV, TAB, XML, PDF, and HTML.
• Created reports with special characters based on the sample report outputs for the smooth transition to XSLT processing and post java processing.
• Created test cases for each of the reports developed.
• Conducted extensive testing and followed specific test procedure based on Report output.
• Created dashboard reports showing charts, lists, crosstabs using dimensional data

Environment: Cognos 10 (Framework Manager, Report Studio), Oracle 10g, SQL Developer, Windows 7.

Confidential, Thousand Oaks, CA

Cognos Developer

Responsibilities:

• Worked closely with the business to understand the reporting needs and built a suitable FM model.
• Used SQL to create the query subjects in Framework Manager.
• Created query studio reports for the business
• Documented all the development and enhancement carried out on the reports and models.
• Created mapping documents to identify the source data that is being reported.
• In charge of the weekly deployments of Reports and Packages to production
• Conducted end to end testing during the migration in each environment
• Maintained a document database for all the migrations and deployments.
• Created and updated Framework manager models and published to cognos connection.
• Developed various complex reports in Report Studio.
• Created reports using conditional blocks, multiple prompts, dynamic sorting.
• Interacted with Business users and SME’s to gather requirements.
• Performed performance tuning for the reports and also documenting the test cases.
• Supported supplemental activities such as report enhancements and troubleshooting.
• Scheduled reports for weekly and monthly runs.
• Used JavaScript for customizing date prompts

Environment: Cognos 10/8.2/8.3/8.4 (Framework Manager, Analysis Studio, Report Studio, Query Studio), Oracle 10g, Windows Vista, PL/SQL Developer, Windows Vista

Confidential, Charlotte, NC

Cognos BI Admin/ Developer

Responsibilities:

• Used Framework Manager to model metadata from different Oracle sources for use in Report Studio
• Responsible for migrating packages (deployment archives) from Dev to QA.
• Responsible for performance tuning of Cognos 8 environment and address performance issues
• Created reports based on user requirements using conditional formatting, conditional blocks, page breaks
• Used standard Noetix views to create custom reports for the various business areas
• Interacted with users to understand the requirements and design the reports accordingly
• Supported the report requests from business to modify and enhance the reports
• Implemented Drill-Thru’s in Report Studio to other reports
• Created forecast reports using List, Crosstab and Charts for better visualization both numerically and graphically
• Creating dashboard reports with drill through capability for the higher management
• Was part of development and support team for 2 entire Go-Live cycles
• Assisted User acceptance for multiple instances
• Unit testing, Integration testing and Performance testing of reports after development

Environment: Cognos 8.2/8.3/8.4 (Framework Manager, Analysis Studio, Report Studio, Query Studio, Metric Studio), Oracle 10g, Windows XP

Confidential

System Analyst/ Tester

Responsibilities:

• Involved in training the students.
• Involved in JKC activities.
• Interacted with the clients for updating the task and modifying the data as per their final call
• Analyzing given data and modifying the data accordingly using internal tool.
• Accountable for giving the production and efficiency within the specified time.
• Responsible for reaching the targets every month in the process.
• Created and maintained the project documentation database
• Extensively involved in troubleshooting and validation.
• Extensive and detailed documentation of user requirements.
• Reviewed and Created Project Assessment, Project Plan, Business Process Requirements, Technical Requirements, Test Specifications, and Test Results.
• Involved in writing Test Plan and Test Cases.
• Write and execute SQL query to verify and validate data in the backend database.

Environment: Windows 7, Sql Server 2005.