SUMMARY

• Overall 9 years of experience in IT industry with experience on Business Intelligence and Data Warehouse Applications.
• Extensive experience in Finance & Banking, Insurance and Healthcare domains
• Worked on full Software Development Life Cycle in Agile and Waterfall methodology projects.
• Confidential Certified Cognos Developer and developed multiple projects using Cognos Suite.
• Expert in analyzing the requirements, designing and developing the applications based on the business requirements, testing and documenting the details of the application.
• Experienced in Performance Tuning, Application Development and in resolving all BI Production support issues on various platforms, using Data warehouse tools including Confidential Cognos 10.2/10.1/8.4 and Informatica 9.6.
• Expert in Confidential Cognos Suite with Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Dashboards and Cognos Connection.
• Expert in developing reports using List, Chart and Cross - Tab, Prompts, Conditional Formatting, Conditional Blocks, Mater and Detailed Reports, Dashboard Portals, Cognos Workspace and Workspace Advanced.
• Good experience in creating DR and Relational model using Framework Manager and Transformer.
• Well- versed in understanding OLTP data and in developing OLAP multi- dimensional cubes and analyzing Power Play Transformers.
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross- Tabs, Summary Reports and Burst Reports.
• Good knowledge on Cognos Admin Activities as enabling security, publishing Model packages and providing object access to users through LDAP and AD Security user groups.
• Worked with business users to analyze the business requirements and process as part of new and ad hoc development.
• Experienced in Data Warehouse Concepts, Methodologies on ODS, Banner ODS and Banner ERP, Data Marts, Star and Snowflake schemas.
• Expert in developing Technical Documents and Design Documents based in business requirements.
• Developed Unit Test Case for Report validation and support business in developing UAT and application validation.
• Developed business case to change management process for implementation changes.
• Good Experience on ETL, BI Tools (Cognos, Informatica).
• Good knowledge on Data stage ETL process, Autoflow process and Control- M process.
• Expert in writing SQL and PL/SQL queries against Oracle 10g/9.x, DB2, MS SQL Server, MS Access databases using TOAD, WINSQL, Confidential DATA STUDIO and SQL Server Management Studio for backend testing.
• Collaborated with Business Analysts, Project Team and End Users to ensure quality of the application and played a key role in timely delivery of the application.
• I am a hardworking, enthusiastic, amicable person with positive attitude towards my personal and professional life.
• High initiative, self- motivated with and excellent communication, analytical and presentation skills, willingness and ability to quickly adapt to new environment and learn new technologies
• Strong Analytical, Administration and Problem solving skills dedicated to maintain the High Quality Standards in Work Delivery ability to work independently and able to work in Collaborative Team Environment.

TECHNICAL SKILLS

BI Tools: Cognos BI 10.1/ 8.4 (Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Power Play)

ETL Tools: Informatica 9.x, Data Transformation Services (DTS), SQL Server 2008/ 2005 Integration Services (SSIS)

Data Modeling Tools: Framework Manager, Transformer

Testing Tools: HP Quality Center 9.2, Clear Quest, Trac

Languages: SQL, PL/SQL

Web Technologies: HTML 4.0, XML, JavaScript

Databases: Oracle 10g/ 9.x, DB2, Sybase, MS Access, MS SQL Server, TOAD, WINSQL, Confidential DATA STUDIO

Operating Systems: MS DOS, Windows 2000/XP/Vista/7, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Round lake, IL

Cognos Developer

Responsibilities:

• Worked extensively on Cognos 10.1 with Framework Manager, Report Studio, Analysis Studio and Transformer.
• Translated reporting requirements and the business data model and to convert into a Framework Manager Model to meet reporting requirements.
• Actively involved in daily status meetings and meetings with Business for gathering requirements.
• Actively involved with the Admin team for migration from Cognos 8.4 to 10.1.
• Transferred Cube data source from 8.4 Production to 10.1 Development.
• Worked on DMR metadata modeling in Framework Manager for dimensional data and published packages in the MOM Insights (Malt O Meal Cognos Portal).
• Extensively used SQL Loader and PL/SQL for extracting source data, transforming and loading into Data Marts, Banner ODS and Operational Data Stores.
• Worked on Model Design Accelerator to reduce the overall time to build a model.
• Used Dynamic Query Mode to improve query performance and functionality.
• Designed the Logical/Physical/Database model that conforms to Star Schema concepts, different views (Import, Business, External) as per Business requirement.
• Created Database layer, Physical layer and Presentation layer, defining appropriate relationships between query subjects.
• 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.
• Worked on Report studio creating various reports ranging from Simple to Complex Reports.
• Created Active Reports and used Business Insights Advanced to create reports.
• Worked on security on Cognos 10.1 on Active Directory.
• Modifying the existing reports based upon the change requested by the user. Involved in resolving Performance issues with various reports.
• Developed List Reports, Bar Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports using Report Studio and Query Studio.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up, Expand-Collapse).
• Deployed the reports and package from Development to Testing and then Testing to Production environments.
• Developed Executive Dashboard reports using Cognos Report Studio.
• Involved in Scripting of SQL for investigating, researching and verifying results of queries and reports.
• Involved in writing test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Unit testing, Integration testing and System testing of the reports in Development, Testing and Production environments.
• Prepared User Documentation to train users and to explain functionality of each report.
• Worked on TOAD with ORACLE as a database.

