Alwin Buthello
469 422 1407
Sr. ETL Developer
PROFESSIONAL SUMMARY:
· 12+ years of professional experience in IT, and the past 9+ years spent primarily on
Data warehouse projects using Informatica Power Center Server, Hadoop EcoSystem, IDQ, Business Objects, Cognos, Teradata, SQL Server and Oracle on UNIX and Windows platforms.
· Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor).
· Experience in Data Load with Informatica CDC (Change Data Capture).
· Experience in Teradata with Fast Load, Multi Load and BTEQ.
· Experience in Hadoop Components using Spark, Python, Sqoop, Oozie, Hive etc.
· Experience in SQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
· Experience in DataStage implementations, Development and support.
· Experience in Oracle Procedures.
· Experience in file transfer thru SFTP and B2B.
· Experience in UNIX and Windows programming.
· Used Tidal and Tivoli for job scheduling tool.
· Experience in developing Data Model using Kimball and Agile methodology.
· Experienced in full Software Development Life Cycle (SDLC) process.
· Experience in working on Tableau.
· Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, Star , Kimball and Snowflake schema database design methodologies.
· Good exposure to Development, Testing, Debugging, Implementation, Documentation & Production Support.
· Good exposure to Excel with Pivots , PivotCharts , Extract data thru Data Connection etc.
· Good understanding on Hadoop components like Hadoop Map Reduce, HDFS Frame work, HIVE, PIG, HBase, Zookeeper, Sqoop, Oozie, and Flume.
· Managed and co-ordinate tasks between multiple teams (Offshore and Onsite) for many projects.
· Ability to work effectively in a supervisory and non supervisory environment as a team member as well as an individual.
Technical Skills Summary:
ETL Tools / Spark 2.0, Informatica(IntegrationService/PowerCenter/PowerMart) 9.6.1/9.5.1/8.6.1/7, DataStage 8.1/8.0.1BI Tools / Business Objects 6.5/5.1, Cognos
Databases / Hive 2.0.1 , Teradata 9.5.1/9.5 , Oracle 11g/10g/9.x,SQL Developer 1.5.5, MS SQL Server 2008, SQL Server 2005
Languages/Others / Python , SQL, PL/SQL, UNIX and Windows
Packages / MS Office (MS Access, MS Excel, MS Visio, MS PowerPoint, MS Word)
OS / Windows 10/95/98/2000/XP/7/8 Professional/NT, UNIX
Hadoop / HDFS, Hadoop MapReduce, Zookeeper, Hive, Pig, Sqoop, Flume, Oozie , Spark
Data Transfer / Data File thru SFTP and B2B.
Professional Experience:
Verizon, Irving, TX
Sr. Data Analyst / ETL Developer Jun 2016 – Till date
Verizon is a global leader delivering innovative communications and technology solutions;
The main objective of this project was Reduction of Churn. Generating reports to monitor and update the Client to improvise on the market requirement and sales team with new products/offers.
Responsibilities:
· Collection and analyzing of Churn Data periodically.
· Load and Build Adhoc Reports using Teradata Utilities and scheduling jobs thru SSIS Packages.
· Sqooping Data from HDFS and ETL Jobs using Spark, Python and loading it in Hive.
· Extensively used Informatica for ETL Development.
· Reports were produced on Tableau and Excel Pivots with Auto refresh ScoreCard.
· Prepared the Deployment documents for Code Migration.
· Involved in Production Support.
· Performance Tuning of Jobs.
· File transfer thru SFTP.
· Worked closely with DBA’s in performance issues.
· Ensures continuing operational quality by documenting bug fixes and enhancements
assigning tasks to developers, testing and updates.
Environment: Teradata 15.10, Informatica Power Center 9.5.1, Spark 2.0, Python, Hive 2.0.1, Tableau 10.2, UNIX, SQL Server etc.
Frontier Richardson, TX
Sr. Informatica SQL Developer and Data Analyst: Sep 2015 - May 2016 .
Project was due to Frontier Communication acquisition Verizon’s wireline, DSL, and FIOS video and satellite TV businesses in the states of Texas, California and Florida.
Project warranted all the data to be migrated into Verizon systems to Frontier system.
The Data from flat files and Oracle Dumps had to be loaded and processed by Informatica to convert them into Frontier Communications systems (DPI) and merger the Data.
Handling Customer Subscriber Provisioning module completely.
- The logic would involve collecting the addresses from all the sources (11 sources) into a single file.
Responsibilities:
· Design critical part that will be the perquisite of conversion
· Implement the changes from mappers / business analyst on daily basis
· Worked with the Team to validate the data alignment and testing to understand the issues and fix them
· Created databases tables, triggers, views, stored procedures, functions, Packages, joins and hash indexes and collect Statistics.
· Led the end to end system testing
· Responsible for code migration, implementation and monitoring with Operations onshore and offshore teams
· Post production support and data analysis to fix bugs and performance tuning.
· Used SQL Developer to write SQL queries for validating constraints, indexes
Environment: Informatica Power Center 9.5.1, Oracle 11g, UNIX, SQL Server 2008, SQL, PL/SQL, DataStage 8.1/8.0.1.
CVS/Coram, Columbia,MD
Sr. Informatica/ETL Developer Feb 2015 - Sep 2015
CVS Pharmacy is the second largest pharmacy acquired Coram which specializes in Infusion therapy services;
The main objective of the project was conversation from Datastage to Informatica, and included with SQL Server migration to Oracle 11g thru Informatica.
Responsibilities:
· Export the DataStage to XML file and re-import to Informatica.
· Closely check and add transformation and logics which are missed during importing.
· Developed new the mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Update Strategy, Joiner and Union transformation based on the new requirements.
· Prepared the Deployment documents for code migration and Data migration.
· Involved in Unit testing of the mappings.
· Performance Tuning of sessions and mappings.
· Experience in file transfer thru SFTP.
· Worked closely with DBA’s in performance issues.
· Used Tivoli for job schedule.
· Experience in developing Agile methodology.
· Worked with Dell Offshore team.
Environment: Informatica Power Center 9.5.1, Oracle 11g, , UNIX, Windows, SQL Server 2008, SQL, PL/SQL, DataStage 8.1/8.0.1.
Verizon, Irving, TX
Sr. Informatica/ETL Developer Jul 2012 – Jan 2015
Verizon is a global leader delivering innovative communications and technology solutions;
The main objective of the project here was data migration, Started from Oracle to Teradata and now working to move to Big Data/Hadoop. In this process we have done item conversions to move between RDBMS and data for legacy systems to HDFS, built some interfaces regarding AR and AP. Apart from this did some future sales forecasting project also.
Responsibilities:
· Analysis of the existing mappings.
· Enhancements to the existing mappings and sessions.
· Developed the mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Update Strategy, Joiner and Union transformation based on the requirements.
· Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
· Extensively used FLOAD and MLOAD utilities in Teradata through Informatica.
· Extensively used Push down Optimization in Informatica.
· Worked on IDQ.
· Involved in testing of the mappings and matching the data with existing warehouse.
· Converted Unix-Oracle scripts to Unix-BTEQ scripts.
· Prepared the Deployment documents for code migration and Data migration.
· Involved in Production Support.
· Involved in Unit testing of the mappings.
· Performance Tuning of sessions and mappings.
· Experience in file transfer thru SFTP and B2B.
· Experience in DataStage implementations, Development and support.
· Experience in developing Data Model using Kimball's methodology.
· Worked closely with DBA’s in performance issues.
Environment: Informatica Power Center 9.5.1/9.1.1, Oracle 11g, Teradata, UNIX, SQL Server, SQL, PL/SQL, DataStage 8.1/8.0.1.
MedSynergies, Irving, Texas
Sr. Informatica/DW Developer May 2011 – Jul 2012
MedSynergies partners with health care organizations and physicians to align their operations by providing revenue cycle management, practice management, consulting services, business process analysis and software integration solutions, Practice management system software including patient demographics and scheduling information as well as all claims and financial data. All transactional data stored in Enterprise Data Warehouse.
Responsibilities:
· Understanding the existing system.
· Involved in preparing the Mapping Document.
· Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and Rank transformations, SQL transformation, Union transformation.
· Preparing Sessions, Workflows, Worklets for Mappings.
· Developed reusable Mapplets using Mapplets Designer.
· Designing of control tables, and data error tables.
· Developed reusable transformations using Transformation Developer.
· Interacting with the testing team to solve the issues.
Environment: Informatica Power Center 8.6.1, Flat files, Oracle 10g, SQL,PL/SQL, Putty, Windows XP, Toad , Tivoli, Business Objects, Unix scripting, Win SCP.
Magellan Health Service, Richmond, VA
Sr. Informatica/DW Developer Aug 2010 – May 2011
Description: Magellan Health Services was selected by the State of Idaho to create a comprehensive pharmacy benefit management program for beneficiaries of Idaho Medicaid and other State healthcare programs, which includes: A POS system, Payments to providers, Clinical consultation and disease management programs and Collection of HCFA rebates
Responsibilities:
· Established Informatica platform at client location.
· Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
· Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
· Developed complex mappings with transformations like lookup, router, aggregator, expression and joiner confirming to the business rules.
· Performance tuning of mappings, transformations and sessions to optimize session performance.
· Created session tasks (session, command etc.) and managed database connections and scheduled workflows.
· Designed high performance mappings by using iterative variable logic in Expression Transformation.
· Used DT Studio component "parser" to load HL7 formats.
· Good knowledge about DT Studio components like Mapper, Serilazer and Splitter.
· Used Unstructured Date Transformation to integrate DT Studio components with Informatica
· Used SQL*Loader for loading the stage tables.
· Created SQL scripts for views, synonyms
· Performed unit and integrated testing.
· Prepared documentation for business data flow from source to mart.
· Move the mappings and scripts between various environments like the Development, QA and production.
· Creating /Modifying Batch scripts.
· Attend to day today maintains of the loading process.
Environment : Informatica Power Center 7.1/6.2, Flat files, Oracle 9i/8i, Control M, DB2, UNIX (SunOS 5.8), PL/SQL, SQL * Loader, MS SQL Server 2000, SQL Navigator, Windows NT 4.0 Erwin 4.0, Micro Strategy 8.0.2, Mainframes, Toad 8.6, Tera Term Pro, Win SCP
Deloitte, Harrisburg, PA
Sr. Informatica Developer Oct 2008 – Aug2010
Description: The project is primarily aimed on tracking down the information of various customers and type of plans at different locations. Integrated all the information into data warehouse for generating reports.
Responsibilities:
· Understand the existing business system, business exchanges information and Dimensional Data Model of the eCIS.
· Prepare the conversion document plans, synchronization documents plans and design appropriate mappings for conversion and synchronization.
· Test synchronization mappings and compare results with SAP outcome results to verify both results are in sync.
· Schedule mappings using OPCONS scheduler.
· Error Out invalid data and analyze the root cause for errors.
· Maintain Envelope tables to identify the data loads.
· Written DOS scripts to Copy/ Delete the flat files in appropriate folders and initiate scripts from Informatica sessions.
· Data cleansing, Validations, data transformations and calculations in Data flows/ Work flows.
· Created complex Data Flows to load the data mart and monitored them.
Environment: Informatica PowerMart /Power Center 7.2, ETL, Business Objects 5.0, Oracle 9i, DB2 (UDB), Autosys, Teradata V2R5/V2R4, UNIX Shell Scripting, ERWIN 3.5.2, Windows NT 4.0
Hewlett Packard, Bangalore, India
ETL Developer Apr 2007– Sep 2008
Description: Development of the Supply Chain for P&G, HP and involved in SRE and CARE Projects.
Responsibilities:
· Involved in System study, Analysis, and Project Planning.
· Involved in Database Designing and Application programming.
· Writing Database Packages, Stored Procedures & Triggers.
· Tuning of SQL-Statements, stored procedures
· Involved Unit testing and deployment of the application.
· Training the users, support and maintenance of the application.
· Discussions with client for bug fixing and customization of application.
· Analyze data processing requirements to create an ETL packages/Mappings
· Prepare and develop a document specification for designing the mappings/Packages.
· Design the mappings to Extract, Transform and load the data from source to the target system.
· Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
· Worked with heterogeneous sources to extract data from different sources.
· Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
· Data cleansing, Validations, data transformations and calculations in mappings.
· Responsible for creating business solutions for Incremental and Full loads.
· Monitors and executes performance tuning of initial and incremental loads.
· Responsible for processing Cubes and Dimensions.
· Cubes/Reports created for HP Global Sales and Marketing using Analysis services.
· Generating scripts for table definition for both dimension and fact tables.
Environment: Informatica 6.2/5.1.2/4.7, Oracle 8i, SSIS 2005, Business Objects, UNIX, Windows NT
Myzus, Mumbai, India
ETL Developer May2006– Apr2007
Description: Development of the Singapore Stock Exchange and Midas v1, Midas v2 Projects.
Responsibilities:
· Developed Conceptual and logical ETL applications to populate data from source to target database by Informatica tool.
· Implemented slowly changing dimensions Type2.
· Create Mapplets for Reuse Transformation logic in Mappings.
· Responsible for generating Reports from Central Myzus Server, using Business Objects Tool.