SUMMARY

• 8+ years of experience in IT industry especially as a Developer/Analyst performing software development life cycle, design and implementation with major focus on Data Warehousing, and Database Applications for Financial, Insurance, Banking, Pharmaceutical and Government sectors.
• 8+ years of extensive experience in BI/OLAP & ETL tools like COGNOS 10,8.4.1, ReportNet 1.1 (IBM Cognos Connection, IBM Cognos Insight, IBM Cognos Workspace, IBM Cognos Workspace Advanced, IBM Cognos Report Studio, IBM Cognos Event Studio, IBM Cognos Metric Studio, IBM Cognos for Microsoft, IBM Cognos Query Studio, IBM Cognos Analysis Studio, IBM Cognos Lifecycle Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio, Framework Manager, COGNOS Connection), COGNOS EP Series 7.3 (Impromptu Administrator, Impromptu Web Reports (IWR), PowerPlay, Transformer, PowerPlay Enterprise Server, PowerPlay Web, Access Manager, Server Administration, Report Administration, Upfront, Visualizer, Architect, COGNOS Query, Scheduler, Notice Cast, Metrics Designer, Metrics Manager)
• Proficient in designing Transformer PowerPlay cubes using different sources in COGNOS BI version 10, 8.
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad - hoc reporting and advanced report authoring.
• Used COGNOS Connection extensively to monitor and manage dispatchers and services, set and maintain security, create and manage data sources, administer reports and deploy data from one environment to another in COGNOS 10, 8.4.1.
• Worked extensively with PowerPlay Transformer and client to design models and analyze the Power Cubes.
• Experience in creating Catalogs in Impromptu Administrator to create Reports.
• Extensively Worked on Cognos Security Administration to restrict the Users.
• Involved with administration of IWR Server, PowerPlay Enterprise Server and ReportNet Server.
• Worked with data modeling using Erwin 4.0/3.x.
• Possess deep knowledge on various phases of software development cycle including analysis, design, development, testing and implementation.
• Experience with Cognos performance tuning
• Experience in Transformer model design and Power play cube building
• Exposure to client interaction and user-requirement analysis.
• Mentored and trained users for the successful execution of the project.
• Involved in designing of Relational and Multidimensional databases.
• Expertise in Client/Server application development using Oracle, SQL Server, PL/SQL
• Strong management experience along with teamwork building and excellent communication skills.
• Excellent problem solving and analytical skills.

TECHNICAL SKILLS

BI Tools: COGNOS 10, 8.x Transformer, Framework Manager, Analysis Studio, Report Studio, Metric Studio, Event Studio, BSP Meta Manager, REPORT NET 1.1(MR1/MR2) COGNOS connection, Framework Manager, Query studio, Report studio, Management Tools, Server Administration Tools, Configuration Manager, Scheduler, COGNOS Series 7.x COGNOS Impromptu Administrator, Impromptu User, Impromptu Web Reports, COGNOS PowerPlay Transformer, PowerPlay, User, PowerPlay Web vs Reports, Power Play Enterprise server, Java, Upfront Administration, Access Manager, LDAP Server, Configuration Manager, Scheduler.

Operating Systems: Windows 95/98, Windows NT 4.0, Windows 2000/XP, LINUX, UNIX

Languages: SQL, PL/SQL, JAVA, .net, HTML, XHTML, MDX, C, C++.

Databases: Oracle 10g/9i/8i/8.x, SQL Server 8.x/7.x/2000, MS Access and SAP.

Software Packages: MS-Office 2003, Microsoft Word, Excel and Power Point

Other Tools: Toad, Cognos SDK, Deployment Tool & Migration Utility (Impcat2xml)

Data Modeling Tools: Informatica 7.1.1, Erwin, Data Stage 7.5.3, SSIS, Visio 2000.

PROFESSIONAL EXPERIENCE

Confidential, OK

Sr.COGNOS Developer/ Administrator

Responsibilities:

