SUMMARY

• Almost 7 years of experience in IT and Business Intelligence of which 5 years in Cognos space having experience in analysis, design, development, testing and implementation of business intelligence solutions and 2.5 years in TM1
• 2.5 Years of experience in Cognos TM1 10.x and TM1 9.x tools
• Cognos TM1 Architect, Perspective and Web client components as production support role.
• Experience in various COGNOS Tools - Cognos 10.x and 8.x BI Suite includes Report Studio, Analysis Studio, Query Studio, Cognos Connection, Power Play Transformer and Power Play Tools, Business Insight, Business Insight advance, Active Reports
• Extensively worked on COGNOS 10 Framework Manager - Creating Models in Framework Manager - Importing Meta Data from Different Sources, Dimension Hierarchy, Star Schema Grouping, Model Design Accelerator and Packages
• Extensively worked on Power Play Transformer - designing and building the Power play cubes using Transformer and developing the dashboard reports by using cube as data source
• Sound experience in performance tuning
• Sound Skills in Report Authoring in Report Studio - Custom Functionality in prompt page and Report Page using JavaScript in HTML ITEMS and Conditional Blocks to develop Hide and Show scenarios, Bursting Options, Extensive Dashboards
• Expert skills in developing complex reports using Direct SQL (with Clause) and Co-related Queries, Sub Queries and Nested Sub Queries in Report Studio
• Developed complex layouts using List, Cross tabs and Chart reports using Master-detailed relationships and Drill-through functionality
• Having good exposure in D.W.H Architecture, OLAP Technologies knowledge in OLTP System Study, Database Schemas like Star schema and Snowflake schema used in relational and dimensional modeling
• Knowledge of ETL tools such as Informatica, Datastage and Teradata, well versed with Datawarehousing concepts
• Experience and expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into detail reportingspecifications
• Experience in Functional Testing, well versed with Test Processes and methodologies and hold ISTQB foundation Certificate in Software Testing
• Excellent troubleshooting /problem solving skills, ability to Mentor and desire to achieve the target
• Excellent communication skills, Quick Learner, Highly motivated and hardworking IT savvy

TECHNICAL SKILLS

Business Intelligence/ETL Tools: Cognos, Teradata, Informatica, Datastage, SSIS, SSRS, SSAS, SAP BI

Tools: Mercury Quality Centre, Test Director, QTP, WinRunner, Visual Source Safe

Programming & Technical Skills: SQL, UNIX, HTML, JavaScript, XML, C, C++, Java, C#.Net, ASP.NET

Databases: SQL Server, Oracle, TOAD, MySQL, MS Access 2003

Operating Systems: MS-DOS, Windows NT/X/Vista, Main frames

Software: MS Office Suite, Project, Visio

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Cognos TM1 Developer

Responsibilities:

• Creating Dimensions, both manually and using Turbo Integrator (TI) Process
• Creating of Subsets like static and dynamic
• Development and Maintenance of TM1 Cubes (Standard, Control, Virtual, Lookup Cube etc)
• Writing Rules
• Assigning Security assignment
• Creating drill through process to exchange data between cubes
• Creating Turbo Integrator (TI) Processes
• Creating Excel template for running TI process for end users
• Doing enhancements to the existing cubes on different servers as per the business requirement
• Created different types of reports like Snapshot, Slice and Active form
• Supporting And Training Clients
• Managing the minor enhancements for the team and coordination of business user acceptance testing

Environment: Cognos TM1 10.1,Oracle,Agresso,Cogons 10.1

Confidential

Business Intelligence Developer (Cognos10.1 and TM1 9.5)

Responsibilities:

• Requirement gathering and documenting technical design document
• Involved in developing and designing of cubes, dimensions, Input sheets and Reports.
• Updating the rules to capture the data into the scenarios
• Integration of TM1 with Cognos
• Used various data spreading techniques
• Creating Aliases, picklist
• Created Slice, Active form and Snapshot report and uploaded into Applications
• Created and published package from the Framework Manager (FM)
• Created dashboard using Business Insight
• Build complex packages using various tool options, also used Model Design Accelerator to build star schema model in Framework Manager
• Created various Reports like list, crosstab and chart
• Created Reports,Filters, and Cascading Prompts
• Customized reports using various featuresHeader/Footer, run report with options, etc.
• The reports ranged from using repeaters, conditional variables and complex calculations.
• TM1 Cube maintenance and support
• Gathering therequirementsandanalysisof thespecificationsprovided by the clients during weeklymeetings.
• Performed Query optimization.
• Interacted with the business users and assisted them to use query Studio to develop ad - hoc reports.
• Accomplished various user request using Sorting/ aggregation tools, Grouping/Ungrouping, Expand/Collapse Group, Formatting tools, Swap options, setting up web page size / page breaks

