We provide IT Staff Augmentation Services!

Data Analyst And Environment Management Resume

Rhode, Island

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)

Hire Now