Mohd Atif Email & Phone Number

Uttar Pradesh, India

Working as a freelancer Big data and Data warehouse Consultant.

Noida, Uttar Pradesh, India

Noida Area, India

Finnone is a leading LMS (lending management system) across the globe and I am working asa Senior Technical Lead for highly customized version of Finnone for Opel Vauxhall Financeproject (OVF) in Europe and Latin America.Successfully Implemented Performance tuning project to reduce the batch timings by30% as a Technical Lead using Indexes, Hints, Explain Plan, parallel processing,CTAS, WithClause.• Successfully implemented GDPR project using Redaction at database level andencryption at form level.• To identify the problem areas and provide solution during migration of 11g to 12c inEurope and Latin America cluster.• Re-compilation of database objects and forms during migration and interacting withOracle support for resolution of identified issues.• Worked at Cardiff, UK (client location) for implementation of Leasing product fromJul 2017 to Aug 2017 as Project Lead handling end-to-end development cycle fromRequirement gathering to post deployment production support.• Worked at High Wycombe, UK (client location) for implementation of Credit Bureau(Experian/Equifax) interfaces from May 2016 to Oct 2016.• Worked at High Wycombe, UK (client location) for gathering requirements for newPlan/Promotion from April 2015 to July 2015• Visited Shanghai, China at Client location for Functional UAT Support of China relocationproject• Providing end-to-end support to business for functional testing during UAT and postproduction support.• Interacting with the business users to understand the functionality and theirrequirements.• Designed and developed custom packages, procedures, Triggers using PL/SQL.• Interacted with Business Analysts and Users in requirement gathering, built complexqueries• Using SQL and wrote stored procedures using PL/SQL.• Involved in the database design for better understanding the relations, associations anddependencies within the database.• Designed Technical design document based on the business requirements.

Pune, Maharashtra, India

Joined TCS as a fresher through Campus placement and completed the Initial learning program(ILP) training at Trivandrum.• Worked in Income tax project at Ghaziabad understanding Client requirements,designing and developing Database application.• Designing and developing Stored procedures, Tables, Views and other Database objectsin Oracle 9i (PLSQL Developer).• Worked in Nielsen Telecom project at Pune.• Successfully completed ETL Optimization Project & reduced cycle time from 35 Hours to12 hours.• Got appreciation e-mails from Clients & Managers for exemplary services• Designing and developing stored procedures, Tables, Views and other Database objectsin MS-SQL (2005 and 2008) using T-SQL• Designing Views and stored procedures in NETEZZA Database to fetch data for reportingapplication• Designing and coding web pages containing charts in ASP.NET for reporting• Migrating and optimizing Google Maps API from Version 2 to 3• Creating custom markers and routes on Google Maps.• Worked at Trivandrum for American express project.

Bachelor Of Technology (B.Tech.), Computer Engineering

Education record