SUMMARY

• Over 9 years experience in deploying/implementing Business Intelligence solutions for various industries like Healthcare, Finance, Retail and Technology using Cognos10 BI, 8 BI, Cognos Report Net 1.1, Cognos Impromptu, Cognos series 7 suite and ETL tools.
• Strong experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications which includes (ETL & OLAP) environment.
• Experience in gathering and documenting end - user business requirements.
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements. Expertise in Data Flow Diagrams, Process Models, and ER diagrams with modeling tools like ERWIN & VISIO.
• Experience in designing and developing mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.
• Expertise in designing and developing models using Framework Manager.
• Expertise in developing Multidimensional Cubes using PowerPlay Transformer, and Reports using Power Play for Windows.
• Creating the Complex Report studio reports using the different MDX expressions using the Cubes as the source data.
• Experience in creating and translating information from various corporate systems and data into, visually rich Dashboards using maps, charts, cross tabs and lists and other graphical elements.
• Extensive experience in creating Scorecards for performance evaluation.
• Proficient in Performance Optimization of reports and Multidimensional Cubes.
• Experience in upgrading reports from Cognos 8.2 to Cognos 10.2
• Experience in migrating reports from Impromptu to ReportNet, and upgrading reports from Report Net to Cognos 8 BI.
• Involved in Installation and Configuration of Cognos 8 BI (All components including PowerPlay and Framework Manager) in Stand-alone and Distributed Environment.
• Extensive experience with database languages such as SQL, MDX and PL/SQL which includes writing triggers, Stored Procedures, Functions, Views and Cursors.
• Experience in writing and executing different Test scenarios (Unit, System & Integration and UAT).
• Strong understanding of Relational Database Design concepts and in depth knowledge of OLAP, OLTP Solutions.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Excellent team player and self-starter with good ability to work independently; proficient at developing & implementing User Training programs and possess good analytical, problem solving and logical skills with ability to meet deadlines, multi-tasking and flexible in work schedules.

TECHNICAL SKILLS

BI Tools: Cognos 10.x,Cognos 8.x, Report Studio, Query Studio, Analysis Studio, Metric Studio, Framework Manager, Event Studio, CubeDesigner,Workspace,CognosSDK,CognosSeries7: Upfront,PowerPlayTransformer,ImpromptuWebeports,Power Play Enterprise Server, Impromptu Administrator. Informatica 9.x,8.x,SSIS,Data Manager, Tableau Desktop 8.3, Tableau Server 8.3

Methodologies: Star, Snowflake Schema.

Databases: Oracle (8.0/9i/11g), SQL Server 2008/2005/2000 (T-SQL, Stored procedures, Triggers, DML, DDL, DTS), DB2, Sybase 11.5, Informix (XPS, 7.x/8.x), MS-Access, XML, JDE

OS: Windows 2000,NT, XP, 7, Server 2000, 2003, 2008, 2012, Sun Solaris 7/8, IBM AIX, UNIX, Ubuntu, Mandriva, Fedora, Open SUSE.

Programming Skills: SQL, PL/SQL, MDX, JAVA, (Eclipse IDE and Net Beans IDE), HTML, C++, Python, XML, Java Script, VB script, Shell Scripting (K-Shell, C-Shell).

DB Tools: SQL*PLUS, SQL*LOADER, SQL*NET, Quest TOAD, SQL Server Management Studio, Oracle Enterprise Manager, Oracle WSGL/Web Tool kit.

DM Tools: Erwin, Visio

Web Servers: IIS, Apache Web Server

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Cognos Developer

Responsibilities:

• Understanding existing business model and writing requirements(BRDs).
• Created the Entity Relationship Diagram implementing Star schema using VISIO
• Developed various mappings and Stored Procedure transformations using PL/SQL Framework.
• Re-designed existing models & developed new dimensional models in Cognos 10.2.1BI and published packages using Framework Manager (FM).
• Worked on Framework Manager to solve ambiguous relationships (loops, reflexive and recursive) in metadata models and published packages.
• Worked on Cube Designer to build OLAP cubes
• Created and adopted multi layered approach to avoid data complexity for end users in FM.
• Developed the List Reports, Cross Tabs, Charts, Drill Through Reports, Master Detail Reports using Report Studio and Query Studio.
• Developed the Report Studio reports using the Cube as a data source.
• Developed the Dashboard reports using Cognos Workspace.
• Scheduled the reports using triggers in CAWA (Computer Associates Workload Administration).
• Created prompts with query macros by including references to Parameter Maps.
• Implemented package level, object level and data level security in the reports.
• Fine tuned the reports, underlying queries and tables using indexes.
• Worked on Automation of Cognos services restart.
• Responsible for Performance tuning by analysing and comparing the turnaround times between SQL and Cognos.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Deployed the Ad-hoc Model Reports from Dev. to Val. and to Prod. Environments.
• Prepared EoW(End of Week) Status Reports and shared with the Managers.
• Production support and prepared documentation for reports developed with End user training
• Involved in conversion of reports from Cognos 10.2 to Tableau 8.3

