SUMMARY:

• Experienced Oracle / SQL Server Data Analyst with over 7 years’ experience in the design, installation and configuration of Oracle and SQL server databases.
• Strong experience in using data mining and statistical modelling tools such as Tableau, SSAS,T - SQL,PL/SQL, Microsoft excel and access in creating and analyzing complex data and SQL queries.
• Highly Proficient in working with SQL Server Management Studio SSMS, Integration services SSIS, Analysis services SSAS and Reporting services SSRS in analyzing data and deploying business reports.
• Expert at utilizing my Management Information Systems proficiency to manage the different phases of a software development life cycle SDLC from business requirements to testing, documentation, production support, training and completions.

TECHNICAL SKILLS:

• Provides after hours, weekend and holidays production and technical supports for SQL server 2008,2012 2014,2016 and Oracle 10g,11g, 12c databases in a 24x7 production environment.
• Highly Proficient in executing and managing all data analyst responsibilities such as database design, installation, Configuration and Using T-SQL/PL SQL in writing and developing complex SQL queries used in obtaining critical data for management decision making processes.
• Provides work guidance and leadership to less experienced data analyst administrators in their assigned duties, acts as technical project leader on assigned projects.
• Strong skills with Software Development Life Cycle methodologies such as Agile and Scrum.
• Perform all Oracle and SQL server data analyst related activities independently and great troubleshooting skills in mission critical data analyst production environment.
• SQL Server 5 years, Oracle 7 years, Excel 7 years, Access 5 years, project management 5 years and Data Analysis 7 years.
• TOOLS /UTILITIES: SQL Server Management Studio SSMS,SQL Server analysis Services SSAS, SQL Server Integration Services SSIS,SQL Server Reporting Services SSRS,SQL developer, SQL*Plus, SQL* Loader, Oracle Recovery Manager (RMAN), Recovery Catalog, Automated Workload Repository (AWR), ADRCI, Oracle Scheduler, Data Pump, Enterprise Reporting using Microsoft Office (Word, Excel, PowerPoint, Outlook and Project.)
• LANGUAGES: T-SQL, XML, Intermediate JAVA, HTML, Cobol, SQL, PL/SQL
• Excellent Financial, leadership qualities, team management and development skills
• Well organized and detail oriented with a can do spirit.
• Good communication (verbal and written) and interpersonal skills
• Reliable, Result Oriented, Trusted & Proactive, very hardworking, resourceful and dedicated with a high sense of duty.
• Good time Management skills with positive altitude at work.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Georgia

ORACLE /SQL SERVER DATA ANAYLST

Responsibilities:

• Strong hands on experience in database design, development and business intelligence of Microsoft SQL server 2008, 2012, 2014 and 2016.
• Highly proficient in designing, developing SQL queries, extracting data from databases and analyzing the data using SQL Server Analysis Services and preparing accurate reports and presentations of findings.
• Expert knowledge with SQL Server Integration services SSIS, SQL Server Analysis Services SSAS and SQL Server Reporting services SSRS in building and generating business reports for Choice Technologies.
• Strong experience in data mining tools used in creating and analyzing complex data and SQL queries such as T-SQL, Access, Tableau and excel statistical modelling techniques.
• Ability to use SQL Server Analysis Services SSAS in creating cubes, data sources,views, named queries, dimension and deploying of analysis service project in SQL Servers.
• Provide implementation and support of database solutions, tables, structures for new evolving sources of data being brought into the organization to support enterprise application and services for Choice Technologies.
• Experienced with SQL Server Integration Services SSIS development (ETL),source to target data mapping and data process flow.
• Optimized the performance of SQL queries using SQL profiler and SQL server database engine wizard.
• Analyzing and making multi-dimensional report of Online transactional Processing OLTP data using the SQL server Analysis Services SSAS.
• Maintaining data integrity and ongoing quality control of generated and delivered report in Choice Technologies.
• Ability to write complex SQL queries, script, stored procedures, creating triggers and indexes to improve database performance in SQL servers.
• Using Microsoft Excel, power point and Access to extract and analyze data and creating relevant user friendly report and presentations for the management of Choice Technologies.
• Installing Oracle software, planning the database & security strategy, enrolling system users and planning for their Oracle Network access.
• Creating, migrating and backing up database for various clients.
• Project Lead - successfully analyzed, recommended and implemented an active Oracle Data Guard to facilitate data protection, site redundancy and disaster recovery.
• Strong project implementation and development using the Oracle Spatial technology.
• Planned, Coordinate, and administer database systems, including base definitions, structures, documentation, requirements, set operational guidelines and protection within the database management system (DBMS).
• Successfully upgrade multiple databases and performance tuning, maintenance and training for continuous operation
• Carrying out Oracle Database maintenance; base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository (AWR)/ Automatic Database Diagnostic Monitor (ADDM) to generate performance reports, monitoring and database performance
• Performed database cloning and refreshes from production to UAT/DEV environment
• Work with Developers to design, develop, test and maintain Oracle PL/SQL packages, triggers, stored procedures and functions to support multiple clients.
• Created, modified and maintained Oracle database objects and storage structures including tablespaces, tables, users, roles, profiles, directories and indexes.

ORACLE /SQL SERVER DATA ANALYST

Responsibilities:

• Maintain the Oracle 11G and SQL Server 2008 clustering environment and troubleshoot performance problems.
• Writing and analyzing SQL queries using T-SQL and PL/SQL in order to obtain critical data.
• Creating and Building business reports with Microsoft access, excel, words and project .
• Generating data from primary or secondary data sources and maintaining databases and data systems.
• Managing backup & Recovery procedure on Oracle and SQL server Databases for first Data Systems.
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Linux shell scripting for monitoring oracle Database status, security & backups.
• Monitored Tablespace size, resizing Tablespace, relocating data files for better disk I/O.
• Created user, allocation of tablespace quotas with privileges and roles for Oracle & SQL Server databases.
• Strong project implementation and development using the Oracle Spatial technology
• Created backup plan design and implementation using cold/hot backups and RMAN backup technology.
• Running complex queries to retrieve data and ad-hoc reports from multiple tables within Oracle database
• Execute routine performance tuning, Monitoring, troubleshooting and SQL optimization in order to provide a high availability service.