SUMMARY

• 11 years of IT experience with 8 years' experience in full life cycle project development including design, coding, testing, implementation, document and ongoing production support for Cognos 10.2, 8.x, 7 on multiple database platforms.
• Extensive experience on different Cognos 10.2 products Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Business Insight, Business Insight advanced, Life Cycle Manager, Real time monitoring, Mash up, Mobile .
• Experience in installation and configuration of Cognos 10.2, Cognos 8.X BI, 7 Series.
• Great breadth of knowledge about how to implement Business Intelligence solutions across the many different functional areas of an organization.
• Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.
• Strong understanding of designing dimensional and relational models, star and snowflake schemas and different DW design paradigms.
• Strong proficiency in different SDLC methodologies including Agile and linear models.
• Experience Creating Reports using JavaScript and cascading style sheets.
• Delivered solution-oriented complex reports using Report Studio and development of ad-hoc reporting interfaces using Query Studio and analysis of reports from cube packages using Analysis Studio.
• Created dashboards using Business Insight with individual RS created objects.
• Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio
• Expert level with developing OLAP models, using Power plays Transformer.
• Expert level with developing metadata models in Framework Manager following best practices
• Experience with Multiple Relational Databases including Oracle, SQL Server, Teradata and IBM DB2.
• Experience in designing and developing of indexes, views, materialized views, triggers, functions, stored procedures and packages.
• Strong experience in COGNOS administration and security tasks.
• Experience in client side scripting using VB Script and Server side using Java script.
• Experience in Client/Server application development using Visual Basic, ASP and MS SQL Server.
• Experience working at State Govt projects at New Mexico, Missouri, District of Columbia, South Carolina and Common wealth of Massachusetts.
• Experience in developing Project process related documents as per the CMM i standards.
• Capable of working in groups as well as independently with excellent communication skills.
• Good in trouble shooting with quick turnaround in fixing the issues.

TECHNICAL SKILLS

• OLAP Tools: Cognos 10.2, Cognos 8.4 BI, Business Objects XI Rel 2.0.
• ETL Tools: Informatica 8, Data stage 7.5, Microsoft SSIS 2008, Cognos Data Manager.
• Data Bases: Oracle 11G, SQL Server 2008, Teradata V2R6, DB2 8.0
• Web Servers: Apache web server, IIS 7.0.
• Languages: C, HTML, SQL, PL/SQL.
• Internet Technologies: HTML, DHTML, ASP, Java Script and VB Script, XML.
• Tools: MS Office, Visio, Erwin, TOAD, VSS.
• Operating Systems: Windows XP, UNIX, Linux.

EXPERIENCE

Confidential

Senior Cognos Consultant

Responsibilities:

• During the nascent stages of the project, I was actively involved in understanding the way the existing legacy systems were structured and operated
• Worked closely with the Business Analyst System Analyst on the client side to define the scope of the reporting component. Actively involved in organizing and attending functional design sessions for various reporting components.
• Translated the notes gathered during these design sessions into functional design documents that were later used for report development.
• Shared the duties of developing metadata models using Cognos Framework Manager for enterprise wide reporting.
• Developed the model in line with best practices suggested by Cognos. Model was developed with a Database Relationship Layer, Business Layer and Presentation Layer.
• Assisted in upgrade of Cognos from 8.4.1 to 10.2. Upgraded all models and reports and validated those to make sure nothing was broken during the upgrade process
• Personally developed over 40 medium to highly complex reports.
• Responsible for assisting and guiding the junior developers in the development of reports.
• Developed Adaptive Dashboards for various Business groups using Cognos Active Reports.
• Involved in creating Cognos Business Workspace.
• Developed highly analytical reports that track Environmental risk activity, Crude rate, adjusted rate, Confidence Interval.
• Many of these reports were developed using highly beneficial features of Cognos such as Drill Through, Conditional Rendering, Style Formatting, Component Reference components, Embedding HTML Components for Maps.
• Provided production support with the issues occurring in the environment for daily, monthly reports.
• Involved in the Cognos administration like creating new data source connections and creating packages, handling the deployment of reports from development to production server and also handling the user permissions on the packages and folders.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Created test plans, cases and scripts from use cases and other user requirements.

Environment: Cognos 10.2 BI, Business Workspace, Transformer, Report Studio, Analysis Studio, Framework Manager, Oracle 12G.

Accomplishments Benefits: This project has greatly helped me to expand my professional expertise. I gained in working on a vast project like this puts me in good stead for my future assignments.