Environment: Cognos 10.2.1-Framework Manager, Cube Designer, Report Studio, Query Studio, Analysis Studio, Metric Studio, SDK, CAWA, Maximo 7.5.0, PL/SQL, XML, HTML, MDX, Oracle11g, SQL Developer, SQL Plus, Javascript, Visio.

Confidential, Austin, TX

Sr. Cognos Developer

Responsibilities:

• Coordinate with Business users to understand, gather and document Business Requirements and translate the Business and assist in creating Dimensional data models.
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN
• Developed mappings in Informatica to load the data from various SQL sources into XML using different types of transformations like source qualifier, expression, filter, aggregator, update strategy, lookup, sequence generator, joiner, xml outputs and normalizer.
• Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions and Workflows.
• Created Logical and Physical Models in Cognos 10.2 Framework manager with a 4-Layer approach (Physical, Business, Presentation, Dimension) using Oracle 11g.
• Enhance the existing metadata models with the desired changes in 10.2 Framework Manager and publish packages.
• Updated & administered the security privileges at object level and data level for the user profiles in Framework Manager.
• Worked on Cognos 10.2 Active reports and developed Dashboards in Workspace.
• Developed List, Cross tab, Drill through, Master-detail, Chart & Conditional formatting reports which involved multiple prompts in Report Studio & Burst them to General Managers.
• Created scorecards using Metric studio which included risk scorecards, profitability scorecards.
• Created reports containing multiple data containers like List, Cross-tab, Graphs and Repeater tables.
• Experience with Parameter Maps and Session parameters in creation of multi-lingual reports
• Worked with Cognos 10.2 Go Office reports.
• Developed Executive Dashboards with drill up and drill down capabilities.
• Developed reports in Cognos 10.2 Report Studio using Native SQL.
• Wrote and executed the Test cases for various reports that were developed in Cognos 10.2
• Identified performance issues in existing sources, targets and mappings by analyzing the Data flow, evaluating transformations and tuned accordingly for better performance.
• Actively involved in Production support. Implemented fixes/solutions to issues/Tickets raised by user community
• Trained Business users to make their own ad-hoc reports using Cognos 10.2 Query Studio.

Environment: Cognos 10.2-Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Metric Studio, Go Office, Workspace, Informatica Power Center 9.0, XML, HTML, MDX, Oracle11g, SQL Server 2008, SQL Server Integration Services, SQL Developer, SQL Plus, SQL Server Management Studio, JavaScript, Erwin.

Confidential, Ft.Worth, TX

Sr. Cognos Developer

Responsibilities:

• Understanding existing business model and user requirements.
• Created the Entity Relationship Diagram implementing Star schema using VISIO
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, ExpressionStored Procedure, Sorter and Sequence Generator transformations.
• Created and Configured Workflows and Sessions to transport the data to target Warehouse tables using Informatica Workflow Manager
• Re-designed Impromptu catalog & developed the model in Cognos 10 BI and published packages using Framework Manager (FM).
• Involved in migrating the Impromptu reports to Cognos 10.2 BI.
• Worked on Framework Manager to solve ambiguous relationships (loops, reflexive and recursive) in metadata models and published packages.
• Created and adopted multi layered approach to avoid data complexity for end users in FM.
• Developed the List Reports, Cross Tabs, Charts, Drill Through Reports, Master Detail Reports using Report Studio and Query Studio.
• Developed the Report Studio reports using the Cube as a data source.
• Developed the Dashboard reports using Cognos Report Studio and Metric Studio.
• Created prompts with query macros by including references to Parameter Maps.
• Involved in upgrading Cognos 8.2 BI reports to Cognos 10.2 BI and deployment.
• 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.
• Responsible for Performance tuning by analysing and comparing the turnaround times between SQL and Cognos.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Involved in fixing invalid Mappings, testing of Informatica Sessions, and the Target Data
• Deployed the Ad-hoc Model Reports from Dev. to Val. and to Prod. Environments.
• Prepared Weekly Status Reports (PMO) and shared with the Managers.
• Production support and prepared documentation for reports developed.

Environment: Cognos 10.2-Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Metric Studio, Impromptu 6.0 Admin, Map Manager, Cognos Configuration, Informatica Power Center 8.5, Power Exchange 8.1 XML, HTML, MDX, Oracle11g, Oracle 8i, JDE, SQL Developer, SQL Plus, Javascript, Visio.

