Project Sales
Resume:
RAGHUNATHAN ANBAZHAGAN
***********@*****.***
OBJECTIVE
TO WORK IN A HIGHLY MOTIVATING AND CHALLENGING ENVIRONMENT THAT PROVIDES THE BEST OPPORTUNITIES TO GROW AND
UTILIZE MY POTENTIAL TO ACHIEVE ORGANIZATIONAL GROWTH WHILE ACHIEVING MY PERSONAL GOALS.
CAREER OVERVIEW
• OVER 4 YEARS OF EXPERIENCE IN ETL ARCHITECTURE, ANALYSIS, DESIGN, DEVELOPMENT, TESTING,
IMPLEMENTATION AND MAINTENANCE OF ENTERPRISE LEVEL DATA WAREHOUSES.
• EXPERIENCE IN RELATIONAL MODELING AND DIMENSIONAL DATA MODELING USING STAR & SNOWFLAKE
SCHEMA, DE-NORMALIZATION, NORMALIZATION.
• EXPERIENCE IN SDLC MODELS LIKE WATERFALL MODEL, ITERATIVE MODEL AND AGILE METHODOLOGIES
• GOOD KNOWLEDGE OF INFORMATICA/OBIEE STANDARDS AND BEST PRACTICES, CONFORMED DIMENSIONS,
SLOWLY CHANGING DIMENSIONS (SCD1, SCD2, SCD3).
• GOOD UNDERSTANDING OF INFORMATICA POWERCENTER 8.6 / 9.1 SERVICES AND SECURITY ADMINISTRATION.
• EXPERIENCED IN GATHERING REPORTING REQUIREMENTS AND IMPLEMENTING THE METADATA LAYERS OF OBIEE
10G/11G TO CREATE REPORTS AND DASHBOARDS.
• WORKED ON ORACLE DAC 11G TO SCHEDULE AND MONITOR INFORMATICA ETL WORKFLOWS.
• EXPERIENCE IN UNIX SHELL SCRIPTING TO CREATE COMMAND LINE TASKS FOR FILE ARCHIVE, TRANSFER AND
OTHER FILE OPERATIONS.
• ABILITY TO QUICKLY LEARN NEW CONCEPTS, CO-OPERATIVE TEAM PLAYER WITH GOOD COMMUNICATION AND
INTERPERSONAL SKILLS.
EXPERIENCE
SENIOR INFORMATICA & OBIEE DEVELOPER (JANUARY’14 –
TILL DATE)
SALES OPERATIONS REPORTING
MOTOROLA MOBILITY, CHICAGO, IL
PROJECT DESCRIPTION
THIS IS AN ENHANCEMENT PROJECT FOR ADDING NEW REPORTING CAPABILITIES TO THE EXISTING SALES AND SERVICE REPORTING
SUBJECT AREAS. IMPLEMENTATION OF NEW CAPABILITIES TO ENABLE BUSINESS USERS TO TRACK ENTIRE ORDER LIFECYCLE FROM ORDER
PLACEMENT TILL DELIVERY TO CUSTOMER. AS PART OF THE PROJECT MANY REPORTS AND DASHBOARDS WERE CREATED TO MEASURE SALES
AND SERVICE METRICS.
● ACTIVELY PARTICIPATED IN THE DISCUSSIONS WITH BUSINESS USERS TO GATHER REPORTING REQUIREMENTS.
● INVOLVED IN REQUIREMENTS ANALYSIS, DESIGN AND DEVELOPMENT OF ETL AND OBIEE COMPONENTS.
● INVOLVED IN THE CREATION OF FUNCTIONAL AND DEVELOPMENT REQUIREMENT DOCUMENTS.
● CREATED DATA MAPPING DOCUMENTS FOR INFORMATICA MAPPINGS.
● PARTICIPATED IN THE DESIGN REVIEW MEETINGS WITH THE BI ARCHITECTS TO FINALIZE THE DESIGN OF EACH MODULE
OF THE PROJECT.
● CREATED COMPLEX INFORMATICA MAPPINGS USING UNCONNECTED LOOKUPS, RANK, SOURCE QUALIFIER, SORTER,
AGGREGATOR, EXPRESSION, ROUTER AND NORMALIZER TRANSFORMATIONS TO EXTRACT, TRANSFORM AND LOAD DATA.
● INVOLVED IN DESIGN AND DEVELOPMENT OF THREE LAYERS (PHYSICAL/BUSINESS MODEL/PRESENTATION) OF OBIEE
METADATA REPOSITORY (RPD).
● CREATED CUSTOMIZED INTERACTIVE DASHBOARDS AND REPORTS IN OBIEE USING DRILL DOWN, GUIDED NAVIGATION,
PROMPTS, FILTERS AND VARIABLES.
● PERFORMED UNIT TESTS AND DOCUMENTED THE RESULTS.
● CREATED SIT AND UAT TEST CASES AND EXECUTED THEM.
● CREATED IMPLEMENTATION DOCUMENTS FOR INFORMATICA AND OBIEE CODE MIGRATION TO PRODUCTION.
● CREATED ORACLE DAC TASKS AND EXECUTION PLANS TO SCHEDULE THE INFORMATICA WORKFLOWS.
● SUPPORTED THE PRODUCTION ENVIRONMENT AFTER THE CODE MIGRATION TO PRODUCTION.
● WORKED ON A NEW REQUIREMENT IN A SHORT SPAN OF TIME AND IMPLEMENTED THE CHANGES IN PRODUCTION BEFORE
DEADLINE.
● CREATED PERFORMANCE METRICS REPORTS WHICH HELPED BUSINESS USERS TO MEASURE THE SHIPMENT AND
DELIVERY METRICS OF ORDERS.
SENIOR INFORMATICA & OBIEE DEVELOPER (JUNE’13 –
DECEMBER’13)
SUPPLY CHAIN PLANNING REPORTING
MOTOROLA MOBILITY, CHENNAI, INDIA
PROJECT DESCRIPTION:
THIS PROJECT WAS TO BUILD A NEW DATAWAREHOUSE WHICH PROVIDES INFORMATION ABOUT THE SUPPLY CHAIN PLANNING OF
PRODUCTS. DEMAND FORECAST, SHIPMENTS AND INVENTORY DETAILS WERE LOADED FROM ORACLE ASCP SYSTEM TO THE
DATAWAREHOUSE. MULTIPLE REPORTS AND DASHBOARDS WERE BUILT FOR DAILY AND EXECUTIVE REPORTING.
● PARTICIPATED IN REQUIREMENTS ANALYSIS DISCUSSIONS WITH BUSINESS ANALYSTS AND DW ARCHITECTS.
● CREATED DEVELOPMENT REQUIREMENTS DOCUMENT AND DATA MAPPING DOCUMENT.
● INVOLVED IN DAILY CALLS WITH OFFSHORE DEVELOPERS TO DISCUSS ABOUT THE DEVELOPMENT REQUIREMENTS AND
CLARIFIED THEIR QUESTIONS ON REQUIREMENTS.
● CREATED AN ISSUE LOGGER DOCUMENT FOR DEVELOPERS TO ENTER THE CODING ISSUES FACED DURING DEVELOPMENT
ALONG WITH THE SOLUTIONS. THIS HELPED THE TEAM TO IDENTIFY AND SOLVE GENERIC ISSUES ENCOUNTERED DURING
DEVELOPMENT.
● CREATED MAPPINGS, SESSIONS, WORKFLOWS, WORKLETS AND WORKFLOW LEVEL TASKS IN INFORMATICA
POWERCENTER 9.1.
● INVOLVED IN DESIGN AND DEVELOPMENT OF THREE LAYERS (PHYSICAL/BUSINESS MODEL/PRESENTATION) OF OBIEE
METADATA REPOSITORY (RPD).
● CREATED SIT AND UAT TEST CASES AND ENSURED ALL THE TEST CASES ARE PASSED BEFORE THE PROJECT TIMELINE.
● CREATED ETL JOBS TO GENERATE OUTBOUND FEED FILES WHICH ARE THEN TRANSFERRED TO MANY EXTERNAL
SERVERS.
● IN ORDER TO MAKE THE ETL MIGRATION PROCESS EASIER CREATED INFORMATICA COMMAND LINE SCRIPTS WHICH
SAVED TIME AND EFFORT OF MIGRATING THE INFORMATICA XMLS THROUGH GUI.
● CREATED INDEXES ON THE DATAWAREHOUSE AND ADDED ORACLE HINTS TO THE SOURCE QUALIFIER QUERIES TO
IMPROVE THE PERFORMANCE OF THE ETLS.
● CREATED INTERACTIVE REPORTS AND DASHBOARDS IN OBIEE FOR BUSINESS USERS.
INFORMATICA & OBIEE DEVELOPER (JULY’12 –
MAY’13)
ECOMMERCE SALES & SERVICE REPORTING
MOTOROLA MOBILITY, CHENNAI, INDIA
PROJECT DESCRIPTION:
THIS PROJECT WAS TO BUILD A DATAMART WHICH INTEGRATES ALL SALES RELATED DATA INTO A DATAMART IN A DE-NORMALIZED FORM.
BUSINESS REQUESTED FOR A NEAR REAL TIME DATA FROM THE DATAMART. THE DATAMART WAS DESIGNED TO INTEGRATE DATA FROM
ONLINE RETAIL WEBSITE, ORACLE ERP AND DATA FEEDS FROM THIRD PARTY CUSTOMERS.
● PARTICIPATED IN REQUIREMENTS ANALYSIS DISCUSSIONS WITH BUSINESS ANALYSTS AND DW ARCHITECTS.
● CREATED DEVELOPMENT REQUIREMENTS DOCUMENT AND DATA MAPPING DOCUMENT.
● INVOLVED IN DISCUSSIONS TO PROVIDE REQUIREMENTS FOR THE INBOUND FEED FILES FROM DIFFERENT TEAMS WITHIN
THE ORGANIZATION AND ALSO FROM THIRD PARTY CUSTOMERS LIKE DHL AND FEDEX.
● CREATED COMPLEX INFORMATICA MAPPINGS USING UNCONNECTED LOOKUPS, RANK, SOURCE QUALIFIER, SORTER,
AGGREGATOR, EXPRESSION, ROUTER AND NORMALIZER TRANSFORMATIONS TO EXTRACT, TRANSFORM AND LOAD DATA.
● USED DIFFERENT SOURCES SUCH AS DELIMITED FLAT FILES, ORACLE AND SQL SERVER TO EXTRACT, TRANSFORM AND
LOAD DATA INTO THE TARGET TABLES.
● ACTIVELY PARTICIPATED IN THE DESIGN REVIEWS AND PROTOTYPE WALKTHROUGHS.
● WORKED WITH THE TEAM MEMBERS AND DESIGNED OBIEE METADATA REPOSITORY AND SUBJECT AREAS.
● TUNED INFORMATICA MAPPINGS AND ORACLE SQL QUERIES TO REDUCE THE ETL RUN TIME.
● PROPOSED AN IDEA OF INTERACTIVE DASHBOARD AND IMPLEMENTED THE SAME WHICH WAS WIDELY USED BY THE
BUSINESS USERS
● AS A TEAM, IMPLEMENTED THE PROJECT ON TIME WHICH MET THE SLA OF 15 MINUTES LOAD TIME.
● CREATED COMPLEX REPORTS FOR AD HOC REQUESTS AND SCHEDULED THE REPORTS AS OUTBOUND FEEDS TO EXTERNAL
SERVERS.
INFORMATICA ETL DEVELOPER (JUNE’11 –
JUNE’12)
EMS REPORTING
MOTOROLA MOBILITY, CHENNAI, INDIA
PROJECT DESCRIPTION:
THIS PROJECT WAS TO INTEGRATE DATA FROM EXTERNAL VENDORS INTO CLIENT DATAWAREHOUSE. DATA FROM MULTIPLE VENDORS ARE
PROCESSED AND LOADED INTO THE DATAWAREHOUSE.
● INVOLVED IN CREATION OF DEVELOPMENT REQUIREMENTS DOCUMENTS.
● INVOLVED IN PROVIDING REQUIREMENTS TO THE INBOUND FEED FILES AND EXTERNAL DATABASE VIEWS.
● WORKED CLOSELY WITH 4 EXTERNAL VENDORS OF THE CLIENT THROUGHOUT THE PROJECT CYCLE TO ENSURE THERE ARE
NO GAPS IN THE REQUIREMENTS.
● INVOLVED IN MEETINGS WITH BUSINESS USERS TO GATHER REPORTING REQUIREMENTS AND UNDERSTAND BUSINESS
OPERATIONS PERTAINING TO THE PROJECT.
● CREATED MAPPINGS, SESSIONS AND WORKFLOWS AS PER THE DATA MAPPING DOCUMENTS CREATED BY SENIOR
DEVELOPERS IN THE TEAM.
● CREATED MAPPINGS USING EXPRESSIONS, FILTER, AGGREGATOR, SOURCE QUALIFIER, ROUTER, LOOKUP, JOINER AND
UPDATE STRATEGY TRANSFORMATIONS.
● CREATED KNOWLEDGE TRANSFER DOCUMENTS FOR SUPPORT TEAM.
● EXECUTED UNIT TEST CASES AND DOCUMENTED THE TEST RESULTS.
● CREATED IMPLEMENTATION NOTES FOR TEST AND PRODUCTION MIGRATION OF ETL CODE.
● DOCUMENTED THE SESSION RUN TIMES AND TUNED THE SQL QUERIES AND INFORMATICA MAPPINGS IN CASE OF ANY
PERFORMANCE ISSUES.
● CREATED CRS (CHANGE REQUESTS) AND PRESENTED THE CHANGES TO BE IMPLEMENTED AS PART OF THE RELEASE TO
THE CHANGE MANAGEMENT TEAM.
● CREATED HP PPM PACKAGES FOR INFORMATICA TEST AND PRODUCTION DEPLOYMENTS.
INFORMATICA & OBIEE SUPPORT (JANUARY’11
– MAY’11)
ENTERPRISE DATAWAREHOUSE SUPPORT
MOTOROLA MOBILITY, CHENNAI, INDIA
PROJECT DESCRIPTION:
THIS WAS A MAINTENANCE PROJECT WHICH INVOLVED SUPPORT AND ADMINISTRATION OF THE ENTERPRISE DATAWAREHOUSE.
● INVOLVED IN PRODUCTION SUPPORT AND ENSURED ETL PROCESSES WORKS AS EXPECTED
● INVOLVED IN ROOT CAUSE ANALYSIS AND RESOLVING OF PRODUCTION ISSUES.
● INVOLVED IN TECHNICAL SUPPORTING, TROUBLESHOOTING DATA WAREHOUSE APPLICATION TO MEET SERVICE LEVEL
AGREEMENT(SLA'S)
● HANDLING OF CR'S (CHANGE REQUESTS) AND ENHANCEMENTS FOR EXISTING APPLICATION AND FOLLOWED CHANGE
MANAGEMENT PROCESS
● UNDERSTANDING OF KNOWLEDGE TRANSFER PROVIDED BY DEVELOPMENT TEAM BEFORE PRODUCTION RELEASE OF
PROJECTS
● CREATED AUTOMATED SHELL SCRIPTS TO SEND ALERT EMAILS WHEN A ETL SESSION RUNS FOR A LONG TIME.
● MIGRATED INFORMATICA ETLS TO TEST AND PRODUCTION ENVIRONMENTS USING DEPLOYMENT GROUPS AND XMLS.
● INVOLVED IN CREATION AND MAINTENANCE OF INFORMATICA REPOSITORIES AND INTEGRATION SERVICES
● INVOLVED IN MAINTENANCE OF INFORMATICA POWERCENTER SERVICES AND PLANNED DOWNTIMES OF OBIEE 10G.
● WORKED WITH INFORMATICA SUPPORT ON ISSUES RELATED TO INFORMATICA SERVICE FAILURES.
● CREATED A SHELL SCRIPT TO GENERATE INFORMATICA COMMAND LINE SCRIPTS FOR MIGRATING LARGE NUMBER OF
ETLS.
● CREATED INFORMATICA USERS AND GROUPS TO PROVIDE ACCESS TO DEVELOPMENT, TEST AND PRODUCTION
ENVIRONMENTS.
● INVOLVED IN INFORMATICA VERSION UPGRADE FROM 8.1 TO 8.6
● USED THE INFORMATICA METADATA TABLES TO GATHER INFORMATION ABOUT SESSION RUN TIMES OVER A PERIOD OF
TIME.
● PROVIDED SUPPORT TO BUSINESS USERS FOR THE INCIDENT TICKETS CREATED BY ANALYSING THE ISSUES REPORTED AND
FIXING THEM.
EDUCATIONAL DETAILS:
BACHELORS DEGREE IN COMPUTER SCIENCE AND ENGINEERING 2010
RAJALAKSHMI ENGINEERING COLLEGE, ANNA UNIVERSITY, CHENNAI, INDIA
Contact this candidate