SUMMARY:

• Over 7 + years of experience in IT Industry which includes 5+ years in analysis, development, testing and implementation of Business Intelligence applications using Cognos Analytics Suite and other BI products.
• Good business knowledge for report requirements in Financial, Power, Healthcare, Retail and Insurance Industries
• Expertise inCognos Analytics and Visualization including Cognos Analytics BI Suite (Framework Manager,Cognosconnection, Work Space, Work Space Advanced, Report Studio, Analysis Studio, and Query Studio) and Cognos 11, 10.2/10.1/ 8.4/8.3/8.2 Suite Product.
• Expert in creating List, cross tab, drill through, master - detail, chart and complex reports which involves Multiple Prompts in Report Studio, Bursting of Reports using various forms of outputs.
• Developed and Published Packages using Framework Manager- Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Experienced in working with Cognos SDK using Java.
• Complex Report Building Experience by using native SQL, Filters, Prompts, Conditional Formatting, Dashboard Reporting using Master/Detail queries, Ranking, Drill-through, Cross tabs, Bursting and performance tuning the cognos reports
• Expertise skills with Cognos Transformer, analysis studio. Includes performance tuning for long cube build time, building cubes incrementally, building sub-cubes, partitioning etc.
• Hands on experience working with databases Oracle 12c/11g/10g and MS SQL Server 2008/2005/2000
• Strong troubleshooting and production Support skills and coordination, interaction with users.
• Good Knowledge in creating Active Reports using report Studio
• Good working knowledge in Multi-Dimensional Reporting Using Report Studio
• Excellent knowledge in writing Transact SQL, PL/SQL codes.
• Strong emphasis on User Requirements Gathering and Business Rules, Business, Technical, GAP and Data analysis, Writing Business, Functional and Technical specifications, Test plans, Creating and maintaining Project Plans
• Experience in configuring security for data sensitive reports for multi user single mart environments.
• Strong analytical and problem solving skills, excellent planning and multi-tasking abilities, with proven experience in utilizing people and process knowledge to help enterprises make critical decisions.
• Excellent verbal and written communication skills, analytical, documentation and interpersonal skills
• Good knowledge of Business and quality standards and processes.
• Worked in Capability Maturity Model (CMMI) environment and well versed with industry best practices

TECHNICAL SKILLS:

Cognos Tools: Cognos Analytics 11.0.6, 11.0.8, 10.2.1/8.2/8.3/8.4, (Framework Manager, Query Studio, Report Studio, Analysis Studio, IBM Cognos Transformer)

Databases: Oracle 10g/11g/12c/, MS SQL Server 2014/2016/2017 MS Access.

Querying Tools: Toad, SQL- Plus, SQL Developer

Data Modeling: Star Schema and Snowflake Schema Modeling, Framework Data Modeler

Languages: PL/SQL, HTML, C, Java Script

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

BI Analyst/ Sr. Cognos Developer

Responsibilities:

• Interact with Client and Client Managers and Business users to gather requirements and assisting in enhancement to existing reports.
• Create and Develop visually rich Dashboard and Visualization with directly interacting with the Client.
• Design, develop, test, and deliver self-service infrastructure and business intelligence (BI) content including reports, Visualization and dashboards to Client using the IBM Cognos Analytics.
• Design, develop the Testing Complex Reports using Report Studio.
• Perform early stage analysis of reporting requests to formulate high level approach and estimates
• Analyze end user requirements to design report mock-ups specifications and production reports
• Articulate data sourcing and data model requirements to ETL and database resources and collaborate on development
• Analyze report SQL and implement changes to optimize query performance.
• Developed and Published Packages using Framework Manager- Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Gather requirements from business users, communicate status updates, and coordinate issue management
• Contribute to the ongoing development and improvement of BI reporting processes and standards

Environment: Cognos Analytics 110.8 (Visualization, Dashboard, Data Module, Report Studio, Cognos Connection, Cognos Administration, Framework Manager), Oracle 12c, SQL, PL/SQL, Html, Unix, SQL Server

Confidential

BI Analyst/ Sr. Cognos Developer

Responsibilities:

