SUMMARY

• Oracle Certified Professional (OCP) and Tuning expert having 16 yr’s experience on medium to large - scale global project in Finance, Telecom, Retail and Insurance domain
• Core work experience in programming on Oracle SQL, PL/SQL, Unix Shell Scripting, Data modeling, Analysis, Scheduling, Monitoring, Batch Processing, Release & Deployment management
• Proficient in analyzing and translating business requirements to functional or technical requirements into solution blueprint
• Proficient to use Toad Data Modeler database design tool to visually create, maintain and document new or existing database system’s ER Diagram for Data Warehouse/ Data mart
• To identify project requirements and develop/deliver high-quality solutions to clients in response to varying business needs under Agile methodology in Agile environment
• Proficient in entire SDLC from Business Requirement, FRs, SRs, POC, ADD, Development to implementation with emphasis on programming in Oracle SQL, PL/SQL for schema, table and other DB objects creations like Package, Procedure, Functions, Trigger, Cursor etc.
• Expertise in using Oracle 9i/10g/11g/12c Enterprise edition
• Extensive experience in Oracle PL/SQL and Unix Shell Scripting
• Proficient in related tools like Toad, PL/SQL Developer, SQL Developer, Toad Data Modeler
• Proficient in query optimization and troubleshooting
• Experienced in basic BO server administration on Windows/Unix platform e.g. user management, access management, release management etc.
• Implementing ETL codes and process flows with various PL/SQL blocks and shell scripts to trigger ETL automatically and scheduling through Crontab, Autosys, Control-M
• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and written communication skills
• Measuring various SLA (Service Level Agreement) metrics for Environment and Configuration team and taking corrective action plan during LAM (Look Ahead Meetings)
• Extensive experience with analysis, design, development, customizations, Build, Deployment and implementation of software applications using agile methodologies
• Effective in meeting with BU, stakeholders and subject matter experts for eliciting requirement and translating those needs into concise functional and non-functional requirements
• Maintain a sense of pride in a job well done; detail-oriented, professional, and self-directed
• Thirst for knowledge and how to apply learning to address current company projects requirement
• Problem-solving skills and the ability to think out of the box
• Coordinate between development team and testing teams to ensure quality gates and right method followed by project team
• Data Analysis for OnLine Transaction Processing (OLTP) and Data Warehousing (OLAP) applications
• Sound understanding of the Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• Expert on Data Modeling - Conceptual, Logical, and Physical Data Models
• Experience in Extracting, Transforming and Loading (ETL) data from spreadsheets, database tables and other sources using Informatica
• IBM DB2 Database Experience, modified procedure, functions and Modules to meet requirement

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g/9i/8i, MS Access, MDM, DRM, IBM DB2 10.5

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, C and Cobol

Development Tools: TOAD, PL/SQL Developer, SQL Developer, Oracle Enterprise Manager, SQL*Plus,, PuTTY, WinSCP, AFT-SWM

Data Modeling Tools: Toad Data Modeler, Software Engineering and Architecture (SE&A), Rational Software Architect (RSA) 9.0, Rational Portfolio Manager (RPM) 6, Rational Team Concert (RTC) 6, Informatica 7.1, MS Visio

Oracle Utilities: SQL*LOADER, UTL FILE, Data Pump (Export/Import)

Operating Systems: Windows 2003/XP/7, HP UNIX, Linux, Sun Solaris

Version Control & Migration Software: Visual Source Safe, SVN, Jira, HP Service Desk, Quality Centre, CM Synergy, Change Synergy, SM7, iTrack, Gitlab

Production Job Scheduler: Control-M, Crontab, Autosys, Net Term/Tivoli Maestro/CONMAN/COMPOSER7.0

PROFESSIONAL EXPERIENCE

Confidential, Nutley, NJ

Production Support Lead and PL/SQL Developer

Responsibilities:

• Develop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as needed
• Develop new DB objects like stored procedures, functions, packages, indexes, views, sequence, triggers, cursors and modify existing SQL or objects
• Understand end-to-end Data flow and data integration rules
• Maintaining the integrity rule of Business processes by changing the database objects
• Challenges the BA on defined BRD and writing trampled functional/technical requirement
• Understand the data and reverse engineer with business stakeholder
• Abstracts the complexity of a system into a manageable model that describes the essence of a system by exposing important details and significant constraints
• Leading the team of 5 EP resources and have extensive experience of working closely with Clients from various client locations of USA and Liaison between RDC offshore team and onsite team
• Responsible for establishing data modeling best practices for advanced analytics, multivariate analyses, business intelligence, data management, and forecast analytics
• Create database tables, indexes, views, triggers and other objects in development environment

