PROFESSIONAL SUMMARY

• 8 years of IT industry experience in the areas of requirements gathering, analysis, design, development, testing, implementation, migration and application support
• Over 6 years of experience in analysis, modeling & design, and development of data warehouse and reporting applications using business intelligence (BI, OLAP) technologies
• Over 6 years of experience in various COGNOS Tools - Framework Manager, Report Studio, Analysis Studio, Query Studio, Transformer, Business Insight, Business Insight Advanced COGNOS Connection & COGNOS Administration
• Created dimensional models using star schema and snowflake schema and using cubes
• Interacted with business users. Gathered and translated the requirements into dimensional model
• Worked in different roles as modeler, administrator, designer and developer
• Experience in transformer models on corporate data to build multidimensional cubes
• Experienced in SQL and in relational databases DB2, Oracle and SQL server
• Identified and fixed performance issues. Research and suggest best practices on optimizing the COGNOS functionalities from the application perspective
• Strong experience in client interaction and understanding business applications, business data flow and data relations for them
• Prepare SDLC 3.1 industry standard artifacts, like High/Low Level Design, Architecture Profiling; distinguish service level SLA, data classification and integration
• Rationalization of the solution and practical evaluation of the project whether it could be achieved or not
• Involved in budgeting, resource utilization, planning project timelines and status reporting
• Performed deep down analysis of the data for auditing and data quality
• Managed large pool of resources over various technologies and skillset
• Liaised with multiple teams from different horizontals in order to create streamline process maps that would show the interdependency of each department
• Experienced in working with cross-functional teams for end-to-end project delivery
• Conducted data analysis, gap analysis, including AS-IS and TO-BE models
• Highly motivated, result oriented professional with a short learning curve and strong communication skills

TECHNICAL SKILLS

COGNOS Tools: COGNOS 10.1/10.1.1 series - Framework Manager, Report Studio, Analysis Studio, COGNOS Connection, Query Studio, Business Insight. COGNOS 8.4/8.3/8.2 series

Languages: XML, HTML, SQL, PL/SQL

Databases: Oracle 10g/11g, DB2, SQL Server, MS Access

Special Software: QlikView, SQL Developer, SQL Plus, TOAD, MS Word, Visio & Excel, HP Quality Centre

System Analysis and Design: Business Analysis, Data Modeling, Impact Analysis, Effort Estimation, Design, Development, Test plans, Implementation plans, Implementation & Production support.

Computer Systems: WindowsServer2003, Linux, AIX, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Berkeley Heights, NJ

BI Lead

Responsibilities:

• Rationalization of the solution and practical evaluation of the project whether it could be achieved or not
• Budgeting, Resource utilization, Planning project timelines, status reporting
• Analyze and document data requirements from business
• Prepare sample functional specs, mock up reports or similar functional requirement specifications based on information gathered
• Prepare SDLC 3.1 industry standard artifacts, like High/Low Level Design, Architecture Profiling; distinguish service level SLA, data classification, integration
• Construct and analyze BI Model Layer in Cognos from Industry standard IBM IIW anchorage data model
• Identify servers, configurations, and Network topologies
• Analyze application performance and suggest improvements where appropriate
• Analyze changes to design specifications and determine the application impact, utilizing design patterns and existing code where applicable to incorporate and test new requirements
• Involvement in Design, Validation, Deployment, Backup and Restore of the Data Models, Reports, Dashboards, Cubes, Multidimensional Data
• Performed deep down analysis of the data for auditing and data quality
• Implement Data Quality Monitoring system using Portals to display monthly reports on Quality of data
• Responsible for code review, document review, packaging and mentoring fellow team members for development of application
• Work on PVCS for code versioning and Cognos Framework Manager for data modeling, Cognos Transformer for Cube Building, Report Studio for Reporting and Dash boarding
• Manage large pool of resources over various technologies and skillset
• Created dashboards (Rate Change Monitoring) using QlikView

Environment: Cognos 10.2, DB2 z/os, Framework Manager, Transformer, Report Studio, Erwin r9, HPQC, MS-Visio, MS-SharePoint, Duck Creek

Confidential, Boston, MA

COGNOS Developer

Responsibilities:

• Gathering business requirements from users, for the reports to be developed.
• Created functional and technical specifications, which acts as a source for report development, and for QA testing from the business requirement documents.
• Imported tables, views and stored procedures from SQL server database into Framework Manager and created relations and filters in the model.
• Troubleshooting and tuning of FM Relational Models, DMRs and reports for better performance.
• Created a Business User friendly Data Model for AD - Hoc Reporting and also trained Business Users on using AD-Hoc Reporting tools like Business Insight and Business Insight Advanced.
• Worked on creating complex SQL queries
• Provided development support during production release for the reports and fine tuning of complex live and batch reports, to improve report performance and to reduce the report runtime errors.
• Performed unit testing and manual testing on each report after development or whenever there is change in report logic.
• Implemented bursting logic on batch reports and report views to produce separate report outputs for each claim file submitter.
• Migration of reports from Dev to QA and Production environments.
• Upgraded the reports from COGNOS 8.4.1 to COGNOS 10.1.1
• Providing technical assistance and mentoring to business users and perform UAT.

Environment: COGNOS 10.1.1 Components like Framework Manager, Query Studio, Report Studio, Analysis Studio, Business Insight and Business Insight Advanced, Windows XP/7, SQL Server 2008 R2, Oracle 10g

Confidential, Windsor, CT

COGNOS Developer

Responsibilities:

• Created Framework Manager Metadata models in COGNOS 10.1 platform by taking data from MARS database and created three tier metadata models and publishing packages to COGNOS connection.
• Worked on modeling the metadata extracted from multiple databases and established joins, cardinality and provided performance tuning to meet the business needs based on functional specification and requirement specification document.
• Created effective and user friendly prompts which enabled flexibility to analyze the data in all possible ways and at the same time achieve tremendous performance time.
• Created complex reports using variables, conditional styling and conditional blocks as per the client requirements.
• Involved in upgrade of reports from COGNOS 10.1 to COGNOS 10.1.1 platform in production and UAT.
• Worked with users throughout the testing phase to ensure data integrity.
• Worked with Business Analysts to gather requirements from the clients and designing reports.

Environment: COGNOS 10.1/10.1.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio), SQL Server 2008, DB2 and Windows XP/7