Data Developer

Kiran

Email: ***********@*****.***

Mobile # 862-***-****

PROFESSIONAL SUMARY

Over 10years of experience in Analysis, Design, Requirements Gathering, Production Support, Performance Tuning, Trouble-shooting and Maintenance of databases and Application Servers.

Around 6years of experience in installation, upgrade, administration and Architecture of UNICA Marketing suite tools including Platform, Marketing Operations, Contact Optimize, Campaign and Interact.

Experience in Design and develop Data ingestion/migration processes/framework from Enterprise Data Warehouse and other enterprise sources into Big Data Ecosystem

Extensive experience in Marketing Operations integration with 3rd party applications.

Developed best practices to create optimized UNCIA Campaign flowcharts

Installed UNICA products and deployed on WebSphere

Experience in Installation, upgrade and administering WebSphere

Experience in monitoring system using different tools like Dynatrace, Splunk and SiteScope

Experience in Configuring JVM for optimal application server performance.

Experience in tuning Out Of The Box CH/RH ETL process

Experience in Writing Custom Macros, triggers to help business users

Experience in Implementing automated process to detect long running and run away flowcharts threads

Experience in designing custom tools to help Channel partners to view CH/RH/Profile table data.

Excellent skills in Design and Development of applications using Oracle Database 11g10g/9i, SQL, PL/SQL, Netezza, NZSQL, NZLOAD and NZPLSQL.

Extensively experience with implementing and deploying application in AWS cloud infrastructure and leveraging AWS Elastic Load Balancing

Specialized in writing complex NZSQL scripts, NZLOAD and stored procedures

Experience in Informatica 9.6/10.1 workflows, mapping

experience in ETL tools like Informatica to do ETL as well as ELT

experience in working with campaign management tools like IBM EMM (a.k.a UNICA EMM)

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Extensively developed PL/SQL code using PL/SQL Packages, stored procedures, functions, triggers, cursors, views, indexes for processing data and enforcing referential integrity.

Experience in using tools like TOAD, PLSQL Developer, and SQL Developer.

Experience in designing data models using Erwin and Visio.

Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.

Involved in Data modeling, E/R diagrams, normalization and de-normalization as per business requirements.

Experience with data warehouse design using Star Schema and Snowflake schema. .

Experience in Data Migration, data loading from flat files to database tables using SQL*Loader.

Experience in working with UNIX and expertise in UNIX Shell Scripting.

Strong experience in SQL Tuning using Explain Plan, SQL*Trace and TKPROF.

24/7 on-call support for production.

Effectively worked on several Oracle provided packages like DBMS_METADATA, DBMS_ALERT, DBMS_OUTPUT, DBMS_CONNECTION_POOL, DBMS_JOBS, DBMS_PROFILER, UTL_FILE, UTL_HTTP and UTL_SMTP

Technical Skills:

Operating Systems

Windows XP/7/10, Sun Solaris, AIX, RHEL, Oracle Enterprise Linux

Vendor Products

UNICA Suite (Platform, Campaign, Marketing Operations, Contact Optimize, Interact), Work front, IBM UBX, Tealium, iServer, StreamSets, WorkFront

Big Data Ecosystem

Hadoop, MapReduce, HDFS, HBase, Zookeeper, hive, Pig, Sqoop, Oozie, Flume, Spark

Cloud Platforms

Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform (GCP)

Database

Oracle 12c/11g/10G, Netezza, Apache Hive, Apache Hbase

Administration

WebSphere, UNICA, Oracle DB, Workfront

Programming languages

ANSI C, PL/SQL programming, NZPLSQL

Other Technologies

HTML, XML, Java Scripting, UNICA, AWS CFT and AWS Cloud infra.

Script Languages

JavaScript, Shell, Perl scripting, PERL Scripting, puppet Scripting

Tools

Toad, PLSQL Developer, OEM, SQL Navigator, SQL Tools, Erwin, Power Designer, MS Visio

Others

Object Oriented Designing Methodology, UML, RDBMS Concepts

CERTIFICATIONS:

Google Cloud Certified Professional Cloud Architect (link to Certificate)

EDUCATION:

Masters in Embedded and Software Engineering Gannon University, Erie, PA.

