SUMMARY

• Having 8 + Years of experience in Teradata, Datastage, SQL, Oracle, Palantir Foundry and Shell scripting in implementation, and maintenance over large scale Data Warehouse environments.
• Extensive experience in Teradata, Oracle and SQL Server database, analyzing the business needs of clients, developing effective and efficient solutions, and ensuring client deliverables within committed timelines.
• Involved in the full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance, and support.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visual C# in script component of SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Experienced in scheduling Sequence and parallel jobs using DataStage Director, UNIX scripts and scheduling tools.
• Extensively used Datastage Designer for developing Parallel jobs and performed complex mappings based on user specifications.
• Expertise in using Teradata utilities such as Fast Load, Multi Load, Tpump, Fast Export Teradata Parallel Transporter, and BTEQ using Teradata SQL Assistance for export and import of data.
• Proficient in Data Modeling Techniques using Star Schema, Snowflake Schema, Fact and Dimension tables, RDBMS, Physical and Logical data modeling for Data Warehouse and Data Marts.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins, and hash indexes in the Teradata database.
• Strong SQL query skills, worked extensively with business teams on ad - hoc requests for providing necessary data for business analysis and decisions.
• Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for ad hoc purpose to extract data for several business users on a scheduled basis.
• Experience in using recursive CTEs, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience working on Agile Scrum methodology and Jira Dashboards.
• Expertise in UNIX shell scripting, Autosys job scheduler, FTP, SFTP, and file management in various UNIX environments experience in running batch jobs in production.
• Substantial Expertise in Stored Procedures, Triggers, Index, Table Partitions, and experienced in Loading data like Flat Files, XML Files, Oracle, DB2, SQL Server into Data Warehouse/Data Marts.
• Experience in working with both 3NF and dimensional models for data warehouse and a good understanding of OLAP/OLTP systems and ETL process.
• Expertise in using Set, Multiset, Derived, Volatile, and Global temporary tables in Teradata for larger Ad hoc SQL requests.
• Proficient in the coding of optimized Teradata batch processing scripts for data transformation, aggregation, and load using BTEQ.
• Performance Tuning of sources, Targets, mappings, and SQL queries in transformations Designing, creating, and tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to support normalized and dimensional models.
• Proficient in performance analysis, monitoring, and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints, and SQL Trace both in Teradata as well as Oracle.
• Experience in Teradata Physical implementation and Database Tuning, technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation, and Data Staging.
• Monitor and troubleshoot performance issues on data warehouse servers and assists in the development of business intelligence, business data standards and processes
• Performing data profiling, Data validation, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst by using Oracle, Teradata.
• Involved in complete software development life-cycle (SDLC), including requirements gathering, analysis, design, development, testing, implementation, and deployment.
• Developed detailed documentation including functional and technical design documents, test cases, support documentation, migration and installation steps, release notes, mapping documents etc.
• Excellent communication skills, inter personnel skills, Proactive, Dedicated, and Ability to quickly grasp new concepts and processes while working vertically across the organization.
• Strong commitment towards quality of the development process and Strong analytical, interpersonal, leadership, and decision-making skills.
• EBS Cloning and Upgrade, Installation, Apply Patches/Patch analysis and Administration, tuning of various components of E-Business Suite 11i/R12.
• Configuration & Supported Oracle Databases 9i/10g/11g/ 12C, Oracle Apps, on call Support, Performance Tuning & Trouble shooting etc.
• Configured OEM 12c monitoring. Created rules to send out mission critical alerts from production database.
• Oracle Certified 11g Database Administrator (OCA).

TECHNICAL SKILLS

Operating System: RHEL, Oracle Enterprise Linux and Windows 2000/2003/2008 server

Database: SQL Server 2014/2016, Oracle 10g/11i, Teradata.

Tools: SQL *Plus, SQL *Loader, Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Toad, Teradata SQL Assistant.

Languages: SQL, PLSQL, Spark SQL, Python.

Applications: Oracle 11i E-Business Suite Versions 11.5.10 and R12 Version 12.1.1

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Application Software Engineer

Responsibilities:

• Working on Palantir foundry tool to create contract entity modeling and design patterns for the automation of development and production environments.
• Reviewing Foundry architecture for Pipeline activities and maintain the standards for critical production timelines.
• Worked on Creating Ingestion Scripts, Cleaning and union operations, updating the Monocles for supporting the monthly production schedules.
• Analyze the business requirements and turn business logic into efficient SQL queries, ETL packages, stored procedures to extract data and compile them into Weekly/Monthly/Quarterly reports to Power BI and Micro Strategy Dashboards.
• Responsible for creating ETL packages data flows in SSIS and later migrating it to Azure Data Factory, building, deploying and executing the ETL packages for loading EDW Data warehouse data into SQL Server input tables and views for Analytics Applications from Optum for further processing in Power BI and Micro Strategy Dashboards.
• Integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and working on extensibility of data-integration using Azure-SSIS Integration Runtime (IR).
• Design and Create Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Macros and Triggers on Teradata and SQL Server Instances.
• Extensively used DataStage for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• Working on the design, development, deployment of Graphic visualizations with Drill Down and Drill through menu options, and Parameterization of the Reporting Dashboard reports with business KPI's in Power BI using DAX functions and maintaining its dashboards and reports up to date with Power BI Gateways.
• Create Fact/Core tables and Dimension tables in Teradata and SQL server back-end databases to support and store massive data used by the front-end Power BI Provider Analytics and Micro Strategy Dashboards.
• Develop Data Extraction, Transformation and Loading jobs from Teradata Source database into SQL Server staging databases using TPT Export, Fast Load, Multi load and using Stored procedures.
• Using Teradata PT (TPT) can simultaneously load data from multiple and dissimilar data sources, and extract data from and to Teradata Database and MS SQL Server Datasets.
• Extensively use SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task, etc. for performing data loads between different database instances which were used for data scrubbing, data validation checks, and optimizing its performance by tuning it during staging phase and development phases before loading the data into Production tables.
• Designed and documented the error-handling strategy in the ETL load process. Prepared the complete business specification document for all the ETL flows and implement Event Handlers and Error Handling in packages.
• Managed the metadata associated with the ETL processes used to populate the data warehouse using SSIS packages, extensively worked on identified the field/column level data quality issues of the source systems to drive the data quality by data deducing, data cleansing and error handling in the ETL mappings, identify and document the source to target mapping data lineage using SSIS and Azure Data Factory (ADF).
• Develop Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and for Error handling during the ETL process. Perform root cause analysis on failures and resolve performance tuning related issues and any bottlenecks in queries. Documented the development work and production releases for future reference.
• Working on Performance Tuning, Optimizing SQL queries through wait stats; Like fixing and reducing parallel Execution, Multi-Tasking Waits, IO waits, Locking Waits, Database Log Waits, and Waits on External Resources.
• Specializing in Design & Development of ETLs that load data from multiple sources (Teradata, SQL Server, Flat Files) into the Warehouse & Datamart using SSIS, Teradata Macros; Design & Development of SQL routines (Stored procedures, triggers) Queries, Teradata BTEQs and UNIX Shell scripts for data load & processing.
• Analyze and develop new codes to suggest new functionality and to support reusability. Development of Teradata BTEQs to Insert, Update, Delete the Target table data.
• Perform Backup and restore of databases to migrate Enterprise SQL Server Database instances data between Reporting SQL servers and Teradata instances, with Toad and work on deployment of latest services packs, content updates, patches and updates to Database Applications, and versioning it to SVN and later in Bit bucket.
• Validate change requests; work on appropriate recommendations to standardize the implementation process.
• Actively worked on optimizing and tuning the procedures and queries to improve performance and decrease run time and resource utilization in Teradata and SQL Server using Teradata Viewpoint, Dell Foglight and SQL Profiler.
• Schedule jobs through Cisco Tidal Enterprise Scheduler and Control-M Manager in different environments to carry out production tasks as defined in a schedule based upon business requirements and event conditions.
• Work with different Agile Methodologies which implies an iterative and incremental method of management for all the new and on-going projects.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, IBM DataStage, SSIS, SSRS, SSAS, T-SQL, MS Access, Palantir Foundry, Service Now, Jira, Tidal, Control-M, Teradata.

Confidential, Los Angeles, CA

