OBJECTIVE
Seeking challenging position in software development to contribute my knowledge for the growth of the company and self, also to improve my domain and technical expertise in Business Intelligence

SUMMARY

• IBM Cognos Certified Report Author and Modeler with over 8 years of experience in Database, Data Warehousing & Business Intelligence with strong experience in Enterprise Data Warehousing tools like Cognos and Ab Initio
• Involved in Full Life-Cycle project activitiesfrom defining project roles and responsibilities, detailing project plans, requirements gathering and specification to implementation, testing and support
• Extensively worked on Relational Databases like Oracle, MS-SQL Server, DB2 and Teradata
• Experience with Dimensional Data Modeling and creating Star Schema/Snowflake Schema
• Experience in Data modeling using Erwin Data Modeler
• Experience in creating complex Stored Procedures, Tables, Views, Materialized Query tables, Indexes and SQL
• Strong experience in Architectural design for ETL and Reporting
• Experience with the Cognos 8/10 BI tools (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Metric Studio, Transformer, TM1, Lifecycle Manager) as a Developerand Administrator
• Involved in Metadata modeling using Cognos Framework Manager, Cognos Transformer
• Implemented Security at different levels in Framework Manager and Cognos Connection
• Expertise in developing Complex Reports (List, Crosstab, Drill through, Master-Detail, Charts, Maps, multi-query multi-prompt reports, burst reports) and Dashboards and Active Reports using Report studio
• Strong experience in best practices design and performance tuning
• Involved in theCognos Administration Tasks like Creating Data source Connections, Publishing Packages, scheduling reports, User Creation, Assigning Security, Deployment of Packages and reports in different environments
• Created Multi Dimensional Cubes using the Cognos Transformer and created Powerplay Cubes
• Involved in the Installation and Configuration of Cognos 8.4 BI tools and Framework Manager
• Experience in the Migration of Cognos Applications fromCognos 8 to Cognos 10, Impromptu/CRN toCognos8 Environment and from Crystal Reports and Mainframe COBOL to Cognos 8Environment
• Experience in customizing reports using Java Scripts, knowledge of Unix Shell Scripting
• Strong experience in ETL process including Data Quality, Source Systems Analysis, Business Rules Validation, Source to Target Mapping Design, Performance Tuning and High Volume Data Loads
• Experience in Ab Initio GDE, Ab Initio EME, Co>Operating System and interaction among these components
• Ability to efficiently relate and transfer the domain challenges and requirement to the product solution
• Expertise in Architectural design, creating Technical, Functional and Non-Functional Requirement documents, High Level and Detailed Design Documents, User Guides and Technical Uptake documents
• Strong consulting and mentoring skills in DW and BI space and demonstrated ability to learn new technologies
• Played the role of a Developer, Lead developer, Mentor, Business Analyst and Architect in various DW projects
• Decisive team player with the ability to meet deadlines, handle multiple tasks and flexible in work schedules

POFESSIONAL CERTIFICATIONS

• IBM Cognos certified BI Author (IBM Certification)
• IBM Cognos certified Modeler (IBM Certification)
• Software Quality Foundation Certification (Infosys Certification)
• Ab Initio Certification (Infosys Certification)
• Teradata certification

TECHNICAL SKILLS

• Business Intelligence Tools
• Cognos 8 / 10: Framework Manager, Report Studio, Query Studio, Cognos Connection, Metric Designer, Metric Studio, Analysis studio and Event Studio, Transformer, TM1, Lifecycle Manager
• Other Versions: Cognos ReportNet, Cognos Impromptu
• Ab Initio: Ab Initio Co>Operating System 2.14,15,16 GDE 1.14, 1.15, 1.16
• Data Modeler: Erwin 4.5/4.0/3.5
• Operating Systems
• Windows 7/VISTA/NT/XP/ME/2000/95/98, LINUX/UNIX
• Databases
• Oracle 11g/10g/9i/8i, DB2, MS-SQL Server 2000/2005, Teradata
• Programming Languages
• C, C++, Java, SQL, PL/SQL(Cursors, Stored Procedures, Triggers and Functions), Perl, PHP, UNIX Shell Scripting, HTML, XML
• Domain
• Banking, Retail, Insurance

PROFESSIONAL EXPERIENCE

Project: Confidential,09/2011 07/2012
Client: Confidential,
Position: Lead Cognos Developer
Responsibilities: Worked in analyzing their social media, survey and chat responses from the customers of the products and providing insights to their customer satisfaction.

