SUMMARY

• Over 7 years experience in deploying/implementing Business Intelligence solutions for various industries like Manufacturing, Banking, Healthcare & Auto using Cognos10.2.1 BI, 8 BI, Cognos Report Net 1.1nand Cognos series 7suite of tools.
• Well - versed with different phases of BI life cycle.
• Extensive experience in gathering and documenting end-user business requirements.
• Experience in upgrading reports from Cognos 8.4.1 to Cognos 10.1
• Developed reports extensively in report studio by creating various Drill-Throughs, Cross-Tabs, Dashboards, and Summary reports.
• Extensive experience in creating Scorecards for performance evaluation.
• Expertise in designing and developing models using Framework Manager.
• Proficient in Performance Optimization of reports and Multidimensional Cubes.
• Good knowledge of ETL Processes.
• Involved in Installation and Configuration of Cognos 8 BI (All components including PowerPlay and Framework Manager) in Stand-alone and Distributed Environment.
• Experience using PL/SQL in development and testing of reports, analyzing data in tables, Cardinalities between tables and joining tables.
• Strong understanding of Relational Database Design concepts and in depth knowledge of OLAP, OLTP Solutions.
• Strong understanding of Dimensional Modeling (Star and Snowflake Schemas)
• Knowledge in SAP BO and SAS Base.
• Knowledge in Informatica and Datastage Workflow.
• Exudes energy, motivation and confidence. A good team player with excellent communication skills, ability to meet deadlines, multi-tasking and flexible in work schedules.
• Provided technical and functional consulting/training to corporate and divisional users for Cognos.
• Strong experience in Client interaction and understanding business applications, business data flow and data relations for them.
• Experience supporting in-shore and off-shore teams for incident responses and service request submissions.
• Successful and highly experienced professional with the extremely valuable combination of technical knowledge, business acumen and interpersonal skills.

TECHNICAL SKILLS

BI Tools: Cognos 10.2/10.1, Cognos 8 Cognos Connection, Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Event Studio, PowerPlay Transformer. Report Net 1.1 Cognos Connection. Cognos Query, Upfront, SAP BO, SAS Enterprise Guide, Crystal and Jasper reports.

Methodologies: Star, Snowflake Schema.

Databases: MS SQL Server 2000/2005, Oracle 8i/9i/10g, DB2, MS Access, Sybase ASE/IQ.

ETL Tools: Data Manager/Decision Stream, Datastage, Informatica, Power Center, Ab Initio.

Web Servers: IIS, Apache Web Server.

Operating Systems: Windows 2000, 2003, NT, XP, vista7, AIX, Server 2000, 2003, 2008, UNIX, Ubuntu, Mandriva, Fedora, Open SUSE.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Sr. Cognos Developer

Responsibilities:

• Interacted with the Business to draft Business Requirements which includes sources, granularity of data, fields in the tables, and business rules.
• Created analysis report on current issues and suggest solutions. Produced special cases progress reports for the management review.
• Involved in debugging of the existing reports and improved the performance.
• Created List reports, crosstab reports, Drill thru and Master Detail and multipage reports using Cognos 10.2.1 Report studio.
• Manually modified the Pass-Through SQL in Report studio to tune and write the complicated reports. Used Union/Join objects in Report studio.
• Used Business Date/Time functions and common functions in queries and filters to make the report dynamic. Used such dynamic reports in scheduling the reports on second Friday of every month.
• Developed Prompt pages, cascaded input prompts to display only the selected entries in the report and also worked on the customization of prompt parameters.
• Created Business Views, Namespaces, Model query subjects in Framework Manager for easier report development and to enhance multi-user environment.
• Successfully designed and implemented security on different levels including object and row level security.
• Involved in migrating the folders from Cognos Development Server to Cognos QA Server and QA Server to Production Server.
• Ensured that developed reports meet specifications, run efficiently and are error free through Data validation and performance testing.
• Involved in administration of Cognos 10.2.1 BI environments. Defined roles and permissions and matched them across all environments for multiple applications.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.
• Involved in deployment (import /export) of reports and packages in different environments.
• Implemented row level security using parameter maps.
• Used SQL in Sql Server Management Studio to test and validate data in reports.
• Conducted various training sessions on basic/advanced report authoring to familiarize end users to the new reporting environment.
• Experience in interviewing Business users and SME's providing recommendations to resolve issues for various business/technical groups and defining strategic solutions to business problems in a multiple project environment.
• Used Agile methodology to oversee the various activities of the project on a day-to-day basis and also conducted daily and weekly meetings to maintain accountability of each of those activities.
• Created various user guides, report technical specifications as required.

