We provide IT Staff Augmentation Services!

Senior Architect / Data Warehouse/ Bi Resume

0/5 (Submit Your Rating)

SUMMARY:

  • Results and performance - driven with strong technical leadership and the ability to provide robust data analytic solutions.
  • With over 45 successful enterprise implementations of business intelligence platforms specializing in Massive Parallel Processing with massive datasets.
  • Bringing real-life experiences in architecting, developing, implementing, administrating, designing, modeling and development of Business Data exploration platforms.
  • Along with understanding the complexity of working with multiple levels of IT, Back Office and Sales Professional local and around the world.
  • Highly motivated and skilled in understanding and coupling the correct solution, to the client s environment to maximize the overall positive impact.
  • One of the latest examples is a project which realized savings of over 100+ million dollars and created several new revenue streams for the client.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Architect / Data warehouse/ BI

Responsibilities:

  • Created new architecture for new AFS Contract and Compensation system.
  • Adopting agile methods created prototype using end user requirements.
  • Conducted and participated in the selection process to choose the technologies for the EDW system.
  • Architected the deployment of Confidential BI and Confidential TM1
  • Architected the ETL process to handle large number of date snippets.
  • Development of Star and Snowflake schemas.
  • Deployed new Confidential Cluster system to handle large amount of data and users.
  • Architected the deployment of Confidential Studios (Report Studio, Query Studio, Metric Studio and workspace advanced).
  • Conducted test to identify how Confidential will behave when using very large databases.
  • Participated in the creation of best practices for AFS development team.
  • Provided Best practices for administering the Confidential BI system.
  • Participated in identifying new Confidential team members

Technologies:ER/WIN, MS SQL Server, Confidential BI 10.1.1, Confidential Powerplay, Confidential Query Studio, Confidential TM1 10.1.1

Confidential

Senior Architect / Data warehouse/ BI

Responsibilities:

  • Lead team to understand user requirements (C-Level).
  • Adopting agile methods created prototype using end user requirements.
  • Conducted and participated in the selection process to choose the technologies for the EDW system.
  • Conducted an evaluation between Confidential and Teradata
  • Architected the ETL process to handle very large amounts of data. 2.4 TB nightly
  • Development of Star and Snowflake schemas.
  • Deployed new Confidential Cluster system to handle large amount of data and users.
  • Architected the deployment of Confidential Studios (Report Studio, Query Studio, Metric Studio and workspace advanced).
  • Conducted test to identify how Confidential will behave when using very large databases.
  • Participated in the creation of best practices for the Sumitomo development team.
  • Provided Best practices for administering the Confidential cluster system.
  • Participated in identifying new Confidential team members
  • Provided a gap analysis to identify needs for the new in-house EDW team.

Technologies:ER/WIN, MS SQL Server, Confidential BI 8, Confidential Powerplay, Confidential Query Studio, Datastage, MVS DB2, Confidential, Oracle Exadata, SAP BW, SAP ECC, Db2 400.

Confidential

Senior Architect / Data warehouse/ BI

Responsibilities:

  • Designed and Architected (ETL) architectures for several clients
  • Using Confidential, I reviewed and approved several implementation plans
  • Confidential Reportnet Development, Power play Cubes
  • Developed Sample reports and ETL processes.
  • Development of Star and Snowflake schemas.
  • Assisted existing deployments of Confidential to comply with best practices.
  • Conducted several proof of concepts for several verticals.
  • Conducted test to identify how Confidential will behave when using very large databases.
  • Participated in the creation of best practices blueprints.
  • Lead and follow several team members to complete the task at hand.

Technologies:ER/WIN, MS SQL Server, Confidential BI 7,8,10, Confidential Powerplay, Confidential Query Studio, Datastage, MVS DB2, Confidential, Oracle Exadata, SAP BW, SAP ECC, Db2 400.

Confidential

Senior Architect / Data warehouse/ BI

Responsibilities:

  • Architected new data flow (ETL) architecture
  • Developed new FM Model for Operational reporting.
  • Confidential Reportnet Development, Power play Cubes
  • Development of Star and Snowflake schemas.
  • Creation of Various types of Reports (Dashboards, List, crosstab, DMR, cubes)
  • Creation and deployment of KPI Dashboard for Operational management.
  • Created various ETL processes to import several data sources onto DSS for Graphical reporting. Very large database (VLDB).
  • Integration with SAP ERP and Maximo Inventory system
  • Worked with several team to complete project on time and within budget.

Technologies:ER/WIN, MS SQL Server, Confidential 7, Confidential Powerplay, Confidential Query Studio, ETL Informatica, MS SQL Server 2008, Confidential .

Confidential

Senior Architect / Data warehouse/ BI

Responsibilities:

  • Architected new data flow (ETL) architecture
  • Developed new FM Model for Operational reporting.
  • Confidential Reportnet Development, Power play Cubes
  • Development of Star and Snowflake schemas.
  • Creation of Various types of Reports (Dashboards, List, crosstab, DMR, cubes)
  • Creation and deployment of KPI Dashboard for Operational management.
  • Created various ETL processes to import several data sources onto DSS for Graphical reporting. Very large database (VLDB).
  • Integration with SAP ERP and Maximo Inventory system
  • Worked with several team to complete project on time and within budget.

