SUMMARY:

Seeking a challenging Business Intelligence/ETL job using my skills in BI, ETL and Data Warehousing.

TECHNICAL SKILLS:

Computer Languages: PL/SQL, SQL, SQL*Plus, SQR, C++, C, Java, JSP, XML, Pro*C, PERL, Experience JavaScript, Protel, Pascal, FORTRAN, LISP, Prolog, COBOL, 8085 assembly

Tools: Teradata Utilities Fast Export/BTEQ/Fast Load, ERwin, HP Quality Center, Oracle’s Enterprise Manager, Quest’s TOAD and SQL Navigator, MS Visio/Project, Cadre's Teamwork, Coad/Yourdon's OOATool and Rumbaugh's OMT CASE Tools, Motif, SAP HANA, Oracle 7.x/8i/9i/10g/11g, Teradata, SQL Server, Ingres and Informix relational database, Paradox, DBASE III Plus

Systems: SAP Business Objects/Web Intelligence (WEBI), SAP Business Objects Data Services (BODS)/Data Integrator (BODI), SAP Information Steward, Informatica, Primavera, SAP BW, SAP FICO, SAP SRM, Maximo from PSDI, TBS from Metasolv, CBP from Saville, Cygent from Cygent, Plateau OpenSuite 5.8 Learning Management System, SAP CAMS Visiprise MES, Intercim Velocity Manufacturing Execution System (MES), Enovia PLM.

OS: UNIX - HP/SUN/AIX, Windows NT, Windows 98, Windows 2000, Ultrix, VxWorks, SOS, XENIX, VMS, MS-DOS

EXPERIENCE:

BI/ETL Architect

Confidential, Dallas, TX

Responsibilities:

• Providing architecture support for ETL and BI framework best practices for SAP BODS 4.x with the BI team.
• Involved in re-architecture, requirement analysis, design and development of existing as well as new BODS ETL jobs with sources such as SAP HANA, Oracle, SQL Server, Teradata and targets such as SAP HANA and Oracle.
• Involved in architecting the HANA data model, performance tuning of HANA attribute and analytic views and HANA SQL statements.
• Design and development of HANA stored procedures to support data profiling pre and post execution of the BODS ETL jobs
• Involved in setting up Data Quality and Data Profiling rules using SAP Information Steward as well as stored procedures. This has helped in the overall data quality in the enterprise data warehouse.
• Involved in planning, developing and implementing Disaster recovery processes and procedures
• Involved in upgrade of BODS platform to 4.2. This involved taking a lead and executing the migration strategy, setting up integration and regression test strategies. Enhancements to existing jobs had to me made when comparable performance was not met for volume loads in HANA.
• Architecture, design and development on SAP BODS to extract incremental data from BW Write Optimized DSO’s (WDSO) and regular DSO’s into an ODS layer which is implemented on SQL Server. This is replacing an existing solution where Informatica is being used to extract data.
• Involved in transition of existing DESKI BO reports on 3.1 platform to WEBI reports on the 4.1 environment. BI layer is being implemented by developing Attribute and Analytic Views on HANA, Data Foundation and Business Layers are being developed using the Information Design Tool (IDT).
• Involved in developing a data model which integrates Fleet Management data from multiple data sources such as SQL Server, Oracle and flat files. This data includes data on vehicles, drivers, claims, thefts, fuel. This involved designing and developing the staging layer, operational data store layer and a multi-dimensional data warehouse layer. The data model was developed using ERwin.

BI/ETL Architect

Confidential, Dallas, TX

Responsibilities:

• Providing technical direction, expertise and development support for the offshore team for design and development of ETL code using Business Objects Data Services (BODS) on a BO XIR4 and Oracle 11g platform.
• Involved in in designing, developing and implementing a Data Warehouse and Business Intelligence solution using BO XIR4, BEx, WEBI, Xcelcius, SAP SRM.
• Working with the onsite technical and business team, setting priorities for new requirements, design and development of WEBI reports using BEx queries.

BI/ETL Architect

Confidential, Waukegan, IL

Responsibilities:

• Involved in implementing a Data Warehouse and Business Intelligence solution using Business Objects XIR4, Business Objects Data Services (BODS), WEBI, Xcelcius on an Oracle 11g platform with Oracle R12/PLM as the source.
• Provided technical direction and leadership in BODS ETL migration strategies, BO and BODS CMC security issues.
• Involved in performance tuning of BODS ETL, WEBI, BO universes and Oracle SQL code.
• Interacted with Business and source side technical resources to gather requirements, setup business rules and testing strategies.
• Developed BODS ETL code, universes and WEBI reports for the Agile PLM reporting solution.
• Provided technical mentoring and support to other team members ( Confidential employees, Accenture consultants and contractors).

BI/ETL Architect, Bell Helicopter

Confidential, TX

Responsibilities:

• Involved in implementing a Data Warehouse and Business Intelligence solution using data extracted from Intercim Velocity MES application, SAP CAMS/Visiprise MES and Enovia. Business Objects (BO) XIR3 Data Services (BODS)/Data Integrator (BODI) and Oracle 10g/11g, PL/SQL is used for the ETL layer.
• The BI layer is implemented using BO Designer, WEBI, and Xcelcius. Near Real Time Change Data Capture (CDC) has been implemented using SQData and Oracle Supplemental logs.
• Involved in leading the technical team, project management, interacting with customers, ensuring requirements and deliverables are being met.
• Tivoli has been used for job scheduling.
• Involved as the BI/ETL architect in design, development, testing and customer buyoff of BODS/BODI ETL Jobs, BO universes and WEBI reports.
• Data analysis and data profiling was done from multiple data sources, a multi-dimensional data model has been developed to support a self serve Business Objects reporting environment.
• I am leading a development team based on an offshore, near offshore and onsite model.
• HP Quality Center was used to create Test Plans for Unit Testing, SIT and UAT and for defect tracking.
• Involved in developing BO XI 3.1 universes based on Multi Providers developed in SAP BW. The Multi Providers are based on multiple Infocubes.
• Involved in developing a data model which integrates data from multiple data sources for shop floor manufacturing processes.
• This involved designing and developing the staging layer, operational data store layer and a multi-dimensional data warehouse layer. The data model was developed using ERwin.
• Some of the BI solutions were developed using a Waterfall model and others using Agile methodology.
• Involved in creating strategies for Disaster Recovery, Failover, Data Governance and MDM.

BI/ETL Architect

Confidential, Dallas/Houston, TX

Responsibilities:

• Involved in implementing a Data Warehouse and Business Intelligence solution for the rapid creation of ad hoc and canned reports in a self serve fashion. Data was extracted from Plateau Learning Management System (LMS) Oracle based solution.
• A multi dimensional Data Warehouse was developed using ERWIN for an Oracle based solution.
• The ETL code was developed using SQL Loader, PL/SQL, UNIX shell scripts. Reporting infrastructure was created by implementing a Business Objects XIR2 solution.
• Universe and WEBI reports were created to take care of self serve reporting needs of end users.
• Involved in multiple roles as a Project Manager/Architect/Developer/Mentor/Analyst - taking care of project schedules, architecture and scalability of BO environment and ETL code, design and development of ETL code and BO universes and reports.

Senior BI/ETL Consultant

Confidential, Southlake, TX

Responsibilities:

• Involved in upgrade and evaluation of strategies to migrate from BO 5.x and 6.x to XIR2 - this involved migrating universe, full client reports, WEBI reports and publications to BO XIR2 universe, DESKI and WEBI reports.
• Involved in upgrade and development of multiple ETL projects using Business Objects Data Integrator (BODI). This involved moving data from different data sources into an Oracle Data Warehouse.
• Involved in requirement gathering, analysis, design and development of Business Objects/DESKI/WEBI reports and universes (5.x, 6.x, XIR2), setting up security strategies for multiple projects - Auto Send, OBR, Call Track, Trip Tailor, Simplicity, Genesys (IVR and Call Center), Revenue Advantage, IATA Agencies, TDW, Primavera, for SAP BW, for SAP FICO etc. The source databases being used are Oracle, SQL Server, Teradata, Informix, and DB2. Some of these projects have been implemented as Web Portals using WEBI SDK and Business Objects Enterprise SDK on Weblogic and Tomcat. All modules of Business Objects were used including Reporter, DESKI, Designer, Central Management Console CMC, Supervisor, BCA, Publisher, WEBI and Business Objects Enterprise SDK.
• Provided support for IVR/Genesys ETL processes running on Oracle and UNIX, debugging processes which had failed and enabling them to be re-run. This involved verifying cron jobs, logs and PL/SQL packages and developing new PL/SQL packages.
• Involved in the design and development of CDD ETL customer extracts using Informatica, Teradata Utilities - Fast Export, BTEQ, Fast Load, UNIX shell scripts, Oracle, PL/SQL, Teradata, XML and flat files. Involved in performance tuning and ensuring that these extracts were re-startable.
• Managed and worked with offshore teams in India, China, Poland and Uruguay. Traveled to international sites to do knowledge transfer, training and project management.
• Provided support on existing BO/Crystal reports dealing with Flight and Ground Operations.
• Involved in the design and implementation of report bursting using Cognos and BO Publisher. Teradata, Oracle and SQL Server are being used as the data sources. On an average 35,000 emails are being sent to external as well as internal customers. every month.
• Worked in the implementation of Business Objects as a Confidential wide Business Intelligence standard. This involved giving presentations of capabilities of Business Objects, develop proof of concepts to show the reporting capabilities as well as ease of integration with available data. As part of this also provided technical support, mentoring and training to other BO users within Confidential .

BI Architect/Business Analyst

Confidential

Responsibilities:

• I was involved in the analysis of Business Objects XIR2 universes and reports which would be impacted by this change.
• I was also involved in the analysis of the Oracle PL/SQL packages as well as SQL Server DTS packages impacted.
• Worked on the design and architecture of changes needed in the universes, reports and packages and coming up with test strategies.
• SQL Server, Oracle, Erwin and BO XIR2 (DESKI, WEBI, CMC, Designer), TOAD were used.