• Developed and implemented information management solutions as a part of Business Intelligence Organization.
• Involved in all phases of the data warehouse project lifecycle, which includes assessment, business requirements gathering, data modeling and database design, ETL/BI architectures, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Involved in the design and implementation of the balanced scorecard and online analytical processing (OLAP) solutions.
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Sales & Marketing, Forecast & Planning and Supplier Performance.
• Collaborated with business to develop high-level designs including logical models and functional specification documents.
• Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
• Prepared training materials, developing Business models and training users in Query Studio according to their specific needs and requirements.
• Assisted and worked with ETL developers and data modelers to make sure that model being developed is according to the business requirements.
• Developed complex Reports using different features like slice & dice, Drill capabilities, queries, Master detail and cross tab tables with multiple breaks.
• Designed and developed Powerplay cubes for multidimensional analysis for Forecast & Planning users.
• Recommended and designed summary tables to be used in reports to optimize performance.
• Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data.
• Administered Cognos BI Server Environment
• Managed Package Migrations and Deployments from one Environment to another.
• Managed Data Sources, run activities, user accounts and permissions
• Expertise in Implementing, testing, maintaining and supporting software, based on technical design specifications and BI development best practices.
• Prepared technical design specifications based on functional requirements and analysis documents
• Reviewing functional requirements, analysis and design documents and provide feedback
• Assisted customer support with technical problems, questions and trained other BI development staff.
• Experienced with version control (Source Safe, SVN, etc.) and experience using automated development tools such as Motio PI.
• Designed and developed Key Performance Indicator Dashboards in Report Studio and Metric Studio.
• Created different types of reports like List, Cross-tab, Chart, Repeaters, Maps, Drill-Thru, Master Detail and Dashboards.
• Experienced in tuning report performance using SQL analysis and database tools required
• Expertise in Cognos Administration, including security design, implementation and deployment
• Experience implementing n-tiered, distributed systems across different Hardware/Operating System platforms required
• Understanding of logical and physical database models
• Ability to quickly analyze, organize, and abstract large amounts of information and to make decisions based on analysis
• Good understanding of Relational databases with Oracle and experience with DB2, MS SQL Server.
• Authored complex reports using Tabular Models, Tabular SQL, Tabular Reference, Tabular Set and Unions.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Developed packages in Framework Manager when necessary for reporting as well as data sources (.IQD).
• Experience with Cognos performance tuning.
• Followed standard formatting styles for all the reports.
• Migration between test and production environments.
• Experienced setting up or utilizing Team Foundation Server (TFS).
• Solid understanding of Software Development Life Cycle.
• Worked inAgile environment.
• Involved in user meetings to gather Business requirements.
• Proficient in creating and executingtest plans, test casesandchange request documentation
• Expertise in working on Microsoft Content Management Server and Web Content Management functionality contained inSharePoint 2010.
• Worked on Branding & Chroming portal by customizing site definitions. Worked extensively with SharePoint Designer 2010 and CSS (Cascading Style Sheet) to change the look and feel of the SharePoint Portal.
• Experienced in working with SQL Server Management Studio /SQL Server Integration Services (SSIS)/ SQL Server Reporting Services (SSRS).
• Knowledge on Business Intelligence (BI) concepts (SQL Server &SharePoint).
• Profound Knowledge on Microsoft OfficeSharePoint 2013.

Environment: COGNOS 10.2 BI, IBM Cognos Connection, IBM Cognos Insight, IBM Cognos Workspace, IBM Cognos Workspace Advanced, IBM Cognos Report Studio, IBM Cognos Event Studio, IBM Cognos Metric Studio, IBM Cognos for Microsoft, IBM Cognos Query Studio, IBM Cognos Analysis Studio, IBM Cognos Lifecycle Manager, 2008 SQL Server, Oracle 11, SharePoint 2013, Team Foundation Server, Microsoft Visual Studio, RedGate SQL Compare, RedGate SQL Data Generator, RedGate SQL Dependency Tracker, RedGate SQL Packager, RedGate SQL Comparison SDK, RedGate SQL Search, RedGate SQL Multi Script, RedGate SQL Doc, RedGate SQL Test, RedGate SQL Automation Pack, Deployment Manager

Confidential, CA

COGNOS Developer/ Administrator

Responsibilities:

• Gathered requirements and prepared business requirements for BI applications.
• Worked in Cognos report studio, analysis studio and query studio, Metric Studio.
• Used Cognos Framework manager for modeling relational and DMR models, Cognos Transformer to model, build and applying security on cubes. Created views in Cognos Transformer in .mdl s using the dimensions.
• Expertise’s in PL/SQL and MDX concepts and to extract, analyze, modify, and update data in Oracle data warehouse tables.
• Responsible for trouble shooting data warehouse refresh issues and BI reports data validation with source systems.
• Created design and development of advanced reports using multiple queries, bursting, drill-through, conditional formatting, master-detail reports, etc. in report studio against relational data sources.
• Strong understanding of data warehouse concepts, star schema design and dimensional modeling.
• Analyzed the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Was responsible for defining the process and working with vendor supplied utilities or writing customized scripts to accomplish the import of data from externals systems
• Created and updated framework manager models by adding tables and creating new joins.
• Provided security in Frame work manager in data level, object level and package level.
• Created and updated Transformer models by updating data sources, using multiple data source, creating multiple measures.
• Provided security in Transformer using single sign-on s.
• Design & development of the reports using COGNOS 8.3 Report Studio, Analysis Studio.
• Developed reports using Report Studio involving embedded JAVA coding.
• Created complex reports in Report Studio by creating different variables and using Conditional Blocks.
• Design & development of multiple dashboard reports using various templates like list reports, cross-tab reports and chart reports from Oracle, Agile, Seibel, using external data sources(flat files), pass thru SQL s in report studio.
• Interacting with the End users on a day to day basis for resolving issues pertaining to the reports.
• Monitored Multiple Cognos Environments.
• Experienced in Installation and configuration Cognos.
• Administering the Cognos packages using the user security.
• Publishing the PowerPlay cubes to the Cognos server using the framework manager model.
• Creating the reports using Report Studio and Analysis Studio for the PowerPlay cubes.
• Created new page in the Cognos connection and embedded the different reports in the same page.
• Applying the security to display data based on the user security.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.
• Hands on experience installing, configuring and monitoring Cognos 10.1.
• Evaluated and implemented patches to existing Cognos environment.
• Pro-Actively monitored Server/Environment.
• Expertise in Cognos Architecture, Query Tuning and capacity planning.
• Analyzed, designed, developed, tuned, and tested deployments in support of multiple business projects
• Defined and documented requirements for conversion and interface programs
• Prepared technical design documents including detailed data mapping documentation
• Developed conversion and interface programs based on approved specifications (Combination ofSSIS, T/SQL,SQL, and Power Shell scripts)
• Loaded data into target data tables in the application schema
• Supported an information management strategy using SSRS, SSIS, Performance Point Services and other integration / reporting tools.
• Maintained and supported multiple international data integration requirements including; currency conversions, data mapping, and units of measure.
• Developed and maintained production, integration services that include: error handling routines, data validation, production job schedules, and job failure alerts.
• Conducted timing and capacity testing to ensure production support capability
• Developed exception and data validation reports for transformation and load jobs
• Conducted program walkthroughs with other team members as required
• Conducted walkthrough of test results for approval of data loaded as required
• Developed appropriate technical documentation, such as Visio flow-charts, as required

Environment: COGNOS 8.3, (COGNOS Connection, Transformer, Framework Manger, Report Studio, Query Studio, Analysis Studio), Oracle 11g, Netezza, Informatica Powercenter 8.x, 9.x, SQL Server 2008 and Windows 7 Enterprise, SQL Management Studio.

Confidential, Carlsbad, CA

Sr. COGNOS Developer/ Analyst

Responsibilities:

