SUMMARY

• Around 8 years of IT experience with emphasis on business requirements gathering and analysis, design, development, testing and data management.
• Sound knowledge of Retail, Finance, Insurance, Biotechnology and Pharmaceutical industries.
• Proficient in Tableau 9.x/8.x/7.x/ 6.x (Desktop, Server, Public, Mobile).
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups and migrate objects of Tableau repository.
• Created various Tableau Reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting
• Created incremental refreshes to pull the delta records from data sources to Tableau Extracts.
• Creating users, groups, projects, Data connections, setting up roles as a Tableau administrator.
• Created subscriptions to deliver the reports on a scheduled time through email.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Extensive experience in conducting Gap Analysis, Business Process Re-engineering, and Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.
• Experience to work with senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development and to manage risk analysis and mitigation plans, status reports, and client presentations.
• A highly motivated and excellent team player with technical expertise in software engineering processes and outstanding knowledge on life cycle of the software design process (SDLC).
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Organized numerous Joint Application developments (JAD) sessions, Interviews, workshops and Requirement Elicitation sessions with end-user/clients/stake holders, Subject Matter Experts and the technology group.
• Experience in development of data mappings and the development of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Posses strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Good knowledge in Microsoft Sharepoint 2010; proficient Star Schema dimensional modeling, which includes understanding business, processes, modeling dimensions, hierarchies and facts.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Proficient in Teradata, Oracle, DB2, MS Access, Informatica, MS SQL Server, MicroStrategy, and Business Objects.
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).
• Proficient in streamlining business processes by recognizing and avoiding bottlenecks, thereby reducing cycle time and improving system efficiency.

TECHNICAL SKILLS

BI Tools: Tableau 9.x/8.x/7 (Desktop/Sever/Reader), Business ObjectsMS SQL Server Reporting Services, MOSS

SQL Tools: Rapid SQL, Toad, Teradata SQL Assistant, PL/SQL Developer

Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio.

ETL Tools: Informatica, Data Stage, MS SQL Server 2008 (SSIS)

Reporting Tools: MicroStrategy, Business Objects, Cognos, Qlikview

RDBMS: Teradata, Oracle, DB2, QMF, VSAM, SQL Server.

UI Tools: CICS, PUTTY, Visible Analyst, Lotus Notes

Testing Tools: Mercury Test Director, IBM Rational Tester, Quick Test Professional (QTP)

Scripting/Lang.: C, HTML, PERL, SQL, PL/SQL, COBOL and XML

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Mainframes, Windows 8/7/XP/2000

PROFESSIONAL EXPERIENCE

Confidential, Hopewell, NJ

Sr. Tableau Developer

Responsibilities:

• Interacting with Business Architect and Reporting Manager, gathering the requirements according to client needs.
• Interact with business representatives for requirements analysis and to define business and functional specifications.
• Involved in requirements gathering creation of use cases, usage scenarios and solution architecture.
• Involved in migration reports from Oracle BI publisher to Tableau. And involved in Data extraction and transformation to Oracle BI to Tableau.
• Created customized dashboard layout in order to neatly fit and present OBI Publisher reports to the customers.
• Administered the entire OBIEE application. Implemented LDAP security, managed access to the reports through roles and permissions.
• Created Reports using different Database connections like Amazon Redshift, Hadoop, IBM DB2.
• Involved in developing reports on Financial Data, Investment management, Credit Management, Risk Management.
• Implemented filters and parameters in transformation of reports to end users.
• Used various transformations to build mappings to meet the business requirements.
• Interacted with the end user, with regular project update and hosted status meetings.
• Created customizable mapping by passing parameters at session level.
• Test all the Developed reports and transport the data to target warehouse, and Tableau Server.
• Scheduling the reports on Tableau Server and refreshing the Data Store on the Server.
• Implemented Installation of Tableau Desktop 9.0/8.3 and Tableau Server.
• Involved in Performance Tuning on the Tableau Dashboard by restricting unwanted data and keeping context filters on the data store.
• Handled in updating versions of Tableau Desktop and Tableau Servers.
• Setting the user permissions in Tableau Sever.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Deep experience with the design and development of Tableau visualization solutions.
• Created different reports containing charts showing end of day trade details and statistics.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Provided 24/7 production support for Tableau users.
• Contributes to team effort by accomplishing related results as needed.

Environment: Tableau Desktop 9.0/8.3/8.2/8.1/8.0, Tableau server / Administrator, tabcmd, SQL developer, Metal (Meta Data Driven ETL), BI Reports, MS Access, MS Excel, MS PowerPoint, SOAP UI, Web-services, SQL Server Management Studio, Big Data Hadoop, VB. SQOOP, GUI.

