Data Analyst Resume
Richmond, CA
SUMMARY
- 5 years of professional IT experience wif expertise in data analysis, management, consulting and advisory roles.
- Proficient in writing SQL queries to analyze data and generate informational reports and customer insights.
- Good exposure in analytic techniques and methods using R programming language.
- Data management, manipulation, storage, retrieval, and statistical analysis using SAS.
- Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance).
- Good understanding of Java concepts, Python Programming and MVC design pattern.
- Knowledge of Hadooparchitecture and various technologies based on Hadoop, such as HDFS, MapReduce, HBase,Hive, PIG and NoSQL.
- Cloud technologies - exposure to Amazon’s AWS web services to upload data and create Hadoop cluster and obtain results using Command Line Interface (CLI). Also, familiar wif Cloudera Manager.
- Designing reports and dashboards of data mining results on Tableau.
- Motivated team player wif excellent communication, interpersonal, analytical and problem solving skills.
- Strong communication, collaboration and team building skills wif proficiency at grasping new functional & technical concepts quickly and utilize the same in a productive manner.
- Strong leadership skills, quick learner, problem-solving approach, multi-tasking skills, resource management skills, planning & tracking of project schedules.
- Has ability to build a strong relationship and maintaining skill across client, teams and functional areas.
- Proven aptitude to work independently and wifin a team environment to meet project deadlines.
- Industry experience in Banking, Retail Systems and Healthcare domain.
TECHNICAL SKILLS
Big Data: MapReduce, HDFS, Hive, Pig, HBase, Zookeeper, Sqoop, MapReduce, Oozie
Business Analysis: SDLC, UML-MS Visio, IBM Rational Clear Quest, BMC Remedy ITSM, JIRA
Operating System: Linux, Unix, Windows (all), MVS, OS/390
Languages: Java, Python, SAS, R, COBOL, JCL
Database: DB2, SQL, NoSQL, HBase, Oracle, Microsoft SQL Server 2008/2012, VSAM and flat files
Utilities: qMF, SPUFI, TSO/ISPF
Tools: Eclipse, SAS Management Studio, R studio, Endevor, OPC, Netterm, Acubench, SVN, FileZilla
Infogix Products: Assure, ER, Perceive, Insight, Nexix, iReports
PROFESSIONAL EXPERIENCE
Confidential, Richmond, CA
Data Analyst
Responsibilities:
- Work wif businesses to understand and gather business requirements for data migration needs.
- Assist in designing, planning and managing the data migration process.
- Perform source system data analysis and data profiling in order to manage source to target data mapping.
- Extracting data from legacy system, perform data cleansing, transforming and loading into new system using SQL scripts which would collaborate immunization information of 87% of California's 0-5 years old.
- Document and set up processes for team to follow all processes for software installations, upgrades, database and software migrations for test and production environments.
Environment: SQL Server 2008, TFS, SFT.
Confidential
Implementation Analyst
Responsibilities:
- As an onsite resource, responsibilities include analyzing customer needs, planning, assessing, designing, deploying Infogix Controls Solutions.
- Ensured dat the solution meets specifications and functions per customer specific operational work flow for multiple concepts, users, and service models.
- Mentoring clients in order to determine the most appropriate way to implement the solution to address the specific needs of the business unit.
- Implemented reconciliation solutions which resulted in reduction in manual tasks and improved efficiency by 70%.
- Provided weekly and monthly data reconciliation reports to business generated using MySQL.
- After "go-live", provide technical support to the customer.
Environment: Infogix Assure, ER, Perceive, Insight, Nexix, iReports, MySQL, JIRA.
Confidential, Pittsburg, PA
Senior Software Engineer
Responsibilities:
- Coordinated the project by analyzing client requirements, preparation of technical and functional specifications.
- Handled the major development using MVC architecture.
- Assisted team wif the coding, testing and maintenance.
- Prepared QA plans, bug tracking and maintaining code releases.
Environment: Microfocus COBOL, Flat Files,MS SQL, Netterm, Acubench, SVN, FileZilla, Windows, UNIX.
Confidential
Software Engineer
Responsibilities:
- Coordinated the project by understanding the requirements, scheduling activities, ensuring the performance consistencies and solving operational issues.
- Involved in the entire software development cycle spanning elaboration stage, building, testing and deployment, production support.
- Developed project documentation which included the technical implementations, test plans and also provided documents for maintenance.
- Developed COBOL programs, JCL jobs and DB2 queries.
- Generate weekly and monthly report using SAS to provide accounting information for various applications.
- Produced CSV, Excel, PDF and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
- Played a major role in proposing and implementing various automation processes for applications which resulted in 75% reduction of L3 incidents and 40% faster processing of batch runs.
- Individually handled the close down of various applications for which data reports were not required which saved approximately 400 MB disk space.
- Regular interaction wif clients for smooth functioning of project applications.
Environment: IBM Mainframes, COBOL, JCL, DB2, VSAM, SAS, IBM Rational Clear Quest, BMC Remedy ITSM.
