SUMMARY

• Over 9 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• 4 years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensive experience in Data Analysis
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, SAP BW, MS Access and client/server applications.
• Extensive experience working as a Business Intelligence Consultant with specialization in Business Objects 6.0/ 6.5/ XIR2/ Crystal XI and Web Intelligence.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• 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.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

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

ETL Tools: Informatica, Data Stage, Talend, Microsoft SQLServer Integrated Services(SSIS)

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint Excel)

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

Databases: Oracle 9i, MySQL, DB2 9.0

Document management: Visual Source Safe 6.0, Share point, 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

Visualization Tools: Tableau Desktop 8.2/8.1/7, Tableau Server 8.2/7, Tableau Reader.

Data warehousing /BI: OBIEE 10g, Hyperion Essbase, BI publisher.

Tools: Informatica Power Center 8.1.1/7.1.2/7.1.1/7.1.5, DataStge 7.5

Tools: Erwin 4.0, SQL Developer, TOAD, Pl/Sql Developer Tidal Enterprise Edition and MS Visio.

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, Teradata and IBM DB2.

Languages: PL/SQL, SQL, HTML,C,C++,Java

Environment: Windows XP/2000/2003/NT 4.0/Vista, UNIX, Sun Solaris, Linux and MS-Dos.

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.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• 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.
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later.
• Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer and Google Big-Query.
• 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 functional design document.
• Participated in the retrospective meetings and next sprint planning meetings.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau desktop 8.1/8.2, tableau server 8.1/8.2, OBIEE 11g,Microsoft SQl Server, Google Big-Query, SSIS, SSAS, Salesforce, Talend.

Confidential, Parsippany, NJ

Senior Business intelligence / Tableau Developer

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Purchasing, Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Consolidate multiple data silos that exist on campus to one location.
• Scheduled data extracts on a daily basis.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.

Environment: Windows XP, Linux, Windows 7,Tableau, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB

Confidential

Tableau Developer/Business System Analyst

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.
• 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.
• 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 various geographic 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 creep issues.

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

Confidential

Data Analyst

Responsibilities:

• Data Profiling and Assessment on DB2 Relational database and IMS hierarchal database across different LOB's in insurance domain.
• Identify which data elements with the SME (Subject Matter Expert) to be assessed and loaded into Trillium Discovery (13.5), TS Discovery 14.0 before analyzing the data.
• Create business rules in Trillium, Micro strategy to find the incorrect data and compare with source allowed values
• Identify the anomalies and follow up with the SMEs to find if it is an unexpected result or an anomaly and prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings and profiling results
• Document data assessment findings and prepare identified anomaly sheet for internal conversion process and Share the results with Stakeholders and data assessment core team
• Provided recommendations to clean up the source data, Application / System modification, perform further research if needed before the final data transformation Conversion team.
• Suggestions to fix the anomalies during conversion stage or DB
• Validation and Prepare Test Cases for Conversion Purposes
• Assist in creating transformation rules with the Business Subject Matter Experts (SMEs) and involve in the process to create data mapping requirements for Population Synchronization (ETL) and DB Validation.

Environment: Trillium Discovery, PL/SQL, Control-D, Lotus Notes, Micro Focus Rumba, MS Office, Windows 7, Share Point

Confidential, Boothwyn, PA

BI/SQL Developer(SSIS, SSAS, SSRS)

Responsibilities:

• Defined data types, created database and database objects such as tables and views
• Tested the table with complex queries such as Joins, Sub-queries and Temp Tables
• Converted complex business logic into T-SQLStored Procedures and User Defined Functions
• Created indexes (Clustered & Non-clustered) to reduce data retrieval time
• Used Try Catch in stored procedure to perform error log mechanism
• Created ETL packages to migrate data from different data sources to data warehouse by using SSIS
• Created Custom Logging in SSIS packages
• Wrote queries to create drill down, drill through and ad-hoc reports on regional analysis on pharmacy, nursing and benefits services using SSRS
• Actively supported business users for changes in reports as and when required using SSRS
• Used complex expressions to group data, filter and parameterize reports
• Deployed reports on server using SSRS and created linked reports and snapshots
• Designed and created data mart, fact tables, dimension tables and online analytical processing (OLAP) cubes for the analysis of business condition using SSAS

Environment: MSSQLServer 2008 R2,SQLServer Integration Services (SSIS) 2010, MSSQLServer Analysis Services (SSAS) 2010,SQLServer Reporting Services (SSRS) 2010,T-SQL, MS Office

Confidential

Sr. SQL Developer

Responsibilities:

• Plan, design, and implement application database code objects such as stored procedures and views.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data files for counterparties.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Trained and mentored EBI team, users andassisted and coached them inmaterial, processes and delivery of training, training standards and best practices.
• Interacted with report owners to establish/clarify their requirements and developed report specifications.
• Performed development activities from gathering requirements and designing solutions, through developing code/ reports, to testing and release / deployment

Environment: Microsoft, Linux, Oracle 10g / 9i / 8i / 7.x, DB2 7.x / 8.x, SQL Server 2005/2000, MS Access 2000

Confidential

Application Developer

Responsibilities:

• As a team member, involved in the activities of Analysis, Design, Development, Unit & integration testing, Implementation and extended
• Support to Post-Implementation.
• Played a key role in coordinating the activities, understanding the existing business requirement and translating them into design Specifications.
• Handled Production Support for Members application everyday by fixing jobs within the SLA times.
• Coordinated with onsite in resolving critical production issues.
• Handled knowledge sharing session and guidance sessions for trainees in the project.
• As a key team member, involved in Development, Testing and Baseline Production Support activities in member application.
• Understanding the business requirements of the End User.
• High level design using MS Visio
• Specification (Low Level Design) Creation for new Requirement and Enhancement
• Worked in Coding new programs in COBOL, DB2, and VSAM.
• Involved in Unit testing, System testing, Regression testing
• Worked on QMF report Creation for SQL testing

Environment: COBOL-II, JCL, MVS, DB2, VSAM File Aid, TSO/ISPFSPUFI, EXPEDITOR, QMF