Experience

• Over 9 years of experience in Database Development with thorough knowledge of implementing various RDBMS Concepts in several medium and large Scale database applications / Back ends in SQL Server 2005/ 2000/ 7.0 Extensive knowledge of Relational Database Management Systems.
• Full Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation.
• Worked on all phases of data warehouse developmentlifecycle, from gathering requirements to testing, implementation, and support.
• Extensive experience working with ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Solid Experience in RDBMS Database Design, Installation, Configuration, Performance Tuning, Optimization, Backup-Recovery and Maintenance activities
• Thorough knowledge of XML and working with XML in SQL Server 2005.
• Extensive Experience working with SQL Server Architecture, Physical & Logical Database Design . Excellent technical and analytical skills in designing of ER modeling for OLTP and dimension modeling for OLAP.
• Hands on experience in designing applications using Visio, UML and Visual Source Safe and Crystal Reports.

Sql server Integration Services (SSIS/ETL)

• Experience in using SSIS (SQL Server Integration Services) for Data Extraction, Transformation and Loading (ETL) solutions for data warehousing. Well versed with SSIS tools like Import and Export Wizard, PackageInstallation, SSIS Package Designer
• Expert in building various DTS Packages with ActiveX scripting for transferred data modifications. Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experience in data migration (using tools like DTS, BULK_INSERT, BCP and Replication) between different homogeneous/heterogeneous systems and SQL Server.

Sql server Analysis Services (SSAS/OLAP)

• Extensive Experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts using Sql server Analysis Services (SSAS).
• Experienced in Building Cubes, Dimensions, measures and fact tables with different Architectures and Data Sources for Business Intelligence.
• Experience in writing MDX Queries, Data Mining Extension language (DMX) used for querying data mining structures and XML for Analysis (XMLA) which can be used to perform administrative tasks in SSAS
• Thorough Knowledge of Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP), and Hybrid OLAP (HOLAP).

Sql server Reporting Services (SSRS)

• Extensive experience in basic and advanced report creation with thorough knowledge of report serving architecture. Experience in creating various types of reports(table, chart and matrix report, web reporting by customizing URL Access etc) using SQL serve Reporting Services(SSRS)
• Extensive experience of creating the Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab etc) using SQl server reporting services 2005
• Designing User interface Units in Forms, Reports, Graphics. Experience in configuring report Printing Options(HTML Printing, Printing from PDF Document, Client- Side Printing)
• Experience in creating reports with complex formulas and to query the database for Business Intelligence.
• Experience in report generation using SQL Server Reporting Services (SSRS) and Crystal Reports as per the client requirement and for the periodic analysis.

Database Development and maintenance(DBA):

• Excellent knowledge in developing user authorizations, Database creation, Tables, indexes, indexed views and clusters creation.
• Extensive knowledge in Tuning SQL queries improving the performance of the Database.
• Created Scheduled Tasks for regular Database Backup and Maintenance Activities. Experience in disaster recovery with Backup and Restore Strategies and scheduling those backups. Good SQL Server administration skills including user authorizations, Database creation, Tables, indexes and clusters creation.
• Experience in monitoring SQL Server Performance in SQL Server 2000 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard and Windows Performance Monitor. Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS Packages.

SQL and .Net Programming:

• Excellent knowledge in developing complex store procedures, efficient triggers, functions, and cursors.
• Hands on experience with scripting in T-SQL in constructing tables, indexes, user profiles, relational database models, data dictionaries and data integrity, optimized indexes and statistics in relation to reporting data model.
• Excellent in developing complex Stored Procedures, Triggers, Functions, Cursors, Views, Indexes, Indexed views using T-SQL
• Thorough knowledge and extensive experience in using .NET Framework Common Language Runtime (CLR) assemblies to create SQL Server objects, such as stored procedures and triggers.
• Extensive experience in working with .NET and SQL CLR programming. Created stored procedures, functions, triggers and UDTs (User Define Data Types) in SQL CLR.
• Worked extensively on ADO.NET to access data from SQL Server. Developed the data access layer in C# using ADO.NET disconnected architecture as well as connected architecture.

Personal Skills

