We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

5.00/5 (Submit Your Rating)

SUMMARY

  • Highly accomplished Business Analyst with over 7 Years of managing complex IT, Financial and Retail projects. Practiced in clarifying business requirements, performing gap analysis between goals and existing procedures/skill sets, and designing process and system improvements to increase productivity and reduce costs.
  • Extensive experience in formulating cash flow analysis, project financing, risk management, business incubation solutions for financial firms and international organizations. Recognized project management skills, constantly deliver complex, large-scale projects on time and within budget.
  • Additional areas of expertise include: SAP SME, Change Control Management, Training Operations Team, Project Risk and Scope, Monitoring and Evaluation.
  • Excellent skills in Business Analysis, OO Analysis, Data Analysis, Data Mining, Data Warehousing, Data Mapping, Requirement Analysis, Business Modeling and Proficient in customizing workflows, activities and deliverables ofexisting business practices.
  • Skilled in determining system requirements and specifications for complex application development projects of Finance Companies emphasis on User Requirements and Functional Requirements through JAD sessions and user interviews.
  • Developed Use Cases/diagrams, Conceptual Model, Behavior diagrams for transportation and billing software.
  • Experienced in creating requirement documents, use cases and test plans.
  • Highly experienced in developing Object Oriented Analysis and Design Models:
  • Use Case Model, Analysis Model and UML.
  • Extensive knowledge of Project Life Cycle PLC , Software Development Life Cycle Process, Agile Unified Process, RUP,Waterfall Software Development Model, Gap Analysis, Project Status Reports, Creating Work Progress Schedules
  • Extensive Documentation Skills for use in Standardization of Testing and Programming Procedures and Guidelines.
  • Experienced in preparing Test Documentation, Test Plans, Test Scenarios, Test Cases and Software Requirement Specifications, Integration Test Specifications and Test Scripts.
  • Utilized Mercury testing tools: Win Runner and Test Director during testing and debugging phases of projects.
  • Ability to perform business analysis, cost benefit analysis and meet user needs and revise system specification.
  • Experience in the development of Business Process Model, End user training and Documentation.
  • A versatile team player with strong business, analytical and communication skills.
  • Experience in gathering and analyzing business requirements for conceptual design and coordination with SAP ABAP/4 development team for customization and implementation of the same.
  • Worked with the SAP BI development team on many Reports like Finance Master Record Report, HR Master Record Report, Monthly Overtime Report, PR Christmas Bonus Report etc.
  • Worked in Production Support team to resolve critical issues.

SKILLS

  • Business Analysis Tools MS Visio, Requisite Pro
  • Modeling Tools Rational Rose, UML
  • Testing Tools Test Director, HP Quality Center, Win runner
  • Databases MS Access, Oracle 9i, SQL server, MySQL, SAP ECC 6.0.
  • Disciplines SDLC, Rational Unified Process RUP , Joint Application Development JAD sessions, Object Oriented Analysis and Design OOAD , Waterfall, Agile, RAD, Prototyping, Business Modeling, Data Modeling, Change Control Process.

EXPERIENCE

Confidential

  • Performed feasibility, adaptability study and risk analysis to identify the business critical areas from USER perspective.
  • Followed a structured approach to organize requirements into logicalgroupings of essentialBusinessProcesses, BusinessRules, and InformationNeeds, thus ensuring that CriticalRequirements are not missed.
  • Gather, analyze and document business requirements by conducting face to face interview session with the business users.
  • Developed requirement reports for day-to-day retail banking needs for opening account, online banking, Credit cards using rational SoDA.
  • Worked with the SQL developers to optimize the SQL queries and stored procedures.
  • Work with the offshore development team to ensure that they understand the functional specifications. Facilitated brainstorming and walkthrough sessions for Use cases.
  • Architecture definition, design of the process flow and data modeling.
  • Creation of the static prototype based on the BRD document.
  • Business process mapping of the ERP system.
  • As a liaison between the developers and management, was instrumental in resolving conflicts between stakeholders and technical development teams.
  • Collaborated with developers as needed to determine the root cause of defects, report software bugs and re-tested the fixed issues.
  • Documenting the use cases, Unit Testing and System Testing.
  • Maintained test matrices on various dimensions like client and test status to reflect the test progress.
  • Continuous interaction and presentations with the end-users.
  • Organized program leadership meetings for the top management to discuss the issues, risks and assign actions to specific work stream owners.
  • Facilitated meetings with clients, brokers and a group of business partners to identify the needs and requirements of the new system, prioritized and organized these requirements in a systematic order, evaluated and compared potential solutions.

Environment: CRM, MS Visio, MS Project, Rational Rose, HP Quality Center.

