ETL and Tableau developer
Resume:
ANUSHA
******.*****@*****.***
SUMMARY:
A value oriented IT professional with 2+ years of experience in Analysis, Design and Development of ETL applications and Business Intelligence Solutions in Data warehousing and Reporting.
Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power center.
Experience in integration of various heterogeneous data sources like SQL Server, Oracle, Flat Files, Excel and XML files and load data in to Data ware house and Data marts using Power center.
Worked in creating complex Mappings using various transformations like Unconnected and Connected lookups, Source Qualifier, Joiner, Rank, Sorter, Router, Filter, Expression, Aggregator, Joiner, Union and Update Strategy.
Very good knowledge in data warehouse designs using Star Schema and Snow Flake Schema Architectures, Fact and Dimension Tables, OLTP and OLAP applications.
Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
In-depth understanding of Data Warehousing and Business Intelligence concepts.
Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts, Bullet Graphs, Area Charts, Scatter Plots, etc.
Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
Ensured maintenance of necessary documentation for key BI & Reporting processes and deliverables.
Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
Good analytical capabilities coupled with excellent decision making skills.
Dedicated and high ambitious to achieve organizational as well as personal goals.
Able to work independently and collaborate proactively and cross functionally within a team to perform well under pressure.
Education
Masters in Computer Science 2015-2017
Fairleigh Dickinson University, Teaneck, NJ
G.P.A = 3.6
Bachelors in Electronics and Communications Engineering
Sree Chaitanya College of Engineering, Telangana, India
Academic Project at Fairleigh Dickinson University
Data Visualization of Hospital quarterly dataset using Tableau in Big Data Course
Collected and analyzed the data of hospital query dataset from different regions of United States.
Created a relational database management system using PL/SQL.
Developed tableau visualizations by creating user objects for Hospital dataset using different kinds of graphs.
Additional Information
Reporting Tools: Tableau, SSRS
ETL Tools: Informatica PowerCenter
Databases: Oracle, MS SQL Server
Scheduling Tool: Autosys
Tools: MS office
Environment: UNIX, LINUX, Windows Server
Programming Languages: C, Java, Linux/Unix Shell
Work Experience
CIT Group, Livingston NJ Jan 2017 – Till Date
Informatica/Tableau Developer
Job Responsibilities:
Worked closely with business analyst to analyze and understand the business requirements.
Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Data warehouse.
Designed complex mappings by using Lookup transformation, Expression, Sequence generator, Update, Aggregator, Router, Stored Procedure.
Created Mappings, Mapplets, Sessions, Workflows (reusable and non-reusable) by using Informatica Power Center.
Designed and developed Tableau Reports, Dashboards and Stories using visual design best practices.
Worked on creating various analytical Dashboards from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Created Prompts, Parameters, customized Calculations, Conditions, Groups, Sets, Bins, Context filters and LODs for various analytical reports and Dashboards.
Experience in creating different visualizations using charts like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles.
Involved in troubleshooting and performance tuning of reports and resolving issues related to Tableau Server and Reports.
Experienced in methodologies like SDLC and Agile methodologies such as SCRUM.
Extensively worked on SQL override in Source Qualifier Transformation for better performance.
Designed and developed stored procedures using PL/SQL and tuned SQL queries for better performance.
Implemented slowly changing dimension (SCD Type 1 & 2) in various mappings.
Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, Assignment, Timer and scheduling of the workflow.
Environment: Tableau 10.0, Informatica 9.5.x, Excel, Access, Autosys, Oracle DB 11g, Windows Server 2008, 2012
Ajel Technologies, India August 2014 – July 2015
ETL / Tableau Developer
Job Responsibilities:
Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
Created various Transformations like Lookup, Joiner, Aggregator, Expression, Filter, Router, Stored Procedure and Update Strategy.
Scheduled Sessions on the Informatica Server using Workflow Manager and Workflow Monitor.
Involved in developing measurement dashboards using Tableau desktop.
Created analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Involved in creating calculations like string manipulation, arithmetic calculations, custom aggregations and ratios, logic statements and quick table calculations in Tableau.
Communicated with Managers, and clients to help them make business decisions
Environment: Tableau 8.0, Informatica 9.5.x, Excel, Access, Oracle DB 11g, Windows Server 2008
Contact this candidate