Objective:

Seeking a challenging position as Cognos Developer/Cognos TM1 Developer/Analyst to effectively utilize creative and analytical problem solving skills

Professional Summary:

• 7 years of overall experience in IT industry
• 5 years of Experience in Business intelligence
• Experience in working as a Cognos Developer/Cognos TM1 developer/Cognos Analyst
• Certified IBM Cognos TM1 Developer , Certified IBM Cognos TM1 Analyst and Certified Cognos BI metadata developer
• Awarded twice for excellent performance by 'The Boeing' IT Team
• Experience in complete system development life cycle (SDLC)
• Experience in understanding the different business work flows
• Expertise working on Cognos 8 application (Framework Manager , Query Studio, Report Studio, transformers)
• Expertise working on CognosTM1 9.4 application (TM1 Perspective, TM1 Architect, TurboIntegrator, TM1 Rules)
• Created reports using financial cubes
• Experience working with Oracle and SQL Databases
• Experience in DMR modeling
• Understanding of MDX (in creating dynamic subsets)
• Experience in integration of Cognos TM1 9.4 and Cognos 8.4
• Worked on Third party tools for migration of packages from 8.2 to 8.4 using upgrade Manager and moving the packages and cubes from Development to Test and Test to Production using BSP Meta Manager 3.2
• Experience following Macro scope format of documentation
• Attended seminars on TM1 (9.5) for new features
• Provided end user training and support

Technical Skills:

BI Tools: Cognos 8 Frame work Manager (8.0/8.4), Query Studio, Analysis Studio, Report Studio, Transformers

Cognos TM1: TM1 perspective, TM1 Architect, TurboIntegrator, Cube Viewer,
TM1 Rules editor, TM1 Web reports

Database System: Oracle 10g/9i/8i, SQL 2005, DB2, Teradata

Programming Languages: SQL, PLSQL, MDX, C

Web Servers: Microsoft Internet Information server (IIS) 4.0, Sun one 5.2

Microsoft Tools: Ms Word, Ms Excel, Ms PowerPoint, Ms Project

Operating System: Windows 95/98/2000/NT/XP

Third Party Tools: Upgrade Manager, BSP MetaManager 3.2, TravTime

Education/Certifications:

• Associate Degree in Engineering
• Bachelor's Degree in Engineering
• Masters in Engineering Management
• IBM Certified Cognos 8 BI Metadata Developer
• IBM certified Cognos TM1 developer
• IBM certified Cognos TM1 Analyst

Work Experience:

Confidential, Dec 2010 - Present
Redwood City, CA
Cognos/TM1 Developer

Confidential, connects utilities with their customers and transforms the delivery of smart grid services while improving energy efficiency, empowering customers and ensuring reliable delivery of low-cost services. We provide the hardware, software and services that connect every device on the smart grid, creating a unified Smart Energy Platform. Over this unified platform, smart utility networks can deploy any number of advanced applications, such as Smart Metering, Demand Response, Distribution Automation and Distributed Generation. Smart Utility Networks can also allow devices such as meters, load management controllers and electric vehicle charging stations to communicate with each other and the utility.
Responsibilities:

• Understanding the multidimensionality of the data for designing Cubes in TM1 and using them as source for Cognos 8 and excel reporting
• Gathered the requirements for regular analysis and forecast and financial reporting in Cognos 8.4 and excel
• Mapped the old structure for different auxiliary cubes feeding the main cubes reporting cubes
• Worked with the team for creating the cubes and modifying the dimensions in the current structures and the old cubes using Business rules using TI process
• Worked with the team on enhancing the existing cubes by suggesting the changes to the structures and modifying the processes
• Worked on adding the new client to the existing servers by partly working as an admin
• Ran the monthly TurboIntegrator process and the chores as per the monthly routine
• Worked with the integration of Cognos TM1 9.5 with Cognos 8.4
• Used Cognos TM1 cubes as data source for Cognos Financial Reporting
• Worked closely with the managers for enhancing the reporting needs as an output from TM1 and Cognos query studio
• Worked on data validation with the Oracle team as a part of TM1 routine
• Added security to the cubes and dimensions in TM1 by controlling them time to time
• Suggested the changes in the process while implementing new TurboIntegrator processes with the team
• Worked with the Oracle team for cleaning the data as a regular fishing routine and applying different checks from time to time
• Documented TM1 objects and the use in different servers

