Db2 Dba/business Analyst Resume
4.00/5 (Submit Your Rating)
PROFESSIONAL SUMMARY:
- Development of ad - hoc reports generation for management use
- Database Analyst with 15+ years of experience in database design, maintenance, performance and support
- Experienced RDBMS for development, maintenance, and storage of large databases
- Proficient in SQL coding, analysis and performance
- Knowledge in problem resolution of processing logic, COBOL coding and JCL development
- Experienced with various 3rd-party vendors tools to support day-to-day database functions. Tool such as Platinum / CA database suite, IBM database suite & utilities, BMC database suite, File-Aide, Omegamon, CA-7 Erwin Tools, Strobe, Endevor, RACF, Compuware Tools
- Experience with change management process for applications and documentation
- Proficient in translating business and user requirements into detailed specifications
- Experienced in conducting requirement analysis, use case design and developing logical models.
- Experiences in reviewing and finding complex issues by reading log files, partnering with systems, storage and network infrastructure partners
- Active team participant in establishment of policies and procedures
- Strong expertise in Data analysis, Data mapping, Data modeling and development
- Excellent in gathering business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
- Excellent communication and organizational skills including the ability to multi-task prioritize and manage increasingly complex issues.
- Data analysis / definition / mapping
- SQL Proficient
- Accelerated learner Problem Resolution
- Strong analytical skills Quality Control driven
- Meeting Facilitator
- Process oriented Risk Analysis and Mitigation
- Commitment to Integrity and Excellence
- Strong communication skills
- Detail oriented
- Ability to recognize the need for change Detail oriented
- Ability to develop and maintain relationships
- Ability to work independently or as a team
- Strong troubleshooting Process Integration
- Problem Complexity
- Process/procedure development
- Requirements Analysis
- Application Release Testing
- Provides technical direction for the design and implementation of complex database environment on a variety of platforms
- Provides the highest level of consultants and recommendation to peer, systems and application development teammates
- Ability to report status by producing appropriate metrics
- Ability to oversee and drive to conclusion, extremely complex problems and issues among multiple support groups and analyze technical issue within specific focus area
TECHNICAL SKILLS:
- Requirements Collection
- TSO / ISPF
- QMF (Query Mgr)
- Strobe
- Data Analysis
- DB Performance Tools
- SQL
- RACF
- MS/Project
- VSAM
- DB2
- Endevor
- MS/Office Tools
- DASD
- Job Scheduling (CA7)
- File-Aid
- IBM Mainframe
- Change Management
- DB2 Connect
PROFESSIONAL EXPERIENCE:
Confidential
DB2 DBA/Business Analyst
- Primary responsibility for managing and maintaining large database systems for Financial Institution:
- Primary DBA for IBM DB2 database platforms
- Secondary DBA for SQL Server database platform
- Achieved data redundancy reductions through analysis
- Rewrote 900 plus Image Copy utility jobs to reduce redundant in CA7
- Save the company $250 thousand dollars from over allocated tables, indexes and maintenance jobs.
- Liaison between test center, DBA’s, systems programmers and developers
- Strong SQL query development and performance on IBM and SQL platforms
- Assisted development team with database performance analysis
- Supported developers in SQL and database design, and maintenance
- Developed ad-hoc queries using SQL
- Developed and implemented process and technical improvements that increase the availability and quality of products and services delivered into production.
- Customized reports to monitor databases
- Maintained data integrity and maintenance
- Manage the analysis and communication of supported and or project requirements, updates, metrics and general information, including project and operational activities, enhancements, test readiness development and maintenance plans to ensure proper operation of business system and services are optimized.
- Create production tests by developing data load scripts and utility function for each environments as well as the systems testing and implementation plan.
- Coordinate physical changes to mainframe databases; and codes, tests, and implements physical database
- Active team participant in development of processes and procedures
- Active DR team participant in implementation of new/modified business initiatives for disaster recovery
- Active team member for implementation of business initiatives including brainstorming on new functionality for current systems.
- Provides extensive experience in troubleshooting hardware, core system software, database environments and application software issues using tools knowledge and experience
- Participates in upgrades to CA database suite and IBM database suite.
- Business Analyst / Program Analyst tasks
- Facilitated requirements gathering and planning sessions
- Translated business requirements into functional requirements
- Participated in data mapping sessions and provided analysis on data integrity issues
- Developed data schemas for use by database administrators
- Performed analysis and design for documenting and understanding reporting requirements
- Created ad-hoc and metrics reports
- Built, modified, and managed tables as well as entire relational databases
- Coordinated 12-month migration and release testing schedule
- Worked with stakeholders as necessary to development risk mitigations
- Responsible for assigning and managing change controls
- Developed processes and procedures to ensure the most efficient/effective implementation of requirements
- Responsibilities included analysis, design, development, maintenance and testing of and IBM mainframe-based package
- Coordinate physical changes to mainframe databases; and codes, tests, and implements physical database
Confidential
Database Analyst/Programmer
- Responsible for IBM DB2 database development, implementation, and maintenance in support of project developers
- Installation of third-party software
- Responsible for Corporate Data Repository
- Data conversion formats
- Responsible for design, coding, testing and implementation of database and database structure.
- Utilized skills in performance and tuning, DASD management and problem solving.
- Developed online CICS programs and batch COBOL programs and enhanced out dated programs
- Created databases and maintain all maintenances jobs using IBM utilities.