SUMMARY

• 7 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 Tableau8.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, 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.
• 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.

TECHNICAL SKILLS

BI Tools: Tableau 9.0x/7 (Desktop/Sever/Reader), Business Objects, MS 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, DataStage, 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 7,8/XP/2000

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

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.
• Worked on data blending and linking in case of merging different sources.
• Created a dual-axis chart with multiple measures and Synchronize the scale as per the need.
• Performed Tableau type conversion functions when connected to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server.
• 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, 9.x, Tableau Desktop 8.x, 9.1, Teradata 12, SQL Server 2008, PL/SQL, SQL Developer, Informatica Power Center, SQL Server 2008, Control-M

Confidential, Philadelphia, PA

Tableau Developer

Responsibilities:

• Responsible for gathering business requirements, doing gap analysis and documenting them textually or within models.
• 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.
• 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.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Involved in creating advanced Tableau functionalities such as geographic mapping, data blending, extract optimization to create advanced chart types and visualizations.
• 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, Irvine, CA

Data Analyst

Responsibilities:

• Identify and analyze Business Requirements from documents and end-user discussions which involved in the review of Service Oriented Architecture (SOA) and design of data models which include Staging in data warehouse.
• Expert Enterprise Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball data warehouse methodologies.
• Identified the Objects and relationships between the objects to develop a Conceptual, Logical and Physical model in Erwin tool and later translated the model into physical model using the Forward Engineering technique in Erwin tool.
• Ensuring the accuracy and level of information supports the business requirements, as well as subsequent development activities comparing the data loads between new EDW (Enterprise Data Warehouse) production system and the retiring system.
• To reduce the bandwidth and execution time and also applying conditional logic, stored procedures are introduced in respected DBMS.
• Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports using Erwin Tool.
• Perform application testing eg.: of loading, reporting interfaces to BDW to verify all systems are in place and operational and the data restored is correct.
• Conducted JAD sessions, and design discussions to come out with the appropriate data mart.
• Experience defining enterprise data location architectures for ODS, Data mart, and Data Warehouse data.
• Created test cases for carrying out unit testing and part of functional testing.
• Documented the business logic in MS- Access associated with the development.

Environment: Erwin, ER/ Studio, DataStage, Oracle, DB2, SQL Plus/ PLSQL, Perl, Teradata, Quick Test Pro, TOAD, UNIX, MS Office Suite (Word, PowerPoint, Excel), MS Project, MS Visio, Windows 2000

Confidential, New York, NY

Data Analyst

Responsibilities:

• Actively involved in understanding business requirements, collecting data, performing data analysis and data migration as per the business need to maintain Data Warehouse/Data Mart.
• Used UML diagrams to graphically capture system designing.
• Maintained data consistency and referential integrity.
• Performed data extraction from different source systems (flat file, RDBMS, Excel).
• Performed data cleansing/scrubbing, Performed Data Analysis and Data Quality Checking.
• Executed complex SQL sub queries to prepare ad-hoc reports in Oracle.
• Wrote SQL queries using derived tables and joins to extract data from the database.
• Used OLAP functions like RANK, QUALIFY, CSUM, SAMPLE and RANDOM.
• Created macros and wrote stored procedures to increase efficiency.
• Performed data analysis, created GAP analysis document, and performed data quality checking.
• Analyzed the necessary tables that need to be populated into the staging database.
• Performed numerous data extraction requests involving SQL scripts
• Involved in analyzing the source data coming from different Data Sources
• Performed in depth analysis of data & prepared periodic reports using MS Excel and SQL.
• Defined key facts and dimensions necessary to support the business requirements.
• Made statistical analysis and reports using SAS.
• Flat file conversion from the data warehouse scenario.
• Created Fact and Dimension tables in Mart.

Environment: UML, SQL, TOAD, Oracle, MS Office Suite (Word, PowerPoint, Excel), MS Project, MS Visio, Windows 2000

Confidential

Jr.SQL Developer

Responsibilities:

• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction
• Prepared functional specifications for user requirements.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Createdentry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.
• Created Tables, Indexes, Table Spaces, Views synonyms,andintegrity constraints.
• Involved in creation ofschema objects, roles and privileges, users.
• PreparedUser manual, Technical documentsfor the end user.
• Prepared executables for system deployment and led the release of applications following

Environment: SQL, PL/SQL, SQL*Loader, Windows XP, UNIX