Bi Consultant Resume
NJ
SUMMARY:
- 24+ years’ experience in computer systems development.
- 6+ years’ experience in IT project management.
- 5+ years’ experience in BI field, using the state - of-the-art BI tool, QlikView.
- 1+ year experience in the Big Data field, using Hadoop, Hive & Pig, in addition to Microsoft specific tools ( Confidential, SCOPE).
- After gaining a long experience working with Bi and visualization tools, Tableau & SpotFire, in addition to the starting point, QlikView, I got the chance to enter the Big Data world. The beginning was a word of a mouth, and extended to involve all what-it-takes tools. That was LINUX VM, HADOOP, HIVE, PIG…etc. Then after handling a project, to Microsoft, I got involved, and experienced too, working with Confidential & Confidential, the Microsoft response to Big Data tools.
- When working with Big Data, the figures, dealt with, change from GB or TB, as working with normal BI or DW tools, to TB, PB, EB and ZB. And this is the real experience, how to deal with such enormous amount of data, in “ExaBytes” and “ZetaBytes”. I had to use all of my previous experience, in all directions, to be able to go through this field, the Big Data.
- Incorporating the previous long experience in IT development and IT project management, worked as a product manager for QlikView at the regional exclusive QlikTech partner, where the technical and managerial skills could be utilized, the job included:
- QlikView Projects implementation:
- As a technical and project leader, I utilized my skills for:
- Customer requirements gathering, study and analysis.
- Existing environment, and data sources study and analysis.
- Designing the solution architecture and the different phases of the life cycle for the data, in addition to the data scope definition.
- Designing and developing the best suitable practice for the QV data model, and designing the best schema (Star, Snowflake….etc), according to the user critical parameters (e.g. .QVD generation, volume size, reload frequency, duration and hierarchy of reload, setting the best time for automatic reload…..etc).
- Developing complex scripting to achieve the best, simplest, achievable data schema which provide the fastest, and most ready, access to the data dimensions and facts, in the shortest time, balancing the trade-off between the reload time and the performance time.
- Where applicable, designing and developing the needed script to fix any possible discrepancies coming from the DWH. Also developing applications to work as “Script generator” for other applications, where applicable.
- Designing and developing the incremental loading, where applicable.
- Designing the best suitable UI, where the goal is to achieve all the user requirements, in the most simple to use interface, including dashboards, different types of charts, dynamic text objects, different types of objects.
- As needed, designing and providing the required reports, bookmarks….etc.
- Selecting, and developing the security technique to be applied, whether though NTFS, DMS or SECTION ACCESS from inside the document, or combination of more than on option, to reach the required security for accessing the application and data reduction.
- Presales activities: Requirement study, POC development and Demonstrations.
- After sales activities: Installation (QV Desktop & QV server/publisher), User & technical, QV server administration, and project implementation.
- Consulting/Advisor where applicable, helping t he customers implementing QlikView at the organization, this involved application development, reload scenario/timing/frequency design, QVD generation scenario design, along with the usual technical support.
- Also, my work involved providing, where applicable, suggestions for enhancements to the QV product, which can boost the product strength, (e.g. dynamic BG for a scatter chart, which led to dynamic link to Google maps).
TECHNICAL SKILLS:
Software/Languages & development tools: BASIC, GW BASIC COBOL C. Confidential PACE (Professional Applications Creation Environment) I.E.F. (Information Engineering Facility). POWERBUILDER. SQL, SQL SERVER. Visual Studio ( Visual C++, Visual Basic). Visual Studio .Net (VB.net, Jscript, JavaScript) J2EE (JAVA, JavaScript) HTML, DHTML, XML Web services ASP Dreamweaver. Data modeling: I.E.F. (Information Engineering Facility). S - Designer. MS VISIO. Database: PACE SYBASE. SQL. Flat DB files (Excel, .CSV, TSV, .etc).
OSs & Environments: Confidential VS. Confidential OIS (Office Information System) MS WINDOWS WINDOWS 3x. WINDOWS for Workgroup. WINDOWS 2000. WINDOWS me. WINDOWS SERVER WINDOWS VISTA MS IIS MSMQ Com\DCOM DLL IBMMQ IBMDB2 IBM WebSphere
Banking software/Customer Access. EXIMBILLS CS. CHEQUEMATE, CHEQUES - 2000. NAVIGATOR. FINESSE 2000.
Document management software: Zylab
Others: 3D Studio, 3Ds MAX(x).MAYA.Adobe Premiere.WINDOWS Movie maker.
PROFESSIONAL EXPERIENCE:
BI CONSULTANT
Confidential, NJ
Responsibilities:
- Another permanent position, with Confidential, where the main business is the BI, and “Business analysis” services. At Fractal, in addition to my usual work with QlikView, I got the chance to work with other tools as well, such as Tableau and SpotFire. Then, finally, I entered the Big Data arena, through Hadoop and its tools (Hive & Pig), and also Microsoft tools in the field, ( Confidential, Confidential ).
BI CONSULTANT (QlikView specialist)
Confidential, CA
Responsibilities:
- This time the deal was a permanent position, with Confidential . I landed there as a BI Consultant, while the mission is to handle QV environment for Confidential clients.
- The first client was Confidential, a major player in the communication industry. They have a good deal of applications, dashboards, customers, business analysts who depend majorly on QlikView as a BI tool. So, I moved to San Diego, CA, where the client sites are.
BI CONSULTANT (QlikView specialist)
Confidential, MA
Responsibilities:
- First step data extraction
- Second step data manipulation (cleansing, combining fields, splitting fioelds….etc)
- Third step data staging
- Dashboard-oriented data prepared.
- After discussing the business requirements with the designated persons, I elected the best practice for building the data model and designing the refreshment mechanism for the data.
- A new piece of design & development was done for this project:
BI CONSULTANT (QlikView specialist)
Confidential, MA
Responsibilities:
- When done, the developers at Confidential were trained on using the tool to develop other applications, and advanced design techniques and the parameters and factors to be taken in cosideration to elect the best approach for designing the solutions.Deployment to production:
- At the end, the users were trained/supervised to deploy the application to production, and manage refreshment and backup functionality as a sample of real live run.
QlikView CONSULTANT
Confidential, NY
Responsibilities:
- Designing & developing integrated components and user interface with QlikView (involving QV OCX, .NET and Web services)
- Building the methodologies and conventions, to be followed by the QlikView developersBuilding, and advising, the best practices in using QlikView and data modeling.
- Designing and building the data model and architect for different applications.
- Designing and developing the end-user layout, building different suitable QlikView objects, to provide different user and business needs.
TECHNICAL PRODUCT MANAGER
Confidential
Responsibilities:
- When the client demand the help for Qlikview implementation, whether for a full DW solution or a limited BI scope, this becomes a mission within the scope of mine.
- Handling the implementation project, included handling:
- Requirement gathering and definition.
- Designing/prototyping proposed solution(s) and dashboard(s)
- Designing solution architecture & full implementation cycle.
- In addition to all the project management activities (Scope definition, tasks assignments, progress monitoring)
- In addition, as a manager, the following also were included in the scope of the job:
IT PROJECTS MANAGER
Confidential
Responsibilities:
- Applying and implementing the PM methodology for the different projects at the bank, including the biggest and main project at the bank, which was replacing the existing whole banking solution with a more advanced one, the work involved:
- Developing the project plan, from scratch.
- Providing the necessary documents for the project plan.
- Putting the forms standards for the projects.
- Complete management for an EDMS (Electronic Document Management System) at the bank., this included all the project phases:
- Starting and managing the project from the beginning, thru different stages: initiation, Planning, execution, control and close out.
- The work also involved the managerial part of the project, such as:
SR. CONSULTANT
Confidential
Responsibilities:
- Participated in development of Confidential products Confidential, which is a banking trade finance solution, using the latest technology J2EE, this involved working with JAVA, JavaScript, IBM DB2, IBM MQ, IBM WebSphere.
- Handled the company state-of-the-art middleware system, xNetik, which involved:
- Developing xNetik applications.
- Developing the necessary add-ons and plug-ins for the xNetik applications, such as:
PROJECT MANAGER
Confidential
Responsibilities:
- Project Manager for the development, implementation and customer support of the Chequemate and Cheques 2000 Systems using S-Designor, PowerBuilder & SYBASE for all the client banks in the U.A.E., Oman and Jordan for Confidential Clearing.
- Involved in demonstrations to possible clients and pre-sales surveys.
- Worked as part of the Project Team in developing the Confidential NAVIGATOR/Finesse 2000 System to adapt to InvestBank specifications. Performed Finesse Customization including screen building and programming using PowerBuilder & Confidential, heavily involved in system testing and integration.
SYSTEMS ANALYST/PROGRAMMER
Confidential
Responsibilities:
- Started my career in the documentation department, developing technical and user manuals for the in-house developed applications, using Confidential OIS (Office Information System).
- Worked as a font designer for Confidential printers, this involved designing different sizes of the fonts for Confidential printers:
- After accumulating the experience, started to get Involved in pre-sales activities in conducting primary surveys and giving demonstrations for the different systems, performed the analysis and design of the different software applications. Involved in development and programming of the different applications.
- Provided on-site support, assistance and consultation regarding the appropriate applications of the different software solutions. Conducted user and provided user and technical documentation for the different applications.