Environment:Cognos 8.4 (Frame work Manager), Query Studio, Cognos TM1 (9.5), TurboIntegrator, TM1 Architect, TM1 Perspective, Oracle 10g, ASCII files

Confidential, Nov 2009 - Present

Cognos Developer/Cognos TM1 application Developer/Analyst

Confidential, is a major aerospace and defense corporation, founded by William E. Boeing in Seattle, Washington. Boeing has expanded over the years, merging with McDonnell Douglas in 1997. Boeing Corporate headquarters has been in Chicago, Illinois since 2001. Boeing is made up of multiple business units, which are Boeing Commercial Airplanes (BCA); Boeing Defense, Space & Security (BDS); Engineering, Operations & Technology; Boeing Capital; and Boeing Shared Services Group.
Responsibilities:

• Understanding the multidimensionality of the data for designing DMR models in Cognos 8 as well as for designing dimensions and cubes in Cognos TM1 by analyzing and identifying different data sources
• Gathered the requirements for regular analysis and for Financial Performances during the JAD sessions
• Created a prototype model for the users
• Created DMR models in Framework Manager and analyzed the same in Query studio
• Worked and supported existing reporting structure
• Created dimensions and cubes using Turbo integrator process using ASCII Flat files and loaded the data by TI process
• Published DMR models and cubes to Cognos Portal
• Used best practices in Cognos TM1 for creating dimensions, cubes in TI process (ordering, indexing, loading the data in cubes, also includes naming convention) and rule statements
• Worked on the scenario modeling (what if analysis)for Boeing Telecom group and Boeing Desktop & computing group
• Involved in Replication of cubes between servers and synchronized the cubes on demand
• Created process chores in TM1 Turbo Integrator
• Strongly analyzed and created different budgeting scenarios by using combinations of different subsets and using data spreading techniques
• Improved the performance of the cubes and DMR models
• Controlled the cubes and dimensions in TM1
• Browsed the data after creating the cubes in cube viewer and In-spreadsheet browser
• Sliced and diced the views in cube viewer (using zero suppression method)
• Created static subsets (by narrow down list method)
• Integrated Cognos TM19.4 and Cognos 8.4
• Worked with the database team for cleaning the data by regular fishing routine
• Supported the Metrics after it was open enterprise wide
• Created Ad hoc reports in query studio for top level management
• Prepared documentation to train end users regarding the functionality of TM1

Environment:Cognos 8.4 (Frame work Manager), Query Studio, Cognos TM1 (9.4), TurboIntegrator, TM1 Architect, TM1 Perspective, Oracle 10g, Metamanager, ASCII files

Confidential, Richmond, VA Jan 2008 - Oct 2009

Cognos Developer:

Confidential, is one of the nation\'s largest producers and transporters of energy, with a portfolio of approximately 27,400 megawatts of generation, 1.2 trillion cubic feet equivalent of proved natural gas and oil reserves, 14,000 miles of natural gas transmission, gathering and storage pipeline and 6,000 miles of electric transmission lines. Dominion operates the nation\'s largest natural gas storage facility with 975 billion cubic feet of storage capacity and serves retail energy customers in 12 states. Corporate headquarters are in Richmond, Va. The project was to understand and analyze the company's financial projection of past 3 years, by helping the Planning team to revaluate company's strength, market and competition. The project was to build DMR models for different metrics, analyze them for further forecasting and budgeting.
Responsibilities:

• Understanding and gathering prerequisites for modeling, reporting and Analysis.
• Worked on installation and configuration of Cognos applications to develop complete SDLC
• Analyzed and identified different data sources for Cognos 8
• Created distribution lists, contacts and printers in Cognos Connection
• Developed Relational and DMR models in Framework Manager with physical and presentation layers to cater various business needs
• Created links to share the model data with other modelers
• Included complex queries, calculations in each models and applied data and package level securities in Framework Manager
• Created complex report using Report Studio and ad hoc reports using Query Studio
• Applied and documented best practices for Framework manager to create models and fine tune the models
• Attended the training for Cognos TM1 through IBM
• Worked with the financial team to install Cognos TM1 9.0
• Worked with the team on post production support
• Prepared user manuals and trained end users to for Adhoc querying
• Prepared user training manuals of TM1 installation for the existing environments

