B. ELAVARASI

994*******

ad43rv@r.postjobfree.com

SUMMARY

To nourish my technical and managerial skills by working in the dynamic environment of the MNC and acquaint myself with the necessary skills required to excel in the practical arena of the corporate world. Expert in managing the baseline scope of assets for each project and reviewing the data received from the variety of sources. Supported the quality of the planning process, analysis and refresh of the asset data is required on a frequent basis. Excel in data analysis, project management, data modeling, implementing user acceptance testing, providing trainings and technical support towards achieving business goals.

TECHNICAL SKILLS

Reporting Tools/ETL : Power BI, SSIS

Databases : Oracle SQL DEVELOPER 11G, SQL SERVER 2014 Ticketing Tools : JIRA, ServiceNow, Remedy

Languages : SQL, DAX, UNIX Shell Scripting

Cloud Platform : Snowflake, Databricks

Automation Tools : Re-Aim, MuleSoft

EDUCATION

Anna University Bachelor's Degree in Information Technology (IT) PROFESSIONAL EXPERIENCE

-Designed simplex to complex intuitive Power BI reports/dashboards, using visuals interactivity.

-Data cleansing and data transformation (Using Power Query Editor/ Advanced Query Editor).

-Good experience on various data sources to extract the data by using various types of connection modes likes Import, Direct Query and Live connection.

-Creating calculated columns, measures, parameters, and custom tables using DAX/ Power Query M-Language.

-Publishing reports to services, Scheduling data refreshes for the datasets/reports, Configuring alerts and subscriptions for end users.

-Design, development, testing and deployment of Power BI Dashboards using Deployment Pipeline.

-Experienced to use standard visualizations like Slicer, Card, stacked column chart, clustered column chart, Line and stacked column chart, Line and clustered column chart, map, Pie-Charts, Bar Graphs, Drill downs and custom visuals using Power BI.

-Implemented Report Filters, Bookmarks, Sync Slicers, Page tooltips, Drill-through.

-Worked in Workspaces, Users and Groups assigning the permissions and security to users using Row Level Security (RLS) implementation.

-Conversant with Data warehouse concepts like Star schema, Snowflake schema, Data Marts, Dimensional & Fact tables and Stored Procedures, Functions, Data Dictionary.

-Experience in Analytical SQL using CTE, Joins, Sub queries, Aggregate functions, Analytical functions, Views.

-Used Power Automate to send dynamic reports to end users and report refresh.

-Build scalable and reusable logic through dataflow for various report in power bi. PROJECTS WORKED

RF Managed Services, Chennai From January 2019 - September 2023 Senior Process Specialist Lead - Data Analyst

CLIENT NAME: PGIM

Technologies : Power BI, MS SQL Server, JSON

Experienced on implementing strategic solutions using Power BI and SQL with extensive and progressive experience in design, development.

• Coordinate and schedule meetings and conferences with SDMs, and external stakeholders.

• Prepare and distribute meeting agendas, minutes, and other relevant materials.

• Handle confidential information and SOPs creation with discretion and maintain their proper organization.

• Participate in management reviews and teleconferences and report weekly & daily status walkthrough to the SDMs / Client

• Understand the business scenario, Work with heads of business to acquire data from various sources.

• Worked on client problem understanding, requirement building, documentation and translation of the requirements into dashboard solutions.

• Building, publishing customized interactive reports and dashboards, report scheduling.

• Creating the Measures according to the business logic in Power BI Desktop using DAX

•·Involved in understanding the business requirements and document specifications. Getting data from different sources, extraction, transform and shape the data using Power Query and then load the data into data modelling.

• Extensively created Calculated Measures, Custom columns using Power BI Desktop to generate reports for Business analysis.

• Data modelling, Creation, Report designing, Data investigation through Power BI.

• Developed analysis reports and visualization using DAX functions like Table Aggregation functions and Date & Time functions.

• Hands on practice on marketplace timeline slicer, hierarchy slicer, text filter, word cloud. Amdocs Development Center, Pune From Dec’2016 - Sep’2018. Scheduling Analyst - Technical & Business Operations CLIENT NAME : Vodafone, O2 IRELAND

Technologies : SQL, Unix Shell Scripting, Mainframe DB2

• Created Workbooks and dashboards for analyzing statistical billing data.

• Created and maintained SQL server agent jobs to execute SSIS packages, batch processes and SQL scripts.

• Monitoring of Rating, Billing, AR, Invoicing, etc. processes and providing expert support.

• Supporting tickets from Customer Operations.

• Daily Report generation monitoring and triggering in case of failures.

• System health check and pro - active restarts.

• Daily & weekly & monthly task, Health checks, monitoring, and proactive restart

• Troubleshooting & resolving all incidents, service request, Problem & trouble tickets assigned as per agreed SOPs.

• Experience with different telecom applications domain.

• Creates and maintains environment for running batch jobs associated with daily batch cycle and batch reporting system.

IBM India Pvt Ltd, Chennai From Feb’2011 to Dec’2014. Senior System Operations Specialist - Technical & Business Operations CLIENT NAME : Marathon Oil Corporation, PMUSA, Vodafone, O2 IRELAND Technologies : SQL, Unix Shell Scripting, Mainframe DB2, JCL

• Created Workbooks and dashboards for analyzing statistical billing data.

• Created and maintained SQL server agent jobs to execute SSIS packages, batch processes and SQL scripts.

• Monitoring of Rating, Billing, AR, Invoicing, etc. processes and providing expert support.

• Supporting tickets from Customer Operations.

• Daily Report generation monitoring and triggering in case of failures.

• System health check and pro - active restarts.

• Daily & weekly & monthly task, Health checks, monitoring, and proactive restarts

• Troubleshooting & resolving all incidents, service request, Problem & trouble tickets assigned as per agreed SOPs.

• Experience with different telecom applications domain.

• Creates and maintains environment for running batch jobs associated with daily batch cycle and batch reporting system.

Mainframe System Administration Trainee - Arich InfoTech Pvt Ltd, Chennai – From Jan’2010 to Feb’2011. Senior Proof Reader - Executive (Scientific & Medical Books Production) Horizon Technologies, Chennai – From Aug’2006 to Sep’2009.

PERSONAL PARTICULARS

Name : B. Elavarasi

Sex : Female

Languages Known : English, Telugu and Tamil

Nationality : Indian

Marital Status : Married

Contact this candidate