Data Sql Server
Resume:
CHRIS IGBINOBA
***********.****@*****.***
OVERVIEW
Business oriented data analyst offering professional expertise in providing
solutions for data analysis, coding, and variable information controls.
Highly motivated, dedicated and hardworking professional with excellent
communication, problems solving and decision making skills. Ability to work
effectively in a multi-task environment. A self-starter with a positive
attitude.
Areas of Expertise and Tools
Microsoft SQL Server 2008, 2008R2, 2012, SQL management Studio (SSMS),
Integration (SSIS), Reporting (SSRS). SQL Server Data Tools (SSDT)/ Visual
Studio 2010, Business Intelligent Development Studio (BIDS). Basic
knowledge of creating multidimensional Data Cube. Report Builder. Knowledge
of Agile methodology and Scrum Circle. Basic knowledge of JSON and XML
Strong Verbal and written communication skills.
Experience_
Database Analyst DIGISOFT CONSULT, Cumming, GA
March 2013 - Present
Key Functions and Contributions:
. Heavily involved in the designing, developing and optimizing the
database.
. Responsible for configuring DB security profiles using MS SQL Server
Management studio (SSMS).
. Designed table schemes, relation and permissions to ensure database
integrity
. Wrote SQL queries to determine information and generate reports.
. Maintained the data integrity during extraction, transformations and
loading process. Creating packages (DTS) and running jobs using
Visual Studio (SSDT) and management studio (SSIS), developed and
supported ETL (Extraction, Transformation and Loading components,
which were used to move large amounts of data from source data (
Source: Excel, SQL Server, MS Word, Flat/CSV files etc.) Into an
optimized operational databases, DataMart, data warehouse or into
Excel, Flat/CSV file.
. Created new tables, views, and index and store procedures.
. Experience writing DDL and DML statements with multiple table joins
and unions.
. Created scheduled jobs for nightly backup of the database (SQL Server
Agent)
. Use creative techniques to compare data with conflicting data types
and resolve issues
. Provide all aspects of database administration for multiple databases
in a production environment.
. Pro-actively ensure database systems are maintained at the highest
level of support; plan/set procedures; provide reliable and secure
systems for business applications.
. Review database error messages, diagnose, and troubleshoot.
. Contribute to project team efforts to ensure operational support
requirements are implemented.
. Responsible for generating reports, optimizing the database for the
queries to run faster, created complex stored procedures.
. Analyzing issues and tracing bottlenecks in queries using MS SQL
profiler and analyzer
. Proven ability to work independently and in small teams; handle
multiple tasks simultaneously and adapt quickly to changes.
. Data output (SSRS) Made data chart presentations and coded variables
from original data, conducted statistical analysis as and when
required and provided summaries of analysis. Customizing SQL Server
reports for clients, implementing watermarks, color coding, setting
parameters, filters. Basic and advanced formatting. (SSDT)
. Design tables to hold the data, (Data Designing), Design views,
functions and stored procedures to move the data around, Validate
queries to make sure they run quickly (INDEXES) and produce accurate
results. Creating Subqueries, quickly and efficiently perform set-
based processing on large amounts of data using stored procedures;
(SSMS) (T-SQL) (CTE).
Admin Coordinator DEMUOS NIG. LTD, Nigeria.
2010- 2013
HR Specialist Lead and Administrative Management.
. Managed a broad range of HR functions including preparing monthly
staff audit, managed staff and office activities, benefits/payroll
administration, confidential record keeping, staff recruitment and
retention, labor/employee relations.
. Updated and simplified perfect attendance program, providing for a
decrease in absentee by 15% and an increase in employee applications
for perfect attendance by 20%.
. Managed several projects simultaneously. Implemented and managed
multiple projects integrated as a
whole, worth about 50 million naira and successfully brought them to
completion.
. Defined project timelines and tasks; assigned work and tracked
progress.
. Managed, monitored milestones and led projects to completion.
Established and managed cost, schedule and performance of large
highly complex projects and was able to bring the projects to
completion two weeks to deadline day.
. Effectively tailored responses and proposals strategic and conceptual
selling models to best position firm in the market place and brought
profit of 5 million weekly.
Data Entry SHELL EXPLORATION & PRODUCTION COMPANY LTD 2007-2013
. Developed strong working partnerships with client staff, third party
vendors and subcontractors at all levels.
. Participated in Monthly Cost/Revenue Review with Finance and Operation
Directors.
. Data entry, Prepared memos and other correspondence and
completed data analysis (reports) via. Microsoft Excel. Reconciling
of receipts and payment vouchers.
Education_
Microsoft Certified Professional, MTA
Bachelor of Science (B.sc), Business studies; Delta State University,
Nigeria
Petroleum Training Institute (Diploma in computer), Nigeria
Contact this candidate