SUMMARY:

• Scrum Master and Senior Database Developer, with 12+ years’ experience in analysis, requirements gathering and stakeholder management seeking a challenging position, to be accorded an opportunity, to apply my expertise, while contributing to the growth of the company. Along with Database Developer role I have also worked as a SCRUM master carrying out all the AGILE ceremonies. I also have an experience working as a Technical Analyst, Application Support Analyst and Developer in my 12+ years of IT Career. Customer oriented and possess real drive to succeed .
• Full life cycle analysis and documentation, with expertise in writing Business Requirements Document, Use case Document, Training Manuals, User Stories and Functional specifications documents
• Proficient in translating business requirements into logical data models, creating modularized enterprise applications and hands on experience as Module Lead in various projects.
• Extensive experience in Application releases, analyzing results, database development, report writing and creating client ready presentations.
• Effective management of stakeholder relationships at all levels of the business. Project governance, including day - to-day management and resolution of risks, defining new processes, resolving issues and dependencies.
• Extensive experience in process management and reverse engineering. Facilitation of interactive sessions with stakeholders to gather requirements and subsequently obtaining sign-off on the approach.
• Preparation of project documentation and presentations from a functional perspective for all the stake holders during different phases of the project and remaining an integral part throughout the SDLC.
• Full project lifecycle experience in AGILE and WATERFALL environments.
• Experience as a SCRUM master carrying out AGILE ceremonies.
• Have experience in various phases of SDLC, including Designing, Development, Testing and Production Support using Oracle SQL, PL/SQL, and UNIX.
• Outstanding time management skills, with the capability to prioritize multiple tasks
• Ability to build strong rapport with clients from a diverse range of backgrounds
• Ability to achieve challenging deadlines
• Ability to work as part of a team or independently,
• Friendly, professional and enthusiastic disposition

TECHNICAL SKILLS:

Process Skills: Agile Methodologies, Business system Analysis, Requirement Analysis, Project Estimation, Incident Management

Programming Languages: Oracle PL/SQL, Microsoft SQL Server, UNIX, Perl Script

Database Systems: Oracle all flavours, SQL Server 2005/2008 (SSIS)

Tools: Confidential, JIRA, Visio, Visual Studio, SQL Server Management Studio 2008, Toad, PL/SQL Developer, HP Service Centre, GIT Stash, Jenkins / Udeploy

PROFESSIONAL EXPERIENCE:

Senior ETL /Database Developer

Confidential

Responsibilities:

• Requirement elicitation from the Legacy Services and stakeholders
• Provide preliminary cost estimation and ball park estimation for the SWR(Small Work Request)
• Ensured all the legacy Perl processes were successfully migrated into Informatica workflows using PL/SQL and Autosys jobs.
• Impact analysis of the requirement on the existing functionality
• Act as a Liaison between the Business users / stakeholders and the scrum teams
• Demo to the customer/tech teams
• Documentation in confluence - Project overview, Functional details, technical details, in scope, out of scope, assumptions, risks, issues/impediments, dependencies, user wire-frames and mock up screens etc.
• Appreciated by the onsite manager for conducting walkthrough sessions of POCs and various enhancements for the clients/ stakeholders, which facilitated early sign off.
• Defined strategies to mitigate potential risks in case of inconsistent behaviour by the processes. Appreciated for remediating Perl in critical client reports.
• Appreciated by the stakeholders for pro-active approach and coming up with different matrices and analysis reports to close out gaps at the earliest.
• Appreciated immensely by stakeholders for overcoming all bottle necks and avoiding possible delays. Instrumental in sticking to the allocated budget and within the project schedule.

Scrum Master

Confidential

Responsibilities:

• Requirement elicitation from the CommBiz stakeholders
• Base lining the systems existing behavior
• Impact analysis of the requirement on the existing functionality
• Provide preliminary cost estimation and ball park estimation for the project / change
• Act as a Liaison between the Business users / stakeholders and the scrum teams
• Demo to the customer/tech teams
• Documentation in confluence - Project overview, Functional details, technical details, in scope, out of scope, assumptions, risks, issues/impediments, dependencies and mock up screens etc.
• Worked as a bridge between Legacy Teams and ESP, to help convert their reports to a Datawarehouse platform
• Ensuring the team follows agile principles and scrum methodology
• Facilitate all scrum practices:
• Backlog grooming with product owner
• Sprint Planning
• Daily Huddles
• Scrum of Scrum meetings
• Sprint Review (Showcase business value/functionality delivered in the sprint)
• Sprint Retrospective (What went wrong - Remediation plan & What went right)
• Maintaining scrum board and ensuring all impediments / blocking issues for scrum team is resolved thereby enabling the completion of a successful sprint
• Tracking of user stories to completion via Confidential
• Appreciated for putting in place few time-saving processes for performing sanity check on the application to facilitate early sign-off post implementation.
• Achieved Bronze Status for the Agile Team
• Successfully delivered migration of Data from Legacy tools like Calgine/Paladyne(Excel based tools) into Datawarehouse environment using ESP (Datawarehouse Tool)
• I was the only consultant Analyst onsite from the Functional Support team during the implementation weekends where time constraints were very crucial. I was able to complete the validation of the reports well ahead of time and recommend the sign off.

IT Consultant/Senior Oracle Developer

Confidential

Responsibilities:

• Gathering system requirements through client interactions
• Provide business solution for the new enhancements.
• Work with Developers and Support team to implement changes in a timely manner.
• Support of the daily business queries related to the application.
• Extensively involved in writing SQL queries PL/SQL programming
• Involved in Unit Testing and Code Deployment
• Provide weekly status reports to various project stakeholders and senior management.

Lead Developer

Confidential

Responsibilities:

• Analyses and discuss the business requirements with the clients.
• Work with Business Analyst and Business Objects teams to get brief idea about requirements and translate the requirement into technical specifications.
• Worked in Agile Environment as an Oracle Developer to fine tune and optimize the queries in resolving the defects.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created Partition/Sub-Partition and materialized views to enhance the performance.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and SQL*TRACE
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Created Archival process for high volume tables.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developed Macro Enable Excel to validate all the rules and populate into all the respective tables by oracle procedure in Database.
• Worked on Decryption and Encryption of NPI data.
• Created FGA (Fine Grained Auditing) policies for NPI columns.
• Created VPD (Virtual Private Database) to control the database row and column level.
• Created the exchange partition to move the 100 million records to partitioned table.
• Worked on Shell scripts to call the package from Autosys.
• Co-ordination with offshore, DBA and IIS admin and UAT Support
• Co-ordinate between all internal and interfacing teams for various phases of testing.
• Manage Production implementation of the project.
• The project exceeded processing time objectives by reducing COB processing time by 60% along with improvements in many other metrics.
• On the spot award for best coding practices and timely project delivery

PL/SQL Developer

Confidential

Responsibilities:

• First point of contact for Business users
• Liaise between Business and Development teams for requirement gathering, SIT and UAT co-ordination.
• Manage application outages for maximum availability and data accuracy. Articulate impacts of issues and changes on Business Functions, prepare recovery strategies and timelines.
• Manage a technical team of 4 to provide Operations and Support round the clock.
• Build, Test and Implement small business requirements and BAU changes.
• System Performance Monitoring, Optimization, Capacity Planning and Reporting.
• Scheduled and participated in code walkthroughs.
• Successfully planned and executed database migration programme.

Software Developer

Confidential

Responsibilities:

• Collecting complete business requirements
• Design and development of software
• Database designing.
• Unit testing and bug fixing
• Creating deployment packages
• Writing software manual and installation guide
• Deployment and maintenance of the application
• Maintaining different environments
• Application third level Support
• Conducting training for the installation and support of software.