SUMMARY

• Around 4 Years’ of experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau.
• Hands - on with creating solution driven dashboards by developing different chart types including Heat Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop.
• Extensively used ETL methodology for performing Data Profiling, Data Migration, Extraction, Transformation and Loading using Talend.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Experience in Error Handling, Execution Recovery and Performance Enhancement of Talend DI Jobs.
• Extracted and collected data using SQL to create needed reports.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Deep Knowledge of writing SQL Queries for Data analysis and Data mapping specification.
• Working knowledge of data transformation and analysis tools like Pig or Hive.
• Good Knowledge in Data Modeling with Star & Snow-Flake Schemas, Fact and Dimensions tables, Physical and logical data modeling using Erwin.
• Proficient in Agile, Test Driven and Waterfall software development life cycle.
• Demonstrated strong interpersonal skills with the ability to work effectively with upper management and excellent leadership skills in motivating others.

TECHNICAL SKILLS

S/W, Products: ORACLE 9i/10g/11g, SQL Server 2008, DB2, SQL, Teradata, VMware.

Tools: Talend, Tableau Desktop, ERwin, Hive, Pig, MS Office(Access, Excel, PowerPoint).

Hardware: OS, Windows Family, UNIX, Linux.

Methods: Dimensional Modeling and Relation Design, Agile, Waterfall.

PROFESSIONAL EXPERIENCE

Talend Developer

Confidential, Dallas

Responsibilities:

• Participated in weekly meeting, reviews and user group meeting as well as communicating with internal stakeholders and business groups.
• Defined target load plans and constraint based loading strategies and wrote ETL specifications, job scheduling documents.
• Wrote ETL specifications, job scheduling documents and designed the ETL jobs using Talend tool to load data from various environments to transfer into Postgres database.
• Created ETL specifications surrogate key management document and report specifications and best cases.
• Involved in design and development of ETL jobs, ensuring quality and compatibility of the code, review of the technical documents, coding and the job designed.
• Involved in successful deployment, user training and warranty support to end user too.
• Created context for use in various environment and business logic defined into ETL Process.
• Created sequences at job level to include multiple jobs and a layer level sequence which include all job level sequences.
• Developed and reviewed SQL queries with use of Joins Clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Environment: Postgres, Windows XP, Talend, Windows, MS office, Tableau Desktop.

Confidential, Dallas

Responsibilities:

• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of customer,air-time, and location dimension.
• Structured the dashboard with a consistent layout with visuals at the top and correspondingTabular data at the bottom.
• Created geo maps to understand the geo-spatial distribution of sales with custom symbols made to represent the customer category.
• Involved in creating dashboards by extracting data from different sources and created dashboard using parameters, sets, groups and calculations.
• Extracted and collected data using SQL to create needed reports.

Data Analyst / Tableau Developer

Confidential

Responsibilities:

• Created Tableau dashboards for reporting and performed data analysis on daily, weekly, and monthly scheduled refresh of data based on business to ensure accurate and updated information and created Tableau dashboards for reporting.
• Extensively used Tableau and SQL to analyze various attributes such as market trends and sales to generate a comprehensive dashboard for products pricing.
• Created drill though reports in dashboard and involved in creating interactive dashboard and applied actions (filter, highlight and URL) to the dashboard.
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and Microsoft SQL Server.
• Performed Tableau type conversion functions when connected to relational data sources and Maintained Tableau server in all Environments.
• Monitored application server and data server activity to track performance and system stability.
• Maintained data integrity in existing transactional databases, allowing new applications integration to go smoothly.
• Wrote several SQL Scripts such as finding tables that have identity columns, finding tables that do not have primary Key.

Environment: SQL Server, Power point, Advanced Excel, Tableau Desktop.