 |
NICHE TECHNOLOGISTS, INC. Nationwide Business Intelligence
Consulting & Staffing Services since 1993 (610) 847-2143 Email: dbarber@nichetech.com Web: www.nichetech.com |
SAMPLE RESUME #3
Try our Live BI Skills Search Engine |
 |
TECHNICAL SKILLS
Business Intelligence Tools
Business Objects 5i, 5.16, 5.0, 4.x, Reporter, Designer, Supervisor, Webi, SDK, Broadcast Agent, BO Auditor, Application Foundations, and Set Analyzer. Cognos Impromptu, PowerPlay, Transformer, Upfront, and Access Manager
Databases
Oracle 9i, 8i, Warehouse builder, SQL, PL/SQL, MS SQL Server 2000, 7.0, and DB2
ETL Tools
Informatica 6.0, 5.1, Power Mart, Power Center, MX2, and Designer
Web Tools
ASP, JSP, MS Visual Interdev, VB6, HTML, XML, VBSCRIPT, Java Script, CSS, MS Office, HTML, DHTML, MTS, COM, DCOM, and Web Logic Server
Reporting Tools
Crystal Reports 9.8, 8.5, 8.0, 7.0, SQR, PS Query, and envision
Operating Systems
Windows NT 4.0, 2000, Unix AIX, and HP
Scripts include Korne-Shell, C-Shell, Awk, and VBA
FUNCTIONAL EXPERIENCE
Financial Management – GL/AR/AP – Billing & Invoicing – Purchasing & Material Management – Quality Control – Sales & Source Orders – Production Support – Engineering Designs – Process Control – Health Plans and Schemes – Aviation Control – Business Forms – ERP Interfaces – CRM – Supply Chain Management
EDUCATION
M.B.A.
B.S (Mathematics/Physics)
CERTIFICATIONS
Brain Bench Certified RDBMS Professional.
Member Tek-Tips Forum in Business Objects.
PROJECT EXPERIENCE
July 03 to February 04
Consultant — Architect / Administrator
Environment: Business Objects 5.16, Web Intelligence 2.7, Supervisor, Auditor, BCA, Oracle 9i, PL/SQL, SQL-Server 2k, Windows 2k
o Installed and configured the environments for both development and production.
o Created repository and security domain with user groups and security implementation.
o Migrated Repository from SQL Server 2k to Oracle 9i and all its domains.
o Business Object Universe, Business Objects Reports and Business Objects repository extensively used, and new universe were designed and developed to support the user requirements.
o Extensive analysis to design the Universes and assign them to respective domains.
o Deployed and scheduled reports through BCA.
o Created complex views to overcome loops and contexts.
o Used aggregate awareness in universes.
o Involved in full life cycle of Business Objects reporting Application.
o Webi Reports were created and deployed through Info View.
o Created Auditor reports and tracked user access of reports and Universes.
February 03 — July 03
Consultant — Senior Developer / Analyst
Environment: Business Objects 5.16, Web Intelligence 2.7, Supervisor, Auditor, BCA, Application Foundation, BO Analytics (Supply chain, customer intelligence), Tomcat, Oracle Warehouse Builder, Oracle 9i, PL/SQL, Windows 2k
o Business Object Universe, Business Objects Reports and Business Objects repository used extensively.
o Extensive analysis to design the Universes and assigned them to respective domains.
o Deployed and scheduled reports through BCA.
o Created complex views to overcome loops and contexts.
o Used Aggregate awareness in universes.
o Involved in full life cycle of Business Objects reporting applications.
o Webi Reports created and deployed through Info View.
o Customized Webi Front end.
o Created Auditor reports and tracked user access of reports and Universes.
o Installed and configured the application foundation for supply chain & Customer Intelligence Analytics.
o Used Set analyzer to create sets and Used universes for analytics creation
o Created Dashboards and Speedo meters for churning analysis.
o Customized the dashboards and KPI’s for better manageability of overall performance.
July 02 – February 03
Consultant — Senior Developer / Analyst
Environment: Essentus Vision, Business Objects 5.16, Web Intelligence 2.7, Crystal Reports 8.5, SQL Server 2k, Oracle 8i, PL/SQL, Citrix server & Windows NT
o Business Object Universe, Business Objects Reports and Business Objects repository has been extensively used new universe were designed and developed to support the user Requirements.
o Extensive Analysis has been done to Design the Universes and assigned them to respective domains.
o VBA scripts have been written to enhance the report functionality and automated the Printing capabilities.
o Deployed and scheduled reports in BCA.
o Created Complex Views to Overcome Loops and contexts.
o Used stored procedures to accommodate user parameters and get rid off database complexities.
o Documented Meta data definitions.
o Developed physical and logical Modeling.
o Developed complex ETL (Extract/Transform/Load) procedures were developed using SQL Server's DTS and T-SQL package to provide a way to update/insert/delete data from multiple heterogeneous sources.
o Completed documentation of database structures and processes used to move data in and out of database for future development and expansion of database.
o Involved in Full life cycle of Business Objects reporting Application.
o Webi Reports have been created deployed through Info View.
o Customized Webi Front end.
Oct 01 – July 02
Consultant ― Senior Developer / Analyst
Environment: Informatica, Power Center, Power Mart, Data Junction, Business Objects 5.0,5i, Web Intelligence 2.6, Crystal Reports 8.5, ERWIN, Data Junction, SQL Navigator Oracle 8.0,8i / PL/SQL, SQL LOADER & Windows NT
Project Brief and Responsibilities
Access Management is the data warehouse. Data sources included Customer Orders Data Base, Engineering Order Database, Provisioning, Billing, Trouble Ticket Management, Network Transaction Usage, etc.
Developed a Data Mart which offers a centralized and coherent view of the enterprise by integrating data from the above-mentioned sources to be used as an aid in the decision making process. The offshoot was an alarm system that will notify when orders do not satisfy certain vendor parameters particularly in the area of provisioning.
o Set up ETL development environment (Data Junction)
o Documented Meta data definitions.
o Developed physical and logical Modeling.
o Worked on evaluation of Metadata Interchange between Modeling Tool (Erwin 3.5), ETL Tool (Informatica)
o Desiged Data ETL processes
o Designed/Coded/Implemented the data integration processes through DataJunctionV7.0, Shell Script and Database Scripts
o Business Object Universe, Business Objects Reports and Business Objects repository extensively used, and new universes were designed and developed to support the user requirements.
o Involved in the full life cycle of Business Objects reporting Application.
o Scheduled full client reports and Webi reports through BCA.
o Developed complex SQL, PL/SQL code to enable user queries to the database for data access, using triggers and stored procedures.
o Developed module to output for the most suitable supplier depending upon the given search conditions as parameters. This was a generic form to incorporate varied quality parameters
o The final reporting from the data-warehouse & the Data-marts are done using the Business Objects tool.
November 00 – September 01
Consultant ― Programmer / Analyst
Environment: Business Objects 5.0,5i, Web Intelligence 2.6, Cognos, Power Play web 6.6, Power Play Transformer, Oracle 8.0,8i / PL/SQL, & Windows NT
Project brief and Responsibilities
This project is a Data warehouse and Data mart aimed at facilitating decision-making managers in terms of Analysis, Reporting and usability of data from multiple sources using Cognos products and Business Objects intelligence products suite. The project is to assist Data warehousing migration from Business Objects 5.02 to Business Objects 5i. This migration requires conversion of Business Object Universe, Business Objects Reports and Business Objects repository. The release 5i of Business Objects includes technology improvements in the Web Intelligence area. Emphasis was given to explore new features/functionality of Webi to determine their usability for the client's specific requirements. New universes were designed and developed to support the user requirements.
o Set permessions using Access Manager on Transformer cubes and Reports.
o Some users were given Auto Access on cubes and servers without the prompts.
o Power Cubes were built based on the Business analysis and Dimensions
o Configured Power play Web viewer and Web Explorer.
o Cubes and reports are also deployed to the enterprise when they are published to Upfront
o Worked on Designing and Developing New Universe Definition.
o Worked on migrating Business Objects Report From ver. 5.02 to ver. 5i.
o Installation/Setting of Web Intelligence and Broadcast Agent server.
o Worked on Exploring and Testing Web Intelligence new features and functionality.
o Customized Webi front page by HTML, VB, Java & ASP.
o Trouble shooting and tuning of the Existing Reports.
o Prepared detailed report on the new features/Functionality of B.O. 5i.
July 99 – October 00
Consultant ― Programmer / Analyst
Environment: Informatica, Power center, Oracle 8.0,8i / Business Objects 5.0, Web Intelligence 2.6, Crystal Reports, PL/SQL & Windows NT, Erwin 3.5.2, HTML, ASP, Java, IIS 5.0
Project Brief and Responsibilities
The Health Plan Control system is custom specific software designed to plan and monitor “Plan Coverage” for Geographical Regions. HPC maintains coverage specifications, bill of services and user requirement data for online processing of Plan Registration and Acceptance notices. The applications capabilities to customize Plan modification criteria made the system a powerful and generic tool for data maintenance and tuning operations. On-demand and automated report generation was possible to notify non-conforming products.
o Involved in set up of Data warehouse.
o Documented Meta data definitions.
o Developed physical and logical Modeling.
o Developed Universes against Oracle database and reports using VBA.
o Involved in the full life cycle of the Business Objects reporting Application.
o Installed Business Objects and created the repository.
o Installed Web Intelligence and Broadcast Agent server.
o Customized Webi front page by HTML, VB, Java &ASP.
o Designed and developed universes.
o Involved in conversion of data with Informatica.
o Reports requirements gathering and designed technical and functional specifications.
o Design and development of full client CAN reports and Webi reports.
o Implemented Complex security setup in supervisor.
o Upgraded Business Object from 5.0 to 5I and Implemented Web Intelligence 2.6
o Scheduled full client reports and Webi reports through BCA.
o Developed complex SQL, PL/SQL code to enable user queries to the database for data access, using triggers and stored procedures.
o Developed module to output for the most suitable supplier depending upon the given search conditions as parameters. This was a generic form to incorporate varied quality parameters.
o Embedded PL/SQL and SQL*Plus were also used for several data extracting purposes.
o Wrote Korn shell Scripts to purge temporary tables
June 98 – July 99
Consultant ― Programmer
Environment: Oracle 7.3.x, Informatica, Power center, ETL, Business Objects 4.1.5, Unix (HP-UX)
Project Brief and Responsibilities
The client wanted to implement Oracle Manufacturing and intended to move to an Oracle based application to handle their Workforce data.
Workforce Maintainer provided a labor collection system for both groups of facilities, initially in seven plants. The application provided a method of entering employee time, calculating payments and exporting data to Peoplesoft at regular intervals for the payment process. It also generated complete daily production costing for analysis.
Workforce Maintainer was made to dispatch “extracts” of employee hours, rates and accounts to the system, as an automated process. The complexity of the application was severe since the methodology of calculating overtime and the creation of the Peoplesoft file were different for each plant. Finally, the system records actual employee vacation hours based on the type of accounts and the plant.
o Involved in Data conversions from different databases into Data warehouse.
o Involved in documentation of the Repository warehouse.
o Designed Universes for the application.
o Creation of repositories for development and production environments.
o Designed and developed reports with drill down options.
o Created can reports and ad-hoc reporting.
o On call help desk production support.
o Conducted end user training for basic and advanced reporting skills.
o Trouble shooting and tuning of the reports.
o Database triggers created to audit data modifications and to log specific information to proper locations.
December 96 – May 98
Consultant ― Programmer / Analyst
Environment: Visual Basic 5.0, COM, Active X, Crystal Reports 6.0 and Oracle 7.3
Material and Financial Accounting System Project Aug 1997 – May 1998
This system consists of templates to maintain various books of accounts and stock order and data pertaining to Cash/Bank Transactions, Journals, Debit Note, credit note, employees, customers and suppliers etc. This system kept track of the daily position of cash and bank transaction. Used RDO and ODBC to interface with Oracle. Extensively used WINDOWS ‘95 compliance controls on it, making user interface more efficient. Incorporated functions and procedures using PL/SQL to consolidate data generate trial balance, P/F data and balance sheet data. In most of the screens DBGrid has been extensively used in an unbound mode, in order to update multiple records at time in the database and some columns of DBGrid have been tagged with help context screens, which are developed programmatically. Each screen was facilitated with a query-invoking concept. By which we can output the query result into the list box in turn modifies or delete the transaction by list indexing. Crystal Reports have been extensively used to cater the needs of MIS.
Inventory Control System Project Dec 1996 – Jul 1997
Responsible for Analysis, Design, Development and Documentation. The project was aimed at fulfilling the daily activities pertaining to any medium level-trading firm in terms of inventory management and smooth coordination with other functional areas of business. Dealing with various functional aspects segregated into Issues and returns as Sales, Sales Return, Purchase, Purchase Return, Purchase Order, and Sales Order. Apart from product, employees, suppliers and customers details, based on referential integrity alliances crucial information has been sought from masters and displayed onto the transaction screens. The data access methodology was with RDO through ODBC. Backend was MS-ACCESS.
August 95 – September 96
Environment: Visual Basic 4.0, Crystal Reports 4.0 and Oracle 7.0 RDBMS
Integrated Automation System Project
Involved in the design and development of the following modules with the objective of automating the internal process of this company. Responsibilities included requirement study and analysis, preparation of data flow diagrams, data modeling, entity relationship diagrams, normalization, user, interaction, designing tables, user interface, processing logic, report formats, wrote stored procedures, functions.
Financial Accounting System Project
This system consists of modules to maintain various books of accounts and data pertaining to invoicing, Purchasing, Cash/Bank Transactions, Generation of Debts, Credits Notes, Journal Vouchers, Ledgers and tracking of Payables/Receivable. In addition it has generation of trial balance, profit/loss statements and balance sheet functionality it consists of 31 input screens and 28 reports. Credit packages incorporating functions and procedures using PL/SQL to consolidate data generate trial balance, P/F data and balance sheet data.
Payroll Accounting System Project
This system was aimed at assisting the payroll department in automating the processing of salaries, allowances, deductions, advances, loans, overtime, taxes and payables to government. The software incorporates user-defined grades, benefits and deductions as per grade, loans and corresponding investments. It also handles gratuity and retirement