Data Power

Malarvizhi Kannan

***********.*******@*****.***

Cell No: -707-***-****

Professional Experience

•Knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and Identifying Data mismatch

•IT experience in Data Analysis, Design, Implementation and support of Business Intelligence using Power BI, Tableau and MSBI Stack: SSRS, SSIS, SSAS and SQL Server.

•Involved in all the phases of SDLC including Requirements collection, Design and Analysis, Development and Customization of the application with Waterfall and Agile SCRUM methodologies.

•Coordinated teams and collected Business requirements document (BRD) from clients' associates and had experience in creating functional requirement documents (FRD).

•Developed complex reports and dashboards and supported the existing reports using Power BI based on the end-user requirements.

•Design, develop and implement reporting and dashboard solutions using Power BI, Tableau.

•Experience implementing and supporting Self-service BI tools such as Microsoft Power BI and Excel (PowerPivot, PowerQuery, and PoverView).

•Hands on experience in Tableau Desktop, Tableau Server, Tableau Public and Tableau Reader in various versions of Tableau.

•Experience in Dimensional Data Modeling using Star and Snowflake Schema, also have vast experience in slowly changing Dimensions and Meta data management.

•Created test scripts, business process flows, and conducted multiple testing cycles.

•Conducted analysis focusing on the development of creative solutions delivering substantial results to clients. Evaluated business needs, user requirements and functional specifications and analyzed and understood client strategic direction, issues and project goals to deliver exemplary customer service to clients.

•Experience in building the Data warehouse using Ralph-Kimball methodology.

•Extensive experience in developing mappings for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse/Data Marts.