Confidential, Raleigh, NC

Sr. Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Experience with the design and development ofTableauvisualization solutions.
• Involved in creating dashboards and reports inTableau. Created report schedules onTableau server.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Developed of key indicators and the appropriate tracking reports with graphical and written summations using summary and Annotations to assist in the quality improvement initiatives.
• Created quick Filters, customized Calculations, Conditional formatting for various analytical reports and dashboards.
• Extract, transform and load data from multiple data sources into the QlikView application
• Design, build, test and debug QlikView solutions based upon specified requirements
• Studying the existing system and conducting reviews to provide a unified view of the program.
• Involved in creating Informatica mappings, mapplets, worklets and workflows to populate the data from different sources to warehouse.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Tune data loads and QlikView application for efficient performance
• QlikView user interface knowledge: charts, graphs, tables, expressions, properties, tabs, layout
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau Server 8.x, Tableau Desktop 7.0,8.0, Teradata 12, SQL Server 2008, PL/SQL, SQL Developer, Informatica Power Center, SQL Server 2008, Control-M.

Confidential, Harford, CT

Tableau Developer/Sr. Data Analyst

Responsibilities:

• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Responsible for gathering business requirements, doing gap analysis and documenting them textually or within models.
• Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on Symbol maps, Bubble chart, Drill down analysis using tableau desktop
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Implemented row level security (Data security) and object (Roles and Permissions) level security.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to Scrum for the stakeholder review.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped.
• Extensively used SQL scripts for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data.
• Responsible for the design, development, testing and implementation of systems to load source data into Target databases using Informatica.
• Identified and developed quality management plans, test scenarios, and test scripts for user acceptance based on system requirements.
• 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 Server 6.x,7.x, Tableau Desktop 6.x,7.x, Oracle 10g, TOAD, MS SQL Server 2008, Share Point, TFS, Informatica 9.1,UNIX, SQL Server 10g, Erwin, MS VISIO, Microsoft Office Suite.

Confidential, San Francisco, CA

Business Systems Analyst/Data Analyst

Responsibilities:

• Interacted with various business people in External Vendors side and gathered the business requirements and translated them into technical specifications.
• Documented business requirements, discussed issues to be resolved and translated user input into ETL design documents.
• Experienced working with team, lead developers, Interfaced with business analysts, coordinated with management and understand the end user experience.
• Worked with data architects and DBAs to design and implement Conceptual data model, Physical Data Model, Informatica mappings and workflows to meet business requirements.
• Involved in ETL process through the entire SDLC from analysis/design to production deployment.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Logged on to the QC Centre to find out the defects posted by testing team and fixed those defects.
• Used SQL Loader to load the flat file data into temp tables to compare the data with that generated from CMA.
• Involved in creation of Schema objects like Indexes, Views, and Sequences.
• Extensively worked with Unix Shell scripting to validate and verify the data in the flat files generated by the ETL process.
• Designed post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
• Scheduled the Informatica Workflows to start running at specified date and time repetitively forever.
• Participated in User Acceptance Testing to validate the data in the flat files that are generated by the ETL Process.
• Coordinated with the Informatica administration team during deployments.
• Provided the production support and solved the production issues immediately after they are noticed.

Environment: Informatica Power Center, Oracle10g, MS Access, TOAD, SQL Developer, PL/SQL, UNIXMercury Quality Center, WindowsNT4.0

Confidential

Business Systems Analyst

Responsibilities:

• Conducted meetings with Subject Matter Experts (SME) to understand the workflow of the business and their application processes Analysis the business functionality of CMS Analysis of all the projects of past related to the functionality.
• Performed GAP analysis to derive requirements for existing systems enhancements
• Involved in writing of Business Scenarios for functionalities used by the systems.
• Analyzed business requirements and translated it into the Functional Designed Document (FDD), to be used as reference by Development and testing teams.
• Experienced working with team, lead developers, Interfaced with business analysts, coordinated with management and understand the end user experience.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Providing support to System and Regression testing team to implement business logic into system at the time of testing and to create test data.
• Part of SME pool to support the Production team to help developers, testers to resolve the production defects.
• Designed and managed project plans and schedules. Managed resolution of project issues and conflicts throughout the System Life Cycle
• Followed the White box and Black box testing for crosschecking design decisions and assumptions against source code

Environment: Informatica PowerCenter, Oracle, MS SQL Server, SQL, Toad, MS Office Suite ( Word, PowerPoint, Excel), MS Project, MS Visio, Windows 2000.