Project Sales

Hari Lagad

*******@*****.*** ● Washington DC

________________________________________________________________________________________________________________________________________________________

EXECUTIVE SUMMARY:

• Over 15 years of extensive IT experience in System-Life-Cycle including Analysis, Design,

Development, Integration, Deployment, QA, Documentation, Support and Migration

• 4+ years of specialization in developing Business Intelligence and Data Warehousing

applications with hands-on experience in Business Objects (Reports, Designer, Web

Intelligence and Info View) and Crystal Reports

• Expert in optimizing, debugging and testing SQL queries, views and stored procedures written in

Teradata, Sybase, Oracle, SQL Server and MySQL

• Good knowledge of ETL utilities in Teradata, Oracle and Sybase. Familiar with Informatica 8.x

• Experienced in migrating reports from Crystal 10.x to Business Objects XIR2

• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice

and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks

• Proven ability in creating complex reports by linking data from multiple data sources, using free

hand SQL, stored procedures and functionalities like Combined Queries

• Used Crystal Reports for creating complicated reports including sub-reports, parameter based

reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports,

data reports along with LOV

• Good in communicating with business users to analyze the business process and requirements

and transforming requirements into work statements. Experienced in effort estimation, impact

analysis and project timeline

• A committed team player with strong communication and leadership skills. Analytical thinker who

strives to devise creative solutions for challenging business needs of clients

TECHNICAL EXPERTISE:

RDBMS: Teradata V2R6/V2R5/V2R2, Oracle 10g/9i/6i, SQL Server 2005, Sybase 11.x, MySQL 3.x

DW/ETL/BI: Business Objects XIR2/6.x/5.x, Crystal Reports 10.x/9.x/6.x, Informatica 6.x

OS: UNIX AIX, HP-UX, Sun Solaris, Linux, Shell Scripting, CRON, Windows, DOS

Languages: SQL, Teradata SQL, PL/SQL, Pro* C, T-SQL, C, Java, VB, PASCAL, COBOL, Clipper, UML

Web: HTML, XML, JavaScript, CSS, MS FrontPage

Other Tools: ErWIN, ClearCase, Teradata SQL Assistant, SQL Developer, TOAD, Rapid SQL, MS Visio

Industry: Health Care, Finance, Technology, Retail, Hospitality, Government, Manufacturing, Agriculture

EDUCATION:

Bachelor of Engineering (Mechanical), SP University of Gujarat, India

PG Diploma in Business Management, Baroda Mgt. Association, India

CERTIFICATION AND TRAINING:

Teradata Certified Professional V2R5, NCR Dayton, OH. USA

RDBMS using ORACLE by CMC Limited, New Delhi, India

PG Certificate in Product Engineering, MS University of Baroda, India

Page 1 of 5

PROFESSIONAL EXPERIENCE IN USA:

Client: Kaiser Permanente, BI Application Developer, Silver Spring MD Dec 2007 – Present

Project: Consolidation of customer data received from different source systems for query, analysis and

reporting

• Participate in project planning sessions with project managers, business analysts and team

members to analyze business requirements and outline the proposed solution

• Extract data from legacy systems and different transactional databases such as purchase order

system and inventory control using Teradata ETL Utilities

• Create reports containing varied information using Crystal Reports 10.x

Develop critical reports like drill down, slice and dice, master/detail for analysis

• Create complex reports including sub-reports, graphical reports, formula base and well-

formatted reports according user requirements

• Migrate/upgrade Crystal Reports 10.x and Business Objects 6.x to Business Objects XIR2

• Build new universe as per the user requirements by identifying the required tables from Data

Mart and by defining the universe connections

• Develop universe user documentation guide for the end users reference

• Use BO Report Services to develop key reporting metrics including reports for sales forecast,

contractor accruals, trend analysis and SOX reporting

• Address data privacy issues and issues arising out of regulatory and HIPPA compliance

• Cross-train business users and other team members

