SUMMARY:

• Ten (10) plus years in fields such as Financial, Banking, and Healthcare domain. Savvy and dynamic individual with a wide range of IT knowledge and expertise gathered over the span of Very passionate about projects and able carry out tasks that are time sensitive in an efficient manner in order to guarantee the growth and improvement of the organization.
• Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experienced in working with tools like TOAD, SQL Server Management studio(SSMS), SQL Developer, Teradata-BTEQ and SQL plus for development and customization
• Ability to understand the business from various points of view due to diverse experiences as Programmer Analyst, Business Analyst and Marketing & Strategic Planning Analyst.
• Extensive Experience in DATA ANALYSIS, DATA MANIPULATION, DATA MINING, DATA EXTRACTION, REPORT CREATION, Importing & Exporting Data in different formats and from various source systems.
• Created numerous reports using SAS and Pivot tables (Excel).
• Manipulated data using SAS Data step such as SAS Format/Informat, Merge, PROC APPEND, PROC DATASETS, PROC SORT and PROC TRANSPOSE
• Extracted data from Flat Files, Excel spreadsheets and external RDBMS (Oracle, Teradata, DB2, MySQL, SQL Server) tables using LIBNAME and SQL PASS-THROUGH facility.
• Proven ability in working with enterprise level large data warehouse, RDBMS systems, and ETL and modeling tools/techniques
• Identified issues when reports are created from several and complex data sources.
• Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, STAR SCHEMA, SNOW-FLAKE, Fact and Dimension Table, Physical and Logical Data Modeling using ERwin
• Expertise in ensuring DATA QUALITY and DATA INTERGRITY in all project deliverables
• Extensive TABLEAU Experience in Enterprise Environment, in Tableau 10.x, 9.x, 8.x as a Consultant, Developer and Analyst
• Knowledge in using TABLEAU PREP to prepare data for analysis in tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Experience working with various data sources such as Oracle, SQL Server, Hadoop, Teradata, PostgreSQL, MySQL, MariaDB and flat file sources
• Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, Sharepoint and Visio).
• Excellent knowledge and ability to create reports, dashboards and Trend analysis with tools such as EXCEL and TABLEAU.
• Experience with UX design and functionality
• Experience in Data Munching (data scrubbing and cleansing).
• Experienced in DATA GOVERNANCE and DATA MANAGEMENT POLICIES
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Self-motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
• Exceptional organizational and time management skills and the ability to work independently.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

TECHNICAL SKILLS:

Databases: Oracle 10g/11g/12c, MS SQL Server 2008/2012/2014 , AWS, MySQL 5.2, 5.7, MS Access, Teradata, PostgreSQL, MariaDB, Hadoop

ETL/Other Tools: Tableau PREP, SAS Base 9.x, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant, Github, Clarity

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

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 10.x, 9.x, Business objects xi3.1, Power BI, MicroStrategy, Excel, PowerPivot, SSRS

Programming language: R, Python, Java, Shell Scripting, HTML, PHP

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

Project Management Tool: Jira

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Senior Data & Reporting Analyst

Responsibilities:

• Accountable and leading the team for translating specific business issues and questions into appropriate functional and analytic designs/results.
• Provides recommendations to support critical business decisions through data analyses
• Created Business Requirements Document (BRD), Functional Requirement Document (FRD), Technical Requirement Document and Data Mapping Documents.
• Utilizes work flows and evidence-based practices to help with analyses and recommendations.
• Collaborates on multiple analytic efforts through project documentation, data extraction from various source systems (ServiceNOW, RSA Archer, etc.), subsequent data summarization, manipulation, display, and/or presentation.
• Automated the extraction of the risk by using tableau prep to connect to the various source systems to cleanse and transform the data that will be used in tableau.
• Developed leading routines and data extracts with Informatica and SAS and Oracle procedures.
• Develops Tableau workbooks using calculated fields to produce the Risk scores to assess the overall Quality of Risk Management(QRM) as well as QRM of the individual applications(Mnemonics).
• Develops visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis, trends and drill downs along with user level security.
• Creates interactive dashboards for the Prime Process and RAU Assessments.
• Provides ongoing coaching, enabling team members to develop and improve skills and capabilities that support the effectiveness of the project.

