SUMMARY

• 6+ years of experience inSoftware Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
• ExtensiveTableau Experience in Tableau 7.x/8.x (Desktop, Server, Reader, Mobile) as a Developer and Analyst
• Competent inSoftware Development Life Cycle methodology (SDLC)andSoftware Testing Life Cycle (STLC)which includesRUP, Agile and Waterfall Methodology.
• Strong knowledge ofBusiness/Process Data flowin organizations and experienced in data modelling concepts.
• Mastered the ability to design and deploy richGraphic visualizationswithDrill Down and Drop down menu option and Parameterized using Tableau.
• Prepared Dashboardsusing calculations, parameters in Tableau
• Extensive knowledge in various reporting objects likeFacts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parametersetc., inTableau Desktop.
• Worked on the development ofDashboard reportsfor theKey Performance Indicators (KPI)for the top management.
• End to end experience in designing and deploying data visualizations usingTableau.
• Excellent understanding ofData modeling(Dimensional & Relational) on concepts likeStar - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle),, MS Access and client/server applications.
• Good knowledge ofNormalization/De-normalization, data design methodology and building Referential Integrity.
• Extensive experience inPL/SQL and SQLand in performance tuning SQL queries inPL/SQL Developer.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth
• Utilized all Tableau tools including Tableau Desktop, Tableau Public, and Tableau Reader extensively
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Expertise in generating reports using global variables, expressions and functions for the reports.
• Extensively worked inOLTP & OLAPenvironments that include QA, Production and development, implement maintain database schema (in source code control) andEntity relationship diagramsfrom business requirements.
• Experienced in tuning long running SQL queries for better performance.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level Data Analysis and Data Management Services.
• Experience inTechnical Support, Troubleshooting, Report Design and Monitoringof system usage.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizingOracle RDBMS Methodologies.
• Strong interpersonal skillswith demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop v7.x/v8.x, Tableau Server v7.x/v8.x, Crystal reports XI/2008

Databases: MySQL, MS SQL Server, ORACLE, MS Access

ETL Tools: Informatica Power Center, Power Exchange/ Power Connect

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, JIRA

Data Modeling: Power Designer, MS Visio

Programming Languages: SQL, PL/SQL, XML, HTML, C#, ASP .NET

Document Management: Documentum, Share point, Ultra Edit

Defect Management tool: HP Quality center

Service Management Tool: HP Service Manager, CA Service Desk

BI SUITE: SQL BI Suite (SSRS / SSAS)

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETLOLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in relational databases that can be used for development of various Tableau reports/ dashboards.
• Building, publishing customized interactive reports and dashboards using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’sneeds.
• Provided support for Tableau developed objects and understand tool administration.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau 8.2/8.1, Informatica 8.X, Oracle 11g, PL/SQL Developer, Flat Files, XML files, Informatica Power center 9x, MS Visio.

Confidential, Schenectady, NY

EDW Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing
• Analyzing the given story/requirements, brainstorming and preparing field level mapping documentation and Design documentation.
• Involved in development of Logical and Physical data models that capture current state/future state data elements
• Developing Informatica mappings using different transformations SQL transformation, Union, XML generator, Source qualifier, Expression transformation, Joiner, Update strategy, sequence generator transformation, Lookups, Filter, router, Normalizer, Aggregator transformation, XML parser, Stored procedure etc.
• Created the Mappings, sessions & workflow which extracts the data from the files and relational databases to load it in to target data base i.e. SQL Server database
• Developing Informatica workflows using reusable as well as non-reusable tasks such as command task, event raise, event wait, Decision, timer, sessions and workflows
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed Story Telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• 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.
• Preparing Implementation plans, promote documentations and raising service desk tickets for promotes to admins.

Environment: Oracle 11g, PL/SQL, Informatica 9, Facets, Amisys, PL/SQL developer, Tableau8.1, PLSQL developer and UNIX.

Confidential, Glen Allen, VA

Tableau Developer/Analyst

Responsibilities:

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Building, publishing customized interactive reports and dashboards using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Provided support for Tableau developed objects and understand tool administration.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau 8.2/8.1, Teradata, SAP Business Objects 4.1/4.0, IDT, UDT, WEBI-BI: SAP BW Query Designer, Analyzer, Teradata SQL Assistant, Teradata Administrator, SQL BI Suite (SSRS / SSAS) 2012.

Confidential, Plano, TX

Tableau developer

Responsibilities:

• Scope of the project was to enhance the Mobile Banking App’ssystematic processes which were associated with Confidential ’sPersonal Banking division. Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements.
• Involved in End-to-End Implementation and Enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Studied and analyzed similar applications and brainstormed with business team to Gather Effective Requirements for the system along with dashboard development.
• Created numerous Dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab’sto display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed Story Telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• 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.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Teradata, SQL Server, MS Excel, CSV, Win Server 2008 R2, Active Directory

Confidential

Informatica Developer

Responsibilities:

• Worked closely with onsite team and client to understand the requirements for enhancements, Issues, System improvement tasks and bug fixes.
• Prepared root cause analysis, estimation and Unit testing plan documents
• Worked Extensively on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Designed and developed Mapplets for faster development, standardization and reusability purposes
• Designed and developed new mappings in Mapping designer and sessions and workflows in Workflow manager and modified existing ones to extract data from SQL Server, Excel, and Flat files and load to Oracle database as per business requirements
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement
• Informatica jobs monitoring, rescheduling, reviewing session and workflow logs, fixing jobs in case of failures and sending daily status reports to customer.
• Designed and developed various reports using Crystal reports
• Analyzed the existing Crystal reports and tuned for faster execution. Troubleshoot existing reports to eliminate data discrepancies and respond to end-user inquiries
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow
• Performed unit testing to validate mappings and populate the database
• Worked along with the QA Team and provided production support by monitoring the processes running daily
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.5, Erwin 4.1,Oracle 10g, SQL, PL/SQL, Toad, Crystal Reports XI, XML Files, Flat files, MS Office, SQL * Plus, UNIX, Windows XP.

Confidential

Database Developer/ Jr. ETL Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Developed Informatica mappings, reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, LOOK UP (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading
• Create/build and run/schedule workflows and worklets using the Workflow Manager.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of the workflows. Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks
• Performed Unit Testing at development level, Source code migration and documentation
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. Coded database triggers, functions and stored procedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security, Maintained system security, control and monitor user access to database.
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.

Environment: Informatica Power Center 8x, Oracle 10g, PL/SQL, Erwin and Toad.