• In depth interaction with Client Architects, Project Manager, Subject Matter Experts, and Developers for solution implementation
• Responsible for the architectural design and detailed design of reporting and obtaining sign off from the business
• Involved in the Installation and Configuration of Cognos 10 BI tools and Framework Manager
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Created data model using Erwin data modeler
• Created database layer, business layer and presentation layer, defining appropriate relationship between query subjects in Framework Manager
• Created Active Reports, List, Crosstab, Dashboard Reports and Drill-Through Reports using advanced reporting techniques in Cognos
• Created several burst reports using Cognos
• Performance tuning of reports at Reporting layer and Framework Manager Model layer
• Extensively worked on the complex prompt page design of various reports
• Creating Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports in Query Studio
• Created ad hoc framework manager model and trained business users to work with the ad hoc package in Cognos Query Studio
• Provided security at different levels for Cognos reports and Framework model
• Used JavaScript for certain validations to overcome the limitations in Cognos report studio
• Created Test Plan and involved in test cases preparation and execution of the test plan
• Handled deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 10 Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio), MS SQL Server, Erwin Data Modeler 4.5, Windows XP

Project: Confidential, 01/2011 - 08/2011
Client: Confidential,
Position: Lead Cognos Developer
Responsibilities: Guthy Renker is one of the largest and most respected direct marketing companies in the world, with distribution in 61 countries. The goal of this project is to process the social media data and to gain business insights. The goal of the project was to upgrade all the existing reports from Cognos Version 8 to version 10 and also to develop few new reports and address some change requests for existing reports

• Involved in the entire project life cycle from analysis, installation, upgrade and development, testing, production and end user support
• Actively participated in the project estimation and the design of the Technical Architecture
• Responsible for settings up Cognos environment for development, testing and production
• Upgraded all the existing reports from Cognos 8 to Cognos 10
• Worked extensively on the testing of the upgraded reports and obtained sign off from the business users
• Discussion with the business regarding their analytical requirements
• Designing the cube as per business needs and creating them in TM1
• Worked on addressing the various burst requirements of the user
• Created Cognos Framework Model and developed active reports, drill through reports and scheduled reports
• Customized Cognos Connection Portal to personalize the homepage
• Extensively worked on the performance tuning of the reports
• Scheduled reports using the Schedule Management tool, Event Studio in Cognos Connection
• Modified Cognos Framework Manager model and reports to address requirement change requests and enhancement requests from the clients post production
• Trained the end users on Cognos 10 environment

Environment: Cognos 10 Suite (Framework Manager, Cognos Connection, Query Studio, Report Studio, Event Studio, TM1, Lifecycle Manager), SQL Developer, Windows

Project: Confidential, 06/2009 12/2010
Client: Confidential,Position: DW Architect/ Lead Cognos Developer

Responsibilities: Replaced the legacy obsolete Crystal COBOL reporting system with semantic metadata driven COGNOS layer by facilitating the analytical needs of the portfolio

• Gathered Business requirements and designed functional and technical requirement and design documentation.
• Analyzing complex COBOL procedures and translating its logic into Cognos report design documents
• Analyzing the report logic and structure from Crystal reports and creating Report design documents
• Served as data modeler in enhancing the portfolio data model for future need
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager
• Set up the Security at the package level, query subject level and the query item level
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model
• Designed and developed the Framework Manager models and published into the Cognos connection
• Created Packages in Framework Manager by importing metadata from different data sources
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level
• Created various complex List, Crosstab, Charts and Dashboard Reports and Drill-Through Reports
• Performance tuning by writing DB2 procedures and importing it as data source and creating Native SQL in Framework Model Layer and also suggesting ETL changes for better performance of reports
• Creating custom calculations in Framework Manager layer to handle complex report logic shared by multiple reports
• Customized data by adding advanced prompts, Filters, Calculations, Summaries and Functions
• Writing VB scripts in Excel to validate the report output with database query results as a part of testing
• Creating test plan SQL scripts for validating data coming from Framework model and reports
• Developed Reports with Multiple Cognos Viewers and with multiple Cognos Reports Integrated onto a Single Page Report
• Collaborated with Business Leaders to share and gather Cognos Planning requirements
• Creating Framework model for ad-hoc reporting needs of the business and training users to build and customize their ad-hoc reports
• In depth interaction with Business and client architects for solution implementation
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities
• Designed few active reports based on the user requirements
• Trained users in using the Ad-hoc components of version 10 that is Business Insight and the Business Insight Advanced

