Data Management

Curriculum Vitae

Zarin khan

Telephone : 856-***-****

Email: *********@*****.*** ;

Address : ***** ******** **** *******, ** 98052

Academic Details:

Master in Management Science(MMS (MIS)) A two year Post Graduate Management Degree completed in 1998-2000 from International Institute of Professional Studies, DAVV, Indore, India.

Bachelor of Science ( Computer Science [Honours]) A THREE-YEAR Bachelors Degree completed in 1993-1996 from Devi Ahilya Vishwa Vidhalaya, Indore, India.

Technical Experience :

Have been in IT Industry for 9 years. Worked as a Database Analyst/Designer/ Programmer/Administrator/Consulant . Handled multiple Database servers in 24X7 support environment.

Experienced in Oracle Designing, Normalization, Physical and Logical Data Modeling, DB Optimization, Migration, Upgrade, PL/SQL programming for creation of Packages, Triggers, Functions and Procedures. DB Installation and Administration.

Experienced in writing Requirement Gathering Documents (SRS) and Design Documents ( FDD, DDD) and Unit Test cases (UTP)

Experienced in writing Unix shell scripts for automation of Database enhancements/debugging/backups.

Experienced in Leading Field Response and Support activities, Lead multiple teams which directly communicated with the client/end-user regarding Application Support, Functional Enhancements, Performance Tuning and Debugging. The supervision role included Planning and Estimation of tasks, Tracking Deliverables and Resources Utilization.

Experienced in providing Technical Consultancy to different teams within the organization

Experienced in Programming, Testing, Debugging in SYBASE. Worked on applications to Extract, Transform and Load data from different Servers into a SYBASE data server. Worked closely with Informatica team to automate the whole process of ETL.

Technical Skills:

Languages : C, C++, SQL, PL/SQL, MySql, T-SQL, Python

Scripting Languages : UNIX Shell scripting, HTML, awk, PHP

Operating Systems : Windows 2000, Windows NT, Windows 2003/2007, Red hat Linux 6.0, HP Unix

RDBMS : MS-Access, Oracle 7.x,Oracle8,Oracle 8i,Oracle 9i, Oracle 10G, SYBASE

Front-end tools: Developer2000, Powerbuilder5.0

Tools: ERWin, TOAD, PL/SQL Developer, Clear Case,Visio,CVS, ReflectionX, MicroSoft Office 2000, SQL Loader, DBArtisan, Tableau

Done an online certification on Introduction to Data Science from University of Washington on Coursera. The course consisted an introduction to the concepts of Big Data, MapReduce, NoSQL, Machine Learning.

Roles and Responsibilities:

Database Analysis and Design. Preparing Software Requirement Specification (SRS), Functional Design Document (FDD), Detailed Design Document (DDD), Data Flow Diagram (DFD),Flow Chart, Unit Test Program (UTP)

Database Programming (writing Procedures, Functions, Packages and Triggers) and Testing (Unit Testing, Integration Testing and Performance testing)

Performance Tuning and Query Optimization.

Administration related tasks, creating users, granting resources, implementing security policies

System configuration for optimal performance.

Debugging and Analyzing Application program.

Analyzing performance problems & recommend actions to alleviate problems.

Field Response activities to understand and implement customer specific requirements, enhancements, bug fixing and resolving performance issues. Planning and effort estimation and Tracking Efforts.

Data Migration, Loading Data from flat files into database after performing ETL operations on the data.

Project Management Tasks like Tracking Deliverables and Resource Utilization

Professional Experience:

Worked as Senior Consultant with Keane Canada Inc, Halifax, NS from March 2012 till Aug 2012. Worked as near shore Consultant for Morgan Stanley USA. Responsibilities included working closely with the client to understand the Automation Requirements, provide Solutions and help them get Implemented.

Worked as Technical Leader with Aricent Technologies, Bangalore, formerly known as Flextronics Software System (Hughes Software System) from Jan 06 to Jan 09. Lead two of the Field Response Teams for different releases of Real Time Billing System for Comverse USA. Responsibilities included handling high priority site issues with multiple teams to help resolve them timely and efficiently.

Worked as a System Engineer with Mphasis BFL, Bangalore from Nov 2004 till Dec 2005, Worked on the client site at Tyco Electronics . Responsibilities included database troubleshooting, optimization, DB programming, writing Unix scripts to initiate and regulate data loading process, PL/SQL Programming for a Data Warehouse project.

Worked as Database Designer and Developer with DACCIT, Indore from May 2000 to August 2004. The primary responsibility included writing Packages, Functions/Procedures and Triggers for different applications. Other responsibilities included Schema Design, creating Flow charts/DFDs for different modules, writing test cases, SQL optimization.

Major projects:

1: Electronic Data Center Management

Client: Morgan Stanley

Contribution: Contributed to Automate a Manual system for Data Center Capacity Management application. Worked directly with the customer to understand the existing data and designed and implemented the entire process of Extraction, Transformation and Loading of data into the Sybase server. Contributed to Optimize and Manage Data Center Inventory Management application.

S/W Used: SYBASE ASE, Unix, DBArtisan, SVN, ERWin, MS Visio, MS-EXCEL.

Synopsis: EDCMO is a group of smaller applications for the Data Centers Data Management for Morgan Stanley. These databases provide support to different BI Applications.

2: Real Time Billing System

Client: Comverse

Contribution: Contributed throughout the project life cycle, includes Analysis& Design, Coding, Integration Testing, Performance Testing, Field Response. Worked on Recurring/Non Recurring Charges, Recharge, Reservation Modules.

