SUMMARY

• An innovative, iligent, articulate, multi - talented, results-oriented and accomplished Information Technology (IT) professional, I hold an MS degree in Information Technology from University of Texas - RGV and TEMPhas over 14 years of experience in the IT industry, including over 8 years as a Data Architect and a Business Analyst wif a wide variety of industries, namely software, telecom, oil & gas, education and government both in USA and Canada. I worked for some of the best 500 Fortune North American companies, like Confidential &T, Confidential, Confidential, Teck Resources, Smart Technologies and Confidential .
• My areas of expertise include database architecture, data architecture, application architecture, enterprise architecture, data modeling, software engineering, data analysis, data management, data governance, data security, database administration, business analysis, systems analysis, application support, cloud computing, cyber security and IT Change Management.
• Having a certificate on data modeling, I am an expert in database design, development and implementation, notably in the SQL Server environment. I can translate business requirements quickly into conceptual, logical and physical data models using various data modeling tools, like Microsoft Visio and Enterprise Architect.
• Equally, I am highly proficient in performing, eliciting and gathering business analysis, system analysis, gap analysis, risk assessment, business requirements, system design, technical specifications, system integration, Htaking the lead role in SDLC (Software Development Life Cycle) from analyzing business processes, gap analysis, risk assessment, eliciting business requirements, creating use cases and documenting business rules to developing conceptual, logical and physical architecture of the databases, applications and systems. I often excel in liaising between business and technical areas and ensure dat projects are complete on spec, on-budget and on time.
• I consistently maintain a strong and successful working relationship wif all colleagues, stakeholders and executives. I utilize my exceptional interpersonal, analytical and problem-solving skills in order to plan and design creative solutions dat meet the stakeholder’s requirements. I have extensive experience in working wif small, medium and large project teams and was involved working on several mission critical and high profile million dollar projects. My broad technical noledge, ability to multi-task and work on multiple projects, organized nature allowed me to complete concurrent projects successfully on time, notably Confidential Confidential Canada and Confidential &T.
• In addition, I have hands on noledge and experience wif the hardware components of computer and possess excellent time management, analytical, troubleshooting, communication, organizational and interpersonal skills. I am also a critical thinker who addresses customer issues promptly. I am capable of troubleshooting and resolving complex computer hardware, software and technical issues quickly and efficiently.

AREAS OF EXPERTISE

• Data Architecture
• Database Architecture
• Enterprise Architecture
• Data Modeling
• Data Management
• Data Security
• Systems Analysis
• Systems Integration
• Systems Solutions
• Requirements Gathering
• Business Analysis
• Use Cases
• Business Process Modeling
• Software Testing
• Application Support
• Virtualization
• Cyber Security
• IT Change Management

TECHNICAL SKILLS

• SQL Server 2000/2008/2014
• MySQL Community Edition 5.5
• Oracle 10g/9i/8i
• Toad for Oracle 11.6
• Windows Server 2000/2003/2008/2012
• Apache Server 2.0
• III 5.0/6.0/7.0
• Linux (Ubuntu) 14.04/12.04
• Visio 2000/2003/2010/2013
• Enterprise Architect 13.0/14.0/15.0
• Java 7/8
• JavaScript 1.8
• Microsoft Power BI Premium/Pro
• Microsoft SQL Server Report Builder 3.0
• JavaScript 1.8
• NetBeans 8.1
• HTML 5.0/4.0
• XML 1.1
• Python 3.5, 3.6 and 3.7
• VMware Player 6.0
• Oracle Virtual Box 5.0/4.3
• Microsoft Dynamics (CRM) 2013/2011
• ServiceNow
• BMC Remedy 7.6

PROFESSIONAL EXPERIENCE

Confidential

Data Architect/Business Analyst/Technical Analyst

Responsibilities:

• Designed, developed and implemented Data Architecture Artifacts, including conceptual, logical and physical data models for the mining engineering systems to ensure dat the enterprise architectural roadmaps were aligned wif enterprise strategies, business objectives, standards, processes and methodologies.
• Managed, updated and maintained data architect models, schemas scripts, technical specifications and other related documentation wifin the organization.
• Planned and defined data management strategies, policies, strategies, procedures, quality and security wifin an enterprise environment.
• Worked wif diverse stakeholders to ensure dat they fully understood and complied wif architectural designs, guidelines and data quality standards.
• Elicited, analyzed and performed business and gap analysis, requirements gathering, risk management, business process models, RFPs and Use Cases via workshops, meetings, walkthroughs and surveys wif stakeholders Confidential all levels wifin an organization to develop TEMPeffective and high-quality enterprise software solutions.
• Planned, executed and developed project structure wif roles and responsibilities for the team to ensure the project was appropriately resourced and was successfully delivered.
• Managed detailed project schedules, including tracking changes, progress, decisions, action items, risks, issues. Ensured dat actions items, risks issues were reviewed and were addressed in a timely manner.
• Maintained project risk log, project deliverables, milestones, and budget were on track, and action items, risks/issues, and decisions were captured, documented and completed wifin the specified time period.
• From time to time, provided Tier 2 & 3 support for incidents related to MineSight and RocScience Engineering systems. Resolved incidents wif vendors and other team members. Documented and submitted incidents and Change Requests in ServiceNow.
• Managed application support during maintenance, deployment, packaging, patching, upgrades and other related activities associated wif operating an application. Resolved incidents working wif vendors and other team members.
• Performed quality assurance, testing, change management and post implementation support.
• Wrote and generated reports using Microsoft Power BI and Microsoft SQL Server Report Builder on the Engineering applications license usage.

