SUMMARY:

• Having 11 Years of Experience in design, development, Testing, Implementing and support for Data warehousing Projects.
• Involved in Full - Cycle project activities from defining project roles and responsibilities, detailing project plans, requirements gathering and specification to implementation, testing and support.
• Have a strong understanding of relational database concepts and extensively worked on Databases like Oracle, MS-SQL Server, DB2, Informix, Teradata.
• Experience in Dimensional Modeling and creating Star Schema/Snowflake Schema.
• Proficient in Dimensional Data Modeling, Physical & Logical data modeling.
• Experience in implementing large-scale applications with expertise in designing and developing Business Intelligence solutions using Cognos 10/8.
• Expertise in performing a variety of complex and technical functions including designing and testing.
• Have a strong understanding of Big Data concepts.
• Expertise in building models of Ralph Kimball methodologies using Cognos Framework Manager.
• Experience in creating multi-dimensional Powerplay cubes using Cognos Transformer.
• Proficient in developing Dashboard/complex reports in Cognos 10/8 BI and Qlikview.
• Experience in creating Dynamic Cubes using Cube Designer.
• Strong experience in best practices design and performance tuning.
• Expertise in Architectural design, Creating Technical, Functional requirement documents, High Level and Detailed Design Documents.
• Proficient in Cognos Administration like installation and configuration, Security, Migration and Deployments.
• Played the role of a Developer, Lead Consultant, Mentor, Administrator and Architect in various DW projects.
• Experience in understanding and working with On-site Off-shore environment.
• Self-starter with drive, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver results, even under pressure.
• Strong analytical & good communication Skills. Very keen and enthusiastic, constant desire to learn, genuine commitment to excel.

TECHNICAL SKILLS:

Reporting & BI Tools: IBM Cognos 10 Suite, Cognos Report Net 8.4/8.3/8.2/8.1/1.0/1.1 (Report Studio, Query Studio, Analysis Studio, Cognos Connection, Event Studio and Framework Manager), IBM Cognos Dynamic Cubes, Cognos Powerplay, Cognos Transformer, Cognos Series 7 and Qlikview 11.20.

Operating Systems: Windows 2000/03/XP/NT, Linux, IBM AIX, Solaris.

Networking & protocols: TCP/IP, DNS, IIS, FTP, HTTP and SMTP

Web/App Servers: IIS, Apache 2.05/2.2

ETL: Informatica

Languages: SQL, C, C++, XML, HTML and Java Scripts

Database Connectivity Interfaces: ODBC, JDBC.

Databases: MS SQL Server 7.0/2000, Oracle 11g/10g/9i/8i, IBM DB2, IBM Informix, Teradata.

Microsoft Tools: MS Excel, MS Word, MS PowerPoint Studio, SharePoint Server.

Hadoop/Big Data Technologies: HDFS, MapReduce, Hive, Pig, Sqoop, Hbase, ZooKeeper.

Domain: Communication, Media & Entertainment, Energy & Utility and Automotive.

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield Beach, Florida

Senior Consultant

Responsibilities:

• Gathering report requirements and documenting.
• Developed various Report studio reports like lists and charts.
• Developed Master-detail reports. Used Join objects in Report Studio for working with data at different levels of granularity.
• Analyzing the root cause of the issue and fixing the reports.
• Implemented report bursting to distribute reports effectively.
• Updated the existing Framework Manager models with new requirements.
• Worked on improving the performance of reports.

Environment: Oracle 11g, Teradata 13.10.07.12, Cognos 10.2(Framework Manager, Report Studio, Query Studio, workspace Advanced, Analysis Studio).

Confidential, Dallas, Texas

Lead Consultant

Responsibilities:

• Involved in the entire life cycle from analysis, installation, development, testing, production and end user support.
• Actively participated in the project estimation and the design of the Technical Architecture.
• Designed and developed the Framework Manager models and published into the Cognos connection.
• Extensively worked on the performance tuning at report layer and Framework Manager Layer.
• Authored various types of reports and Dashboards in Report Studio.
• Responsible for setting up Cognos environment for development, testing and production.
• Developed reports using Pass-through SQL to tune report performance. Used union/Join objects in Report Studio.
• Design and implementation of third party schedulers (CAWA and Espresso).
• Provided security at different levels for Cognos reports and packages.
• Used Cognos Event Studio to mange report runs and notifications.
• Created various List, Chart and Drill-Through Reports.
• Testing Data and Reports in all phases of Development.
• Created Dynamic Cubes using Cube Designer.
• Scheduled & delegated tasks to the team members.
• Created groups and roles in providing access to users.
• Developed Qlikview POC and prototypes for Analytical Reports.
• Prepared Weekly Status Reports (PSR) and shared with the Managers.
• Worked on On-site Off-shore environment.
• Integrated Cognos with MS SharePoint for Single Sign-on and seamless integration.
• Established an audit reporting system to monitor, analyze performance and usage of different reports and other objects.
• Handled deployment of packages in different environment, user, knowledge transfer, support and transition activities.
• Supported various applications in Production environment.

