Project: EMD 1.1 & 2.0 (Dell Account)
EMD is the tool to process & analyze marketing data & financial data which helps Dell to generate business. Dell gets marketing Data & communication media information from different sources & financial data from business, this system process such data and provide static’s for marketing via different communication media. Dell data capture bureau gets information to cease media, and this system process to suppress such data. System handles more then 7 Tera Bytes size of data for one instance.
Responsibilities:
• Requirement gathering & impact assessment.
• Understanding of their existing processes, designing new & existing for new system, & data modeling.
• Defining code migration strategies.
• Performance & Tuning of database process to optimize the result.
• Using SQL Server Integration Services (SSIS) implemented ETL process.
• Used ETL Process (using SSIS) to for “Data Extracting”, “Data Cleansing”, “Data Mapping”, “Fuzzy Logic” (vis-à-vis new and exiting data), “Data Loading”, & “Business Rules Application”.
• Development of processes.
• Used QA Process for documentations & quality assurance.

Environment: Windows XP, MS SQL Server 2000 & 2005, SSIS, Visio 2003 Architect Version, VS 2005 & .Net Frame Work.

Ness Technologies is a CMM level V company, having operations in 14 different countries.

Functioning as a Project Leader – Database DBA & Report Designer, the major responsibilities like Requirement Analysis, database design & Optimization of database coding, Defining standards, part of the Architecture Team, Communication with the clients on various issues, involved in the real-time coding and unit testing of the applications.

Lead & Database Architect Ness Technologies December 2006 – March 2007
Project: Oracle10 & Oracle Discoverer R&D
Currently, am doing R&D for Oracle general aspects and on Oracle 10g features, and also presenting to the Ness Development Team, Database Team & Management for development aspect on Oracle database.

As a Mentor for team responsible for the following activities
• R & D on Oracle general aspects.
• Providing performance and designing tips to Database team.
• Standardizing database standards and process for future projects.
• Analyzing previous database related common issues and resolutions.
• Explored the management side of Oracle 10g database features.

Environment: Windows 2000, Oracle 10g.

Project: Child Data Digital Hub (CDDH)
Plan – International is the world level organization which helps or provided poor children’s basic necessity and education. We are developing their child’s and sponsor’s information system.
Responsibilities:
• Requirement gathering and understanding of their existing systems.
• Definition of Standards and process on database side
• Data modeling for new system.
• Defining data migration strategies and process.
• Did POC for “Data replication using service broker & Merge Replication”, Ad-hoc reporting tool report builder & data encryption.
• Using SQL Server Integration Services (SSIS) implemented Migration strategy.
• Implemented MS Reporting Services 2005 for Reports and Data models for Ad-hoc Reporting.
• Used ETL Process (using SSIS) to for “Data Extracting”, “Data Cleansing”, “Data Mapping” & “Data Loading”.
• Used QA Process for documentations & quality assurance.
Environment: Windows 2003 & XP, MS SQL Server 2005, SSIS, MS Reporting Services, Visio 2003 Architect Version.

Project: Data Audit of Shares & Stock Broking
Project scope includes modelling of database, Analysis of data from their existing 3 systems (SIEBEL, CDU, and HUB) and generating audit, matrix. These audited results will be used to implement new system and enhancement in existing system.
Responsibilities:
• Requirement gathering and Analysis on 3 systems
• Data modelling for Audit database.
• Process documents including weekly status reports.
• Doing coding for analysis purposes.
• Used ETL Process to for “Data Extracting”, “Data Cleansing”, “Data Mapping” & “Data Loading”.
• Used QA Process for documentations & quality assurance.
Environment: Windows 2000, MS SQL Server 2000, and Access2000.

Project: Report Designing Based on OLAP & MDX
Project scope includes designing of reports using OLAP Cubes & MDX queries. It has three phases.
Responsibilities:
• Pre-sales support & Visited Paris for technical discussion.
• Understanding of technology OLAP Cubes and MDX.
• Completion of evaluation phase includes Designing of Reports using MDX & OLAP Cubes.
• Used SSIS for Data Migration processes.
Environment: Windows 2003 Advance Server, MS SQL Server 2005, MS Reporting Service 2005, SQL Analysis Services, OLAP Cubes & MDX.

