SUMMARY:

• Architecting, design and Implementation of AWS Redshift Data Warehouse Application
• Specialist in ETL Architect, design on Talend and Informatica.
• Specialist in Oracle, Mongo DB, PostgreSQL, MySQL Administration and Performance Optimization.
• Hands on experience using AWS services such as RDS,DMS, S3, Data Pipeline, Cloud Formation,
• Develop and Implement Automation of Oracle Database Installation / Upgrade, patching in RAC and Data guard Configurations.
• Design and configured Disaster Recovery using Oracle Active Data guard and Streams.
• Designed and Developed high performance real - time Fleet Tracking BI/Data Warehousing solutions with Oracle/PostgreSQL/MySQL/Mongo Database and Talend ETL tool.
• Hands on Experience on Jasper BI tool and product evaluation on Pentaho.
• Administration of Talend and Jasper Server.
• Implementing Oracle Minimum Security Baseline requirements with sound privilege management and fine grained auditing policy.
• Implementation and Automation of Database Monitoring Tools ( Confidential -DBSPI),
• Developed DB Capacity Planning for future expansion requirements.
• Development and Implementation of secured and tuned RMAN / Image-Copy based Database Backup and Restore Strategies.
• Develop and Automate Installation of Oracle Enterprise Manager Database Console.
• Interfacing with Oracle Advanced Customer (ACS) to review service requests, bug Analysis, Filing of bugs.
• Strong experience in analyzing AWR/ADDM and Other Oracle Tuning Advisor/Statistics tools.
• Extensive experience in database cloning and patching of Oracle Database.
• Extensive experience in database Performance Tuning.
• Strong Unix shell scripting skills in Linux/ Confidential -Unix and Solaris environments.
• Strong experience in development and performance tuning with SQL, PL/SQL.
• Used Object oriented features such as data abstraction methodologies using Cursor, Nested Tables, Varying Arrays, Records and overloading sub Programs
• Have used advanced features like Bulk data collection data and Conditional compilation.
• Developed ETL specifications, source to target mapping and other documentation required for ETL development. Ensures appropriate documentation is completed and stored in the repository database.
• Worked as part of a team to elicit, document, and finalize business requirements (e.g. process modeling, data, business rules, functions, etc.)
• Developed test cases and plans, and assists with system testing.
• Ensured that data projects follow prescribed development life cycle and meet quality standards.
• Facilitates communication between developers and business users to ensure that customer requirements are correctly translated to appropriate data design specifications
• Worked with business users to optimize information usage
• Proactively diagnoses, researches, monitors for and resolves SQL and database-related faults and performance problems
• Developed and maintained appropriate repositories of data model and dataflow diagrams relating to the data warehouse
• Develop and communicate project plans, work assignments, target dates and other aspects of assigned projects.
• Experience in integration of various data sources with Multiple Relational Databases like Redshift, Oracle, MySQL, PostgreSQL, Netezza, Teradata, DB2, Informix, and Sybase.
• ETL Analyst/ETL Developer with extensive experience in the Information Technology (IT) industry with specialization in the Analysis, Design, Data Modeling, Development, Testing, Implementation and Maintenance of Enterprise Data Warehousing.
• Expertise in analyzing the source systems data and the current reports to gather the business requirements and map them in the IT requirement.
• Experience in Maintaining and improving automated build processes. Worked with development team to ensure configuration integrity of requirements, requirements traceability, design documents, source code, tests, and test reports in a multi-project software environment.
• Extensive experience in database design for data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Strong experience with UNIX Shell Scripting, PL/SQL, Oracle Procedures and Packages.
• Strong domain knowledge in Retail, Manufacturing, Finance, Health and Life insurance.
• Train new team members in CM process, standards & procedures.
• Excellent communication at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions.
• Result oriented approach for task completion and desire to accomplish everything with perfection and within the stipulated timeframe.

TECHNICAL SKILLS:

ETL tools: Talend Big data 6.4, 5.6, Informatica Power Center 8.1.1, 7.2, Oracle Sql*Loader.

RDBMS: Redshift, Oracle 11g/10g/9i/8i/7, PostgreSQL 9.x, MySQL 5.x, Mongo DB 2/3.x, Netezza, Teradata V2R6.

Programming: SQL, PL/SQL, C, Pro*C, Java, Ruby, XML.

Operating systems: Windows NT/95/98/2000/XP, DOS, UNIX, LINUX 7.0/8.0/9.0

Scripting languages: UNIX Korn Shell & Perl scripting.

Reporting Tools: Jasper, Cognos, Microstrategy, Ruby on Rails, Pentaho

Data Modeling Tool: Erwin.

