Database Administrator Resume Profile
Summary
Have a total experience of 14 Yrs in IT. Worked in various projects involving Database administration, client-server technologies, process management, content management, web administration and system analysis. Worked as programmer, analyst, administrator and project leader in a team as well as in single person projects. Technology Experience Software SQL Server 2000/2005/2008, ASP.Net, Oracle Hardware/Platform Windows NT, Windows 2000/ 2003/ 2008 Domain
Experience
Health Insurance, Marketing Management, Real Estate and Asset Management
Project Description: CONFIDENTAIL implementation which replaces existing legacy system which involves conversion and migration of existing legacy data to DPAS solution database Role Description: Database Administrator Responsibilities: Database administration of development, uat and production environments Support developers for implementing/creating database objects in various environments Map database objects from Legacy system to DPAS system Requirements gathering and anaysis Build and modify automation scripts Build and/or modify data migration,conversion scripts Implement validation rules in conversion scripts Implement disaster recovery process for end client Software/Technology: SQL Server 2008 / 2012 CONFIDENTAIL Project Description: CONFIDENTAIL implementation which replaces existing legacy system which involves conversion and migration of existing legacy data to DPAS solution database
Role Description: Database Administrator
Responsibilities: Database administration of development, uat and production environments Support developers for implementing/creating database objects in various environments Map database objects from Legacy system to DPAS system Requirements gathering and anaysis Build and modify automation scripts Build and/or modify data migration,conversion scripts Implement validation rules in conversion scripts Implement disaster recovery process for end client Software/Technology: SQL Server 2008 / 2012 CONFIDENTAIL
Project Description: Deloitte Pension Administration System implementation which replaces existing legacy system which involves conversion and migration of existing legacy data to DPAS solution database Role Description: Database Administrator Responsibilities: Database administration of development, uat and production environments Support developers for implementing/creating database objects in various environments Map database objects from Legacy system to DPAS system Requirements gathering and anaysis Build and modify automation scripts Build and/or modify data migration,conversion scripts Implement validation rules in conversion scripts Implement disaster recovery process for end client Software/Technology: SQL Server 2008 CONFIDENTAIL Responsibilities: Applications DBA support for online enrollment database, ADSCDS, FWA and CORE applications Microsoft dynamics CRM data migration Production support Develop new features Database design and implementation for new projects including acquisitions Closely work with Business partners in estimating, designing and implementing solutions Fine tune existing stored procedures Change Management Experience in waterfall and agile methodologies Handled mission critical applications Experience in implementing High availability using Mirroring Software/Technology: SQL Server 2000 / 2005/2008 Applications DBA CONFIDENTAIL Responsibilities: Day to day administration checks Change Management Backup and Restore New features installation Clustering, Mirroring, replication snapshot, transaction Disaster recovery setup Install and build and setup DR. Script tasks required for automation setup including step by step recovery process Software/Technology: SQL Server 2005 Database Administration CONFIDENTAIL Responsibilities: Day to day administration checks Change Management Backup and Restore New features installation Clustering, Mirroring, replication snapshot, transaction Disaster recovery setup Install and build and setup DR. Script tasks required for automation setup including step by step recovery process Software/Technology: SQL Server 2005 Database Administration CONFIDENTAIL Project: CONFIDENTAIL is a third party vendor application used for cash flow analysis of fixed income securities traded for each month. Beast is a client/server application developed for assisting BondEdge system processes. Role Description: CONFIDENTAIL. Beast application analyst and programmer. Responsibilities: Day-to-Day administration of BondEdge application, involving various processes of BondEdge. This is a highly user interactive and time bound application which requires the administrator to be well versed with all the processes of the application. Beast system responsibilities involve, assisting BondEdge processes after careful analysis of data, requirements gathering, database design, pl/sql programming and using Business objects for data sourcing. Software/Technology: Visual Basic, ASP, Sql Server, BondEdge and Business Objects CONFIDENTAIL Project Description Customer Inquiry website provide online access to their loan information. This project involves converting existing CAI websites into generic website. Based on the logon credentials each user should get directed to appropriate website. Role Description: Analysis and programming. Responsibilities: Analysis of existing CAI websites. Redesigning existing website to make it generic based on user logon information. Unit Testing, user acceptance, sign-off and implementation. Creation and maintenance of Business Objects universes. Technology: ASP, Sql Server and Business Objects CONFIDENTAIL Project Description: is a CONFIDENTAIL product and services website. This website is used by GEMSA to promote is products and services to its clients. Role Description: Design and Programming. Responsibilities: Requirement gathering, design and creation of healthyproperties.com. Web administration and database maintenance. Software/Technology: ASP, Sql Server CONFIDENTAIL Project Description: CONFIDENTAIL is a client/server technology based application. It used to track, process and analyze financial statements of loans issued by GEMSA. Role Description: Analysis, design and programming. Responsibilities: Analysis of existing system. Redesign and break up into individual modules. Design and coding of individual modules and Integration of modules. Software/Technology: Access, Visual Basic, Sql-Server, VSS CONFIDENTAIL Project Description: CONFIDENTAIL is workflow tracking application of marketing operations dept. It's used from creation to completion of job work. It's a process oriented application using cross platform Microsoft technologies. Role Description: Analyst / Administration Responsibilities: Administration of day to day activities. Design, programming and implementation of enhancements. Software/Technology: MS-Access, MS-Outlook CONFIDENTAIL CONFIDENTAIL Business Studies is a GEFA internal marketing/sales research application. Palm pilots are used to do the study by gathering metrics on-site. Role Description: Analyst, Administrator Responsibilities: Administration of palm pilots, creation of case study trees, analysis of case study trees, configuration of palm-pilots, data transfer and reporting. Software/Technology: Kinemark Solutions, Palm-Pilots CONFIDENTAIL Project Description: CONFIDENTAIL is a web based application used by agents banks to sell gesimplesecurity products online. This application is used to create and maintain client policy records. This is a three tier application. Business rules are implemented using COM technologies Software/Technologies: ASP, Oracle, Allianz COM components Responsibilities: Creation of and maintenance of websites. This includes design, creation, change control, sign-off, publish and maintenance of websites. Responsibilities include co-coordinating with vendor at vendor location. Role Description: Web Administrator CONFIDENTAIL Project Description: FileNet reporting module using dlls of FileNet and incorporating into Visual Basic application. This reporting module is available through FileNet front-end application to authorized users. Software/Technology: Visual Basic, FileNet and Microsoft VBA Role Description: Programmer Responsibilities: Requirements collection, coding of reports using FileNet dlls. Incorporating the reports into management module of FileNet application. CONFIDENTAIL Project Description: It's a client- server application used to capture client information and print using state-format specific forms. Responsibilities: Designing of Forms using PureEdge xml , xml coding behind the forms, integration with database and database programming. Also, involves client side Installation of required software, drivers and support Software/Technology: XML, Sql Server, PureEdge Role Description: Programmer CONFIDENTAIL Project Description: Agent administration system. This application is used for initial licensing, contracting, appointment and termination of Agents. The documents used for Agents appointment are scanned and saved using FileNet imaging system. The project involves upgrading current FileNet system to next version, Panagon. Software/Technology: Visual Basic, FileNet Role Description: Programmer Responsibilities: Requirements collection, analysis of current agent system, FileNet scripts, documentation of various processes involved. Estimate of Project conversion and demo. CONFIDENTAIL Project Description: This project involves creation of image processing software product. This involves various image processing techniques and methods like, contouring, skeletonization, thinning edging etc. Software/Technology: Visual Basic Role Description: Programmer Responsibilities: Requirements collection, analysis and modifications of algorithms used for different morphological operations. Design and implementation using visual basic.
