Harun Raseed Basheer

Contact: +91-917******* E-mail: adc53m@r.postjobfree.com

Seeking an BI/ETL Developer Position in an organization where I can apply my skills and experience, to contribute to the organization’s growth and get conducive environment to learn and grow.

Overall 3.5 years of Total Experience in the IT Industry.

Having around 3.5 years of IT experience in Development, Maintenance and Support of Business Applications in Data Warehousing tool like Abinitio and SSIS.

Being a part of DevOps team, will be working with scrum team closely for new product features and updates before deploying it in Lower environment.

Expertise in SQL and developing complex code units.

Support all day to day activities related to database like data consolidation, data migration scripting

Strong Experience in Abinitio Co-Operating System, EME, application tuning, and debugging strategies.

Analysed and identified potential area of improvements in the project and created alerting systems using automation tools such as Ansible.

Experience in integration of various data sources from Mainframe and Databases.

Ability to write complex sql queries for reporting purpose.

Have completed ITIL Level 1 and Level 2 Internal certification and having good knowledge in Incident, problem, and change management.

Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently. Developed effective working relationships with client teams to understand support requirements.

Highest Qualification: Graduated (B.E) from Jerusalem College of Engineering, Chennai in the department of Electrical and Electronics Engineering with an aggregate of 80.4% during 2012-16.

Higher Secondary: Completed my HSC education from Balaji Matriculation Higher Secondary School, Chennai securing a percentage of 82% during 2011-2012.

Secondary Education: Completed my Tenth (S.S.L.C) from Balaji Matriculation Higher Secondary School, Chennai securing a percentage of 78.6% during 2009-10.

ETL Tool : SSIS, Abinitio

Reporting Tool : SSRS, Tableau, Power BI

OS : Windows, Linux

Databases : MS SQL, DB2

Scripting : Unix Shell Scripting, Python Scripting

Scheduling Tool : Control-M, Windows Task Scheduler

Ticketing Tool : Service Now

Other Tools : Ansible (Automation Tool)

Received ‘spot recognition’ from Manager for effective and timely resolution of various critical issues.

Done certification on Basic level ITIL.

Deployed Ansible automation code using python front-end screen for automating the validations done during Server maintenance.

Was captain of the Red House during schooling and was representative of the class for 2 years.

Secured cash award and certificates for presenting a Technical paper and project models in symposium.

Won in Debate Competition during College. Was winner in Kho-Kho competition during schooling for two successive years 2009 & 2010.

Best outgoing student of the batch 2012-2016 from Jerusalem College of engineering.

Active Member of AEEE during college.

oProject: Loan Portfolio Management.

oCompany Name: Nationstar Mortgage (Mr.Cooper)

oProject Duration: 02/2019-To till date

oTeam Size: 4

oEnvironment Used: SSIS,SQL,Unix, Power BI

oProject Description: The LPM project is developed to capture the data from the source systems (SQL Server) and perform extractions, transformations and loading of the transactional and payment data and creating reports for the investors.

oResponsibilities:

Developing SSIS packages for the investors to get the payment file timely.

Enhancing the existing graphs in order to meet the business requirement.

Involved in scheduling and monitoring the jobs in control-M.

Automated the SSIS failure log analysis.

Developed adhoc graphs to serve the instant requests from the business.

Creating Reports using Power BI, Tableau and SSRS.

oProject: EGMIS- Enhanced Global Management Information System.

oCompany Name : Syntel International Pvt Ltd.

oClient: American Express

oProject Duration: 12/2017-To – 02/2019

oTeam Size: 5

oEnvironment Used: Abinitio 3.15,SSIS, DB2, Unix

oProject Description: The main aim of the project is to capture the data from the mainframe systems and perform extractions, transformations and loading of the transactional data received from the EGMIS file into the database and thereafter generating reports, which is done by the reporting team. EGMIS is a utility created for all Markets to load their data into GDR database to help in AMEX Enhanced reporting products.

oResponsibilities:

Processing and Loading transaction/profile data flown from all regions from multiple teams into the OLAP & OLTP database.

Identifying recurring issues or repetitive processing activities and reducing the manual effort by implementing automation scripts.

Scheduling Major Incident Management (MIM) calls with clients and key stakeholders to discuss about ongoing critical impacts in applications.

Monitoring the Server and CPU performance in both application and database server to ensure all applications are BAU.

Migrating script objects from one server to another by taking backups of the earlier version.

Performing capacity analysis in database and restricting more applications connecting to the Database server leading to DB connection issues. Will make sure DB connection count is below threshold limit.

Closely working with multi-level database teams to ensure the shared file system across application server and database servers are up and running to ensure all online users access the reports available in the shared systems.

Replicating customer data from source Database server to destination server by ensuring no data loss impacting online users transactions reports.

Closely working with agile team about the new product features before implementing in lower environment.

Using UNIX Utilities for data processing.

Involvement with development teams for future changes in applications.

oProject: Membership Rewards Program (MR Program)

oCompany Name : Syntel International Pvt Ltd.

oClient: American Express

oProject Duration: 12/2016-12/2017

oTeam Size: 6

oEnvironment Used: Abinitio 3.15, SSIS, DB2, Unix

oProject Description: The Corporate MR program will provide Membership rewards to Corporate Card clients to satisfy the demand for a company-level rewards program. While most rewards programs drive value at the Card Member level, this program is for the rewards, which concentrate at organizational level. This rewards program will allow a client to selectively enroll eligible cards and pool earned points at the company level. The file is pulled from the mainframe systems and once the file received, validation process will be triggered through control-m, which includes file level and record level check and also will check field level and will do the balancing. Delta processing is when an older table data and a new table data are compared to identify changes that have occurred. Only the data that has changed is updated in the file which acts as load file to load into the database.

oResponsibilities:

Developed graphs using Graphical Development Environment (GDE) with various Ab Initio components such as Join, Rollup, Lookup, Partition by Key, Round Robin, Gather, Merge, Dedup sort, Scan etc.

Developed Ab Initio XFR’s to derive new fields and solve various business requirements.

Developed adhoc graphs to serve the instant requests from the business.

Worked with project team in optimizing the graph, using phases/checkpoints to avoid deadlocks to improve the efficiency.

Involved in writing wrapper scripts using UNIX to run the graphs.

Wide usage of Lookup Files while getting data from multiple sources when size of the data is limited.

Date of Birth: 07th July, 1995

Hobbies: Playing Online Games and drawing.

Languages Known: English, Tamil

Strengths:

Hardworking

Determined and Dedicated

Possessing Leadership qualities

Ability to interact with people

Having quick grasping tendency and self-learner.

Family Background:

Father : Basheer M (Businessman)

Mother: Kamila B (Homemaker)

Sister : Aafrin Banu (B.sc)

I hereby declare that the information that I have furnished is authentic, and true to the best of my knowledge.

Job Objective:

Professional Summary:

Education:

Technical Skills

Certifications and Laurels

Extra-Curricular Activities

Work-Experience

Personal Details

Contact this candidate