Skills
Academic Details:
Master in Management Science (MMS (MIS)) A two year Master’s Degree in Management completed in 1998-2000 from International Institute of Professional Studies, DAVV, Indore, India.
Bachelor of Science (Computer Science [Honors]) A THREE-YEAR Bachelor 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/Consultant. Production support for multiple Database servers in 24X7 support environment.
Experienced in Database Designing, Database Modelling, PL/SQL Database Programming, Query Optimization, Migration, Upgrade, 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/Linux shell scripts for automation of Database enhancements/debugging/backups.
Experienced in Leading Field Response team 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, R
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, Reflection X, 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 (Now NTT Data), 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.
Project history
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 Data warehouse. 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 provides 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.
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 Data warehouse. 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 provides 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.
Local Availability
Open to travel worldwide