Project: Space Management Requirement and Reporting Tool (SMaRRT)
SMaRRT is a Space Management tool developed for CFC California. It handles the inventory of the office and the cube spaces of the CFC units across US. The application mainly revolves around demand side represented by the business units and the supply side represented by the Corporate Real Estate. Another key aspect of the application is the forecasting of the Demands and supplies based on the trends.
Responsibilities:
• Participation in requirement gathering, understanding of system.
• Participation in overall system designing.
• Preparation of complete data flow.
• Did Complete Data Modelling.
• Designing of Reporting process and Business Reports.
• Database management, backend design, Optimization tuning.
• Interaction with Client & reporting to management.
• Used ETL Process to for “Data Extracting”, “Data Cleansing”, “Data Mapping” & “Data Loading”. Required migration of Data from Excel files, Access DB to SQL Server.
• Used QA Process for documentations & quality assurance.
Environment: Windows 2000 Advance Server, MS SQL Server 2000, Asp.Net, MS Visio & MS Reporting Service 2000.

Project: Jewel Applications - DW Design, Migration, Maintenance & Performance Tuning
The project scope includes Data ware house design for reports, migration of the existing report of Web Focus to MS Reporting services, Maintenance & Performance optimization, Scheduling & Capacity planning. Mourant is using these reports for billing & other information within the organization & to client. All the reports were taking lot of time.
Responsibilities:
• Onsite (Jersey – UK) for the requirement gathering, understanding of system, design for the data ware house system for reports
• Project management, documentation, tracking & scheduling.
• Preparing & analyzing analysis documents as per business model.
• Reviewing code, Impact, Unit test cases and integrated test cases.
• Database management, backend design, Optimization tuning.
• Interaction with Client & reporting to management.
• Used ETL Process to for “Data Extracting”, “Data Cleansing”, “Data Mapping” & “Data Loading”.
• Used QA Process for documentations & quality assurance.
Environment: Windows 2000 Advance Server, MS SQL Server 2000, Visual Studio .NET 2003, MS Reporting Services, Crystal Reports 8.0.

Project: Report Migration & Performance Optimization
The project scope includes migration of the existing report of crystal to MS Reporting services, Performance optimization, Scheduling & Capacity planning. Pitt Ohio Express is using these reports for there daily business needs. All the reports were taking lot of time. And to maintain these reports on crystal was costly, as change in policy for the Crystal Reports tool. All the reports are deployed using MS reporting services tools.
Responsibilities:
• Project management, documentation, tracking & scheduling.
• Preparing & analyzing analysis documents as per business model.
• Reviewing code, Impact, Unit test cases and integrated test cases.
• Database management, backend design, Optimization tuning.
• Interaction with Client, onsite team.
• Used ETL Process to for “Data Extracting”, “Data Cleansing”, “Data Mapping” & “Data Loading”.
• Used QA Process for documentations & quality assurance.
Environment: Windows 2000 Advance Server, MS SQL Server 2000, Visual Studio .NET 2003, MS Reporting Services, Crystal Reports 8.0.

Project: Data Migration from Various source systems
This project is used by Countrywide to maintain the loan related history that includes collateral maintenance, interest calculation etc. Currently this project is on three different systems i.e. Sun Solaris, IBM I-SERIES and Oracle on Windows. Work involved is migration of data from all these systems using PL/SQL tools and AS-400 tools. The project is based on Oracle 8i (PL/SQL). The project basically involves BARCLAYS BANK OF UK for which migration the data. The project in its initial stage will be data migration from the two source databases provided by Countrywide will be on Windows Oracle platform, but in the later stages the database will be migrated from Solaris Server to AS-400 IBM Mainframe.
Responsibilities:
• Project management, documentation, tracking & scheduling.
• Preparing mapping documents as per business model.
• Reviewing code, Impact, Unit test cases and integrated test cases.
• Database management, backend design, and coding.
• Interaction with onsite team.
• Used ETL Process to for “Data Extracting”, “Data Cleansing”, “Data Mapping” & “Data Loading”.
• Used QA Process for documentations & quality assurance.
Environment: Windows NT, Oracle8.0, TOAD.

Project: Margin Stock Reporting
This is developed for the sister concern of broking houses, which trades with multiple brokers. This application provides the risk of organization across all the open position in the security market.
Responsibilities:
• Project management, documentation, tracking, scheduling, and estimation.
• Preparing design documents as per business model.
• Reviewing code, Impact analysis, Unit test cases and integrated test cases.
• Database management, backend design, and coding.
• Technical supports to the clients.
Environment: Windows NT, VB 6.0, Crystal Report 8.0, MS SQL Server 7.0/ 2000