Environment: Business Objects XIR2, Crystal Reports 10.x, Teradata V2R6, Oracle 10g, SQL Server

2005, Teradata SQL Assistant, RapidSQL, Clarity by Epic, Remedy TeamTrack, Lotus Notes 7.x,

Windows, Novell Enterprise Wide Area Network with Distributed Data

Client: Swift Technologies, BI Team Lead, Centerville OH Jan 2007 – Dec 2007

Project: Lead BI/DW projects and leverage business development activities

• Setup professional teams and processes for providing BI/DW Services to regional clients

• Conduct and train BI/DW Consultants in development teams

• Use Agile methodology to manage multiple BI/DW efforts operating simultaneously

• Perform requirements elicitation, impact analysis and effort estimation

• Assist developers in analysis of business requirements

• Prepare system documentation, test procedures and test strategy

• Provide implementation support during migration process

• Prepare knowledge repository and conduct knowledge transfer sessions

• Setup best practices for BI/DW Services with proven development methodologies

• Perform business development and account management activities

Environment: Business Objects 6.x, Crystal Reports 9.x, Teradata V2R5, Oracle 10g, Sybase 11.x,

Informatica 6.x, Teradata SQL Assistant, RapidSQL, TOAD, ClearCase, ErWin, MS Visio,

W indows

Client: NCR Corporation, BI/DW Consultant, Dayton OH Feb 2005 - Dec 2006

Project: Re-build strategic planning and resource management EDW to deliver accurate information in

timely fashion and improve overall productivity of business processes

Page 2 of 5

• Interact with business analysts and users to identify enhancement requirements, transform

requirements into technical specifications, design a solution and create an implementation plan

• Coordinate with DBA for migration of existing objects from Oracle DW to Teradata DW

• Load data into Teradata DW using Teradata utilities such as FastLoad, MLoad and TPump

• Optimize performance by tuning queries, eliminating data redundancy and minimizing data

instantiation

• Create reports using Business Objects that contain charts and graphs for management

illustrating resource utilization and cost distribution

• Provide the security access management by creating users/groups and folders

• Provide technical expertise in developing complex SQL queries for ad-hoc reporting

• Plan and execute periodic disaster recovery exercises

Environment: Business Objects 5.x, Teradata V2R5, Oracle 9i, Teradata Utilities, MS Visio, Windows,

NCR Unix V4, Shell Scripting

Client: Keshav Corporation, Database Application Developer, Eaton OH Jan 2003 - Oct 2004

Project: Develop a customized accounting and reporting software system to consolidate cash-flow,

occupancy forecasts, room-rate planning and customer feedback from multiple data sources

• Design and develop database for customized reporting software

• Create DB objects such as tablespaces, profiles, roles, grants, users, views, tables

• Implement business logic using packages, stored procedures, functions and triggers

• Load data from external files using SQL*Loader and import/export utilities

• Tune queries to optimize performance using EXPLAIN PLAN and diagnostic tools

• Install and configure Crystal Enterprise 6 on Windows 2003 server and multiple client editions

on Windows XP terminals

• Use Crystal to generate various types of reports for management that illustrate consolidated

cash-flow, occupancy forecasts and room-rate planning from multiple data sources

• Support and maintain Oracle DB and Crystal Reports in production

Environment: Oracle 9i, SQL Plus, TOAD, Crystal Reports 6.x, Windows

Client: W eb Vision Inc, Senior Database Developer, Los Angeles CA Jul 2002 - Dec 2002

Project: Develop an online gift shop and support desk mailing system

• As a team, design and develop major aspects of Software Development Life Cycle (SDLC)

including requirements elicitation, architecture (MVC), design, development (Waterfall),

integration, testing, deployment and support for an online gift shop

• Design operational flow of support desk mailing system based on feedback from business users

using flowcharts and test cases

• Data mapping and normalization using ER model to optimize data relations and dependencies

• Leverage front-end development in HTML/Java for auto mailing module of support desk system

• Participate in code reviews, design presentations and progress meetings