Supervised multiple teams which handled Field Response Activities. It required extensive user interaction and planning and prioritization of multiple tasks .

S/W Used: Oracle8i,Oracle 10G, HP Unix, Clearcase,CWS, ERWin, MS Visio.

Synopsis: It is a pre paid billing system for Comverse which provides Billing Solutions to Wimplecom Russia, Alltel (Now Verizon) US,Reliance India and part of Airtel India etc. The RTBD project was part of IN (Intelligent Networks) group.

3. Tyco Electronics Data warehouse

Client: Tyco Electronics

Contribution: Provided 24X7 support to multiple databases . Included Support to ensure that Data-loading is done daily without issues, Providing Application Enhancements on User requests, PL/SQL programming, writing packages, Unix scripts coding, Client communication and providing daily status reports, optimization of data retrieval process.

S/W used: Oracle 9i, Toad, UNIX

Synopsis: it is a data warehouse project dealing with several OLTP servers’ loading data into Tyco Electronics Datawarehouse. The project task is to read data from flat files, load it into an intermediate database, Validate data for different business requirements and load it into the data warehouse. The project also deals with retrieving the data from DWH to be published on DSS websites.

4. Friction Material Dashboard

Client: Honeywell Technology Solution Lab Pvt. Ltd

Contribution: Involved in Logical as well as Physical Designing, Sizing and writing codes for monthly report generation which would be used by MIS. Writing packages and triggers. Optimization of the report generation.

S/W used: Oracle 9i, Toad, Visio, ERWin tool.

Synopsis: It is a DSS project which takes data from 3 OLTP Databases and generates profitability reports monthly vis product profitability, customer profitability and zone wise profitability report, also keep comments and notes added for decision support.

5. EnterPrise Finance Management System.

Client: Prestige Group of Industries.

Contribution: Involved in Database Creation, Maintenance, Tuning, Backups Scripts, Database Triggers, Stored Procedures etc.

S/W Used: Oracle8.0, VisualBasic6.0

Synopsis: It deals with the finance management of an enterprise with number of companies individually within it, apart from regular finance report it also provides the stock management of Individual companies. Comprehensive help is also provided in System.

6.Human Resource Module.

Client : STI India Limited.

Contribution : Involved in Database Design, coding in PL/SQL, DB triggers

S/W Used : Oracle8.0, VisiualBasic6.0

Synopsis : This Module was developed for STI India Limited, which is India renowned yarn manufacturing company. The system consists of all the functionality and processes of Human Resource department of an Organization. From attendance, leave maintenance, appraisal, tracking loans, PF, ESI, salary register, pay slips, and a large number of reports where the part of that system. A small training module was also developed to keep track of training provided to employees, officers and managers of the organization. This training module was added to the HR module later.

7. Workshops and Warranty System

Client: Sanghi Bros. Indore Ltd.

Contribution: Involved in creation of Database of required size and Configured DBA objects Rollback Segment, Table spaces SGA, Wrote Database Triggers, Stored Procedures, Pl/SQL Blocks. Coding done in Unix Shell Scripts for Online Backups.

S/W Used: Oracle 8.0/Developer2000/UNIX

Synopsis: This Project mainly deals in Workshop and Warranty Systems of the organization. It provides all the Jobs, Indents, Bills on-line to the Customers and Vehicle information to the Management as per their Requirements. It also provide PCR (Product Complaint Report), WCD (Warranty Claim Data), Credit notes of all the parts claim to Telco and all the Reports related to these to the organization for their Decision Making Purpose. Also provide the stock management of Individual companies. Comprehensive help is also provided in System.

8.Integrated Academy Information Systems.

Client : Indore Public School Academy. IPS Academy is concern that runs

All bachelors & Masters courses. It has Engineering. College, MBA,

Arts, Sc. and Commerce courses. It also has hotel management. Course

& School from Nursery to class 12th. Aim was to develop integrated

Solution to make the functioning of the Academy smooth & reliable.

Project was both Web- based & Client Server based.

Contribution : Involved in Database programming and DBA part.

Involved in System design and development of Integrated Academy

Information Systems

Involved in the Coding &Testing of the System.

S/W Used : Oracle 8,PoweBuilder5.0/6.0

Synopsis: ( Main Modules )

1.College Information Systems: Academy catalogue, facilities,

Hostel, Courses, Fees & Sports facilities.

2.Student Information Systems: Student admission, re - admission, hostel admission, attendance, results & mark sheets. Sports Achievements etc.

3.Stores: Requisition, issues to depts., Material receipts, Performa

Invoices, stock ledger, purchase orders, reminders, low & high

Level fixing of items.)

4.Library information System: Books, magazines & Journals

Subscription records, Issue Rules, according to membership types,

Issues, Deposits, waiting list, Fine - charging List of defaulters,

Reminders to subscribers.

Others:

Have Experience of giving Corporate Training for RDBMS for Eicher Motors Indore .

Experienced as a part time faculty for MIT/BIT students for RDBMS.

Personal Details:

Father : Mr. A.R.Khan

Permanent Address: 116,Ashoka Colony, Manik Bagh Road, Indore, India

Phone Number: 91-731-*******

Languages Known: English, Hindi, Urdu

Hobbies: Reading, Writing, Painting,Cooking

I hereby declare that all the above stated information is true and correct to the best of my knowledge and belief.

[Zarin Khan]

Date:

Place:

Contact this candidate