• A team player with excellent interpersonal, analytical, numerical and communication ,presentation skills with strong aptitude towards learning new technologies
• Ability to fit into any turbulent challenging environment.
• Committed to execute and deliver projects deliverables on time and for Customer Satisfaction.

Technical Summary:

Languages

C, C++, C#, JAVA, T-SQL,PL/SQL,Java Script,VB Script,Xml,Visual basic, ASP.NET , VB.NET, ADO.NET, Web Services

DATABASE/RDBMS

SQL Server 2008/2005/2000/7.0/6.5, Oracle 8.0/9ig,DB2,MS Access

Database Technologies/Tools

SQL Management Studio, SQL Business Intelligence Studio
SQL Enterprise Manager, SQL Analyzer,SQL Profiler

ETL

SQL Server Integration Services, SQL Server DTS, DataStage, Data Transformation Services (DTSX Package)

OLAP/Reporting:

SQL Server Analysis Services, SQL Server Reporting Services

Data Modeling Tool

MS Visio, ERWIN,UML

Business Objects

Crystal Report 8.5/9,Universe,Data Integrator Designer

Operating Systems

Windows XP/Server 2003/2000/NT4/98/95 ,Linux

Utilities

BCP, OSQL, SQLCMD, DTS Import/Export, FTP

Education

• Master in Computer Science
• Bachelors of Computer Science

Confidential, Secaucus, NJ May'09-Till Now
Role.Sr SQL Server Developer

Confidential, Group is a global leader in medical communications, serving healthcare professionals and the pharmaceuticals and biotech industries. The TouchPoint Project would consist of event management, speaker administration, contract management, speaker interface, expense and payments management, alerts, template management, evaluation management and reporting functionality. The application will be integrated with external application for check processing and billing. The application enables pharmaceutical companies, vendors and speakers to collaborate to setup, mange and execute an event effectively and efficiently. Typical users of the system would include administrators, client representatives, client brand personnel, client coordinators, vendor coordinators and speakers. The application will be web enabled and the architecture will accommodate multiple clients in a single instance, that is, it will enable the application to be deployed in an application service provider environment.
Responsibilities

• Involved in Data Integration byidentifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server 2005 Integration services (SSIS).
• Created DTSX package to generate current Date based XML File for Account, Agreement, and Event Application. Used Xml task, Xml Source, Execute Sql task, Script task of Sql server 2005 Integration Services (SSIS) to achieve this task. Used ON ERROR functionality of SSIS to handle failed task.
• Used Execute process task of (SSIS) to send and received files from FTP server.Used Dataflow task to transfer data from XML to XSL file.Used File System Task to Copy, Move, Rename Blueprint Project Files and Directory. Used Email Notification Task tosend Status of Package execution. Used XmlStudio 2009 to validate XSD Schema with XML file.
• Used Package Configuration (.dtsconfig) to change property for dtsx package at run time for different environment(Development,QA,UAT)
• Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
• Migrated databases from SQL Server 2005 to 2008 with multiple data refreshes in the SQL 2008 environment.
• Created Role-playing Dimensions, Standard Dimensions, Linked dimensions, Time dimensions, semi additive measures in (SSAS) as per client requirements.
• Design fact and dimension tables, populated fact and dimension tables, created multi-dimensional OLAP cubes, maintain and optimize cubes in SQL server 2005 Analysis services (SSAS).
• Used (SSAS) Star Schema, Snowflake Schema, Aggrigation, Partition, KPI as per Project requirement.
• Used MOLAP storage for fastest query performance. Used multiple partitions to break up measure group into separate physical components to improve Query performance
• Extracted data from the SSAS cube and prepare report using SQL Server 2005 Reporting Services (SSRS).
• Created Drill down reports, Multi parameterized reports, Sub Reports, List ,Chart,Matrix Reports using Sql server reporting services (SSRS).
• Scheduling the reports to run on daily/weekly/monthly basis both automated and

Manual using (SSRS) and email the results to the users in the required format.