ETL Developer

Responsibilities:

• Creating Report Parameters and Query Parameters to filter the data in SSRS based on business requirements.
• Modifying the existing Reports based on business requests.
• Created Stage Tables, Final Tables, Views, Stored procedures for fetching the data from different data marts and worked on SSIS Packages to automate the production run’s where the data will feed directly to Micro Strategy Dashboards for Provider portals and generating vendor extracts.
• Developed SSIS package for creating different database backup files for generating historical pools.
• Based on the requirement, analyzed the requirement and developed SSIS packages.
• Good understanding of Flat files data and configuration of flat files.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Marts.
• Created source table definitions in the DataStage Repository.
• Developed various SSIS packages and SSRS reports based on the requirement.
• Worked on various data migration activities to copy the data from multiple sources to SQL Server destinations.
• Involved in fine-tuning of SSIS packages, by eliminating Sort components.
• Model data using MS Excel, Access, SSIS, SQL and other data ware house analytical tools.
• Assist with determining work load and related activities for other Data Analysts.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSIS.
• Prepared the complete data mapping and Report Definitions for the project.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Designed and implemented PL/SQL packages to support process automation and legacy system integration.
• Assist management in driving business decisions based on data.
• Implemented checkpoint mechanism, created as many control flows as possible to improve the checkpoint functionality.
• Deployed packages in Test, Development and Production environments.
• Implemented SSIS error logging mechanism and redirected the warning and error messages to text file for audit logs.
• Configured environmental variables to support the configuration files which are used in SSIS Packages to automate the test environments.

Environment: SSIS, SSRS, T-SQL & UNIX, Teradata and SQL Server, PL/SQL, IBM Info sphere DataStage 8.5, Oracle 11g.

Confidential, Dallas

Oracle DBA/ Oracle Applications DBA 

Responsibilities:

• Managed and cloned full-sized development, testing, QA and Patch environments.
• Perform 2-tier clones of Oracle Applications 11i instances.
• Perform clones of Oracle Applications R12 with both Hot Backup and Cold Backup.
• Patched, configured, and maintained production, development, and testing instances.
• Formulated a comprehensive data migration plan with different conversion strategies, detailed object and field mappings.
• Setting up the environment for Oracle database by installing 11g as per the client requirement and later, per the requirement upgrading it to 12c.
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning.
• Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for the file system and CPU issues.
• Upgraded Oracle 11. .2.5 on Linux.
• Tuned DataStage transformations and jobs to enhance their performance.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Scheduled Datastage job using Autosys scheduling tool.
• Handling various application issues/problems related to Apache, Concurrent manager, Forms server.
• Support and maintain Oracle Applications 11i instances including production.
• Configured, and maintained production, development, and testing instances.
• Applying database and applications patches (Maintenance, mini-packs, bugs, technology and security patches) and cloning the databases.
• Administrating the Oracle Applications instances, User administration and patch management
• Create Database Objects for custom applications.
• Create and maintain custom responsibilities as per the client request.
• Backing up System & User databases by using different Backup strategies, scheduling the Backups. Restoring them whenever necessary.
• Configuring load balancing on client and server side and Monitoring RAC database on load tests and performance monitoring and generating reports for analyze and giving suggests to application teams and creating required Indexes for better performance.
• Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for the file system and CPU issues.
• Managing Responsibilities and adding custom responsibilities to users.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Worked with Oracle Support to solve open Service Requests.
• Creating database links, Materialized views as per the requirement.
• Performing daily and weekly health checks of various Databases. Installing and implementing new oracle apps modules and Products.
• Installation, Creation and Configuration of database.
• Upgrading and Migrating Oracle E-Business suites.
• Configure custom scripts for application and database backups and built DR rsync process for logs/out files.
• Configuring Workflow Notification Mailer.
• Creating temporary tablespace groups and assigning to users.
• User management, roles and Profile creation.
• Checking free space in data files.
• Tablespace management, Adding and resizing data files in tablespaces.
• Applying database patches using OPATCH utility.

Environment: s: Oracle 11i E-Business Suite Versions 11.5.10 and R12 Version 12.1.1, PL/SQL, IBM Web Sphere DataStage 8.1 Parallel Extender, Autosys