Lalu Thomas Vazhekatt
Coppell TX 75019
Work Authorization: U.S. Citizen
Masters in Computer Applications (MCA) – Bharathiar University, Coimbatore, India.
Bachelor of Science (B.Sc.) – Calicut University, Calicut, India.
Awards and Recognition:
US Patent: System and Method for Off-Net Planned Cost Derivation, Analysis, and Data Consolidation.
·More than 20 Years of experience in Analysis, Design, Development, Implementation and Support of Data Warehouse solutions and Enterprise Applications using Oracle technologies in multiple domains including Database marketing, Telecommunications, Animal Health, ERP, Data Quality and other areas.
·12+ Years development experience in Oracle PL/SQL, SQL Loader, Unix Shell scripts, Oracle Forms and Reports.
·Worked extensively in Oracle backend utilizing various Oracle capabilities including Tables, Indexes, Constraints, Packages, Stored procedures, Functions, Triggers, Collections, Bulk Collect, Dynamic SQL, External Tables etc…
·Experience in developing ETL solutions using Talend, Informatica, Oracle and Unix Shell.
·Performed Development lead role to build Operational Data Store (ODS) for telecom Inventory, Access and Network Expense domains and migrating data from multiple legacy systems into ODS.
·As a Data Warehouse Architect, provided architecture support to multiple Data Warehouse projects from inception to implementation.
·Worked in Agile (Scrum) environment as Scrum Master on various telecom data warehouse projects working with product owners and multiple development teams.
·Awarded US Patent for end-to-end Architecture work on System and Method for Off-Net Planned Cost Derivation, which brought in additional nearly $10 Million annual savings in Network Expense.
·Worked in PeopleSoft HRMS and Financials modules as well as in Siebel.
Oracle 12c, SQL, PL/SQL, SQL*Loader, Oracle Forms
Unix Shell scripts
Toad, SQL Developer
ETL – Talend and Informatica Power Center 9.1
Microsoft Project, Visio, Rally Software, Erwin Data Modeler
PeopleSoft 7.5, Siebel99, Java, Visual Basic
Data-Axle, Dallas, TX –Lead Database Developer (Sep 2014 – Present):
Worked as a lead ETL Developer/Data Analyst working on loading customer data into Oracle database using Talend, PL/SQL and shell scripts.
Made use of the capabilities of Talend ETL tool for validating and loading client data files into database as well as for the automation and scheduling of jobs.
Effectively used of Oracle features such as Packages, Procedures, Functions, Indexes, Table Partitioning, Collections, Analytical functions etc.
Used Oracle Table Partition for automated high performing data archival and retention.
Worked on mapping customer details such as personal info, purchase behavior, etc… into Marketing Intelligence Data Warehouse tables.
Participated in initial mapping, cleansing and loading of new customer legacy data.
Supported Marketing Database for multiple clients such as Silverstar Brands, Universal Screen Arts, Honeywell, USO, Bridgestone etc…
Acquired customer domain data from various sources including USPS and matched and merged the data at individual and household level.
Performed Analysis and data mapping to acquire legacy Customer and Sales data and integrated into Infogroup’s Campaign Management Data Warehouse system.
Developed process to automate Talend, Oracle and shell script jobs for weekly data processing.
Environment: Oracle, SQL, PL/SQL, Shell scripts and Talend
Level (3) Communications, Broomfield CO –Architect / Scrum Master (Feb 2011 – Aug 2014):
Worked as a Data Warehouse (DW) Domain Architect for Inventory imperative, Attained Planned Cost and Access Management.
Managed Data Warehouse impact due Legacy Broadwing inventory conversion into Telcordia Granite by identifying all impacted downstream systems and proposed architectural solution and implemented those changes working closely with Development teams.
Worked on identifying DW impact due to legacy Global Crossing inventory systems EON into Telcordia Granite migration.
Provide architectural support for on-going development of Access Management applications such as Access Mediation Layer (AML), Attained Planned Cost (APC).
Scrum Master and Architect for Attained Planned Cost Program (APC)
Developed SQL queries and PL/SQL scripts to analyze data and create test data.
Attained Planned Cost Data Mart generated nearly $10M in disputes per year.
Identified and implemented legacy system migration impact to Corporate Data Warehouse (CDW) involving multiple domains such as Network Inventory, Telephone Number, Access Service Request (ASR), Access Mediation Layer (AML), etc…
Implemented Operational Data Store for Trunk Group sourcing data from Telcordia Granite.
Awarded Patent from US Patent Office for Attained Planned - System and Method for Off-Net Planned Cost Derivation.
Developed a Data Quality Layer to correlate Off-net data keys so that cost variation during different phases of the circuit life cycle can be determined.
Managed Informatica PowerCenter upgrade to 9.0 for hundreds Informatica Mappings.
Environment: Oracle, SQL, PL/SQL, Shell scripts, XML, ETL, Informatica Power Center, Microsoft Visio, Microsoft Project.
Level (3) Communications, Broomfield CO – Software Architect ( July 2008 – Jan 2011):
Managed large teams with direct reporting employees and both onsite and offshore outsourcing teams.
Helped to stabilize the initial phase of Outsourcing model at Level3 by leading multiple teams across several development and support projects.
Worked as Dev lead and Architect for building Operational Data Store (ODS) for Network Inventory data acquiring from Telcordia Granite, Telcordia TNE and many other legacy systems from the acquired companies.
Worked with business stakeholders of both legacy and target state systems to generate Standardized Lookup values to improve Data Quality of the migrated data.
Built Decision Support Layer (DSL) for Trunk Group Inventory data.
Responsible for building Operations Data Store for Inbound and Outbound Access Service Requests (ASR) sourcing from Synchronoss Service Request Management platform. Managed the data conversion of legacy ASR data into the ODS.
Developed PL/SQL package to extract CLLI data from External Circuit ID and apply logic to clean the A & Z end data and to flip location info if needed.
Implemented Netsure (Oracle) - Network Optimization, Capacity Planning Data Mart for Access Management Organization which brought in $3M Netex Synergy savings annually.
Lead a large offshore and onsite team to convert legacy Wiltel asset data from Siebel 6.5into Siebel 7.8.
Responsible for building Access Mediation Layer (AML) from Inception to Implementation working as Dev lead and Architect. AML is a Decision Support Layer supporting all reporting needs for Offnet Inventory, fetching data from various Operational Data Stores for Vendor Billing (Netex), Network Inventory, Access Service Request, Order Entry, Workflow etc and correlating them to make decisions on building Network Capacity versus leasing it.
Implemented Circuit Variation Reporting (CVR) to identify variations in Offnet Order from Order to Provisioning and Billing.
Environment: Oracle, SQL, PL/SQL, Shell scripts, XML, ETL, Informatica Power Center, Microsoft Visio, Microsoft Project
Level (3) Communications, Broomfield CO – Software Engineer Principal ( June 2006 – June 2008):
Responsible for Design, Development and implementation of Metro Access Research System (MARS) to support Mergers & Acquisition (M&A) by calculating Network Synergy which resulted in Level3’s acquisition of Broadwing Communications for $1.39 Billion.
Created several Oracle PL/SQL scripts and stored procedures to pull data from Vendor Billing systems and loading spreadsheet data from potential candidate M&A opportunity.
Created pl/sql procedure to send request and receive response XML messages to and from Web services to obtain most optimal solution for Network Routing.
Created Shell scripts to automate and cron database jobs.
Developed test plan and conducted tests on data marts.
Provide production support for the MARS applications..
Environment: Oracle, SQL, PL/SQL, Shell scripts, XML, ETL, Informatica Power Center.
Lockheed Martin IT - Lead Oracle Developer ( Sep 2004 – June 2006):
Client: USDA, APHIS, Veterinary Services, Fort Collins, CO.
Lead a team of Oracle developers for various animal disease programs.
Legacy data migration for Chronic Wasting Disease (CWD) program using External tables and pl/sql.
Scheduled data load using shell scripts.
Designed architecture to launch forms applications for various animal disease programs from one launching pad.
Developed new forms and modified existing forms using Oracle Forms Builder 10g.
Used Oracle Application Server 10g to host Oracle Forms on the Web.
Developed JSP pages for various disease programs accessing data from Oracle database.
Worked on XML message communication between USDA and various veterinary diagnostic labs using Rhapsody.
Environment: Oracle Forms Developer 10g, Oracle Application Server 10g, Oracle 9i database, PL/SQL, Shell scripts, XML, JSP, JDeveloper.
Sun Microsystems, Broomfield, CO. – Senior Software Engineer (Oct 2000 – July 2004):
Worked of various projects/applications such as DataICE, DQI, and Contact Cleanup. Major responsibilities include Analysis, design and development of data quality measurement and data cleanup tools. Worked as a Project Manager for DataICE project.
All these applications are developed using advanced features of PL/SQL. Created various stored procedures, triggers, created materialized views on the remote data warehouse. Worked on data warehouse and conducted SQL performance tuning. Employed Parallel Execution techniques to improve the performance of queries and DML statements. Used External Tables for data loading. Following are the applications/tools developed while working at Sun Microsystems:
·DataICE: DataICE foundation aims to build a data quality measurement framework to enable the view of three key data quality attributes (ie. Integrity, Completeness, Effectiveness) from the dimensions of customer, product, and operational performance.
·Data Quality Index (DQI): The objective of this project is to measure the quality of data pertaining to Sun's global case management System (Radiance) and Contract First! Applications.
·Contact Cleanup: This project is to archive and purge those contacts, which are not linked to any active contract in the Contract First! Application.
·Global Customer Identification – SAS customer Changes:
This project is to facilitate special treatment to Strategic Customers in the Contract First! Application.
Optimos Inc., Chantilly, VA. (Sr. Software Engineer) Feb 1999 – Sep 2000:
Client: Geneva Pharmaceuticals, Inc, Broomfield, CO.
Siebel Consultant (Jul 2000 – Sep 2000)
Developed an interface between SAP and Siebel using Siebel Tools.
Environment: Siebel 99, Siebel Visual Basic, Oracle 8.0, Actuate.
Client: Anderson Consulting, Englewood, CO.
Oracle Consultant (Mar 2000 - Jun 2000)
Worked on the reports of Health Care Management system for pacific care. Primary responsibility was to improve the performance of the SQL queries in the benefit reports. Performed SQL Tuning on the Oracle queries in 17 Crystal Reports.
Environment: Oracle 8.0, SQL, PL/SQL, Seagate Info (Crystal Report, SQL Designer).
Client: Resort Computer Corporation, Lakewood, CO.
Oracle Consultant (Jul 1999 - Mar 2000)
Developed PL/SQL procedures & functions and Oracle forms & reports using Developer 6.0 for the hospitality industry application called RCC Premier. Performed data modeling using Erwin. Created an interface between RCC Premier application and PBX and Point of Sale (POS.). Worked on data migration from Legacy system to Oracle using SmartDB Workbench.
Environment: Oracle Developer 6.0, Oracle Application Server, SmartDB and ERwin
Client: Optimos Inc., Chantilly, VA.
Siebel Consultant (May 1999- Jul 1999)
Completed Siebel 99 Sales Enterprise In-house Implementation utilizing Siebel Rapid Application Development Methodology.
Environment: Oracle 8.0, People Tools, Crystal Reports, and SQR
Client: American Council for Education (ACE), Washington D.C.
PeopleSoft Consultant (Feb 1999 - Apr 1999)
Did customization on the Vanilla PeopleSoft Financials and HR modules. Generated various reports using SQR and Crystal Reports.
Environment: Oracle 8.0, PeopleTools, SQL/SQR, PeopleCode, Process Scheduler and SQR.
Wipro Systems, Bangalore, India. (Sr. Systems Engineer) Jan 1998 – Jan 1999:
Client: Bytel, UK
Worked on migration of the application Subscriber Management Systems (SMS) from Ingress to Oracle. Developed coding standards for Oracle Developer 2000 and PL/SQL. Provided technical support on Developer 2000, PL/SQL and SQL performance tuning for a team of more than 100 developers. Developed various libraries for application and Administrative Module for SMS application administrative persons.
Environment: Oracle 7.3, PL/SQL and Developer/2000
Indus Valley Software Solutions, Chennai, India. (Systems Analyst) Aug 1995 – Jan 1998:
Client: VERO President Systems Ltd., Bangalore, India. (Sep 1996 - Jan 1998)
Worked as a Team Lead for the application Enterprise Management System (EMS). Participated in analysis, Design, development and implementation using Oracle 7.3, Developer 2000 and PL/SQL. Following are the various modules developed for VERO President Systems:
·Goods Inward - GRN (Goods Receipt Note) is prepared with details regarding Supplier, Delivery Challan, Excise Gate Pass, and Purchase Order.
·Purchase Systems - It maintains supplier details. Generates and maintains Purchase Requisitions, Quotation, Purchase Order and Rate Contract.
·Inventory Control System - Module captures all receipt and issue transactions made through different documents like Goods Receipt Note (GRN), Stores Return Note (SRN), Stores Requisition (SR), Sub-contract Shipping Memo, Production Credit Note (PCN), Stores Transfer Note (STN), Work-in-Progress Credit Note (WCN), and Work-in-progress Issue Voucher (WIV).
·Bill of Material - System maintains details about all products and components, route card for material specifications, structure master, tool cards to have list of tools for various operations of the route cards and machine master to have details of different machines.
·Worked as Oracle DBA. Created and managed development database on NT and production database on HP UNIX. Created roles for various users. Created users and assigned roles to them. Created and managed database objects like views, Synonyms, Sequences and Performed SQL optimization.
Environment: Oracle 7.3, Enterprise Manager, PL/SQL, Dev 2000 and ERwin on Windows NT using Pentium and HP Net Server E 40.
Client: Widia Ltd. Bangalore, India. Mar 1996 - Aug 1996
Participated in the development of an enterprise application called Material System which take care of Procurement, Inventory and Good receipt for a manufacturing unit using Oracle, PL/SQL and Developer 2000.
Environment: Oracle 7.1 with Developer/2000 and DG UNIX using Pentium and DG Aviion Super Mini.
Client: Festo Controls, Ltd. Bangalore, India. (Aug 1995 - Feb 1996)
Developed Accounts Payable module for the application Integrated Manufacturing System (IMAS). Developed an interface between Procurement module and Accounts Payable module. Handled various types of bills such as Local, Foreign and Service Bills.
Environment: Oracle 7.1 with PL/SQL, SQL*Forms 3.0, SQL*ReportWriter 1.1, SQL*Menu 5.0, Pro*C, and HP UNIX using HP 9000.