Data Analyst Modeller

Vamsi A

Data Analyst

Email: ******.*****@*****.***

Ph. #: 647-***-****

PROFESSIONAL SUMMARY:

Motivated and results-driven Data Analyst with over 5+ years of proven track record in data analytics and process mapping.

Ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.

Expertise in Design Various Reports/dashboards to provide insights and data visualization using BI/ETL tools like Tableau and Power BI.

Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.

Expertise in data models, database design development, data mining and segmentation techniques.

Strong experience in Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration, Data Integration.

Experience Data Modeller with strong conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, creating data mapping documents, writing functional specifications, queries.

Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.

Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches

Good Experience on Data archival process to SAS data sets and flat files.

Expertise in Tableau Server Installation and Configuration, creating sites, users, groups, projects, providing access levels and monitoring server health.

Expertise in configuring Tableau server environment in 1-node/3-node/5-node architecture based on the client requirements.

Experience in establishing best practices for Tableau dashboard development and deployment model for promoting them to QA/UAT/PROD environments

Extensive experience in working with Tableau Desktop, Tableau Server in various versions of Tableau.

Extensive experience in using Tableau functionalities for creating different Filters, Charts, Interactive dashboards with page and dashboard Prompts.

Expert in backend testing to verify Data integrity and Data validation of client server and web-based applications using SQL.

Experience in creating views for reporting purpose which involves complex SQL queries with sub-queries, inline views and multi table joins, with clause and outer joins as per the functional needs.

Expertise in Data Analysis functions includesData Virtualization, Data Visualization and Data Transformation & Sourcing.

Extensive experience with SQL, ETL (SSIS), PL/SQL and advanced Excel.

Experience in handling of large amounts of data (Data Cleansing, Data Profiling & Data Scrubbing and Data Blending).

Proficient in Creating and Transforming Business Requirements into software requirement specification SRS using MS Word and Rational Requisite Pro.

Strong work ethics, taking ownership of all duties and responsibilities and efficient time management skills.

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

TECHNICAL SKILLS:

BI Tools

Power BI and Tableau

RDBMS

Teradata, MS SQL Server, MS Access, DB2 UDB, Hadoop, HIVE, SQOOP, PIG, HIVE

Database Tools

Toad, Oracle.

ETL Tools

Informatica

Project Tracking

JIRA, RALLY, GitHub

Languages

SQL, PL/SQL, C, C++, Java.

Web Technology

HTML, DHTML, XML, Java Script

Operating Systems

Windows, UNIX (IBM AIX)

Programming languages

Python, R, SQL, Linux, UNIX shell scripting, Java, JSP, HTML, JavaScript, JIRA, T-SQL, PL/SQL, XML, HTML, CSS, Visual Basic, VBScript, Java script

Methodologies

Software Development Life Cycle, Agile, Waterfall, Data Modeling Logical/ Physical/ Dimensional, MS Project, SQL Profiler, Toad and TFS.

PROFESSIONAL EXPERIENCE:

Client:Sun Life Financial, Calgary, AB Sep 2021 – Till date

Role: Data Analyst

Responsibilities:

Interacted with clients to gather business and system requirements which involved documentation of processes based on the user requirements.

Performed asData Analysis using visualization tools such as Power BI, Spotfire, and SharePoint to provide insights into the data.

Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.

Worked on Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, and drill through filters, etc.

Created DDL scripts for implementing Data Modeling changes.

Created ERWIN crystal reports in HTML, RTF format depending upon the requirement,

Worked onData model in model mart, created Skilled in System Analysis, E-R/DimensionalData Modeling, Database Design and implementing RDBMS specific features.

Created the conceptual model for the datawarehouse using Erwin data modeling tool.

Worked onmining data from the SQLdatabase that was used in several significant presentations.

Implemend Multidimensional and Tabular cubes to perform interactive analysis.

Performed data analysisand data profiling using complex SQL on various sources systems including Oracle and Teradata.

Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.

Responsible for development of workflow analysis, requirement gathering, data governance, data management and data loading.

Developed ETL Scripts while loading the data, resolving loops & ambiguity joins.

Worked on setup data governance touch points with key teams to ensure data issues were addressed promptly.

Responsible for facilitating UAT (User Acceptance Testing), PPV (Post Production Validation) and maintaining Metadata and Data dictionary.

Responsible for source data cleansing, analysis and reporting using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation in Excel.

Actively involved in data modeling for the Application migration to Teradata and developed the dimensional model.

Created views for reporting purpose which involves complex SQL queries with sub-queries, inline views, multi table joins, with clause and outer joins as per the functional needs in the Business Requirements Document (BRD).

