SUMMARY

• Professional Data Engineer/ETL Developer with experience in designing, building and maintaining large analytics - ready data lakes and data warehouses using leading-edge technologies.
• Experience in Data Profiling, Data Manipulations, Data Migration, Data Conversion, Data Quality, Data Integration.
• Experience in carrying out the entire Software Development Life Cycle (SDLC).
• Excellent knowledge of Agile & Scrum development environment, multiple web browsers, and automated testing suites.
• Expertise in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience working on creating models for Oracle/Teradata/ SQL Server/DB2.
• Expertise in Source to target mapping in enterprise data warehouse environment
• Experience in Tableau (Desktop, Server, Mobile) as a Developer and Analyst.
• Designed, developed and implemented Dashboards, Scorecards & KPI Reports.
• Knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Experience in implementation of Data Cleanup Procedures, Transformation, Scripts, Stored Procedures and execution of Test plans for loading the data successfully into Targets.
• Experience in designing Test Scenarios, and Test cases for the validation of data in the data warehouse.
• Experience in SQL Query tuning and instance tuning as the part of performance tuning.
• Good knowledge of tracking system such as JIRA and version control tools such as Git.
• Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply new concepts.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter, Ab Initio, DataStage, SSIS

BI/Data Visualization Tools: Tableau, R, Pivot, Power BI, IBM Cognos

Data Modelling Methodologies: Star schema, Snowflake schema, Logical/Physical modelling

Languages: SQL (Teradata, Oracle, Hadoop, Hive, Presto, PostgreSQL), PL/SQL(Oracle), Unix Shell scripts, Python, JavaScript, html, CSS, d3

Data Modelling Tools: Power Designer, SQL Developer

Databases: Teradata, Oracle, DB2, SQL Server, HBase, MySQL, Mongo dB

Database Tools: TOAD, Oracle SQL developer, Teradata SQL Assistant, Enterprise manager, Query Analyzer, SSMS, Database engine tuning Advisor, SSIS, SSAS, SSRS

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer

Responsibilities:

• Involved in requirement gathering and data analysis and Interacted with Business users to understand the reporting requirements.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Worked closely with the BI Data Engineers to identify necessary data, understand the schema and ETL, as well as build the meta-data needed to satisfy business requirements.
• Worked on creating DDL, DML scripts for the data models.
• Performed file level validations, audit control, reconciliation, technical data quality checks and profiling on the source data before loading it into HDFS environment to ensure that lake will inherit the same quality of the data available Confidential source.
• As part of Data Lake team, involved in ingesting 207 source systems which include databases (DB2, MySQL, oracle), flat files, mainframe files, xml files into the Data Lake Hadoop environment which are later explored by reporting tools.
• Performed extensive data analysis on fraudulent data using complex SQL queries and discovered patterns for anti-money laundering activities.
• Prepared Test plan, test case according to the Source to target mapping document.
• Created new complex & simple reports and visualizations and supported existing reports.
• Created interactive dashboards and visualizations of claims reports, Fraud analysis and improved statistical data using Tableau.
• Involved in development of several ETL Applications where data from Data Lake is transformed to implement business data quality rules and published for downstream applications.
• Developed reusable Ab Initio graphs by identifying repeated patterns which saved other team members time and reduced code redundancy and maintenance costs.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Toad, MS Access, Excel and SQL.

Confidential, Houston, TX

Data Engineer

Responsibilities:

• Extensively involved in almost all the phases of Project Life Cycle (SDLC) right from Requirements Gathering to Testing and Implementation, Reporting etc.
• Understand the data visualization requirements from the Business Users.
• Analyzed Sales data mart model to identify the tables and their relations in order to extract required data.
• Involved in developing SQL queries to extract data from the Sales data marts as per the requirements.
• Created Source to Target Data mappings for the individual reports.
• Created a process design architecting the flow of data from various sources to target and Involved in extracting the data from OLTP to OLAP.
• Maintained data integrity during extraction, transformation and loading of data into data warehouse and engaged in requirements and gap workshops with clients for identifying the data sources and data needed for analysis.
• Strong experience developing visualizations with Tableau and deploying those visualizations to Tableau Server.
• Developed new customized reports and dashboards using Tableau and various visualization tools by connecting to single or multiple data sources.
• Took ownership of projects pertaining to data visualizations in Tableau, visualizing and producing reports or articles of sales data/trend information.
• Built Dashboard/Stories over data using Tableau for better business insights using Scatter Plots, Geographic Map, Pie Charts and Bar Charts.
• Created Pivot tables in Excel to analyze data across several dimensions.

Confidential

Tableau Developer

Responsibilities:

• Involved in Requirement gathering, Analyses and preparing the Report, Design Specifications based on User's requirements.
• Involved in Data Modeling.
• Extracted data from different Sources and performed Data Blending.
• Created Workbooks by Importing data, Defining Relationships.
• Created List, Cross Tab Reports with Quick Filters, Summarized filters.
• Developing, Designing and Supporting Interactive Tableau Dashboard reports.
• Experience with the Design and Development of Tableau Visualization solutions.
• Created Bar Charts, Line Charts, Area Charts, Bullet Graphs, Dual lines, Combined Charts, Filled and Symbol Maps, Lollipop, Waterfall, Funnel, Scatter Plots, Box & Whiskers, Heat Maps, Gantt Charts, Score Cards, Bubble Chart, Pie Chart, Stacked Bars and Complex reports.
• Good knowledge in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
• Strong knowledge on Software Development Life Cycle (SDLC).
• Created Parameters for user friendly reports to End Users.
• Formatting the data by using Legends, Marks, Colors, Size and Shape.
• Providing the Security while Publishing to the Tableau Server through Privileges.
• Applied various types of Filters like Data Source Filters, Quick Filters, Context Filters and Cascading Filters.
• Created Table Calculations, Calculated fields and Parameters.
• Created Groups, Sets, Bins and performed Conditional Sorting and Filtering as per the Requirements.
• Coordinating with Business Analyst in validating Report Requirements.
• Executed and tested required queries and reports before Publishing.
• Validating data for each report and Review the reports.
• Developed Story-telling Dashboards in Tableau Desktop and published them on to Tableau Server that allowed End Users to understand data in an easy and efficient manner.
• Writing SQL queries for data validation by using Join condition.
• Delivering Reports to Business team on timely manner.
• Used Trend lines, Reference lines, Statistical and Forecasting techniques to describe data.
• Working with measures like Individual axis, Blending axis, Dual axis.