SUMMARY:

• Innovative professional with 4 years of progressive experience in the IT industry with prime focus on Data Analysis, Design, Programming, Testing, Integration and deployment of enterprise architecture based components and business applications
• Extensive experience in BI Modeling/Report Authoring using Cognos 10Xand 8x Suite, Cognos ReportNet MR1,MR2, Cognos EP Series 7.1/7.2/7.3
• Strong experience in creating Framework Manager Models with 3 Layer approach and publishing packages for BI authors for reporting needs.
• Expert in Design, Develop and Maintain the Relational and Dimensionally Modeled Relational (DMR) metadata - model using Framework Manager
• Hands on Experience in Report Studio for creating advanced and professional reports like Dash boards, Drill through, Multi Page report etc.
• Sound expertise and Hands-on experience in Reporting using Cognos 10X Report Studio and Cognos Business Insight.
• Experience in developing different kind of reports including Templates, List, Cross-tab, Repeater tables, Charts, Complex Financial Reports and Conditional block lists using Report studio in Cognos Report Net & Cognos 8.
• Expert in development of OLAP Models and Power Cubes using Cognos Transformer
• Good Knowledge and understanding on ODS, Data Warehouse, Data marts, Star and Snow Flake Schemas.
• Extensive experience in publishing of Developed Impromptu Web Reports (IWR) and Power play Web Reports into the web for end users using upfront.
• Deploying Models and reports from DEV to TEST and TEST to PROD and administering users/groups/roles.
• Worked on Security to clients using Access Manager and worked with Data level Security, Object level Security and Package level Security in Frame Work Manager.
• Have Good Experience in Production Support and Troubleshoot/Test issues with existing reports and cubes.
• Installation & Configuring the Cognos tools in distributed Environments on windows.
• Experienced with Multiple Relational Databases including Oracle, SQL- Server
• Developed SQL queries using TOAD, PL/SQL Developer to Test the performance of the reports.
• Experienced in writing and tuning SQL and PL/SQL scripts.
• Worked independently with business analysts/User to gather the requirements and provide efficient end-user training.
• Experience in preparing Functional Specifications, Technical Specifications based on requirements.
• Expertise in Regression, System Integration, Functional and Performance Testing.
• Excellent communication skills both oral and written.
• Zeal to accept work related challenges, dedication towards work.
• Pragmatic, Self-Motivated, Flexible and good Team player.

TECHNICAL SKILLS:

BI Tools: IBM Cognos 10x,Cognos 8.x (Cognos Connection, Framework ManagerReport Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio)EP Series7i (Impromptu, PowerPlay Transformer,Administrator, Enterprise Server, Architect, Access Manager, Visualizer, Upfront), ReportNet MR1, MR2

Languages: SQL, PL/SQL, C, C++, HTML, XML, Visual Basic

Application Servers: Web Sphere 6.0 and Apache Tomcat

Web Servers: Microsoft IIS, IBM HTTP Server (HIS)

Migration Utilities: MigS7, Mig Deploy

Tools: TOAD, PL/SQL Developer, Microsoft Project, CVS

Databases: Oracle 10g/9.x, DB2, MS SQL Server and MS Access.

Operating Systems: MS DOS, Windows and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Cognos Consultant

Responsibilities:

• InteractedwithCustomersforrequirement gathering,effectiveanalysisand also to provideend-user training.
• Responsible for translating the Business requirements into technical specifications.
• Analyzed data flow and business requirements to create High Level Design document.
• Installed, configured, troubleshoot SQL Server, Oracle, data base clients on Cognos servers.
• Designed various Audit related reports in report studio to provide audit details to management.
• Analyzed the source data to resolve various BI reports issues.
• Involved in a data migration process between different versions ofCognos.
• Worked with development team on a Proof of concept on Portal setup along with security and navigation enhancements.
• Provided technical consulting to the team and super users on Cognos issues in Agile Scrum Environment.
• Created Relational and Dimensional Models using multiple data sources and publishing packages to Cognos connections in Framework Manager.
• Designed Master detail reports, Multi query and Multi page reports as per BRD (Business Requirement Document).
• Designed many Complex Reports as List, cross tab, drill through, master-detail, chart using Report Studio and Ad-hoc reports using Workspace Advanced.
• Created complexdashboardswith piecharts, crosstabandMultipromptsinReport Studio and developed Active reports with custom filters and Visualizations
• Designed Complex reports using SAP Data with Cascading Prompts, Filters, and Custom Calculations.
• Created Complex reports in Cognos 10.2.1 including Drill Down and Drill UP reportsfromDMR modeled Frame work model.
• Created user groups and roles in Cognos Connection and applied data level and group level security for various entries.
• Worked with Security Administration within Cognos Connection in Defining roles and permission and matched them across all environments for multiple applications
• Worked on report performance Improvement found issues and fixed them.
• Involved in deployments of Packages and Reports to different environments.
• Worked on various info cubes likePurchasing Groups, Vendor Evaluationfor the Material Management module from the Business content.
• Analyzed and validated the report and performing data analysis by writing complex SQL
• Worked with different client teams to support Reporting issues and enhancing the existing reports.
• Developed Technical Specification documents for all newly developed and modified processes.
• Performed Peer Reviews and Unit Test and coordinate migration and deployment of Business Intelligence solution components to production and non-production software environments.

