We provide IT Staff Augmentation Services!

Sql Dba Resume

0/5 (Submit Your Rating)

Houston, TX

SUMMARY:

  • More than 16+ years of intensive and progressive experience in performing computer programming, DBA/LAN. And systems analysis in broad - based ADP settings including system level analysis, design, development and implementation on contemporary computer hardware, RDBMS and programming
  • Languages. 7+ year experience in application development using MSSQL SERVER, Visual Basic/.NET, RDL, ADO, HTML, Crystal Reports, MS Access. More than 9+ years experience supporting in capacity of Sr. DBA for MSSQL SERVER, MYSQL, HYPER-V, VMware, Amazon.com, Xeround DB and Azure. Managing EC2, Route 53, VPC, S3, RDS, Cloud Watch, Elastic Beanstalk, IAM, Load balancer and buckets, Switches, routers, IP phones, JIRA, SVN, Memcached, SharePoint 2010, and Barracuda firewall highly motivated professional, a skilled communicator, and an excellent team player.

TECHNICAL SKILLS:

Specialties: Extensive remote user experience Strong oral and written communication Systematic problem - solving Disaster recovery, Always on Availability Groups, Failover Clustering, Replication. Decommissioning, DBCC commands, DVM etc. Partitioning, Power BI, MSSQLR. Technical skills

Tools: Red Gate Software. Fog light (Quest) SQL Monitoring software for monitoring databases. Lite speed (Quest) SQL Backup software for compressing databases. IrDA - DB Artisan tool for managing databases, Decommissioning of MSSQL SERVER.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SQL DBA

Responsibilities:

  • Database Administration for very large and complex databases in SQL Server 2016/2014/2012/ R2, 2008. Always - On Availability Groups (AAG) and HA/DR Troubleshooting. Database Administration on Production Servers with server configuration, performance tuning (PTO) and maintenance with outstanding troubleshooting capabilities.
  • T-SQL writing stored procedures, triggers and functions. Administering SQL Server High Availability and Disaster Recovery strategies. Data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations. Implemented the new SQL Server 2014 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG. Worked on logical and physical data base modeling with ERWIN tools. Experience in using DMV and dynamic management functions for finding out long running queries. Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability. Experience in Disaster Recovery Planning and Security Management operations. Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Having hands on experience in DR processes including Log shipping and
  • Database Mirroring. Worked on configuring SQL Server with minimum privileged access. Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. Troubleshoot performance problems, fine-tuning of databases and index Analysis. Worked on SQL Server 2016 migration from SQL Server 2012/2014/2008. Experience on 64 bit SQL Server 2016/2014/2012 and 2008 R2 systems and MSCS Configurations. Implemented Always-ON (AAG) on SQL Server 2014 SP2 CU5. Maintained individual service accounts for SQL Server services on cluster with different
  • Security groups to raise security mark. Having Experience on Data center servers and handling 1.4 TB databases. Handling Memory configurations for SQL Server 2016/2014 and SQL Server 2012 on Windows 2016. Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and
  • Application support. Created Linked Servers between SQL Server 2016 R2 & three tire app databases. Also created DTS package for data transfer between the two environments. Knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering. Experience in supporting Very Large databases (VLDB) and troubleshooting the problems. 24x7 Production Database on Call Support. Experienced with using 3rd party DBA tools such as LiteSpeed, RedGate, and IDERA. Ability to understand business requirements and estimate for delivery commitments. Resolving issues on production as well as on developments environments. Configuring database by populating metadata for databases from master database server. Supporting multiple SQL servers instance in a complex environment. Configuring VB/.Net application based on customer requirements. Adding objects, querying objects, updating etc. to databases as well as on VB/.NET application. Advanced knowledge and use of Microsoft Excel and Access is required.

Environment: Win 2008R 2/2012/2014/2016/ Win7/Win10, Hyper-V, MSSQL SERVER 2008/2, .net 4.5, VS 2010/2012/201 , RDL .net, ADO.net

Confidential

SQL DBA Production Support/CM

