Manager Data
Resume:
Muhammad S. Alam
Fulshear, TX - 77441
*********@*****.***
OBJECTIVE
To be a part of an organization where process of learning never ends and every day is a challenge to learn, perform and deliver to facilitate the growth and development of the respective organization as well as an individual SKILLS SUMMARY
Excellent communicator, with experience working at client sites to facilitate project implementations, support, and training
Exposed to diverse internal and external technical and business environments, recognized for ability to manage multiple tasks simultaneously
Creative, analytical thinker with demonstrated ability to troubleshoot problem, determine strategies to resolve issues, and consistently implement effective solutions
Excellent analytical, problem solving, communication, and team skills
Strong management, planning, architecting, analyzing, design, and programming capabilities
Familiarity with enterprise level internet and Outlook MS Exchange
Strong leadership ability with experience training developers and advising technical groups on ETL best practices. TECHNICAL SKILLS
Databases: Oracle (9i, 10g, and 11gR2), Oracle PL/SQL, MySQL, SQL Reporting Services, SQL Server 2005/2008, Lotus Notes, MS Access, SAP, OBIEE (Oracle Business Intelligence Enterprise Edition Plus), Oracle PeopleSoft Software: Microsoft Office 2007 (Publisher, Share Point Designer, SQL Server, Communicator, Access, Groove, Project, Visio, Exchange Server 2000/2003/2007, Word, Excel, PowerPoint and Outlook), Adobe Illustrator, Lotus Notes, Crystal Report XI Professional 11.5, SQL Reporting Services, Dreamweaver, Percussion, Acrobat, Photoshop, Apache Tomcat, HTML and JavaScript, Platforms: RSA Archer, IIS, ServiceNow, VMware Workstation, Symantec Antivirus, RSA enVision, RSA Archer, McAfee IPS Manager, Bluecoat Reporter, Tipping Point, McAfee E mail, Checkpoint, Fortinet IPS and Q1 QRadar, AS400
GUI: Microsoft Visual Web Developer 2008 Express, Oracle Application Express, Power Builder WORK EXPERIENCE
Computer Systems Analyst Wipro Technologies Houston, TX November 2016 - Present
Responsible for all technical aspects of the Chevron eGRC Platform (Archer GRC/ServiceNow). This included managing all the servers, SQL databases, and platform instances for updates and performance, as well as coordinating support and resolution of issues. I managed a support team that handled all inquiries about the Archer GRC platform as well as processed end-user requests (Application Issues, Access Requests, Reporting Requests, and SAFe).
• Participating in Agile user stories grooming sessions
• Building new on-demand and customizing core Archer applications for disaster recovery solution
• Creating new data feeds, bulk create and update schedules, configuring data-driven events, calculations, and notifications
• Migrating Archer applications along with data from Archer v 6.3 to v 6.8
• Clarifying user stories requirements with business representatives
• Participating in Archer – ServiceNow integration for bringing applications and devices data to Archer
• Participating in Archer framework infrastructure change impact meetings
• Participate in all technical aspects for ServiceNow of project and solution delivery.
• Firm understanding and develop of ServiceNow applications, modules, and dashboards. RSA Archer Developer
July 2014 – September 2016 CIBC Toronto, ON
Responsible for install (5.5 and 6.1), upgrade, configuration and Architect, LDAP, Design and Implement GRC Solutions in RSA Archer internally and DMZ. which includes calculations, data import, data feed, data driven events, customization, notifications, and reports. Incepted from Enterprise management, program unwinds usage of various out of the box solutions of RSA Archer like Disaster Recovery Management and Policy Management.
• Worked on packaging for archer core solutions, User/Group, and access role management
• Field creation and Configuration in applications and questionnaires Page 2 of 4
• Created on-demand application, notification, and calculated fields as per the requirement
• Experienced with Change Management as per the requirement
• Design and development of Customized Dashboards and custom reports
• Import data into the application through mange data imports
• Configuration of Archer to Archer and File Transporter data-feeds
• Worked on requirement analysis, implementation and design process with the application and process owners
• Building the Business Requirement documents for the applications and assessment processes
• Experience with Archer solution planning and execution of migrations, testing and upgrades
• Coordinate with onsite team for the development / enhancement support for various modules within Archer
• Designed and Implemented Workflows based on record status, record permissions, events and notifications
• Good Knowledge of active directory, LDAP and SSO, setup in GRC Archer application
• Hands on configuration and customization of Archer and 5.5 and 6.1 platform.
• Experienced in creating fields, reports, iView’s and dashboards in Archer, configuring access control, record permissions, events and notifications in Archer.
• Experienced in Data migration planning, content mapping and integrate with Bay Dynamics, Qualys in Archer.
• Experienced in creating UAT and SIT test scripts and creating development and test plans Information Security Analyst
2010 - 2014 The Herjavec Group Mississauga, ON
Responsible for review, analyze security, system events, alert, report, screen, detect security issues, create customer monthly and quarterly report in RSA Archer and manage problems until closure.
Practical competency in Archer eGRC platform installation, configuration, and administration. Strong hold on all the features of platform like application builder, business workflow, dashboards and reporting, system integration, access control at various levels (system, application, record and field), Integrating RSA Archer with external systems (thru Data Feed Manager, Data Publication Manager) etc.
Practical knowledge and experience in - Automating business processes, streamlining workflow and delivering real-time reports across the enterprise
Training business executives and stakeholders, enabling them to tailor RSA Archer eGRC applications and build new applications
In process of establishing strategic alignment with RSA partners and distributors for Implementing and configuring -
“RSA Archer platform and customizing business solutions, providing GRC services to their clients".
Implemented and configured Archer solution modules such as, Enterprise, Risk, Policy, Vendor and Threat Management
Centralize and organize data, build applications, access control, create workflow process, notification types, Import and publish data, packaging, data driven and calculated field configuration, reporting through – iViews, dashboard, workspace
Ensure that Service Level Agreements are met
Perform system maintenance and maintain current documentation
Provide resolution plans for system and network issues, report common and repeat problems (trend analysis) to Management and propose process and technical improvements.
Implement and manage an Enterprise Web Content Filter
Develop and maintain supporting documentation
Participate in security reviews of new services to ensure that end products meet operational security requirements. Database Administrator
2009 – 2011 Halliburton – Sperry Drilling Calgary, AB Responsible for the installation, upgrades, and maintenance of all phases of Oracle, SAP and Access databases including hardware, operating systems, Landmark products, network connectivity, and system security and backup.
Install and upgrade the database server and application tools
Analyze, design, develop, deploy and implement new database system.
Provide support in database modifications and design structures.
Write stored procedures, triggers, SQL code and troubleshooting (for application support and for reporting and analytics purposes)
Install and maintain database software with upgrades or patches.
Develop and maintain data backup and recovery systems (RMAN).
Work on data Acquisition, data import, data export and data management activities (involving ETL tools, BI Tools)
Configure, optimize, and support MSSQL and MySQL and/or other relational databases
Create profiles and user accounts and grant resources for smooth database operations.
Analyze databases performance and tune the databases when needed.
Assist in worldwide Halliburton users support using Remedy.
Performed enterprise database (Oracle 11gR2) and applications server software installations, configurations, upgrading patches, database management and network administrations.
Created user profiles, groups, roles and scripting for easy database administration. Page 3 of 4
Approved all productions database designs and schema changes.
Controlled all migrations of the database schema objects and ensure the data availabilities
Monitored database and performance tuning and others diagnostic activities
Deployed and tested the Crystal Reports on Landmark product
Assist Team Leads by working on proof of concept and prototyping activities to assess whether the proposed architecture and components meet the non-functional requirements; reliability, performance, and maintainability
Document the detailed design for the new parts of the database conversion system
Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
Install and manage the Oracle Financials for business development, and inventory departments DBA Project Manager – Oracle Travel Experts Project 2008 – 2009 Southern Alberta Institute of Technology Calgary, AB Responsible business requirement, design ER diagram, create database, tables, loading data, users, roles, profiles, back and recovery plans, and testing, web integration and security for client Travel Experts
Interviewed the senior travel agent/manager to collect background information and provided Project Schedule
Installation of Oracle client tools and establishing connectivity to databases
Creating the Model Database for Travel Experts (e.g.ER Diagram entities/attributes/relationships) using Visio
Creating Travel Experts database.(e.g. Pfile, Data files, Log files, Control files, and Tablespaces)
Sizing database objects for effective space management and optimal performance
Loading the Travel Experts data from different formats to oracle using SQL loader
Data need to be extracted from different tables in different schemas/databases for analysis.
Travel data comes in different formats so its new scenario for every trial.
Spreading the table and index data on different table spaces for better performance.
Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
Responsible for installation, setup, and configuration of Oracle Database on servers
Installation of client tools on user machines and establishing connectivity to databases
Database and SQL tuning to improve performance of loads.
Analyzing and resizing objects for Travel Experts Database. Running imports/export utilities, off-line backup, on-line backup various Oracle Applications utilities Use of recovery strategy when required.
Design web application development tool for the Travel Experts database using Oracle Application Express
Maintenance support after implementations, documentation and user training MWD - Field Technician/Well Planner
2006 – 2008 Ryan Energy Technologies Calgary, AB
Reporting directly to the Technical Support Manager. Accountable for planning, revising and drafting final working copies of well plots, spider maps, ellipse of uncertainty plots and 3D interference plots using:
Preparing well path proposals using client-supplied geological data
Analyzing proposals in relation of offset well information in order to advice client and field staff
Working closely with Directional Coordinators to prepare appropriate materials for bid packages and to ensure the smooth operation of ongoing jobs that meet or exceed client expectations
Review of all drilling parameters, hook load, WOB, torque, rpm, mud pump pressure, strokes and flow from Pason IT System Analyst/Inventory Controller
2003 – 2005 MediSystem Pharmacy Alberta Ltd Calgary, AB Responsible for ordering, purchasing, tracking, pricing, receiving and liaising with various clients using SAP, including:
Maintain an adequate inventory of supplies, equipment and materials in a cost-effective manner
Survey vendors to ensure that purchases comply with policies, regulations and good purchasing practices
Document inventory by utilizing database Kroll Computer Systems Inc., receive supplies, equipment and materials, mark prices and stock inventory facility and maintain organization
Providing IT support in a wide variety of software and hardware technologies on various platforms (different location). EDUCATION
2010 Southern Alberta Institute of Technology Calgary, AB Database Administrator Certificate
2009 Southern Alberta Institute of Technology Calgary, AB CADD Operator Level I Certificate of Achievement
Page 4 of 4
2002 DeVry University, Phoenix, AZ Calgary, AB
Bachelor of Science in Computer Information Systems 1999 Southern Alberta Institute of Technology Calgary, AB Diploma in Computer Engineering Technology
CERTIFICATES
2020 ServiceNow Certified System Administrator Houston, TX ServiceNow
2018 SCALED AGILE Houston, TX
SAFe Certified 4.5
2013 RSA Archer Mississauga, ON
RSA Archer Certified Administrator
2011 RSA enVision Mississauga, ON
RSA enVision Certified Systems Engineer
2011 McAfee Partner eLearning Mississauga, ON
McAfee Network Security Platform Certified
2007 Canadian Management Centre Calgary, AB
Leadership Development Course
Reference: Furnished upon request
Contact this candidate