Environment: Cognos 10.1, Framework Manager, Report Studio, Analysis Studio, Oracle-SQL 10g/11g, TOAD.

Confidential, Bloomington IL

BI Cognos Analyst

Responsibilities:

• Understood the business by investigating and studying the company’s existing resources.
• Interacted with business users and gathered report requirements.
• Analyzed the existing data warehouse database to create models base on requirements.
• Worked along with the ETL team to understand the flow of data from OLTP system to OLAP system.
• Involved in defining the Source Definitions and Target Definitions in Designer tool.
• Developed report prototypes using Excel Spread Sheet and MS Word.
• Prepared report specifications as part of company’s documentation policy.
• Developed models in Framework Manager and deployed packages to the Cognos Connection.
• Customized data by adding filters at both the Framework Level and Report Level.
• Published different packages from Framework Manager to Cognos Connection.
• Analyzed relationships between tables in the schema and applied cardinality in the database layer.
• Created highly Complex Reports using OLAP CUBES as Data Source for Multi- Dimensional Analysis.
• Implemented all business logic in Framework Manager by creating prompts, folders, calculated columns, joins and naming convention.
• Created Dashboards using list reports, cross-tab reports and chart reports and applied filters, calculations, complex expressions, conditional formatting, conditional blocks.
• Developed Drill Down/Up and Drill through and Master Detail reports.
• Bursting the reports in various formats, such as html, PDF, excel and sending via e-mail based on the sales area and different levels of administration.
• Developed many Ad hoc reports using Query Studio and Analysis Studio.
• Created schedule jobs to run Report and Report View.
• Developed and supported multiple applications and Optimize new and existing complex reports.
• Created and maintained LDAP and AD Security groups based on user profiles
• Developed UTC (unit test cases) and helped Business Partners in UAT (User Acceptance Test cases) documentation as part of testing.
• Created a implementation plan and component documents for Change Management approvals.
• Involved in providing estimates and deliverable plan to project by analyzing the business requirements.
• Assured quality of report data output by manually verifying and executing SQL statements in TOAD.
• Trained and guided business users about Query Studio, Analysis Studio and Application usage.
• Monitored daily report Schedule Management required for the business.

Environment: Cognos BI 10.2/10.1/8.4 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, Analysis Studio, Business Insight, Business Insight Advance and Event Studio), Informatica, SQL Server 2008, Oracle 10g, MS OFFICE and Window Server and Unix.

Confidential, Boulder CO

Cognos Developer

Responsibilities:

• Extensively worked with Business Team and Functional Team to review business requirements, and Functional clarifications.
• Coordinated and conducted various meetings between Offshore and Functional Team to review business requirements, and Functional clarifications.
• Estimated the time required for the development and planned for the team activities.
• Provided key project inputs by working with the users and developers in defining several functional and technical issues of project and system requirements.
• Played a key role in planning, testing and implementing system enhancements and conversions.
• Responsible for creating and maintain all testing documentation including test cases, test scripts and test task lists.
• Created customized, Complex reports in Cognos Report Studio and Ad-hoc reports in Query Studio.
• Responsible for the daily, weekly, monthly, quarterly and year end reports for business needs.
• Worked in Framework manager to create Models using different data sources and publishing packages to Cognos connections as per reporting requirements.
• Created DR and Relational Models in Framework Manager.
• Created plans and models to fit as per business needs using Cognos Planning.
• Designed and implemented Data Cubes using Microsoft OLAP services, Cognos Impromptu and Power Play to facilitate executive, management and end user reporting.
• Created multidimensional cubes using Impromptu Query Definition in Power Play Transformer
• Developed Power Play cubes which involved model definition in Transformer, used multiple queries, calculated measures, customized cube and Optimized Cube creation time.
• Created Dashboards in Report Studio involving a mixture of data coming from both the database and Power Play cubes.
• Developed many complex reports as List, cross tab, drill through, and master - detail chart using Report Studio.
• Implemented Security filters at package level, object level and data level.
• Administered Cognos portal and specified user roles and permissions using LDAP
• Involved and worked in Data Mapping from legacy system to PeopleSoft System.