Responsibilities:

  • Implementing and Maintaining Log Shipping, Clustering,DatabaseMirroring, Always On as Disaster Recovery and High Availability solution. Supporting over 200+ instances of SQL server which were mixed flavored of SQL server in a clustered environment which included DR, Prod, UAT, Dev, Sand boxes and VMware servers. Performing 0ver 60 releases on daily biases as per required by development teams. Decommissioning of MSSQL SERVER
  • Install, configure, administrator, manage & troubleshoot multi node multisite SQLServerclusters, and standalone serverand instance setup. SQLServerSetup, Installation, Version Upgrade, SQLServerupgrade and migrating using export/import, SSMA (SQLServerMigration Assistance) from various source to SQL server. SQLServerHardening & Best Practice Implementation for production environment.
  • Capacity Planning, Load Balancing & Scaling out SQLServerand applicationserver/web server.Design and ImplementDatabaseBackup Restore & Disaster Recovery Strategy.
  • DatabaseArchiving / Partitioning, data mapping, creating multiple file-file group for better databasesandserverperformance.
  • Auditing SQLServerSecurity with C2 for compliance with the business polices, produces & requirements.
  • Implementing transparent data encryption (TDE) and extensible key management (EKM) to make encryption and key management using a third-party key managerData. Transfer / Transformation (ETL).
  • Plan, Design and scheduledDatabaseMaintenance & Administrative Tasks. SQLServerDatabaseMonitoring with DDL Triggers, SQLServerProfiler, Event Notifications and creating alert fordatabasemonitoring & reviewing log files and daily bases.
  • Troubleshooting SQLServerfordatabase, application users respective and provide solution within timely fashion.
  • Schedule SQLServerAgent Jobs, SQLServeracross multipleServerswith automatic and manual execution. Performance Tuning - Execution plan, Profiler, Performance Monitor, Extended Events, Data Collector and Resource Governor.
  • Enterprise Policy Management / Centralized Management. Supported SQL 2008/2012/2014 , T-SQL, Backup / Recovery, Resource Governor, Database Mirroring, Partitioning, Replication; SSIS, SSRS, SQL Agent, SQL Profiler, Encryption, BCP, Log Shipping, Configuring Always On Group on SQL SERVERS.
  • Performed database administration tasks, including creating maintenance plans for multiple MSSQL servers to allow for system and user application database backups and maintenance cleanup; automating daily maintenance tasks; implementing Database Mail and Job Notification, using SQL Server Integration Services to transform data (ETL), installing and maintaining SQL Server, SSIS, SSRS, SSAS; researching and implementing column and Transparent Data Encryption.

Environment: Win 2008R2/2012/2014/Win7/Win10, Hyper-V/VM Ware, AWS, CMS, MYSQL, MSSQL SERVER 2008/2 Pre, IIS7.5, .NET 4.5, VS 2010/2012/201 6

Confidential, Irving, TX

Sr. SQL DBA

Responsibilities:

  • Maintained database data integrity, back-ups and disaster recovery. Identified and solved complex problems and identified ways to improve efficiency.
  • Converted 300+ user application databases and servers to Database Operations control group, saving over $2M per year.
  • Developed and maintained comprehensive disaster recovery strategy and action plans. Ensured the application data and underlying systems were fully recoverable after catastrophic event.
  • Resolved multitude of database problems (e.g., slow database performance). Diagnosed root-cause of problems, impact to business, developed, tested and implemented cost-effective solutions. Followed-up with stakeholders to ensure complete resolution and satisfaction.
  • Recovered production data during catastrophic disc failure. Diagnosed cause of problem, implemented disaster recovery plan. Resulted in minimal loss of productivity. Cited as most cost-effective approach to data recovery, resulting in implementation by other stakeholders.
  • Trained database administrators to ensure each had the knowledge and skills to perform their jobs with optimal effectiveness and meet all regulatory compliance requirements. Resulted in higher job performance levels and eliminated risk of non-compliance audit issues.
  • Migrated data and databases from former to current owner database systems. (MSSQL to Oracle)
  • Decommissioned 200+ user application databases and servers. Removed users, disabled MSSQL server and notified stakeholders. Achieved 100% verification of data integrity.
  • Maintained compliance with company and government security requirements. Monitored production systems to ensure ongoing compliance and reported discrepancies to application managers. Resulted in zero unauthorized access attempts.
  • Trained Oracle DBA in MS SQL processes and procedures. Resulted in full coverage from staff that had the knowledge and skills to perform all required responsibilities.

Environment: VB 6, VBA, VB Script, Win 08/03/00/XP, UNIX, SQL SERVER 00/05/08/12, power shell, VMware.

Confidential, Bedford,TX

