We provide IT Staff Augmentation Services!

Data Architect/etl Lead Resume

Reston, -vA

SUMMARY:

Result driven Software Engineer with over 10 Years of experience in Data Warehousing, Data Architecting, Data Analytics and Business Intelligence platforms. With 9 years of hands on experience on working with various ETL and BI tools.5 years of experience in leading and managing projects and end - to-end implementation of data integration solutions in a wide variety of platforms, operating systems and databases. Skilled in developing Requirement Specifications, Architectural Designs and working with data in the Distributed File systems.

TECHNICAL SKILLS:

Database: Oracle 10g, 11g, MS SQL SERVER

Database Tools: PL/SQL Developer 5.1, TOAD 9.5, SQL*Loader, ERWIN

ETL Tools: Informatica PowerCentre 10.x, 9.x, 8.x, OWB 11g R2, ODI11g, 12C, Pentaho, Abinitio

BI Tools: SAP Business Objects X1 4.0, R3, R2, Crystal Reports 8, OBIEE, Tableau, Performance Analytics

Cloud: AWS

Scripting Languages: SQL / PLSQL, UNIX, Python, R, Java Script, CSS

Scheduling: UNIX Cronjobs, Autosys

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Oozie, Flume

Methodologies: Waterfall, Agile

Issue Tracking: Jira, Confluence

PROFESSIONAL EXPERIENCE:

Confidential, Reston -VA

Data Architect/ETL Lead

  • Provide ETL, Database and BI solutions for IT Asset Management and Infrastructure support platform
  • Suggest architectural improvements, and formulate methodologies to optimize Database Objects
  • Designed road maps in the data migration from Confidential.
  • Interacted with core and cross-functional teams to gather data requirements and provide fixes
  • Created Jira for Issue tracking and Implement projects in and Agile environment
  • Provide database solutions and designed data extraction mappings for the Integration of Change, Incident, Problem management and CMDB modules from Confidential.
  • Designed ETL maps in Informatica PowerCentre to pull data from Confidential to operations data mart
  • Automated manual data loading processes by effective scripting, ETL and scheduling mechanisms through Autosys and Increased the resource efficiency by 90 %
  • Implemented multiple data visualization dashboards for overall ITSM operations using Performance Analytics and Tableau for management reporting
  • Created datasets by writing Views and Materialized Views using Advanced Analytical functions in SQL for data analysis, profiling and validations
  • Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming

Confidential, NY

Sr ETL Developer

  • Implemented data extraction methodologies for the Medicaid Data Warehouse
  • Designed mapping documents and data quality rules for the MDW
  • Implemented robust and scalable ETL codes in ODI with minimal utilization of system resources
  • Configured Data Servers for Oracle and File technologies and setup contexts and agents
  • Designed the ETL maps by making use of appropriate Knowledge Modules and Operators
  • Implemented Journalized Knowledge modules in order to achieve change data capture
  • Integrated ETL maps by creating ODI packages to perform bulk data load
  • Queried huge data sets and designed maps in OWB to generate data delivery extracts
  • Implemented Analytical Functions and used Parallel Hints in SQL queries to enhance the performance
  • Debug, maintain and enhance the ETL processes between several data sources

Confidential, Herndon -VA

Sr ETL Developer

  • Implemented star schema data model to create Multifamily Data Mart for reporting needs
  • Designed mapping documents and created data extraction rules
  • Extracted data by implementing data extraction rules using Informatica transformations
  • Implemented ETL mappings In Informatica to load SCD of Type 2 dimension
  • Created Profiles and Data Quality Rules using Informatica DQ Analyst application
  • Queried and created datasets by creating Materialized Views
  • Created use cases and data visualization dashboards using Tableau as part of phase 0 prototyping
  • Designed Interactive dashboards in Tableau making use of analytical capabilities
  • Resolved and provided solutions to the database issues and ETL defects

Confidential, Chicago-Il

Sr ETL Developer

  • Integrated data from multiple sources in to data warehouse from ETL methodologies
  • Designed various ETL mappings and reusable pluggable mappings in OWB
  • Configured Metadata Navigator for tracing the Repository activities
  • Creation of Process flows, scheduled & Monitored all the Batch jobs and ensured successful execution
  • Implemented ODI Interfaces for Student and Workday data warehouse
  • Worked on the end to end implementation of mappings,scripts and db objects across environmnets

Confidential, Mount Laurel- NJ

ETL Lead

  • Derived Mapping document by using detailed design document pertaining to CURAM data model
  • Modeled and enhanced the existing CURAM data mart by using ERWIN for reporting needs
  • Implemented Incremental loading method over Truncate load by reducing the system utilization
  • Designed several OWB maps in to ODI and took part in the end to end implementation
  • Created robust ETL maps and transformed data as part of data conversion project
  • Implemented SCD type 2 dimension maps to maintain the history of the records in specific tables
  • Designed process flows in order to execute the data in bulk and based on various events
  • Created OMB scripts to deploy the OWB maps across environments
  • Implemented effective event log and error handling mechanisms
  • Implemented cronjobs in Unix and scheduled ETL jobs on timely basis

Confidential

IT Consultant

  • Worked as a lead for data warehouse team managed designed and implemented the ETL solutions as per the business needs
  • Designed Interfaces, Maps in ODI and OWB to handle SMS,TAP and GPRS data for M2M platform
  • Monitored daily jobs for the successful run and provide fixes upon job failure
  • Designed process flows to Integrate several maps for bulk data loading operation
  • Designed complex reports and KPI metrics in Business Objects for management reporting
  • Handled production issues and provided data mapping solutions

Confidential

ETL Developer

  • Closely work with BA to understand the user needs to represent the data
  • Designed ETL maps using operators and applied transformations techniques to load the data to ODS
  • Extracted the data from T24 core banking system and legacy systems using Informatica and OWB
  • Data Analysis for the banking operations by creating complex queries and PL/SQL procedures
  • Designed Universes and reports in SAP Business Objects for management reporting
  • Worked on end to end development as well as provided production support for data warehouse ops

Confidential

Software Engineer

  • Effectively Communicate with end users to understand their needs for design and development
  • Designed various maps using Informatica PowerCentre to load the data to Operational Data Store
  • Extensively used Key operators to Transform and Load the Data to Target Schema
  • Designed Universe In SAP Business Objects as well as developed complex reports and KPIs
  • Involved in all Analysis, Development, Testing, and Maintenance, as well as resolved problems during implementation

Confidential

Associate Software Engineer

  • Interacted with Business Analyst to understand the needs and requirements
  • Perform Data Analysis of Source Systems and provide data exception reports
  • Involved in the creation of Maps using Informatica PowerCentre
  • Designed Monthly, Weekly & Daily Report as per operational needs
  • Extensively used Free Hand SQL as an External data provider to design reports
  • Designed and managed universe in Business Objects

Hire Now