Seeking a challenging project wherein I can utilize my Business Intelligence/Data Warehousing technical skills, People Management, Project Management and business knowledge acquired over 10+ years.

PROFESSIONAL SUMMARY
• Overall 10+ years of IT experience in designing and developing Business Intelligence, Data Warehousing, Client/Server, Web applications and also as a Project Lead with exceptional exposure in diversified domain like Investment Bank, Financial, Telecom and Insurance.
• Provided Project Leadership which includes Status Reporting, Client/Project team coordination and Quality Assurance
• Involved in Planning, Controlling and Monitoring, and also Managing and directing the assigned project resources to meet project objectives.
• Collaborate with senior management, Project managers and onsite managers to plan business and technology initiatives. Use formal and informal networks to accomplish project objectives. Identify and resolve project issues and manage project risk.
• Captured Business requirements, produced conceptual and logical design, Lead development, coordinated onsite/offshore activities and performance reporting.
• Expertise in designing, developing and implementing Data warehouse and Business Intelligence solutions using Cognos 10, cognos 8. 4, Cognos Report net 1. 1 (Report Studio, Query Studio, Framework Manager), Cognos 7 series (Impromptu, Transformer, Power play) and Business Objects.
• Profound experience in Data modeling, BI/DW application design, implementation, installation and configuration of Cognos 8 suite of products in Windows and Linux operating systems using Oracle 10G and SQL Server 2000 as a database.
• Expertise and experience in design and development of Dashboards, Scorecards, Multidimensional Cubes, Dimensional & Relational Models and advance reports using html and java scripting, Charts and Maps.
• Profound knowledge and experience in SDLC and Project Management Process.
• Ability to manage work relationship through motivation, delegation, supervision, team building and conflict ***** CATION
• Bachelor of Computer Application.
• Diploma in Computer Technology

TECHNICAL SKILLS
Data Warehouse and Business Intelligence Tools:
o Cognos 10. 0. 1/ 8. 4 / 8. 3 (Framework Manager, Report Report Studio, Business Insight, Query Studio, Event, Metric and
Analysis Studio)
o Cognos Go Office/Go Mobile
o Cognos 7 Series (Impromptu, Transformer, Power
Play Cubes)
o Business Object XI, Pentaho
o Informatica Operating Systems:
o Windows NT, XP, 2000, 2003
o Unix, Linux
o Sun Solaris 2. 8
Application Server:
o IIS 5. 0, 6. 0, Apache
o Web logic
o Tomcat
Programming Languages:
C, Java, Visual Basic
Modeling Tools:
o ERWIN 4. 0, Cognos Framework Modelling
o Star and Snowflake Schema
Configuration & Issue Management:
Clearcase, Visual SourceSafe Applications:
o MS Office, Visio
Database:
o Oracle 10G, SQL Server 2000/2005

Project Engagements:

JP Morgan Chase, Mumbai, India (Feb-2011 to May-2012)
View Portfolio Reporting

Environment: Cognos 8. 4, Framework Manager, Report/Query Studio, Oracle 11 G, Tomcat and IIS.
Responsibilities:
 Involved in design, development and implementation of “Data warehouse” solutions.
 Plan and schedule project timelines and milestones using appropriate tools.
 Track project milestones and deliverables.
 Coach, mentor, motivate and supervise project team members.
 Build, develop, and grow any business relationships vital to the success of the project.
 Report to the supervisor periodically on team and ***** work accomplishments, problems, progress in mastering tasks and work processes, and ***** and team training needs.
 Gather business and functional requirements, feasibility study, Estimate time, design, develop and implement Business Intelligence solutions.
 Took End to End ownership of developing reports from analyzing the specification till production.
 Designed and Developed data models using Cognos Framework Manager.
 Designing and Developing advance reports based on request.
 Coordinated with Onsite team and ensured all the Data warehouse work products are developed with high quality.
 Worked closely with the business to resolve the production issues on time.



Merrill Lynch-Bank of America, Mumbai, India (May 2007 to Jan 2011)
Portfolio Margin Reports

Environment: Cognos 8. 2, Framework Manager, Report/Query Studio, Oracle 10 G, Tomcat and IIS.
Responsibilities:
 Involved in design, development and implementation of “Data warehouse” solutions.
 Plan and schedule project timelines and milestones using appropriate tools.
 Track project milestones and deliverables.
 Coach, mentor, motivate and supervise project team members.
 Build, develop, and grow any business relationships vital to the success of the project.
 Intercede with the supervisor on behalf of the team to inform the supervisor of performance management issues/problems and to recommend/request related actions, such as assignments, reassignments and Peer reviews.
 Prepare reports and maintain records of work accomplishments and administrative information, as required, and coordinate the preparation, presentation, and communication of work-related information to the supervisor.
 Took End to End ownership of this project from requirement gathering till production.
 Gather business and functional requirements, feasibility study, Estimate time, design, develop and implement Business Intelligence solutions.
 Involved in design, development and implementation of “Data warehouse” solutions
 Coordinate with Onsite team and ensure all the Data warehouse work products are developed with high quality.
 Designing and Developing advance reports based on request
 Designed and Developed Data models using Cognos Framework Manager