Lead Information Analyst

Responsibilities:

  • Designed, created, implemented, and maintained commercial wholesale and leasing operations databases.
  • Reduced processing time from 4 hours to 45 minutes. Resolved longstanding inefficiency of daily production in operations. Modified stored procedures to execute faster and more efficiently.
  • Built and maintained new SQL servers from the ground up, installed operating systems, SQL and tape back-up software. Developed clear, concise and comprehensive documentation. Cited for saving labor costs by doing the work that had been done by two FTEs.
  • Designed, implemented and maintained Microsoft SQL Server / Microsoft Windows NT database systems to support reporting for commercial wholesale, retail and leasing operations. Resulted in secure databases that were accessible through the internet.
  • Lead data management team responsible for development, staging, and production environments. Established performance objectives, trained and coached staff, assigned work and ensured all team members had the skills, tools and motivation to achieve all objectives.
  • Oversaw Change Control Management process, ensuring all software put into production was thoroughly tested and met all performance requirements.
  • Consulted with business system owners and IT operations to achieve well-tuned applications. Improved database and query performance relative to business needs. Coordinated efforts to ensure minimal disruption to user productivity.

Environment: VB 6, VBA, Access 2003, VB Script, Win 2003/2000/XP,UNIX, scripting, AS/400, Showcase7, SQL SERVER 2000/2005.

Confidential, DALLAS, TX

Sr. Programmer/analyst

Responsibilities:

  • Designed and implemented inventory control system for Confidential which utilized access as front end and MYSQL 3.5 as backend with linked tables from 3 different data sources FOX Pro, MYSQL and access databases which was redesigned by me and consolidated in one database utilizing Microsoft SQL SERVER 2000 as a backend and Access 2000 as a front end application.
  • Generated customized and cross-tab reports/queries fordaily/monthly/weekly/ quarterly /yearly stocks, shipping details, Reallocation/reconciliation ofinventory etc. Designed and implement Clients database for New York Insurance Company'sindependent agent which utilizes Access 2000 as front end and back end with reports in Access 2000. Used BCP/DTS to import and export data.
  • Utilized VB scripts to implementing complex DTS process for ETL. Migrate Access/MYSQL Databases to SQL SERVER 2000 data store. Wrote many complex and calculation basedCROSSTAB/OLAP) queries. Designing forms in access/crystal reports and for presentation object.
  • Designed custom functions and procedures (Sub routines) in VB/VBA and SQL. Utilized ADO and ADO.NET objects for connectivity as well as ODBC to retrieve data from different data stores. Designed friendly front-ends forms by employing textboxes, combo box, tree view controls, date control, labels etc. Wrote ad hoc queries and designed ad hoc repots in crystal reports 10v\Access (very complex).
  • Wrote stored procedures, views, functions in SQL SERVER for DML and DDL. Used Erwin 3.5 to redesign the database in SQL SERVER 2000. Supporting all aspects of databases and applications and all users.Network resources as well as perfuming duties as a DBA and network administrator. Configured SQL Servers to send notifications to myself for each scheduledprocess and respected
  • Developers. Created maintenance plans. Designed planes for disaster recovery (log shipping). Verified backups on daily basis. Configured SQL mail on all the servers in order to send notifications and created operators and alters. Installed, configured and managed shared disk Clustered servers in Active/Active Model and Active/Passive Model. Installed, configured and managed Replication on LAN as well as Wan for Transaction, Merger and Snapshot replication in enterprise environment.
  • Responsible for object migration from DEV - QA - PROD environments. Optimized existing stored procedures by creating Hash tables in tempdb for optimal performance.
  • Optimized queries using execution plain and created stored procedures which performed calculations dynamically for populating tables. Updating the databases manually by executing queries and stored procedures, loading data into tables from different data sources and data mapping. Wrote scripts to attach and detach databases. Wrote DBCC scripts to check the database allocation and structural integrity.
  • Designed databases, tables, stored procedures, indexes, views etc. Role included supporting and maintenance of applications using SQL Server 7.0/2000 and Visual Basic and determine Used BCP to import and export data.
  • Replicating database from heterogeneous database like MYSQL and Access for production.

Environment: SQL SERVER, VB, VB.NET, ADO.NET, Access, VB Script, Win 2003/2000/XP/98, MYSQL, FoxPro, asp, FrontPage, Flash MX, Photoshop. Crystal Reports 5/10v.

