Data Analyst Resume
Newton, PA
OBJECTIVE
- A proactive and fast learning individual seeking an opportunity to work as a dynamic data analyst utilizing analytical & methodical skills and relevant expertise to help the company achieve business goals while sticking to vision, mission and values.
- Ability to collaborate with partners and drive analytic projects end to end, Superior communication skills, both verbal and written.
- Special interest for acquiring data from different sources and develop data systems that support analysis and reporting data by using various visualization tools.
SUMMARY
- 2+ years of Professional experience in Information Technology involving Data gathering, Analysis, Design, Testing, and Training. Excellent skills in state - of-the-art technology of client server computing, desktop applications and website development.
- Over 2+ years of learning experience on Big Data Analytics with hands on experience on writing Map Reduce jobs on Hadoop Ecosystem including Hive and Pig.
- Good working experience onHadooparchitecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node and Map Reduce programming paradigm.
- Expertise in Hadoop - Big data technologies: Hadoop Distributed File System (HDFS), Map Reduce, PIG, HIVE, HBASE, SQOOP.
- Good working experience onHadoopCluster architecture and monitoring the cluster.
- In-depth understanding of Data Structure and Algorithms.
- Experience in implementing standards and processes forHadoopbased application design and implementation. Experience in managing and reviewingHadooplog files.
- Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice versa.
- In depth knowledge of database like MySQL and extensive experience in writing SQL queries, Stored Procedures, Triggers, Cursors, Functions and Packages.
- Excellent knowledge of HTML, CSS, JavaScript, PHP.
- Good working experience on Installing and maintaining the Linux on desktops.
- Experience with Create/Manage Groups, Users, Workbooks and Projects, Database Views, Data Sources and Data Connections.
- Experience with reading through Tableau logs to work through problems finding root causes and rectifying.
- Good understanding of tableau server license mechanism.
- Experience developing dashboards/reports/visualizations using Tableau.
- Experience in designing and deploying a multitude application utilizing almost all of the AWS stack(including EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM) focusing on high-availability, fault tolerance, and auto-scaling.
- Created users and groups using IAM to S# for object loss notifications.
TECHNICAL SKILLS
Programming Languages: Java, C/C++, Assembly Language (8085/8086), Python
Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Hive, Pig, Sqoop, Flume,Pentaho
Visualization Tool: Tableau, Wolfram Alpha
Microsoft Office Tools and Technologies: MS Word, MS Excel, MS PowerPoint, MS Visio, SharePoint
RDBMS: SQL Server 2008, MYSQL.
OS and Cloud Technologies: Windows, UNIX/LINUX, AWS, Ubuntu.
IDE’s: Eclipse, JDeveloper, IntelliJ IDEA.
Development Tools: MS Visual Studio, Notepad ++
PROFESSIONAL EXPERIENCE
Confidential
Data Analyst
Responsibilities:
- Accountable for executing and processing of data change requests.
- Responsible for maintenance, administration and support of data elements.
- Ensures metadata, reference documentation, data files and data flows are accurate and up to date.
- Create mappings between fields in the different sources/systems.
- Support with data validation, quality issues, integrity, accuracy, consistency and works to resolve impacting issues related to data elements; de-duplication and cleaning.
- Salesforce.com admin support: User access administration, regular data loads, data validation.
- Perform special projects as needed.
- SQL querying skills using tools like SQL based data query languages.
- Extracted, complied and tracked data and analyzed data to generate reports.
- Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis using some visualizations tools.
- Used advanced Excel functions to generate spreadsheets and pivot tables.
- Developed User Interface using HTML, XML and Java.
- Performed installation of Software’s, troubleshooting of Software’s, drivers and essential desktop /laptop troubleshooting.
- Create and maintain documentation as it relates to network configuration, network mapping, processes, and service records.
- Supported the full span of the SDLC from detailed business analysis, designing user interface design, writing business and technical
- Presented solutions in written reports while analyzing, designing, testing and monitoring systems in a waterfall methodology.
- Primary contact for internal users on how to complete required forms and retrieve related data in SAP.
Environment: Hadoop Ecosystem, Java, HTML, MS SQL, Python, Linux, UNIX server.
Confidential, Newton, PA
Business Analyst
Responsibilities:
- Supporting in planning, designing, and development of business processes.
- Providing recommendations in enhancing and expediting business activities.
- Collecting, compiling, and interpreting business data and drafting reports.
- Conducting clients' meetings, understanding and integrating their business needs into technology.
- Developing test procedures, test plans, and test cases for clients.
- Working closely with development team and testing software releases.
- Performed research and provided valuable inputs in data management process.
- Assisted in the development of market research analysis.
- Handled responsibilities of master data integration effectively.
- Supported data gathering and analysis of data.
- Participated in data quality control and validation.
- Examined user operations inquiries and outlined business specifications.
Confidential, Hainesport, NJ
Quality Assurance Data Analyst
Responsibilities:
- Developing and maintaining databases assigned/designed for reporting purposes.
- Utilizing SQL and PL/SQL for test setup and data validation on Access, Oracle, SQL Server, and Sybase databases.
- Maintaining data and generating reports from the CareLogic and Mclean eBasis.
- Conducting data analysis, design trend & performance benchmarking reports.
- Function as system administrator for software systems including agency training system.
- Format/maintain up to date approved policies and agency forms utilizing approved software/network to track ongoing updates, reviews, and approval systems
- Tracking and analyzing data and Designing reports on performance indicators.
- Providing formatted data/ reports for management/Agency improvement activities.
- Accurately and articulately detailed data issues and conveyed problems/technical issues to programmers.
- Verifying new deployments and contributed to evolution of various tools to improve data quality.
- Monitor data integrity by performing quality assurance checks on client and partner data.
- Mine and translate inventory data into meaningful metrics used to analyze efficiency and quality.