SUMMARY

• A dependable and diligent professional offering several years of diversified customer service/ IT Experience.
• Dedicated to achieving customer satisfaction as well as meeting or surpassing company expectations.
• Strong rapport with personnel, customers, and associates based on knowledge, professionalism, and integrity.
• Manage multiple tasks, experienced in envisioning and implementing cost effective and result oriented strategy to create and boost awareness of business products and services.
• A dependable and diligent professional offering several years of diversified customer service/ IT Experience.
• Dedicated to achieving customer satisfaction as well as meeting or surpassing company expectations.
• Strong rapport with personnel, customers, and associates based on knowledge, professionalism, and integrity.
• Consistently recognized for technical troubleshooting skills used to rapidly and cost - effectively resolve challenging technical issues.
• Quickly learn and master new technology; equally successful in both team and self-directed settings; and proficient in a range of computer systems, tools and testing methodologies.
• Understand the technical aspects of database organization, and how database organization affects computer and performance.
• Good communicate with users to ensure that all of the data requirements are met in the database design.
• Excellent experience as a leader and a computer technician and troubleshooting.
• Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical issues.

TECHNICAL SKILLS

Systems: Windows Server 2000/2003/2008 , Windows 2000 Professional, Windows NT/2000/XP/Vista/7/8/10

Software: MS Project, MS Visio, Adobe Acrobat, Microsoft Office (2007, 2010, 2013) Management studio, SQL, EXCEL., Access, QA Testing tool, test direction version

Reporting Tools: SQL Server Reporting Services (SSRS), SAP WEBI Intelligence, SAP Crystal Reports 10

Data Modeling Tools: Oracle SQL Developer, TOAD Data Modeler, PowerBI, SAP Business Intelligence Suite, Tableau.

ETL Tools: SSIS (SQL Server Integration Services), Talend Data Integration, DTS (Data Transformation Services), Jitterbit Data Integration (Harmony Platform) and Jitterbit Cloud Data Loader for Salesforce.

PROFESSIONAL EXPERIENCE

SQL DBA/Data Integration Analyst/ETL Developer

Confidential - Atlanta

Responsibilities:

• The project was focused on Designing and Implementing a Data Warehouse for the organization and the Data Warehouse must support the Business Objectives according the Data requirements.
• Responsible for identifying business requirements of Data Warehouse and
• Planning, Designing, Scheduling and Coordinating Data Warehouse analysis, design, development, and deployment.
• Experience in Data Models-Data Warehouse modeling using Oracle SQL Developer and Toad Data modeler.
• Acquiring Data from primary and secondary sources and maintain Data systems.
• Supports in the Data design, end-to-end development processes of Data extraction, transforming and loading operation data (ETL), as well as Data integration processes like Data Replication and Data Synchronization using Talend Data Integration tool.
• Responsible for designing, building, and supporting all components of data warehouse, such as (ETL) processes, databases, reports, and reporting environments and data sources files.
• Develops and automates (ETL) processes that involve error and reconciliation handling, utilizing Microsoft SQL Server Integration Services (SSIS) and Talend Data Integration tools.
• Performing Data profiling and Source to Target Mappings (While capturing ELT and business metadata).
• Perform testing in Development environment that Data inputs meets business user’s requirements and conduct appropriate functional and performance testing to identify bottlenecks and Data quality issues.
• Experience in Designing and Developing BO Universe using SAP Business Objects Information Design Tool (IDT)
• Experience in Designing and Developing analytical and AD-hoc reports using SAP WEBI Intelligence and SAP Crystal Report tools.

SQL Server Database Administrator/Integration Developer

Confidential, Atlanta GA

Responsibilities:

• Design, create and maintain database objects including all physical and logical primary objects such as tablespaces, data files, tables, clusters, indexes, views, sequences, packages, procedures, etc.
• Create and maintain coding standards for stored procedures, triggers, logical and physical DB schema design.
• Responsible for designing, developing and optimizing company database
• Constantly provide support for test and company production Database environments to include problem identification, reporting, tracking, analysis and resolution.
• Constantly manage and coordinate (ETL) processes and tasks.
• Performs capacity planning, supporting, troubleshooting, and (ETL) performance modification.
• Experience in creating metadata, developing (ETL) processes, and using several reporting tools; and performing data validation and data cleansing functions.
• Constantly monitor the SQL Database performance and space utilization.
• Have Experience in Microsoft SQL Server 2005, 2008, 2012 and 2014.
• Constantly establish, maintain and monitor database backups, database security, user-role assignments, and individual logins per company security policies and procedures.
• Experienced in SQL Server Management Studio (SSMS) to access, configure, manage, administer and development of all components of SQL Server objects.
• Experienced in using SQL Server Integration Service (SSIS) extensively to solve critical business problems, updating data warehouse, cleaning and mining data.
• Experienced in using SQL Server Agent (SSA) to automate and schedule the execution of SSIS packages, scheduling daily Back-ups and updating the database.
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
• SQL Server Reporting Service (SSRS) was extensively used in generating, deploying and managing report for the organization.
• Experience in data warehousing and supporting high volume production OLTP and OLAP databases.
• Tuning T-SQL queries to improve performance.
• Experienced in Installation of PHP, Apache, and Perl DBI support in MySQL Server version 5.5 and 5.6.
• Experienced in Tuning MySQL Server using Mysqladmin, variable command, setting variables and default parameters.
• Experienced in running multiple servers on a single data directory in MYSQL.
• Experienced in backing up entire database, compressed backup files, backing up individual tables, and using MySQLDUMP to transfer database to another server in MYSQL.
• Experienced in Installation of PHP, Apache, and Perl DBI support in MYSQL Server version 5.5 and 5.6.

SQL Server Database Analyst/Administrator

Confidential, Atlanta GA

Responsibilities:

• Install and configure new SQL Servers.
• Created new tables, views, functions, triggers and stored procedures.
• Data migration from pre-existing and legacy data from Excel to MS SQL Server.
• Experience in Microsoft SQL Server 2005,2008 and 2012
• As new systems are brought in-house, choose whether to use clustering, log shipping, Replication & mirroring, Windows Azure, or other technologies.
• Advise developers on the most efficient database designs (Tables, Data types, Stored Procedures, Functions, etc.)
• Design indexes for existing applications, choosing when to add or remove indexes
• When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes.
• Conduct SQL Server lunch-and-learn sessions for application developers
• Deciding whether clustering, log shipping, mirroring, replication, etc. are the right fit to solve a business problem.
• When performance issues arise, determine the most effective way to increase performance including moving objects from staging to production SQL Servers, Tests all patches before deploying to production hardware purchases, server configuration changes, or index/query changes.
• Pro-actively ensure database systems are maintained at the highest level of support; plan/set procedures; provide reliable and secure systems for business applications.
• Contribute to project team efforts to ensure operational support requirements are implemented.
• Schedule, monitor, and maintain database backup and recovery procedures which will protect the business.
• Work closely with operations staff to ensure stable performance for the database environments, monitors, analyzes, identifies and resolves bottlenecks and resolves problems.
• Ensure change management procedures and methodologies are implemented and followed.
• Using ETL Development tools in Database Migration to meet the company target etc. (Data Migrator, SSIS, SSDT and Talend Studio )solve company unexpected complex problems in Data Analytical and visualization format.

SQL Server Analyst

Confidential, Austell GA

Responsibilities:

• Installs and configures SQL Database setups.
• Manages SQL Server security and logins.
• Manages SQL Database cluster, replication and mirroring.
• Configure SQL Server monitoring utilities to minimize false alarms.
• Designs disaster recovery strategies.
• On-call troubleshooting for SQL Server service outages.
• Designing tables and picking data-types.
• Using Profiler traces and other tools to find the most frequently run queries.
• Coordinates backups and restore functions.
• Maintained a backup and recovery option to retrieve the lost data.
• Ensure that new database code meets company standards for readability, reliability, and performance.
• Assisted in building strategies for installing and improving thedatabase.
• Draw up disaster recovery plans for critical and non-critical database.