Confidential, Dallas, TX

SQL Server DBA/Analyst

Responsibilities:

  • Designed and developed data structures to store enterprise data in a SQL SERVER 2000 ENTERPRISE environment.
  • Created scheduled database processes supporting automated file transfers.
  • Maintained databases, including updating statistics, re-indexing, structure modifications, capacity planning, and index analysis. Implemented database security, logins, users, roles, and object level permissions.
  • Implemented configuration management of database objects. Worked with integrated project teams as project database administrator for large-scale modifications. T-SQL development and writing T-SQL queries Administrative tasks including DBCC commands, I/O, memory/cache utilization etc. Planned and executed database modifications and SQL scripts for vendor applications, data repair, and functionality enhancements.
  • Implemented database backup and recovery procedures, including disaster recovery procedures. Assisted software engineers and end users with query writing, database access, and general information. Performed transaction analysis and performance tuning of database applications and batch processes. Conferred with senior management and staff on policies and procedures, technical problems, and priorities that relate to database operations. Prepared project status/progress reports on assigned activities.
  • Designed ETL processes (data sources include ORACLE, Spread sheets, etc.), including data quality and testing. Improved query responsiveness and processing performance.
  • Optimized hardware resources, deployed and interpret monitor counters. Performed migrations for SQL 2000 in an enterprise environment for production servers and databases in a clustered. Managing and Supporting 30 severs and 200 databases in an enterprise environment.
  • Promoting objects from DEV - QA - PROD environment. Designed and implemented centralized job management status reports for each server which reducing overhead on DBA group.
  • Utilized spot light software by Quest for monitoring servers I/O, Cache, Locks, Disk utilization, processors, ETC. Access Databases/Queries to OLTP SQL SERVER systems, written interfaces in VB DMO objectsto re-route data to new platforms.Migrated Access\Queries Databases to SQL SERVER, replace access reports with Crystal Web reports VB/.NET DEVELOPMENT: 1. wrote a visual basic 6. /crystal report application including developed COM+ objects (which I originally created) to VB .NET application.
  • Created an application (my idea) to assist the Help Desk department: Instead of customers calling the help desk department and the transaction was entered manually into a CRM system, customers would now email the helpdesk department, my application will read and update the CRM system automatically, direct the emails to individuals in the helpdesk department and maintain a "load balance" between the helpdesk operators. The email server was MICROSOFT EXCHANGE and CDO objects were used to control the functionality of exchange and outlook in .NET application.

Environment: SQL SERVER, VB, VB.NET, ASP, ASP.NET, ADO.NET, Quest, Access 2003, VB Script, Win 2003/2000/XP

Confidential, Houston, TX

SQL Server DBA/ SQL Server Developer/VB developer

Responsibilities:

  • Responsibilities included evaluating, Designing, testing, supporting and implementing databases structures and Migrated Used BMC SQL programmer/SQL Analyzer tools to modify existing stored procedures for new processes.
  • Created and modified tables to accommodate new stored procedures and process. Created tables, view, Indexes, stored procedures, defaults and other objects.
  • Responsibilities included maintaining the databases on daily basis, responsible for production servers as well as for development servers. Resolved issues on production environment as well on development environment.
  • Installed and configured SQL server for optimal performance. Configured SQL Servers to send notifications to myself for each scheduled process and respected developers.
  • Created maintenance plans for backups, jobs, alters and designed ETL processes for automation. Designed planes for disaster recovery by implementing replications to remote sites and log shipping.
  • Verified backups on daily basis. Installed, configured and managed shared disk Clustered servers in Active/Active Model and Active/Passive Model.
  • Installed, configured and managed Replication on LAN as well as WAN for Transaction, Merger and Snapshotreplication in an enterprise environment.
  • Responsible for object promoting objects from DEV - QA - PROD environments.
  • Optimized existing stored procedures by creating Hash tables in tempdb for optimal performance. Optimized queries using execution plain and created stored procedures which performed calculations dynamically for populating tables.
  • Updating the databases manually by executing queries and stored procedures, loading data into tables from different data sources and data mapping.
  • Wrote scripts to attach and detach databases.
  • Wrote DBCC scripts to check the database allocation and structural integrity and created scripts for re-indexing tables. Role included supporting and maintenance of applications using SQL Server 7.0/2000 and Visual Basic.
  • Determining databases design and redesigned the databases and technical documentation for databases. Used BCP/DTS to import and export data.
  • Utilized VB scripts to implementing complex DTS process for ETL. Integrated Lawson system using DTS services.
  • Utilized OSQL to perform tasks from DOS prompt. Used ARC Serve IT and Legato to backup and restore from tape devices and scheduled tape backups on daily and weekly in rotation to off site. Installed servers, Volume sizing, Capacity control, Quota assigning, remote installation.
  • Installed and configure RAID level 5 for tolerance and configured network load balancing for performance, assigned network IP addresses. Installed and configured DNS, WINS, TCP/IP protocols, applied patches and upgrades to servers. Designed/Implemented/MaintainedOLAP servers and processes to replicate production data to the server. Developed .net components using DSO /CDO components and wrote VB.NET components (for the ETL environment) to interpret and cleanse data entering the warehouse and alert administrators via email if certain conditions would arise. Developed .net components using DSO /CDO components and wrote VB.NET components (for the ETL environment) to interpret and cleanse data entering the warehouse and alert administrators via email if certain conditions would arise.

Environment: SQL SERVER,VB, VB.NET, ASP, ASP.NET, ADO.NET,BMC, Access 2000, VB Script, Win 2003/2000/XP, Erwin.

SQL Server DBA/ SQL Server Developed

Confidential, Coppell, TX

Responsibilities:

  • Worked as a DBA/LAN Administrator to support and maintain internal databases in a production environment. Role basically included supporting and maintenance of applications using SQL Server 7.0/2000. Responsibilities included maintaining the database on daily basis, Responsible for production and development servers. Resolve issues on production environment as well on development environment. Optimize existing stored procedures and queries utilizing execution plain. Resolved production integration issues, which were failing. Loading data into tables from different sources and data mapping. Managing Schedules tasks for creating nightly Batch processes. Configured SQL Servers to send notifications to myself for each scheduled process and respected developers. Wrote scripts to attach and detach databases. Wrote DBCC scripts to check the database corruption, allocation and structural integrity of all the objects, I/O, memory/cache utilization. Imported and exported data using DTS and BCP. Designed ETL process utilizing VB scripting language. Installed and configuredstandby server. Used performance monitor to monitor performance of objects and profiler to trace objects. Created maintenance plans for disaster recovery utilizing replication and log shipping. Verifying backups on daily basis. Created transaction logs files. Determine database design and redesigned the databases and documented databases. Solely responsible for object migration from DEV - QA - PROD environments. Implemented security standards.
  • Configured SQL mail on all the servers in order to send notifications and created operators jobs and alters. Installed MSSQL 7.0 and configured for optimal performance. Created databases, tables, indexes, views, stored procedures and other objects. Responsible for Managing NT Server Administration as well as Windows 2000 servers. Used policy editor to restrict client machines from accessing various objects in Windows NT/2000/98/xp. Created user groups and users based on departments and assigning appropriative permissions. Implemented database security, logins, users, roles, and object level permissions. Installed and configured TCP/IP protocols. Created trust relation between servers. Allocating resources. Migrating resources from one server to other. Installed Adapters, printers and device drivers and created share resources. Implemented UNC to configure SQL Agent. Configured startup/shutdown parameters. Configured swap spaces. Performed window NT 4.0 migration to windows 2000.
  • Configured and managed Active directories/Trust/Replications and managed windows advanced server 2000 in the capacity of a LAN Administrator in an Enterprise environment. Used ARC Serve IT to backup and restore from tape devices and scheduled tape backups on daily and weekly rotation. Disk sizing, building servers, implemented load balancing, assigned network IP addresses, DNS, WINS and configured networks.
  • Implemented RAID Level 5 on Dell servers. Replaced disk controllers and hot spares. Used Dell open manage to install and configure the servers. Generated reports using crystal reporting tool based on custom quires, using ODBC for connectivity to databases. Implemented IIS 5.0 configured and administered. Installed software's, and upgrades patches, hot fixes. Utilized Microsoft project 98 to implement time management, resources management and project tracking.

Environment: SQL SERVER, Access 97/2000, VB Script, Win 2003/2000/XP, Erwin. Microsoft project 98, Crystal Reporting.

Confidential, Fort Worth. TX

SQL Server Developer/SQL Server DBA

