Business Operations Analyst/project Implementation Resume
SUMMARY
- PROFILEAccomplished, passionate and committed senior IT professional wif eight (8) years of outstanding programming, analytical, support and communication skills, demonstrated ability to adapt to complex situation and willingness, valuable problem solving abilities, exceptional flexibility (willingness to relocate wifin the US and internationally, and a constant desire to exceed expectations; excellent oral and written communication skills (Fluent in French); very detailed oriented, deadline driven; strong ability to excel in a culturally diverse environment; self - starter and leader who is equally TEMPeffective working alone or as part of a team.
TECHNICAL SKILLS
Database: Oracle 9 10G, 11G, SQL Server, Netezza, Teradata, Sybase.
Software and Utilities: DNS, DHCP, WINS, Active Directory Services, MS Exchange Server, Terminal Service, Exchange Server, Telnet,MS Internet Explorer, MS Word, MS Access, MS Excel, MS PowerPoint, MS Outlook, MS Project, MS Visio, Microsoft Visual Source Safe, FTP, SFTP, Cisco VPN System Client, BrightStor ArcServe Backup, Netbackup, Adobe Reader, Heat, Test Director, Heat, SDE (Service Desk), Remedy, Clear Quest, Tidal Scheduler, Autosys Scheduler, Control M, CBSS AS400, Sterling Commerce Connect Direct V 4.0, SQL +, Telnet, HTML, WS FTP Pro, Putty, Informatica 8.6.1/9x, Microsoft .NET, VEdit, PGP, GNUPG, Chrystal Reports, AS400, Data Junction Integration Studio, TOAD, Cognos, MicroStrategy, Gomez, TCP/IP, Netcool Xenoss, Adobe Illustrator, Adobe Photoshop, Websphere, Jboss, J2EE, F5 BigIP load balancer, Oracle Enterprose Manager, Oracle SOA suite, Xenoss, VMWare Vphere, Netscaler, Netcool, Nagios, Solarwind.
Outstanding Achievements: Increased data center productivity by 20% by responding and resolving hardware and software issues in a timely fashion. Decreased company service cost by 10-15% by using excellent troubleshooting and problem solving skills. Successfully lead and trained NOC Technicians.
PROFESSIONAL EXPERIENCE
Confidential
Business Operations Analyst/Project Implementation
Responsibilities:
- Support full implementation and provide services for application support activities as part of the Data transfer systems in production, specially CISCO scheduler products TIDAL and IBM file transfer Connect Enterprise.
- Work wif partner teams (Interfacing applications/Infrastructure/Engineering/Development/Release Management) to resolve all outstanding issues towards these applications.
- Perform efficient work for keeping the highest quality support level
- Work wif the TMO support teams to assist wif their daily work.
- Executing small projects led by the team.
- Work on adhoc requests, audits and other reporting as and when required.
- Ensuring required SLA/KPI levels for application.
- Be able to work independently wif all production application support teams
- Analyse all production intakes, defects and remedy tickets opened by the end customer and prioritize them for immediate resolve and/or long term fixes.
- Provide excellent and quality on call support as and when needed.
Confidential
Linux System Administrator
Responsibilities:
- Perform regular security monitoring to identify any possible intrusions, also enrolling users and maintaining system security.
- Maintains documentation on configuration and interface specifications; tests and certifies client data transmissions for successful integration wif backend systems.
- Automates creation and export of data files for recurring reporting requirements.
- Performs daily system monitoring, verifies the integrity and availability of all hardware, server resources, systems and key processes, reviews system and application logs, and verifies completion of scheduled jobs such as backups.
- Performs regular security monitoring to identify any possible intrusions; enrolls users and maintains system security.
- Performs daily backup operations, ensures all required file systems and system data are successfully backed up to the appropriate media, creates recovery tapes or disks; recycles media and sends it off site as necessary.
- Performs regular file archival and purge as necessary; assists in systems administration of servers in remote locations.
- Provides Tier II/other support per request from various constituencies and investigates and troubleshoots issues.
- Maintains servers at local datacenter including repair and recover from hardware or software failures; coordinates and communicates wif impacted constituencies.
- Monitors and manages OS and UNIX operating system software, system hardware and application performance, assists in upgrades of servers.
- Provide database administration and management wif Linux/UNIX/Microsoft platforms/environments/tools (including operational and monitoring features).
- Monitor oracle Databases using Oracle Enterprise manager.
- Perform Oracle database maintenance, perform deployment in SOA suite, creation of Data sources, JMS destinations, securing web services.
- Monitor the daily performance of the production environment.
- Provide a support on any kind of Infrastructure changes affecting the Oracle/MS SQL Server databases.
- Perform operational aspects of high availability (clustering and related, including replication) solutions, and database security related concepts and designs (SOX compliance).
Confidential, MD
Business Analyst
Responsibilities:
- Analyzed data from the consumer usage of interactive products in an Oracle environment.
- Assisted in creating Project Plan, Road Map. Designed Requirements Planning and Management document.
- Performed Enterprise Analysis and actively participated in buying Tool Licenses.
- Identified subject - matter experts and drove the requirements gathering process through approval of the documents dat convey their needs to management, developers, and quality assurance team.
- Performed technical project consultation, initiation, collection and documentation of client business and functional requirements, solution alternatives, functional design, testing and implementation support.
- Requirements Elicitation, Analysis, Communication, and Validation according to Six Sigma Standards.
- Captured Business Process Flows and Reengineered Process to achieve maximum outputs.
- Gatheird and documented Use Cases, Business Rules, created and maintained Requirements/Test Traceability Matrices.
- Co-oordinated wif the off shore QA Team members to explain and develop the Test Plans, Test cases, Test and Evaluation strategy and methods for unit testing, functional testing and usability testing
Confidential
Data Warehouse Support Engineer
Responsibilities:
- Identified need for environment release and maintenance; collaborated and assisted project team wif change management process.
- Scheduled and implemented changes in informatica environment; tested and reviewed testing results; supported production environment 24/7; wrote shell scripts to automate processes.
- Troubleshot, analyze, and fix Business/Sales/Inventory report in Micro strategy and other reporting tools.
- Identified production failures or errors and managed tickets through incident management process (leading bridge call, contact impacted users, root cause, resolution, monitoring and communication).
- Created and updated Informatica workflow and mappings using SQL and Unix to support daily production issues.
- Developed, update and modify SQL queries and Unix script to troubleshoot data issues/loads on Oracle, Netezza, SQL SERVER Database, sourcing from Flat File, XML file, Oracle and Netezza Database, and conducted impact analysis.
- Identified performance issues and corrective actions, in Unix, Oracle, Netezza, and Informatica environment.
- Schedule, Support, Monitor and Troubleshoot Autosys batch job.
- Troubleshot application errors on Unix web servers in order to restore availability.
- Created, managed, tested and installed FTP accounts, SSH keys and Public Keys for SFTP accounts setup.
- Supported web applications using Weblogic, JBoss, Tomcat, Websphere, HTML, XML and JavaScript.
- Strong understanding of UNIX environment, shell scripts and triaging and understanding production issues logs.
- Performed user account management, folder creation/ permissions, repository upgrades, software installation, upgrades, troubleshooting, and maintenance in a hybrid Solaris, Linux and Informatica environments.
- Administered and configured workstations to ensure connectivity to servers, databases, and applications
- Troubleshot and analyzed OS and hardware errors on systems and coordinate wif Sun Microsystems to obtain replacements for defective hardware and applied firmware and patch updates to systems
- Maintain Subject Matter Expertise in many business areas and conducted 24/7 on - call support rotation.
- Work wif the team to ensure the quality of coordinated business functions.
- Participate in design and maintenance of enterprise architecture.
- Perform code deployments to QA and Production Environments, data migrations and data loads.
- Create, maintain and review application run-books and standard operating procedures and environment standards.
Confidential, Alpharetta, GA
Shift Application Support Analyst
Responsibilities:
- Tracked and managed work/issues using BMC Remedy CRM software; created and managed FTP accounts for users.
- Documented procedures for technical operations and tasks; wrote shell scripts to automate processes.
- Provided technical support to users to resolve issues on workstations and servers.
- Performed user and group administration for over 400 employees using LDAP.
- Troubleshot application errors on web servers in order to restore availability.
- Created Samba shares for users to permit easy data transfers between UNIX and Windows systems.
- Coordinate system changes wif application developers, network support and storage teams
- Create new Solaris zones for developers when test machines are required.
- Supported production of Oracle Transportation Manager Application and UPS Flex Global View system website.
- Create, Support and maintain three major Web Application user s account and access.
- Perform daily maintenance of web applications servers, and services in a Unix and windows platform.
- Perform analysis on application, and infrastructure to determine point of failures.
- Clearly document system failures, and escalate issues to related team such as DBA, Developers, and Managers.
- Administrated Cognos server, recycled server services, monitored, ran and troubleshot Cognos report.
- Monitored, ran, and troubleshot Data load (PLSQL script); performed data validation in a Unix platform, checking logfiles using VEdit and other Unix tools, handled SQL queries, and stored procedures, using TOAD.
Confidential, GA
Sr Production Analyst
Responsibilities:
- Managed ETL processes for multiple file types for all clients using Data Junction Map.
- Processed client data using established process procedures, interpreting detailed instructions, interacting wif other teams, documenting processed jobs, and ensuring job processing is carried out in a timely and accurate manner.
- Developed queries, DTS packages, stored procedures, tables, to update and maintain databases containing critical client data using MS SQL Server 2000 & 2005.
- Researched analyzed and recommended methods for improving information process flow and efficiency.
- Designed, developed, and maintained reporting tools used to provide information for management and executives.
- Designed and maintained Dashboard Metrics application; handled queries to troubleshoot errors.
- Maintained daily focus on achieving and exceeding team and business goals.
- Coordinated wif the software developers and the certification team to ensure dat Client provides exceptional service to partners and clients by developing the most efficient processes.
- Represented Client Production Team for process innovation, relationship building and client satisfaction efforts.
- Managed internal relationships wif Software Developers, Certification Staff and other internal teams; understand the needs of other internal parties while TEMPeffectively communicating opportunities and needs of the Production team.
- Maintained reports using Crystal Report and resources to facilitate efficient and accurate information sharing.
- Independently worked wif peers, data developers and data analyst in performing validation of various types of healthcare related data including medical claims, pharmacy claims, Memberships, and HRA s.
- Tracked data processing defects; maintained client historical trends and distributions for file feed comparison; performed translation of file layouts and data dictionaries to the actual content of files received.
Confidential Alpharetta, GA
Data Load Specialist/ Analyst
Responsibilities:
- Participated in the staging and updating of the Data Services data; identified and reported data layout changes.
- Supported the analysis, resolution, and documentation of database issues identified during the data load process, using SQL and procedures.
- Used appropriate staging procedures for data files in preparation for data loads; created and modified UNIX scripts.
- Executed scripts in proper order to create historical delta files. Load the delta files using multiple applications such as informatica; reviewed transformation statistics and load process logs to verify the success of the data load.
- Researched and identified and analyzed rejections throughout the entire data load process.
- Reload the fixed rejections using specific scripts or applications; coordinate the resolution of production issues
- Maintained, updated, and reviewed all documentation necessary to support the data load process.
- Recommended strategic direction for processes and improvements implementation.
Confidential Atlanta, GA
Business Production Analyst
Responsibilities:
- Led Production Operations quality improvement projects aligned to business priorities, as identified by management.
- Provided communication and support to business on Production Operations initiatives.
- Performed data processing, designing, error handling, scheduling, and monitoring process workflow, using ETL tool Informatica Power Center such as Workflow Monitor, Workflow Manager, and Workflow Designer.
- Implemented data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the table targets.
- Developed SQL and PL/SQL codes through various steps, to implement the business logics of database in Oracle.
- Executed queries against major relational databases for data sets for production using joins.
- Initialized & monitored python and Unix scripted processes through Unix & Tidal Scheduling Software.
- Ensured secure transmission of files to vendors FTP site using PGP and GNUPG encryption software.
- Analyzed built, documented, and modeled processes to measure key business metrics
- Developed and communicated needed process changes to SW development teams for design/development, using UML, Software Life Cycle skills. Tests, and documents said designs to meet the intended corrections.
- Independently created, maintained, and modified SQL queries; stored procedures, and SQL/UNIX shell scripts.
- Generated and modified business reports and files, using programming tools such as Java, or Java Script.
- Interpreted and translated customer requirements into acceptable format for internal processing.
- Designed workarounds to resolve issues until long - term solutions can be applied; developed and implemented automated backup procedures for system/process recovery.
Confidential, GA
Network Operating Center Analyst
Responsibilities:
- Managed day to day system administration and monitoring; maintained a hardware inventory database
- Installed, maintained and troubleshot, Windows XP and Windows 2000 systems.
- Used various troubleshooting command such as PING, IPCONFIG, TRACEROUTE, DNS tools and others utilities to analyze and solve network connectivity issues.
- Supported and maintained user account including rights, security and group policies using active directory.
- Created DOS batch script, and net login script to enhance system performance.
- Handled daily Backups tapes rotation; ran daily system maintenance utilities on servers, desktops, and network.
- Installed and upgraded hardware and software on desktop, and laptop for individual clients need.
- Responded to telephone calls, email, tickets and personnel requests for technical support. Documents, tracks, and monitors the problem to ensure a timely resolution; configured and deployed new desktop and laptop systems
- Trained and assisted new associates; provided WIFI solutions to remote users
- Imaged and installed new systems using Norton Ghost; maintained licenses for the department s software repository
- Maintained OPEX AS series scanning system; update data center dashboards, and databases for forecast accuracy.
- Troubleshot and repaired system database using Microsoft Access, and SQL.
- Generated documentations and reported for daily process in the NOC, and the data centers.
- Excelled in meeting the service level agreement related to two data management centers of over 50 employees each.
- Supervised biometric security system by assigning and managing employee access in a high - secured environment.
- Coordinated carriers according to company and accounts manager needs, and documents assignments.
- Ordered, documented, and conducted inventory of IT equipments in the NOC.