• Gathered requirements and prepared business requirements for BI applications.
• Worked in Cognos report studio, analysis studio and query studio, Metric Studio.
• Used Cognos Framework manager for modeling relational and DMR models, Cognos Transformer to model, build and applying security on cubes. Created views in Cognos Transformer in .mdl s using the dimensions.
• Expertise in PL/SQL and MDX concepts and to extract, analyze, modify, and update data in Oracle data warehouse tables.
• Built Cognos 10 active reports and worked on troubleshooting the run time performance and .mht file size issues by using MDX functions and meaningful interactivity respectively.
• Responsible for trouble shooting data warehouse refresh issues and BI reports data validation with source systems.
• Created design and development of advanced reports using multiple queries, bursting, drill-through, conditional formatting, master-detail reports, etc. in report studio against relational data sources.
• Developed report design and development with OLAP (Cube) data sources using MDX functions.
• Strong understanding of data warehouse concepts, star schema design and dimensional modeling.
• Worked with Oracle Exadata, Siebel, Agile Databases and Applications.
• Worked on the ERP applications. Gathering requirements from end users and create Dashboards using Business Insight and Business Insight Advanced and creating Active Reports on a large scale creating meaningful interactivity and also keeping a check on size of the .mht file.
• Analyzed the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Was responsible for defining the process and working with vendor supplied utilities or writing customized scripts to accomplish the import of data from externals systems
• Developed Job streams using Data Manager to execute the sequence of jobs and tracking the status of the jobs.
• Created and updated framework manager models by adding tables and creating new joins.
• Provided security in Frame work manager in data level, object level and package level.
• Created and updated Transformer models by updating data sources, using multiple data source, creating multiple measures.
• Provided security in Transformer using single sign-on s.
• Design & development of the reports using COGNOS 10 Report Studio, Analysis Studio.
• Created complex reports in Report Studio by creating different variables and using Conditional Blocks.
• Design & development of multiple dashboard reports using various templates like list reports, cross-tab reports and chart reports from Oracle Exadata, Agile, Seibel, using external data sources(flat files), pass thru native SQL s in report studio.
• Interacting with the End users on a day to day basis for resolving issues pertaining to the reports

Environment: COGNOS 10, (COGNOS Connection, Transformer, Framework Manger, Report Studio, Query Studio, Analysis Studio), Oracle 11g and Informatica Powercenter 9.x, JAVA, Windows XP and Windows Server 2008 R2, SQL Developer, Toad.

Confidential, San Diego, CA

Sr. Analyst

Responsibilities:

• Strongly experienced in requirements gathering and preparing business requirements for BI applications.
• Strongly experienced in Cognos including report studio, analysis studio and query studio.
• Experienced using Cognos Framework manager for modeling relational and DMR models.
• Experienced in using Cognos Transformer to build and refresh cubes.
• Well versed with PL/SQL and MDX concepts and to extract, analyze, modify, and update data in Oracle data warehouse tables.
• Experienced building Cognos 10 active reports.
• Expertise in trouble shooting data warehouse refresh issues and BI reports data validation with source systems.
• Experienced in design and development of advanced reports using multiple queries, bursting, drill-through, conditional formatting, master-detail reports, etc. in report studio against relational data sources.
• Experienced in report design and development with OLAP (Cube) data sources using MDX functions.
• Strong understanding of data warehouse concepts, star schema design and dimensional modeling.
• Experience working with Oracle Discoverer reports.
• Experienced working with data warehouse application.
• Well versed with working in the ERP applications. Gathering requirements from end users and create reports, dashboards and other business intelligence from databases and a BI data warehouse
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Responsible for defining the process and working with vendor supplied utilities or writing customized scripts to accomplish the import of data from externals systems
• Developed Data Manager dimensional builds to generate multi-dimensional data
• Developed Job streams using Data Manager to execute the sequence of jobs and tracking the status of the jobs.
• Created and updated framework manager models by adding tables and creating new joins.
• Provided security in Frame work manager in data level, object level and package level.
• Created and updated Transformer models by updating data sources, using multiple data source, creating multiple measures.
• Provided security in Transformer using single sign-on s.
• Design & development of the reports using COGNOS 10 Report Studio, Analysis Studio.
• Created complex reports in Report Studio by creating different variables and using Conditional Blocks.
• Design & development of multiple dashboard reports using various templates like list reports, cross-tab reports and chart reports from Oracle database.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports

Environment: COGNOS 10, (COGNOS Connection, Transformer, Framework Manger, Report Studio, Query Studio, Analysis Studio), Oracle 11gNetezza and Windows 7 and Windows Server 2008 R2, Toad.

Confidential, San Jose CA

Sr. COGNOS Developer/ Analyst

Responsibilities:

