Resume

Sign in

Data Microsoft Office

Location:
Conshohocken, Pennsylvania, 19428, United States
Salary:
52000
Posted:
February 07, 2018

Contact this candidate

Resume:

.

SWARNA MATCHA

PROFESSIONAL OVERVIEW

*+ years of experience on Data analysis, extraction, transformation, Load and visualize data using Analytical tools and ETL tools

Good hands on experience using Microsoft Excel to analyze data and generate reports

Good hands on experience using Excel Formulas and Macros

Good hands on experience creating pivot tables, pivot charts, pie charts, bar charts

Looking up data using functions VLOOKUP, HLOOKUP, INDIRECT in Excel

Good hands on experience writing SQL queries for Oracle, SQL Server and Teradata databases

Good Hands on experience gathering data from multiple sources, transforming and loading to targets

Create Reports, Dash boards using Tableau desktop, PowerBI desktop and publishing them to tableau server, Power BI site

Establish the data connection for SQL Server, Oracle

Create visualization Bar charts, line charts, Pie charts, Pivot charts via Microsoft Excel, Tableau and Power BI

Good Hands on experience in ETL tool Ab initio

Good hands on experience using the components dataset, database, transform, partition, Departition etc.

Good knowledge and experience on Informatica power center

Good Knowledge on Microsoft Access creating databases, queries, forms and reports

Good hands on experience working in Windows, Unix, Mainframe environments

Good knowledge creating queries, tables, forms in Microsoft Access.

Good Knowledge on Salesforce Administration

Good Knowledge on SAS, Google Analytics

Ability and desire to learn new processes, tools, and technologies

Keen attention to detail when analyzing and interpreting data/issues

Ability to multi-task, prioritize effectively and efficiently

Capability to understand the business processes, database structures, and data presentation.

Highlight issues, concerns at the earliest and do defect prevention/resolution activities

Excellent written and verbal communication skills

Strong mathematical, analytical, problem solving, and decision-making skills

Create Test Cases, CIT Plan, CIT test closure report, Low level Design Documents, job scheduling requirements, code handover specs, Error Handling Documents for Support etc.

Demonstrated ability to meet schedules and multi-task across multiple projects.

Good Individual and team player who thrives on working in diverse teams and challenging environment

Flexible and adaptable across multiple technologies and methodologies

TECHNICAL SKILLS

Microsoft Office Tools : Word, Excel, Visio, PowerPoint, Access, Outlook

Database : Oracle 9i,10g, SQL Server, PostgreSQL, Mongo Db, Teradata

Operating Systems : Unix, Windows XP, Windows Server 2003, Mainframe

Analytical Tools : Excel Pivot Table, Power bi, Tableau, SSRS,SAS

ETL Tool : Ab Initio, Informatica, SSIS

Programming Language: HTML, XML

Browsers : Internet Explorer, Google Chrome, Mozilla Firefox

Professional Recognition

• Outstanding Contribution Award to achieve CMMI level 5 for Sopra Steria

PROFESSIONAL EXPERIENCE

Freelancer 2016 Nov-2016 Dec

Responsibilities:

Translate business needs to technical specifications

Responsible for Data Extraction, cleansing data and Visualize data using tools

Gather the data from different data sources.

Responsible for Data Extraction, Transformation and Load using tools and Scripts

Create Reports, Dash boards using tableau desktop, PowerBI desktop and publishing them to tableau server, Power BI site

Establish the data connection for SQL Server

Create visualization Bar charts, line charts, Pie charts, Pivot charts via Microsoft Excel, Tableau, Power BI

Applying Formats and Styles to reports and data

Collaborate with teams to integrate systems

Sharing the reports to Users and providing the support for better understanding

Sopra Steria - India 2010 June-2013 Aug

Role: BI/Data Analyst

Responsibilities:

Translate business needs to technical specifications

Responsible for Data Extraction, Transformation and Load using tools and scripts

Validating the data and loading into targets

Create Reports, Dash boards using tableau desktop and publishing them to tableau server

Create visualization Bar charts, Pie charts, Pivot charts via Microsoft Excel

Looking up data using functions VLOOKUP, HLOOKUP, INDIRECT and Macros

Applying Formats and Styles to reports and data

Prepare the Documentation regarding the work for future references

Participate in Team meetings for requirements gathering, code updates

Provide support to end users

Collaborate with teams to integrate systems

Contact Details:

Full Name : Swarna Latha Matcha

Phone : 732-***-****

Education : Bachelor’s Degree in Computer Science Engineering

Email : ac4dvx@r.postjobfree.com

Location : Conshohocken, PA



Contact this candidate