Database Analyst Developer/business Systems Administrator Resume
2.00/5 (Submit Your Rating)
New, YorK
SUMMARY
- Adapt quickly to new concepts and responsibilities, possess an energetic positive attitude, has a willingness to work with new software, and maintain procedures and effective methods for operations
- Focused on high quality tasks completion, result oriented, excellent communication and organization skills with attention to details, ability to understand and link business and technology requirements
- 12 years experience in RDBMS design, ETL process development, SQL Server based and web enabled application design, development, implementation, and support, business requirements specifications
- Proficient in business systems project data flow analysis, gathering functional requirements, administration, implementation, design, development, maintenance and support
- Strong experience with ETL process development, data migration, data transformation process automation
TECHNICAL SKILLS
Tools: MS Windows 2000/XP/Vista/7, MS SQL Server 2005/2008, SQL/T - SQL, Microsoft Word, Access, Excel, PowerPoint, C#/Visual Studio.Net, VBA/VBScript, Business Intelligence, Crystal Reports 9.5/10, ORACLE 9/10g SQL/PL SQL, TOAD, Unix Shell script, JavaScript, ASP, HTML, XML, UML, Use Case, Visio, Erwin
PROFESSIONAL EXPERIENCE
Confidential, New York
Database Analyst Developer/Business Systems Administrator
Responsibilities:
- Serve as an database expert of Shareholders Department for managing and supporting Institutional Investors Portfolio Monitoring Database System and as a point of contact for day-to-day user support to help investigate recoverable losses of fund shareholders due to fraud by companies they invest in, developing code using SQL
- Provide database administration, data collection mining and automation, maintain users and security
- Perform monitoring database growth, data mapping and transformation coding for new data integration
- Collaborate with business customer to analyze information needs and functional requirements and work with client support representatives and technical support specialists to develop necessary business process workflow enhancements, customization requests, and provide client support to troubleshoot application issues
- Build procedures and scripts to load securities data, debug and improve ETL database processes, assist staff with writing queries, scripts, stored procedures, building reports, and new product installations
- Trains departmental staff on application systems, manage stuff for data downloads and data manipulations
Confidential, NJ
Database Application Developer/Business Systems Administrator/Business Analyst
Responsibilities:
- Worked with subject matter and business client to capture meetings, information, ideas, discussions
- Analyzed and evaluated business systems and user needs, develop requirements specifications
- Designed, developed and supported SQL Server based and web enabled application, implemented Oracle and PeopleSoft data for HR Personnel Management System, which allowed to produce budget and stuff reports
- Designed automated process of loading data(data transformation module, DTS packages, stored procedures), matrix, tabular, parametric, and summary reports for Engineering Department Costs Data Warehouse
- Designed and developed executable module, which transfers source data into database, executes data processing stored procedures, creates XML file for web site, creates execution log file, and automatically send e-mails messages about execution to users for Minority and Women Business Enterprises System
- Designed, developed and implemented web enabled Digital Asset Management System and integrated it with Canto Cumulus 5.5 digital assets catalogs based on metadata database
- Designed and developed database, implemented HR Soft Charter 9, created data transferring executable module and SQL Server DTS packages, which automatically transfer employee data from Excel spreadsheet files to the SQL Server database for Organizational Charts web based application
- Designed and developed SQL Server based application, and user manual, conducted user training for Education and Training System, which allowed to navigate and manage a compilation of employees training courses, certifications and other information related to HR personnel data, and produce reports
- Designed, developed and supported Electronic Documents and Drawings Management System
Confidential, New York
Information Systems Development Officer
Responsibilities:
- Conducted business requirement analysis, databases modeling, design, integration, financial sales and business management reports for various financial system applications
- Designed, developed and supported Help Desk, Employee Contacts, Computer Inventory, Investments and Insurance Reports, Business Management Computer Systems, using MS SQL Server, Access, Crystal Reports
- Developed Investments and Insurance Services, Policy Owner’s Tracking, and Licensing Computer Systems