Environment: Cognos 10.2.2/8.4, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Work Space Advanced, Work Space, Transformer, Cognos Cube Designer,MS SQL Server 2012, Oracle, SAP, Windows 2008.

Confidential, Jacksonville, FL

Sr. Cognos Developer

Responsibilities:

• Worked with Customers in Gathering Requirementsand Solved the Reporting Issues for the end users.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlined the proposed solution.
• Created Adopt usage report for Business group, which will give a snap shot of licenses, studio’s usage and Co-ordinated with the Business users for the UAT testing.
• Involved in deployments of Packages and Reports from Dev to Test, Test to Staging and Staging to Prod using MotioCI.
• Administered the quality of data generated and helped to make changes wherever required.
• Upgraded successfully Cognos BI applications within the target time.
• Worked in Framework Manager to create Models using different data sources and publishing packages to Cognos connections for reporting requirements
• Designed Master detail reports, Multi query and Multi page reports as per BRD (Business Requirement Document).
• Designed many Complex Reports as List, cross tab, drill through, master-detail, chart using Report Studio and Ad-hoc reports using Workspace Advanced.
• Involved inQuery Optimization, and Developing Prompt pages and Conditional variables.
• Designed Active reports with custom filters and Visualizations.
• Createdcustom prompted reports in Report Studio,Bursting reports to different user groups.
• Designed Dynamic Cubes using Cognos Cube designer with calculated members.
• Designed Dashboards with drill through from summary to Detail Reports.
• Worked with Object Level and Package Level Security within Cognos Framework Manager.
• Designed various Audit related reports in report studio to provide audit details to management.
• Analyzed and validated the report and performing data analysis by writing complex SQL
• Created Breadcrumbs in reports using Java Script.
• Modified the SQL in Report Studioto tune and/or to write complicated reports. Used union/Joinobjects in Report Studio
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
• Involved in installation, configuration, migration and testing of all objects in multiple environments and performed Cognos Upgrades from 10.1.1 to 10.2.1
• Installed, configured, troubleshoot SQL Server data base clients on Cognos servers.
• Designed and Prepared a Training Material for the Users.
• Formalized the reporting process by creating thetechnical specificationand requirement specification and Performed Unit Test Validation

Environment: Cognos 10.2.2/8.4, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Work Space Advanced, Work Space, MS SQL Server 2012, Windows 2008.

Confidential, Kent, WA

Sr. Cognos Engineer

Responsibilities:

• Provided BI solutions across all areas of Cognos including Cognos Administration, support, design and development of BI applications.
• Worked on multiple Data Warehouse projects.
• Worked closely with business analysts in gathering requirements to design and develop the reports.
• Hands-on experience in implementing Data warehousing methodologies including Star Schemas and Snow-Flake Schemas for huge data warehouses.
• Developed the projects as per Agile Methodology.
• Developed several List Reports, Crosstab Reports, Drill through Reports and Multidimensional Reports with cascading prompts, Macros, filters, calculations using Cognos.
• Developed the Proof of concept on Portal setup along with security and navigation enhancements.
• Created upgrade tasks lists as part of upgrade process. This was made on the basis of experience had from prior upgrade.
• Created Relational and DMR models in framework manager from various data sources such as Netezza and SQL Server and published package to Cognos Connection.
• Worked on performance tuning of existing reports and models.
• Production Support, which involves solving End - user problems.
• Scheduled Reports using Cognos Connection.
• As a part of Admin team Involved in installation, configuration, migration and testing of all objects in multiple environments and performed Cognos Upgrades from 10.1.1 to 10.2.1
• Promoted Reports from Dev to QA and QA to Prod through MotioCI.
• Created Complex Ad Hoc reports in Cognos 10.2.1 Workspace Advanced including Drill Down reportsfromDMR model.
• Designed and developed Dynamic cubes in Cognos Cube Designer.
• Experience on UNIX, shell scripting.
• Performed Unit Testing in validating data in the reports and Peer Reviews
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members.
• Provided Technical and User Documentation on BI Projects.

