SUMMARY

• Highly skilled IT Professional with over 9 years of experience working for major corporate clients, with an extensive and wide range of IT leadership, planning, programming knowledge, skills, abilities, and experience working as Applications Analyst, Systems Analyst, Project Manager, Solutions Architect.
• Hands on experience in Full Life Cycle design & development of Data warehouse, ETL and Cognos Reporting Process.
• Good experience in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 7/ 8/10 and Cognos Report Net
• Sound skills in Cognos 10 BI Suite (Framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio, Transformer)
• Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages) with Relational & DMR and Complex Report building with Report Studio
• Expert at designing and creating Multi - dimensional Cubes for corporate data using Power play Transformer.
• Expertise in Business Process Modeling, Process Improvement, Feasibility Analysis, Gathering-Elicitation & Management of requirements, GAP Analysis, Design & Development of Business Applications & Project Management Skills.
• Involved in Installation, Configuration, and Administration of Cognos Series 8 & 10 Suite.
• Good written and oral communication ability in translating the business requirements into Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Requirement traceability matrix and System Requirement Specification.
• Acted as a liaison between business people who have a business problem and technology Efficient in creating Use Case Diagrams, Activity Diagrams and class diagrams, using Unified Modelling Language (UML) and Object-Oriented Analysis & Design.
• Created MultiPage tabbed Portlet, Dashboard Reports in Cognos 8.4.
• Created Dashboards using Workspace advance & Report Studio. Used functionalities like Active reports, drill through, drill up-down and Workspace advance.
• Experience in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like star schema and snowflake schema.
• Expert at creating Multi-dimensional Cubes for corporate data using Power play Transformer.
• Experience in Security Implementation in Cognos8, ReportNet, on various levels using third-party security providers like LDAP, Active Directory, and Series 7.
• Basic knowledge of BIA (Business Insight Advanced).
• Developed data Mappings between source systems and warehouse components.
• Knowledge of Ralph Kimball’s methodology and Inman’s approach for Data Modeling and DWH.
• In-depth Knowledge of SDLC using the iterative and incremental methodologies such as RUP, Agile, Scrum, and Non-iterative methodologies like waterfall methodologies.
• Experience in conducting Joint Application Development (JAD) sessions and interviewing Subject Matter Experts (SMEs), asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.
• Prepared and executed functional Test Plans for User Acceptance Testing (UAT) to support business users.
• Energetic, self driven and passionate with good relationship management, team management and communication skills.
• Extensive experience with cross country teams and working directly with offshore teams also.

TECHNICAL SKILLS

Reporting & ETL Tools: Cognos 10.1/8.4 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio) Cognos EP Series 7.3, Business Objects 5.1, Cognos Impromptu 7.3, Power Play Transformer, Cubes, IWR, Visual Studio, Informatica Power Centre (Power Centre Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor); Informatica Power Mart; Informatica Power Exchange, Informatica workflow designer/Monitor, Transformation, Data Stage, ERWIN.

Databases: Oracle 8i/9i/10g, SQL Server 2000/5.0, DB2-400, DB2-UDB, Teradata, IBM Neteeza

Computer System: Win95/98/2000/XP/7, Windows NT, AS400, Linux

Programming Languages: SQL, Cobol, Java, Sequel Query

Special Software: MS Access, Excel, Visio, MS Project, SVN, OMS, Database Monitor (DB Mon), Performance Explorer (PEX), Framework Manager, Erwin, MS SQL Server, PowerPoint

Methodologies: OLAP,HOLAP, RAD, AGILE, RUP and Waterfall.

Testing Tools: Quality Centre, QTP, Load Runner

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton CA

Sr Cognos Developer

Responsibilities:

• Involved in requirement gathering and analysis developing specification documents for reports as per client requirements.
• Developed Metadata Models using Layered Architecture (Database, Logical and Business) and DMR models using Framework manager and created filters, prompts, calculations, summaries and functions in Framework Manager.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created complex dashboards, portlets with area charts, pie charts, crosstab and Multi prompts in Report Studio for various reports.
• Created the active reports by using cognos10.2.1.
• Created the Global shared location for storing the Cognos report outputs for different project streams.
• Created the events in the event studio.
• Extensively used cascading prompts, filters, calculations, conditional variables, multiple queries for data extraction in reports.
• Created Drill through Reports & Master Detail Reports.
• Created Burst Reports and Multilingual Reports based on groups of users & Preferences for our Asian, American and European partners.
• Developed Transformer models by creating dimension maps, measures and levels and created power cubes according to business requirements.
• Extensively Build Power cubes and worked on cube optimization to improve performance.
• Good experience in migrating the views from Cognos 10.1 power play studio to Cognos 10.2.1.
• Good experience in creating Active Directory.
• Good experience in adding new custom roles by using Active Directory.
• Build report templates that include standard report objects, queries, and layouts.
• Involved in building Reporting Database using Informatica(source analyzer, mapping designer, warehouse designer, transformation developer and Mapplets designer)
• Involved in Performance Tuning, Monitoring and Optimization of PL/SQL blocks in both Development and Production environment, for Oracle and SQL Server databases.
• Good experience in the Cognos deployments.
• Involved in the admin related tasks. Creating the LDAP groups and assigning proper privileges to the users, authors and power users.
• Good experience in IBM Clear case and Clear quest
• Trained end users in understanding the functionality of Cognos Report Studio, Query Studio and Analysis Studio.
• Trained the end users to create the new reports by using the Report studio, Query studio, Business Insight.

Environment: Cognos 10.2.1/10.1, 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Transformer, Go Office), Oracle 11g, Cognos Access Manager, Informatica, Windows Server 2008, MS Project, MS Visio, PL/SQL Developer.

Confidential, NYC

Sr Cognos Developer

Responsibilities:

• Involved in gathering Business requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Involved in discussions with business stakeholders to understand project goals and requirements in order to quickly deploy reports and analytics that enable better decision making.
• Developed Technical Design and Functional Design Documents.
• Extracted data from different Sources (EXCEL, Flat files, Oracle database), performed Transformations and Loading (ETL).
• Involved in the ETL Mapping team discussions to solve the issues in mapping document or design.
• Created SQL Server stored procedures. Has done performance tuning by creating indexes, temporary tables, Partition functions, table variables.
• Involved in creation of Relational and Multi-dimensional models using Cognos framework manager and created packages, published to the server for reporting needs.
• Work directly with business customers to build portals, reports, dashboards with the COGNOSBI suite (Framework Manager, Report Studio and Transformer.
• Extremely proficient in writing complex reports, building portals, dashboards, scorecards, FM models, cubes and integrating with SharePoint.
• CreatedActive Dash Board Reportsusing Report Studio, Business Insight and Advanced.
• CreatedGlobal Trend Analysis, Sales Analysis and Budget & Forecast Dash Board Reports and Created Active reports using Report studio, Business Insight Advanced.
• Experienced in implementing best practices onCognosDashboards, Scorecards, Portal, report design, development and testing.
• Created dashboards for a managerial/Directorial overview with drill up and drill down capabilities in 10, 10.1.1.
• Created Multidimensional Power Cubes using Transformer and created Drill up/Drilldown reports using Report Studio and Analysis Studio.
• Created Drill through, Burst and Master Detail Reports. Created Active reports and dash board reports for the business needs.
• Worked on POC on dynamic cubes which enable to pull the data into In-memory and report against that, which gave a great performance compared to the regular OLAP.
• Created Dynamic cubes using IBM Cube Designer and analyzed the recommendations using advisor.
• Created Multi tab, Drill up/Down, Multi Query and multipage reports using report studio.
• Developed Reports withMultiple Cognos Viewersand with Multiple Cognos Reports developed Complex Reports, DashboardsforMobile and IPad Report Applications.
• Involved in creation ofMulti Source and Multi Tab Dash BoardActive reports for the business Needs.
• Experienced with Offshore/Onshore business models for development activities and involved in daily calls for coordinating the work to offshore team and help them to understand and implement.
• Running the jobs on a UNIX based sever in Batches.
• Extensively used UNIX SHELL SCRIPTING for running the jobs.
• Involved inconfiguring Cognos Mobile Server and Setup Corporate browserto access the Active reports in Mobile and Involved in testing theCognos Mobile Solutionsbefore handover to Business team Accessibility.
• Involved in day to day production support activities for the existing live products, working with IBM representatives on couple of PMR’s and admin groups for patches installations for fixes, upgrading versions and set the permissions for security.
• Did a quick turn around on the releases which enabled quick deliverables.
• Involved in Performance tuning of models/reports/cubes for better quality product delivery.
• Prepared Test cases and Test procedures for Testing of reports.
• Trained users on ADHOC reporting and usage of reports.

Environment: Cognos 10.1, Transformer, Report Studio, Query Studio, Metric Studio, Business Insight and Business Insight Advanced, Oracle 10g, Erwin 4.0,Dynamic Cubes, Active Reports, Dash Board reports, Cognos Mobile, Power Cubes, TOAD, PL/SQL, Data stage, TM1 and UNIX/Linux.

Confidential, East Hanover NJ

Sr Cognos Developer

Responsibilities:

• Created advanced reports using Report Studio10.
• Developed all types of reports (lists, crosstabs, charts, and map report) for IPAD using Cognos Active Reports
• Developed list reports, cross tab reports, chart reports, reports with multiple prompts, cascading prompts and Filters.
• Designed and Developed Framework Manager Models to be deployed as packages.
• Worked on complex reports such as dashboards, scorecards and reports with multiple drill throughs.
• Bursting Report Studio reports and sending reports via Email to several business users.
• Supported the reports in Production environment transferred knowledge on maintaining/ modifying reports in the future to the support team.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Designed the Cognos Connection portal according to user specifications.

Environment: Cognos 10 (Query Studio, Report Studio, Analysis Studio, Cognos Connection, Framework manager), Oracle, SQL Developer, Microsoft Excel, Windows XP, LDAP.

Confidential, NY

Cognos Developer

Responsibilities:

• Interacted with the Business users for requirement gathering.
• Installed & configured Cognos component such as the ReportNet.
• Created Cascade Prompts, Bookmarks, Query prompts, Filters, and Multilingual Reports Using Report Studio.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• Configured access manager namespace in Cognos connection and created new users and user groups in access manager.
• Provided technical assistance, training and mentoring to Users and Business Partners

Environment: Cognos ReportNet 1.1 MR3 (Framework Manager, Report Studio, Query Studio), Oracle 9i, SQL Server 2000, SQL, PL/SQL, Windows XP/NT

Confidential, RI

Cognos Developer

Responsibilities:

• Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Involved in Creating IQD files from Report net and designed Power play models in Transformer
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Created Dash board reports to get all the information from other reports.
• Production Support, which involves solving user problems.

Environment: Cognos Report net 1.1 MR2 (Framework Manager, Query Studio, Report Studio), Impromptu 7.2, Power Play Enterprise Server 7.2, Transformer 7.2, Informatica 7.0, Oracle 9i, T-SQL, XML and HTML.

Confidential

SQL Developer

Responsibilities:

• Installed and configured SQL Server 2000/2005.
• Designed and developed the databases.
• Actively participated in logical design of database design to meet new product requirement using ERWIN.
• Configured the DTS packages to run in periodic intervals.
• Writing stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Facilitated simplified access of database for end users using demoralized views and created triggers on them to maintain to database integrity
• Created tables, views, triggers, stored procedures and indexes.
• Created integrity rules and defaults.
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment.
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.

Environment: SQL server 2000/2005, Windows 2000, Oracle, DB2, Flat Files.