SUMMARY:

• 8+ years of excellent Industry experience in Operational, Analytical and Data - warehousing projects.
• Experienced in Securities, Credit Risk, Confidential, Surety Bonds, Re-Insurance, Consumer Banking, and CRM.
• Worked with prestigious clients: World Bank, General Motors, Confidential Bank/ Confidential Group, Confidential, Confidential, Bloomberg.
• Extensive development experience with Report Studio, Business Insight, Business Insight Advanced, Query Studio, Analysis Studio, Event Studio, Powerplay Transformer in Cognos 10.1.1/10.1 , Cognos 8.x and Cognos ReportNet.
• Extensive Data Modeling experience in Framework Manager. Experienced in Star and Snow-flake models and DMR models, complicated financial models, re-usable components, macros, model-based security and Packages.
• Experienced as Solutions Architect, Data Architect, Data Modeler, Reports Design, Development and Automation.
• Experienced in design and development of Cognos Powerplay Tranformer Cube models and MOLAP design.
• Experience in design and development of Dashboards, Scorecards, ROLAP and other Data Visualization artifacts.
• Familiar with Access Manager implementations - users, groups, roles, classes and security.
• Cognos Administration expertise: Security using LDAP, Content Administration and Deployment Export/Import
• Experienced in Migration Planning: Cognos ReportNet to Cognos 8, Migration execution: Crystal to Cognos.
• IBM Cognos certified professional.
• Experienced in working with ETL architecture in huge data mart designs and engagements.
• Experienced with complex ETL processes in PL/SQL for Operational Data Mart systems.
• Experienced in stored procedures in DB2 and Oracle and PL/SQL/Packages development with Ref-Cursors.
• Experienced in SLA bound delivery, Data Quality Audit processes and Data Governance processes.
• Performed SME role for two critical applications: Dealerization - the process of assignment of leads to dealers; Presentation - the process of calculated De-Normalization of operational data for Ad-hoc reporting for end users.
• Experienced in Project Management (Offshore/Onsite model), Agile methodology and other SDLC methods.
• Pre-sales experience in tool capabilities presentation and Proof of concepts (PoC).
• Worked on an end-to-end Data mart engagement from conceptualization, pre-sales, design, functional and data mapping development, UAT, deployment and delivery including ETL code in oracle, Framework model and reports.
• Business Analyst/Data Analyst experience in Credit Risk, Banking &Finance, Re-insurance, Manufacturing and Confidential systems. Experienced in documentation and analysis of requirements in FRD/BRD and User Experience based design.
• Experienced in Performance testing, Load testing, benchmarking and SQL Performance tuning,.
• Experienced in Competency building, technical event hosting and Technology training and material.

SKILL SET:

BI Tools: Cognos 10.x, 8.x, Series 7 BI - Report Studio, Analysis Studio, Business Insight, Business Insight Advanced, Event Studio, Query Studio, Framework Manager, Cognos ReportNet, Powerplay Tranformer, Access Manager, Metrics Studio, Impromptu, Oracle Discoverer

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

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

WORK EXPERIENCE:

Confidential, New York, NY

Framework Manger

Responsibilities:

• Currently working on the major initiative of upgrading from Cognos 8 to Cognos 10.
• Working with a large business team in enhancement and issue fixes of custom client reports in Cognos 8.
• Worked on various issues with the Framework manager model impeding standardization and upgrade to 10.2
• Migrated a large suite of custom client report packages from stored procs to standalone Cognos reports.
• Worked on standardization tasks including formatting templates using classes and re-usable components.

Confidential, Weehawken, NJ

Framework Manger

Responsibilities:

• Working on the solution architecture and development in Report Studio and customization with JavaScript
• Leading the team in development of the large number of reports including tabbed dashboards in Report Studio.
• Created template, conditional formatting, complex layouts and query designs for complex Report Studio reports.
• Working on completion of Cognos FM model completion in Framework Manager for various Business Areas.
• Worked with Consensus Vendor organization in automated conversion of Discoverer meta-data to Cognos.
• Analyzed Discoverer meta-data and reports in understanding the implementation and identifying challenges.
• Designed security architecture with the client-side technical team and application methodology in Cognos.

Confidential, Warren, NJ

Framework Manger

Responsibilities:

• Worked as the reporting solutions architect and lead developer.
• Developed Cognos 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 model with determinants and parameter maps.
• 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

Framework Manger

Responsibilities:

• Worked in the capacity of Solution Architect while transforming CYBORG model to PeopleSoft model.
• Designed the physical reporting Data Mart from scratch to cater to the complex technical requirements.
• Developed an entirely new Data-Mart model in Framework Manager, with highly complex reporting approaches in three different contexts - Daily, Current, Historical, As of Date and Range - out of 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 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.

Confidential, Jersey City, NJ

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.
• 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

Framework Manger

Responsibilities:

• Worked with dedicated team in developing a pilot module on Confidential 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.

Team Lead, Senior Developer

Confidential, Irving, TX

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.

Team Lead, Senior Developer

Confidential, Irving, TX

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.

Senior Developer, Business Analyst

Confidential, Irving, TX

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 defintions, 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.

Team Lead, Coordinator

Confidential, Irving, TX

Responsibilities:

• Involved in the migration planning activity with the team and Confidential 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 Confidential cubes with Confidential Access Manager data-sources.