Tools/Utilities: Clear Case, PVCS, PL/SQL Developer, SQL* PLUS, Mercury Test Director, SharePoint

PROFESSIONAL EXPERIENCE:

Senior DBA/ DW/ ETL Architect

Confidential

Responsibilities:

• Lead DBA/Database Architect/Data Integration-ETL for Confidential Project and Legacy Data Warehousing Application Product (Fleet Outlook/Lendor Outlook/Device Outlook).
• Leveraged AWS-Talend for Big Data ETL Tool for Data Integration from discrete source ranging from RDBMS (Oracle/MySQL/PostgreSQL), Mongo DB-No-SQL, Sales Force.
• Architected Database design, model and ETL components.
• Implemented AWS Redshift Data Warehousing BI solution for Cloud Telematics Application.
• Interacted with Talend-Support for Troubleshooting and Performance enhancement exercise.

Environment: Redshift, Oracle 11g, Talend 6.4, PostgreSQL, MySQL, Mongo DB, Jasper

Senior DBA

Confidential

Responsibilities:

• Development Design and Administration of Oracle database Disaster Recovery Configuration using Active Data Guard, Fast Recovery Area and Flashback Logs.
• Developed and implemented secured RMAN-Incremental Image-Copy based Backup and Restore Strategy
• Developed scripts to automate database Installation, Upgrade and Patching, Partition Management Operations (PMOPS) and Statistics Gathering Strategy.
• Weekly interaction with Oracle Advance Customer (ACS) Support team to review Service Request, Filing of Bugs and Bug analysis.
• Developed proactive database monitoring scripts and Implemented external monitoring tool( Confidential -DBSPI)
• Developed script to automate Oracle Enterprise Manager DB console configuration.
• Implemented Oracle Minimum Security Baseline with secured privilege management and fine grained auditing policy.
• Advanced configuration of Oracle net components (sqlnet.ora and listener.ora) for performance and security.
• Database capacity planning for future expansion requirements.

Environment: Redshift, Oracle 11g, Talend 6.4, PostgreSQL, MySQL, Mongo DB, Jasper

DBA/ DW-Architect

Confidential

Responsibilities:

• Administered large OLTP and Data Warehouse application in RAC/Streams configuration.
• Developed and designed high velocity, high performance Real-Time Fleet Tracking reporting Data Warehousing application using dimensional modeling techniques and implemented with Oracle Streams and In house ETL solution built on Ruby on Rails Frame Work.
• Developed end-to-end complex backend reporting scripts.
• Performance tuning and Administration and Maintenance of Data Warehouse.
• Developed script to automate partition maintenance operations (PMOS).
• Implemented sound statistics gathering backup and restore strategies.
• Responsible for Database Installation, upgrade and patching and troubleshoot performance bottleneck
• Expertise in Database (Oracle, MySQL, PostgreSQL) / BI (Informatica, Talend, Pentaho) product evaluations.

DBA / ETL Architect

Confidential

Responsibilities:

• Installation and Cloning of Oracle Database.in QA, Staging and production environments.
• Provided support for data warehouse in 24 * 7 production environment.
• Investigated and resolved performance issues with ETL processes. Recommended alternatives and workarounds for improving ETL performance and to improve data latency.
• Set-up and maintained scripts for proactive database monitoring.
• Developed ETL specifications, source to target mapping and other documentation required for ETL development. Ensures appropriate documentation is completed and stored in the repository database.
• Development of custom application using Informatica, KSH and Perl scripts on Oracle,DB2 and Netezza appliance for the Merchandising, Distribution, Business Reports, Direct Marketing, Warranty Administration and other critical business applications.
• Worked as part of a team to elicit, document, and finalize business requirements (e.g. process modeling, data, business rules, functions, etc.)
• Worked with business users to optimize information usage
• Maintain and improve automated build processes. Work with development team to ensure configuration integrity of requirements, requirements traceability, design documents, source code, tests, and test reports in a multi-project software environment.
• Proactively diagnoses, researches, monitors for and resolves SQL and database-related faults and performance problems
• Develops and maintains appropriate repositories of data model and dataflow diagrams relating to the data warehouse
• Provide technical support and problem analysis/resolution for existing programs in Data warehousing production environment.
• Maintain and improve automated build processes. Work with development team to ensure configuration integrity of requirements, requirements traceability, design documents, source code, tests, and test reports in a multi-project software environment.
• Create system documentation including, source to target data mapping, database design diagrams, programming specifications, etc.
• Worked closely with the Business analysts to support the requirements and provide them with data analysis.
• Developed and maintained the process document for the code movement between Development to Test and Production environment.
• Worked with project managers to develop project specific processes and CM plans.
• Train new team members in CM process, standards & procedures.

