Data Etl
Resume:
Athulya Gopinath
********@*****.***
Professional Summary:
• 4+ years of work experience in designing and developing Data warehouse applications with special emphasis on Design and Development of Data Warehousing using SAP BODS 4.x. Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Excellent understanding of application development lifecycle and expertise in Data Modelling and Data Warehousing using Agile Methodology.
• Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Strong experience with SAP BODS designer components - Jobs, Workflows, Data Flows, Formats, Data Store and Scripts.
• Well versed in using Data Services Designer to ETL from multiple sources including Flat Files, Excel workbooks, XML; SAP ECC and third-party tools through Data Store setup and custom transfer program
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps.
• Well versed in using Performance Tuning techniques to improve Throughput of data.
• Fluent in utilizing Data Integrator and Platform transforms, Variables and functions
• Involved in setting up the Scorecards and associate the Data Quality dimensions.
• Involved in defining the validation rules and bind those rules to against the specific columns.
• Experience in developing visualizations using Tableau to infer certain patterns/trends or insights from datasets.
• Well versed in installing using and extracting data from oracle and MySQL Databases.
• Data Mart development experience to create an extended star schema.
• Extensive experience in SQL, PL/SQL programming, triggers and Query optimization with MySQL, MS-SQL and Oracle Databases. Written queries for insert, update and modification operations. Performed database optimization and normalization using database tools.
• Good interaction with clients, understanding business applications, business data flows and data relations.
• Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements.
• Ability to handle multiple tasks concurrently and meet the required deadlines. Technical Skills:
Operating System Windows 7, 8, Windows Server 2008/2003, UNIX/Linux, MAC. Languages SQL, PL/SQL, Python, Unix shell scripting Databases Oracle 11g/10g, MS SQL Server.
Tools SAP BODS v4.2, Informatica, MySQL, MS Word/Excel, Tableau, Oracle, Selenium, Jira, Jenkins, SQL Developer, Putty, SAP Data Management Professional Experience:
Accenture, Bangalore, India Mar’ 17 – Jun’ 20
Fortune 500 Multinational professional services company Role: Application Development Analyst
Responsibilities:
• Extensively used ETL methodology for Data Extraction, transformations, loading using Data Integrator.
• In-depth knowledge of data warehousing tools, databases and data mapping.
• Performing Unit-Testing, System Integration testing and expected result stabilization to ensure quality data deployment.
• Extensively worked on BODS/BODI Designer Components-Jobs, Workflows, Data Flows, Formats, Data Store and Scripts.
• Extensively worked on BODS Administration Tasks like Repository Configuration, Job Server configuration, Local Repository configuration, Central Repository configuration, Job Scheduling, Monitoring.
• Worked on Change Data Capture on both SOURCE and TARGET level and implemented the SCD Slowly changing Dimension Type 1, Type 2 and Type 3.
• Data Mart development experience to create an Extended Star Schema
• Debug complex ETL jobs using Data Integrator Scripts, Workflows, Dataflow, Data stores, Transforms and Functions.
• Extensively worked on data loads from BODS to BW System.
• Proficient in SQL, ETL & SQL Performance Tuning.
• Involved in defining the validation rules and bind those rules to against the specific columns.
• Experience in scheduling tools like TWS and reconciliation tool Accurate
• Experience in preparing design change documents based on discussions with business requirement changes, performance tuning, code defect fixes and change in data structure from source
• Prepared mapping documents capturing all the rules from the business.
• Involved in ETL Production support resolving job failures and data issues in code/design of the jobs.
• Developed reconciliation reports to business for Source Target data comparison. Manage production services of more than 100 applications to ensure business continuity with minimal impact.
• Worked with a wide range of stakeholders and functional teams along with other data analysts and data scientists to develop data visualizations to provide relevant business insights.
• Analyze, design, build, test and implement enhancements to existing systems and/or new applications.
• Provide overnight batch support post-deployment.
• Responsible for creating Playbooks for BODI, Talend, UNIX, PowerShell.
• Train Team members in SAP BODS by taking number of technical sessions.
• Perform Hot Fixes in the live environment.
Console, vim, Git, Visual Studio, IBM RTC & UCD, MySQL Workbench Methodologies
Agile Technologies, Data Analytics, Data Management, Data Warehousing, Data Visualization, Data Governance & Quality, Automated Software Testing
• Create and maintain technical documentation and contribute to project deliverables where applicable.
• Provide analysis of system defects as and when required.
• Undertake root cause analysis and problem investigation.
• Responsible for identifying and deploying the automation within the system.
• Act as a liaising between business and third-party vendor.
• Responsible for creating dummy data, to test code reliability under different scenarios.
• Good understanding of the various functionalities of banking domain. Sutherland Global Services, Kerala, India Apr’ 16 – Feb’ 17 Digital Transformation & Business process services Role: ETL Developer
Responsibilities:
• Used SAP BODS for extraction, transformation and loading (ETL) of source data from Database sources like Oracle, SQL Server, flat files.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Worked on identifying trends and patterns in data sets.
• Developed data visualizations in Tableau with an emphasis on formatting, layout and fonts.
• Experience in performance tuning to improve run time of Tableau dashboards.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Involved in trouble shooting and resuming failed jobs. Education:
Mahatma Gandhi University, Rajagiri School of Engineering and Technology, Cochin, India Apr’ 2016 Bachelor’s Degree in Applied Electronics and Instrumentation, 3.5/4.0 GPA
Contact this candidate