SUMMARY:

• Over 7 years of experience in Business Intelligence, Designing, Analysis, Data Warehousing, Web - Based Applications and Databases.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• In-depth knowledge on Tableau Desktop and Tableau Server.
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, Upgrade, Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management.
• 3 yrs. experience in Tableau Dashboards on latest designs and presentations.
• Acted as a Point of Contact in Data Interoperability, Analytics, and BI, Production support issue resolution.
• Designed, developed and supported BI solutions, involved in debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and used custom images, geo coding to build spatial visualizations of non-geographic data.
• 4 yrs. of professional experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000/7.0, DTS, SSIS,SSRS and SSAS.
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule ETL Packages.
• Excellent knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.
• Ability to handle different projects concurrently and lead experience.
• Self-motivated, energetic, self-starter with excellent analytical, organizational and creative skills.

TECHNICAL SKILLS:

BI/ETL Tools: Tableau, SSIS (SQL server integration services), DTS & Data stage.

Databases & Related Technologies: SQL Server 2008/2005, Oracle 11g/10g/, MS Access, DB2 MS excel 2010, MS Share point.

Operating Systems: Windows 8/7/XP/2003

Modeling Tools: MS-Visio

Reporting Tools: SQL Server Reporting Services Defect

Management tool: T-SQL, SQL, PL/SQL, C, JAVA, VB, MS ACCESS

Office Tools: Microsoft Office /

PROFESSIONAL EXPERIENCE:

SR.TABLEAUADMIN/DEVELOPER

Confidential, Buffalo, NY

Responsibilities:

• Develop, support, maintain, and test,DeveloperSuit (Form, Report), SQL/PL-SQL Program.
• Design, create and maintain data model and data.
• Installed Tableau Server in Dev, QA, UAT and Prod environments.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Monitored Vizql and WGSQL Server activity to track performance and system stability.
• Tableaudevelopment lifecycle from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created data blending in case of merging two different datasets.
• Design, create and extend application layer to manage the CMS data repository and ETL (Extract, Transform, and Load) feeds from multiple sources.
• Design, develop and support Performance and Capacity Application Dashboard using APEX.
• Design, develop and support complex performance and capacity charts and reports usingTableau Tool.
• Expertise with data architecture, data interoperability and data analytics usingTableauand SQLs.
• Assisted Seagate DBAs and ApplicationDeveloperswith Oracle SQL troubleshooting, performance tuning and enhancements
• Defined and created procedures to install Tableau desktop in silent mode.

Environment: TableauServer v7/8,TableauDesktop v7/8, SQL Server 2008/2012, Oracle 11g, SQL SSIS, Team Foundation Server, Visual Studio 2012.

Tableau Developer

Confidential, Henderson, NV

Responsibilities:

• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Developed various dashboards and used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• 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.
• Involved in license management SLA’s with Tableau support.
• Prepared use cases and got reviewed with state of Nevada.
• Designed dash boards for actionable, non-actionable complaints from Multi-dimensional database.
• Generated dashboards to compare the expected weekly sales vs. projected sales used dual axis for comparison.
• Prepared different views for Small business Health Options Program (SHOP).
• Created dashboard for Finance team, provided security by using user filters.

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

TABLEAUDEVELOPER

Confidential -Westport, CT

Responsibilities:

• Generation ofTableauextracts and implementation of different calculations, visualizations in the Tableaulay out design.
• Understanding and translation of various existing SSRS reports andTableaudashboards.
• In charge of the team that built the shared Tableau Platform over the virtual environment.
• Working with User for requirements and part of the team developing the software. sessions to the employees on the tools
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Defined group level security standards for Tableau
• Designed the strategy for Automated Software Delivery through Silent install for Tableau.
• Worked on Tableau, Dashboard and report development team under Performance management
• Installation and configuration ofTableauserver in dev. and production environment.
• Authenticating thetableaudashboards before publishing totableauserver.
• Publishing the developed reports to productionTableauserver environment.
• Security implementation totableauserver reports based on user community.
• Tableauserver API integration with MRCS 4.0 portal integration for trusted authentication.

Environment: BI solutions, BI environment, BI Applications,Tableau8x BI toolkit\Product stack (Desktop\Server)

SR. SQL DEVELOPER

Confidential, Philadelphia, PA

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 and assisted and coached them in material, processes and delivery of, 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

SQLDEVELOPER

Confidential

Responsibilities:

• Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Schedule, Business Change Management, and Develop Feasibility Study Report for Preliminary Study of the Project, and Budget of the Project.
• Participated with individual and JAD/RAD sessions (Work Sessions) with the stakeholders (Offer Management) and the technical units (Amdocs) for business requirement gathering followed by (Agile Scrum) approach.
• Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs.
• Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Data Analysis, and Data Conversion.
• Applied SQL for cross checking Data Validation for Referential Data in SQL Server.
• Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users.
• Assisted in creating Data Sample that included specific size of data from the database reflecting different data field elements' values. Data Sample would then be compared with Source Application Systems to test the accuracy of data field elements values.
• Used SQL Server Integrations Services (SSIS) to extract data (ETL), and quickly load data into SQL Server table, and handle data quality issues.
• Used SQL Server Reporting Services (SSRS) - Reporting Services Components and Business Intelligence Development Studio (BIDS) in order to design and develop reports

Environment: MS Visio, MS Office Suite, HTML, XML, Test Director, VB, Client Server, UML, Waterfall, Windows XP, Test Director, MS Project, MS Access, MS SQL, Oracle, TOAD.

BUSINESS ANALYST

Confidential

Responsibilities:

• Using a wide range of techniques to capture business requirements.
• Identifying an organizations strengths and weaknesses.
• Working with business owners to develop solutions.
• Assisting in the preparation of business proposals.
• Documenting, testing and implementing software updates.
• Identifying client business requirements.
• Defining project scope and objectives.
• Preparing and analyzing financial performance information.
• Allocating junior staff to tasks and then tracking the progress of their work.
• Making sure that all tests are conducted and documented according the standards agreed upon.
• Proficient in Microsoft Office programs.
• Identifying and managing any anticipated resistance or risks.
• Involved in the definition of roles and responsibilities.
• Carrying out business improvement reviews.
• Meeting with project teams to review deliverables and deadlines.
• Producing test plans and scenarios on behalf of the business.

Environment: Microsoft Office, Oracle 9i, Rational Clear Case, XML, MS Visio and Manual Testing