Environment: Oracle 10g, Informatica, IBM DB2 UDB, Netezza, Teradata V2R6, Cognos, Autosys, Microstrategy, Informix, Allbase, Confidential UNIX 11.0, AIX, Linux, Windows NT, Perl, Korn Shell Scripts.

Software Consultant

Confidential, Somers, NY

Responsibilities:

• Design and developed stored procedures, functions, Packages.
• Written API’s in Pro*c which will interact with Oracle Advanced features of, External Functions, thereby eliminating the processing speed of PowerBuilder Calling GEMMS API through RPC Call.
• Developed Unix Korn Shell scripts for Batch Jobs.
• Responsible for developing and maintaining different Batch jobs including Subledger Process, Sales Extract, Cost of Goods.
• Provide technical support and problem analysis/resolution for existing programs in production.
• Gather customer requirements then conduct detailed technical analysis and design of programs
• Applying different tuning techniques to improve performance of SQL’s. Generating different custom reports based on user requirements.
• Code new programs and provide enhancements to existing programs. Writing technical documentation of program code and logic.
• Involved in all levels of testing.
• Used PVCS case tool for Versioning Control.

Environment: Oracle 8.0.6, SQL Plus 8.0, PL/SQL 8.0.6, Pro*C, SQR, Confidential UNIX 11.0, Windows NT, Korn Shell Scripts, PVCS, Oracle Process Manufacturing (GEMMS 4.10.11) Power Builder 6.5, PFC.

Software Consultant

Confidential

Responsibilities:

• Designed Technical aspects of TMW application to incorporate the changes due to Database convergence & System Convergence.
• Developed Pro*c program to implement the changes due to Database convergence & System Convergence.
• Developed Pro*c program to read the Cases coming from WEB and processing and loading into TMW application Database.
• Developed Unix Shell scripts to run the Pro*c programs in Unix Environment
• Responsible for Technical Design, Implementation, Unit Testing, Integration Testing and regression testing.
• Used Clear case tool for Versioning Control.

Environment: Oracle 8.1.5, 8.1.6, 7.3.2, SQL Plus 8.0, PL/SQL 8.0/2.0,Pro*C, SQR, Solaris, Windows NT, Shell Scripts Workstation, Clear Case, Orbix for C++, Xerces C++ parser for Solaris.

Confidential

Sr. Systems Executive

Responsibilities:

• Designed Messaging API to abstract Sonic MQ API.
• Developed wrapper class to abstract Sonic MQ messaging API.
• Developed wrapper class to abstract Sonic MQ messaging API.
• Used Sonic MQ (Progress) JMS provider.

Environment: Java 2.0, JSP, EJB, XML, JMS, and Sonic MQ JMS.

Confidential

Programmer Analyst

Responsibilities:

• Involved in Analysis, Design and Development of the system.
• Used Oracle 8i and Forms 6.0 for prototyping and development of the system.
• Used SQL Plus 8.0, PL/SQL and SQL Loader for accessing and updating the database.
• Created Stored Procedures for maintaining Stock Based on Material Code, Category, and Material Location Combination.
• Performed various database administration (DBA) tasks.
• Did system testing, user training and maintenance.
• Involved in Coding, Design and Development of the system.
• Used Oracle 8.0 and Forms 5.0 for prototyping and development of the system.
• Performed various database administration (DBA) tasks.
• Did system testing, user training and maintenance.
• Designed the User Interface. Designed and developed screens like Bill passing, Cash & Bank Transaction etc.
• Created stored procedures for maintaining balance in various account heads.
• Performed various database administration (DBA) tasks.
• Did system testing, user training and maintenance.
• Designed and developed forms like Call Entry, Payment Note, Dispatch Entry, etc.
• Developed Pro*c program to implement the changes due to Database convergence & System Convergence.
• Did system testing, user training and maintenance.
• Performed various database administration (DBA) tasks.

Environment: Oracle 7.1/7.3,SQL Plus, PL/SQL 2.0, Pro *C, Confidential UNIX 9.2/10.0, Oracle Forms.

Confidential

Programmer Analyst

Responsibilities:

• Designed user interface using Screen Painter
• Developed Reports like Pending GIR Statement, Shortage or Excess reports etc.
• Did documentation of the project.
• Did system testing, user training and maintenance.
• Did Prototyping of user interface using Screen Painter.
• Developed modules like Cash & Bank Entry.
• Developed Reports using C language like Cash & Bank Statement.
• Did system testing, user training and maintenance.

Environment: PC, LAN - DOS, BTRIEVE, XTRIEVE & C