PROFESSIONAL SUMMARY:

• 6 years of experience in SQL Data Analyst and Environment Management.
• Knowledgeable in Banking, Capital Market, Retail and Natural Gas domain.
• Experienced in Data Analysis, validation and interpretation of data in order to ensure projects align with business goals of corporate clients.
• Experienced in Environment management, Environment planning, Resource management, Risk/Issues management, and Change management.
• Experience with Teradata using SQL to create database objects like DDLs, Tables, Views and Procedures.
• Used Hive to analyze teh partitioned and bucketed data.
• Created Indexes on tables for new database to faster retrieval of data for teh Reports.
• Used Temp Tables to reduce teh number of rows for joins, to aggregate data from different sources for different reports
• Performed Importing and Exporting data from Snowflake, Redshift to Teradata.
• Experience in working on BMC Workload Automation as Control - M Administrator, scheduling Production batch and calendar requirements as per business requirement to ensure continuity of business services.
• Experience in SQL for generation of reports and business data analysis with Teradata.
• Expertise in Client-Server application development using Oracle12C/11g/10g.
• Expertise in developing and customizing UNIX performance Reports using Python and Shell Scripting.
• Experience in teh area of analysis, design, development, implementation and Production Support of complex Servers with applications using Oracle, WebLogic.
• Excellent understanding of Software Development Life Cycle (SDLC) phases such as Analysis, Design, Development, Implementation and Support.
• Facilitating meetings between stakeholders, Preparation of weekly status reports and initiate/coordinate weekly and monthly status meetings and suggesting process improvements.

TECHNICAL SKILLS:

Operating Systems: AIX, Linux - RHEL, Oracle Linux 6.6, CentOS.

Languages: UNIX Shell Scripting, PL/SQL and PYTHON.

Job Scheduler: BMC Workload Automation 7 and 8, 2.2.4

Application Servers: Oracle12C/11g/10g, Oracle Application Server, WebLogic - Oracle Fusion Middleware

Tools: Teradata Studio, Teradata SQL Assistant, Putty, Putty CM, SQL, Teradata, Xmanager, Control-M, PRTG network Monitoring Software, DynaTrace Application Monitor, BMC Workload Automation.

WORK EXPERIENCE

Data Analyst and Environment Management

Confidential, Rhode Island,

Responsibilities:

• Worked on analyzing incremental lift in sales and visits for stores due to promotional campaigns, including mailing, e-mailing, and MMS, using statistical models; improves customer retention by 15%.
• Analyze, validate and interpret data in order to ensure projects align with business goals of corporate clients
• Use a variety of technologies including proprietary and open source software to implement solutions to complex data-related problems
• Maintain, extract and query databases and processes in order to reconcile inventory discrepancies and accurately map forecasts
• Experienced in SQL for analyzing CVS billing system on Mainframe platform.
• Co-ordination with stakeholders on multiple job sites including 3rd party vendors on receiving firm critical files/reports for processing/validation of business data for CVS.
• Scheduling Control-M jobs on control-M server for processing teh files and Implementing Job schedule changes for impacted files.
• Impact analysis of client billing system by closely working with Business Analysts.
• Develop reporting requirements and specifications with business and product development teams
• Develop weekly reports illustrating key figures and trends and outlining progress for all Data Strategy team members
• Consistently meet deadlines for timely delivery of projects through database management and ad hoc queries
• Analyzed value of customers by generating reports to classify potential customers for certain events.

Environment: Teradata, Teradata Studio, Teradata SQL Assistant, AWS, Github, Unica, Snowflake, Alexandria(S3 Feature Library), Shell Scripting, SQL, Python, Linux - RHEL, CentOS, Control-M Enterprise Manager version 7.0.0, SFTP.

Data Analyst and Environment Management

Confidential - Confidential USA

Responsibilities:

• Expertized on Teradata statistical models with SQL Assistant and Teradata Studio for analyzing incremental lift in sales due to promotional campaigns.
• Created SQL scripts to perform data extraction, manipulation and maintaining data model.
• Generated DDL for DB objects like Tables, Views and Function etc.
• SQL tuning and knowledge of Cursors for performance optimization.
• Created Indexes on tables for faster retrieval of data.
• Used Temp Tables to reduce teh number of rows for joins, to aggregate data from different sources for different reports
• Maintain, extract and query databases and processes in order to reconcile inventory discrepancies and accurately map forecasts
• Generation of adhoc reports and business data analysis using SQL and shell scripting.
• Develop reporting requirements and specifications with business and product development teams
• Use a variety of technologies including proprietary and open source software to implement solutions to complex data-related problems
• Develop weekly reports illustrating key figures and trends and outlining progress for all Data Strategy team members
• Consistently meet deadlines for timely delivery of projects through database management and ad hoc queries

Tools/Environment: Teradata, Teradata Studio, Teradata SQL Assistant, AWS, Github, Unica, Snowflake, Redshift, Alexandria (S3 Feature Library), Shell Scripting, SQL, Python.

