Aravind Pillai

Aravind Pillai [email protected]

Senior Informatica Architect

email

: Ph

: 513-923-0129

---------------------------------------------------------------------------------------------------------------------------Professional Summary • • •

•

•

• • •

• • •

• •

• • •

9 years of total IT experience. 5+ years in technical architect roles. PMP certified project management professional. Demonstrated technical expertise in popular business intelligence tools such as Informatica Power Center, Informatica Power Connect and Cognos. Proven experience in leading all stages of system development efforts, including requirements definition, design, architecture, testing, maintenance and support. Provided strategic thinking, solutions and roadmaps while driving architectural recommendations specific to data warehouse applications and business intelligence tools focusing on ETL functions. Performed project level design, data analysis and application performance analysis. Demonstrated ability to clearly articulate technical designs in written communications. Extremely strong in ETL design, development, testing and implementation using tools like Informatica Repository manager, Informatica Designer, Informatica Workflow Manager and Metadata manager. Extensive experience in creation of complex informatica Mappings using Mapplets and reusable transformations. Experience in various COGNOS reporting tools like Impromptu, Transformer, Power Play and Visualizer. Expert level understanding of Oracle database capabilities and DW best practices including appropriate use of indexing, material views, portioning, snapshot capture and referential integrity. Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages. Expertise in implementation of Data Warehousing and Decision Support Systems in Unix/Windows environments. In-depth understanding of data warehousing concepts, Kimball methodologies,including dimensional modeling, star schema design and implementation. Excellent Business Analysis skills, communication skills and problem solving skills. Trained in Six sigma quality processes. Experienced dealing with outsourced technical resources and coordinating global development efforts. Mentored developers by providing technical guidance and troubleshooting assistance.

Technical Skills DBMS Oracle 9i/10g, MS Access Business Intelligence Informatica Powercenter 8.1, Informatica Powerconnect, COGNOS Language PL/SQL, SQL, Unix, Perl, Cobol, Jcl, MQ Series Tools & Utilities: Toad, IBM - Tivoli, MS Project, VSS , Visio, Test Director OS/Environment Windows, UNIX Quality Six-Sigma Trained

Certifications  Project management  Project management  Informatica Powermart/Powercenter  Data Warehousing concepts  Cognos Impropmtu Professional

PMP certified Brainbench certified Brainbench certified Brainbench certified Product Ceritified

Work permit Information Type of Visa : H1B Project Details Project 1 : Algo Risk Implementation Employer : Syntel Inc Client : Allstate Investments, Chicago Role : Project Lead / Senior ETL Architect Duration : Nov 2007 – Till date Technologies DBMS Oracle 10g Business Intelligence Informatica Powercenter 8.1 Language PL/SQL, SQL, Unix, Perl Tools & Utilities: Toad, IBM – Tivoli, VSS , Visio, Test Director OS/Environment Windows, UNIX

Allstate Investments, LLC is an investment management subsidiary of The Allstate Corporation. Algorithmics Market Risk Solution (Algo Risk) was implemented in Allstate Investments to Strengthen risk management areas and fixed income analytics.

Responsibilities • Lead and mentor the ETL team in designing, developing, and delivering ETL framework to implement Algo Risk third paty tool. • Team Management responsibility, Project oversight and expectations management. • Worked with business users to define and document new or changing requirements. • Translated business requirements into technical design for data transformation. • Ensured architectural adherence through blueprint and design reviews. • Developed logical data models and assisted in creating physical data models. • Designed and developed source to target data mappings. Effectively used informatica recommended techniques for complex mapping design and for enhancing mapping performance. • Created complex mappings using Unconnected Lookup, Sorter, Aggregator, dynamic Lookup and Router transformations for populating target table in efficient manner. • Hands on experience with advanced optimization techniques such as concurrent caching, auto memory calculations and push down optimization. • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts. • Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance. • Identifying data lineage using metadata manager. • Developed PL/SQL stored procedures for source pre load and target pre load. • Created Informatica Repository Queries for mappings and sessions documentation • Created Shell Scripts to execute the sessions using pmcmd. • Identifying Performance bottlenecks and fine-tuning ETL mappings and workflows to improve performance. • Developed and executed System integration testing strategies. Conduct peer reviews. • Informatica administration resposibilities including migration of code from Dev to QA and to preproduction staging area. • Co-ordinated pre-release and release processes including change control, contingency and fallback plans, production migration and warranty support. Project 2 : Foreign Trade Zone Development

Employer : Patni Computer Systems Client : GE Aircraft Engines, Cincinnati Role : Senior ETL Architect Duration : Mar 2005 to Oct 2007 Technologies DBMS Oracle 9i, MS Access Business Intelligence Informatica Powercenter 7.1, COGNOS 7.1 Language PL/SQL, SQL, Cobol, Unix Tools & Utilities: Toad, VSS , Visio, Test Director OS/Environment Windows, UNIX GE AE is a business unit of General Electric Company. This unit develops, manufacturers, and distributes gas turbine engines, parts, and components for civil and military aircrafts. This project involve design and development of Inventory/Transaction datamart for implementing foreign trade zone trade program in GE manufacturing plant. Responsibilities • 2 year development project. Part of the team design through Phase 1 implementation. • Served as a Senior ETL architect in defining and developing Inventory data mart. • Primary responsibility include leading the Architecture, design and implementation of ETL framework. • Participated in workshops with various process teams to gather business requirements, define the grain and understand reporting requirements. • Designed ETL architecture to extract transactional data from multiple operational sources and load to a single target oracle database serving as an independent data mart. • Defined various facts and Dimensions in the data mart including Aggregate and Summary facts. • Designed and developed complex mappings using various transformations in Designer to load data from flat files, legacy systems and Oracle database into the target Oracle datamart. • Created complex slowly changing dimensions type II processes using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations • Designed and developed UNIX shell scripts as part of the pre-session and post-session command to automate the process of loading, pulling, renaming and pushing data from and to different servers • Effectively utilized shared/ persistent caching techniques and incremental aggregation strategies to improve performance. • Extensively used Workflow Manager to create connections, sessions, tasks, workflows. • Developed Impromptu reports to facilitate Inventory discrepancy analysis.

