SUMMARY

• 8+years of IT Experience in design, analysis, development and implementation of Various applications in Client/Server OLAP environment using BI Tools in Manufacturing, Retail and Financial industries
• 4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0, 8.1 and 8.2, 8.3 as a developer and Administrator.
• 2+ years of extensive MicroStrategy 7.i/ 7.5/8.0/ 8.1/9.0/9.0.1 , Narrowcast server, MicroSrtategy Web, MicroStrategy Desktop and Intelligence server.
• Administer and supervise all Tableau servers which include creation and maintenance of users, user groups, roles, assigning security on projects/sites, automate background tasks and maintaining the servers.
• Experience in Installation, configuration and administration of Tableau Server in a multi - server and multi-tier environment.
• Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Perform migration and deployment of dashboards across multiple Tableau servers.
• Create and maintain complex dashboards in Tableau.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Deep understanding of the Oracle E-Business Suite Procure to Pay and Order to Cash cycles.
• Well versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing reports from Multi-Dimensional OLAP Cubes.
• Experienced in developing complex reports using Business Objects XIR3/XIR2 Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Proficient in developing Entity-Relationship diagrams, Dimensional Modeling, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata,, Informatics UNIX, DB2, Oracle and SQL Server technologies.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Managed cross-functional teams through Software Development Life Cycle.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions totheir requirement.
• Installing and configuring of MicroStrategy suite including MicroStrategy Desktop, Administartor, Intelligence server, web, and narrowcast server on NT servers and sun solaris environments.
• 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.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Well experienced in writing complex queries, stored procedures, functions, cursors and packages using PL/SQL programming.
• Outstanding knowledge in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio).

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management AndData Collection.

BI Tools: Tableau7.0,Tableau8.0/8.1/8.2,8.3 OBIEE 10g,11g,SSRS MicroStrategy 8.1/9.0/9.0.1

Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, MS Access.

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio

Languages: SQL, PL/SQL, C, C++, ASP.Net, HTML, XML, XSL

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP, UNIXLINUX.

PROFESSIONAL EXPERIENCE

Confidential, SAN DIEGO, CA

TABLEAU DEVELOPER/ADMINISTRATOR

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Managing users with Active Directory accounts in a Kerberos enabled environment with SSO (single sign on) to connect to Tableau server from Tableau Desktop.
• 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.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• 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.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Automate regular repository back up based as per business needs.
• Analyzing the existing system and to identify the areas of improvement.
• Create Technical design document, provide end user training and training manual.
• 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.
• Create the public objects like metrics, filters, prompts, custom groups, consolidation and reports.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer 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 onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop 7 &8.3,TableauServer,MS Office Suite,MS SQL ServerR2, MS. Excel

Confidential, NEWYORK, NY

TABLEAUDEVELOPER/ ADMINISTRATOR

Responsibilities:

• Worked as a Tableau admin, in charge of the report development and maintenance
• Independently worked on owning IT support tasks related to TableauReports on Server.
• Developing, Designing and supporting interactive Tableau Dashboard reports.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls lists.
• Delivering reports to Business team on timely manner.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and compound), Filters, Prompts (Filter, Object), Templates and Reports.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
• Developed MicroStrategy Dynamic dashboards in the flash mode using several controls and worked extensively on widgets.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Published dashboards to Tableau server.
• Worked on the requirement gathering of the reports
• Created dashboards displaying sales, variance of sales between planned and actual values.
• Analyzed the database tables and created database views based on the columns needed.
• Developed SQL Server Impersonation for Impersonation Requirements, How Impersonation Works,
• Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
• Good Knowledge and Worked on TABCMD & TABADMIN, Database Maintenance and Troubleshooting.

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

Confidential, OMAHA, NEBRASKA.

MSSQL Developer,SSIS,SSRS

Responsibilities:

• Dealt with requirements gathering, analysis, design, development, change management, deployment and user training.
• Added logins, roles, groups to the Window NT and MSSQLServer and maintainedproper security procedures.
• Designed ER diagrams (Physical and Logical usingErwin) and mapping the data into database objects.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a varietyof failures.
• Created, maintained, modified, and optimizedSQLServer databases, database security and auditing
• Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.
• Connected Linked Servers toOLE DB data sources and providers.
• Wrote distributed queries for Linked Servers.
• Scheduled Jobs and Alerts usingSQLServer Agent.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• GeneratedSub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports usingSSRS2005.
• Performed Data Analysis for automating various drugs related reports utilizingSQLAnalysis Services.
• Designed, programmed, deployed and tested the requested Reports.

Environment: SQLServer 2005 Enterprise Edition, MS Excel,T-SQL, MS Access 2000,SQLReporting Services, Erwin 7.3, XML.

Confidential

SQL Developer

Responsibilities:

• Interacted with the Business Users and Supervisors to get a better understanding of client business processes and to gather business requirements. Analyzed the Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Converted the User Requirements into Business Requirements, Functional Requirements and Technical Requirement. Also created Business Process Models from the requirement specifications.
• Created Use Case specifications, Business flow diagrams, Activity/State diagram and Sequence diagram using MS Visio, so the developers and other stake holders can understand the business process according to their perspective with possible alternate scenarios.
• Communicated extensively with the Financial Examiners and with different levels of management to identify requirements, use cases and to develop functional specifications.
• Implemented RUP and followed iterative, Use Case driven process for requirement documentation and deployment.
• Participated in meetings and Database Analysis with Developers, Project Managers and Quality Analysts to discuss business requirements, test planning, resource utilization, and defect tracking.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing / verification.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing. Developed user test cases and validated test results during user acceptance testing.
• Used Test Director for Defect Tracking and prioritizing defects and for enhancements after base lining the requirements.

Environment: Outlook, MS SQL Server 2000, Microsoft Visio, MS Office, XML

Confidential

SQL Developer

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Configured Replication Server.
• Worked on a Terabytes of Data.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2000, ER-Win, T-SQL, Excel, Access and Windows NT.