Data-warehouse Architect Resume
Boca Raton, FL
SUMMARY:
Respected senior data warehouse architect with almost two decades of multi - industry experience. Accomplished Data Warehouse architect and implementation specialist with a history of superior performance. Successful leader of full life cycle projects involving Enterprise Application Development through Business Intelligence. Skilled in Informatica, Trillium, Oracle, Embarcadero, Business Objects, OBIEE, Informatica cloud, Sales Force and Big Data. Certified Business Intelligence Professional (CBIP) from TDWI.
AREAS OF EXPERTISE:
- Architect Design
- Architect Development
- BI/DW Solutions
- Informatica Cloud & SalesForce
- Customer Data Integration
- Data Quality
- Data Governance
- Big Data
- Metadata managment
- Self-Service BI
- Master Data Management
- ETL
KEY SKILLS ASSESSMENT:
ETL & BI: Informatica, Syncsort DMExpress, Trillium Data Quality, Business Objects, Crystal reports, Oracle Reports, OBIEE, Big Data
Cloud Technologies: Informatica Cloud, Salesforce CRM
ERP: Oracle E-Business Suite
Databases: Oracle, SQLServer, Sybase and Informix
Scripting: Unix Shell Scripts, Windows Batch Scripts, PERL
Languages: Java, ASP, Oracle Webserver(PLSQL Cartridges), Oracle Forms, Visual Basic, C, Pro*C, PERL
Tools: Embarcadero, Erwin, Oracle Designer, JBuilder, JDeveloper, Visual Source Safe, Toad, SQL Navigator, Autosys, Control-M
PROFESSIONAL EXPERIENCE:
Confidential, Boca Raton, FL
Data-warehouse Architect
Technical Environment: Informatica, Trillium, Oracle, Unix Shell scripting, Business Objects, Embarcadero, Toad, OBIEE, Informatica Cloud, Sales Force, Big Data.
Responsibilities:
- Project estimates, time line, resource and budget planning as well as vendor selection and vendor management.
- Key contributor to solution architecture, architecture and design of future state applications and business transformation for order to cash program enterprise wide.
- Key contributor to architecture, strategy, implementation and support of Data Integration, Business Intelligence, Master Data Management strategy and Performance Management Solutions to business users across North America.
- Key role in development of BI strategy and roadmap, BIDW methodology, BI Artifacts, BI/DW architecture standards. Re-architecture of Datawarehouse platform using BI reference architecture as well as Kimball and Inmon methodologies.
- ETL and DB environment architecture, design, development for implementation of BI solutions. Architected and executed the upgrade of BI/DW environment on time and very low budget. Administration of Informatica and Trillium environments.
- ETL Code review for enforcement of ETL standards. Process optimization of BI/DW ETL processes.
- Coordination with onsite and offshore teams for successful implementation.
- Architecture, design and implementation of ETL and Data quality solution for customer data integration to identify and resolve exceptions between Billing and Service delivery applications.
Confidential, Boca Raton, FL
ETL Lead
Technical Environment: Informatica, Oracle, Unix Shell scripting, PERL, Informix, C, Bugzilla, Control-M, DMExpress, Syncsort
Responsibilities:
- Steered and facilitated Requirements Analysis sessions with business groups. Project proposals, estimates and resource planning.
- Developed Technical requirements document. Data modeling, system data analysis, design and database creation.
- Lead Technical design and development for ETL for large data warehouse.
- Review Technical Design Document and Test Plans with the technical board.
- Coordinate Onsite and Offsite development with development teams as well as coordinate system and integration testing with QA teams onsite and offsite.
- Develop production run books and best practices. Production deployment and KT to Production Support team.
Confidential, Miami, FL
Technical Lead
Technical Environment: Informatica, Crystal reports, Oracle, Unix Shell scripts, Windows batch scripts, PERL, SQLServer, Autosys, Java, C, Pro*C, ASP, Visual Source Safe
Responsibilities:
- Participate in JAD sessions with business analysts, clients.
- Coordinate and participate in Technical architecture sessions for ETL and CRM products.
- Develop and review Technical Design documents.
- Lead technical teams onsite and offsite.
- Client interaction and user interaction for requirements, demos and training.
- Project proposals, estimates and resource planning/
- Lead ETL projects for dataloads and feeds.
- Lead Web projects as well as client server projects.
Confidential, Miami
Senior programmer Analyst
Technical Environment: C, Pro*C, Oracle, Unix Shell Scripts, Windows Batch files
Responsibilities:
- Design and development of interfaces product to interface time management and workforce CRM solutions with different ERP products.
- Successfully implemented for leading aerospace and defense clients such as Boeing, Lockheed Martin, Raytheon.
Confidential
Senior Programmer Analyst
Responsibilities:
- Development of automation software for manufacturing processes such as work order creation, purchase orders, invoices etc., for clients such as Allied Signals and Confidential .
Technical Environment: Java, Net Dynamics, HTML, Java Script and Oracle Database, PL/SQL
Confidential
Software Engineer
Technical Environment: C, Pro*C, Oracle, Forms, Unix Shell scripts, Oracle Reports, Visual Basic
Responsibilities:
- Development and testing of modules such as ATM banking, anywhere banking, Trade Finance, CORBA etc., for Finnacle, banking automation product of Infosys.
- Production Planning and Control department functions that include data analysis and generation of production, sales and inventory reports.