Sophia Francisca Mary A

Tableau Developer

770-***-**** admgq9@r.postjobfree.com

Chennai https://public.tableau.com/profile/sophia7897 newProfile=&activeTab=0 SUMMARY

• Tableau developer with 1+ years of hands on experience.

• Proficient with Tableau Products.

• Experience in gathering requirements from Clients and Business Analyst.

• Working with Database Objects like Tables, Views &Functions using SQL.

• Experience in Data Extraction, Cleaning and Transformation.

• Extensively involved in creating graphs by using measures and dimensions data from various databases using data blending and joining concept and utilized almost all type of graphs in Show me function.

• Access and transform massive data sets through filtering, grouping, aggregation, Level of Detail Expression and Tableau calculations.

• Created action filters, parameters, sets and groups for analytical reports and dashboards.

• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions and filters.

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

• Utilized Tableau server to publish and share the reports with business users.

• 3+ years of experience as Database Administrator.

• Support and drive the basic integration between team members.

• Quick learner and adapts to new technologies easily. SKILLS

Tableau Desktop BI Reporting

Tableau Server Dashboards

Tableau Prep SQL

ETL MS Excel

Data Analysis Windows

Data Visualization Linux

Data Management

PROFFESSIONAL EXPERIENCE

IBM India Pvt Ltd [ May 2015 – Till]

IBM India is a service based company which produces and sells hardware and software products and providing consulting software and services.

Project Details:

1. Tableau Developer: DHL Internationals [April 2020-Till] DHL is an International courier and package delivery services. Analyzing the key indications in specific to DHL Express division across different countries.

Technologies: Tableau Server,Desktop,SQL,MS Excel

Roles and Responsibilities:

• Understanding the Business insights and extracting the data from the source.

• Analyzing the key performance indicators.

• Cleaning,extracting and transforming the data for Analysis.

• Build the interactive dashboard with the derived Analysis and presented the key insights.

• Publish and share the results with the customers. 2.DB2 Database Admistrator: DHL Internationals-Germany [Feb 2018 - Mar 2020] DHL is an International courier and package delivery services which is a division of German Logistics.Maintaining their DB2 Databases located in 2 data centers Oberhausen and Bremen Location Technologies: IBM DB2,SQL,Linux,Windows.

Roles and Responsibilities:

• Administered,supported and monitored databases by proactively resolving database issues and maintaining servers.

• Worked with customers to understand needs and provide required service.

• Developed team communications and information for various client meetings.

• Created scripts and processes for data integration and maintenance.

• Installation,configuration, customization, performance tuning of database.

• Database version migration, patching and security management.

• Provide development and production support to troubleshoot day-to-day database or related application issues. 3.DB2 Database Administrator: Ahold – UK [Apr 2017-Jan 2018] Ahold is a Dutch Grocery retail company includes supermarkets, hyper-marts and online stores. Maintaining their DB2 Databases located in 4 data centers in major cities. Technologies: IBM DB2,SQL,Linux,Unix,Windows.

Roles and Responsibilities:

• Worked on day to day database related issues occurred and resolving the queries on-time.

• Making required changes, updates and modifications to database structure and data.

• Database version migration, patching and security management.

• Scheduling the backup jobs and other process and monitoring for successful completion.

• Ability to solve HA issues related to HADR, MQ series and replication methods.

• Performed online and offline backups, restore, redirect restore and roll forward activities.

• Ensuring database integrity,stability and system availability. 4. AS400 Iseries Specialist Sysco Food Corps – USA [May 2015 – Mar 2017] Sysco Food Corps is an international corporation involved in marketing and distributing food products, smallwares, kitchen equipment and tabletop.Maintaining their large number of 200+ Iseries Servers. Technologies: AS400-Iseries,Linux,Unix.

Roles and Responsibilities:

• Plan and implements a full range of operations tasks associated with complex environment to improve current system operations

• Incident, Problem and Change Management using Remedy & Maximo

• Reporting all issues to respective support team and maintaining the document process QMX on day to day basis.

• Conducting Quality checks on all team members in weekly basis.

• Extracting/ formatting alert logs and consolidating for score card on weekly basis.

• Coordinating with Helpdesk, Service Management and Hands on eyes in getting issue resolved.

• Working with Job scheduling, managing servers through HMC, backup management using BRMS, creating and working with subsystem and job management, monitoring system performance and user activities and analyses hardware/software issues in servers.

Ramco Systems Pvt Ltd [Mar 2014 – Oct 2014]:

Ramco Systems is a software and services provider which provides Enterprise Resource Planning, Human Capital Management, Logistics and Aviation Maintenance & Engineering and Maintenance Repair & Overhaul software. Project Details:

1.Project Trainee: ERP Solutions-Podar Jumbo kids Education[Mar 2014-Oct 2014] Podar Jumbo Kids is the Pre School for Children in 360+ locations in India.Designed and developed reports using Ramco Decision Works and SQL as backend.

Technologies: SQL,Decision Works.

Roles and Responsibilities:

• Involved in Report design using Decision Works and screen design using PDK design as Front End and SQL as Back end.

• Design, Develop, Test, and Support for all the modules and changes can be made as per customer needs.

• Developing Reports as per the requirements. Created Stored Procedure in SQL

• Fixing and Clearing the issues based on support queue ACADEMIC & PROFESSIONAL CREDENTIALS

B.E (Computer Science & Engineering) – May 2013

Mohamed Sathak Engineering College, Chennai.

HSC – April 2009

Sacred Heart Convent Anglo-Indian High. Sec.School, Villupuram. SSLC – March 2007

Hameediah Matriculation High. Sec.School, Kilakarai. CERTIFICATIONS

IBM Certified Database Administrator – DB2 11.1 for LUW IBM Certified Database Associate – DB2 11.1 Fundamentals for LUW

Contact this candidate