.
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