Confidential, San Diego, CA

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.
• Created reports in Report Studio and Analysis Studio with multiple queries and drill through capabilities.
• Created reports in Cognos 10.1 using Native SQL.
• Customization of prompt and report pages functionality using JavaScript.
• 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, Cognos Configuration, HTML, MDX, Oracle10g, PL/SQL,SQL Developer, SQL Plus, TOAD, Javascript, Visio, Windows Server 2003, LDAP.

Confidential, Aliso Viejo, 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 various Report Technical Specification (RTS) documents to define detailed user requirements.
• Defined various Functional Specification document to outline various reporting standards, Business rules and Data Mapping.
• Worked with the BI team to develop a versatile Framework Manager Model using the MDDW data warehouse data model in Oracle 8i Database which follows the Functional Specifications document.
• Created Business Views, Namespaces, Model query subjects in Framework Manager for easier report development and to enhance multi-user environment.
• Implemented model level security leveraging the same security levels as implemented at the back end Sales application.
• Built Multidimensional Cubes using PowerPlay Transformer and published them to Cognos connection using Framework Manager.
• We were able to complete around 200 reports successfully before the deadlines.
• Ensured that developed reports meet specifications, run efficiently and are error free through Data validation and performance testing.
• Developed various reports using Pass-Through SQL as required to improve performance.
• Actively involved in Data Warehouse design.
• Involved in administration of Cognos 8 BI environments.
• Involved in deployment (import /export) of reports and packages in different environments.
• Used SQL in TOAD for Oracle 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.
• Created various user guides, report technical specifications as required.

Environment: Cognos 8.x BI Suite (Cognos Connection, Framework Manger, Query StudioReport Studio, Cognos SDK), MDX, Oracle 9i, Windows Server 2003, Datastage 7.0.

Confidential, Nashville, TN

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, SQL Server, SQL Tools, 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), MDX, MS SQL Server 2000, Windows Server 2003 Enterprise SP2

Confidential, Readington, NJ

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.3Power 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, power Cube 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.

Confidential

Jr. Cognos Developer

Responsibilities:

• Designed models using Framework Manager and deployed packages to the Cognos Connection Portal.
• Installed and configured Cognos 8 environment and maintain portal security.
• Created user groups and provided login credentials for end users.
• Importing data into SQL Server tables from other applications and environments.
• Created Database layer and Business layer, defining appropriate relationship between query subjects.
• Developed List, Cross-tab, Drill-through, Master-Detail, Chart and Complex Reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Extensively worked on Analysis Studio to develop multi dimensional analysis.
• Designed Power Play Reports to provide summarized results by measures and dimensions.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Built Power Play Reports based on the cubes and published to Report Net Server.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports, Cognos connection portal.

Environment: Cognos 8, Framework Manager, Report Studio, Analysis Studio, Query StudioReport Net 1.1, Cognos Transformer, Power play Window/Web, Informatica, Teradata, Impromptu7AIX, Oracle, Windows.

Confidential

Jr. Cognos Developer

Responsibilities:

• Web Installation, implementing, administrating Cognos for both networked and web-based solutions to maintain Cognos PowerPlay cubes and Impromptu reports on the web.
• Created new Catalogs using Cognos Impromptu 6.0
• Customized data by adding calculations, filters and prompts in the catalog
• Generated reports as per the requirements using Cognos impromptu
• Powerplay reports were created from the various Cubes created for the user. Explorer and Reporter reports were created based on the requirements of the user and the project
• Generated IQD files to feed PowerPlay Transformer Models to create Multidimensional Cubes to generate PowerPlay reports
• Maintaining Cognos Web Services on IIS Servers. Configuration of NDS/LDAP authentication and authorization.
• Maintain user security and privileges through Access Manager and Web Services on IIS.

Environment: Cognos PowerPlay/Transformer 7.0,Cognos PowerPlay enterprise Server 7.0,Cognos Impromptu 7.0,Cognos Upfront, Impromptu Web Reports7.0, Access manager, Cognos IWR, Oracle 8i, PL/SQL, DB2, XML, Windows NT, Windows2000, Sun Solaris

Confidential

Report Net Developer & SQL Developer

Responsibilities:

• Involved in complete Software Development Life Cycle of the project.
• Created Data Source connections, Tables structures for storing user information.
• Created functions, procedures for inserting, updating data based on conditions.
• Wrote the database triggers for the complex business rule validations.
• Created and performed the Unit and Integrity test cases and assisted the testing team in System Test and Production move process.
• Involved in SQL Query Optimization
• Prepared User documentation to train users and functionality of each report.
• Created Stored Procedures and functions to accomplish several computations.
• Created Star Schema using fact and dimension Tables and further created dimensions, levels and hierarchies.
• Developed ReportNet Reports and published.
• Tested the ReportNet, Power play User, Power play Transformer and other Cognos utilities after installation

Environment: Report Net, Oracle 9i, SQL, PL/SQL, UNIX, Windows NT.