SUMMARY:

• Over 15 years of IT industry experience with last 7 years in Tableau Visualization tool
• Extensive experience in various database technologies (Oracle v8/9i//10x/11x), relational database design using Entity - Relationship diagram tools like ERWin, SQL, Procedures and Functions, N-tier architecture and technologies (KIVA Enterprise server, Weblogic etc.), reporting tools like Tableau and ETL tools like Informatica, Data Analytics using R, Hadoop ecosystem
• Tableau Developer Experience: Worked on Tableau versions 7.x/8.x/9.x and current version (ver 10.x)
• Business Analyst Experience: Ability to drive the full analysis and product development cycle leveraging my communication and presentation skills with various stake holders in customer organizations.
• Collaborative Efforts: Worked in teams varying from 5-12 members, to gather Business requirements and develop Business Rules using tools like ARIS Business Rule Engine in conjunction with SAP Netweaver
• Worked on SAP Business Objects Data Services XI 3.2,4.0/4.2, SAP BI/BO 4.0,Xcelsius 2008 sp4, Crystal Reports XI/2008, Web Intelligence, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

Data Integration/Tableau Consultant

Resposnibilities:

• HL7 2.3, CCDA standards
• Implemented Segments, Triggers and Events
• FHIR 1.0 standards (Fast Healthcare Interoperability Resources)
• Identification of Resources, Creation of Resources, Modification and Deletion of Resources
• FHIR supported interoperability information exchange architectures/paradigms.
• Implemented Messaging, Documents, Services and REST (Representational State Transfer - on-line access)
• Implemented Key concepts of FHIR - Resources, Extensions, Data types, Bundle and Profiles
• Ensemble Integration Engine
• Creation, monitoring and maintenance of Production involving
• Business Services (define the adapters to connect with the incoming data in the file or db format. Involves setting the connection parameters with the file directory on the incoming server, TCP/IP connection, the port number etc)
• Business Operations (Same as above except for the outgoing destinations)
• Business Process(Define the Business logic/rules based on the business requirements, related to the flow and transformation of the data. Use Ensemble BPL to define the business logic).
• Creation/Maintenance of Business Logic
• Data transformation, adding activities, requests and responses, record mapping etc
• Developed dashboards and worksheets for correlating and analysis of patient data.
• Developed data visualizations and interacting with Business users to understand and analyze their requirements.
• Created dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculated fields.
• Involved in creating a dual-axis bar chart with multiple measures and also created bins for different measures.
• Implemented data blending in order to merge data from different sources.
• Used and applied actions like filter, highlight and URL to dashboards.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, SQL Server and Oracle.
• Developed local and global filters while preparing worksheets and dashboards in Tableau.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Performed Tableau type conversion functions when connected to relational data sources.
• Experience in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables.

Environment: Tableau Desktop, Tableau Server 9.x/10.1, MS SQL Server 2012, MS Excel, SQL Server Management Studio,, MS Office 2010/2013.

Business Analyst/ Tableau Developer

Responsibilities:

• Responsible for executing all the phases of Business Analysis for Visualization project for KPJ
• Initiation/Conceptualization - Stakeholder discussions, Requirement gathering and research
• Gathered and documented the objectives of the process thus understanding the big picture of the exercise (maximize the RoE - Return on Equity)
• Planning - project scope definition and documentation, Business requirement gathering
• Analysis and Design - Feasibility study, created the POC, UX Design
• Develop various data connections from data source to Tableau Server for report and dashboard development
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments
• 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.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions and Hierarchies feature in tableau.
• 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.

Environment: Tableau Desktop 8.2 and 8.3, Tableau Server 8.2 and 8.3, MS SQL Server, MS Excel, CSV, Win Server 2008 R2, Active Directory, Tableau Data Extract (TDE)

Consultant Tableau Developer Etiqa Insurance

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• 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.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.0 .
• Created multiple visualizations like Heat Maps, Bar Graphs, Bullet Graphs .
• Preparing Dashboards using calculations, parameters in Tableau.
• 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.
• Defined best practices for Tableau report development.
• Extensively used data blending in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.

Environment: Tableau 8.x/9.x, SQL, PL/SQL, Oracle 10g, Confidential Office Suite(Word, Excel, Outlook, Power Point).

Consultant- SAP BW/BI/ETL Prudential

Responsibilities:

• Designing and Developing ETL jobs using BODS for migration of data from Source DW to Target system.
• Actively involved in requirements gathering, design discussions, source data analysis, preparing mapping document and design documentation.
• Developed flat file formats to load staging jobs from different sources like flat files, excel workbooks and .csv files. Extensively used lookup, lookup ext functions in Data Integrator to load data from source to target.
• Performed extract, transform and load operations using BODS transformations such as Query transform, SQL Transform, Row generation, Table comparison, History preserving, Map operation and Key generation transform.
• Configured the mappings to handle the updates to preserve the existing records using History Preserve Transformation for Slowly Changing Dimensions Type-2.
• Performed incremental loads using Map operation, Table comparison transforms, Auto correct load options based on the operation code to insert/update/delete.
• Used SQL Server to write SQL queries, joins to test ETL tables.
• Created Scripts, declared local Variables, global Variables and fine tuned complex transformations in the data flows.
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data Cleansing process.
• Implemented Try and Catch mechanism to handle errors and scripts objects, variables and parameters at data flow and work flow level. implementation and testing for change requests, complex SQL analysis.
• Performance tuning of SQL queries like pushing down operations to database level, using cache memory, Degree of Parallelism, collect statistics to monitor jobs, implementation of recovery mechanism, Error handling and setting up validation rules.
• Using Data Services Management Console to schedule and run jobs, Manage Repositories and perform Metadata Reporting.
• Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP Cubes.
• Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Stacked Bar, List Views etc creatively using best Xcelsius components effects for better interaction.
• Actively involved in Proof of Concept on usage of SAP HANA 1.0 SP8.
• Experience in SAP HANA Data Provisioning with Data Extraction Transfer Loading (ETL) using SAP Data Services.
• Integrating SAP and Non SAP Data through Data Services into HANA DB.
• Experience in setting up connection to SAP HANA and loading data through data services.

Environment:: SAP Business Objects Data Services XI 3.2,4.0/4.2, SAP BI/BO 4.0,Xcelsius 2008 sp4, Crystal Reports XI/2008, Web Intelligence, MS Sql Server 2008, Sql Developer, Sql Server 2008 Management Studio, SAP HANA

Senior Consultant

Responsibilities:

• Lead Generation, Cold calling, setup CRM, sending emails, writing proposals to Residential Owners, Qualifying customers for new loans and re-financing
• Sold and Refinanced loans of over $6M
• Collaborated with multiple parties to closed Real Estate deals worth over $3M
• Sustained relationships with all the concerned parties, especially the buyer and the seller.
• Ensured high customer satisfaction and generated future business worth millions through references of satisfied clients

Director of Consulting Services

Responsibilities:

• Managed and built a team of 8 Customer support Engineers for US territory
• Escalated and interfaced with the Engineering department to resolve critical Customer issues, improve customer satisfaction resulting in additional business and on time renewals.
• Supported the NA Account Managers in reaching their consulting sales targets of $3M quarterly. Sometimes exceeding their targets.
• Strategically planned additional consulting revenue streams including post sales services, staffing and additional feature enhancements specific to the client’s requirements.

Director of Product Development

Responsibilities:

• Setup the Tech team growing from zero to 12 people
• Managed design and development of the online Taxi Rental platform on a Three tier App server platform (KIVA
• Identified and negotiated the software and hardware licenses with various vendors
• Hired and mentored personnel for engineering team
• Presented the technology platform to the potential VCs
• Participated in meetings with potential vendors/partners to enroll on our platform
• Designed full functionality of the application
• Designing and developing database schema, ER diagrams (ERWin tool), logical and physical databases involving more than 40 tables, indexes, clusters
• Writing performance enhancing SQL queries, nested queries, optimized queries

Environment: KIVA n-tier Enterprise Server, Java, Visual Basic, C++, Oracle Database 9i, Netscape and IE Browser, Javascript

Consultant

Responsibilities:

• Cisco was looking forward to get into the internet hosting market. Hence needed a survey system to survey the internal/external Sales personnel to get insight into the market trends and experiences.
• Developed web based Survey system for the Internet Business Division. In addition to maintenance of various systems.
• Designing and developing database schema, ER diagrams (ERWin tool), logical and physical databases tables, indexes etc.

Environment: Oracle database (v8/9i), Javascript, MS Web server, Netscape and IE browsers.

Founder

Responsibilities:

• Conceived the idea of having commodity apps (biometrics, medical, credit cards, government etc.) on the Smart cards
• Took the risk and invested in Gemplus and Schlumberger software development kits
• Developed the airline ticketless travel app for Gemplus, by loading passenger details on the Java card
• Presented my idea at Smart Card convention, Carte’ 08 Paris, France.
• Managed the Strategic, Operational, Sales and Technical aspects of the company.