SUMMARY:

• A result driven IT consultant with experience of over 11 years in IT Strategy, SDLC, Business Intelligence solutions and Agile practices.
• Proficient in implementing Data Warehousing and Business Intelligence (BI) solutions.
• Experienced in Tools like Cognos, Tableau, OBIEE with strong knowledge of Oracle and SQL Server Databases.
• Strong experience in Client interaction, Leading Team, Business Requirements and Data Modeling.
• Experienced in migration and upgradation projects in Cognos.

TECHNICAL SKILLS:

BI Tools: Cognos 8 and 10, ReportNet1.1, Cognos Impromptu, Cognos PowerPlay Transformer, Brio 8.2, OBIEE, Business Objects

Databases: Oracle, SQL Server

Data Modeling Tools: Erwin

ETL Tools: Working knowledge of DataStage and Informatica

Languages: SQL, PL/SQL

Environment Management: Databases, Java, BRE, .NET, UNIX, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Technical Lead

Responsibilities:

• Analyzed data provided by the business analysts for pricing data loads.
• Understand and analyze metadata and identification of key metrics.
• Developed PL/SQL scripts and other code related components to load the data into data base.
• Provided functional and technical expertise on BI - DW projects.
• Involved in piloting and implementing Cognos BI platform for the Infrastructure reporting agile pod.
• Worked with Managing Consultants to propose reporting solutions to the client.
• Delivered Framework model and canned reports as part of proof of concept.
• Testing and performance tuning of Cognos reports/data model to meet the required SLA.
• Environment Management for the non-prod environment used by Data Load team.
• Responsible for doing production release/implementations.

Environment: Cognos10, Oracle, SQL server, Java, Blaze Rules, Windows, UNIX

Confidential, Boston, MA

Team Lead

Responsibilities:

• Led an onsite team of 4 technical resources who worked on Cognos and Risk applications.
• Understand the existing data elements behind current cognos reports and SQL queries.
• Worked on enhancing and fine tuning Cognos Framework models.
• Developed standard Templates which laid a foundation for all reporting needs.
• Developed dashboards and custom reports from multiple data sources.
• Debug and minor changes to PL/SQL stored procedures to eliminate data discrepancies.
• Involved in migration project from Business Objects to Cognos.
• Trained the team on Cognos best practices.

Environment: Cognos10, Oracle, Windows

Confidential, Boston, MA

Cognos Data Analyst

Responsibilities:

• Analysis towards the data elements that will be brought into the data warehouse.
• Worked on Cognos reports and cubes for reverse engineering.
• Data profiling and analysis by directly writing SQL queries against the database.
• Worked with IT department in designing the warehouse and establishing dimensions and facts tables.
• Lead several working sessions with IT to put together the logical and physical data model.
• Coordinated between the business and IT team during the entire project life cycle.
• Worked on writing formal requirements with the business team for the data warehouse release.

Environment: Cognos8, Oracle, Erwin

Confidential, Albany, NY

Cognos Consultant

• Worked on SQL Framework Models and Query subjects.
• Worked on expanding existing cognos Framework Model for efficient reporting.
• Developed SQL based reports using Toad and integrated them into cognos.
• Worked on several requests from business towards building Report Studio reports.
• Implemented strategies to use existing cognos model and SQL inserts to create cognos reports.
• Report optimization which included combination of joins/unions and SQL inserts.

Environment: Cognos 8.3 (Frame Work Manager, Cognos Connection, Report Studio), Oracle10g

Confidential, Princeton, NJ

Sr. Cognos Developer

• Managing and Administering the entire Cognos 8 for BI Team.
• Involved in designing the Framework Manager Models.
• Improving existing models by Creating Alias tables and applying other techniques for effective reporting.

Environment: Cognos 8.4 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Oracle9i

Confidential, Albany, NY

Lead Cognos Consultant

Responsibilities: 

• Evaluated existing data architecture and performed analysis towards a new reporting platform.
• Researched best practices towards the necessary metadata modeling.
• Indentified Gaps between the current data scenario and desired data approach.
• Implemented new Cognos BI environment.
• Examined the process and business flow methods to identify quality data to be used for reporting from redundant/junk data.

Environment: Cognos 9 Express, Impromptu 7.4, SQL Server, DB2

Confidential, Princeton, NJ

Sr. Cognos Consultant

• Designed and incorporated changes as per different client requirements into Framework Manager Model.
• Developed List Reports, Charts, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio.
• Worked on development and maintenance of Power Play cubes.
• Working extensively on applying and maintaining Security for several different users in ReportNet..
• Estimated the time and effort for various ReportNet reports and fitting them piece by piece into the migration cycle.

Confidential, Santa Clara, CA

Cognos Report Writer

• Created Dashboards using the new Dashboard feature in Cognos 8.3
• Slicing and Dicing on Reports.
• Implemented complex drill down requirements into the reports.
• Implemented the MDX queries to create reports in Cognos.
• Reporting based on hierarchies, levels and members from cube data. .

Confidential, Oklahoma City, OK

Senior Cognos Developer/Admin

Responsibilities:

• Conducting meetings with in the Dobson group; and between AT&T and Dobson to discuss the transition process.
• Analysis of the scenarios discussed and formulated the strategy to implement the changes.
• Involved in architectural changes into the Cognos environment.
• Extensively worked on Security to account and restrict AT&T users from seeing the Dobson regions.
• Monitored the cubes, scheduling of reports/cubes, migrations between servers.

Confidential, Boston, MA

Consulting Engineer (Cognos)

Responsibilities:

• Extensively developed Cognos reports that included lists, charts, pies, graphs, repeaters etc.
• Developed some complex Dashboards which included multiple queries, each with different levels in depth b/c of usage of Tabular models and Tabular.
• Understanding Database schema for various clients and importing it into the Cognos Environment.
• Working with Customer service support in fixing the reports returned back from clients.

Confidential, Raleigh, NC

ReportNet Developer

Responsibilities:

• Worked on enhancing and expanding existing Framework Manager Model. Created simple to complex reports as well as Dashboard like reports using Report Studio.
• Deployment of reports and administering cognos connection.
• Responsible for training and creating Ad hoc reports for business users.