Responsible for design and development of the website using HTML, CSS, LESS, and Adobe Flash. Designing and editing of WordPress content and themes.
Data Warehouse Developer
Independence Blue Cross
Implemented the file transfer process for the migration of the servers and the data from the mainframe to the server.
Requirements, and coding the data warehouse and ETL processes. I also involved in the development of the IBM DB2 and IMS DB tables.
Worked on mainframe and EDW projects for the manual and automated testing of the data transformation and loading process using SAS/shell scripts.
Designed and developed SAS programs for manual and automated testing of data validation, file manipulation, and data extraction, integration, and loading into SAS and SQL.
Designed and developed complex Informatica mappings using various transformations like source Qualifier, Expression, Filter, Router, Lookup, Aggregator, Sequence Generator, Sorter, XML, and Union.
Developed SAS programs to extract data from mainframe file to load into the EDW. The manual process was used to create the SFTP connection.