• Interacting with Sr Business managers and Business users to gather requirements and assisting in enhancement to existing reports.
• Analyzed data sources for existing reports built on Access database.
• Worked with ETL design team in identifying source to target mapping and applying business rules for data transformation.
• Identifying facts and dimension tables, involved in the design of data model using star schema.
• Created detailed design documents for reports and suggested enhancements to the business team.
• Developed various complex and customized reports using prompts like value prompt, date prompt, cascading prompt, Select & Search Prompt and using conditional formatting.
• Involved in setting up sign-on for Groups/Roles to secure the Models and packages
• Customized data by addingFilters Prompts, Calculations, Summaries and Functions
• Developed complex reports like multipage reports with master detail relationships, Prompts, Calculations and
• Conditions using Cognos report studio In PDF and excel and adhoc reports using query studio
• Assisted Business Relationship Mangers in creating report analysis from analysis studio using the cube packages as source
• Created List, Cross Tab, Repeater, Chart reports and drill through reports in report studio
• Involved and performed unit testing (manual testing) for the reports that have been developed
• Modeled the metadata in the project by adding business rules such as filters and calculations
• Developed dashboard using Report Studio which include crosstabs, Lists and charts.
• Created various packages using Framework Manager.
• Worked on developing Active Reports using Report Studio

Environment: Cognos 11.0.6, 10.2 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manager), Cognos transformer 10.1 Oracle 10g, SQL, PL/SQL, Html, Toad for Data Analyst 2.5, Windows 7/XP.

Confidential

Sr. Cognos Developer

Responsibilities:

• Involved in Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications
• Developed various complex and customized reports using prompts like value prompt, date prompt, cascading prompt, Select & Search Prompt and using conditional formatting as well
• Created drill through definitions in the reports based on the cubes to drill down to detail level of the data.
• Developed complex reports like multipage reports with master detail relationships, Prompts, Calculations and
• Conditions using Cognos report studio In PDF and excel and adhoc reports using query studio
• Assisted Business Relationship Managers in creating report analysis from analysis studio using the cube packages as source
• Created List, Cross Tab, Repeater, Chart reports and drill through reports in report studio
• Involved and performed unit testing (manual testing) for the reports that have been developed
• Modeled the metadata in the project by adding business rules such as filters and calculations
• Build power cubes with package as source using Cognos transformer
• Generated packages out of the cubes and published onto Cognos connection
• Created Framework packages with various security settings and published onto Cognos connection.
• Created Database layer, Business layer in the model by defining appropriate relationship between query subjects
• Involved in Documentation and Users on Query Studio for Ad-Hoc Reporting
• Created Dashboards in IBM Business insight
• Worked with Analysis Studio to develop multi-dimensional reports and applied context filters for better analysis
• Involved in developing Drill up and Drill down reports using Analysis Studio
• Wrote SQL Statements for data validation in Reports created in Report Studio.
• Administering user access to reporting applications which includes setting up Cognos security by assigning users to the groups and roles defined in the Cognos Namespace
• Perform day to day Cognos administration and production support activities
• Conducted multiple sessions with management, end users for open and pending issues and for customizing reports, fixing the errors in the data as a part of production support
• Giving Access to different folders, Packages, Reports based on the users request
• Scheduled and distributed reports using Schedule Management in Cognos connection
• Performed unit testing and documented test cases and detail design of the project

Environment: Cognos 10.1/8.4 (Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manager),Cognos transformer 10.1 Oracle 10g, SQL, PL/SQL, Html, Toad for Data Analyst 2.5, Windows 7/XP.

Confidential, Dallas, TX

Sr Cognos Developer

Responsibilities:

• Worked with business analysts and end users to understand business rules and interpret data.
• Developed Framework Manager Design documentation and Report documentation.
• Worked on Cognos SDK using JAVA to Display a list of IBM Cognos BI reports in a custom web page
• UsedAnalysis Studio to build Multidimensional Reports.
• Developed List, Cross tab, Drill through, Master-Detail, andCharts which involved Multiple Prompts, Multiple Frames, Filters, Multi-page, Multi-query reports against different data sources inReport Studio.
• Created the Reports in different formats like PDF, XML, HTML, Excel and CSV.
• Involved inBursting Report Studioreports and sending reports via Email to several business users.
• Involved in scheduling Report Studio and Query Studio reports inCognosConnection.
• Created Packages whichincludes Query Subjects, Joins, Filters, Prompts inFramework Manager.
• Published thePackages toCognosConnection.
• UsedCognosConnection for organizing, security, scheduling and distributing reports.
• Developed ad-hoc reports in Query Studio.
• Extensively Used PL/SQL.

