SUMMARY:

• Overall 12+ years of work experience in Oracle development projects (Primarily Oracle PL Sql, Oracle forms development, Big Data/Hadoop development, design, administration, engineering Oracle solutions as data analyst cum ETL developer).
• Awards: Extra miler award winner in ‘R’ system international Ltd and at Xpanxion LLC, Atlanta).
• Design Tools: Experienced in using Enterprise architect tool V.11, Visio, Erwin, Data Modeler to draw IT architecture design, ER modeling of OLTP, OLAP database system.
• Development: Experienced in Migrating Databases, writing advanced Pl/SQL, Shell Scripting, performing Core DBA activities/Administration, performance tuning, Use of Data Pump, SQL*Loader and new features of (10g/11g/12C). Proficient in writing simple and complex SQL, PL/SQL Functions, Procedures and Packages. Expert in creating database objects like Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, UTL FILE, Collections and Analytical queries. Traced errors using Exception Handling (DBMS UTILITY) and DBMS UTILITY.FORMAT ERROR BACKTRACE extensively for the ease of debugging and displaying the error messages in the application.
• DBA activities: Experienced in ORACLE STREAMS, SSIS, Database firewall, Data encryption/masking, Cloud deployment, and Oracle advance security (redaction). Proficient in Performance tuning and Query optimization using Oracle Hints. Explain Plan, Auto trace, TKPROF utilities and understanding of Oracle architecture.
• Domains: Core banking, Financial banking, Media, Insurance and Retail.
• Soft Skills: Possess good interpersonal, presentation and developmental skills with strong analytical and problem - solving approach. Excellent team player. Have ability to communicate effectively with client. Have ability to mentor medium-experienced team.
• Configuration: Experienced with configuration management systems and concepts specifically SVN, Subversion, and VSS.
• Process: Waterfall/Iterative/Agile. Experienced in creating ERDs and understand design concepts. Have experience in contributing at all the stages of SDLC including requirements gathering, design/document, development, testing, implementation, post-implementation support and continuous improvement.
• Standards: Established and followed best practices in performance tuning and troubleshooting. Set DB standards across organization and participated in EQA reviews.
• Review: Reviewed PL/SQL code, prepared design and provided optimal solutions to team on regular basis.
• Research: Multithreading of Pl/SQL using different techniques, Evaluation of ETL tool finalization.
• Project Management: Planning (MPP & Tailoring), Monitoring, Controlling, Proposal writing, Estimation (WBS/UCP), Skill development, Interviewing of associates and customer requirement. Participated in quality audit, Risk/ escalation management and contingency plan etc.

TECHNICAL SKILLS:

Operating Systems: Windows NT\2000\2003\2008, Unix AIX 5.0\HP-UX, Linux, Solaris

Programming Languages: SQL, Unix Shell scripting, PL/SQL, Forms/Report 11g

BigData NoSQL: Hadoop CDH3\4\5, HDFS, MongoDB

BigData Ecosystem: Impala, Hive, Pig, Sqoop, Spark, Flume, Oozie

Databases: Oracle 9i\10g\11g\12c, MySQL 5.1.28

ETL\ELT Tools: Informatica 9.5\8.1\7.1\6.2, Oracle Data Integrator 10g\11g, Oracle Warehouse Builder 11g,SSIS

Middle layer: WebLogic 10.2

Schedulers: Autosys, ControlM, OEM, Crontab

Data Modeling Tools: Erwin 9.5\7.0, Oracle SQL Data Modeler 3.0, EA

Development Tools: Pl/sql Developer, Toad, Putty, SecureCRT, Form Builder

Others supporting Tools: Eclipse, Visio, Excel, Microsoft Project, PowerPoint, Word, SVN, Jira, putty, SharePoint, WINSCP, ExamDiff, Vmware

PROFESSIONAL EXPERIENCE:

PL/SQL Developer

Confidential, New York

Responsibilities:

• Coordinated with Business teams for gathering the requirements and translate the business needs to convert the legacy data to the normalized data and export to the production.
• Conducted meetings to review the documents with the Business/QA/IT team.
• Provide support to the Business and QA during the Testing phase.
• Involved in writing several Ad hock Queries as per business requirement.
• Created various PL/SQL objects like Stored Procedures, Functions and packages as per business requirements, for multiple stages like Delta and Beta process (Client defined custom process).
• Designed and developed custom database objects which will validate junk data and valid data, based on data results business will take decision further.
• Involved in performance tuning of SQL queries and sent Ref Cursors out in JAVA.
• Worked on design of conceptual, logical and physical data models using various Data modeling tools like Erwin, MS Visio.
• Involved and supported thorough unit testing of all the components and documentation. Supported QA team and business teams by testing and bug fixing the errors/ bugs (which are raised through JIRA ticketing system).
• Created and maintained tables, indexes, materialized views and types in lower environments
• Involved in ETL framework design for inbound/outbound data loads/extracts.
• More than six months of experience in installing, configuring, and testing Hadoop ecosystem components.
• Processed large sets of structured, semi-structured and unstructured data. Supported systems application architecture.
• Assessed business rules, collaborate with stakeholders and performed source-to-target data mapping, designed and reviewed DB.
• Got a chance to create data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling, data mining, machine learning and advanced data processing. Experienced in optimizing ETL workflows.

