SUMMARY

• 15+ years of IT experience involving various aspects of Business Intelligence. Well versed with complete Life Cycle Development process including requirement analysis, documentation, development, testing, implementation, and maintenance.
• 10+ years of strong experience in designing and implementing complex reporting solutions using COGNOS Suite 10.2.1 / 8.4.1 / series 7 ver. 4.
• Proficient in developing metadata models in Framework Manager following best practices.
• Proficient with developing OLAP models, using PowerPlay Transformer.
• Skilled at training users to use Query Studio and Analysis Studio, and Report Studio.
• Ability to effectively communicate with various business groups to gather requirements and prepare functional and technical documents.
• Strong understanding of designing dimensional and relational models, star and snowflake schemas and different DW design paradigms.
• Mid - level knowledge of Oracle and DB2 databases.
• Mid-level knowledge of COGNOS administrative and security tasks.
• Exceptional ability to quickly master new concepts and technologies.
• Excellent functional and technical analysis and communication skills and also maintaining effective working relationships with organizational team.
• Excellent in trouble shooting and multi-tasking with quick turnaround in fixing the issues.
• Sound knowledge with Tableau visualizations and dashboards using

TECHNICAL SKILLS

ETL Tools: Cognos 8 series - Data Manager

Metadata Modeling Tools: Cognos 10.2.1 BI Suite /Cognos 8.4.1 FP4 - Frame Work Manager, Cognos PowerPlay Transformer, Cognos Impromptu Administrator, Cognos 7.3 - Frame Work Manager, Transformer, Siebel Administrator.

Analytic/Visualization Tool: Siebel Analytics 7.8.4, OBIEE, Cognos Power Play Client/Web, Analysis Studio, ESRI Map Designer, Tableau 10.4

Reporting Tools: Cognos 10.1.2/8.4 / 7.3 – Cognos Connection - ReportStudio, QueryStudio, Business Insight, Event Studio, Impromptu Client, Cognos Upfront.

Operating Systems: Windows XP/2000/ME/98/95/NT 4.0, UNIX, zLinux.

Languages: C, C++, Visual C++, Visual Basic 6.0

Web Languages: HTML, XML, JavaScript, VBScript

Databases: MS Access, Oracle, SQL Server 2000, 2005, DB2

Project Management Tools: MS-Office 2003/XP,MS Excel, MS Power Point, MS Word, MS Access, Ip Switch – WS FTP

PROFESSIONAL EXPERIENCE

Client: Confidential, Montvale, NJ

Role: Lead BI – Development/Analytics

Responsibilities:

• Single contact for Cognos/Tableau IT SME. Provide expert assistance to business intelligence users to clarify business/technology issues and decision-making.
• Work with Executive level, Legal department and Daimler Executive level Business users.
• Participate and contribute in different meetings on solution design, process improvement, escalation and other topics.
• Create function specifications as required. Analyze, comprehend and implement client’s required BI methodology.
• Involved in Installation, development, unit testing, and migration to the QA environment, support for system and UAT, migration to production, and support during production stabilization.
• Debug and solve report problems by partnering with technical and business teams.
• Write training materials and assist the team in providing training to end users on report development and execution.
• Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, Master-detail & conditional formatting reports.
• Design and Implement Dashboard reports, drill through reports, and drill up/down reports using cubes as a data source in Cognos Report Studio.
• Developed Active reports for users to use offline and on mobile devices.
• Implemented Burst Functionality to distribute reports effectively.
• Implemented ‘Pick-List’ workaround in Cognos 8.4/10.2 environment – A feature of Impromptu version and not in current versions.
• Implemented the Copy and Active method in Cube builds to avoid Cube lock issue.
• Schedule cube builds and manage them with Windows Task Scheduler along with VB Scripts.
• Mentor Business users on various BI Suite tools.
• Prepared Tool documentation and New features Training Documents for Business and Field Users.
• Deployed Reports, Packages and Folders from QA to PROD Environments.
• Used CISM/ITServ tools to manage the development/Enhancement and Issues that were submitted by the users and other teams.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Working with user group requirement to designed, developed and implemented Tableau visualization solution for Sales, Product and Customer KPIs.

Environment: Cognos 10.2.1 BI Suite, Cognos 8.4.1(Framework Manager, Query studio, Report Studio, Transformer, Analysis Studio) Windows, DB2 Database and Tableau (10.4).

Client: Confidential, Stamford, CT

Role: Senior Cognos BI Developer

Responsibilities:

• Understand the Postal & Meter Usage and Accounting process.
• Study and analyze the existing source system, business flow between the Users and Business line to understand current report generation process.
• Was responsible for understanding the Business requirement by interacting with the On-site lead and communicating with Off-shore Development team.
• Identification & analysis of data elements required for generating reports.
• Participate in design discussion and review session with client solution architect team.
• Prepared Technical Design of the reporting application needed by the Users.
• Validate and analyze the business requirements listed out by the Business Users.
• Involved in Meta Data Model Creation using Frame Work Manager.
• Created several types of reports Business, Accounting and Financial Reports using Cognos Report Studio.
• Created multiple layer report providing a comprehensive and detail report with Drill through facility.
• Involved in integrating different reports in a single page and in adding additional functionalities apart from Cognos using HTML and java scripts.
• Prepared Test Cases for the reports as well as the UI.
• Performed System Unit Testing for the Cognos reports.
• Prepared Design Docs at High Level Design, Low Level design and Application Manual for Business Users.
• Also Involved in Development/Production Maintenance, Enhancement development while on Production used by Business users.

Environment: Database-Oracle 9i, Cognos Server OS--Windows Server 2003 Web Server—IIS, Cognos 8.2 – Framework Manager, Report Studio, Cognos Connection, HTML, JavaScript

Confidential

Responsibilities:

• Understand the Accounting process. Analyze the business flow between the Users and the Accounting.
• Need to validate and analyze the business requirements listed out by the Business Users.
• Documenting the report design (High-level and low-level design), analysis specifications, and functional specifications.
• Validate and analyze the business requirements listed out by the Business Users.
• Mainly involved in Production support of the existing Cognos reporting structure.
• Performed Cognos administrative functions such as creating user accounts, user classes and roles using Access Manager.
• Handle Tickets raised by Users through Clarify tool.
• Involved in enchantment of existing reports, Framework Manager Models.
• Involved in new request for ReportStudio reports.
• Prepared documentation and performed user training.

Environment: Database-Oracle 9i, Cognos Server OS--Windows Server 2003 Web Server—IIS, Cognos 8.2 – Framework Manager, Report Studio, Cognos Connection, HTML, JavaScript

Role: Business Intelligence Executive

Confidential

Responsibilities:

• Analyzed business requirements & developed Process & reporting/metrics.
• Participated in creating the logical design of the Data warehouse to be built.
• Identify and Design the dimensions, facts and fact table details.
• Actively involved in process improvement activities like process flow, problem resolution, etc.
• Perform ETL process using Cognos – Data Manager and create the Metadata for further modeling process.
• Publish packages using Cognos FrameWork manager for further reporting purpose.
• Report generation using Cognos ReportNet.
• Generating Claim wise, Warranty Analysis - dealer and model wise, Repair Analysis -Turn around time for service, Dash board reports Using Report Studio.
• Developed List, Crosstab, and drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, and multi-page, multi-query reports against multiple databases.
• Generated Project document about Extraction, Transformation, loading process, followed by Metadata Modeling phase and step by step documentation of creating reports.

Environment: Windows XP, JavaScript, MS SQL Server 2000, Cognos ReportNet 1.1 - Framework Manager, Report Studio, Query Studio, Cognos Connection.

Client: Confidential, Redmond, WA

Role: Cognos BI Analyst

Responsibilities:

• Mentor a team of 5 members.
• Subject Matter Expert (SME) for all technical, products, tools and process issues.
• Understand the organization and user requirements and decide on the data extraction, transformation and loading. Data analysis and reporting would be easy and efficient.
• Understanding the business flow of the company and arrive at a data flow and business flow analysis.
• Developing business and functional requirements for new business intelligence implementation and subsequent releases.
• Create Reports and Analysis business trend and performance based on Customer Satisfaction and Customer support team.
• Reports included CSAT (Customer Satisfaction) on daily and weekly basis with respect to Quality.
• Assist in Training programs, as needed (new hire training, technical refresher training, etc.).
• Collate, prepare and send Daily and Weekly Flash reports regarding the important metrics of MSN Process to the Client in US on a daily and weekly basis.
• Review trends on Operational Analysis with respect to SL Metrics and other process data with the Managers and Team Lead to work on Action Plans to improve inconsistency.
• Collate data and present them for the Monthly Business and Quarterly Business review.
• Track the necessary data with respect to the MSN process like the Tools downtime tracking report, Quality audits report and fatal error Analysis report with Quality parameters.

Environment: Windows XP/2000, Oracle 9i, MS Excel, Report Net 1.1, Cognos connection, Query Studio, Cognos connection, HTML.

Confidential

Role: Application Developer

Responsibilities:

• Mentor a team of 8-10 members.
• Assist in Training programs, as needed (new hire training, technical refresher training, etc.).
• Bug fixing and problem solving with the existing Excel, Cognos reports.
• Document article and write new KB articles on the new products released.
• Subject Matter Expert (SME) for all technical, products, tools and process issues
• Knowledge Transfer on Cognos to the Team.
• Involved in Development/Production Maintenance, Enhancement development while on Production used by Business users
• Collate, prepare and send Daily and Weekly Flash reports regarding the important metrics.
• Review trends on Operational Analysis with respect to SL Metrics and other process data with the Managers and Team Lead to work on Action Plans to improve inconsistency.