PROFESSIONAL SUMMARY:

• Over 8+ years of experience in Design, Development, Testing, Integration, Implementation and Maintenance of Business Intelligence using Tableau/MicroStrategy.
• Extensively used inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8 and SQL, PL SQL and Unix shell scripting.
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Experience in configuring reports from different data sources using data blending
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Introduced Tableau to my team to produce appealing data visualizations to clients and to help them make effective business decisions
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations) with the data warehouse.
• Created complex Reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
• Experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends
• Expertise in test planning and testing methodology for Quality Assurance validation of MicroStrategy configuration, reports and other outputs
• Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Handled Slowly Changing dimensions in a Data warehouse depending on the changes in business dimensions.
• Very good experience in working with very large databases like Oracle, Teradata, SQL Server, DB2 etc.
• Knowledge of data transformation and processing ETL tools like Informatica and Datastage.
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.

TECHNICAL SKILLS:

BI Reporting Tools: Tableau 8.2/8.1/7 (Desktop/Sever/Reader)MicroStrategy 9.2.1/8.1.2/8.1.1/8.0.2 (Desktop/Architect/Web/Intelligence/Server/Narrowcast Server)

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

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

Tools: SQL Developer, TOAD, SQL Plus

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, XML

Operating Systems: Windows 2003/2000/NT/XP/7, Sun Solaris, Linux, Unix, Sun Solaris, Linux and MS-Dos

Testing Tools: Bugzilla, Quality Center 9.2

SDLC Methodologies: Waterfall and Agile

Application Servers: IIS Web Server, Web Logic

PROFESSIONAL EXPERIENCE:

Confidential, Foster City, CA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weeklyand monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop 7 & 8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential, Jacksonville, FL

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

Confidential, Baltimore, MD

MicroStrategy Developer

Responsibilities:

• Co-ordinated meetings with clients and business users to discuss and understand requirements.
• Involved in discussion with data modelers to understand data modeling of existing schema.
• Worked with client to gather requirements and prepared technical specifications documents.
• Involved in JAD (Joint Application and Design) sessions and GAP analysis sessions to understand existing reports and convert Cognos reports into Microstrategy by creating corresponding Attributes, Metrics, Filters and Prompts.
• Involved in migration of Cognos reports into Microstrategy Reports.
• Involved in designing of schema objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Expertise in using Apply simple Function in Attributes and Metrics to make manipulations to values.
• Responsible in developing of public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports)on top of Schema Objects
• Responsible for the creation of metrics like Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex Microstrategy reports in an efficient way.
• Involved in creation of logical views and Freeform SQL Reports to translate Freeform SQL Cognos Reports into Microstrategy Reports.
• Expertise in developing Microstrategy reports by combining multiple Cognos reports based on functionality and usability of reports.
• Used Apply Simple and Apply Comparison functions to develop Advanced Filters and Transformations
• Involved in creation of reports at Aggregate Level as well as Detail Level Tables to retrieve data in an efficient way.
• Involved in setting of VLDB Properties to improve performance of reports as well as passing hints to the SQL queries.
• Involved in creating Dense Rank function metric at report level to generate sequence numbers for PDE Transactions.
• Expertise in developing dashboard reports in Microstrategy by combining multiple reports in Cognos by using selectors.
• Involved in development of reports on Sap Cubes.
• Involved in moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window
• Involved in creation of Users/User Groups and assigning appropriate privileges through User Manager in Administration.

Environment: Microstrategy9.0.1, Architect, Web Intelligence, Object Manager, Cognos8.4.1 Framework Manager, Query Studio, Report Studio, Informatica8.6.1, Teradata 12, DB2 8.x/9.1, Oracle 10GR2, SAP, SQL, PL/ SQL, Windows NT and UNIX.

Confidential

MicroStrategy Developer

Responsibilities:

• Worked with business requirements analyst’s subject matter experts to identify and understand requirements and produce the report design specification and estimates the project.
• Created the Detail design documents and Technical Specification Documents based on Business requirement documents.
• Participate in daily status and monthly planning meetings
• As per business requirement, Designed developed and maintained MicroStrategy based reports.
• Design and development of MicroStrategy schema objects like Attributes, Facts and Hierarchies using MicroStrategy Architect.
• Created complex metrics with different level dimensionality condition and transformations for user and business specific reporting needs.
• Closely worked with ETL team for maintaining the quality of the data and reconcile Fact and lookup tables for finding the Gap analysis.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
• Respond to business users inquires directly to provide technical support and best-practice report consulting.
• Perform code review and unit, system, regression testing.
• Involved in Performance tuning of SQL for long running reports.
• Created Dashboard for Corporate Financial Forecasting
• Used report services for various banded report to satisfy the printing requirements of the user.
• Provide production support ofMicroStrategy reporting application.
• Create users in MicroStrategy and grant required access for projects.
• Coordinated in moving the objects from Development to Production Environment in MicroStrategy by using Object Manager.
• Configuration of Narrowcast server and Involved in various Narrowcast task like creating Documents, service designs, subscription, administration and scheduling.
• Prepared technical project related documentation.

Environment: MicroStrategy Desktop, MicroStrategy Intelligence Server8.1.0, MicroStrategy Web8.1.0, MicroStrategy Narrowcast Server8.1.0.MicroStrategyOLAP Provider, Oracle10g and UNIX