SUMMARY:

• Over 11+ years of diverse IT experience.
• Extensively worked on various profiles which include End to End Delivery on..
• Database Development
• Database Administration
• Confidential - DWH
• Data Modelling/Architect
• BI / Data Analysis
• Migration
• Data Governance
• Performance Tuning
• Automation Testing
• Deployment Strategies
• DB Team Lead
• Scrum Master

COMPETENCY:

• Data Quality Management
• NoSQL DB
• Agile Delivery Foundation
• Oracle Platform Architecture Oracle Database and Oracle PLSQL
• Business Data Warehousing
• EDM Data Architecture and Modeling
• Digital: BigData and Hadoop Ecosystem MapR
• Lean Six Sigma (LSS)
• Integrated Quality Management System (iQMS)
• Software Security Assurance

SKILL:

Databases/RDBMS: Oracle, PostgreSQL, SQL Server

Confidential: Informatica Powercenter, Datastage, WTX

Data Modeling: TOAD, Kimball, Erwin, Power Designer

BI Tools (Open Source) : Pentaho, SepgoBI

Performance & Testing tools: OEM, IBM RIT, Jmeter

Languages: Oracle PLSQL, Postgres SQL, XML, Jason, C, HTML, CSS, JAVA

Development Tools/ IDEs: TOAD, Oracle SQL Developer, PLSQL Developer, PostgreSQL, Oracle APEX,IBM FileNet, Migration Tool, XManager, PUTTY/WINSCP

Methodology: Agile, Waterfall

Operating Systems: Windows, UNIX and LINUX

Version control and Build: GIT, SVN, CVS, Jenkins, CI/CD Pipeline, CDAAS

Defect Tracking Tools: ServiceNow, HP Service Center, JIRA. Issue Tracker

Domain: Banking and Finance (NL), Insurance (USA/UK), Taxation (MEA)

PROFESSIONAL EXPERIENCE:

Database Developer

Confidential

Responsibilities:

• Implementing the data model required by the application
• Design and Manage schema objects and implementing rules for data integrity
• Writing PL/SQL subprograms like Package, Procedure, functions, Triggers, Dynamic SQLs
• Perform SQLLOADER, DATAPUMP
• Analysis and Tuning application code
• Creating the application interface with the chosen development tool
• Establishing a Globalization Support environment for developing globalized applications
• Instantiating applications in different databases for development, testing,, and deployment in a production environment
• Choosing a programming environment for a new development project
• End to End Deployment
• Working understanding on APEX
• Perform Unit test
• Performed application/database migration from legacy to target system

Database Administrator

Confidential

Responsibilities:

• Installing, upgrading, and patching Oracle Database software
• Designing databases, including identifying requirements, creating the logical design (conceptual model), and physical database design
• Creating Oracle databases
• Designing User access policies
• Developing and testing a backup and recovery strategy, backing up Oracle databases regularly, and recovering them in case of failures
• Configuring the network environment to enable clients to connect to databases
• Managing database Instance
• Managing storage for the database
• Managing users and security
• Managing database objects such as tables, indexes, and views, Partitions, Materliazed views
• Monitoring and tuning database performance
• Monitoring Database Sessions activities
• Investigating, gathering diagnostic data for, and reporting to Oracle Support Services any critical database errors
• Evaluating and testing new database features
• Experience with ASM, Data Guard,
• Expertise in analyzing Database ADDM, AWR, ASH, SQLplan reports

Confidential

Responsibilities:

• Involved in assisting the development for data movement, data quality, data cleansing and Confidential -related activities.
• Sharing technical knowledge of Extract/Transform/Load ( Confidential ) solutions for BI projects
• Documentation of all technical and system specifications for all Confidential processes and
• Perform unit tests on all processes and prepare required programs and scripts.
• Worked closely with Business Analyst to ensure the end to end design of business requirements
• Developed the task plan for Confidential developers for a specific project
• Performance tuning and troubleshooting issues
• Ensure the Confidential delivery as per design guidelines
• Unit testing Confidential code
• Review of Confidential design documents
• Hands on with MDM, change data capture (SCD), key generation and optimization
• Develop all data warehouse models and prepare reports for all meta data integration
• Close Onsite communications and co-ordination with clients
• Perform data mapping using templates, data validation, data manipulation, data analysis use cases.
• Plan and build roadmaps for the future of the Data integration
• Develop Unit Test/ Function test using IBM RIT Tool
• Define test and deployment strategies

Database Team Lead

Confidential

Responsibilities:

• Ensure database is developed in line with business requirement
• Ensure team has clear understanding and encourage team to take an active role in the project
• Drive the project team for on time delivery
• Lead the design, planning and execution validation activities
• Maintain team collaboration
• Organize any necessary meetings to progress team work (weekly, daily, or ad-hoc as appropriate)
• Manage escalation activities and organize discussions to address issues
• Define and manage team structure and associated modifications
• Assign team responsibilities
• Manage delivery of the agreed roadmap items, specifically as applies to the project and outlined within the charter.
• Monitor progress and manage risks to and recovery of any schedule slippages
• An ability to work well with people from diverse backgrounds

Scrum Master

Confidential

Responsibilities:

• Facilitate Scrum Collaborations
• Find methods to effectively manage the product backlog
• Help communicate the Product owner's expectations to the project team
• Arrange and optimize product backlog
• Organize scrum events as necessary
• Educate team to adopt of Agile way of working