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