Sql Developer Resume
SUMMARY
- 9+ Years of total IT experience.
- Hands on experience in Software Design, Development, Implementation and Testing of Applications in AS/400.
- In depth knowledge in Retailing Industry.
- Proven track record in fixing issues real time with immaculate accuracy.
- Strong analytical skills combined with excellent problem solving and programming techniques.
- 7.5 years of experience as AS400 developer with strong skills in RPG/400, RPGILE and Control languages.
- Excellent experience in developing applications in RPG/400, RPGLE, RPGILE, RPG Free.
- Experience in developing the applications using MQ series.
- Worked on the various I - Series tools like ROBOT, Implementer, Hawk-Eye and ALDON
- Good understanding and knowledge on DB2/400, SQL/400 and Query/400.
- Acted as key liaison between Business and developers in different projects.
- Involved in developing data-flow-diagrams using MS Visio for power point presentations and used in project documentations
- Good knowledge in using the scheduling tools like UC4 and Robot Scheduler
- Good understanding of IFS and shell concepts
- Strong Knowledge of Retail Merchandizing Systems (RETEK),PKMS
- Involved in gathering business requirement and designing functional specifications.
- Participated in discussions with Project Manager, Business Analysts and Team Members..
- Strong experience in SQL, PL/SQL for coding Stored Procedures, Functions and database Triggers.
- Experience in writing SQL Queries for different Data Bases very efficiently.
- Experience in writing UNIX shell scripts (k shell, Bash) for file and process manipulations.
- Experience in using IBM rational suit like Clear Case for versioning and Clear quest for Change management process in the organization. Also has experience in VSS (Virtual Source Safe).
- Strong analytical, problem solving skills, excellent communication and interpersonal skills.
- Proficient in using Microsoft Visio, Word, Power Point and Excel.
- Experience in working with offshore/onsite teams and provided 24*7 on call production support.
- Experience in managing an offshore team from India.
- Involved in requirement analysis, Business analysis, Use-case analysis, change management and configuration management.
- Writing high level Test Plans and Test cases based on the baseline requirements.
- An excellent team player with highly favourable interpersonal and Communication skills.
TECHNICAL SKILLS
Languages: RPGLE, SQL/400, CL, MQ Programming in AS400, SQL, PL/SQL, UNIX Shell Scripts
Database Tools: DB2/400, SQL Loader, SQL developer, DB2 command center
Operating Systems: OS/400, Windows 2003/NT, UNIX-AIX
Application/Tools: Visual SourceSafe, Remedy Action Request System 7.0, Change Management, Adobe Photoshop, Adobe Acrobat, Microsoft Project, Visio
Software’s Used: RPGLE, RPG Sub-files, RPG/400, SQL/400, RPG, CL, AS400 Tools (Hawkeye), AS400 Utilities(DBU), MQ Programming in AS400, Configuration Management Tool (Implementer), Unix Shell Scripting, SQLs in DB2,AS/400, Job and Robot Scheduler, UC4, Clear Quest
PROFESSIONAL EXPERIENCE
Confidential
SQL Developer
Responsibilities:
- Development of Business Reports.
- Analyzing and designing changes for enhancements to existing system
- Enhancements for creating feed jobs to different systems.
- Creating SQL queries and providing user reports
- Requirements and Design for various modules (pricing, third part systems etc.)
- Designing changes for replacing the dept/class hierarchy with the customer centric hierarchy.
- Enhancements for creating feed jobs to different systems.
Confidential
SQL Developer
Responsibilities:
- Review of the design and programs
- Co- ordinate implementation planning and implementation execution activities with offshore
- Defect tracking and closure from onsite
- Providing support during cut over and Go - live Post Go- Live support activities
Confidential
SQL Developer
Responsibilities:
- Review of the design and programs
- Co- ordinate implementation planning and implementation execution activities with offshore
- Defect tracking and closure from onsite
- Providing support during cut over and Go - live Post Go- Live support activities