PROFESSIONAL SUMMARY:

• Information Technology Professional with over 9 + years of experience in Application development and Production support of Telecom/Energy/Airlines/Finance/Manufacturing Industry.
• Comprehensive knowledge of Software development life cycle ranging from Business Requirement gathering, Designing Databases, Developing Applications, Unit Testing, System Integrity Testing and User Acceptance Testing.
• Experienced in reviewing and analyzing functional specifications and project specifications and develop solutions to user problems.
• Extensive experience in data modeling using normalization concepts for large databases. Hands on experience in using data modeling tools like Embarcadero ER Studio, ERWIN, Toad Data Modeler.
• In - Depth Knowledge of Oracle Architecture, Memory structures, Oracle Processes, data dictionary, Schema Objects.
• Extensive experience in designing and developing database solutions using Oracle latest features and adopting best standards.
• Experienced in performance tuning and query optimization using utilities like DBMS PROFILER, Explain Plan, SQL Trace and TKPROF.
• Demonstrated experience using business intelligence, data warehousing, data mining, large scale data modeling, data analysis, and data visualization tools.
• Experienced in Developing and Customization of Reports and Forms using Oracle Forms 10g and Oracle Reports 10g.
• Involved in DBA activities such as Backup/Recovery, Export/Import, Performance Tuning, Creating users and granting role/privileges.
• Hands on Big Data Technologies Hadoop Ecosystem(HDFS, HIVE, PIG), Oracle Big Data Appliance.
• Extensive experience in Enterprise Application Integration (EAI) using tools from TIBCO Suite-TIBCO Business works, TIBCO Administrator, TIBCO EMS, TIBCO Designer, TIBCO Hawk.
• Extensive experience in implementing SOA concepts by designing and developing Web Services using SOAP/HTTP and SOAP/JMS with TIBCO Business Works.
• Integrated Shell Script, PL/SQL and used CRON to schedule batch jobs. Experienced in Data loading using UNIX Shell scripts, SQL*Loader, External Tables.
• Hands on experience in Core JAVA, J2EE and JDBC.
• Experienced in XML technologies like XQuery, XSLT, X-path, XML schema.
• Technical documentation of different lifecycle deliverables, design and system specifications and user manuals.
• Worked on 24*7 environments to provide production support.
• Experienced in Version Control Tool like CVS, Perforce, Tortoise SVN.
• Good team spirit and organized working habits with a willingness to learn new concepts.
• Excellent communication and presentation skills along with time management.
• Ability to readily grasp complex architectural environments, work from general guidelines under strict deadlines and quickly adapt to new environment.

TECHNICAL SKILLS:

Operating Systems: UNIX, Sun Solaris v.2.8, Linux9.2, Windows

Languages: Java, PL/SQL

RDBMS: Oracle 9i/10g/11g/12c, Postgres, SQL Server

Big Data: Hadoop Ecosystem( HDFS, Hive, Pig), Oracle BDA, Big Data SQL, Oracle NOSQL, Kaftka, Spark

Query Tools: TOAD, SQL Developer, SQL Plus, PL/SQL Developer

Data Modeling Tools: Embarcadero ER Studio, ERWIN, Toad Data Modeler, SQL Power Architect

Reporting Tool: Oracle Forms 9i/10g, Oracle Reports 9i/10g, Crystal Reports, OBIEE

ETL Tools: OWB 11g, Informatica 7.0, Data Stage

TIBCO Integration: TIBCO BW 4.x/5.x, TIBCO EMS 4.x/5.x, TIBCO Admin 4.x/5.x

Web Services: SOAP/JMS,SOAP/HTTP, WSDL, XML, XSLT, XPATH

Web Technologies: HTML, XML

Version Control Tool: CVS, Perforce, Tortoise SVN, Microsoft Visual Studio 10

Other Tools: Eclipse, MS Viso, Erwin, JDK 1.6, LISA 4.0, Spring

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Senior ETL PL/SQL Developer

Responsibilities:

• Primary responsible for leading various projects such as Pre Oracle, EBX to MDM, Small Business to their completion, keep the management appraised with the status. Delegated and assigned tasks to offshore team.
• Performed Dimensional Data modeling and created Star Schema data model to meet the OLAP needs.
• Developed generic file utility framework using external table to load/generate files to/from different vendors. Created Java Stored procedures to do file operation in Oracle Database server.
• Developed meta data driven generic reusable rule engine to execute process specific business rules.
• Primarily responsible for building generic exception handling and logging mechanism and implementing it across different rule engines. Reused existing notification framework to notify business user through email and attachments.
• Created database triggers to replicate configuration changes done in EBX database to Master data management (MDM) schema.
• Set up automated archival process implementing Partition Exchange mechanism to archive monthly transactional data. Archived partitions were further compressed.
• Developed efficient PL/SQL clean-up scripts to remove older transactional data from non-partitioned tables.
• Developed ETL mappings for data extraction, transformation and loading from clearing to Pre Oracle using Oracle OWB.
• Involved in OWB upgrade from 10gR2 to 11gR2. Worked with DBA team to perform upgrade in lower environments, removed redundant locations and verified existing systems integrate with the upgraded system.
• Created OMB Plus scripts to export all the existing mappings from production to SVN and further import and deploy the mdl files generated to lower environments.
• Fine tuned resource intensive query against partitioned table to do runtime partition pruning, use local partitioned indexes.
• Identified and fine tuned poorly performing queries related to TSYS Jobs. Lead OWB mappings and PL/SQL scripts performance tuning efforts.
• Effectively used DBMS PROFILER, Explain Plan, SQL Trace, TKPROF and system generated AWR report to identify the performance bottlenecks and fix them accordingly.
• Used Bulk processing techniques (FOR ALL, BULK COLLECT) to improve application performance. Effectively used features like Dynamic SQL using Bind variables, Ref Cursors, Collections while building the application.
• Solved day to day production issues and made sure critical applications were up and running all the time reducing business impacts.
• Involved in on site and on call support over the weekend as needed and through pager rotation.
• Worked on UNIX shell scripts to automate various processes.
• Extensive experience in scheduling, monitoring and production support of Oracle PL/SQL Batch jobs using Tidal and DBMS SCHEDULER.
• Used SVN - Version control tool for code management and JIRA for tracking tasks and issues.

Environment: Oracle 11g, SQL Developer, SQL*Plus, OWB 11g, OBIEE, WinScp, UNIX Shell Scripting, Putty, SVN, Tidal, JIRA, Eclipse, Core Java.

Confidential, Austin, TX

Senior ETL PL/SQL Developer

Responsibilities:

• Prepared high level and low level design documents, specifications, data mapping documents & provided the most effective solution after discussing scopes, risks, opportunities with technical experts and business.
• Analyzed and worked on porting existing applications from Postgres database to Oracle database.
• Responsible for creating scalable, multithreaded ETL PL/SQL framework to run batch jobs to move data from landing zone to Target tables.
• Developed metadata driven PL/SQL utility scripts to generate External tables, Sql Loader control files, getter functions and other generic codes required for data migration.
• Created PL/SQL scripts to perform ETL from different data sources (Main Frame, DB2, ORACLE) to Oracle database. Implemented Oracle External Tables with Parallel Pipelined Table Functions and utilities like SQL Loader.
• Tuned existing Data Warehousing application processing large data sets. Modified queries to do Partition pruning, partition wise join, created bitmap indexes, used result cache, scalar sub-queries reducing application time significantly. Implemented features like Dynamic Sql, Bind Variable, Collections, Bulk Collect with LIMIT clause.
• Effectively used Explain Plan, SQL Trace, TKPROF and system generated AWR report to identify the performance bottlenecks and fix them accordingly.
• Developed Data Stage ETL jobs to load from multiple sources Flat file, EBCIDIC Binary Comp-3 Packed Decimal data file, source Oracle database tables to target Oracle ODS tables.
• Developed Data Stage multi instance generic ETL job using schema file/SQL file to load Oracle database tables.
• Responsible for creating and maintaining Architecture document for PL/SQL ETL Framework.
• Wrote XQuery to generate, parse and load XML files.
• Created PL/SQL API Functions to generate code to perform ETL. Trained junior developers through multiple workshops.
• Involved in prototyping effort to convert existing Data Hub to Data Lake using Big Data Technologies.
• Responsible for UAT Deployment/support, Production Deployment/Support. Worked closely with Business Users during UAT support.
• Wrote Unix shell scripts to do file manipulation of incoming mainframe files before being processed by DataStage.

