Professional Profile
Mr. Sanchez is a Senior Cloud Data & Analytics Architect with more than 15 years of experience in the Information Technology (IT) industry in helping clients to align IT strategies with corporate strategic initiatives across all organizational departments, divisions, and locations. Demonstrated and/or proven ability to effectively communicate with all levels of management and lead complete project life cycles, from initial planning and needs determination to final testing and deployment of financial reporting systems using technologies such as Power BI, QlikView, Tableau, SAP Business Objects, Cognos, and Oracle Hyperion Essbase in a client/server architecture and network environment. Led and managed a team of five or more resources on several data analytics/data warehouse projects for clients in the healthcare, financial services, insurance, automotive services, energy/commodity, retail, and telecom industries in tracking and analyzing company’s revenue, financial performance, risk and exposure, operating expenses, capital and operating metrics against all developed business plans. Involved with every phase of the life cycle development, including feasibility studies, design, and coding for large to medium data analytics/data warehouse projects. Has acquired over the years a comprehensive understanding of database design and methodology from multiple perspectives (user, designer, and developer) and has hands-on experience in designing, developing, and implementing data integration (ETL) strategies and/or techniques on multiple database platforms and operating system environments using today’s cutting-edge technology such as Oracle Data Integrator, SQL Server Integration Services (SSIS), and Informatica. A strong interpersonal, written and oral communication skills, and is committed to delivering superior quality work.
Experience Summary
Nov 1998 - Current |
GDW Solutions, Inc. |
Senior Cloud Data & Analytics Architect/Data Warehouse Specialist |
Sep 2022 Sep 2024 |
Circuit Clinical |
Senior Cloud Data & Analytics Architect |
Nov 2020 Sep 2022 |
Credit Suisse |
Cloud Automation Engineer/Platform Manager |
Jul 2018 Jan 2020 |
CozyRoc, LLC. |
Senior Data Integration/Data Warehouse Architect |
Aug 2013 May 2016 |
Deutsche Bank |
Vice President/QlikView Platform Manager |
Mar 1997 Dec 1998 |
MCI Systemhouse, Inc. |
Technical Architect |
Jun 1994 Mar 1997 |
Butler Technology Solutions, Inc. |
Data Mart Architect/Oracle DBA |
Nov 1993 May 1994 |
Analysts International Corporation |
Application Developer |
Jul 1992 Mar 1993 |
IBM Corporation |
Lead Application Developer |
Jun 1991 Aug 1991 |
Orange County Information Services |
Programmer/Analyst |
Jun 1989 Aug 1989 |
Orange County Information Services |
Programmer/Analyst |
Technical Skills
Hardware: |
IBM 4381, 3090, AS/400, SUN, IBM Compatible |
Operating Systems: |
UNIX(Solaris 2.7), Windows 95/NT/2000/XP, OS/2 2.11, VMS, IDS/MVS, OS/400, |
Languages: |
Perl, SQL, PL/SQL, Visual Basic 6,C/C++, Pro*C, JavaScript, HTML, VBScript, ActiveX Script, COBOL II, APPC, JCL, CICS/VS |
Databases/Tools: |
Azure SQL Server, Snowflake, Delphix, MongoDB, Oracle8i, Oracle Data Integrator 11g(Formerly known as Sunopsis), SQL Server 2008 SSIS, Oracle 11g, Sunopsis, SQL Server 2000 (DTS,Analysis Services), Informatica PowerMart v5, Oracle Express, Essbase v3.2 and v6.0, DB2/400, DB2/2, MS Access 97, PowerDesigner 6.1, ERWIN 3, Oracle Enterprise Manager, Transformation Server for the AS/400, Transformation Server for MS Windows NT |
Applications/Tools: |
VMware Realization, VMware Orchestrator, QlikView, Business Objects XI R2, MS Visual Studio 2008, OpenLink Endur v52r2, Cognos Impromtu and PowerPlay, Cognos PowerPlay Web Edition, Cognos Impromptu Web Reports, Informatica, Commander 4.2, DMLan 4, TSO/ISPF, MS Internet Information Server 4.0, MS Site Server 3.0 Commerce Edition, MS Transaction Server 2.0, MS Index Server, MS Developer Studio97 |
Big Data: |
Azure, Azure Databricks, Azure Data Factory, Cloudera, Hue, Impala, Hadoop, Map Reduce, Hive, HBase, Mahout, Sqoop, Pig, Zookeeper, Flume |
Relevant Experience
Circuit Clinical | Senior Cloud Data & Analytics Architect | ||
09/22 - 09/24 | Buffalo, NY | ||
Designed cloud-based data and analytics solutions for the clinical trial industry, addressing data compliance (e.g., HIPAA), structured/unstructured data, and specific research needs. Led a team of Data Engineers to refactor application architecture and implement scalable cloud solutions. Developed and managed robust ETL pipelines using Azure Data Factory (ADF) and SSIS for integrating and processing data from EHR, patient records, and lab results. Built scalable data pipelines using Azure Databricks for advanced data processing, transformation, and analytics. Deployed Azure services, including Azure API for FHIR, Azure Data Lake Storage Gen2 (DLS Gen2), and configured Role-Based Access Control (RBAC) assignments to ensure secure and compliant data access. Created and optimized cloud-based data architectures for storage, processing, and analysis of clinical trial data using Azure technologies, ensuring security and privacy. Developed interactive Power BI dashboards and customized visualizations: Delivered actionable insights and designed KPIs to monitor recruitment, enrollment, and operational performance effectively. Collaborated with stakeholders to align analytics solutions with business goals and performed exploratory analysis for meaningful insights. Optimized performance of data pipelines and analytics processes, ensuring efficient resource utilization in cloud environments. Mentored junior team members on best practices, industry standards, and technical expertise in data architecture. Proficient in developing SSIS packages, stored procedures, and strategies for high-performance data integration and management. Stayed abreast of advancements in cloud, analytics, and machine learning technologies to enhance clinical trial data solutions. |
|||
Credit Suisse | Cloud Automation Engineer/Platform Manager | ||
11/20 - 09/22 | Morrisville, NC | ||
Lead the Cloud Engineering team responsible for supporting the Delphix and MongoDB platform globally within the Group Chief Information Officer Division of the bank in providing a stable infrastructure as a service across traditional database technologies (e.g., Oracle, MS SQL Server, Sybase) by improving automation on the cloud environments. Worked closely with the operational team, project/program management, and domain leadership with onboarding of database applications to the Delphix and MongoDB platforms. Managed the Delphix and MongoDB platform book of work (e.g., issues, releases, bugs) using the agile project management tool - Atlassian JIRA Project Management software. Performed installation and configuration for both the Delphix and MongoDB (e.g., ReplicaSet, Shard) platform on a Cloud infrastructure. Participated in high-level enterprise architecture analysis, evaluation, design, integration, documentation, and development. Work collaboratively across the database regional and leadership team to drive the adoption of standard NoSQL toolsets to reduce complexity and support operational goals for increasing Cloud automation across the enterprise. Basic knowledge and experience with modern infrastructures automation platforms such as VMware vRealize Automation (vRA) and VMware vRealize Orchestrator (vRO) that enables private and multi-cloud environments on Cloud infrastructure. Helped shape team vision, establish team goals and work with direct reports and leaders across the organization on strategies for executing, measuring progress, and sharing results. Provided daily monitoring, management, troubleshooting, and issue resolution for both Delphix and MongoDB platforms hosted on the Cloud. |
|||
CozyRoc, LLC. | Senior Data Integration/Data Warehouse Architect | ||
07/18 - 01/20 | Raleigh, NC | ||
Helped customers in how to use the company’s software product in building data transformations with SQL Server Integration Services (SSIS) including importing data from files, sourcing from SharePoint and other CLOUD applications, and moving data from one database platform to another. Prepared and managed multiple database server environments (both physical and virtual) in order to troubleshoot/resolve customer technical issues which included creating database schema objects. Built interactive Power BI dashboards and tailored visualizations to provide actionable insights and design KPIs. Developed strategies for data acquisitions, management, governance, use, and retention of data assets for clients in various industries. Developed and published (e.g., blogs, articles) best practices for data integration using Microsoft SQL Server Integration Services (SSIS) and company’s software product usage; Thus, increasing company’s subscription-based offering downloads by 100 percent. Selected, purchased, and implemented a cloud-based helpdesk ticketing system (e.g., Zoho Desk) with knowledge base articles in order to automate frequent tasks, improve customer response, and process efficiency. Participated in industry events, speaking with partners, prospects and customers, which included product technical demonstrations. Create detailed documentation for functional or technical design that can be understood and used by all business partners and customers. |
|||
Deutsche Bank | Vice President/QlikView Platform Manager | ||
08/13 - 05/16 | Cary, NC | ||
As a member of the Shared Application Services team,managed a team of QlikView platform engineers responsible for supporting over 4,700 users globally, 264 QlikView applications, and 124 Windows 2008 servers across multiple locations within the Shared Application Services at Deutsch Bank. Oversaw the shared platform, day to day requests, book of work, and roadmap strategy. Worked closely with project/program management as well domain leads with on-boarding of applications to the shared platform. Managed risks, issues, and escalations in the day to day operation of the shared platform. Reviewed and signed off of new applications and ensured applications on-boarded adhere to QlikView best practices and industry standards. Reviewed and approved weekly production changes in order to prevent risk of failure and guarantee system stability. Planned and/or conducted major hardware, network, software, and operating system upgrades and migrations. Ensured all audit & compliance issues were closed on time and no outstanding risks or gaps on scorecards. Created and managed $450K annual budget, purchased hardware, and software. Ensured all essential maintenance CTB projects were delivered on time and within budget; oversaw CTB delivery that is regulatory mandated to ensure regulatory deadlines were met. |
|||
GDW Solutions, Inc. | Cloud Data & Analytics Architect/Consultant | ||
04/20 - 07/20 | CONDUENT | Morrisville, NC | |
As a team lead, worked closely with business stakeholders to architect and develop Cloud Data & Analytics solutions in Azure and Snowflake. Architected, designed and maintained high performing ELT/ETL processes using such tools as Azure Databricks, Scala, Python, and Azure Data Factory. Established data management metrics like data cataloging, data storage and archival, data lineage within Azure Data Lake. Database, storage, and other back-end services in fully virtualized environments. Collaborated with other resources around security, encryption, etc. for cloud Data Analytics environments. Utilized framework driven approach to ELT development to deliver scalable and reusable solutions. Architected and designed how to assess the performance of data solutions, how to diagnose performance problems, and tools used to monitor and tune performance. Established automated, elastic scaling of cloud services, automated deployment and remediation. Collaborated with Product owners to drive adoption and optimization of the analytics platform. Defined analytics standards and best practices. Identified and delivered process improvements based on analytics, metrics and skills. Experienced across all phases of data modeling, from conceptualization to database optimization. |
|||
Senior Data Warehouse Technical Architect/Consultant | |||
07/16 - 07/18 | Credit Suisse | Morrisville, NC | |
Served as the Lead Data Warehouse Architect/Developer for a custom-built analytics and data warehouse solution at Credit Suisse, supporting capacity management and resource planning. The solution provided critical performance insights into assets (e.g., servers) with potential operational, financial, and reputational impact. Conducted detailed requirements gathering, designed dimensional data models, and developed source-to-target mappings. Set up development and UAT environments, and designed ETL processes using SQL Server 2008 SSIS, native database languages, PowerShell, VB Scripting, and Python. Built interactive Tableau dashboards to present insights from the data repository effectively. Developed SSIS packages to produce Tableau Data Extract (TDE) files, enabling seamless integration with Tableau Dashboard applications. Led a small offshore vendor team in migrating and planning several terabyte-sized databases to a Data Lake environment (e.g., Cloudera). This included developing data acquisition processes (ETL), cleansing and aggregating data, and creating database objects. |
|||
Lead ETL Architect/DB2 Developer/Consultant | |||
12/12 - 07/13 | Brown Brother Harriman | Jersey City, NJ | |
Served as the ETL Architect/Senior ODI Developer in the development of a custom built Enterprise Data Warehouse (EDW)/Cognos initiative that support the company’s Exchange Traded Fund (ETF) and investment services at Brown Brother Harriman Corporation; the newly built ETF EDW eliminated extensive use of Excel macros and improved efficiency, productivity and most of all reduced risk. Thus, enhancing the current workflow/process and increasing the number of funds, baskets, and clients. Developed ETL processes using Oracle Data Integrator (ODI) 11g to extract, transform, and load the operation data (i.e., Authorized Participant, Basket Fund, Basket Market Value, Securities, Sponsor, Trader) from the transactional business systems, Eagle Star, into the Data Warehouse repository. Set up and configured the Oracle Data Integrator (ODI) 11g with multiple Master Repositories in a three-tier environment and performed periodic upgrades when required. Performed detail data analysis of both data elements requested by the business and data sources; documented data source definition, source-to-target mapping, and logical structures to support the ETL batch process. Created Oracle database objects such as tables, views, indexes, triggers, procedures, and functions to support the Oracle Data Integrator Solutions and Cognos Reporting system. Provided additional support, guidance, and training in the deployment of the Oracle Data Integrator solution in various environments such as integration, QA, and production which included automation of production release of ODI Scenarios and database objects. Helped estimating ETL project tasks and defining project scope. |
|||
ETL Architect/Informatica Developer/Consultant | |||
01/12 - 10/12 | Wyndham Vacation Ownership | Orlando, FL | |
Served as one of the ETL Architect/Informatica Developer in the deployment of a custom built ETL strategy in supporting the implementation of an Enterprise Data Warehousing/OBIEE initiative that collected, cleansed, and integrated the company’s data (i.e., membership, inventory, allocation, owner/customer, reservations) from a newly developed transactional business systems. Worked closely with other team members and business users in understanding the business requirements and the source operational systems. Performed detail data analysis of both data elements requested by the business and transactional source systems. Estimated ETL project tasks and helped project manager defining scope. Documented data source definition and ETL specification (a.k.a., logical source-to-target mapping) for each environment (i.e., staging, central repository, data mart). Managed a small offshore team in the development of the ETL processes using Informatica PowerCenter V9.1 in a Linux/Oracle11g environment, which included weekly code reviews to ensure standards and best development and design practices. Created, executed, and maintained QA test plans for each environment (i.e., staging, central repository, data mart). |
|||
Lead ETL Architect/DB2 Developer/Consultant | |||
05/11 - 12/11 | Bank of America Corp | Jersey City, NJ | |
Served as a Lead ETL Developer/DB2 Developer in the enhancement of an existing custom ETL framework that collected, cleansed, And integrated the company’s performance data (i.e., cash-flows, liquidity positions) from various operational source systems. The enhancements were part of an overall initiative in improving an internal custom built Liquidity Risk Management System (LRSMS) that supported and provided Bank of America Corporate Treasury executives, senior managers, and business analyst with analytical reporting capability on the company’s liquidity position, sources and uses of cash, forecasting of cash flows and stress test modeling, funding counterparties, and developing funding plan as needed. Major contributions and/or accomplishments included: designing and developing an ETL component that dynamically constructed in real time the SQL to load over 100 source feeds into the Liquidity Position fact table using a Meta Data strategy; designing and developing an ETL process that mapped custom products and/or services hierarchical relationship with the company’s general ledger products for reporting purposes; developing DB2 objects such as tables, views, indexes, triggers, procedures, and functions to support the ETL Meta Data Rule component; providing support, guidance, and training in the deployment of the solution in various environments such as integration, QA, and production; and creating database objects to support the development of Spotfire reports to allow users access to source reference data; The following tools and/or technologies were used in the development and deployment of the solution: DB2 V9.7, DB2 V9.7 SQL Procedure, Windows, Linux, LRM Studio, Toad For DB2 V4.7, and Spotfire Client and Server. |
|||
Lead ETL Developer/Data Architect/Consultant | |||
12/10 - 05/11 | United States Department of the Treasury: Bureau of Public Debt | New York, NY | |
Served as a Lead ETL Developer/Data Architect in the deployment of the agency Auction Securities Data Warehouse in order to make easier access of auction securities data, provide analytics, trending and comparisons, reporting and exporting capabilities that support the business needs, but most of all increase data utilization, and improve customer services and productivity. Primary responsibilities included but not limited to performing source-to-target mapping, installing and creating Oracle11g database objects (i.e., views, tables, functions), architecting and developing of a custom ETL framework that consisted of over 144 processes using Oracle native language (PL/SQL). The following tools and/or technologies were used in the development and deployment of the solution: Oracle11g, Oracle PL/SQL, and Business Objects 3.1 (i.e., Universe, Webi). |
|||
Senior Oracle Data Integrator (ODI) Developer/Consultant | |||
05/10 - 12/10 | Kimco Realty Corp | New Hyde Park, NY | |
Served as a Senior Oracle Data Integrator (ODI) Developer in the development of the company's budget, forecast, and capital planning reporting system in order to improve the cycle time of the current planning process, reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast. Primary responsibility include but not limited to installing and configuring the Oracle Data Integrator software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL processes using the Oracle Data Integrator 10g (formerly called Sunopsis) to update the Hyperion Planning and several Hyperion Essbase 11g applications including updates to meta data for various dimensions and loading of raw data; Other tasks include creating scripts such as load rules, calc, and Maxl to clear the Hyperion Essbase applications in order to facilitate the ETL processes, creating MS SQL Server 2008 SQL scripts and database objects in order to establish various environments such as development, test, and production, and creating Smart Views in order to test and validate the loading of raw data into the Hyperion Essbase application. |
|||
Senior Business Intelligence Solution Architect/Consultant | |||
09/04 - 04/10 | Banco Santander Central Hispano | Stamford, CT | |
Served as a Senior Business Intelligence Solution Architect in defining, developing, and enhancing of two separate custom DW/BI systems for the corporate loans and investment business units. Primary responsibility include but not limited to coordinating, planning, and conducting interviews with various business users in identifying and capturing business requirements, defining and developing project scope/plan, creating and developing two separate multi-dimensional data models using the Ralph Kimball methodology, performing source-to-target mapping, building database schemas in an Oracle8i environment which included creating scripts and procedures for production migration, and building two separate ETL batch processes (over 120 packages) using MS SQL Server 2008 Integration Services (SSIS). Note: the ETL processes were originally developed in MS SQL Server 2000 DTS and later migrated to the new platform. Additional tasks include the creation of a custom analytical application using MS SQL Server 2000 Analysis Services for the investment services in order to track primary and secondary commission by region and salesperson, the migration of the original reporting solution to Business Objects Enterprise (BOE) XI R2, the creation of the migration procedures for installing and configuring BOE in a production environment, performing BOE software upgrade and patch installation in the development environment, creating and developing of BOE Web Intelligence reports, training business users in how to navigate through BOE Info View and creating and accessing reports. |
|||
Data Warehouse Architect/Consultant | |||
04/04 - 09/04 | Pitney Bowes, Inc. | Stamford, CT | |
Served as a Data Warehouse Architect/Consultant in the enhancement and development of a SAP Business Warehouse application at Pitney Bowes Corporation. Responsibilities included but not limited to conducting intereviews with executives, senior managers, SME's, business analysts, and technical staff in capturing and understanding business requirements, and defining project scope; performed detail data analysis of both data elements requested by the business and data source (IMS and SAP R/3), and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart; translated business requirements into dimensional data model to support the billing/invoice data mart using Erwin; communicated and/or provided knowledge transfer to consultant (SAP BW Developers), both on and offshore, in the development and support of the project (SAP BW). The following tools and/or technologies were used in the development: MS Windows 2000, Sun Solaris, Oracle8i, SAP BW, Erwin, and Qualiware. |
|||
Senior Data Warehouse Specialist/Consultant | |||
05/03 - 03/04 | Automotive Finance Corporation | Indianapolis, IN | |
Served as a Data Warehouse Specialist/Consultant in the enhancement and development of an enterprise data warehouse/business intelligence application for the automotive services at Automotive Finance Corporation. Primary focus and/or development efforts were in the reengineering of the ETL processes using the Oracle Data Integrator (formerly known as Sunopsis) tool. Additional tasks included the creation of schema objects (tables, views, indexes, packages, triggers, etc.) in an Oracle8i environment, the expansion of a single dimensional data model (star schema) into multiple star schemas, source to target mapping, storage capacity planning and the support and maintenance of the Cognos EP Series 7 reporting environment. The following tools and/or technologies were used in the development: MS Windows 2000 Server, Sun Solaris, Oracle8i, Sunopsis, PL/SQL, Cognos EP Series 7, Erwin, and Oracle Enterprise Manager. |
|||
Senior Data Warehouse Specialist/Employee | |||
09/01 - 10/02 | OpenLink Financial | Long Island, NY | |
Served as a Senior Data Warehouse Specialist/Consultant in the enhancement and development of a custom analytical application for trading and risk management in the energy/commodity marketplace. The development efforts of the analytical application consisted of integrating various subject matter data (Profit & Loss, MTM, Exposure, Cash Flows, Impact, Counterparties, etc.) from the Endur application. In addition to the development role, helped build the data warehousing services of the company and trained and mentored internal staff on data warehousing. Tasks included conducting requirement analysis; the design and development of a dimensional data model (star schema); the creation of a database, in both Oracle8i and SQL Server 2000; the development of ETL processes (PL/SQL, DTS Packages); the creation of several multidimensional cubes; the development of a web reporting application; client training and documentations. The following tools and/or technologies were used in the development: MS Windows 2000 Server, Sun Solaris, Oracle8i, SQL Server 2000 (DTS and Analysis Services), PL/SQL, MS Office Web Components, Erwin, FrontPage 2000, Oracle Enterprise Manager. |
|||
Lead Data Warehouse Architect/Oracle DBA Manager/Employee | |||
10/00 - 05/01 | J.Crew | Manhattan, NY | |
Served as a Lead Data Warehouse Architect in the development of a web-based Enterprise Customer Relationship Management (eCRM) reporting application for the eCommerce department at J.Crew. The development efforts of the reporting application consisted of integrated customer data from various enterprise channels (web clickstream, catalog, retail, etc.), thus providing a consistent view of the customer. Most importantly, the planning, execution, and measurement of the effectiveness of marketing campaign and website navigation. Tasks included conducting requirement analysis, designing and developing of a data model (star schema), the creation a Oracle8i database, coding of ETL procedures (PL/SQL, Perl and Informatica), designing of Cognos Impromptu and PowerPlay reports, software installation, and the automation of production jobs. The following tools and/or technologies were used in the development: MS Windows NT, Sun Solaris, Oracle8I, PL/SQL, Perl, Unix, Essbase, Cognos, Erwin, IIS, and shell scripts. |
|||
Lead Oracle Database Administrator(DBA)/Consultant | |||
01/00 - 10/00 | Move.com | San Francisco, CA | |
Served as a Lead Oracle Database Administrator in a development environment for an enterprise database applicaton, Move.com. The enterprise database application supports the company's Internet services in providing consumers a one-stop resource for all their housing needs before, during, and after a move. Tasks include designing and building of logical and physical database structures, administrating several Oracle database applications and security, analyzing and translating end users requirements into database objects (tables,views,indexes,procedures,functions,etc.) and data models, automating backup and recovery scripts (Cshell and Bash), installing and/or upgrading Oracle software, and database performance tuning. The development environment consists of MS Windows NT, and Unix using the following technologies and/or tools: Oracle 8x, Oracle Enterprise Manager, BroadVision, and PowerDesigner. |
|||
Oracle Database Administrator(DBA)/Consultant | |||
07/99 - 11/99 | The Guardian Insurance | Manhattan, NY | |
Served as an Oracle Database Administrator for an enterprise database application,The Guardian Insurance. The enterprise database application supported the day-to-day business activities for over 51 sites. Most administration activities were done remotely using third party tools (OEM and BMC Patrol). Tasks included monitoring daily activities, troubleshooting problems, software and application upgrades on various platforms (MS Windows NT, Sun, and AIX), performance tuning, automation of backup and recovery scripts, and maintenance of system security and database objects. |
|||
Decision Support Analyst/Consultant | |||
06/99 - 07/99 | Reckitt & Colman | Wayne, NJ | |
Served as a Decision Support Analyst in the deployment of a web-based enterprise reporting application for Reckitt & Colman. Tasks included the installation and configuration of the Cognos and MS IIS (version 4.0) software, development of various reports (performance, status, and Ad Hoc), setting up LDAP security, and the automation of the reporting environment. The development was done under MS Windows NT platform using the following front-end tools to retrieve and manipulate data from an Oracle database application: Cognos Impromptu and Impromptu Web Reports. |
|||
Decision Support Analyst/Sr. Oracle DBA/Consultant | |||
11/98 - 05/99 | CitiCorp Global Technology, Inc. (CGTI) | Manhattan, NY | |
Served as a Decision Support Analyst in the deployment of an enterprise data warehouse application for CitiCorp Global Technology, Inc (CGTI), a division of Citigroup. The enterprise data warehouse application is to support the business processes (Order Management, End User Billing Detail, Carrier Services, and Products) of CGTI. Task include analyzing and documenting business data reporting needs, designing and developing of Impromptu reports, designing and developing of multi-dimension models in PowerPlay, and assisting in the development of user training materials. Additional responsibilities include the creation of Oracle database objects (Index, Tables, Views, etc.), database performance tuning and SQL statements, data extraction scripts, installation and configuration of Cognos software in a MS Windows NT environment, and the automation of the reporting environment. |
|||
MCI Systemhouse, Inc. | Technical Architect/Employee | ||
08/98 - 11/98 | Avon Corporation | Rye, NY | |
Assisted in the support and maintenance of an Electronic Order Entry (EOE) Web-based application for the Avon Corporation. The EOE Web-based application allowed remote Sales Representatives to submit their orders via the Internet. Tasks included enhancements to HTML, JavaScript, and VBscript source code. The following Web and/or technologies were used in the developing and deploying the application in a Windows NT Server 4.0 environment: MS Internet Information Server 4.0 (IIS), MS Site Server 3.0, Commerce Edition, MS Transaction Server 2.0, MS Index Server, SQL Server 6.5, and MS Developer Studio97. |
|||
11/97 - 07/98 | Chase Manhattan Bank | Manhattan, NY | |
Served as an Oracle Database Administrator (DBA) in the deployment of an enterprise data warehouse database in Oracle for the Chase Manhattan Bank. The data warehouse database was deployed to support the Profitability Reporting Facility (PRF) application for the financial analysis community. Tasks include the design, development, and the administration of several Oracle database applications exceeding 50 Gbytes in data, Oracle performance tuning, translation of business requirements into database application design and data models, and migration of various database schemas between databases. Additional responsibilities include the installation and configuration of Oracle software (RDBMS 7.3 and Oracle Enterprise Manager 1.5) in a UNIX and Windows NT environment. |
|||
05/97 - 11/97 | Major League Baseball Corporation | Manhattan, NY | |
Served as a Technical Architect in leading a group of team members in the design, development, and implementation of a data warehouse database application for the Major League Baseball Corporation. Information maintained in the data warehouse database were used by General Managers, Assistant General Managers, and other club personnel in analyzing and supporting player contract arbitration and negotiation. Tasks included the design and development of a Conceptual System Blueprint, the presentation of the propose system to the client, the evaluation and selection of hardware and software vendors, the logical and physical design and implementation of the database application, and the design and development of the data distribution program between databases. Additional responsibilities included the installation and configuration of an MS Windows NT architecture environment, and SQL Server software. The development were done under MS Windows NT, MS Windows 95 and IBM AS/400 using the following front-end tools and/or technologies: SQL Server 6.5, DB2/400, MS Access 97, Business Objects 4.0, Transformation Server for AS/400 and MS Windows NT, Visual Basic 5.0, and Wise Installation 5.0. |
|||
03/97 - 05/97 | Pitney Bowes | Stamford, CT | |
Participated in the feasibility study of a data warehouse project for the Mailing System Division at Pitney Bowes. Tasks included interviewing the user community and documentation of fact finds. Additional responsibilities included the assessment of an Oracle on-line transaction processing database in an MS Windows NT 4.0 architecture environment. |
|||
Butler Technology Solutions, Inc. | Data Mart Architect/Employee | ||
11/95 - 03/97 | Xerox Corporation | Rochester, NY | |
Designed, developed, and implemented a two-tier client/server application that consisted of a Decision Support System (DSS) for the XES finance organization at Xerox Corporation. Tasks included the design, development, and the administration of a Oracle data mart, the distribution of global data from the Data Warehouse, installation and configuration of the Oracle software in both production and test environment, performance tuning, implementation of a backup and recovery strategy, conducting requirements analysis, data modeling, automation of production jobs and support. The development were done under Windows for Workgroups and Unix using the following front-end tools and/or technologies to retrieve and manipulate data from various database systems (Oracle, Essbase, Access, and DB2): Essbase Application Manager, Visual Basic, Access, Embedded SQL, ODBC, Pro*C, Cshell, and SQL*Plus. In addition to the implementation of the DSS, provided support for integrating various components of the development of an C++ application, evaluation and acquiring of new installation software for productivity enhancements, and functional and/or technical support of an MS inter-application (Visual Basic, Excel, and Access). |
|||
Lead OLAP Developer | |||
02/95 - 10/95 | Bausch & Lomb, Inc. | Rochester, NY | |
Designed, developed, and implemented a Decision Support System (DSS) for the Personal Product Division at Bausch and Lomb, Inc. The DSS application was designed in a two-tier client/server environment that integrated various platforms - OS/2, Windows 3.1, NT, IBM 3090, and AS/400. Tasks included the design and development of a Graphical User Interface (GUI) using Commander Builder (EIS), the design and development a multi-dimensional database (MDDB) application using Essbase that stored and maintained company's financial, marketing, and sales data, and the loading and manipulation of the data into the database using ADL and Essbase SQL Interface. Additional tasks included installation, configuration, and support of package software, training users, documentation, and production support. |
|||
Lead Application Developer | |||
06/94 - 01/95 | Mutual Life Insurance Company of New York | Syracuse, NY | |
Developed, tested, and implemented a batch application in C that calculated the required reserve for all policies at Mutual Life Insurance Company of New York. Designed OWL application interface in C++ that allowed the output results to be viewed by end users. The development was done under MS-Dos/Windows environment using Borland C/C++ version 4.0. Additional tasks included designing and testing of reports using EasyTrieve Plus and Cobol II, and retrieval of customer data from an IMS/VS database. Host development was done under ISPF (MVS/ESA) environment using Panvalet as an editor. XPEDITOR was used as a debugging tool for all Cobol II applications. |
|||
Analysts International Corporation | Application Developer | ||
11/93 - 05/94 | Rochester Gas & Electric Corporation | Rochester, NY | |
Designed, tested, and implemented several distributed processing programs using Advanced Program-to-Program Communications (APPC) for the Information Technology Division at Rochester Gas & Electric Corporation. The distributed processing programs allowed customer service orders to be sent and received from a Mobil Telecommunication application, thus allowing Field Personnel to view customer service order on their PC Radio (laptops). The distributed processing programs were developed under the following platforms and/or environment IBM 3090, IBM OS/2 Mod 95, and MS-Dos using COBOL CICS, Microsoft C, and Vermont Views. Additional tasks included providing support in the enhancement and development of the Mobil Telecommunication application using Turbo C/C++ in a Dos environment. |
|||
IBM Corporation | Lead Application Developer | ||
07/92 - 03/93 | IBM Corporation | Poughkeepsie, NY | |
Coordinated and implemented an Information Delivery System (IDS) for the technical support department at IBM Corporation. Tasks included the design, development, and the administration of a DB2 database application, the design and development of a distribution program that allowed personnel remote access to data from a portable terminal, conducting requirement analysis, and the automation of production jobs and support. The development of the IDS was done under OS/2 2.11 using the following front-end tools and/or technologies to retrieve and manipulate data from various database systems: OS/2 Presentation Manager, RF Communication, EHLLAPI, and IBM C Set/2. |
|||
Orange County Information Services | Programmer/Analyst | ||
06/91 - 08/91 | Orange County Information Services | Goshen, NY | |
Designed, developed, and implemented an inventory and automation tracking system for the Orange County Information Services. The development was done on a Wang 100 system. Tasks included logical and physical layout of the database, coding of programs to load the database, interviewing the user community, documentation of reference manual, and training end users on the Wang 100 system. |
|||
Programmer/Analyst | |||
06/89 - 08/89 | Orange County Information Services | Goshen, NY | |
Designed, developed, and implemented a recovery application using COBOL for the Orange County Information Services. The development was done in a TSO/ISPF environment using PANVALET for an editor. The recovery application ran on an IBM 4381 (MVS/XA). |
|||
Education
1993 B.S., Information Systems
Rochester Institute of Technology
Technical Courses
Member number:4252
Additional Contact information is available on
the Information Page.
Software
Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 1999
Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA
03290-0257