PROFESSIONAL SUMMARY:

• 7+ years of professional experience in the field of IT, End to End ETL transactions, Business Intelligence, Project Management, Business/Data Analytics, Data Visualization, Data Integration and Data Modeling.
• Skilled in BI tools of Tableau, Power BI, SSRS including report, query writing and building front end BI applications as per specifications.
• Experience in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
• Hands on Experience in working with WDC (Web Data Connectors), Tableau Desktop, Tableau Admin, Tableau Server and Tableau online in various versions of Tableau 10, 9 and Tableau 8.
• Experience in designing various Data Visualization Dashboards, gathering customer requirements, writing test cases, preparing analytical reports to help users to identify critical KPI's and partnering with developers to ensure full understanding of internal/external customer needs.
• Secured Tableau Server by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Experience in creating extracts in Tableau from various source files including flat files, excel sheets, access files and different databases.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), End - to-End ETL validations.
• Consulting with business clients, collaborating with developer teams, using data visualization tools, such as Tableau, Power BI platform to create business intelligence visualizations.
• Designed, developed and supported BI solutions, Involved in Debugging, monitoring and troubleshooting issues/tickets. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Strong proficiency in the full life cycle of business solution development with outstanding capabilities in analysis, problem definition and requirements gathering.
• Hands on database experience in Oracle 9i/10g, SQL Server and in ETL tools like Data stage.
• Experience in designing Power BI graphical and visualization solutions with business requirement documents for creating interactive dashboards.
• Hands on experience with SDLC models, SCRUM/Agile based analysis and project management.

TECHNICAL SKILLS:

ERP: Oracle 9i/10g

BI Tools: Tableau Desktop, Tableau Online, Tableau Server, Tableau AdminCrystal Reports, Power BI, SSRS

ETL Tools: SQL Server Integration Services (SSIS), Data Stage

GUI/IDE Tools: Microsoft Visual Studio, PUTTY, Toad

Testing Tools: HP QC, ALM, QTP, SOAP UI, TFS

Languages: C, C++, Java, SQL, UNIX Shell Programming, .Net, ETL

Web Technologies: HTML, XML, UML, Shell, Perl, VB Script, Java Script

Databases: Oracle, SQL Server, MS Access, DB2

Operating Systems: Windows 7/XP/2000/NT/98, Linux, UNIX (Solaris, HP-UX)

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

BI Developer / Tableau Consultant

Responsibilities:

• Served as a liaison between the business and the IT department by conducting weekly meetings with stakeholders, developers, QA Team to document any changes and apply them to Tableau reports as needed.
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration and configuration for data warehouse with automated and manual field data collection systems.
• Involved in creating database objects like tables, views and procedures, triggers and functions using SQL to provide definition, structure and to maintain data efficiently.
• Extracting the data tables using custom generated queries from Excel files, Access/ SQL database and providing extracted data as an input to Tableau.
• Designed dashboards on the concept of Dynamic availability where in a variety of worksheets/ Views were connected by Actions.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Extracted data from multiple data sources into internal data base by creating Database Objects.
• Experience with Tableau as an administrator, including providing installation, maintenance, upgrades, scheduling, performance tuning and monitoring.
• Developed various reports using different visualizations such as Donut charts, Gantts, Bars, Lines, Pies, Maps (Filled and Symbol), Highlight tables, Bubbles and Scatter Plots.
• Used LOD functions like fixed, Include and Exclude to show revenue shrink and financial debts at different granularities such as region, state and stores.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Created action filters, parameters, KPI’s, calculated sets and hierarchies for preparing dashboards and worksheets in Tableau Desktop.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live and extract datasets, VLOOKUP in Excel.
• Worked effectively on Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries.
• Experience with Tableau as an administrator including providing installation, administration, configuration, maintenance, scheduling, performance tuning and upgrade.

Confidential, Miami, FL

BI Analyst

Responsibilities:

• Implemented advanced collections for Accounts Receivables which increased the collections by 26% by conducting credit investigations, collected delinquent accounts and all credit related issues.
• Making strategic recommendations on Data collection, integration and retention requirements incorporating business requirements and knowledge of best practices.
• Upgrading Tableau Server, creating tableau sites, groups for admins, performance tuning of Tableau server, defining the user roles and responsibilities.
• Built business dashboards to conduct trend analysis on retail metrics, especially relating to driving sales revenue, customer retention and salesperson productivity.
• Making Data Extractions for Budget from external Web Data Connectors (WDC) that impact the business.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Online, Involved in Performance Tuning of Tableau Reports.
• Created External filter, internal filter and Context filter to improve performance. Quick filters to display as per user requirement.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Extensive experience in using all Level of Detail (LOD) expressions like Include, Fixed and Exclude to create visualizations that are different than the view level or visualizations level of detail.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Extensive knowledge in all types of aggregations like Sum, Average, Count, Count (distinct), Median, Minimum, Maximum, Percentile and Std.Deviation etc.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users.
• Yearly and Quarterly Budget forecasting for ongoing, future Products with the help of BI Tools (Tableau, Power BI).
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau and Power BI.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot and Power Maps), integrated them to share point.
• Used Power BI (Power Pivot) to develop data analysis prototype, used power view and power map to visualize reports.

Confidential, Harrisburg, PA

SQL BI Developer

Responsibilities:

• Actively participated in interaction with Team Lead and technical manager to fully understand the requirements of the system.
• Developed SQL programs in T-SQL, writing Views, Stored Procedures, Joins and Queries with best execution plan.
• Generated Sub-Reports, Cross-tab, Conditional, Drill Down reports, Drill through reports and Parameterized reportsusing SSRS.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Created Packages using Import and Export Wizard for exporting the data from Excel Spreadsheet to SQL Server.
• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Understanding the ETL process from the business requirement documents.
• Developed test parameters using ETL process to map source data base to target data base.
• Verifying ETL process using Data Stage and validating the output data with expected results.
• Exposure in optimizing ETL jobs to reduce memory and storage consumption.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed SQL queries to Insert, Update and Delete data in Database.
• Worked on stored procedures, triggers and on substantial number of business analytical functions.

Confidential

Data Analyst

Responsibilities:

• Participated in analysis and testing of the redesigned brand web sites to ensure the highest level of quality.
• Worked closely with the Business Users and SMEs to Define the Project scope for new clients and enhancement requests for existing clients.
• Defined project deliverables, resources and timelines and documented them in MS Project.
• Analyzed Gap between current state and desired future state to define enhancements and opportunities.
• Coordinated with Technical Team, Project Manager, Business users for the requirements elicitation and review.
• Worked with SMEs, Data architects, ETL and DBAs to elicit functional requirements and convert them into technical requirements and design definition.
• Used interview, document analysis, data analysis, prototype, JAD sessions and workshops for requirements elicitations and conducted walk through sessions for requirements review and approval.
• Project run with the testing of Agile Scrum methodology.
• Prepared and maintained Requirement Traceability Matrix for requirement, change control, design, and development and testing.
• Created and maintained data mapping based on client data and application requirement specifications.
• Prepared data transformational rules documents and data dictionary for the downstream users.
• Created test data for design and development, functional/regression and UAT testing.
• Executed SQL queries to extract data on SQL Server and Oracle databases for data analysis and validation.
• Created Business Requirements Document, User Processing Manual and other project artifacts.
• Worked extensively to define test plan, test cases, and execution of testing using multiple scenarios and update/maintain issue log using HP ALM.
• Worked closely with business to define Retirement Planning services, pension planning accounting and financial analysis retirement planning and investments.