Summary:

• Over 17 years of experience in IT industry with knowledge base in Data warehouse and Big Data technology solutions. I have experience in management, development, administration support. I am involved in full-lifecycle including requirement gathering, data modeling, development, administration and documentation.
• Experience in Administration of Hadoop, Informatica, Talend, Data stage and AWS.
• Experience in Development of ETL applications for Data Warehousing / Business Intelligence applications using Informatica, Talend and IBM Data stage, Quality Stage.
• Experience with Development of GoldenGate replication in heterogeneous environment.

Technical Skills:

Tools : Informatica 9.1.0, Talend, Hadoop 1.1.2/2.2 ,

IBM Info Sphere Data Stage, Quality Stage 8.1/7.5/6.2 ,

Golden Gate

No SQL : Cassandra, MongoDB

Cloud Computing : AWS EC2 virtual server ,Amazon Linux,

Amazon S3 storage

Scripting Languages : Python 3.4,Shell scripting

Database : Oracle 11g,Teradata, SQL Server,

Informix7.x/9.x, Sybase,Progress

Operating System : Linux RHEL, Centos, OEL , UNIX HP, AIX ,Windows.

Professional Experience:

Confidential

Principal Administrator/Lead Developer

Administration:

• Provided operational support services relating to Hadoop infrastructure and application installation
• Supported technical team members in management and review of Hadoop log files and data backups
• Supported technical team members for automation, installation and configuration tasks.
• Provided technical assistance for configuration, administration and monitoring of Hadoop clusters.
• Commission, Decommission of data nodes and adding additional data nodes etc.

Confidential

Senior Informatica Administrator/Developer

Administration:

• Involved in administration of ETL tool like setting security model.
• Applied Informatica hotfix3,hotfix4, Salesforce and Hadoop Plug-in
• Involved in automating and tuning of informatica session query
• Installed, configured and implemented Proactive Monitor and Jasper Soft tools.
• Setup security model for Proactive Monitor tool in QA and PROD in the Data warehouse environment. The PROD job failures can be addressed through third level support.
• Written UNIX shell scripts to automate certain process in the data warehouse environment.
• Setup user group, roles and user.

Developer:

• Design, Developed the Dimension Fact for university of phoenix Data warehouse
• Design and Developed informatica jobs for third party application using informatica.
• Developed on several enhancement projects like forecasting.
• Involved in enhancement of current data warehouse by changing the process using golden gate tool more efficiently.

Senior Golden gate Developer

• Developed and Implement Data Replication between Heterogeneous Databases
• Supporting real time data replication using Golden Gate for several database.

Talend Administrator

• Installed Talend on AWS ec2 instances
• Mounted S3FS bucket in all Talend instances that will be added to virtual job server cluster
• Configured SVN for the code to be managed
• Installed and managed Amin console to manage resources
• Installed and configured plugin like MongoDB and MySQL
• Upgraded from Talend5.0.1 to 5.1.1

Software: Informatica 9.1,Informatica Metadata manager, Informatica IDQ, Informatica Proactive Monitor 2.5,Goldengate,Talend 5.1,Oracle 11g,Sqlserver,MongoDB,MySQL

Hadoop 1.2/2.2 HIVE, HBase, SQOOP, OOZIE, Map/Reduce, HDFS,YARN

Confidential

ETL Architect/ Developer

• As an architect was involved in managing and working on upgrades from DS7.1 to DS 8.1
• Replaced stored procedures in Sybase with the Data Stage jobs using the CDC change data capture plug-in available in DataStage8.1 parallel job.
• Used some of the stages available in the latest version while rewriting the application from DS7.1 to DS8.1
• Routines in DS 7.1 was rewritten using Unix shell script in DS 8.1
• Analyzing server routines in the DataStage7.1 to convert to parallel routines DataStage8.1 which will be implemented using C programming language.
• Developed and Implemented applications on DS 8.1 parallel version
• Developed stored procedure in Sybase

Software: IBM InfoSphere DataStage8.1/7.1, Quality Stage,SunSolaris 10,Sybase,Oracle 11g

Confidential

Data warehouse Manager/Architect/Administrator/Developer