Environment: Cognos 10.2.1 BI Suite (Cognos Connection, Framework Manger, Query Studio, Report Studio, Cognos SDK), SQL Server Management Studio.

Confidential, Malta, NY

Sr. Cognos Developer

Responsibilities:

• Understanding existing business model and user requirements.
• Implemented package level, object level and data level security in the reports.
• Fine-tuned the reports, underlying queries and tables using indexes.
• Worked on Data Analysis, Validate reports and troubleshoot the errors.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Validated report content between versions of cognos software using Lifecycle Manager (LCM)
• Conceptualized and formalized several List, Chart, Cross tab, master-detail, Drill-Down and Bursting reports using Report Studio, and made available to the users
• Developed Conditional Formatting, Conditional Blocks Using String, Boolean and Language variables
• Designed and developed reports of significant size and complexity from user requirements that vary and lack clear definition, using Report Studio and/or SQL statements and adhoc custom SQL reports
• Developed several custom SQL reports in Cognos report studio using advanced SQL such as pivoting, ranking desnse rank, aggregating at different levels of granularities
• Worked on Framework Manager to solve ambiguous relationships in metadata models, and published packages.
• Created and adopted multi layered approach to avoid data complexity for end users in FM.
• Responsible for improving report response time by creating appropriate joins between Query Subjects.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Prepared Weekly Status Reports (PMO) and shared with the Managers.
• Extensively used Workspace, Workspace Advanced.
• Deployed the Ad-hoc Model Reports from Dev. to Val. and to Prod. Environments.
• Production support and prepared documentation of each report created.
• Proficient in technical documentation including technical specifications, test plans, requirement specifications, Business Requirement Document (BRD), Functional Requirement Document (FRD), Non-Functional Requirement Document, data flow diagrams, data path diagrams and Purdue models etc

Environment: Cognos10.2, Cognos 8.4, Workspace, Workspace Advanced Framework Manager, Report Studio, Business Insight, Query Studio, Analysis Studio, Metric Studio,DB2,Oracle11g,MS Visio.

Confidential

Sr. Cognos Developer

Responsibilities:

• Created Star schema, dimensional models, Data Level Security in the Framework Manager Metadata model.
• Interact with Business Users in multiple locations to finalize or clarify Requirements and assist in creating the Dimensional data models.
• Worked on Cognos 10.1 Active reports and created dashboards in Business Insight.
• Enhance the existing metadata models with the required changes in Framework Manager and published them to the Cognos connection.
• Created Requirements and Technical design documents. Attend the project meetings, Reviews and Walk-throughs for requirements, design and test plans.
• Involved in upgrading Cognos 8.4 BI reports to Cognos 10.1.1 BI and deployment.
• Created reports in Report Studio and Analysis Studio with multiple queries and drill through capabilities.
• Created reports in Cognos 10.1 using embedded SQL.
• Worked with Database Administrators, Security Teams, and IT Infrastructure teams to resolve technical issues and coordinate changes that impact user communities.
• Cognos Administration activities including Server configuration, Security, Upgrades, Patch Installations, Implementation of Change Requests.
• Coordinate with IBM on Issues, Upgrades and Installations.
• Process Improvements and Research on optimizing the Cognos Functionalities from the Application perspective.

Environment: Cognos 10.1 - Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio,Map Manager, CognosConfiguration, HTML, Oracle10g, PL/SQL,SQL Developer, SQL Plus, TOAD, Javascript, Visio, Windows Server 2003, LDAP.

Confidential, Agora Hills, CA

Cognos Developer

Responsibilities:

