SUMMARY:

• System architecture and software engineer with 12+ years of extensive experience in architecting and administering infrastructure for complex Enterprise Applications.
• Specialized in implementation, design, business continuity, application, configuration, installations, clustering and consolidation solutions, system maintenance, troubleshooting, performance monitoring and solutions.
• Proven technical and architectural skills in managing mission critical large - scale applications, combined with exceptional interpersonal and communication skills.
• Highly motivated team player with sincere work ethic, focused on delivering bottom line value to the organization.
• Designs integration service interfaces & schemas using industry standards, patterns and canonical representations.
• Possess expertise in software design process including requirements gathering, design, interface implementation, testing and maintenance.
• Expertise in all the phases of the project life cycle (SDLC) implemented in both waterfall and agile (Scrum) models.
• Experience in design and development of TIBCO Business Works, TIBCO Administration, EMS, TIBCO Business Events, TIBCO Business Events Decision manager, TIBCO AMX BPM and TIBCO Business Studio.
• Experience in web services using SOAP, Restful services.
• Splunk installation on multiple servers using AWS system manager.
• Administering SQL Server 2000/ 2005/2008/2008 R2/2012/2014 in Production, QA and Development environments and knowledge on SQL Server 2016/2017
• Ability to work independently, take ownership and deliver quality product on time.
• Profound understanding of Web services, deployment in load-balancing and fault tolerant environment.
• Led the support and maintenance of more than 120 odd BW interfaces and 3 BE interfaces integrating with Mainframes, HP Exstream and several service providers for Allstate insurance.
• Worked on implementing automated ear creation of TIBCO BW components from ANT/MAVEN script for all the environments (DEV, TEST, QA, Pre -Prod, and PROD).
• Expertise in installation and configuration of TIBCO AMX BPM server in Linux environment.
• Experienced in services using Business Works 5.x/6.x, Enterprise Message Service (EMS)/JMS, TIBCO Adapters, JAVA, SOA, SOAP, REST, JSON, SQL, Micro Services and Unix/Linux.
• Experienced in executing automated unit and performing tests of integration services.
• Administering very large databases (VLDBs)
• Setting up High Availability using Always On, Log shipping, Replication and Mirroring
• Setting up SQL Agent jobs and alerts, DB Mail, Maintenance Plans
• Devising Backup strategies, Capacity Planning and Security Management
• Migrating Enterprise Edition to Development Edition on lower lanes.
• Troubleshooting and query/performance optimization
• Using SQL Server tools (SSMS, Profiler, Configuration Manager etc.)
• Using Third-party client tools (Oracle, Sybase, DB2, MySQL clients etc.)
• Using Resource Governor and Policy Based Management
• Developing and deploying SSIS/DTS packages
• Expert in creating Jobs, Alerts, Notifications, proxies, Database Mail, operator and Agent.
• Using Backup tools like Lite Speed, NetBackup and Avamar
• Preparing SQL Server Build Standards and Security Baseline documents
• Building UAT and DEV environments for SQL Server
• Experience in creating virtual machines and images for SQL Server on Hyper-V and VMware environment.
• Provisioning VMs in Microsoft Private cloud environment
• Hands on Experience in SSRS for trouble shooting the issues
• Hands on Experience in SSIS for trouble shooting the issues
• Hands on Experience in creating reports for the database analysis
• Automating activities/tasks in Microsoft Private cloud environment using SMA Runbooks
• Provisioning and administering Virtual Networks, EC2s and SQL Databases in AWS environment
• Setting up and administering SQL Server Analysis and Reporting Services environments
• IIS and developing applications using .Net technologies
• Strong ability to learn new technologies quickly and adapt to changing environments
• Assists with evaluation of Proof of Concepts (POCs), project estimation and engages in performance testing and tuning activities.
• Install, patch, monitor, diagnose, performance tune Tibco software.
• Provide 24x7 third-level support.
• Provide SME advice on architecture, design, and implementation of new projects and deliverables to applications.
• Follow best practice implementation process - checklist, pre/post implementation validation and checkout, exercised backout procedures for platform stability and high success rate.
• Analyze and performance tune the Tibco platforms.
• Develop and manage Hawk rules.
• Devise automation and autonomics trigger and scripts for best performance, self-tuning, and outage avoidance.
• Experience on working with the vendor in root cause analysis, managing tickets, collecting doc, devising workarounds, taking corrective or preventative actions, and implementing vendor fixes.
• Abide by all requirements from Security, Compliance, and Audit.
• Keep all platforms at supported software levels and apply CIS security patching.
• EMS migration from 7 to 8 version
• Hawk migration from 4 to 4.5,5.0
• Tibco Ear deployment in AWS cloud using CI/CD pipeline
• Tibco Monitoring logs in Cloudwatch service in AWS.
• Git Hub version control experience to deploy the achieve files in Jenkinns.
• Have received manager and client appreciation for the work done in the projects.
• Awarded with Star Performer honors for automating the daily health scripts and significantly reducing the manual support activity needed for trading applications.
• Facilitated TIBCO training and got BEST Facilitator Award.
• Engaged directly with the clients on multiple projects and have been appreciated by the clients for excellent work.
• Have a high level of aspiration, looking for more challenging and responsible work that offers professional growth while being resourceful, innovative and flexible.
• Received Spot Award for fixing critical defects in production.