Environment: Cognos 10(Report Studio, Query Studio, Analysis Studio, PowerPlay Studio, Event Studio, Transformer and Framework Manager), SQL Server 2008, Oracle 9i/10g (SQL, PL/SQL), SSIS

Confidential

Business Intelligence Developer

Responsibilities:

• Design and develop reporting solutions using Cognos 8.4 to meet the outlined requirement of the Operational, Compliance & Analytical needs
• The reports developed included CASA approved forms that were critical to the day to day operations and ensured compliance to Aviation standards.
• Responsible for the gap/data analysis, technical design, implementation and deliverables.
• Expertise with the power play transformer model, and cube design with single or multiple data sources.
• Responsible for the Cognos security, scheduling and deploy reports from development to testing and production.
• Worked on multi query reports, drill-thru, prompted, bursting, union query, SQL joins, and tabular SQL in the report studio.
• Responsible to design Cognos power play cubes,
• Proficient with model query subjects, data source query subjects, and stored procedure query subjects in the framework manager.
• Effectively scheduled all the reports and sending emails to users using Event Studio in cognos8.
• Key role in production issue resolution and helping users
• Knowledge with star schema grouping, segmenting, and linking (Multi-user environment).
• Provided user training on query studio and Cognos tool functionality.
• Responsible for team co-ordination/mentoring, production support and deployment.

Environment: Cognos 8.4(Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, and Framework Manager), Mantis Bug Tracker, Oracle 10g (SQL, PL/SQL)

Confidential

Cognos Developer /Tester

Responsibilities:

• Framework Metadata modelling, Report Authoring
• Writing the Technical and reviewing the technical design document
• Supporting the UAT Environment in tackling the Issues, bugs Raised
• Ensuring successful deployment of reports to production
• Modifying existing reports
• Troubleshooting the current report issue by analysing the SQL both in the report studio and Framework Manager and try to resolve the issues by proper joins between the tables
• Testing the Reports, interface and data testing

Environment: Cognos 8.4(Report Studio, Query Studio, Analysis Studio, Event Studio, and Framework Manager), HP Quality Center, Oracle 10g (SQL, PL/SQL), Teradata

Confidential

Cognos Developer + Tester

Responsibilities:

• Business Requirement Gathering and Planning
• GDW workflow understanding and Data Model design update.
• Framework Model design, development and implementation with appropriate security.
• GDW Batch scheduling according to data planning.
• Worked with the Business Analysts to understand the report requirements and to create different business scenarios for data validation and data sanity check during the testing phase.
• Development and maintenance of Cubes in Cognos Transformer.
• Analyzing Cubes by creating cube views using Analysis Studio
• Documentation for all stages of project until the client signs off
• Created Drill through Reports, Dashboards, adhoc reports, Analytical & Standard reports.
• Involved in Development, testing, deployment and Scheduling of Cognos reports.
• Worked on resolving the Performance issues of the Cognos reports and increased the performance of the reports by tuning SQL.
• Unit testing and shadow support of the project until the project is live.
• Prepared User documentation to train users and functionality of each report.
• Provided the training to end users

Environment: Cognos 8 BI, UNIX, Control-M, Transformer, HP Quality Center, Oracle 10g

Confidential

Business Intelligence Analyst (Cognos)

Responsibilities:

• Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Analyzing and Understanding the client requirements for each report.
• Design and development of Framework model using Cognos Framework Manager 8.
• Generating various List Reports, Grouped Reports, Cross tab Reports, Drill-Through Reports and SQL Based Reports.
• Conditional Formatting of the report's.
• Unit testing of the reports by running SQL at backend.
• Created 5 Query Studio Queries. Managed Administrative task of setting User Level Security in Cognos Connection.

Environment: Cognos 8.4/8.3 (Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Framework Manager, PowerPlay Transformer), SSIS, SQL Server 2005, Oracle 9i/10g (SQL, PL/SQL)

Confidential

Business Intelligence Analyst/Tester

Responsibilities:

• Testing reports created by BI Consultants
• Liaising with Functional Team for functional & authorizations issues as per transactions
• Reviewing and analysing technical design document