Confidential

Lead PL/SQL Developer

Responsibilities:

• Participate in all phases of the Software Development Process including design, development, testing, deployment and maintenance
• Develop new DB2 objects like stored procedures, functions, views, sequence, triggers, cursors and modify existing SQL or objects
• Develop DB2 stored procedures, functions and SQL statements which will be used by client's Planning Systems applications
• Design and develop conceptual, logical and physical data models for Manual Order and eCom replenishment for both Oracle and DB2 Database
• Used Toad Data Modeler to create logical, physical and universal Entity Relationship Diagrams (ERD) - models for Oracle and DB2 Databases
• Existing databases reverse engineered into Toad Data Modeler models and displayed as Entity Relationship Diagrams (ERD)
• Have designed upgrade/modifications of existing schemas as per business requirements and applied the appropriate constraint to maintain the data integrity
• Collaborate with other DB2 developers and DBAs to promote changes from development environment to QA and UAT environments
• Work closely with .NET developers to ensure a smooth integration of front-end and back-end parts of applications and setup test data
• Coordinate between development team and testing teams to ensure quality gates and right method followed

Confidential

Programmer Analyst

Responsibilities:

• Understand end-to-end Data flow and data integration rules, standardize and cleansed data
• Design and develop conceptual, logical and physical data models for data marts
• POC for Trillium job stream used for cleanse, parse, geocode, generate window key
• Redesign of Pre-merge which handles exact match and merge process which handles fuzzy duplicates by creating Fact and Dimension tables for AIME data mart
• Code changes to fix split household issue and introduce mapping table to keep track of changes
• Through analysis of many complex packages and modified to improve the performance
• Design solutions to complex problem with an emphasis on efficiency, quality, and simplicity
• Ability to lead a diverse team with different skill level and background challenged with complex task
• Created oracle objects like Tables with appropriate constraints, Views, Indexes, Sequences etc.
• Peta-byte scale datamart tuning through AIME for campaign management / merge management
• Additional DBA responsibilities like debugging performance bottleneck and tuning the sequel by using latest analytical function
• Developed various anonymous PL/SQL blocks and named PL/SQL blocks like procedure, function, trigger, cursor and packages as per need basis and tuned the underlined sql
• Used Toad Data Modeler to create logical, physical and universal Entity Relationship Diagrams (ERD) - models
• Existing databases reverse engineered into Toad Data Modeler models and displayed as Entity Relationship Diagrams (ERD)
• Co-ordinate with DBA team for physical implementation
• Have designed upgrade/modifications of existing schemas as per business requirements
• Used SE&A for architecting new schema from scratch and reverse engineering to connect to DB
• Responsible for establishing data modeling best practices

Confidential

Lead PL/SQL Developer

Responsibilities:

• Responsible for data analysis/reconciling gap for missing data elements between CDB and RDR
• Modified DB objects like procedure and table to make it fit as per Legal Entity Allocation process
• Designing new tables and appropriate constraints on Oracle 11g database
• Maintaining and Creating new DB objects like tables, procedure, function, trigger, cursor and packages as per need basis using PL/SQL
• Modified CDB Expense Code table and all areas where expense code data is displayed or entered (e.g., Statement Templates screens, Chargeback screens, Reports), as well as any internal CDB batch processes/updates
• Modified/migrated entire Merrill Lynch code from old legacy system to new e-ledger Central DB
• Analyzes source data files to layout to develop data conversion requirements
• Ensures all required data elements are being received after conversion
• Develop DB report as per client requirement and help to integrate them with UI
• Regularly working on Various Data analysis requests and producing reports
• Automated the Batch loading reports using tools like Autosys to create .jil file
• Prepares initial Data Conversion File request and schedule for receiving data files using Autosys
• Improve the process without impacting existing applications by tuning
• Partners with data conversion/platform configuration team to identify specific scenarios in order to ensure quality
• Participates in internal testing and review of data/configuration
• Defines data edits that should be run to validate accuracy of data received
• Have to coordinate with UI team to understand the PL/SQL requirements and develop objects