Environment: Cognos8.4 (CognosConnection, Framework Manager, Query Studio, Report Studio, Event Studio, Metric Studio, Analysis Studio) IBM Cognos SDK, Oracle 10g, SQL, Windows XP.

Confidential, Atlanta, GA

Cognos Developer

Responsibilities:

• Participated in discussions with the senior management to create the business requirements.
• Created different Data sources and Created model using different Data Sources and created packages and published to the Cognos portal.
• Created Drill Through reports and Conditional Formatting by using Report Studio.
• Created reports like List, Cross tab and Dashboards by using Report Studio.
• Extensively worked on complex reports using tabular sets, child tabular models, drill through reports, master detail reports, conditional prompts. Developed Multi Page Reports.
• Created user groups, Roles to implement the Cognos security using Access manager.
• Customized Cognos Connection Portal to personalize the homepage.
• Created the documentation for cubes & Reports. Testing and Validating the Reports
• Managed Scheduling of Reports
• Involved in analyzing the cardinality between query subjects.
• Customized data by adding Calculations, Filters, Prompts and Governor Settings.
• Production Support which involves solving user problems.

Environment: Cognos 8.2 (Framework Manager, Cognos Connection, Report Studio, Query Studio), SQL server.

Confidential, Bentonville, AR

Cognos Developer

Responsibilities:

• Involved in analyzing, documenting functional and technical requirements for developing packages and reports.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Involved in building ad-hoc and complex reports using prompts and parameters in Report Studio and Query Studio.
• Involved in setting up sign-on for Groups/Roles to secure the Models and packages.
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and multiple Prompts in Boards.
• Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
• Also involved in planning a model which help the business in making suitable decisions.
• Experienced in creating security setup in Cognos 8.3 BI environment.
• Developed list, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query, Burst Reports against database.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.

Environment: Cognos 8.3 BI Series, Power Play, Framework Manager, Oracle, SQL Server, PL/SQL, Windows 2000, Microsoft Excel

Confidential, Carson, CA

Cognos Developer

Responsibilities:

• Develop reports with Report Studio to perform easy views and access the information to all corporate staff with the best practices.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports
• Create and update the Technical Documentation and Detail Documentation of each process within Cognos Report studio.
• Assist in the development of the metadata layer in Framework Manager in conjunction with the logical and physical data models
• Developed reports with Prompt pages and Conditional Variables
• Design and Develop Cubes
• Design and develop reports based in a G/L Catalog.
• Deliver reports within tight date lines and milestones.
• Develop multidimensional power cubes using, using Transformer.
• Communicate a data model for reporting requirements to business users and architect

Environment: Cognos 8.2 (Framework Manager, Cognos Connection, Report Studio, Query Studio), SQL server 2005

Confidential

Business Analyst

Responsibilities:

• Analyzed and collected business requirements identified system interfaces and created the requirements specification document.
• Performed Requirement Analysis to Develop Use Cases, Activity Diagrams and Sequence Diagrams. Hence developed and documented conceptual design of Application in System Specification Document.
• Extensively interacted with both user group and development team in coming up with structured charts, Class and sequence diagrams.
• Managed and tracked change control process of requirements and design changes using Rational Requisite Pro. Documented the changes, issues and their impact on the system design and delivery.
• Provided documentation such as requirements management plans, functional requirements, test plans and test cases.
• Incorporated the best practice methodologies as advocated by the Rational Unified Process.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis
• Created requirements traceability matrix (RTM) using Requisite Pro. Performed user interviews, JAD sessions.
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Designed and developed project templates based on SDLC Methodology
• Developed UML Use Cases for the application using Rational Rose and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Developed modules in the HR department for educating and the user about the new system.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on daily basis.

Environment: RUP, Rational Requisite Pro, Rational Rose, Oracle, MS Project, MS office suite