Environment: Cognos 10.2.1/10.1.1 (Framework Manager, Cognos Cube Designer, WorkSpace, WorkSpace Advanced, Report Studio and Query Studio), Netezza, SAP BW,Windows 2008.

Confidential, Richmond, VA

Sr. Cognos Developer

Responsibilities:

• Interacting with different business teams to gather requirements, prepare functional and technical documents and UAT Process.
• Good Exposure to Agile Environment.
• Involved in peer review process to review the reports and models created by developers.
• Worked closely with Business analysts and Data Warehouse team to design the best BI models for reporting and analysis.
• Designed and Developed the Framework Manager models using stored procedures, Relational tables and published Packages on server.
• Generated variousList Reports,Cross tab Reports,Chart Reports, Drill-Down andDrill-Through Reports.
• Initiated the Portal design in Cognos environment.
• Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer.
• Analyzing existingtransactional database schemasand designingstar schema modelsto support the users reporting needs and requirements.
• Worked with DW team to add new data requirements that needs to bring from datasource and eventually update the proper data marts for the reporting solutions.
• Worked extensively on EDW and Facets databases in various environments
• Created Dashboards to present criticalcompany data in a single report.
• Analyzing the Data mapping documents, BRD documents for Survey Outcomes reports.
• Deploying Models and Dynamic Cubes from Dev to Test and Test to Stage.
• Involved in performing several Cognos upgrades from Cognos 8.4 to Cognos 10.1.1.
• Provided support to business analysts in utilizing Query studio, Analysis studio and Business Insight Advanced tools to perform analysis and create AdHoc reports.
• Installed and configured Cognos Content Manager, Dispatchers and gateway components on single server and multi-tier environments.
• Performance tuningby analyzing and comparing the turnaround times between SQL and Cognos.
• Configured Cognos on Windows server with SQL Server as content store and audit database.

Environment: Cognos 10.1.1/8.4 (Framework Manager, Transformer, Business Insight, Business Insight Advanced, Report Studio and Query Studio), TOAD, MS SQL Server 2012, Windows 2008.

Confidential, Jacksonville, FL

Cognos Consultant/Cognos Administrator

Responsibilities:

• Provided technical consulting to the team and super users on Cognos issues.
• Installed, configured, troubleshoot SQL Server data base clients on Cognos servers.
• Created Adopt usage report for Business group, which will give a snap shot of licenses, studio’s usage.
• Developed various Audit related reports in report studio to provide audit details to management.
• Analyzed the source data to resolve various BI reports issues
• Initiated the Portal design in Cognos environment.
• Developed the Proof of concept on Portal setup along with security and navigation enhancements.
• Upgraded successfully Cognos BI applications within the target time.
• Created upgrade tasks lists as part of upgrade process. This was made on the basis of experience had from prior upgrade.
• Worked in Framework Manager to create Models using different data sources and publishing packages to Cognos connections for reporting requirements
• Developed Master detail reports, Multi query and Multi page reports as per BRD (Business Requirement Document).
• Developed many Complex Reports as List, cross tab, drill through, master-detail, chart using ReportStudio and Ad-hoc reports using Query Studio.
• Designed reports with Cascading Prompts, Filters, and Custom Calculations.
• Created user groups and roles in Cognos Connection and applied data level and group level security forvarious entries.
• Involved in deployments of Packages and Reports to different environments.
• Analyzed and validated the report and performing data analysis by writing complex SQL
• Worked with different client teams to support Reporting issues and enhancing the existing reports.
• Developed Technical Specification documents for all newly developed and modified processes.

Environment: Cognos 10X/8.4/8.3, Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, MS SQL Server 2012,Windows 2008.