SUMMARY:

• Results - driven hands on business intelligence professional with 15+ years of experience planning, defining, developing and managing the implementaion of value-driven business solutions.
• Interfaced extensively with business stakeholders to analyze needs, define strategy, solve complex issues, and build effective solutions to increase overall visibility of critical data for enhanced decision-making.
• Extensive experience in the design and development of reporting and analytical solutions for large enterprise data warehouses.
• Strong understanding of dimensional modeling of star schemas and snowflake schemas for building enterprise data warehouses.
• Skilled in leading teams in the successful delivery of design, rewrite, tuning, upgrade and problem resolution projects that have improved performance, increased visibility of data and supported business growth.
• Extensive hands on experience with BI tools - IBM Cognos Suite, OBIEE, Microstrategy Mobile and Visualisation tools - Tableau and Qlikview.
• Extensive experience with Oracle, Teradata and MS SQL Server databases.
• Accountable for overall success of projects from capture of requirements through on-time and quality delivery.
• Demonstrated excellent project management skillls in the implemention of BI projects.
• Extraordinary analytical and problem solving skills.
• Exceptional Leadership and management, strategic planner and team player.
• Highly motivated and results driven.

TECHNOLOGY ENVIRONMENTS:

Cognos 10.1, Microstrategy & OBIEE Business Intelligence Reporting tools

Qlikview and Tableau visualization tools

Oracle 11g, Teradata 10.1 and MS SQL Server Databases / Data Warehouse

Informatica and Oracle ODI ETL tools

Windows, UNIX & Windows Operating System Environments

Big Data Knowledge

PROFESSIONAL EXPERIENCE:

Confidential, New York

Technical BI Manager

Responsibilities:

• Designed, developed and managed the Cognos reporting environment for both Ecommerce and Full line business of Confidential Inc from both Oracle and Teradata databases.
• Worked extensively on creating models using Framework Manager and publishing packages for reporting.
• Interfaced with users to analyze and gather requirements and translated them into technical requirements and reporting solutions.
• Designed and developed Confidential .com sales returns and transfer to store reporting project. Validated data on the Cognos report against the returns data in Qlikview.
• Led the strategic Omni Channel initiative to provide consumers with the ability to purchase on-line and pick-up at store locations. Developed standard and adhoc reports in Cognos to evaluate the overall financial success of the new initiative. Interacted extensively with the database team to ensure relevant data was populated in the Data Warehouse and Data Marts.
• Directed critical initiative to provide a single view of the customer across eCommerce and store businesses. Led the design of new complex Cognos reports leveraging data from multiple data sources.
• Led the design and delivery of new Flash Sales reports using Oracle PL/SQL stored procedures and functions. Reports were automated and scheduled in Cognos. The project automated manual functions that enabled the sales team to evaluate financial success of on-line Flash sales programs.
• Developed the build out of sales reports for Off-Fifth Confidential business that eliminated manual spreadsheets and provided an effective framework for evaluating sales performance against established goals.
• Led the successful upgrade of Cognos 8.4 to latest 10.1 release with minimal disruption to business operations. Oversaw team in testing and modifying portfolio of reports to mitigate issues.
• Key contributor to the project to resolve issues with portfolio of 50+ Cognos reports for the eCommerce business that minimized processing timeframe by 90%. Worked with the architecture of creating multiple data marts that eliminated performance issues.
• Managed efforts of direct reports and coordinated efforts of internal technical resources and consultants from IBM/Deloitte for the Oracle RMS project at Confidential .
• Managed the team to develop functional specifications for reporting in OBIEE.
• Evaluated the technical feasibility of reporting solutions in OBIEE considering existing reporting requirements in Cognos.

Confidential, Woodbridge, NJ

Project Lead/Assistant Vice President

Responsibilities:

• Led the architectural design and build out of new reporting solutions in Cognos to support systems modernization efforts for this asset management firm.
• Lead architect for 3 year project to develop 100+ new reports to support the replacement of legacy system with new Global Plus Trust Accounting System.
• Designed the metadata in Cognos Framework manager models and key team member in the development of new complex reports and rewrite of existing financial reports.
• Collaborated with the Oracle database team to provide data for reporting.
• Developed PL/SQL stored procedures where needed for reporting.
• Converted functional specification to technical specifications, architected solutions, delivered status reports to leadership and business stakeholders and ensured the successful delivery of projects.
• Installed and configured Cognos 8.4 with the gateway, framework manager component, content store and creating virtual directories on the web server.
• Handled server administration and tuned the dispatcher and reporting services for optimum server performance.
• Worked extensively with user security which was defined in Cognos Series 7 LDAP integrated with Active Directory.
• User classes defined in Cognos Access Manager was mapped to user roles in Cognos Connection thereby controlling user access to folders and published content on the portal.
• Team lead in the migration of Cognos IWR reports to Cognos 8.4.
• Handled production support and responded to user queries and requests in a timely manner.
• Evaluated the Business Intelligence requirements and recommendations made to support current and future BI requirements.

Confidential, New Jersey & Virginia

Senior Consultant - Data Warehouse & Business Intelligence Solutions

Responsibilities:

• Built an impressive record of achievements designing and delivering solutions to Clients.
• Consulted with clients to provide expertise in building effective reporting framework to support growth.
• Leveraged advanced reporting techniques and problem solving skills to develop innovative solutions and optimize performance of reports and database queries.
• Provided the subject matter expertise to optimize performance of data warehouse and enhance reporting framework for Confidential Enterprises.
• Designed and implemented changes to Framework Manager models, created packages for ad-hoc reporting in Query Studio and tuned Oracle stored procedures to improve performance in data loads from legacy system to data marts.
• Led the full life cycle design, development and enhancement of ETL and reporting platform for the InterCompany Pooling(ICP) application that processed critical regulatory reports for Confidential (AIG).
• Monitored and optimized ETL jobs to ensure successful completion and availability of data for reporting.
• Designed and implemented enhancements to the data warehouse and ICP data marts.
• Modeled the ICP data mart leveraging Cognos Impromptu. Coded custom extracts and transformations utilizing Oracle stored procedures and functions extensively.
• Ensured the quality and integrity of the data in the data warehouse.
• Designed enhancements for Data Warehouse/Data Marts by providing technical infrastructure designs, while ensuring adherence to corporate standards.
• Responsible for the monthly maintenance, updates and cube refresh for Claims Financial data mart.
• Developed new and maintained portfolio of 75+ Impromptu and PowerPlay reports

Confidential, Titusville, NJ

Responsibilities:

• Developed solutions to load, validate, analyze and maintain managed Plantrak and Xponent data.
• Developed multidimensional Power cubes in Cognos Transformer to develop PowerPlay reports.
• Developed Unix Shell scripts to execute the SQL’s, which create a temporary table from which IQD’s were being generated. The IQD’s served as source files for PowerPlay Transformer.
• Developed ad hoc reports in PL/SQL and SQL for Managed Care Pull through initiative.
• Worked on deploying the PowerPlay cubes and standard reports on the web using the Cognos Server Administration tools and Web Portal Cognos Upfront.
• Developed Impromptu Web Reports for efficient ad hoc reporting.
• Mentored users on PowerPlay 6.0 and its features.
• Designed and delivered a comprehensive reporting system for Confidential ’s CARS/IS application that provided business with the means to access critical rebate,chargeback and pricing data.
• Developed Impromptu reports, leveraged Cognos macros for automation, resolved issues with production reports and upgraded catalogs and reports to Impromptu 6.0.
• Collaborated and trained users to ensure the proper execution of reports6.0.
• Created powercubes in PowerPlay Transformer 6.0 to report on sales data by manufacturing company, territory and customers.
• Optimized and resolved reporting issues.
• Enhanced performance and analysis, created a drill through cube to analyze data to the product level.
• Cube groups were also created based on the manufacturing companies so that sales data particular to the manufacturing company could be analyzed.
• Used nested categories feature of PowerPlay 6.0 and several other formatting features to create several report templates from a power cube containing data on key customers.

Confidential

Developer

Responsibilities:

• Core member of team that designed and developed new systems for clients leveraging an offshore delivery model.
• Collaborated in developing and delivering a banking system utilizing Oracle 7.1 that automated and integrated core banking functions. Developed Oracle repo