Lavanya Manickavachakam

Senior Business Intelligence Lead

Work History

Work History
Oct 2011 - Present

Senior Bi Administrator/reporting

BI
UNITED WATER-Senior Administrator/Reporting /Lead Data Architect Key Responsibilities: Business Intelligence Lead. Responsible for the successful end-end implementation of the Business Intelligence solution using Business Objects Suite of Products for a 40 million dollar Customer Information System project spanning 2+ years and 31 Business Units across the United States Playing a pivotal role in the development of data warehouse for Customer Care and Billing System.
Oct 2005 - Oct 2011

Programmer Analyst

Everest Consulting Group
Programmer Analyst Key Responsibilities: Installed and Configured Data Integrator XI R2 Worked on Business Objects Designer suite including, creating semantics layers, with Class & objects, drill-down hierarchies, created new derived objects, shortcut joins, defined alias tables and contexts Created advanced and complex Business Objects reports using Universes, Used the Drill Down/Up functionality to analyze data in Web I. Designed highly efficient solutions such as having one report refresh scheduled for multiple Business Units, having the same report fetch monthly or daily data based on the parameter types. Created ETL jobs in Data Integrator using various data cleansing functions to load data from different legacy systems to datamarts. Used transformations such as Table Comparisons, Case, Pivot, Lookup transformations and scripts to send appropriate email notifications and backup the files. Played a key role in the PeopleSoft Reporting Project and responsible for various key activities in the entire project lifecycle. Performed a detailed comparative study between Business Objects/Data Integrator XI R2 environment and SQL Server 2005 environment. Created a BI Tool Scorecard and evaluated the two products against various technical features and capabilities. Interacted with users and collected the user feedback on various tools. Modeled the data marts based on various functional areas such as General Ledger, Asset Management, Payroll, Procurement and Accounts Receivables. Identified the facts and dimensions for the star schema data models. Created customized dimensional tables for various hierarchical structures in PeopleSoft databases. Created a data dictionary giving unified, unique user friendly names for all selected entities in the PeopleSoft database. Designed and developed cubes for various functional areas such as AR, Payroll, General Ledger, AM etc. using SQL Server Analysis Services. 3M HealthCare Business-Reporting Lead
Mar 2003 - Jul 2004

Web Developer

Honeywell Aerospace
Phoenix, Arizona-Reporting Lead Key Responsibilities: Designed and developed star schema dimensional model for various datamarts such as Customer Service DataMart, ERB Data Mart, GMS DataMart and HAT ODS and operational datastores Developed Oracle PL/SQL stored procedures to populate dimension table and fact tables Responsible for developing critical reports using features like Drill down, Slice and Dice, Master/Detail for analysis using Business Objects 5.1. 7. Created trend charts and reports using Business Objects 5.1. 7. Developed complex Business Objects Reports with Business Objects SDK to use controls such as Calendar Control for user inputs, calling stored procedures to enhance the report functionality. Developed complex reports some of which span multiple databases, multiple universes & multiple data providers. Created Control tables to be used by the SQL Loader utility to load flat files into oracle tables. Involved in writing Unix Shell Scripts to load flat files into oracle tables using SQL Loader utility. Developed web reports using ASP from DB2 databases JdEdwards Responsible for coding of common utility functions for Julian date conversions, export to excel feature using VB Script and Java Script.
Oct 2002 - Mar 2003

Software Engineer

Caritor India Pvt Limited
Software Engineer,, India Key Responsibilities: For the Guildpro product, developed classes in Visual Basic 6.0 for System Maintenance Module, Invoice Module, Appraisal Module Coded stored procedures in MS SQL Server 7.0 to implement the business logic and updating Data. Created transformations in DTS for migration of data between databases from MSDE to MS SQL Server 7.0
Jun 2001 - Sep 2002

Software Engineer

Zenith Software Technology(India) P Ltd
Software Engineer,, India Key Responsibilities: Designed and developed user Interfaces for various modules using Visual Basic 6.0 Responsible for writing stored procedures in MS SQL Server 7.0 to implement the business logic and updating data..