Technologies:ER/WIN, MS SQLServer, Confidential 7, Confidential Powerplay, Confidential Query Studio, ETL Informatica, MS SQL Server 2008, MVS DB2.

Confidential

Senior Architect / Data warehouse/ BI

Responsibilities:

  • Installation of Confidential logical and physical configuration.
  • Framework Model Development.
  • Development of Star and Snowflake schemas.
  • Creation of Various types of Reports (Dashboards, List, crosstab, DMR, cubes)
  • Creation and deployment of KPI Dashboard for Inventory Management.
  • Architected deployment of Informatica.
  • Develop Internal SEO ranking BI Solution.
  • Created various ETL processes to import several data sources onto DSS for Graphical reporting.
  • Develop financial BI Architecture.
  • Responsible for implementation and delivery of BI Team for Several client in the US and Europe

Technologies: ER/WIN, MS SQL Server, Confidential Reportnet, Confidential Powerplay, Confidential Query Studio, ETL tools, Confidential Now and other tools, MS SQL Server 2008, Oracle 10G,JCAPS.

Confidential

Enterprise Systems Architect

Responsibilities:

  • Development of Star and Snow-flake schemas.
  • Creation of Various types of Reports (Dashboards, List, crosstab, DMR, cubes)
  • Creation and deployment of KPI Dashboard for Inventory Management.
  • Creation of new Data warehouse in DB2
  • Develop Internal SEO ranking BI Solution.
  • Created various ETL processes to import several data sources onto DSS for Graphical reporting.
  • Develop financial BI Architecture for the Operational departments.

Technologies: Oracle 9 Enterprise, Confidential DB2, ATG Commerce, SUN OS, Confidential Impromptu, Confidential PowerPlay

Confidential

Senior BIArchitect/ Principal

Responsibilities:

  • Developed integration plan for the new installation of Confidential 7.3 with integration to SQL Server, ORACLE, DB2 UDB.
  • Designed and implemented ETL process to integrate multiple databases onto data warehouse for KPI reporting.
  • Integrated Confidential environment onto Current LDAP authentication process.
  • Migrated Current Crystal reports onto Reportnet.
  • Designed and Implemented OLAP Cubes.
  • Upgraded Confidential 7 environment to Confidential 8 along with all key components such as Portal, reportnet, OLAP Cubes etc.
  • Implemented Business Intelligence Solution Utilizing Confidential ver 8; Powerplay; Reportnet; Query Studio.
  • Maintain Databases utilizing DBA tools like DBartisian and Erwin ER.
  • Designed and implemented ETL process for BI Solution.

Technologies: Oracle, MS SQL Server, DB2 UDB, JAVA, Confidential Reportnet, Confidential Powerplay, Confidential Query Studio, and ETL tools, JavaScript, Confidential 7.3, Confidential 8, See Confidential JCAPS, DTS.

Confidential

Senior BI Architect / Developer

Responsibilities:

  • Implemented Confidential 7 environment.
  • Implemented DSS and OLTP databases.
  • Maintain Databases utilizing DBA tools like DBartisian and Erwin ER.
  • Created Backup and restore procedures for all online databases.
  • Provided technology directions for the database development and technical architectures.
  • Implemented data warehousing for e-commerce solutions.
  • Implement new server clustered with SUN, ORACLE, EMC.
  • Implemented ICRM Technologies (Oracle, SUN, EMC).
  • Developed ER Diagrams aligned to Development efforts
  • Integrated J2EE environment with Database LDAP and RDBMS Systems.
  • Implemented state of the art content delivery system.
  • Provided architectural guidance support for DBA's and Developers.
  • Develop Database IT Strategy for the company based on business goals.
  • Develop operational procedures for all online databases.
  • Coded and implemented all backup and restore routines for Oracle and SQL Server.
  • Implemented a real time MPP System for online e-commerce processing.

Technologies:SUN / Linux / WinXP, ORACLE / MS SQL, EMC, CISCO, EAI See Confidential, AKamai, J2EE / Weblogic, (Oracle, SQL Server, MySQL, DB2, Sybase)

Confidential

Sr. Architect

Responsibilities:

  • Implement new e-branding campaign utilizing e-CRM technologies.
  • Created Data dictionaries for in-house use Development.
  • Migrated Current DB2/4000 database to Oracle environment.
  • Designed and Implemented full J2EE environment into Database System.
  • Provided architectural guidance for all IT Staff on database technologies and coding standards.
  • Successfully Implemented ATG/DYNAMO technology with Oracle and DB2/400(Scenario Server, Ecommerce Server).
  • Created IT budgets for acquisition of new database technologies.
  • Switched EDI Spec to utilize database driven XML messaging.
  • Develop Database Strategy for the company based on business and marketing goals.
  • Negotiated IT contracts with vendors and suppliers.
  • Leverage current AS/400 investment to integrate with new environment. (SUN / ORACLE).

