We provide IT Staff Augmentation Services!

Programmer Analyst/system Analyst Resume

SUMMARY:

  • Over 15 years of experience as a Database Developer/Administrator/Operations Engineer.
  • Extensively involved in installations, configuration, database administration, account maintenance, database security, database design, replication, normalization, memory management, storage management and capacity planning.
  • Written stored procedures, triggers, functions and packages using T - SQL. Extensively involved in understanding user requirements, planning the creation of stored procedures, triggers and other system objects along with the follow-on performance monitoring and tuning, mirroring and memory management.
  • Provided 24x7 production support for various Database Applications on MSSQL Server 2005/2008/ 2012/2014/2016 on Windows NT and Sybase 10.x/11.x/12.x and Unix Platforms (HP-UX, Solaris 2.x, AIX, Linux)
  • Hands-on experience as an NT/Unix Administrator. Proficient in writing scripts. Involved activities like Backup, Disaster Recovery, Performance Tuning and Architecture
  • Hands on experience with various Hadoop Technologies like HortonWorks, Cloudera, MapR, Spark ThriftServer, Presto

TECHNICAL SKILLS:

O.S: Solaris 2.x, AIX 4.x, HP-UX 11.x/10.x, WIN 200x/NT, Linux (Ubuntu

RDBMS: SYBASE 10.x/11.x/12.x, SQL Server 7.0/ 2000/20, Oracle 8.x/11.x/12.x, Postgres 9.x, MySQL 5.x

Hadoop: Cloudera 5.x, Horton 2.x, MapR, Presto, Spark

Tools: Informatica ETL 4.7/5.1, Erwin 3.5, DB-Artisan 5.4.1/6.0, EXCEED, Lotus, SQL-Backtrack 4.1.0/4.3.0 , Tivoli Storage Manager, Veritas Cluster 1.3.0, Business Objects 5.0, APT Workbench, PB 7.0 and DWB, Visual Basic, Great Plains 2013/10.0, Tableau 8x/9x/10x

Scripts: PERL 5.0/5.6.0, Shell Scripting (k/b/c), PowerShell, Python

Hardware: SUNE 3500/450/250/ Ultra, HP9000/K210, Compaq Proliant Alphaserver, PCx86/Pentium, DELL PowerEdge

Languages: T-SQL, C#,.Net, Javascript, Backbone.js, Knockout.js, C/C++, Visual C++,, COBOL, FORTRAN, Pascal, BASIC, HQL

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst/System Analyst

Environment: Hadoop Technologies (Cloudera/HortonWorks/MapR/Presto), AWS (RDS/ EC2/RedShift), Confidential Azure, Confidential SQL Server 2012/2014/2016 , Analysis services (2012/2014), Postgres 9.x, MySQL 5.x, SAP Sybase ASE/IQ, MemSQL, Mongo 3.x (BI Connector), Tableau 9.x/10.x, Zabbix 3.x, Powershell, Python, VMWare vSphere 6.0

Responsibilities:

  • Setup ALWAYS ON clustering for SQL Server in production for TFS 2015.
  • Involved in setting up databases for Development teams in various database technologies that tableau supported on virtual machines and physical machines.
  • Created Hadoop clusters using different Hadoop technologies like Horton/Cloudera/MapR/Presto/Spark (Add/remove nodes/space, rebalance nodes, use different authentication mechanisms)
  • Loaded data on to them for testing as well as user support cases using Hive/Sqoop/Oozie workflows.
  • Setup Kerberos authentication for the different database technologies
  • Migrated databases from Virtual machines to Amazon EC2/RDS using AWS CLI and also configured different authentication like SSL
  • Configured databases on AWS on RDS (Mysql/Postgres/Redshift/EC2) and setup IAM, restored snapshots
  • Configured SQL Azure MSSQL database and configured firewall exceptions for different IPs
  • Configured SharePoint Servers and oData Services on Windows Environment
  • Wrote scripts in Powershell and Python for different needs like backups/Alerting/Zabbix API item, trigger creation, SQL jobs.
  • Configured MongoDB 3.x (BI connector) and loaded data using csv files and DRDL for the BI connector.
  • Created/maintained VMWare Virtual machines for both production and Dev environments. Use Powershell vCLI for different administrative activities on vMWare
  • Created various VIZ using Tableau to help with automate status info/DB info to end users and our team (instead of running queries on different technologies to gather the data).

Confidential

Programmer Analyst/System Analyst

Environment: MS SQL Server 2000/20 /2014/2016 , Windows 2000/20, Analysis Services 2000/20, Visual Studio 2010/2012, SQL Server Reporting Services, Linux, GitLab, ChilliProject, RackSpace, MongoDB, Powershell, Exchange, Active Directory, Great Plains 2013/10, JavaScript, Backbone.js, knockout.js, Tableau 8.1

Responsibilities:

  • Involved in Analysis, Design and Development in the migration of the trader website to Mobile workstations including Phone/pad devices.
  • Developed reports for Accounting/Trader Team Users/Operations for helping analyze the orders and troubleshoot issues using T-SQL Stored procedures, Views, Triggers.
  • Automated Processes for Freight Rate Changes to help our Logistics department to move Loads and publish it to various Load Boards for marketing and quick moving of inventory.
  • Worked on RackSpace servers for our external websites and involved in writing shell scripts to automate processes.
  • Automated several reports in SQL Server to email users and constantly interacted with them to help reduce their day to day manual operations.
  • Developed Cubes using Analysis Services for reporting purposes.
  • Involved in Migration of Legacy Reports from older SQL Server versions to SQL Server 2012.
  • Setup a backup system exclusively for reporting based on User requirements.
  • Migrated Databases between servers from older servers to current hardware. Troubleshooting and resolving various migration issues.
  • Upgraded the SQL Database and GP Interface from GP10 to GP2013. Provided backend support for GP and also developed auto-import invoice process using e-Connect from our frontend to GP db.
  • Developed multiple reports on Purchase Orders/Sales Orders to help our Accounting team to pinpoint discrepancies and quickly resolve them for month-end/year-end closing.
  • Helped with importing data from DOT website to help improve carrier prospects for our Logistics team.

Confidential

Programmer Analyst/System Analyst

Environment: MS SQL Server 2000/2005/2008 , Windows 2000/2003/2008 , Analysis Services 2000/2005/2008 , E.piphany, Visual Studio 2005/2008/2010 , SQL Server Reporting Services

Responsibilities:

  • Involved in developing and supporting KPI website( http://aiopskpis) for Audience intelligence to report the status of various Pipelines (AI Pipelines/CI Pipelines).
  • Developed various SQL store procedures, triggers, objects and performance tuned them for optimal response times. Troubleshoot and resolved issues with linked servers, SPN’s and also setup disaster recovery for the KPI feature.
  • Provided DBA support to all AI Data systems. Involved in High availability planning using clustering and log shipping.
  • Involved in troubleshooting performance issues in SQL Server and resolving them.
  • Involved in development/pilot of the Event Processing System for all the AI systems using .Net Workflows.
  • Involved in automation of features for ease of manageability and also reporting to Operations team as a whole.
  • 24x7 production support.

Confidential

Programmer Analyst/System Analyst

Environment: MS SQL Server 7.0/2000/2005 , Windows NT 2000/2003, Analysis Services 7.0/2000/2005 , Visio 2000, E.piphany, Visual Studio 2005/2008.

Responsibilities:

  • Provided 24x7 Production Support to the Various SQL Servers 2000/2005.
  • Involved in development of Stored Procedures, Triggers, Functions etc.
  • Written Stored Procedures to report the database Daily Usage and provided graphical representation using Excel.
  • Involved in release of various custom applications to production.
  • Maintain and troubleshoot the various MSSQL servers in various Production, Development and Preview Environments.
  • Involved in Database modeling and design.
  • Involved in Performance tuning and index tuning for the various database applications.
  • Involved in maintaining the Datawarehouse and Data Marts.
  • Migrated databases between Servers to use better hardware and for performance tuning the applications.
  • Provided 24x7 support for the Datawarehouse to keep the system up and running.
  • Involved in large scale production deployments and troubleshooting.
  • Created Maintenance plans for database backups and db maintenance tasks to achieve performance goals.
  • Used technologies like SAN snap/cloning to create replicas of databases.
  • Creating plans for archiving, reporting and also maintaining different security levels for these environments.
  • Involved in development of Notification Services using C# and SQL for automation of an Application Notification System on an Enterprise level.
  • Involved in developing and automating production processes using WorkFlow Foundation.

Confidential

Programmer Analyst/System Analyst

Environment: Sybase 11.9.x/12.x, MS SQL Server 7.0/2000, Oracle 8.x, UDB 7.0, Embarcadero Design Tools 5.4.1/6.0 (DB-Artisan, Schema Manager), Perl (5.0, 5.6.0), Windows NT 4.0, Sun Solaris 2.6/2.7, AIX 4.3.x, VERITAS CLUSTER 1.3.0, Replication Server 12.0, Informatica ETL 5.1, SQL-Backtrack 4.3.00

Responsibilities:

  • Upgraded Sybase Servers to version 12.x from 11.9.x on heterogeneous (Sun Solaris, AIX and NT) platforms.
  • Installing/Upgrading the SYBASE servers / MSSQL Servers.
  • Setup, Configure and Maintain Warm Standby database using Replication Server 11.5/12.0 for Sybase and Configured Replication on MS SQL Server using Publisher, Distributor and Subscriber method.
  • Provided 24x7 production support, which involved database administration of about Sybase servers, MS-SQL Servers and Oracle Servers. Database size varies from 10GB to 500GB.
  • Upgraded SQL-Backtrack from 4.1.00 to version 4.3.00 and ADSM from 2.4.1 to 2.5.00.
  • Used SQL-Backtrack for the various database Backups and Recovery operations.
  • Wrote Shell Scripts to automate the process of SYBASE Shutdown and Startup Procedures.
  • Wrote batch files and shell scripts for the various activities like database backups, refreshing databases and update statistics. Scheduled the scripts using CRON.
  • Developed stored procedures and triggers as part of the back-end development.
  • Other activities included performance tuning of the server as a whole, tuning various application specific queries.
  • Provided Support for the various ETL 5.1 developments to install/configure Open Client to connect to the Sybase/MSSQL/Oracle/UDB databases.
  • Created Mappings, Transformations using Power Center 4.7/5.1 Mapping Designer.
  • Create and Maintain Repository using Repository Manager.
  • Created and executed various DTS packages in MS-SQL server for Data Transformations.
  • Used import/export utility for Oracle for various data transfer operations in Oracle.

Confidential, San Francisco, CA

Programmer Analyst/System Analyst

Environment: MS SQL Server 6.5/7.0/2000 , Windows NT 4.0/ Windows 2000, Perl 5.6.0,

Responsibilities:

  • Identified Schema differences in the Production Databases and automated the schema synchronization of about 100 databases (Sizes varied from 1 GB to 20 GB).
  • Provided 24x7 Production Support for MSSQL 7.0/2000 as well as SYBASE 11.x/12.x Database Servers.
  • Manage the Directory extract for Various Clients (Microsoft, AltaVista, Excite).
  • SQL Server 7.0 Installation and Rebaselining.
  • Configured and Manage Confidential Cluster Server on WINDOWS NT.
  • Used DTS packages to Import/Export Data between servers and databases.
  • Plan, test and Migrate from SQL 7.0 to SQL 2000. Designed SQL Scripts to help the QA in their testing.
  • Setup, Test, implement and manage Replication of databases in the development environment and production environment.
  • Maintained the Development, Pre-production and Production Environments (Servers were located at various locations in Europe, Asia and US).
  • Involved in release of the various custom client applications to Production.
  • Designed Scripts for Users management and Security for SQL Server.
  • Written Scripts (Batch and T-SQL) for the daily extracts.
  • Developed T-SQL scripts including triggers, procedures.
  • Troubleshooting data on Unix machines for correctness of data for Site Updates.
  • Developed Scripts to automate various database processes like BCP, Update Statistics, Database loads/dumps.

Confidential

Programmer Analyst/System Analyst

Environment: MS SQL Server 6.5, Windows NT 4.0, Sybase 11.5.1, Sun-Solaris 2.x

Responsibilities:

  • Setup, Manage and troubleshoot Replication.
  • Monitored the system activity relating to security, performance and general functioning.
  • Scheduled the regular system, backup and recovery and transaction log dump schedules
  • Created separate devices for taking transaction log dumps.
  • Managed User Security and permission
  • Tuned queries for better performance.
  • Created a backup for the production server.
  • Written Scripts for DBCC, Update Statistics and generation of Schemas using system tables.
  • Setting up of Replication Server using the Warm standby
  • Implemented replication by replicating to an external server using replication definitions and subscriptions.
  • Wrote shell scripts to ease creation of logical connections.
  • Wrote scripts to switch from primary to standby to assist in disaster recovery

Hire Now