MS BI Developer/Data analyst Resume

PROFESSIONAL SUMMARY:

Innovative, enthusiastic, dedicated, self - motivated and passionate about data and data analytics.BI developerfor over 8 years .Thorough study of oracle Database architecture and SQL server ability to work at any stage of the complete structure. Develop the acuity to learn fast and to face challenges. Grounded with high technical,modelling, analytical and reporting skills at Master level added to twoOracle Accepted ingenious and committed team player with excellent communication, detailed and oriented problem-solving skills driven.

PROFESSIONAL SKILLS:

Platforms: Windows 8/ 7/2000/2003/ XP/Vista, Adobe, Ubuntu, Fedora, PLSQL.

Databases: Oracle 12c,11g, 10g, 9i, ADO.NET, Access, Oracle SQL, SQLServer.

Other Software Tools: Visual Studio, Visual Studio .NET.

Networks: Windows NT, Cisco.

Multilingual: Fluent English, French and German.

DBA skills: Oracle 12c, 11g, 10g Database Administration, Performance Tuning & Capacity Monitoring, Data Security, Backup & Recovery, Standby/Failover Administration, Oracle RAC & ASM Administration/Installation, Oracle Forms and Reports Development

Database: Backed Web Solutions, SQL Tuning in an Oracle Environment

PROFESSIONAL EXPERIENCE:

Confidential

MS BI Developer/Data analyst

Responsibilities:

As a team member, participated a data-integration project for financial services firm that consolidated information from accounting applications, third-party market data and internal equities/fixed income applications using SSIS, SSAS & Power BI.
Developed optimized data collection and qualifying procedures.
Extracted, compiled and tracked data, and analyzed data to generate reports with ssis, ssas, ssrs& Power BI.
Loaded data from flat data files into SQL Server 2014 database tables using bulk insert, and table export/import; loaded data from flat files and excel sheet into Oracle database using SQL*Loader with SSIS.
Designed SSIS package that extract patient's data from a SQL Server Database by using Lookup task, Foreach Loop Container. Used the slowly changing dimension task and its accompanying wizard to load a new dimension.
Designed, performed and tested routine database backups and restore.
Created and executed automated software test plans, test cases and scripts to uncover, identify and document software problems to ensure quality assurance.
Established and maintained sound backup and recovery policies and procedures.
Extracted, compiled and tracked data, evaluated and analyzed data to generate reports with SSIS, SSRS, SSAS & Power BI.
Optimized and developed stored procedures, Triggers, Joins, Views, Cursors on database with T-SQL .
Compiled and validated data; reinforced and maintained compliance with corporate standards.
Developed and initiated more efficient data collection procedures.
Collaborated and worked with managing leadership to prioritize business and information requirements.
Created and optimized processes in the Data Warehouse to import, retrieve and analyze data in the Data Mart System (Jobs, DTS, Queries, ERWIN)using SSIS, SSRS, SSAS and Power BI

Confidential

MSBI Developer

Responsibilities:

Reviewed and implemented database design and implementation (tables, indexes, views, stats).
Contributed to auto parts retailer’s 10% revenue escalation in 2013 which saved time by standardizing content from different databases, enabling increase in sales and supported staff to quickly respond to customer requests with SSIS, SSRS, SSAS and Power BI.
Installed Oracle software /Created and migrated Database, planed capacity, maintained objects, backed up and recovered database, diagnosed and resolved problems, and managed large databases on a daily basis.
Backed up other dba’s workload as required and Dba on-call support rotations.
Worked with other team members to complete special projects and achieve project deadlines.
Leveraged analytical tools to develop efficient system operations.
Worked independently and as well worked well with anotherDBA’s on the team and customer daily.
C communicated effectively with other dbas, project managers, and customers on technical issues.
Ensured availability and security for database in a production environment.
Analyzed operational maintenance issues and recommended performance enhancements.
Created scripts using T-SQL to automate tasks with scheduler.
Implemented and maintained database security (create and maintain users and roles, assign privileges).
Monitored and performed tuning on database server.

Confidential

BI Developer

Responsibilities:

Operated and maintained multiple Oracle database instances.
Installed, configured and upgraded database Oracle 10g.
Performed database tuning and provided recommendations for tuningSetup.
Maintained documentation and standards.
Worked as part of a team and provide 7x24 support when required (rotation).
Performed general technical troubleshootingInterface with Oracle Corporation for technical support.
Performed periodic audits as required by corporate or regulatory bodies.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship