SUMMARY:

• 9 + years of experience in IT in various disciplines as a Programmer/Developer/Admin in different industries.
• 8+ years of Business Intelligence Experience in Cognos with special emphasis on analysis, design, testing, development, documentation and implementation of Cognos applications and ETL methodologies in all the phases of the Data warehousing life cycle .
• Experience in Cognos11.0.7,10 (10.2/10.2.1/10.1.1/8.4/8.3/8.2/8.1 ) Suite (Framework Manger, Cognos Connection, Report Studio, Query Studio and Analysis Studio) with expertise in Metadata Modeling - Create project, Prepare Metadata, Prepare the Business View, Create and Manage packages, Set security and publish into portal.
• Expertise in creating adhoc reports, Dashboards and scorecards building using Report Studio, Query Studio Analysis studio and Workspace.
• Experience on configuring Cognos Environment, setting up security, notifications, content store in a large distributed environments.
• Strong in developing Cognos Framework manager models and publishing the packages into Cognos environment using various data sources like Oracle and SQL Server etc.
• Worked on end-to-end process of installation, Configuration and migration of Cognos 10.2.2 for large number of applications across diverse regions.
• Developed Metadata Models and DMR models using Framework manager and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Expertise in Transformer model design and Power Play Cube building.
• Collaboration with the ETL development team and closely work with them in the process of extracting data from different data sources, data transformation and loading the data into data warehouse for analytical purpose.
• Worked closely with business users and analysts in requirement gathering process for reporting.
• Good Understanding of the principles of DW using fact tables, dimension tables and star schema, snowflake schema modeling and EDW .
• Implemented Data Security, Object Security, Package Security in Framework Manager and created user classes, roles or groups as per the requirement.
• Developed Highly Interactive Reports for various Business groups using Cognos Active reports.
• Experienced in Oracle database application development, SQL and PL/SQL.
• Working knowledge on different data sources Oracle 7.x/8i/9i/10g/11g, SQL Server 2005/2008, Confidential DB2 UDB 7.x/8. x.9.x databases.
• Knowledge in generating reports using Obiee and Tableau BI reporting tools.
• Comprehensive involvement in all phases of application lifecycle development in analysis, development, testing, debugging and User Acceptance Testing (UAT) with QA team.
• Possess good technical and communication skills desirably. Ability to play as a great team player and a quick learner with quality leadership skills.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, C, Core Java

ETL Tools: Confidential Data Stage (7.5/7.5.2/8.1 )

Data Warehousing: Cognos (11.0.7, 10.2.2/10.2.1/10.1.1/8.4/8.3/8.2/8.1 ), Framework manager MR1 / MR2/ MR3/ MR4, Cognos Connection, Cognos Power Play Transformer 7.1 / 7.0/ 6.6/ 6.5 , Power Play 7.1 MR2/ 7/ 6.6/ 6.5, IWR 7.1 MR2/ 7.0/ 6.0, OBIEE 10.1, Tableau 8.3

Databases: Oracle 8i /9i/10g/11g, Confidential DB 2 8.1.5/8.2.7/9.7.3 , Confidential DB2 UDB V8, MS SQL Server 2005, 2008,2012

Job Scheduling Tools: Tivoli Work Scheduler 7.0

Operating Systems: Windows 2012 R2/ NT/2000/XP/Vista/95/98/7, UNIX, DOS, Linux, Centos.

Internet Tools: HTML, DHTML, XML, JAVA SCRIPT

Developer Tools: SQL*Plus, SQL*Loader, Toad for Oracle 10.5/9.5/9.1/8.0 , Toad for DB2 5.0, DB Visualizer 8.0.7, Confidential Clear Case V7.0.1.0, Clear Quest 8.0.1.1

PROFESSIONAL EXPERIENCE:

Confidential, LA

Sr BI Admin/Developer

Responsibilities:

• Currently working in complete Migration project starting from setting up Development and Production Environments for the migration of the Cognos cubes, reports from 8.3 to 10.2.2 and 10.2.2 to Cognos Analytics (Cognos 11.0.7) and supporting, developing new and existing reports enhancements to the current production environment.
• Involved in setting up all 4 Cognos servers and installed Cognos 10.2.2 and Cognos 11.0.7 for Development and Production environments.
• Installed Cognos 10.2.2/11.0.7 in different development environments and migrate the cognos 8.3 cubes, existing reports successfully in to Cognos 10.2.2 and 11.0.7 Cognos Dev Servers.
• Deploy successfully existing Cognos Cubes and Reports from 11.0.7 Dev server to Production server.
• Involved in Configuring Cognos production servers for F5 load balancing .
• Involved in installation and configuration of IIS with Cognos 11.0.7 Analytics application.
• Implemented SSL Certificates in Windows 2012 R2 and configure with Cognos applications.
• Involved in pointing to the current existing Cognos reports to new Oracle schemas and migrate to Cognos 11.0.7 Productions servers.
• Extensively worked on Cognos Framework Manager - Creating Models in Framework Manager - Importing Meta Data from Different Sources, Dimension Hierarchy and Packages.
• Supporting both current and new production environments.
• Worked on Requirement gathering & understanding the requirement and implementing them in Cognos.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Confidential, Princeton, NJ

Cognos BI Consultant

Responsibilities:

• Understanding existing business and customer requirements.
• Design of Framework Manager Metadata Models (Relational).
• Implementing business logic and calculation in Framework Manager for ad-hoc reporting.
• Created standard report templates for business users for ad-hoc reporting.
• Analyzing existing Excel reports and created the same reports in Cognos using Report Studio.
• Preparing Dashboards using calculations, parameters in Cognos Report studio.
• Developed complex executive Dashboards Year Over Year, Performance Summary Dashboards with multiple charts, list reports, cross tab reports and Drill through reports
• Prepared mock up designs for the customer requirements and suggest them the best way of display for reports on complex dashboards.
• Worked on Trend lines to display positive and negative values for the green and red trend lines on YOY dashboard.
• Worked on calculations and added variance for the YOY and Performance Summary Dashboards.
• Cognos Framework models around 50 packages have been upgraded from lower to higher version.
• After report migration make sure there are no issues with canned and query studio reports.
• Report layouts and values have been verified between lower and higher versions.
• Involved in import Rave visualizations and added to the existing Cognos reports for Dashboards.
• Extensively worked on understanding the business requirements and Involved in performance tuning for Reports.
• Created Active reports using Data Deck and Data Tab controls.
• Used Java Scripts to derive various business requirements.

Environment: Cognos 10.2.2, (Report Studio, Query Studio, Framework Manager), Oracle, sql developer.

Confidential, Pleasanton, CA

Lead Cognos Developer

Responsibilities:

• Collaborate with Off shore and on shore teams, worked on Confidential Cognos Production Tickets for both EDW and CBIA Data warehouses and resolved them in time.
• Coordinate with off-shore developers on defects, development issues on various staging (UAT) and production environments.
• Install the Confidential Cognos applications on AMIs and configure all required software configurations and provide data as needed using AWS management console.
• Create an Amazon Web Services (AWS) account and log into the AWS management console.
• Assist with Support tickets and responding to developer questions; troubleshoot bugs and issues recorded in JIRA and coordinate with Lead Developers on status.
• Given full KT of Cognos Existing reports and FM packages to off shore team regarding EDW and CBIA Data warehouses and coordinate with them.
• Prepared Roadblocks, Risks for Data marts for the EDW, Deployment process, User Administration and send them to client manager in time.
• Developed requirement specification documents with inputs given from Power users and also designed report mockups when required.
• Involved in getting Cognos, database access to entire team and worked with approvals and provide them to team.
• Involved in Cognos Existing Reports Enhancements which required approvals from report owners and worked with off shore team.
• Involved in Manual weekly reports Weekly ‘Sale Weekly Sale New Hire/Termination’ and ‘Sales Head Count’ reports and mail them to users in time.
• Worked on modeling the metadata extracted from multiple databases and established joins and cardinality to meet the business needs.
• Scheduled meetings with offshore team on daily basis and reviews production tickets status and send the status report to higher management.
• Involved and worked with existing Active reports and enhancements according to user requests.
• Involved in the Deployment process and deploy cognos FM packages and reports Code from Dev to Uat and Uat to Prod and help the team members to resolve the Deployment issues.
• Involved in review the CRM Unification stories and provide an estimate to develop the effort.
• Monitor CBIA COGNOS incident and service request queue.
• Involved in adding new users in to Cognos environment and assign them roles and permissions.
• Schedule meetings with off shore and on shore team on daily basis.
• Manage builds and releases, created Release Notes.
• Mentor new hires, provide training and conduct knowledge share sessions.

Environment: Cognos 10.2, (Report Studio, Query Studio, Framework Manager, Analysis Studio), Oracle, ODI 11g, Oracle sql developer, Toad, linux5.0, JIRA

Confidential, Sacramento CA

Cognos Admin/Developer

Responsibilities:

• Involved in the Administration, analysis, design, development, testing and deployment of analytical & transactional reporting system.
• Installed Cognos 10.2.2 and configure on windows servers.
• Assigned security for users on folders, business units, Report studio, Query studio, Analysis studio and Metrics studio in DEV, UAT and PROD environments.
• Maintained the LDAP group structure with in Cognos environments.
• Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain, and secure Cognos reports.
• Worked on extracting the queries and sending them to Business Analyst for further Analysis.
• Worked on various PSR Reports implementing and making the existing report changes according to requirements.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Interacting with the Application Developers on a regular basis for resolving issues pertaining to the reports.
• Maintain knowledge of Confidential data models and data dictionary for the purpose of maintaining Cognos packages and enhancing user awareness of business data.
• Created Burst reports for both Internal and External Users.
• Customized data by adding the Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.
• Coordinate with batch team and involved in scheduling Batch reports for internal and external users.
• Maintain the existing package(s) and suggest for ways of improving the performance and maintainability.
• Involved in making the SQL changes for exiting reports for various Operational, PSR, and Production reports.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Maintain existing Framework Manager Package and Build New Packages as per reporting needs.
• Involved in Assembly Test and System Test for the Cognos reports and worked with testers.
• Worked with different existing FM packages and making the changes as per assigned SIR Requirements.
• Involved in Cognos production issues and worked with the team members and resolved.
• Involved in Extracting the SQL for the various Model based Reports and submit to the lead for further analysis.
• Also involved in Merging Framework Manager code and reports code in to clear case for team requests.
• Reviewed and analyzed the data from various sources.
• Unit testing, Integration testing and system testing of the reports in different environment’s.
• Educate and provide knowledge transfer to report developers and business users on Cognos tool and best practices.
• Played as a good mentor to the newly joining team by giving knowledge transition in both technical and functional areas.

Environment: Cognos 10.2, (Report Studio, Query Studio, Framework Manager), OBIEE 11g ODI 11g, Oracle, Oracle sql developer, Toad, linux5.0, Clear Case V7.0.1.0, Clear Quest 8.0.1.1

Confidential, Boulder, CO

Sr. Cognos Developer / Admin

Responsibilities:

• 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.
• Built Framework Manager Models, and established the cardinalities to suit the business needs.
• Worked as a gate keeper and involved in cognos code deployment from DEV to UAT and UAT to PROD for entire team and involved in resolving the deployment issues.
• Involved in Migrating the reports from Actuate to Cognos 8.4.1/10.1.1/10.2.1 Environment.
• Developed Standard Reports, List, Cross tab, Charts, Drill-through Reports, Master Detail Reports, using Report Studio and Query Studio.
• Developed Dash Board reports and DTS (Direct to source reports) reports and custom reports in Report Studio for number of Confidential clients like Broad Ridge Financial solutions, The Firm, Healthnet, State Street, Omers. etc.
• Created Direct to source reports (DTS), Service level metric reports and custom reports using requirements from different RAs.
• Modifying the existing reports upon the change request by different users from different clients.
• Customized data by adding the Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.
• Created Packages in Framework Manager and publish packages to Main folders for report studio.
• Implemented security for Data access, Object level access and Package access in different packages for different users.
• Involved in Migration process and deploy the code for Framework Manager Models and reports from Cognos Version 8.4.1 to 10.1.1 and 10.1.1 to 10.2.1.
• Created Information Objects (IO's) using FM and published to the Main folders and make this IO's are available to users.
• Responsible for Deploying Models and Reports from Development to Production using Motio tool for the whole team and resolve the issues while deploying.
• Debugging the queries and Resolve the Performance Issues of the reports.
• Unit testing, Integration testing and system testing of the reports in DEV, UAT, PROD and ISC environments.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Worked on Problem tickets and resolve the issues in time by coordinating with ETL and Database teams and support most of the Confidential clients like state street, Broad ridge financial services etc - - -
• Worked on Change tickets and deploy the code in to UAT, PROD and ISC and also Interact with users remotely and help them running their own queries.

Environment: Cognos 8.4.1/10.1.1/10.2.1 (Report Studio, Query Studio, Framework Manager) Data stage, Windows 7, Linux5.0, Linux 6.0, DB2 9

Confidential, Rye, New York

Admin/Senior Cognos Developer

Responsibilities:

• Imported metadata from various sources such as Relational Databases, Cognos8.4 models into the Framework Manager.
• Designed Model query subjects and published packages for creating different report studio and query studio reports.
• Created business views, namespaces, model query subjects in Framework Manager Model for easier report development and to enhance multi user environment.
• Worked on relationships (cardinality) between query subjects to better represent the logical structure of the business and the user requirements.
• Adding business rules by defining different kinds of calculations and filter.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Involved in the Installation and Configuration of Cognos 8.4 BI tools and Framework Manager.
• Created list reports and chart reports using multiple queries in a single report.
• Created reports ranging from ad-hoc to complex reports using drill through, conditional formatting and cross tab reports.
• Customized data by adding prompts, Filters, Calculations, Summaries and Functions.
• Involved in implementing column level Data security with in Confidential Cognos for a particular user.
• Involved in Performance Tuning the reports in Report Studio.
• Created Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Scheduled reports to run on daily/weekly/monthly basis and sending report links to users through email.
• Worked on Creating prompts and cascading prompt pages.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Involved into deploy the Models and reports from development to UAT and PROD.

Environment: Cognos 8.4 (Report Studio, Query Studio, Framework Manager, Transformer8.4), Cognos Report Net 1.1 MR3, Framework Manager, Power play 7.4, Impromptu, IWR, Oracle9i, Informatica, Windows2003, Linux5.0, Oracle 10g and Toad.

Confidential, Rockville, MD

Cognos Developer

Responsibilities:

• Involved in the Installation and configuration of Cognos 8.3 Environment and Customizing the cognos connection portal.
• Developed Framework Manager Models with physical layer and presentation Layer to cater the various business needs.
• Defined relationships and cardinality between different database tables.
• Defined data sources and their associated connections in COGNOS Connection.
• Made use of complicated queries, conditions and filters. Extensively used conditional blocks, conditional formatting, conditional texts, different prompts and Static choices for the graphs.
• Implementing the YTD, QTD, MTD calculations in the reports using the Report Studio.
• Creating reports based on DMR Model, Cubes using MDX Functions.
• Fine-tuned the queries for performance purpose and enhanced the performance of the reports.
• Extensively used cascading prompts, drill-through, summaries, conditional formatting, grouping and sorting features to generate efficient and user-friendly reports.

Environment: COGNOS 8.3/8.4(Report Studio, Query Studio, Analysis Studio, Metric Studio), Oracle 10g, PL/SQL, Microsoft SQL Server 2005 database, Informatica, Microsoft SQL Server Windows XP/2003.