Confidential

Data Architect/Data Analyst/Business Analyst

Responsibilities:

• Provided end-to-end data architecture solutions for the AGS Metadata System (AGSMS) during the design phase of project and ensured dat the right data architectural solutions were delivered. This involved creating, implementing and managing the metadata data models - conceptual, logical and physical models using Enterprise Architect software dat were aligned wif enterprise data mapping, business requirements, security, strategies, processes, policies, standards and methodologies.
• Designed, developed and administered ArcGIS (GIS) and Spatial databases in the SQL Server environment, including managing, implementing and supporting database architecture, solutions, maintenance, health monitoring, performance tuning, disaster recovery and database backups. Also enhanced new features and functionalities to the existing databases as requested by the users.
• Extracted, transformed and loaded (ETL) data from multiple platforms and stored the data into the master ArcGIS and Spatial databases.
• Deployed, integrated and tested the metadata architecture for the new ArcGIS and Spatial database management systems based on business requirements and ensured dat the data architecture platform met the ISO standards.
• Planned, architected, and implemented data integration flows between various information systems.
• Facilitated, shared and adopted data governance best practicesthrough governance committees in the enterprise.
• Updated and maintained documentation data dictionaries, data flows and data structure.
• Managed, updated and maintained the database design models, database schemas, scripts and technical specifications.
• Created visual reports (e.g., dashboards, graphs) based on data coming from multiple sources in Power BI.
• Worked wif stakeholders to ensure dat they understood and fully complied wif the data quality, standards, policies, strategies, guidelines and architectural designs of the platform.
• Elicited business requirements, including functional and non-functional requirements using business analysis, gap analysis, risk assessments, business process modeling, flowcharts, business rules, roadmaps, use cases, scenarios, interviews, walkthroughs and interviews for the existing and new projects.
• Developed, planned and managed detailed project schedules, including tracking changes, progress, decisions, action items, risks and issues. Ensured action items, risks and issues were reviewed and addressed in a timely manner.
• Prepared, completed and delivered the design, development and implementation stage of the project on time and achieved 100% accuracy of the goals and wifin the expected time line dat the team targeted initially.
• Provided first-level technical support for the Banner and Cisco phone systems dat involved troubleshooting hardware, software and network connectivity issues ensuring dat the technical issues were resolved in a timely fashion so dat the downtime was minimum.
• Researched, analyzed and identified the trend and the problems of the Call Volumes found Confidential the student call center and provided the possible solutions dat reduced the call high volumes by 30%.
• Worked wif the upper management team to conduct business impact assessment, identify the current business process issues and provide proposed solutions to the issues.
• Supervised and managed more 50 agents in the Call Center, including creating training materials, hiring and training new agents, handling time cards of the agents, maintaining the EPAFs (Electronic Personal Action Form) dat kept track of agents work eligibility, work extension and funds to ensure the compliance, standards and policies of the department.
• Earned a solid reputation for solving complex issues and delivering exceptional customer service.

Confidential

Data Architect/DBA/Business Analyst

Responsibilities:

• Created, automated and implemented new Oracle Profiles to Oil and Gas Applications using Toad for Oracle. This involved managing 19 Databases (projects), including Wellview, Siteview, Well Launcher, Energy Components, Field Data Capture, EDM, Hoops, Maxitrak, Integrity Objects, Resbase, Logsleuth, OFM, Landmark, ArcGIS, GeoCarta, eSearch, Volts, SurFin, Capital Manager and CS Explorer Databases.
• Ran SQL Queries using T-SQL to reset/drop the expired or locked Oracle Profiles in the Databases to stay in compliance wif the GIPA (Global Information Policy Association).
• Dropped the expired or reset locked the Oracle Profiles in the Databases to stay in compliance wif the GIPA (Global Information Policy Association).
• Acted as the Change Management Agent for the business transformation and technology modification. Communicated wif the users about the business process, changes and benefits for the projects. Submitted the Change Requests for the new Oracle Profiles for the live production databases in the IT Change Management System (CRM) to get the business approvals and deployed the changes during non-business hours so dat the users were not impacted during the database outages. Successfully, managed, deployed and implemented the changes in software applications and the new changes enhanced the productivity by 20%.
• Designed, developed and maintained the database security, data flow and user interfaces diagrams for multiple platforms - the DPO, GGRE and Corporate Databases using Enterprise Architect software to stay compliance wif the GIPA policy.
• Planned, documented and implemented enterprise automated portion of the database design and solutions wifin the organization.
• Set up the Automated Job Alerts using Scripts (PL/SQL) for monitoring the Failed Logins, Locked Accounts and Expired Passwords as a proactive the database security measurement.
• Designed, developed and maintained reports wif data visualization tools such as Power BI and SSRS reports.
• Provided support to the Application Support Team during patching, maintenance, upgrades and other related activities associated wif an application for maximum functionality, efficiency and availability.
• Analyzed, identified and conducted the gap analysis between the current-state and the future-state of the database applications and took the required actions to reduce manual workload and improve the efficiency of the applications.
• Worked wif the stakeholders to gather, perform and create business requirements, business analysis, business process modeling and business/use cases so dat they met the requirements of the applications to ensure the execution and delivery of the projects were on time.
• Provided project status reports to the stakeholders weekly on progress, issues and potential risks.
• Played the key role in automating the Oracle Profiles for the Oil and Gas Applications minimizing human intervention and rendering the security, reliability and efficiency by 25%.

Confidential

Data Architect/Application Engineer/Business Analyst

Responsibilities:

• Designed, developed, configured and supported AutoSol oil and gas applications (AES, ACM, AlarmManager) dat interacted wif HMI interfaces and other 3rd party databases (Access, SQL and Oracle).
• Provided project engineering support to AutoSol oil and gas applications, which involved analyzing, troubleshooting and resolving software, application, database, server installation, registration, licensing, configuration, upgrade, security, connectivity and migration issues to ensure dat the issues were resolved to earn the highest customer satisfaction.
• Prepared, documented and implemented Application Architecture design and solutions in an enterprise environment.
• Documented incident tickets accurately in CRM to identify the root causes of the software problems and also report the new, unnon and software defects to the Software Development team to have them fixed in the next release.
• Successfully, facilitated, coordinated and conducted workshops, walkthroughs and meetings wif the stakeholders to analyze, gather and determine Project Overview, business systems requirements, technical specifications, Risk Management, Business Process Models, Business Process Engineering and Business Case Development to discover gaps between requirements and the delivered software application.
• Achieved the highest levels of productivity handling more calls TEMPthan other Engineers, which led to a 30% increase in product sales.
• Provided application support to Smart products (Smart NoteBook, Smart Blackboard, Smart Response), which involved troubleshooting and resolving Software Installations, Configurations, Upgrades, Patches and Registration.
• Documented the problems experienced by the customers, conducted the root cause analysis and wrote the trouble shooting steps to resolve the issues in Customer Relationship Management (Microsoft Dynamics CRM).
• Escalated unresolved issues to 3rd level support for further troubleshooting and resolution.
• Implemented use cases if one existed or built the use cases wif new business rules.
• Assisted Software Testers in developing Test Plans, Test Cases and Test Scenarios to ensure the accuracy and stability of new software applications.
• Worked wif the Software Development Team to identify software bugs and deficiencies based on testing results.
• Consistently, recognized for solving complex issues and highest customer satisfaction.
• Identified, supported and resolved software application related issues to a Tax Application (Profile) dat resulted ranging from Software Installations, Configurations, Set ups and Upgrades.
• Maintained support documentation in the trouble ticketing system - Customer Relationship Management (Microsoft Dynamics CRM).
• Helped Testers design, develop and prepare Test Plans, Test Cases and Test Scripts in accordance wif system specifications to ensure formal QA compliancy before moved to production.
• Provided On-Call and after hours support for the application on a rotation basis.
• Implemented new procedures, policies dat increased the department productivity, improved system uptime to 10% and provided highest customer satisfaction.

Confidential

Technical Support Analyst

Responsibilities:

• Provided technical support for Shaw Network infrastructure, including network connectivity, internet access, MS Outlook configuration, firewall, routers and anti-virus issues via phone, email and remote halp desk tools in Windows, Linux and Mac environments.
• Documented the issues, the solutions applied and closed the trouble tickets into computer systems - CRM.
• Escalated issues to the second-level support when the solutions were unnon or could not be resolved.
• Delivered the highest levels of productivity taking over 125 calls per week and averaging 25 calls daily.
• Processed inbound technical support calls Confidential 20% faster rate TEMPthan team average.
• Set up, deployed and maintained the databases designed for the Electronic Bill Payment System in the MS SQL environment and ensured dat it met the business requirements. This included designing, developing, documenting and managing the corporate database architecture, solutions, maintenance, performance tuning, database security, backups and recovery procedures of the databases.
• Created both the logical and physical data models for the databases using Visio and ensured dat the physical data models were normalized to match the client specifications.
• Defined, developed, implemented and maintained IT Master Data Management (MDM) program.
• Provided maintenance and monitoring of the database on a daily basis to ensure service issues were identified and resolved wifin established SLAs.
• Used the DTS Packages to upgrade the databases from SQL Server 7.0 to SQL Server 2000.
• Analyzed, conducted and performed project schedules complete wif work breakdown structures, dependencies, meetings, walkthroughs, workshops, road maps, milestones and deliverables.
• Created Business Use Case models, business requirements, functional, non-functional requirements, business process modeling and technical specifications. Also collaborated wif the stakeholders to ensure budget, milestones, deliverables, risks and issues were fully captured and documented and right on track.
• Planned, supported and implemented architectural roadmaps, security and solutions dat involved alignment wif enterprise strategies, policies, standards, processes and methodologies.
• Developed project plan and ensured deliverables, milestones, and budget were on track, and action items, risks, issues, and decisions were captured and documented.
• Designed, developed and implemented database management system under budget and three weeks ahead of deadlines.
• Implemented the system dat was cost TEMPeffective, secure and user friendly and it increased the productivity, reliability and scalability by 10%.

Confidential California,

Data Architect/DBA/Business Analyst

Responsibilities:

• Successfully, installed, configured and administered Databases in the MS SQL environment designed to support the DSL Batch Ordering process efficiently.
• Created, updated and maintained UML models, flow charts, business process models and database diagrams using Visio. Created the logical data models and translated the Logical database models into physical database models dat integrated wif the existing or proposed database architecture.
• Supported, administrated and managed the database security, integration, performance tuning, backups and recovery Procedures of the database management system on a regular basis.
• Designed, developed and implemented corporate database architecture design platform, best practices, security, methods, standards, tools, policies and processes in an enterprise environment.
• Defined vision, strategy and principles for data management wifin the organization.
• Supported and co-ordinated data governance committees and their activitiesand ensured dat data governance roadmap was integrated into overall enterprise development planning.
• Executed SQL queries - sp who, sp lock and sp monitor to perform Database Performance Tuning from time to time.
• Migrated the out dated Databases from MS SQL Server 7.0 to MS SQL Server 2000 successfully utilizing ETL (Extract Transform and Load) tool.
• Performed system analysis, software integration and implementation for the existing and new environments.
• Planned, scheduled and maintained multi-phased project plan complete wif work breakdown structures, dependencies, activities, meetings, workshops, walkthroughs, status updates, milestones, and deliverables wif the stakeholders.
• Collaborated wif the stakeholders and elicited business requirements, business/use cases, risk, gap analysis, policies, processes, policies, procedures and solutions. Also supported to ensure technical specifications and functional designs were in sync wif the business systems requirements and the quality products and milestones were delivered on time and wifin budget for the future development.
• Provided On-Call 24x7 shift rotations, overtime and off hours support to minimize the impact of system disruptions.
• Delivered $1.2 million database system on time, on spec and on budget dat led to a 25% increase in product sales.
• Implemented a system dat enhanced high productivity, availability and scalability of the department and proved cost TEMPeffective, secure and user friendly.

Confidential

Data Architect/DBA/Business Analyst

Responsibilities:

• Collaborated wif the stakeholders and elicited business requirements, business/use cases, risk, gap analysis, policies, processes, policies, procedures and solutions. Also supported to ensure technical and functional designs were in sync wif the business systems requirements and the quality products and milestones were delivered on time and wifin budget for the future development.
• Assisted in design, development and administration of the databases in the MS SQL environment dat involved database creation, schema development, maintenance, backups and upgrades of the emulation system (CTCBridge 32).
• Created, modified and maintained the conceptual, logical and physical database models of the CTCBridge 32 system utilizing MS Visio.
• Designed, developed and managed data flow diagrams, data management road maps and data management strategy for the database architecture platform.
• Performed database migration and validation from Access 97 to SQL Server 7.0. Resolved data loading and migration related issues. Successfully, managed and completed 99% records mapping.
• Planned, documented and managed database architecture and solutions platform wifin the organization.
• Elicited business systems requirements wif the stakeholders via workshops, meetings, conference calls for the new database systems.
• Provided 24x7 production database support through on call.
• Helped developed a system dat guaranteed high availability, reliability and performance.