PROFESSIONAL SUMMARY:

• More than 8 years of experience in BI with expertise in Cognos 8/10 BI (Report Studio, Query studio, Analysis studio, Business Insight Framework Manager), Developed and Published Packages in Framework Manager.
• Having the knowledge on Data warehousing Concepts, Informatica and Business Objects.
• Experience in full BI Lifecycle implementation from requirements gathering to Data Modeling, ETL and Reporting
• In Depth understanding of the AS - IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans
• Installed COGNOS Tools, provided training and End User Support.
• Proficient in creation of multiple summary tables and Analytical Data marts from an Oracle 8i relational database.
• Published Framework Manager Package which feeds data for Iqd files and reports.
• Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts.
• Exported Framework package structure from Content Store to deploy the reports and data source in other environments.
• Experience in Report Scheduling and bursting of Reports.
• Responsible in interacting with business partners to identify information needs and business requirements for reports.
• Extensive knowledge in creating dash boards using Report studio.
• Extensively worked on Transformer for creating Multidimensional Cubes.
• Excellent communication skills and has ability to implement projects with demanding objectives.

TECHNICAL SKILLS:

BI Tools: Cognos 10 BI Query Studio, Analysis Studio, Report Studio, Business Insight and Framework Manager, Cognos 8.1.2 MR1 BI, Cognos Power Play Transformer7, Impromptu Web Reports (IWR), Access Manager, Power Play Enterprise Server 7.

GUI: Visual Basic 6.0

Languages: C, C++, PL/SQL, Java Script, HTML & XML.

Servers: Apache Tomcat, BEA WebLogic Server, IBM WebSphere.

Databases: Oracle 8i / 9i, SQL Server 2000/2005, Ms-Access.

Operating Systems: Windows 95/98/NT/2000/XP, UNIX, LINUX.

Utilities: MS Office 98 / 2000, Outlook 2000 and Lotus Notes.

PROFESSIONAL EXPERIENCE:

Confidential, Bala Cynwyd, PA

Sr. BI Developer

Responsibilities:

• Involved in the development of High Level Designs, and translating business requirements to technical documentation
• Designed and Implemented new dashboards using Portlet pages and cognos workspace
• Executed Cognos Administration tasks such as maintaining data source connections, user access permissions to packages and folders
• Deployed reports and packages among different environment Dev, Test and Production
• Production Support for Various Teams with all the requirements and enhancements
• Upgraded Cognos 10.2.1 to Cognos 10.2.2
• Created Technical documents for the upgrade process.

Environment: Cognos 10.2.2, SQL Server, Windows 2000.

Confidential, Wall Street, NY

Sr. BI Developer

Responsibilities:

• Create tactical and strategic reports from raw data to final product that are utilized by over 300 users
• Using complex SQL scripts to create stored procedures and aggregate tables based on multiple servers and databases
• Delivering lead indicators and trends to senior management; developing on-going analysis and reports to track business trends (sales, attrition, member usage)
• Create complex models to support executive decision on key projects such as introducing new products, pricing restructure and operating hours of our network
• Assist IT in UAT; actively involved in data integrity testing and reconciliation during transition out of legacy transactional software
• Ongoing analytics support for senior management (ad-hoc requests, analysis/reports for board meeting)
• Customer Insights: member demographics, usage pattern and purchasing trends to support management decisions
• Data segmentation in reports based on user’s span of control (Cognos C10 burst); producing flexible reports to support different consolidation levels and distribution as business evolves; portal maintenance for all user groups
• Creating prototype of reports, discuss reporting needs with business leaders for a quick product turnaround
• Design user friendly reports by recognizing target audience, business requirements and KPIs

Environment: Cognos 10, SQL Server, Windows 2000.

Confidential, Fort Washington,PA

Cognos Consultant

Responsibilities:

• Removed ambiguous relationships between the Query subjects and there after worked on optimizing and tuning the Query performance
• Created and Published packages from Framework Manager to Cognos Connection in order to generate ad-hoc queries using Query Studio and standard reports in Report Studio
• Worked on complex reports like dashboards, cross-tab, master-detail, reports with drill-through, prompts, filters, Page set etc
• Implemented conditional formatting in the reports and enabled multilingual feature
• Involved in importing and exporting of data from development to production environment
• Created various views like Business view intended for different groups
• Exported framework package structure from Content Store to deploy the reports and data source in other environments.
• Applied various kinds of prompts such as Value prompt, Date prompt, Textbox Prompt, Select & Search Prompt for report's better performance
• Maneuvered complex reporting structures with ease by designing reports with a combination of multiple list objects and cross tab objects.
• Involved in supporting test users to create test scenarios.
• Created walkthrough documentation of the reports to give users an overview of the report’s capabilities.
• Imported and implemented report specifications into production environment as a part of migrating reports from development to production.