• Created several Dynamic Stored Procedure, trigger, Cursors, User defined functions, Inline Functions (UDF), View using Sql 2005T-SQL programming to implement the business logic and performance. Used Open XML, For XML, and XML Paths in some of the Stored Procedures.
• Designed and Implemented Performance Tuning, Query Optimization and Maintenance plan for consistency checks, backup/restore, reindexing within defined Maintenance Window and Server Monitoring throughSQL 2005 . Performance monitoring and Optimizing Indexes tasks by using Performance Monitor, SQL Profiler, and Index tuning wizard.
• Supports testing, debugging, and refining the Business Intelligence solutions to produce the required product
• Study and understanding the business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules.

Environment: SQL Server 2005 Enterprise Edition, Sql server 2005 Integration services, SQL server 2005 business intelligence suite, SQL Server 2005 Reporting Services ,SQL Server 2005 Analysis Services ,Sql server Management Studio, MS Visio,.Net Script,SQL Profiler Tool

Confidential, Montvale, NJ July'08 - April' 09
Role: Sr SQL Server Developer
Confidential, operates as an international network of member firms offering audit, tax and advisory services. This Project is based on developing an integrated system & ETL processes to migrate KRISK and CEAC database into NGGC. Project also involved evaluating KMPG Client and their Engaging party
using .Net application. Actual Reporting services is used to view various Client and Engagement
Evaluation Reports.

Responsibilities