Environment: Cognos 8.0 (Report Studio, Query Studio, Framework Manager), Oracle9i, Cognos TM1 (9.0)

Confidential, Chattanooga TN Jan 2007 - Nov 2007

Confidential, provider is a diversified financial services company that operates businesses related to Commercial Banking, Branch Banking, Consumer Lending and Investment Banking. The project involved metadata modeling in order to generate financial reports for the fiscal year cycle. Providing data security and access authentication to different users was also to be maintained.
Responsibilities:

• Interacted with business users to identify key Dimensions and Measures for different Accounting systems
• Analyzed the available Data Sources and mapping the architecture need of Models
• Created standard filters, calculations, and conditions in Models
• Formulated the joins, resolving relationship, cardinality in FM
• Built models, generate packages using multi data source in Framework Manager
• Published packages by managing data and package level securities
• Created multiple dimensions, alternate drill through in the existing models as per the reporting requirements
• Migrated packages and reports from series 7 to Cognos 8
• Created standard Calculations, Filters, for Ad-hoc query users
• Involved in the performance tuning of SQL queries
• Conducted periodic training for Adhoc users
• Prepared documentation to train end users regarding the functionality of each report

Environment:ReportNet, Cognos8 (Report Studio, Query Studio, Framework Manager), Access Manager, Powerplay 7.1, Transformer, Oracle 9i, Windows 2000

Confidential, Piscataway, NJ Oct 2005 - Oct 2006

Cognos consultant
Confidential, is the world\'s most comprehensive and broadly based manufacturer of health care products, through its operating companies, as well as a provider of related services, for the consumer, pharmaceutical, and medical devices and diagnostics markets. The fundamental objective of Johnson & Johnson was to provide scientifically sound, high quality products and services to help heal, cure disease and improve the quality of life. The project involved collecting and planning the data, utilization of the planning data in form of Cognos 8 reports and DMR models which contributed to more accurate measurement of critical parameters and the budgeted sales, using migration, creation and atomization of financial reports from Oracle financial database, figures of the products manufactured by the company to help in the planning of production levels, storage levels and inventory management

Responsibilities:

• Involved in installation and configuration of Cognos 8.0
• Involved in migration of cubes and reports from Cognos series 7 to Cognos 8.0
• Used Framework Manager to model metadata by analyzing the cardinalities and joins in the process of model design and created, published packages with security settings to Cognos 8.0 server
• Created multi dimensional and summary reports using analysis studio to read and analyze data
• Created financial reports, created drill through reports in Query Studio and used them in Report Studio and created master - detail relations within the child reports.
• Worked on complex reports like list, cross tab, dashboard reports, calculated columns, filters and cascading prompts.
• Performed manual SQL tuning to enhance the performance of complex reports.
• Deployed the packages and reports from development to test environment and test to production environment.
• Involved in integrating existing LDAP security with Cognos 8.0 server security.
• Prepared user manual and trained end users with Cognos 8.0 functionality.

Environment: Cognos 8.0, Cognos ReportNet 1.1, Oracle 8i, Teradata.

Confidential, Mumbai, India June 2003 - Aug 2005

Functional Analyst
Confidential, is India\'s second-largest bank with total assets of Rs. 4,062.34 billion (US$ 91 billion). ICICI Bank offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life and non-life insurance, venture capital and asset management.ICICI Bank\'s equity shares are listed in India on Bombay Stock Exchange and the National Stock Exchange of India Limited and its American Depositary Receipts (ADRs) are listed on the New York Stock Exchange (NYSE).

Responsibilities:

• Conducted meetings with the client regarding requirement analysis
• Followed standard analysis procedures to understand the primary format and scope of the system requirements
• Guided developers on the points to be documented and the common documenting conventions
• Analyzed the documented information and converting it into assertive forms
• Prepared standard reports and forwarded them to the concerned authorities
• Prepared common questionnaires, slides, forms used in requirement analysis
• Prepared standard reports and forwarding them to the concerned authorities