Environment: Cognos 8.4 (Framework Manager, Cognos Connection, Query Studio, Report Studio), DB2, Ab Initio, Mainframes, Erwin data Modeler, Windows XP

Project: Confidential,03/2008 05/2009
Client: Confidential,Position: Lead Cognos Developer

Responsibilities: Provided an interim reporting solution in a span of two months to address the immediate report requirements of the clients when they wanted to analyze the success of their new SkyMiles launch.

• Clear interaction with Business users regarding the business requirements and reporting needs
• Analysis of the data for the data model and report requirements of the business
• Creating design documents for data model, reports and Framework Manager Model and obtaining sign off from business
• Creating test plan and SQL scripts for Cognos reports and Framework Manager model and obtaining sign off from business
• Involved in the Installation and Configuration of Cognos 8.4 BI tools and Framework Manager.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Implemented Framework manager security for Data access, Object level access and Package level access based on the Organization Level
• Created various complex List Reports, Cross tab Reports, Chart Reports and Drill-Through Reports
• Analyzing the performance requirements of the reports carrying out performance tuning by creating Materialized Query Tables, Views, Indexes and handling complex joins and logic a ETL level
• Creating jobs, scheduling and Distributing Reports through Schedule Management in Cognos Connection
• Handling training sessions and demonstration of Cognos tools to End-users
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 8.4 (Framework Manager, Cognos Connection, Query Studio, Report Studio), DB2, AbInitio, Mainframes, Windows XP

Project: Confidential, 06/2007 02/2008
Client: Confidential,Position: DW Architect/Lead BI developer

Responsibilities: Provided an integrated data mart which shall store all necessary information in order to produce SEC and FASB mandated regulatory disclosures, Call Report and a set of specialized SunTrust (STI) level reports across all lending portfolios.

• Clear interaction with the clients to determine the business drivers
• Responsible for project estimation, ETL architectural design, design walkthrough to clients and developers
• Extensively worked on creating the data mart using Ab Initio GDE
• Worked extensively on Data profiling for understanding the data and creating mapping document
• Developed graph for population of the base fact from two major systems
• Developed various Ab Initio Graphs for data cleansing
• Parameterization of various graphs to reduce coding effect
• Used Different Ab Initio Components like Sort, Dedup, Rollup, Scan, Reformat, Join in Various Graphs
• Worked on components like run program and runsql components to run UNIX and SQL commands in Ab Initio
• Extensively worked on Partitioning and De-Partitioning components
• Worked on improving the performance of Ab Initio graphs by using various performance techniques
• Discussion about the data transport techniques, extract and load dependencies
• Design for Source System failures
• Development of Cognos Framework Manager Model, Transformer model, Cubes and complex dashboard reports, Drill up, drill down, drill though and Master Detail reports.
• Customized Cognos Connection according to the project specifications
• Involved in administration tasks like creating data source, publishing packages, creating users, role based user security and scheduling the reports
• Created SQL scripts to validate the data from the integrated data mart through Cognos reports
• Created Ad-hoc Framework Manager Model and trained users to work in Query Studio
• Worked on Quality Centre for QA related tasks
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 8 (Framework Manager, Cognos Connection, Query Studio, Report Studio, Transformer), DB2, Ab Initio (GDE, Co>Operating System), Unix, Quality Centre, Windows XP

Project: Confidential,11/2006 05/2007
Client: Confidential,Position: Cognos Lead Developer

Responsibilities: Customer relationship Management System project is used for research on the new customers, potential customers and old customers and their engagement with the business and the new products. The project aimed at creating a data model for different modules and carrying out the research with the aid or Cognos reports.

• Worked closely with Business Users in understanding the domain challenges
• Responsible for converting functional requirements into technical specifications
• Translated complex concepts in ways that can be understood by a variety of audiences
• Extensively worked on creating data model for the project using Erwin
• Worked on metadata modeling in Cognos Framework manager to meet the report requirements
• Built Multi Dimensional Models (DMR) with Relational Data using Framework Manager and Deployed Packages to the Report Servers.
• Created complex dashboards, drill through reports, crosstab and chart reports with advanced reporting capabilities
• Worked in Cognos Job creation, scheduling, and troubleshooting
• Extensively worked on the performance requirements of the reports
• Worked on Complex SQL queries for data testing
• Worked as a mentor, assisting the team to gain expertise in Cognos
• Handling deployment of packages in different environment, user training, knowledge transfer, support and transition activities

Environment: Cognos 8(Framework Manager, Cognos Connection, Query Studio, Report Studio, Transformer), Erwin, SQL Server 2000, Excel, Windows XP