Environment: Cognos 10/8 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Oracle 10, Windows 2000.

Confidential, Malvern, PA

Cognos Consultant

Responsibilities:

• Primarily responsible for interacting with Business Stake Holders, Testers, Developers during Project Development and Implementation phase to gather business requirements and garner better perspective of client's organizational structure.
• Acting as a techno-functional contact to support technical team and business team alike
• Involved in the development of High Level Designs, and translating business requirements to technical documentation to accelerate project development
• Analyzing ongoing data feed to defined benefits database and developing reports for functional reconciliation purposes as well as conforming to new system requirements
• Developed various ad-hoc report types ranging from simple lists, crosstabs through complex dashboards, drill-through, master-detail & conditional formatting reports.
• Using Framework Manager, developed business model to adhere with user specifications; provided deliverables on data mapping documentations, and reporting matrix.
• Working with DBAs to ensure table structures adhere with end-user reporting needs
• Implemented standards in report design and appearance by following set of predefined rules while applying colors and fonts styles to the report structure
• Developed testing strategies in-accordance with different environments to test and validate reports ensuring apt specifications and requirements for Systems Acceptance Testing (SAT), Client Acceptance Testing (CAT), and Performance Testing.
• Providing internal and external walkthroughs for translating online application GUI into backend data to developers, testers, business users, and systems analysts
• Working with QA management in implementing dashboards for Metrics analysis.
• Scheduling jobs to run reports in Cognos to distribute financial reports to various user-groups in the organization; to conduct performance-testing in different environments.
• Responsible for handling production support by reviewing report data, conducting data analysis, and escalating issues and concerns to upper management
• Providing end-user training during post-production phase and guiding them with using Cognos and understanding of Data Setup.

Environment: Cognos 8.3 and Cognos 8.4/10 (Report studio, Framework Manager) Oracle 9i

Confidential, Houston, Tx

Cognos Developer

Responsibilities:

• Migrated 20 Impromptu Reports to Cognos 8.3 Reports
• Successfully completed the annual Reports for Confidential Blue Book Project ‘09
• Developed Cognos Reports for the Cognos Enterprise Planning - Reporting Integration project
• Working knowledge of using IQD files in building cubes using Transformer
• Worked as a Lead Developer for a team of 4 developers, for Order Life Cycle Project
• Created Dimensions, Levels, Calculated Measures, Special Categories with relative time period and Cube groups
• Added various portlets and customized the portal design
• Coded SQL using Teradata SQL Assistant and created Pass-through SQL Reports when the framework packages did not have the required tables
• Optimized the Powerplay Transformer Cube build times using various techniques like SQL Tuning, Time-based partitioning and etc

Environment: 8.3 Report Studio, Analysis Studio, Powerplay Transformer, Oracle

Confidential, Denver, CO

Cognos Consultant

Responsibilities:

• Resolved different ambiguous relationships between query subjects while creating Framework manager model
• Created and Published packages from Framework Manager to Cognos Connection in order to generate ad-hoc queries using Query Studio and standard reports in Report Studio
• Worked on complex reports like dashboards, cross-tab, master-detail, reports with drill-through, prompts, filters etc
• Implemented security at Package level, Object level, Data level using Framework manager
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection
• Created various views like Business view intended for different groups
• Lead the testing and deployment tasks for the newly developed BI objects

Environment: Cognos 8.1.1 BI Suite (Framework Manager, Cognos Connection, Report Studio, Query Studio), MS SQL Server 2000

Confidential, Chicago, IL

Cognos Developer.

Responsibilities:

• Published the package with the externalize query subjects for the data source to the Transformer model.
• Created dash boards to get the business decision at a glance using report studio.
• Created the transformer models and cubes with various rollups and customized time dimensions.
• Published Framework Manager Package which feeds data for Iqd files and reports.
• Exported framework package structure from Content Store to deploy the reports and data source in other environments.
• Tuned report studio reports for improved performance and less response time by taking advantage of options available within report studio.
• Carried out bursting of reports in Report Studio.
• Involved in supporting test users to create test scenarios.
• Created walkthrough documentation for the Cube and reports to give users an overview of the report’s capabilities.
• Imported and implemented report specifications into production environment as a part of migrating reports from development to production.

Environment: Cognos 8 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Cognos Powerplay Transformer 7.4, Oracle9i, Windows 2000.