Environment: Oracle 11g, IBM Informix, Cognos 10.2(Framework Manager, Report Studio, Query Studio, Event Studio, Cube Designer, Analysis Studio), TOAD.

Confidential, Burbank, CA

Senior Consultant

Responsibilities:

• Gathering Business Requirements and documenting them technically with all phases of SDLC and Translating business requirement into Technical specification.
• Handled complete range of BI capabilities: reporting, analysis, score carding, dashboards and business event management.
• Understanding the requirements from the Functional Specifications.
• Created complex DMR and relational packages in Framework Manager Model.
• Designed and implemented various Materialized views to use in Cognos Reporting.
• Testing Data and Reports in all phases of Development.
• Developed Transformer models and created powerplay Cubes.
• Developed dimensional reports using multidimensional data source (Cubes and DMR) in Report Studio.
• Developed Several Reports including burst reports using Query Studio, Report Studio, and Analysis Studio.
• Assisted and worked with ETL developers to make sure that model being developed is according to the business requirements.
• Prepared Best Practices Documentation for Authoring & for developing a metadata model using Framework Manager.
• Administered Cognos BI Server environment.
• Worked on performance tuning of existing reports and models.
• Prepared User documentation to train users and functionality of each report.
• Prepared Weekly Status Reports (PSR) and shared with the Managers.

Environment: DB2, Cognos 8.3.(Framework Manager, Transformer Model, Power play Cube, Report Studio, Query Studio, Analysis Studio),TOAD.

Confidential

Senior Consultant

Responsibilities:

• Preparation of Design and Estimation
• Gathering Business Requirements and documenting them technically with all phases of SDLC and Translating business requirement into Technical specification.
• Created Packages in Framework Manager
• Created Transformer Model and published as Power play Cubes.
• Testing Cubes, Packages and Reports and Tuning for the Performance.
• Prepared Gate Review documents for moving from Development environment to QA and to Production.
• Involved in unit testing and preparing unit test document for Packages and Reports.
• Submitted issues in Quality Center and regularly checking the Status of the issue and work closely with Developers to resolve.
• Peer reviewing the reports.
• Mentored and trained users for the successful execution of the project.

Environment: Oracle 9i, Cognos 8.3 Cognos 8.3.(Framework Manager, Transformer Model, Power play Cube, Report Studio, Query Studio, Analysis Studio.

Confidential

Senior Consultant

Responsibilities:

• Created Data Sources in Cognos Connection to work with the Cubes in Cognos 8.
• Publishing Cubes as Packages in Framework Manager.
• Tested the Cubes in Analysis Studio.
• Deployment of Cubes in Production environment.
• Involved with Scheduling Reports through Schedule Management in Cognos Connection.
• Created the Packages in Framework Manager.
• Preparation of all other required Documents.

Environment: Oracle 9i, Cognos 8.2, Cognos 8 Report Studio, Cognos 8 Analysis Studio, Cognos 8 Powerplay Transformer, Cognos 8 Framework Manager and Windows 2000 Server.

Confidential

Cognos Developer

Responsibilities:

• Building Ad hoc Reports using Query Studio And Building Reports using Report Studio
• Working with Data through Filtering, Sorting, Grouping Identical values, calculations, summarization, changing the data format. Using prompts to filter data & creating Custom groups.
• Changing the Appearance of Reports titles, ordering items, swapping rows & columns.
• Adding conditional formatting to a report (Hiding & showing objects, Highlighting.
• Create Run, and Schedule Reports and Jobs using Cognos Connection.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.

Environment: Oracle 9i, Cognos ReportNet (Query Studio &Report Studio) and Windows 2000 Server.

Confidential

Cognos Developer

Responsibilities:

• Created catalogs using Cognos Impromptu 7 to generate reports.
• Created standard filters, calculations, prompts and conditions in catalog.
• Solving Troubleshooting in powerplay etc
• Creation of catalogs, Impromptu Query Definition (IQD) to Power cubes.
• Thoroughly understanding the core functionality of user requirements.
• Adding multiple layouts and Drill-through to master detail reports.
• Working with Data through Filtering, Sorting, Grouping Identical values, calculations, summarization, changing the data format.
• Maintained the Cognos Query Models, Impromptu, IWR, Cognos Power Play.
• Supported Cognos application.

Environment: Sql Server, Impromptu 7.1, Impromptu Web Reports 7.1(IWR), Cognos Upfront 7.1 and Cognos Power Play Transformer 7.1, Windows 2000.