PROFESSIONAL SUMMARY:

• 11+ years of experience in Analysis, Design, Development, Testing and Implementation of Data Warehouse and Business Intelligence applications.
• Highly experienced in LAMP Development with creation of websites on diverse themes
• 6+ years of experience in Tableau 9.x/8.x/7.x in developing Performance Dashboards, Score cards, metrics, What if analysis, Prompts, Drills and Reports/Dashboards for all the functional areas including Finance/Business and Health care domains.
• Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations & Impact Analysis.
• Extensive knowledge of PHP, MySQL, Web Services, APIs, Blog platforms, Social media marketing and integration
• Worked with jira agile and can update jira with minimum down time.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Created workflows,fields and other components in Jira.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Extensive experience in creating rich visualizations in dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Proficient in creating Calculations (LOD, Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Very good exposure to ETL tools like Informatica, MicroStrategy and IBM Data stage.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Excellent working knowledge on LAMP environment.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Expertise in Performance tuning and improved Reports performance in Tableau using extracts and context filters and custom SQL.
• Implemented Tableau security at the Data (Data security) and object (Roles and Permissions) security.
• Experience in using Tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Analyzed and built data visualization models using Alteryxand Tableau.
• Proficiency in creating different types of reports such as Cross - Tab, Drill-down, Top N, OLAP and Sub reports, and formatting them using both SSRS.
• Expertise in generating reports using SQL Server Reporting Services, Business Objects, Crystal Reports and MS Excel spreadsheets.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies.
• Extensive knowledge and Experience in dealing with RDBMS including Normalization, Web forms, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

TECHNICAL SKILLS:

Reporting Tools: Tableau ( Desktop/Server/Mobile/Public) 9.x/8.x/7.x, SSRS, Business Objects

ETL tools: SSIS, Informatica

Databases: Oracle, MS SQL Server, DB2, MS Access, My SQL, Excel, Teradata

Languages: PL/SQL, T: SQL, JavaScript, C, C++, SQL

Data Modeling Tools: Erwin, MS Visio, Power Designer

Operating Systems: iOS, Unix, Windows

Methodologies: Rapid Application Development, Waterfall, Agile, Scrum, Kimball/Inmon

PROFESSIONAL EXPERIENCE:

Confidential, Addison, TX

Sr. Data Analyst

Responsibilities:

• Involved in reviewing the business requirements and 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.
• Create team specific Agile process flow in JIRA to move tasks from one activity to another.
• Used extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Created pie and bar charts and combining dashboards to demonstrate high health risk areas.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and MS Excel.
• Extensively used data blending in Tableau, and also performed Tableau type conversion functions when connected to relational data sources.
• Used advanced SQL scripts and aggregation functions and advanced charts like tree map and bubble chart for applications.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created line charts to show number of completed Health Assessment people for each client in a breakdown of weekly, quarterly and yearly parameter numbers.

Environment: Tableau Server, Tableau Desktop 7.x/8.x, Oracle 11g, Jira,MS SQL Server 2008, PHP, Excel, TSQL, UNIX, SQL, Toad, MS Office, TFS, Citrix, Share Point.

Confidential, Pataskala, OH

Sr. Data Analyst

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications and performed impact analysis.
• Analyze the data from different data sources and develop Tableau Reports.
• Enhance and refine the technical architecture to keep in pace with new Tableau software releases and changing business demands.
• Creation of dashboards with Combination Charts, Custom Charts based on the customer requirement.
• Managed and maintained company IT infrastructure, including configuring Windows, Linux, and OS X machines, and troubleshooting hardware and software
• Analyze and deployed automated systems in Python and PHP.
• Functional role in defining the dashboard requirements and providing the best practices/approach to perform ETL using Alteryxand publish data to the reports/dashboards
• Designed and Developed various analytical reports from multiple data sources by blending data on a single Worksheet in Tableau Desktop.
• Used Jira for tracking,reporting and resolving issues.
• Loading data to Cassandra cluster with the help of Java API.
• Used Jira workflows for multiple projects as per business needs.
• Utilized Alteryx to create workflows and generate predictive, statistical and spatial results by combining data
• Created Global filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views
• Develop dynamic websites using PHP/MySQL connectivity and client/server scripting
• Created Dashboards with interactive views, trends and drill downs.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Developed Tableau visualizations to support Data Summary, Analytical Reports.
• Trained the business users on Tableau's self-service model of Creating and Publishing the Reports.
• Built Complex Formulas (using "calculated-field" feature) in Tableau for various business calculations.
• Provided resolution to performance problems of dashboards deployed on Tableau server using out of the box performance analyzer tool of Tableau desktop and Tableau server.
• Strong SQL skills including use of nested expressions, unions, multi-table joins.
• Administered user, user groups, and scheduled instances of data refresh activity to be consumed by Tableau reports.

Environment: Tableau Desktop 9.2/8.3, Tableau Server 9.2, Oracle 11g, Jira, PHP,MySQL, MS SQL Server 2008, Excel, TSQL, UNIX, SQL Server 2008, HP Quality Center, SVN, Alteryx, Service Now, MS Office.

Confidential, Ann Arbor, MI

Data Analyst

Responsibilities:

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008/2005 and Flat files.
• Involved in installation and configuration of SQL Server 2012/2008/2005 with latest Service Packs.
• Enhancing performance using Optimization Techniques-Normalization (2NF), Indexing and Transaction Isolation levels, Monitoring logs to ensure the completeness of batch Processes, Scripts and Processes. Created Linked Servers to connect OLEDB data sources and providers.
• Created Shell Scripts to load data from other sources to SQL databases and maintained them.
• Participated in designing a data warehouse to store all information from OLTP to Staging and Staging to Enterprise Data warehouse to do better analysis.
• Used basic Script Task for renaming the file names, Storing Row Count Values into User Variables.
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, Transforming, and Loading data from and to various RDBMS and NonRDBMS Sources and Destinations.
• Generated different SSIS packages using transformations such as Fuzzy lookup, derived column and Slowly Changing Dimensions (SCD) to perform different business requirements.
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Look-up, Conditional Split, Merge Join, Multicast, Union All, Derived Column, Data Conversion, For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, and Precedence Constraint) to achieve business requirements.
• Worked with Data Integrity team in maintaining company databases and also helped them to reconcile data.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Migrated existing legacy DTS packages to SSIS using DTS Xchange.
• Building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2008/2005 Pack.
• Captivated proper Error Handing Techniques like Logging, Checkpoints, and Event handler to handle Errors in the package.
• Collected detailed requirements and created SSRS templates.
• Designed and developed several enterprise reports (SSRS/Crystal Reports) using the data from ETL Loads and heterogeneous sources.
• Created Matrix reports for the management to have high level of knowledge on different categories in any specific period.
• Designed and developed multiple reports such as Ad-hoc, Drill Down, Drill Through, SubReports, Linked Reports, including stylish Graphs and Charts.
• Worked on Reporting subscription services such as data driven subscriptions for email and file sharing.
• Generated reports using different Variables, Expressions and Functions using SSRS 2008 R2.
• Deployed generated reports each Week, Month and Quarter into the Report Server allowing users to access reports through browser.

