SUMMARY:

• IT professional with 12 years of experience including 10 years of Business Intelligence & Data Warehouse
• Managed and Executed all the phases of a project life cycle during the tenure that includes Scoping Study, Requirements Gathering, Architecting, Design, Development, Implementation, Quality Assurance, Application Support for end - to-end IT solution offerings in Data Warehousing, OLAP & BI space
• Expertise in Operational, Financial and HR data analysis and reporting analytics
• Excellent problem solving and expertise in providing basic to complex BI solutions using suite of Cognos (
• Series7, Cognos8 and Cognos10 including Framework Manager, Administration, Report Studio, Query Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, EP Planning and SDK), HTML and Java Scripts, Business Objects products, Qlikview, CGI Perl, SSIS and Informatica PowerCenter/PowerMart.
• Successful track of various software upgrade and migration plans including Cognos Series 7 migration to ReporNet, CRN to Cognos 8.3, upgrade to 8.4 and Cognos 10 migration.
• Installation, configuration, and administration of CRN, Cognos 8.4 and Cognos 10 in multi-tier production,
• VM WARE, Windows 2003 environments
• Extensive database experience and highly proficient in Oracle PL/SQL, Transact SQL including writing queries, stored procedures, functions and triggers
• Thorough knowledge of Ralph Kimball's Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Slowly Changing Dimensions (Type1, Type2, and Type3) and Surrogate keys
• Expertise includes Data Analysis, Data Modeling, Data Cleansing, Transformation and Integration
• Experienced in using modeling tools such as CA ERwin, MS Visio, and ER/Studio XE (Embarcadero)
• Liaison between business, development, infrastructure and support teams
• Responsible for retention (development and growth) and recruiting staff
• Mentor, teach, and have created a variety of pieces of a development methodology
• Manage team by ensuring that projects tasks are in line with each innovator’s career interests when possible
• Ability to implement various SDLC methodologies (WaterFall, Spiral, RAD, LD, Agile, Build and Fix) and combine to come up with a Hybrid model to maximize client satisfaction based on the requirement, time & resource constraints

TECHNICAL SKILLS:

SKILLS: Project Management, System Analysis, BI Architect, Data Modeling, Function Analysis, Strategic ThinkingProgramming: (Visual Basic, Java, ASP .NET, ASP, UNIX, Shell, Perl, PL/SQL, Transact SQL, HTML, DHTML, XML,JavaScript), Oracle, Sybase, SQL Server, DB2, Rapid SQL, Data Studio, Toad, DB Artisan, MS Project, Excel, Visio,ERWIN, BI suites Cognos 7.x, 8.x & 10, Cognos SDK, Business Objects, Qlikview, JFree Reports, Essbase, Informatica, Data manager, SSIS, CRM applications Siebel, Pivotal and TickR, IIS Web Server, Apache, Netscape, Sun One, LDAP servers. CVS, Visual Source Safe, Remedy CMP (Change Management Process).

WORK EXPERIENCE:

Confidential, NYC

VP,BI Manger/Architect

Responsibilities:

• Equity and Fixed Income business management the ability to view every dollar of revenue and every share executed over multiple criteria to better gauge, understand, and manage each individual line of business (cash, electronic trading, derivatives, fi, and wm) on a daily basis
• The ability to gauge individual customer profitability by providing a single view of revenue (Commissions) alongside associated expenses and charges (Soft Dollar Credits, Trading P&L, etc…)
• The ability to gauge business and associated revenues on a daily, monthly, yearly basis for the Individual producers (Account Executives, Sales Traders)
• Define, Architect and Develop Confidential Equity Revenue Mart, Equity & Fixed Income Payout Systems, Global Reporting Platform to support domestic and international business. Built reconciliations to address issues.
• Installed, Configured and Administered Cognos platform on dev, qa and prod on distributed environments
• Built robust BI infrastructure providing a central repository of over 200 pre-constructed producer and management reports, dashboards, as well as over 4 dozen additional with interactive query, drill through capabilities and PowerPlay Cubes using ReportNet, Cognos 8 & 10
• Successfully migrated Cognos application from ReportNet - Cognos 8 - Cognos10 including FM models and 400 + reports /dash boards/leader board screens.
• Designed and implemented various levels of Security using Access Manager on LDAP from the ground up.
• Built DMR and OLAP Models and designed reports against those models
• Trained power users and the team on Query Studio, Business Insight and Business Insight Advance (BIA) tools
• Implemented standards on developing fm models, reports and the customization of the portal
• Created Jobs, Schedules and automated the batch process using Congos SDK
• Extensively involved in vendor, product and people management
• Monitor BI usage capture and maintenance of metrics

Consultant

Confidential, Thousand Oaks, CA

Responsibilities:

• Lead, and participate in teams of IT Consultants (business and technical system analysts), developers, and system engineers during the implementation of order management, analytical, business intelligence, and financial information systems at customer sites.
• Performed complete end-to-end requirements gathering and analysis that yielded detailed functional and technical specification documents.
• As a liaison between stake holders, technical groups, business units, internal development and support groups consistently gained both respect and trust
• Analyzed and implemented all integration points between custom & core software modules and interfaces
• Instrumental in quality and on time QA and integration testing efforts
• Consistently played hands on technical role during all phases
• Delivered both small and large-scale technical product and custom business to clients
• Successfully managed multiple projects during the entire Software Development Lifecycle, via detailed project planning and tracking, management of client relationship at all strategic levels, budgeting & resource mgmt
• Establish and enforce technical standards for deliverables of projects rticulate the business value of information usage and audit usage, performance metrics and
• Develop and manage the BI dependency plan, job scheduling and cycle management
• Determine and ensure execution of backup, recovery and archival strategy
• Continue to investigate and evaluate emerging BI technologies
• Define and get agreement with support and IT operations personnel on service level agreements
• Find and confirm corporate goals and Identify business metrics related to goals
• Relate business drivers to corporate goals and to functional goals
• Develop and maintain BI strategy to ensure that the BI Roadmap aligns with the corporate goals
• Decision Support Designer/ Developer / Report Writer/ Trainer and Administration Responsibilities
• Data analysis and providing continues feedback to data mart teams
• Designing / developing/ maintaining metadata models using Cognos Framework Manager by implementing standard recommended procedures, methods and functionality
• Developing various kinds of complex and simple reports using ReportStudio, QueryStudio, Impromptu, Power Play, Visualizer and Metrics Manager Converting PL SQL/ Crystal Reports, BO reports to Cognos Reports and
• Query and Report Optimization Developing prompt pages and conditional variables.
• Designing/Publishing/Updating user’s home page using Cognos connection and SDK
• Designed models by mapping business needs using PowerPlay Transformer and created multi dimensional cubes, cube groups, and reports. Decreased the Cube build times drastically and improved runtime performance.
• Created Reports (Simple & Complex), Matrix using QueryStudio and ReportStudio for purpose
• Implemented Qlikview reporting and Enterprise Planning for Product Control and Accounting depts
• Involved in strategic planning for Cognos RNet, 8.x architecture and setting up various Cognos environments and the configurations
• Mapping Cognos Series 7 users to the Cognos user groups and setting up different levels of security
• Scheduling and distributing reports by creating Jobs through schedule management and SDK
• Trained
• Modelers to use FM to develop metadata models and publishing packages to ReportNet Server,
• Prof Authors to write complex reports using tables, variables, along with other advanced techniques
• Power Users to use Query Studio, Analysis Studio, Business Insight Advanced for Ad-hoc reporting