• Created SSIS packages to download the files from secure https websites which are in XML format and finally stores them in database
• Created SSIS Packages to export data from Excel (Spreadsheets) & Flat Files to SQL Server 2005
• Used SSISActivex script task to call Web Services to evaluate Rules.Used SSISNotification task to send message through e-mails.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Worked on SQL Server Analysis services(SSAS) in integration with XMLA for the purpose of MDX used in Multidimensional Queries in Data warehouses.
• Used (SSAS)MDX Queries,Fact,Dimension to create NGGC Cube and used Calculate method of SSAS to calculate Key Performance Indicator (KPI) for graphical analysis.
• Responsible for creating the complex client reports and custom reports (On demand, AdHoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using Sql server 2005 Reporting services(SSRS).
• Created Adhoc Reports, Adhoc Report Model, AdminReport, AuditTrailReport, MySearch Report, Matrix Report using Sql server Reporting Services 2005(SSRS).
• Used localization in depth to see SSRS report in different language. Used SSRS Report MANAGER, Report designer for designing and managing reports.
• Used Xml Data source to generated Configurable Component report using Sql server 2005 Reporting Services. Used XMLDiff Task of SSIS to Compare Different Version and generate Version Comparison Report using SSRS.
• Worked on XML query language using XPath, XQuery as well as XSLT. Used ROW, AUTO, and EXPLISIT for defining element hierarchy in XML.Used OpenXml and ForXml for retriving data from .Net Application.
• Created Indexes, Stored Procedures, Views and Triggers using Sql 2005 T-Sql programming as per the requirements and needs during the project.
• Developer Logical and Physcical Datamodel for CEAC and NGGC Database using Visio. Prepare current database structure and configuration for high-performance through analysis and optimization
• Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily/Weekly/Monthly Load as per different Time Zone. Maintain Process Log and Created ProcessReport using SQl server 2005 Reporting Services(SSRS)
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.Developed partitioned views and tables for the purpose of security and fast upload.

Environment:
SQL Server 2005 Enterprise Edition, Sql server 2005 Integration services, SQL server 2005 business intelligence suite, SQL Server 2005 Reporting Services ,SQL Server 2005 Analysis Services ,Sql server Management Studio, ERWIN,MS VISIO,SQL Profiler Tool

Confidential, Columbus, GA Feb '07 - June'08
Role: SQL Server OLAP Developer

The Scope of this project is to provide dimension descriptions along with attributes and measures within those dimensions which will be included in CIS Analytics Release. CIS Analytics is intended to provide a graphical point and click Business Intelligence application by building a Customer Data Mart to enable analysis. CIS Analytics will also provide the customer with a dimensional view of Aflac's business by providing the ability to explore data by drilling up/down along predefined dimensions and measures.

Responsibilities

• Effectively design, develop, and implement Business Intelligence solutions using Microsoft Integration Services 2005(SSIS), Analysis Services 2005(SSAS) and Reporting Services 2005(SSRS).
• Helped several groups in Microsoft's IT Department with OLAP schema design, cube development, data warehousing design, MDX optimization, and front-end implementation and development.
• Worked Various SSIS2005 Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, ftp task, send mail task and active script task.
• Designed SSASFact and Dimension Tables, Populated Fact and Dimension Tables, Created Multi-Dimensional OLAP Cubes with KPIs, Actions
• Developed Data Marts using Star and Snow Flake schema using Measures and Dimensions tables.
• Used MOLAP storage for fastest query performance. Used multiple partitions to break up measure group into separate physical components to improve Query performance.
• Created Virtual cubes as per Client requirements. Used different Hierarchy levels while creating Dimensions.
• Used MDX queries to extract data from the cubes for the complex calculation. Create MDX script for representing Cube Calculation.
• Responsible for creating the Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab etc
• Developed SSRSreports using dynamic selection criteria, parameter passing to formulas.
• Created Attribute Hierarchy for freely organize data at query time and User defined Hierarchy for Roll up reports.
• Created Indexes, Stored Procedures, Views and Triggers as per the requirements and needs during the project.
• Designed SQL Database objects in .NET with SQL CLR programming. Created various StoredProcedures, Functions, Triggers, and User Define Data Types using C#.

Environment:
SQL Server 2005 Enterprise Edition, Sql server 2005 Integration services, SQL server 2005 business intelligence suite, SQL Server 2005 Reporting Services ,SQL Server 2005 Analysis Services ,Sql server Management Studio, ERWIN,MS VISIO, Business Object XI,Crystal Reports 9.0.

Confidential, Parsippany, NJ Feb '06 to Jan '07
Role: SQL Server Developer
Confidential, is one of the preeminent and most integrated providers of Real Estate and relocation services. Realogy Franchise is a functioning and working business model which is Realogy's leading brands Century21, ColdwellBanker, ColdwellBanker Commercial ERA and Sotheby's International Realty. The project is used to create Commercial and Residential properties reports, financial reports closing deals and resale activity reports ETC. It is used to convert Crystal reports to SSRS and is extended to new business requirements.

Responsibilities

• Build ETL processes using MS DTSX package. Used DTS jobs for importing data from legacy systems to the current model. Used ActiveX scripting for transferred data modifications.
• Created (SSIS) DTSX packages to import and export data from Excel, Text File, CVS Files.
• Review the current Data Mart and OLAP cubes and propose corrections and enhancements
• Constructed Sql server Analysis Services 2005(SSAS) Data Warehouse and designed Fact tables and Dimensiontables that were populated via DTS from production OLTP databases.
• Used SSAS MDX queries toextract datafrom the cubes for the complex calculation. Used key performance indicator (KPI) for graphical analysis.
• Responsible for creating the Summary Reports, Sub Reports, and Drill-down, dynamic grouping, Cross-Tab etc) using SQl server reporting services 2005(SSRS).
• Created User Conditions and Filters to improve report generation and readability of report and displayed the summary of data by creating Charts.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created views and stored procedures for Reports using complex SQL, T-SQL and Dynamic T-SQL. Implemented ER Integrity using Foreign Keys and Cascade Triggers.
• Responsible for Converting old Crystal reports into SQL server 2005 reporting services.
• Scheduling the reports to run on daily/weekly/monthly basis both automated and Manual using SSRS and email the results to the users in the required format.
• perform database tuning and performance monitoring
• Prepare both developer-level and user-level documentation
• Actively involved in Unit testing, System Testing, UAT and Implementation of the project

Environment:

• SQL Server 2005 Enterprise Edition, Sql server 2005 business intelligence suite, SQL Server 2005 Reporting Services server 2005 Management Studio, Business Object ,Crystal Reports 9.0, VB.NET, MS EXCEL 2000, Windows 2000 platform

Confidential, Mahwah, NJ Aug`05 to Jan`06
Role: SQL Server Developer

Description:
The project was to create data entry for over goods warehouse product. Its main purpose is to track
Lost goods or not shipped goods .so company people can track the goods and utilized the non claimed goods. The project was to create a data warehousing analysis Cube for the existing applications. The project involved analyzing the business users' requirements, creating the Cubes and Dimension for the ROLAP analysis and reporting services.