Environment: Oracle 12c, SQL Developer, SQL*Plus, TOAD 11.6.1.6, HDFS, Hive, Pig, Oracle BDA, Kafka, Spark, Big Data SQL, Oracle NOSQL, Postgres, pgAdminIII, Putty, SVN, DataStage 11.3.1, WinScp.

Confidential, Houston, TX

Senior Oracle PL/SQL Developer

Responsibilities:

• Developed Database application to meet business need using Oracle PL/SQL features. Created Packages, Procedures, Functions and Triggers.
• Reviewed conceptual data model with business users, App Dev and architects to make sure all the requirements are fully covered.
• Modified existing materialized views doing complete refresh to do incremental refresh. Analyzed materialized views refresh and rewrite capabilities.
• Developed scripts to create multi-schema specific to each business market. Granted rights based on the business requirement. Tested to ensure existing applications work in multi-schema environment.
• Implemented Oracle Advanced queuing to setup queues to transfer messages to business users and Tech Support team. Incorporated messaging system in existing applications, logged and sent messages of each jobs status.
• Maintained row level security in specific tables as per business need using Oracle DBMS RLS package. Implemented and tested script in multiple markets to ensure a user gets necessary DML operation access.
• Implemented parallel processing in batch processing. Created parallel pipelined table functions.
• Tuned slow running queries. Generated Explain Plan and trace file for the problematic session. Ran TKPROF and use information for tuning. Created indexes and modified query to use index, used hints.
• Created transaction level global temporary table. Performed necessary transformation of xml payload before inserting into remote database.
• Tuned enterprise level exception handling application. Created ticket and notified business users when exception occurred.
• Stored Business logic in database. Used Native Dynamic SQL with bind variables to execute the logic.
• Implemented XPath and XQuery expressions. Generated XML instance as per XML Schema required to call different services. Loaded data into relational tables using XML payload. Involved in XPath Rewrite using B-Tree, Function Based indexes to improve performance of XPath-Based functions. Performed XQUERY Rewrite using EXPLAIN PLAN.
• Generated soap envelope using SQL Xquery and invoked contract generation and credit check services.
• Modified queries of existing application for issues seen after migration to 11g environment.
• Actively involved in production support. Created applications for production support team to release and schedule jobs across different interfaces.
• Maintained Source code using Microsoft Visual Studio 10.

Environment: Oracle 11g, PL/SQL Developer, SQL Developer, SQL*Plus, TOAD Data Modeler, Tortoise SVN, soap UI 4.5, FileZilla, Stylus Studio, Unix Shell Scripting, TIBCO EMS 4.6, TIBCO Business Works 5.x, TIBCO Administrator 5.3

Confidential, Fort Worth, TX

Oracle PL/SQL Developer

Responsibilities:

• Developed Database application to meet business need using Oracle PL/SQL features. Created Packages, Procedures, Functions and Triggers.
• Expanded Physical Data Model for the OLTP application using Embarcadero ER Studio.
• Implemented parallel processing using DBMS SCHEDULER, DBMS JOBS and SQL Hint. Created parallel pipelined Table functions.
• Fixed dead lock occurred in existing application due to un-indexed foreign keys. Modified logic in existing application to ensure strict ordering of updates are performed.
• Tuned slow running queries. Generated Explain Plan, ran TKPROF and used trace file for tuning. Created new indexes, modified queries to use existing index.
• Tuned queries doing repeated PL/SQL function calls, used scalar sub-queries instead. Created views embedding function logic into SQL.
• Removed unwanted fields from query to use index, modified code to replace aggregates with analytical functions.
• Modified existing materialized views script to enable query rewrite. Used parallel hints to enable parallel refresh. Ordered data as per indexed keys resulting queries against materialized views to use index.
• Wrote script to find unused index in overly indexed environment. Monitored environment for a week and dropped unused index, performed index rebuild as required after data archival.
• Tuned queries using nested views and analytic functions. Wrote pagination queries for generating different reports.
• Involved in Regression Testing, Throughput Testing and Performance Testing during Oracle 11g Upgrade. Tuned some of the long running queries and applications to use Oracle 11g features.
• Wrote scripts to perform massive deletes in highly normalized environment. Created batch jobs and scheduler jobs to perform data archive and cleanup from transactional and historical tables. Logically divided data and spawned DBMS JOBS to perform deletes.
• Scheduled jobs to rebuild indexes, shrink space and gather statistics after massive deletes were performed. Gathered histograms as required.
• Created jobs to synch lower environment with flight schedule and capacity data from higher environment. Wrote script to notify if any exception occurred.
• Used external tables to load files generated by application into database and generate report for the application to use.
• Wrote SQL Loader script to load weekly tape load data from production. Generated reports to find capacity mismatch and missing flights between HUB and CREX.
• Created script to remove orphan data, enable constraints, reset sequences and validate objects after hot backup from production.
• Participated in Data Stage training conducted by IBM.
• Designed and developed Reports using Crystal Reports
• Developed PL/SQL stored procedures calling in house service from database.
• Created java scripts using JDBC to perform PL/SQL stored procedure and function calls.
• Loaded java class into database, created java stored procedures and invoked methods from PL/SQL function call.
• Participated in code review and database coding standard meetings, followed the enterprise wide standards.
• Part of the Agile team and followed Agile Methodologies.
• Supported application deployment to higher environments in each release.
• Worked with QA team to prepare Test data. Involved in Build Verification Testing and Regression Testing.
• Responsible for maintaining documents in AA Wiki.

Environment: Oracle 11g/10g, SQL Developer, SQL*Plus, Embarcadero ER Studio, SQL Power Architect, Data Stage, Crystal Reports, WinScp, UNIX Shell Scripting, ITKO LISA, Rally, Putty, SVN, Eclipse, Core Java.

Confidential, Taylor, TX

Application Developer II

Responsibilities:

• Created PL/SQL Stored Procedures, Packages, Functions and Triggers to perform Extract, Transform, Compute and Load for Day Ahead Market and Real Time Market Calculations. It involved pulling Hourly, Fifteen Minutes and Five Minutes data from different markets and performing necessary calculations to get the estimated and actual volumes and price for each Market Participant on Hourly and Daily basis.
• Wrote PL/SQL procedures to move data across different Interfaces. Performed necessary data transformation and validation. Extensively used Dynamic SQL, REF Cursors, Bulk binding/Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.
• Created Database objects like tables, synonyms, sequences, views and triggers during development. Enforced database integrity using primary keys and foreign keys.
• Extensively involved in tuning queries/database, creating indexes, suggesting and implementing alternative approaches like partitioning of tables, using global temporary tables, creating Materialized views. Used EXPLAIN PLAN, Optimizer HINTS, SQLTRACE and TKPROF utilities.
• Wrote scripts to generate data during FAT testing. Used Oracle SQL Loader utility to export and load data from higher environment into lower environment during bug fixes and testing.
• Automated Shell scripts to schedule batch jobs pulling data from higher environment into data stage area for business reporting.
• Wrote Java Stored Procedures to perform various business needs.
• Coordinated with release management team and DBA for successful deployment in every release. Used Ant build to deploy the application.
• Configured common frameworks like Generic DB Processor, Common Error Handling and Logging, Notification service, FTP Service.
• Developed TIBCO Business Works processes to call various internal and external services.
• Implemented common logging and error handling service for all Interfaces. Enhanced existing error handling service for enterprise-wide use.
• Developed custom Java functions to perform necessary transformation, parse xml documents.
• Extensively worked on XML, XSLT, XSD. Implemented XPath and XQuery expressions and tested interface for functionality and performance.
• Configured EMS transport objects like Queues, Topics and Bridges and worked in access level control for creating users, groups.
• Involved in the deployment of projects into various environment using TIBCO Administrator and App Manage Utility.
• Participated in application performance tuning, fine tuned interfaces to increase system throughput. Ensured services can handle requests as per business need. Modified code and deployed correspondingly adjusting parameters like Max Jobs, Flow limit, Activation Limit for each process starters.
• Performed happy path testing and Exception testing for each Test case. Used soapUI to perform testing for different services.
• Extensively worked with QA team for their end to end testing. Supported System and User Acceptance Testing.
• Wrote automated LISA test script to validate data against different Calculations. Created test scripts for doing black box testing.
• Tested job orchestration using TIBCO, validated job triggering logic for each job and generated report using LISA.
• Created Test cases for Long day Short day scenarios. Ensured calculation being done correctly.
• Responsible for maintaining calculation document for different markets. These documents show detailed information regarding each Event occurrence, Triggering logic, Compute Logic.

