SUMMARY

• 9+ years of experience in IT with solid experience designing and creating data visualizations using Tableau and ETL, ERP, SQL, PL/SQL, UNIX, Informatica Power Centre, Oracle.
• Created end - to-end solution for ETL transformational jobs that involve writing Informatica workflows and mappings, SQL procedures and functions.
• Refactor the mappings to work on Hadoop Environment.
• Performed multiple performance check to get the tradeoffs among the different informatica Hadoop engines.
• Identified and established new approaches for easy path to make the ETL mappings in Informatica on Hadoop engines- Blaze and Spark.
• Worked as a TableauDeveloper. Created visualizations and dashboards as per the user requirements.
• Worked in data preparation, data transformation and reports.
• Implemented End-to-End BI Solution to decommission Cognos Metric Studio Using Power BI and Informatica.
• Good understanding of Business Intelligence concepts. Worked with Dimensions and Fact tables.
• Extensive experience and expertise in creating and analyzing data using MS Excel pivot tables and charts.
• Strong Understanding on the phases of Software Development Life Cycle (SDLC) and models including Waterfall and Agile.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager 7.
• Extensively used ETL Tool Informatica to load data from XML, Flat Files, Oracle, SQL Server, and DB2.
• Expertise in designing Test plans, defining Test cases, performing Verification and Validation, maintaining test scripts and analyzing bugs.
• Proven expertise with Quality Center (QC) /ALM (Application Life Cycle Management).
• Strong Knowledge of Functional Testing, GUI Testing, System Testing, Regression Testing, and User Acceptance Testing.
• Expertise in HPALM to manage complete testing effort, defect Tracking and Bug Reporting.
• Strong insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines, along with excellent communication and documentation skills.
• Experience in Transact SQL, ETL Technology, SSRS, Business Objects, Visual Studio for Office Add-Ins, Tableau, data warehousing architecture, and data modeling.
• Adapting ETL processes to accommodate changes in source systems and new business user requirements.

TECHNICAL SKILLS

Data Management Systems: Microsoft SQL Server 2014/2012/ 2008 R2/2005/2000, MS Access, Oracle 10g.

ETL Tools: Informatica Power Centre 8.X/9.X (Repository Manager, Designer, Workflow Monitor, Workflow Manager), SQL Server integration services (SSIS), Data Transformation Services (DTS)

Reporting Tools: MS SQL Server Reporting Services (SSRS), Crystal Reports, Tableau desktop 10.x/9.x/8.x.

SQL Server Tools & Packages: SQL Server Management Studio, Business Intelligent Studio, Query Analyser, Profiler, Performance Monitor, SQL Server Agent, ETL, SSAS, SSRS, Data Transformation Services

Languages: T-SQL, My SQL, VB.NET, HTML, XML, Bash, BTEQ, Machine Learning & Python (learning)

Operating Systems: Windows 7/8/10, UNIX and LINUX, Mac OS X

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Sr. ETL Informatica/Tableau Developer

Responsibilities:

• Perform data analysis for business users’ requests and giving solutions.
• Develop ETL mappings as per the business requirements using Informatica Developer client tool.
• Develop interface systems for creating an integration among applications.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, HTTP, XML and Union to develop robust mappings in the Informatica Designer.
• Used Informatica Data explorer IDE and Data Quality IDQ to implement Data rule taxonomy repository managing data rules to standardize and remove duplication of customer data and reporting on theexecution of rules against data.
• Involve in other data warehousing projects which may require small enhancements to the coding.
• Worked in production support for Informatica Mappings.
• Responsible for tuning ETL procedures to optimize load and query Performance
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Analyzed customers credit and transaction histories, stated preferences, and current interactions enabled tableau to identify opportunities for improved promotions, special offers, recommendations, and targeted advertising.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Developed Ad-hoc Business object reports according to user's requests.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Compared the visualized the quarterly weekly sales with previous weeks and quarters. This gave a perspective on the situation using concrete numbers
• Developed Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Set’s to create detail level summary report and Dashboard using KPI's.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Develop, maintain, and enhance Informatica Mappings, Work-flows, and processes.
• Identify and documenting ongoing maintenance requirements.
• Able to engage and drive priority issues with client stake holders which are time-sensitive

Environment: Informatica BDM 10.2, DB2, Mainframes, Postgres 9.6, Teradata, BTEQ, Fastexport, Multiload,Fastload, Hive, HDFS, Blaze, Sqoop, pgAdmin4 v2, Aqua studio v18, IBM Data Studio.

Confidential, Mount Laurel, NJ

Sr. Informatica/Tableau Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on realtime
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and design of the businessprocess, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated ontoData warehouse.
• Built Strategic, Analytical and operational dashboards using Tableau.
• Working with team of developers designed, developed and implement aBI solution for Sales, Product and Customer KPIs.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to high light the value of analytics in Executive decision support control.
• Used the automatic forecasting as a baseline to estimate progress toward making quota.
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Used Debugger to test the mappings and fixed the bugs.
• Work with BI reporting (MicroStrategy) team in preparing the required complex SQLs, used in reports.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.5.1, IDQ 9.5.1, IDE 9.5.1, Oracle 10g, SQL Developer, Teradata, TDStudio, BTEQ, Fastload, REST, SOAP, Putty, MicroStrategy, Tidal Scheduler.

Confidential

SQL/Tableau Developer

Responsibilities:

• Experience working closely with internal and external stakeholders to discuss organizational needs and gather dashboard requirements and creating functional/technical requirement documents for smooth process flows.
• Strong Hands on experience working with Tableau desktop, Tableau Prep and Tableau server in various Tableau versions including the latest 2019 series.
• Extensive knowledge in various reporting objects like Joins, Unions, Hierarchies, filters, calculated fields like LODs, Sets, Bins, Groups, and Parameters in Tableau.
• Strong hands on experience creating highly interactive dashboards, designing rich graphic visualizations with modular design of reports, worksheets and views in Tableau with a strong understanding of the appropriate chart types (Bar charts, Line charts, scatter plots, box plots, field Maps, Bar in Bar, Pyramid charts, Line and Bar) to use to highlight patterns in the data, answer questions, and communicate results.
• Knowledge about the different data sources that Tableau can connect to like relational databases (RDBMS), flat files, cubes etc.
• Demonstrate advanced knowledge of Tableau, including Table Calcs, LOD Expressions, Parameters, and Dashboard Actions
• Excellent knowledge of Tableau calculated fields, parameter controls, hierarchy, groups, sets, dashboard actions, filters, annotations etc. in Tableau
• Strong understanding of Data Visualization concepts and ability to identify trends & patterns in the data for providing actionable insights using Tableau Analytics Pane
• Experienced in Tableau Server administration including Publishing workbooks, publishing data sources, schedules, creating sites and projects, creating and adding new users/groups/roles, managing users and groups, assigning permissions, keeping revision history and setting up data driven alerts.
• Pretty familiar working in Agile/Scrum development methodology
• Exhibit excellent communication, time management, problem solving, organizational skills and ability to work directly with clients, technical and management personnel.
• Fast learner with the ability to work under little or no supervision.
• Works well individually and in teams, shares information, supports colleagues and encourages participation.
• Proven ability to be able to multitask as well as assess and change priorities.
• Willing to go the extra mile with a strong work ethic; self-directed and resourceful.
• Motivated and enthusiastic team player that takes ownership to deliver successful results.