Environment: Framework Manager, Cognos Connection, Query Studio, Report Studio, Metric Studio, and Analysis Studio, Cognos planning, Cognos Power Play Transformer, LDAP, XML, Informatica, MS SQL Server 2005, Oracle, DB2, JAVA/J2EE, Cognos SDK, PeopleSoft HRMS 7.6(HR, Benefits, Payroll, Fully Custom Time & Labor) People Tools 7.6, SQR 6.0, Windows 2003 server and Unix.

Confidential, Baltimore, MD

Cognos Analyst

Responsibilities:

• Worked actively in Cognos 8.4 environment, worked actively with Report Studio, Query Studio and Analysis Studio.
• Actively involved in Customized Cognos Connection with appropriate reports and security measures.
• Created Model Query subjects, Data Source Query subjects, Stored Procedure Query subjects as per the business requirements in the Framework Manager.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created Database layer, Physical layer and Presentation layer, defining appropriate relationships between query subjects.
• Implemented Framework Manager Security for Data access, Object level access and Package access.
• Developed Business View of the data (Metadata Models) with Namespaces, Folders, Query Subjects and Query items in Framework Manager.
• Developed List Reports, Bar Charts, Drill-Through Reports, Master Detail Reports using Report Studio and Query Studio.
• Developed reports, which used Conditional blocks/Variables and associated them with queries to show data only when the conditions were fulfilled.
• Developed Reports using Conditional Formatting, Cascading prompts and Optional prompts.
• Developed Dash Board reports in Report Studio using MDX Functions.
• Created Drill- through reports and Customized Reports with Prompts (List and Crosstab).
• Actively involved in developing Transformer model design and Power play cube building and implemented Securities on cubes.
• Worked on Performance Tuning to maintain fast performance of the cubes and Transformer models.
• Created Oracle PL/SQL Stored Procedures, Functions using Toad for use by Framework Manager Packages and Report Studio reports.
• Performed SQL Tuning to enhance the performance of the reports.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Unit testing, Integration testing and System testing of the reports in Development, Testing and Production environments.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Used JavaScript, HTML and CSS for complex validation, navigation, communication and format customization.
• Coordinated with Development Team & Deliverables and working on high priority issues.
• Organized and conducted weekly status meeting with the IT-BI team and the end user.

Environment: Cognos 8.4 (Cognos Connection, Framework Manager, Report Studio, Query Studio, Power Play Transformer), JavaScript, Oracle 10g-SQL, DB2.

Confidential

BI Test Analyst

Responsibilities:

• Manually tested the application based on software requirements specifications.
• Involved in creating Test Strategy for Testing.
• Good experience in preparing the Test Plans, developed Test cases and Test Procedures based on SRS.
• Peer review of the documents like Test Plan and Test Cases using Test Director.
• Created Test Matrices to report the progress and status of the testing effort.
• Created traceability Matrix and responsible for documentation.
• Analyzed and reported data based in business functionality and performing data analysis by writing SQLs against Data warehouse tables.
• Validated BI Cognos Dashboards and report functionality.
• Monitored data quality, resolving problem data issues and ensuring timely updates.
• Involved in testing the application manually before automating the desired test cases.
• Closely worked with developers and System engineers to nail down the technical problems.
• Designed, configured and monitored scenarios for load, stress and performance testing.
• Performed Positive and Negative testing of the application.
• Performed White Box, Black Box, Functional Testing, Regression Testing, System Testing, We testing, Database Testing and User Acceptance Testing on various builds of the application supported in various Operating Systems.
• Performed GUI Testing on various screens.
• Performed backend testing by executing SQL Query statements.
• Prepared the defect reports and interacted with developers for debugging.
• Involved in the Defect reporting Analysis and reported to the management.
• Developed and shared daily and weekly Defect Status Reports with test lead upon request.
• Followed the standards in the application for testing life cycle.

Environment: Test Director 7.2, Bugzilla, Cognos 8.4 Suite, Oracle 9i, SQL, MSSQL Server, Toad, Benthic Golden, MS Office, VB Script, HTML, Windows XP and UNIX.

Confidential

Systems Engineer

Responsibilities:

• Involved in creating entity relational and dimensional relational data models using Data Modeling tool Erwin.
• Creating databases from the physical model and creating indexes on the tables in the data warehouse.
• Designed database objects and Oracle Forms, Reports. Including Forms based in stored procedures.
• Generated SQL and PL/SQL scripts to install, create and drop Trading Exchange connection database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Extensively used SQL Loader and PL/SQL for extracting source data, transforming and loading into Data Marts and Operational Data Stores.
• Created PL/SQL procedures, functions and packages to fulfill the transformation part of the ETL.
• Responsible for capturing data changes.
• Created Export/Import scripts to Export Files using Oracle’s Export Utility and importing the data into different oracle database.
• Used Transportable table spaces for moving large volumes of data between two Oracle databases.

Environment: PL/SQL, Oracle, Erwin, MS Office (Word, Excel, PowerPoint), Visio, Windows 2000/ NT.