NICHE TECHNOLOGISTS, INC.
Nationwide Business Intelligence
Consulting & Staffing Services since 1993
|
NICHE TECHNOLOGISTS, INC. Nationwide Business Intelligence
Consulting & Staffing Services since 1993 |
| Offices:
610/847-2143. Fax: 610/847-8555 E-Mail: dbarber@nichetech.com Web: http://www.nichetech.com |
Corporate
Offices POB 507 Revere, PA 18953-0507 |
||||||||
| This is a representative sample of the consultants and job seekers available at Niche Technologists. For more details or to discuss your staffing needs, contact us at 610/847-2143 or dbarber@nichetech.com SAMPLE RESUME #1 Try our one-of-its-kind Live BI Skills Search Engine
Education 4-year degree Data Warehousing/Business Intelligence/ERP Oracle Express Suite includes Express Server (4.8 - 6.3), Express Administrator, Express Objects/Analyzer (2.0 - 6.2), Oracle Financial Analyzer (4.8 - 6.3), Oracle Sales Analyzer, Oracle Financials, Relational Access Manager, Web Agent, Acumate, Stratagem, IRI Retail Scanner Data, and SAS Programming/Software Development VB, VBA, SQL, SQL plus Technologies Internet Development - HTML, XML, ASP, IIS, VB, VBA, VBScript, SQL Server, JavaScript, Visual Interdev Database Design and Development Oracle 8, Microsoft SQL Server 7.0, Microsoft Access, Microsoft Project Hardware & OS Windows NT/2000, Windows 2000 server/advance server, VAX/VMS, IBM Mainframe (MVS/TSO, CMS), Sun Solaris, HP UNIX Technical Business Acumen - Project management, requirements analysis, data gauging, data modeling, technical architecture, OLAP technologist, Pre/Post sales consultant Industry Experience Consumer Package Goods, Retail, Manufacturing, Government, Transportation, Health Care, Financial Services OverviewØ Experienced in gathering requirements, project management, and technical leadership. Ø Expertise in developing multi-tiered Web applications using Microsoft technologies, including Active Server Pages, Visual Basic, SQL Server and Windows NT server. Ø OLAP Expertise with Oracle business intelligence solutions, including Express Server (4.8-6.3), Financial Analyzer (4.8-6.3), Express Analyzer (2.0-6.2), Sales Analyzer, and (light) IRI Retail Scanner Data Ø Experienced with Oracle and Microsoft relational products SQL Server and Data Transformation Services. Ø Experienced with relational products including Access, Oracle 8 and SQL Plus. Ø Understanding of issues related to data warehousing, data modeling, and database management. Ø Over 10 years experience building BI/EIS applications using OLAP tools Ø Over 10 years of experience using VB, VBA and VBScript used to develop BI applications Ø Able to quickly grasp new technologies and products to provide innovative solutions. Work Experience November 02 - February 03 Project Lead/ConsultantØ Managed a project team to implement OFA/Oracle Express Ø Created custom interfaces to extract data directly from General Ledger and stored data in OLAP cubes for consolidation and reporting Ø Created Excel spreadsheet using VBA to do all data cleansing prior to loading into Express Ø Created and installed corporate modeling structure Ø Created all corporate balance sheets and income statements, which were submitted to corporate at month end Ø Held a one week training course and assisted end-users with first month-end close August 1989 - October 2002 Technology Manager/Consultant - October 1994 to October 2002Ø Managed project teams in delivering business intelligence solutions. Ø Technical lead in delivering e-Commerce solutions. Ø Participated in projects in multiple roles of client manager, technical lead, project manager, requirements analyst and developer. Ø Designed middle-tier components for e-Commerce solutions. Ø Designed data extract, load, transformation and modeling for business intelligence solutions. Ø Reported directly to the CTO. Ø Assisted sales staff by doing demos and prototypes and entire sales cycle Senior Consultant, Business Intelligence - August 1989 to October 1994Ø Managed medium-sized business intelligence solutions. Ø Participated with development teams to design and implement business intelligence solutions. Ø Involved in all aspects of requirements, development, data extract, load, transformation and presentation of information. Ø Participated in several OLAP implementations using Acumate, Stratagem and Oracle Express. Ø Gave demonstrations and taught classes using Oracle Express to both current and prospective clients. Ø Supported sales staff with pre and post sales of Business Intelligence products June 1987 to July 1989Manager of Financial ReportingManaged several team members to development an internal reporting tool to assist in the financial close. OLAP technology used was ACUMATE. Supported up to 35 users during the monthly close. Participated in design, development and deployment of an internal reporting tool. Instrumental in creating a mandatory 3-day training course for potential users. October 1985 to May 1987Software ConsultantParticipated in the sales cycle for the Stratagem OLAP product. Accompanied sales staff on sales calls to answer all technical questions, give slide presentations and general overview of the product. Became the Stratagem expert. September 1983 to September 1985 Software ConsultantParticipated in the Stratagem sales cycle, Accompanied the sales representatives on sales call to answer all technical questions, give slide presentations and comprehensive overview of the product. Assisted in development, design and created end-user interfaces using ISPF type menu. Conducted seven-day training courses to customers. July 1982 to September 1983 Programmer/AnalystProgrammer Analyst for consulting firm aiding hospitals in electronically filing all required state forms utilizing APL.August 1981 to July 1982 ConsultantUtilized a proprietary relational database system developed in APL. Designed and implemented this relational technology at client sites.Practice Accomplishments Organizational responsibilities include the following: Managed 15 senior and associate consultants in the areas of utilization, professional development / training, performance evaluation and compensation. Operated within budgetary constraints and toward billable objectives. Participated in recruitment and hiring for all levels. Improved the project staffing process. Assisted in division revenue management. Business Development Experience Participated in over 20 proposals and business development efforts. As sole or lead technologist, proposed potential technologies and software partners, provided scope recommendations, estimated project cost and timeframe of all phases, and defined deliverables. Customized methodologies to be client specific and educated clients on potential benefits. Project SamplingDeveloped a custom Portfolio Executive Information system for high-level managers. System was developed with a custom VB front end using Express server. This enables high-level managers to access portfolio information in a timelier manner. Participated in the management, analysis, design, and customization of a collection of systems to support extraction of actual data from transaction systems, allocation of summary level information for product profitability, sub-systems to provide needed information not otherwise available, data entry for user budgets, controlled exchange of information throughout the organization, and presentation of variances through an Executive Information System. Implemented advanced reporting functionality into an existing Budget EIS using Acumate technology. Developed the Budget EIS system that is used by Budgeting Managers to allow easy retrieval of data. Application was done in Visual Basic. Technical manager responsible for managing a team of consultants that supported the existing financial and reporting system in Acumate and Visual Basic technologies. Coordinated with the client's information managers to identify new requirements as well as implementation of any new functionality into the current systems architecture. Other projects include managing the conversion of these systems in order to support parent company's information requirements and support of the Daily Sales EIS in Acumate and Visual Basic. Processed monthly data installments from IRI. Managed and implemented the development of worldwide HR reporting systems. The projected included all phases, scoping, design, implementation and user training. Technology used was Oracle Express Objects on the front-end and Express server on the backend. This allowed the client to analyze all personnel on a worldwide basis. Designed a Sales reporting system by Department Store using VB and Acumate technology. This system enabled all sales people to access the sales data on a daily bases. Claims Analysis Designed and Implemented a Claims analysis graphical interface for the Vice President of Claims. The project involved a complete redesign of the underlying database structure in order to track the payments to different defense firms on a claim over time. Loss Prevention Designed and implemented a report that would allow users to determine the best areas for educational services in order to prevent malpractice claims. Also lead the graphical interface analysis and design for the reports. Actuarial Reporting Designed and implemented a reporting tool for the CEO. The graphs were based on complicated industry formulas in order to facilitate the process to predict entire costs of malpractice claims based on precedence. Technical Analyst Researched multi-dimensional, and transaction database tools that would fit the model of the older Acumate database warehouse. Presented the best-fit tools to the CIO and top executives of the firm. Project Manager Managed a team of consultants on the entire conversion of the reporting system. Handled budget tracking, cost forecasting and resource scheduling for the entire project. Designed and implemented a quality assurance and user acceptance plans for the conversion. Organized and performed training sessions for the users. Client Manager Attended and led all client-related meetings and handled all issues related to the project. Maintained communication with the client on changes in the scope of the project. Technical Architect Assisted in the planning and development to design the overall database warehouse to the most efficient for performance on all reporting abilities within the system. Developed Visual Basic COM Objects for the Graphical Interface part of the system. Technical expert and lead on a $100K e-Business strategy engagement. Responsibilities included quality and accuracy of deliverables, selecting software partners, and building client confidence in technical capabilities. Proposed $10M of e-Business initiatives. Identified and interviewed potential software partners to evaluate product scalability, security, and integration capability. Prepared cost benefit analysis and recommended partner. Instrumental in securing $100K initial follow-on engagement, in which responsibilities included delivery assurance. Directed team through requirements gathering, analysis and design, development, and deployment. Instrumental in securing $1.2M follow-on engagement. Led design and implementation of Oracle's Express-based Sales Analyzer reporting tool. Systems included revenue, expense and marketing databases. Led a team of consultants in a prototype to determine if Sales Analyzer could handle up to 15 dimensions in a sales reporting system. Designed a Tax Planning and Modeling application using VB and Acumate Client Server Developed a Retail Tracking system to develop custom report generators to support their information infrastructure using Express technology. Implemented a Logistics Cost Analysis system and DSS using Acumate technology that maintains allocation calculations and reporting functionality to support changing warehousing requirements. Performed an application assessment of the global EIS. This assessment included analysis of the feasibility of the RAA/RAM database design, identification of system integration requirements, and recommendations. End.
SAMPLE RESUME # 2 TRY OUR BI/OLAP SKILLS SEARCH ENGINE
SOFTWARE Cognos: PowerPlay Transformer, PowerPlay, Impromptu, Impromptu Web Reports (light experience), Access Manager, Architect, Enterprise Server, Upfront, Scheduler, Query (light) SQL Server, Oracle, Oracle Applications General Ledger and Financial Statement Generator (FSG), Unix, Visual Basic, ASP, JavaScript, Microsoft Access, Crystal Reports Professional, Windows 95/98/2000/XP/NT Microsoft Office, Visio, Visual InterDev, Visual Basic Script, HTML, and ADO WORK EXPERIENCE December 03 to present Cognos Consultant · Extensively worked on understanding the business requirements and designing Cognos applications · Developed ETL scripts to extract and cleanse data from SQL databases for loading into Cognos · Created List, Sub and Cross-Tab reports using Impromptu and distributed Catalog to users for Ad-Hoc reporting and analysis · Created standard filters, calculation prompts, and conditions · Designed the architect model, developed the Cognos Query and PowerPlay packages for production and demonstrations · Published IWR reports and PowerPlay cubes on the portal using Cognos IWR report admin and PowerPlay Enterprise Server · Created dimension maps and multidimensional cubes using Impromptu's Query Definition in PowerPlay Transformer March 2001 to August 2003 Senior Cognos Business Analyst · Designed and implemented data cubes using Microsoft OLAP services, Cognos Impromptu, and PowerPlay to facilitate executive, management and end user reporting. · Created reports using Cognos and automated scripts to validate the integrity of the data based on end user needs. · Trained technical and non-technical users on the use of Cognos tools · Migrated different databases (Oracle and MS Access) to MS SQL Server database using Data Transformation Service tool (DTS) · Monitored data quality, resolving problem data issues, and ensuring timely updates · Provided Oracle back end programming including PL/SQL, Oracle Stored Procedure, data mining, data cleanup and data reporting. · Administered database security, backups, tuning, configuration, and performance (MS SQL 2000) · Responsible for Oracle's FSG and supported accounting team in performing their daily tasks as they relate to the general ledger.
May 2000 to January 2001 Senior Developer/Database Administrator · Performed Database and Server administration including Production support, Logical and Physical Design, Performance Tuning, Monitoring space usage, System configuration, Creating devices, Adding logins/users, Dumps/Recovery, Back up, Task scheduling on SQL 6.5/7.0 · Developed and maintained a Web based Video Streaming Application. This application gives consumer the ability to purchase or to download and enjoy their favorite video clips via Web. The site was also developed to allow various business alliances to be able to create customized banners for their sites. · Responsibilities included analysis, design, development, testing and maintenance of the system. October 1998 to May 2000 Programmer/Analyst · Responsible for the design, development, testing, implementation and maintenance of the Sales Order Tracking System. The system was designed to allow sales personnel to view and electronically annotate reports that are currently delivered to them on paper. · Worked closely with the project's DBA to design and implement Database Stored Procedures. · Utilized ADO and used Crystal Reports for report generation. · Defined initial client specifications, project planning, design, coding, and testing of client interface. · Developed and maintained Bonus Calculator. The system was a subset of the Sales Order Tracking System. It calculated and kept track of the monthly bonuses paid out to sales personnel. August 1997 to September 1998 Programmer Analyst · Utilized Visual Basic 4.0 and 5.0, MS Access 7.0, PDQ Comm 2.3 communications custom control. · Created logical flow, coded, tested and debugged Data Files Exchange System. The purpose of the system was to establish connection and transfer data files between Host and Remote Systems. · Designed the MS Access 7.0 host database: tables, queries. Created stored procedures for the remote SQL Server 6.5 database (to export necessary data). · Participated in development of Inventory and Event Tracking Subsystem to keep track of the artworks, customers, and participating artists and maintain optimum level of stock. Used Visual Basic 4.0 and 5.0, Crystal Reports Professional EDUCATION 4-year degree SAMPLE RESUME #3Try 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 03Consultant - 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 03Consultant - 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
Resume 4
Substantial and current hands-on development experience (4.5 years) with the Cognos Suite: PowerPlay, PowerPlay Enterprise Server, Transformer, Access Manager, Upfront, Impromptu, Impromptu Web Reports, Visualizer, Cognos Script, and MDL Language). Full systems life-cycle experienced. Also has hands-on development experience with Business Objects and Crystal Reports. Has a history of team and project management experience throughout his career both as a consultant and when full-time employed in corporate America. Knows Data Warehousing, DSS, EIS, and OLAP.
WINDOWS NT, HTML, FRONTPAGE, BUSINESS OBJECTS, VISUAL BASIC, TESTBASIC, VISUAL TEST, SQA SUITE, SQABASIC, ORACLE, SQL PLUS, MS ACCESS, SQL SERVER, INFORMIX, SOURCESAFE, CRYSTAL REPORTS, ISQL, Q&E, LOTUS NOTES, ARTEMIS, MS PROJECT, UNIX, SABLIME, SYBASE, ORACLE 2000, JAVA, C, DB2, SPUFI, QMF, CICS, COBOL II, IMS DB/DC, PROTERM, ESCORT, OMEGAMON, PROEDIT, DB2 UTILITIES, PLATINUM, WORD, EXCEL, ORACLE CASE APPLICATIONS & INDUSTRIES Brokerage, Pharmaceutical, Banking, Human Resources, Telecommunication Wireless and Transmission Configurators, Transportation, Insurance, Marketing, International Billing, Customer Care Centers, Order Processing, Telephony, Financial, Sales Analysis, Manufacturing, Retail PROFESSIONAL EXPERIENCE PROJECT EXPERIENCE - Interfaced with the Finance, Marketing and Pricing to define reporting
requirements and project plan for intranet applications for Customer Pricing
System 1/01/99 - 4/01
- Interfaced with the Portfolio Management and Global Asset Management
Groups to define reporting requirements and project plan for intranet
applications for Fixed Income And Equities 2/99 - 9/9 - Interfaced with National Account Managers and Contract Administrators
to define reporting requirements and project plan EDUCATION Chubb Institute for Computer Technology Diploma Oracle CASE Method Data Warehousing Institute Member
Resume 6 SUMMARY Certified Hyperion Essbase (version 5) professional using Essbase beta
version 6 for the past 18 months. Other certifications include MS Windows
Architecture I and II, MS Visual Basic 5.0, MS Access 95 and its Developers
Toolkit, and a MS Certified Solution Developer. Has some experience with
Peoplesoft. WORK EXPERIENCE
SUMMARY Comprehensive Essbase skills (6 years) including full systems life cycle, developing financial reporting and budgeting applications in the education, manufacturing, and telecommunications industries. Extensive calc scripts and member formulas experience. Skills include very good interpersonal skills, project management experience, Wired for OLAP, ArcPlan (training), Essbase 5 Certified, Essbase 6 Release training, Essbase 5 Calc Scripts and Optimization. Self-starter. EXPERIENCE ThinkFast Consulting, Inc. Assigned to various Fortune 500 clients where he created and implemented Essbase business intelligence applications. Responsibilities included project management, requirements, design, creation and implementation. Extensive experience working with Calc scripts and member formulas. University of California, Los Angeles, CA Financial Analyst (1994 -1996) Accounts Payable Supervisor (1990 -1993) Supervised Business Enterprise Accounts Payable office, including a staff
of three. We processed invoices, and purchase requisitions for operating
units, and reconciled the General Ledger and prepared accrual reports
for monthly and fiscal closing. Participated in the transition from a
manual accounts payable system to an on line system. Assistant Front Office Manager - Holiday Inn Pasadena, 1986-1987
§ Hyperion Essbase 5 Certified Professional
SUMMARY
Provides visionary leadership in the effective use of information to gain a competitive advantage in the market place. Professional with a broad experience in Business Intelligence combined with Sales and Marketing. Focused on rapid identification of high value creation projects. Team player and facilitator, leads by example and encouragement. Excellent interpersonal skills, personable, innovative, creative. Enjoys building teams and mentoring others. EXPERIENCE (Confidential) October 2000 to Present Director of Business Development Brought buyers and sellers to B2B market for nutritional supplement raw materials. Identified and negotiated with potential strategic partners to bring additional content and value to the site. Cambridge Technology Partners, Inc. 1997-September 2000 Senior Consultant Supported the CTP selling process, lead scope, vendor selection process, provided client sessions, team facilitation and functional expertise to project teams. Project sampling: ˇ Acted as Senior Business Analyst for the pre-design phase of an Operational Data Store for the leasing arm of a major banking group. ˇ Technical Team Lead in a scope project of a Compliance/Surveillance Operational Data Store for a major Wall Street brokerage firm. ˇ Technical Team Lead in a Data Warehouse scope project for a nationwide restaurant chain. ˇ Key member of a team responsible for the complete redesign and rebuilding of the Database Marketing and Analysis System of a $200 Million NJ based Direct Mail Catalog Company. ˇ Key member of a scope team for the redesign of the Management Reporting System of a major New-York based international bank. ˇ Led Data Warehouse design and architecture for a major Mexican soft drinks company. ˇ Led needs analysis, architecture and design for a cost distribution and reporting system for a major Venezuelan cement manufacturer. Oracle Consulting Inc. Principal Consultant - Data Warehouse Practice 1995-1997 Provided functional Data Warehouse and Decision Support expertise to Project Teams. Project sampling: ˇ Led Needs Analysis and Database Design of a Marketing Data Mart for a Philadelphia based Life Insurance Company. ˇ Performed the Needs Analysis and Database Design of several Data Warehouse projects for East Coast based Credit Card Companies. Fabrics On-Line, Inc. President 1994-1995 Raised funds, wrote Business Plan, integrated software, designed interface, and defined marketing plans. ˇ Co-founded the 1st B2B electronic market for fabrics. ˇ Raised $184,000 in capital from state seed capital fund and private investors. ˇ Defined and implemented system architecture and interface customization. ˇ Awarded the Benjamin Franklin Technology Fund Innovation Award. Metaphor, Inc. Senior Consultant Pharmaceutical Sector 1988-1994 Solved business problems of Fortune 500 clients through the use of Information Technology, specifically object oriented decision support tools and Data Warehouses: ˇ Performed requirement gathering, needs analysis and Database Design for the very initial Data Warehouse implementations of some of the region large Pharmaceutical sector accounts. ˇ Build Business Intelligence application in Metaphor visual object oriented development environment. ˇ Led design and construction of prototype business intelligence applications building team. ˇ Supported sales effort through effective demonstrations, executive and technical presentations, ˇ Support Person of the Quarter (Q4 1989). ˇ Significant Contributor Award 1990, 1991 SUMMARY OF PRIOR EXPERIENCE IMS Health, Ltd., Senior Sales Support Consultant 1987 - 1988 Computer Marketing Services, Regional Sales Manager 1986 - 1987 Gravit America Inc., Sales and Plant Manager 1984 - 1985 Center for Operational Research, Account Manager - Pharmaceutical Sector 1982 - 1984 Black & Decker France, Marketing Research Manager 1979 - 1982 TECHNICAL SKILLS Databases: DB2, Sybase, Oracle Languages: SQL Tools: ErWin, Express, Gentia, Exchange Application, DataStage, Broadbase, Metaphor Operating Systems: Windows 3.1, Windows 98, Windows 2000, Windows NT, OS/2 Packages: Access, Excel, PowerPoint, Word, Project. EDUCATION Indiana University Graduate School of Business, M.B.A., International Marketing & MIS 1979 I.E.C.S. - Strabourg France, B.S. Business, Marketing, 1976 Keywords: Showcase Essbase consulting
|
|||||||||