• Very Strong in Interacting with the Business Users and Supervisors to get a better understanding of Client Business Processes and gather Business Requirements and converting them into Business Requirement Documents, Use Case Document, test methodology, designing test plan, preparing documentation, standardizing procedures.
• Extensively worked with Business users and the Board of Directors to understand their needs and generated various reports using Impromptu, Power Play, and Report studio.
• Worked with the data center closely for various automation processes and managed distribution lists.
• Published OLAP Cubes and Reports on the Cognos Sever Administration Portal.
• Installed Cognos 8.3 on a test server for migrating the cubes from 7.1/7.3
• Analyzed the Business needs and proposed models to consolidate the framework projects.
• Designed Framework models to explain the capability of Cognos 8 and the advanced features such as Dashboards/ Scorecards.
• Trained Business users to use Query Studio and Cognos Connection using Cognos 8.3
• Worked on Cognos Security Administration to restrict the Users.
• Created UAT plan documents for the managed reports.
• Created and Managed Catalog’s in Impromptu Administrator by adding tables and creating new joins, and created distributed catalogs when required.
• Tested and validated reports based on source system data.
• Provided training to end users on Cognos Impromptu, and Power play
• Worked on migrating the reports from the Legacy systems (Mainframe) to Cognos.
• Used Macros for automation of reports.
• Created portfolio’s for various Retail & Wholesale divisions
• Represented the Cognos Team at the Cognos User Group Meetings of Middle Tennessee.

Environment: Cognos 8.3, Cognos ReportNet, Cognos Impromptu 7.1/7.4, Impromptu Web Reports 7.1(IWR), Cognos Power Play 7.1/7.3, Cognos Power Play Transformer 7.3, Cognos Upfront 7.1, Portfolio, Access Manager 7.1, Configuration Manager 7.1, DB2, Toad, Oracle, Ms-Excel, Windows NT, Citrix Client tools.

Confidential, Tempe, AZ

Cognos Developer

Responsibilities:

• Interacted with business users for requirement gathering.
• Modeled metadata with Framework Manager to provide efficient Model and packages for Sales and Finance departments.
• Customized metadata to dynamically control the data returned, using Session Parameters, Parameter Maps, and Macros.
• Implemented security using Views.
• Involved in administration of Cognos 8 BI environment.
• Developed reports envisioning those created in Access.
• Developed reports using dynamic Pass-Through SQL when required.
• Involved in importing and exporting of data between all three environments.
• We were able to complete around 50 reports successfully before the deadlines.
• Conducted user training to familiarize end users to the new reporting environment

Environment: Cognos 8.2 BI Suite (Cognos Connection, Framework Manger, Query Studio, Report Studio, Analysis Studio), MS SQL Server 2000, Windows Server 2003 Enterprise SP2

Confidential, Minneapolis, MN

Cognos Developer

Responsibilities:

• Analyzed the existing Oracle Form based Client server System.
• Analyzed the Data-mart.
• Created the Design Specifications for the Requirement Specification
• Worked on Data Mapping for the models.
• Created the Framework Manager Models.
• Provided the prompts in Query Studio
• Created predefined Filters for the Ad-hoc users.
• Applied three levels of security to the model (Data, Object and Package)
• Published the models in Development Environment and applied the Folder security and access capabilities for the users
• Migrated the reports to Test Environment. Ensured that it works fine when migrated to Test and good to go for Production.
• Worked on the migration of reports to Test to Production Environment.
• Converted Complex Power-Prompt Reports into Cognos 8 Reports.
• Implemented prompt skipping in Cognos 8 Reports.
• Worked on Access Manager for administration purpose.

Environment: Cognos 8 MR2 (Framework Manager, Report Studio, Query Studio, SDK), Cognos 7.3, Power prompts Oracle 9i and Windows Server 2003.

Confidential

Cognos Developer

Responsibilities:

• Built Multidimensional Cubes using PowerPlay Transformer and published them to Cognos Connection using Framework Manager.
• Optimized the cube performance and report response time by enabling time-based partitioning, Incremental build, consolidation, powercube compression, and cross-tab caching.
• Involved in scheduling and administering Congos ReportNet reports using Schedule Management in Cognos Connection.
• Created Power-Play reports with drill-through, sorting, and ranking features.
• Created charts, lists and cross-tabs using Report Studio and ad-hoc reports using Query Studio.
• Developed a cube-based interactive scorecard for daily bookings, billing and inventory backlog.
• Created a sales scorecard to track the discount percentage metric, which was having a major impact on the generated revenue.
• Created other scorecards and dashboards in Metrics Manager for performance evaluation.

Environment: Cognos 8 BI, Cognos ReportNet1.1, PowerPlay Transformer, Metric Studio, Metrics Manager, Windows 2003 Server, Oracle 9i.