SUMMARY:

• 8.5 years of excellent Industry experience in Data - Warehousing, Business Intelligence and Operational projects.
• Experienced in Trading & Securities, Credit-Risk, HR, Surety-Bonds, Re-Insurance, Consumer Banking, CRM.
• Extensive experience with BI tools: Cognos 10.2/ 10.1.1/10.1 /8. x/ReportNet - Framework Manager Report Studio, Workspace, Business Insight, Query Studio, Analysis Studio, Event Studio, Powerplay Transformer, Dynamic Query Mode (DQM), Dynamic Cubes, Crystal Reports, Oracle Discoverer, Micro Strategy, Cognos Migration
• IBM Cognos certified professional.
• Experienced in Data Modeling for large Data-Warehouse applications including both Relational and Dimensional models - OLTP/MOLAP/ROLAP/Star/Snow-flake models including DMR and Relational MDW/MDM.
• Experienced in BI Solutions and Data Architecture, Reports/Analytics Design, Development and Automation.
• Experienced in conceptualization, design and development of Dashboards, Scorecard, Adhoc Reporting models and other Data Visualization artifacts and Data Security implementation.
• Experienced in creation of data-modeling technical artifacts including Data Models, Use Case Documents, Functional and Technical Specification Documents (FSD, TSD) and Data Flow Diagrams.
• Experienced in end-to-end Data mart engagements from conceptualization, design, documentation, data mapping, development, UAT, deployment and delivery involving both ETL and BI applications.
• Extensive Client-facing and Business Analysis experience while analyzing complex requirements with challenging delivery timelines, working with teams, business liaisons and analysts from across the globe.
• Experienced in ETL design and development in IBM Data Stage, Oracle PL\SQL
• Experienced with Stored Procedures in DB2, Oracle and PL/SQL/Packages development for operational routines.
• Experienced in leading large project teams including Offshore-Onsite model (Development and Maintenance modes) and working with teams from other data/process vendor groups while managing critical SLA bound deliverables.
• Pre-sales experience in tool capabilities presentation and Proof of concepts (PoC).
• Experienced in Agile and SDLC life cycles, Data Aggregation, Data Quality Audit, Performance optimization.
• Experienced in Competency building, technical event hosting and Technology and Documentation.

TECHNICAL SKILLS:

DWBI Tools: Cognos 10.x, 8.x, Series 7 BI - Report Studio, Analysis Studio, Business Insight, Business Insight Advanced, Event Studio, Query Studio, Framework Manager, ReportNet, Powerplay Tranformer, Access Manager, Metrics Studio, Impromptu, Oracle Discoverer, Crystal Reports, Micro-Strategy, IBM Data Stage, Cognos Workspace Advanced

Database: Oracle, DB2, SQL, PL/SQL, RDBMS, Toad/Oracle SQL Developer, Physical Data Modeling

Operation Systems: Unix-Solaris, IBM AIX, Linux, Windows 95/98/2000/XP/Vista/2003

Languages: C, C++, Java, JavaScript, HTML and XML

Project Management: MS Office Excel/Word/PowerPoint/Access/Visio/Microsoft Project, JIRA, HP QC, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Cognos 10.2/8.4, Framework Manger

Responsibilities:

• Own the complex financial model in Cognos, working with the ETL team for fitting reporting requirements.
• Defined standardization items varying from reports formatting templates to meta-data definitions for custom built ad hoc reporting functionality.
• Solved issues with the Cognos meta-data model impeding standardization reports standardization and upgrade.
• Currently working on migration from Cognos 8 to Cognos 10 including enabling new DQM technology.
• Working with a large business team in enhancement and maintenance of custom client reports.
• Migrated a suite of custom client report packages from stored procs to standalone Cognos reports.

Confidential, Weehawken, NJ

Microsoft Visio, IBM Data Stage, Oracle Discoverer

Responsibilities:

• Worked on the architecture and work flow of the entire Cognos migration and laid out the process for the team.
• Lead the team in delivery of the large number of reports including scripted tabbed dashboards in Report Studio.
• Developed meta-data model in Framework Manager for various Business Areas as defined in Discoverer.
• Worked with Consensus Vendor organization in automation of conversion of Discoverer meta-data to Cognos FM xml digests for factory model conversion routine.
• Analyzed Discoverer meta-data and reports in understanding the implementation and identifying challenges.
• Worked on enhancement and maintenance of ETL processes in IBM Data Stage.
• Worked on functional and performance based re-design of ETL structures and data summarization.
• Worked on pilot initiative of analytical modules in Micro-Strategy including presentation of tools capability.