PROFESSIONAL EXPERIENCE

Humana Inc Sep 2014 – Current

Role: Lead Application Architect

Responsibilities:

Installed, Upgrade and configured UNICA products including Platform, Marketing Operations, Contact Optimize, Campaign and Interact.

Deployed UNICA products to WebSphere

Upgraded UNICA Products to Latest Version

Architected and implemented Interact Run Time environment in AWS with Auto Scaling enabled.

Implemented Custom Interact deployment process when Whitelist table is populated with huge dataset

Implement Custom process to do automated rolling restart Interact Run Time servers post deployment.

Supported 1300+ Marketing Operations Users

Worked with IBM/HCL Product engineering team and support team regarding Enhancements and Defects

Developed best practices and assisted users in developing optimized batch flowcharts, interactive flowcharts and strategies.

Created Custom macros, Triggers and custom pl/sql code in optimizing campaign batch flowcharts.

Designed Gateway Service abstracting Interact Out of the Box REST API

Designed and implemented Custom process to capture and compare Interact Deployment data.

Worked with HCL UNICA Engineering team and certified Azure SQL Data Warehouse to be used with Version 11.1

Designed and Implemented Integration between Marketing Operations and Workfront to improve Business users productivity.

Created Automated process to trigger flowcharts and clean-up temp files and tables generated by campaign using tools like unica_srvadm and unica_acclean

worked with Channel partners during integration with Interact and provided Interact REST API knowledge

Configured LDAP integrated login with in Platform.

Designed and implemented Security polices and roles with Platform and Marketing Operations.

Designed and Developed data ingestion processes to load data into Big Data ecosystem

Created Backup and DR strategy for UNICA products

Created SQL Scripts with complex transformations and business logic and PL/SQL to summarize data prior to loading into EDW and Datamarts.

Analyzed time consuming SQL and PL/SQL block queries and tuned them to run in less time by using cost based Optimizer hints, Explain plan.

Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.

Implemented table partitioning and Sub-Partitioning to improve performance, data management and to leverage partition pruning.

Created Database trigger on Insertion, Updating and Deletion to keep records of Audit routines.

Using DBMS_STATS, DBMS_JOB to gather the statistics and schedule jobs, DBMS_METADATA for dynamic scripting.

Involved in Tuning, Performance and Optimization of queries and standardization of the codes

Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.

Created database objects like Tables, Indexes, Views, Materialized Views, Triggers, Procedures, Functions, Exceptions using SQL*plus and TOAD.

Developed Row level and Statement level Triggers for auditing tables in PL/SQL.

Developed Views and Materialized Views for specific data retrieval for the reports.

Developed data load processes using Unix Shell Scripts and DBMS Jobs to automate jobs and loading data into the Database using SQL* Loader.

Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings

Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput

Handled errors using System defined exceptions and User defined exceptions like INVALID_NUMBER, NO_DATA_FOUND and PRAGMA EXCEPTION_INIT.

Created PERL Scripts to automate and capture metrics from Logs.

Used export/import and expdp/impdp database utilities for data transfer

Created data load process to load data from OLTP sources into Netezza

Designed table structure and databases in Netezza

Created external tables and NZLOAD process in Netezza to load data from external systems

Created Netezza stored procedures with complex business rules

Created custom Change Data Capture (CDC) scripts from Netezza using inbuilt columns

Developed Informatica mappings, sessions and workflows to load data from various systems to EDW and Netezza in both ETL and ELT models

Extensively used Oracle in-built function to compute values like Analytical function, Aggregate function, Single row and multiple row functions and also wrote user defined function.

Implemented AWS infrastructure with elastic load balancing and automating using puppet scripting

Created different types of indexes bitmap, B*tree and function based to improve performance.

Planned Index Rebuilding, Index Analyze and Table Analyze on periodic basis.

Involved in creating users and privilege Management using roles and grants.

Environment: UNICA 11.1, AWS, Workfront, Cloudera Hadoop Distribution, Oracle 12c/11g AIX, RHEL, OEL, SHELL Scripting, PERL Scripting, SQL, Erwin, SQL*Plus, Netezza, NZSQL, NZLOAD, Informatica, Java, TOAD, IBM EMM (UNICA), SVN, PlSql Developer, iServer, SQUIDS and Dollar Universe.