Confidential

  • Provided critical input on Business / Functional Requirements during walkthrough sessions.
  • Built mock up html screens as POC to show the future functionality.
  • Involved in preparing project plans and identifying major milestones for each stage as per the SDLC model RUP Methodology .
  • Worked on IAM Identity Access Management comprising of four main components namely, Authentication, Authorization, User Management and Central User Repository.
  • Co-author business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
  • Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing and Loan Monitoring.
  • Facilitated JAD Joint Application Development sessions to identify business rules and requirements with Business Teams. Then documented them in a format that can be reviewed and understood by both business people and technical people.
  • Developed and implemented processes and tools for requirements gathering, Analysis, planning, tracking and delivery using Rational Rose requisite pro RUP
  • Develop reports using Crystal Reports to transform data into meaningful information.
  • Coordinated activities between business unit and technical staff, developing new methods, policies, and procedures to meet the business needs.
  • Conducted workflow, process diagram to derive requirements for existing systems enhancements.
  • Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
  • Constantly monitored the compliance to SOX 404 requirements.
  • Organized cross training of team members and Users to become more responsive.
  • Assisted the Project Manager with various additional activities like creative problem solving, updating documents, making presentations on power point, scheduling, budgeting and Tracking of the project life cycle with Team Track.
  • Wrote extensive SQL queries to retrieve information from the SQL Database Server.
  • Assisted in the development of quality assurance artifacts including: Quality Assurance Plan, Product Acceptance Plan, Test Plan, Test Case
  • Validated UAT and Production Entitlements requests for the Business and data migration tasks for post-production.

Environment: UML, MS Visio, MS Office MS Excel, MS Word, MS PowerPoint , SQL.

Confidential

  • Conduct workshops with all external Interface vendors, point solutions in implementing a global deployment.
  • Responsible for continuous process improvement and for identifying and maintaining a clear and measurable Development Process that is deployable throughout the enterprise using RUP.
  • Communicated extensively with the clients and with different levels of management to identify requirements, use cases and to develop functional specifications.
  • Acted as a facilitator in JAD sessions to analyze and prioritize competing business needs.
  • Circulate the business requirements document to the stake holders and get their sign off.
  • Demonstrated excellent technical writing skills by developing Business Requirements Document BRD and Functional Specifications Document FSD .
  • Acted as a liaison between development team and end-users during various SDLC phases.
  • Conducted User Acceptance Testing UAT .
  • Was Involved in testing and Reports Security using different Roles ESS, MSS etc.,
  • Worked on E-Case a Third Party tool to SAP Sync and thereby to resolve the Critical Production Support Issues.
  • Reviewed and estimated the work effort for DuPont EMEA Leave Types and Leave Reasons for 11 countries.
  • Developed Test Plans, Test Cases and Prepared test data for interpreting the positive/negative testing.

Environment: SAP HR, Rational Rose, MS Visio, MS Project, SAP ECC 6.0, Solution Manager, HP Quality Center.

Confidential

  • Interacted with Subject Matter Experts in the Fixed Income Group, Portfolio Managers, Investment Advisors, Share Holders and IT Group Heads such as Project Managers, Developers, and Process Analysts to comprehend the business process, Business Requirements.
  • Prepared graphical depictions of Narrative Use Cases, Use Case Diagrams, Activity Diagrams, Sequence Diagrams, using MS Visio.
  • Conducted walkthroughs for High level requirement and Use Case Walk Through to discuss line areas on data, technology and application integration issues with the Business team, Architecture, Design team and development team.
  • Performed JAD sessions to collect needs for Credit Suisse Mortgage Backed Security order management systems trade repositories.
  • Described Business laws for the universal Compliance Engine, the Credit Suisse proprietary trade compliance engines.
  • Captured business requirements through JRP and JAD sessions, interviews of brokers and traders, surveys, controlled brainstorming sessions, prototyping and conducting JRP session with the management groups, vendors, users and the IT Group for open and pending issues to develop specifications.
  • Carried out UAT by developing test plans, test scenarios, test cases, test data to be used in testing based on business and user requirements, technical specifications and/or product knowledge.

Environment: MS Office, MS Visio, MS Project, SQL, Oracle, Load Runner, Quick Test Pro, Unix,

Confidential

  • Generated Business requirements for the application using Requisite Pro and integrated with Use Cases.
  • Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the users to upgrade or change the business specifications for the application.
  • Associated, change requests throughout the development cycle, in relevance to requirements using traceability matrix, thus mapped these changes with appropriate relationships with other requirements.
  • Documented business process workflows for user's review.
  • Documenting High and Detail level requirements, Test plans, Test cases, Test summary reports, determine test needs, test environment, test data, Installation, Troubleshooting procedures.

Environment: MS Visio, MS Project, Rational Rose, HP Quality Center. Java, JSP.

Confidential

  • Associated, change requests throughout the development cycle, in relevance to requirements using traceability matrix, thus mapped these changes with appropriate relationships with other requirements.
  • Produced the visual models for the various business processes for the application using Rational Rose to create Use Cases, sequence diagrams and activity diagrams.
  • Preliminary design of physical and logical diagram for Database.

Environment: MS Project, Rational Rose, J2EE, MS SQL Server, JavaScript, HP Quality Center.

We'd love your feedback!