Merrill Lynch-Bank of America, Mumbai, India
Client Reporting Center

Environment: Cognos 8. 2, Framework Manager, Report/Query Studio, Oracle 10 G, Tomcat and IIS.
Responsibilities:
 Involved in design, development and implementation of “Data warehouse” solutions.
 Plan and schedule project timelines and milestones using appropriate tools.
 Track project milestones and deliverables.
 Coach, mentor, motivate and supervise project team members.
 Build, develop, and grow any business relationships vital to the success of the project.
 Gather business and functional requirements, feasibility study, Estimate time, design, develop and implement Business Intelligence solutions.
 Prepare reports and maintain records of work accomplishments and administrative information, as required, and coordinate the preparation, presentation, and communication of work-related information to the supervisor.
 Involved in design, development and implementation of “Data warehouse” solution.
 Coordinate with Onsite team and ensure all the Data warehouse work products are developed with high quality.
 Designed and Developed Data models using Cognos Framework Manager
 Providing solution to improve the performance of a report both at report as well as at Database level
 Modifying the existing Framework manager as per the new requirements
 Designing and Developing advance reports using HTML and Java scripts.


Chenoa Information and Services
Client-Employers Direct Insurance Company, California (Nov2005- May2007)
Management Activity Reports

Environment: Cognos 8. 2, Framework Manager, Report/Query Studio, Oracle 10 G, Tomcat, IIS, Web Logic, Web Sphere.
Responsibilities:
 Involved in design, development and implementation of “Data warehouse” solutions.
 Effectively communicate project expectations to team members and stakeholders in a timely and clear fashion.
 Plan and schedule project timelines and milestones using appropriate tools.
 Track project milestones and deliverables.
 Coach, mentor, motivate and supervise project team members.
 Estimate the resources and participants needed to achieve project goals.
 Build, develop, and grow any business relationships vital to the success of the project.
 Direct and manage project development from beginning to end.
 Gather business and functional requirements, feasibility study, Estimate time, design, develop and implement Business Intelligence solutions.
 Designed and developed a model in framework manager as per the business
 Created different layers in framework manager for ad-hoc reporting.
 Design, Develop and document Database schema.
 Prepared column mapping document and migrate existing SQL’s to new tables.
 Coordinate with onsite team and ensure all the Data warehouse work products are developed with high quality.
 Verify, validate and ensure data mart and data warehouse solutions and also make sure all the newly sourced tables are in sync with the external database.

Chenoa Information and Services
Client: Employers Direct Insurance Company, California
Claims Activity Reports

Environment: Cognos 8. 2, Framework Manager, Report/Query Studio, Oracle 10 G, Tomcat, IIS, Web Logic, Web Sphere.
Responsibilities:
 Direct and manage project development from beginning to end.
 Gather business and functional requirements, feasibility study, estimated time, designed, developed and implemented Business Intelligence solutions.
 Designed, Developed and documented Database schema.
 Involved in design, development and implementation of “Data warehouse” solutions
 Coordinate with Onsite team and ensure all the Data warehouse work products are developed with high quality.
 Documented user guide and trained business users about “Report Studio” and “Query Studio” for creating adhoc reports.

Chenoa Information and Services
Client: Employers Direct Insurance Company, California
Pricing-Underwriting
Environment: Cognos 8. 2, Framework Manager, Report/Query Studio, Oracle 10 G, Tomcat, IIS, Web Logic, Web Sphere.
Responsibilities:
 Involved in design, development and implementation of “Data warehouse” solutions.
 Plan and schedule project timelines and milestones using appropriate tools.
 Track project milestones and deliverables.
 Coach, mentor, motivate and supervise project team members.
 Build, develop, and grow any business relationships vital to the success of the project.
 Gather business and functional requirements, feasibility study, estimated time, designed, developed and implemented Business Intelligence solutions.
 Designed, Developed and documented Database schema.
 Designed and developed Relational/Dimensional Modeling for Pricing Application.
 Integrated Cognos 8. 2 reports with java application.

Chenoa Information and Services
Client: Employers Direct Insurance Company, California
Policy holder Claims and Information Center
Environment: Cognos 8. 2, Framework Manager, Report/Query Studio, Oracle 10 G, Tomcat, IIS, WebLogic, WebSphere.
Responsibilities:
 Gathered business and functional requirements, feasibility study, time estimation and automated deployment process of the business intelligence solution using Cognos 8. 2. Involved in training end users and product managers in Report and Query Studio.
 Setup development environment and configured Cognos.
 Designed and Developed Dimensional/Relational models using Cognos Framework Manager.
 Created standard calculations, enumeration translations and filters using Framework Manager. Modeled base class virtual and ambiguous relationships. Worked extensively on performance fine-tuning of SQL queries using TOAD.
 Designed and developed reports using list, charts, dynamic/custom sorting, dynamic grouping, conditional formatting/nested cross tabs, graphical, and drill through.
 Assisted in deploying the Cognos ReportNet Reports through their eReporting Portal using URL calls to dispatcher and also used SDK for certain functionalities.