•Experience in creating Reusable Transformations (Joiner, Lookup, Sorter, Aggregator, Expression, Update Strategy, Router, Filter, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

•Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.

•Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

•Experience in performance tuning of SQL queries and ETL components.

•Extensively used SQL and PL/SQL in creation of Triggers, Functions, Indexes, Views, Cursors and Stored Procedures.

•Proficient in writing documents, preparing presentations and presenting them.

•Experienced in UNIX Shell scripting as part of file manipulation, Scheduling and text processing.

•Excellent knowledge on creating DML Statements for underlying statements

•Involved in code migration from Development to Testing & Production environment.

•Worked with end users/customers to understand business requirements, recommended technical solutions, and documented functional requirements

•Experienced in creating SSIS packages in Data Extraction, Transforming, and Loading (ETL) from various sources using SQL Server Integration Service

•Experience in providing System and User-defined Variables, Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages

•Experience in creating configuration files to deploy the SSIS packages across all environments

•Expertise in conversion of DTS to SSIS packages and troubleshooting the migration issues

•Extensive knowledge of Designing, Developing, and deploying various kinds of reports using SSRS with relational and multidimensional data

•Performed detailed analysis, gathered requirements and specifications in software Development life cycle process and performed unit testing, integration and production install and support.

•Extensive experience in creating complex Stored Procedures, Views, Indexes, Synonyms &

•Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints, and Indexes.

•Effectively involved in all the phases of SDLC such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects

•Expert in using SQL Server Agent to schedule and monitor jobs.

Work Experience

ETL Power BI / Tableau Sept 2016 – Present

Cigna Corporate Services - Plano, TX

•Responsible for Importing data from different data sources like SAP BW, Azure Analysis Service, SharePoint, and Excel and modelling it into Power BI Desktop.

•Hands on experience with different data import modes in Power BI like Import, Live connection, and Direct Query.

•Creating interactive reports by using different visualizations like table, matrix, line, Line and stacked column, Slicers, clustered column charts in Power BI Desktop.

•Created calculated measures and calculated columns in Power BI desktop to show good analysis techniques.

•Design and develop T-SQL procedures, query performance tuning and SSIS packages.

•Created functions to provide custom functionality as per the requirements.

•Used SSIS to implement slowly changing transformation to maintain historical data in data warehouse.

•Developed visualizations using sets, Parameters, Dynamic sorting, Filtering, Parameter driven analysis.

•Used Tableau features like Data blending, Extracts, Parameters, Filters Calculations, Context Filters, Hierarchies, Actions Maps etc.

•Design and development of Tableau visualization solutions using operational dashboards.

•Expertise in understanding visual design principles like color, layouts, and graphics.

• Created Relationships, actions, calculated fields, sorting, groupings, live connections, in-memory in both Tableau and Excel.

•Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.

Created Tables, Views, Constraints, Indexes and developed Complex database objects including Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL

•Created stored procedures, Views and SQL queries to pull data into power BI model.

•Designed expressions to calculate, group, filter, parameterize, and format report contents.

•Generated score cards with executive summary dashboards to display performance monitoring measures.

•Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.

•Integrating power BI report with REST API, websites, SharePoint, so on

•Provide continued maintenance and development of bug fixes for the existing and new Power BI

•Reports.

•Develop, test and maintain ETL procedures employing ETL tools

•Extensively used MS SQL to embed complex business logic in stored procedures

•Configured the mappings to implement Slowly Changing Dimensions (Type-2).

•Expert in creating and developing Power BI Dashboards into rich look.

•Expertise in Power BI, Power BI Pro, Power BI Mobile.

•Created Power BI reports and dashboards to address business objectives and reporting requirements.

• Expertise in writing complex calculated measures by using DAX.

•Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, bar and density charts.

•Integrate custom visuals based on business requirement using Power BI Desktop.

•Exploring data in a different way and across visualization by using Power BI.

•Develop SQL queries/scripts to import data from Azure SQL database.

•Worked on all types of transformation that are available in Power Query Editor based on requirement.

•Worked on Finance Insights report to show how revenue is fluctuating Month over Month, Quarter over Quarter and Year over Year and their Percentages using DAX Time intelligence functions like Previous month, Previous Quarter, sameperiodlastyear etc.

•Connected tabular model from Azure analysis service using live connection and created interactive reports on top of that based on business requirement.

•Experience on creating different levels of filters like visual level, page level, report level filters.

•Hands-on experience with Bookmarks, Sync Slicers, Tooltips, Actions & Interactions in Power BI.

•Experience with composite models, Data Modelling and Power Query editor like appending queries, splitting data into separate columns, adding columns, Advance editor, creating groups etc.

•Performing unit testing on created reports to get desired output from the data.

ETL Informatica Developer April 2014 – Aug 2016

Austin Community College - Austin, TX

•Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Master Data Management(MDM), Data Marts / Decision Support Systems using Informatica Power Center ETL tool.

•Knowledge on Informatica Power Exchange that brings the data from mainframe structure to the target.

•Worked in a competitive Agile environment to develop standard ETL framework and reusable mappings and Mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup and Filter.

•Created Reusable Transformations, Worklets, and made use of the Shared Folder Concept using shortcuts wherever possible to avoid redundancy.

•Implemented standards for naming Conventions, Mapping Documents, Technical Documents, and Migration form.

•Experienced in delivering the Technical process flow for different Line of Business. Gathered, analyzed & documented business requirements.

•Working extensively on Source, Target, Lookup, Expression, Sequence Generator, Joiner, Router, Update strategy, Aggregator, Filter etc. transformations in Informatica for populating target table in efficient manner.

•Designing the ETL Extract from various sources like Oracle, MS SQL Server, Teradata, Flat files and load the data into target and also involved in creating Staging Tables in Teradata.

•Implementing Slowly Changing Dimensions Type 2 and Type 3 for data loads.

•Creating Mappings to implement data cleansing on the source data.

•Using Mapping Variables, Mapping Parameters and Session Parameters to increase the re-usability of the Mapping.

•Creating source to target mappings, edit rules and validation, transformations, and business rules. Analyzing client requirements and designing the ETL Informatica mapping.

•Scheduling and Running Workflows in Workflow Manager and monitoring sessions using Informatica Workflow Monitor.

•Tuning performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.

•Validating and testing the mappings using Informatica Debugger, Session Logs and Workflow Logs.

•Extensively worked on developing Informatica Mapplets, Mappings, Sessions, Worklets and Workflows for data loading.

•Experienced Working on different tasks in Workflow Manager like Sessions, Event wait, Decision, E-mail, Command, Assignment, and Scheduling of the workflow.

•Created sessions, batches for incremental load into staging tables and scheduled them to run daily by using Autosys.

Data Analyst July 2013 – Mar 2014

Johnson & Johnson - New Brunswick, NJ

•Developed insightful reports, KPIs and dashboards on the key drivers of business to identify improvement opportunities.

•Evaluated and assessed data quality measures to ensure that they meet Enterprise Data Governance guidelines.

•Experienced using Hadoop, MapReduce, Hive and Spark to write batch and stream analytic processing jobs.

•Created dashboards using Tableau and Podium for visualization of reports. Created Key Performance Indicators (KPI) dashboards and parameters.

•Automated and listed packages in Python to support daily, weekly and monthly standard reports.

•Created dashboards and reports using Power BI for presentations and visualization by end users.

•Conducted data profiling on small and large data sets to evaluate data quality and provided remediation and recommendations.

•Retrieved and transformed data using Tableau and software and MS Excel into actionable intelligence.

•Create and perform SQL queries for a variety of daily, weekly and monthly performance statistical reports.

•Used pandas, NumPy, seaborn, SciPy, matplotlib, scikit-learn in Python for developing various machine learning algorithms.

•Gathered and analyzed business requirements, interacted with various business users, project leaders, developers and also took part in identifying different data sources

•Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

•Performed data testing, tested ETL mappings (Transformation logic), tested stored procedures, and tested the XML messages.

•Data wrangling and scripting in Python, database cleanup in SQL, advanced model building in R/ Python, and expertise in data visualization.

Contact this candidate