PROFESSIONAL SUMMARY:

• Developer with over 8 years of experience in Software design, Database Design, Development, Integration, Implementation and maintenance of business intelligence and the related database platforms.
• 6+ years of experience in Tableau, data discovery, data visualization, data analysis and report development using complex functionalities like Data blending, Calculations, parameters, calculated fields, groups, sets and hierarchies.
• Designed several executive level reports with drill down functionality, Filtering, Highlighting, url actions and also combined multiple data sources to create these reports.
• Expertise in designing and creating various analytical reports to help users identify critical KPI’s and facilitate strategic planning in the organization
• Experience in developing reports/ Dashboards with different Analytic views (Drill - down, cascading style sheets, Pivot tables, and various charts).
• Extensive experience in using Quick Table calculations, static and dynamic sets, parameters and Level of detail using advanced and statistical functions in tableau desktop.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report.
• Analyzed and used Tableau Server system requirements based on many factors including the number of users and targeted workload.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms
• Used the tableau command line utilities for various Dashboard Migrations from one environment to the other.
• Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Strong Knowledge in all phases of the Software development life cycle (SLDC) such as developing, testing, Migrating, Administration, security management and production supporting on various platforms.
• Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS including tools like BCP utility, DTS and SSIS 2005/2008 Packages with proper control flow and data flow elements by using MS SQL Server 2012/2008-R 2/2008/2005.
• Very well versed in the water fall methodology and agile implementation
• Self-learning ability, excellent interpersonal communication, Leadership Quality, good team player and determination to learn new technologies and adapt.

TECHNICAL SKILLS:

RDBMS: SQL Server, MySQL, Hadoop, Impala/HIVE, Oracle 12/11/10/8.0/7. x, Teradata, CE/ 2000/20005/2008/2012 , Neteeza 7 P2

Reporting Server: Tableau 8.x/9.x/10.x/2018.x

Reporting Tools: Tableau 8.x/9.x/10.x/2018.x

Microsoft Office: MS Word, MS Excel, MS. PowerPoint, MS. Access, MS. Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Business Intelligence Architect / Tableau Developer

Responsibilities:

• Collaborated with Life Solutions business partners and the broader analytics organization (Advanced Analytics, Business Intelligence, Data Governance) to create value-driven data insights aligned with the firms strategic priorities.
• Interacted directly with Audit Managers and their staffs, Business process owners, Finance and team members to design and implement data analysis solutions.
• Continually re-assessed these solutions in efforts to make them more efficient and effective.
• Developed methodologies that allowed for effective and repetitive data extraction processes.
• Worked with users to understand the user requirements, layout, and look and feel for the reports to be developed.
• Built reports against single table, multiple tables, views and also built formulas in tableau for various business calculations.
• Designed and optimized data connections, data extracts, schedules for backgrounds tasks and incremental refresh for weekly and monthly dashboard reports on the tableau server.
• Ensured data integrity within the dashboards and reports, and developed procedure for increasing the quality and accuracy of information from multiple data sources.
• Introduced self-service as a concept - Educated and mentored both teams and business partners on Business intelligence concepts and best practices.
• With bi-weekly trainings and WebEx sessions our business users are now able to generate quick and advanced visualizations to explore data and detect trends and patterns.
• Tableau training partner, I have prepared several documentations for all the dashboards and trained our users on how to utilize these documents.
• Tableau site Admin- Publishing and removing and granting permissions to the published dashboards.
• Extensive use of Teradata SQL Assistance for data queries, joins and analysis.
• Implemented row level security on the published dashboards to restrict access to various users.
• Performed database tuning and performance monitoring.

Confidential, Long Island, New York

Tableau Developer/ Data Analyst

Responsibilities:

• Analyzed business user requirements, participated in sessions with clients, project stakeholders, users, SME’s, development and testing team to get better understanding of the requirements and functionalities.
• Worked on Business Intelligence standardization to create a database layer with user friendly views in oracle that was used for developments of various Tableau Reports/ Dashboards.
• Implemented reporting Framework for multiple groups and LOB’S including our Compliance and Risk Management group.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created consumer lending KPI dashboards to display loan conversion rate to measure the efficiency of managing the pipeline.
• Defined best practices for Tableau Report development by adhering to style, guidelines and techniques.
• Designed wireframes, dashboard templates as per the requirement with tabular reports, bar charts, waterfall charts, gant charts, bubble charts,
• 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.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Implemented various data connections from data source to Tableau Server for report and dashboard development.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal (SharePoint).
• Assigned Permissions to the different Lines of Businesses and Users.
• Was also responsible for the performance of the tableau Dashboards on the web portal.
• Conducted regular meetings with business on review, modifications and process improvement.
• Conducted tableau product training with business users and other team members.
• Used Alteryx for Cleansing, Joining, and shaping data
• Worked heavily on Alteryx formula preparation, join, Parse, Transform, data Investigations, Predictive, and Time series.

Confidential - New York, NY

Tableau Developer/ Admin

Responsibilities:

• Gathered the business requirements from the end users keeping in mind their need for the application and documented it in Functional and Technical Specifications Documents.
• Interacted with business stakeholders to understand their decision-making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Evaluated data models to design Tableau solutions.
• Created dashboards for Sales Analysts to measure performance of their field representatives.
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies
• Introduced several levels of dashboard drill down and links to interrelated performance metrics.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Provided support to business team by responding to ad-hoc data requests, answering questions, and providing technical support and analysis
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Created and managed server groups and permissions.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Confidential, Newark, NJ

MS SQL Developer/SSRS Developer/Tableau Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Identifying, analyzing, and interpreting trends or patterns in complex data sets
• Design and develop ad-hoc /scheduled reports and dashboards for various business units
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Created Advance connections, join new tables, create, manage, extract and monitor queries.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
• Tested the reports and fixed bugs in the stored procedures.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.