SUMMARY

• Oracle Certified Professional (OCP) and Tuning expert having 16 yr’s experience on medium to large - scale global project in Finance, Telecom, Retail, Insurance and Entertainment 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
• 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/10, 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, Lyndhurst, NJ

Lead PL/SQL Developer

Responsibilities:

• Maintain PFS, RLS, CMS, EMEA and APAC instances and debug the RCA for Pre-Pack B & R PO/ ASN, physical inventory related issue and provide the functional or technical resolution
• Debug & maintain Class, Vendor, Style, Color, Size and location related issue of each inventory
• 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
• Existing databases reverse engineered into Toad Data Modeler models and displayed as Entity Relationship Diagrams (ERD)
• Fix the issue related to daily cyclic job, nightly batch job and monthly batch job failure
• Abstracts the complexity of a system into a manageable model that describes the essence of a system by exposing important details and significant constraints
• Coordinate between development team and testing teams to ensure quality gates and right method followed
• Managing the team of 5 resources and have extensive experience of working closely with Clients from various client locations of USA, EU, APAC

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
• 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
• Develop robust SQL statements and optimize them for maximum performance by analyzing the execution plan and changing them as needed
• 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

Confidential, PA

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
• 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