SUMMARY:

• Senior BI Consultant with 10+ years of experience in Database, Data Warehousing & Business Intelligence with strong experience in Enterprise Data Warehousing.
• Working knowledge of Qlikview.
• Experienced in managing the project deliverables, work allocation and invoicing.:
• Extensive experience in leading the development team for successful delivery of BI projects.
• Good experience in leading the service team for supporting Enterprise Data warehouses and Data marts.
• Experience and expertise in understanding existing business processes, data analysis, requirements analysis, business systems analysis and design, converting requirements specifications into functional specifications.
• Involved in Full Life - Cycle project activities from defining project roles and responsibilities, detailing project plans, requirements gathering and specification to implementation, testing and support.
• Appreciated for improving & maintaining the project deliverables and status from Red to Green zone.
• Expertise in Cognos 8, 10 suites (Report studio, Query Studio, Analysis Studio, Framework Manager, Transformer).
• Have closely been working with organizations in providing Data Reporting Solutions such as Report Development, Framework Model Creation, Power Play Cubes creation, Data Management to increase process quality and a reduction in batch failures.
• Have lead the team and developed highly complex reports with complexity pertaining to the database as well as report structure requirements.
• Certified by IBM Cognos as COGNOS 8 BI AUTHOR, along with Oracle and Teradata.
• Experience in Creating Models and publishing packages using Framework manager.
• Sound Knowledge as a Solution Designer in designing and building end user reports using Cognos Report Studio, design a model to generate power cubes using Cognos Transformer.
• Good experience in ETL tools like IBM Data Stage & Data Manager.
• Strong experience in Consumer Health Care and P&C Insurance domain.
• Excellent Inter-personal skills and a quick learner. Ability to get along with the team well, proven leadership qualities and client co-ordination.
• Decisive leader with sound understanding of Onsite/Offshore Model and deft in managing members of distributed skill sets, ensuring judicious utilization of resource, cross-functional teams comprising of On-site teams, offshore teams, Developers etc.

TECHNICAL SKILLS:

Reporting: Qlikview 10,IBM Cognos BI 10/ 8 Series(Cognos Connection, Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio, Power Play Transformer), Cognos EP Series 7.0(Impromptu, Power Play Transformer, Power Play Web, Enterprise Server, Upfront), Access Manager

ETL: IBM Data Stage, Data Manager, Informatica

Languages: SQL, PL/SQL

Databases: Oracle 12c/11g/10g/9i/8i, SQL Server, MS-Access, DB2, Teradata 12

Web Servers: IIS 6.0, Apache

Platform: Windows, UNIX.

Data Modeler: SQL Developer, Erwin

Interface Tool: Toad, PL/SQL Developer, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant

Responsibilities:

• To work extensively with Business groups in identify the data logic
• Analyzing the existing excel reports to identify the business logic.
• Explaining the business logic to team and assigning tasks.
• Devising the SQL code for transforming the data.
• Designing and developing the Cognos Framework model.
• Designing and developing the Cognos Report studio reports for creating the Dashboards.
• Developing Dash Insight application for housing the dashboards.

ENVIRONMENT: Cognos 10.2, Oracle 12c, DashInsight 4.

Data Lead

Responsibilities:

• To work extensively with Business groups in identify the data logic
• Working with the development team to explain the load process.
• Working with data modeler to identify the relevant dimension attributes and facts.
• Designing the ETL load process.
• Design the ETL mappings
• Developing complex mapplets as reusable components.
• Developing the Qlikview POCs
• Assisting the team for developing the Qlikview data model.
• Assisting the team for developing the Qlikview dashboard.

ENVIRONMENT: Qlikview 10, Informatica Power Center 9, Teradata v12.

Project Lead

Responsibilities:

• To work extensively with Business groups in identifying new enhancement requests.
• Presenting the weekly and monthly reviews of the project to the client managers.
• Designing the solutions for new requirements and managing its delivery along with load balancing among the team for the other support activities.
• Managing the deliverables for several enhancements involving various stake holders.
• Managing & tracking the effort and invoicing of the change requests.
• Analyzing the business requirements, identify the bottlenecks and iterate them with business groups.
• Coordinating the development & support effort with the offshore team members.
• Maintaining the project’s SLA adherence in green zone.
• Managing the day-to-day support activities.

ENVIRONMENT: IBM Cognos 10/8.4/8.3 BI, Data Stage 7.5, Oracle 10g, Windows server 2003, Remedy.

Project Lead

Responsibilities:

• Interact with the client for requirement understanding.
• To design and troubleshoot the ETL process to collect data from JDE system and load it into the Data warehouse built up on Oracle 10g.
• To design Transformer model and troubleshoot the issues related to cubes.
• Review of work products and documents.
• To guide the team to resolve ETL and reporting issues.
• To assign and validate the tasks to the team

ENVIRONMENT: IBM Cognos 8.4, Data Stage 7.5, Oracle 10g, Windows server 2003.

Module Lead

Responsibilities:

• Interact with the client for requirement understanding and elucidate the team.
• Create the DMR and relational Framework model for the development of reports and ad hoc analysis.
• Create the Transformer model for building the cubes.
• Development of POCs for different cube and reporting requirements
• Analysis, Designing and Development of Reports, Assisting team members in development & troubleshooting issues.
• Validate the reports for data.

Cognos Consultant

Cognos Developer