Confidential, Washington, DC

Data Analyst/Tableau Developer

Responsibilities:

• Created complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data
• Business requirement gathering and translating them into clear and concise specifications and queries
• Played a key role in UAT process by taking valuable feedback from customers and improving product performance which led to project's extension
• Created database objects such as tables, views, stored procedures, triggers
• Produced clear, concise, relevant and accurate documentation based on captured requirements and information gathered from stakeholders and subject matter expert
• Handled tasks of building, deploying and maintaining metadata inventories and data support tools
• Created Dashboards that ensured data driven monitoring of KPI, KRI and KCI, exposures, controls and processes tracked appropriately to provide guidance for risk mitigation and process improvements
• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
• Documenting the extent to which data fails to meet threshold reporting requirements
• Define and maintain current state documentation and data lineage capture using data flow and metadata
• Mastered the ability to design and deploy rich Graphic visualizations with Navigational sheets, Drill Down menu option and Parameterized using Tableau.
• Generated Dashboards with Quick filters, calculated fields, Groups, Parameters and Sets to handle views more efficiently in Tableau.
• Building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions 10.x/9.x
• Created Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.

Confidential, Providence, RI

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Create BTEQ scripts to load the data from staging table in to target table in Teradata environment
• Created SAS code to be used by the team members to export and import data in and out of SAS and Teradata.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created complex dashboards using filters, calculations based on requirements, drill-through and Linked reports.
• Involved in creating compound and dynamic reports with sets, groups and hierarchies.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9.1 desktop.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/ dynamic and static data sets
• Used Web Mapping Service and embedded different city maps in tableau.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Created Different Schedules based on the requirement and used to create tasks to refresh and Subscriptions to the reports
• 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.

Confidential, Dublin, OH

Data Analyst

Responsibilities:

• Support, manage, and maintain organizations clinical data in databases in SQL Server.
• Analyze data and develop unique tables, charts and other data displays for inclusion in reports to various clients and as data support for research/consulting staff.
• Gather, analyze, and document data requirements for projects of medium to high complexity and moderate to high risk, perform source system data quality analysis.
• Used SQL and PROC SQL (SAS) for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
• Perform numerous data pulling requests using SQL server 2012 and Tableau for analysis.
• Collect data from all clients and make recommendations for improvement.
• Clean, process and load data through ETL using SSIS and queries in SQL Server, presented in MS Excel, Tableau report or PDF.

Confidential, Chicago, IL

Business Intelligence Developer

Responsibilities:

• Involved in business process analysis, attended daily meetings to keep up with requirement changes and updates
• Worked with business users to understand their business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
• Made business recommendations based on data collected to improve business efficiency.
• Worked in an Agile environment - Completing sprints to fulfil customer requirements
• Demonstrated team cohesiveness and organizational commitment.
• Developed and executed automated test case scripts Test for the Front-end applications
• Performed Data Analysis, created gap analysis document, and performed data quality Checking.
• Created an automated daily ETL (Extract, Transform& Load) process using Teradata Utilities such as Fast Load, Multi Load and SQL Assistant
• Worked with the testing team to resolve bugs related to ETL mapping before production
• Developed various dashboards, used context filters, sets while dealing with huge volume of data. Provided Tableau desktop for end users. Worked on creating Pivots, sets, groups, and parameters.
• Worked on Creating various plots and drill down analysis using Tableau desktop.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

Confidential, Minneapolis MN

Data Analyst

Responsibilities:

• Utilized SQL to develop stored procedures, views to create result sets to meet varying reporting requirements.
• Built and supported the transformation of various data inputs into the companies Data Warehouse.
• Analyzed and designed solutions create technical integration and consult with QA personnel on their tasks related to the imports and extracts.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP (Online Analytical Functions).
• Wrote queries to fetch data from different table by using JOINs, Sub-queries, Correlated sub-queries and derived tables
• Worked with OLAP and OLTP tools such as ETL, data warehousing and Modeling.
• Responsible for designing the new reports and writing the technical document, gathering the requirements, analyzing the data, and creating Tableau reports and dashboards.
• Created numerous permanent tables, Volatile tables and Global Temporary tables.
• Handle Strong healthcare material including experience with transaction standards.
• Gathered Information, analyzed reports and presented reports