SUMMARY

• Over all 18 years of experience in Design/Development/Testing and maintenance of software systems in Telecom/Financial/Airline/Retail industries, 7+ years of experience in Enterprise Data Warehouse design, development and maintenance.
• Experience in building large Data Warehouse by integrating data from various data sources like Mainframe Datasets, Oracle, MySQL, Flat files and Near Real time systems.
• Very good understanding of Teradata Architecture MPP and components Parse Engine, BYNET and AMPs.
• Very good understanding about start schema and snowflake schema and slowly changing dimensions.
• ETL experience with Teradata utilities like Bteq, Fastload, Multiload and Fastexport and using ETL tool Datastage Enterprise Edition.
• Writing SQL queries in Teradata and Oracle databases.
• Using Hadoop HDFS shell interface commands.
• Developed Map/Reduce programs using ruby to apply the data standardization rules.
• Developed Hive SQLs to extract the data from HDFS into flat files.
• Development experience using C, C++, Java, Pro *C languages.
• Experience in developing Shell scripts, Perl scripts and Awk scripts for data validations, file transfers, common utilities.
• Experience in navigating in mainframes to search for datasets and job logs and transfer datasets to Linux server.
• Experience in complete SDLC - analysis, design, implementation and testing of Client/Server, Data Warehouse applications.
• Experience in using version control tools SVN and GitLab and
• Experience in using SVN and GIT commands on the server to deploy the changes.
• Experience in Applications/Systems Architecture.
• Experience in implementing data security policies to secure the PCI and PII data.
• Experience in Unit testing and supporting UAT testing.

TECHNICAL SKILLS

• Languages: C, C++, Java, Pro* C, SQL, PL/SQL, Osh, Hive SQL.
• Scripting Languages: Korn shell, Bash, Awk and Perl.
• ETL Tools: Ascential/IBM DataStage Enterprise Edition 7.5, Orchestrate 7.5.
• Databases: Tetadata(12.0, 13.0), Oracle, Cloudera Hadoop.
• Version Control Softwares: GitLab.
• Scheduling Tool: BMC Control - M
• Middlewares: MQ Series, Tuxedo
• Cloud Platforms: Google Cloud Platform (GCP)
• Operating Systems: Linux, Unix (AIX, HP-Unix, Sun Solaris, SCO).

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Build Lead

Softwares: Pro *C, C, Ksh, Bash, SQ, Oracle, Tuxedo, Linux, AIX, SVN.

Responsibilities:

• Work with scrum master to analyze the user stories and divide them to several technical tasks.
• Analyze each technical task and work with other developers and QA team to complete the technical tasks.
• Participate in sprint planning meetings with scrum master.
• Develop Pro *C programs to implement the technical tasks.
• Write the SQL queries to embed in Pro *C programs to select/update/delete the data in Oracle database.
• Develop various shell scripts to develop the batch jobs calling the Tuxedo services which contains the actual Pro *C programs.
• Using few Tuxedo commands to shutdown/reboot Tuxedo servers, check the Tuxedo services.
• Work with Branching and Strategy team to request for SVN branch.
• Work with environment team to request for environment needed to implement the project.
• Support the QA team in their testing tasks.
• Work with configuration and implementation teams deploy the code in lower environments and production environments.

Confidential, Chicago, IL

Sr. Unix Support Engineer

Softwares: C, Ksh, Bash, SQL, Awk, TFS, IBM Orchestrate, Control-M, ServiceNow, Linux.

Responsibilities:

• Support the jobs in production running in Control-M.
• Work and resolve the user created incidents in ServiceNow.
• Work with Data Warehouse team in any data related issue.
• Work on application performance improvements.
• Work on minor enhancements and bug fixes.
• Manage and work with offshore team members on various tasks.
• Provide the data for production support metrics.

Confidential, Hoffman Estates, IL

ETL Lead Developer/Architect/Application Admin

Softwares: C, Java, Ksh, Bash, SQL, Awk, Perl, Ruby, Bteq, Fastload, Fastexport, Multiload, GitHub/GitLab, Teradata SQL Assistant, Control-M, Teradata, Cloudera Hadoop, JIRA, Sun Solaris, Linux, Windows 7.

Responsibilities:

• Experience in working in Agile environment for project deliverables.
• Setup the meetings to discuss with business teams to understand the business requirements.
• Prepare the functional design documents to implement new functionality in C program application to parse mainframe Tranfiles.
• Worked on migrating CDW and CDI applications to GCP and experience in writing big query in GCP.
• Develop and Unit test the code changes made to C program.
• Responsible for making changes related to enhancement and bug fixes in C program and maintain the make file.
• Implemented the automation scripts for validating the output files created by C program before starting the ETL process.
• Developed and implemented several ETL scripts using Teradata utilities like Bteqs, Fastloads, Mloads and Fastexports.
• Use most of the HDFS FS shell commands to move the files from local file system to HDFS and vice a versa for analyzing the original data from sources.
• Responsible for application related code changes needed to support the CDH Hadoop version upgrades.
• Develop Hive SQL scripts to query data from HDFS and copy into flat files.
• Worked on server migration project to port the existing C, Java and Teradata ETL programs from existing Linux server to new Linux server.
• Implemented several ksh/bash shell scripts for developing common utilities, file validations scripts, file transfers scripts and environment setup scripts.
• Implemented seral functional changes in existing Perl program to handle the credit card encryption within Teradata system.
• Implemented major functional change in Perl wrapper script called from Control-M jobs which executes Teradata ETL scripts.
• Developed sever Perl subroutines to perform various tasks within a Perl program.
• Manage the server/system accesses for team members by working with Unix/Linux system admin team.
• Navigate on mainframes to search for datasets and job logs and transfer datasets to Linux server.
• Maintain PGP keys to add new PGP keys and delete old PGP keys from the key ring.
• Setup the new projects/groups in GitLab to maintain the source code. Maintain the accesses to team members for groups/projects in GitLab.
• Experience in using the GIT commands on server to deploy the source code changes.
• Responsible for version controlling the source code using SVN and GitLab.

Confidential, Hoffman Estates, IL

Release & Deployment Lead

Software: C++, Java, Korn Shell, Awk, Perl, SQL, Sun Solaris, HP UNIX, AIX, Windows 2003.

Responsibilities:

• Developed Methods and Procedures to effectively carryout the new deployment tasks for each application.
• Document the changes in the methods and procedures to keep them up to date and accurate.
• Actively participate in release walk thru meetings to understand the code changes applied to existing/new C++ programs and validate the tasks related to deployment team.
• Perform the build and deployment activities for C++ applications
• Analyze the release and deployment process to improve it.
• Developed automation scripts in KSH and Perl to perform the scheduled deployments.
• Perform SQL queries to validate the data and generate reports.
• Handled the major release work in the moth of 0912 and 1002.
• Maintenance and support of Non-Production and production environments.