Post Job Free

Resume

Sign in

Database developer

Location:
Kolkata, West Bengal, India
Posted:
July 07, 2021

Contact this candidate

Resume:

ASFIN NAAZ

Application Developer

[ asfinnaaz@yahoo.com Ó 950-***-**** Pune, India

linkedin.com/in/asfin-naaz-siddiqui-17103494a

SUMMARY

Application developer with 6.2 years of experi-

ence in a multinational corporate environment.

Highly organized and efficient developer with

demonstrated success in designing and imple-

menting technology solutions that empowers

and improves the business from the functional

perspective of the systems. Seeking to bring

fast, intelligent solutions to the position pro-

vided at your company. Possessing diversified

technical background and willingness to keep

learning.

Offering experience in Oracle PL/SQL,Exasol

db, Unix and ETL Informatica expertise in anal-

ysis, design and implementation.

Strong knowledge of SDLC and all phases of

Application development.

Experience in developing Packages, Stored

Procedures, Functions, Triggers, Views, Cur-

sors, Packages, Joins, Sub-Queries, Dynamic

queries etc.

Created multi-threaded packages to improve

performance and have done various perfor-

mance testing. Created packages for reporting

purposes.

Created Schema and Granted resources, privi-

leges and roles to users.

Created/Updated/Used Unix Shell Scripts,

Cron jobs to automate process and run pack-

ages. Supported all the UNIX requests for vari-

ous applications.

Comfortable knowledge in scheduling tools

like CAWA, Autosys and JIL Scripts and

Scheduling Dependencies for Batch Jobs.

Familiar with Functionalities of Power Cen-

ter Tools of Repository Manager, Workflow

Manager and WorkflowMonitor,Mapping De-

signer.

Created mappings using SQL, Aggregator,

Expression, Joiner, Filter and Various Other

Transformations.

Familiar with Supply chain and Retail domain

knowledge.

MOST PROUD OF

3

Courage I have

To take up any ad-hoc responsibility

and complete it in time like - to imple-

ment Oracle VPD

z

Persistence & Loyalty

I showed despite the hard moments

and my willingness to stay with my

position

EXPERIENCE

Application Developer

Citicorp Services India Private Limited

Apr 2020 – Ongoing Pune, India

Zeus is an application which is used as QA tool for internal Citi Anti Money Laundering investigations. Cases are generated from upstream for suspicious transactions which are investigated further and all such closed cases come into Zeus for further validation.

Developed PLSQL Packages, Procedures for new developments and enhance- ments and report generation for multiple regions (NAM,LATAM,EMEA,APAC).

Implemented Oracle VPD for NAM region.

Implemented General Data Protection Regulation-GDPR (data deletion) in various regions.

Single handed worked from Requirement gathering to PROD movement of the code.

Building and maintaining technical documentations related to Database.

Developed shell scripts for connecting to database and running packages. Application Developer

Aera Software Technology

May 2019 – Mar 2020 Pune, India

At AERA, we deliver technology that enables the Self driving Enterprise – cognitive operating system that connects you with your business and au- tonomously orchestrates your operations. Proficiency in designing cloud se- curity compliance.

As a part of project, we collect, index and harmonize billions of transactions from complex enterprise systems and external data sources. While AERA con- tinually extracts input data for real-time analytic, it does so with minimal im- pact to the underlying systems. Data are encrypted and transferred securely to the cloud then use that data for predictive analytic and perform decision making.

Worked on in-house ETL, Data visualization tool and reporting tool.

Worked on Data modelling. Did data modelling for many projects using Star schema.

System Analyst

Gap Inc.

May 2018 – May 2019 Hyderabad, India

Gap is a major retailer of apparel, accessories and personal care product for men, women and children all over the world.

Worked on upgrading version of RMS (Retail Merchandising System)-v10 RMS on-premise application to v16 RMS (SaaS Model) on Cloud.

Developed various queries, procedures, functions, packages, indexes, views, triggers, cursors, dynamic queries, reports for job logic.

Understood how business operations are performed from existing codes and data models. Worked closely with BA team to establish problem specifica- tions and system designs.

Developed Unix Scripts for archiving of old folders, running packages, multi- threading packages and doing FTP etc.

Worked closely with product team on defects and enhancements and close them within the stipulated SLA.

STRENGTHS

Hard-working Persuasive

Motivator & Leader Decision making

Strategic thinking

Business & IT Development

Domain knowledge

Vendor Management

IT Operation Support

Quality Analysis SystemMigrations

Project management

Requirement Analysis

EDUCATION

B.E. in Electronics and Telecommuni-

cation

Pune University

June 2010 – June 2014

System Engineer

Tata Consultancy Services

Dec 2014 – Apr 2018 Hyderabad, India

Worked for two big clients – Bank of America and J P Morgan and Chase

J P Morgan project was an enterprise library application for all the legal bod- ies of J P Morgan. It stores all the legal laws and rules of that particular geo- graphical area which the bank has to follow. The law is received from various sources and is broken into smaller laws and are stored in elastic storage for faster retrieval of data and to prevent the overhead.

Bank of America project was a data warehouse for corporate workplace do- main in Bank of America. Extracting all the bank related information across various sub domains like vendor projects, work location, account details, em- ployee details, Demographic information and reaching out to the customers and vendors maintaining authenticated and centralized data. Data is loaded and pulled to carter the line of business needs on daily operational activities to facilitate in decision making process.

Developed various queries, procedures, functions, packages, indexes, views, triggers, cursors for job logics.

Worked on Informatica PowerCenter tool to build workflows, deploy them across the environments and scheduling the data load jobs in Autosys Sched- uler.

Performed unit testing, Integration testing and performance testing based on the need and scale of the development efforts.

Developed Unix Scripts for archiving of old folders, job scheduling and job running using FTP.

Modified existing code to correct errors, adapt to new hardware and improve performance by using performance tuning techniques.

Worked closely with clients to establish problem specifications and system designs.

SKILLS

Programming languages

PL/SQL, SQL, Shell Script

Database

Oracle, Exasol

Operating Systems

Unix, Windows

Schedulers

CaWA, Autosys (JIL Scripts), Cron job

Tools

Toad, Putty, SQL Developer, WinSCP, Informatica Powercenter, In-house ETL and Data visualisation tools, Jira, Confluence LANGUAGES

English

Hindi

Urdu



Contact this candidate