SUMMARY

• Over seven years of IT experience in analysis, design and implementation of business intelligence systems, reporting tools, OLAP environments and tools, along with strong analytical and technical skills.
• Strong experience in implementing and architecting BI solutions using Cognos 10/8.x BI Suite for large and mid - sized client implementations.
• Interacted with end users on a regular basis for resolving issues pertaining to the reports.
• Excellent knowledge of data warehousing concepts, star schema, snow-flake schema and worked on both OLAP and OLTP databases.
• Developed Metadata Models and DMR models using Framework manager and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Experience implementing security (data level,object level and package level).
• Implemented best practices (database layer, logical layer and presentation layer) in Framework manager.
• Involved in creating simple list reports and complex reports like Master detail, Drill through and Cascading prompt reports using report studio.
• Complex report building experience using Tabular Objects, Tabular SQL, Filters Customized Prompts, Conditional Formatting and complex layouts like CrossTabs, Sub Reporting and bursting.
• Expertise in relational and dimensional modeling.
• Deployed models and reports from development to production environments.
• Experienced with multiple relational databases including Oracle, MS SQL server, DB2, Oracle 11g and Teradata.
• Involved in analyzing multidimensional cubes using Power play studio and Analysis studio.
• Strong experience in migration of Cognos report from 7.x series to 8.x series.
• Experience in improving the performance of Cognos reports by tuning SQL, implementing data marts, suggesting indices, ranexplain plans and implementedthe server changes.
• Effective communications skills (verbal and written) for both highly technical and non-technical audiences.

TECHNICAL SKILLS

Operating Systems: Window XP/2000/NT, Window Vista, and Window 7

ETL Tool: Oracle Data Integrator 10g, 11g, 12c

Reporting Tools: Cognos 10.1/8.4/8.3/8.2/8.1 BI Tools including Report StudioQuery Studio, Analysis Studio, OBIEE 11g

Databases: SQL, PL/SQL, XML, HTML, SQL Server 05/08, Oracle 10g, 11g

PROFESSIONAL EXPERIENCE

Sr.Cognos Developer

Confidential, Claymont, DE

Responsibilities:

• Designed Meta models in the Framework manager 10.2 by creating the database layers and the business layers, defined the appropriate relationships between query subjects in Framework manager and then deployed packages into the Cognos connection portal.
• Prepared the requirement specifications documents based on the user inputs.
• Conducted discussions with the business users on requirements gathering.
• Prepared the requirement specifications documents based on the user inputs.
• Daily status meetings with the users on the project development.
• Implemented star schema grouping and dimension hierarchy in Framework manager model.
• Developed List, Cross Tab, Drill Through, Master-details and complex reports, which involved multiple prompts, multi-query in Cognos and 10.2 report studio.
• Involved in bursting reports against the database.
• Created custom templates and custom toolboxes for the use of reporting and developed byte by byte.
• Moved packages and reports from development to QA and then theproduction servers.
• Tested reports using review checklists for quality assurance before delivering to the end users.
• Involved into move to deployment to UAT and production.
• Trained the end users effectively to use the reporting tools and to build and customize their ad-hoc reports.
• Helped the teams to resolve the issues within the agreed SLAs.
• Worked with the DBA’s in back up strategy for the Cognos Content store database.
• Skilled at training users to use Query Studio and Analysis Studio andCognosworkspace.
• Developed the reports from legacy system to Cognos.
• Identified production faults and critical issues followed and troubleshoot them.
• Provided remedial measures to the production issues or process failure.

Environment: Cognos 10.2 Report Studio, Query Studio, Framework manager,Oracle 11g, Toad, and Windows XP, Solaris, Linux AIX Server

Sr.Cognos Consultant

Confidential, Edison,NJ

Responsibilities:

• Worked closely with the business users to define reporting requirements and documented the requirements in order to design, develop and maintain the Cognos reports.
• Exposed the data modeling and contributed along with the architects in designing.
• Worked on relationships (cardinality) between query subjects to better represent the logical structure of the business and the user requirements.
• Worked on securing Cognosconnection and setup connection security by assigning the users to the groups and roles defined in Cognosnamespace.
• Created relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Scheduled reports and jobs to run periodically.
• Developed templates, Master Detail Reports, Chart Reports and Mult-ilingualreports using Report Studio and Query studio.
• Created Query prompts, prompt pages, calculations, conditions, Filters and dashboard reports using Report Studio.
• Used conditional blocks and conditional formatting to merge two or more Cognos reports and developed consolidated reports.
• Scheduled and distributing reports through schedule management in Cognos Connection. Worked with complex calculations, formatting, conditional formatting, Bursting, Cross Tabs, multi-query reports and charts.
• Generated SQL and analyzed Cognos SQL, Native SQL to trouble shoot the report issues.
• Designed and placed data in layers varying to physical, business and presentation.
• Worked with the administrators, users and analysts to maintain exchange of the reporting requirements.
• Used the best practices of business to meet projects and company objectives.
• Identified production faults and critical issues followed and troubleshoot them.
• Provided remedial measures to the production issues or process failure.