Client Network Services Inc, Gaithersburg, MD Nov 2013 – Sep 2014

Role: Oracle DBA/Developer

Responsibilities:

Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.

Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.

Involved in various stages of the project life cycle mainly analysis, design, Coding, testing and implementation of the application.

Involved in Designing data models using Erwin

Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.

Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.

Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Performance improvement analysis on materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements

Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.

Created UNIX Shell scripts for automating the execution process.

Unit testing various PL/SQL blocks and GUI testing the user interface screens.

Developed Procedures and Triggers for Oracle Forms and Reports

Interacted with Java developers and used JDBC for interaction with Oracle database.

Extracted Transformed and Loaded (ETL) data source database to data warehouse system.

Involved in writing complex queries to generate reports as per client requests as part of production support

Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.

Coordinated with DBA in improving Database Performance.

Involved in developing test plans and test cases based on high-level and detailed designs.

Monitored user interaction with the system and make improvements to tune applications to shifting business and user needs.

Environment: Oracle 11g AIX, SQL, Erwin, SQL*Plus, TOAD, IBM Clear Case, Sql Developer.

Client: Humana Inc Jan 2011 – Nov 2012

Role: Oracle/Netezza Developer

Responsibilities:

Created complex queries using SQL and PL/SQL to summarize data which are used as views on which reports are based.

Designed Entity-Relationship models using ERWIN and other design features.

Responsible for Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application

Used SQL*Loader to load data into Oracle database.

Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.

Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges

Created data load process to load data from OLTP sources into Netezza

Designed table structure in Netezza

Created external tables in NZLOAD process in Netezza

Created Netezza stored procedures with complex business rules

Experience in table distribution methods in Netezza

Knowledge in Netezza internal storage mechanism

Knowledge in how zone maps works

Implemented exception handling using autonomous transactions, Pragma Init, Locks, used save points, commits & rollbacks to maintain transactional consistency & database integrity.

Created Perl scripts for automating the execution process.

Maintained and Updated existing applications of Oracle Forms 10g and Reports 10g based on regular basis.

Developed custom libraries for the existing applications, used canvases, blocks, and visual attributes in developing front end using forms 10g.

Effectively used Oracle Reports for generating PDF reports according to the client’s requirements.

Used Oracle Supplied Packages such as UTL_FILE, DBMS_JOB, DBMS_SQL and DBMS_ALERT.

Developed and maintained UNIX shell scripts (Korn Shell) to process extracts and loads.

Usage of Dynamic Execute Immediate statements to fetch data as needed for Dynamic SQL.

Created database Triggers for data security and used SQL* Loader for bulk data load

Achieved optimum Performance Tuning using EXPLAIN PLAN and TKPROF functional utilities and also by creating Indexes.

Monitored user interaction with the system and made improvements to tune applications to shifting business and user needs.

Developed software test plans, test design specifications, and test scripts for various test scenarios.

Involved in Unit Testing for the project.

Involved in Production Support and troubleshooting data quality and integrity issues

Environment: Oracle 11g/10g, AIX-UNIX, SQL*Plus, SQL*Loader, Informatica, TOAD, PL/SQL, Perl, Netezza, Toad, SQL, Erwin.

Client: FedEx, Collierville, TN Feb 2009 – Dec 2010

Role: Oracle DBA/Developer

Responsibilities:

Performed Impact & Analysis for the project.

Involved in Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.

Involved in Designing data models using Erwin.

Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.

Wrote dynamic script for schema sync.

Developed, modified and optimized complex queries for data retrieval and modification.

Wrote Unix shell scripts for automating regular data loading jobs

Developed packages for processing data in the staging tables according to the Clients requirements

Writing UNIX Shell Scripts to automate load process, scheduling batch jobs in Crontab.

Worked in unit, integration and performance testing.

Documented changes and enhancements in code

Tuned the SQL queries and complex procedures to improve performance

Wrote control files for data loading using SQL*Loader

Developed& maintained Unix shell scripts to automate file transfers

Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.

Provided 24/7 on call production support.

Environment: Oracle 10g, AIX, SQL*Plus, SQL, Perl, PL/SQL, SQL*Loader, Erwin, Toad, Java.

Contact this candidate