Environment: Oracle 10g, TOAD, PL/SQL Developer, SQL*Plus, CVS, Core JAVA, JDBC, Business Works 5.2/5.1, TIB/EMS 4.x, TIBCO Administrator 5.2, TIBCO Hawk 4.2, XML, XSD,, LISA, XML, Web Services, Eclipse, JDK 1.5, EJB, Spring, JBoss, CVS, Unix Shell Scripting.

Confidential, Overland Park, KS

Oracle Developer II

Responsibilities:

• Designed and implemented Tables, surrogate keys, primary keys, unique keys, foreign keys, indexes (b-tree and bit map). Normalized tables to 3rd normal for OLTP and de-normalized to 1st normal form for Data Warehouse needs.
• Developed new PL/SQL packages, procedures and functions to in corporate Business Rules. Extensively used Bulk binding/Bulk collection, REF Cursors, Dynamic SQL and Collections.
• Involved in ETL processes to load data from Flat files into the target Oracle database using Pipelined Table Function. Wrote verification script to ensure proper data loading to maintain the data integrity between source and the target database.
• Involved in tuning database and SQL statements for optimal performance. Analyzed AWR report and trace files for query performance. Used Oracle hints to do table joins in the specified order.
• Worked on table partitioning (Range, Hash and List) and deployed Bitmap indexes on Partitioned and non-partitioned tables to increase performance.
• Developed materialized views to compute aggregated information and enabled query re-write. Used advanced SQL like analytical functions.
• Used SQL*Loader and UTL FILE Packages for data interfaces. Optimized and fine tuned PL/SQL code to reduce the loading process - Utilized SQL*Loader, performed bulk data loads into database tables using external tables.
• Involved in data model reviews with data architect and business users with explanation of the data model to make sure it is in-line with business requirements.
• Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner Transformation.
• Automated Shell scripts to pull and load data from operational resources into Data Staging Area and Data Warehouse for business intelligence reporting.
• Developed, tested, and implemented shell scripts for backups, refresh of DBs, data loads from/to external systems, and automated thru Crontab.
• Actively involved in Production Support by Trouble Shooting and Bug Fixing.
• Participated in Code and Design Reviews for the backend data population and reporting system.

Env ironment: Oracle 10g, MS Access, TOAD, SQL Developer, SQL*Plus, Perforce, ODBC, Oracle Reports 10g, Oracle Forms 10g, Putty, Sun Solaris 10, Informatica Power Center 7.0, Erwin, Unix Shell scripting, Golden Gate

Confidential, MA

Software Engineer

Responsibilities:

• Developed the system using MS Visual Studio in. NET and C# environments on Service Oriented Architecture with an emphasis on both front-end methodologies including HTML, XML, JavaScript,JQuery, AJAX, JSON, WCF
• Developed and designed Power Resume Search (PRS) Module for parsing, analyzing, displaying of candidate resume for employer portal.
• Consuming and Developing Windows Communication Foundation services (WCF)
• Full system life cycle experience: design, coding, testing, bug fixing, deployment, documentation and maintenance.

Environment: Oracle 8.0, Erwin, SQL, PL/SQL, SQL*PLUS, JDK 1.4, J2EE 1.4 environment - Enterprise Java Beans (EJB),Eclipse, Core JAVA, JDBC, Forms 6i/Report 6i, Putty, Unix Shell Scripting.