PROFILE

• Dynamic technology professional with over seven (7) years of IT experience, including extensive technical background in DB applications, Data Analysis, ETL Development, Data modeling and warehousing.
• Strong knowledge of Oracle/SQL Server Architecture, schema, and Transaction management. Keen researcher with robust resolution pedigree; utilizing knowledge of relational database and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions towards achieving a goal.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau 9.2, 9.3, 10.4, 2018, 2019, 2020 Excel and PowerPivot, SSRS, Power Bi

Databases: MS SQL Server 2005/2008/2012 , Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2

ETL/Other Tools: Informatica Power Center 8.6.1/9, SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata - BTEQ, PL/SQL

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix

Programming Language: SAS SQL, PL/SQL, TSQL

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Tableau Developer/Data Analyst

Responsibilities:

• Utilizing data visualization tools, including Tableau and Power BI to provide an at-a-glance interface to end users and clients
• Creating Tableau dashboards using stack, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, etc to demonstrate key information for decision making
• Implementing hierarchies in Tableau with Portfolio as the highest level followed by application and project details
• Modeling all the dashboards with appropriate filters for comprehensive analysis by portfolio, application and employee roles, timestamps and location
• Extracting, manipulating and building complex formulas in Tableau, in addition, using level-of-detail calculations for various business calculations
• Developing and producing peer quality metric performance: validating data and processes to ensure accuracy, completeness, and consistency of data using SAS
• Utilizing SAS and other software to provide adhoc reporting for regulatory submissions, risk-based monitoring and publications
• Use advanced SQL concepts like OLAP, Group By and aggregate functions
• Using complex SQL queries to manipulate fetch data from different databases.
• Creating DTS packages for migration of data between different SQL environments like MS SQL
• Developed stored procedures, views, triggers, execute test cases and defect management for ETL and BI systems

Confidential, Wilmington, DE

Data Analyst/Tableau Developer

Responsibilities:

• Used tableau data visualization tools to provide an easy to understand dashboard for end users to quickly identify key themes within their Data
• Designed and created report per client’s requirements pulling data from different sources
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI's
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Provided data architecture and modelling to ensure that data within the Claims Management System (CMR) was in line with compliance guidelines
• Configured data mapping between Oracle and SQL Server using SSIS
• Deployed Tableau Dashboards and worksheets in clustered environment.
• Documented a whole process of working with Tableau Desktop, and evaluating Business Requirements.

Confidential, Pittsburgh, PA

Data Analyst/Tableau Developer

Responsibilities:

• Performed financial forecasting and reconciliation of internal accounts using Tableau, SQL and Excel
• Developed high end Tableau reports for Clients and Management and published to Tableau server.
• Involved in resolving reporting and design issues throughout the reporting life cycle.
• Collaborated with development team responsible for product delivery, support, development and maintenance.
• Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Monitored the project processes, making periodic changes, authoring progress and completion managed project plans and budget, guaranteeing on-time delivery.
• Ensured all project requirements and objectives are properly documented and pursued.
• Responsible for developing, analysing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
• Work with client and team members to understand and clarify visualization requirements.
• Written complex SQL queries and optimized queries for performance tuning.