Environment: T-SQL, MS SQL 2008, SSIS, SSRS, Erwin, Visual Studio 2008, Windows XP, MS Office 2007.

Confidential, Newark, NJ

Sr. Data Analyst

Responsibilities:

• Assisted the client with thorough analysis of their existing system, challenges, and business needs. Documented the reporting requirements and interacted with users, gathered information for project development.
• Gathered business requirements, defined data flow coming from multiple sources, analyzed data quality, worked with the data warehouse team to develop logical data models.
• Involved in project planning, scheduling timelines for deliverables, and obtaining approval from all the stakeholders.
• Marketing analytics including pre-campaign analysis to identify customers for campaign, post -campaign analysis to evaluate campaign success, and recommendation for future campaign performance.
• Analysis of production data for process improvement and reduction of costs (e.g. Trouble Shooting and Root Cause Analysis.
• Developed, published user friendly interactive reports and dashboards. Automated these reports in Tableau server using its strong feature of scheduling and authenticating.
• Employed rich Tableau features using action filters, parameters, calculated fields, drill downs and sets giving the user a friendly navigation option through all the views in the dashboard.
• Created Tableau dashboards using bar-in-bar graphs, line charts, filled maps, dual axis charts, bubble charts and Gantt charts.
• Effectively used data joining or data blending features for building an integrated view of multiple tables or data sources.
• Documented best practices for Tableau report development, performance tuning, and shared it in a common folder for access by the users and other developers.
• Developed dashboards in Tableau desktop, published them on to Tableau server as .twbx packaged workbook giving the user an option for build customized reports if they so desire.
• Scheduled data refresh on Tableau server for daily, weekly, or customized refresh depending on the business requirement to ensure that dashboards update periodically with fresh data.
• Developed and published customized and interactive dashboards, shared URL with the users giving them an option to open the dashboard with a click of a button.
• Initiated and organized for meetings with the data warehouse team, business users, analysts, project managers and leadership team to update the project, and to seek feedback.
• Maintained dashboards, provided post production support, and any quick fixes required.

Environment: Tableau 7.0, BusinessObjectsXIR3, IDT, Oracle 11g/10g, Jira, SQL Server 2008/2012, Toad, Windows 2008 Server.

Confidential, San deigo,CA

Systems Analyst

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects.
• Designed database, tables and views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access and Excel into MS SQL Server using SSIS Packages.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Performed Unit Testing and Tuned SQL statements using Indexes and Stored Procedures
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries. Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Generated Sub Reports, Cross tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS
• Ability to analyze, configure and troubleshoot networks.

Environment: MS SQL SERVER 2005, SSIS, SSRS, Query Analyzer, MS Excel, MS Access, Windows.

Confidential, Falls Church, VA

Data Analyst

Responsibilities:

• Conduct Data analysis including acquisition, cleansing, transformation, modeling, visualization, documentation and presentation of results.
• Run KPI meetings, keep Open Data Portal up-to-date, and assist with Public Records Requests.
• Design and develop SSIS package for loading data from OLTP to ODS and finally to Data Warehouse.
• Designed Data Warehouse and Database for the system using Star Schema which includes Tables, Stored Procedure and Indexes in SQL Server Management Studio.
• Design VBA modules and macros for Access database for analysis purpose.
• Created parameterized, drill down and aggregation reports in MS SQL using SSRS.
• Use SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Experience working in agile environment, which is accepted standard methodology implemented across all the IT projects.
• Responsible for Testing and Debugging the Stored Procedure, SQL Scripts, SSIS package and Reports.
• Worked in on site/ off shore environment; coordinated my activities by proactively communicating with my counterparts in the off shore team and working closely with my manager.

Environment: Microsoft SQL Server 2008/ 2005, T-SQL, SSIS, SSRS, VB Scripting, Erwin, Visual Studio 2008, SQL Query Analyzer, VB, MS Project, Visio, MS Office 2007.