TECHNICAL SKILLS

Programming Languages: SQL, PL - SQL, TSQL, R, Python

Other Tools: JIRA, Service Now, MS Visio, GitHub, Toad, Pl-SQL Developer, Oracle Forms and Reports Developer, Azure DevOps

BI Tools: SSIS, Informatica, Snowflake, SSAS (Tabular and Multidimensional), Tableau, Power BI, Excel, SAP Lumira

Web Technologies: XML, HTML, CSS, JSP

Key Strengths: Requirement Gathering, Incident & Team Management, Database Design, Data Modeling, Business Process Modeling, ETL Process, Data Warehousing, Big Data Integration, Test Data Management

PROFESSIONAL EXPERIENCE

Confidential

ETL Engineer/Data Engineer

Responsibilities:

• Developed and maintained ETL mappings to extract the data from multiple source systems that comprise databases like Oracle, SQL Server, flat files to the Staging area, Data Warehouse and then to the Data Marts using SSIS
• Maintained SQL scripts and complex queries for analysis and extraction
• Performed and presented Data analysis, Data Cleaning, Wrangling and prediction modeling for complex data and files
• Translated data requirements between front-line consulting staff and technical resources by creating reports and dashboards using Power BI, SQL, and Tableau
• Managed deployments to QA/UAT/PROD and resolved production issues raised in ETL solutions within given SLA timelines
• Worked on JIRA & Azure DevOps for creating User Stories and worked in daily agile Scrum meeting, Scrum review and retrospective
• Managed a team of 6 members, prepared project plans, and tracked project deliveries for ETL and reporting projects

Confidential

ETL Engineer

Responsibilities:

• Created technical design documents, ETL mapping, unit/system/integration test plans, and end-user system documents
• Developed Tableau visualizations and dashboards using Tableau Desktop and developed Tableau workbooks from multiple data sources using Data Blending
• Worked in R and PL/SQL programming to implement business user requirements and business rules
• Extracted data from various source systems like XML, flat-files, CSV, Oracle and loaded into MS SQL server using SSIS, done analysis and created star and snowflake schema and data cubes using SSAS and created reports using SSRS
• Collaborated with different business stakeholders to identify opportunities for process improvements, recommend system modifications, and developed policies for data governance