• Assist in design and specification of test plans

• Post-installation defect fixing and business request processing

Environment: MySQL 3.x, HTML, JavaScript, CSS, Java, Linux, Apache, ErWin

Page 3 of 5

Client: NCR Corporation, Teradata Consultant, Dayton OH Feb 2000 - Jun 2002

Project: Maintenance and upgrade of enterprise-wide global database for online timekeeper application

• Collect system program inventory and perform impact analysis and strategic planning

• Design, develop and implement three interfaces to Timekeeper from [Payroll / Project / Finance]

• Merge regional databases into a single global timekeeper database using ETL utilities

• Address data integrity issues and issues arising out of global data federation such as currency

and time zone differences

• Coordinate with data warehouse custodians for data transfer and data security aspects

• Generate analytical reports for man-hours allotment to sales, services and projects

• Convert COBOL applications to Teradata packages and shell scripts to overcome legacy

• Performance monitoring and tuning of database structures and SQL queries

• Unit test and write QA test plans for integrations testing of interfaces developed

• Automate concurrent and serial job scheduling using CRON

Environment: Teradata V2R2, Oracle 8i, DBArtisan 4.02, Teradata SQL Assistant, SQL Plus, Report

W riter 2.x, NCR UNIX V4, Windows

Client: Sterling Inc, Database Developer, Akron OH Jun 1998 - Nov 1999

Project: Build online credit verification for jewelry sales system

• Interact with business users and analysts for requirements elicitation

• Logical and physical design of Oracle DB for Sales System

• Design and develop of customer feedback forms using Oracle Forms

• Develop reports for management and application administrator using Oracle Reports

• Implement business functions using packages, procedures, functions, records and cursors

• SQL tuning for performance enhancement

• UNIX shell scripting for development and production jobs

Environment: Oracle 6i, Utilities, Oracle Forms/Reports 6i, SQL, PL/SQL, Pro* C, HP-UX, Windows

PROFESSIONAL EXPERIENCE IN INDIA:

Employer: NDDB, Sr. Systems Executive, Anand Gujarat Jun 1984 - Apr 1998

National Dairy Development Board (NDDB) is the largest dairy cooperative in India. Visit: www.nddb.org

Project: Support computer applications for payroll, personnel care, accounting and marketing

• System-Life-Cycle including analysis, design, development, integration, deployment, QA,

documentation, support and migration of payroll and accounting systems.

• Data modeling, physical and logical DB design. Unix server and DB administration.

Environment: Oracle 6i Forms/Reports, Developer 2000, PowerBuilder, PowerDesigner, Clipper,

W atcom, MS Office, System Engineer [CASE tool], WIPRO Mini, DEC Alpha AXP, UNIX [OSF/1, SCO,

XENIX] Windows 3.x, 95, 98 Micros PC, DOS, NetWare, Unify, System V, FoxPro, C, COBOL

Major Accomplishment: Implemented a uniform accounting system for nation wide dairy projects

Employer: GNVFC, Assistant Manager (Systems), Bharauch Gujarat Oct 1983 - Jun 1984

Page 4 of 5

Gujarat Narmada Valley Fertilizers Company (GNVFC) is the biggest fertilizer and industrial chemicals

manufacturing company in state of Gujarat. Visit: www.gnvfc.net/

Project: Automation of customer invoicing and payment processing

• Lead projects and cross-train team members/business users.

• Oversee logistics, documentation and conformity to business procedures.

Environment: FoxPro, Clipper, Unify dBase III+, COBOL, BASIC, FORTRAN, Micros PC Family, DOS

Major Accomplishment: Paper work reduced by 30%. Auto invoicing increased revenue by 10%

Employer: Jyoti Limited, Mechanical Engineer, Vadodara Gujarat Jan 1981 - Sep 1983

Jyoti Ltd. is an industry leader in manufacturing electric pumps and hydel systems. Visit: www.jyoti.com

• Product design, process supervision and quality testing

Page 5 of 5

Contact this candidate