GLOBAL BI VIZ PRACTICE HEAD
WIPRO TECHNOLOGIES
Total years of experience :29 years, 6 Months
Objective: Having proven expertise in the following areas
• Delivery excellence
• Practice Coe across verticals and tools
• BICC
• Contextualized RFP response
• BI Analytics Product development across domains with POC/POV
• BI tool & ETL selection process
• Data integration and mashups
• Best practices to implement BI projects to save time and money
• UI UX best practices in design of dashboards
And to further specialize for the benefit of the organization.
Project 1: Top management dashboarding - using qlikview - automated dashboards for top mgmt across all lines of business and operations to ensure that information is available for effective decision making.
Project 2: Design, development and maintenance of data warehouse : Project manage End to end development of Data Warehouse for the company . Development of efficient ETL tool using PL / SQL (Sybase) to migrate data from production transactional system to staging environment and creation of FACT and DIMENSION tables to create the star schema based DW for premium and claims data across lines of business.
Project 3: Implementation of portfolio analysis for various lines of business: Project manage Design, development, implement acturial portfolio analysis for personal lines. Designed development of ETL scripts that incrementally update the data mart for PL, massage, cleanse and standardize dimensions
Project 4: Implmentation of Quickstart - Sales and Marketing CRM - Project manage Implementation and customization of quickstart - sales and marketing crm, design of data mart, design of efficient processes for data transfer from source to target, maintain audit trails, detailed data base design and data modeling, design of reports and cubes.
Project 5: Implement Cognos IWR and Powerplay PPES - project manage Installation, cognos iwr - impromptu web reporting. This has helped Stabilizing and standardized the reporting environment. The focus has been on minimizing the use of adhoc reports by users and consolidating the company MIS dw BI .
Project 6: CRM- Single image of customer - Initiated ‘Single image of customer’ project across the organization for effective implementation of CRM. Have conducted meetings and discussion with stakeholders to map “as is” processes and suggested improvements on the same. Effectively demonstrated the benefits of the new improved process for effective implementation of CRM .
have worked for various clients in usa / ireland - dublin / kenya from 1999 thru 2001/2
• Client - Kindle Banking Systems - Dublin / Ireland
• Role - QA analyst.
• Domain - Banking
• Jan 1998 - Aug 1998
• Environment : VB 5.0, Oracle 7.3, MF-cobol, C, Btrieve, UNIX AIX, NT 4.0
• Develop test scripts and conducted module and system testing for banking software - BRANCHPOWER.
• Maintenance programming on existing Branchpower, Bankmaster and TPS software .
• Develop, design and implement training modules .
• Client -Standard Chartard Bank - Kenya
• Role - Software Implementation of BRANCHPOWER.
• Domain - Banking
• Nov 1998 -Dec 1998
• Environment - VB 5.0, Oracle 7.0, MF-cobol, Btrieve, UNIX AIX, NT 4.0.
• System testing and implementation for Y2K compliance in 32 branches in Kenya
• Installed software for clients and provided on-site support and user training.
• Supported existing clients and resolved critical issues/problems in a timely fashion.
• Maintenance programming on existing Branchpower software.
Client: ADP - Long Island - New York, USA
Position : Technical Team Leader.
Domain : Dealer Services.
• Jan 1999 - April 2000
• Environment - VB 6, VBA Oracle 7.3, NT 5.0, UNIX AIX, MS-Access, FTP, Cognos 6, MS - project.
• Design, Develop and implement new reservation system - conversion from COBOL to VB. Project Management experience to lead team of 8 .
• Develop new reporting solution using cognos - migration from excel to cognos.
• Conversion of existing excel / access Reports.to cognos
• Maintain existing dealer services systems.
• Experience in Project Leadership and User Interface.
Employer : 24/7Media - Bethesda, Maryland - USA.
Position : Senior consultant MIS.
Domain : Internet Advertising
May 2000 - Jan 2002 .
Environment: Business Objects 5.1 - Reporting, Designer & Data mining tools, Oracle 8i, NT, Unix AIX, RS 6000, FTP, SQL+, MS-project.
• Analysis, design, development and implementation of sales and marketing, warehousing and Inventory control software across 32 warehouses and 6 regional offices. Data audit and control in HO, top management reporting using EIS & D2K Reports and participated in Data communication software implementation.
• Build a DATAmart for Sales and Marketing Information system with data coming from 32 warehouses and 6 regional offices across the country
• Implemented GIS software ( Market Map) in 6 regional offices, to monitor sales forecasting, market coverage and penetration, improve sales by tapping new markets. Developed tools for linking company data to existing maps for top management sales planning and production planning .
• As part of the SAP R/3 team, working with Arthur Anderson consultants, Solely responsible for data mapping from the warehousing legacy system to the new SAP R/3 system .
• Design, Develop and implement sales and marketing information system for prize money calculation for salesmen, production planning and marketing.
• Maintenance of existing warehousing, Base Quota and Marketing Information system for generation of top management reports.
• Development & Implementation of Mobile Order Booking system ( using LAPTOPS ) for salesmen using file interfacing between Clipper and cobol.
• Development of batch processes for monitoring file transfers, updates, maintenance of logs and reporting system for errors in data communications.
• User training for Regional offices, warehouses and sales office personnel for various in-house systems and software.
• VBA scripting for generation of automated charts for marketing information system.
• Experience in Project Leadership.
SYSTEMS ANALYSIS AND DESIGN PROJECT MANAGEMENT PROGRAMMING LOGIC AND CREATION OF DFD'S