Environment Management

Confidential

Responsibilities:

• Provide day to day update to business on critical application jobs running in TISMP.
• Scheduling of control-M jobs on BMC control-M server.
• Exporting Control-M jobs from Production to TTD servers as per project requirements.
• Management of Control-M stacks - Scheduling, Monitoring, Reporting and Troubleshooting.
• Installation of control-M agents on specified nodes to schedule control-M jobs.
• Perform system startup/shutdown, Backup strategy, Documentation, User Management, Security and Network management.
• LVM in AIX and RHEL flavors.
• Configuration and maintenance of NFS, DNS, SMTP, Auto FS, Samba for Linux Environments.
• Analyze server logs, problem determination, recovery and restart.
• Installation, configuration and maintenance of WebLogic application.
• Maintaining updated documentation of all teh Servers and installed applications.
• Analyze server logs, problem determination, recovery and restart.
• Installation, configuration and maintenance of WebLogic application.
• Knowledge transfer to newly joined team members.
• Expertise in developing and customizing UNIX performance Reports using Shell Scripting.
• CreatedShell Scriptsaccording to teh needs of teh project/client requirements to handle Database Daily archival and weekend maintenance process.

Tools/Environment: Linux, SQL, AIX (5.3, 6.1 and 7.1), Linux - RHEL (5.9, 5.11-Tikanga, 6.7, 6.8- Santiago), CentOS (6.5), Weblogic (Oracle Fusion Middleware), Oracle12C/11g/10g, Putty, DynaTrace Application Monitor, UNIX Shell Scripting, Xmanager, BMC Workload Automation Control-M 7 and 8

Environment Management

Confidential

Responsibilities:

• Build and manage RHEL and CentOS servers as per HLD for Smart Meter project.
• Installation of PRTG monitoring tool on all teh Linux/Solaris servers and constantly monitoring teh same.
• Installation of Sophos Antivirus software on all teh Linux servers.
• Installation of patches, Security fixes, packages on Linux servers.
• Build documentation for installation of RHEL and CentOS servers.
• Installation and configuration of VMware tools on Linux machines.
• Responsible for support activities like User Management, Storage Management, Filesystem creation, deletion, resizing and renaming, Permissions/Remote Copy of files, firewall settings.
• Work on enhancements of teh system as per requirements and/or Change requests.

Tools/Environment: Linux - RHEL (5.9, 5.11-Tikanga, 6.7, 6.8- Santiago, 7.2-Maipo), CentOS, PRTG network Monitoring Software.

Environment Management

Confidential

Responsibilities:

• Experience in SQL for generation of reports and business data analysis with Teradata.
• Time-to-Time Support of Applications like Oracle Database, Oracle Weblogic running on teh AIX/Linux Servers.
• Installation of Dynatrace - performance monitoring tool on Linux servers.
• Build and manage RHEL and CentOS servers as per HLD.
• Schedule scripts for FS, Disk, Memory, CPU usage and trigger mail for monitoring.
• Work closely with teh business team in gathering teh system requirements.
• Provide day to day update to business on critical application jobs running in IGMS.
• Installation, configuration and maintenance of WebLogic application.
• Expertise in developing and customizing UNIX performance Reports using Shell Scripting.

Tools/Environment: SQL, Oracle 12C/11g/10g, Weblogic (Oracle Fusion Middleware), BMC Workload Automation Control-M 7, AIX (5.3, 6.1, and 7.1), Linux - RHEL (5.9, 5.11-Tikanga, 6.7, 6.8- Santiago, 7.2-Maipo), CentOS (6.5), UNIX Shell Scripting, Putty, Xmanager.

Environment Management

Confidential

Responsibilities:

• Experience in administration, troubleshooting, tuning and security of IBM AIX, Linux servers.
• Experience in installation of application software’s like WebLogic server on AIX/Linux platforms.
• Scheduling of control-M jobs on BMC control-M server.
• Installation of control-M agents on specified nodes to schedule control-M jobs.
• Co-ordinate and work on setting up new Control-M server, re-scheduling of jobs with configuration changes based on project requirements and plan for migration of control-M from version 2.2.4 to version 8.
• Good knowledge on User Management, Disk/Volume group Management, Filesystem creation, deletion, resize and renaming, setting up Cron jobs, changing kernel parameters.
• Experience in monitoring teh availability & performance of RHEL servers using tools like nmon, sar, mpstat, topas, vmstat, netstat, iostat and top and familiar with SMITTY tool in AIX.
• Experience in DNS, NFS, Samba, SMTP, FTP, remote access, security management and system troubleshooting skills.
• Develop skills on UNIX scripting and automate few activities in IGMS application, reducing considerable man-hours.

Tools/Environment: BMC Workload Automation and control-M 2.2.4, AIX (5.3, 6.1, and 7.1), Unix Shell scripting, Oracle 12C/11g/10g, CentOS (6.5)