SUMMARY

• A senior IT Professional with over 15 years of multi - faceted technical experience on UNIX and Windows platforms.
• Providing technical leadership in design, development, and implementation support in Data Warehousing, Business Intelligence, Business Process Engineering and Re-Engineering, ETL, etc...
• Delivers the best-of-breed IT solutions to the world leading organizations within the financial, manufacturing, education, telecommunications, and healthcare industries, as well as the Aerospace & Defense and the Federal Government.
• Works closely with business users, technology managers, offshore developers, and external vendors.
• Excellent ability to work independently and in all phases of the project development lifecycle.
• Excellent ability to manage project deliverables, timeline, and allocate resources.
• Proven track record for delivering state-of-the-art technology solutions on time and within budget.
• Strong expertise in Business Intelligence and Data Warehousing.
• Strong expertise in providing technical leadership and architecting IT solutions.

PROFESSIONAL EXPERIENCE

Confidential - Buffalo, NY

Solutions Architect / ETL Architect

Responsibilities:

• Team Lead responsible for all ETL strategy design, mapping design for the Enterprise Data Warehouse and MDM.
• In the process of redesigning the entire CCAR data mart for enhancement and performance.
• Responsible for all code reviews, technical reviews, and first level quality check before the data is released to the MDM team and Data Analysts.
• Implemented a much improved data loading architecture for the MDM project, thus reducing the complexity, failure points, and development efforts.
• Responsible for managing the on-shore and off-shore teams to ensure the soundest solution is implemented.
• Responsible for managing all resources to ensure timely delivery of tasks/projects based on the project timeline.

Confidential - Buffalo, NY

Data Warehouse Architect

Responsibilities:

• Redesigned IH Enterprise Data Warehouse, thus improving data quality, reliability, and performance.
• Introduced a much simpler Data Warehouse architecture and made it easier for business reporting and querying.
• Architected one of the client’s most successful solutions to track fraud and subscribers’ transfers and data anomalies by redesigning the entire data architecture to eliminate defects and improve accuracy and efficiency.
• Successfully redesigned and implemented the company’s Brokers’ Commissions Payment & Tracking System and resolved all previous defects. Thus, eliminating payments delays to brokers and accounting errors.
• Managed all projects deliverables and ensuring timely and successful completion of stories and tasks in an Agile Methodology environment.
• Created all project documentation including technical design documents and Statements of Operating Procedure.

Confidential - Palo Alto, CA

Oracle Business Intelligence Architect / Technical Lead

Responsibilities:

• Technical Lead roles on Oracle Business Intelligence, ETL, Information Management & Analytics projects.
• Designed and implemented robust Data Warehouse and BI Architectures and Security strategies for major corporations.
• Implemented clustered Oracle BI environments for high availability and load balancing.
• Implemented a security strategy allowing the enterprise Active Directory users to access OBIEE with their existing network accounts.
• Interfaced directly with stakeholders and upper management to deliver the solution to the exact specifications.
• Provided a strong expertise and guidance during the design, development, testing, and deployment phases to on-shore and off-shore developers.
• Delivered a strong expertise in the design, development of the RPD as well as reports and interactive dashboards.
• Identified project deliverables and allocate resources as well as conduct all technical meetings to ensure that deadlines are met and high standard of quality is delivered to the client.
• Responsible for providing detailed technical design and development process of various solutions to corporate clients around the globe based on their IT needs.
• Provided technical leadership on migrations and application upgrades.
• Simultaneously worked on and managed multiple projects.

Confidential - Long Island, NY

Business Intelligence Architect / Data Warehouse Engineer

Responsibilities:

• Project lead responsible and accountable for the coordinated design, development, and management of multiple Business Intelligence projects related to Oracle Business Intelligence Applications previously known as Fusion Intelligence (Finance, Supply Chain, Manufacturing, Human Resources, Sales, Marketing, etc…).
• De-normalized the OBIEE source tables for General Ledger and Account Receivables source systems.
• Based on the new business requirements, redesigned and remodeled Teradata source tables structure in order to facilitate BI and reporting. Thus, significantly improving data retrieval performance.
• Designed, implemented, and managed a well-architected and clustered BI environment for the worldwide reporting and analytics needs.
• Delivered very robust and popular BI solutions used in all worldwide divisions.
• Architected, implemented, customized, and administered the EBS and OBIEE security integration and EBS responsibilities setup and management.
• Deployed, customized, and managed all Fusion Intelligence (Oracle BI Application) objects.
• Designed, developed, and maintained all OBIEE web catalogs and repositories (RPD).
• Designed and developed all BI reports and interactive dashboards, and responsible for all migration, and maintenance of OBIEE objects in BI Answers.
• Coordinated all development efforts between the offshore and US developers.
• Was responsible for tracking all BI development efforts, resources, project timeline and deliverables, as well as ensuring the quality standard of the company is fully met.
• Provided technical expertise to the North American, European, Australian-New Zealand, and Asian divisions in the delivery of reliable and accurate data used in making sound business decisions.

Confidential

Data Warehouse Architect (Senior Principal Consultant)

Responsibilities:

• Technical lead who designed, developed, and implemented highly performing Oracle Data Warehouse and Business Intelligence environments while following the standard Oracle Software Development Lifecycle.
• Led the design, development, and deployment phases of several data cleansing, conversion, and integration projects.
• A lead member of the “SWAT Team” that was responsible for handling critical status assignments by identifying the problems, removing all the obstacles, then resolved the issues as per the client’s specifications, which led to millions of dollars in savings for both the clients and Oracle.
• Developed and deployed Oracle Business Intelligence Enterprise Edition (OBIEE) and PeopleSoft EPM (Enterprise Performance Management) Data Warehouses and applications.
• Designed and developed solutions around Oracle HCM, Financial, and Supply Chain applications
• Designed and Developed efficient ETL maps using major ETL tools (Oracle Warehouse Builder, IBM | Ascential DataStage, Informatica PowerCenter), thus building a strong expertise with the industry’s best and most popular ETL tools, OS platforms, and hardware.
• Successfully completed activities requiring high level of expertise such data Conversion/Integration and all related activities (data cleansing, scrubbing, massaging, etc.) in very competitive environments.
• Led small and highly effective teams of developers (2 to 6 developers) within larger projects.
• Provided users with information sharing (knowledge transfer) and technical training sessions.
• Developed functional and technical documentation.

Confidential - New York, NY

Information Warehouse Applications Developer

Responsibilities:

• Designed, developed, deployed, and maintained Business Intelligence/OLAP tools, SAS, and Warehouse applications for analytic use against the JPMC Data Warehouse (30+ terabytes of data) while following the Application/Software Development Life Cycle.
• Successfully migrated the entire Business Intelligence and SAS user community from IBM S80 and Silver nodes to the new IBM flagship hardware (Regatta - p690) on time, on schedule, and within budget.
• Developed Business Intelligence and SAS applications for the JPMC One-Desk initiative to define a common corporate desktop build and interface.
• Provided high level technical support for the Business Support Center and the 300+ users in CCS.
• Supported all Warehouse applications (Cognos, SAS, etc.) and activities related to software upgrades, maintenance releases, and system changes.
• Documented all application development, deployment, testing, and training Procedures.