Confidential, Warren, NJ

Cognos 10.1.1/10.1, Report Studio, Framework Manger

Responsibilities:

• Worked as the Cognos reporting solutions data architect and lead developer.
• Worked on the reporting meta-data model (FM 10.1.1). Model complexity involved varied sources of data, and loops in the original design which had to be re-designed to a conformed dimensional model with determinants.
• Worked on performance optimization of the model with Business Namespace Layer of joins and context filters.
• Worked on a large suite of reports from various modules with very complex layouts and aggregations.
• Worked with JavaScript to extensively customize report behavior involving prompt page overrides & templates.
• Worked with highly complex SQL queries for aggregated analytical reports from Product Processor feeds.
• Worked on Powerplay Transformer 10.1.1 while creating a Multi-Dimensional Dashboard PoC 360 degree
• Created complex cube-based reports complete with Tree Prompt functionality in Business Insight Advanced.
• Involved in functional analysis and documentation while playing a dual BA-Developer role.

Confidential, New York, NY

Microsoft Vision, Cognos 10.1, Oracle, JavaScript, HP QC, IBM Data Stage

Responsibilities:

• Worked in the capacity of Cognos and Data Architect while transforming CYBORG model to PeopleSoft.
• Designed the physical reporting Data Mart from scratch to cater to the complex technical requirements.
• Developed an entirely new Data-Mart for use with Cognos Framework Manager, with complex reporting approaches in three contexts - Daily, Current, Historical, As of Date and Range - in the same meta-data model.
• Developed the highly complex security application methodology (row and column level) in the FM model.
• Developed a suite of Ad hoc Cognos packages for subject specific reporting involving complex implicit cursors.
• Worked on the Snow-Flake optimization of the original Star schema model with fact-less fact implementation.
• Developed re-usable components and transformation calculations and filters, macro-based implementation of a highly complex data-security implementation in the model with extensive use of parameter maps.
• Worked with the PeopleSoft team in overhauling the initial Data-Mart architecture to meet the requirements.
• Worked on ETL design of extraction and transformation of People Soft HCM data to be staged and loaded to MDW data source for reporting.
• Worked on data transformation logic in Data Stage for mimicking numerous scenarios (Daily, Point in Time, Historical, As of Date, As of Effective Date reporting scenarios) of data usage in report, for development of ETL routines that worked with the functional requirements.

Confidential, Jersey City, NJ

Cognos 8.4, Report Studio, Framework Manger

Responsibilities:

• Worked with client management and users and the existing application team in transforming the legacy model and inherent issues into a more usable, issue-free and scalable system in Cognos.
• Managed the offshore team, while at client site in technology delivery of the system.
• Decisively lead the project away from timeline slippages and delivery risks.

Confidential, Jersey City, NJ

Cognos 8.4, Report Studio, Framework Manger

Responsibilities:

• Lead team in developing a pilot module on HR KPI concepts.
• Worked on critical performance issues of the reporting module created by the team.
• Worked closely with the Confidential delivery management in enhancing the proposal to a dashboard based.
• Analyzed existing reporting system with the Re-insurance group and helped identify the pitfalls and limitations.

Confidential, Irving, TX

Cognos 8, Report Studio, Framework Manger

Responsibilities:

• Worked closely with business personnel on defining the business scope of the module.
• Worked on the functional requirements in converting the existing deck of PPT based reporting.
• Worked on meta-data design of the staged data and traffic light pattern dashboards.
• Derived the implementation of complicated calculation of risk scores and aggregation patterns.
• Developed the dashboard and the main deck of reports involving complex levels of context switching, navigation and presentation of data including graphs, spark charts etc.
• Developed JavaScript implementation of collapsible navigation list panels, hover values and hyperlink texts.

Confidential, Irving, TX

Cognos 8, Report Studio, Analysis Studio, Framework Manger

Responsibilities:

• Design and implementation of reports in Phase I and II of the project.
• Implemented hierarchical security structures and objects in the framework manager model in Phase II.
• Coordinated and managed the entire Phase II of the project in all technical and delivery aspects.
• Lead the offshore team in delivery of Phase II to leverage the system to an audience of 700 users at an almost inexistent defect count. Widely appreciated by both client and organization management.
• Participated in subsequent releases assisting the team in complex report implementation methodology.
• Draft of test plans and coordination with offshore team to implement the test cases.
• Designed complicated data filters in the framework model using macros, parameter maps and data.
• Worked on conditional formatting, conditional layouts, report level joins, calculations, hierarchical tree prompts using DMR, unions, graphs and charts, summary tables, report branding standards.
• Worked on dashboard pages, portlets, search functionality, graphical reports, drill through navigation etc.
• Worked on a PoC in using PL/SQL with REF CURSORS to create reports to interactively write back to DB.

