We provide IT Staff Augmentation Services!

Data Consultant Resume

Chicago, IL

TECHNICAL SKILLS

  • Oracle 11g & SQL Server
  • MongoDB
  • Unix Shell Scripts
  • Kafka
  • DataStage & SSIS
  • Control M & Airflow
  • Tableau
  • Spark
  • Rest & SOAP API
  • Python & Pandas
  • Salesforce SOQL
  • ERwin

PROFESSIONAL EXPERIENCE

Data Consultant

Confidential, Chicago IL

Responsibilities:

  • Lead Developer of a Data Warehousing team working in an agile environment, performing Task Planning, Hands - on Development and Code Reviews.
  • Instrumental in performing Data Profiling and migrating Oracle RDBMS data to NoSQL MongoDB
  • Responsible for Salesforce Integration with MDM data for Wealth & Asset Management WorkStation.
  • Built ETL Data Pipelines using Spark framework with Hierarchical Models on Distributed File System.
  • Implemented Lambda Architecture by ingesting messages from Kafka Cluster by Spark Streaming and using Spark SQL on MongoDB.
  • Scheduled ETL Data Pipelines using Control-M and Airflow.
  • Designed and developed generic ETL flows hosted on both SMP & MPP architecture exposed them via REST API, MQs to external systems by parsing JSON and XML messages.
  • Performed Data Analysis and Wrangling using Python on MongoDB and exposed them to BI tools.
  • Efficiently utilized Aggregation Framework, Sharding capabilities for querying on MongoDB
  • Visualized the data by Pareto charts, Waterfall charts, Trend Lines, Geo Maps Tableau dashboards by incorporating Data Blending from multiple Databases in Tableau.
  • Published interactive reports and dashboards in Tableau using Groups, Bins, Sets, Parameters and Filters.
  • Lead the Performance Tuning initiative in ETL DataStage, SQL, and, Tableau.

ETL Lead

Confidential, NY

Responsibilities:

  • Lead the team of 4 for migration of ETL from/to SSIS and DataStage code.
  • Reviewed and updated documents such as Technical Specification, Mapping from different source systems, Code Review, Test Cases and, Deployment documents for ETL process.
  • Worked with Salesforce API to extract and load into the SalesForce Cloud using SOQL statements.
  • Designed UNIX Shell scripts for Data Validation and running ETL data pipelines via Control-M schedule.
  • Developed Generic ETL code with Dynamic PL/SQL, Cursors, Stored Procedures, Packages, Triggers and Functions for Error Handling, Audit balancing and Reporting on Oracle Operational Data Store.
  • Created SSIS packages to read from files, DB2. Massaged the data and loaded the MS SQL Server, DB2 components.

ETL Developer

Confidential, NJ

Responsibilities:

  • Worked on 7.5.X ETL DataStage environment in creating Star and Snowflake Schemas.
  • Imported and exported repositories across various projects using DataStage Manager.
  • Tuned DataStage transformations & cleansed data to enhance their performance.
  • Designed job sequences to automate the process and document all the job dependencies, predecessor jobs, and frequencies to help the production.

Associate Oracle DB Engineer

Confidential, NY

Responsibilities:

  • Documented, implemented and maintainedData modelsusing ERwin.
  • Designed Logical and PhysicalDB for business transaction functionality.
  • MonitoredDB performance and modified Queries, Packages, and, Stored Procedures as required.

Hire Now