• • •

Creation of Cognos Cubes and provide data security using user classes and creation of different dimensional views to create different views for users. Implementation and Warranty support. Informal training and knowledge transfer to GE AVIATION employees.

Project 3 : CAS – BDW Interface Enhancements Employer : Patni Computer Systems Client : GE Transportation, Cincinnati Role : Team Lead / ETL Consultant Duration : July 2004 – Feb 2005 Technologies DBMS Oracle 8i Business Intelligence Informatica Powercenter 7.1, Informatica Powerconnect 7.1,COGNOS 7.1 Language PL/SQL, SQL, MQ Series Tools & Utilities: Toad, VSS ,Test Director OS/Environment Windows, UNIX This project involve enhancement to Supply chain Business dataware house. Designed and developed new interface from Legacy source system to Enterprice Business data warehouse. Responsibilities

• •

• •

• • •

• •

Interacted with business users to gather requirements, created high level process flows and technical design documents. Developed data Mappings between source systems and warehouse components using Mapping Designer. Extracted sales order transaction data from MQ series messages and loaded to oracle target tables using power connect. Worked extensively on transformations such as MQ series source qualifiers, Sorter, Router, Union, Joiner, Filters, Router, Normalizer, Expression and Aggregator to load data. Used Debugger to test and fix bugs in the mappings. Created and configured MQ series workflows. Mappings were designed to cater the slowly changing dimensions (S.C.Ds). Developed several reusable transformations and mapplets that were used in other mappings. Created workflows, worklets, email/commands and sessions. Involved in Performance Tuning of Informatica. Done ETL mapping unit testing, UAT and also developed test plans.

• • •

Developed SQL test scripts for integration testing. Wrote PL/SQL Packages and Stored procedures to implement business rules and validations. Used the informatica Scheduler to schedule the weekly, daily data loads

Project 4 : Consolidated Application Systems (CAS) Employer : Patni Computer Systems Client : GE Transportation, Cincinnati Role : Module Lead Duration : Sep 2002 – June 2004 Technologies DBMS Oracle 8i Business Intelligence Informatica Powercenter 7.1 Language PL/SQL, SQL, COBOL, JCL ,VSAM Tools & Utilities: Toad, VSS ,Test Director OS/Environment Windows, UNIX GE uses CAS mainly for recording information on Bill of Materials / Product Structure, Inventory management, Shipping and Receiving functions. This project involve customization of CAS applications and development of new interfaces. Developed ETL interfaces to Planning system and Warehouse management system using Informatica tools. Responsibilities • Design and develop Mappings using various transformations such as Aggregator, Router, source qualifier, Normalizer, Filter, Sorter, transaction controls and Union. • Created reusable components using mapplets. • Creation of various tasks such as Sessions, Commands, Assignment, Decisions, Event raise and Event waits. • Designed and developed Oracle PL/SQL scripts for Data Import/Export. • Developing and scheduling sessions, tasks and workflows using workflow manager. • Performance tuning the mappings to reduce the load time. • Unix scripts for screen door programs. • Code reviews and Testing for peer’s mappings / workflows. • Create, update and maintain ETL technical documentations and facilitate in migration efforts. • Troubleshoot and resolve application issues. • Quality control activities. Project 5 : Integrated Spares and Support Equipment System (ISSES)

Employer : Patni Computer Systems Client : GE Transportation, Cincinnati Role : Programmer Duration : May 2001 – Sep 2002 Technologies

DBMS

Language Tools & Utilities: OS/Environment

COBOL, JCL ,VSAM, IDMS, ADSO,SQL Toad, VSS ,Test Director Windows, UNIX

ISSES was initiated in 1982 as a means of reducing inventory levels while retaining the flexibility to meet customer demand for GE spares business. ISSES system encompasses activities in Spares support such as Order Acquisition, Customer and Contract maintenance, Order maintenance, Material allocation, Warehousing, Billing, Commercial Invoicing, Military Spares Invoicing and Cost Price History. Responsibilities • Analysis of requirements. • Construct programs based on specs. • Create and execute unit test plans. • Document new programs written. • Mentoring new team members. Project 6 : Constructions cost estimator - Development and support Employer : Printec Computer Academy, Kerala Role : Programmer Duration : Feb 1998 – Sept 1999 Technologies Language Tools & Utilities: OS/Environment

Foxpro AUTOCAD, STAD, MS Excel Windows

This project involved design and development of cost estimator for constructing roads and buildings. This software was mainly used by local authorities and building contractors. Responsibilities • Analysis of requirements. • Construct programs based on specs. • Create and execute unit test plans. • Document new programs written. • Assist clients in design and cost estimations.

Education Masters from Kerala University, 2001 B Tech from Kerala University, 1997