SUMMARY

• 7+ years of experience in IT domain where I used to analysis, design, development and implementation of Business Intelligence solution.
• Seeking a challenging opportunity to demonstrate my organizational skills and educational background and aim for simultaneous achievement of corporate and personal goals in a rewarding global organization offering career growth and professional development.
• Design disaster strategy with configuration of Hot / Cold backup.
• Design database including Physical / Logical / Relational Modeling. Design and management of table space and data files for growth analyzing.
• Experience on databases Oracle 11g / 12c as DBA including SQL / PLSQL. Implementation and administration of Oracle Database with performance tuning.
• Good skills in Client - Server application development using Oracle11g/12c, PL/SQL, SQL *PLUS, TOADandSQL*DEVEPLOER.
• Good technical and analytical skills with clear understanding of design goals of ER modeling forOLTPand dimension modeling forOLAP.
• Experience withData flow diagrams, Data dictionary, Entity relation modelinganddesign techniques.
• Experience inOracle various packages, RecordsandPL/SQL Tables.
• Maintained Microsoft SQL server 2012 including user account management and database backup.
• Experienced inenhancing and deploying the SSIS Packagesfromdevelopment server to production server.
• Administration for Computer Hardware and different operating system including Windows and RedHat / Oracle Linux Platform.
• Handling techniques for critical job failures in the production environment and Involved in fixing the data issues in the EDW database.
• Management of different methodologies specially CISCO devices.
• In depth knowledge of Management and Administration of AWS services as well as designing and developing Amazon EC2, Amazon S3, Amazon RDS, Amazon Elastic Load Balancing, Amazon SWF, Amazon SQS, CLI,VPC, S3, Glacier, Route 53, CloudTrail, IAM and other services of the AWS infrastructure
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong analytical, presentation, problem solving and excellent inter-personal communication skills and flexible to learn new technologies in the IT industry towards company’s success.

TECHNICAL SKILLS

Language: SQL, HTML,T-SQL, Python, Object oriented programming

Server Hardware: HP ProLiant Rack Servers / G4 /G7, Raid Level Configuration.

RDBMS: SQL Server, Oracle, MS Access

TOOLS: TOAD, ORACLE ENTERPRISE MANAGER, INFORMATICA, SSMSESSDT, TABLEAU, ORACLE DATA INTEGRATOR, SQL*DEVEPLOEREnvironment OEL (Red Hat), Windows 98 /XP/7/8, Windows Server 2003/2008/2012.

Cloud Platform: Amazon Web Services (AWS), Azure.

Administration: Oracle Utilities for Backup & DR, Microsoft SQL 2005 & 2008.

Networking: Design LAN & implementation using wired technologies, also installations of network components and devices

PROFESSIONAL EXPERIENCE

Confidential

Database Engineer

Responsibilities:

• Provide technical support to clients, Implementation of POS system with training and live covers.
• Configuration of database & upgrades with appropriate release.
• Strategy designing to clients for database backup and DR with RMAN.
• Development of interface server with Oracle Micros and Opera database, also manage and administration of Oracle Data Guard with Head Office Team.
• Maintenance and administration of client Database including query optimization, schedule task and Performance measurement.
• Involved in operations on ETL usingSQL*Loaderto load data from flat files obtained from various facilities every day. Created database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL Developer.
• Collaborated with developers and performance engineers to enhance supportability and identify performance.
• Implementing patch for the database to resolve critical errors.
• System administration and performance monitoring.
• Worked in creating test case, test scripts document and coordinated with Business for User Acceptance test.
• Worked on complex queries and procedures based on the business requirements.
• Developed load procedures using SQL and other procedures to keep the Database current. Presented to management on a weekly basis the progress and issues regarding their data.
• Regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot using SEM (SQL Enterprise Manager).
• Monitored and fixed nightly maintenance; optimized and improved DTS and SSIS packages.
• Created mappings to load Dimension tables and Fact tables.
• Created mappings to load flat file data to Oracle database which can be reused for different processes.
• Created and configured workflows, work lets and sessions to transport the data to target systems using Informatica Workflow Manager.
• Used Concurrent Workflow Execution.
• Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency.

Confidential

System Engineer

Responsibilities:

• Configure the OS Linux and Windows Server / Client OS.
• Team working to derive technical sales.
• Working on Projects with different technologies.
• Work and implement Cisco and Juniper Netscreen for Firewall, VPN and branch connectivity solutions.
• Implementation of site to site VPN, client VPN using Cisco routers and VPN Concentrator to connect client’s remote location.
• Plan & develop various IT infrastructures using the product sets of Router, Switches & Firewalls.
• Responsible and understand client network problems and provide resolution in timely manner with quality.
• Highly responsible to work with client, external vendors to discuss and work on issues, to install, configure or replace equipment.
• Design and implement Surveillance solutions, on Pelco products.
• Arrange post sales discussion between architect, implementation person and clients to provide the extensive knowledge to the customer on the proposed products.
• Providing support to multiple integration projects for network planning, budget forecasting and project management.

Confidential

Customer Sales Presentative

Responsibilities:

• Team working for technologies and business owners.
• Entertain walk-in customer’s queries and resolve them in timely manner.
• Understand to customer’s complaints and provide them best available options.
• Always make sure customer don’t leave premises without getting their questions answered.
• Resolved number of inquiries in any given week and consistently met performance benchmarks in volume and accuracy.
• Greet transfer and hold calls, Build rapport, listen, clarify and manage conversational flow.