SUMMARY

• Innovative professional with 8+ years of progressive experience in the IT industry with prime focus on Programming, Analyzing, Designing, 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

Technology: IBM Cognos 10x,Cognos 8.x (Cognos Connection, Framework Manager

Tools: Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio)

BI Tools: 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 XP/2000/NT/9X and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Cognos Developer

Responsibilities:

• Involved in Gathering Requirementsand the reporting issues from the End users.
• Provided technical consulting to the team and super users on Cognos issues in Agile Scrum Environment.
• 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.
• Architecture the upgrade process based on requirement analysis, risks, resource planning, Time constraints etc.
• 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 Report Studio and Ad-hoc reports using Query Studio.
• Developed Active reports with custom filters and Visualizations.
• 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 for various 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.
• Performed post-development peer reviews, 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, MS SQL Server 2012,Windows 2007.

Confidential, Kent, WA

Sr.Cognos Developer

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.
• 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.
• 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,Windows 2007.

Confidential, Richmond, VA

Sr. Cognos Developer / BI 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.
• 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 2007.

Confidential, Jacksonville, FL

Cognos Developer

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 Report Studio 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 for various 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 2007.

Confidential, Lansing, MI

Cognos Administrator/Sr. Cognos Developer

Responsibilities:

• Involved in installation, configuration and maintenance of Cognos Administration tool-8.3/8.4
• Prepared and maintained complicated reports through the use of Cognos tools.
• Developed, managed and monitored testing and production environment.
• Administered the quality of data generated and helped to make changes wherever required.
• Modeled metadata and applied in Cognos framework and reporting.
• Ensured proper scheduling and administration of Cognos connection.
• Evaluated the overallperformanceof Cognos suite to meet the business needs.
• Facilitated the requirements gathering process and fact-finding sessions with business users to identify report requirements/design.
• Installation & Configuring the Cognos 8.4 client tools on windows Environment.
• Designing the logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Created customized ad-hoc packages in Framework Manager for Query Studio users.
• Created Data Source using Oracle 9i and Imported Tables/Views to the Framework manager model and set the cardinality between them as per the business requirements.
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to Report Studio reports.
• Involved in creating and working with PL/SQL stored procedures, triggers.
• Upgraded model and reports from Cognos 8.3 to Cognos 8.4.
• Involved in Resolving the Performance issues of the Reports.
• Extracted source definitions from various sources like Oracle, flat files and DB2 into the Informatica PowerCenter repository.
• Testing the report and the validity of the data it retrieves from the database.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio), Cognos Access Manger, Oracle 9i, Windows 2003 Server.

Confidential, New York, NY

Cognos Administrator/Cognos Consultant

Responsibilities:

• Installed and Configured Cognos 8.2 and 8.3 Framework Manager.
• Communicated with business users on requirements gathering Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Created model using SQL Server 2005 as Data Source
• Upgraded model and reports from Cognos 8.2 to Cognos 8.3.
• Created security at package level, object level in model and security to package in Cognos connection.
• Created stored procedure Query Subject in Frame Work (FM) model.
• Created Report Using SQL code in Report Studio.
• Created stored procedure Query Subject in Frame Work (FM) model.
• Involved in deploying packages and reports from Dev to QA.
• Involved in Resolving the Performance issues of the Reports.
• Testing the report and the validity of the data it retrieves from the database.

Environment: Cognos8.2/8.3 (Frame work Manager, Query Studio, Report Studio), Cognos8.2, SQL server 2005, Windows XP

Confidential, Aliso Viejo, CA

Cognos Developer

Responsibilities:

• Gathered and Analyzed User requirements.
• Installed and configured ReportNet.
• Defined Data Sources and their associated connections in Cognos Connection.
• Modeled metadata from Oracle database for use in Report and Query Studio using Framework Manager in ReportNet.
• Created different Powerplay cubes for region facts using Transformer.
• Recreated the existing Impromptu reports in Query Studio and Report Studio.
• Optimized the cube performance and the report response time.
• Created best practices document that helps user to create error free and effective reports.
• Developed Drill through reports to provide attention to details and analyze the business data.
• Created regular and cascaded prompts for implementation with filter.
• Used conditional formatting to highlight deviations in the data.
• Involved in Resolving the Performance issues of the Reports.
• Testing the report and the validity of the data it retrieves from the database.
• Participated in discussions with the senior management to better understand the business requirements.
• Developed impromptu query definition (.iqd) files imported into transformer for creation of cubes.

Environment: Cognos ReportNet 1.1 MR2 (Framework Manager, Report Studio and Query Studio), Cognos impromptu, PowerPlay 7.2, Cognos Transformer 7.2, Powerplay Enterprise Server 7, Oracle 9i (SQL, PL/SQL), SQL Server

Confidential

Oracle Developer

Responsibilities:

• Involved in discussions with the end user to analyze the requirements for generating reports
• Imported data with validation from flat-files to Oracle database using SQL*Loader.
• Loaded data into flat files from oracle using SQL*Plus.
• Developed reports using Reports 6i for various transactions such as books due by date and visitor reports.
• Developed test plans and performed testing Worked with two distinguished Customer groups and supported them throughout all releases.
• Also Involved in Tech Support once we move into Production.

Environment: Oracle 7.x, Visual Basic5.0, SQL*Plus, SQL*Loader, SQL, PL/SQL, Reports 6i, Windows XP.