PROFESSIONAL HIGHLIGHTS

• Around 8 years of total IT experience in the Design, Modeling, Development and Production support of Cognos applications
• Around 5 years of successful hands-on experience playing role as a BI Project Manager delivering Quality BI products by following the methodical Project Life Cycle approach
• Efficient Communication, Management & Leadership skills for mentoring the project team and following the principles of the Project Management as stated by the PMI
• Successfully played role of Project Manager, Offshore Team Coordinator and BI Technical Lead
• Good experience in deployment of the reports from development environment to test and production environment.
• Technical leader who knows how to determine priorities and complete project deliverables within tight timeframes.
• Experienced in using SCRUM methodology for planning, scheduling and control of post-production support and enhancement activities.
• Experienced in conceptualizing, initiating, planning and controlling projects.
• Experienced in all phases of Software Applications Project Lifecycle.
• Experienced in coordinating project efforts with all stakeholders.
• Strong requirements gathering and solution analysis experience
• 7 years of extensive experience using Cognos Series 8 (8.1, 8.2, 8.3, 8.4), Cognos ReportNet 1.X suite, Cognos Series 7.X suite.
• Expertise of over 7 years in creation of Packages, Cubes and reports development and huge expertise creating Business Dashboards using Cognos tools
• Strong experience in Installation, Configuration, Monitoring and Management of Cognos on both UNIX and Windows platforms.
• Experience in setting up security access in LDAP, Framework Manager and Cubes
• Strong database knowledge of DB2, Oracle , SQL Server, Teradata stored procedures and functions
• Strong ERP knowledge of Peoplesoft HRMS and Peoplesoft Financials
• Sound knowledge on BI Reporting processes and have experience working with ETL & BI Reporting Tools

EDUCATIONAL QUALIFICATIONS

• PMP – Project Management Professional Certified
• MS IT – Masters of Information Technology
• BE Comp – Bachelor of Computer Engineering

TECHNICAL SKILLSET

OLAP Tools:

Cognos 8.x, BI (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio), Cognos 7.X(Impromptu, Impromptu Web Reports, Upfront 7.0, Access Manager, PowerPlay Transformer, Powerplay

ETL:

AbInitio 2.14, Informatica 8.6

Database:

DB2 UDB V 7.2, MS SQL Server 7.0 and 2000, Oracle (9i, 10g), PL/SQL, SQL, SQL *Loader, T-SQL, Teradata

Languages:

SQL, JavaScript, PL/SQL, C, C++, Pro*C, Shell, AWK, UNIX (Sun Solaris 5.6, SCO),

Web:

HTML, XML, PHP4

OS:

MS-DOS, Windows 95 / 98 / 2000 / XP / NT 4.0 and Windows NT 4.0 servers, 2000 and 2003 servers, UNIX

ERP:

Peoplesoft HRMS V8.2, Peoplesoft Financials V8.1, Oracle Apps 11.5.8

MS Office Tools:

MS Office (Excel, Word, Power Point, MS Access), Microsoft Project.

App Development:

UML, Object Oriented Applications, Rational Rose

Data Modeling:

Erwin 3.5.2, ER/Studio 4.0, Visio

PROFESSIONAL SUMMARY

Confidential,BALTIMORE, MARYLAND USA APR 10 – TILL DATE

Cognos Manager / Technical Lead

The Laureate Education Inc used Ultimate Software, Cognos 8 suite to develop numerous dashboards, reporting solutions for HR Operations globally showing several business metrics related to HRIS, Benefits, Payroll and Compensation

Responsibilities

• Created Cognos templates for reports and reports landing page for the entire organization to view Cognos reports
• Created the Saratoga Dashboards for Global Operations depicting the quarterly cost to revenue ratio, employee demographics etc
• Created US National Dashboard for Organization wide KPIs for Finance, HR, Compensation, Benefits & Employee demographics
• Successfully implemented the data integration for the Malaysia entities And gathered the requirements and created enterprise wide implementation of Cognos reports

Confidential,SILVER SPRINGS, MARYLAND & PLEASANTON CALIFORNIA USA AUG 06 – APR 10 DATE

Project Manager

The Kaiser Permanente Information Technology (KPIT) used Cognos 8 suite to develop numerous dashboards showing several business metrics related to Finance, HR systems, Hospital & Quality in the National LMP Dashboard, HR Workforce Dashboard & CAL Dashboard

Responsibilities

• Gathered the PMO artifacts for standard processes and formal documentation for Project
• Created the stakeholder register and analyzed the stakeholders using the salience model
• Used formal procedures and templates for the Business Analysts to gathered the Business Requirements and thereby defining the scope and proactively managed the scope creep by following the change control process
• Defined the Work Breakdown Structure with the help of the project team by analyzing the activities needed for each deliverable & Used that for Estimating the Cost and Time for each activity for creating Project schedule
• Created Project Management Plan by integrating various plans and there by created MS Project Plan and communicated the Business using standard communication tools and thereby distributed the Performance reports on timely basis in form of Status reports, Trend Reports etc
• Used numerous methods to create Risk Management Plan for handling the threats and opportunities for the risks registered in the Risk Register
• Constantly monitored the project scope, cost and schedule so that the project is completed within time and budget
• Used the scope statement to create Quality metrics checklist for the product acceptance
• Efficiently identified, Influenced and resolved numerous issues concerning technical standards, inter-personal conflicts
• Calculated the Performance measures related to completed work and forecasts on bi-weekly basis and communicated them to the required stakeholders
• Established clear goals and agendas of projects and project meetings thereby directed the team using facilitated workshops for inter-team and inter-personal building activities
• Improvised processes and templates so that they would ease & enhance the project development standards
• Extensively used Visio to create diagrams which would efficiently convey the information across various teams
• Coordinated with the PMO & Functional Managers for procuring various resources needed for the projects
• Closed the project following proper standards and documented the processes and procedures for on-going operations and made sure that proper handover of the project was completed
• Followed the PMI Ethics and Conduct Codes regarding Project Management
• Assisted the project team to get training as well as getting support from Organization to facilitate the team with the organizational standards and policies so that they are duly implemented
• Efficiently fast-tracked & crashed the project schedule during stringent deadlines and situations and completed the project within due time
• Created a War-room for the project team and ensured that the communications went well and the team cohesion was formed
• Implemented the Tools and Techniques documentation to track the lessons learned during the project time
• Planned proper Resource Allocation to various tasks by proactively understanding the needs of the Project as well as of the team members
• Enhanced problem solving techniques for both technical and non-technical issues and followed a structured approach so that the process was followed properly and thereby avoiding any conflicts
• Encouraged inter-team dialogue about technical issues and resolutions so that all concerns and ideas were factored in
• Understood the concerns and requests of the stakeholders and kept all of them on single page about project work
• Created reward system for better performance and dedicated efforts towards project tasks
• Assisted the Admins to identify and create the users in Access Manager and assign them respective roles
• Followed sessions with the data modeler and data owners to decide the required data model for particular Cognos projects
• Analyzed the data and database from Oracle 10g/9i databases by querying from TOAD, WinSql
• Assisted the testing team for UAT and BCT by creating test scripts
• Successfully deployed all the projects to Production meeting the deadline and carried out support tasks by closing the incidents in quick time
• Improved the quality of the work by enhancing looks and performance of all the Cognos applications
• Managed the onshore & offshore Cognos Teams to yield successful results and met the deadlines for every project

Environment

• Cognos 8.x, Access Manager, AbInitio, Informatica Power center v7.0, MS DOS Script, SQL, SQL Server 2K, Oracle 9i, DB2, Win 2000, UNIX, Mainframe, TOAD, WinSql

Confidential,OAKLAND, CALIFORNIA, USA FEB 05 – AUG 06

Project Manager / Cognos Technical Lead

The My-HR Project at Kaiser Permanente used the Cognos Suite for transforming the existing HR, Payroll and Benefit Reports from Genesis, COBOL, SAS, and Crystal Reports to Cognos ReportNet.

Responsibilities

• Successfully transformed into the role of Project Manager from Cognos Technical Lead
• Made efficient use of the Organizational Process Assets such as documentation, process, templates etc
• Iteratively and efficiently identified various stakeholders and their influence and designed a strategy to know their inputs and concerns
• Identified the legacy system users and the designers and thereby assisted the Business Analysts to brainstorm the requirements by creating workshops for requirement gathering
• Facilitated the Business Analysts with the templates for requirement gathering and scope definition and thereby created a common understanding of the requirement and scope of work
• Estimated the project work using various methods and factored in the risks and thereby created the budget, timelines and thus created the project plan
• Organized a kick-off meeting by bringing all stakeholders to a table to give the necessary jumpstart and focus for the project
• Tracked and reported the project progress using various charts and kept the customers and management aware of progress
• Assisted the technical team overcome the technical challenges by getting the Cognos/IBM support for any issues
• Prepared tips and techniques document so that everyone shared the knowledge for future references
• Followed up with the technical teams, customers and sponsors in weekly meetings and resolved their issues with an efficient way
• Made the team aware of the compliance issues and duly followed them as per the regulations
• Managed inter-team concerns and resolved the problems in the benefit of the project work as well as all the teams
• Ensured the proper usage of skills and technology was used by Quality Assurance to satisfy the Quality Standards
• Re-iterated and constantly checked resolved, mitigated and transferred any Risks and efficiently handled them using the most suitable process
• Created and enhanced an efficient communication process within the teams to keep everyone on the same page
• Assisted the Analysts and Technical team to create a proper knowledge transfer of the product for the efficient management of the product operations
• Mentored and managed on-shore and off-shore team by distributing them work and assisted them to carry on their work properly by resolving their issues
• Coordinated with Testing team for UAT and BCT and assisted developing the Test scripts and Test plans
• Identified and analyzed the HRMS source tables and joins which were needed for reporting & created the Technical documentation and mapping documents
• Connected the backend PeopleSoft EPM database in Cognos Connection to develop the Payroll and Workforce Benefit Packages in Framework Manager and published them into CRN to use for Query Studio for creating ad-hoc queries and Report Studio for developing the Reports.
• Created packages having proper business names and created joins for performance enhancement
• Developed HR, Payroll and Benefit Reports for the Kaiser Permanente Area Managers and HR Personnel
• Developed Cubes for Employee Leave Accruals, Demographics and Pay Balances Leave using Power play Transformer and published them to Cognos ReportNet server
• Wrote reports using Report Studio for creating dashboards by using specific color coding schemes for Charts, Trend Lines, Bar graphs, Stacked charts, Gauges, Pie-charts
• Created complex reports with List, Crosstabs, Discontinuous crosstabs, master-detailed reports, drill down & drill through reports, cascading prompts with simple to very complex calculations
• Exclusively used the Conditional Layout, Conditional Formatting, Conditional blocks and Report variables for dynamic rendering of the reports as per the selection
• Analyzed the particular problems with the ETL, Database and the Development teams regarding the issues and solved the problems efficiently
• Organized and archived the Project documents as per the standards for future references
• Was awarded the My-HR Excellence Award in 2006 for the dedicated and consistent efforts towards the project which had helped Kaiser Permanente Program Offices reach new heights with reporting systems

Environment

• ReportNet V 1.x, Cognos 8.1, Cognos 7.4, Access Manager, AbInitio, Informatica Power center v7.0, MS DOS Script, SQL, SQL Server 2K, Oracle 9i, DB2, Win 2000, UNIX, Mainframe, TOAD, WinSql

Confidential,ORISKANY, NEW YORK, USA FEB 04 – DEC 04

Sr. Cognos Developer

Chryslers Orion Bus Corporation used the Cognos Suite for transforming the existing Backlog and Revenue system’s information into catalogs and cubes in order to prepare Rapid Delivery of Ad-Hoc Data to IB associates

Responsibilities

• Interacted with users for requirement gathering
• Involved in analysis, and design the technical
• Documented the specifications to create Catalogs and also wrote the mapping documents
• Imported Metadata from SAP BW Datasources
• Installed and Configured Cognos Impromptu and Transformer 7.2, CRN on a stand alone and development work has been done in windows based CRN, later we created deployment package and will be transferred to Unix box
• Created Database Objects including Views, Catalogs, Packages in Use of Backlog and Revenue systems
• Created four different Catalogs in Impromptu Administrator importing metadata from Backlog, Revenue, Time Track and Expense systems and used in order to create reports
• Defined join conditions, table aliases and views for the user requirement.
• Created folders, filters, prompts, calculations and stored in catalog.
• Created and customized various List reports, cross tab reports, drill through reports and sub- reports.
• Created and developed various reports like Business Mix Reports, Variance Reports, and Trend over Time Reports
• Worked on cross tab reports, drill-thru, linked-sub reports and sub reports.
• Created multi page report based on multiple Master queries to show the data on different pages when the Master record changes in a Report
• Created numerous simple to complex reports in Impromptu and published the reports to IWR using Upfront
• Created Power-prompts and wrote Java Script to validate the prompts
• Created drill through reports from Revenue to Backlog summary then to Client details based on the Client ID.
• Developing Multi-Dimensional Analysis and Business Metrics Reports using Cognos Power Play and Power Cubes using Cognos Transformer 7.2
• Formulation of joins strategy and Adding columns in catalog after they are added in already existing tables
• Extensively used Power play Transformer to move relative data mart data into powercubes
• Responsible for publishing Powerplay cubes to upfront using PPES to provide end users with a single, Web-based point of personalized access to reports.
• Customized cube content with view (Suppress, Cloak, Filter, Summarize)
• Successfully migrated the Cognos Series 7.x to Cognos ReportNet V1.0
• Configuration and maintenance of Directory Server (LDAP) and Domain Name System (DNS) for security authentication and authorization
• Created various joins, cardinalities, filters, calculations and followed the aesthetics of package development
• Created datasources in Cognos Connection and imported the tables, columns in Framework Manager from deriving data from various datasources
• Wrote simple to very complex Iqd’s which were the datasources for the cube creation
• Created numerous Cubes using Cognos Transformer 7.2 by creating proper dimensions, levels, measures from single to multiple iqd’s
• Created Alternate Drill downs in the cubes for analysis of the data
• Calculated categories were generated for certain Levels where data summarization was needed
• Enhanced the Cube refresh and report performance issues using data and process analysis
• Created users and user classes through Access manager.
• Created complex reports with List, Crosstabs, Discontinuous crosstabs, master-detailed reports, drill down & drill through reports
• Published Impromptu Web Reports (IWR) and cubes on upfront using Cognos Server Administration tool.
• Organized accessed data sources into Transformer models, Dimensional maps and developed Power-Cubes, which can be changed in many ways to Slice and Dice and drill-through data for further multi dimensional analysis.
• Wrote macro\'s to schedule the Power Cube refresh
• Maintain the Cube Security by Category level and Dimension level.

Environment

• Cognos ReportNet V1.0, Cognos Impromptu 7.x, Cognos Transformer 7.3, Access Manager, MS DOS Script, SQL, SQL Server 2K, Oracle 9i, DB2, Win 2000, UNIX, Mainframe, WinSql

Confidential,PUNE, INDIA JAN 01 – OCT 02

Web Developer

Responsibilities

• Installation of SQL Server and Apache and IIS Web Server
• Created Web Applications in ASP 3.0 for Yellow Pages and for Dental Business Forecaster
• Created Style sheets for the standards of the Web Portal
• Talked to the user and gathered the requirements and prepared mock ups
• Understood the requirements thoroughly to implement the expected application utilities
• Created various modules such as Login, User registration, Discussion Forums etc.
• Created various data models and tables and joins within the SQL server
• Used MS access for creating some data storage
• Implemented security features using the session id’s etc
• Successfully deployed the application onto several servers