Mike Arsov

• Involved in understanding Business Process and coordinating with Business-users to get specific user requirements • Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule • Performance Review and Coding and getting it signed off from the client • Extract data from heterogeneous sources like SQL Server 2000 and Oracle 9i • Used DataStage Designer to develop ETL jobs • • Wrote stored procedures to augment the ETL process

• Worked in a team environment for various clients to develop a Business Intelligence solution that would support better business decision making, improve business performance and create competitive advantage • Developed DataStage Extract, Trasform and Load (ETL) jobs involving legacy system integration and complex business rule transformations before loading the Data Warehouse • Converted COBOL code and copybooks into DataStage programs and unit tested • Created JCLs to run the DataStage programs

• Extracted IBM mainframe EBCIDIC character datasets • Converted COBOL and ETI code into ETL design document and transformation rules. • Created DataStage ETL jobs to load the Teradata EDW • Created custom routines for common set of transformations • Created JCLs to run the DataStage programs on the IBM mainframe • Prepare and execute test cases for unit and integration testing • Wrote numerous VB scripts to aid the development processes increasing performance and reliability

• Meet with business units to review, analyze and evaluate Crystal reports • Specify and document business requirements • Worked towards identifying redundancies in the reports to create more efficient systems process • Worked on processes to phase out old and replace with new and improved reports • Automated extraction processes to collect statistical information from the Exchange Server regarding usage and ownership of the reports

Systems Management Option