Technologies: Oracle 11G, Linux, SQL Developer, Toad, XML, Erwin, MS Visio

PL/SQL Developer

Confidential, Chicago IL

• Created stored procedures for Purchase Order, selling, designing and calculating their commission, categorizing greetings as per shelf types, inventory updates and online purchases etc.
• Written PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Involved in preparation of daily, weekly and monthly MIS reports for Finance Teams.
• Tested and debugged Oracle PL/SQL packages.
• Created Oracle objects like tables, types, packages, procedures and functions.
• Explored on Big data Hive, HBase, PIG scripting, Sqoop and MongoDB

Technologies: Oracle 11g, TOAD, Shell Scripts, UNIX, Putty, forms report, Rational tool

Project Lead

Confidential

• Participated in technical brainstorming activity to draw optimal solution and allot team. Planning, Monitoring, Skill development, Capability building, handling escalations, resource management if any
• Optimized Solution evaluation for future use and long term vision for a strong project
• Also involved in PL/Sql development, performance tuning and designing FORMS wherever required

Technologies - Oracle Pl sql, Oracle DB11g R2, Enterprise Architect, Visio, free mind

Senior system analyst

Confidential

Responsibilities:

• Involved in WBS creation, drawing estimations, project plan creation, Update PSR monthly, project schedule, tailoring document preparation, writing WSR, minutes, maintain configuration documents properly, proposal writing as well as solution constructor for the team.
• This project has given me wide exposure of all project management aspects as well as technical knowledge of middle-ware forms/report technology.

Technology - Forms/Report 3.0, 4.5, 6.0, 11g, WebLogic suite, Mantis -(Defect/bug logging), Promise - tracking of project tasks, PSR- project status monitoring dashboard, Toad- Pl/sql development, Forms/Report builder - application developer, Tortoise SVN - Configuration mgmt. tool, DB REPLAY - Load testing

Senior System Analyst

Confidential

• MultiChoice is Media domain company client which is one of the largest media service providers.
• Confidential is one of project which includes bulk sms, Bulk Email facility. My role was to develop complex code in pl/sql, ETL as well as do some administration stuff.
• I was involved as Subject matter expert, Defining coding standard, solving complex query, tuning and multithreading activity on database.

Sr. Pl/SQL developer

Technologies: Oracle Pl/sql 11g R2, ETL, sql*loader, Oracle streams

Confidential, Atlanta

• Responsible in Designing of Logical& Physical Data models, Forward and Reverse engineering using Microsoft Visio and Erwin.
• Worked on Query optimization & Performance tuning using Execution Plan.
• Worked on the queries for improving the load performance in various schemas across databases using appropriate HINTS.
• Reverse engineering with the existing 3NF model and creating for dimensional data model.
• Involved in various phases of Software Development Life Cycle (SDLC) of the application like Requirement gathering, Design, Analysis and Code development.
• Worked on writing PL/SQL in Oracle 11g Database for creating tables, Stored procedures, Functions, Triggers and select statements.
• Worked on data migration and data conversion from the SQL server, DB2 to Oracle using Informatica and Oracle Data Integrator (ODI)
• Worked on migration, systems architecture, planning, testing, query optimization and trouble shooting and assisted in database design and data modeling
• Managed tasks in workflow manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and scheduled workflow
• Used various transformations like Source Qualifier, Joiner, Lookup, Router, Filter, Expression and Update Strategy
• Interacted with the data modelers and business analysts to understand the requirements and the impact of the ETL on the business
• Extracted data from flat files, DB2, SQL and Oracle to build an operation data source and applied business logic to load the data into the global data warehouse

Technologies: Oracle Pl/Sql, SharePoint, XML, UNIX, ODI, Informatica

System Analyst

Confidential

Responsibilities:

• To find all accounts, credit cards, defaulter entries, Addresses of customer using oracle Sql*Loader. It’s an integration project with third party verification appl.

Technologies: Oracle Pl/Sql, UNIX, Erwin, Sql*Loader