Confidential, Irving, TX

Cognos 8, Powerplay Transformer 7.4, Analysis Studio, Oracle SQL Developer, IBM AIX

Responsibilities:

• Involved in design of the cube models from queries on the framework model to iqds to mdls.
• Developed and tested various cube models on Cognos Powerplay Transformer 7.4
• Debugged deviation of certain calculated facts precision and format of metrics.
• Responsible for maintenance and enhancement releases of the Profitability and Restatement cubes.
• Worked on special categories involving time dimension, setting of time period values, implementation of data sources, dimensions, facts, power cube definitions, alternate drill downs etc in the dimensional model.
• Worked on debugging during cube construction on UNIX, in resolving cube volume issues, Multi-File Cube Threshold settings etc to handle voluminous cubes.

Confidential, Irving, TX

Cognos 8, Powerplay Transformer 7.4, Analysis Studio, Framework Manger

Responsibilities:

• Involved in the migration planning activity with the team and NAIT infrastructure administrators.
• Re-designed cube models to work with new environment standards involving Access Manager Implementation.
• Manually migrated cube drill-through definitions in the new environment due to utility incompatibilities.
• Re-designed the security framework to be compliant with the new environment implementation after migration.
• Implemented a PoC for job status reporting using Event Studio using audit and content store schemas data.
• The project involved integrating the existing CBG cubes with NAIT Access Manager data-sources.

Confidential, Irving, TX

Cognos 8, Framework Manger, Report Studio, Oracle SQL Developer

Responsibilities:

• General maintenance of Staging reports during the Restatement process.
• Developed a number of new Customer Hub validation/audit reports.
• Coordination with Production Support team towards smooth delivery of Restatement reports and cubes.
• Work involved creation and configuration of Cognos jobs, creation of java routines for report scheduling.

Confidential, Detroit, MI

Cognos 8, Framework Manger

Responsibilities:

• Developed ETL package in Oracle PL/SQL for staging, cleansing and star schema grouping.
• Developed the start schema model in the Framework Manger for the quarterly and annual business reviews.
• Developed the original deck of reports - graphs/charts/statistical reports including quarterly, monthly and yearly trends in customer interests, vehicle sales, match of sales to leads, trends of quality of lead data etc.
• Handled presentation to the client in Annual Business Review meeting.

Confidential

Cognos ReportNet, Framework Manger, Report Studio, Oracle, Toad, SQL, PL/SQL

Responsibilities:

• Developed the complete PL-SQL package ETL package.
• Worked closely with the client-site lead in identifying and defining the various business views.
• Laid out the entire data dictionary for the project and summary data quality audit processes.
• Designed and implemented a complex Framework manager model and reports of varying complexity.

Confidential, Detroit, MI

Cognos ReportNet, Cognos Impromptu Series 7, Framework Manger

Responsibilities:

• Designed and developed a highly complex Operational Reports and audit reports on daily operational statistics.
• Worked as the Cognos Admin in maintaining the Cognos, UNIX and Web-Servers for Dev, QA and Production.
• Carried out pre-sales work and presentation to the client in migration to Cognos 8 BI Suite.
• Planned migration from Cognos ReportNet 1.1 to Cognos 8 BI Suite.

Confidential

Cognos ReportNet, Framework Manger, Report Studio, Query Studio

Responsibilities:

• Report Functional and Technical specification in ‘Default Rate Analysis’ and ‘Asset Correlation’ modules.
• Designed and developed several reports in Phase II (Default Rate Analysis) of the project.
• Worked on Functional Specification of the Product Cost Analysis module in phase III.
• Worked on design and documentation of complicated financial framework manager models.

Confidential

Cognos ReportNet, Framework Manger

Responsibilities:

• People: Hosted an event ‘Cognos Antarvarsha’ involving Customers, Associates and Technology.
• Product: Set up the complete environment for the unit consisting of Oracle resources, Cognos Impromptu, Cognos Powerplay and Cognos ReportNet.
• Process: Tech support to several engagements including Standard Chartered, GSK and Confidential .
• Proliferation: Trained a number of associates from varying geographies in Cognos ReportNet.
• Patent: Successful ‘PoC’ on internal resource allocation, reporting and analysis in Cognos Powerplay 7.3.