We provide IT Staff Augmentation Services!

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

Hire Now