Responsibilities:

  • Worked as a DBA in a team environment to implement salary review RDBM system. Responsibilities included maintaining the database on daily basis, Responsible forproduction anddevelopment servers. Resolve issues on production environment as well as on development environment.
  • Resolved failing jobs and created new jobs. Optimize existing stored procedures and queries using execution plain and created new stored procedures which performed calculations dynamically. Created tables, views, stored procedures for initial population of the data for setup and configuration for application. Modify databases schema tables etc.
  • Designed ETL process (data sources include ORACLE, Spread sheets, automation etc.), including data quality and testing. Created maintenance plans for disaster recovery.
  • Schedule backup’s tasks. Managing Schedules tasks for creating nightly Batch processes Refreshing databases as required by development team. Responsible for migrating objects from development environment to production environment. Created transaction logs files.
  • Installed and configuredservers for production as well as for development environment, andfor user testing. Determine database design and redesigned the database and documented databases. Implemented database security, logins, users, roles, and object level permissions.
  • Utilized performance monitor to monitor performance of objects and profiler to trace objects. Implemented Exec software for backup and restore from tape device and scheduled tape backups on daily and weekly rotation. Worked with development team on salary review project which was redesigned. Tools used to redesign was Erwin.

Environment: SQL Server 2000/7.0, Access 2000, Window 2000 advanced server, Erwin

Confidential, Dallas, TX

VB Lead Developer/Crystal reporting/Access database/SQL SERVER

Responsibilities:

  • Responsible for SQL Server backup/recovery for 2 productions, 2 Development and 1 test server.
  • Upgraded 2 servers from SQL Server 6.5 to S QL Server 7.0. Configured SQL Servers to send notifications to respective users/developers and myself for each scheduled process.
  • Responsible for object migration from DEV - QA - PROD environments. Also debugged Store procedures using CAST tools and VS. Created views, tables, indexes, stored procedures, jobs, alter, maintenance planes, etc. Designed and implemented Contract Tracking System for internal use for Confidential utilizing Access 7.0 Database (SDLC).
  • Multiple forms were designed according to end user specs. Multiple reports were generated based on end users specs in Access 7.0. The system was automated to send e-mails base on the criteria of expiration of a contract to respective users. The utility was implemented utilizing VB 6.0. MAPI/CDO controls and timer controls were employed. Implement reports utilizing crystal reporting tool based on custom queries, using ODBC for connectivity to databases. Migrated the Access database/application to SQL Server database/VB 6.0.

Environment: VB 4.5/6.0, RAD, ADO 2.1,SQL SERVER / 2000/7.0/6.5 , T-SQL, Access, COM+,VB Script, Window NT, Novell., VB Developer/Crystal, reporting/Access database

Confidential, San Antione, TX

VB Developer/Crystal reporting/Access database/SQL

Responsibilities:

  • Independently design an application which Imported files from mainframe JCL system into windows files system and then created files system which produced data written into text files and creating files, folders etc. based on where the main frame code had a terminator, utilizing VB and access database and designing reports in Crystal base upon file system.

Environment: VB 4.5/6.0, RAD, ADO 2.1,SQL SERVER / 2000/7.0/6.5 , T-SQL, Access, COM+,VB Script, Window NT, Novell.

Confidential, Austin, TX

VB Developer/Crystal reporting/Access database

Responsibilities:

  • This client/server application employed MDI as well as EDI design. Extensively used 3rd party Active-X controls like DB-Grids, Flex-grids and various Sheridan 3-D controls. Created stored procedures to obtain various business functions and rules. This application also generated various parametric reports based on custom queries and Crystal Reports was used as the reporting tool. Application also had an in-built form based querying feature to fetch complex-join data. Created Front End screens using VB controls like grid, list box, buttons, text boxes experience in coding using VB classes, and optimum coding methods.
  • Used Crystal Reports 4.5 for several grouping levels with scripting in the Crystal Formula Editor for calculate fields. Passed filter formulas and file names from V.B front end. Designed various MDI Forms, customized menus, for inventory control tracking and maintenance of customer, invoices and shipping stock information. Generated customized and cross-tab reports for monthly stocks, shipping details etc. System has in-built security for user authentication. Worked in a team environment to design an inventory control system using relational database concepts with SQL Server as back-end and VB as a front.

Environment: Visual Basic 5.0, Windows NT, Windows95, Crystal Reports 4.5, SQL SERVER .6.5

We'd love your feedback!