SUMMARY

• Overall 8 years of extensive IT Experience in Data Warehousing and Business Intelligenceapplications in Financial, Health Care and Automobile industries.
• Proficient in Tableau 6.x/7.x/8.x Desktop, Server , SAP Business Objects and SSRS.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• 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.
• Expertise in Teradata 13.10, Oracle, SQL Server, Informatica, SSIS, SSRS, SSAS, Microsoft Office Suite.
• Participated in Tableau 9.0 Beta release both in Tableau Desktop and Tableau Server
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unittesting, Integration testing, System testing, Regression testing, and User Acceptance Testing UAT .
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post-Production support.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD,Waterfall and Agile.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

TECHNICAL SKILLS:

BI Tools: Tableau 7.x/8.x, Trillium Discovery

ETL Tools: Informatica, Data Stage, Talend, Microsoft SQL ServerIntegrated

Services SSIS

Front End Tools:Microsoft Project, Microsoft Office, Visible Analyst

Databases: Oracle 9i, MySQL, DB2 9.0Document management Visual Source Safe 6.0,

Sharepoint, Ultra Edit, Documentum

Defect management tool: HP Quality center 10.0

Programming Languages: C, C , COBOL, DB2, JCL, SQL, PL/SQL 2.X.

Data modeling: Power Designer, Erwin, ER Studio, MS Visio

Other Tools: Requirements Management Requisite Pro, Toad, Sub Version

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Worked with Source system Subject Matter Expert SME to ensure that the extracts are properly mapped.
• Worked on the backend SSAS cube development which was the source data for the tableau.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Designing and Developing the ETL Architecture and restructuring the reporting layer.
• Prepared dashboards using calculated fields, parameters, calculations,groups, sets and hierarchies in Tableau.
• Created Filter and Url actions to navigate from the Executive Dashboard to the Detail Report and implemented the back button logic to navigate back to the
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Extensively used calculated fields for different logics for Trend,Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functionaldesign document.
• Involved in Onsite Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau desktop 8.1/8.2/8.3, tableau server 8.1/8.2, OBIEE 11g, Microsoft Sql Server,SSIS, SSAS, Talend

Confidential

Tableau Developer

Responsibilities:

• Served as Business Systems Analyst meeting deadlines and budget requirements.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• ETL Design and Development of Mappings in Informatica.
• 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.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Designing the ETL Architecture and merging with the Existing model
• Worked on drill through reports by creating HTML references.
• Migrated all the reports, dashboards, scorecards from Tableau 7.0 to Tableau 8.0 after testing the version on Sand Box.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends at variousgeographic locations.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• 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 creepissues.

Environment: Tableau 7.0/8.0, Teradata 13.10, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential

BO Report Developer

Responsibilities:

• Directly coordinating with user to gather the new requirements and working with existing issues.
• Generated Cross Tab, Charts Vertical Business Objects Reports using Web Intelligence Rich Client using Universe.
• Migrated upgraded Business Objects from 6.5 to 3.1 Using Import Wizard.
• Designed Universes for Financial Billing system and Order processing
• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and Universes.
• Involved in joining the tables by creating aliases to resolve the loop
• Created Reports based on subtotal of Currency and General Ledger category
• Created many reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals
• Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Perform unit testing, system testing and user acceptances test UAT for universe, reports and security management.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Developed universe user documentation guide for the end users reference.
• Successfully Migrated Developed Reports from Development Environment to Testing Environment and once testing is done then moved them to Production Environment using Import Wizard.
• Taking the Backup of Existing BO Reports and Universe using Import Wizard.
• Worked on Informatica, and used functions like lookup, date, conversions, etc. in Mappings.
• Responsible for creating mapping and transformation specifications based on the business requirements from various business teams.

Environment: Business Objects 3.1/6.5, Import Wizard, Report Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer, Info View, SQL Server2000,TSQL, SQL, PL/SQL Windows 2003. Informatica.

Confidential

Business Objects Developer

Responsibilities:

• Assigned Scheduling Rights as per the User Requirements
• Published reports in Business Objects Enterprise XI R2 using Central Management Console and Publishing Wizard.
• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management
• Work with Business Users and team leads to develop system requirements, analyze data Element andcontinuous end-user support.
• Work with production team to coordinate and assist in rollout of releases.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Worked with BO support in troubleshooting issues and provide logs as per request for resolving several complex issues
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Provided solutions to various groups for scheduling reports using Packages and event based job scheduling.
• Co-ordinating with various groups in scheduling releases between environments.
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Experience on Developing Crystal Reports.
• Daily reporting to Management on status, issues, migrations, escalations and progress.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit
• Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.
• Experience managing user accounts and group accounts in Crystal enterprise environment.

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle 10g, Clear case

Confidential

Business Objects Developer

Responsibilities:

• Used multiple sub reports, pass through parameters and pass by parameter linking for generatingcomplex reports for management.
• Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like variables, prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit
• Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Monitoring Scheduling Reports
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.

Environment: Business Objects, Universe Designer, Web Intelligence. Oracle 10g