SUMMARY

• 7+ years of IT experience in Software Application Design, Build, Testing and Documentation in for both financial and healthcare organizations
• 5+ years of extensive experience on Cognos 10 Reporting Tools Reporting against various Data sources
• Experience utilizing business intelligence, relational database and data warehouse methodologies
• Designed and constructed packages, cubes, dashboards and complex reports for Confidential Medical Solutions business users
• Migrated Actuate reports to Cognos specification
• Very well experienced with Cognos Framework Manager, Report Studio, and Query Studio.
• Followed standard Data warehousing concepts.
• Well versed with the various databases like SQL Server, Oracle, and Teradata.
• 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 Client

Databases: 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, Costa Mesa 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
• Created List, Sub and Cross-Tab reports using Report studio and distributed Catalog
• Used cascading prompts, drill-through, conditional formats, grouping and association features of Report Studio to generate efficient and user-friendly reports
• Created Drill-Through Reports to provide users with more detailed information.
• Developed various complex reports in Report Studio.
• Created reports using conditional blocks, multiple prompts, dynamic sorting.
• Used JavaScript for customizing date prompts
• Designed and constructed packages, cubes, dashboards and complex reports

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, LA

Cognos Consultant

Responsibilities:

• Extensively worked on understanding the business requirements and involved in performance tuning for Cognos Reports
• Created the project and imported the data from SQL server and Oracle data sources in the Framework Manager for marketing analysis package
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Building models and publishing packages in Framework Manager to the Cognos 8.4 server.
• Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.
• Development of ad-hoc reporting interfaces using Cognos Query Studio.
• Experience in writing and fine-tuning complex SQL queries in DB2, Oracle
• Worked extensively on SQL, to test and verify the accuracy of the reports.
• Worked on Wire frames during the Elaboration Phase Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Upgrade the report and packages version of COGNOS from 8.2 to 8.4 and Participate in the regression testing and unit testing.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio & models in Framework Manger and development of any new Reports.

Environment: Cognos 10.1.1 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Transformer, Map Manager, Go Mobile, Event Studio), JavaScript and HTML, TOAD, Oracle Database 10g, Manhattan WMS, Windows XP Professional, XML and HTML.

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.