Sanjay Butola

SANJAY BUTOLA Email:-Contact: - - 956 SUMMARY: ● Over 11 years of extensive experience in building Data Warehouse/BI solutions using various technologies like Teradata, Oracle, MS SQL, GCFR, OWB (Oracle Warehouse Builder). ● Worked in agile(Scrum), DevOps and Waterfall approaches. ● Have worked on Banking, Insurance and Telecom domains. ● Good understanding of AWS. ● Fair knowledge of AWS, Python, Hive SQL, Hadoop. ● Teradata 14 certified as a Technical Specialist. ● Thorough knowledge of Software Development Life Cycle, which include Requirement gathering, Designing, Development and Supporting the Application. ● Good understanding on Data Warehousing Concepts. ● Expertise in developing complex SQL queries. ● Expertise in the area of coding and testing of applications using ETL tool and scripting. ● Expertise in Performance Enhancement of long running user’s Queries. ● Experience in Requirements Analysis, Physical Data Modeling, Development, Deployment. ● Expertise in preparing Technical Design Documents, and reviewing code and design doc. ● Having knowledge of tools like TOAD 10, PLSQL Developer, Edit Plus. EDUCATION ● Bachelor of Science (Computer Science) from University of Mumbai - 2008 AWARDS ● Employee of the Quarter award. CERTIFICATION ● Teradata 14 Certified Technical Consultant KEY SKILLS & TECHNOLOGIES SKILLS ● ● ● ● ● ● ● SDLC implementation in Teradata/Oracle Agile(SCRUM) implementation Performance Tuning using Teradata ETL using OWB tool PDM in Teradata Teradata Utilities Migration from Oracle/DB2/Sybase to Teradata TECHNOLOGIES ● ● ● ● ● ● ● ● Teradata 14 AWS Python Hive Oracle Warehouse Builder(OWB) Unix GCFR UDA QueryGrid PROFESSIONAL EXPERIENCE: Client: ANZ Bank New Zealand Project: TAXII (IRD) Role: Developer/Consultant April 2019 – Till Now Project Description The taxation act 2018 requires that payers of investment income(ANZ) must provide certain information to Inland Revenue(IR) on a regular basis and in an electronic format of its customers. Responsibilities ● ● ● ● ● ● ● Built file extraction process to generate csv files for different source systems. Day to day business meeting with stakeholders. Build business requirement document. Help team with story sizing and refinements. Responsible for all the technical stuff. Guide the team for future stories. Apply scrum practices within team. Environment: Teradata 16.20, SQL Assistant, Data Stage, GCFR, Unix. Client: ANZ Bank New Zealand Project: Prescribed Transaction Reporting (PTR) Role: Developer/Consultant Jul 2017 – April 2019 Project Description ANZ is New Zealand’s largest financial entity. As part of New Zealand Police compliance, every financial entity should report its suspicious, moneylaundered transactions to NZ Police. We have built a robust solution for ANZ, which report all such transactions. Responsibilities ● ● ● ● ● ● ● Gathering business requirement from business analyst and converting that into technical/mapping document. Break down the requirements and their sizing into different sprints. Setting the delivery roadmap of modules allocated. Responsible for overall development including effort estimation. Modeling the requirements in the form of logical design and converting that into physical definitions. Single point of contact to business/testing team. Coordinating with onsite team and single point of contact from offshore. Environment: Teradata 16.20, SQL Assistant, Data Stage, GCFR, Unix. Client: Bank Of America USA Project: BACARDI Role: Consultant Aug 2016 – Apr 2017 Project Description Bank of America is one of the largest banks in USA. Their current system was built in DB2 database. They were facing some serious performance related challenges and hence they wanted to use Teradata. As part of this solution, we have built all the DB2 artefacts including tables, views, procedures, queries in Teradata. We have done significant performance improvement changes as well. Responsibilities ● ● ● ● ● Thorough impact assessment on DB2 system, since the whole system is replacing the risk is more. Build all the jobs in Teradata using agile methodology. Convert/Build SAS code in Teradata. Done sizing of all the sprints. Responsible for team leading activities. Environment: Teradata 14.10, SQL Assistant, DB2 Client: Westpac Project: Westpac BCWC GDW Re-Platform Role: Physical Data Modeler Sep 2015 – Aug 2016 Project Description Westpac is one of the leading financial banking firms of Australia situated in Sydney. Their existing system is in Oracle and they want to migrate it in Teradata. Phase 1 is already in production; phase 2 is currently in development stage. As part of phase 2 they want to move their Oracle table structure in Teradata. Responsibilities ● ● ● ● ● ● ● Coordinating with onsite team and single point of contact from offshore. Responsible for team leading activities. Creating Teradata compatible DDLs as compare to Oracle. Analyzing Oracle data demographics and come up with good PI candidate. Checking skewness of the table for PI. Suggesting any secondary indexes. Loading data from Oracle to Teradata. ● ● Creating the full deployment package for production environment. Fixing any adhoc request of phase 1 for PDM changes. Environment: Teradata 14, SQL Assistant, Oracle, TMA. Client: American Express (AMEX) Project: FIHL Amex IDN End User Rollout Support Role: Teradata Developer and Performance Tuner Jan 2014 to Aug 2015 Project Description American Express is the financial banking system of USA. Initially it was a migration project where they wanted to migrate their procedures from Sybase to Teradata, but later on business users were experiencing huge delay in their reporting queries due to which their report used to take longer than expected time. This was all because of bad design implementation reporting layer. So we have given suggestions on design front after analyzing the data demographics and by fine tuning queries. Responsibilities ● ● ● ● ● ● ● ● ● ● Users Queries and Application Tuning. Tuning, Redesigning and re-writing for CPU, I/O, & space return decision. Enabling users to maximize performance gains in queries and application. Responsible for reaching out to user by analyzing their query in Viewpoint. User’s procedures migration from Sybase to Teradata. Responsible to users’ tickets related to bad performance of query. AMEX Systems CPU and I/O analysis. Balancing the return on effort of tuning vs. application redesign. Impact analysis of tables using Mainframe. It includes tracing back all the jobs, which are dependent on the target job. Environment: Teradata 14, SQL Assistant, Viewpoint Client: JPMC (J.P. Morgan Chase) Project: Forklift Role: Developer Jan 2013 – Dec 2013 Project Description JP Morgan Chase is one of the largest banking firms in USA. There was a performance bottleneck while using DB2, so client wanted to migrate from DB2 to Teradata for optimal performance. So as part of migration we have to migrate all the tables from DB2 to Teradata using TPT multiload utility in UNIX. Responsibilities ● ● ● ● ● ● ● ● ● Analysis of Size estimation of DB2 tables and accordingly segregates the tables as per size. TPT creation for the Teradata tables. Working on TPT to load the data in the Teradata. Perform numeric, non-numeric and count validation for the new loaded tables. Performance tuning of highly time-consuming queries. Suggesting design level changes as part of Performance tuning activity. Analysis of skew tables and providing alternate solution to those. Maintaining the logs of the entire load. Actively participating in daily status call. Environment: Teradata 13.10, TPT, Shell Scripting, DB2 Client: Unilever Project: ISCA R2 (Cordillera) Role: Developer March 2012 – Dec 2012 Description: Unilever is one of the largest consumer goods industries in the world. Unilever had already done migration of Mexico region and they wanted to apply the same requirement for their Latin Americas region. So we had to take the Mexico region requirements and develop the system for their Latin Americas region. Responsibilities ● Involved in the new development. ● Worked on BTEQs. ● Involved in fixing the defect and provides the ETA for completion. ● Single point of contact from Semantic team in Defect Triage call with other vendors. ● Actively worked on Performance tuning part in Demand Planning area. ● Created and managed end to end semantic mapping document and shared it with the testing team. ● Was part of Post production Support for more than one month, and resolved the high priority incidents within SLA. Environment: Teradata 13.10, BTEQ Wipro Infotech, Mumbai Oct 2008 – Feb 2012 Client: Life Insurance Corporation of India (LIC) Project: LIC - BI Migration Role: Developer Jul 2010 – Feb 2012 Project Description LIC is one of the largest insurance company of Asia. LIC was using Business Object as their reporting tool, and they wanted to migrate it to Microstrategy tool. Therefore, we developed the semantic layer of ETL, which would be source for Microstrategy. It includes designing data model as per Microstrategy and PDMs for semantic layer. Responsibilities ● ● ● ● ● ● Creating BTEQ scripts. Responsible for Incremental and Historical Data Loading. Responsible for helping data modeler in order to gather the information from existing system for creating LDM. Active involvement in Implementing Delete Strategy. Responsible for creating SRS document. Owned many subject areas. ● ● Responsible for overall development and the testing of the ETL. Interaction with client to resolve issue. Environment: Teradata 12, BTEQ, Business Objects, Microstrategy. Client: Dialog Telecom Project: Dialog Telekom - BI Implementation Role: Developer Mar 2009 – Jun 2010 Project Description Dialog Telekom is the largest telecom service provider in Sri Lanka having 9+ million subscribers. The main objective of this project is to build a large data warehouse to store their valuable CDRs (Call Detail Records) and other Analysis related information. We have developed many SBUs in this project like GSM, DBN, CDMA, Dialog Television etc. Responsibilities ● ● ● ● ● ● ● ● ● ● ● ● Creating OWB mappings to load the data from source to target tables. Have created Process Flows and Schedules to run daily load as D-1 in OWB. Have done Analysis of source systems. Created LLD, UTC’s about the proposed solution for ETL. Created low-level design documents for reports. Having knowledge of full SDLC of this project. Have faced client site and was in Sri Lanka (Onsite) for 3 months. I was SPOC to the client at onsite for all the issues. Used to maintain the Issue Tracker and circulate within the team and with Client. Have fixed all UAT comments at onsite. Used to send WSR (Weekly Status Report) to the client and higher management of WIPRO. Was responsible for all the Support activities for 3 months and was leading a team of 3 resources. Environment: Oracle 10g, Oracle Warehouse Builder (OWB) 10GR2, OBIEE.