• As a Service Owner, I had a fabulous opportunity to work with all the major Production IT Functions on all aspect of Service Ownership including Service Transition and Service Roadmaps.
• Analyzed business requirements and provided system enhancement recommendations.
• Experience in design, development, deployment and support of data warehouse with Ascential DataStage and Informatica as an ETL tool.
• Created transformations like Expression, Filter, Joiner and Lookups for data cleansing and data consistency.
• Created Mappings for populating target table in efficient manner using Sorter Aggregator.
• Involved in defining technical and functional specifications for ETL process.
• Used both Pipeline and Partition Parallelism for improving performance.
• Tuned mappings to provide optimum efficiency
• Data transformation mappings were built between ODS to Data marts.
• Data Files were loaded into Teradata using Multi Load and Fast Load utilities.
• Exported data files using Fast Export utility and also developed Bteq scripts.
• Involved in rewriting Legacy applications.
• Involved in data migration from Legacy applications to DHL Data marts.
• Developed Shell Scripts to automate file manipulation and data loading procedures.
• Managed DataStage repository, defined custom routines, Imported and exported jobs between different systems.
• Hash files were used as an intermediate to extract and write data in a job.
• Used COSORT utility in shell scripts for sorting the ASCII files.
• Scheduled jobs using Control M and CA7.
• Responsible for Design Documents reviews, Performance and Technical acceptance review.
• Worked with offshore and onshore team in implementing the application on a timely manner.

Software:AscentialDataStage8.x/7.x/6.x,Teradata,QualityStage,Informix,

Cognos,Actuate, Prism, PL/SQL, Oracle, Sql Server,ControlM, CA7

Confidential

Data warehouse consultant

• ETL tool was used as a back-end for data extraction, transformation, loading and Crystal Reports was used as a front-end reporting tool.
• The Insight project integrates data from multiple operational platforms i.e. Mainframe, SAP, JDA and PeopleSoft into a single Enterprise Warehouse.
• Solar Turbines is a Leader in Designing, Manufacturing and Servicing Industrial Gas Turbine Power System Solutions for the Oil, Gas and Power Generation Industries.
• Involved in defining technical and functional specifications for ETL process.
• Involved in performance tuning of the ETL process.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and research for possible solutions.
• ETL tool was used to extract data from source systems, aggregate the data and load into the database.
• Used various Transformations like Expression, Filter, Joiner and Lookups for better data quality and consistency.
• Designed Migration Mappings and created data template documents.
• Developed various Informatica Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica.

• Documented the process flow from source to target.

Software: Informatica 6.2, Crystal Reports, AIX, PL/SQL, Oracle Discoverer, Oracle Reports, Oracle Express, Oracle Designer.

Confidential

Data warehouse Consultant

• Created complex functions, stored procedures and packages by using PL/SQL.
• Identification and implementing business rules constraints, triggers etc. and views.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Utilized SQL Plus as the main interface with Oracle 8i.
• Involved in the development of a migration tool to convert data from the existing database to the required database format.
• Shell Scripts were written to automate the stored procedures, triggers and functions.
• Developed packages by using PL/SQL for automating the transactions happening in the tables.
• Used Collections like variable arrays, nested tables extensively.
• Used SQLLDR to load data from CSV file to database.
• Created front-end procedures and functions with Forms.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Involved in PL/SQL Debugging and support.
• Worked on tuning of SQL after analyzing the table
• Involved in Unit Testing of the modules,

Software: Oracle 8i, PL/SQL, HP-UX 10.x, SQL Loader, Oracle Forms Reports 6i, SQL Plus, Toad.

Confidential

PL/SQL Developer

• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• SQL Loader was used to convert the data from the Excel to oracle tables.
• Wrote Stored Procedures for effective inserting and updating of the data to the tables when the application is online reducing the network traffic.
• Sub-queries and joins were extensively used in stored procedures.
• Created Shell scripts to automate the load of data from Text files to Oracle Tables.
• Created Packages to automate transactions from the Oracle Forms.
• Created database triggers to automate the transactions that take place online.
• Subversion technology used to maintain the source code.
• Used UTL File Packages to Load data from Excel Sheet to Oracle Tables.
• Used Oracle Forms to design and develop the interface for the system.
• Created matrix reports using Reports.
• Created Object Groups to create to screen templates with Forms.
• Used Import Export tools to create dump files for exporting and importing data to the database.
• Created front-end procedures and functions with Forms

Software Oracle 8i, PL/SQL, HP-UX 10.x, complex Stored Procedures, triggers and packages , SQL Loader, Oracle Forms Reports 6i, SQL Plus, Toad.

Confidential

Lead

• Responsible for developing complex back-end database applications using Oracle technologies.
• Create and developed highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.Analysis, Design, and Development of the Data Entry Subsystem.
• Responsible for setting up development standards for database development within PL/SQL.
• Contribute to a high-performing workgroup by applying interpersonal and collaboration skills to achieve corporate goals. Provide high level of attention to detail while completing multiple tasks demonstrating a commitment to quality while meeting project deadlines.
• Expertise in designing, developing Extraction, Transformation, and Load scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project
• Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document.
• Review the business requirements with the Analysts, Business Users and Developers to construct SQL queries for implementing the same in PL/SQL packages.

Software: Oracle8 Forms Reports, MS Access 97, Windows 95.