Environment: Cognos 10.1, Report Studio, Query Studio, Framework manager Oracle 11g, Toad, and Windows XP

Cognos Developer

Confidential, Ronkonkoma, NY

Responsibilities:

• Developed hierarchies and measures to support Adhoc reporting and multi-dimensional reporting.
• Implemented Framework manager security for data access, object level access and package access.
• Published packages to Cognosconnection and implemented package level security.
• Implemented security in the Framework manager packages.
• Developed Lists, Cross Tabs and chart reports depending on the requirements.
• Developed Master detail and Drill through reports, which navigates from summarized to the detailed information.
• Managed theuser ID’s and user groups like providing privileges to the users and user groups in access manager.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Performed unit testing for all reports and packages.
• Created report views with saved prompts and schedules according to the business requirements.
• Enhanced in Enterprise framework manager models and published packages. Day-to-day administration activities like monitoring and scheduling jobs for the front end reports.
• Developed the appropriate programs and systems documentation.

Environment: Cognos 10.1/8.4 BI, Oracle 11g,Sql Server 2005, Framework Manager, Report Studio, and Analysis Studio.

ETL and Cognos Developer

Confidential, Orlando, FL

Responsibilities:

• Involved in interaction with the users to get business requirements and specifications.
• Created Framework models, Report Studio reports and dashboards.
• Preparedbest practices documents for Framework manager, Report Studio, security and deployments.
• Communicated the project status to the project sponsors, all team members and other relevant stakeholders and involved parties.
• Negotiated and resolved issues as they arose across areas of the projects and where they impacted on other activities.
• Involved in estimates of the project.
• Played a vital role with onsite and offshore teams.
• Understands the business logic involved in the reports and done the report enhancements according to the client’s requests.
• Createdpackages on the UAT and PROD report scheduler application.
• Deployed packages, folders and content store from a development environment to test and then to the production environments.

Environment: Cognos 8.4 (Frame work Manager, Report Studio, Query Studio), and SQL SERVER 2005.

Cognos Developer

Confidential

Responsibilities:

• Involved in requirement gathering from the business users.
• Analyzed the specifications provided by the clients and developed specification documents for reports as per the client requirements.
• Designedand developed the Framework manager models and published into Cognosportal.
• Designedand developed the reports using Cognos 8.4 Report Studio and analysis studio reports. Also worked as an administrator in working with report and analysis studio.
• Designed and development of multiple reports using various templates like list reports, Cross-tab reports and chart reports and involved in complex reporting.
• Extensively worked on analysis studio to develop multi-dimensional reporting.
• Worked with Global Drill- through definitions to drill through from analysis studio reports to report studio reports.
• Created Ad-hoc reports using Query Studio.
• Worked as report studio administrator, to create complex reports and dashboards for the given requirements.
• Created complex dashboards with area charts, pie charts, CrossTab and multi prompts in report studio.
• Designed power play reports to provide summarized results by measures and dimensions.
• Interacting with the end users on a regular basis for resolving issues pertaining to the reports.
• Co-facilitated the client workshops and training, typically small to medium group of clients.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Tested reports using review checklists for quality assurance before delivering to the end users.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), Oracle 10g, Windows 2003 Server, IIS Web Server, SQL Server 2005,Unix.

Software Engineer

Confidential

Responsibilities:

• Requirement gathering from the business teams.
• Converted the functional requirements into technical documents as per the business standards.
• Analyzed the existing codes and did the impact analysis.
• Created the data base objects like Tables, Views, Sequences, Synonyms Stored Procedures and Functions, Packages, Cursors, Ref Cursor and Triggers as per the business requirements.
• Used the SQL loader to upload the information into the database and used the UTL FILE packages and wrote the data to the files.
• Maintained and managed all versions of data models for production, testing and developing databases.
• Tested the code functionality using testing environments.
• Used different Joins, Subqueries and nested query in SQL query.

Environment: MS Word, MS Excel, Visual Basic, SQL, Windows XP, Oracle 9i