Description
PROFESSIONAL SUMMARY Overall 11 years of IT experience - Teradata, Data Modelling, Enterprise Data Warehousing, Big Data & ETL * Extensively worked on Architecture, Data Analysis, Design, Development, Implementation, Maintenance and Support on RDBMS Systems and Big Data Technologies * Strong working experience in Financial, Healthcare, Entertainment Domains/Industries * Experience in Design, Enhancement, and Development of applications for OLAP and DSS - Decision Support Systems using Dimension Modelling * Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling * Extensively worked on Teradata 15 and load and unload utilities like MultiLoad, FastLoad, FastExport, BTEQ, TPump & TPT * Advanced and Strong working experience on SQL, Performance tuning and Query analysis * Experience in building Data Marts, Data Structures, Data Storages, Data warehouses, Data Archives, and Data Analysis * Extensively worked on processing large sets of Structured, Semi-structured and Unstructured data and supporting systems application architecture using Hadoop Hive, MapReduce and Sqoop * Experience in Designing and Developing Informatica mappings from various transformation logics using filter, expression, rank, router, aggregator, joiner, lookup and update strategy * Strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis * Good experience in UNIX Shell scripting * Strong working knowledge in Agile Project Management methodology * Ability to coordinate the flow of development initiatives and experience in all phases of Testing - Unit testing, System Testing, Integration Testing, Regression testing, Performance and Acceptance testing * Exceptional communication skills - Verbal and Written * Good understanding of Project Management methodologies and SDLC * Outstanding working relationship with the clients and as well effective communication with the management and within the team AREAS OF EXPERTISE - TECHNOLOGY & TOOLS Summary My Orders Reporting Project mainly deals with all the backlog orders (eOM and OM data) from different source systems and shows data in different variances like Business benefits, SFDC, POD, KPIs and Graphical Analysis. It has different users across the globe which involves the reporting part in both OBIEE and Spotfire. Responsibilities * Responsible for developing the data model (physical and logical model) for the project * Involved in developing schemas, analyze the data, design the entities and its relationships required for efficient reporting * Involved in designing the tables, indexes to improve the performance * Worked as an Onsite Coordinator - Interacting with the Business users on gathering the requirements Implemented the CRQ's by analyzing the specifications provided by the client * Designed and developed Informatica mappings, BTEQs (Teradata Utilities) and Job Chains using Cronacle to maintain optimal performance * Actively involved in development and testing phases like Unit Testing, System Testing, Regression Testing, UAT Support for providing Quality and Defect free code * Conducted code walkthroughs and review peer code and documentation * Worked with Junior/Senior developers, DBAs, and systems support personnel in elevating and automating successful code to Production * Involved in creating dashboards for the reporting standpoint * Involved in anticipating the customer's needs and Coordinating with the Architects and the team to meet the deliverables on time Environment - Teradata, Informatica, Cronacle, Spotfire, UNIX Project Summary Global Service shop for GE Healthcare is an ecommerce project which was developed for marketing the GE Healthcare products online. The Service shop was made available online in USA, Canada, UK, France, Saudi, Australia, Germany, India and New Zealand regions. Responsibilities * Involved with the Business and regional teams to understand the data request/requirements * Analyzed the data and ensure that the data shared is not deviating from the existing Global Catalog Structure * Primarily involved in developing the data files and was responsible for the smooth data loading process to Stage and Production environments * Responsible for all phases of testing in different environments * Maintain the Data Masters for the complete project for all the regions Environment - Hybris regions. Responsibilities * Involved with the Business and regional teams to understand the data request/requirements * Analyzed the data and ensure that the data shared is not deviating from the existing Global Catalog Structure Project Summary Global Service Visibility Project mainly dealt with all the closed service requests from different regions like CARES, CAPS, MUSIC, Siebel Intl, USCAN and Siebel Americas. Data is viewed in different angles at the system level and at the part level and the costs involved in different service requests. Responsibilities * Involved in interacting with the Business users on gathering the requirements during the backlog/grooming sessions * Implemented complex transformations by creating custom transformations in addition to using built-in ones * Excellent experience in creating and managing Database users, Schemas, Roles, Tables views and Projections * Involved in providing the Optimal ETL Solution to extract and load the data from different source system to EDW * Strong working experience in Design of scalable, reusable, and minimal maintenance of ETL templates * Coordinated with the Technical architects and within the team to meet the deliverables on time and was responsible to handle and fix the issues in Stabilization period * Involved in development and testing phases including Coding, Unit Testing, UAT Support for providing Quality and Defect free code * Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures * Responsible for all phases of Testing in different environments * Prepared the Support document and Transition the project to the Support team * To propose the new optimized solutions to make the data available for NRT reporting Environment - Teradata, Informatica, Cronacle, UNIX & OBIEE, AWS (EC2) Project Summary Warner Bros. Entertainment Inc is a Time Warner Company. It is a leading studio that produces and distributes entertainment content such as movies, home entertainment products, games and related products. Warner Home Video, as known in the US (also known as Warner Home Entertainment Internationally) is the business unit that manages the supply chain and associated logistics for the manufacturing, marketing and accounting of various lines of business including Video Sales, Games Distribution and Video on Demand (Electronic Sell Thru- EST). MARVIN stands for Master Repository for Video Intelligence. Marvin is mainly needed to deal with data with respect to Video which in turn deals with Home video sales, Video rights sold to a channel, profits obtained from it etc. It also deals with video games industry like selling XBOX machines, revenue obtained from internet game download etc. It also deals in internal data i.e. amounts due from a dealer, cost involved in creation of video /video games software, manufacturing DVDs etc. Responsibilities * Involved in developing a new module for APAC region using Teradata BTEQ's * Implemented the CRQ's by analyzing the specifications provided by the clients * Provided tech team support and was on-call coordinator for the project * Primarily involved in monitoring the Teradata jobs that were scheduled through ORSYP and made sure the loads were completed on time * To fix the scheduled jobs on failure, and to re-run the failed jobs through Unix environment * Ensured the compliance of Quality procedures related to the project Environment - Teradata, Informatica, Business Objects, UNIX Project Summary Category Management is a service which is provided to selective retailers who plan to achieve their target and measure their effectiveness in the market. This objective was accomplished by standard dashboards which are generated in comparison with the industry data. The Industry data was purchased by WHE from external agencies such as AC Nielsen, GFK, OCC, NPD etc. This service was offered in Video industry, games industry and hardware industry. Planogram is also another service provided to the retailers. This helps in providing schematic layout to retailers about how to place various products on retailer store shelf. Responsibilities * Implemented the CRQ's by analyzing the specifications provided by the clients * Primarily involved in monitoring the Teradata jobs that were scheduled through ORSYP and made sure the loads were completed on time * To fix the scheduled jobs on failure * Ensured the compliance of Quality procedures related to the project Environment - Teradata, Informatica and MicroStrategy Project Summary DBS is the largest bank in Singapore as measured by assets and a leading bank in Hong Kong, providing the full range of services in corporate, SME, consumer and wholesale banking activities across Asia and the Middle East. IDM (Integrated Data Mart) is designed to capture regional reporting requirements for Business Analytics supporting OLAP features. Responsibilities * Analyzed of the specifications provided by the clients * Developed scripts using TERADATA BTEQ * Created the detailed design document * Validated the data by using Unit testing * Ensured the compliance of Quality procedures related to the project Environment - Teradata SQL, Teradata and Informatica Client : Telstra Australia - Bangalore, India Oct 2007 to Sep 2008 Software Engineer Project Name - TELSTRA Project Summary The project was basically a transformation of the existing data warehouse into a new architecture. I was involved in the data out system testing and system integration testing team and was primarily responsible for running the shell scripts and checking the jobs. Responsibilities * Involved in monitoring the workflows, re-running jobs on failure, updating the data and fixing the bugs * Validated the status of the jobs * Analyzed the root cause for failures * Handled jobs on failure and then scheduled the jobs * Ensured the compliance of Quality procedures related to the project Project Summary This project was aimed at developing Enterprise data warehouse for SIAM COMMERCIAL BANK by replacing their existing data warehouse with EDW. The whole delivery was divided into three releases along with it the entire system was divided into different source systems. For this activity, Sunopsis was used as the front-end tool and Teradata as Database. Responsibilities * Analyzed the specifications provided by the clients * Developed Interfaces using Sunopsis * Prepared Business Rules for the developed interfaces * Documented the developed interfaces ENVIRONMENT - Teradata V2R5, Windows XP, ODI (Sunopsis)
Accomplishments
Highlights:
Keywords
