SUMMARY:

• Over 8+ years of extensive IT Experience as a Data Analyst, Business Systems Analystin Data Warehousing and Business Intelligence applications in Retail, Banking, Financial and Healthcare industries.
• 4+ years of experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 9.x/8.x/7.x.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Proficient Star Schema dimensional modeling, which include understanding business processes, modeling dimensions, hierarchies and facts.
• Working knowledge of performance improvement measures including aggregate tables, Indexes and Explain plan
• Experience in writing complex SQL queries to perform End - to-End ETL validations and support Ad-hoc business requests.

TECHNICAL SKILLS

Database: SQL Server 2008/2005/2000, Oracle 9i, MySQL, MSSQL, Microsoft Access

Tools: Toad, Oracle SQL Developer, SQL Plus, Oracle Enterprise Manager, SQL Server Management Studio, Business Intelligence Development studio (BIDS), SQL Profiler

Pentaho Suite: Pentaho Data Integration (Kettle), Pentaho BI Server, Pentaho Analysis Tool.

Reporting Tools: Tableau, Crystal Reports, MS Access, MS Excel

Languages: T-SQL, PL/SQL, ASP.NET, C#,VB.Net C, C++, Visual Basic 6.0

Operating System: Windows 2000/ 2003 Server/ Win XP/Vista/7, Unix, Red Hat Linux,, Mac OS X 10.6/10.7/10.8/10.9

Certification: ACTC,MSCA

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience in creating dashboards using calculations, parameters in Tableau.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Mastered in different formatting techniques, using Annotations and Mark Label.
• Developed TEMPeffective and interactive Dashboards using Parameters and Actions.
• Setting the user permissions in Tableau Sever.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Prepared proof of concept for best practices in Tableau deployment.
• Expertise in providing business solutions by analyzing various trends, risks and patterns in the data using interactive reports.
• Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop
• Involved in integration of Tableau JavaScript API Filters in web application
• Defined best practices for Tableau report development.
• Created dashboards and reports for ad-Hoc Reporting.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Provided post implementation production support.

Environment: Tableau (Desktop/ Server), Teradata, SQL developer, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2007 server

Confidential, MI

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Worked with Project team to determine technical and development impact of a project.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models
• Gathering and documenting the requirements dat are critical to the business mission and using those requirements to design application software.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Worked with Source system Subject Matter Expert (SME) to ensure dat the extracts are properly mapped. Used SQL for data mapping and querying.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created reports and dashboards using Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created new Schedule's and checking the task's daily on the server.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andTEMPeffectively used data blending feature in tableau.
• Created users, groups, projects, Data connections, and settings as a tableau administrator.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.

Environment:Tableau Desktop / Serve, Teradata,Informatica, MS SQL Server, Toad, Teradata SQL Assistant, SQL, PL/SQL, T-SQL, UNIX, Microsoft office Suite (Word, Excel, PowerPoint).

Confidential, San Francisco, CA

BI Pentaho Developer

Responsibilities:

• Extensively worked with Business Users in gathering requirements and actively cataloging and supporting various issues and providing their solution.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.
• Used bunch of transformations in Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of inputs and outputs for various data sources including Tables, Access, Text File, Excel and CSV file.
• Participated in design of Staging Databases and Data Warehouse/Data mart database using Star Schema/Snowflakes schema in data modeling.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Worked very closely with Project Manager to understand the requirement of reporting solutions to be built.
• Gathered business requirement by understanding business Processes and needs.
• Installed and Configured Pentaho BI Suite 4.2 & 4.4 along with Enterprise Repository in Pentaho BI server.
• Used Pentaho Import Export utility to Migrate Pentaho Transformations and Job from one environment to others.
• Used different types of input and output steps for various data sources including Tables, Access, Text File, Excel and CSV files.
• Configured Pentaho BI Server for report deployment by creating database connections in Pentaho enterprise console for central usage by the reports deployed in the repository.
• Implemented Logic with Database lookup table to maintain Parent- Child relationship and maintain hierarchy.
• Used Pentaho Design Studio for creating custom parameters as well as generating report.
• Used Pentaho Report designer to create various reports having drill down functionality by creating Groups in the reports and drill through functionality by creating sub-reports within the main reports.
• Automated file transfer processes and mail notifications by using FTP Task and Send Mail task in Transformations
• Applied Configuration, Logging, Error reporting to all Transformation and Jobs to make it deployment easy and troubleshoot package on run time.
• Used Pentaho Enterprise Console (PEC) to monitor the ETL Jobs/Transformation on Production Database.
• Resolved connectivity issue on different server by using Kettle.Properties file and setup Variable for each DB connection.
• Performed Data cleansing by creating tables to eliminate the dirty data using SSIS.
• Involved in performing incremental loads while transferring the data OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Responsible for creating database objects like table, views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized table, established joins and created Clustered, Non-Clustered indexes whenever necessary.

Environment: Oracle 11g/10g, Pentaho Data Integration Spoon 4.4.0/4.2.0/4.1.2, Oracle Toad 11.5/10.6, PL/SQL, Pentaho Enterprise console

Confidential

System Administrator

Responsibilities:

• Project lead for RMM implementation of LabTech to manage all client devices and streamline remote support and monitoring.
• Managed LabTech for our clients with over 1000 agents deployed.
• Worked with clients on IT roadmaps and planning for the technology spending and growth.
• Managed the day to day IT work for all my clients, including server, network, workstation, mobile device support.
• Automated installations of workstations, using scripting, group policy, deployment packages and documentation.
• Assist in the planning and execution of the ConnectWise,
• Schedule and manage tickets on service board
• Project manage new and existing projects with clear measurable goals
• Proactively research and maintain knowledge of IT solutions provider and related industries
• Responsible for the oversight and support an organization's infrastructure systems such as File and Print Services, Email, Network OS and Applications.
• Perform maintenance and support of the availability and functionality of these systems.
• Maintenance (includes OS Patching and upgrades), implementation rollouts of new systems, L1,2&3 break fix
• Resolve inbound tickets (Level 1 & 2 helpdesk as needed), and ensure SLAs are maintained
• Review and monitor our service-ticket boards, and ensure routine network maintenance occurs
• Manage all server/desktops to keep them up-to-date with Microsoft and third-party patches, virus definitions, and malware, using our Remote Monitoring Management (RMM) software
• Assist with consistent monitoring of Backup devices and manage/escalate failures as needed
• Installed & Configured Windows server 2003, 2008, 2012 VMware vSphere, Hyper v, Exchange server 2010/2013& Linux operating systems.
• Perform day-to-day Macintosh support activities and processes to deliver enterprise-wide technical support services for Macintosh systems and applications
• Installed and Configured applications like Veritas NetBackup / Veeam Backup and Replication.
• Experience as a System Administration on various Linux Windows Server 2003/2008/2012 and Mac OS Server Snow Leopard/Lion/Maverick
• Record your own work, as well as maintain, update, and create technical support and end-user support documentation
• Escalate technical issues outside your skillset to other technical team members

Environment: MS SQL Server 2005/2008,Labtech RMM Tool, Connectwise.