TECHNICAL SKILLS:

Skills: Tibco BW, Tibco Ems. Tibco RV, Tibco Hawk, TEA 2.2, Solaris, Redhat Linux, Window 2012/2016, BI (SSIS, SSRS, SSAS), MSSQL 2008/2012/2014/2016 , Maximo, BMC Remedy, PowerBI

Languages: English

RELATED EXPERIENCE:

Confidential

TIBCO Developer /ETL Developer

Environment: TIBCO Business Works, TIBCO AMX BPM, SQL database server, TIBCO EMS, SVN, Putty, Win SCP, Windows and UNIX, MSSQL 2014/2016,Autosys,Fog-light

Responsibilities:

• Expertise in all the phases of the project life cycle implemented in scrum model.
• Gathering technical information and other business, technical clarifications for the sprint.
• Preparing the Solution Design Documents.
• Building Inbound and Outbound BW Interfaces for the BPM flow.
• Conducting Unit testing and Integration testing for the developed Modules.
• Attending Daily stand-up calls for updating project status to on shore team.
• Delegating the work to the offshore team and doing code reviews and code review check lists.
• Providing support to Testing team to resolve the issues during testing.
• Preparing the EMS Intake sheets for the queue’s creation and DB scripts.
• Patching support for Tibco hawk 4.9 to Tibco hawk 5.2.
• Working with vendor to resolve the issue while upgrades
• AWS system manager to deploy the scripts on multiple environments using tag and version based.
• Monitoring the alerts using business rules and deploying in Tibco Hawk.
• Creating Queues and Topics using Spring Framework for JMS.
• SSIS packages by migrating to a SQL server database with SSIS integration services using SSDT tools.
• Performed tests on SSIS packages to ensure compliance with business requirements and clearly documented testing methods used.
• Created Datamart databases for OLAP for analytical processing.
• Creating SQL secondary files to partition the data on the database.
• Migrated the SQL server agent jobs from SQL server to Auotsys monitoring tool.

Confidential

Responsibilities:

• Identify several solutions with the Corporate Real Estate, Corporate Security and other business.
• Installing and configuring the Dynamics product and analyze the solution to reduce code effect.
• Interaction with client right from the requirements stage to delivery of the application.
• Coordinate with client and vendors in case of production issues.
• Performing the scrum methods to find the causes of the issues bases on security compliance.
• Developing BDA actions, templates and patch packages for SQL Server releases using Perl, VBScript and/or PowerShell scripts
• Participating in meetings with all the SQL Server DBA team managers across the Bank
• Developing nested algorithms to reduce the cost of solution in all stages of development
• Performing Unit-Testing on each piece of the stage to maintain the low error standards.
• Created and managed over 25 SSIS packages by migrating to a SQL server database with SSIS integration services using SSDT tools.
• Performed tests on SSIS packages to ensure compliance with business requirements and clearly documented testing methods used.
• Tibco BW integration tool for converting JSON files to CSV format for application delivery.

Confidential

TIBCO Developer

Environment: TIBCO Business Works, TIBCO AMX BPM, Oracle database, TIBCO EMS, SVN, Putty, Win SCP, Windows and UNIX, oracle 11g.

Responsibilities:

• Expertise in all the phases of the project life cycle implemented in scrum model.
• Gathering technical information and other business, technical clarifications for the sprint.
• Building Inbound and Outbound BW Interfaces for the BPM flow.
• Deployments of DAA and EAR in TIBCO AMX administrator in Dev.
• Deployment of the BW and AMX decision components.
• Conducting Unit testing and Integration testing for the developed Modules.
• Attending Daily stand-up calls for updating project status to on shore team.
• Delegating the work to the offshore team.
• Coordinating with people across various locations.
• Ensuring and assuring qualitative deliverables.

Confidential

TIBCO Developer

Environment: TIBCO BW, TIBCO EMS, TIBCO Administrator, TIBCO Business Events 4.0TIBCO Business Events Decision Manager, SQL Developer, Team Foundation Server (TFS), ITSM Service Now, HP Quality Center, WRQ Reflection.

Responsibilities:

• Created low level design documents.
• Involved in Design review board meetings.
• Development of TIBCO BW and BE Interfaces as per the Design Documents.
• Involved in designing the technical document which depicts the interaction between Business Events and Business Works.
• Implementing Concepts, Events, and Business Rules using Business Events.
• Created CDD file and Build the EAR’s on Business Studio.
• Preparation the Deployment Instructions spread sheets for Production deployments.
• Preparation of production implementation plan and maintenance and Unit Test plans.
• Fixing the Production Defects and resolving the issues based on the priority.
• Creating Change Orders and co-coordinating Release Management for every major and minor Release.
• Development of TIBCO Interfaces as per the Design Documents.
• Preparation the Deployment Instructions spread sheets for Production deployments.
• Preparation of production implementation plan and maintenance and Unit Test plans.
• Fixing the Production Defects and resolving the issues based on the priority.
• Creating Change Orders and co-coordinating Release Management for every major and minor Release.
• Providing support to Testing team to resolve the issues during testing.
• Preparation the Deployment Instructions spread sheets for Production deployments.
• Preparation of production implementation plan and maintenance and Unit Test plans.
• Fixing the Production Defects and resolving the issues based on the priority.
• Creating Change Orders and co-coordinating Release Management for every major and minor Release.
• Providing support to Testing team to resolve the issues during testing.

Confidential, Charlotte, NC

Senior SQL Server DBA

Responsibilities:

• Building and configuring SQL Server standalone/Clusters and other components
• Managing security on Production and Development environments
• Upgrading SQL Servers and migrating databases
• Administering Very Large Databases (VLDBs)
• Automating regular DBA tasks using Windows PowerShell, VBScript
• Installing SQL Server Service Packs and Hotfixes
• Setting up HADR features - Log Shipping, Replication, Mirroring, Clustering
• Building shared SQL Server environments which can be used by multiple teams
• Building and configuring SQL Server QA, DEV and Test environments
• Setting up monitoring tools to monitor the database environment
• Devising and implementing Backup and Recovery strategies
• Resolving disk space issues and other production related issues
• Scheduling DBCC checks and index rebuild/reorganization
• Importing data using Bulk Copy Program (BCP), Integration Services (SSIS) from various data sources
• Creating and deploying SSIS packages
• Building and configuring SSAS and SSRS environments
• Creating and deploying various reports using SSRS
• Analyzing the performance of database servers and fine-tuning the environment
• Participating in meetings with LOB managers

Confidential

System Support

OS: Windows Server 2003/2008(R2/RedHat Linux 5/6/Solaris 8/10

Database: SQL Server 2005/2008/2008 R2/2012/2014

Scripting: PowerShell, Bash Scripting

Responsibilities:

• Worked as UNIX administrator L3/L2 level support for Remote Administration production support, installed various applications and software in UNIX environments.
• Patched the entire higher version on the servers for support from Vendors.
• Setup clusters on the critical applications supporting failover and high availability requirements.
• Working on change requests.
• Working on Firmware upgrades on the servers.
• Troubleshooting the file systems issues.
• Increasing the file systems on both the Windows and Linux servers.
• Troubleshooting the storage issues on the servers.
• Involved in CAB meeting for requests based on severity, BCP tests with application teams, worked closely with SAN/NAS teams
• Worked closely with Network Teams to find out Root Cause Analysis for drops in Critical data centers and developed Health Check Scripts at server levels.
• Worked closely with Backup teams and installed Backups and ran the backup jobs for critical servers.
• Supported 24/7 for production issues at all levels of the server and created SOP for support and process improvements.