• Gathering requirements from end users and create reports, dashboards and other business intelligence from databases and a BI data warehouse
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Working with IT staff and Data Warehouse Administrator to manage the reporting structures, the data models for all reporting solutions
• Responsible for defining the process and working with vendor supplied utilities or writing customized scripts to accomplish the import of data from externals systems
• Developed Data Manager dimensional builds to generate multi-dimensional data
• Developed Job streams using Data Manager to execute the sequence of jobs and tracking the status of the jobs.
• Created data marts using data manager and load data into the databases to build a data warehouse environment.
• Design and Developed the Transformer Models and Framework Manager Metadata Models and DMR models and Published into server.
• Created and updated framework manager models by adding tables and creating new joins.
• Provided security in Frame work manager in data level, object level and package level.
• Created and updated Transformer models by updating data sources, using multiple data source, creating multiple measures.
• Provided security in Transformer using single sign-on s.
• Design & development of the reports using COGNOS 10 Report Studio, Analysis Studio.
• Created complex reports in Report Studio by creating different variables and using Conditional Blocks.
• Design & development of multiple dashboard reports using various templates like list reports, cross-tab reports and chart reports from Oracle database.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Performance tuning by analyzing and comparing the turnaround times between SQL and COGNOS.
• Developed Report Studio and Analysis Studio Reports in COGNOS 10 portal
• Built cubes using transformer and provided security for the cubes.
• Involved in unit testing to validate the reports.

Environment: COGNOS 10, (COGNOS Connection, Transformer, Framework Manger, Report Studio, Query Studio, Analysis Studio, Data Manager), COGNOS 7.4, COGNOS Go Office, Erwin 4.5, JAVA, Oracle 10g and Windows XP.

Confidential

Cognos Developer/SQL Developer / Database Administrator

Responsibilities:

• Installed and Configured Cognos Report Net 1.1 (MR1) and upgraded the existing Cognos versions of the Power Play and impromptu.
• Develop complex and highly formatted Cognos 8 applications to meet Business requirements.
• Use advanced features of Cognos 8 to produce dashboard style reports
• Handled client facing/consulting skills, such as the ability to work with the business partners to translate business requirements into potentially complex technical solutions that meet or exceed those business needs.
• Developing Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio.
• Extensively worked on CRN Administration and Security using Cognos Configuration and Access manager.
• Using Scheduler Schedule the reports Daily, Monthly, Yearly.
• Installed and Configured Sun One Directory Server and Object Store Server.
• Created Catalogs in Impromptu Administrator to create Reports.
• Worked on Cognos Security Administration to restrict the Users.
• Used Power Prompts Developer Studio for Designing Application.
• Consolidate the monitoring mechanism of marketing and financial performance
• Successfully resolving SQL Server problems, which involve in-depth knowledge of SQL
• Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.
• Created sophisticated SQL Server database to responsively handle complex queries. (DTS)
• Created and managed multiple recurring production data import/export processes into MS SQL databases.
• Extensively worked on TOAD tool, testing the queries.
• User Interface Platform team in implementing Panorama and ProClarity server based applications
• Perform analysis, design, development, testing, debugging and documenting of proClarity reports for a financial services.
• Tracked the weekly bug or issue report updates from the developers in the form of the QA Error Log.
• Created Power point Slides using COGNOS GO Office and Published to COGNOS Connection.
• Involved in unit testing to validate the reports.
• Used COGNOS Connection to administer Reports as well as the ReportNet Server.
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Designed and developed Time Based Reports like YTD, MTD and WTD financial reports for the end users.
• Created list reports, crosstab reports and chart reports using Report Studio.
• Created prompts, calculations, conditions & filters, prompt pages, variables etc. using Report Studio for several Reports.
• Created complex reports using tabular sets, child tabular models (more than one tabular model), drill through reports, master detail reports, book mark reports, conditional prompts.
• Documented all the process changes, requirement changes and code changes.
• Attended weekly meetings to understand and recommend the business solutions.
• Scheduling and Distributing Reports through Schedule Management in COGNOS Connection.
• Scheduled ReportNet reports to run on a monthly, weekly, and daily basis using COGNOS Scheduler.

Environment: COGNOS 8.x (COGNOS Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Data Manager), Cognos ReportNet 1.1 MR1 (Framework Manager, Query Studio, Report Studio, Cognos Connection), Impromptu 7.1, Impromptu Web reports (IWR) 7.1, Power Prompts 7.1, Framework Manager, Visualizer, Cognos Architect, Metrics Manager, Upfront, VB Script, Excel, IIS, TOAD 7.0, Oracle 8.1.7, SQL 2005, DB2/UDB 7.0, Sun Solaris, Windows 2000.