Responsibilities:

• Gathered functional and Business requirements and wrote technical specifications for building the Global Enterprise Data Warehouse. Involved in re-designing of database to create de-normalized reporting schema for better throughput.
• Expert level skill in Extraction, Transformation and Loading (ETL) in SQL Server database.
  Good knowledge in transformation of data between databases using tasks like Bulk Insert Tasks ,Data Pump Task
• Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and fact Tables. Created MDX queries for different complex measurement and also included KPI for Graphical Analysis.
• Data transfer using SSIS & DTS packages, used Open Query, Bulk Insert, BCP to copy data between various data sources: SQL Server, flat file (with or without format files), Excel spreadsheet, Access, etc.
• Review the current Data Mart and OLAP cubes and propose corrections and enhancements
• Developed Store Procedures and User defined functions (UDF) to access data from data Mart.
• Extensive experience on Business analysis and Enterprise reporting solutions delivery using Sql server reporting Services (SSRS).
• Created both automated and manual reports using SQL Server Reporting Services( SSRS )
• Created reports on both relational databases as well as against analytical cubes (SSAS).
• Created and debug complex stored procedures, triggers and views to capture updated and deleted data from OLTP systems
• Extensive use of Query Analyzer for performance tuning
• Decided upon the locking strategy that could be used for various batch programming structures & transactions

Environment:
SQL Server 2005 Enterprise Edition, Sql server 2005 business intelligence suite, SQL Server 2005 Reporting Service,SQL server 2005 Management Studio, Crystal Reports 9.0, ERWIN, UML, VB.NET,MS Project, MS Access 2000, MS EXCEL 2000, Windows 2000 platform

Confidential, Bloomington, ILFeb `04 to July `05
Role: SQL Server Developer

Description
The project was to develop an integrated system and ETL processes. Data was transported to a SQL staging database. Create stored procedures and DTS packages as part of the ETL process to populate the data marts.

Responsibilities:

• Has been part of the core team in Requirement analysis and database design. Involved in application analysis and system design
• Involved in Process Flow Modeling, Data Flow Modeling and Data modeling for reporting system database.
• Created flowcharts in E-R diagram using MS Visio for documentation of the project
• Extensively used Joins and sub-queries for complex queries involving multiple tables for reporting purposes
• Helping QA personals in deploying and testing the application, which uses SQL Server as a database
• Developed stored procedures, functions and triggers in T-SQL to implement data extract, transformation, and load (ETL) processes for all raw data and to manipulate raw data into views and materialized views for reporting purposes
• Used DTS Packages for data import and data export from SQL Server to Access, text and Excel files. Developed ETL for SQL Server 2000 using DTS packages
• Developing T-SQL / DTS scripts as required to load or manipulate data within database environments
• Created Spreadsheets and text files using DTS packages and Link Servers from different business groups
• Write transformation routines, develop bulk load routines
• Involved in disaster recovery and data migration
• Created Stored Procedures,Triggers,Views,(UDFs) and Indexes for better performance of the queries
• Configured and distributed replication to maintain the master tables in sync with the local databases

Environment:
SQL Server 2000, SQL Profiler, SQL Query Analyzer, Enterprise Manager and Microsoft SQL Server technologies - ETL / Integration (DTS)

Confidential, Reston, VA
Role: SQL Server Developer/DBA Apr'03 to Jan '04

Description:

Worked on the Data ware house collecting the data from different databases such as MS Access and SQL Server 6.5 and storing all these information into one database in SQL Server 7.0, so that the User can retrieve and reports can be generated.

Responsibilities:

• Participated in the Data Modeling to generate target database layout use for the data marts.
• Involved in Administering MS-SQL Server, performing day to day tasks such as Database tuning by checking indexes and modifying procedures, creating users, assigning roles etc
• Performance tuning servers, optimization using SQL Server Profiler, NT Performance monitor, Query Analyzer. Involved in utilizing PL
• SQL, T-SQL and Visual Basic programming to write program units for conversions
• Involved in Data Mapping, writing stored procedures for conversion and performing quality testing before the sign off
• Generated Data Mapping documents to define mapping from source to target.
• Setting up security creating groups, user defined roles, logins, granting permissions
• Data Modeling using Erwin
• Worked with different data models, normalization & de-normalization of tables using Erwin
• Designed new Database and doing conversion from a legacy system (MS Access to SQL 2000)
• Planned and implemented various SQL, T-SQL statements, stored procedures and triggers according to the requirements of the project for OLTP database systems
• Involved in writing T-SQL Programming to implement Stored Procedures and Functions for different tasks. Worked on DTS, Import and Export utility, BCP Utility and replication tool for transferring data Maintenance, installation, performance monitoring, and tuning

Environment:
MS SQL Server 7.0/2000, T- SQL, VBA, MS Access 97/2000, Windows NT

Confidential, New Haven, CT June'02 to Mar '03
Role: System Analyst/Programmer

Project: Human Resource Management System

Description: This System keeps track of the Company's Manpower requisitions, recruitment process, detail history of an employee, termination details etc. This system also helps in managing payroll system and training for employees, Induction, promotion, transfer etc., and other details pertaining to employee is available online

Responsibilities:

• Involved in Project planning and implementation through out the life cycle of the project
• Involved with Business Analysts to finalize System Requirement Specifications
• Coordinated with the implementation team for implementation
• Provided technical leadership and expertise over the design and development of system
• Developed procedures for managing software product during the stages of Product Planning
• Reviewed the business requirements or use cases, do the analysis, and convert them to logical data models.
• Verified and validated the package using various Software testing techniques and methods
• Involved in Testing, Bug Fixing and Documentation of the Project
• Developed de-normalized tables and population logic for reporting layer
• Designed and Developed Reports using Crystal Reports
• Used Active X to display The requested Client and projects detail information in Crystal Reports
• Created Stored Procedures to implement business logic in the back end using Cursors and Functions
• Extensively used Joins and Sub-Queries for complex queries involving multiple tables for reporting purposes
• Performed Database authentication modes, creation of users, configuring of permissions and assigning roles to users
• Prepared User Manuals, Flow charts, Functional documentations and System Documentations

Environment:
Visual Basic 6.0, SQL Server 2000, Win 2000 and Crystal Reports.

Confidential, NJ Jan `02 to May `02
Role: SQL Server Developer/DBA

Project: AT & T Corp account management

Description: This project is designed and developed for internal use of SOXAL to run their Accounts department. It allows the user to enter cash and bank transactions and get reports for Cash Book, General Ledger, Receipts & Payments up-to Balance Sheet. Used Dynamic selection criteria, parameter passing to formulas etc while using Crystal Reports with Graphical Interface

Responsibilities:

• Architecture and designing of the entire project as per client's specification
• Involved in design and development of application interface
• Involved in Database designing
• Interaction with client to design screens and reports as per their requirement
• Designed Reports for the Accounts Department.
• Design Complex Report using Crystal Report.
• Coding and unit testing with test data and live data
• Unit testing with test data and live data and monitor the functional testing and Integration testing before deploying
• Provided access to Database through MS Access Driver for storing data
• Environment:
• Visual Basic 6.0, Sql Server 7/2000, Win NT and Crystal Report

Confidential, Chennai, India June`99 to Nov `01

Position: Software Programmer

Project: SFA (Sales Force Automation)

Description:SFA is a client/server-based system written on the VB platform. This software is to provide the up to date information to Sales Representatives and their higher authorities, like Products, Addresses, To-do, Company, Activity Sheets, Project Information, etc. And also provide the various reports with latest information.

Responsibilities:

• Analysis and design the application architecture
• Involved in code review of the application
• Wrote code for Knowledge mark Program and utilize ADO database for connection and retrieval and update database information
• Designed reports using Data reports
• Hands on experience in ActiveX, COM and DCOM Technologies
• Created COM/DCOM components using VB6 (ActiveX DLL) and are Exported, Packaged and Deployed.
• Database Programming using ADO, DAO and ODBC
• Developed reports using dynamic selection criteria, parameter passing to formulas
• Performed Unit testing with test data and live data
• Implementing project as per requirements specified by client

Environment:
Visual Basic 6.0, MS Access 97, Win NT and Data Reports.