Environment:Agile, Teradata, BTEQ, Fast Load, Fast Export, Multi load, Oracle, Unix Shell Scripts, SQL Server, SAS, PROC SQL, MS Office Tools, MS Project, Windows XP, MS Access, Pivot Tables

Client: Vetro Tech Inc, Toronto, ON. Jan 2020 – Aug 2021

Role: Data Analyst

Responsibilities:

Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.

Worked with the businesses and project team members (Architect, Solution Designer, and SME's) to understand and create reporting solutions.

Performed Data analysis and Data profiling using SQL queries on various sources systems including Oracle, SQL Server.

Designed and Developed data mapping procedures ETL- Data Extraction, Data Analysis and Loading process for integrating data using Informatica.

Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.

Worked on designing and development of Tableau visualization solutions and created business requirement documents and plans for creating dashboards.

Created and maintained issue log where Business users enter their feedback by working on dashboard in test environment.

Worked on Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Developed views and templates with Python and Django's view controller and templating language to create user-friendly website interface.

Used Python and Django to interface with the jQueryUI and manage the storage and deletion of content.

Involved in Tableau Server Installation and Configuration, creating users, groups, projects and assigning access levels.

Involved in Tableau server upgraded from single node to distributed environment, making Tableau services more scalable and stable.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked on Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Log Axes and dashboards using KPI's.

Worked on development assisting users in creating and modifying worksheets and data visualization dashboards.

Worked on best practices for Tableau report development.

Worked oncreation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks

Worked on Preparing Dashboards using calculations, parameters in Tableau

Defined best practices for Tableau Desktop and Server report development and effectively used data blending feature in tableau.

Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.

Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.

Worked on Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

Worked on Creating users, groups, projects, Data connections, settings as a tableau administrator.

Involved in creating dashboards and reports in Tableau and maintaining server activities, user activity, and customized views on Server analysis.

Participated in the retrospective meetings and next sprint planning meetings.

Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Assist with Support tickets and responding to developer questions; troubleshoot bugs and issues recorded in JIRA and coordinate with Lead Developers on status.

Environment: Tableau Desktop, Rally, Agile Scrum, Shell Scripting, ERWIN, Teradata, MSBI (SSAS, SSRS, SSIS), MS SQL Server, PL/SQL, Python, SQL. TOAD, Flat files, Tableau server / Administrator, SQL developer, Access and .CSV Files

Client: Encode Technologies Inc., Chilliwack, BC. Aug 2018 – Dec 2019

Role: Data Analyst

Responsibilities:

Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users.

Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks

Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.

Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.

Created DML code and statements for underlying & impacting databases.

Performed data reconciliation between integrated systems.

Worked as Metrics reporting, data mining and trends in helpdesk environment using Access

Extensively used MS Access to pull the data from various data bases and integrate the data.

Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.

Responsible for different Data mapping activities from Source systems to Teradata

Worked on the oversight for compliance to the Enterprise Data Standards

Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server with high volume data

Worked with Excel Pivot tables.

Create and Monitor workflows using workflow designer and workflow monitor.

Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL

Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Developed regression test scripts for the application and involved in metrics gathering, analysis and reporting to concerned team and tested the testing programs

Identify & record defects with required information for issue to be reproduced by development team.

Flexible to work late hours to coordinate with offshore team.

Environment: MS Excel, PL/SQL, ETL Tools Informatica, Oracle, Teradata, Teradata SQL Assistant.

Client:JP Morgan Chase, India. Apr 2017– Jul 2018

Role: Data Analyst

Responsibilities:

Responsible for gathering data migration requirements.

Identified problematic areas and conduct research to determine the best course of action to correct the data.

Analyzed reports of data duplicates or other errors to provide ongoing appropriate inter-departmental communication and monthly or daily data reports.

Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.

Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible

Involved in data mapping and data clean up.

Involved with dataprofiling for multiple sources and answered complex business questions by providing data to business users.

Enhance smooth transition from legacy to newer system, through change management process.

Archived the old data by converting them in to SAS data sets and flat files.

Analyzed and maintained SAS programs and macros to generate SAS datasets.

Created Technical Design Documents, Unit Test Cases.

Involved in Test case/data preparation, execution and verification of the test results

Reviewed PL/SQL migration scripts.

Coded PL/SQL packages to perform Application Security and batch job scheduling.

Created user guidance documentations.

Created reconciliation report for validating migrated data.

Analyzed problem and solved issues with current and planned systems as they relate to the integration and management of order data.

Planned project activities for the team based on project timelines using Work Breakdown Structure.

Environment:UNIX, Shell Scripting, XML Files, XSD, XML Spy, SAS PROC SQL, Cognos, Oracle,Teradata, Sybase, Mercury Quality Center, Toad, AutoSys.

Reference available upon request.

Contact this candidate