Confidential

Senior Cognos Consultant

Responsibilities:

• Analyzed the business functional requirements and worked with the business units to define the strategy of the business and created IBM centralized reporting capability.
• Created multiple relational models and DMR models based on the requirements.
• 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.
• Defined package level, object level securities to allow users create calculations over the query items.
• Modified Power Cubes by adding new Dimensions, Levels and Measures.
• Designed summary and detail reports which involves the key functionalities of the report studio like conditional blocks, conditional layouts. Designed reports which involve drill down, drill up and drill through functionalities in report studio.
• Developed analytical reports for Enrollments, Scholarships, Completions, SAT, Programs, Courses Faculty.
• Created drill through definitions in the reports based of the cubes to drill down to detail level of the data.
• Created dashboard-style reports combining list, cross-tabular, and chart displays to give executives an at-a-glance .
• Responsible for troubleshooting Cognos BI Server issues.
• 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.
• Coordinating with the ETL team in defining the ETL logic for Reporting table loads and in setting up the timely schema refreshes for the Reporting Schemas.
• 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.1 BI Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer , DB2, AS400.

Accomplishments Benefits: This is challenging assignments that I worked on due to lack of clear direction and business rules and nevertheless I learnt to maximize my efficiency in a fast paced working environment under pressure to meet deadlines.

Confidential

Senior Cognos Developer/Admin

Responsibilities:

• Communicate with the internal business users to gather requirements and systems analysis of business process and create functional and Technical specification documents.
• Involved in Technical Architecture to set up new servers for Cognos development, UAT and production environment and upgrading from Cognos 8.4 to Cognos 10.1.
• Managing user access and Cognos capability mapping through LDAP groups.
• Generating ad-hoc reports from audit database regarding usage, user count, report or cube build failure tracking etc when demanded by projects.
• Debugged and suggested solutions for problems in existing Report designs
• Used Cognos Best Practices for creating FM Packages, Reports, Dashboards and cubes.
• Created Dashboards in Cognos Business Insight for Slots by Applying filters and Configuring widget controls to customize the dashboard.
• Created Dashboards in IBM Cognos Business Insight Advanced for Slots using chart widget, crosstab widget and Formatting layout by drill up and drill down and Applying conditional formatting to the dashboard.
• Conducted User training for Business Insight Advanced users.
• Created Analysis studio reports using Nested crosstabs, context filters, Drill through.
• Created Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Manage tasks and effort for enhancement releases and other critical support activities.

Environment: Cognos 8.4, 10.1.1 BI Life Cycle Manager, Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer , Teradata 13.

Confidential

Senior Cognos Consultant

Responsibilities:

• Study and analysis of the business requirements gathering, understanding client's data warehousing requirements and system analysis of business process.
• Collaborate with business users to capture and document their analytical requirements.
• Strong experience with client interaction, understanding business applications, business data flow, data relations to gather Requirements and create functional and Technical specification documents.
• Translate requirements into flexible semantic layers Using solid semantic layers, deploy solutions that provide easy to build ad-hoc analyses and visualizations.
• Interacting with the users for understanding of Data Analysis of Fixed assets module and deriving its underlined table structure.
• Involved in upgrading from Cognos 8.4 to Cognos 10.1.1
• Identifying the relationships between FA module tables and designing facts and Dimensions from Oracle EBS system.
• Used Cognos Best Practices for creating FM Packages, DMR and Reports.
• Developed various financial reports including income statements, balance sheets and cash flow reports.
• Performed Cognos administrative tasks including security, user accounts, software installations and deployments
• Created Dashboards in Cognos Business Insight for Assets by Applying filters and Configuring widget controls to customize the dashboard.
• Created Dashboards in IBM Cognos Business Insight Advanced for Fixed assets using chart widget, crosstab widget and Formatting layout by drill up and drill down and Applying conditional formatting to the dashboard.
• Developed interactive Dashboards using in-report prompts, custom portal pages and inter-portlet communication techniques
• Skilled at training users to use Query Studio, Analysis Studio and Business Insight Advanced.
• Created Analysis studio reports using Nested crosstabs, context filters, Drill through.
• Created several Reports with Conditional Formatting, Conditional Page layout, Master-detail, Drill Through, Scheduling.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.

Environment: Cognos 8.4.1, Cognos 10.1.1 BI Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insight, Business Insight advanced, Power play Transformer , Oracle EBS 12.1, Oracle 11g, Toad.