SUMMARY

• 8 years as Business Intelligence Consultant with activities as assistance, evaluation, conniving and stimulation of software. Business Intelligence solutions across multiple industries. As part of the end - to-end implementation, he has gathered and analyzed business requirements, project preparation, blueprinting, realization, final preparation and go live and support for Cognos BI Application.
• Data warehousing is part of Cognos software where it is deal with many big data and form a new data to make importance management decisions. For example combination of two tables with different data except one. (Primary Key like employee ID).
• Experience working directly from business requirements to create technical designs for large scale, high performing, integrated application environments.
• Develop and build multi-dimensional OLAP cubes Cognos Power Play Transformer
• Assist with design and development of operational, financial and ad-hoc report using Cognos 10, Microsoft Access, Excel, VBA and Tally ERP 10
• In-depth knowledge and a practical experience of using Waterfall, Agile, Scrums, Rational Unified Process, Business Process Reengineering, Unified Modeling Language, System Requirements Specification and Functional Requirements Specification, Rapid Application Development, and MS Visio.
• Adhere to report development Life Cycle from Development to Test to production
• Partner with internal customers to perform ‘needs analysis’ in order to develop report solutions for operational and financial reporting/processes
• Partner with internal business customers to collaboratively work through the report development process. Build complex reports related to sales, volume, service evaluations and budget performance
• Analyze current business and reporting processes and look for means to improve efficiency and reduce bottlenecks
• Serve as a key resource for team members within the department
• Assist with setting standards, best practices and performance guidelines
• Able to develop BI solutions that follow standards, best practices that meet or exceed performance guidelines
• Good inter-personal skills and can work efficiently in a team as well as independently
• Provided 24x7 production supports for applications based on Cognos products.
• Worked with data model tools as TOAD and Oracle SQL Developer

TECHNICAL SKILLS

Reporting Skills: Cognos 10, Cognos Report net MR2, Frame Work Manager, Transformer, Configuration Manager, Access Manager, Analysis Studio, Report Studio, Microsoft Office and Query Studio.

Data Base: MS SQL Server 2005/2008, Oracle 9i/10g/11g, TOAD

ETL Tools: SAP BI 7.x/3.x (Trained), SAP BO (Trained), Informatics 8.4(Trained), Data Stage, DataMarts, Staging, OLAP.

Web Servers: Apache, Lighttpd, Jigsaw

Operating Systems: Windows 2003/2007/xp professional/10, Enterprise Server, MAC OS and Linux

PROFESSIONAL EXPERIENCE

Confidential, Nashville, Tennessee

Sr. Cognos Developer

Responsibilities:

• Partner with the Multi Asset or Alternatives Investments team to understand their data & tools requirements for Portfolio management system & research tools
• Help teams to establish and running of Cognus 10 in the institutes.
• Provides project level analysis - producing required project analysis documentation (business requirements, scope matrix, use cases, sequence diagrams, future state proposals, UAT plan).
• Collaborate closely with developers to implement the requirements, provide necessary guidance to testers during QA process, lead UAT with users, etc.
• Worked extensively on relationships between query subjects to better represent the logical structure of the business and the user requirements. Used Dimensional modeling (DMR) and Relational modeling techniques technique to develop FM models.
• Created various IQD in Framework Manager and from this IQD's as source, integrated to Power Play Transformer to create various models and build cubes.
• Created Technical design document for Report studio reports based on Functional specifications.
• Customized Cognos Data source Connection with appropriate reports and security measures
• Created Standard Template design for report studio reports
• Created Active Reports according to the User requirement

ENVIRONMENT: Cognos 10.2(Cognos Connection, Framework Manager, Report Studio and Query Studio), Oracle 9i, IIS 6.0, Windows 2003 Server, TOAD

Confidential, Dallas

Sr. Cognos Developer

Responsibilities:

• Work on strategic projects with the Risk Management business.
• Working on large scale projects as well as handling day-to-day operational requests from the business.
• Work with risk department on fixed income, equity and counterparty risk projects.
• Provides project level analysis - producing required project analysis documentation (requirements, use cases, sequence diagrams, future state proposals …etc.)
• Created the reports Using SQL object by writing the queries manually
• Created Macro Prompts in Report Studio reports
• Performance Tuning of the reports
• Migrated framework packages and reports between different environments (Development, QA and Production).
• Scheduled Reports and Created Jobs to run periodically
• Unit Testing of Reports
• Prepared Unit Test Cases for the Reports
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports mainly through Analysis Studio, Query Studio, and Business Insight.
• Preparation of Cognos Training Presentation for end users
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
• Worked closely with clients to understand, gather and documented business requirements
• Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developed Dashboards, List, cross tab, drill through, master-detail, chart, Active reports and complex reports which involved Multiple Prompts in Report Studio.
• Design and creation of Multi Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Participated in the process of Identifying BI tools for the future.
• Involved in Requirement Analysis, Functional Design and Technical Design.
• Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Developed and documented Informatica mappings and Informatica sessions as per the business requirement.

ENVIRONMENT: Cognos 10.1.1( Cognos Connection, Report Studio, Query Studio, Framework Manager, Business Insight, Advanced Business Insight, Event Studio, Power play and Transformer), SQL Server, IIS 6.0, Windows 2003 Server., TOAD)

Confidential, Wayzata, MN

Jr. Cognos Developer

Responsibilities:

• Administered security to Report net, Cognos 8 environments using Access manager.
• Upgraded Cognos content to the latest version of Report net.
• Created standard list, cross tab, charts and drill through reports in report studio.
• Built reports using conditional blocks to implement certain complex business logic and also implemented conditional styles to highlight business sensitive data.
• Provided data security, object security and package access in Framework Manager. And also secured the folders by setting up access permissions in Cognos Connection.
• Scheduled reports to run daily, weekly and monthly using Schedule Manager.
• Carried out bursting of reports to distribute reports to various end users by email.
• Deployed packages from development environment to production environment.
• Created most commonly used calculations and filters in framework manager and organized into different folders in business view.
• Created ad-hoc reports in Query Studio and Standard Reports in Report Studio.
• Created complex reports using Tabular sets and master-detail queries.
• Tuned the performance of the reports by creating functions, procedures and packages at the database level and filtering out unwanted data at the framework manager level. And also recommended and utilized the aggregate tables in the database to achieve user acceptance level of run - time for the reports
• Prepared documentation for the setup and configuration of the Cognos application.
• Prepared training documentation for the developers to accomplish complex tasks in Report net.
• Installed and configured Development and QA Report net servers.

ENVIRONMENT: Cognos Data Manager 8.4/ Cognos BI 8.4 (Query Studio, Report Studio, Framework Manager, Analysis Studio), SQL Server 2005, Windows Server.

Confidential, Virginia

BI Cognos Developer

Responsibilities:

• Involved in understanding existing Business Model and Customer Requirements by participating in the Design Team and user requirement gathering meetings.
• Involved in creation of standardized testing procedures for report development.
• Built reports using multiple charts with drill-up and drill-down functionality.
• Incorporated Layout Component Reference in the new reports.
• Created Business Intelligence dashboards comprising several lists, charts, and cross-tabs in a single page.
• Expertise in managing multiple projects and coordinating with off-shore team for on-time delivery of report modules.
• Maneuvered complex reporting structures with ease by designing reports with a combination of list, cross tab and charts.
• Tuned report studio reports for improved performance and less response time by taking advantage of options available within report studio.
• Implemented standards in Report design and appearance by following set of predefined rules while applying colors and fonts styles to the report structure.
• Built Complex Reports involving Prompts, calculations, Conditions & Filters.
• Highlighted agent performances using Conditional Formatting for the contest 'Best Agent of the Quarter'
• Worked on scheduling and saving the reports on Daily, Weekly & Monthly basis using Cognos Scheduler.
• Utilized the burst capability in Cognos to distribute the report to end users.
• Implemented Unit testing and Integration testing to ensure the designed reports met required business standards.
• Table of Contents and Bookmarks were used extensively for users to navigate through reports instantly.
• Created reports using Impromptu
• Involved in creation of calculation in model query subjects.
• Added static choices so users can choose string values in a prompt.
• Used conditional blocks to display user specified formats
• Assisted in publishing packages in Cognos connection for report creation in Report Studio and Query Studio.
• Involved in Creation of various list, grouped list, cross tab, and nested cross tab reports using Report Net Report Studio and used Query Studio to create ad-hoc reports.
• Created filter, prompts, and calculations to customize the package for different report authoring.
• Created prompts in reports to add interactivity for users.
• Created Unit Test cases for each report requirement
• Created documentation for all reports.

ENVIRONMENT: Cognos 8.1 (Impromptu, Power play), Oracle 9i. Cognos Report Net 1.1 MR2 (Cognos Connection, Report Studio, Query Studio, Framework Manager), Oracle 9i, IIS 6.0, Windows 2003 Server.

Confidential

Cognos Developer

Responsibilities:

• Serve as a liaison between the Technology organization, business users, and support teams
• Work with Business Intelligence tools such as Qlikview and Qliksense (but not limited to) to develop reports and provide data to stakeholders
• Manage project scoping and estimation activities, document the project scope and approach, review plans with business and technology stakeholders and acquire sign-off from business and technology leadership
• Assist in the business in identifying, assessing, and documenting business requirements
• Assist in evaluating priorities and advise on options, risks, and costs versus benefits of proposed solutions
• Work with Program Managers and Resource Managers to develop a project staffing model, build and manage the project team, define roles and responsibilities of project team members, monitor resource allocations and project budgets
• Document detailed functional specifications and related solution design components based on documented business requirements
• Create a project plan and manage project costs, quality, and schedules to drive project execution activities through implementation and project closure
• Document an overall test plan and ensure full traceability of documented business requirements and solution design elements through documented test cases
• Document, manage, and communicate project issues, risks, and action items
• Hold project status meetings to review overall project RAG status, risks and issues, action items, and assess progress as defined in the project schedule
• Document the implementation plan and facilitate implementation activities
• Provide feedback and lessons learned on project execution and project team performance
• Regularly monitor reporting systems (and underlying dependencies) to detect and fix errors

ENVIRONMENT: Cognos 7 (Cognos Connection, Report Studio, Query Studio, Framework Manager, Power play and Analysis Studio), Oracle, IIS 6.0, RHEL.

Confidential

Cognos Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Worked with different sources such as relational databases, flat files for extraction using Source Qualifier and joiner.
• Created the mappings using the transformations like Source Qualifier, Joiner, Look up, Filter, and Update strategy.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Work lets for data loads. Created reusable transformations and Mapplets to use in multiple mappings
• Implemented performance issues on mappings to increase the efficiency of loading the data from various metrics to the target database.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

Environment: Informatica Power Center 6.1(Power Center Designer, workflow manager, workflow monitor), Oracle, TOAD, Windows XP.