We provide IT Staff Augmentation Services!

Data Analyst Resume

SUMMARY:

  • 11+ years of Experience as a Architect/Lead/Developer in Big Data, Talend, Data Warehouse, ETL, BI and MDM technologies encompassing multiple ETL, reporting & MDM tools, and data environments including relational, multi - dimensional, and big data (Hadoop) platforms.
  • 7+ years of Industry experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, CRM, Client/Server applications.
  • 6+ years of IT experience as a Business Analyst in deployment of web-based, Client-Server applications, developing business processes and system solutions for Hotel, Retail, Healthcare and Financial Industries for various projects from conceptualization to implementation.
  • Strong experience on Project Management, Systems Integration, Data warehouse architecture, Database Design, ETL Design, Report Design, ETL Optimization, Data Profiling, Data quality process design, Best practice implementation, ETL Development, Production support and team co-ordination.
  • Strong Expertise in ETL technologies Informatica (Certified), SSIS & Talend.
  • 4+ years of MDM experience as MDM (Talend & Informatica) Architect/Lead/developer responsible for a complete enterprise MDM solution from inception to production.
  • Experience as BI Lead/Developer with 4+ years hands on in Oracle Business Intelligence, Tableau consultant with strong experience in end to end solution development and support.
  • Excellent understanding of Hadoop architecture and underlying framework including storage management.
  • Experience in using various Hadoop Ecosystems such as HDFS, MapReduce, Pig, Hive, Zookeeper, HBase, Sqoop, Oozie, Kafka, Storm, NiFi, Talend BigData Studio and Flume for data storage and analysis.
  • Strong experience in Data Analysis, Data Profiling Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Informatica PowerCenter and Talend Studio Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
  • Over 3+ years of expertise experience in Talend Data Fabric to ingest the data from various source systems to Hadoop using Talend Bigdata Integration Suite, performed the data quality analysis using Talend DQ, cleansed the data using Talend DP and mastered & governed the customer data using Talend MDM.
  • Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications.
  • Developed design and approach for Incremental pull & CDC with insert/update/deletes across multiple source systems and modules like SAP BW and HANA, Sales force, Siebel in ETL as well as Hive.
  • Experience in developing Map Reduce Programs using Apache Hadoop for analyzing various source system types as per the requirement & using Sqoop to import data into HDFS from Oracle, DB2, Progress/ AS400 databases, SAP HANA, Sales Force, FTP.
  • Understanding of Partitioning and Bucketing concepts in Hive, and performance improvement in Hive modifying Joins, groups and aggregations.
  • Good knowledge in using job scheduling and monitoring tools like Autosys, DAC, TAC, Crontab, Oozie.
  • Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
  • Ability to collaborate as a Functional Analyst & Technical Developer with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
  • Assisted with new business activities as required, including attending brainstorming sessions, Developing statistical analyses to prove capabilities and other assignments as needed.
  • Modelled and Designed Architecture, Use Case and Activity diagrams using Rational Software Architect Tool and Microsoft Visio.
  • Over 3 years of Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, Universal Data Models, FACT & Dimensions tables, Logical & Physical data modeling, ERStudio 7.1/6.1
  • 2+ years of hands on experience in customizing and configuring Workforce, Payroll and Recruitment data of HR BI Apps analytics and extended the OOTB code as per requirements from Business.
  • 2+ years of experience with CRM solutions using Siebel Call Center application.
  • Experienced working in Waterfall, Agile and Scrum development environments.
  • Gained progressive working experience in Banking, Finance, Hospitality, Healthcare and Product based industries.

TECHNICAL SKILLS:

Reporting Tools: Oracle Business Intelligence (OBIEE) 10.1.3.3, Microstrategy 9.x, Tableau 9.x, Oracle Business Intelligence Applications 6.3/ 7.9, QlikView

Cloud Technologies: Amazon Redshift

CRM: Siebel CRM

ETL Tools: Informatica PowerCenter 7.x/ 8.x/ 9.x, Talend ETL, Pentaho, ODI

Data Modeling: Erwin 7.2, MS Visio 2010/ 2013

Data Quality: IDQ, Talend DQ, Talend DP, Talend Stewardship Console

Databases: Oracle 8i, 9i, 10g, 11g, MS SQL Server 2005/2008/2012/2014 , DB2

Operating Systems: Red Hat 6.x/ 7.x, Ubuntu 12.x/14.x/15.x, Windows 2003/2008/2012

Programming Languages: C/C++, Shell Scripting, SQL, PL/SQL, HTML

Scheduling Tools: Autosys, DAC, TAC, Oozie

MDM: Talend MDM 5.6/2/ 6.1, Informatica

Certifications Informatica, OBIEE, OCP

Big Data Hortonworks Data Platform (HDP) 2.3, Hive, Spark, Pig

DBA Oracle DBA Support, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

  • Developed design and approach for Incremental pull & CDC with insert/update/deletes across multiple source systems and modules like SAP BW and HANA, Sales force, Siebel in ETL as well as Hive.
  • Experience in developing Map Reduce Programs using Apache Hadoop for analyzing various source system types as per the requirement & using Sqoop to import data into HDFS from Oracle, DB2, Progress/ AS400 databases, SAP HANA, Sales Force, FTP.
  • Understanding of Partitioning and Bucketing concepts in Hive, and performance improvement in Hive modifying Joins, groups and aggregations.
  • Good knowledge in using job scheduling and monitoring tools like Autosys, DAC, TAC, Crontab, Oozie.
  • Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
  • Ability to collaborate as a Functional Analyst & Technical Developer with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
  • Assisted with new business activities as required, including attending brainstorming sessions, Developing statistical analyses to prove capabilities and other assignments as needed.
  • Modelled and Designed Architecture, Use Case and Activity diagrams using Rational Software Architect Tool and Microsoft Visio.
  • Over 3 years of Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, Universal Data Models, FACT & Dimensions tables, Logical & Physical data modeling, ERStudio 7.1/6.1
  • 2+ years of hands on experience in customizing and configuring Workforce, Payroll and Recruitment data of HR BI Apps analytics and extended the OOTB code as per requirements from Business.
  • 2+ years of experience with CRM solutions using Siebel Call Center application.
  • Experienced working in Waterfall, Agile and Scrum development environments.
  • Gained progressive working experience in Banking, Finance, Hospitality, Healthcare and Product based industries.

Hire Now