Technologies:SUN, LINUX, AS/400, ORACLE, ATG/DYNAMO and Services, JAVA/JSP/J2EE, MAPQUEST API, XML, See Confidential, VITRIA, Web Sphere, MS SQL Server.

Confidential

Senior Architect / Database Administrator

Responsibilities:

  • Implemented full J2EE architecture integrated to Oracle and MS SQL Server.
  • Provided System Architectural direction on reporting and database Infrastructure.
  • Completed the development of the ASP and B2B models.
  • Developed Database infrastructure to handle millions of e-commerce subscribers.
  • Provided guidance in B2B relations and contracts.
  • Successfully implemented business continuity plan for all mission critical databases.
  • Provided technology directions for the development and technical architectures
  • Implemented data warehousing for e-commerce solutions.
  • Analyzed and implement database schema's utilizing E/R tools.
  • Develop IT budgets and strategies for the organization.
  • Provided WCT with the procedural documentation of new database support operations.

Technologies:SUN Solaris 2x 7x, Netscape I-Planet Server, JSP and XML, J2EEE, JAVA, C++ and JAVA Script, Oracle8i Enterprise Server, MySQL, Windows NT Server 40, Windows Workstation 40, CISCO Catalyst 5000, 2xxx, Telephony Technology, Search Engine Technologies, ORACLE, EMC Disks Subsystems, JRUN, RESIN/ JBOSS. (J2EEE), Implemented "Xtreme" Development methodologies.

Confidential

Senior BI Architect

Responsibilities:

  • Tuned SQL server environment for OLTP Transactions.
  • Also tuned Oracle on SUN environments for Decision Support System (DSS).
  • Implemented DSS and OLTP systems with Oracle based technologies.
  • Designed and implemented database schema for the use of internet base search engines.
  • Analyzed and implement database schema's utilizing E/R tools.
  • Tuned index and primary key definitions to increase performance.
  • Implemented Internet e-commerce utilizing database technologies (Oracle, Sybase).
  • Provided with the procedural documentation of the new data center operations.
  • Implemented and directed implementation of SUN & EMC environments.
  • Provided management with strategies for development and computing architecture.
  • Provided development guidance on methodologies.
  • Implemented EMC Disk subsystem for the enterprise.

Technologies:SUN E1000, SUN E6500, SUN 2x, 7x, ORACLE 7x, 8x, Microsoft VB, ASP, JAVA, EMC Power Path, EMC Time Finder, EMC Symmetrix 3700, Windows NT Enterprise Server 40, Windows NT Server 40.

Confidential

Director Technical Systems Architect

Responsibilities:

  • Recommended new Researched technologies for integration into the enterprise.
  • Provided implementation guidelines for new technologies based on approved architecture.
  • Provided the IT technical direction for acquisition of new technologies and their integration.
  • Establish ground and recommend new hardware standards. (Storage, Computing Systems).
  • Provide roadmap architecture for Win95 migration and impact assessment.
  • Recommended new SNA connectivity solution for LU62 and 3270 communications utilizing.
  • Microsoft SNA Server, Windows NT 351 and Bus-tech Channel attachment technology.
  • Provided foundation for server consolidation.
  • Integrated Token Ring Switching technologies with current network.
  • Implemented PeopleSoft HR application utilizing Oracle and Sun Solaris 23.
  • Implemented Internet technology in John Alden utilizing Netscape Commerce Server 10 and Windows NT.
  • Provided Development architecture for client server and host-based systems.
  • Implemented purchasing system for John Alden Financial Corporation utilizing Sybase and Sun Solaris and PowerBuilder.

Technologies:Windows NT 31, 35 and 351, Windows 95, OS/2 211, OS2/WARP, MS DOS, MS Windows 31, WFW 311, Systems 7, AIX 30, SUN Solaris, NetWare 3x, Confidential DB2, Microsoft SQL, Server 421a and 6x, Oracle 7, Sybase 492 and 10, Cisco Routers, Wellfleet Routers, TCP/IP, IPX/SPX, SNA, Named Pipes, Mainframes, DSS Systems.

Confidential

Senior Systems Engineer II

Responsibilities:

  • Recommended new technologies for financial reporting project for board of directors.
  • Applied Lotus Notes and implemented on new marketing force.
  • Dial-Up access utilizing NT RAS & SHIVA.
  • Excel graphs for rate information.
  • Download data from db2 via MDI gateway for PC analyst tools (MS query, Paradox, Access).
  • Design and develop new commissions statement system, utilizing PowerBuilder, Sybase, MDI gateway and DB2.
  • Establish new product annuity process

Confidential, Miami, FL

Senior Programmer Analyst

Responsibilities:

  • Implemented new commissions and procedures and rates for annuity agents, integrating Process with main corporate accounting systems.
  • Implemented new annuity regulations for a marketing organization.
  • Recovered administrative systems on a disaster recovery during hurricane Andrew 1992.
  • Developed new agent statement systems utilizing Power Builder and Sybase

Confidential

Programmer Analyst II

Responsibilities:

  • Develop system for the Environmental Control Board of New York collection.
  • Implemented new customer service system for collection and tracking.

We'd love your feedback!